public ActionResult GetInputMode()
{
StringBuilder sb = new StringBuilder();
List<ListItem> list = new GeneralOptional().InputModeList;
foreach (ListItem InputMode in list)
sb.Append(InputMode.Value + ":" + InputMode.Text + ";");
return Json(sb.ToString(), JsonRequestBehavior.AllowGet);
}
/// <summary>
/// 测试OrderAttribute
/// </summary>
/// <returns>新建的OrderAttribute对象</returns>
public OrderAttribute OrderAttributeTest()
{
MemberOrganization oOrg = new MemberOrganization
{
Code = GetRandCode()
};
oLiveEntities.MemberOrganizations.Add(oOrg);
MemberChannel oChannel = new MemberChannel
{
Code = GetRandCode()
};
oLiveEntities.MemberChannels.Add(oChannel);
GeneralResource oGeneralResource = new GeneralResource { };
MemberRole oRole = new MemberRole
{
Organization = oOrg,
Code = GetRandCode(),
Name = oGeneralResource
};
oLiveEntities.MemberRoles.Add(oRole);
MemberUser oUser = new MemberUser
{
Organization = oOrg,
Role = oRole,
Channel = oChannel,
LoginName = GetRandCode(),
Passcode = GetRandCode(),
SaltKey = "88888888"
};
oLiveEntities.MemberUsers.Add(oUser);
OrderInformation oOrderInformation = new OrderInformation
{
Organization = oOrg,
Channel = oChannel,
User = oUser,
Code = GetRandCode()
};
oLiveEntities.OrderInformations.Add(oOrderInformation);
GeneralOptional oOptional = new GeneralOptional
{
Organization = oOrg,
Code = GetRandCode()
};
oLiveEntities.GeneralOptionals.Add(oOptional);
OrderAttribute oAttribute = new OrderAttribute
{
Order = oOrderInformation,
Optional = oOptional
};
oLiveEntities.OrderAttributes.Add(oAttribute);
oLiveEntities.SaveChanges();
return oAttribute;
}
static Guid? orgId; //组织ID;
#endregion Fields
#region Methods
public ActionResult AddNewOptional()
{
ViewBag.optionalTypeList = getOptionalTypeSelectlist();
ViewBag.optionalInputMode = getInputModeSelectlist();
ViewBag.OrgSelectList = GetOrganizationList();
ViewBag.otitle = LiveAzure.Resource.Stage.OptionalController.AddOptional;
Guid orgGid = GetOrganization();
GeneralOptional oOptional = new GeneralOptional
{
Name = NewResource(ModelEnum.ResourceType.STRING, orgGid)
};
return PartialView(oOptional);
}
/// <summary>
/// 获取属性输入模式下拉框列表
/// </summary>
/// <returns></returns>
public List<SelectListItem> getInputModeSelectlist()
{
List<ListItem> inputModeList = new GeneralOptional().InputModeList;
List<SelectListItem> oInputModeList = new List<SelectListItem>();
foreach (ListItem item in inputModeList)
{
oInputModeList.Add(new SelectListItem { Value = item.Value, Text = item.Text });
}
return oInputModeList;
}
/// <summary>
/// 更新Optional
/// </summary>
/// <returns></returns>
public void SaveOptional(GeneralOptional newOptional)
{
GeneralOptional oldOptional = dbEntity.GeneralOptionals.Include("Name").Where(g => g.Gid == newOptional.Gid).Single();
oldOptional.Otype = newOptional.Otype;
oldOptional.Code = newOptional.Code;
oldOptional.RefID = newOptional.RefID;
oldOptional.Sorting = newOptional.Sorting;
oldOptional.Name.SetResource(ModelEnum.ResourceType.STRING, newOptional.Name);
oldOptional.InputMode = newOptional.InputMode;
oldOptional.Remark = newOptional.Remark;
if (ModelState.IsValid)
{
dbEntity.Entry(oldOptional).State = EntityState.Modified;
dbEntity.SaveChanges();
}
}
/// <summary>
/// 保存添加的属性
/// </summary>
/// <param name="optional">页面传回的GeneralOptional对象</param>
/// <returns>Optional/SetOptionalItems</returns>
public void SaveNewOptional(GeneralOptional optional)
{
try
{
GeneralOptional oOptional = new GeneralOptional
{
RefID = optional.RefID,
Otype = optional.Otype,
Code = optional.Code,
Sorting = optional.Sorting,
Name = new GeneralResource(ModelEnum.ResourceType.STRING, optional.Name),
InputMode = optional.InputMode,
OrgID = optional.OrgID,
Remark = optional.Remark
};
dbEntity.GeneralOptionals.Add(oOptional);
dbEntity.SaveChanges();
}
catch (Exception ex)
{
RedirectToAction("ErrorPage", "Home", new { message = ex.Message });
}
}
/// <summary>
/// 获取属性类型下拉框列表
/// </summary>
/// <returns></returns>
public List<SelectListItem> getOptionalTypeSelectlist()
{
List<ListItem> oTypelist = new GeneralOptional().OptionalTypeList;
List<SelectListItem> oTypeSelectlist=new List<SelectListItem>();
foreach (ListItem item in oTypelist)
{
oTypeSelectlist.Add(new SelectListItem { Value = item.Value, Text = item.Text });
}
return oTypeSelectlist;
}
/// <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());
}
}
public ActionResult Index(GeneralOptional optional)
{
optionals = optional;
dbEntity.GeneralOptionals.Add(optional);
dbEntity.SaveChanges();
if (optional.InputMode == (byte)ModelEnum.OptionalInputMode.COMBOBOX)
{
return RedirectToAction("SetOptionalItems", "Optional");
}
else
{
return RedirectToAction("Index","Home");
}
}
/// <summary>
/// 编辑属性页
/// </summary>
/// <returns></returns>
public ActionResult Index()
{
//从session里读出用户名，查出其所属组织
string loginName = "admin";
MemberUser user = dbEntity.MemberUsers.Where(u => u.LoginName == loginName).Single();
//调用方法生成页面所需的下拉框列表
ViewBag.optionalList = getOptionalTypeSelectlist();
ViewBag.optionalInputMode = getInputModeSelectlist();
//新建GeneralOptional对象，将其所属组织赋值
GeneralOptional optional = new GeneralOptional
{
OrgID = user.OrgID
};
return View(optional);
}
