protected override void PageLoad() { base.PageLoad(); int queryString = RequestHelper.GetQueryString <int>("ID"); this.bookingProduct = BookingProductBLL.ReadBookingProduct(queryString, base.UserID); }
/// <summary> /// 读取一条缺货登记数据 /// </summary> /// <param name="id">缺货登记的主键值</param> /// <param name="userID">用户ID</param> /// <returns>缺货登记数据模型</returns> public BookingProductInfo ReadBookingProduct(int id, int userID) { SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int), new SqlParameter("@userID", SqlDbType.Int) }; parameters[0].Value = id; parameters[1].Value = userID; BookingProductInfo bookingProduct = new BookingProductInfo(); using (SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "ReadBookingProduct", parameters)) { if (dr.Read()) { bookingProduct.ID = dr.GetInt32(0); bookingProduct.ProductID = dr.GetInt32(1); bookingProduct.ProductName = dr[2].ToString(); bookingProduct.RelationUser = dr[3].ToString(); bookingProduct.Email = dr[4].ToString(); bookingProduct.Tel = dr[5].ToString(); bookingProduct.UserNote = dr[6].ToString(); bookingProduct.BookingDate = dr.GetDateTime(7); bookingProduct.BookingIP = dr[8].ToString(); bookingProduct.IsHandler = dr.GetInt32(9); bookingProduct.HandlerDate = dr.GetDateTime(10); bookingProduct.HandlerAdminID = dr.GetInt32(11); bookingProduct.HandlerAdminName = dr[12].ToString(); bookingProduct.HandlerNote = dr[13].ToString(); bookingProduct.UserID = dr.GetInt32(14); bookingProduct.UserName = dr[15].ToString(); } } return(bookingProduct); }
public BookingProductInfo ReadBookingProduct(int id, int userID) { SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@id", SqlDbType.Int), new SqlParameter("@userID", SqlDbType.Int) }; pt[0].Value = id; pt[1].Value = userID; BookingProductInfo info = new BookingProductInfo(); using (SqlDataReader reader = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "ReadBookingProduct", pt)) { if (reader.Read()) { info.ID = reader.GetInt32(0); info.ProductID = reader.GetInt32(1); info.ProductName = reader[2].ToString(); info.RelationUser = reader[3].ToString(); info.Email = reader[4].ToString(); info.Tel = reader[5].ToString(); info.UserNote = reader[6].ToString(); info.BookingDate = reader.GetDateTime(7); info.BookingIP = reader[8].ToString(); info.IsHandler = reader.GetInt32(9); info.HandlerDate = reader.GetDateTime(10); info.HandlerAdminID = reader.GetInt32(11); info.HandlerAdminName = reader[12].ToString(); info.HandlerNote = reader[13].ToString(); info.UserID = reader.GetInt32(14); info.UserName = reader[15].ToString(); } } return(info); }
/// <summary> /// 页面加载 /// </summary> protected override void PageLoad() { base.PageLoad(); user = UserBLL.ReadUserMore(base.UserId); int id = RequestHelper.GetQueryString <int>("ID"); bookingProduct = BookingProductBLL.ReadBookingProduct(id, base.UserId); }
public void UpdateBookingProduct(BookingProductInfo bookingProduct) { SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@id", SqlDbType.Int), new SqlParameter("@isHandler", SqlDbType.Int), new SqlParameter("@handlerDate", SqlDbType.DateTime), new SqlParameter("@handlerAdminID", SqlDbType.Int), new SqlParameter("@handlerAdminName", SqlDbType.NVarChar), new SqlParameter("@handlerNote", SqlDbType.NVarChar) }; pt[0].Value = bookingProduct.ID; pt[1].Value = bookingProduct.IsHandler; pt[2].Value = bookingProduct.HandlerDate; pt[3].Value = bookingProduct.HandlerAdminID; pt[4].Value = bookingProduct.HandlerAdminName; pt[5].Value = bookingProduct.HandlerNote; ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "UpdateBookingProduct", pt); }
/// <summary> /// 页面加载方法 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { int bookingProductID = RequestHelper.GetQueryString <int>("ID"); if (bookingProductID != int.MinValue) { CheckAdminPower("ReadBookingProduct", PowerCheckType.Single); bookingProduct = BookingProductBLL.ReadBookingProduct(bookingProductID, 0); HandlerNote.Text = bookingProduct.HandlerNote; IsHandler.Text = bookingProduct.IsHandler.ToString(); } } }
/// <summary> /// 提交按钮点击方法 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void SubmitButton_Click(object sender, EventArgs e) { BookingProductInfo bookingProduct = new BookingProductInfo(); bookingProduct.ID = RequestHelper.GetQueryString <int>("ID"); bookingProduct.IsHandler = Convert.ToInt32(IsHandler.Text);; bookingProduct.HandlerDate = RequestHelper.DateNow; bookingProduct.HandlerAdminID = Cookies.Admin.GetAdminID(false); bookingProduct.HandlerAdminName = Cookies.Admin.GetAdminName(false); bookingProduct.HandlerNote = HandlerNote.Text; string alertMessage = ShopLanguage.ReadLanguage("UpdateOK"); CheckAdminPower("UpdateBookingProduct", PowerCheckType.Single); BookingProductBLL.UpdateBookingProduct(bookingProduct); AdminLogBLL.Add(ShopLanguage.ReadLanguage("UpdateRecord"), ShopLanguage.ReadLanguage("BookingProduct"), bookingProduct.ID); ScriptHelper.Alert(alertMessage, RequestHelper.RawUrl); }
public int AddBookingProduct(BookingProductInfo bookingProduct) { SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@productID", SqlDbType.Int), new SqlParameter("@productName", SqlDbType.NVarChar), new SqlParameter("@relationUser", SqlDbType.NVarChar), new SqlParameter("@email", SqlDbType.NVarChar), new SqlParameter("@tel", SqlDbType.NVarChar), new SqlParameter("@userNote", SqlDbType.NVarChar), new SqlParameter("@bookingDate", SqlDbType.DateTime), new SqlParameter("@bookingIP", SqlDbType.NVarChar), new SqlParameter("@isHandler", SqlDbType.Int), new SqlParameter("@handlerDate", SqlDbType.DateTime), new SqlParameter("@handlerAdminID", SqlDbType.Int), new SqlParameter("@handlerAdminName", SqlDbType.NVarChar), new SqlParameter("@handlerNote", SqlDbType.NVarChar), new SqlParameter("@userID", SqlDbType.Int), new SqlParameter("@userName", SqlDbType.NVarChar) }; pt[0].Value = bookingProduct.ProductID; pt[1].Value = bookingProduct.ProductName; pt[2].Value = bookingProduct.RelationUser; pt[3].Value = bookingProduct.Email; pt[4].Value = bookingProduct.Tel; pt[5].Value = bookingProduct.UserNote; pt[6].Value = bookingProduct.BookingDate; pt[7].Value = bookingProduct.BookingIP; pt[8].Value = bookingProduct.IsHandler; pt[9].Value = bookingProduct.HandlerDate; pt[10].Value = bookingProduct.HandlerAdminID; pt[11].Value = bookingProduct.HandlerAdminName; pt[12].Value = bookingProduct.HandlerNote; pt[13].Value = bookingProduct.UserID; pt[14].Value = bookingProduct.UserName; return(Convert.ToInt32(ShopMssqlHelper.ExecuteScalar(ShopMssqlHelper.TablePrefix + "AddBookingProduct", pt))); }
protected override void PostBack() { BookingProductInfo bookingProduct = new BookingProductInfo(); bookingProduct.ProductID = RequestHelper.GetForm <int>("ProductID"); bookingProduct.ProductName = StringHelper.AddSafe(RequestHelper.GetForm <string>("ProductName")); bookingProduct.RelationUser = StringHelper.AddSafe(RequestHelper.GetForm <string>("RelationUser")); bookingProduct.Email = StringHelper.AddSafe(RequestHelper.GetForm <string>("Email")); bookingProduct.Tel = StringHelper.AddSafe(RequestHelper.GetForm <string>("Tel")); bookingProduct.UserNote = StringHelper.AddSafe(RequestHelper.GetForm <string>("UserNote")); bookingProduct.BookingDate = RequestHelper.DateNow; bookingProduct.BookingIP = ClientHelper.IP; bookingProduct.IsHandler = 0; bookingProduct.HandlerDate = RequestHelper.DateNow; bookingProduct.HandlerAdminID = 0; bookingProduct.HandlerAdminName = string.Empty; bookingProduct.HandlerNote = string.Empty; bookingProduct.UserID = base.UserID; bookingProduct.UserName = base.UserName; int num = BookingProductBLL.AddBookingProduct(bookingProduct); ScriptHelper.Alert("되션냥묘", "/ProductDetail.aspx?ID=" + bookingProduct.ProductID.ToString()); }
/// <summary> /// 准备缺货登记模型 /// </summary> /// <param name="dr">Datareader</param> /// <param name="bookingProductList">缺货登记的数据列表</param> public void PrepareBookingProductModel(SqlDataReader dr, List <BookingProductInfo> bookingProductList) { while (dr.Read()) { BookingProductInfo bookingProduct = new BookingProductInfo(); bookingProduct.ID = dr.GetInt32(0); bookingProduct.ProductID = dr.GetInt32(1); bookingProduct.ProductName = dr[2].ToString(); bookingProduct.RelationUser = dr[3].ToString(); bookingProduct.Email = dr[4].ToString(); bookingProduct.Tel = dr[5].ToString(); bookingProduct.UserNote = dr[6].ToString(); bookingProduct.BookingDate = dr.GetDateTime(7); bookingProduct.BookingIP = dr[8].ToString(); bookingProduct.IsHandler = dr.GetInt32(9); bookingProduct.HandlerDate = dr.GetDateTime(10); bookingProduct.HandlerAdminID = dr.GetInt32(11); bookingProduct.HandlerAdminName = dr[12].ToString(); bookingProduct.HandlerNote = dr[13].ToString(); bookingProduct.UserID = dr.GetInt32(14); bookingProduct.UserName = dr[15].ToString(); bookingProductList.Add(bookingProduct); } }
/// <summary> /// 更新一条缺货登记数据 /// </summary> /// <param name="bookingProduct">缺货登记模型变量</param> public static void UpdateBookingProduct(BookingProductInfo bookingProduct) { dal.UpdateBookingProduct(bookingProduct); }
/// <summary> /// 增加一条缺货登记数据 /// </summary> /// <param name="bookingProduct">缺货登记模型变量</param> public static int AddBookingProduct(BookingProductInfo bookingProduct) { bookingProduct.ID = dal.AddBookingProduct(bookingProduct); return(bookingProduct.ID); }