public bool Add(T_PUMPTRUCK t_pumptruck)
{
try
{
db.T_PUMPTRUCK.Add(t_pumptruck);
db.SaveChanges();
return(true);
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
// LogHelper.Error("BLL执行Add方法:" + e.Message);
}
return(false);
}
public ActionResult Edt()
{
string S_PT_ID = Request.Params["S_PT_ID"] == null ? "" : Request.Params["S_PT_ID"];
T_PUMPTRUCK t_pumptruck = bcglBll.GetLIstT_PUMPTRUCK(S_PT_ID);
return(View(t_pumptruck));
}
public ActionResult ADD(T_PUMPTRUCK t_pumptruck)
{
try
{
t_pumptruck.S_PT_ID = Guid.NewGuid().ToString("N");
bcglBll.Add(t_pumptruck);
return(Json(new { code = "1", msg = "新增成功!" }));
}
catch (Exception e)
{
return(Json(new { code = "0", msg = e.Message }));
}
}
//public SYSCOMMANDO GetSYSCOMMANDO(string id)
//{
// SYSCOMMANDO SYSCOMMANDO = new SYSCOMMANDO();
// try
// {
// var query = from a in db.SYSCOMMANDO
// where a.ID == id
// select a;
// SYSCOMMANDO syscommando = query.ToList().FirstOrDefault();
// return syscommando;
// }
// catch (System.Exception e)
// {
// // LogHelper.Error("BLL执行GetSYSCOMMANDO方法:" + e.Message);
// return null;
// }
//}
public bool Edt(T_PUMPTRUCK model)
{
try
{
db.T_PUMPTRUCK.Attach(model);
db.Entry <T_PUMPTRUCK>(model).State = System.Data.EntityState.Modified;
db.SaveChanges();
return(true);
}
catch (Exception e)
{
throw;
}
return(false);
}
public T_PUMPTRUCK GetLIstT_PUMPTRUCK(string S_PT_ID)
{
try
{
var query = from a in db.T_PUMPTRUCK
where a.S_PT_ID == S_PT_ID
select a;
T_PUMPTRUCK t_pumptruck = query.ToList().FirstOrDefault();
return(t_pumptruck);
}
catch (System.Exception e)
{
// LogHelper.Error("BLL执行GetLIstT_PUMPTRUCK方法:" + e.Message);
return(null);
}
}
public void Del(string iditems)
{
try
{
string[] ss = iditems.Split(',');
foreach (string item in ss)
{
T_PUMPTRUCK model = (T_PUMPTRUCK)db.T_PUMPTRUCK.Where(w => w.S_PT_ID == item).FirstOrDefault();
db.T_PUMPTRUCK.Attach(model);
db.Entry <T_PUMPTRUCK>(model).State = System.Data.EntityState.Deleted;
}
db.SaveChanges();
}
catch (System.Exception e)
{
// LogHelper.Error("BLL执行Del方法:" + e.Message);
throw;
}
}
//public object GetT_CAMERA() {
// try
// {
// var query=from a in db.T_
// }
// catch (Exception e)
// {
// LogHelper.Error("BLL执行GetT_CAMERA方法:" + e.Message);
// return null;
// }
//}
//public List<T_MANAGEUNIT> GetT_MANAGEUNIT()
//{
// List<T_MANAGEUNIT> list = new List<T_MANAGEUNIT>();
// T_MANAGEUNIT item = new T_MANAGEUNIT();
// item.S_ID = "--请选择--";
// item.S_PT_DEPARTMENT = "--请选择--";
// list.Add(item);
// try
// {
// var query = from a in db.T_MANAGEUNIT
// select a;
// list.AddRange(query.ToList());
// return list;
// }
// catch (Exception e)
// {
// // LogHelper.Error("BLL执行GetT_MANAGEUNIT方法:" + e.Message);
// return list;
// }
//}
public List <T_PUMPTRUCK> GetT_PUMPTRUCK()
{
List <T_PUMPTRUCK> list = new List <T_PUMPTRUCK>();
T_PUMPTRUCK item = new T_PUMPTRUCK();
item.S_PT_ID = "";
item.S_PT_NAME = "--请选择--";
list.Add(item);
try
{
var query = from a in db.T_PUMPTRUCK
select a;
list.AddRange(query.ToList());
return(list);
}
catch (Exception e)
{
// LogHelper.Error("BLL执行GetT_PUMPTRUCK方法:" + e.Message);
return(list);
}
}
public async Task <ActionResult> Edt(T_PUMPTRUCK t_pumptruck)
{
try
{
bcglBll.Edt(t_pumptruck);
return(Json(new { code = "1", msg = "修改成功!" }));
}
catch (DbUpdateConcurrencyException e)
{
var entry = e.Entries.Single();
T_PUMPTRUCK tp = (T_PUMPTRUCK)entry.Entity;
var databaseEntry = entry.GetDatabaseValues();
if (databaseEntry == null)
{
return(Json(new { code = "0", msg = "该记录已被其他人删除!" }));
}
else
{
string ret = "";
var databaseValues = (T_PUMPTRUCK)databaseEntry.ToObject();
if (databaseValues.S_SPBH != tp.S_SPBH)
{
ret += "S_SPBH,当前值：" + databaseValues.S_SPBH + "。";
}
if (databaseValues.S_PT_NAME != tp.S_PT_NAME)
{
ret += "S_PT_NAME,当前值：" + databaseValues.S_PT_NAME + "。";
}
if (databaseValues.S_PZ != tp.S_PZ)
{
ret += "S_PZ,当前值：" + databaseValues.S_PZ + "。";
}
if (databaseValues.S_PT_FLOW != tp.S_PT_FLOW)
{
ret += "S_PT_FLOW,当前值：" + databaseValues.S_PT_FLOW + "。";
}
if (databaseValues.S_PT_LIFT != tp.S_PT_LIFT)
{
ret += "S_PT_LIFT,当前值：" + databaseValues.S_PT_LIFT + "。";
}
if (databaseValues.N_PT_CLASS != tp.N_PT_CLASS)
{
ret += "N_PT_CLASS,当前值：" + databaseValues.N_PT_CLASS + "。";
}
if (databaseValues.S_ADD != tp.S_ADD)
{
ret += "S_ADD,当前值：" + databaseValues.S_ADD + "。";
}
if (databaseValues.S_PT_AREA != tp.S_PT_AREA)
{
ret += "S_PT_AREA,当前值：" + databaseValues.S_PT_AREA + "。";
}
if (databaseValues.S_SYSCOMMANDOID != tp.S_SYSCOMMANDOID)
{
ret += "S_SYSCOMMANDOID,当前值：" + databaseValues.S_SYSCOMMANDOID + "。";
}
if (databaseValues.S_PT_CONTACTS != tp.S_PT_CONTACTS)
{
ret += "S_PT_CONTACTS,当前值：" + databaseValues.S_PT_CONTACTS + "。";
}
if (databaseValues.S_PT_CONTACTPHONE != tp.S_PT_CONTACTPHONE)
{
ret += "S_PT_CONTACTPHONE,当前值：" + databaseValues.S_PT_CONTACTPHONE + "。";
}
if (databaseValues.S_BZ != tp.S_BZ)
{
ret += "S_BZ,当前值：" + databaseValues.S_BZ + "。";
}
if (databaseValues.S_QX != tp.S_QX)
{
ret += "S_QX,当前值：" + databaseValues.S_QX + "。";
}
tp.RowVersion = databaseValues.RowVersion;
return(Json(new { code = "0", msg = ret }));
}
}
}
public ActionResult Detail(string S_PT_ID)
{
T_PUMPTRUCK t_pumptruck = bcglBll.GetLIstT_PUMPTRUCK(S_PT_ID);
return(View(t_pumptruck));
}
