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());
}
