public ActionResult Edit(Tb_Gys model) { var oldParam = new Hashtable(); BaseResult br = new BaseResult(); Hashtable param = base.GetParameters(); Hashtable param_model = null; ParamVessel pv = new ParamVessel(); pv.Add("mc", string.Empty, HandleType.ReturnMsg); pv.Add("bm", string.Empty, HandleType.DefaultValue); pv.Add("flag_state", string.Empty, HandleType.ReturnMsg); pv.Add("id", string.Empty, HandleType.ReturnMsg); try { param_model = param.Trim(pv); oldParam = (Hashtable)param_model.Clone(); model.id_masteruser = id_user_master; model.id_edit = id_user; br = BusinessFactory.Tb_Gys.Update(model); } catch (Exception ex) { br.Message.Add(ex.Message); } WriteDBLog("供应商-编辑", oldParam, br); return(JsonString(br, 1)); }
/// <summary> /// 获取查询条件参数(采购商/客户角色) /// </summary> /// <param name="param"></param> /// <param name="flag">0 获取分页总条数的参数 1获取分页数据源参数</param> /// <returns></returns> private Hashtable Get_cgsPageParam(Hashtable param, int flag) { //当选择供应商过滤时 if (param.ContainsKey("id_gys") && long.Parse(param["id_gys"].ToString()) != 0) { BaseResult br = new BaseResult(); param.Add("id", param["id_gys"]); //根据供应商ID获取供应商对象 br = BusinessFactory.Supplier.Get(param); if (br.Data == null) { br.Success = false; br.Message.Add(string.Format("不存在该供应商或供应商资料有误,请检查后重试!")); return(null); } Tb_Gys gys = (Tb_Gys)br.Data; if (flag == 1) { param.Add("id_userAndMaster", ""); } param.Add("id_user_master", (long)gys.id_user_master); param.Remove("id_gys"); param.Remove("id"); } if (flag == 0) { param.Add("fatherId", 0); param.Add("id_user", GetLoginInfo <long>("id_user")); } param.Add("isKeFu", 1); return(param); }
///// <summary> ///// 添加关注 ///// cxb ///// 2015-4-13 ///// </summary> ///// <param name="entity"></param> ///// <returns></returns> //public override BaseResult Add(dynamic entity) //{ // BaseResult br = new BaseResult(); // Tb_Gys_Cgs gyscgs = (Tb_Gys_Cgs)entity; // DAL.Add(gyscgs); // br.Success = true; // br.Message.Add(String.Format("取消关注[{1}]。信息:供应商流水号:{0}, 供应商名称:{1}", gyscgs.id_gys, gyscgs.alias_gys)); // return br; //} /// <summary> /// 取消关注 /// lxt /// 2015-02-28 /// </summary> public override BaseResult Delete(Hashtable param) { BaseResult br = new BaseResult(); long id = TypeConvert.ToInt64(param["id"], 0); long id_user_master_cgs = TypeConvert.ToInt64(param["id_user_master_cgs"], 0); long id_user = TypeConvert.ToInt64(param["id_user"], 0); string flag_from = TypeConvert.ToString(param["flag_from"], "pc"); param.Clear(); param.Add("id", id); Tb_Gys gys = DAL.GetItem <Tb_Gys>(gysType, param); if (gys == null) { br.Success = false; br.Message.Add("取消关注失败,该供应商不存在或资料已缺失!"); br.Level = ErrorLevel.Warning; return(br); } param.Clear(); param.Add("id_user_master_gys", gys.id_user_master); param.Add("id_user_master_cgs", id_user_master_cgs); Tb_Gys_Cgs gysCgs = DAL.GetItem <Tb_Gys_Cgs>(typeof(Tb_Gys_Cgs), param); if (gysCgs == null) { br.Success = true; return(br); } param.Clear(); param.Add("id_user_master_gys", gys.id_user_master); param.Add("id_user_master_cgs", id_user_master_cgs); param.Add("new_flag_stop", YesNoFlag.Yes); DAL.UpdatePart(typeof(Tb_Gys_Cgs), param); param.Clear(); param.Add("id_gys", gysCgs.id_gys); param.Add("id_cgs", gysCgs.id_cgs); //成功后删除申请记录 DAL.Delete(typeof(Tb_Gys_Cgs_Check), param); //记录供采关系日志 var Loggcgx = new Tb_Gys_Cgs_Log(); Loggcgx.id_cgs = gysCgs.id_gys.Value; Loggcgx.id_gys = gysCgs.id_cgs.Value; Loggcgx.id_user = id_user; Loggcgx.flag_state = Gys_Cgs_Status.CallBack; Loggcgx.flag_form = flag_from; Loggcgx.contents = string.Format("[{0}]撤销对[{1}]的关注.", gysCgs.mc_cgs, gysCgs.mc_gys); DAL.Add(Loggcgx); br.Success = true; br.Message.Add(string.Format("[{0}]撤销对[{1}]的关注.", gysCgs.mc_cgs, gysCgs.mc_gys)); return(br); }
public ActionResult Add(Tb_Gys model) { #region 获取参数 var oldParam = new Hashtable(); Hashtable param = base.GetParameters(); param.Add("id_masteruser", id_user_master); Hashtable param_model = null; BaseResult br = new BaseResult(); Tb_Gys model_gys = new Tb_Gys(); #endregion #region 执行操作 try { ParamVessel pv = new ParamVessel(); pv.Add("mc", string.Empty, HandleType.ReturnMsg); pv.Add("bm", string.Empty, HandleType.DefaultValue); pv.Add("flag_state", string.Empty, HandleType.ReturnMsg); pv.Add("id_masteruser", string.Empty, HandleType.ReturnMsg); param_model = param.Trim(pv); oldParam = (Hashtable)param_model.Clone(); if (TryUpdateModel(model_gys)) { model_gys.mc = param_model["mc"].ToString(); model_gys.bm = param_model["bm"].ToString(); model_gys.flag_state = byte.Parse(param_model["flag_state"].ToString()); model_gys.id_masteruser = id_user_master; model.id_create = id_user; br = BusinessFactory.Tb_Gys.Add(model_gys); } else { br.Message.Add("参数有误!"); } } catch (Exception ex) { br.Message.Add(ex.Message); } #endregion WriteDBLog("供应商-新增", oldParam, br); return(JsonString(br, 1)); }
private bool CheckParam(BaseResult result, Tb_Gys dwModel, string addOrUpdate = "") { result = result ?? new BaseResult(); if (dwModel == null) { result.Success = false; result.Message.Add("参数有误!"); return(false); } if (string.IsNullOrEmpty(dwModel.id_masteruser)) { result.Success = false; result.Message.Add("请登录!"); return(false); } //if (string.IsNullOrEmpty(dwModel.bm)) //{ // result.Success = false; // result.Message.Add("请输入编码!"); // return false; //} Hashtable ht = new Hashtable(); ht.Add("id_masteruser", dwModel.id_masteruser); ht.Add("dw", dwModel.bm); ht.Add("flag_delete", (int)Enums.FlagDelete.NoDelete); if (addOrUpdate == "update") { if (string.IsNullOrEmpty(dwModel.id)) { result.Success = false; result.Message.Add("参数有误!"); return(false); } } if (DAL.GetCount(typeof(Tb_Gys), ht) > 0) { result.Success = false; result.Message.Add("输入单位已存在!"); return(false); } return(true); }
public ActionResult Supplier(string obj) { BaseResult br = new BaseResult(); Hashtable param = JSON.Deserialize <Hashtable>(obj); try { //根据供应商获取反馈信息 if (param.ContainsKey("id_gys") && int.Parse(param["id_gys"].ToString()) != 0) { param.Add("id", param["id_gys"]); param.Remove("id_gys"); br = BusinessFactory.Supplier.Get(param); if (br.Data == null) { br.Success = false; br.Message.Add(string.Format("不存在该供应商或供应商资料有误,请检查后重试!")); return(null); } Tb_Gys gys = (Tb_Gys)br.Data; param.Add("id_user_master", (long)gys.id_user_master); param.Remove("id"); } ParamVessel p = new ParamVessel(); p.Add("pageIndex", (long)1, HandleType.DefaultValue); p.Add("id_user_master", string.Empty, HandleType.Remove); p.Add("flag_state", string.Empty, HandleType.Remove); param = param.Trim(p); param.Add("isKeFu", 1);//过滤客服数据 param.Add("fatherId", 0); param.Add("id_user", GetLoginInfo <long>("id_user")); } catch (CySoftException ex) { throw ex; } catch (Exception ex) { throw ex; } return(Json(GetPageData(param))); }
public override BaseResult Add(dynamic entity) { #region 验证参数 BaseResult result = new BaseResult() { Success = true }; Tb_Gys gysModel = entity as Tb_Gys; if (gysModel == null) { result.Success = false; result.Message.Add("参数有误!"); return(result); } if (string.IsNullOrEmpty(gysModel.mc)) { result.Success = false; result.Message.Add("名称不允许为空!"); return(result); } //if (string.IsNullOrEmpty(gysModel.bm)) //{ // result.Success = false; // result.Message.Add("编码不允许为空!"); // return result; //} #endregion #region 验证是否重复 Hashtable ht = new Hashtable(); ht.Add("id_masteruser", gysModel.id_masteruser); ht.Add("mc", gysModel.mc); ht.Add("flag_delete", (int)Enums.FlagDelete.NoDelete); if (DAL.GetCount(typeof(Tb_Gys), ht) > 0) { result.Success = false; result.Message.Add("输入名称已存在!"); return(result); } //ht.Clear(); //ht.Add("id_masteruser", gysModel.id_masteruser); //ht.Add("bm", gysModel.bm); //ht.Add("flag_delete", (int)Enums.FlagDelete.NoDelete); //if (DAL.GetCount(typeof(Tb_Gys), ht) > 0) //{ // result.Success = false; // result.Message.Add("输入编码已存在!"); // return result; //} #endregion #region 执行操作 try { gysModel.id = Guid.NewGuid().ToString(); gysModel.flag_delete = (int)Enums.FlagDelete.NoDelete; gysModel.rq_create = DateTime.Now; gysModel.zjm = CySoft.Frame.Utility.MnemonicCode.chinesecap(gysModel.mc); DAL.Add(gysModel); } catch (Exception ex) { result.Success = false; result.Message.Add("新增操作异常!"); } #endregion return(result); }
public override BaseResult Init(Hashtable param) { #region 获取数据 BaseResult br = new BaseResult(); Hashtable ht = new Hashtable(); string FilePath = param["filePath"].ToString(); string id_masteruser = param["id_masteruser"].ToString(); string id_user = param["id_user"].ToString(); string id_shop = param["id_shop"].ToString(); List <Tb_Gys_Import> list = (List <Tb_Gys_Import>)param["list"]; List <Tb_Gys_Import> successList = new List <Tb_Gys_Import>(); List <Tb_Gys_Import> failList = new List <Tb_Gys_Import>(); List <Tb_Gys> addGYSList = new List <Tb_Gys>(); List <Tb_Gysfl> addGYSFLList = new List <Tb_Gysfl>(); #endregion #region 获取供应商分类List ht.Clear(); ht.Add("id_masteruser", param["id_masteruser"].ToString()); ht.Add("flag_delete", (int)Enums.FlagDelete.NoDelete); var gysflList = DAL.QueryList <Tb_Gysfl>(typeof(Tb_Gysfl), ht); #endregion #region 获取所有供应商 ht.Clear(); ht.Add("id_masteruser", param["id_masteruser"].ToString()); ht.Add("flag_delete", (int)Enums.FlagDelete.NoDelete); var allGysList = DAL.QueryList <Tb_Gys_User_QueryModel>(typeof(Tb_Gys), ht); #endregion #region 数据处理 foreach (var item in list) { br = this.CheckImportInfo(item); if (!br.Success) { item.bz_sys = br.Message.Count > 0 ? br.Message[0].ToString() : "数据不符合要求"; failList.Add(item); } else { #region 验证数据 if (list.Where(d => d.mc == item.mc).Count() >= 2) { item.bz_sys = String.Format("导入数据 名称:{0}重复!", item.mc); failList.Add(item); continue; } //if (list.Where(d => d.bm == item.bm).Count() >= 2) //{ // item.bz_sys = String.Format("导入数据 编码:{0}重复!", item.bm); // failList.Add(item); // continue; //} if (allGysList.Where(d => d.mc == item.mc).Count() > 0) { item.bz_sys = String.Format("导入数据 名称:{0} 已被占用!", item.mc); failList.Add(item); continue; } //if (allGysList.Where(d => d.bm == item.bm).Count() > 0) //{ // item.bz_sys = String.Format("导入数据 编码:{0} 已被占用!", item.bm); // failList.Add(item); // continue; //} #endregion #region 供应商分类 如果不存在 则添加一条 string idgysfl = Guid.NewGuid().ToString(); if (!string.IsNullOrEmpty(item.id_gysfl) && gysflList != null && gysflList.Where(d => d.mc == item.id_gysfl && d.flag_delete == 0).Count() > 0) { idgysfl = gysflList.Where(d => d.mc == item.id_gysfl && d.flag_delete == 0).FirstOrDefault().id; } else { Tb_Gysfl gysflModel = new Tb_Gysfl() { id_masteruser = id_masteruser, id = idgysfl, bm = DateTime.Now.ToString("yyyyMMddHHmmss"), mc = item.id_gysfl, path = "0/" + idgysfl, id_farther = "0", id_create = id_user, rq_create = DateTime.Now, id_edit = id_user, rq_edit = DateTime.Now, flag_delete = 0, sort_id = 0 }; gysflList.Add(gysflModel); addGYSFLList.Add(gysflModel); } #endregion #region 供应商model Tb_Gys model = new Tb_Gys() { id = GetGuid, id_masteruser = id_masteruser, bm = item.bm, mc = item.mc, id_gysfl = idgysfl, companytel = item.companytel, zjm = CySoft.Utility.PinYin.GetChineseSpell(item.mc), tel = item.tel, lxr = item.lxr, email = item.email, zipcode = item.zipcode, address = item.address, flag_state = byte.Parse(item.flag_state), bz = item.bz, id_create = id_user, rq_create = DateTime.Now, id_edit = id_user, rq_edit = DateTime.Now, flag_delete = 0 }; addGYSList.Add(model); #endregion successList.Add(item); } } #endregion #region 保存供应商相关信息 DAL.AddRange(addGYSList); DAL.AddRange(addGYSFLList); #endregion br.Message.Add(String.Format("导入供应商成功!")); br.Success = true; br.Data = new Tb_Gys_Import_All() { SuccessList = successList, FailList = failList }; return(br); }
public override BaseResult Update(dynamic entity) { #region 验证参数 BaseResult result = new BaseResult() { Success = true }; Tb_Gys gysModel = entity as Tb_Gys; if (gysModel == null || string.IsNullOrEmpty(gysModel.id)) { result.Success = false; result.Message.Add("参数有误!"); return(result); } if (string.IsNullOrEmpty(gysModel.mc)) { result.Success = false; result.Message.Add("名称不允许为空!"); return(result); } //if (string.IsNullOrEmpty(gysModel.bm)) //{ // result.Success = false; // result.Message.Add("编码不允许为空!"); // return result; //} #endregion #region 验证是否重复 Hashtable ht = new Hashtable(); ht.Add("id_masteruser", gysModel.id_masteruser); ht.Add("mc", gysModel.mc); ht.Add("flag_delete", (int)Enums.FlagDelete.NoDelete); ht.Add("not_id", gysModel.id); if (DAL.GetCount(typeof(Tb_Gys), ht) > 0) { result.Success = false; result.Message.Add("输入名称已存在!"); return(result); } //ht.Clear(); //ht.Add("id_masteruser", gysModel.id_masteruser); //ht.Add("bm", gysModel.bm); //ht.Add("flag_delete", (int)Enums.FlagDelete.NoDelete); //ht.Add("not_id", gysModel.id); //if (DAL.GetCount(typeof(Tb_Gys), ht) > 0) //{ // result.Success = false; // result.Message.Add("输入编码已存在!"); // return result; //} #endregion #region 更新操作 ht.Clear(); ht.Add("id", gysModel.id); ht.Add("id_masteruser", gysModel.id_masteruser); ht.Add("new_bm", gysModel.bm); ht.Add("new_mc", gysModel.mc); ht.Add("new_lxr", gysModel.lxr); ht.Add("new_flag_state", gysModel.flag_state); ht.Add("new_tel", gysModel.tel); ht.Add("new_companytel", gysModel.companytel); ht.Add("new_email", gysModel.email); ht.Add("new_zipcode", gysModel.zipcode); ht.Add("new_address", gysModel.address); ht.Add("new_bz", gysModel.bz); ht.Add("new_rq_edit", DateTime.Now); ht.Add("new_id_edit", gysModel.id_edit); ht.Add("new_id_gysfl", gysModel.id_gysfl); try { DAL.UpdatePart(typeof(Tb_Gys), ht); } catch (Exception ex) { result.Success = false; result.Message.Add("更新操作异常!"); } #endregion return(result); }
public ActionResult AddToSupplier(string obj) { BaseResult br = new BaseResult(); Hashtable param = JSON.Deserialize <Hashtable>(obj); Faq model = new Faq(); if (String.IsNullOrEmpty(param["contents"].ToString())) { br.Message.Add(string.Format("反馈内容不允许为空!")); br.Success = false; return(Json(br)); } else if (param["contents"].ToString().Length > 2000) { br.Success = false; br.Message.Add(string.Format("提交内容请限定在2000个字内!")); return(Json(br)); } model.contents = param["contents"].ToString(); param.Remove("contents"); bool b = false; long fatherId = 0; long id_gys = 0; //判断是否为继续反馈 if (param.ContainsKey("contain")) { ParamVessel p = new ParamVessel(); b = true; fatherId = long.Parse(param["fatherId"].ToString()); p.Add("fatherId", 0, HandleType.ReturnMsg); p.Add("id_user_master", 0, HandleType.ReturnMsg); param = param.Trim(p); model.fatherId = fatherId; model.id_user_master = long.Parse(param["id_user_master"].ToString()); param.Remove("contain"); } else { id_gys = long.Parse(param["id"].ToString()); //根据供应商ID获取供应商对象 br = BusinessFactory.Supplier.Get(param); if (br.Data == null) { br.Success = false; br.Message.Add(string.Format("不存在该供应商或供应商资料有误,请检查后重试!")); return(Json(br)); } Tb_Gys gys = (Tb_Gys)br.Data; model.flag_state = 0; model.fatherId = 0; model.id_user_master = gys.id_user_master; param.Remove("id"); } try { model.id = BusinessFactory.Utilety.GetNextKey(typeof(Faq)); model.id_user = GetLoginInfo <long>("id_user"); model.id_user_receive = 0; model.flag_delete = 0; // 0 未删除 model.flag_from = "android"; br = BusinessFactory.Faq.Add(model); //当继续提交反馈成功后修改主问题Id状态为0 if (!br.Success) { return(Json(br)); } if (br.Success && b) { br = UpdateFaqState(fatherId, 0); } return(Json(br)); } catch (CySoftException ex) { throw ex; } catch (Exception ex) { throw ex; } }