public string GetOffList(string ErpVoucherno) { LogNet.LogInfo("发货清单:" + ErpVoucherno); BaseMessage_Model <List <OffList> > model = new BaseMessage_Model <List <OffList> >(); try { List <OffList> list = new List <OffList>(); T_OutBarcode_DB _db = new T_OutBarcode_DB(); if (!_db.GetOffList(ErpVoucherno, ref list)) { model.HeaderStatus = "E"; model.Message = "获取数据失败!"; return(JSONHelper.ObjectToJson <BaseMessage_Model <List <OffList> > >(model)); } model.HeaderStatus = "S"; model.ModelJson = list; return(JSONHelper.ObjectToJson <BaseMessage_Model <List <OffList> > >(model)); } catch (Exception ex) { model.HeaderStatus = "E"; model.Message = ex.Message; return(JSONHelper.ObjectToJson <BaseMessage_Model <List <OffList> > >(model)); } }
public ActionResult SaveBarcodePro(string data) { LogNet.LogInfo("外箱打印开始"); LogNet.LogInfo("外箱打印:" + data); var objT_InStockDetailInfo = JsonConvert.DeserializeObject <View_Product_Model>(data); string err = ""; T_Product_DB print_DB = new T_Product_DB(); DateTime time1 = DateTime.Now; try { LogNet.LogInfo("外箱打印开始SaveBarcodeForPro前"); if (print_DB.SaveBarcodeForPro(currentUser, objT_InStockDetailInfo, time1, ref err)) { LogNet.LogInfo("外箱打印开始SaveBarcodeForPro后"); return(Json(new { state = true, obj = time1.ToString("yyyy/MM/dd HH:mm:ss") }, JsonRequestBehavior.AllowGet)); } return(Json(new { state = false, obj = err }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { state = false, obj = ex.ToString() }, JsonRequestBehavior.AllowGet)); } }
protected override List <T_QualityDetailInfo> GetModelListByJson(string UserJson, string ModelListJson) { UserModel userModel = JSONHelper.JsonToObject <UserModel>(UserJson); List <T_QualityDetailInfo> modelList = JSONHelper.JsonToObject <List <T_QualityDetailInfo> >(ModelListJson); string strUserNo = string.Empty; string strPostUser = string.Empty; //if (TOOL.RegexMatch.isExists(userModel.UserNo) == true) //{ // strUserNo = userModel.UserNo.Substring(0, userModel.UserNo.Length - 1); //} //else //{ // strUserNo = userModel.UserNo; //} //User_DB _db = new User_DB(); //strPostUser = _db.GetPostAccountByUserNo(strUserNo, modelList[0].StrongHoldCode); foreach (var item in modelList) { item.FromErpWarehouse = item.lstStock.FirstOrDefault().WarehouseNo; item.FromErpAreaNo = item.lstStock.FirstOrDefault().AreaNo; item.FromBatchNo = item.lstStock.FirstOrDefault().BatchNo; item.ToErpWarehouse = userModel.ToSampWareHouseNo; item.ToErpAreaNo = userModel.ToSampAreaNo; item.PostUser = userModel.UserNo;// strPostUser; } LogNet.LogInfo("UpadteT_QualityUserADF-----" + JSONHelper.ObjectToJson <List <T_QualityDetailInfo> >(modelList)); return(modelList); }
public string GetInfoList(string id, string StrongHoldCode) { LogNet.LogInfo("基础数据:" + id + "S:" + StrongHoldCode); T_Material_Batch_Func tfunc = new T_Material_Batch_Func(); return(tfunc.GetInfoList(id, StrongHoldCode)); }
public bool SaveModelListBySqlToDB(User.UserModel user, ref List <TBase_Model> modelList, ref string strError) { try { List <string> lstSql = new List <string>(); lstSql = this.GetSaveModelListSql(user, modelList); if (lstSql == null || lstSql.Count == 0) { return(true); } int i = dbFactory.ExecuteNonQueryList(lstSql, ref strError); if (i > 0) { return(true); } else { return(false); } } catch (Exception ex) { LogNet.LogInfo("SaveModelListBySqlToDB:" + ex.Message); strError = ex.Message; return(false); //throw new Exception(ex.Message); } }
public string CreateInterfacePost(T_InterfaceInfo model, string VoucherJson) { JsonModel jsonModel = new JsonModel(); try { var assembly = Assembly.LoadFile(@model.Route); var type = assembly.GetType(model.ClassName); var instance = assembly.CreateInstance(model.ClassName); //type.GetProperty("strJson").SetValue(instance, modeJson, null); //strError = type.GetProperty("strErrMsg").GetValue(instance).ToString(); object[] obj = new object[1]; obj[0] = VoucherJson; var method = type.GetMethod(model.FunctionName); return(method.Invoke(instance, obj).ToString()); } catch (Exception ex) { jsonModel.result = "false"; jsonModel.ErrMsg = "调用ERP接口异常:" + ex.Message + ex.InnerException; LogNet.LogInfo("CreateInterfacePost----" + jsonModel.ErrMsg); return(JSONUtil.JSONHelper.ObjectToJson <JsonModel>(jsonModel)); } }
public string CreateInterfaceGet(T_InterfaceInfo model, string VoucherJson) { JsonModel jsonModel = new JsonModel(); jsonModel.payload = new PayLoad(); jsonModel.payload.std_data = new Std(); jsonModel.payload.std_data.execution = new Exe(); try { LogNet.LogInfo("VoucherJson:" + VoucherJson); var assembly = Assembly.LoadFile(@model.Route); var type = assembly.GetType(model.ClassName); var instance = assembly.CreateInstance(model.ClassName); //type.GetProperty("strJson").SetValue(instance, modeJson, null); //strError = type.GetProperty("strErrMsg").GetValue(instance).ToString(); object[] obj = new object[1]; obj[0] = VoucherJson; var method = type.GetMethod(model.FunctionName); LogNet.LogInfo("---------------------调用ERP接口:" + model.ClassName + model.FunctionName + "参数:" + VoucherJson); return(method.Invoke(instance, obj).ToString()); } catch (Exception ex) { LogNet.LogInfo("CreateInterface:" + ex.InnerException + ex.Message); jsonModel.payload.std_data.execution.code = "1"; jsonModel.payload.std_data.execution.description = "调用ERP接口异常:" + ex.InnerException + ex.Message; return(JSONUtil.JSONHelper.ObjectToJson <JsonModel>(jsonModel)); } }
//protected override void OnStart(string[] args) public void OnStart() { StopSync = false; server = WCF.GetWCF(); syncReceiptTimeFile = Path.Combine(basePath, syncReceiptFileName); syncDeliveryTimeFile = Path.Combine(basePath, syncDeliveryFileName); syncBaseTimeFile = Path.Combine(basePath, syncBaseFileName); syncQualityStatuceTimeFile = Path.Combine(basePath, synQualityStatuceFileName); int FirstSyncTime = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["FirstSyncTime"]); //同步时间文件不存在,自动创建 createSyncTimeFile(syncReceiptTimeFile, FirstSyncTime); createSyncTimeFile(syncDeliveryTimeFile, FirstSyncTime); createSyncTimeFile(syncBaseTimeFile, FirstSyncTime); createSyncTimeFile(syncQualityStatuceTimeFile, FirstSyncTime); LogNet.LogInfo("Server Start:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); //DocumentSyncReceipt = new Thread(new ThreadStart(SyncReceipt)); //DocumentSyncReceipt.Start(); //DocumentSyncDelivery = new Thread(new ThreadStart(SyncDelivery)); //DocumentSyncDelivery.Start(); DocumentSyncBase = new Thread(new ThreadStart(SyncBase)); DocumentSyncBase.Start(); //QualitySyncStatus = new Thread(new ThreadStart(QualityStatus)); //QualitySyncStatus.Start(); }
/// <summary> /// 根据选择的任务号ID获取上架任务明细 /// </summary> /// <param name="ModelDetailJson"></param> /// <returns></returns> public string GetT_InTaskDetailListByHeaderIDADF(string ModelDetailJson) { T_InTaskDetails_Func tfunc = new T_InTaskDetails_Func(); LogNet.LogInfo("上架获取明细:" + ModelDetailJson); return(tfunc.GetModelListByHeaderIDADF(ModelDetailJson)); }
//三级查询 public string GetInfoListThree(string id, string StrongHoldCode, string DeparMentNo) { LogNet.LogInfo("三级查询:" + id + "D:" + DeparMentNo); T_Material_Batch_Func tfunc = new T_Material_Batch_Func(); return(tfunc.GetInfoListThree(id, StrongHoldCode, DeparMentNo)); }
public string SaveT_BarcodeADF(string BarcodeJson) { LogNet.LogInfo("U9调用BarcodeJson:" + BarcodeJson); LogNet.LogInfo("-----------------------------------------------------"); T_Product_Func tfunc = new T_Product_Func(); return(tfunc.SaveT_BarcodeADF(BarcodeJson)); }
/// <summary> /// 获取入库单据,构造状态1 /// </summary> /// <param name="UserJosn"></param> /// <param name="ModelJson"></param> /// <returns></returns> public string GetT_InStockListADF(string UserJson, string ModelJson) { LogNet.LogInfo("收货模块UserJson:" + UserJson); LogNet.LogInfo("收货模块ModelJson:" + ModelJson); LogNet.LogInfo("-----------------------------------------------------"); T_InStock_Func tfunc = new T_InStock_Func(); return(tfunc.GetModelListADF(UserJson, ModelJson)); }
//完工提交 public string SaveT_ProDuctListADF(string UserJson, string ModelJson, string Guid) { LogNet.LogInfo("完工提交UserJson:" + UserJson); LogNet.LogInfo("完工提交ModelJson:" + ModelJson); LogNet.LogInfo("-----------------------------------------------------"); T_Product_Func tfunc = new T_Product_Func(); return(tfunc.SaveModelListSqlToDBADF(UserJson, ModelJson, Guid)); }
//获取生产订单 public string GetT_ProDuctListADF(string UserJson, string ModelJson) { LogNet.LogInfo("获取生产订单UserJson:" + UserJson); LogNet.LogInfo("获取生产订单ModelJson:" + ModelJson); LogNet.LogInfo("-----------------------------------------------------"); T_Product_Func tfunc = new T_Product_Func(); return(tfunc.GetModelList(UserJson, ModelJson)); }
//关联提交 public string SaveT_ProDuctBarcodeADF(string UserJson, string ModelJson, string PrintIP, string outbarcode) { LogNet.LogInfo("关联提交UserJson:" + UserJson); LogNet.LogInfo("关联提交ModelJson:" + ModelJson); LogNet.LogInfo("-----------------------------------------------------"); T_Product_Func tfunc = new T_Product_Func(); return(tfunc.SaveT_ProDuctBarcodeADF(UserJson, ModelJson, PrintIP, outbarcode)); }
public string PostZh(string UserJson, string ModelJson, string Guid) { LogNet.LogInfo("提交转换单UserJson:" + UserJson); LogNet.LogInfo("提交转换单ModelJson:" + ModelJson); LogNet.LogInfo("提交转换单Guid:" + Guid); LogNet.LogInfo("-----------------------------------------------------"); T_Material_Batch_Func tfunc = new T_Material_Batch_Func(); return(tfunc.PostZh(UserJson, ModelJson, Guid)); }
public string PostZhMove(string UserJson, string List, string Order, string Type, string Guid) { LogNet.LogInfo("提交转换单移库UserJson:" + UserJson); LogNet.LogInfo("提交转换单移库List:" + List); LogNet.LogInfo("提交转换单移库Order:" + Order); LogNet.LogInfo("提交转换单移库Type:" + Type); LogNet.LogInfo("-----------------------------------------------------"); T_Material_Batch_Func tfunc = new T_Material_Batch_Func(); return(tfunc.PostZhMove(UserJson, List, Order, Type, Guid)); }
public string PostCheck(string Json) { JsonModel jsonModel = new JsonModel(); jsonModel.payload = new PayLoad(); jsonModel.payload.std_data = new Std(); jsonModel.payload.std_data.execution = new Exe(); try { List <T_InterfaceInfo> lstModel = GetInterface("8887"); if (lstModel == null || lstModel.Count == 0) { //jsonModel.payload.std_data.execution.code = "1"; //jsonModel.payload.std_data.execution.description = "没有配置获取数据二开接口!"; jsonModel.result = "0"; jsonModel.resultValue = "没有配置获取数据二开接口!"; return(JSONUtil.JSONHelper.ObjectToJson <JsonModel>(jsonModel)); } T_InterfaceInfo model = lstModel.Find(t => t.Function == "3"); if (model == null) { jsonModel.result = "0"; jsonModel.resultValue = "没有配置获取数据二开接口!"; return(JSONUtil.JSONHelper.ObjectToJson <JsonModel>(jsonModel)); } JsonModel jsonModel1 = new JsonModel(); jsonModel1.payload = new PayLoad(); jsonModel1.payload.std_data = new Std(); jsonModel1.payload.std_data.execution = new Exe(); LogNet.LogInfo("VoucherJson:" + Json); var assembly = Assembly.LoadFile(@model.Route); var type = assembly.GetType(model.ClassName); var instance = assembly.CreateInstance(model.ClassName); object[] obj = new object[1]; obj[0] = Json; var method = type.GetMethod(model.FunctionName); LogNet.LogInfo("---------------------调用ERP接口:" + model.ClassName + model.FunctionName + "参数:" + Json); return(method.Invoke(instance, obj).ToString()); } catch (Exception ex) { //jsonModel.payload.std_data.execution.code = "1"; //jsonModel.payload.std_data.execution.description = ex.Message; jsonModel.result = "0"; jsonModel.resultValue = ex.Message; return(JSONUtil.JSONHelper.ObjectToJson <JsonModel>(jsonModel)); } }
/// <summary> /// PDA提交JSON转换成List对象 /// </summary> /// <param name="ModelListJson"></param> /// <returns></returns> protected override List <T_InStockDetailInfo> GetModelListByJson(string UserJson, string 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]); modelList.ForEach(t => t.IsQuality = IsQuality); //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.ToErpWarehouse = user.ReceiveWareHouseNo; item.ToErpAreaNo = string.Empty; item.ToBatchNo = item.BatchNo; item.PostUser = user.UserNo; item.StrEDate = item.lstBarCode.FirstOrDefault().EDate.ToString("yyyy/MM/dd"); } //item..PostDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd")); } LogNet.LogInfo("SaveT_InStockDetailADF---" + JSONHelper.ObjectToJson <List <T_InStockDetailInfo> >(modelList)); return(modelList); }
public void OnStop() { StopSync = true; //while (true) //{ // if (DocumentSyncReceipt != null && DocumentSyncReceipt.ThreadState != System.Threading.ThreadState.Running) // { // DocumentSyncReceipt.Abort(); // DocumentSyncReceipt = null; // break; // } // Thread.Sleep(500); //} //while (true) //{ // if (DocumentSyncDelivery != null && DocumentSyncDelivery.ThreadState != System.Threading.ThreadState.Running) // { // DocumentSyncDelivery.Abort(); // DocumentSyncDelivery = null; // break; // } // Thread.Sleep(500); //} //while (true) //{ // if (QualitySyncStatus != null && QualitySyncStatus.ThreadState != System.Threading.ThreadState.Running) // { // QualitySyncStatus.Abort(); // QualitySyncStatus = null; // break; // } // Thread.Sleep(500); //} while (true) { //if (DocumentSyncBase != null && DocumentSyncBase.ThreadState != System.Threading.ThreadState.Running) //{ DocumentSyncBase.Abort(); DocumentSyncBase = null; break; // } Thread.Sleep(500); } LogNet.LogInfo("Server Stop:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); }
public bool PostCheckToTrans(List <T_TransportSupDetailInfo> modelList, ref string strError) { try { BaseMessage_Model <List <T_TransportSupDetailInfo> > model = new BaseMessage_Model <List <T_TransportSupDetailInfo> >(); bool bSucc = false; string strUserNo = string.Empty; string strPostUser = string.Empty; string StrongHoldCode = string.Empty; if (modelList[0].ErpVoucherNo.Contains("HH2")) { modelList.ForEach(t => t.gtype = "C"); } else { modelList.ForEach(t => t.gtype = "A"); } StrongHoldCode = modelList[0].ErpVoucherNo.Substring(0, 3); modelList.ForEach(t => t.VoucherType = 9992); modelList.ForEach(t => t.StrongHoldCode = StrongHoldCode); T_Interface_Func tfunc = new T_Interface_Func(); string ERPJson = BILBasic.JSONUtil.JSONHelper.ObjectToJson <List <T_TransportSupDetailInfo> >(modelList); string interfaceJson = tfunc.PostModelListToInterface(ERPJson); model = BILBasic.JSONUtil.JSONHelper.JsonToObject <BaseMessage_Model <List <T_TransportSupDetailInfo> > >(interfaceJson); LogNet.LogInfo("ERPJsonAfter:" + BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <List <T_TransportSupDetailInfo> > >(model)); //过账失败直接返回 if (model.HeaderStatus == "E" && !string.IsNullOrEmpty(model.Message)) { strError = "回传T100费用失败!" + model.Message; bSucc = false; } else if (model.HeaderStatus == "S" && !string.IsNullOrEmpty(model.MaterialDoc)) //过账成功,并且生成了凭证要记录数据库 { strError = "回传T100费用成功!凭证号:" + model.MaterialDoc; bSucc = true; } return(bSucc); } catch (Exception ex) { strError = ex.Message; return(false); } }
protected override List <T_OutStockTaskDetailsInfo> GetModelListByJson(string UserJson, string ModelListJson) { UserModel userModel = JSONHelper.JsonToObject <UserModel>(UserJson); List <T_OutStockTaskDetailsInfo> NewModelList = new List <T_OutStockTaskDetailsInfo>(); List <T_OutStockTaskDetailsInfo> modelList = new List <T_OutStockTaskDetailsInfo>(); modelList = JSONHelper.JsonToObject <List <T_OutStockTaskDetailsInfo> >(ModelListJson); modelList = modelList.Where(t => t.ScanQty > 0).ToList(); modelList.ForEach(t => t.VoucherType = 9996); LogNet.LogInfo("SaveT_OutStockTaskDetailADF---" + JSONHelper.ObjectToJson <List <T_OutStockTaskDetailsInfo> >(modelList)); //modelList.ForEach(t => t.PostUser = userModel.UserNo); //modelList.ForEach(t => t.ToErpAreaNo = userModel.PickAreaNo); //modelList.ForEach(t => t.ToErpWarehouse = userModel.PickWareHouseNo); return(modelList); }
/// <summary> ///质检同步 /// </summary> void QualityStatus() { int SyncQualityStatusTime = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["QualitySyncStatus"]) * 1000; while (!StopSync) { try { string lastQualityStatusTime = string.Empty; //初始时间 if (File.Exists(syncBaseTimeFile)) { using (StreamReader sr = new StreamReader(syncQualityStatuceTimeFile)) { lastQualityStatusTime = sr.ReadLine(); //最后执行日期 sr.Close(); } } LogNet.LogInfo("同步质检数据开始:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); string errMsg = ""; List <T_QualityInfo> modelList = new List <T_QualityInfo>(); string strError = String.Empty; bool result = server.GetT_AllQualityList(ref modelList, ref strError); if (result && modelList.Count != 0) { foreach (T_QualityInfo model in modelList) { result = server.UpdateStockByQuality(model.ErpVoucherNo, ref errMsg); errMsg += result ? model.ErpVoucherNo + "\r\n" : "|"; } } LogNet.LogInfo("同步质检数据结束:" + result + "\r\n" + strError + "\r\n" + errMsg + "\r\n同步时间:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); if (result) { using (StreamWriter sw = new StreamWriter(syncBaseTimeFile)) { sw.WriteLine(DateTime.Now.ToString("yyyy-MM-dd")); sw.Close(); } } } catch (Exception ex) { LogNet.LogInfo("同步质检数据错误:" + ex.Message + "\t同步时间:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); } Thread.Sleep(SyncQualityStatusTime); } }
public bool PostCloseOutStockVoucherNo(List <T_OutStockInfo> modelList, ref string strError) { try { BaseMessage_Model <List <T_OutStockInfo> > model = new BaseMessage_Model <List <T_OutStockInfo> >(); bool bSucc = false; //string strUserNo = string.Empty; //string strPostUser = string.Empty; //string StrongHoldCode = string.Empty; //StrongHoldCode = modelList[0].ErpVoucherNo.Substring(0, 3); //modelList.ForEach(t => t.VoucherType = 50); //modelList.ForEach(t => t.WmsStatus = "E"); //modelList.ForEach(t => t.StrongHoldCode = StrongHoldCode); T_Interface_Func tfunc = new T_Interface_Func(); string ERPJson = BILBasic.JSONUtil.JSONHelper.ObjectToJson <List <T_OutStockInfo> >(modelList); LogNet.LogInfo("closeJSON:" + ERPJson); string interfaceJson = tfunc.PostModelListToInterface(ERPJson); model = BILBasic.JSONUtil.JSONHelper.JsonToObject <BaseMessage_Model <List <T_OutStockInfo> > >(interfaceJson); LogNet.LogInfo("ERPJsonAfter:" + BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <List <T_OutStockInfo> > >(model)); //过账失败直接返回 if (model.HeaderStatus == "E" && !string.IsNullOrEmpty(model.Message)) { strError = "回传T100关闭状态失败!" + model.Message; bSucc = false; } else if (model.HeaderStatus == "S" && !string.IsNullOrEmpty(model.MaterialDoc)) //过账成功,并且生成了凭证要记录数据库 { strError = "回传T100关闭状态成功!凭证号:" + model.MaterialDoc; bSucc = true; } return(bSucc); } catch (Exception ex) { strError = ex.Message; return(false); } }
public string DelStockForU9(string ErpVoucherNo, string ErpVoucherNoIn, string Guid) { LogNet.LogInfo("ErpVoucherNo:" + ErpVoucherNo + ",ErpVoucherNoIn:" + ErpVoucherNoIn + ",Guid:" + Guid); BaseMessage_Model <string> messageModel = new BaseMessage_Model <string>(); try { string strError = string.Empty; if (string.IsNullOrEmpty(ErpVoucherNo) || string.IsNullOrEmpty(Guid) || string.IsNullOrEmpty(ErpVoucherNoIn)) { messageModel.HeaderStatus = "E"; messageModel.Message = "成品入库单,调入单和Guid不能为空!"; return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <string> >(messageModel)); } if (!CheckGuid(Guid, ref strError)) { messageModel.HeaderStatus = "E"; messageModel.Message = "GUID已经存在,不能重复提交-" + strError; return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <string> >(messageModel)); } T_OutTaskDetails_DB _db = new T_OutTaskDetails_DB(); if (_db.DelStockForU9(ErpVoucherNo, ErpVoucherNoIn, ref strError) == false) { messageModel.HeaderStatus = "E"; messageModel.Message = strError; return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <string> >(messageModel)); } else { messageModel.HeaderStatus = "S"; messageModel.Message = "操作成功!"; return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <string> >(messageModel)); } } catch (Exception ex) { messageModel.HeaderStatus = "E"; messageModel.Message = ex.Message; return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <string> >(messageModel)); } }
/// <summary> /// 发货数据同步 /// </summary> void SyncDelivery() { int SyncDeliverytTime = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["SyncDeliverytTime"]) * 1000; while (!StopSync) { try { string lastSyncDeliveryTime = string.Empty; //初始时间 if (File.Exists(syncDeliveryTimeFile)) { using (StreamReader sr = new StreamReader(syncDeliveryTimeFile)) { lastSyncDeliveryTime = sr.ReadLine(); //最后执行日期 sr.Close(); } } LogNet.LogInfo("同步发货数据开始:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); string errMsg = ""; bool result = server.DocumentSyncDelivery("", String.Empty, ref errMsg, 22, "ERP", -1, null); LogNet.LogInfo("同步发货数据结束:" + result + "\r\n" + errMsg + "\r\n同步时间:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); if (result) { using (StreamWriter sw = new StreamWriter(syncDeliveryTimeFile)) { sw.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); sw.Close(); } } Thread.Sleep(SyncDeliverytTime); } catch (Exception ex) { LogNet.LogInfo("同步发货数据错误:" + ex.Message + "\t同步时间:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); Thread.Sleep(SyncDeliverytTime); } } }
//public override List<T_OutStockTaskDetailsInfo> GetModelListByHeaderID(int headerID) //{ // try // { // string strError = string.Empty; // List<T_StockInfo> lstStock = new List<T_StockInfo>(); // List<T_OutStockTaskDetailsInfo> list = base.GetModelListByHeaderID(headerID); // if (list == null || list.Count == 0) // { // return null; // } // if (GetPickRuleAreaNo(list, ref lstStock, ref strError) == false) // { // throw new Exception(strError); // } // //if (lstStock == null || lstStock.Count == 0) // //{ // // throw new Exception("获取物料对应拣货库位为空!"); // //} // return CreateNewListByPickRuleAreaNo(list, lstStock); // } // catch (Exception ex) // { // throw new Exception(ex.Message); // } //} public bool GetPickRuleAreaNo(List <T_OutStockTaskDetailsInfo> modelList, ref List <T_StockInfo> stockList, ref string strError) { try { int iResult = 0; DataSet ds; string strOutStockTaskXml = XmlUtil.Serializer(typeof(List <T_OutStockTaskDetailsInfo>), modelList); LogNet.LogInfo("GetPickRuleAreaNo:" + strOutStockTaskXml); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter("strOutStockTaskXml", OracleDbType.NClob), new OracleParameter("PickAreaCur", OracleDbType.RefCursor, ParameterDirection.Output), new OracleParameter("bResult", OracleDbType.Int32, ParameterDirection.Output), new OracleParameter("ErrString", OracleDbType.NVarchar2, 200, strError, ParameterDirection.Output) }; cmdParms[0].Value = strOutStockTaskXml; cmdParms[1].Value = ParameterDirection.Output; cmdParms[2].Value = ParameterDirection.Output; cmdParms[3].Value = ParameterDirection.Output; ds = dbFactory.ExecuteDataSetForCursor(ref iResult, ref strError, dbFactory.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "p_getpickarea", cmdParms); if (iResult == 1) { stockList = TOOL.DataTableToList.DataSetToList <T_StockInfo>(ds.Tables[0]); strError = string.Empty; } return(iResult == 1 ? true : false); } catch (Exception ex) { throw ex; } }
public string SaveT_BarcodeADF(string BarcodeJson) { LogNet.LogInfo("U9生成条码类BarcodeJson:" + BarcodeJson); BaseMessage_Model <string> messageModel = new BaseMessage_Model <string>(); try { if (string.IsNullOrEmpty(BarcodeJson)) { messageModel.HeaderStatus = "E"; messageModel.Message = "传入参数不能为空!"; return(JsonConvert.SerializeObject(messageModel)); } List <Barcode_Model> BarcodeModel = JSONHelper.JsonToObject <List <Barcode_Model> >(BarcodeJson); T_Product_DB ProductDB = new T_Product_DB(); string strMsg = ""; if (ProductDB.SaveBarcode(BarcodeModel, ref strMsg)) { messageModel.HeaderStatus = "S"; messageModel.Message = "打印成功"; return(JsonConvert.SerializeObject(messageModel)); } else { messageModel.HeaderStatus = "E"; messageModel.Message = "数据插入失败!" + strMsg; return(JsonConvert.SerializeObject(messageModel)); } } catch (Exception ex) { messageModel.HeaderStatus = "E"; messageModel.Message = ex.ToString(); return(JsonConvert.SerializeObject(messageModel)); } }
public string SaveModelListSqlToDBADF(User.UserModel user, List <TBase_Model> modelList) { BaseMessage_Model <List <TBase_Model> > model = new BaseMessage_Model <List <TBase_Model> >(); try { bool bSucc = false; string strError = ""; if (user == null) { model.HeaderStatus = "E"; model.Message = "传入用户信息为空!"; JsonConvert.SerializeObject(model); } if (CheckModelBeforeSave(modelList, ref strError) == false) { model.HeaderStatus = "E"; model.Message = strError; JsonConvert.SerializeObject(model); } T_Interface_Func tfunc = new T_Interface_Func(); string ERPJson = GetModelListByJsonToERP(user, modelList);//JSONUtil.JSONHelper.ObjectToJson<List<TBase_Model>>(modelList); LogNet.LogInfo("ERPJsonBefore:" + ERPJson); string interfaceJson = tfunc.PostModelListToInterface(ERPJson); LogNet.LogInfo("YMH00000000ERP:" + interfaceJson); model = JSONUtil.JSONHelper.JsonToObject <BaseMessage_Model <List <TBase_Model> > >(interfaceJson); LogNet.LogInfo("ERPJsonAfter:" + JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <List <TBase_Model> > >(model)); //过账失败直接返回 if (model.HeaderStatus == "E" && !string.IsNullOrEmpty(model.Message)) { return(interfaceJson); } else if (model.HeaderStatus == "S" && !string.IsNullOrEmpty(model.MaterialDoc)) //过账成功,并且生成了凭证要记录数据库 { modelList.ForEach(t => t.MaterialDoc = model.MaterialDoc); } //LogNet.LogInfo("ERPJson:" + JSONUtil.JSONHelper.ObjectToJson<List<TBase_Model>>(modelList)); bSucc = db.SaveModelListBySqlToDB(user, ref modelList, ref strError); if (bSucc == false) { model.HeaderStatus = "E"; model.Message = strError; } else { model.HeaderStatus = "S"; model.TaskNo = modelList[0].TaskNo; model.Message = GetSuccessMessage(model.MaterialDoc, modelList[0].TaskNo); } return(JsonConvert.SerializeObject(model)); } catch (Exception ex) { model.HeaderStatus = "E"; model.Message = "保存" + GetModelChineseName() + "失败!" + ex.Message + ex.TargetSite; return(JsonConvert.SerializeObject(model)); } }
public string UserLoginADF(string UserJson) { BaseMessage_Model <UserInfo> messageModel = new BaseMessage_Model <UserInfo>(); try { UserInfo model; User_DB _db = new User_DB(); DateTime CurrentTime; LogNet.LogInfo("UserLoginADF---" + UserJson); UserInfo user = BILBasic.JSONUtil.JSONHelper.JsonToObject <UserInfo>(UserJson); //UserInfo user = JsonConvert.DeserializeObject<UserInfo>(UserJson); model = _db.GetModelBySql(user); if (model == null) { int iSucc = _db.GetScalarBySql(user); if (iSucc <= 0) { messageModel.Message = "该用户不存在,请检查大小写是否输入正确!"; messageModel.HeaderStatus = "E"; return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <UserInfo> >(messageModel)); } else { messageModel.Message = "密码输入错误,忘记密码请联系管理员重置!"; messageModel.HeaderStatus = "E"; return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <UserInfo> >(messageModel)); } } CurrentTime = model.CurrentTime; if (user.WarehouseID != -100) { if (!model.WarehouseCode.Contains(user.WarehouseID.ToString())) { messageModel.Message = "登录账户与所选仓库不一致!"; messageModel.HeaderStatus = "E"; return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <UserInfo> >(messageModel)); } } if (model.UserStatus == 2) { messageModel.Message = string.Format("用户【{0}】已停用", model.UserName); messageModel.HeaderStatus = "E"; return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <UserInfo> >(messageModel)); } if (model.IsDel == 2) { messageModel.Message = string.Format("用户【{0}】已删除", model.UserName); messageModel.HeaderStatus = "E"; return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <UserInfo> >(messageModel)); } model.WarehouseID = user.WarehouseID; user = model; T_UserGroup_Func ugf = new T_UserGroup_Func(); List <T_UserGroupInfo> lstGroup = new List <T_UserGroupInfo>(); if (ugf.GetModelListBySql(user, ref lstGroup)) { user.lstUserGroup = lstGroup; } //暂时屏蔽 T_MENU_Func tmfun = new T_MENU_Func(); List <T_MenuInfo> lstMenu = new List <T_MenuInfo>(); if (tmfun.GetModelListBySql(user, ref lstMenu, false)) { user.lstMenu = lstMenu.Where(t => t.MenuType == 4).ToList(); } //根据用户配置的仓库ID,获取对应的收货,发货库位 T_Area_Func tafun = new T_Area_Func(); List <T_AreaInfo> lstArea = new List <T_AreaInfo>(); if (tafun.GetModelListBySql(user.WarehouseID, ref lstArea)) { T_AreaInfo areaInfo = new T_AreaInfo(); //查找收货待检库位 areaInfo = lstArea.Find(t => t.AreaType == 2); if (areaInfo != null) { user.ReceiveHouseID = areaInfo.HouseID; user.ReceiveAreaID = areaInfo.ID; user.ReceiveAreaNo = areaInfo.AreaNo; user.ReceiveWareHouseNo = areaInfo.WarehouseNo; user.ReceiveHouseNo = areaInfo.HouseNo; user.ReceiveWareHouseName = areaInfo.WarehouseName; user.QuanUserNo = areaInfo.QuanUserNo; user.QuanUserName = areaInfo.QuanUserName; //user.lstQuanUser = _db.GetQuanUser(user.QuanUserNo); } //查找拣货临时库位 areaInfo = lstArea.Find(t => t.AreaType == 3); if (areaInfo != null) { user.PickHouseID = areaInfo.HouseID; user.PickAreaID = areaInfo.ID; user.PickWareHouseID = areaInfo.WarehouseID; user.PickAreaNo = areaInfo.AreaNo; user.PickWareHouseNo = areaInfo.WarehouseNo; user.PickHouseNo = areaInfo.HouseNo; user.PickWareHouseName = areaInfo.WarehouseName; } areaInfo = lstArea.Find(t => t.AreaType == 4); if (areaInfo != null) { user.ToSampWareHouseNo = areaInfo.WarehouseNo; user.ToSampAreaNo = areaInfo.AreaNo; } } //T_WareHouse_Func twfun = new T_WareHouse_Func(); //List<T_WareHouseInfo> lstWarehouse = new List<T_WareHouseInfo>(); //if (twfun.GetModelListBySql(user, ref lstWarehouse)) //{ // user.lstWarehouse = lstWarehouse; //} messageModel.Message = "登录成功!"; messageModel.HeaderStatus = "S"; messageModel.ModelJson = user; return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <UserInfo> >(messageModel)); //return JsonConvert.SerializeObject(messageModel); } catch (Exception ex) { messageModel.Message = ex.Message; messageModel.HeaderStatus = "E"; return(BILBasic.JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <UserInfo> >(messageModel)); } }