public ActionResult LevelSave(MemberLevel model)
{
MemberLevel memLevel = (from u in dbEntity.MemberLevels
where u.Deleted==false&&u.OrgID == gLevelOrgId && u.Code == model.Code
select u).SingleOrDefault();
if (memLevel == null)
{
memLevel = new MemberLevel();
memLevel.Name = new GeneralResource(ModelEnum.ResourceType.STRING, model.Name);
dbEntity.MemberLevels.Add(memLevel);
}
else
{
memLevel.Name.SetResource(ModelEnum.ResourceType.STRING, model.Name);
}
memLevel.Code = model.Code;
memLevel.OrgID = gLevelOrgId;
memLevel.Mlevel = model.Mlevel;
memLevel.Discount = model.Discount;
dbEntity.SaveChanges();
return View("LevelEdit");
}
/// <summary>
/// 导入用户级别
/// </summary>
/// <param name="sExcelFile">Excel文件名</param>
/// <param name="sSheetName">Sheet名</param>
public void ImportUserLevel(string sExcelFile, string sSheetName)
{
try
{
ExcelData oExcel = new ExcelData(sExcelFile, sSheetName);
DataColumn colOrgan = oExcel.ExcelTable.Columns["组织"];
DataColumn colCode = oExcel.ExcelTable.Columns["代码"];
DataColumn colNameCN = oExcel.ExcelTable.Columns["中文名称"];
DataColumn colNameUS = oExcel.ExcelTable.Columns["英文名称"];
DataColumn colLevel = oExcel.ExcelTable.Columns["级别"];
DataColumn colDiscount = oExcel.ExcelTable.Columns["折扣"];
DataColumn colRemark = oExcel.ExcelTable.Columns["备注"];
foreach (DataRow row in oExcel.ExcelTable.Rows)
{
string sOrgan = row[colOrgan].ToString();
var oOrgan = (from o in dbEntity.MemberOrganizations
where o.Code == sOrgan && o.Otype == (byte)ModelEnum.OrganizationType.CORPORATION
select o).FirstOrDefault();
string sCode = row[colCode].ToString();
GeneralResource oName = new GeneralResource(ModelEnum.ResourceType.STRING, 2052, row[colNameCN].ToString(), 1033, row[colNameUS].ToString());
byte nLevel;
Byte.TryParse(row[colLevel].ToString(), out nLevel);
decimal mDiscount = 1;
Decimal.TryParse(row[colDiscount].ToString(), out mDiscount);
string sRemark = row[colRemark].ToString();
var oLevel = (from l in dbEntity.MemberLevels
where l.OrgID == oOrgan.Gid && l.Code == sCode
select l).FirstOrDefault();
if (oLevel == null)
{
oLevel = new MemberLevel { Code = sCode };
dbEntity.MemberLevels.Add(oLevel);
}
oLevel.Organization = oOrgan;
if (oLevel.Name == null)
oLevel.Name = oName;
else
oLevel.Name.SetResource(ModelEnum.ResourceType.STRING, oName);
oLevel.Mlevel = nLevel;
oLevel.Discount = mDiscount;
oLevel.Remark = sRemark;
dbEntity.SaveChanges();
if (Utility.ConfigHelper.GlobalConst.IsDebug)
Debug.WriteLine("{0} {1} {2}", this.ToString(), sCode, sRemark);
}
oEventBLL.WriteEvent(String.Format("导入MemberLevel成功: {0} {1}", sExcelFile, sSheetName),
ModelEnum.ActionLevel.GENERIC, ModelEnum.ActionSource.SYSTEM, this.ToString());
}
catch (Exception ex)
{
oEventBLL.WriteEvent(String.Format("导入MemberLevel错误: {0} {1} {2}", sExcelFile, sSheetName, ex.Message),
ModelEnum.ActionLevel.ERROR, ModelEnum.ActionSource.SYSTEM, this.ToString());
}
}
public ActionResult LevelAdd()
{
MemberLevel memLevel = new MemberLevel { Name = NewResource(ModelEnum.ResourceType.STRING, OrgID) };
ViewBag.exist = 0;
return View("LevelEdit", memLevel);
}