Exemplo n.º 1
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!base.IsPostBack)
     {
         Chain.BLL.SysNotice bllNotice = new Chain.BLL.SysNotice();
         DataTable           dtNotice  = bllNotice.GetList(5, "", "SysNoticeTime desc").Tables[0];
         this.rptNotice.DataSource = dtNotice;
         this.rptNotice.DataBind();
         this.txtMemStartTime.Value = DateTime.Now.AddDays(-20.0).ToString("yyyy-MM-dd");
         this.txtMemEndTime.Value   = DateTime.Now.ToString("yyyy-MM-dd");
         int shopID = this.UserModel.UserShopID;
         this.sltShop.Value = shopID.ToString();
         Chain.Model.SysShop modelShop = new Chain.BLL.SysShop().GetModel(this.UserModel.UserShopID);
         if (modelShop.ShopImageUrl != null && modelShop.ShopImageUrl.ToString() != "")
         {
             this.spShopPhoto.Src = modelShop.ShopImageUrl;
         }
         this.spShopName.InnerHtml       = modelShop.ShopName;
         this.spShopContactMan.InnerHtml = modelShop.ShopContactMan;
         this.spShopTel.InnerHtml        = modelShop.ShopTelephone;
         this.spShopAddress.InnerHtml    = this.BindAddress(this.UserModel.UserShopID);
         Chain.BLL.SysGroup   bllGroup   = new Chain.BLL.SysGroup();
         Chain.Model.SysGroup modelGroup = bllGroup.GetModel(this.UserModel.UserGroupID);
         this.spGroupName.InnerHtml = modelGroup.GroupName;
         Chain.BLL.Mem         bllMem         = new Chain.BLL.Mem();
         Chain.BLL.MemRecharge bllMemRecharge = new Chain.BLL.MemRecharge();
         Chain.BLL.OrderLog    bllOrderLog    = new Chain.BLL.OrderLog();
         Chain.BLL.MemCount    bllMemCount    = new Chain.BLL.MemCount();
         string strMemToday               = "CONVERT(varchar(10),MemCreateTime,120) = CONVERT(varchar(10),GETDATE(),120) AND MemID > 0";
         string strMemYesterday           = "CONVERT(varchar(10),MemCreateTime,120) = CONVERT(varchar(10), DATEADD(day,-1,GETDATE()),120) AND MemID > 0";
         string strMoneyToday             = "CONVERT(varchar(10),RechargeCreateTime,120) = CONVERT(varchar(10),GETDATE(),120)";
         string strMoneyYesterday         = "CONVERT(varchar(10),RechargeCreateTime,120) = CONVERT(varchar(10), DATEADD(day,-1,GETDATE()),120)";
         string strGetMoneyToday          = "CONVERT(varchar(10),OrderCreateTime,120) = CONVERT(varchar(10),GETDATE(),120)";
         string strGetMoneyYesterday      = "CONVERT(varchar(10),OrderCreateTime,120) = CONVERT(varchar(10), DATEADD(day,-1,GETDATE()),120)";
         string strGetCountMoneyToday     = "CONVERT(varchar(10),CountCreateTime,120) = CONVERT(varchar(10),GETDATE(),120)";
         string strGetCountMoneyYesterday = "CONVERT(varchar(10),CountCreateTime,120) = CONVERT(varchar(10), DATEADD(day,-1,GETDATE()),120)";
         if (modelShop.ShopID > 1)
         {
             strMemToday               += string.Format(" AND MemShopID = {0}", shopID);
             strMemYesterday           += string.Format(" AND MemShopID = {0}", shopID);
             strMoneyToday             += string.Format(" AND RechargeShopID = {0}", shopID);
             strMoneyYesterday         += string.Format(" AND RechargeShopID = {0}", shopID);
             strGetMoneyToday          += string.Format(" AND OrderShopID = {0}", shopID);
             strGetMoneyYesterday      += string.Format(" AND OrderShopID = {0}", shopID);
             strGetCountMoneyToday     += string.Format(" AND CountShopID = {0}", shopID);
             strGetCountMoneyYesterday += string.Format(" AND CountShopID = {0}", shopID);
         }
         this.spMemToday.InnerHtml     = bllMem.GetRecordCount(strMemToday).ToString();
         this.spMemYesterday.InnerHtml = bllMem.GetRecordCount(strMemYesterday).ToString();
         int     memtoday     = int.Parse(this.spMemToday.InnerHtml);
         int     memyesterday = int.Parse(this.spMemYesterday.InnerHtml);
         decimal rate;
         if (memtoday > memyesterday)
         {
             this.imgMemberRate.Src = "images/icon (18).png";
             if (memyesterday != 0)
             {
                 rate = memtoday - memyesterday / memyesterday;
             }
             else
             {
                 rate = 1m;
             }
         }
         else
         {
             if (memyesterday != 0)
             {
                 rate = memyesterday - memtoday / memyesterday;
             }
             else
             {
                 rate = 0m;
             }
             this.imgMemberRate.Src = "images/icon (1).png";
         }
         this.spMemberRate.InnerHtml     = (rate * 100m).ToString("F1") + "%";
         this.spMoneyToday.InnerHtml     = bllMemRecharge.GetRecMoney(strMoneyToday).ToString("F2");
         this.spMoneyYesterday.InnerHtml = bllMemRecharge.GetRecMoney(strMoneyYesterday).ToString("F2");
         decimal moneytoday     = decimal.Parse(this.spMoneyToday.InnerHtml);
         decimal moneyyesterday = decimal.Parse(this.spMoneyYesterday.InnerHtml);
         if (moneytoday > moneyyesterday)
         {
             this.imgMoneyRate.Src = "images/icon (18).png";
             if (moneyyesterday != 0m)
             {
                 rate = moneytoday - moneyyesterday / moneyyesterday;
             }
             else
             {
                 rate = 1m;
             }
         }
         else
         {
             if (moneyyesterday != 0m)
             {
                 rate = moneyyesterday - moneytoday / moneyyesterday;
             }
             else
             {
                 rate = 0m;
             }
             this.imgMoneyRate.Src = "images/icon (1).png";
         }
         this.spMoneyRate.InnerHtml         = (rate * 100m).ToString("F1") + "%";
         this.spGetMoneyToday.InnerHtml     = (bllOrderLog.GetTotalCash(strGetMoneyToday) + bllMemCount.GetTotalCash(strGetCountMoneyToday) + Convert.ToDecimal(this.spMoneyToday.InnerHtml)).ToString("F2");
         this.spGetMoneyYesterday.InnerHtml = (bllOrderLog.GetTotalCash(strGetMoneyYesterday) + bllMemCount.GetTotalCash(strGetCountMoneyYesterday) + Convert.ToDecimal(this.spMoneyYesterday.InnerHtml)).ToString("F2");
         decimal cashtoday     = decimal.Parse(this.spGetMoneyToday.InnerHtml);
         decimal cashyesterday = decimal.Parse(this.spGetMoneyYesterday.InnerHtml);
         if (moneytoday > cashyesterday)
         {
             this.imgCashRate.Src = "images/icon (18).png";
             if (cashyesterday != 0m)
             {
                 rate = cashtoday - cashyesterday / cashyesterday;
             }
             else
             {
                 rate = 1m;
             }
         }
         else
         {
             if (cashyesterday != 0m)
             {
                 rate = cashyesterday - cashtoday / cashyesterday;
             }
             else
             {
                 rate = 0m;
             }
             this.imgCashRate.Src = "images/icon (1).png";
         }
         this.spCashRate.InnerHtml = (rate * 100m).ToString("F1") + "%";
     }
 }
