| | |
| | | |
| | | #region æ«ç 模åè°ç¨æ¹æ³ |
| | | |
| | | #region å
¶ä»å
¥åº è·åå
¥åºç±»å |
| | | |
| | | /// <summary> |
| | | /// è·åå
¥åºç±»å |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("WEBSController/GetStockInStyle_Json")] |
| | | [HttpGet] |
| | | public Object GetStockInStyle_Json() |
| | | { |
| | | try |
| | | { |
| | | ds = oWebs.get_StockInStyle(); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¥è¯¢ä¸å°å
¥åºç±»åä¿¡æ¯ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "æå"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "è·åå
¥åºç±»åä¿¡æ¯å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | #region å
¶ä»åºåº è·ååºåºç±»å |
| | | |
| | | /// <summary> |
| | | /// è·ååºåºç±»å |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("WEBSController/GetStockOutStyle_Json")] |
| | | [HttpGet] |
| | | public Object GetStockOutStyle_Json() |
| | | { |
| | | try |
| | | { |
| | | ds = oWebs.get_StockOutStyle(); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¥è¯¢ä¸å°åºåºç±»åä¿¡æ¯ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "æå"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "è·ååºåºç±»åä¿¡æ¯å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | #region ç´æ¥è°æ¨ è·åè°æ¨åºè´§ç±»å |
| | | |
| | | /// <summary> |
| | |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | |
| | | #region æ«ç 模å 客æ·ãä¼ ç¥¨ãæ¡ç éªè¯è°ç¨ |
| | | |
| | | /// <summary> |
| | | /// æ«ç 模å 客æ·ãä¼ ç¥¨ãæ¡ç éªè¯è°ç¨ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("WEBSController/GetCheakBarCodeAndCP_Json")] |
| | | [HttpGet] |
| | | public object GetCheakBarCodeAndCP_Json(long HCusID, string HCP, string HBarCode) |
| | | { |
| | | try |
| | | { |
| | | HBarCode = HBarCode.Trim(); |
| | | if (oWebs.Get_CheakBarCodeAndCP(HCusID, HCP, HBarCode, ref DBUtility.ClsPub.sErrInfo)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = DBUtility.ClsPub.sErrInfo; //æåï¼ |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = DBUtility.ClsPub.sErrInfo; //å¤±è´¥ï¼ |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "客æ·ãä¼ ç¥¨ãæ¡ç éªè¯å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | |
| | | #endregion |
| | | |
| | |
| | | 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("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() }); // è²æ³½ ???å¿
å¡« |
| | |
| | | } |
| | | } |
| | | } |
| | | |
| | | //æ´æ°æ¡ç æºåidä¿¡æ¯ |
| | | sql = string.Format($@"update a set HSourceInterID = b.FID,HSourceEntryID = c.FEntryID from Gy_BarCodeBill a left join AIS20220609121235..TFKO_t_Cust100009 b on a.HSourceBillNo = b.FBillNo left join AIS20220609121235..TFKO_t_Cust_Entry100065 c on b.FID = C.FID and a.HBarcodeNo = c.FSEQ where HSourceBillNo = '{HSourceBillNo_TB}'"); |
| | | //æ§è¡æ´æ°è¯å¥ |
| | | oCn.RunProc(sql); |
| | | |
| | | } |
| | | } |
| | | |
| | | sJXCode = sBarCode; |
| | | |
| | | //æ´æ°æ¡ç æºåidä¿¡æ¯ |
| | | sql = string.Format($@"update a set HSourceInterID = b.FID,HSourceEntryID = c.FEntryID from Gy_BarCodeBill a left join AIS20220609121235..TFKO_t_Cust100009 b on a.HSourceBillNo = b.FBillNo left join AIS20220609121235..TFKO_t_Cust_Entry100065 c on b.FID = C.FID and a.HBarcodeNo = c.FSEQ where HSourceBillNo = '{HSourceBillNo_TB}'"); |
| | | //æ§è¡æ´æ°è¯å¥ |
| | | oCn.RunProc(sql); |
| | | sJXCode = sBarCode; |
| | | } |
| | | else |
| | | { |
| | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没æè¿åä»»ä½è®°å½ï¼"; |
| | | objJsonResult.data = null; |
| | | objJsonResult.data = new |
| | | { |
| | | Materlist = ds.Tables[0], //è¿åç©ææç»å表信æ¯ï¼0ï¼ |
| | | Mouldlist = ds.Tables[1], //è¿å模治å
·å表信æ¯ï¼1ï¼ |
| | | FIFOlist = ds.Tables[2], //è¿åå
è¿å
åºå表信æ¯ï¼2ï¼ |
| | | BarCodelist = ds.Tables[3], //è¿åæ¡ç æç»å表信æ¯ï¼3ï¼ |
| | | ICMOReportlist = ds.Tables[4], //è¿åæºåçäº§æ±æ¥åæ¡ç æç»å表信æ¯ï¼4ï¼ |
| | | BarCodeDetailslist = ds.Tables[5] //è¿åå½åææ«ææ¡ç æç»ä¿¡æ¯ï¼5ï¼ |
| | | }; |
| | | return objJsonResult; |
| | | } |
| | | else |