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