private RemainRecord WrapRemainRecordItem(DataRow remainRecordRow)
{
RemainRecord remainRecordItem = new RemainRecord();
if (remainRecordRow != null)
{
remainRecordItem.ID = Convert.ToInt32(remainRecordRow["ID"]);
if (Convert.ToInt32(remainRecordRow["CowGroupID"]) != 0)
{
remainRecordItem.CowGroupID = Convert.ToInt32(remainRecordRow["CowGroupID"]);
}
if (Convert.ToInt32(remainRecordRow["FormulaID"]) != 0)
{
remainRecordItem.FormulaID = Convert.ToInt32(remainRecordRow["FormulaID"]);
}
if (Convert.ToInt32(remainRecordRow["RecordUserID"]) != 0)
{
remainRecordItem.RecordUserID = Convert.ToInt32(remainRecordRow["RecordUserID"]);
}
remainRecordItem.RecordTime = Convert.ToDateTime(remainRecordRow["RecordTime"]);
if (Convert.ToInt32(remainRecordRow["RemainQuantity"]) != 0)
{
remainRecordItem.RemainQuantity = float.Parse(remainRecordRow["RemainQuantity"].ToString());
}
}
return(remainRecordItem);
}
public List <RemainRecord> GetRemainRecordList()
{
List <RemainRecord> lstRemainRecord = new List <RemainRecord>();
DataTable datRemainRecord = this.dalRemainRecord.GetRemainRecordList();
foreach (DataRow drRemainRecord in datRemainRecord.Rows)
{
RemainRecord remainRecordItem = WrapRemainRecordItem(drRemainRecord);
lstRemainRecord.Add(remainRecordItem);
}
return(lstRemainRecord);
}
public int InsertRemainRecordInfo(RemainRecord remainRecord)
{
StringBuilder sql = new StringBuilder();
sql.Append(@"insert into [Feed_RemainRecord] values (
" + remainRecord.CowGroupID + ","
+ remainRecord.FormulaID + ","
+ remainRecord.RecordUserID + ",'"
+ remainRecord.RecordTime + "',"
+ remainRecord.RemainQuantity + ")");
return(dataProvider1mutong.ExecuteNonQuery(sql.ToString(), CommandType.Text));
}
public ActionResult Save()
{
try
{
string cowGroupID = Request.Form["cowGroupName"];
string remainQuantity = Request.Form["reQuantity"];
RemainRecord remainRecord = new RemainRecord();
remainRecord.CowGroupID = Convert.ToInt32(cowGroupID);
remainRecord.FormulaID = bllCowGroup.GetFormulaIDByGroupID(Convert.ToInt32(cowGroupID));//需要根据牛群ID获得配方ID
remainRecord.RecordUserID = UserBLL.Instance.CurrentUser.ID;
remainRecord.RecordTime = DateTime.Now;
float s;
float.TryParse(remainQuantity, out s);
remainRecord.RemainQuantity = s;
bllRemainRecord.InsertRemainRecordInfo(remainRecord);
}
catch (Exception e)
{
}
return(RedirectToAction("../../Feed/CowGroup/List"));
}
public int InsertRemainRecordInfo(RemainRecord remainRecord)
{
return(dalRemainRecord.InsertRemainRecordInfo(remainRecord));
}
