| | |
| | | string HBillNo_PL = ""; |
| | | string HBillNo = ""; |
| | | long HOrgID = 0; |
| | | string HERPBillType = ""; |
| | | DataSet Ds; |
| | | DataSet Ds1; |
| | | //写入WMS产品入库单 |
| | |
| | | } |
| | | //根据单据ID获取扫描的组织有哪几个 |
| | | string tt = ""; |
| | | Ds1 = oCn.RunProcReturn("exec h_p_Kf_GetOrgIDByTemp_CLD " + oMain.HInterID.ToString(), "h_p_Kf_GetOrgIDByTemp_CLD"); |
| | | Ds1 = oCn.RunProcReturn("exec h_p_Kf_GetOrgIDByTemp_CLD_New " + oMain.HInterID.ToString(), "h_p_Kf_GetOrgIDByTemp_CLD_New"); //20240708修改 |
| | | //Ds1 = oCn.RunProcReturn("exec h_p_Kf_GetOrgIDByTemp_CLD " + oMain.HInterID.ToString(), "h_p_Kf_GetOrgIDByTemp_CLD"); |
| | | |
| | | sRemark = sRemark + " ;获取组织个数" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff"); |
| | | |
| | |
| | | for (int y = 0; y < Ds1.Tables[0].Rows.Count; y++) |
| | | { |
| | | HOrgID = Pub_Class.ClsPub.isLong(Ds1.Tables[0].Rows[y][0]); |
| | | HERPBillType = Pub_Class.ClsPub.isStrNull(Ds1.Tables[0].Rows[y][1]); |
| | | //根据TMP表 返回 子表信息 |
| | | Ds = oCn.RunProcReturn("exec h_p_Kf_GetProductInBillByOrgID_CLD " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "'," + HOrgID.ToString(), "h_p_Kf_GetProductInBillByOrgID_CLD"); |
| | | Ds = oCn.RunProcReturn("exec h_p_Kf_GetProductInBillByOrgID_CLD_New " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "'," + HOrgID.ToString() + ",'" + HERPBillType + "'", "h_p_Kf_GetProductInBillByOrgID_CLD_New"); //20240708修改 |
| | | //Ds = oCn.RunProcReturn("exec h_p_Kf_GetProductInBillByOrgID_CLD " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "'," + HOrgID.ToString(), "h_p_Kf_GetProductInBillByOrgID_CLD"); |
| | | |
| | | sRemark = sRemark + " ;获取API数据" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff"); |
| | | |
| | |
| | | if (HReturn.Contains("\"IsSuccess\":false") == true) |
| | | { |
| | | sErrMsg = sErrMsg + "产品入库单失败!" + HReturn + "999" + tt + "888" + sJson; |
| | | LogService.Write("生成生产入库单(源单:生产任务单)多源单失败!" + HReturn + tt +sJson); //写入txt文本 |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = sErrMsg + "999" + tt + "888" + HReturn; |
| | | LogService.Write("生成并审核生产入库单(源单:生产任务单)多源单成功!" + HReturn + tt + sJson); |
| | | oCn.Commit(); |
| | | return true; |
| | | } |