public string Create(UserAccount ua)
{
try
{
User loginUser = Session[SessionList.FamilyManageUser.ToString()] as User;
ua.UserID = loginUser.ID;
ua.ctypeName = WebComm.GetAccountListByXml().Where(c => c.TypeID == int.Parse(Request.Form["ctypeID"])).SingleOrDefault().TypeName;
db.UserAccounts.Add(ua);
db.SaveChanges();
return WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "添加成功", "UserAccountList", "", CallBackType.none, "");
}
catch (Exception ex)
{
return WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "添加失败！" + ex.Message, "", "", CallBackType.none, "");
}
}
public ActionResult List(UserAccount ua)
{
int pageNO = 1;
if (Request.Form["pageNum"] != null)
{
int.TryParse(Request.Form["pageNum"], out pageNO);
}
BindComboxUser();
BindAccountType();
List<UserAccount> list = GetUserAccountList(pageNO, ua);
return View(viewFolder + "List.cshtml", list);
}
/// <summary>
/// 获取用户账号列表
/// </summary>
/// <param name="currentPage">当前页码</param>
/// <param name="uBank">查询实体</param>
/// <returns></returns>
private List<UserAccount> GetUserAccountList(int currentPage, UserAccount uAccount)
{
var ubList = db.UserAccounts.AsQueryable();
User loginUser = Session[SessionList.FamilyManageUser.ToString()] as User;
//区分用户加载数据，如果不是超级管理员，只能查看自己的数据
if (!UserPower.adminUserCode.Contains(loginUser.cUserCode))
{
ubList = ubList.Where(ub => ub.UserID == loginUser.ID);
}
if (uAccount != null && uAccount.UserID > 0)
{
ubList = ubList.Where(c => c.UserID == uAccount.UserID);
}
if (uAccount != null && uAccount.ctypeID > 0)
{
ubList = ubList.Where(c => c.ctypeID == uAccount.ctypeID);
}
if (uAccount != null && !string.IsNullOrEmpty(uAccount.cname))
{
ubList = ubList.Where(c => c.cname.Contains(uAccount.cname));
}
SetPagerOptions(ubList.Count(), currentPage);
List<UserAccount> list = ubList.OrderBy(b => b.ID).Skip((currentPage - 1) * pageSize).Take(pageSize).ToList();
return list;
}
public string Edit(UserAccount ua)
{
try
{
User loginUser = Session[SessionList.FamilyManageUser.ToString()] as User;
ua.ctypeName = WebComm.GetAccountListByXml().Where(c => c.TypeID == int.Parse(Request.Form["ctypeID"])).SingleOrDefault().TypeName;
db.Entry(ua).State = EntityState.Modified;
db.SaveChanges();
return WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "修改成功", "UserAccountList", "", CallBackType.none, "");
}
catch (Exception ex)
{
return WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "修改失败" + ex.Message, "", "", CallBackType.none, "");
}
}