protected void Page_Load(object sender, EventArgs e)
{
//设置左边菜单
var mst = this.Master as Member_Manage_MasterPage;
mst.SetMenuTitle("交易管理", "已卖出的货品");
string act=Request["action"];
if (!string.IsNullOrEmpty(act))
{
switch (act)
{
case "pager":
BindData();
break;
case "od_det":
var bl = new DS_Orders_Br();
var js = new System.Web.Script.Serialization.JavaScriptSerializer();
var md = bl.GetSingle(int.Parse(Request["id"]));
Response.Write(js.Serialize(md));
Response.End();
break;
case "del":
var oddbl = new DS_OrderDetail_Br();
oddbl.Delete(int.Parse(Request.Form["id"]));
Response.End();
break;
}
return;
}
if (IsPostBack) return;
BindData();
}
private void BindData()
{
string orderNum = Request["orderNum"], startDate = Request["startDate"], endDate = Request["endDate"], orderState = Request["orderState"], proName = Request["proName"], pageIndex = Request["pageIndex"], pageSize = Request["pageSize"];
var bl = new DS_OrderDetail_Br();
var sql = new System.Text.StringBuilder();
var param = new object[6];
sql.Append("memberid=@0");
param[0] = _userData.Member.ID;
if (!string.IsNullOrEmpty(orderNum))
{
sql.Append(" and OrderNum=@1");
param[1] = orderNum.Trim();
}
else
{
if (!string.IsNullOrEmpty(startDate))
{
sql.Append(" and CreateDate>=@2");
param[2] = DateTime.Parse(startDate);
}
if (!string.IsNullOrEmpty(endDate))
{
sql.Append(" and CreateDate<@3");
param[3] = DateTime.Parse(endDate).AddDays(1);
}
if (!string.IsNullOrEmpty(orderState))
{
sql.Append(" and State=@4");
param[4] = byte.Parse(orderState);
}
if (!string.IsNullOrEmpty(proName))
{
sql.Append(" and ProName.Contains(@5)");
param[5] = proName.Trim();
}
}
int recordCount = 0, _pageIndex = string.IsNullOrEmpty(pageIndex) ? 1 : int.Parse(pageIndex), _pageSize = string.IsNullOrEmpty(pageSize) ? 3 : int.Parse(pageSize);
Repeater1.DataSource = bl.Query(sql.ToString(), "id desc", (_pageIndex - 1) * _pageSize, _pageSize, ref recordCount, param);
Repeater1.DataBind();
ViewState["rc"] = recordCount;
}
private void BindData()
{
string orderNum = Request["orderNum"], startDate = Request["startDate"], endDate = Request["endDate"], orderState = Request["orderState"], proName = Request["proName"],pageIndex=Request["pageIndex"],pageSize=Request["pageSize"];
var bl = new DS_OrderDetail_Br();
var sql = new System.Text.StringBuilder();
var param=new object[6];
sql.Append("memberid=@0");
param[0] = _userData.Member.ID;
if (!string.IsNullOrEmpty(orderNum))
{
sql.Append(" and OrderNum=@1");
param[1] = orderNum.Trim();
}
else
{
if (!string.IsNullOrEmpty(startDate))
{
sql.Append(" and CreateDate>=@2");
param[2] = DateTime.Parse(startDate);
}
if (!string.IsNullOrEmpty(endDate))
{
sql.Append(" and CreateDate<@3");
param[3] = DateTime.Parse(endDate).AddDays(1);
}
if (!string.IsNullOrEmpty(orderState))
{
sql.Append(" and State=@4");
param[4] = byte.Parse(orderState);
}
if (!string.IsNullOrEmpty(proName))
{
sql.Append(" and ProName.Contains(@5)");
param[5] = proName.Trim();
}
}
int recordCount = 0, _pageIndex = string.IsNullOrEmpty(pageIndex) ? 1 : int.Parse(pageIndex), _pageSize = string.IsNullOrEmpty(pageSize) ? 3 : int.Parse(pageSize);
Repeater1.DataSource = bl.Query(sql.ToString(), "id desc", (_pageIndex - 1) * _pageSize, _pageSize, ref recordCount, param);
Repeater1.DataBind();
ViewState["rc"] = recordCount;
}
protected void Page_Load(object sender, EventArgs e)
{
//设置左边菜单
var mst = this.Master as Member_Manage_MasterPage;
mst.SetMenuTitle("交易管理", "已卖出的货品");
string act = Request["action"];
if (!string.IsNullOrEmpty(act))
{
switch (act)
{
case "pager":
BindData();
break;
case "od_det":
var bl = new DS_Orders_Br();
var js = new System.Web.Script.Serialization.JavaScriptSerializer();
var md = bl.GetSingle(int.Parse(Request["id"]));
Response.Write(js.Serialize(md));
Response.End();
break;
case "del":
var oddbl = new DS_OrderDetail_Br();
oddbl.Delete(int.Parse(Request.Form["id"]));
Response.End();
break;
}
return;
}
if (IsPostBack)
{
return;
}
BindData();
}
