private string GetAllMoneyByType(string type)
{
string str = string.Empty;
ShowShop.BLL.Member.UserInfoNote noteBll = new ShowShop.BLL.Member.UserInfoNote();
ChangeHope.DataBase.DataByPage dataPage = null;
decimal money = 0;
StringBuilder shtml = new StringBuilder();
switch (type)
{
case "in":
shtml.Append("当前页面总收入：");
dataPage = noteBll.GetListByWhere(" noteType=1 and buckleOrAdd=0 ");
if(dataPage.DataReader!=null)
{
while(dataPage.DataReader.Read())
{
money += Convert.ToDecimal(dataPage.DataReader["ticketCount"]);
}
}
break;
case "out":
shtml.Append("当前页面总支出：");
dataPage = noteBll.GetListByWhere(" noteType=1 and buckleOrAdd=1 ");
if (dataPage.DataReader != null)
{
while (dataPage.DataReader.Read())
{
money += Convert.ToDecimal(dataPage.DataReader["ticketCount"]);
}
}
break;
default:
break;
}
shtml.Append("<span style='color:Red'>"+money.ToString() + "</span>元");
return shtml.ToString();
}
/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
protected string GetList(string strWhere)
{
// noteType =0
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.Member.UserInfoNote bll = new ShowShop.BLL.Member.UserInfoNote();
ChangeHope.DataBase.DataByPage dataPage = bll.GetListByWhere(strWhere);
//第一步先添加表头
table.AddHeadCol("", "序号");
table.AddHeadCol("", "用户账号");
table.AddHeadCol("", "录入时间");
table.AddHeadCol("", "增加点卷");
table.AddHeadCol("", "减少点卷");
table.AddHeadCol("", "操作员");
table.AddHeadCol("", "备注/说明");
table.AddHeadCol("", "操作");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
if (curpage < 0)
{
curpage = 1;
}
int count = 0;
while (dataPage.DataReader.Read())
{
count++;
string No = (15 * (curpage - 1) + count).ToString();
table.AddCol(No);
table.AddCol(GetUserID(Convert.ToInt32(dataPage.DataReader["userId"].ToString())));
table.AddCol(dataPage.DataReader["noteDate"].ToString());
table.AddCol(dataPage.DataReader["buckleOrAdd"].ToString() == "0" ? dataPage.DataReader["ticketCount"].ToString() : string.Empty);
table.AddCol(dataPage.DataReader["buckleOrAdd"].ToString() == "1" ? dataPage.DataReader["ticketCount"].ToString() : string.Empty);
table.AddCol(dataPage.DataReader["noteName"].ToString());
table.AddCol(dataPage.DataReader["causation"].ToString());
table.AddCol(string.Format("<a href=coupons_record_view.aspx?id={0}>查看</a>", dataPage.DataReader["id"].ToString()));
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return view;
}
private string GetList(string where)
{
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.Member.UserInfoNote noteBll = new ShowShop.BLL.Member.UserInfoNote();
ChangeHope.DataBase.DataByPage dataPage = noteBll.GetListByWhere(where);
table.AddHeadCol("", "序号");
table.AddHeadCol("","交易日期");
table.AddHeadCol("","会员帐号");
table.AddHeadCol("","收入金额");
table.AddHeadCol("","支出金额");
table.AddHeadCol("","操作人员");
table.AddHeadCol("","备注/原因");
table.AddHeadCol("","操作");
table.AddRow();
if(dataPage.DataReader!=null)
{
int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
if (curpage < 0)
{
curpage = 1;
}
int count = 0;
while (dataPage.DataReader.Read())
{
count++;
string No = (15 * (curpage - 1) + count).ToString();
table.AddCol(No);
table.AddCol(dataPage.DataReader["noteDate"].ToString());
table.AddCol(dataPage.DataReader["userName"].ToString());
table.AddCol(dataPage.DataReader["buckleOrAdd"].ToString()=="0" ? dataPage.DataReader["ticketCount"].ToString() : "");
table.AddCol(dataPage.DataReader["buckleOrAdd"].ToString()=="1" ? dataPage.DataReader["ticketCount"].ToString() : "");
table.AddCol(dataPage.DataReader["noteName"].ToString());
table.AddCol(dataPage.DataReader["causation"].ToString());
table.AddCol("<a href='coupons_record_view.aspx?id=" + dataPage.DataReader["id"].ToString() + "'>查看</a>");
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return view;
}
/// <summary>
/// 绑定TABLE
/// </summary>
/// <param name="where"></param>
/// <returns></returns>
public string GetListByWhere(string where)
{
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.Member.UserInfoNote noteBll = new ShowShop.BLL.Member.UserInfoNote();
ChangeHope.DataBase.DataByPage dataPage = noteBll.GetListByWhere(where);
table.AddHeadCol("","用户名");
table.AddHeadCol("","时间");
table.AddHeadCol("","添加日期");
table.AddHeadCol("","减少日期");
table.AddHeadCol("","操作人员");
table.AddHeadCol("","备注/原因");
table.AddHeadCol("","操作");
table.AddRow();
if (dataPage.DataReader != null)
{
while (dataPage.DataReader.Read())
{
table.AddCol(dataPage.DataReader["userName"].ToString());
table.AddCol(dataPage.DataReader["noteDate"].ToString());
table.AddCol(dataPage.DataReader["buckleOrAdd"].ToString() == "0" ? dataPage.DataReader["ticketCount"].ToString() : "");
table.AddCol(dataPage.DataReader["buckleOrAdd"].ToString() == "1" ? dataPage.DataReader["ticketCount"].ToString() : "");
table.AddCol(dataPage.DataReader["noteName"].ToString());
table.AddCol(dataPage.DataReader["causation"].ToString());
table.AddCol("<a href='coupons_record_view.aspx?id=" + dataPage.DataReader["id"].ToString() + "'>查看</a>");
table.AddRow();
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return view;
}
else
{
return "抱歉没有符合您要求的信息！";
}
}