private void Get_ParameterList(string strSql) { Chain.BLL.GoodsLog bllGoodsLog = new Chain.BLL.GoodsLog(); int Counts = this.NetPagerParameter.RecordCount; strSql += " and GoodsLog.ShopID>0"; strSql += " and GoodsLog.ShopID = SysShop.ShopID and GoodsLog.UserID = SysUser.UserID"; strSql = PubFunction.GetShopAuthority(this._UserShopID, "GoodsLog.ShopID", strSql); DataTable db = bllGoodsLog.GetListSP(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.rptGoodsLog.DataSource = db; this.rptGoodsLog.DataBind(); PageBase.BindSerialRepeater(this.rptGoodsLog, this.NetPagerParameter.PageSize * (this.NetPagerParameter.CurrentPageIndex - 1)); }
private void Get_ParameterList(string strSql) { OrderLog bllOrder = new OrderLog(); int Counts = this.NetPagerParameter.RecordCount; strSql += "and OrderLog.OrderShopID = SysShop.ShopID and OrderLog.OrderMemID = Mem.MemID and Mem.MemLevelID=MemLevel.LevelID and OrderLog.OrderUserID = SysUser.UserID"; strSql = PubFunction.GetShopAuthority(this._UserShopID, "OrderShopID", strSql); DataTable db = bllOrder.GetListSP(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.gvRptExpense.DataSource = db; this.gvRptExpense.DataBind(); PageBase.BindSerialGridView(this.gvRptExpense, false, this.NetPagerParameter.PageSize * (this.NetPagerParameter.CurrentPageIndex - 1)); PageBase.BindNullSGridView(this.gvRptExpense); }
protected void btnRptStaffMoneyExcel_Click(object sender, EventArgs e) { int Counts = this.NetPagerParameter.RecordCount; string strSql = this.QueryCondition(); StringBuilder strDetail = new StringBuilder(); strSql += " and Staff.StaffClassID = StaffClass.ClassID and StaffClass.ClassShopID = SysShop.ShopID"; strSql = PubFunction.GetShopAuthority(this._UserShopID, "ClassShopID", strSql); StringBuilder strSb = new StringBuilder(); strSb.Append(" 1=1 "); if (this.txtStaffStartTime.Value != "") { strSb.AppendFormat(" and StaffMoney.StaffCreateTime>='{0}'", DateTime.Parse(this.txtStaffStartTime.Value)); strDetail.AppendFormat(" and StaffCreateTime>='{0}'", DateTime.Parse(this.txtStaffStartTime.Value)); } if (this.txtStaffEndTime.Value != "") { strSb.AppendFormat(" and StaffMoney.StaffCreateTime<='{0}'", DateTime.Parse(this.txtStaffEndTime.Value)); strDetail.AppendFormat(" and StaffCreateTime<='{0}'", DateTime.Parse(this.txtStaffEndTime.Value)); } DataTable dtStaff = this.bllStaff.GetListSP(100000, 1, out Counts, strSb.ToString(), new string[] { strSql }).Tables[0]; DataExcelInfo.StaffMoney(dtStaff, this._UserName, strDetail.ToString()); }
protected void btnRptPointRateExcel_Click(object sender, EventArgs e) { string strStartTime = this.txtStartTime.Value; string strEntTime = this.txtEndTime.Value; StringBuilder strTime = new StringBuilder(); string strSql = this.QueryCondition(); if (strStartTime != "") { this.strwhere.AppendFormat(" and POINTCREATETIME>='{0}'", strStartTime); strTime.AppendFormat(" and PointLOG.POINTCREATETIME>='{0}' ", strStartTime); } if (strEntTime != "") { this.strwhere.AppendFormat(" and POINTCREATETIME<='{0}'", strEntTime); strTime.AppendFormat(" and PointLOG.POINTCREATETIME<='{0}'", strEntTime); } PointRate bllPointRate = new PointRate(); int Counts = this.NetPagerParameter.RecordCount; strSql += "and MEM.MEMID<>0 AND MEM.MEMSHOPID=SYSSHOP.SHOPID"; strSql += " AND MEM.MEMLEVELID=MEMLEVEL.LEVELID"; strSql += " AND MEM.MEMUSERID=SYSUSER.USERID"; if (RptPointRate.MemCardId != null) { strSql += string.Format(" and Mem.MemCard={0}", RptPointRate.MemCardId); } strSql = PubFunction.GetShopAuthority(this._UserShopID, "MemShopID", strSql); DataTable db = bllPointRate.GetListSP(Counts, this.NetPagerParameter.CurrentPageIndex, out Counts, strTime.ToString(), new string[] { strSql }).Tables[0]; DataExcelInfo.PointRateExcel(db, this._UserName, this.strwhere.ToString()); }
protected void BindExchangeList() { GiftExchange bllGiftExchange = new GiftExchange(); int Counts = this.NetPagerParameter.RecordCount; string strSql = " GiftExchange.MemID=Mem.MemID and ExchangeStatus=1 "; if (this._UserShopID != 1) { strSql = PubFunction.GetShopAuthority(this._UserShopID, "ShopID", strSql); } DataTable dtGiftExchange = bllGiftExchange.GetVerifyListSP(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.rptExchangeVerify.DataSource = dtGiftExchange; this.rptExchangeVerify.DataBind(); PageBase.BindSerialRepeater(this.rptExchangeVerify, this.NetPagerParameter.PageSize * (this.NetPagerParameter.CurrentPageIndex - 1)); }
private void Get_ParameterList(string strSql) { Mem bllMem = new Mem(); int Counts = this.NetPagerParameter.RecordCount; strSql += " and Mem.MemShopID = SysShop.ShopID and Mem.MemLevelID = MemLevel.LevelID and Mem.MemUserID = SysUser.UserID"; strSql += " and Mem.MemShopID =SysShopMemLevel.ShopID and SysShopMemLevel.MemLevelID=MemLevel.LevelID "; strSql = PubFunction.GetShopAuthority(this._UserShopID, "MemShopID", strSql); DataTable db = bllMem.GetListSP(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.gvRptMemDrain.DataSource = db; this.gvRptMemDrain.DataBind(); PageBase.BindSerialRepeater(this.gvRptMemDrain, this.NetPagerParameter.PageSize * (this.NetPagerParameter.CurrentPageIndex - 1)); }
private void BindExpenseMoney() { OrderLog bllOrder = new OrderLog(); string sbWhere = this.QueryCondition(); sbWhere += "and OrderLog.OrderShopID = SysShop.ShopID and OrderLog.OrderMemID = Mem.MemID and Mem.MemLevelID=MemLevel.LevelID and OrderLog.OrderUserID = SysUser.UserID"; sbWhere = PubFunction.GetShopAuthority(this._UserShopID, "OrderShopID", sbWhere); string strMoney = bllOrder.GetTotalMoney(sbWhere + " and datediff(day,OrderCreateTime,getdate())=0").ToString("f2"); this.lblToTalToday.Text = strMoney; strMoney = bllOrder.GetTotalMoney(sbWhere + " and datediff(week,OrderCreateTime,getdate())=0").ToString("f2"); this.lblToTalWeek.Text = strMoney; strMoney = bllOrder.GetTotalMoney(sbWhere + " and datediff(month,OrderCreateTime,getdate())=0").ToString("f2"); this.lblToTalMonth.Text = strMoney; strMoney = bllOrder.GetTotalMoney(sbWhere).ToString("f2"); this.lblTotal.Text = strMoney; strMoney = bllOrder.GetDiscountMoney(sbWhere + " and datediff(day,OrderCreateTime,getdate())=0").ToString("f2"); this.lblDiscountToday.Text = strMoney; strMoney = bllOrder.GetDiscountMoney(sbWhere + " and datediff(week,OrderCreateTime,getdate())=0").ToString("f2"); this.lblDiscountWeek.Text = strMoney; strMoney = bllOrder.GetDiscountMoney(sbWhere + " and datediff(month,OrderCreateTime,getdate())=0").ToString("f2"); this.lblDiscountMonth.Text = strMoney; strMoney = bllOrder.GetDiscountMoney(sbWhere).ToString("f2"); this.lblDiscountTotal.Text = strMoney; }
private void Get_ParameterList() { string strSql = ""; EmailLog bllEmail = new EmailLog(); int Counts = this.NetPagerParameter.RecordCount; strSql += "EmailLog.EmailShopID = SysShop.ShopID and EmailLog.EmailUserID = SysUser.UserID "; strSql = PubFunction.GetShopAuthority(this._UserShopID, "EmailShopID", strSql); DataTable dt = bllEmail.GetListSP(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.gvEmailList.DataSource = dt; this.gvEmailList.DataBind(); PageBase.BindSerialRepeater(this.gvEmailList, this.NetPagerParameter.PageSize * (this.NetPagerParameter.CurrentPageIndex - 1)); }
private void Get_ParameterList(string strSql) { string strStartTime = this.txtStartTime.Value; string strEntTime = this.txtEndTime.Value; if (strStartTime != "") { strSql = strSql + " and OrderCreateTime>='" + strStartTime + "'"; } if (strEntTime != "") { strSql = strSql + " and OrderCreateTime<'" + PubFunction.TimeEndDay(strEntTime) + "'"; } strSql += " AND OrderLog.OrderType != 4 AND OrderLog.OrderType != 5 "; Chain.BLL.Goods bllGoods = new Chain.BLL.Goods(); int Counts = this.NetPagerParameter.RecordCount; strSql = PubFunction.GetShopAuthority(this._UserShopID, "OrderLog.OrderShopID", strSql); DataTable dt = bllGoods.GetGoodsExpense(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.rptGoods.DataSource = dt; this.rptGoods.DataBind(); PageBase.BindSerialRepeater(this.rptGoods, this.NetPagerParameter.PageSize * (this.NetPagerParameter.CurrentPageIndex - 1)); }
private void BindStaffMoneyList(string strSql) { int Counts = this.NetPagerParameter.RecordCount; strSql += " and Staff.StaffClassID = StaffClass.ClassID and StaffClass.ClassShopID = SysShop.ShopID"; strSql = PubFunction.GetShopAuthority(this._UserShopID, "ClassShopID", strSql); StringBuilder strSb = new StringBuilder(); strSb.Append(" 1=1 "); if (this.txtStaffStartTime.Value != "") { strSb.AppendFormat(" and StaffMoney.StaffCreateTime>='{0}'", DateTime.Parse(this.txtStaffStartTime.Value)); } if (this.txtStaffEndTime.Value != "") { strSb.AppendFormat(" and StaffMoney.StaffCreateTime<='{0}'", DateTime.Parse(this.txtStaffEndTime.Value + " 23:59:59")); } DataTable dtStaff = this.bllStaff.GetListSP(this.NetPagerParameter.PageSize, this.NetPagerParameter.CurrentPageIndex, out Counts, strSb.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.rptStaffMoneyList.DataSource = dtStaff; this.rptStaffMoneyList.DataBind(); PageBase.BindSerialRepeater(this.rptStaffMoneyList, this.NetPagerParameter.PageSize * (this.NetPagerParameter.CurrentPageIndex - 1)); }
private void BindPointChange() { PointLog bllPoint = new PointLog(); string strSql = this.QueryCondition(); strSql += " and PointLog.PointMemID = Mem.MemID "; strSql = PubFunction.GetShopAuthority(this._UserShopID, "PointShopID", strSql); int intPoint = bllPoint.GetPointChange(strSql); this.lblChangePoint.Text = intPoint.ToString(); }
private void BindStaffTotalMoney() { StaffMoney bllStaffMoney = new StaffMoney(); string strSql = this.QueryCondition(); strSql += " and Staff.StaffClassID = StaffClass.ClassID and StaffClass.ClassShopID = SysShop.ShopID and StaffMoney.StaffID = Staff.StaffID"; strSql = PubFunction.GetShopAuthority(this._UserShopID, "ClassShopID", strSql); decimal dclStaffMoney = bllStaffMoney.GetStaffTotalMoney(strSql); this.lblStaffMoney.Text = dclStaffMoney.ToString("0.00"); }
private void BindExchage() { GiftExchange bllExchage = new GiftExchange(); string strSql = this.QueryCondition(); strSql += " and GiftExchange.MemID=Mem.MemID "; strSql = PubFunction.GetShopAuthority(this._UserShopID, "MemShopID", strSql); DataTable dtExchange = bllExchage.GetGiftExchange(strSql).Tables[0]; this.lblExchangeNumber.Text = dtExchange.Rows[0]["ExchangeAllNumber"].ToString(); this.lblExchangePoint.Text = dtExchange.Rows[0]["ExchangeAllPoint"].ToString(); }
private void BindDrawMoney() { MemDrawMoney bllDrawMoney = new MemDrawMoney(); string strSql = this.QueryCondition(); strSql += " and MemDrawMoney.DrawMoneyMemID=Mem.MemID "; strSql = PubFunction.GetShopAuthority(this._UserShopID, "DrawMoneyShopID", strSql); DataTable dtDrawMoney = bllDrawMoney.GetDrawMoneyCount(strSql).Tables[0]; this.lblDrawTotalMoney.Text = decimal.Parse(dtDrawMoney.Rows[0]["DrawMoney"].ToString()).ToString("0.00"); this.lblDrawActualMoney.Text = decimal.Parse(dtDrawMoney.Rows[0]["DrawActualMoney"].ToString()).ToString("0.00"); }
protected void btnExpenseExcel_Click(object sender, EventArgs e) { int Counts = this.NetPagerParameter.RecordCount; string strSql = this.QueryCondition(); strSql += " and MicroWebsiteOrderLog.MicroOrderShopID = SysShop.ShopID and MicroWebsiteOrderLog.MicroOrderMemID = Mem.MemID and MicroOrderStatus !=2 "; strSql = PubFunction.GetShopAuthority(this._UserShopID, "MicroOrderShopID", strSql); DataTable dtExpenseHistory = new MicroWebsiteOrderLog().GetListSP1(this.NetPagerParameter.PageSize, this.NetPagerParameter.CurrentPageIndex, out Counts, new string[] { strSql }).Tables[0]; DataExcelInfo.MicroExpenseHistory(dtExpenseHistory, this._UserName); }
protected void btnMemCountExcel_Click(object sender, EventArgs e) { int Counts = this.NetPagerParameter.RecordCount; string strSql = this.QueryCondition(); strSql += " and Mem.MemID = MemCount.CountMemID and MemCount.CountShopID = SysShop.ShopID and Mem.MemUserID = SysUser.UserID and Mem.MemLevelID=MemLevel.LevelID"; strSql = PubFunction.GetShopAuthority(this._UserShopID, "CountShopID", strSql); DataTable dtMemCount = this.bllMemCount.GetListSP(10000000, 1, out Counts, new string[] { strSql }).Tables[0]; DataExcelInfo.MemCount(dtMemCount, this._UserName); }
private void BindRechargeMoney() { MemRecharge bllMemRecharge = new MemRecharge(); string sbWhere = this.QueryCondition(); sbWhere += "AND RechargeIsApprove=1 and MemRecharge.RechargeShopID = SysShop.ShopID and MemRecharge.RechargeMemID = Mem.MemID and Mem.MemLevelID=MemLevel.LevelID and MemRecharge.RechargeUserID = SysUser.UserID"; sbWhere = PubFunction.GetShopAuthority(this._UserShopID, "RechargeShopID", sbWhere); decimal czMoney = bllMemRecharge.GetRechargeMoney(sbWhere + string.Format(" and MemRecharge.RechargeCreateTime >= '{0}' and MemRecharge.RechargeCreateTime < '{1}'", this.txtStartTime.Value, PubFunction.TimeEndDay(this.txtEndTime.Value))); this.lblczMoney.Text = czMoney.ToString("f2"); decimal zsMoney = bllMemRecharge.GetGiveMoney(sbWhere + string.Format(" and MemRecharge.RechargeCreateTime >= '{0}' and MemRecharge.RechargeCreateTime < '{1}'", this.txtStartTime.Value, PubFunction.TimeEndDay(this.txtEndTime.Value))); this.lbzsMoney.Text = zsMoney.ToString("f2"); }
private void BindStorageTiming() { MemStorageTiming bllTime = new MemStorageTiming(); string strSql = this.QueryCondition(); strSql = PubFunction.GetShopAuthority(this._UserShopID, "StorageTimingShopID", strSql); DataTable dtTime = bllTime.GetTimeTotal(strSql).Tables[0]; this.lblMoney.Text = decimal.Parse(dtTime.Rows[0]["TotalMoney"].ToString()).ToString("0.00"); this.lblDiscountMoney.Text = decimal.Parse(dtTime.Rows[0]["DiscountMoney"].ToString()).ToString("0.00"); this.lblToalTime.Text = int.Parse(dtTime.Rows[0]["TotalTime"].ToString()).ToString(); this.lblRemainTime.Text = int.Parse(dtTime.Rows[0]["RemainTime"].ToString()).ToString(); this.lblTotalPoint.Text = int.Parse(dtTime.Rows[0]["TotalPoint"].ToString()).ToString(); }
protected DataTable GetListAllData() { Mem bllMem = new Mem(); int Counts = this.NetPagerParameter.RecordCount; string strSql = this.QueryCondition(); strSql += "and Mem.MemShopID = SysShop.ShopID and Mem.MemLevelID = MemLevel.LevelID and Mem.MemUserID = SysUser.UserID"; strSql += " and Mem.MemShopID =SysShopMemLevel.ShopID and SysShopMemLevel.MemLevelID=MemLevel.LevelID "; strSql = PubFunction.GetShopAuthority(this._UserShopID, "MemShopID", strSql); return(bllMem.GetListSP(1000000, 1, out Counts, new string[] { strSql }).Tables[0]); }
protected void btnMoneyExchangeExcel_Click(object sender, EventArgs e) { string strSql = this.QueryCondition(); int Counts = this.NetPagerParameter.RecordCount; strSql = PubFunction.GetShopAuthority(this._UserShopID, "UserShopID", strSql); MoneyChangeLog moneyChangeLogBll = new MoneyChangeLog(); DataTable db = moneyChangeLogBll.GetMoneyChangeLog(100000, 1, out Counts, new string[] { strSql }).Tables[0]; DataExcelInfo.MoneyChangeLogReportExcel(db, this._UserName); }
protected void btnRptPointExchangeExcel_Click(object sender, EventArgs e) { PointExchange bllGiftExchange = new PointExchange(); int Counts = this.NetPagerParameter.RecordCount; string strSql = this.QueryCondition() + " and GiftExchange.ExchangeStatus=2 and GiftExchange.MemID=Mem.MemID and GiftExchange.ExchangeUserID = SysUser.UserID and Mem.MemShopID = SysShop.ShopID"; strSql = PubFunction.GetShopAuthority(this._UserShopID, "MemShopID", strSql); DataTable dtGiftExchange = bllGiftExchange.GetListSP(100000, 1, out Counts, new string[] { strSql }).Tables[0]; DataExcelInfo.RptGiftExchangeExcel(dtGiftExchange, this._UserName); }
protected void btnOut_Click(object sender, EventArgs e) { string strSql = this.QueryCondition(); GoodsNumber bllGoodsNumber = new GoodsNumber(); int Counts = this.NetPagerParameter.RecordCount; strSql = PubFunction.GetShopAuthority(this._UserShopID, "ShopID", strSql); DataTable db = bllGoodsNumber.GetListSP(100000, 1, out Counts, new string[] { strSql }).Tables[0]; DataExcelInfo.GoodsStockTotalExcel(db, this._UserName); }
protected void btnPointRankExcel_Click(object sender, EventArgs e) { Mem bllMem = new Mem(); int Counts = this.NetPagerParameter.RecordCount; string strSql = this.QueryCondition(); strSql += "and Mem.MemShopID = SysShop.ShopID and Mem.MemLevelID = MemLevel.LevelID and MemPoint>0 "; strSql = PubFunction.GetShopAuthority(this._UserShopID, "MemShopID", strSql); DataTable dtPoint = bllMem.GetPointRankList(100000, 1, out Counts, new string[] { strSql }).Tables[0]; DataExcelInfo.PointRankReportExcel(dtPoint, this._UserName); }
protected void btnExpenseExcel_Click(object sender, EventArgs e) { int Counts = this.NetPagerParameter.RecordCount; string strSql = this.QueryCondition(); strSql += " and OrderType<>3 "; strSql += " and OrderLog.OrderShopID = SysShop.ShopID and OrderLog.OrderMemID = Mem.MemID and OrderLog.OrderUserID = SysUser.UserID"; strSql = PubFunction.GetShopAuthority(this._UserShopID, "OrderShopID", strSql); DataTable dtExpenseHistory = this.bllOrderLog.GetListSP(1000000, 1, out Counts, new string[] { strSql }).Tables[0]; DataExcelInfo.ExpenseHistory(dtExpenseHistory, this._UserName); }
protected void btnRptPointChangeExcel_Click(object sender, EventArgs e) { PointLog bllPointLog = new PointLog(); int Counts = this.NetPagerParameter.RecordCount; string strSql = this.QueryCondition(); strSql += "and PointLog.PointShopID = SysShop.ShopID and PointLog.PointMemID = Mem.MemID and Mem.MemLevelID=MemLevel.LevelID and PointLog.PointUserID = SysUser.UserID"; strSql = PubFunction.GetShopAuthority(this._UserShopID, "PointShopID", strSql); DataTable dtPointLog = bllPointLog.GetListSP(100000, 1, out Counts, new string[] { strSql }).Tables[0]; DataExcelInfo.PointChangeReportExcel(dtPointLog, this._UserName); }
protected void btnOut_Click(object sender, EventArgs e) { Chain.BLL.Goods bllGoods = new Chain.BLL.Goods(); int Counts = this.NetPagerParameter.RecordCount; string strSql = this.QueryCondition(); strSql += " and Goods.GoodsClassID = GoodsClass.ClassID and Goods.GoodsID = GoodsNumber.GoodsID"; strSql = PubFunction.GetShopAuthority(this._UserShopID, "ShopID", strSql); DataTable dtGoods = bllGoods.GetListSP(100000, 1, out Counts, new string[] { strSql }).Tables[0]; DataExcelInfo.GoodsListExcel(dtGoods, this._UserName); }
protected void btnPointRankExcel_Click(object sender, EventArgs e) { SysUserWork bllsysuserwork = new SysUserWork(); int Counts = this.NetPagerParameter.RecordCount; string strSql = this.QueryCondition(); strSql += "and SysUserWork.userID = SysUser.userid and SysUser.UserShopID = SysShop.ShopID "; strSql = PubFunction.GetShopAuthority(this._UserShopID, "UserShopID", strSql); DataTable dtPoint = bllsysuserwork.GetListSP(100000, 1, out Counts, new string[] { strSql }).Tables[0]; DataExcelInfo.PointUserWorkExcel(dtPoint, this._UserName); }
protected void btnMemDrawMoneyExcel_Click(object sender, EventArgs e) { MemDrawMoney bllDrawMoney = new MemDrawMoney(); int Counts = this.NetPagerParameter.RecordCount; string strSql = this.QueryCondition(); strSql += "and MemDrawMoney.DrawMoneyShopID = SysShop.ShopID and MemDrawMoney.DrawMoneyMemID = Mem.MemID and Mem.MemLevelID=MemLevel.LevelID and MemDrawMoney.DrawMoneyUserID = SysUser.UserID"; strSql = PubFunction.GetShopAuthority(this._UserShopID, "DrawMoneyShopID", strSql); DataTable db = bllDrawMoney.GetListSP(1000000, 1, out Counts, new string[] { strSql }).Tables[0]; DataExcelInfo.MemDrawMoney(db, this._UserName); }
protected void btnRptExpenseExcel_Click(object sender, EventArgs e) { OrderLog bllOrder = new OrderLog(); int Counts = this.NetPagerParameter.RecordCount; string strSql = this.QueryCondition(); strSql += "and OrderLog.OrderShopID = SysShop.ShopID and OrderLog.OrderMemID = Mem.MemID and Mem.MemLevelID=MemLevel.LevelID and OrderLog.OrderUserID = SysUser.UserID"; strSql = PubFunction.GetShopAuthority(this._UserShopID, "OrderShopID", strSql); DataTable dtExpense = bllOrder.GetListSP(100000, 1, out Counts, new string[] { strSql }).Tables[0]; DataExcelInfo.RptExpenseReportExcel(dtExpense, this._UserName); }
protected string QueryCondition() { string strMemShopID = this.sltShop.Value; StringBuilder strSql = new StringBuilder(); strSql.Append(" SysShopPointLog.UserID = SysUser.UserID AND SysShopPointLog.OutShopID = SysShop.ShopID "); if (strMemShopID != "") { strSql.AppendFormat(" and SysShopPointLog.OutShopID in ({0})", int.Parse(strMemShopID)); } else { strSql.AppendFormat(PubFunction.GetShopAuthority(this._UserShopID, "SysShopPointLog.OutShopID", ""), new object[0]); } if (this.sltCzlx.Value != "") { strSql.AppendFormat(" and ShopPointType = '{0}'", this.sltCzlx.Value); } if (this.txtShopPointAccount.Value.Trim() != "") { strSql.AppendFormat(" and ShopPointAccount='{0}'", this.txtShopPointAccount.Value.Trim()); } if (base.Request.QueryString["PID"] != null) { string pid = base.Request.QueryString["PID"].ToString(); if (pid == "151") { strSql.AppendFormat(" and SysShop.ShopType = 2", new object[0]); } if (pid == "152") { strSql.AppendFormat(" and SysShop.ShopType = 3", new object[0]); } if (pid == "154") { strSql.AppendFormat(" and SysShop.ShopType = 1", new object[0]); } } if (this.txtStartTime.Value != "") { strSql.AppendFormat("and CreateTime>='{0}' ", this.txtStartTime.Value); } if (this.txtEndTime.Value != "") { strSql.AppendFormat("and CreateTime<='{0}'", PubFunction.TimeEndDay(this.txtEndTime.Value)); } return(strSql.ToString()); }