82 lines
3.4 KiB
C#
82 lines
3.4 KiB
C#
|
using System;
|
|||
|
|
using System.Collections.Generic;
|
|||
|
|
using System.Web;
|
|||
|
|
using System.Web.UI;
|
|||
|
|
using System.Web.UI.WebControls;
|
|||
|
|
using System.Data;
|
|||
|
|
namespace Mtxfw.VipSite
|
|||
|
|
{
|
|||
|
|
public partial class Admin_Member_FHGL0 : Mtxfw.Utility.MemberBase
|
|||
|
|
{
|
|||
|
|
Mtxfw.DAL.user_Results_jl3 daojl3 = new Mtxfw.DAL.user_Results_jl3();
|
|||
|
|
Mtxfw.DAL.user_jjfp daojjfp = new Mtxfw.DAL.user_jjfp();
|
|||
|
|
Mtxfw.DAL.user_info daoUser = new Mtxfw.DAL.user_info();
|
|||
|
|
Mtxfw.Utility.Config config = new Mtxfw.Utility.Config("");
|
|||
|
|
Mtxfw.DAL.user_Results daoResults = new Mtxfw.DAL.user_Results();
|
|||
|
|
protected string JQFHCount = "0", JQFHCount0 = "0", JQFHCount1 = "0";
|
|||
|
|
public int gtype = 0;
|
|||
|
|
protected override void OnLoad(EventArgs e)
|
|||
|
|
{
|
|||
|
|
base.OnLoad(e);
|
|||
|
|
string hostname = Request.Url.Host;
|
|||
|
|
|
|||
|
|
if (!IsPostBack)
|
|||
|
|
{
|
|||
|
|
if (Session["IFPassword"] == null)
|
|||
|
|
{
|
|||
|
|
Response.Redirect("/Member_IFPassword.aspx?Url=/Admin_Member_FHGL0.aspx");
|
|||
|
|
}
|
|||
|
|
if (IFStores != 1)
|
|||
|
|
{
|
|||
|
|
Mtxfw.Utility.Tools.Message("您没有权限!", "/gl.aspx");
|
|||
|
|
}
|
|||
|
|
if (MemberJS.IndexOf("积分支付成本结算") == -1)
|
|||
|
|
{
|
|||
|
|
Mtxfw.Utility.Tools.Message("您没有权限!", "/gl.aspx");
|
|||
|
|
}
|
|||
|
|
Page.Title = "积分支付成本结算 - " + GetWebName;
|
|||
|
|
string strYJ = new DAL.user_jjfp().Getzd("count3", "TType=0").ToString();
|
|||
|
|
|
|||
|
|
if (strYJ != "")
|
|||
|
|
{
|
|||
|
|
JQFHCount = Convert.ToDouble(strYJ).ToString();
|
|||
|
|
}
|
|||
|
|
strYJ = new DAL.user_jjfp().Getzd("count4", "gtype=" + gtype + " and TType=0").ToString();
|
|||
|
|
if (strYJ != "")
|
|||
|
|
{
|
|||
|
|
JQFHCount0 = Convert.ToDouble(strYJ).ToString();
|
|||
|
|
}
|
|||
|
|
int atop10 = new DAL.user_info().GetCount("gtype=" + gtype + " and UserState='正常' And IFStores=0 and uLevel4=1");
|
|||
|
|
JQFHCount1 = (atop10).ToString();
|
|||
|
|
Data_Bind();
|
|||
|
|
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
MyPager.PageChanged += delegate(object s, EventArgs ex)
|
|||
|
|
{
|
|||
|
|
Data_Bind();
|
|||
|
|
};
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
protected void Data_Bind()
|
|||
|
|
{
|
|||
|
|
System.Text.StringBuilder sb = new System.Text.StringBuilder();
|
|||
|
|
String SJ = Request.QueryString["SJ"];
|
|||
|
|
String SJ2 = Request.QueryString["SJ2"];
|
|||
|
|
|
|||
|
|
if (!String.IsNullOrEmpty(SJ) && !String.IsNullOrEmpty(SJ2))
|
|||
|
|
{
|
|||
|
|
sb.Append("and (addtime between '" + SJ + " 00:00:00' and '" + SJ2 + " 23:59:59')");
|
|||
|
|
//sb.Append("and (CONVERT(varchar(100),DATEADD(mm,DATEDIFF(mm,0,dateadd(month,-1,addtime)),0),120)>=CONVERT(varchar(100),cast('" + SJ + " 00:00:00' as datetime),120) And CONVERT(varchar(100),dateadd(ms,-3,DATEADD(mm,DATEDIFF(m,0,dateadd(month,-1,addtime))+1,0)),120)<=CONVERT(varchar(100),cast('" + SJ2 + " 23:59:59' as datetime),120))");
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
string strOrder = " Order By addtime desc";
|
|||
|
|
MyPager.PageSize = 100;
|
|||
|
|
MyPager.RecordCount = daojjfp.GetCount("gtype=" + gtype + " and TType=2" + sb.ToString());
|
|||
|
|
Mtxfw.Utility.Tools.ToBind(Repeater1, daojjfp.GetPager(MyPager, "", "gtype=" + gtype + " and TType=2" + sb.ToString() + strOrder));
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
}
|