/// <summary> /// 导出单位信息到EXCEL /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnExport_Click(object sender, EventArgs e) { if (gvList.Rows.Count <= 0) { MessageBoxShow("导出没有数据!"); return; } try { Hashtable ht1 = new Hashtable(); ht1.Add("Dictlabid", dropDictlab.SelectedValue); ht1.Add("IsActive", dropStatus.SelectedValue); ht1.Add("strKey", TextUtility.ReplaceText(txtStrKey.Text.Trim()) == "" ? null : TextUtility.ReplaceText(txtStrKey.Text.Trim())); DataTable dt = null; if (raoType.SelectedValue == "0") { dt = dictCustomerService.GetDictcustomerExportList(ht1); } else { dt = dictCustomerService.GetDictcustomerdiscountedExportList(ht1); } if (dt == null || dt.Rows.Count <= 0) { MessageBoxShow("导出没有数据!"); return; } SortedList sortlist = new SortedList(new MySort()); sortlist.Add("audittext", "审核状态"); sortlist.Add("DICTCUSTOMERID", "单位ID"); sortlist.Add("CUSTOMERNAME", "单位名称"); sortlist.Add("CUSTOMERCODE", "客户代码"); sortlist.Add("labname", "分点实验室"); sortlist.Add("ADDRESS", "单位地址"); sortlist.Add("CONTACTMAN", "联系人"); sortlist.Add("CONTACTPHONE", "联系人电话"); sortlist.Add("saleman", "销售人员"); sortlist.Add("checkbillnam", "财务人员"); sortlist.Add("TELEPHONE", "联系电话"); sortlist.Add("FAX", "传真"); sortlist.Add("EMAIL", "邮箱"); sortlist.Add("POSTCODE", "邮编"); sortlist.Add("CUSTOMERNAME2", "单位别名"); sortlist.Add("REMARK", "备注"); String sheetname = DateTime.Now.ToString("yyyy-MM-dd"); String filename = DateTime.Now.ToString("yyyyMMdd_hhmmss"); ExcelOperation <DataTable> .ExportDataTableToExcel(dt, filename, sheetname, sortlist); } catch (Exception ex) { MessageBoxShow("导出数据出错。错误信息:" + ex.Message); } }
/// <summary> /// 导出 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnExport_Click(object sender, EventArgs e) { Hashtable ht = GetParm(); DataTable dt = ordersService.DataForFinanceAuditExport(ht); if (dt.Rows.Count > 0) { String sheetname = DateTime.Now.ToString("yyyy-MM-dd"); String filename = DateTime.Now.ToString("yyyyMMdd_hhmmss"); ExcelOperation <DataTable> .ExportDataTableToExcel(dt, filename, sheetname); } else { MessageBoxShow("没有需要导出的数据!", MessageBoxIcon.Information); } }
//导出当前页数据 protected void btnExport_Click(object sender, EventArgs e) { try { Hashtable ht = new Hashtable(); PageUtil pageUtil = new PageUtil(GridInfos.PageIndex, GridInfos.PageSize); ht["Dictcustomerid"] = DropCustomer.SelectedValue; ht["Realname"] = tbxName.Text = TextUtility.ReplaceText(tbxName.Text); ht["Idnumber"] = tbxIDNumber.Text = TextUtility.ReplaceText(tbxIDNumber.Text); ht["dictsalemanid"] = Userinfo.userId;//销售人员id ht["pageStart"] = pageUtil.GetPageStartNum(); ht["pageEnd"] = pageUtil.GetPageEndNum(); DataTable source = memberservice.GetCustomerInfosExportList(ht); if (source.Rows.Count == 0) { MessageBoxShow("导出没有数据!"); return; } string sheetname = DateTime.Now.ToString("yyyy-MM-dd"); string filename = DateTime.Now.ToString("yyyyMMdd_hhmmss"); SortedList sortlist = new SortedList(new MySort()); sortlist.Add("Realname", "姓名"); sortlist.Add("Sex", "性别"); sortlist.Add("Birthday", "出生日期"); sortlist.Add("Mobile", "手机"); sortlist.Add("Idnumber", "身份证"); sortlist.Add("Addres", "住址"); ExcelOperation <Dictmember> .ExportDataTableToExcel(source, filename, sheetname, sortlist); } catch (Exception) { MessageBoxShow("导出数据出错,请联系管理员!"); } }
protected void btnExcel_Click(object sender, EventArgs e) { try { if (Dp_BeginDate.Text == "" || Dp_EndDate.Text == "") { MessageBoxShow("起止时间不能为空!", MessageBoxIcon.Information); return; } Hashtable ht = new Hashtable(); if (dropDictLab.SelectedValue == "-1") { ht.Add("labid", Userinfo.joinLabidstr); } else { ht.Add("labid", dropDictLab.SelectedValue); } if (DropCustomer.SelectedValue != "-1") { ht.Add("customername", DropCustomer.SelectedValue); } ht.Add("province", dropProvice.SelectedValue); ht.Add("DateStart", Dp_BeginDate.Text); ht.Add("Section", txtSection.Text.Trim()); ht.Add("DateEnd", Convert.ToDateTime(Dp_EndDate.Text).AddDays(1).ToString("yyyy-MM-dd")); String sheetname = DateTime.Now.ToString("yyyy-MM-dd"); String filename = DateTime.Now.ToString("yyyyMMdd_hhmmss"); if (ddlStatus.SelectedValue == "1")//护美类产品返回公司体检量统计 { using (DataTable hpvinstrumentsList = new HpvtestingService().GetListHpvinstrumentsByWhereTime(ht)) { if (hpvinstrumentsList.Rows.Count > 0) { ExcelOperation <DataTable> .ExportDataTableToExcel(hpvinstrumentsList, filename, sheetname); } else { MessageBoxShow("没有需要导出的数据!", MessageBoxIcon.Information); } } } else if (ddlStatus.SelectedValue == "0")//全部检测数据导出 { using (DataTable TM15List = new HpvtestingService().GetListTM15ByWhereTime(ht)) { if (TM15List.Rows.Count > 0) { ExcelOperation <DataTable> .ExportDataTableToExcel(TM15List, filename, sheetname); } else { MessageBoxShow("没有需要导出的数据!", MessageBoxIcon.Information); } } } else if (ddlStatus.SelectedValue == "2")//查询TM15检测数据 { ht.Add("isTP", "1"); using (DataTable TM15List = new HpvtestingService().GetListTM15ByWhereTime(ht)) { if (TM15List.Rows.Count > 0) { ExcelOperation <DataTable> .ExportDataTableToExcel(TM15List, filename, sheetname); } else { MessageBoxShow("没有需要导出的数据!", MessageBoxIcon.Information); } } } else if (ddlStatus.SelectedValue == "3")//分点查询所有检测项目,并组合项目及价格求和 { using (DataTable TestNameList = new HpvtestingService().GetListTestNameWhereTime(ht)) { if (TestNameList.Rows.Count > 0) { ExcelOperation <DataTable> .ExportDataTableToExcel(TestNameList, filename, sheetname); } else { MessageBoxShow("没有需要导出的数据!", MessageBoxIcon.Information); } } } else if (ddlStatus.SelectedValue == "4")//HPV+TM检查统计导出 { using (DataTable TM15HPVList = new HpvtestingService().SelectHPVTMAccondingInfos(ht)) { if (TM15HPVList.Rows.Count > 0) { ExcelOperation <DataTable> .ExportDataTableToExcel(TM15HPVList, filename, sheetname); } else { MessageBoxShow("没有需要导出的数据!", MessageBoxIcon.Information); } } } } catch (Exception ex) { MessageBoxShow(ex.Message, MessageBoxIcon.Error); } }