| | |
| | | |
| | | string sErrMsg = ""; |
| | | bool bResult; |
| | | //è·åç³»ç»åæ° |
| | | if (oSystemParameter.ShowBill(ref sErrMsg) == true) |
| | | { |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "森楷") //ç³»ç»åæ° å®¢æ·å®å¶ååç§° 空ç½ä¸ºéç¨ |
| | | { |
| | | DataSet ds; |
| | | string sql = "select HBarCode,HSourceInterID,HSourceEntryID,HSourceBillNo from Gy_BarCodeBill with(nolock) where HBarCode = '" + sCode + "'"; |
| | | string HDataBaseName = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "DataBaseName");//è·åéè¶æ°æ®åºåç§° |
| | | string HSourceBillNo = ""; |
| | | Int64 HSourceInterID = 0; |
| | | ////è·åç³»ç»åæ° |
| | | //if (oSystemParameter.ShowBill(ref sErrMsg) == true) |
| | | //{ |
| | | // if (oSystemParameter.omodel.WMS_CampanyName == "森楷" && sSourceType == "1241") //客æ·ä¸ºæ£®æ¥·ï¼å¹¶ä¸ä¸ºå
¶ä»å
¥åºåæ¨¡åæ¶è¿å
¥å¤æ |
| | | // { |
| | | // DataSet ds; |
| | | // string sql = "select HBarCode,HSourceInterID,HSourceEntryID,HSourceBillNo from Gy_BarCodeBill with(nolock) where HBarCode = '" + sCode + "'"; |
| | | // string HDataBaseName = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "DataBaseName");//è·åéè¶æ°æ®åºåç§° |
| | | // string HSourceBillNo = ""; |
| | | // Int64 HSourceInterID = 0; |
| | | |
| | | ds = oCn.RunProcReturn(sql, "Gy_BarCodeBill"); |
| | | //夿æ¡ç ä¿¡æ¯æ¯å¦å¨æ¡ç æ¡£æ¡ä¸ |
| | | if (ds == null || ds.Tables[0].Rows.Count < 1) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¡ç æ¡£æ¡ä¸ä¸å卿¡ç ç¼å·ï¼" + sCode; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | //è·åå
¥åºç³è¯·ååå·/主ID |
| | | HSourceBillNo = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HSourceBillNo"]); |
| | | HSourceInterID = DBUtility.ClsPub.isInt(ds.Tables[0].Rows[0]["HSourceInterID"]); |
| | | //æ ¹æ®å
¥åºç³è¯·ååå·å¤æåæ®ä¿¡æ¯æ¯å¦å·²ç»åæ¥å°éè¶ |
| | | sql = string.Format(@"select * from FROM {0}..T_STK_MISCELLANEOUS with(nolock) where FBILLNO = '" + HSourceBillNo + "'", HDataBaseName); |
| | | ds = oCn.RunProcReturn(sql, "T_STK_MISCELLANEOUS"); |
| | | //å
¥åºç³è¯·å没æåæ¥å°éè¶åè¿è¡åæ¥ |
| | | if (ds == null || ds.Tables[0].Rows.Count < 1) |
| | | { |
| | | sql = "exec h_p_Kf_StockInRequestBillToErp " + HSourceInterID + "," + HSourceBillNo; |
| | | ds = oCn.RunProcReturn(sql, "h_p_Kf_StockInRequestBillToErp"); |
| | | // ds = oCn.RunProcReturn(sql, "Gy_BarCodeBill"); |
| | | // //夿æ¡ç ä¿¡æ¯æ¯å¦å¨æ¡ç æ¡£æ¡ä¸ |
| | | // if (ds == null || ds.Tables[0].Rows.Count < 1) |
| | | // { |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "æ¡ç æ¡£æ¡ä¸ä¸å卿¤æ¡ç ç¼å·ï¼" + sCode; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | // } |
| | | // else |
| | | // { |
| | | // //è·åå
¥åºç³è¯·ååå·/主ID |
| | | // HSourceBillNo = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HSourceBillNo"]); |
| | | // HSourceInterID = DBUtility.ClsPub.isInt(ds.Tables[0].Rows[0]["HSourceInterID"]); |
| | | // //æ ¹æ®å
¥åºç³è¯·ååå·å¤æåæ®ä¿¡æ¯æ¯å¦å·²ç»åæ¥å°éè¶ |
| | | // sql = string.Format(@"select * from FROM {0}..TFKO_t_Cust100009 with(nolock) where FBILLNO = '" + HSourceBillNo + "'", HDataBaseName); |
| | | // ds = oCn.RunProcReturn(sql, "TFKO_t_Cust100009"); |
| | | // //å
¥åºç³è¯·å没æåæ¥å°éè¶åè¿è¡åæ¥ |
| | | // if (ds == null || ds.Tables[0].Rows.Count < 1) |
| | | // { |
| | | // sql = "exec h_p_Kf_StockInRequestBillToErp " + HSourceInterID + "," + HSourceBillNo; |
| | | // ds = oCn.RunProcReturn(sql, "h_p_Kf_StockInRequestBillToErp"); |
| | | |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | oCn.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "webapiå
¥åºç³è¯·å忥ï¼è·åä¿¡æ¯å¤±è´¥"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | JObject model = new JObject(); |
| | | model.Add("FBillType", new JObject() { ["FNumber"] = Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["FBillType"]) }); //åæ®ç±»å |
| | | model.Add("FDate", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æ¥æ"])); //åæ®æ¥æ |
| | | model.Add("FStockOrgId", new JObject() { ["FNumber"] = Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["åºåç»ç»ä»£ç "]) }); //åºåç»ç»ä»£ç |
| | | model.Add("FBillNo", HSourceBillNo); //åæ®å· |
| | | model.Add("FStockDirect", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["åºåæ¹å"])); //åºåæ¹å |
| | | model.Add("FDEPTID", new JObject() { ["FNumber"] = Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["é¨é¨ä»£ç "]) }); //çäº§è½¦é´ |
| | | model.Add("F_paez_Text", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["å
¥åºç å"])); //å
¥åºç å |
| | | model.Add("F_paez_Integer2", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["çåæ°"])); //çåæ° |
| | | model.Add("F_paez_Integer1", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["çç®¡åªæ°"])); //çç®¡åªæ° |
| | | model.Add("F_paez_Integer3", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["å®é¿"])); //å®é¿ |
| | | model.Add("F_paez_BaseProperty4", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["çé"])); //çé |
| | | model.Add("F_paez_Base", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["å·¥å·"])); //å·¥å· |
| | | model.Add("F_paez_Combo", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["çæ¬¡ä»£ç "])); //çæ¬¡ |
| | | model.Add("F_paez_BaseProperty1", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æ¹å·"])); //æ¹å· |
| | | model.Add("F_paez_Integer", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["ç®±æ°"])); //ç®±æ° |
| | | model.Add("F_paez_Decimal2", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æ»é"])); //æ»é |
| | | model.Add("F_paez_BaseProperty2", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æåç¼ç "])); //æåç¼ç |
| | | model.Add("F_paez_BaseProperty5", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["åå"])); //åå |
| | | model.Add("F_paez_Base1", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["线å·"])); //çº¿å· |
| | | // if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | // { |
| | | // oCn.RollBack(); |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "webapiå
¥åºç³è¯·å忥ï¼è·åä¿¡æ¯å¤±è´¥"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | // } |
| | | // else |
| | | // { |
| | | // JObject model = new JObject(); |
| | | // //model.Add("FBillType", new JObject() { ["FNumber"] = Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["FBillType"]) }); //åæ®ç±»å |
| | | // model.Add("FDate", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æ¥æ"])); //åæ®æ¥æ |
| | | // model.Add("FStockOrgId", new JObject() { ["FNumber"] = Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["åºåç»ç»ä»£ç "]) }); //åºåç»ç»ä»£ç |
| | | // model.Add("FBillNo", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["åæ®å·"])); //åæ®å· |
| | | // model.Add("FStockDirect", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["åºåæ¹å"])); //åºåæ¹å |
| | | // model.Add("FDEPTID", new JObject() { ["FNumber"] = Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["é¨é¨ä»£ç "]) }); //çäº§è½¦é´ |
| | | // model.Add("F_paez_Text", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["å
¥åºç å"])); //å
¥åºç å |
| | | // model.Add("F_paez_Integer2", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["çåæ°"])); //çåæ° |
| | | // model.Add("F_paez_Integer1", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["çç®¡åªæ°"])); //çç®¡åªæ° |
| | | // model.Add("F_paez_Integer3", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["å®é¿"])); //å®é¿ |
| | | // //model.Add("F_paez_BaseProperty4", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["çé"])); //çé |
| | | // model.Add("F_paez_Base", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["å·¥å·"])); //å·¥å· |
| | | // model.Add("F_paez_Combo", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["çæ¬¡ä»£ç "])); //çæ¬¡ |
| | | // //model.Add("F_paez_BaseProperty1", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æ¹å·"])); //æ¹å· |
| | | // model.Add("F_paez_Integer", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["ç®±æ°"])); //ç®±æ° |
| | | // model.Add("F_paez_Decimal2", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æ»é"])); //æ»é |
| | | // //model.Add("F_paez_BaseProperty2", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æåç¼ç "])); //æåç¼ç |
| | | // //model.Add("F_paez_BaseProperty5", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["åå"])); //åå |
| | | // model.Add("F_paez_Base1", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["线å·"])); //çº¿å· |
| | | |
| | | model.Add("F_paez_BaseProperty", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æºå°"])); //æºå° |
| | | model.Add("F_paez_Decimal", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["ç®±é"])); //ç®±é |
| | | //model.Add("F_WJUK_Text", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æ¥æº"])); //æ¥æº |
| | | model.Add("FDEPTID1", new JObject() { ["FNumber"] = Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["é¨é¨ä»£ç "]) });//é¨é¨ |
| | | model.Add("F_paez_BaseProperty6", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æ»å"])); //æ»å |
| | | model.Add("F_paez_BaseProperty7", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["管è²"])); //ç®¡è² |
| | | model.Add("F_paez_Assistant", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["ç级"])); //ç级 |
| | | model.Add("F_paez_Text11", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æå°ç®±å·"])); //æå°ç®±å· |
| | | //model.Add("F_paez_Text3", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["ææ¬"])); //ææ¬ |
| | | model.Add("F_paez_Text4", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æå¤§ç®±å·"])); //æå¤§ç®±å· |
| | | //model.Add("F_paez_PrintTimes", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æå°æ¬¡æ°"])); //æå°æ¬¡æ° |
| | | //model.Add("F_paez_Text5", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["线å·"])); //æ¡ç æå° |
| | | model.Add("F_paez_BaseProperty10", new JObject() { ["FNumber"] = Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["é¨é¨ä»£ç "]) }); //ç产é¨é¨ |
| | | model.Add("F_paez_Combo1", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æ¯å¦å
å¤è´¸"])); //æ¯å¦å
å¤è´¸ |
| | | model.Add("F_paez_Combo2", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["产åç±»å"])); //产åç±»å |
| | | model.Add("F_paez_Combo3", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["满çç¶æ"])); //满çç¶æ |
| | | model.Add("F_paez_BaseProperty11", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["è§æ ¼åå·"])); //è§æ ¼åå· |
| | | model.Add("F_paez_BaseProperty12", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["ç½å«"])); //ç½å« |
| | | model.Add("F_TFKO_Text4", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["ç®±å·åç¼"])); //ç®±å·åç¼ |
| | | model.Add("F_paez_WB", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["ç½å«"])); //ç½å«1 |
| | | // //model.Add("F_paez_BaseProperty", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æºå°"])); //æºå° |
| | | // model.Add("F_paez_Decimal", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["ç®±é"])); //ç®±é |
| | | // //model.Add("F_WJUK_Text", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æ¥æº"])); //æ¥æº |
| | | // model.Add("FDEPTID1", new JObject() { ["FNumber"] = Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["é¨é¨ä»£ç "]) });//é¨é¨ |
| | | // //model.Add("F_paez_BaseProperty6", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æ»å"])); //æ»å |
| | | // //model.Add("F_paez_BaseProperty7", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["管è²"])); //ç®¡è² |
| | | // model.Add("F_paez_Assistant", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["ç级"])); //ç级 |
| | | // model.Add("F_paez_Text11", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æå°ç®±å·"])); //æå°ç®±å· |
| | | // //model.Add("F_paez_Text3", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["ææ¬"])); //ææ¬ |
| | | // model.Add("F_paez_Text4", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æå¤§ç®±å·"])); //æå¤§ç®±å· |
| | | // //model.Add("F_paez_PrintTimes", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æå°æ¬¡æ°"])); //æå°æ¬¡æ° |
| | | // //model.Add("F_paez_Text5", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["线å·"])); //æ¡ç æå° |
| | | // //model.Add("F_paez_BaseProperty10", new JObject() { ["FNumber"] = Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["é¨é¨ä»£ç "]) }); //ç产é¨é¨ |
| | | // model.Add("F_paez_Combo1", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æ¯å¦å
å¤è´¸"])); //æ¯å¦å
å¤è´¸ |
| | | // model.Add("F_paez_Combo2", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["产åç±»å"])); //产åç±»å |
| | | // model.Add("F_paez_Combo3", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["满çç¶æ"])); //满çç¶æ |
| | | // //model.Add("F_paez_BaseProperty11", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["è§æ ¼åå·"])); //è§æ ¼åå· |
| | | // //model.Add("F_paez_BaseProperty12", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["ç½å«"])); //ç½å« |
| | | // //model.Add("F_TFKO_Text4", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["ç®±å·åç¼"])); //ç®±å·åç¼ |
| | | // model.Add("F_paez_WB", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["ç½å«"])); //ç½å«1 |
| | | |
| | | |
| | | JArray Fentity = new JArray(); |
| | | foreach (DataRow item in ds.Tables[1].Rows) |
| | | { |
| | | JObject FentityModel = new JObject(); |
| | | FentityModel.Add("FSrcEntryId", item["FSRCENTRYID"].ToString());// æºååå½å
ç ã |
| | | FentityModel.Add("FIsNew", item["FIsNew"].ToString());// æºåç±»å |
| | | FentityModel.Add("FMaterialId", new JObject() { ["FNumber"] = item["FMaterialId"].ToString() }); // ç©æç¼ç |
| | | FentityModel.Add("FREPORTTYPE", new JObject() { ["FNumber"] = item["FREPORTTYPE"].ToString() }); // çäº§æ±æ¥ç±»å |
| | | FentityModel.Add("FProductType", item["FPRODUCTTYPE"].ToString());// 产åç±»å |
| | | FentityModel.Add("FUNITID", new JObject() { ["FNumber"] = item["FUNITID"].ToString() });//åä½ |
| | | FentityModel.Add("FWORKSHIPID", new JObject() { ["FNumber"] = item["FWORKSHOPID"].ToString() });//çäº§è½¦é´ |
| | | FentityModel.Add("FMTONO", item["FMTONO"].ToString());// 计åè·è¸ªå· |
| | | FentityModel.Add("FCheckProduct", item["FCheckProduct"].ToString());// äº§åæ£éª |
| | | FentityModel.Add("FISENTRUST", item["FISENTRUST"].ToString());// ç»ç»å§æå å·¥ |
| | | FentityModel.Add("FSrcBillType", item["FSRCBILLTYPE"].ToString());// æºåç±»å |
| | | FentityModel.Add("FMOBILLNO", item["FMOBILLNO"].ToString());// ç产订å |
| | | FentityModel.Add("FSrcBillNo", item["FSrcBillNo"].ToString());// æºåç¼å· |
| | | FentityModel.Add("FMoEntrySeq", item["FMoEntrySeq"].ToString());//ç产订åè¡å· |
| | | FentityModel.Add("FPROJECTNO", item["FPROJECTNO"].ToString());// 项ç®ç¼å· |
| | | FentityModel.Add("FSTDMANHOUR", item["FSTDMANHOUR"].ToString());// å使 åå·¥æ¶ |
| | | FentityModel.Add("FHRPREPARETIME", item["FHRPREPARETIME"].ToString());// 人ååå¤å·¥æ¶ |
| | | FentityModel.Add("FMACPREPARETIME", item["FMACPREPARETIME"].ToString());// æºå¨åå¤å·¥æ¶ |
| | | FentityModel.Add("FSrcInterId", item["FSrcInterId"].ToString());// æºåå
ç |
| | | FentityModel.Add("FSrcEntrySeq", item["FSrcEntrySeq"].ToString());// æºåè¡å· |
| | | FentityModel.Add("FMoId", item["FMoId"].ToString());//ç产订åå
ç |
| | | FentityModel.Add("FMoEntryId", item["FMoEntryId"].ToString());//ç产订ååå½å· |
| | | FentityModel.Add("FBaseUnitID", new JObject() { ["FNumber"] = item["FBaseUnitID"].ToString() });//åä½ |
| | | FentityModel.Add("FSTOCKINORGID", new JObject() { ["FNumber"] = item["FSTOCKINORGID"].ToString() });//å
¥åºç»ç» |
| | | FentityModel.Add("FOwnerTypeId", item["FOwnerTypeId"].ToString());// 货主类å |
| | | FentityModel.Add("FOwnerId", new JObject() { ["FNumber"] = item["FOwnerId"].ToString() });// 货主 |
| | | FentityModel.Add("FSTOCKID", new JObject() { ["FNumber"] = item["FSTOCKID"].ToString() });//ä»åº |
| | | FentityModel.Add("FCostRate", item["FCOSTRATE"].ToString());// ææ¬æé |
| | | FentityModel.Add("FSNUNITID", new JObject() { ["FNumber"] = item["FSNUNITID"].ToString() });//åºåå·åä½ |
| | | FentityModel.Add("FISBACKFLUSH", item["FISBACKFLUSH"].ToString());// åå²é¢æ |
| | | FentityModel.Add("FMOMAINENTRYID", item["FMOMAINENTRYID"].ToString());// ç产订å主产ååå½ |
| | | FentityModel.Add("FQAIP", item["FQAIP"].ToString());//ç´§æ¥æ¾è¡ |
| | | FentityModel.Add("FREQSRC", item["FREQSRC"].ToString());//éæ±æ¥æº |
| | | FentityModel.Add("FREQBILLNO", item["FREQBILLNO"].ToString());//鿱忮 |
| | | FentityModel.Add("FREQBILLID", item["FREQBILLID"].ToString());// 鿱忮å
ç |
| | | FentityModel.Add("FREQENTRYSEQ", item["FREQENTRYSEQ"].ToString());//鿱忮è¡å· |
| | | FentityModel.Add("FREQENTRYID", item["FREQENTRYID"].ToString());// 鿱忮åå½å
ç |
| | | FentityModel.Add("FBASEQUAQTY", item["FBASEQUAQTY"].ToString());// åºæ¬åä½åæ ¼æ°é |
| | | FentityModel.Add("FQUAQTY", item["FQUAQTY"].ToString());//åæ ¼æ°é |
| | | FentityModel.Add("FFailQty", item["FFailQty"].ToString());//ä¸åæ ¼æ°é |
| | | FentityModel.Add("FScrapQty", item["FScrapQty"].ToString());//æ¥åºæ°é |
| | | FentityModel.Add("FBASEFINISHQTY", item["FBASEFINISHQTY"].ToString());//åºæ¬åä½å®ææ°é |
| | | FentityModel.Add("FFINISHQTY", item["FFINISHQTY"].ToString());//宿æ°é |
| | | FentityModel.Add("FLot", new JObject() { ["FNumber"] = item["FLot"].ToString() });//æ¹å· |
| | | FentityModel.Add("FBOMID", new JObject() { ["FNumber"] = item["FBOMID"].ToString() });// BOMçæ¬ |
| | | // JArray Fentity = new JArray(); |
| | | // foreach (DataRow item in ds.Tables[1].Rows) |
| | | // { |
| | | // JObject FentityModel = new JObject(); |
| | | // FentityModel.Add("FMATERIALID", new JObject() { ["FNumber"] = item["ç©æä»£ç "].ToString() }); // ç©æä»£ç |
| | | // FentityModel.Add("FUnitID", new JObject() { ["FNumber"] = item["计éåä½ä»£ç "].ToString() }); // åä½ä»£ç |
| | | // FentityModel.Add("FQty", item["åé"].ToString()); //åé |
| | | // FentityModel.Add("FBASEUNITID", new JObject() { ["FNumber"] = item["åºæ¬è®¡éåä½ä»£ç "].ToString() }); // åºæ¬åä½ä»£ç |
| | | // FentityModel.Add("FBASEQTY", item["宿¶æ°é"].ToString()); //宿¶æ°é |
| | | // FentityModel.Add("FSecUNITID", new JObject() { ["FNumber"] = item["åºåè¾
计éåä½ä»£ç "].ToString() }); // åºåè¾
计éåä½ä»£ç |
| | | // FentityModel.Add("FSecQTY", item["åºåè¾
åä½å®æ¶æ°é"].ToString()); //宿¶æ°éï¼åºåè¾
åä½ï¼ |
| | | // FentityModel.Add("FOWNERTYPEID", item["货主类å"].ToString()); //货主类å |
| | | // FentityModel.Add("FOWNERID", new JObject() { ["FNumber"] = item["货主代ç "].ToString() }); // 货主代ç |
| | | // FentityModel.Add("FKEEPERTYPEID", item["ä¿ç®¡è
ç±»å"].ToString()); //ä¿ç®¡è
ç±»å |
| | | // FentityModel.Add("FKEEPERID", new JObject() { ["FNumber"] = item["ä¿ç®¡è
代ç "].ToString() }); // ä¿ç®¡è
代ç |
| | | // FentityModel.Add("FAuxPropId", new JObject() { ["FAUXPROPID__FF100003"] = new JObject() { ["FNumber"] = item["è¾
å©å±æ§ä»£ç "].ToString() } } ); // è¾
å©å±æ§ |
| | | // FentityModel.Add("FExtAuxUnitId", new JObject() { ["FNumber"] = item["è¾
计éåä½ä»£ç "].ToString() }); // è¾
计éåä½ä»£ç |
| | | // FentityModel.Add("FExtAuxUnitQty", item["ç®±æ°"].ToString()); //ç®±æ° |
| | | // FentityModel.Add("F_TFKO_Assistant", new JObject() { ["FNumber"] = item["ç½å«ä»£ç "].ToString() }); // ç½å« |
| | | // FentityModel.Add("F_TFKO_Assistant1", new JObject() { ["FNumber"] = item["åå代ç "].ToString() }); // åå |
| | | // FentityModel.Add("F_TFKO_Assistant2", new JObject() { ["FNumber"] = item["è²æ³½ä»£ç "].ToString() }); // è²æ³½ |
| | | // FentityModel.Add("F_TFKO_Assistant3", new JObject() { ["FNumber"] = item["纤度代ç "].ToString() }); // 纤度 |
| | | // FentityModel.Add("F_paez_Qty", item["æ¯é"].ToString()); //æ¯é |
| | | // FentityModel.Add("F_TFKO_Text1", item["管è²"].ToString()); //ç®¡è² |
| | | // FentityModel.Add("F_TFKO_Text2", item["æ»å"].ToString()); //æ»å |
| | | // FentityModel.Add("FBoxcode", item["ç®±å·"].ToString()); //ç®±å· |
| | | // FentityModel.Add("F_PAEZ_SQSL", item["ç³è¯·åæ°é"].ToString()); //ç³è¯·åæ°é |
| | | // FentityModel.Add("F_paez_Integer4", item["çåæ°"].ToString()); //çåæ° |
| | | // FentityModel.Add("F_paez_BaseQty", item["å®åæ°é"].ToString()); //å®åæ°é |
| | | // FentityModel.Add("F_paez_Qty1", item["宿¶æ°é"].ToString()); //宿¶æ°é |
| | | // FentityModel.Add("F_paez_Text2", item["ç®±å·"].ToString()); //ç®±å· |
| | | |
| | | JArray Fentity2 = new JArray(); |
| | | JObject FentityModel2 = new JObject(); |
| | | FentityModel2.Add("FEntity_Link_FFlowId", item["FEntity_Link_FFlowId"].ToString()); |
| | | FentityModel2.Add("FEntity_Link_FFlowLineId", item["FEntity_Link_FFlowLineId"].ToString()); |
| | | FentityModel2.Add("FEntity_Link_FRuleId", item["FEntity_Link_FRuleId"].ToString()); |
| | | FentityModel2.Add("FEntity_Link_FSTableName", item["FEntity_Link_FSTableName"].ToString()); |
| | | FentityModel2.Add("FEntity_Link_FSBillId", item["FEntity_Link_FSBillId"].ToString()); |
| | | FentityModel2.Add("FEntity_Link_FSId", item["FEntity_Link_FSId"].ToString()); |
| | | Fentity2.Add(FentityModel2); |
| | | FentityModel.Add("FEntity_Link", Fentity2); |
| | | FentityModel.Add("FBFLowId", new JObject() { ["FID"] = item["FBFLOWID"].ToString() }); |
| | | Fentity.Add(FentityModel); |
| | | } |
| | | model.Add("FEntity", Fentity); //æç»ä¿¡æ¯ |
| | | JObject jsonRoot = new JObject() |
| | | { |
| | | ["Creator"] = "", |
| | | ["NeedUpDateFields"] = new JArray(), |
| | | ["NeedReturnFields"] = new JArray(), |
| | | //["IsDeleteEntry"] = "true", |
| | | //["SubSystemId"] = "", |
| | | //["IsVerifyBaseDataField"] = "false", |
| | | ["IsDeleteEntry"] = "true", |
| | | ["SubSystemId"] = "", |
| | | ["IsVerifyBaseDataField"] = "true", |
| | | ["IsEntryBatchFill"] = "false", |
| | | ["ValidateFlag"] = "true", |
| | | ["NumberSearch"] = "true", |
| | | ["IsAutoAdjustField"] = "false", |
| | | ["InterationFlags"] = "", |
| | | ["IgnoreInterationFlag"] = "", |
| | | //["IsAutoSubmitAndAudit"] = true,//èªå¨è°ç¨æäº¤åå®¡æ ¸åè½ |
| | | ["Model"] = model |
| | | }; |
| | | |
| | | //ä»é
ç½®æä»¶è·å CLOUDç½åãè´¦å¥ä¿¡æ¯ãç»å½ç¨æ·ãç»å½å¯ç |
| | | if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo)) |
| | | { |
| | | oCn.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å
¥åºç³è¯·å忥è·åç»å½è´¦å·å¯ç 失败ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | // //JArray Fentity2 = new JArray(); |
| | | // //JObject FentityModel2 = new JObject(); |
| | | // //FentityModel2.Add("FEntity_Link_FFlowId", item["FEntity_Link_FFlowId"].ToString()); |
| | | // //FentityModel2.Add("FEntity_Link_FFlowLineId", item["FEntity_Link_FFlowLineId"].ToString()); |
| | | // //FentityModel2.Add("FEntity_Link_FRuleId", item["FEntity_Link_FRuleId"].ToString()); |
| | | // //FentityModel2.Add("FEntity_Link_FSTableName", item["FEntity_Link_FSTableName"].ToString()); |
| | | // //FentityModel2.Add("FEntity_Link_FSBillId", item["FEntity_Link_FSBillId"].ToString()); |
| | | // //FentityModel2.Add("FEntity_Link_FSId", item["FEntity_Link_FSId"].ToString()); |
| | | // //Fentity2.Add(FentityModel2); |
| | | // //FentityModel.Add("FEntity_Link", Fentity2); |
| | | // //FentityModel.Add("FBFLowId", new JObject() { ["FID"] = item["FBFLOWID"].ToString() }); |
| | | // Fentity.Add(FentityModel); |
| | | // } |
| | | // model.Add("FEntity", Fentity); //æç»ä¿¡æ¯ |
| | | // JObject jsonRoot = new JObject() |
| | | // { |
| | | // ["Creator"] = "", |
| | | // ["NeedUpDateFields"] = new JArray(), |
| | | // ["NeedReturnFields"] = new JArray(), |
| | | // //["IsDeleteEntry"] = "true", |
| | | // //["SubSystemId"] = "", |
| | | // //["IsVerifyBaseDataField"] = "false", |
| | | // ["IsDeleteEntry"] = "true", |
| | | // ["SubSystemId"] = "", |
| | | // ["IsVerifyBaseDataField"] = "true", |
| | | // ["IsEntryBatchFill"] = "false", |
| | | // ["ValidateFlag"] = "true", |
| | | // ["NumberSearch"] = "true", |
| | | // ["IsAutoAdjustField"] = "false", |
| | | // ["InterationFlags"] = "", |
| | | // ["IgnoreInterationFlag"] = "", |
| | | // //["IsAutoSubmitAndAudit"] = true,//èªå¨è°ç¨æäº¤åå®¡æ ¸åè½ |
| | | // ["Model"] = model |
| | | // }; |
| | | |
| | | var loginRet = InvokeHelper.Login(); |
| | | var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>(); |
| | | if (isSuccess == 0) |
| | | { |
| | | oCn.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ç»å½éè¶å¤±è´¥ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | string result = InvokeHelper.Save("PRD_MORPT", JsonConvert.SerializeObject(jsonRoot));//ä¿å |
| | | // //ä»é
ç½®æä»¶è·å CLOUDç½åãè´¦å¥ä¿¡æ¯ãç»å½ç¨æ·ãç»å½å¯ç |
| | | // if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo)) |
| | | // { |
| | | // oCn.RollBack(); |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "å
¥åºç³è¯·å忥è·åç»å½è´¦å·å¯ç 失败ï¼"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | // } |
| | | |
| | | if (JObject.Parse(result)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") |
| | | { |
| | | LogService.Write(JsonConvert.SerializeObject(jsonRoot)); |
| | | oCn.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å
¥åºç³è¯·å忥éè¶äºå¤±è´¥ï¼åå·:" + HSourceBillNo + result + jsonRoot; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | // var loginRet = InvokeHelper.Login(); |
| | | // var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>(); |
| | | // if (isSuccess == 0) |
| | | // { |
| | | // oCn.RollBack(); |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "ç»å½éè¶å¤±è´¥ï¼"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | // } |
| | | // else |
| | | // { |
| | | // string result = InvokeHelper.Save("k18d2ab4f14034c569576ec8e0835a80c", JsonConvert.SerializeObject(jsonRoot));//ä¿å |
| | | |
| | | //æäº¤å®¡æ ¸ |
| | | string result1 = string.Empty; |
| | | string result2 = string.Empty; |
| | | var fID = JObject.Parse(result)["Result"]["Id"].ToString(); |
| | | var fBillNo = JObject.Parse(result)["Result"]["Number"].ToString(); |
| | | var json = new |
| | | { |
| | | Ids = fID, |
| | | }; |
| | | if (oSystemParameter.omodel.Sc_ICMOReportBill_AutoCheck == "Y") //ç³»ç»åæ° èªå¨å®¡æ ¸ |
| | | { |
| | | result1 = InvokeHelper.Submit("PRD_MORPT", JsonConvert.SerializeObject(json));//æäº¤ |
| | | result2 = InvokeHelper.Audit("PRD_MORPT", JsonConvert.SerializeObject(json));//å®¡æ ¸ |
| | | // if (JObject.Parse(result)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") |
| | | // { |
| | | // LogService.Write(JsonConvert.SerializeObject(jsonRoot)); |
| | | // oCn.RollBack(); |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "å
¥åºç³è¯·å忥éè¶äºå¤±è´¥ï¼åå·:" + HSourceBillNo + result + jsonRoot; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | // } |
| | | |
| | | if (JObject.Parse(result1)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") |
| | | { |
| | | oCn.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å
¥åºç³è¯·ååå·:" + ",æäº¤å¤±è´¥" + result1; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | // //æäº¤å®¡æ ¸ |
| | | // string result1 = string.Empty; |
| | | // string result2 = string.Empty; |
| | | // var fID = JObject.Parse(result)["Result"]["Id"].ToString(); |
| | | // var fBillNo = JObject.Parse(result)["Result"]["Number"].ToString(); |
| | | // var json = new |
| | | // { |
| | | // Ids = fID, |
| | | // }; |
| | | // if (oSystemParameter.omodel.Kf_StockInRequestBill_AutoCheck == "Y") //ç³»ç»åæ° èªå¨å®¡æ ¸ |
| | | // { |
| | | // result1 = InvokeHelper.Submit("k18d2ab4f14034c569576ec8e0835a80c", JsonConvert.SerializeObject(json));//æäº¤ |
| | | // result2 = InvokeHelper.Audit("k18d2ab4f14034c569576ec8e0835a80c", JsonConvert.SerializeObject(json));//å®¡æ ¸ |
| | | |
| | | if (JObject.Parse(result2)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") |
| | | { |
| | | oCn.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å
¥åºç³è¯·ååå·:" + ",å®¡æ ¸å¤±è´¥" + result2; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "è·åç³»ç»åæ°å¤±è´¥ï¼ " + sErrMsg; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | // if (JObject.Parse(result1)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") |
| | | // { |
| | | // oCn.RollBack(); |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "å
¥åºç³è¯·ååå·:" + ",æäº¤å¤±è´¥" + result1; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | // } |
| | | |
| | | // if (JObject.Parse(result2)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") |
| | | // { |
| | | // oCn.RollBack(); |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "å
¥åºç³è¯·ååå·:" + ",å®¡æ ¸å¤±è´¥" + result2; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | // } |
| | | // } |
| | | // } |
| | | // } |
| | | // } |
| | | // } |
| | | // } |
| | | //} |
| | | //else |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "è·åç³»ç»åæ°å¤±è´¥ï¼ " + sErrMsg; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | |
| | | string sExpressNumber = ""; |
| | | WebSoBar = oWebs.get_CheckTypeByBarCode_All(sCode, sInterID, HBillType, sBillNo, sMaker, WhID, SPID, sQty, sRedBlue, SourceFlag, sSourceBillNo, sSourceType, HOWNERID, sExpressNumber, ref DBUtility.ClsPub.sErrInfo); |