/// <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);
}
