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