public basicinfoModel GetBasicInfo(int ovaid)
{
using (Entities db = new Entities())
{
string sql = string.Format(@"select * from fi_uvas t where t.ovaid={0}", ovaid);
basicinfoModel model = db.Database.SqlQuery <basicinfoModel>(sql).FirstOrDefault();
return(model);
}
}
public HttpResponseMessage EditBasicInfo(basicinfoModel model)
{
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK);
int success = bll.EditBasicInfo(model);
if (success > 0)
{
response.Content = new StringContent("{\"success\":true}", Encoding.GetEncoding("UTF-8"), "text/html");
}
return(response);
}
public int AddBasicInfo(basicinfoModel model)
{
using (Entities db = new Entities())
{
fi_uvas uvas_model = new fi_uvas();
uvas_model.createtime = DateTime.Now;
uvas_model.createuserid = model.createuserid;
uvas_model.device = model.device;
uvas_model.isdelete = 0;
uvas_model.ovaname = model.ovaname;
uvas_model.ovanum = model.ovanum;
uvas_model.unit = model.unit;
db.fi_uvas.Add(uvas_model);
return(db.SaveChanges());
}
}
public int EditBasicInfo(basicinfoModel model)
{
using (Entities db = new Entities())
{
fi_uvas uvas = db.fi_uvas.FirstOrDefault(t => t.ovaid == model.ovaid);
if (uvas != null)
{
uvas.device = model.device;
uvas.ovaname = model.ovaname;
uvas.unit = model.unit;
uvas.ovanum = model.ovanum;
return(db.SaveChanges());
}
else
{
return(0);
}
}
}
public int EditBasicInfo(basicinfoModel model)
{
return(dal.EditBasicInfo(model));
}
public int AddBasicInfo(basicinfoModel model)
{
return(dal.AddBasicInfo(model));
}
