| | |
|---|
| | | objJsonResult.data = 1; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | if (oItemSub.HQty > oItemSub.HRQty) |
|---|
| | | if (Convert.ToDecimal(oItemSub.HQty) > Convert.ToDecimal(oItemSub.HRQty)) |
|---|
| | | { |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 0; |
|---|
| | |
|---|
| | | } |
|---|
| | | oItemSub.HEntryID = i; |
|---|
| | | oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); |
|---|
| | | oItemSub.HRemark = ""; |
|---|
| | | //oItemSub.HRemark = ""; |
|---|
| | | oItemSub.HCloseMan = ""; |
|---|
| | | oItemSub.HCloseType = false; |
|---|
| | | oBill.DetailColl.Add(oItemSub); |
|---|
| | |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | sql = string.Format(@" |
|---|
| | | //瑞琪字段 |
|---|
| | | sql = string.Format(@" |
|---|
| | | SELECT T3.FNAME AS FTYPENAME,M.HBILLNO,B.HINTERID,B.HENTRYID,C.FID,C.FENTRYID, D.FBILLNO,B.HQTY,CD.FRECEIVEORGID,CDOO.FNUMBER AS FRECEIVENUMBER |
|---|
| | | ,D.FSUPPLIERID,DS.FNUMBER AS FSUPPLIERNUMBER,D.FPURCHASEORGID,DOO.FNUMBER AS FPURCHASEORGNUMBER,CROO.FNUMBER AS FSETTLEORGNUMBER, |
|---|
| | | E.FPRICETIMEPOINT,E.FSETTLECURRID,EC.FNUMBER AS FSETTLECURRNUMBER,C.FMATERIALID,CM.FNUMBER AS FMATERIALNUMBER ,C.FUNITID |
|---|
| | | ,CU.FNUMBER AS FUNITNUMBER,CR.FPRICE,CR.FTAXPRICE,CR.FTAXRATE,D.FPURCHASERID,isnull(T4.FNUMBER,'') AS FPURCHASERNUMBER |
|---|
| | | ,B.HExpressNumberSub,B.HExpressSupplierSub,B.HRemark,B.HPlanArrivalDate,B.HBoxNumber |
|---|
| | | FROM CG_POINSTOCKBILLSUB B |
|---|
| | | JOIN CG_POINSTOCKBILLMAIN M ON B.HINTERID = M.HINTERID |
|---|
| | | JOIN {0}..T_PUR_POORDERENTRY C ON B.HSOURCEINTERID = C.FID AND B.HSOURCEENTRYID = C.FENTRYID |
|---|
| | |
|---|
| | | FentityModel.Add("FTaxPrice", item["FTAXPRICE"].ToString());//含税单价 |
|---|
| | | FentityModel.Add("FEntryTaxRate", item["FTAXRATE"].ToString());//税率 |
|---|
| | | |
|---|
| | | FentityModel.Add("F_bsv_Text1", item["HExpressSupplierSub"].ToString());//物流单位 (瑞琪) |
|---|
| | | FentityModel.Add("F_bsv_Text2", item["HExpressNumberSub"].ToString());//物流单号 (瑞琪) |
|---|
| | | FentityModel.Add("FDescription", item["HRemark"].ToString());//表体备注 (瑞琪) |
|---|
| | | FentityModel.Add("F_bsv_dhrq", item["HPlanArrivalDate"].ToString());//到货日期 (瑞琪) |
|---|
| | | FentityModel.Add("F_bsv_xh", item["HBoxNumber"].ToString());//箱号 (瑞琪) |
|---|
| | | |
|---|
| | | JArray Fentity2 = new JArray(); |
|---|
| | | JObject FentityModel2 = new JObject(); |
|---|
| | | FentityModel2.Add("FDetailEntity_Link_FRULEID", "PUR_PurchaseOrder-PUR_ReceiveBill"); |
|---|
| | |
|---|
| | | return objjson; |
|---|
| | | } |
|---|
| | | //LogService.Write("jsonRoot:" + jsonRoot.ToString()); |
|---|
| | | var result = InvokeHelper.Save("PUR_ReceiveBill", jsonRoot.ToString()); |
|---|
| | | var result = InvokeHelper.Save("PUR_ReceiveBill", jsonRoot.ToString()); |
|---|
| | | |
|---|
| | | //LogService.Write(result); |
|---|
| | | if (JObject.Parse(result)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() == "TRUE") |
|---|
| | | { |
|---|
| | |
|---|
| | | } |
|---|
| | | |
|---|
| | | } |
|---|
| | | |
|---|
| | | ////更新物流字段 （瑞与琪） |
|---|
| | | //oCn.RunProc("exec h_p_Cg_LocalToKingDee_POInStock " + HBillNo + "," + HInterID); |
|---|
| | | |
|---|
| | | //更新主表状态 审核 |
|---|
| | | sql = string.Format(@"update Cg_POInStockBillMain set |
|---|
| | | HBillStatus = 2 , |
|---|
| | |
|---|
| | | SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM(); |
|---|
| | | int HInterID = 0; |
|---|
| | | string sql = "select HInterID from CG_POINSTOCKBILLMAIN where HBILLNO = '" + HBillNo + "'"; |
|---|
| | | if (type == "Print") |
|---|
| | | sql += " and HBillStatus = '2' ";//打印判断是否审核 |
|---|
| | | //if (type == "Print") |
|---|
| | | // sql += " and HBillStatus = '2' ";//打印判断是否审核 |
|---|
| | | DataTable dt = oCn.RunProcReturn(sql, "HInterID").Tables[0]; |
|---|
| | | if (dt.Rows.Count > 0) |
|---|
| | | HInterID = Convert.ToInt32(dt.Rows[0]["HInterID"]); |
|---|
| | |
|---|
| | | var HinterID = mylist[i].ToString(); |
|---|
| | | oCn.RunProc($"exec h_p_SRM_UpDatePPBomRelationQty {HinterID}"); |
|---|
| | | } |
|---|
| | | |
|---|
| | | //判断未关联数量是否为0 |
|---|
| | | DataSet ds = oCn.RunProcReturn($"select T1.hqty-T1.hrelationqty as hqty,单据号,物料编码 from H_v_SRM_POOrderBillList t1 where hentryid in ({string.Join(", ", entryList)}) ", "H_v_SRM_POOrderBillList"); |
|---|
| | | //安瑞：AIS20220914133941 瑞与琪：AIS20220308151944 本地：AIS20210811135644 夏宝：AIS20211130140219 |
|---|
| | | DataSet ds = oCn.RunProcReturn($"select T1.hqty-T1.hrelationqty+q.FMRBQTY as hqty,单据号,物料编码 from H_v_SRM_POOrderBillList t1 left join AIS20210811135644..T_PUR_POORDERENTRY_R q on q.FENTRYID=t1.HEntryID where hentryid in ({string.Join(", ", entryList)}) ", "H_v_SRM_POOrderBillList"); |
|---|
| | | DataTable dt = ds.Tables[0]; |
|---|
| | | if (dt.Rows.Count > 0) |
|---|
| | | { |
|---|
