public ActionResult Save()
{
RemoveAddMilk removeAddMilk = new RemoveAddMilk();
UpdateModel <RemoveAddMilk>(removeAddMilk);
bllRemoveAddMilk.InsertRemoveAddMilkInfo(removeAddMilk);
return(View());
}
public List <RemoveAddMilk> GetRemoveAddMilkList()
{
List <RemoveAddMilk> lstRemoveAddMilk = new List <RemoveAddMilk>();
DataTable datRemoveAddMilk = this.dalRemoveAddMilk.GetRemoveAddMilkList();
foreach (DataRow drRemoveAddMilk in datRemoveAddMilk.Rows)
{
RemoveAddMilk removeAddMilkItem = WrapRemoveAddMilkItem(drRemoveAddMilk);
lstRemoveAddMilk.Add(removeAddMilkItem);
}
return(lstRemoveAddMilk);
}
public int InsertRemoveAddMilkInfo(RemoveAddMilk removeAddMilk)
{
StringBuilder sql = new StringBuilder();
sql.Append(@"insert into Medical_RemoveAddMilk values (
" + removeAddMilk.EarNum + ",'"
+ removeAddMilk.Method + "','"
+ removeAddMilk.LeftFront + "','"
+ removeAddMilk.RightFront + "','"
+ removeAddMilk.LeftBack + "','"
+ removeAddMilk.RightBack + "','"
+ removeAddMilk.OprateDate + "')");
return(dataProvider1mutong.ExecuteNonQuery(sql.ToString(), CommandType.Text));
}
private RemoveAddMilk WrapRemoveAddMilkItem(DataRow removeAddMilkRow)
{
RemoveAddMilk removeAddMilkItem = new RemoveAddMilk();
if (removeAddMilkRow != null)
{
if (Convert.ToInt32(removeAddMilkRow["ID"]) != 0)
{
removeAddMilkItem.ID = Convert.ToInt32(removeAddMilkRow["ID"]);
}
if (Convert.ToInt32(removeAddMilkRow["EarNum"]) != 0)
{
removeAddMilkItem.EarNum = Convert.ToInt32(removeAddMilkRow["EarNum"]);
}
removeAddMilkItem.Method = removeAddMilkRow["Method"].ToString();
removeAddMilkItem.LeftFront = removeAddMilkRow["LeftFront"].ToString();
removeAddMilkItem.RightFront = removeAddMilkRow["RightFront"].ToString();
removeAddMilkItem.LeftBack = removeAddMilkRow["LeftBack"].ToString();
removeAddMilkItem.RightBack = removeAddMilkRow["RightBack"].ToString();
removeAddMilkItem.OprateDate = Convert.ToDateTime(removeAddMilkRow["OprateDate"]);
}
return(removeAddMilkItem);
}
public int InsertRemoveAddMilkInfo(RemoveAddMilk removeAddMilk)
{
return(dalRemoveAddMilk.InsertRemoveAddMilkInfo(removeAddMilk));
}
