| | |
|---|
| | | DataTable dt = new DataTable(); |
|---|
| | | try |
|---|
| | | { |
|---|
| | | ds = oCn.RunProcReturn("select * from POOrderBill_Excel ", "POOrderBill_Excel"); |
|---|
| | | ds = oCn.RunProcReturn("select HORGName,SupplierName,MaterialNum,HPackFlag,sum(HQty) HQty from POOrderBill_Excel group by HORGName, SupplierName, MaterialNum, HPackFlag ", "POOrderBill_Excel"); |
|---|
| | | |
|---|
| | | for (int i = 0; i < ds.Tables[0].Rows.Count; i++) |
|---|
| | | { |
|---|
| | |
|---|
| | | |
|---|
| | | if (NumCount < double.Parse(dt.Rows[i]["数量"].ToString())) |
|---|
| | | { |
|---|
| | | error = error + $"第{(i + 1)}行导入数量大于采购订单合计数量,请找采购员申请做采购订单!"; |
|---|
| | | error = error + $"第{(i + 1)}行,物料编码:{dt.Rows[i]["物料编码"].ToString()},包装标识:{dt.Rows[i]["包装标识"].ToString()},导入数量:{dt.Rows[i]["数量"].ToString()} 大于 采购订单合计数量:{NumCount},请找采购员申请做采购订单!"; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | else |
|---|
