//初始列表
private void BindItemGrid()
{
DateTime now = Convert.ToDateTime(curDate).Date;
switch (showType)
{
case "a":
beginDate = DateHelper.GetSqlMinDate();
endDate = DateHelper.GetSqlMaxDate();
break;
case "d":
beginDate = DateHelper.GetCurDate(now);
endDate = DateHelper.GetCurDate(now);
break;
case "w":
beginDate = DateHelper.GetWeekFirst(now);
endDate = DateHelper.GetWeekLast(now);
break;
case "m":
beginDate = DateHelper.GetMonthFirst(now);
endDate = DateHelper.GetMonthLast(now);
break;
case "y":
beginDate = DateHelper.GetYearFirst(now);
endDate = DateHelper.GetYearLast(now);
break;
}
string query = "1=1";
if (keywords != "")
{
query = "ItemName like '%" + keywords + "%'";
}
DataTable newlists = new DataTable();
lists = bll.GetItemListByGroup(userId, beginDate, endDate, query, groupType, "asc");
if (lists.Rows.Count > 0)
{
lists.DefaultView.Sort = string.Format("{0} {1}", sort, by);
}
this.GroupList.DataSource = lists;
this.GroupList.DataBind();
//更新总价
UpdateTotal(lists);
}
private void PopulateControls()
{
int userId = Convert.ToInt32(Session["UserID"]);
string begin = Request.QueryString["begin"];
string end = Request.QueryString["end"];
string query = Request.QueryString["query"];
string sub = Request.QueryString["sub"];
string sort = Request.QueryString["sort"];
string by = Request.QueryString["by"];
ItemTableBLL bll = new ItemTableBLL();
DataTable newlists = new DataTable();
DataTable lists = bll.GetItemListByGroup(userId, Convert.ToDateTime(begin), Convert.ToDateTime(end), query, sub, "asc");
if (lists.Rows.Count > 0)
{
DataRow[] rows = lists.Select("1=1", string.Format("{0} {1}", sort, by));
if (rows.Length > 0)
{
newlists = rows.CopyToDataTable();
}
}
StringBuilder items = new StringBuilder();
items.Append("<table border=\"0\" class=\"tablelist\">");
if (lists.Rows.Count > 0)
{
foreach (DataRow dr in newlists.Rows)
{
items.Append("<tr>");
items.Append("<td style=\"width:140px;\">" + dr["MyLabel"].ToString() + "</td>");
items.Append("<td style=\"width:100px;\" class=\"countcolor\">" + dr["CountNum"].ToString() + "</td>");
items.Append("<td style=\"width:100px;\" class=\"shoucolor\">" + QueryHelper.GetPriceDot(dr["ShouRuPrice"], "sr") + "</td>");
items.Append("<td style=\"width:100px;\" class=\"zhicolor\">" + QueryHelper.GetPriceDot(dr["ZhiChuPrice"], "zc") + "</td>");
items.Append("<td style=\"width:100px;\" class=\"shoucolor\">" + QueryHelper.GetPriceDot(dr["JieRuPrice"], "jr") + "</td>");
items.Append("<td style=\"width:100px;\" class=\"zhicolor\">" + QueryHelper.GetPriceDot(dr["HuanChuPrice"], "hc") + "</td>");
items.Append("<td style=\"width:100px;\" class=\"shoucolor\">" + QueryHelper.GetPriceDot(dr["HuanRuPrice"], "hr") + "</td>");
items.Append("<td style=\"width:100px;\" class=\"zhicolor\">" + QueryHelper.GetPriceDot(dr["JieChuPrice"], "jc") + "</td>");
if (sub == "ItemBuyDate")
{
items.Append("<td class=\"cellleft\"><a href=\"ItemQuery.aspx?date=" + dr["MyLabel"].ToString() + "&showType=d\" class=\"baselink\">查看</a></td>");
}
else if (sub == "ItemName")
{
items.Append("<td class=\"cellleft\"><a href=\"javascript:void(0);\" class=\"itemdown baselink\" ref=\"" + dr["MyLabel"].ToString() + "\" query=\"" + query + "\">展开</a></td>");
}
else
{
items.Append("<td class=\"cellleft\"><a href=\"javascript:void(0);\" class=\"detaildown baselink\" ref=\"" + dr["MyLabel"].ToString() + "\" query=\"" + query + "\">展开</a></td>");
}
items.Append("</tr>");
}
}
else
{
items.Append("<tr>");
items.Append("<td colspan=\"9\">没有消费记录。</td>");
items.Append("</tr>");
}
items.Append("</table>");
Response.Write(items.ToString());
Response.End();
}
private void PopulateControls()
{
int userId = Convert.ToInt32(Session["UserID"]);
string begin = Request.QueryString["begin"];
string end = Request.QueryString["end"];
string query = Request.QueryString["query"];
string sub = Request.QueryString["sub"];
string sort = Request.QueryString["sort"];
string by = Request.QueryString["by"];
ItemTableBLL bll = new ItemTableBLL();
DataTable newlists = new DataTable();
DataTable lists = bll.GetItemListByGroup(userId, Convert.ToDateTime(begin), Convert.ToDateTime(end), query, sub, "asc");
if (lists.Rows.Count > 0)
{
DataRow[] rows = lists.Select("1=1", string.Format("{0} {1}", sort, by));
if (rows.Length > 0)
{
newlists = rows.CopyToDataTable();
}
}
StringBuilder items = new StringBuilder();
items.Append("<table border=\"0\" class=\"tablelist\">");
if (lists.Rows.Count > 0)
{
foreach (DataRow dr in newlists.Rows)
{
items.Append("<tr>");
items.Append("<td style=\"width:140px;\">" + dr["MyLabel"].ToString() + "</td>");
items.Append("<td style=\"width:100px;\" class=\"countcolor\">" + dr["CountNum"].ToString() + "</td>");
items.Append("<td style=\"width:100px;\" class=\"shoucolor\">" + QueryHelper.GetPriceDot(dr["ShouRuPrice"], "sr") + "</td>");
items.Append("<td style=\"width:100px;\" class=\"zhicolor\">" + QueryHelper.GetPriceDot(dr["ZhiChuPrice"], "zc") + "</td>");
items.Append("<td style=\"width:100px;\" class=\"shoucolor\">" + QueryHelper.GetPriceDot(dr["JieRuPrice"], "jr") + "</td>");
items.Append("<td style=\"width:100px;\" class=\"zhicolor\">" + QueryHelper.GetPriceDot(dr["HuanChuPrice"], "hc") + "</td>");
items.Append("<td style=\"width:100px;\" class=\"shoucolor\">" + QueryHelper.GetPriceDot(dr["HuanRuPrice"], "hr") + "</td>");
items.Append("<td style=\"width:100px;\" class=\"zhicolor\">" + QueryHelper.GetPriceDot(dr["JieChuPrice"], "jc") + "</td>");
if (sub == "ItemBuyDate")
{
items.Append("<td class=\"cellleft\"><a href=\"ItemQuery.aspx?date=" + dr["MyLabel"].ToString() + "&showType=d\" class=\"baselink\">查看</a></td>");
}
else if (sub == "ItemName")
{
items.Append("<td class=\"cellleft\"><a href=\"javascript:void(0);\" class=\"itemdown baselink\" ref=\"" + dr["MyLabel"].ToString() + "\" query=\"" + query + "\">展开</a></td>");
}
else
{
items.Append("<td class=\"cellleft\"><a href=\"javascript:void(0);\" class=\"detaildown baselink\" ref=\"" + dr["MyLabel"].ToString() + "\" query=\"" + query + "\">展开</a></td>");
}
items.Append("</tr>");
}
}
else
{
items.Append("<tr>");
items.Append("<td colspan=\"9\">没有消费记录。</td>");
items.Append("</tr>");
}
items.Append("</table>");
Response.Write(items.ToString());
Response.End();
}