| | |
|---|
| | | List<Model.ClsKf_POStockInBillMain> lsmain = new List<Model.ClsKf_POStockInBillMain>(); |
|---|
| | | ListModels oListModels = new ListModels(); |
|---|
| | | lsmain = oListModels.getPOStockInBillMainByJson(msg1); |
|---|
| | | lsmain[0].HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); |
|---|
| | | lsmain[0].HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); |
|---|
| | | //lsmain[0].HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); |
|---|
| | | //lsmain[0].HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); |
|---|
| | | string sSourceBillType = lsmain[0].HBillType; |
|---|
| | | |
|---|
| | | WebAPI.WebS.ClsKf_POStockInBillMain websLsmain = new WebS.ClsKf_POStockInBillMain(); |
|---|
| | |
|---|
| | | 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"; |
|---|
