| | |
| | | jobject16.Add("FSRCENTRYID", dataRow2["FENTRYID"].ToString()); |
| | | jobject16.Add("FORDERBILLNO", dataRow2["FBILLNO"].ToString()); |
| | | jobject16.Add("FPOORDERENTRYID", dataRow2["FENTRYID"].ToString()); |
| | | jobject16.Add("FGiveAway", dataRow2["FGIVEAWAY"].ToString());//是否赠品 |
| | | //jobject16.Add("FPrice", dataRow2["FPRICE"].ToString()); |
| | | //jobject16.Add("FTaxPrice", dataRow2["FTAXPRICE"].ToString()); |
| | | //jobject16.Add("FEntryTaxRate", dataRow2["FTAXRATE"].ToString()); |
| | |
| | | ,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 |
| | | ,C.FGIVEAWAY AS FGIVEAWAY |
| | | 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("FPrice", item["FPRICE"].ToString());//单价 |
| | | FentityModel.Add("FTaxPrice", item["FTAXPRICE"].ToString());//含税单价 |
| | | FentityModel.Add("FEntryTaxRate", item["FTAXRATE"].ToString());//税率 |
| | | FentityModel.Add("FGiveAway", item["FGIVEAWAY"].ToString());//是否赠品 |
| | | |
| | | JArray Fentity2 = new JArray(); |
| | | JObject FentityModel2 = new JObject(); |
| | |
| | | string sql = string.Empty; |
| | | if (FCusName.Contains("安瑞")) |
| | | sql = $"select top 1 HItemID,HSourceBillNo,HQty,HSourceInterID,HSourceEntryID from Gy_BarCodeBill where HSourceInterID =(select distinct HSourceInterID from Cg_POInStockBillSub where HInterID ={HInterID}) and HBarCode = '{HBarcode}' and HBarCodeType ='箱号内条码'"; |
| | | else if(FCusName.Contains("添康科技")) |
| | | sql = $"select top 1 HItemID,HSourceBillNo,HQty,HSourceInterID,HSourceEntryID,HMaterID,HBatchNo,HProduceDate,HExpiryDate from Gy_BarCodeBill where HSourceInterID = {HInterID} and HBarCode = '{HBarcode}' and HBarCodeType ='箱号内条码'"; |
| | | else |
| | | sql = $"select HItemID,HSourceBillNo,HQty,HSourceInterID,HSourceEntryID from Gy_BarCodeBill where HSourceInterID ={HInterID} and HBarCode = '{HBarcode.Split('#')[0]}' and HQty = {HBarcode.Split('#')[1]}"; |
| | | DataSet ds = oCn.RunProcReturn(sql, "H_v_SRM_POOrderBillList"); |
| | | DataSet ds = oCn.RunProcReturn(sql, "Gy_BarCodeBill"); |
| | | if (ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |