/// <summary> /// EditReprot /// </summary> /// <param name="uid"></param> /// <returns></returns> public ActionResult Edit(int uid) { BLL.T_STOCK_InHead bllHead = new BLL.T_STOCK_InHead(); Book.Model.T_STOCK_InHead head = bllHead.GetModel(uid); Book.BLL.V_Inbody_Book bllBody = new Book.BLL.V_Inbody_Book(); List <Book.Model.V_Inbody_Book> lst = bllBody.GetModelList("InHeadID=" + uid); ViewBag.head = head; ViewBag.lst = lst; return(View()); }
public bool Add(Book.Model.T_STOCK_InHead head, List <Book.Model.T_STOCK_InBody> lst) { Book.DAL.T_STOCK_InHead bllHead = new Book.DAL.T_STOCK_InHead(); int headid = bllHead.Add(head); Book.DAL.T_STOCK_InBody bllBody = new Book.DAL.T_STOCK_InBody(); foreach (var item in lst) { item.InHeadID = headid; bllBody.Add(item); } return(true); }
public ActionResult AddSave() { Book.Model.T_STOCK_InHead head = new Book.Model.T_STOCK_InHead(); head.CeateTime = Convert.ToDateTime(Request.Form["CreateName"]); head.OrderNumber = Convert.ToString(Request.Form["OrderNumber"]); head.ProviderID = Convert.ToInt32(Request.Form["json.ID"]); head.ProviderName = Convert.ToString(Request.Form["json.Name"]); head.UserID = 1; head.UserName = "******"; List <Book.Model.T_STOCK_InBody> lst = new List <Book.Model.T_STOCK_InBody>(); int i = 0; while (Request.Form["items[" + i + "].book.ID"] != null) { Book.Model.T_STOCK_InBody body = new Book.Model.T_STOCK_InBody(); 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_In bll = new BLL.T_Stock_In(); bool result = bll.Add(head, lst); if (result) { MODEL.Message message = new MODEL.Message(); message = BookProject.Public.T_CloseSMess("InList", "InList", "添加入库单成功!"); 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_InHead model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_STOCK_InHead set "); strSql.Append("ProviderID=@ProviderID,"); strSql.Append("ProviderName=@ProviderName,"); 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("@ProviderID", SqlDbType.Int, 4), new SqlParameter("@ProviderName", 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.ProviderID; parameters[1].Value = model.ProviderName; 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_InHead head, List <Book.Model.T_STOCK_InBody> lst) { //更新header Book.DAL.T_STOCK_InHead bll = new Book.DAL.T_STOCK_InHead(); bll.Update(head); //更新body: 删除老的 Book.DAL.T_STOCK_InBody bllBody = new Book.DAL.T_STOCK_InBody(); bllBody.DeleteByHeadid(head.ID); //更新body: 插入新的 Book.DAL.T_STOCK_InBody dalBody = new Book.DAL.T_STOCK_InBody(); foreach (var item in lst) { item.InHeadID = head.ID; dalBody.Add(item); } return(true); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Book.Model.T_STOCK_InHead model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_STOCK_InHead("); strSql.Append("ProviderID,ProviderName,CeateTime,UserID,UserName,OrderNumber)"); strSql.Append(" values ("); strSql.Append("@ProviderID,@ProviderName,@CeateTime,@UserID,@UserName,@OrderNumber)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@ProviderID", SqlDbType.Int, 4), new SqlParameter("@ProviderName", 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.ProviderID; parameters[1].Value = model.ProviderName; 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_InHead DataRowToModel(DataRow row) { Book.Model.T_STOCK_InHead model = new Book.Model.T_STOCK_InHead(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["ProviderID"] != null && row["ProviderID"].ToString() != "") { model.ProviderID = int.Parse(row["ProviderID"].ToString()); } if (row["ProviderName"] != null) { model.ProviderName = row["ProviderName"].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_InHead GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,ProviderID,ProviderName,CeateTime,UserID,UserName,OrderNumber from T_STOCK_InHead "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; Book.Model.T_STOCK_InHead model = new Book.Model.T_STOCK_InHead(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }