public MssqlCondition PrepareCondition(OrderRefundSearchInfo searchInfo)
{
MssqlCondition mssqlCondition = new MssqlCondition();
mssqlCondition.Add("[RefundNumber]", searchInfo.RefundNumber, ConditionType.Like);
mssqlCondition.Add("[OrderNumber]", searchInfo.OrderNumber, ConditionType.Like);
mssqlCondition.Add("[Status]", searchInfo.Status, ConditionType.Equal);
mssqlCondition.Add("[TmCreate]", searchInfo.StartTmCreate, ConditionType.MoreOrEqual);
mssqlCondition.Add("[TmCreate]", searchInfo.EndTmCreate, ConditionType.Less);
mssqlCondition.Add("[OwnerId]", searchInfo.OwnerId, ConditionType.Equal);
return(mssqlCondition);
}
protected override void PageLoad()
{
base.PageLoad();
OrderRefundSearchInfo searchInfo = new OrderRefundSearchInfo();
searchInfo.RefundNumber = RequestHelper.GetQueryString <string>("RefundNumber");
searchInfo.OrderNumber = RequestHelper.GetQueryString <string>("OrderNumber");
searchInfo.Status = RequestHelper.GetQueryString <int>("Status");
searchInfo.StartTmCreate = RequestHelper.GetQueryString <DateTime>("StartAddDate");
searchInfo.EndTmCreate = RequestHelper.GetQueryString <DateTime>("EndAddDate");
orderRefundList = OrderRefundBLL.SearchList(1, pageSize, searchInfo, ref Count);
allOrderList = OrderBLL.ReadList();
topNav = 0;
}
public List <OrderRefundInfo> SearchList(int currentPage, int pageSize, OrderRefundSearchInfo searchInfo, ref int count)
{
using (var conn = new SqlConnection(connectString))
{
ShopMssqlPagerClass pc = new ShopMssqlPagerClass();
pc.TableName = "OrderRefund";
pc.Fields = "*";
pc.CurrentPage = currentPage;
pc.PageSize = pageSize;
pc.OrderField = "[Id]";
pc.OrderType = OrderType.Desc;
pc.MssqlCondition = PrepareCondition(searchInfo);
count = pc.Count;
return(conn.Query <OrderRefundInfo>(pc).ToList());
}
}
protected void Page_Load(object sender, EventArgs e)
{
CheckAdminPower("ReadOrderRefund", PowerCheckType.Single);
string action = RequestHelper.GetQueryString <string>("Action");
if (!Page.IsPostBack)
{
enumList = EnumHelper.ReadEnumList <OrderRefundStatus>();
Status.DataTextField = "ChineseName";
Status.DataValueField = "Value";
Status.DataSource = enumList;
Status.DataBind();
Status.Items.Insert(0, new ListItem {
Text = "所有状态", Value = int.MinValue.ToString()
});
RefundNumber.Text = RequestHelper.GetQueryString <string>("RefundNumber");
OrderNumber.Text = RequestHelper.GetQueryString <string>("OrderNumber");
Status.Text = RequestHelper.GetQueryString <string>("Status");
StartAddDate.Text = RequestHelper.GetQueryString <string>("StartAddDate");
EndAddDate.Text = RequestHelper.GetQueryString <string>("EndAddDate");
OrderRefundSearchInfo searchInfo = new OrderRefundSearchInfo();
searchInfo.RefundNumber = RequestHelper.GetQueryString <string>("RefundNumber");
searchInfo.OrderNumber = RequestHelper.GetQueryString <string>("OrderNumber");
searchInfo.Status = RequestHelper.GetQueryString <int>("Status");
searchInfo.StartTmCreate = RequestHelper.GetQueryString <DateTime>("StartAddDate");
searchInfo.EndTmCreate = RequestHelper.GetQueryString <DateTime>("EndAddDate");
var orderRefundList = OrderRefundBLL.SearchList(CurrentPage, PageSize, searchInfo, ref Count);
BindControl(orderRefundList, RecordList, MyPager);
intStatus = searchInfo.Status;
}
}
public static List <OrderRefundInfo> SearchList(int currentPage, int pageSize, OrderRefundSearchInfo searchInfo, ref int count)
{
return(dal.SearchList(currentPage, pageSize, searchInfo, ref count));
}
