// id 参数名应该与控件上设置的 DataKeyNames 值匹配
public void lvIndicator_UpdateItem(Guid IndicatorID)
{
TextBox txtEditName = new TextBox();
txtEditName = (TextBox)lvIndicator.EditItem.FindControl("txtEditName");
var name = txtEditName?.Text;
TextBox txtEditRemark = new TextBox();
txtEditRemark = (TextBox)lvIndicator.EditItem.FindControl("txtEditRemark");
var remark = txtEditRemark?.Text;
if (String.IsNullOrEmpty(name))
{
return;
}
using (ImsDbContext context = new ImsDbContext())
{
IMS.Models.Indicator item = null;
// 在此加载该项，例如 item = MyDataLayer.Find(id);
item = context.Indicators.Find(IndicatorID);
if (item == null)
{
// 未找到该项
ModelState.AddModelError("", String.Format("未找到 id 为 {0} 的项", IndicatorID));
return;
}
TryUpdateModel(item);
if (ModelState.IsValid)
{
// 在此保存更改，例如 MyDataLayer.SaveChanges();
//不重名，更改项目名称
var query = context.Indicators.Where(n => n.Name == name && n.IndicatorID != item.IndicatorID).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 lvIndicator_DeleteItem(Guid IndicatorID)
{
using (ImsDbContext context = new ImsDbContext())
{
IMS.Models.Indicator item = null;
item = context.Indicators.Find(IndicatorID);
if (item == null)
{
// 未找到该项
ModelState.AddModelError("", String.Format("未找到 id 为 {0} 的项", IndicatorID));
return;
}
//检查在DepartmentMonitors中是否存在该信息
var queryDepartmentMonitor = context.DepartmentIndicatorValues.Where(d => d.IndicatorID == IndicatorID).FirstOrDefault();
if (queryDepartmentMonitor != null)
{
//DepartmentMonitors 中存在该信息，不能删除
ModelState.AddModelError("", String.Format("在科室项目值表中存在 {0} 的项，禁止删除", item.Name));
return;
}
TryUpdateModel(item);
if (ModelState.IsValid)
{
// 在此保存更改，例如 MyDataLayer.SaveChanges();
context.Indicators.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 lvIndicator_InsertItem()
{
var item = new IMS.Models.Indicator();
TextBox txtName = new TextBox();
txtName = (TextBox)lvIndicator.InsertItem.FindControl("txtInsertName");
var name = txtName?.Text;
TextBox txtRemark = new TextBox();
txtRemark = (TextBox)lvIndicator.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.Indicators.Where(n => n.Name == name).FirstOrDefault();
if (query != null)
{
ModelState.AddModelError("", String.Format("项目 {0} 已存在！", name));
return;
}
item.IndicatorID = new Guid();
item.Name = name;
item.Remarks = remark;
context.Indicators.Add(item);
context.SaveChanges();
}
}
}