| | |
| | | } |
| | | else |
| | | { |
| | | tb2.Rows[i]["HWHID"] = ds.Tables[0].Rows[0]["HItemID"].ToString(); |
| | | tb2.Rows[i]["HWHID"] = ds.Tables[0].Rows[0]["HSPGroupID"].ToString(); |
| | | } |
| | | string HWHID = tb2.Rows[i]["HWHID"].ToString(); |
| | | //鏌ヨ浠撲綅 |
| | | ds = oCN.RunProcReturn("select * from Gy_StockPlace where HName='" + HSPName + "'and HSPGroupID=" + HWHID+ " and HUSEORGID=" + HORGid + "", "Gy_Warehouse"); |
| | | ds = oCN.RunProcReturn("select * from Gy_StockPlace where HName='" + HSPName + "'and HSPGroupID=" + HWHID+ " and HUSEORGID=" + HORGid + "", "Gy_StockPlace"); |
| | | |
| | | if (ds.Tables[0].Rows.Count == 0) |
| | | { |
| | |
| | | |
| | | } |
| | | |
| | | ds = oCN.RunProcReturn($"exec h_p_OperationBill '{HBeginDate}','{HEndDate}',''{HEquipmentNumber}", "h_p_OperationBill"); |
| | | ds = oCN.RunProcReturn($"exec h_p_OperationBill '{HBeginDate}','{HEndDate}','{HEquipmentNumber}'", "h_p_OperationBill"); |
| | | // 娣诲姞鍒楀悕 |
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
| | | { |