| | |
|---|
| | | } |
|---|
| | | #endregion |
|---|
| | | |
|---|
| | | #region[MES报废补单工单查询] |
|---|
| | | public static ToMessage MesBadOrderSearch(string mesordercode, string sourceorder, string partcode, string partname, string partspec, int startNum, string creatuser, string createdate, int endNum, string prop, string order) |
|---|
| | | { |
|---|
| | | var dynamicParams = new DynamicParameters(); |
|---|
| | | string search = ""; |
|---|
| | | try |
|---|
| | | { |
|---|
| | | if (mesordercode != "" && mesordercode != null) |
|---|
| | | { |
|---|
| | | search += "and A.wo_code like '%'+@mesordercode+'%' "; |
|---|
| | | dynamicParams.Add("@mesordercode", mesordercode); |
|---|
| | | } |
|---|
| | | if (sourceorder != "" && sourceorder != null) |
|---|
| | | { |
|---|
| | | search += "and A.m_po like '%'+@sourceorder+'%' "; |
|---|
| | | dynamicParams.Add("@sourceorder", sourceorder); |
|---|
| | | } |
|---|
| | | if (partcode != "" && partcode != null) |
|---|
| | | { |
|---|
| | | search += "and A.materiel_code like '%'+@partcode+'%' "; |
|---|
| | | dynamicParams.Add("@partcode", partcode); |
|---|
| | | } |
|---|
| | | if (partname != "" && partname != null) |
|---|
| | | { |
|---|
| | | search += "and B.partname like '%'+@partname+'%' "; |
|---|
| | | dynamicParams.Add("@partname", partname); |
|---|
| | | } |
|---|
| | | if (partspec != "" && partspec != null) |
|---|
| | | { |
|---|
| | | search += "and B.partspec like '%'+@partspec+'%' "; |
|---|
| | | dynamicParams.Add("@partspec", partspec); |
|---|
| | | } |
|---|
| | | if (createdate != "" && createdate != null) |
|---|
| | | { |
|---|
| | | search += "and CONVERT(varchar(100),A.lm_date,23)=@createdate "; |
|---|
| | | dynamicParams.Add("@createdate", createdate); |
|---|
| | | } |
|---|
| | | if (creatuser != "" && creatuser != null) |
|---|
| | | { |
|---|
| | | search += "and U.username like '%'+@creatuser+'%' "; |
|---|
| | | dynamicParams.Add("@creatuser", creatuser); |
|---|
| | | } |
|---|
| | | |
|---|
| | | if (search == "") |
|---|
| | | { |
|---|
| | | search = "and 1=1 "; |
|---|
| | | } |
|---|
| | | // --------------查询指定数据-------------- |
|---|
| | | var total = 0; //总条数 |
|---|
| | | var sql = @"select A.id, A.status,A.wotype,A.wo_code,A.materiel_code as partcode,B.partname,B.partspec,A.plan_qty,A.wkshp_code,C.org_name as wkshp_name, |
|---|
| | | A.route_code,E.name as route_name,A.stck_code,F.name as stck_name,A.plan_startdate,A.plan_enddate,A.piroque,A.sourceid,A.m_po,U.username as lm_user,A.lm_date,S.bad_qty |
|---|
| | | from TK_Wrk_Man A |
|---|
| | | left join (select wo_code,sum(bad_qty) as bad_qty from TK_Wrk_Step where bad_qty>0 group by wo_code) S on A.wo_code=S.wo_code |
|---|
| | | left join TMateriel_Info B on A.materiel_code=B.partcode |
|---|
| | | left join TOrganization C on A.wkshp_code=C.org_code |
|---|
| | | left join T_Sec_Stck D on A.stck_code=D.code |
|---|
| | | left join TFlw_Rout E on A.route_code=E.code |
|---|
| | | left join T_Sec_Stck F on A.stck_code=F.code |
|---|
| | | left join TUser U on A.lm_user=U.usercode |
|---|
| | | where A.is_delete<>'1' and A.status='START' and A.wotype='PO' and S.bad_qty>0 " + search; |
|---|
| | | var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total); |
|---|
| | | mes.code = "200"; |
|---|
| | | mes.Message = "查询成功!"; |
|---|
| | | mes.count = total; |
|---|
| | | mes.data = data.ToList(); |
|---|
| | | } |
|---|
| | | catch (Exception e) |
|---|
| | | { |
|---|
| | | mes.code = "300"; |
|---|
| | | mes.count = 0; |
|---|
| | | mes.Message = e.Message; |
|---|
| | | mes.data = null; |
|---|
| | | } |
|---|
| | | return mes; |
|---|
| | | } |
|---|
| | | #endregion |
|---|
| | | |
|---|
| | | #region[产品编码查找工艺路线下拉接口] |
|---|
| | | public static ToMessage PartSelectRoute(string partcode) |
|---|
| | | { |
|---|
