public static string UpdateTransferHead(TransferHead model)
{
string result = "";
string strSql = "";
strSql += string.Format(@" SET XACT_ABORT ON ");
strSql += string.Format(@" BEGIN TRANSACTION ");
string ID = "";
if (model.ID == "" || model.ID == null)
{
Random rd = new Random();
string dateTimeStr = System.DateTime.Now.ToString("yyyy/MM/dd hh:MM:dd");
ID = dateTimeStr.Substring(0, 4) + dateTimeStr.Substring(5, 2) + dateTimeStr.Substring(8, 2)
+ dateTimeStr.Substring(11, 2) + dateTimeStr.Substring(14, 2) + dateTimeStr.Substring(17, 2);// rd.Next(1, 1000000000).ToString();
}
else
{
ID = model.ID;
}
if (!CheckTransferHead(ID))
{
strSql += "Insert Into wm_TransferHead (ID,TransferDate,LocID,NextLocID,FlagID) Values ('"
+ ID + "','" + model.TransferDate + "','" + model.LocID + "','" + model.NextLocID + "','" + model.FlagID + "')";
}
else
{
strSql += string.Format(@"UPDATE wm_TransferHead SET TransferDate='{0}' WHERE ID='{1}'"
, model.TransferDate, model.ID);
}
strSql += string.Format(@" COMMIT TRANSACTION ");
result = SQLHelper.ExecuteSqlUpdate(strSql);
result = ID;
return(result);
}
public JsonResult List(TransferHead model)
{
//构造成Json的格式传递
//var result = new { iTotalRecords = 100, iTotalDisplayRecords = 10, data = list };
var list = TransferDAL.LoadTransferDetailsByID(model.ID);
return(Json(list, JsonRequestBehavior.AllowGet));
//return Json(null, JsonRequestBehavior.AllowGet);
}
public static List <TransferHead> LoadTransferHead(string ID)
{
List <TransferHead> lsModel = new List <TransferHead>();
string strSql = "Select * FROM wm_TransferHead Where ID='" + ID + "'";
DataTable dt = SQLHelper.ExecuteSqlReturnDataTable(strSql);
for (int i = 0; i < dt.Rows.Count; i++)
{
TransferHead mdj = new TransferHead();
DataRow dr = dt.Rows[i];
mdj.ID = dr["ID"].ToString();
mdj.FlagID = dr["FlagID"].ToString();
mdj.TransferDate = dr["TransferDate"].ToString();
mdj.LocID = dr["LocID"].ToString();
mdj.NextLocID = dr["NextLocID"].ToString();
lsModel.Add(mdj);
}
return(lsModel);
}
public ActionResult AddTransferHead(TransferHead model)
{
string result = TransferDAL.UpdateTransferHead(model);
return(Json(result));
}
