public JsonResult List(SysDictViewModel viewModel, PageInfo pageInfo)
{
QueryCollection queries = new QueryCollection();
if (!string.IsNullOrEmpty(viewModel.Name))
{
queries.Add(new Query {
Name = "Name", Operator = Query.Operators.Contains, Value = viewModel.Name
});
}
else if (!string.IsNullOrEmpty(viewModel.Code))
{
queries.Add(new Query {
Name = "Code", Operator = Query.Operators.Contains, Value = viewModel.Code
});
}
else if (viewModel.TypeId != 0)
{
queries.Add(new Query {
Name = "TypeId", Operator = Query.Operators.Equal, Value = viewModel.TypeId
});
}
var list = SysDictService.GetListByPage(queries.AsExpression <SysDict>(), x => true, pageInfo.Limit, pageInfo.Page, out int totalCount, true).Select(x => new
{
x.Id,
x.Name,
x.Code,
x.SortCode
}).ToList();
return(Json(Pager.Paging(list, totalCount), JsonRequestBehavior.AllowGet));
}
public ActionResult Delete(int id)
{
try
{
SysDictService.DeleteBy(x => x.Id == id);
return(WriteSuccess("数据删除成功"));
}
catch (Exception ex)
{
return(WriteError(ex));
}
}
public ActionResult BatchDel(string idsStr)
{
try
{
var idsArray = idsStr.Substring(0, idsStr.Length).Split(',');
int[] ids = Array.ConvertAll <string, int>(idsArray, int.Parse);
var result = SysDictService.DeleteBy(x => ids.Contains(x.Id)) > 0 ? WriteSuccess("数据删除成功") : WriteError("数据删除失败");
return(result);
}
catch (Exception ex)
{
return(WriteError(ex));
}
}
public ActionResult Edit(SysDictViewModel viewModel)
{
if (ModelState.IsValid == false)
{
return(WriteError("实体验证失败"));
}
viewModel.Id = viewModel.Id;
viewModel.UpdateTime = DateTime.Now;
viewModel.UpdateUserId = UserManager.GetCurrentUserInfo().Id;
SysDict entity = viewModel.EntityMap();
SysDictService.Update(entity, new string[] { "Name", "Code", "SortCode", "UpdateTime", "UpdateUserId" });
return(WriteSuccess());
}
/// <summary>
/// 查询列表（带分页）
/// </summary>
/// <param name="condition"></param>
/// <returns></returns>
public Response <List <DoctorMemberDTO> > GetList(DoctorMemberCondition condition)
{
using (var db = new DBEntities())
{
var query = from item in db.DoctorMembers
join doctor in db.Doctors on item.DoctorID equals doctor.DoctorID
join member in db.UserMembers on item.MemberID equals member.MemberID
//join map in db.UserMemberMaps on member.MemberID equals map.MemberID
//join user in db.Users on map.UserID equals user.UserID
orderby item.ModifyTime, item.CreateTime descending
where item.IsDeleted == false && member.IsDeleted == false &&
doctor.DoctorID == condition.UserID //&& map.IsDeleted == false
select new DoctorMemberDTO
{
DoctorMemberID = item.DoctorMemberID,
DoctorID = item.DoctorID,
MemberID = item.MemberID,
MemberName = member.MemberName,
Birthday = member.Birthday,
Gender = member.Gender,
Mobile = member.Mobile
};
//动态查询条件
if (!string.IsNullOrEmpty(condition.Keyword))
{
query = query.Where(i => i.MemberName.Contains(condition.Keyword));
}
//分页
int total = 0;
var page = query.Pager(out total, condition.CurrentPage, condition.PageSize);
//从字典中取名称
if (page != null && page.Count > 0)
{
SysDictService dictService = new SysDictService();
page.ForEach(i =>
{
i.GenderName = dictService.GetDictName(EnumDictType.UserGender, ((int)i.Gender).ToString());
});
}
var result = new Response <List <DoctorMemberDTO> >()
{
Data = page,
Total = total
};
return(result);
}
}
/// <summary>
/// 我的患者(下拉框)
/// </summary>
/// <returns></returns>
public Response <List <DoctorMemberDTO> > GetMyMemberDDL(DoctorMemberCondition condition)
{
var result = new Response <List <DoctorMemberDTO> >();
using (var db = new DBEntities())
{
var query = from item in db.DoctorMembers
join member in db.UserMembers on item.MemberID equals member.MemberID
//join map in db.UserMemberMaps on member.MemberID equals map.MemberID
//join user in db.Users on map.UserID equals user.UserID
orderby item.ModifyTime, item.CreateTime descending
where item.IsDeleted == false && member.IsDeleted == false &&
item.DoctorID == condition.DoctorID //&& map.IsDeleted == false
select new DoctorMemberDTO
{
MemberID = item.MemberID,
MemberName = member.MemberName,
Gender = member.Gender,
Birthday = member.Birthday,
Mobile = member.Mobile
};
if (!string.IsNullOrEmpty(condition.PatientName))
{
query = query.Where(i => i.MemberName.Contains(condition.PatientName));
}
int total = 0;
result.Data = query.Pager(out total, condition.CurrentPage, condition.PageSize);
result.Total = total;
}
if (result.Data != null)
{
var dictService = new SysDictService();
result.Data.ForEach(i =>
{
i.GenderName = dictService.GetDictName(EnumDictType.UserGender, ((int)i.Gender).ToString());
});
}
return(result);
}
public ActionResult Create(SysDictViewModel viewModel)
{
try
{
if (ModelState.IsValid == false)
{
return(WriteError("实体验证失败"));
}
SysDict entity = viewModel.EntityMap();
entity.CreateUserId = UserManager.GetCurrentUserInfo().Id;
entity.UpdateUserId = UserManager.GetCurrentUserInfo().Id;
entity.CreateTime = DateTime.Now;
entity.UpdateTime = DateTime.Now;
SysDictService.Add(entity);
return(WriteSuccess());
}
catch (Exception ex)
{
return(WriteError(ex));
}
}
public ActionResult Edit(int id)
{
var viewModel = SysDictService.GetList(x => x.Id == id).FirstOrDefault();
return(View(viewModel.EntityMap()));
}
