protected string QueryCondition()
{
string strMemShopID = this.sltShop.Value;
StringBuilder strSql = new StringBuilder();
strSql.Append(" 1=1 ");
if (strMemShopID != "")
{
string str = PubFunction.GetMemListShopAuthority(int.Parse(strMemShopID), "DrawShopID", strSql.ToString());
strSql.AppendFormat(" and {0} ", str);
}
else
{
string str = PubFunction.GetMemListShopAuthority(this._UserShopID, "DrawShopID", strSql.ToString());
strSql.AppendFormat(" and {0} ", str);
}
if (this.txtShopSmsAccount.Value.Trim() != "")
{
strSql.AppendFormat(" and DrawAccount='{0}'", this.txtShopSmsAccount.Value.Trim());
}
if (this.sltCzlx.Value != "")
{
strSql.AppendFormat(" and DrawStatus = '{0}'", this.sltCzlx.Value);
}
if (this.txtStartTime.Value != "")
{
strSql.AppendFormat(" and DrawCreateTime>='{0}' ", this.txtStartTime.Value);
}
if (this.txtEndTime.Value != "")
{
strSql.AppendFormat(" and DrawCreateTime<='{0}'", PubFunction.TimeEndDay(this.txtEndTime.Value));
}
return(strSql.ToString());
}
private void GetSysUserList(string strSql)
{
SysGroup group = new SysGroup();
SysUser user = new SysUser();
int Counts = this.NetPagerParameter.RecordCount;
strSql += " and SysShop.ShopType=3 and SysUser.UserShopID = SysShop.ShopID and SysUser.UserGroupID = SysGroup.GroupID ";
switch (PubFunction.curParameter.istry)
{
case 0:
strSql += "and SysUser.UserID>1";
break;
case 2:
strSql += "and SysUser.UserID>1";
break;
}
if (this._UserGroupID != 1)
{
object obj = strSql;
strSql = string.Concat(new object[]
{
obj,
" and ((sysUser.UserID=",
this._UserID,
") or (UserGroupID in (select GroupID from SysGroup where ParentGroupID=0 or ParentIDStr like '%/",
int.Parse(this.txtUserType.Value),
"/%')))"
});
}
else
{
object obj = strSql;
strSql = string.Concat(new object[]
{
obj,
" and UserGroupID in (select GroupID from SysGroup where ParentGroupID=0 or ParentIDStr like '%/",
int.Parse(this.txtUserType.Value),
"/%' or GroupID=",
int.Parse(this.txtUserType.Value),
")"
});
}
DataTable db = user.GetListSP(this.NetPagerParameter.PageSize, this.NetPagerParameter.CurrentPageIndex, out Counts, new string[]
{
PubFunction.GetMemListShopAuthority(this._UserShopID, "UserShopID", 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.gvSysUserList.DataSource = db;
this.gvSysUserList.DataBind();
PageBase.BindSerialRepeater(this.gvSysUserList, this.NetPagerParameter.PageSize * (this.NetPagerParameter.CurrentPageIndex - 1));
}
private void GetSpecialList()
{
Special blls = new Special();
string strSql = string.Empty;
strSql += "1=1";
strSql += " and Special.SpecialUser = SysUser.UserID ";
strSql = strSql + "and SpecialUser="******"SpecialID", 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.gvSpecialList.DataSource = dtMem;
this.gvSpecialList.DataBind();
PageBase.BindSerialRepeater(this.gvSpecialList, this.NetPagerParameter.PageSize * (this.NetPagerParameter.CurrentPageIndex - 1));
}
private void GetMemList(string strSql)
{
Chain.BLL.Mem member = new Chain.BLL.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 ";
DataTable dtMem = member.GetListSP(this.NetPagerParameter.PageSize, this.NetPagerParameter.CurrentPageIndex, out Counts, new string[]
{
PubFunction.GetMemListShopAuthority(this._UserShopID, "MemShopID", 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.gvMemList.DataSource = dtMem;
this.gvMemList.DataBind();
PageBase.BindSerialRepeater(this.gvMemList, this.NetPagerParameter.PageSize * (this.NetPagerParameter.CurrentPageIndex - 1));
Chain.BLL.MemCustomField bllCustom = new Chain.BLL.MemCustomField();
List <Chain.Model.MemCustomField> fieldlist = bllCustom.GetModelList("CustomType=1 and CustomFieldIsShow=1");
if (fieldlist.Count > 0)
{
StringBuilder strHeader = new StringBuilder();
StringBuilder strHtml = new StringBuilder();
for (int i = 0; i < this.gvMemList.Items.Count; i++)
{
Literal ltlMemID = (Literal)this.gvMemList.Items[i].FindControl("ltlMemID");
Literal ltlHtml = (Literal)this.gvMemList.Items[i].FindControl("ltlHtml");
int MemID = Convert.ToInt32(ltlMemID.Text);
DataRow[] drMem = dtMem.Select(string.Format(" MemID = {0}", MemID));
strHtml.Length = 0;
foreach (Chain.Model.MemCustomField mdCustomField in fieldlist)
{
if (i == 0)
{
strHeader.AppendFormat("<th>{0}</th>", mdCustomField.CustomFieldName);
}
strHtml.AppendFormat("<td>{0}</td>", drMem[0][mdCustomField.CustomField]);
}
ltlHtml.Text = strHtml.ToString();
}
this.ltlHeader.Text = strHeader.ToString();
}
}
protected string QueryCondition()
{
string strWhere = " 1=1 ";
string strShopID = this.sltShop.Value;
if (strShopID != "1")
{
strWhere += string.Format(" and TemplateShopID in ({0})", this._UserShopID);
}
else
{
strWhere = strWhere + "and " + PubFunction.GetMemListShopAuthority(this._UserShopID, "TemplateShopID", strWhere);
}
return(strWhere);
}
protected void BtnMemExcel_Click(object sender, EventArgs e)
{
Chain.BLL.Mem bllMember = new Chain.BLL.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 ";
DataTable db = bllMember.GetListSP(100000, 1, out Counts, new string[]
{
PubFunction.GetMemListShopAuthority(this._UserShopID, "MemShopID", strSql)
}).Tables[0];
DataExcelInfo.MemReportExcel(db, this._UserName);
}
protected string QueryCondition()
{
string strMemShopID = this.sltShop.Value;
StringBuilder strSql = new StringBuilder();
strSql.Append(" SysShop.ShopID>0 and SysShop.ShopState=0 and SysShop.ShopType=3 ");
if (strMemShopID != "")
{
string strwhere = PubFunction.GetMemListShopAuthority(int.Parse(strMemShopID), "SysShop.ShopID", " 1=1 ");
strSql.AppendFormat(" and {0} ", strwhere);
}
else
{
string strwhere = PubFunction.GetMemListShopAuthority(this._UserShopID, "SysShop.ShopID", " 1=1 ");
strSql.AppendFormat(" and {0} ", strwhere);
}
return(strSql.ToString());
}
protected string QueryCondition()
{
string strMemShopID = this.sltShop.Value;
StringBuilder strSql = new StringBuilder();
strSql.Append(" ShopID>1 and ShopType=3 ");
if (this._UserShopID != 1)
{
string str = PubFunction.GetMemListShopAuthority(this._UserShopID, "ShopID", " 1=1 ");
strSql.AppendFormat(" and {0} ", str);
}
else
{
string str = PubFunction.GetMemListShopAuthority(this._UserShopID, "ShopID", " 1=1 ");
strSql.AppendFormat(" and {0} ", str);
}
return(strSql.ToString());
}
protected string QueryCondition()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("1=1 and SysShop.ShopType=3 ");
if (this.sltIsFinish.Value != "")
{
strSql.AppendFormat(" and IsFinish = {0}", this.sltIsFinish.Value);
}
if (this.sltShop.Value != "")
{
Chain.Model.SysShop shop = new Chain.BLL.SysShop().GetModel(Convert.ToInt32(this.sltShop.Value));
if (shop.ShopID == 1)
{
strSql.Append("");
}
else if (shop.IsAllianceProgram)
{
strSql.AppendFormat(" AND OutShopID IN (SELECT ShopID FROM SysShop WHERE FatherShopID = {0} or ShopID = {1} )", this.sltShop.Value, this.sltShop.Value);
}
else
{
strSql.AppendFormat(" and OutShopID = '{0}'", this.sltShop.Value);
}
}
else if (this._UserShopID == 1)
{
string str = " and " + PubFunction.GetMemListShopAuthority(this._UserShopID, "OutShopID", strSql.ToString());
strSql.Append(str);
}
else
{
strSql.AppendFormat(" AND OutShopID IN (SELECT ShopID FROM SysShop WHERE FatherShopID = {0} or ShopID = {1} )", this._UserShopID, this._UserShopID);
}
if (this.txtStartTime.Value != "")
{
strSql.AppendFormat("and StartTime>='{0}' ", this.txtStartTime.Value);
}
if (this.txtEndTime.Value != "")
{
strSql.AppendFormat("and EndTime<='{0}'", PubFunction.TimeEndDay(this.txtEndTime.Value));
}
return(strSql.ToString());
}
protected string QueryCondition()
{
string strQueryMem = this.txtQueryMem.Value;
string strMemLevelID = this.sltMemLevelID.Value;
string strMemShopID = this.sltShop.Value;
string strPointSymbols = this.sltPoint.Value;
string strPoint = (this.txtPoint.Value.Trim() != "") ? this.txtPoint.Value.Trim() : "0";
decimal intPoint = decimal.Parse(strPoint);
StringBuilder strSql = new StringBuilder();
strSql.Append("1=1");
if (strQueryMem != "")
{
strSql.AppendFormat("and (MemCard = '{0}' or MemName like '%{0}%' or MemMobile = '{0}' or MemCardNumber = '{0}' )", strQueryMem);
}
if (strMemLevelID != "")
{
strSql.AppendFormat("and Mem.MemLevelID={0}", int.Parse(strMemLevelID));
}
if (strMemShopID != "")
{
string strwhere = PubFunction.GetMemListShopAuthority(int.Parse(strMemShopID), "PointShopID", " 1=1 ");
strSql.AppendFormat(" and {0}", strwhere);
}
else
{
string strwhere = PubFunction.GetMemListShopAuthority(this._UserShopID, "PointShopID", " 1=1 ");
strSql.AppendFormat(" and {0}", strwhere);
}
if (intPoint != 0m)
{
strSql.AppendFormat("and PointNumber" + strPointSymbols + "{0}", intPoint);
}
if (this.txtStartTime.Value != "")
{
strSql.AppendFormat("and PointCreateTime>='{0}' ", this.txtStartTime.Value);
}
if (this.txtEndTime.Value != "")
{
strSql.AppendFormat("and PointCreateTime<='{0}'", PubFunction.TimeEndDay(this.txtEndTime.Value));
}
return(strSql.ToString());
}
public void CouponGetList()
{
Coupon coupon = new Coupon();
int Counts = this.NetPagerParameter.RecordCount;
string strWhere = " 1=1 ";
if (this._UserShopID != 1)
{
strWhere = strWhere + " and " + PubFunction.GetMemListShopAuthority(this._UserShopID, "CouponShopID", strWhere);
}
DataTable db = coupon.GetListSP(this.NetPagerParameter.PageSize, this.NetPagerParameter.CurrentPageIndex, out Counts, new string[]
{
strWhere
}).Tables[0];
this.NetPagerParameter.RecordCount = Counts;
this.gvCouponList.DataSource = db;
this.gvCouponList.DataBind();
PageBase.BindSerialRepeater(this.gvCouponList, this.NetPagerParameter.PageSize * (this.NetPagerParameter.CurrentPageIndex - 1));
}
private void BindMemExpenseMoney()
{
OrderLog bllOrder = new OrderLog();
string sbWhere = this.QueryCondition();
sbWhere += " and OrderLog.OrderMemID=Mem.MemID";
if (this.txtStartTime.Value != "")
{
this.timeStart = DateTime.Parse(this.txtStartTime.Value);
}
object obj = sbWhere;
sbWhere = string.Concat(new object[]
{
obj,
" and OrderLog.OrderCreateTime>='",
this.timeStart,
"'"
});
if (this.txtEndTime.Value != "")
{
this.timeEnd = Convert.ToDateTime(PubFunction.TimeEndDay(this.txtEndTime.Value));
}
obj = sbWhere;
sbWhere = string.Concat(new object[]
{
obj,
" and OrderLog.OrderCreateTime<='",
this.timeEnd,
"'"
});
if (this._UserShopID != 1)
{
sbWhere = PubFunction.GetMemListShopAuthority(this._UserShopID, "MemShopID", sbWhere);
}
DataTable dtMem = bllOrder.GetMemExpenseMoney(sbWhere).Tables[0];
this.lblTotalNumber.Text = dtMem.Rows[0]["TotalNumber"].ToString();
this.lblTotalMoney.Text = decimal.Parse(dtMem.Rows[0]["TotalMoney"].ToString()).ToString("0.00");
}
protected string QueryCondition()
{
string strQueryMem = this.txtQueryMem.Value;
string strMemShopID = this.sltShop.Value;
StringBuilder strSql = new StringBuilder();
strSql.Append(" 1=1 and MemID>0 and Mem.MemConsumeCount>0");
if (strQueryMem != "")
{
strSql.AppendFormat(" and (MemCard ='{0}' or MemName like '%{0}%' or MemMobile='{0}' or MemCardNumber = '{0}' )", strQueryMem);
}
if (strMemShopID != "")
{
string strwhere = PubFunction.GetMemListShopAuthority(int.Parse(strMemShopID), "MemShopID", " 1=1 ");
strSql.AppendFormat(" and {0}", strwhere);
}
else
{
string strwhere = PubFunction.GetMemListShopAuthority(this._UserShopID, "MemShopID", " 1=1 ");
strSql.AppendFormat(" and {0}", strwhere);
}
return(strSql.ToString());
}
