private void GetSysRemind() { int count = 5; Chain.BLL.Mem bllMem = new Chain.BLL.Mem(); DataTable dtBirhtday = bllMem.GetBirthdayList(0, this.shopID, count).Tables[0]; this.gvMemBirthday.DataSource = dtBirhtday; this.gvMemBirthday.DataBind(); StartPage.RepeaterBindSerial(this.gvMemBirthday, 0); DataTable dtMemPastTime = bllMem.GetMemPastTime(" and DATEDIFF(day,getdate(),MemPastTime) = 0 ", this.shopID, count).Tables[0]; this.gvMemPastTime.DataSource = dtMemPastTime; this.gvMemPastTime.DataBind(); StartPage.RepeaterBindSerial(this.gvMemPastTime, 0); DataTable dtMemPointRest = bllMem.GetMemPointReset(string.Format("MemPoint>0 and DATEDIFF(day,isnull(MemConsumeLastTime,MemCreateTime),getdate()) >= '{0}' and MemShopID = '{1}' ", PubFunction.curParameter.intPointPeriod, this.shopID), 0, count).Tables[0]; this.gvdMemPontReset.DataSource = dtMemPointRest; this.gvdMemPontReset.DataBind(); StartPage.RepeaterBindSerial(this.gvdMemPontReset, 0); DataTable dtGoods = new Chain.BLL.Goods().GetStockRemind(string.Format("Number < = '{0}' and GoodsType = '0' and ShopID = '{1}'", PubFunction.curParameter.intStockCount, this.shopID), count).Tables[0]; this.gvGoods.DataSource = dtGoods; this.gvGoods.DataBind(); StartPage.RepeaterBindSerial(this.gvGoods, 0); DataTable dtCustomRemind = new Chain.BLL.SysCustomRemind().GetList("CustomReminder like '%" + PubFunction.UserIDTOName(this.userid) + "%' and DATEDIFF(day,CustomRemindTime,getdate())<=0 ", count).Tables[0]; this.gvCustomRemind.DataSource = dtCustomRemind; this.gvCustomRemind.DataBind(); StartPage.RepeaterBindSerial(this.gvCustomRemind, 0); }
private void GetCustomRemindList() { Chain.BLL.SysCustomRemind bllCustomRemind = new Chain.BLL.SysCustomRemind(); DataTable dtCustomRemind = bllCustomRemind.GetList("").Tables[0]; this.gvCustomRemind.DataSource = dtCustomRemind; this.gvCustomRemind.DataBind(); }
private void GetCustomRemindInfo() { int intRemind = int.Parse(base.Request.QueryString["CID"]); Chain.Model.SysCustomRemind modeRemind = new Chain.BLL.SysCustomRemind().GetModel(intRemind); this.txtCustomRemindID.Value = modeRemind.CustomRemindID.ToString(); this.txtCustomRemindTitle.Value = modeRemind.CustomRemindTitle; this.txtCustomRemindTime.Value = modeRemind.CustomRemindTime.ToShortDateString(); this.txtCustomRemindDetail.Value = modeRemind.CustomRemindDetail; string strReminder = modeRemind.CustomReminder; string[] str = strReminder.Split(new char[] { ',' }); string[] array = str; for (int i = 0; i < array.Length; i++) { string p = array[i]; this.cblCustomReminder.Items.FindByValue(p).Selected = true; } }
private int GetSysRemind(int shopID, int userid) { int sumCount = 0; int count = 100000; Chain.BLL.Mem bllMem = new Chain.BLL.Mem(); DataTable dtBirhtday = bllMem.GetBirthdayList(0, shopID, count).Tables[0]; sumCount += dtBirhtday.Rows.Count; DataTable dtMemPastTime = bllMem.GetMemPastTime(" and DATEDIFF(day,getdate(),MemPastTime) = 0 ", shopID, count).Tables[0]; sumCount += dtMemPastTime.Rows.Count; DataTable dtMemPointRest = bllMem.GetMemPointReset(string.Format("MemPoint>0 and DATEDIFF(day,isnull(MemConsumeLastTime,MemCreateTime),getdate()) >= '{0}' and MemShopID = '{1}' ", PubFunction.curParameter.intPointPeriod, shopID), 0, count).Tables[0]; sumCount += dtMemPointRest.Rows.Count; DataTable dtGoods = new Chain.BLL.Goods().GetStockRemind(string.Format("Number < = '{0}' and GoodsType = '0' and ShopID = '{1}'", PubFunction.curParameter.intStockCount, shopID), count).Tables[0]; sumCount += dtGoods.Rows.Count; DataTable dtCustomRemind = new Chain.BLL.SysCustomRemind().GetList("CustomReminder like '%" + PubFunction.UserIDTOName(userid) + "%' and DATEDIFF(day,CustomRemindTime,getdate())<=0 ", count).Tables[0]; return(sumCount + dtCustomRemind.Rows.Count); }