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