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)); }