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);
}
