public ActionResult AddOptionalItem(Guid optGid)
{
Guid orgGid = GetOrganization();
GeneralOptItem oOptionalItem = new GeneralOptItem
{
OptID = optGid,
Name = NewResource(ModelEnum.ResourceType.STRING, orgGid)
};
optid = optGid;
GeneralOptional oOptional = dbEntity.GeneralOptionals.Where(o => o.Gid == optGid).Single();
ViewBag.optionalName = oOptional.Name.GetResource(CurrentSession.Culture);
return View(oOptionalItem);
}
/// <summary>
/// 保存属性选项
/// </summary>
/// <returns>选项列表</returns>
public void SaveOptionalItem(GeneralOptItem OptionalItem)
{
GeneralOptItem oOptionalItem = new GeneralOptItem
{
OptID = OptionalItem.OptID,
Code = OptionalItem.Code,
Sorting = OptionalItem.Sorting,
Name = new GeneralResource(ModelEnum.ResourceType.STRING, OptionalItem.Name),
Remark = OptionalItem.Remark
};
dbEntity.GeneralOptItems.Add(oOptionalItem);
dbEntity.SaveChanges();
}
public ActionResult SetOptionalItems(GeneralOptItem oOptionalItem)
{
//为oOptionalItem对象的主表字段赋值，值为Index方法中保存的GeneralOptional对象的Gid
oOptionalItem.OptID = optionals.Gid;
dbEntity.GeneralOptItems.Add(oOptionalItem);
dbEntity.SaveChanges();
return View();
}
/// <summary>
/// 导入属性定义
/// </summary>
/// <param name="sExcelFile">Excel文件名</param>
/// <param name="sSheetName">Sheet名</param>
public void ImportOptional(string sExcelFile, string sSheetName)
{
try
{
ExcelData oExcel = new ExcelData(sExcelFile, sSheetName);
DataColumn colOrgan = oExcel.ExcelTable.Columns["组织"];
DataColumn colType = oExcel.ExcelTable.Columns["用途"];
DataColumn colMainCode = oExcel.ExcelTable.Columns["属性代码"];
DataColumn colOptCode = oExcel.ExcelTable.Columns["选项代码"];
DataColumn colSorting = oExcel.ExcelTable.Columns["排序"];
DataColumn colNameCN = oExcel.ExcelTable.Columns["中文名称"];
DataColumn colNameUS = oExcel.ExcelTable.Columns["英文名称"];
DataColumn colMode = oExcel.ExcelTable.Columns["输入模式"];
DataColumn colRemark = oExcel.ExcelTable.Columns["备注"];
string sLastOrgCode = "";
MemberOrganization oOrgan = null;
GeneralOptional oOption = null;
foreach (DataRow row in oExcel.ExcelTable.Rows)
{
string sOrgCode = row[colOrgan].ToString();
byte nType;
Byte.TryParse(row[colType].ToString(), out nType);
string sMainCode = row[colMainCode].ToString();
string sOptCode = row[colOptCode].ToString();
int nSorting;
Int32.TryParse(row[colSorting].ToString(), out nSorting);
GeneralResource oName = new GeneralResource(ModelEnum.ResourceType.STRING, 2052, row[colNameCN].ToString(), 1033, row[colNameUS].ToString());
byte nMode;
Byte.TryParse(row[colMode].ToString(), out nMode);
string sRemark = row[colRemark].ToString();
if (!String.IsNullOrEmpty(sOrgCode) && (sOrgCode != sLastOrgCode))
{
oOrgan = (from o in dbEntity.MemberOrganizations
where o.Code == sOrgCode && o.Otype == (byte)ModelEnum.OrganizationType.CORPORATION
select o).FirstOrDefault();
sLastOrgCode = sOrgCode;
}
if (!String.IsNullOrEmpty(sMainCode))
{
oOption = (from o in dbEntity.GeneralOptionals
where o.OrgID == oOrgan.Gid && o.Code == sMainCode
select o).FirstOrDefault();
if (oOption == null)
{
oOption = new GeneralOptional { Organization = oOrgan, Code = sMainCode };
dbEntity.GeneralOptionals.Add(oOption);
}
oOption.Otype = nType;
oOption.Sorting = nSorting;
if (oOption.Name == null)
oOption.Name = oName;
else
oOption.Name.SetResource(ModelEnum.ResourceType.STRING, oName);
oOption.InputMode = nMode;
oOption.Remark = sRemark;
}
else
{
GeneralOptItem oOptItem = (from i in dbEntity.GeneralOptItems
where i.Deleted == false && i.OptID == oOption.Gid && i.Code == sOptCode
select i).FirstOrDefault();
if (oOptItem == null)
{
oOptItem = new GeneralOptItem { Optional = oOption, Code = sOptCode };
dbEntity.GeneralOptItems.Add(oOptItem);
}
oOptItem.Sorting = nSorting;
if (oOptItem.Name == null)
oOptItem.Name = oName;
else
oOptItem.Name.SetResource(ModelEnum.ResourceType.STRING, oName);
oOptItem.Remark = sRemark;
}
dbEntity.SaveChanges();
if (Utility.ConfigHelper.GlobalConst.IsDebug)
Debug.WriteLine("{0} {1} {2}", this.ToString(), sMainCode, sRemark);
}
oEventBLL.WriteEvent(String.Format("导入GeneralOptional成功: {0} {1}", sExcelFile, sSheetName),
ModelEnum.ActionLevel.GENERIC, ModelEnum.ActionSource.SYSTEM, this.ToString());
}
catch (Exception ex)
{
oEventBLL.WriteEvent(String.Format("导入GeneralOptional错误: {0} {1} {2}", sExcelFile, sSheetName, ex.Message),
ModelEnum.ActionLevel.ERROR, ModelEnum.ActionSource.SYSTEM, this.ToString());
}
}
/// <summary>
/// 删除选中的GeneralOptItem对象
/// </summary>
/// <param name="OptionalItempost"></param>
/// <returns></returns>
public ActionResult DeleteOptionalItem(GeneralOptItem OptionalItempost)
{
GeneralOptItem otherOptItem = dbEntity.GeneralOptItems.Where(g => g.Gid == OptionalItempost.Gid).Single();
otherOptItem.Deleted = true;
dbEntity.Entry(otherOptItem).State = EntityState.Modified;
dbEntity.SaveChanges();
return Json(GridResponse.CreateSuccess(), JsonRequestBehavior.AllowGet);
}