| | |
|---|
| | | FROM TUser U |
|---|
| | | inner join cte on U.storg_code=cte.torg_code |
|---|
| | | left join TOrganization T on U.storg_code=T.torg_code |
|---|
| | | left join TUser S on U.lm_user=S.usercode " + search + ""; |
|---|
| | | left join TUser S on U.lm_user=S.usercode |
|---|
| | | where 1=1 " + search + ""; |
|---|
| | | var data = DapperHelper.GetPagedDataWith<object>(withsql, sql, dynamicParams, prop, order, startNum, endNum, out total); |
|---|
| | | mes.code = "200"; |
|---|
| | | mes.message = "查询成功!"; |
|---|
| | |
|---|
| | | 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) |
|---|
| | | { |
|---|
