public void PrepareCondition(MssqlCondition mssqlCondition, BookingProductSearchInfo bookingProductSearch)
{
mssqlCondition.Add("[ProductName]", bookingProductSearch.ProductName, ConditionType.Like);
mssqlCondition.Add("[RelationUser]", bookingProductSearch.RelationUser, ConditionType.Like);
mssqlCondition.Add("[Email]", bookingProductSearch.Email, ConditionType.Like);
mssqlCondition.Add("[Tel]", bookingProductSearch.Tel, ConditionType.Like);
mssqlCondition.Add("[IsHandler]", bookingProductSearch.IsHandler, ConditionType.Equal);
mssqlCondition.Add("[UserID]", bookingProductSearch.UserID, ConditionType.Equal);
}
/// <summary>
/// 组合搜索条件
/// </summary>
/// <param name="mssqlCondition"></param>
/// <param name="bookingProductSearch">BookingProductSearchInfo模型变量</param>
public MssqlCondition PrepareCondition(BookingProductSearchInfo bookingProductSearch)
{
MssqlCondition mssqlCondition = new MssqlCondition();
mssqlCondition.Add("[ProductName]", bookingProductSearch.ProductName, ConditionType.Like);
mssqlCondition.Add("[RelationUser]", bookingProductSearch.RelationUser, ConditionType.Like);
mssqlCondition.Add("[Email]", bookingProductSearch.Email, ConditionType.Like);
mssqlCondition.Add("[Tel]", bookingProductSearch.Tel, ConditionType.Like);
mssqlCondition.Add("[IsHandler]", bookingProductSearch.IsHandler, ConditionType.Equal);
mssqlCondition.Add("[UserID]", bookingProductSearch.UserID, ConditionType.Equal);
return(mssqlCondition);
}
public List <BookingProductInfo> SearchBookingProductList(BookingProductSearchInfo bookingProductSearch)
{
MssqlCondition mssqlCondition = new MssqlCondition();
this.PrepareCondition(mssqlCondition, bookingProductSearch);
List <BookingProductInfo> bookingProductList = new List <BookingProductInfo>();
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@condition", SqlDbType.NVarChar) };
pt[0].Value = mssqlCondition.ToString();
using (SqlDataReader reader = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "SearchBookingProductList", pt))
{
this.PrepareBookingProductModel(reader, bookingProductList);
}
return(bookingProductList);
}
/// <summary>
/// 搜索缺货登记数据列表
/// </summary>
/// <param name="bookingProductSearch">BookingProductSearchInfo模型变量</param>
/// <returns>缺货登记数据列表</returns>
public List <BookingProductInfo> SearchBookingProductList(BookingProductSearchInfo bookingProductSearch)
{
string condition = PrepareCondition(bookingProductSearch).ToString();
List <BookingProductInfo> bookingProductList = new List <BookingProductInfo>();
SqlParameter[] parameters =
{
new SqlParameter("@condition", SqlDbType.NVarChar)
};
parameters[0].Value = condition;
using (SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "SearchBookingProductList", parameters))
{
PrepareBookingProductModel(dr, bookingProductList);
}
return(bookingProductList);
}
protected override void PageLoad()
{
base.PageLoad();
int queryString = RequestHelper.GetQueryString <int>("Page");
if (queryString < 1)
{
queryString = 1;
}
int pageSize = 20;
int count = 0;
BookingProductSearchInfo bookingProduct = new BookingProductSearchInfo();
bookingProduct.UserID = base.UserID;
this.bookingProductList = BookingProductBLL.SearchBookingProductList(queryString, pageSize, bookingProduct, ref count);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.Page.IsPostBack)
{
base.CheckAdminPower("ReadBookingProduct", PowerCheckType.Single);
this.RelationUser.Text = RequestHelper.GetQueryString <string>("RelationUser");
this.ProductName.Text = RequestHelper.GetQueryString <string>("ProductName");
this.IsHandler.Text = RequestHelper.GetQueryString <string>("IsHandler");
List <BookingProductInfo> dataSource = new List <BookingProductInfo>();
BookingProductSearchInfo bookingProduct = new BookingProductSearchInfo();
bookingProduct.RelationUser = RequestHelper.GetQueryString <string>("RelationUser");
bookingProduct.ProductName = RequestHelper.GetQueryString <string>("ProductName");
bookingProduct.IsHandler = RequestHelper.GetQueryString <int>("IsHandler");
dataSource = BookingProductBLL.SearchBookingProductList(base.CurrentPage, base.PageSize, bookingProduct, ref this.Count);
base.BindControl(dataSource, this.RecordList, this.MyPager);
}
}
/// <summary>
/// 页面加载
/// </summary>
protected override void PageLoad()
{
base.PageLoad();
user = UserBLL.ReadUserMore(base.UserId);
int currentPage = RequestHelper.GetQueryString <int>("Page");
if (currentPage < 1)
{
currentPage = 1;
}
int pageSize = 20;
int count = 0;
BookingProductSearchInfo bookingProductSearch = new BookingProductSearchInfo();
bookingProductSearch.UserID = base.UserId;
bookingProductList = BookingProductBLL.SearchBookingProductList(currentPage, pageSize, bookingProductSearch, ref count);
commonPagerClass.Init(currentPage, pageSize, count, !string.IsNullOrEmpty(isMobile));
}
/// <summary>
/// 页面加载方法
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
CheckAdminPower("ReadBookingProduct", PowerCheckType.Single);
RelationUser.Text = RequestHelper.GetQueryString <string>("RelationUser");
ProductName.Text = RequestHelper.GetQueryString <string>("ProductName");
IsHandler.Text = RequestHelper.GetQueryString <string>("IsHandler");
List <BookingProductInfo> bookingProductList = new List <BookingProductInfo>();
BookingProductSearchInfo bookingProductSearch = new BookingProductSearchInfo();
bookingProductSearch.RelationUser = RequestHelper.GetQueryString <string>("RelationUser");
bookingProductSearch.ProductName = RequestHelper.GetQueryString <string>("ProductName");
bookingProductSearch.IsHandler = RequestHelper.GetQueryString <int>("IsHandler");
PageSize = Session["AdminPageSize"] == null ? 20 : Convert.ToInt32(Session["AdminPageSize"]);
AdminPageSize.Text = Session["AdminPageSize"] == null ? "20" : Session["AdminPageSize"].ToString();
bookingProductList = BookingProductBLL.SearchBookingProductList(CurrentPage, PageSize, bookingProductSearch, ref Count);
BindControl(bookingProductList, RecordList, MyPager);
}
}
/// <summary>
/// 搜索缺货登记数据列表
/// </summary>
/// <param name="currentPage">当前的页数</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="bookingProductSearch">BookingProductSearchInfo模型变量</param>
/// <param name="count">总数量</param>
/// <returns>缺货登记数据列表</returns>
public List <BookingProductInfo> SearchBookingProductList(int currentPage, int pageSize, BookingProductSearchInfo bookingProductSearch, ref int count)
{
List <BookingProductInfo> bookingProductList = new List <BookingProductInfo>();
ShopMssqlPagerClass pc = new ShopMssqlPagerClass();
pc.TableName = "ProductBooking";
pc.Fields = "[ID],[ProductID],[ProductName],[RelationUser],[Email],[Tel],[UserNote],[BookingDate],[BookingIP],[IsHandler],[HandlerDate],[HandlerAdminID],[HandlerAdminName],[HandlerNote],[UserID],[UserName]";
pc.CurrentPage = currentPage;
pc.PageSize = pageSize;
pc.OrderField = "[ID]";
pc.OrderType = OrderType.Desc;
pc.MssqlCondition = PrepareCondition(bookingProductSearch);
count = pc.Count;
using (SqlDataReader dr = pc.ExecuteReader())
{
PrepareBookingProductModel(dr, bookingProductList);
}
return(bookingProductList);
}
/// <summary>
/// 搜索缺货登记数据列表
/// </summary>
/// <param name="currentPage">当前的页数</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="bookingProduct">BookingProductSearchInfo模型变量</param>
/// <param name="count">总数量</param>
/// <returns>缺货登记数据列表</returns>
public static List <BookingProductInfo> SearchBookingProductList(int currentPage, int pageSize, BookingProductSearchInfo bookingProduct, ref int count)
{
return(dal.SearchBookingProductList(currentPage, pageSize, bookingProduct, ref count));
}
/// <summary>
/// 搜索缺货登记数据列表
/// </summary>
/// <param name="bookingProduct">BookingProductSearchInfo模型变量</param>
/// <returns>缺货登记数据列表</returns>
public static List <BookingProductInfo> SearchBookingProductList(BookingProductSearchInfo bookingProduct)
{
return(dal.SearchBookingProductList(bookingProduct));
}
public List <BookingProductInfo> SearchBookingProductList(int currentPage, int pageSize, BookingProductSearchInfo bookingProductSearch, ref int count)
{
List <BookingProductInfo> bookingProductList = new List <BookingProductInfo>();
ShopMssqlPagerClass class2 = new ShopMssqlPagerClass();;
class2.TableName = ShopMssqlHelper.TablePrefix + "BookingProduct";
class2.Fields = "[ID],[ProductID],[ProductName],[RelationUser],[Email],[Tel],[UserNote],[BookingDate],[BookingIP],[IsHandler],[HandlerDate],[HandlerAdminID],[HandlerAdminName],[HandlerNote],[UserID],[UserName]";
class2.CurrentPage = currentPage;
class2.PageSize = pageSize;
class2.OrderField = "[ID]";
class2.OrderType = OrderType.Desc;
this.PrepareCondition(class2.MssqlCondition, bookingProductSearch);
class2.Count = count;
count = class2.Count;
using (SqlDataReader reader = class2.ExecuteReader())
{
this.PrepareBookingProductModel(reader, bookingProductList);
}
return(bookingProductList);
}
