protected void btnSeach_Click(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
sb.Append("1=1 ");
string storeid = DisposeString.DisString(txtStoreId.Text);
if (storeid.Length > 0)
{
sb.Append(" and Storeid='" + storeid + "'");
}
string storename = Encryption.Encryption.GetEncryptionName(DisposeString.DisString(txtStoreName.Text));
if (storename.Length > 0)
{
sb.Append(" and StoreName like '" + storename + "%'");
}
UserControl_ExpectNum exp = Page.FindControl("ExpectNum1") as UserControl_ExpectNum;
int ExpectNum = exp.ExpectNum;
if (ExpectNum > 0)
{
sb.Append(" and ExpectNum=" + ExpectNum);
}
ViewState["sql"] = sb.ToString();
Pager pager = Page.FindControl("Pager1") as Pager;
pager.PageBind(0, 10, "StoreInfo", "ID,StoreInfo.Number,StoreId,StoreInfo.Name,StoreName", sb.ToString(), "RegisterDate", "givStoreInfo");
Translations();
}
protected void btnSeach_Click(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
sb.Append("1=1 and iszx=1 and type=0 ");
string mb = DisposeString.DisString(txtStoreid.Text);
if (mb.Length > 0)
{
sb.Append(" and storeid like '%" + PageBase.InputText(this.txtStoreid.Text.Trim()) + "%'");
}
if (this.DatePicker2.Text != "")
{
sb.Append(" and year(zxdate)=year('" + PageBase.InputText(this.DatePicker2.Text) + "') and month(zxdate)=month('" + PageBase.InputText(this.DatePicker2.Text) + "') and day(zxdate)=day('" + PageBase.InputText(this.DatePicker2.Text) + "') ");
}
UserControl_ExpectNum exp = Page.FindControl("ExpectNum1") as UserControl_ExpectNum;
int ExpectNum = exp.ExpectNum;
if (ExpectNum > 0)
{
sb.Append(" and zxqishu=" + ExpectNum);
}
ViewState["SQLSTR"] = "select id,iszx,storeid,name,storeoff.Number,zxqishu,zxdate,case when iszx=1 then '" + GetTran("001286", "已注销") + "' when iszx=2 then '" + GetTran("001287", "已恢复") + "' else '' end as zx from storeoff where " + sb.ToString();
Pager pager = Page.FindControl("Pager1") as Pager;
pager.PageBind(0, 10, "storeoff", "id,iszx,storeid,name,storeoff.Number,zxqishu,zxdate,case when iszx=1 then '" + GetTran("001286", "已注销") + "' when iszx=2 then '" + GetTran("001287", "已恢复") + "' else '' end as zx", sb.ToString(), "zxdate", "givTWmember");
}
protected void btnSeach_Click(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
sb.Append("1=1 and iszx=1 and type=0");
string mb = DisposeString.DisString(txt_member.Text);
if (mb.Length > 0)
{
sb.Append(" and Number like '%" + PageBase.InputText(this.txt_member.Text.Trim()) + "%'");
}
if (this.DatePicker2.Text != "")
{
sb.Append(" and year(zxdate)=year('" + PageBase.InputText(this.DatePicker2.Text) + "') and month(zxdate)=month('" + PageBase.InputText(this.DatePicker2.Text) + "') and day(zxdate)=day('" + PageBase.InputText(this.DatePicker2.Text) + "') ");
}
UserControl_ExpectNum exp = Page.FindControl("ExpectNum1") as UserControl_ExpectNum;
int ExpectNum = exp.ExpectNum;
if (ExpectNum > 0)
{
sb.Append(" and zxqishu=" + ExpectNum);
}
ViewState["SQLSTR"] = "select id,iszx,offReason,OperatorName,Name,Number,zxqishu,zxdate,case when iszx=1 then '" + GetTran("000000", "已冻结") + "' when iszx=2 then '" + GetTran("001287", "已恢复") + "' else '' end as zx from MemberoffSP ,memberinfobalance" + BLL.CommonClass.CommonDataBLL.GetMaxqishu() + " as b where " + sb.ToString();
Pager pager = Page.FindControl("Pager1") as Pager;
pager.PageBind(0, 10, "MemberOffSP ", "id,iszx,MemberOffSP.Name,offReason,Operator,MemberOffSP.Number,zxqishu,zxdate,case when iszx=1 then '" + GetTran("000000", "已冻结") + "' when iszx=2 then '" + GetTran("001287", "已恢复") + "' else '' end as zx", sb.ToString(), "zxdate", "givTWmember");
}
protected void btnSeach_Click(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
sb.Append("1=1");
string mb = DisposeString.DisString(txt_member.Text);
if (mb.Length > 0)
{
sb.Append(" and Number like '%" + this.txt_member.Text.Trim() + "%'");
}
if (this.DatePicker2.Text != "")
{
sb.Append(" and year(upddate)=year('" + this.DatePicker2.Text + "') and month(upddate)=month('" + this.DatePicker2.Text + "') and day(upddate)=day('" + this.DatePicker2.Text + "') ");
}
UserControl_ExpectNum exp = Page.FindControl("ExpectNum1") as UserControl_ExpectNum;
int ExpectNum = exp.ExpectNum;
if (ExpectNum > 0)
{
sb.Append(" and ExpectNum=" + ExpectNum);
}
Pager pager = Page.FindControl("Pager1") as Pager;
pager.PageBind(0, 10, "updatestore", "number ,oldstoreid,newstoreid,expectnum,case flag when 1 then '" + GetTran("001032", "个人所属店铺重置") + "' when 2 then '" + GetTran("001035", "团队所属店铺重置") + "' end as flag, upddate", sb.ToString(), "upddate", "givTWmember");
Translations();
}
protected void btnSeach_Click(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
sb.Append("1=1");
if (txt_member.Text.Trim().Length > 0)
{
if (this.DropDownList1.SelectedValue == "0")
{
sb.Append(" and nj.Number like '%" + PageBase.InputText(this.txt_member.Text.Trim()) + "%'");
}
else if (this.DropDownList1.SelectedValue == "1")
{
sb.Append(" and operateNum like '%" + PageBase.InputText(this.txt_member.Text.Trim()) + "%'");
}
}
if (this.DropDownList2.SelectedValue == "1")
{
sb.Append(" and type%2=1"); //奇数是安置
}
else if (this.DropDownList2.SelectedValue == "2")
{
sb.Append(" and type%2=0");
}
if (this.DatePicker2.Text != "")
{
sb.Append(" and year(AdjustDate)=year('" + Convert.ToDateTime(PageBase.InputText(this.DatePicker2.Text)) + "') and month(AdjustDate)=month('" + Convert.ToDateTime(PageBase.InputText(this.DatePicker2.Text)) + "') and day(AdjustDate)=day('" + Convert.ToDateTime(PageBase.InputText(this.DatePicker2.Text)) + "') ");
}
UserControl_ExpectNum exp = Page.FindControl("ExpectNum1") as UserControl_ExpectNum;
int ExpectNum = exp.ExpectNum;
if (ExpectNum > 0)
{
sb.Append(" and nj.ExpectNum=" + ExpectNum);
}
//sb.Append(" and " + GetNumber("nj"));
ViewState["SQLSTR"] = "select nj.Number,Original,NewLocation,nj.ExpectNum,AdjustDate,OperateNum,m1.name as name1,(select [name] from memberinfo where number=nj.Original) as name2,(select [name] from memberinfo where number=nj.NewLocation) as name3,case when type%2=1 then '" + GetTran("000663", "安置") + "' when type%2=0 then '" + GetTran("000667", "推荐") + "' else '' end as lx from NetAdjustmentHistory nj inner join memberinfo m1 on nj.number=m1.number where " + sb.ToString();
Pager pager = Page.FindControl("Pager1") as Pager;
pager.PageBind(0, 10, "NetAdjustmentHistory nj inner join memberinfo m1 on nj.number=m1.number", " nj.Number,Original,NewLocation,nj.ExpectNum,AdjustDate,OperateNum,m1.name as name1,(select [name] from memberinfo where number=nj.Original) as name2,(select [name] from memberinfo where number=nj.NewLocation) as name3,case when type%2=1 then '" + GetTran("000663", "安置") + "' when type%2=0 then '" + GetTran("000667", "推荐") + "' else '' end as lx", sb.ToString(), "nj.id", "givTWmember");
}
protected void btnSeasch_Click(object sender, EventArgs e)
{
//string pagecolumn = "ID,number,StoreID,name,StoreName,ExpectNum,Direct,TotalAccountMoney,OperateNum,Direct,OfficeTele,RegisterDate,StoreLevelStr";
StringBuilder sb = new StringBuilder();
sb.Append("1=1 ");
if (chShi.Checked)
{
if (this.CountryCity1.Country != "" && this.CountryCity1.Country != "" && this.CountryCity1.Country != "")
{
UserControl_CountryCity countryCity = Page.FindControl("CountryCity1") as UserControl_CountryCity;
string cp = DBHelper.ExecuteScalar("select cpccode from city where country='" + this.CountryCity1.Country + "' and province='" + this.CountryCity1.Province + "' and city='" + this.CountryCity1.City + "'").ToString();
sb.Append(" and cpccode='" + cp.ToString() + "'");
}
}
UserControl_ExpectNum expectnum = Page.FindControl("ExpectNum1") as UserControl_ExpectNum;
if (expectnum.ExpectNum > 0)
{
sb.Append(" and ExpectNum=" + expectnum.ExpectNum);
}
if (txtStoreId.Text.Trim().Length > 0)
{
sb.Append(" and StoreId='" + txtStoreId.Text.Trim() + "'");
}
if (ddl_shenhe.SelectedValue == "1")
{
sb.Append(" and number='" + Session["Member"].ToString() + "'");
ViewState["sql"] = sb.ToString();
string codition = sb.ToString();
Pager pager = Page.FindControl("Pager1") as Pager;
ViewState["pagewhere"] = sb.ToString();
pager.PageBind(0, 10, "UnauditedStoreInfo", pagecolumn, codition, "RegisterDate", "givStoreInfo");
}
else
{
sb.Remove(0, sb.Length);
sb.Append(" number='" + Session["Member"].ToString() + "'");
ViewState["sql"] = sb.ToString();
string codition = sb.ToString();
Pager pager = Page.FindControl("Pager1") as Pager;
ViewState["pagewhere"] = sb.ToString();
pager.PageBind(0, 10, "storeinfo", pagecolumn, codition, "RegisterDate", "givStoreInfo");
}
Translations();
}
protected void btnSeach_Click(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
sb.Append("1=1 and mp.number=mi.number ");
string mb = DisposeString.DisString(txt_member.Text);
if (mb.Length > 0)
{
sb.Append(" and mobiletele like '%" + PageBase.InputText(this.txt_member.Text.Trim()) + "%'");
}
if (txtName.Text.Length > 0)
{
sb.Append(" and name like '%" + PageBase.InputText(this.txtName.Text.Trim()) + "%'");
}
if (this.DatePicker2.Text != "")
{
sb.Append(" and year(zxdate)=year('" + Convert.ToDateTime(PageBase.InputText(this.DatePicker2.Text)).ToUniversalTime() + "') and month(zxdate)=month('" + Convert.ToDateTime(PageBase.InputText(this.DatePicker2.Text)).ToUniversalTime() + "') and day(zxdate)=day('" + Convert.ToDateTime(PageBase.InputText(this.DatePicker2.Text)).AddDays(1).ToUniversalTime() + "') ");
}
UserControl_ExpectNum exp = Page.FindControl("ExpectNum1") as UserControl_ExpectNum;
int ExpectNum = exp.ExpectNum;
if (ExpectNum > 0)
{
sb.Append(" and zxqishu=" + ExpectNum);
}
if (this.DropDownList1.SelectedValue != "0")
{
sb.Append(" and iszx=" + PageBase.InputText(this.DropDownList1.SelectedValue));
}
string col = "mi.mobiletele,mp.Name,mp.Number,zxqishu,zxdate,case when iszx=1 then '" + GetTran("007542", "已冻结") + "' when iszx=2 then '" + GetTran("001287", "已恢复") + "' else '' end as zx,offReason,Operator,OperatorName";
Pager pager = Page.FindControl("Pager1") as Pager;
pager.PageBind(0, 10, "MemberOffSP mp ,memberinfo mi", col, sb.ToString(), "mp.id", "givTWmember");
ViewState["SQLSTR"] = "select " + col + " from MemberOffSP where " + sb.ToString();
}
protected void btnSeasch_Click(object sender, EventArgs e)
{
//string pagecolumn = "ID,number,StoreID,name,StoreName,ExpectNum,Direct,TotalAccountMoney,OperateNum,Direct,OfficeTele,RegisterDate,StoreLevelStr";
StringBuilder sb = new StringBuilder();
sb.Append("1=1 and storestate = 0");
UserControl_ExpectNum expectnum = Page.FindControl("ExpectNum1") as UserControl_ExpectNum;
if (expectnum.ExpectNum > 0)
{
sb.Append(" and ExpectNum=" + expectnum.ExpectNum);
}
if (txtStoreId.Text.Trim().Length > 0)
{
sb.Append(" and StoreId='" + txtStoreId.Text.Trim() + "'");
}
ViewState["sql"] = sb.ToString();
string codition = sb.ToString();
Pager pager = Page.FindControl("Pager1") as Pager;
ViewState["pagewhere"] = sb.ToString();
pager.PageBind(0, 10, "StoreInfo ", pagecolumn, codition, "RegisterDate", "givStoreInfo");
Translations();
}
protected void BtnSeach_Click(object sender, EventArgs e)
{
string name = Encryption.Encryption.GetEncryptionName(DisposeString.DisString(this.txtname.Text));
string storeid = DisposeString.DisString(this.txtstoreid.Text);
string storename = Encryption.Encryption.GetEncryptionName(DisposeString.DisString(this.txtstorename.Text));
string level = dplLevel.SelectedValue;
int ExpectNum = 0;
UserControl_ExpectNum texpectnum = Page.FindControl("ExpectNum1") as UserControl_ExpectNum; //这边使用as转换没有必要使用try catch来捕获异常，因为使用as时，不能转换不会报异常只会返回一个null
if (texpectnum == null)
{
ExpectNum = -1;
}
else
{
ExpectNum = texpectnum.ExpectNum;
}
StringBuilder sb = new StringBuilder();
sb.Append(" 1=1 ");
if (name.Length > 0)
{
sb.Append(" and Name like '" + name + "%'");
}
if (storename.Length > 0)
{
sb.Append(" and StoreName like '" + storename + "%'");
}
if (storeid.Length > 0)
{
sb.Append(" and StoreId='" + storeid + "'");
}
if (level != "-1")
{
sb.Append(" and storelevelint=" + dplLevel.SelectedValue);
}
string totalDataStart = txtBox_OrderDateTimeStart.Text.Trim();
string totalDataEnd = txtBox_OrderDateTimeEnd.Text.Trim();
if (totalDataStart != "")
{
Convert.ToDateTime(totalDataStart);
sb.Append(" and dateadd(hour," + sphours + ",RegisterDate)>='" + totalDataStart + " 00:00:00'");
}
if (totalDataEnd != "")
{
Convert.ToDateTime(totalDataEnd);
sb.Append(" and dateadd(hour," + sphours + ",RegisterDate)<='" + totalDataEnd + " 23:59:59'");
}
if (ExpectNum > 0)
{
sb.Append(" and ExpectNum=" + ExpectNum);
}
ViewState["sql"] = sb.ToString();
Pager pager = this.Page.FindControl("Pager1") as Pager;
pager.PageTable = " StoreInfo";
pager.PageColumn = "ID,StoreInfo.Number,StoreID,StoreInfo.Name,StoreName,TotalAccountMoney,(TotalAccountMoney-TotalOrderGoodMoney-(select isnull(sum(ActualStorage*PreferentialPrice*(-1)),0) from Product,stock where Product.ProductId=stock.ProductId and stock.StoreId=StoreInfo.Storeid and ActualStorage<0)) as kebaodane,(TotalAccountMoney-TotalOrderGoodMoney) as kedinghuoe,ExpectNum,Direct,RegisterDate,StoreLevelInt,SCPCCode";
pager.PageSize = 10;
pager.Condition = sb.ToString();
pager.key = "ID";
pager.ControlName = "givSearchStoreInfo";
pager.Pageindex = 0;
pager.PageBind();
Translations();
}
protected void btnSeach_Click(object sender, EventArgs e)
{
if (ViewState["LevelType"].ToString() != "" && ViewState["LevelType"].ToString() == "Member")
{
StringBuilder sb = new StringBuilder();
sb.Append("1=1 and Grading.levelnum=bsco_level.levelint and bsco_level.levelflag=0 and Grading.GradingStatus=1");
string mb = DisposeString.DisString(txt_member.Text);
if (mb.Length > 0)
{
sb.Append(" and Number like '%" + this.txt_member.Text.Trim() + "%'");
}
if (this.DatePicker2.Text != "")
{
sb.Append(" and year(inputdate)=year('" + Convert.ToDateTime(this.DatePicker2.Text).ToUniversalTime() + "') and month(inputdate)=month('" + Convert.ToDateTime(this.DatePicker2.Text).ToUniversalTime() + "') and day(inputdate)=day('" + Convert.ToDateTime(this.DatePicker2.Text).AddDays(1).ToUniversalTime() + "') ");
}
UserControl_ExpectNum exp = Page.FindControl("ExpectNum1") as UserControl_ExpectNum;
int ExpectNum = exp.ExpectNum;
if (ExpectNum > 0)
{
sb.Append(" and ExpectNum=" + ExpectNum);
}
ViewState["SQLSTR"] = "select remark,operaternum,Number,Grading.ExpectNum,inputdate,bsco_level.levelstr as lv,isnull((select top 1 isnull(levelstr,'') from bsco_level where levelint=Grading.oldLN),'无') as oldlv,(select top 1 [name] from memberinfo where number=Grading.number) as name1 from Grading,bsco_level where " + sb.ToString();
Pager pager = Page.FindControl("Pager1") as Pager;
pager.PageBind(0, 10, "Grading,bsco_level", "remark,operaternum,Grading.Number,Grading.ExpectNum,inputdate,bsco_level.levelstr as lv,isnull((select top 1 isnull(levelstr,'') from bsco_level where levelflag=0 and levelint=Grading.oldLN),'无') as oldlv,(select top 1 [name] from memberinfo where number=Grading.number) as name1", sb.ToString(), "Grading.inputdate", "givTWmember");
givTWmember.Visible = true;
gv1.Visible = false;
}
else if (ViewState["LevelType"].ToString() != "" && ViewState["LevelType"].ToString() == "Store")
{
StringBuilder sb = new StringBuilder();
sb.Append("1=1 and Grading.levelnum=bsco_level.levelint and bsco_level.levelflag=1 and Grading.GradingStatus=0");
string mb = txt_member.Text.ToString();
if (mb.Length > 0)
{
sb.Append(" and Number like '%" + this.txt_member.Text.Trim() + "%'");
}
if (this.DatePicker2.Text != "")
{
sb.Append(" and year(inputdate)=year('" + this.DatePicker2.Text + "') and month(inputdate)=month('" + this.DatePicker2.Text + "') and day(inputdate)=day('" + this.DatePicker2.Text + "') ");
}
UserControl_ExpectNum exp = Page.FindControl("ExpectNum1") as UserControl_ExpectNum;
int ExpectNum = exp.ExpectNum;
if (ExpectNum > 0)
{
sb.Append(" and ExpectNum=" + ExpectNum);
}
ViewState["SQLSTR"] = "select remark,operaternum,Number,Grading.ExpectNum,inputdate,bsco_level.levelstr as lv,isnull((select top 1 isnull(levelstr,'') from bsco_level where levelflag=1 and levelint=Grading.oldLN),'无') as oldlv,(select top 1 [name] from storeinfo where storeid=Grading.number) as name1 from Grading,bsco_level where " + sb.ToString();
Pager pager = Page.FindControl("Pager1") as Pager;
pager.PageBind(0, 10, "Grading,bsco_level", "remark,operaternum,Number,Grading.ExpectNum,inputdate,bsco_level.levelstr as lv,isnull((select top 1 isnull(levelstr,'') from bsco_level where levelflag=1 and levelint=Grading.oldLN),'无') as oldlv,(select top 1 [name] from storeinfo where storeid=Grading.number) as name1", sb.ToString(), "Grading.inputdate", "gv1");
givTWmember.Visible = false;
gv1.Visible = true;
}
Translations();
}
