private void GetValue()
{
this.search = base.Request.QueryString["search"].ToString();
this.startTime = base.Request.QueryString["startTime"].ToString();
this.endTime = base.Request.QueryString["endTime"].ToString();
this.reportType = base.Request.QueryString["reportType"].ToString();
this.tzCase = base.Request.QueryString["tzCase"].ToString();
this.tzType = base.Request.QueryString["tzType"].ToString();
this.ballType = base.Request.QueryString["ballType"].ToString();
this.gdid = base.Request.QueryString["gdid"].ToString();
this.pathStr = "search=" + this.search;
this.pathStr = this.pathStr + "&startTime=" + this.startTime;
this.pathStr = this.pathStr + "&endTime=" + this.endTime;
this.pathStr = this.pathStr + "&reportType=" + this.reportType;
this.pathStr = this.pathStr + "&tzCase=" + this.tzCase;
this.pathStr = this.pathStr + "&tzType=" + this.tzType;
this.pathStr = this.pathStr + "&ballType=" + this.ballType;
this.creditSql = "select sum(mgd*csgd) as csmgd,zdlid,(select username from agence where userid =ball_order.zdlid) as zdlname,count(*) as tzNumber,sum(tzmoney) as tzmoney,sum(win-lose) as result,sum(mdls) as mdls,sum(mdls*csdls) as csmdls,sum(mzdl) as mzdl,sum(mzdl*cszdl) as csmzdl,sum(mgd) as mgd,isnull(sum(csdls)/count(*),0) as csdls,isnull(sum(cszdl)/count(*),0) as cszdl FROM ball_order WHERE userid in (select userid from member where usertype='信用' and gdid = '" + this.gdid + "') and gdid = '" + this.gdid + "' and datediff(s,'" + this.startTime + "',balltime) > 0 and datediff(d,balltime,'" + this.endTime + "') >= 0 and tzType in (" + MyFunc.GettzType(this.tzType) + ") group by zdlid";
this.cashSql = "select sum(mgd*csgd) as csmgd,zdlid,(select username from agence where userid =ball_order.zdlid) as zdlname,count(*) as tzNumber,sum(tzmoney) as tzmoney,sum(win-lose) as result,sum(mdls) as mdls,sum(mdls*csdls) as csmdls,sum(mzdl) as mzdl,sum(mzdl*cszdl) as csmzdl,sum(mgd) as mgd,isnull(sum(csdls)/count(*),0) as csdls,isnull(sum(cszdl)/count(*),0) as cszdl FROM ball_order WHERE userid in (select userid from member where usertype='现金' and gdid = '" + this.gdid + "') and gdid = '" + this.gdid + "' and datediff(s,'" + this.startTime + "',balltime) > 0 and datediff(d,balltime,'" + this.endTime + "') >= 0 and tzType in (" + MyFunc.GettzType(this.tzType) + ") group by zdlid";
}
private void GetValue()
{
this.search = base.Request.QueryString["search"].ToString();
this.startTime = base.Request.QueryString["startTime"].ToString();
this.endTime = base.Request.QueryString["endTime"].ToString();
this.tzType = base.Request.QueryString["tzType"].ToString();
this.username = base.Request.QueryString["username"].ToString();
this.pathStr = "?search=" + this.search;
this.pathStr = this.pathStr + "&startTime=" + this.startTime;
this.pathStr = this.pathStr + "&endTime=" + this.endTime;
this.pathStr = this.pathStr + "&username="******"&tzType=" + this.tzType;
this.creditSql = "SELECT od.csgd,od.tzmoney*od.csgd as csres,convert(numeric(5,2),od.hsuser_w) as hsuser_w,convert(numeric(5,2),od.hsuser_l) as hsuser_l,dbo.GettzType_Func(od.tzType) as tzTypeName,od.tzType as tzType,od.updatetime as updatetime,od.username as username,od.content as content,od.tzmoney as tzmoney,isnull((od.win-od.lose),0) as result,convert(numeric(7,3),od.curpl) as curpl,od.abc as abc,od.iscancel as iscancel,od.isdanger as isdanger FROM ball_order as od inner join member as mb on od.userid = mb.userid where datediff(s,'" + this.startTime + "',od.balltime) > 0 and datediff(d,od.balltime,'" + this.endTime + "') >= 0 and od.username = '******' and od.tzType in (" + MyFunc.GettzType(this.tzType) + ")";
this.cashSql = "SELECT od.csgd,od.tzmoney*od.csgd as csres,convert(numeric(5,2),od.hsuser_w) as hsuser_w,convert(numeric(5,2),od.hsuser_l) as hsuser_l,dbo.GettzType_Func(od.tzType) as tzTypeName,od.tzType as tzType,od.updatetime as updatetime,od.username as username,od.content as content,od.tzmoney as tzmoney,isnull((od.win-od.lose),0) as result,convert(numeric(7,3),od.curpl) as curpl,od.abc as abc,od.iscancel as iscancel,od.isdanger as isdanger FROM ball_order as od inner join member as mb on od.userid = mb.userid where datediff(s,'" + this.startTime + "',od.balltime) > 0 and datediff(d,od.balltime,'" + this.endTime + "') >= 0 and od.username = '******' and od.tzType in (" + MyFunc.GettzType(this.tzType) + ")";
this.sumCreditSql = "SELECT count(*) FROM ball_order WHERE datediff(s,'" + this.startTime + "',balltime) > 0 and datediff(d,balltime,'" + this.endTime + "') >= 0 and username = '******' and tzType in (" + MyFunc.GettzType(this.tzType) + ")";
this.sumCashSql = "SELECT count(*) FROM ball_order WHERE datediff(s,'" + this.startTime + "',balltime) > 0 and datediff(d,balltime,'" + this.endTime + "') >= 0 and username = '******' and tzType in (" + MyFunc.GettzType(this.tzType) + ")";
}
private void GetValue()
{
this.startTime = base.Request.QueryString["startTime"].ToString();
this.endTime = base.Request.QueryString["endTime"].ToString();
this.reportType = base.Request.QueryString["reportType"].ToString();
this.tzCase = base.Request.QueryString["tzCase"].ToString();
this.tzType = base.Request.QueryString["tzType"].ToString();
this.pathStr = "";
this.pathStr = this.pathStr + "&startTime=" + this.startTime;
this.pathStr = this.pathStr + "&endTime=" + this.endTime;
this.pathStr = this.pathStr + "&reportType=" + this.reportType;
this.pathStr = this.pathStr + "&tzCase=" + this.tzCase;
this.pathStr = this.pathStr + "&tzType=" + this.tzType;
this.pathStr = this.pathStr + "&ballType=" + this.ballType;
this.pathPartStr = "";
this.pathPartStr = this.pathPartStr + "&startTime=" + this.startTime;
this.pathPartStr = this.pathPartStr + "&endTime=" + this.endTime;
this.pathPartStr = this.pathPartStr + "&reportType=" + this.reportType;
this.pathStr = this.pathStr + "&tzCase=" + this.tzCase;
this.pathPartStr = this.pathPartStr + "&ballType=" + this.ballType;
this.creditSql = "select max(csgd) as csgd,max(1-csgd-cszdl-csdls) csgs,gdid,(select username from agence where userid =ball_order.gdid) as gdname,count(*) as tzNumber,sum(tzmoney) as tzmoney,sum(win-lose) as result,sum(mgd*(1-csgd-cszdl-csdls)) as mgs,sum(mgd) as mgd,isnull(sum(mgd*csgd),0) as csmgd,sum(mzdl) as mzdl,sum(mdls) as mdls FROM ball_order WHERE gdid in (" + this.Session.Contents["adminarrgd"].ToString().Trim() + "-1) and userid in (select userid from member where usertype='信用') and datediff(s,'" + this.startTime + "',balltime) > 0 and datediff(d,balltime,'" + this.endTime + "') >= 0 and tzType in (" + MyFunc.GettzType(this.tzType) + ") group by gdid";
this.cashSql = "select max(csgd) as csgd,max(1-csgd-cszdl-csdls) csgs,gdid,(select username from agence where userid =ball_order.gdid) as gdname,count(*) as tzNumber,sum(tzmoney) as tzmoney,sum(win-lose) as result,sum(mgd*(1-csgd-cszdl-csdls)) as mgs,sum(mgd) as mgd,isnull(sum(mgd*csgd),0) as csmgd,sum(mzdl) as mzdl,sum(mdls) as mdls FROM ball_order WHERE gdid in (" + this.Session.Contents["adminarrgd"].ToString().Trim() + "-1) and userid in (select userid from member where usertype='现金') and datediff(s,'" + this.startTime + "',balltime) > 0 and datediff(d,balltime,'" + this.endTime + "') >= 0 and tzType in (" + MyFunc.GettzType(this.tzType) + ") group by gdid";
this.allSql = "SELECT count(*) as tzNumber,sum(tzmoney) as tzmoney,sum(win-lose) as result,sum(mgd*(1-csgd-cszdl-csdls)) as mgs,sum(mgd) as mgd,sum(mzdl) as mzdl,sum(mdls) as mdls FROM ball_order WHERE gdid in (" + this.Session.Contents["adminarrgd"].ToString().Trim() + "-1) and datediff(s,'" + this.startTime + "',balltime) > 0 and datediff(d,balltime,'" + this.endTime + "') >= 0 and tzType in (" + MyFunc.GettzType(this.tzType) + ")";
this.creditPartSql = "SELECT max(csgd) as csgd,max(1-csgd-cszdl-csdls) csgs,dbo.GettzType_Func(tzType) as tzTypeName,tzType,count(*) as tzNumber,sum(tzmoney) as tzmoney,sum(win-lose) as result,sum(mgd*(1-csgd-cszdl-csdls)) as mgs,sum(mzdl) as mzdl,sum(mdls) as mdls,sum(mgd) as mgd,isnull(sum(mgd*csgd),0) as csmgd FROM ball_order WHERE gdid in (" + this.Session.Contents["adminarrgd"].ToString().Trim() + "-1) and userid in (select userid from member where usertype='信用') and datediff(s,'" + this.startTime + "',balltime) > 0 and datediff(d,balltime,'" + this.endTime + "') >= 0 and tzType in (" + MyFunc.GettzType(this.tzType) + ") group by tzType";
this.cashPartSql = "SELECT max(csgd) as csgd,max(1-csgd-cszdl-csdls) csgs,dbo.GettzType_Func(tzType) as tzTypeName,tzType,count(*) as tzNumber,sum(tzmoney) as tzmoney,sum(win-lose) as result,sum(mgd*(1-csgd-cszdl-csdls)) as mgs,sum(mzdl) as mzdl,sum(mdls) as mdls,sum(mgd) as mgd,isnull(sum(mgd*csgd),0) as csmgd FROM ball_order WHERE gdid in (" + this.Session.Contents["adminarrgd"].ToString().Trim() + "-1) and userid in (select userid from member where usertype='现金') and datediff(s,'" + this.startTime + "',balltime) > 0 and datediff(d,balltime,'" + this.endTime + "') >= 0 and tzType in (" + MyFunc.GettzType(this.tzType) + ") group by tzType";
this.allPartSql = "SELECT count(*) as tzNumber,sum(tzmoney) as tzmoney,sum(win-lose) as result,sum(mgd*(1-csgd-cszdl-csdls)) as mgs,sum(mgd) as mgd,sum(mzdl) as mzdl,sum(mdls) as mdls FROM ball_order WHERE gdid in (" + this.Session.Contents["adminarrgd"].ToString().Trim() + "-1) and datediff(s,'" + this.startTime + "',balltime) > 0 and datediff(d,balltime,'" + this.endTime + "') >= 0 and tzType in (" + MyFunc.GettzType(this.tzType) + ")";
}
private void GetValue()
{
this.startTime = base.Request.QueryString["startTime"].ToString();
this.endTime = base.Request.QueryString["endTime"].ToString();
this.reportType = base.Request.QueryString["reportType"].ToString();
this.tzCase = base.Request.QueryString["tzCase"].ToString();
this.tzType = base.Request.QueryString["tzType"].ToString();
this.pathStr = "";
this.pathStr = this.pathStr + "&startTime=" + this.startTime;
this.pathStr = this.pathStr + "&endTime=" + this.endTime;
this.pathStr = this.pathStr + "&reportType=" + this.reportType;
this.pathStr = this.pathStr + "&tzCase=" + this.tzCase;
this.pathStr = this.pathStr + "&tzType=" + this.tzType;
this.pathStr = this.pathStr + "&ballType=" + this.ballType;
this.pathPartStr = "";
this.pathPartStr = this.pathPartStr + "&startTime=" + this.startTime;
this.pathPartStr = this.pathPartStr + "&endTime=" + this.endTime;
this.pathPartStr = this.pathPartStr + "&reportType=" + this.reportType;
this.pathStr = this.pathStr + "&tzCase=" + this.tzCase;
this.pathPartStr = this.pathPartStr + "&ballType=" + this.ballType;
this.creditSql = "select sum(mzdl*cszdl) as csmzdl,sum(mdls*csdls) as csmdls,dlsid,(select username from agence where userid =ball_order.dlsid) as dlsname,count(*) as tzNumber,sum(tzmoney) as tzmoney,sum(win-lose) as result,sum(mzdl) as mzdl,sum(cszdl)/count(*) as cszdl,sum(mdls) as mdls,sum(csdls)/count(*) as csdls FROM ball_order WHERE userid in (select userid from member where usertype='信用' and zdlid = '" + this.Session.Contents["adminuserid"].ToString() + "') and zdlid = '" + this.Session.Contents["adminuserid"].ToString() + "' and datediff(s,'" + this.startTime + "',balltime) > 0 and datediff(d,balltime,'" + this.endTime + "') >= 0 and tzType in (" + MyFunc.GettzType(this.tzType) + ") group by dlsid";
this.cashSql = "select sum(mzdl*cszdl) as csmzdl,sum(mdls*csdls) as csmdls,dlsid,(select username from agence where userid =ball_order.dlsid) as dlsname,count(*) as tzNumber,sum(tzmoney) as tzmoney,sum(win-lose) as result,sum(mzdl) as mzdl,sum(cszdl)/count(*) as cszdl,sum(mdls) as mdls,sum(csdls)/count(*) as csdls FROM ball_order WHERE userid in (select userid from member where usertype='现金' and zdlid = '" + this.Session.Contents["adminuserid"].ToString() + "') and zdlid = '" + this.Session.Contents["adminuserid"].ToString() + "' and datediff(s,'" + this.startTime + "',balltime) > 0 and datediff(d,balltime,'" + this.endTime + "') >= 0 and tzType in (" + MyFunc.GettzType(this.tzType) + ") group by dlsid";
this.allSql = "SELECT count(*) as tzNumber,sum(tzmoney) as tzmoney,sum(win-lose) as result,sum(mzdl) as mzdl,sum(mdls) as mdls FROM ball_order WHERE zdlid = '" + this.Session.Contents["adminuserid"].ToString() + "' and datediff(s,'" + this.startTime + "',balltime) > 0 and datediff(d,balltime,'" + this.endTime + "') >= 0 and tzType in (" + MyFunc.GettzType(this.tzType) + ")";
this.creditPartSql = "SELECT sum(mzdl*cszdl) as csmzdl,sum(mdls*csdls) as csmdls,dbo.GettzType_Func(tzType) as tzTypeName,tzType,count(*) as tzNumber,sum(tzmoney) as tzmoney,sum(win-lose) as result,sum(mzdl) as mzdl,sum(cszdl)/count(*) as cszdl,sum(mdls) as mdls,sum(csdls)/count(*) as csdls FROM ball_order WHERE userid in (select userid from member where usertype='信用' and zdlid = '" + this.Session.Contents["adminuserid"].ToString() + "') and zdlid = '" + this.Session.Contents["adminuserid"].ToString() + "' and datediff(s,'" + this.startTime + "',balltime) > 0 and datediff(d,balltime,'" + this.endTime + "') >= 0 and tzType in (" + MyFunc.GettzType(this.tzType) + ") group by tzType";
this.cashPartSql = "SELECT sum(mzdl*cszdl) as csmzdl,sum(mdls*csdls) as csmdls,dbo.GettzType_Func(tzType) as tzTypeName,tzType,count(*) as tzNumber,sum(tzmoney) as tzmoney,sum(win-lose) as result,sum(mzdl) as mzdl,sum(cszdl)/count(*) as cszdl,sum(mdls) as mdls,sum(csdls)/count(*) as csdls FROM ball_order WHERE userid in (select userid from member where usertype='现金' and zdlid = '" + this.Session.Contents["adminuserid"].ToString() + "') and zdlid = '" + this.Session.Contents["adminuserid"].ToString() + "' and datediff(s,'" + this.startTime + "',balltime) > 0 and datediff(d,balltime,'" + this.endTime + "') >= 0 and tzType in (" + MyFunc.GettzType(this.tzType) + ") group by tzType";
this.allPartSql = "SELECT count(*) as tzNumber,sum(tzmoney) as tzmoney,sum(win-lose) as result,sum(mzdl) as mzdl,sum(mdls) as mdls,sum(mgd) as mgd FROM ball_order WHERE zdlid = '" + this.Session.Contents["adminuserid"].ToString() + "' and datediff(s,'" + this.startTime + "',balltime) > 0 and datediff(d,balltime,'" + this.endTime + "') >= 0 and tzType in (" + MyFunc.GettzType(this.tzType) + ")";
}
private void CashDeal()
{
string text = "";
string sql = "";
string text3 = "";
DataBase db = new DataBase(MyFunc.GetConnStr(2));
text = "SELECT username,count(*) as tzNumber,sum(tzmoney) as tzmoney,sum(tzmoney*truewin) as realtzmoney,sum(win-lose) as result,sum(mzdl) as mzdl,sum(mdls) as mdls FROM ball_order_view WHERE userid in (select userid from member where usertype='信用' and dlsid = '" + this.Session.Contents["adminuserid"].ToString() + "') and dlsid = '" + this.Session.Contents["adminuserid"].ToString() + "' and (updatetime between '" + this.startTime + "' and '" + this.endTime + "') and tzType in (" + MyFunc.GettzType(this.tzType) + ") group by username";
sql = "SELECT username,count(*) as tzNumber,sum(tzmoney) as tzmoney,sum(tzmoney*truewin) as realtzmoney,sum(win-lose) as result,sum(mzdl) as mzdl,sum(mdls) as mdls FROM ball_order_view WHERE userid in (select userid from member where usertype='现金' and dlsid = '" + this.Session.Contents["adminuserid"].ToString() + "') and dlsid = '" + this.Session.Contents["adminuserid"].ToString() + "' and (updatetime between '" + this.startTime + "' and '" + this.endTime + "') and tzType in (" + MyFunc.GettzType(this.tzType) + ") group by username";
text3 = "SELECT count(*) as tzNumber,sum(tzmoney) as tzmoney,sum(tzmoney*truewin) as realtzmoney,sum(win-lose) as result,sum(mzdl) as mzdl,sum(mdls) as mdls FROM ball_order_view WHERE userid in (select userid from member where usertype='现金' and dlsid = '" + this.Session.Contents["adminuserid"].ToString() + "') and dlsid = '" + this.Session.Contents["adminuserid"].ToString() + "' and (updatetime between '" + this.startTime + "' and '" + this.endTime + "') and tzType in (" + MyFunc.GettzType(this.tzType) + ")";
switch (this.reportType.ToLower())
{
case "ledger":
this.tableHeader.Visible = false;
this.ShowCashContent(db, sql);
this.ShowZongShuContent(db, text3);
goto Label_02F7;
case "breakdown":
this.tableHeader.Visible = false;
this.ShowCashContent(db, sql);
this.tableBottom.Visible = false;
goto Label_02F7;
case "soccer":
this.tableHeader.Visible = false;
this.ShowCashContent(db, sql);
this.ShowZongShuContent(db, text3);
break;
case "basketball":
this.tableHeader.Visible = false;
this.tableMiddle.Visible = false;
this.tableBottom.Visible = false;
break;
}
Label_02F7:
db.CloseConnect();
db.Dispose();
}
