| | |
| | | //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); |
| | | if (sWhere != "") |
| | | { |
| | | sWhere = " and ( HNumber like '%" + sWhere + "%' or HName like '%" + sWhere + "%' ) "; |
| | | sWhere = " and ( p.HNumber like '%" + sWhere + "%' or p.HName like '%" + sWhere + "%' ) "; |
| | | } |
| | | try |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | ds = oCN.RunProcReturn("Select HItemID,HNumber å·¥åºä»£ç ,HName å·¥åº from Gy_Process where HStopflag=0 " + sWhere + " Order by HItemID ", "Gy_Process"); |
| | | ds = oCN.RunProcReturn("Select p.HItemID,p.HNumber å·¥åºä»£ç ,p.HName å·¥åº,w.HItemID å·¥ä½ä¸å¿ID,w.HNumber å·¥ä½ä¸å¿ä»£ç ,w.HName å·¥ä½ä¸å¿,d.HItemID é¨é¨ID,d.HNumber é¨é¨ä»£ç ,d.HName é¨é¨ from Gy_Process p left join Gy_WorkCenter w on p.HWorkCenterID = w.HItemID left join Gy_Department d on p.HDeptID = d.HItemID where p.HStopflag = 0 " + sWhere + " Order by HItemID ", "Gy_Process"); |
| | | if (ds == null || ds.Tables[0].Rows.Count <= 0) |
| | | { |
| | | objjson.code = "0"; |
| | |
| | | ordrlist.HPinfan = dt.Rows[i]["HPinfan"].ToString(); |
| | | ordrlist.HSourceName = dt.Rows[i]["ç产线"].ToString(); |
| | | ordrlist.HEndDate = dt.Rows[i]["计åå®å·¥æ¥æ"].ToString();//忥 ç产订å å¤±ææ¥æ |
| | | ordrlist.HMinQty = dt.Rows[i]["æå°å
è£
æ°"].ToString(); |
| | | if (HBarCodeType == "仪å¨å¤è´ä»¶æ¡ç 容å¨è§å") |
| | | { |
| | | ordrlist.HMinQty = dt.Rows[i]["æªçææ¡ç æ°é"].ToString(); |
| | |
| | | ordrlist.HRemark = dt.Rows[i]["夿³¨"].ToString(); |
| | | ordrlist.HMTONo = dt.Rows[i]["计åè·è¸ªå·"].ToString(); |
| | | |
| | | if(HSourceBillType == "æ¶æéç¥å") |
| | | { |
| | | ordrlist.HFurnaceNO = dt.Rows[i]["çå·"].ToString(); |
| | | ordrlist.HCoilNO = dt.Rows[i]["é¢å·æå
å·"].ToString(); |
| | | ordrlist.HheatNO = dt.Rows[i]["çå¤ç"].ToString(); |
| | | } |
| | | |
| | | if (HBarCodeType == "仪å¨å¤è´ä»¶æ¡ç 容å¨è§å") |
| | | { |