private void Get_ParameterList(string strSql) { SysShop bllPointLog = new SysShop(); int Counts = this.NetPagerParameter.RecordCount; StringBuilder strWhere = new StringBuilder(); if (this.txtStartTime.Value != "") { strWhere.AppendFormat(" and ShopCreateTime>='{0}' ", this.txtStartTime.Value); } if (this.txtEndTime.Value != "") { strWhere.AppendFormat(" and ShopCreateTime<='{0}'", PubFunction.TimeEndDay(this.txtEndTime.Value)); } DataTable db = bllPointLog.GetListShop(this.NetPagerParameter.PageSize, this.NetPagerParameter.CurrentPageIndex, out Counts, strWhere.ToString(), new string[] { strSql }).Tables[0]; this.NetPagerParameter.RecordCount = Counts; this.NetPagerParameter.CustomInfoHTML = string.Format("<div class=\"results\"><span>当前第{0}/{1}页 共{2}条记录 每页{3}条</span></div>", new object[] { this.NetPagerParameter.CurrentPageIndex, this.NetPagerParameter.PageCount, this.NetPagerParameter.RecordCount, this.NetPagerParameter.PageSize }); this.gvRptPointChange.DataSource = db; this.gvRptPointChange.DataBind(); PageBase.BindSerialRepeater(this.gvRptPointChange, this.NetPagerParameter.PageSize * (this.NetPagerParameter.CurrentPageIndex - 1)); }
private DataTable Get_ParameterList(string strSql) { SysShop bllShop = new SysShop(); string strStartTime; if (this.txtStartTime.Value == "") { strStartTime = DateTime.Now.AddYears(-50).ToString("yyyy-MM-dd"); } else { strStartTime = Convert.ToDateTime(this.txtStartTime.Value).AddSeconds(1.0).ToString(); } string strEndTime; if (this.txtEndTime.Value == "") { strEndTime = DateTime.Now.AddYears(50).ToString("yyyy-MM-dd"); } else { strEndTime = Convert.ToDateTime(this.txtEndTime.Value).AddDays(1.0).AddSeconds(-1.0).ToString(); } return(bllShop.getTotalShop(strStartTime, strEndTime, new string[] { strSql }).Tables[0]); }
protected string BindShopName(object shopid) { SysShop Shop = new SysShop(); string shopname = ""; if (shopid != null) { shopname = Shop.GetShopNameByShopid(shopid.ToString()); } return(shopname); }
protected void btnRptPointChangeExcel_Click(object sender, EventArgs e) { SysShop bllPointLog = new SysShop(); int Counts = this.NetPagerParameter.RecordCount; string strSql = this.QueryCondition(); DataTable dt = bllPointLog.GetAllianceListShop(100000, 1, out Counts, new string[] { strSql }).Tables[0]; DataExcelInfo.AllianceListShopReportExcel(dt, this._UserName); }
private void Get_ParameterList() { SysShop shop = new SysShop(); int Counts = 0; DataTable db = shop.GetListS(1000, 1, out Counts, new string[] { "ShopID>0 and ShopID !=" + this.ShopID.Value }).Tables[0]; this.gvShopAuthorityList.DataSource = db; this.gvShopAuthorityList.DataBind(); PageBase.BindSerialRepeater(this.gvShopAuthorityList, 0); }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { if (base.Request.QueryString["PID"] != null) { int pid = int.Parse(base.Request.QueryString["PID"]); if (pid == 147) { this.txtDrawType.Value = "2"; } else if (pid == 148) { this.txtDrawType.Value = "3"; this.ltlTitle.Text = "主页 > 商家管理 > 商家积分申请提现"; } } this.chkSMS.Checked = (this.curParameter.bolMoneySms && this.curParameter.bolAutoSendSMSByMemPointChange); this.chkPrint.Checked = this.curParameter.bolAutoPrint; this.lblDrawAccount.InnerText = this.curParameter.strMemPointChangePrefix + DateTime.Now.ToString("yyMMddHHmmssffff"); this.lblDrawTime.InnerText = DateTime.Now.ToString(); this.lblDrawUser.InnerText = this._UserName; this.txtDrawUserID.Value = this._UserID.ToString(); PubFunction.Get_PrintTitle(ref this.lblPrintTitle, ref this.lblPrintFoot, this._UserShopID); SysShop shop = new SysShop(); Chain.BLL.PointDraw bllPointDraw = new Chain.BLL.PointDraw(); if (this._UserShopID == 1) { this.txtTotalPoint.Value = "0"; } else { int point = shop.GetShopPointByShopid(this._UserShopID, int.Parse(this.txtDrawType.Value)); int drawPoint = bllPointDraw.GetShopPointDraw(this._UserShopID); if (drawPoint >= point) { this.txtTotalPoint.Value = "0"; } else { this.txtTotalPoint.Value = (point - drawPoint).ToString(); } } this.txtShopID.Value = this._UserShopID.ToString(); this.lbl_PointDrawPercent.InnerText = PubFunction.curParameter.PointDrawPercent.ToString(); this.PointNum.Value = PubFunction.GetPointNum("JFBD"); } }
private void Get_ParameterList(string strSql) { SysShop bllPointLog = new SysShop(); int Counts = this.NetPagerParameter.RecordCount; DataTable db = bllPointLog.GetAllianceListShop(this.NetPagerParameter.PageSize, this.NetPagerParameter.CurrentPageIndex, out Counts, new string[] { strSql }).Tables[0]; this.NetPagerParameter.RecordCount = Counts; this.NetPagerParameter.CustomInfoHTML = string.Format("<div class=\"results\"><span>当前第{0}/{1}页 共{2}条记录 每页{3}条</span></div>", new object[] { this.NetPagerParameter.CurrentPageIndex, this.NetPagerParameter.PageCount, this.NetPagerParameter.RecordCount, this.NetPagerParameter.PageSize }); this.gvRptPointChange.DataSource = db; this.gvRptPointChange.DataBind(); PageBase.BindSerialRepeater(this.gvRptPointChange, this.NetPagerParameter.PageSize * (this.NetPagerParameter.CurrentPageIndex - 1)); }
protected void btnRptPointChangeExcel_Click(object sender, EventArgs e) { StringBuilder strWhere = new StringBuilder(); if (this.txtStartTime.Value != "") { strWhere.AppendFormat(" and ShopCreateTime>='{0}' ", this.txtStartTime.Value); } if (this.txtEndTime.Value != "") { strWhere.AppendFormat(" and ShopCreateTime<='{0}'", PubFunction.TimeEndDay(this.txtEndTime.Value)); } SysShop bllPointLog = new SysShop(); int Counts = this.NetPagerParameter.RecordCount; string strSql = this.QueryCondition(); DataTable dt = bllPointLog.GetListShop(100000, 1, out Counts, strWhere.ToString(), new string[] { strSql }).Tables[0]; DataExcelInfo.ShopListShopReportExcel(dt, this._UserName); }
private string BindStaff(string strCallbackFun) { StringBuilder sbHtml = new StringBuilder(); DataTable dtStaffClass = new StaffClass().GetList(" SysShop.ShopID=StaffClass.ClassShopID ").Tables[0]; sbHtml.Append("<ul class=\"mktree\" id=\"treeStaff\">"); sbHtml.Append("<li><a href=\"javascript:void(0);\" onclick=\"javascript:" + strCallbackFun + "();\" style='font-size:14px;color:#303030;font-weight:bolder;'><img src='/images/ico/open.png'/> 所有商家</a></li>"); if (this._UserShopID == 1) { sbHtml.Append("<ul>"); DataTable dtShop = new SysShop().GetList("ShopID>0").Tables[0]; foreach (DataRow dr in dtShop.Rows) { sbHtml.Append(string.Concat(new object[] { "<li><font style='font-size:14px;color:#4f4e4e;'> <a href='#' class='mytrees' onclick='bindtree(", dr["ShopID"].ToString(), ")'><img id='img", dr["ShopID"].ToString(), "' src='/images/ico/close.png'/></a></font><a style='font-size:14px;color:#4f4e4e;' href=\"javascript:void(0);\" onclick=\"javascript:", strCallbackFun, "(", dr["ShopID"], ",true);\"> 商家:", dr["ShopName"], "</a>" })); StaffList.CreateStaffClass(sbHtml, dtStaffClass, strCallbackFun, int.Parse(dr["ShopID"].ToString())); } sbHtml.Append("</ul>"); } else { StaffList.CreateStaffClass(sbHtml, dtStaffClass, strCallbackFun, this._UserShopID); } return(sbHtml.ToString()); }