private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
this.btnExcel.Attributes.Add("onclick", "javascript:window.open('../DataGridToExcel.aspx', 'Sample', 'toolbar=no,location=no,directories=no,status=yes,menubar=yes,scrollbars=no,resizable=yes,copyhistory=yes,width=790,height=520,left=0,top=0')");
if (Session["Login"] != null)
{
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)Session["Login"];
// if(ls1.strLimit!="CL001")
// {
// this.SetErrorMsgPageBydir("对不起，你没有权限使用此功能！");
// return;
// }
if (!IsPostBack)
{
this.FillDropDownList("tbCommCode", ddlAssType, "vcCommSign ='AT'", "全部");
this.FillDropDownList("tbCommCode", ddlDept, "vcCommSign ='MD'", "全部");
if (ls1.strLimit != "CL001")
{
ddlDept.Items.FindByValue(ls1.strDeptID).Selected = true;
ddlDept.Enabled = false;
}
strBeginDate = DateTime.Now.ToShortDateString();
strEndDate = DateTime.Now.ToShortDateString();
string strDept = ddlDept.SelectedValue;
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
DataTable dtoper = busiq.GetConsOperList(strDept, strBeginDate, strEndDate);
this.FillDropDownList(dtoper, ddlOper, "全部");
Session.Remove("QUERY");
Session.Remove("toExcel");
Session.Remove("page_view");
}
else
{
strBeginDate = Request.Form["txtBegin"].ToString();
strEndDate = Request.Form["txtEnd"].ToString();
}
if (this.UcPageView1.MyDataGrid.DataSource != null)
{
if (((DataView)this.UcPageView1.MyDataGrid.DataSource).Count > 0)
{
UcPageView1.FootBar.Visible = true;
btnExcel.Enabled = true;
}
else
{
btnExcel.Enabled = false;
}
}
else
{
btnExcel.Enabled = false;
}
}
else
{
Response.Redirect("../Exit.aspx");
}
}
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if (Session["Login"] == null)
{
Response.Redirect("../Exit.aspx");
return;
}
string strAssid = Request.QueryString["aid"];
string strCardid = Request.QueryString["cid"];
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busi = new BusiComm.BusiQuery(strcons);
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)Session["Login"];
if (!IsPostBack)
{
Session.Remove("asold");
Session.Remove("asnew");
CMSMStruct.AssociatorStruct ass1 = busi.GetAssDetailInfo(strAssid, strCardid);
txtAssID.Text = ass1.strAssID;
txtCardID.Text = ass1.strCardID;
txtAssName.Text = ass1.strAssName;
txtSpell.Text = ass1.strSpell;
txtAssNbr.Text = ass1.strAssNbr;
txtAssType.Text = ass1.strAssType;
txtLinkPhone.Text = ass1.strLinkPhone;
txtEmail.Text = ass1.strEmail;
txtLinkAddress.Text = ass1.strLinkAddress;
txtComments.Text = ass1.strComments;
Session["asold"] = ass1;
}
}
protected void btQuery_Click(object sender, System.EventArgs e)
{
Session.Remove("QUERY");
Session.Remove("toExcel");
strBeginDate = Request.Form["txtBegin"].ToString();
strEndDate = Request.Form["txtEnd"].ToString();
if (strBeginDate == "" || strEndDate == "" || strBeginDate == null || strEndDate == null)
{
this.SetErrorMsgPageBydir("时间不能为空，请重新选择时间！");
return;
}
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
Hashtable htPara = new Hashtable();
string strOperName = ddlOper.SelectedValue;
string strDeptID = ddlDept.SelectedValue;
if (strOperName == "全部")
{
strOperName = "";
}
htPara.Add("strOperName", strOperName);
if (strDeptID == "全部")
{
strDeptID = "";
}
htPara.Add("strDeptID", strDeptID);
htPara.Add("strBegin", strBeginDate);
htPara.Add("strEnd", strEndDate);
try
{
DataTable dtout = busiq.GetDailyCashQuery(htPara);
if (dtout == null)
{
this.SetErrorMsgPageBydir("查询出错，请重试！");
// btnExcel.Enabled=false;
return;
}
UcPageView1.MyDataGrid.PageSize = 30;
DataView dvOut = new DataView(dtout);
this.UcPageView1.MyDataSource = dvOut;
this.UcPageView1.BindGrid();
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if (Session["Login"] != null)
{
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)Session["Login"];
if (!IsPostBack)
{
this.FillDropDownList("tbCommCode", ddlDept, "vcCommSign ='MD' and vcCommCode<>'FYZX1'", "全部");
this.FillDropDownList("AllREGION", ddlRegion, "", "全部");
if (ls1.strLimit != "CL001")
{
ddlDept.Items.FindByValue(ls1.strDeptID).Selected = true;
ddlDept.Enabled = false;
ddlRegion.Enabled = false;
}
strBeginDate = DateTime.Now.ToShortDateString();
strEndDate = DateTime.Now.ToShortDateString();
string strDept = ddlDept.SelectedValue;
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
DataTable dtoper = busiq.GetConsOperList(strDept, strBeginDate, strEndDate);
this.FillDropDownList(dtoper, ddlOper, "全部");
// Session.Remove("QUERY");
// Session.Remove("toExcel");
// Session.Remove("page_view");
}
else
{
strBeginDate = Request.Form["txtBegin"].ToString();
strEndDate = Request.Form["txtEnd"].ToString();
}
// if(this.UcPageView1.MyDataGrid.DataSource!=null)
// {
// if(((DataView)this.UcPageView1.MyDataGrid.DataSource).Count>0)
// {
// UcPageView1.FootBar.Visible = true;
//// btnExcel.Enabled=true;
// }
// else
// {
//// btnExcel.Enabled=false;
// }
// }
// else
// {
//// btnExcel.Enabled=false;
// }
}
else
{
Response.Redirect("../Exit.aspx");
}
}
protected void Button1_Click(object sender, System.EventArgs e)
{
//查询
try
{
//查询
Session.Remove("QUERY");
Session.Remove("toExcel");
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
string strDeptId = this.ddlDept.SelectedValue;
if (strDeptId == "全部")
{
strDeptId = "";
}
string strBeginDate = Convert.ToDateTime(this.txtBeginDate.Text).ToString("yyyy-MM-dd");
string strEndDate = Convert.ToDateTime(this.txtEndDate.Text).ToString("yyyy-MM-dd");
DataTable dtout = busiq.GetTimeSales(strDeptId, strBeginDate, strEndDate);
//this.TableConvert(dtout,"门店","tbCommCode","vcCommSign='MD'");
dtout.TableName = "门店时段消费统计";
DataTable dtexcel = dtout.Copy();
Session["QUERY"] = dtout;
Session["toExcel"] = dtexcel;
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)Session["Login"];
if (dtout.Rows.Count <= 0)
{
Button2.Enabled = false;
}
else
{
if (ls1.strLimit == "CL001")
{
Button2.Enabled = true;
}
}
UcPageView1.MyDataGrid.PageSize = 30;
DataView dvOut = new DataView(dtout);
this.UcPageView1.MyDataSource = dvOut;
this.UcPageView1.BindGrid();
}
catch (Exception ex)
{
this.clog.WriteLine(ex);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string strCardId = Request["vcCardId"];
this.lblCardId.Text = strCardId;
string strAssState = Request["OperFlag"];
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
DataTable dt = busiq.GetAssInfo(strCardId, strAssState);
if (dt == null || dt.Rows.Count == 0)
{
switch (strAssState)
{
case "0":
this.Popup("未找到会员资料或者此会员不在正常在用状态");
break;
case "1":
this.Popup("未找到会员资料或者此会员不在挂失状态");
break;
}
this.RedirectPage("wfmAssInfo.aspx");
return;
}
this.lblAssName.Text = dt.Rows[0]["vcAssName"].ToString();
this.lblLinkPhone.Text = dt.Rows[0]["vcLinkPhone"].ToString();
this.lblLinkAddress.Text = dt.Rows[0]["vcLinkAddress"].ToString();
this.lblAssState.Text = dt.Rows[0]["vcAssState"].ToString();
this.lblCharge.Text = dt.Rows[0]["nCharge"].ToString();
this.lblCreateDate.Text = dt.Rows[0]["dtCreateDate"].ToString();
this.lblOperDate.Text = dt.Rows[0]["dtOperDate"].ToString();
this.lblDept.Text = dt.Rows[0]["vcDeptName"].ToString();
this.hfAssId.Value = dt.Rows[0]["iAssId"].ToString();
this.hfAssState.Value = strAssState;
switch (strAssState)
{
case "0":
this.Button1.Text = "挂失";
break;
case "1":
this.Button1.Text = "解挂";
break;
}
}
}
protected void ddlDept_SelectedIndexChanged(object sender, System.EventArgs e)
{
string strDept = ddlDept.SelectedValue;
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
DataTable dtoper = busiq.GetConsOperList(strDept, strBeginDate, strEndDate);
this.FillDropDownList(dtoper, ddlOper, "全部");
this.UcPageView1.MyDataGrid.DataSource = null;
this.UcPageView1.MyDataGrid.DataBind();
this.UcPageView1.FootBar.Visible = false;
}
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if (Session["Login"] == null)
{
Response.Redirect("../Exit.aspx");
return;
}
string strAssid = Request.QueryString["aid"];
string strCardid = Request.QueryString["cid"];
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busi = new BusiComm.BusiQuery(strcons);
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)Session["Login"];
if (!IsPostBack)
{
Session.Remove("asold");
Session.Remove("asnew");
CMSMStruct.AssociatorStruct ass1 = busi.GetAssDetailInfo(strAssid, strCardid);
txtAssID.Text = ass1.strAssID;
txtCardID.Text = ass1.strCardID;
txtAssName.Text = ass1.strAssName;
txtSpell.Text = ass1.strSpell;
txtAssNbr.Text = ass1.strAssNbr;
if (ass1.strAssTypeDisp == "X" || ass1.strAssTypeDisp == "x")
{
this.FillDropDownList("AssAT", this.ddlAssType, "vcCommSign='AT'");
this.ddlAssType.Enabled = false;
}
else
{
this.FillDropDownList("AT1", this.ddlAssType);
this.ddlAssType.Enabled = true;
}
ddlAssType.SelectedIndex = ddlAssType.Items.IndexOf(ddlAssType.Items.FindByValue(ass1.strAssType));
txtLinkPhone.Text = ass1.strLinkPhone;
txtEmail.Text = ass1.strEmail;
txtLinkAddress.Text = ass1.strLinkAddress;
txtComments.Text = ass1.strComments;
Session["asold"] = ass1;
}
}
protected void Button1_Click(object sender, System.EventArgs e)
{
try
{
//查询
Session.Remove("QUERY");
Session.Remove("toExcel");
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
DataTable dtout = busiq.GetSalesSum(ddlYear.SelectedValue, ddlMonths.SelectedValue, ddlNextMonths.SelectedValue);
this.TableConvert(dtout, "门店", "tbCommCode", "vcCommSign='MD' and vcCommCode<>'FYZX1'");
dtout.TableName = "销售汇总表";
DataTable dtexcel = dtout.Copy();
Session["QUERY"] = dtout;
Session["toExcel"] = dtexcel;
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)Session["Login"];
if (dtout.Rows.Count <= 0)
{
Button2.Enabled = false;
}
else
{
if (ls1.strLimit == "CL001")
{
Button2.Enabled = true;
}
}
UcPageView1.MyDataGrid.PageSize = 30;
DataView dvOut = new DataView(dtout);
this.UcPageView1.MyDataSource = dvOut;
this.UcPageView1.BindGrid();
}
catch (Exception ex)
{
this.clog.WriteLine(ex);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
protected void btQuery_Click(object sender, System.EventArgs e)
{
Session.Remove("QUERY");
Session.Remove("toExcel");
strBeginDate = Request.Form["txtBegin"].ToString();
strEndDate = Request.Form["txtEnd"].ToString();
if (strBeginDate == "" || strBeginDate == null)
{
this.SetErrorMsgPageBydir("时间不能为空，请重新选择时间！");
return;
}
string[] beginlist = strBeginDate.Split('-');
string[] endlist = strEndDate.Split('-');
if (beginlist.Length != 3)
{
this.SetErrorMsgPageBydir("时间格式不正确！");
return;
}
string strBegin = strBeginDate;
string strEnd = strEndDate;
strBegin = beginlist[0];
if (int.Parse(beginlist[1]) < 10)
{
strBegin += "0" + beginlist[1];
}
else
{
strBegin += beginlist[1];
}
if (int.Parse(beginlist[2]) < 10)
{
strBegin += "0" + beginlist[2];
}
else
{
strBegin += beginlist[2];
}
DateTime dtyestoday = new DateTime(int.Parse(beginlist[0]), int.Parse(beginlist[1]), int.Parse(beginlist[2]));
dtyestoday = dtyestoday.AddDays(-1);
string strYestoday = dtyestoday.Year.ToString();
if (dtyestoday.Month < 10)
{
strYestoday += "0" + dtyestoday.Month.ToString();
}
else
{
strYestoday += dtyestoday.Month.ToString();
}
if (dtyestoday.Day < 10)
{
strYestoday += "0" + dtyestoday.Day.ToString();
}
else
{
strYestoday += dtyestoday.Day.ToString();
}
strEnd = endlist[0];
if (int.Parse(endlist[1]) < 10)
{
strEnd += "0" + endlist[1];
}
else
{
strEnd += endlist[1];
}
if (int.Parse(endlist[2]) < 10)
{
strEnd += "0" + endlist[2];
}
else
{
strEnd += endlist[2];
}
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
string strDeptID = ddlDept.SelectedValue;
string strDeptName = ddlDept.SelectedItem.Text.Trim();
Hashtable htPara = new Hashtable();
if (strDeptID == "全部")
{
strDeptID = "%%";
}
htPara.Add("strDeptID", strDeptID);
htPara.Add("strBegin", strBegin);
htPara.Add("strEnd", strEnd);
htPara.Add("strYestoday", strYestoday);
try
{
DataTable dtout = busiq.BusiIncomeReport(htPara, strDeptName);
if (dtout == null)
{
this.SetErrorMsgPageBydir("查询出错，请重试！");
btnExcel.Enabled = false;
return;
}
else
{
if (strDeptName == "全部")
{
dtout.TableName = "业务量报表-所有门店";
}
else
{
dtout.TableName = "业务量报表-" + strDeptName;
}
DataTable dtexcel = dtout.Copy();
Session["QUERY"] = dtout;
Session["toExcel"] = dtexcel;
if (dtout.Rows.Count <= 0)
{
btnExcel.Enabled = false;
}
else
{
btnExcel.Enabled = true;
}
}
UcPageView1.MyDataGrid.PageSize = 40;
DataView dvOut1 = new DataView(dtout);
this.UcPageView1.MyDataSource = dvOut1;
this.UcPageView1.BindGrid();
this.UcPageView1.FootBar.Visible = false;
if (strDeptName != "全部")
{
this.UcPageView1.MyDataGrid.Items[16].BackColor = Color.SkyBlue;
this.UcPageView1.MyDataGrid.Items[23].BackColor = Color.SkyBlue;
this.UcPageView1.MyDataGrid.Items[30].BackColor = Color.SkyBlue;
this.UcPageView1.MyDataGrid.Items[50].BackColor = Color.SkyBlue;
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
private void btQuery_Click(object sender, System.EventArgs e)
{
Session.Remove("QUERY");
Session.Remove("toExcel");
strBeginDate = Request.Form["txtBegin"].ToString();
strEndDate = Request.Form["txtEnd"].ToString();
if (strBeginDate == "" || strEndDate == "" || strBeginDate == null || strEndDate == null)
{
this.SetErrorMsgPageBydir("时间不能为空，请重新选择时间！");
return;
}
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
string strOperName = ddlOper.SelectedValue;
string strDeptID = ddlDept.SelectedValue;
string strCardID = this.txtCardID.Text.Trim();
Hashtable htPara = new Hashtable();
if (strOperName == "全部")
{
strOperName = "";
}
htPara.Add("strOperName", strOperName);
if (strDeptID == "全部")
{
strDeptID = "";
}
htPara.Add("strCardID", strCardID);
htPara.Add("strDeptID", strDeptID);
htPara.Add("strBegin", strBeginDate);
htPara.Add("strEnd", strEndDate);
try
{
DataTable dtout = busiq.GetBusiLogQuery(htPara);
if (dtout == null)
{
this.SetErrorMsgPageBydir("查询出错，请重试！");
btnExcel.Enabled = false;
return;
}
else
{
this.TableConvert(dtout, "会员类型", "tbCommCode", "vcCommSign='AT'");
this.TableConvert(dtout, "操作员门店", "tbCommCode", "vcCommSign='MD'");
dtout.TableName = "操作员日志";
DataTable dtexcel = dtout.Copy();
Session["QUERY"] = dtout;
for (int i = 0; i < dtexcel.Rows.Count; i++)
{
if (dtexcel.Rows[i][3].ToString().Substring(0, 1) != "V")
{
dtexcel.Rows[i][3] = "'" + dtexcel.Rows[i][3].ToString();
}
}
Session["toExcel"] = dtexcel;
if (dtout.Rows.Count <= 0)
{
btnExcel.Enabled = false;
}
else
{
btnExcel.Enabled = true;
}
}
UcPageView1.MyDataGrid.PageSize = 30;
DataView dvOut = new DataView(dtout);
this.UcPageView1.MyDataSource = dvOut;
this.UcPageView1.BindGrid();
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
private void btQuery_Click(object sender, System.EventArgs e)
{
Session.Remove("QUERY");
Session.Remove("toExcel");
strBeginDate = Request.Form["txtBegin"].ToString();
strEndDate = Request.Form["txtEnd"].ToString();
if (strBeginDate == "" || strEndDate == "" || strBeginDate == null || strEndDate == null)
{
this.SetErrorMsgPageBydir("时间不能为空，请重新选择时间！");
return;
}
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
Hashtable htPara = new Hashtable();
string strConsType = this.ddlConsType.SelectedValue;
string strOperName = ddlOper.SelectedValue;
string strDeptID = ddlDept.SelectedValue;
if (strConsType == "全部")
{
strConsType = "";
}
htPara.Add("strConsType", strConsType);
if (strOperName == "全部")
{
strOperName = "";
}
htPara.Add("strOperName", strOperName);
if (strDeptID == "全部")
{
strDeptID = "";
}
htPara.Add("strDeptID", strDeptID);
htPara.Add("strBegin", strBeginDate);
htPara.Add("strEnd", strEndDate);
try
{
//double dsum=0;
DataTable dtout = busiq.GetSpecConsQuery(htPara);
if (dtout == null)
{
this.SetErrorMsgPageBydir("查询出错，请重试！");
btnExcel.Enabled = false;
return;
}
else
{
this.TableConvert(dtout, "特殊消费类型", "tbCommCode", "vcCommSign='PT'");
dtout.TableName = "特殊消费统计";
DataTable dtexcel = dtout.Copy();
Session["QUERY"] = dtout;
Session["toExcel"] = dtexcel;
if (dtout.Rows.Count <= 0)
{
btnExcel.Enabled = false;
}
else
{
btnExcel.Enabled = true;
}
}
UcPageView1.MyDataGrid.PageSize = 30;
DataView dvOut = new DataView(dtout);
this.UcPageView1.MyDataSource = dvOut;
this.UcPageView1.BindGrid();
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
private void btQuery_Click(object sender, System.EventArgs e)
{
Session.Remove("QUERY");
Session.Remove("toExcel");
strBeginDate = Request.Form["txtBegin"].ToString();
strEndDate = Request.Form["txtEnd"].ToString();
if (strBeginDate == "" || strEndDate == "" || strBeginDate == null || strEndDate == null)
{
this.SetErrorMsgPageBydir("时间不能为空，请重新选择时间！");
return;
}
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
Hashtable htPara = new Hashtable();
string strAssType = ddlAssType.SelectedValue;
string strDeptID = ddlDept.SelectedValue;
string strGoodsType = ddlGoodsType.SelectedValue;
string strGoodsName = this.txtGoodsName.Text.Trim();
if (strAssType == "全部")
{
strAssType = "";
}
if (strDeptID == "全部")
{
strDeptID = "";
}
if (strGoodsType == "全部")
{
strGoodsType = "";
}
htPara.Add("strAssType", strAssType);
htPara.Add("strDeptID", strDeptID);
htPara.Add("strGoodsType", strGoodsType);
htPara.Add("strBegin", strBeginDate);
htPara.Add("strEnd", strEndDate);
htPara.Add("strGoodsName", strGoodsName);
try
{
string querytype = "0";
DataTable dtout = new DataTable();
if (chbAssType.Checked && chbGoodsType.Checked && chbDept.Checked)
{
querytype = "1";
dtout = busiq.GetConsKindQuery(htPara, querytype);
if (dtout == null)
{
this.SetErrorMsgPageBydir("查询出错，请重试！");
btnExcel.Enabled = false;
return;
}
this.TableConvert(dtout, "门店", "tbCommCode", "vcCommSign ='MD'");
this.TableConvert(dtout, "会员类型", "tbCommCode", "vcCommSign ='AT'");
// this.TableConvert(dtout,"商品类型","PClass","vcCommSign ='FINALPRODUCT'");
}
else if (chbAssType.Checked && !chbGoodsType.Checked && !chbDept.Checked)
{
querytype = "2";
dtout = busiq.GetConsKindQuery(htPara, querytype);
}
else if (!chbAssType.Checked && chbGoodsType.Checked && !chbDept.Checked)
{
querytype = "3";
dtout = busiq.GetConsKindQuery(htPara, querytype);
// this.TableConvert(dtout,"商品类型","PClass","vcCommSign ='FINALPRODUCT'");
}
else if (!chbAssType.Checked && !chbGoodsType.Checked && chbDept.Checked)
{
querytype = "4";
dtout = busiq.GetConsKindQuery(htPara, querytype);
this.TableConvert(dtout, "门店", "tbCommCode", "vcCommSign ='MD'");
}
else if (chbAssType.Checked && chbGoodsType.Checked && !chbDept.Checked)
{
querytype = "5";
dtout = busiq.GetConsKindQuery(htPara, querytype);
if (dtout == null)
{
this.SetErrorMsgPageBydir("查询出错，请重试！");
btnExcel.Enabled = false;
return;
}
this.TableConvert(dtout, "会员类型", "tbCommCode", "vcCommSign ='AT'");
// this.TableConvert(dtout,"商品类型","PClass","vcCommSign ='FINALPRODUCT'");
}
else if (chbAssType.Checked && !chbGoodsType.Checked && chbDept.Checked)
{
querytype = "6";
dtout = busiq.GetConsKindQuery(htPara, querytype);
if (dtout == null)
{
this.SetErrorMsgPageBydir("查询出错，请重试！");
btnExcel.Enabled = false;
return;
}
this.TableConvert(dtout, "门店", "tbCommCode", "vcCommSign ='MD'");
this.TableConvert(dtout, "会员类型", "tbCommCode", "vcCommSign ='AT'");
}
else if (!chbAssType.Checked && chbGoodsType.Checked && chbDept.Checked)
{
querytype = "7";
dtout = busiq.GetConsKindQuery(htPara, querytype);
if (dtout == null)
{
this.SetErrorMsgPageBydir("查询出错，请重试！");
btnExcel.Enabled = false;
return;
}
this.TableConvert(dtout, "门店", "tbCommCode", "vcCommSign ='MD'");
// this.TableConvert(dtout,"商品类型","PClass","vcCommSign ='FINALPRODUCT'");
}
if (querytype == "0")
{
this.SetErrorMsgPageBydir("请至少选择一个分类项！");
btnExcel.Enabled = false;
return;
}
if (dtout == null)
{
this.SetErrorMsgPageBydir("查询出错，请重试！");
btnExcel.Enabled = false;
return;
}
else
{
dtout.TableName = "消费分类统计";
DataTable dtexcel = dtout.Copy();
Session["QUERY"] = dtout;
Session["toExcel"] = dtexcel;
if (dtout.Rows.Count <= 0)
{
btnExcel.Enabled = false;
this.lblSumCount.Text = "总数量：0";
this.lblSumFee.Text = "总金额：0元";
}
else
{
double sumcount = 0;
double sumfee = 0;
for (int j = 0; j < dtout.Rows.Count; j++)
{
sumcount += Math.Round(double.Parse(dtout.Rows[j]["数量合计"].ToString()), 2);
sumfee += Math.Round(double.Parse(dtout.Rows[j]["金额合计"].ToString()), 2);
}
this.lblSumCount.Text = "总数量：" + sumcount.ToString();
this.lblSumFee.Text = "总金额：" + sumfee.ToString() + "元";
btnExcel.Enabled = true;
}
}
UcPageView1.MyDataGrid.PageSize = 20;
DataView dvOut = new DataView(dtout);
this.UcPageView1.MyDataSource = dvOut;
this.UcPageView1.BindGrid();
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
protected void btQuery_Click(object sender, System.EventArgs e)
{
Session.Remove("QUERY");
Session.Remove("toExcel");
strBeginDate = Request.Form["txtBegin"].ToString();
strEndDate = Request.Form["txtEnd"].ToString();
if (strBeginDate == "" || strEndDate == "" || strBeginDate == null || strEndDate == null)
{
this.SetErrorMsgPageBydir("时间不能为空，请重新选择时间！");
return;
}
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
string strtype = ddlType.SelectedValue;
string strDeptID = ddlDept.SelectedValue;
Hashtable htPara = new Hashtable();
if (strDeptID == "全部")
{
strDeptID = "";
}
htPara.Add("strDeptID", strDeptID);
htPara.Add("strBegin", strBeginDate);
htPara.Add("strEnd", strEndDate);
try
{
DataTable dtout = busiq.GetTopQuery(htPara, strtype);
if (dtout == null)
{
this.SetErrorMsgPageBydir("查询出错，请重试！");
btnExcel.Enabled = false;
return;
}
else
{
if (strtype == "0")
{
dtout.TableName = "销售商品排行表";
}
else
{
dtout.TableName = "会员消费排行表";
}
DataTable dtexcel = dtout.Copy();
Session["QUERY"] = dtout;
if (strtype == "1")
{
for (int i = 0; i < dtexcel.Rows.Count; i++)
{
if (dtexcel.Rows[i][0].ToString().Substring(0, 1) != "V")
{
dtexcel.Rows[i][0] = "'" + dtexcel.Rows[i][0].ToString();
}
}
}
Session["toExcel"] = dtexcel;
if (dtout.Rows.Count <= 0)
{
btnExcel.Enabled = false;
}
else
{
btnExcel.Enabled = true;
}
}
UcPageView1.MyDataGrid.PageSize = 30;
DataView dvOut = new DataView(dtout);
this.UcPageView1.MyDataSource = dvOut;
this.UcPageView1.BindGrid();
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
protected void btQuery_Click(object sender, System.EventArgs e)
{
Session.Remove("QUERY");
Session.Remove("toExcel");
strBeginDate = Request.Form["txtBegin"].ToString();
strEndDate = Request.Form["txtEnd"].ToString();
if (strBeginDate == "" || strEndDate == "" || strBeginDate == null || strEndDate == null)
{
this.SetErrorMsgPageBydir("时间不能为空，请重新选择时间！");
return;
}
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
Hashtable htPara = new Hashtable();
string strCardID = txtCardID.Text.Trim();
htPara.Add("strCardID", strCardID);
string strAssName = txtAssName.Text.Trim();
htPara.Add("strAssName", strAssName);
string strLinkPhone = txtLinkPhone.Text.Trim();
htPara.Add("strLinkPhone", strLinkPhone);
string strDeptID = ddlDept.SelectedValue;
if (strDeptID == "全部")
{
strDeptID = "";
}
htPara.Add("strDeptID", strDeptID);
htPara.Add("strBeginDate", strBeginDate);
htPara.Add("strEndDate", strEndDate);
try
{
DataTable dtout = busiq.GetCardRecycle(htPara);
if (dtout == null)
{
this.SetErrorMsgPageBydir("查询出错，请重试！");
btnExcel.Enabled = false;
return;
}
else
{
this.TableConvert(dtout, "会员类型", "tbCommCode", "vcCommSign='AT'");
this.TableConvert(dtout, "会员状态", "tbCommCode", "vcCommSign='AS'");
this.TableConvert(dtout, "门店", "tbCommCode", "vcCommSign='MD'");
dtout.TableName = "会员卡回收清单";
DataTable dtexcel = dtout.Copy();
Session["QUERY"] = dtout;
for (int i = 0; i < dtexcel.Rows.Count; i++)
{
if (this.JudgeIsNum(dtexcel.Rows[i][0].ToString().Substring(0, 1)))
{
dtexcel.Rows[i][0] = "'" + dtexcel.Rows[i][0].ToString();
}
dtexcel.Rows[i][2] = "'" + dtexcel.Rows[i][2].ToString();
dtexcel.Rows[i][10] = "'" + dtexcel.Rows[i][10].ToString();
}
Session["toExcel"] = dtexcel;
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)Session["Login"];
if (dtout.Rows.Count <= 0)
{
btnExcel.Enabled = false;
}
else
{
if (ls1.strLimit == "CL001")
{
btnExcel.Enabled = true;
}
}
}
UcPageView1.MyDataGrid.PageSize = 30;
DataView dvOut = new DataView(dtout);
this.UcPageView1.MyDataSource = dvOut;
this.UcPageView1.BindGrid();
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
this.btnExcel.Attributes.Add("onclick", "javascript:window.open('../DataGridToExcel.aspx', 'Sample', 'toolbar=no,location=no,directories=no,status=yes,menubar=yes,scrollbars=no,resizable=yes,copyhistory=yes,width=790,height=520,left=0,top=0')");
if (Session["Login"] != null)
{
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)Session["Login"];
// if(ls1.strLimit!="CL001")
// {
// this.SetErrorMsgPageBydir("对不起，你没有权限使用此功能！");
// return;
// }
if (!IsPostBack)
{
this.FillDropDownList("tbCommCode", ddlAssType, "vcCommSign ='AT'", "全部");
this.FillDropDownList("tbCommCode", ddlDept, "vcCommSign ='MD' and vcCommCode<>'FYZX1'", "全部");
this.FillDropDownList("tbCommCode", ddlBillType, "vcCommSign ='PT'", "全部");
this.FillDropDownList("tbCommCode", ddlAssState, "vcCommSign ='AS'", "所有");
this.FillDropDownList("AllREGION", ddlRegion, "", "全部");
this.ddlConsFlag.Items.Add(new ListItem("正常消费", "0"));
this.ddlConsFlag.Items.Add(new ListItem("已撤消", "9"));
this.ddlConsFlag.SelectedIndex = 0;
if (ls1.strLimit != "CL001")
{
ddlDept.Items.FindByValue(ls1.strDeptID).Selected = true;
ddlDept.Enabled = false;
ddlRegion.Enabled = false;
}
strBeginDate = DateTime.Now.ToShortDateString();
strEndDate = DateTime.Now.ToShortDateString();
string strDept = ddlDept.SelectedValue;
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
DataTable dtoper = busiq.GetConsOperList(strDept, strBeginDate, strEndDate);
this.FillDropDownList(dtoper, ddlOper, "全部");
Session.Remove("QUERY");
Session.Remove("toExcel");
Session.Remove("page_view");
#region 控制按钮显示
this.Button1.Visible = false;
this.Button2.Visible = false;
Hashtable htOperFunc = (Hashtable)Application["OperFunc"];
ArrayList almenu = (ArrayList)htOperFunc[ls1.strLoginID];
if (almenu != null)
{
for (int i = 0; i < almenu.Count; i++)
{
CMSMStruct.MenuStruct ms1 = (CMSMStruct.MenuStruct)almenu[i];
System.Web.UI.WebControls.Button btnCurrent = this.FindControl(ms1.strFuncAddress.Replace("wfmConsItem_", String.Empty)) as System.Web.UI.WebControls.Button;
if (btnCurrent != null)
{
btnCurrent.Visible = true;
this.Button2.Visible = true;
}
}
}
#endregion
}
else
{
strBeginDate = Request.Form["txtBegin"].ToString();
strEndDate = Request.Form["txtEnd"].ToString();
}
}
else
{
Response.Redirect("../Exit.aspx");
}
}
protected void Button3_Click(object sender, System.EventArgs e)
{
//查询套餐
Session.Remove("QUERY");
Session.Remove("toExcel");
strBeginDate = Request.Form["txtBegin"].ToString();
strEndDate = Request.Form["txtEnd"].ToString();
//Table4.Width= "1224px";
if (strBeginDate == "" || strEndDate == "" || strBeginDate == null || strEndDate == null)
{
this.SetErrorMsgPageBydir("时间不能为空，请重新选择时间！");
return;
}
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
Hashtable htPara = new Hashtable();
string strCardID = txtCardID.Text.Trim();
htPara.Add("strCardID", strCardID);
string strAssName = txtAssName.Text.Trim();
htPara.Add("strAssName", strAssName);
string strSerial = txtSerial.Text.Trim();
htPara.Add("strSerial", strSerial);
string strAssType = ddlAssType.SelectedValue;
string strOperName = ddlOper.SelectedValue;
string strDeptID = ddlDept.SelectedValue;
string strConsFlag = this.ddlConsFlag.SelectedValue;
string strBillType = this.ddlBillType.SelectedValue;
if (strAssType == "全部")
{
strAssType = "";
}
htPara.Add("strAssType", strAssType);
if (strOperName == "全部")
{
strOperName = "";
}
htPara.Add("strOperName", strOperName);
if (strDeptID == "全部")
{
strDeptID = "";
}
htPara.Add("strDeptID", strDeptID);
if (strBillType == "全部")
{
strBillType = "";
}
htPara.Add("strBillType", strBillType);
htPara.Add("strBegin", strBeginDate);
htPara.Add("strEnd", strEndDate);
htPara.Add("strConsFlag", strConsFlag);
string strConfirm = this.ddlConfirm.SelectedValue;
if (strConfirm == "全部")
{
strConfirm = "";
}
htPara.Add("strConfirm", strConfirm);
htPara.Add("bPackage", true);
string strPackage = this.ddlPackage.SelectedValue;
if (strPackage == "全部")
{
strPackage = "";
}
htPara.Add("strPackage", strPackage);
string strAssState = ddlAssState.SelectedValue;
if (strAssState == "所有")
{
strAssState = "Roll";
}
htPara.Add("strAssState", strAssState);
try
{
double dsum = 0;
double dcashsum = 0;
DataTable dtout = busiq.GetConsQuery(htPara);
if (dtout == null)
{
this.SetErrorMsgPageBydir("查询出错，请重试！");
btnExcel.Enabled = false;
return;
}
else
{
dtout.Columns["备注"].ColumnName = "套餐数量";
this.TableConvert(dtout, "会员类型", "tbCommCode", "vcCommSign='AT'");
this.TableConvert(dtout, "付款类型", "tbCommCode", "vcCommSign='PT'");
Session["ConfirmConsItem"] = dtout.Copy();
this.TableConvert(dtout, "门店", "tbCommCode", "vcCommSign='MD'");
dtout.TableName = "消费明细";
DataTable dtexcel = dtout.Copy();
Session["QUERY"] = dtout;
for (int i = 0; i < dtexcel.Rows.Count; i++)
{
dsum += Math.Round(double.Parse(dtexcel.Rows[i]["合计"].ToString()), 2);
if (dtexcel.Rows[i]["付款类型"].ToString() == "支付现金")
{
dcashsum += Math.Round(double.Parse(dtexcel.Rows[i]["合计"].ToString()), 2);
}
if (dtexcel.Rows[i]["会员卡号"].ToString().Substring(0, 1) != "V")
{
dtexcel.Rows[i]["会员卡号"] = "'" + dtexcel.Rows[i]["会员卡号"].ToString();
}
dtexcel.Rows[i]["商品名称"] = "'" + dtexcel.Rows[i]["商品名称"].ToString();
}
Session["toExcel"] = dtexcel;
if (dtout.Rows.Count <= 0)
{
btnExcel.Enabled = false;
}
else
{
btnExcel.Enabled = true;
}
}
dsum = Math.Round(dsum, 2);
dcashsum = Math.Round(dcashsum, 2);
this.lblSum.Text = "金额汇总：" + dsum.ToString() + "元\r\r\r\r\r\r\r\r现金汇总：" + dcashsum.ToString() + "元";
UcPageView1.MyDataGrid.PageSize = 30;
DataView dvOut = new DataView(dtout);
this.UcPageView1.MyDataSource = dvOut;
this.UcPageView1.BindGrid();
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
protected void btQuery_Click(object sender, System.EventArgs e)
{
Session.Remove("QUERY");
Session.Remove("toExcel");
strBeginDate = Request.Form["txtBegin"].ToString();
strEndDate = Request.Form["txtEnd"].ToString();
if (strBeginDate == "" || strEndDate == "" || strBeginDate == null || strEndDate == null)
{
this.SetErrorMsgPageBydir("时间不能为空，请重新选择时间！");
return;
}
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
Hashtable htPara = new Hashtable();
string strCardID = txtCardID.Text.Trim();
htPara.Add("strCardID", strCardID);
string strAssName = txtAssName.Text.Trim();
htPara.Add("strAssName", strAssName);
string strAssType = ddlAssType.SelectedValue;
string strAssState = ddlAssState.SelectedValue;
string strDeptID = ddlDept.SelectedValue;
if (strAssType == "全部")
{
strAssType = "";
}
htPara.Add("strAssType", strAssType);
if (strAssState == "全部")
{
strAssState = "";
}
htPara.Add("strAssState", strAssState);
if (strDeptID == "全部")
{
strDeptID = "";
}
htPara.Add("strDeptID", strDeptID);
htPara.Add("strBeginDate", strBeginDate);
htPara.Add("strEndDate", strEndDate);
string strLinkPhone = this.txtLinkPhone.Text;
htPara.Add("strLinkPhone", strLinkPhone);
try
{
DataTable dtout = busiq.GetAssInfo(htPara);
if (dtout == null)
{
this.SetErrorMsgPageBydir("查询出错，请重试！");
btnExcel.Enabled = false;
return;
}
else
{
// this.TableConvert(dtout,"会员类型","tbCommCode","vcCommSign='AT'");
this.TableConvert(dtout, "会员状态", "tbCommCode", "vcCommSign='AS'");
this.TableConvert(dtout, "门店", "tbCommCode", "vcCommSign='MD'");
dtout.TableName = "会员资料清单";
DataTable dtexcel = dtout.Copy();
Session["QUERY"] = dtout;
for (int i = 0; i < dtexcel.Rows.Count; i++)
{
if (dtexcel.Rows[i][0].ToString().Substring(0, 1) != "V")
{
dtexcel.Rows[i][0] = "'" + dtexcel.Rows[i][0].ToString();
}
dtexcel.Rows[i][2] = "'" + dtexcel.Rows[i][2].ToString();
// dtexcel.Rows[i][10]="'"+dtexcel.Rows[i][10].ToString();
}
Session["toExcel"] = dtexcel;
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)Session["Login"];
if (dtout.Rows.Count <= 0)
{
btnExcel.Enabled = false;
}
else
{
if (ls1.strLimit == "CL001")
{
btnExcel.Enabled = true;
}
}
}
if (this.CheckAuthority())
{
dtout.Columns.Add("挂失");
foreach (DataRow dr in dtout.Rows)
{
if (dr["会员状态"].ToString() == "正常在用")
{
dr["挂失"] = "<a href='wfmAssInfoDetail.aspx?OperFlag=0&"
+ "vcCardId=" + dr["会员卡号"].ToString()
+ "'>挂失</a>";
}
else if (dr["会员状态"].ToString() == "挂失")
{
dr["挂失"] = "<a href='wfmAssInfoDetail.aspx?OperFlag=1&"
+ "vcCardId=" + dr["会员卡号"].ToString()
+ "'>解挂</a>";
}
}
}
UcPageView1.MyDataGrid.PageSize = 30;
DataView dvOut = new DataView(dtout);
this.UcPageView1.MyDataSource = dvOut;
this.UcPageView1.BindGrid();
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
protected void btQuery_Click(object sender, System.EventArgs e)
{
Session.Remove("QUERY");
Session.Remove("toExcel");
strBeginDate = Request.Form["txtBegin"].ToString();
strEndDate = Request.Form["txtEnd"].ToString();
if (strBeginDate == "" || strEndDate == "" || strBeginDate == null || strEndDate == null)
{
this.SetErrorMsgPageBydir("时间不能为空，请重新选择时间！");
return;
}
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
Hashtable htPara = new Hashtable();
string strCardID = txtCardID.Text.Trim();
htPara.Add("strCardID", strCardID);
string strAssName = txtAssName.Text.Trim();
htPara.Add("strAssName", strAssName);
string strAssType = ddlAssType.SelectedValue;
string strOperName = ddlOper.SelectedValue;
string strDeptID = ddlDept.SelectedValue;
string strFillType = ddlFillType.SelectedValue;
string strAssState = ddlAssState.SelectedValue;
if (strAssState == "所有")
{
strAssState = "Roll";
}
htPara.Add("strAssState", strAssState);
if (strAssType == "全部")
{
strAssType = "";
}
htPara.Add("strAssType", strAssType);
if (strOperName == "全部")
{
strOperName = "";
}
htPara.Add("strOperName", strOperName);
if (strDeptID == "全部")
{
strDeptID = "";
}
htPara.Add("strDeptID", strDeptID);
switch (strFillType)
{
case "正常充值":
strFillType = "Norm";
break;
case "补卡充值":
strFillType = "%补卡%";
break;
case "补充值":
strFillType = "%补充值%";
break;
case "消费撤消":
strFillType = "%消费撤消%";
break;
case "合并转移":
strFillType = "%合并%";
break;
case "充值撤消":
strFillType = "%充值撤消%";
break;
}
htPara.Add("strFillType", strFillType);
htPara.Add("strBegin", strBeginDate);
htPara.Add("strEnd", strEndDate);
try
{
double dsum = 0;
double dsum2 = 0;
DataTable dtout = busiq.GetFillQuery(htPara);
if (dtout == null)
{
this.SetErrorMsgPageBydir("查询出错，请重试！");
btnExcel.Enabled = false;
return;
}
else
{
this.TableConvert(dtout, "会员类型", "tbCommCode", "vcCommSign='AT'");
this.TableConvert(dtout, "操作员门店", "tbCommCode", "vcCommSign='MD'");
dtout.TableName = "充值明细";
DataTable dtexcel = dtout.Copy();
Session["QUERY"] = dtout;
for (int i = 0; i < dtexcel.Rows.Count; i++)
{
dsum += double.Parse(dtexcel.Rows[i]["充值金额"].ToString());
dsum2 += double.Parse(dtexcel.Rows[i]["赠款金额"].ToString());
if (dtexcel.Rows[i][3].ToString().Substring(0, 1) != "V")
{
dtexcel.Rows[i][3] = "'" + dtexcel.Rows[i][3].ToString();
}
}
Session["toExcel"] = dtexcel;
if (dtout.Rows.Count <= 0)
{
btnExcel.Enabled = false;
}
else
{
btnExcel.Enabled = true;
}
}
this.lblSum.Text = "充值金额：" + dsum.ToString() + "元，赠送金额：" + dsum2.ToString() + "，汇总金额：" + Convert.ToString(dsum + dsum2);
UcPageView1.MyDataGrid.PageSize = 30;
DataView dvOut = new DataView(dtout);
this.UcPageView1.MyDataSource = dvOut;
this.UcPageView1.BindGrid();
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
private void btQuery_Click(object sender, System.EventArgs e)
{
Session.Remove("QUERY");
Session.Remove("toExcel");
strBeginDate = Request.Form["txtBegin"].ToString();
strEndDate = Request.Form["txtEnd"].ToString();
if (strBeginDate == "" || strEndDate == "" || strBeginDate == null || strEndDate == null)
{
this.SetErrorMsgPageBydir("时间不能为空，请重新选择时间！");
return;
}
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busiq = new BusiComm.BusiQuery(strcons);
Hashtable htPara = new Hashtable();
string strCardID = txtCardID.Text.Trim();
htPara.Add("strCardID", strCardID);
string strAssName = txtAssName.Text.Trim();
htPara.Add("strAssName", strAssName);
string strPhone = txtPhone.Text.Trim();
htPara.Add("strPhone", strPhone);
string strAssType = ddlAssType.SelectedValue;
string strAssState = ddlAssState.SelectedValue;
string strDeptID = ddlDept.SelectedValue;
if (strAssType == "全部")
{
strAssType = "";
}
htPara.Add("strAssType", strAssType);
if (strAssState == "全部")
{
strAssState = "";
}
htPara.Add("strAssState", strAssState);
if (strDeptID == "全部")
{
strDeptID = "";
}
htPara.Add("strDeptID", strDeptID);
htPara.Add("strBeginDate", strBeginDate);
htPara.Add("strEndDate", strEndDate);
try
{
double sum_Fee = 0;
double sum_IG = 0;
DataTable dtout = busiq.GetAssInfo(htPara);
if (dtout == null)
{
this.SetErrorMsgPageBydir("查询出错，请重试！");
btnExcel.Enabled = false;
return;
}
else
{
this.TableConvert(dtout, "会员类型", "tbCommCode", "vcCommSign='AT'");
this.TableConvert(dtout, "会员状态", "tbCommCode", "vcCommSign='AS'");
this.TableConvert(dtout, "门店", "tbCommCode", "vcCommSign='MD'");
dtout.TableName = "会员资料清单";
DataTable dtexcel = dtout.Copy();
Session["QUERY"] = dtout;
for (int i = 0; i < dtexcel.Rows.Count; i++)
{
if (dtexcel.Rows[i][0].ToString().Substring(0, 1) != "V")
{
dtexcel.Rows[i][0] = "'" + dtexcel.Rows[i][0].ToString();
}
dtexcel.Rows[i][2] = "'" + dtexcel.Rows[i][2].ToString();
dtexcel.Rows[i][10] = "'" + dtexcel.Rows[i][10].ToString();
}
Session["toExcel"] = dtexcel;
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)Session["Login"];
if (dtout.Rows.Count <= 0)
{
btnExcel.Enabled = false;
this.lblSumFee.Text = "当前余额汇总：0";
this.lblSumIG.Text = "当前积分汇总：0";
}
else
{
for (int j = 0; j < dtout.Rows.Count; j++)
{
sum_Fee += Math.Round(double.Parse(dtout.Rows[j]["当前余额"].ToString()), 2);
sum_IG += Math.Round(double.Parse(dtout.Rows[j]["当前积分"].ToString()), 2);
}
}
}
sum_Fee = Math.Round(sum_Fee, 2);
this.lblSumFee.Text = "当前余额汇总：" + sum_Fee.ToString() + "元";
this.lblSumIG.Text = "当前积分汇总：" + sum_IG.ToString();
UcPageView1.MyDataGrid.PageSize = 30;
DataView dvOut = new DataView(dtout);
this.UcPageView1.MyDataSource = dvOut;
this.UcPageView1.BindGrid();
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}