public int UpdateMilkHallInfo(MilkHall milkHall) { //StringBuilder sql = new StringBuilder(); //sql.Append(@"UPDATE [Milk_Hall] set "); //if (milkHall.VacuumPressure != null) //{ // sql.Append("[VacuumPressure] = " + milkHall.VacuumPressure + ","); //} //if (milkHall.Pulsation != null && milkHall.Pulsation != 0) //{ // sql.Append("[Pulsation] = " + milkHall.Pulsation + ","); //} //if (milkHall.CleanupCount != null && milkHall.CleanupCount != 0) //{ // sql.Append("[CleanupCount] = " + milkHall.CleanupCount + ","); //} //if (milkHall.ModifyTime != null && string.IsNullOrWhiteSpace(milkHall.ModifyTime.ToString())) //{ // sql.Append("[ModifyTime] = " + milkHall.ModifyTime + ","); //} //sql.Append("[Name]='" + milkHall.Name + "' where ID=" + id); string sql = String.Format(@"insert into Milk_Hall ([VacuumPressure] ,[Pulsation] ,[CleanupCount] ,[ModifyTime]) values ({0},{1},{2},'{3}')", milkHall.VacuumPressure, milkHall.Pulsation, milkHall.CleanupCount, milkHall.ModifyTime); return(dataProvider1mutong.ExecuteNonQuery(sql, CommandType.Text)); }
private MilkHall WrapMilkHallItem(DataRow milkHallRow) { MilkHall milkHallItem = new MilkHall(); if (milkHallRow != null) { milkHallItem.ID = Convert.ToInt32(milkHallRow["ID"]); //milkHallItem.Name = milkHallRow["Name"].ToString(); //milkHallItem.PastureID = Convert.ToInt32(milkHallRow["PastureID"]); if (milkHallRow["VacuumPressure"] != null && !string.IsNullOrWhiteSpace(milkHallRow["VacuumPressure"].ToString())) { milkHallItem.VacuumPressure = float.Parse(milkHallRow["VacuumPressure"].ToString()); } if (milkHallRow["Pulsation"] != null && !string.IsNullOrWhiteSpace(milkHallRow["Pulsation"].ToString())) { milkHallItem.Pulsation = Convert.ToInt32(milkHallRow["Pulsation"]); } if (milkHallRow["CleanupCount"] != null) { milkHallItem.CleanupCount = Convert.ToInt32(milkHallRow["CleanupCount"]); } } return(milkHallItem); }
public JsonResult Update(string VacuumPressure, string Pulsation, string CleanupCount) { //MilkHall milkHall = new MilkHall(); //UpdateModel<MilkHall>(milkHall); //MilkHall milkHallExist = bllMilkHall.GetMilkHallByID(id); //milkHallExist.VacuumPressure = milkHall.VacuumPressure; //milkHallExist.Pulsation = milkHall.Pulsation; //milkHallExist.CleanupCount = milkHall.CleanupCount; //milkHallExist.ModifyTime = DateTime.Now; //bllMilkHall.UpdateMilkHallInfo(milkHallExist, id); //string VacuumPressure = Request.Form["vacPressure"]; //string Pulsation = Request.Form["pulsat"]; //string CleanupCount = Request.Form["cleaCount"]; MilkHall milkHall = new MilkHall(); milkHall.VacuumPressure = float.Parse(VacuumPressure); milkHall.Pulsation = Convert.ToInt32(Pulsation); milkHall.CleanupCount = Convert.ToInt32(CleanupCount); milkHall.ModifyTime = DateTime.Now; bllMilkHall.UpdateMilkHallInfo(milkHall); return(Json(1, JsonRequestBehavior.AllowGet)); }
public MilkHall GetMilkHallByID() { MilkHall milkHallInfo = new MilkHall(); DataTable milkHallData = dalMilkHall.GetMilkHallByID(); if (milkHallData != null && milkHallData.Rows.Count == 1) { milkHallInfo = WrapMilkHallItem(milkHallData.Rows[0]); } return(milkHallInfo); }
public List <MilkHall> GetMilkHallList() { List <MilkHall> milkHallList = new List <MilkHall>(); DataTable milkHallData = dalMilkHall.GetMilkHallList(); foreach (DataRow drCow in milkHallData.Rows) { MilkHall cowItem = WrapMilkHallItem(drCow); milkHallList.Add(cowItem); } return(milkHallList); }
// // GET: /Parameter/ public ActionResult Edit() { //ViewBag.ID = id; //MilkHall milkHall = bllMilkHall.GetMilkHallByID(id); //ViewBag.VacuumPressure = milkHall.VacuumPressure; //ViewBag.Pulsation = milkHall.Pulsation; //ViewBag.CleanupCount = milkHall.CleanupCount; //ViewBag.Name = milkHall.Name; MilkHall milkHallExist = bllMilkHall.GetMilkHallByID(); ViewBag.VacuumPressure = milkHallExist.VacuumPressure; ViewBag.Pulsation = milkHallExist.Pulsation; ViewBag.CleanupCount = milkHallExist.CleanupCount; return(View("~/Views/Milk/Hall/Parameters.cshtml")); }
public JsonResult LoadTask() { MilkHall milkHallExist = bllMilkHall.GetMilkHallByID(); ViewBag.VacuumPressure = milkHallExist.VacuumPressure; ViewBag.Pulsation = milkHallExist.Pulsation; ViewBag.CleanupCount = milkHallExist.CleanupCount; var milkData = new { vacuumPressure = milkHallExist.VacuumPressure, pulsation = milkHallExist.Pulsation, cleanupCount = milkHallExist.CleanupCount }; return(Json(milkData, JsonRequestBehavior.AllowGet)); }
public int UpdateMilkHallInfo(MilkHall milkHall) { return(dalMilkHall.UpdateMilkHallInfo(milkHall)); }