/// <summary> /// EditOutReport /// </summary> /// <param name="uid"></param> /// <returns></returns> public ActionResult Edit(int uid) { Book.BLL.T_STOCK_OutHead bllHead = new Book.BLL.T_STOCK_OutHead(); Book.Model.T_STOCK_OutHead head = bllHead.GetModel(uid); Book.BLL.V_Outbody_Book bllBody = new Book.BLL.V_Outbody_Book(); List <Book.Model.V_Outbody_Book> lst = bllBody.GetModelList("InHeadID=" + uid); ViewBag.head = head; ViewBag.lst = lst; return(View()); }
public bool Add(Book.Model.T_STOCK_OutHead head, List <Book.Model.T_STOCK_OutBody> lst) { Book.DAL.T_STOCK_OutHead bllHead = new Book.DAL.T_STOCK_OutHead(); int headid = bllHead.Add(head); Book.DAL.T_STOCK_OutBody bllBody = new Book.DAL.T_STOCK_OutBody(); foreach (var item in lst) { item.InHeadID = headid; bllBody.Add(item); } return(true); }
public JsonResult AddSave() { Book.Model.T_STOCK_OutHead head = new Book.Model.T_STOCK_OutHead(); head.CeateTime = Convert.ToDateTime(Request.Form["CreateName"]); head.OrderNumber = Convert.ToString(Request.Form["OrderNumber"]); head.GuestID = Convert.ToInt32(Request.Form["json.ID"]); head.GuestName = Convert.ToString(Request.Form["json.Name"]); head.UserID = 1; head.UserName = "******"; List <Book.Model.T_STOCK_OutBody> lst = new List <Book.Model.T_STOCK_OutBody>(); int i = 0; while (Request.Form["items[" + i + "].book.ID"] != null) { Book.Model.T_STOCK_OutBody body = new Book.Model.T_STOCK_OutBody(); string BookID = Request.Form["items[" + i + "].book.ID"]; BookID = BookID.Replace(",", ""); body.BookID = Convert.ToInt32(BookID); body.Discount = Convert.ToDecimal(Request.Form["items[" + i + "].book.Discount"]); body.InHeadID = 0; body.Num = Convert.ToInt32(Request.Form["items[" + i + "].book.Num"]); body.Price = Convert.ToDecimal(Request.Form["items[" + i + "].book.Price"]); lst.Add(body); i++; } BLL.T_Stock_Out bll = new BLL.T_Stock_Out(); bool result = bll.Add(head, lst); if (result) { MODEL.Message message = new MODEL.Message(); message = BookProject.Public.T_CloseSMess("OutList", "OutList", "添加出库单成功!"); return(Json(message)); } else { MODEL.Message message = new MODEL.Message(); message = BookProject.Public.T_CloseFMess("InList", "InList", "添加入库单失败!"); return(Json(message)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Book.Model.T_STOCK_OutHead model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_STOCK_OutHead set "); strSql.Append("GuestID=@GuestID,"); strSql.Append("GuestName=@GuestName,"); strSql.Append("CeateTime=@CeateTime,"); strSql.Append("UserID=@UserID,"); strSql.Append("UserName=@UserName,"); strSql.Append("OrderNumber=@OrderNumber"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@GuestID", SqlDbType.Int, 4), new SqlParameter("@GuestName", SqlDbType.NVarChar, 50), new SqlParameter("@CeateTime", SqlDbType.DateTime), new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@UserName", SqlDbType.NVarChar, 50), new SqlParameter("@OrderNumber", SqlDbType.NVarChar, 50), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.GuestID; parameters[1].Value = model.GuestName; parameters[2].Value = model.CeateTime; parameters[3].Value = model.UserID; parameters[4].Value = model.UserName; parameters[5].Value = model.OrderNumber; parameters[6].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public bool EditSave(Book.Model.T_STOCK_OutHead head, List <Book.Model.T_STOCK_OutBody> lst) { //更新header Book.DAL.T_STOCK_OutHead bll = new Book.DAL.T_STOCK_OutHead(); bll.Update(head); //更新body: 删除老的 Book.DAL.T_STOCK_OutBody bllBody = new Book.DAL.T_STOCK_OutBody(); bllBody.DeleteByHeadID(head.ID); //更新body: 插入新的 Book.DAL.T_STOCK_OutBody dalBody = new Book.DAL.T_STOCK_OutBody(); foreach (var item in lst) { item.InHeadID = head.ID; dalBody.Add(item); } return(true); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Book.Model.T_STOCK_OutHead model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_STOCK_OutHead("); strSql.Append("GuestID,GuestName,CeateTime,UserID,UserName,OrderNumber)"); strSql.Append(" values ("); strSql.Append("@GuestID,@GuestName,@CeateTime,@UserID,@UserName,@OrderNumber)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@GuestID", SqlDbType.Int, 4), new SqlParameter("@GuestName", SqlDbType.NVarChar, 50), new SqlParameter("@CeateTime", SqlDbType.DateTime), new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@UserName", SqlDbType.NVarChar, 50), new SqlParameter("@OrderNumber", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.GuestID; parameters[1].Value = model.GuestName; parameters[2].Value = model.CeateTime; parameters[3].Value = model.UserID; parameters[4].Value = model.UserName; parameters[5].Value = model.OrderNumber; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Book.Model.T_STOCK_OutHead DataRowToModel(DataRow row) { Book.Model.T_STOCK_OutHead model = new Book.Model.T_STOCK_OutHead(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["GuestID"] != null && row["GuestID"].ToString() != "") { model.GuestID = int.Parse(row["GuestID"].ToString()); } if (row["GuestName"] != null) { model.GuestName = row["GuestName"].ToString(); } if (row["CeateTime"] != null && row["CeateTime"].ToString() != "") { model.CeateTime = DateTime.Parse(row["CeateTime"].ToString()); } if (row["UserID"] != null && row["UserID"].ToString() != "") { model.UserID = int.Parse(row["UserID"].ToString()); } if (row["UserName"] != null) { model.UserName = row["UserName"].ToString(); } if (row["OrderNumber"] != null) { model.OrderNumber = row["OrderNumber"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Book.Model.T_STOCK_OutHead GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,GuestID,GuestName,CeateTime,UserID,UserName,OrderNumber from T_STOCK_OutHead "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; Book.Model.T_STOCK_OutHead model = new Book.Model.T_STOCK_OutHead(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }