/// <summary> /// 更改数据字典状态 /// </summary> /// <param name="id"></param> /// <returns></returns> public OpResult ChangeStatus(int id) { var result = OpResult.Fail("状态变更失败"); try { var model = _dal.GetById(id); var model1 = model; model1.Status = !model.Status; _dal.UpdateStatus(model1); var logMsg = LogEngine.CompareModelToLog <SysDataDictionary>(Pharos.Sys.LogModule.数据字典, model, model1); logEngine.WriteInsert(logMsg, Pharos.Sys.LogModule.数据字典); result = OpResult.Success("数据保存成功"); if (result.Successed) { Pharos.Infrastructure.Data.Redis.RedisManager.Publish("SyncDatabase", new Pharos.ObjectModels.DTOs.DatabaseChanged() { CompanyId = Sys.SysCommonRules.CompanyId, StoreId = "-1", Target = "SysDataDictionary" }); } } catch (Exception e) { result = OpResult.Fail("状态变更失败" + e.Message); } return(result); }
public ActionResult AddBrand(ProductBrand obj) { var re = new OpResult(); obj.CompanyId = CommonService.CompanyId; if (ProductBrandService.IsExist(o => o.CompanyId == obj.CompanyId && o.Title == obj.Title && o.Id != obj.Id)) { re.Message = "已存在该名称"; } else if (obj.Id == 0) { obj.BrandSN = ProductBrandService.MaxSN; obj.State = 1; re = ProductBrandService.Add(obj); #region 操作日志 try { var logMsg = LogEngine.CompareModelToLog <ProductBrand>(LogModule.品牌管理, obj); logEngine.WriteInsert(logMsg, LogModule.品牌管理); } catch { } #endregion } else { var supp = ProductBrandService.FindById(obj.Id); obj.ToCopyProperty(supp); re = ProductBrandService.Update(supp); #region 操作日志 try { var logMsg = LogEngine.CompareModelToLog <ProductBrand>(LogModule.品牌管理, obj, supp); logEngine.WriteUpdate(logMsg, LogModule.品牌管理); } catch { } #endregion } return(Content(re.ToJson())); }
public OpResult Import(ImportSet obj, System.Web.HttpFileCollectionBase httpFiles, string fieldName, string columnName) { var op = new OpResult(); var errLs = new List <string>(); int count = 0; try { Dictionary <string, char> fieldCols = null; DataTable dt = null; op = ImportSetService.ImportSet(obj, httpFiles, fieldName, columnName, ref fieldCols, ref dt); if (!op.Successed) { return(op); } var brandClass = DataDictRepository.GetQuery(o => o.DicPSN == 5).ToList(); var otherClass = brandClass.FirstOrDefault(o => o.Title.StartsWith("其")); var brands = GetList(); var clsIdx = Convert.ToInt32(fieldCols["ClassifyId"]) - 65; var titleIdx = Convert.ToInt32(fieldCols["Title"]) - 65; count = dt.Rows.Count; var max = DataDictRepository.GetQuery().Max(o => o.DicSN); for (int i = dt.Rows.Count - 1; i >= 0; i--) { try { var dr = dt.Rows[i]; var text = dr[clsIdx].ToString(); if (text.IsNullOrEmpty()) { continue; } var cls = brandClass.FirstOrDefault(o => o.Title == text); if (cls != null) { dr[clsIdx] = cls.DicSN.ToString(); } else { if (obj.RefCreate) { var data = new SysDataDictionary { DicPSN = 5, Status = true, Title = text, DicSN = max++, CreateDT = DateTime.Now, CreateUID = CurrentUser.UID }; DataDictRepository.Add(data); brandClass.Add(data); dr[clsIdx] = data.DicSN.ToString(); } else if (otherClass != null) { dr[clsIdx] = otherClass.DicSN.ToString(); } else { errLs.Add("行业分类[" + text + "]不存在!"); dt.Rows.RemoveAt(i);//去除不导入 continue; } } text = dr[titleIdx].ToString().Trim(); if (brands.Any(o => o.Title == text)) { errLs.Add("品牌名称[" + text + "]已存在!"); dt.Rows.RemoveAt(i);//去除不导入 } else { brands.Add(new ProductBrand() { Title = text }); } } catch (Exception e) { throw new Exception("品牌分类处理失败!", e); } } var maxsn = BrandRepository.GetQuery().Max(o => (int?)o.BrandSN).GetValueOrDefault(); StringBuilder sb = new StringBuilder(); sb.Append("begin tran "); foreach (DataRow dr in dt.Rows) { sb.Append("insert into "); sb.Append(obj.TableName); sb.Append("(BrandSN,State,Source,"); sb.Append(string.Join(",", fieldCols.Keys)); sb.Append(") values("); sb.AppendFormat("{0},", ++maxsn); sb.AppendFormat("1,0,"); foreach (var de in fieldCols) { var index = Convert.ToInt32(de.Value) - 65; try { var text = dr[index].ToString(); sb.Append("'" + text + "',"); } catch (Exception e) { throw new Exception("列选择超过范围!", e); } } sb = sb.Remove(sb.Length - 1, 1); sb.Append(");"); } sb.Append(" commit tran"); if (dt.Rows.Count > 0) { op.Successed = new DBHelper().ExecuteNonQueryText(sb.ToString(), null) > 0; LogEngine.WriteInsert("品牌导入", LogModule.档案管理); } } catch (Exception ex) { op.Message = ex.Message; op.Successed = false; LogEngine.WriteError(ex); errLs.Add("导入出现异常!"); } return(CommonService.GenerateImportHtml(errLs, count)); }
public static OpResult SaveOrUpdate(Supplier obj) { var re = new OpResult(); if (!obj.MasterAccount.IsNullOrEmpty() && SupplierService.IsExist(o => o.Id != obj.Id && o.MasterAccount == obj.MasterAccount && o.BusinessType == 2 && o.CompanyId == CommonService.CompanyId)) { re.Message = "该账号已存在,请重新填写!"; } else if (!obj.Title.IsNullOrEmpty() && SupplierService.IsExist(o => o.Id != obj.Id && o.Title == obj.Title && o.BusinessType == 2 && o.CompanyId == CommonService.CompanyId)) { re.Message = "该简称已存在,请重新填写!"; } else if (!obj.FullTitle.IsNullOrEmpty() && SupplierService.IsExist(o => o.Id != obj.Id && o.FullTitle == obj.FullTitle && o.BusinessType == 2 && o.CompanyId == CommonService.CompanyId)) { re.Message = "该全称已存在,请重新填写!"; } else if (obj.Id.IsNullOrEmpty()) { obj.Id = Logic.CommonRules.GUID; obj.BusinessType = 2; obj.CompanyId = CommonService.CompanyId; re = SupplierService.Add(obj); #region 操作日志 try { LogEngine logEngine = new LogEngine(); var logMsg = LogEngine.CompareModelToLog <Supplier>(LogModule.批发商, obj); logEngine.WriteInsert(logMsg, LogModule.批发商); } catch { } #endregion } else { var supp = SupplierService.FindById(obj.Id); Supplier _oInfo = new Supplier(); if (supp != null) { ExtendHelper.CopyProperty <Supplier>(_oInfo, supp); } var exc = new List <string>(); if (obj.MasterPwd.IsNullOrEmpty()) { exc.Add("MasterPwd"); } exc.Add("CompanyId"); obj.BusinessType = supp.BusinessType; obj.ToCopyProperty(supp, exc); re = SupplierService.Update(supp); #region 操作日志 try { LogEngine logEngine = new LogEngine(); var logMsg = LogEngine.CompareModelToLog <Supplier>(LogModule.批发商, obj, _oInfo); logEngine.WriteUpdate(logMsg, LogModule.批发商); } catch { } #endregion } return(re); }