| | |
| | | { |
| | | for(int i=0;i< dsMain.Tables[0].Rows.Count; i++) |
| | | { |
| | | string HMaterNumber = DBUtility.ClsPub.isStrNull(dsMain.Tables[0].Rows[0]["产品代码"]); |
| | | string HMaterNumber = DBUtility.ClsPub.isStrNull(dsMain.Tables[0].Rows[i]["产品代码"]); |
| | | if (!oMaterHlp.GetInfoByNumber(HMaterNumber)) |
| | | { |
| | | string sMsg = "物料【" + HMaterNumber + "】不存在!"; |
| | |
| | | DataSet dsSub = oCN.RunProcReturn("select * from diyipi_WorkQty where 产品代码 = '" + HMaterNumber + "' order by 工序序号", "diyipi_WorkQty"); |
| | | for(int j = 0; j < dsSub.Tables[0].Rows.Count; j++) |
| | | { |
| | | string HProcNumber = DBUtility.ClsPub.isStrNull(dsSub.Tables[0].Rows[j]["工序代码"]); |
| | | string HProcName = DBUtility.ClsPub.isStrNull(dsSub.Tables[0].Rows[j]["工序"]); |
| | | //得到工序内码 |
| | | if (!oProcHlp.GetInfoByNumber(HProcNumber)) |
| | | if (!oProcHlp.GetInfoByName(HProcName)) |
| | | { |
| | | string sMsg = "工序【" + HProcNumber + "】不存在!"; |
| | | string sMsg = "工序【" + HProcName + "】不存在!"; |
| | | if (finalErrMsg.Contains(sMsg) == false) |
| | | { |
| | | finalErrMsg = finalErrMsg + "工序【" + HProcNumber + "】不存在!\r\n"; |
| | | finalErrMsg = finalErrMsg + "工序【" + HProcName + "】不存在!\r\n"; |
| | | } |
| | | continue; |
| | | } |
| | |
| | | //得到生产资源内码 |
| | | if (!oSourceHlp.GetInfoByNumber(sHNumberSourceList[t])) |
| | | { |
| | | string sMsg = "生产资源【" + HProcNumber + "】不存在!"; |
| | | string sMsg = "生产资源【" + sHNumberSourceList[t] + "】不存在!"; |
| | | if (finalErrMsg.Contains(sMsg) == false) |
| | | { |
| | | finalErrMsg = finalErrMsg + "生产资源【" + HProcNumber + "】不存在!\r\n"; |
| | | finalErrMsg = finalErrMsg + "生产资源【" + sHNumberSourceList[t] + "】不存在!\r\n"; |
| | | } |
| | | continue; |
| | | } |