public JsonResult GetEAN(string materialno) { try { T_Material_DB t_Material_DB = new T_Material_DB(); string EAN = t_Material_DB.getEAN(materialno); if (!string.IsNullOrEmpty(EAN)) { return(Json(new { state = true, obj = EAN }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { state = false }, JsonRequestBehavior.AllowGet)); } } catch (Exception) { return(Json(new { state = false }, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// PDA提交JSON转换成List对象 /// </summary> /// <param name="ModelListJson"></param> /// <returns></returns> protected override List <T_InStockDetailInfo> GetModelListByJson(string UserJson, string ModelListJson) { LogNet.LogInfo("SaveT_InStockDetailADF---" + ModelListJson); int IsQuality = 0; string strUserNo = string.Empty; List <T_InStockDetailInfo> modelList = JSONHelper.JsonToObject <List <T_InStockDetailInfo> >(ModelListJson); UserModel user = JSONHelper.JsonToObject <UserModel>(UserJson); modelList.ForEach(t => t.ReceiveQty = t.ScanQty); modelList = modelList.Where(t => t.ReceiveQty > 0).ToList(); //IsQuality = GetIsQuality(modelList[0]); IsQuality = GetIsQualityByVoucherType(modelList[0]); string StrongHoldCode = ""; string StrongHoldCodeName = ""; T_WareHouse_DB TWareHouseDB = new T_WareHouse_DB(); TWareHouseDB.GetStrongholdcode(user.ReceiveWareHouseNo, ref StrongHoldCode, ref StrongHoldCodeName); modelList.ForEach(t => { t.IsQuality = IsQuality; foreach (var itemBarCode in t.lstBarCode) { //成品入库单做一个调拨的操作 if (t.VoucherType == 50) { T_Material_DB MaterialDB = new T_Material_DB(); itemBarCode.MaterialNoID = MaterialDB.GetMaterialNoid(itemBarCode.MaterialNo, "0300"); } else { T_Material_DB MaterialDB = new T_Material_DB(); itemBarCode.MaterialNoID = MaterialDB.GetMaterialNoid(itemBarCode.MaterialNo, StrongHoldCode); } } }); //if (TOOL.RegexMatch.isExists(user.UserNo) == true) //{ // strUserNo = user.UserNo.Substring(0, user.UserNo.Length - 1); //} //else //{ // strUserNo = user.UserNo; //} ////确定过账人,根据登录账户以及操作的订单据点来确定 //User_DB _db = new User_DB(); //string strPostUser = _db.GetPostAccountByUserNo(strUserNo, modelList[0].StrongHoldCode); foreach (var item in modelList) { if (item.lstBarCode != null && item.lstBarCode.Count() > 0) { item.SupPrdBatch = item.lstBarCode.FirstOrDefault().SupPrdBatch; item.SupPrdDate = item.lstBarCode.FirstOrDefault().SupPrdDate; item.StrSupPrdDate = item.lstBarCode.FirstOrDefault().SupPrdDate.ToShortDateString(); item.BatchNo = item.lstBarCode.FirstOrDefault().BatchNo; //item.IsSpcBatch=="Y"?item.FromBatchNo: item.lstBarCode.FirstOrDefault().BatchNo; item.ReceiveWareHouseNo = user.ReceiveWareHouseNo; item.ReceiveAreaNo = string.Empty; item.ReceiveUserNo = user.UserNo;// strPostUser; item.FromErpWarehouse = user.ReceiveWareHouseNo; item.ToErpAreaNo = string.Empty; item.ToBatchNo = item.BatchNo; //item.PostUser = user.UserNo; item.PostUser = user.UserName; item.StrEDate = item.lstBarCode.FirstOrDefault().EDate.ToString("yyyy/MM/dd"); } //item..PostDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd")); } return(modelList); }
//物料:flag= "0" 入库单:1 出库单 2 public bool GetVoucherNo(string Erpvoucherno, ref string ErrorMsg, string flag = "0") { if (string.IsNullOrEmpty(Erpvoucherno)) { ErrorMsg = "单据号不能为空"; return(false); } int WmsVoucherType = 9999; string syncType = "ERP"; int syncExcelVouType = -1; DataSet excelds = null; int StockType = 0; string tableName = "t_material"; if (Erpvoucherno.Contains("Wgr"))//成品入库单 { tableName = " T_instock"; StockType = 10; WmsVoucherType = 50; } if (Erpvoucherno.Contains("RE"))//退回处理单 { tableName = " T_instock"; StockType = 10; WmsVoucherType = 47; } if (Erpvoucherno.Contains("MO"))//生产订单 { tableName = " T_Product"; StockType = 10; WmsVoucherType = 51; } if (Erpvoucherno.Contains("SM"))//销售出货单 { tableName = " T_Task"; StockType = 20; WmsVoucherType = 46; } if (Erpvoucherno.Contains("Tra"))//形态转换单 { StockType = 10; WmsVoucherType = 52; } if (Erpvoucherno.Contains("DC"))//调拨出库单 { if (flag == "1") { tableName = " T_instock"; StockType = 10; WmsVoucherType = 30; } else { tableName = " T_Task"; StockType = 20; WmsVoucherType = 31; } } if (Erpvoucherno.Contains("DR"))//调拨入库单 { tableName = " T_instock"; StockType = 10; WmsVoucherType = 30; } if (Erpvoucherno.Contains("ZF"))//杂发单 { StockType = 20; WmsVoucherType = 0; } if (WmsVoucherType == 0 || tableName == "") { ErrorMsg = "找不到该单据类型!"; return(false); } if (flag != "0") { //查看单据是否存在 T_Material_DB DB = new T_Material_DB(); if (DB.GetCount("SELECT count(1) FROM " + tableName + " WHERE erpvoucherno ='" + Erpvoucherno + "'") > 0) { return(true); } //using (var db = SqlSugarBase.GetInstance()) //{ // if (db.Ado.GetInt("SELECT count(1) FROM " + tableName + " WHERE erpvoucherno ='" + Erpvoucherno + "'") > 0) // { // return true; // } //} } //同步单据 if (SyncErp.SyncJsonFromErp(StockType, string.Empty, Erpvoucherno, WmsVoucherType, ref ErrorMsg)) { return(true); } else { return(false); } }
//专门给U9用 public bool SaveBarcode(List <Barcode_Model> backmodels, ref string strMsg) { try { T_Material_DB MDB = new T_Material_DB(); Print_DB print_DB = new Print_DB(); bool flag = false; string info = ""; backmodels.ForEach(item => { int Materialnoid = MDB.GetMaterialNoid(item.MaterialNo, item.StrongHoldCode); if (Materialnoid == 0) { info = "据点【" + item.StrongHoldCode + "】物料主数据没有物料【" + item.MaterialNo + "】信息!"; flag = true; } else { item.MaterialNoID = Materialnoid; } item.CompanyCode = ""; item.VoucherType = "51"; item.Creater = "U9"; item.RowNo = "1"; item.RowNoDel = "1"; item.BarcodeType = 1; }); if (flag) { strMsg = info; return(false); } if (print_DB.SubBarcodes(backmodels, "sup", 1, ref strMsg)) { return(true); } else { return(false); } //List<Barcode_Model> listbarcode = new List<Barcode_Model>(); //foreach (var backmodel in backmodels) //{ // Barcode_Model model = new Barcode_Model(); // model.CompanyCode = ""; // model.ErpVoucherNo = backmodel.ErpVoucherNo; // model.VoucherType = "51"; // model.StrongHoldCode = backmodel.StrongHoldCode; // model.StrongHoldName = backmodel.StrongHoldName; // model.MaterialNoID = backmodel.MaterialNoID; // model.MaterialNo = backmodel.MaterialNo; // model.MaterialDesc = backmodel.MaterialDesc; // model.spec = backmodel.spec; // model.BatchNo = backmodel.BatchNo; // model.ProductBatch = backmodel.ProductBatch;//给批号加密成8位 // model.ErpVoucherNo = backmodel.ErpVoucherNo; // model.Qty = backmodel.Qty; // model.CusCode = backmodel.CusCode; // model.CusName = backmodel.CusName; // model.StoreCondition = backmodel.StoreCondition; // model.ProtectWay = backmodel.ProtectWay; // model.LABELMARK = backmodel.LABELMARK; // model.SerialNo = backmodel.SerialNo; // model.Creater = "U9"; // model.ReceiveTime = DateTime.Now; // model.BarCode = "2@" + model.MaterialNo + "@" + model.Qty + "@" + model.SerialNo; // model.RowNo = "1"; // model.RowNoDel = "1"; // model.BarcodeType = 1; // listbarcode.Add(model); //} //if (print_DB.SubBarcodes(backmodels, "sup", 1, ref strMsg)) //{ // return true; //} //else //{ // return false; //} } catch (Exception ex) { strMsg = ex.ToString(); return(false); } }