Exemplo n.º 2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            this.shopID                = this._UserShopID;
            this.UserGroupID           = this._UserGroupID;
            this.userid                = this._UserID;
            this.txtMemStartTime.Value = DateTime.Now.AddDays(-20.0).ToString("yyyy-MM-dd");
            this.txtMemEndTime.Value   = DateTime.Now.ToString("yyyy-MM-dd");
            this.strOrder              = " SysNoticeTime desc";
            this.sltShop.Value         = this.shopID.ToString();
            Chain.BLL.SysNotice bllNotice = new Chain.BLL.SysNotice();
            DataTable           dtNotice  = bllNotice.GetList(5, this.strSql, this.strOrder).Tables[0];

            this.rpNotice.DataSource = dtNotice;
            this.rpNotice.DataBind();
            Chain.BLL.Mem       bllMem    = new Chain.BLL.Mem();
            Chain.BLL.OrderLog  bllLog    = new Chain.BLL.OrderLog();
            Chain.BLL.SysShop   bllShop   = new Chain.BLL.SysShop();
            Chain.Model.SysShop modelShop = bllShop.GetModel(this.shopID);
            this.lblShopName.Text    = modelShop.ShopName;
            this.lblShopAddress.Text = modelShop.ShopAddress;
            this.lblShopMem.Text     = modelShop.ShopContactMan;
            this.lblShopPhone.Text   = modelShop.ShopTelephone;
            if (this.shopID != 1 && PubFunction.curParameter.bolShopPointManage)
            {
                this.lblPointCount.Text = modelShop.PointCount.ToString();
            }
            else
            {
                this.lblPoint.Visible = false;
            }
            if (this.shopID != 1 && PubFunction.curParameter.bolShopSmsManage)
            {
                this.lblSmsCount.Text = modelShop.SmsCount.ToString();
            }
            else
            {
                this.lblSms.Visible = false;
            }
            Chain.Model.SysGroup modelSysGroup = new Chain.BLL.SysGroup().GetModel(this.UserGroupID);
            this.lbGroupName.Text = modelSysGroup.GroupName;
            Chain.BLL.MemRecharge bllMemRecharge = new Chain.BLL.MemRecharge();
            Chain.BLL.OrderLog    bllOrderLog    = new Chain.BLL.OrderLog();
            Chain.BLL.MemCount    bllMemCount    = new Chain.BLL.MemCount();
            string strMemToday               = "CONVERT(varchar(10),MemCreateTime,120) = CONVERT(varchar(10),GETDATE(),120) AND MemID > 0";
            string strMemYesterday           = "CONVERT(varchar(10),MemCreateTime,120) = CONVERT(varchar(10), DATEADD(day,-1,GETDATE()),120) AND MemID > 0";
            string strMoneyToday             = "CONVERT(varchar(10),RechargeCreateTime,120) = CONVERT(varchar(10),GETDATE(),120)";
            string strMoneyYesterday         = "CONVERT(varchar(10),RechargeCreateTime,120) = CONVERT(varchar(10), DATEADD(day,-1,GETDATE()),120)";
            string strGetMoneyToday          = "CONVERT(varchar(10),OrderCreateTime,120) = CONVERT(varchar(10),GETDATE(),120)";
            string strGetMoneyYesterday      = "CONVERT(varchar(10),OrderCreateTime,120) = CONVERT(varchar(10), DATEADD(day,-1,GETDATE()),120)";
            string strGetCountMoneyToday     = "CONVERT(varchar(10),CountCreateTime,120) = CONVERT(varchar(10),GETDATE(),120)";
            string strGetCountMoneyYesterday = "CONVERT(varchar(10),CountCreateTime,120) = CONVERT(varchar(10), DATEADD(day,-1,GETDATE()),120)";

            if (modelShop.ShopID > 1)
            {
                strMemToday               += string.Format(" AND MemShopID = {0}", this.shopID);
                strMemYesterday           += string.Format(" AND MemShopID = {0}", this.shopID);
                strMoneyToday             += string.Format(" AND RechargeShopID = {0}", this.shopID);
                strMoneyYesterday         += string.Format(" AND RechargeShopID = {0}", this.shopID);
                strGetMoneyToday          += string.Format(" AND OrderShopID = {0}", this.shopID);
                strGetMoneyYesterday      += string.Format(" AND OrderShopID = {0}", this.shopID);
                strGetCountMoneyToday     += string.Format(" AND CountShopID = {0}", this.shopID);
                strGetCountMoneyYesterday += string.Format(" AND CountShopID = {0}", this.shopID);
            }
            this.ltlMemToday.Text          = bllMem.GetRecordCount(strMemToday).ToString();
            this.ltlMemYesterday.Text      = bllMem.GetRecordCount(strMemYesterday).ToString();
            this.lblrMoneyToday.Text       = bllMemRecharge.GetRecMoney(strMoneyToday).ToString("F2");
            this.lblrMoneyYesterday.Text   = bllMemRecharge.GetRecMoney(strMoneyYesterday).ToString("F2");
            this.lblGetMoneyToday.Text     = (bllOrderLog.GetTotalCash(strGetMoneyToday) + bllMemCount.GetTotalCash(strGetCountMoneyToday) + Convert.ToDecimal(this.lblrMoneyToday.Text)).ToString("F2");
            this.lblGetMoneyYesterday.Text = (bllOrderLog.GetTotalCash(strGetMoneyYesterday) + bllMemCount.GetTotalCash(strGetCountMoneyYesterday) + Convert.ToDecimal(this.lblrMoneyYesterday.Text)).ToString("F2");
            this.GetSysRemind();
        }