protected void btnImport_Click(object sender, ImageClickEventArgs e) { try { string orderString = hiddExpOrder.Value.Trim(); //排序 string order = "asc"; //排序:降序 string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "LinkDate"; //要排序的字段,如果为空,默认为"ID" if (orderString.EndsWith("_d")) { order = "desc";//排序:降序 } string ord = " ORDER BY " + orderBy + " " + order; CustComplainModel CustComplainM = new CustComplainModel(); string CustID = hiddCustID.Value; //客户ID CustComplainM.ComplainType = Convert.ToInt32(ddlComplainType.SelectedItem.Value); //投诉类型 CustComplainM.Critical = seleCritical.Value; //紧急程度 string ComplainBegin = txtComplainBegin.Value.Trim(); //投诉开始时间 string ComplainEnd = txtComplainEnd.Value.Trim(); //结束时间 CustComplainM.Title = txtTitle.Value.Trim(); //客户投诉主题 string CustLinkMan = txtCustLinkMan.Value.Trim(); //客户联系人 string DestClerk = txtEmplNameL.Value.Trim(); //接待人 CustComplainM.State = seleState.Value; //状态 CustComplainM.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; string CanUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID.ToString(); DataTable dt = ComplainBus.ExportComplainInfo(CanUserID, CustID, CustComplainM, ComplainBegin, ComplainEnd, CustLinkMan, DestClerk, ord); OutputToExecl.ExportToTableFormat(this, dt, new string[] { "投诉单编号", "投诉主题", "客户名称", "投诉时间", "投诉分类", "紧急程度", "接待人", "处理状态" }, new string[] { "ComplainNo", "title", "custNam", "ComplainDate", "typename", "Critical", "EmployeeName", "state" }, "客户投诉列表"); } catch { ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>"); } }
void LoadDataBind() { string id = Request.QueryString["id"].ToString();//客户编号 string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; DataTable dt = ComplainBus.PrintComplain(CompanyCD, id); if (dt != null) { rd.Load(Server.MapPath(@"~/PrinttingModel/CustManager/ComplainPrint.rpt")); CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.CustLinkMan")); UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //绑定数据 rd.SetDataSource(dt); rd.Refresh(); this.CrystalReportViewer1.ReportSource = rd; rd.SetParameterValue("Today", "制表人:" + userInfo.EmployeeName); } }