public string GetModelListByHeaderIDADF(int headerID) { BaseMessage_Model <List <TBase_Model> > messageModel = new BaseMessage_Model <List <TBase_Model> >(); try { List <TBase_Model> modelList = db.GetModelListByHeaderID(headerID); if (modelList == null || modelList.Count == 0) { messageModel.HeaderStatus = "E"; messageModel.Message = "获取" + GetModelChineseName() + "数据列表为空!"; } else { messageModel.HeaderStatus = "S"; messageModel.ModelJson = modelList; } return(JsonConvert.SerializeObject(messageModel)); } catch (Exception ex) { messageModel.HeaderStatus = "E"; messageModel.Message = ex.Message; messageModel.ModelJson = null; return(JsonConvert.SerializeObject(messageModel)); } }
public string GetModelListByHeaderIDADF(string ModelDetailJson) { BaseMessage_Model <List <TBase_Model> > messageModel = new BaseMessage_Model <List <TBase_Model> >(); try { if (string.IsNullOrEmpty(ModelDetailJson)) { messageModel.HeaderStatus = "E"; messageModel.Message = "业务JSON为空!"; return(JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <List <TBase_Model> > >(messageModel)); } TBase_Model model = GetModelByJson(ModelDetailJson); List <TBase_Model> modelList = db.GetModelListByHeaderID(model.HeaderID); if (modelList == null || modelList.Count == 0) { messageModel.HeaderStatus = "E"; messageModel.Message = "获取" + GetModelChineseName() + "数据列表为空!"; } else { messageModel.HeaderStatus = "S"; messageModel.ModelJson = modelList; } return(JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <List <TBase_Model> > >(messageModel)); } catch (Exception ex) { messageModel.HeaderStatus = "E"; messageModel.Message = ex.Message; messageModel.ModelJson = null; return(JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <List <TBase_Model> > >(messageModel)); } }
public string UpdateModelListSqlToDBADF(string UserJson, string ModelJson) { BaseMessage_Model <List <TBase_Model> > model = new BaseMessage_Model <List <TBase_Model> >(); try { bool bSucc = false; string strError = ""; if (string.IsNullOrEmpty(UserJson)) { model.HeaderStatus = "E"; model.Message = "传入用户信息为空!"; return(JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <List <TBase_Model> > >(model)); } User.UserModel user = JSONUtil.JSONHelper.JsonToObject <User.UserModel>(UserJson); List <TBase_Model> modelList = GetModelListByJson(UserJson, ModelJson); bSucc = db.UpdateModelListBySqlToDB(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(JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <List <TBase_Model> > >(model)); } catch (Exception ex) { model.HeaderStatus = "E"; model.Message = "更新" + GetModelChineseName() + "失败!" + ex.Message + ex.TargetSite; return(JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <List <TBase_Model> > >(model)); } }
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 SaveModelListSqlToDBADF(string UserJson, string ModeJson, string Guid = "", string strPost = "") { BaseMessage_Model <List <TBase_Model> > model = new BaseMessage_Model <List <TBase_Model> >(); try { string strError = ""; if (Guid != "") { if (!CheckGuid(Guid, ref strError)) { model.HeaderStatus = "E"; model.Message = "GUID已经存在,不能重复提交-" + strError; return(JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <List <TBase_Model> > >(model)); } } bool bSucc = false; if (string.IsNullOrEmpty(UserJson)) { model.HeaderStatus = "E"; model.Message = "传入用户信息为空!"; return(JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <List <TBase_Model> > >(model)); } User.UserModel user = JSONUtil.JSONHelper.JsonToObject <User.UserModel>(UserJson); user.GUID = Guid; List <TBase_Model> modelList = GetModelListByJson(UserJson, ModeJson); if (strPost != "复核") { if (CheckModelBeforeSave(modelList, ref strError) == false) { model.HeaderStatus = "E"; model.Message = strError; return(JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <List <TBase_Model> > >(model)); } } //是否过账 if (string.IsNullOrEmpty(strPost) || (strPost == "下架" && (modelList[0].VoucherType == 31 || modelList[0].VoucherType == 53)) || strPost == "复核") { T_Interface_Func tfunc = new T_Interface_Func(); string ERPJson = GetModelListByJsonToERP(user, modelList, strPost);//JSONUtil.JSONHelper.ObjectToJson<List<TBase_Model>>(modelList); //LogNet.LogInfo("-----------------------ERPJsonBefore:" + ERPJson); string interfaceJson = tfunc.PostModelListToInterface(ERPJson); 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); } } //modelList.ForEach(t => t.MaterialDoc = "Wgr0401210221054"); //LogNet.LogInfo("ERPJson:" + JSONUtil.JSONHelper.ObjectToJson<List<TBase_Model>>(modelList)); //LogNet.LogInfo("------------------------ymh:ERPtoWMS-" + JSONUtil.JSONHelper.ObjectToJson<List<TBase_Model>>(modelList)); bSucc = db.SaveModelListBySqlToDB(user, ref modelList, ref strError, strPost); if (bSucc == false) { model.HeaderStatus = "E"; model.Message = strError; //LogInfo.ErrorLog("------------------WMS失败:单号:【"+ modelList[0].ErpVoucherNo==null?"":modelList[0].ErpVoucherNo + "】错误信息:"+ strError); LogNet.LogInfo("------------------ymh:WMS-失败:单号:【" + modelList[0].ErpVoucherNo == null ? "" : modelList[0].ErpVoucherNo + "】错误信息:" + strError); } else { model.HeaderStatus = "S"; model.TaskNo = modelList[0].TaskNo; model.Message = GetSuccessMessage(model.MaterialDoc, modelList[0].TaskNo); LogNet.LogInfo("-----------------ymh:WMS-成功:单号:【" + modelList[0].ErpVoucherNo == null ? "" : modelList[0].ErpVoucherNo + "】"); } return(JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <List <TBase_Model> > >(model)); } catch (Exception ex) { //LogInfo.ErrorLog("------------------WMS失败:错误信息:" + ex.ToString()); LogNet.LogInfo("------------------ymh:WMS-失败:错误信息:" + ex.ToString()); model.HeaderStatus = "E"; model.Message = "保存" + GetModelChineseName() + "失败!" + ex.Message + ex.TargetSite; return(JSONUtil.JSONHelper.ObjectToJson <BaseMessage_Model <List <TBase_Model> > >(model)); } }
public string GetModelListADF(User.UserModel user, TBase_Model baseModel) { BaseMessage_Model <List <TBase_Model> > messageModel = new BaseMessage_Model <List <TBase_Model> >(); try { string strError = string.Empty; List <TBase_Model> modelList = new List <TBase_Model>(); if (user == null) { messageModel.HeaderStatus = "E"; messageModel.Message = "用户对象为空!"; //return JSONUtil.JSONHelper.ObjectToJson<BaseMessage_Model<List<TBase_Model>>>(messageModel); return(JsonConvert.SerializeObject(messageModel)); } if (baseModel == null) { messageModel.HeaderStatus = "E"; messageModel.Message = "业务对象为空!"; //return JSONUtil.JSONHelper.ObjectToJson<BaseMessage_Model<List<TBase_Model>>>(messageModel); return(JsonConvert.SerializeObject(messageModel)); } //TBase_Model model = GetModelByJson(ModelJson); if (!string.IsNullOrEmpty(baseModel.ErpVoucherNo)) { //请求ERP数据 if (Sync(baseModel, ref strError) == false) { messageModel.HeaderStatus = "E"; messageModel.Message = "获取" + GetModelChineseName() + "ERP数据失败!" + strError; //return JSONUtil.JSONHelper.ObjectToJson<BaseMessage_Model<List<TBase_Model>>>(messageModel); return(JsonConvert.SerializeObject(messageModel)); } } modelList = db.GetModelListADF(user, baseModel); if (modelList == null || modelList.Count == 0) { messageModel.HeaderStatus = "E"; messageModel.Message = "获取" + GetModelChineseName() + "数据列表为空!"; } else { messageModel.HeaderStatus = "S"; messageModel.ModelJson = modelList; } //return JSONUtil.JSONHelper.ObjectToJson<BaseMessage_Model<List<TBase_Model>>>(messageModel); return(JsonConvert.SerializeObject(messageModel)); } catch (Exception ex) { messageModel.HeaderStatus = "E"; messageModel.Message = ex.Message; messageModel.ModelJson = null; //return JSONUtil.JSONHelper.ObjectToJson<BaseMessage_Model<List<TBase_Model>>>(messageModel); return(JsonConvert.SerializeObject(messageModel)); } }