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