// id 参数名应该与控件上设置的 DataKeyNames 值匹配
public void lvDepartmentType_UpdateItem(Guid DepartmentCategoryID)
{
TextBox txtEditName = new TextBox();
txtEditName = (TextBox)lvDepartmentCategory.EditItem.FindControl("txtEditName");
var name = txtEditName?.Text;
TextBox txtEditRemark = new TextBox();
txtEditRemark = (TextBox)lvDepartmentCategory.EditItem.FindControl("txtEditRemark");
var remark = txtEditRemark?.Text;
if (String.IsNullOrEmpty(name))
{
return;
}
using (ImsDbContext context = new ImsDbContext())
{
IMS.Models.DepartmentCategory item = null;
// 在此加载该项，例如 item = MyDataLayer.Find(id);
item = context.DepartmentCategories.Find(DepartmentCategoryID);
if (item == null)
{
// 未找到该项
ModelState.AddModelError("", String.Format("未找到 id 为 {0} 的项", DepartmentCategoryID));
return;
}
TryUpdateModel(item);
if (ModelState.IsValid)
{
// 在此保存更改，例如 MyDataLayer.SaveChanges();
//不重名，更改项目名称
var query = context.DepartmentCategories.Where(n => n.Name == name && n.DepartmentCategoryID != item.DepartmentCategoryID).FirstOrDefault();
if (query != null)
{
ModelState.AddModelError("", String.Format("项目 {0} 已存在！", name));
return;
}
item.Name = name;
item.Remarks = remark;
//database win
bool saveFailed;
do
{
saveFailed = false;
try
{
context.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
saveFailed = true;
// Update the values of the entity that failed to save from the store
ex.Entries.Single().Reload();
}
} while (saveFailed);
}
}
}
// id 参数名应该与控件上设置的 DataKeyNames 值匹配
public void lvDepartmentCategory_DeleteItem(Guid DepartmentCategoryID)
{
using (ImsDbContext context = new ImsDbContext())
{
IMS.Models.DepartmentCategory item = null;
item = context.DepartmentCategories.Find(DepartmentCategoryID);
if (item == null)
{
// 未找到该项
ModelState.AddModelError("", String.Format("未找到 id 为 {0} 的项", DepartmentCategoryID));
return;
}
//检查在DepartmentMonitors中是否存在该信息
var query = context.DepartmentCategoryIndicatorMaps.Where(d => d.DepartmentCategoryID == DepartmentCategoryID).FirstOrDefault();
if (query != null)
{
//DepartmentMonitors 中存在该信息，不能删除
ModelState.AddModelError("", String.Format("在科室类别项目映射表中存在 {0} 的项，禁止删除", item.Name));
return;
}
TryUpdateModel(item);
if (ModelState.IsValid)
{
// 在此保存更改，例如 MyDataLayer.SaveChanges();
context.DepartmentCategories.Remove(item);
//database win
bool saveFailed;
do
{
saveFailed = false;
try
{
context.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
saveFailed = true;
// Update the values of the entity that failed to save from the store
ex.Entries.Single().Reload();
}
} while (saveFailed);
}
}
}
public void lvDepartmentCategory_InsertItem()
{
var item = new IMS.Models.DepartmentCategory();
TextBox txtName = new TextBox();
txtName = (TextBox)lvDepartmentCategory.InsertItem.FindControl("txtInsertName");
var name = txtName?.Text;
TextBox txtRemark = new TextBox();
txtRemark = (TextBox)lvDepartmentCategory.InsertItem.FindControl("txtInsertRemark");
var remark = txtRemark?.Text;
if (String.IsNullOrEmpty(name))
{
ModelState.AddModelError("", "请输入名称!");
return;
}
TryUpdateModel(item);
if (ModelState.IsValid)
{
// Save changes here
using (ImsDbContext context = new ImsDbContext())
{
//需检查是否有重名情况
var query = context.DepartmentCategories.Where(n => n.Name == name).FirstOrDefault();
if (query != null)
{
ModelState.AddModelError("", String.Format("项目 {0} 已存在！", name));
return;
}
item.DepartmentCategoryID = new Guid();
item.Name = name;
item.Remarks = remark;
context.DepartmentCategories.Add(item);
context.SaveChanges();
}
}
}