コード例 #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                this.txtStartDate.Text = DateTime.Now.ToString("yyyy-MM-01");
                this.txtEndDate.Text   = DateTime.Now.ToString("yyyy-MM-dd");

                BindSpreadRecordData();
            }

            StringBuilder sWhere = new StringBuilder();

            sWhere.AppendFormat(" WHERE UserID = {0} AND Score < 0 ", Fetch.GetUserCookie().UserID);

            if (txtStartDate.Text.Trim() != "")
            {
                sWhere.AppendFormat(" AND CollectDate >= '{0}' ", CtrlHelper.GetText(txtStartDate) + " 00:00:00");
            }

            if (txtEndDate.Text.Trim() != "")
            {
                sWhere.AppendFormat(" AND CollectDate < '{0}'", Convert.ToDateTime(CtrlHelper.GetText(txtEndDate)).AddDays(1));
            }

            total = (0 - treasureFacade.GetUserSpreaderTotal(sWhere.ToString())).ToString("N");

            Themes.Standard.Common_Header sHeader = (Themes.Standard.Common_Header) this.FindControl("sHeader");
            sHeader.title = "会员中心";
        }