| | |
| | | string sJson_End_PL = ""; |
| | | string HBillNo_PL = ""; |
| | | string HBillNo = ""; |
| | | long HOrgID = 0; |
| | | long HPRDORGID = 0; |
| | | long HSTOCKINORGID = 0; |
| | | long HINSTOCKOWNERID = 0; |
| | | string HERPBillType = ""; |
| | | DataSet Ds; |
| | | DataSet Ds1; |
| | |
| | | } |
| | | //根据单据ID获取扫描的组织有哪几个 |
| | | string tt = ""; |
| | | 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_New2 " + oMain.HInterID.ToString(), "h_p_Kf_GetOrgIDByTemp_CLD_New2"); //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"); |
| | |
| | | "\"InterationFlags\": \"\",\"IsAutoSubmitAndAudit\":\"false\", \"Model\":["; |
| | | 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]); |
| | | HPRDORGID = Pub_Class.ClsPub.isLong(Ds1.Tables[0].Rows[y]["HPRDORGID"]); |
| | | HSTOCKINORGID = Pub_Class.ClsPub.isLong(Ds1.Tables[0].Rows[y]["HSTOCKINORGID"]); |
| | | HINSTOCKOWNERID = Pub_Class.ClsPub.isLong(Ds1.Tables[0].Rows[y]["HINSTOCKOWNERID"]); |
| | | HERPBillType = Pub_Class.ClsPub.isStrNull(Ds1.Tables[0].Rows[y]["HERPBillType"]); |
| | | //根据TMP表 返回 子表信息 |
| | | 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_New2 " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "'," + HPRDORGID.ToString() + "," + HSTOCKINORGID.ToString() + "," + HINSTOCKOWNERID.ToString() + ",'" + HERPBillType + "'", "h_p_Kf_GetProductInBillByOrgID_CLD_New2"); //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"); |