| | |
| | | IEnumerable<object> data; |
| | | try |
| | | { |
| | | if (flag == "-1" && stckcode == null) |
| | | { |
| | | mes.code = "200"; |
| | | mes.count = 0; |
| | | mes.message = "暂无数据!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | | string[] classcode = Array.ConvertAll<string, string>(stckcode.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), s => s.ToString()); //string分割转string[] |
| | | switch (flag) |
| | | { |
| | |
| | | #endregion |
| | | |
| | | #region[仓位信息新增/编辑保存] |
| | | public static ToMessage TSecLocaAddUpdate(string data_sources, string locacode, string locaname, string stckcode, string parentlocacode,string depth, string status, string description, string OperType, User us) |
| | | public static ToMessage TSecLocaAddUpdate(string data_sources, string locacode, string locaname, string stckcode, string parentlocacode, string depth, string status, string description, string OperType, User us) |
| | | { |
| | | string sql = ""; |
| | | List<object> list = new List<object>(); |
| | |
| | | lm_user = us.usercode, |
| | | lm_date = DateTime.Now.ToString(), |
| | | data_sources = data_sources, |
| | | depth= depth |
| | | depth = depth |
| | | } |
| | | }); |
| | | bool aa = DapperHelper.DoTransaction(list); |
| | |
| | | name = locaname, |
| | | idwarehouse = stckcode, |
| | | idparent = parentlocacode, |
| | | depth= depth, |
| | | depth = depth, |
| | | status = status, |
| | | description = description, |
| | | lm_user = us.usercode, |
| | |
| | | |
| | | |
| | | #region[工序查询] |
| | | public static ToMessage StepSearch(string stepcode, string stepname, string enable, string steptypecode,int startNum, int endNum, string prop, string order) |
| | | public static ToMessage StepSearch(string stepcode, string stepname, string enable, string steptypecode, int startNum, int endNum, string prop, string order) |
| | | { |
| | | var dynamicParams = new DynamicParameters(); |
| | | string search = ""; |
| | |
| | | } |
| | | sql = @"update TStep set stepname=@stepname,flwtype=@steptypecode,enable=@enable,descr=@description, |
| | | lm_user=@username,lm_date=@CreateDate where id=@stepid"; |
| | | list.Add(new { str = sql, parm = new {stepid = stepid, stepname = stepname, steptypecode = steptypecode, enable = enable, description = description, username = us.usercode, CreateDate = DateTime.Now.ToString() } }); |
| | | list.Add(new { str = sql, parm = new { stepid = stepid, stepname = stepname, steptypecode = steptypecode, enable = enable, description = description, username = us.usercode, CreateDate = DateTime.Now.ToString() } }); |
| | | bool aa = DapperHelper.DoTransaction(list); |
| | | if (aa) |
| | | { |