private void button2_Click(object sender, EventArgs e) { var file = FileDialogHelper.SaveExcel( $"{dateTimePicker1.Value.Date.ToString("yyyyMMdd") + "-" + dateTimePicker2.Value.Date.ToString("yyyyMMdd")}.xlsx"); if (string.IsNullOrEmpty(file)) { return; } //var dt = (dataGridView1.DataSource as DataTable); var dt = DataTableHelper.GetDgvToTable(dataGridView1); try { string error; AsposeExcelTools.DataTableToExcel2(dt, file, out error); if (!string.IsNullOrEmpty(error)) { MessageDxUtil.ShowError($"导出Excel出现错误:{error}"); } else { if (MessageDxUtil.ShowYesNoAndTips("导出成功,是否打开文件?") == DialogResult.Yes) { Process.Start(file); } } } catch (Exception ex) { LogTextHelper.Error(ex); MessageDxUtil.ShowError(ex.Message); } }
private void btnExportBill_Click(object sender, EventArgs e) { //装备单据数据 DataTable dt = PrepareBillData(); #region 导出数据 try { SpecialDirectories sp = new SpecialDirectories(); string fileName = FileDialogHelper.SaveExcel(string.Format("入库单({0})", DateTime.Now.ToString("yyyy-MM-dd")), sp.Desktop); if (string.IsNullOrEmpty(fileName)) { return; } string outError = ""; AsposeExcelTools.DataTableToExcel2(dt, fileName, out outError); if (!string.IsNullOrEmpty(outError)) { MessageDxUtil.ShowError(outError); LogTextHelper.Error(outError); } else { Process.Start(fileName); } } catch (Exception ex) { MessageDxUtil.ShowError(ex.Message); LogTextHelper.Error(ex); } #endregion }
/// <summary> /// 导出Excel的操作 /// </summary> private void btnExport_Click(object sender, EventArgs e) { string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName)); if (!string.IsNullOrEmpty(file)) { List <DepartmentInfo> list = CallerFactory <IDepartmentService> .Instance.FindAll(); DataTable dtNew = DataTableHelper.CreateTable("序号|int,Id,PID,Number,Name,SortCode,Type,Address,InnerPhone,OuterPhone,Remark,CompanyId,CompanyName,FoundDate,CloseDate,Creator,CreatorId,CreateTime,EditorId,Deleted,Enabled"); DataRow dr; int j = 1; for (int i = 0; i < list.Count; i++) { dr = dtNew.NewRow(); dr["序号"] = j++; dr["Id"] = list[i].Id; dr["PID"] = list[i].PID; dr["Number"] = list[i].Number; dr["Name"] = list[i].Name; dr["SortCode"] = list[i].SortCode; dr["Type"] = list[i].Type; dr["Address"] = list[i].Address; dr["InnerPhone"] = list[i].InnerPhone; dr["OuterPhone"] = list[i].OuterPhone; dr["Remark"] = list[i].Remark; dr["FoundDate"] = list[i].FoundDate; dr["CloseDate"] = list[i].CloseDate; dr["Creator"] = list[i].Creator; dr["CreatorId"] = list[i].CreatorId; dr["CreateTime"] = list[i].CreateTime; dr["EditorId"] = list[i].EditorId; dr["Deleted"] = list[i].Deleted; dr["Enabled"] = list[i].Enabled; dtNew.Rows.Add(dr); } try { string error = ""; AsposeExcelTools.DataTableToExcel2(dtNew, file, out error); if (!string.IsNullOrEmpty(error)) { MessageDxUtil.ShowError(string.Format("导出Excel出现错误:{0}", error)); } else { if (MessageDxUtil.ShowYesNoAndTips("导出成功,是否打开文件?") == System.Windows.Forms.DialogResult.Yes) { System.Diagnostics.Process.Start(file); } } } catch (Exception ex) { LogTextHelper.Error(ex); MessageDxUtil.ShowError(ex.Message); } } }
/// <summary> /// 导出Excel的操作 /// </summary> private void btnExport_Click(object sender, EventArgs e) { string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName)); if (!string.IsNullOrEmpty(file)) { string where = GetConditionSql(); List <WeightInfo> list = BLLFactory <Weight> .Instance.Find(where); DataTable dtNew = DataTableHelper.CreateTable("序号|int,车牌号|CarNo,车卡号|CardID,毛重|MzQty,皮重|PzQty,净重|NetQty,毛重衡器号|MZ_BalanceNo,毛重时间|MZ_Time,毛重方式|MZ_Type,毛重司磅员|MZ_Operator,皮重衡器号|PZ_BalanceNo,皮重时间|PZ_Time,皮重方式|PZ_Type,皮重司磅员|PZ_Operator,打印状态|PrintStatus,数据状态|DataStatus,备注|Remark,建立时间|InsertTime"); DataRow dr; int j = 1; for (int i = 0; i < list.Count; i++) { dr = dtNew.NewRow(); dr["序号"] = j++; dr["车牌号"] = list[i].CarNo; dr["车卡号"] = list[i].CardID; dr["毛重"] = list[i].MzQty; dr["皮重"] = list[i].PzQty; dr["净重"] = list[i].NetQty; dr["毛重衡器号"] = list[i].MZ_BalanceNo; dr["毛重时间"] = list[i].MZ_Time; dr["毛重方式"] = list[i].MZ_Type; dr["毛重司磅员"] = list[i].MZ_Operator; dr["皮重衡器号"] = list[i].PZ_BalanceNo; dr["皮重时间"] = list[i].PZ_Time; dr["皮重方式"] = list[i].PZ_Type; dr["皮重司磅员"] = list[i].PZ_Operator; dr["打印状态"] = list[i].PrintStatus; dr["数据状态"] = list[i].DataStatus; dr["备注"] = list[i].Remark; dr["建立时间"] = list[i].InsertTime; dtNew.Rows.Add(dr); } try { string error = ""; AsposeExcelTools.DataTableToExcel2(dtNew, file, out error); if (!string.IsNullOrEmpty(error)) { MessageDxUtil.ShowError(string.Format("导出Excel出现错误:{0}", error)); } else { if (MessageDxUtil.ShowYesNoAndTips("导出成功,是否打开文件?") == System.Windows.Forms.DialogResult.Yes) { System.Diagnostics.Process.Start(file); } } } catch (Exception ex) { LogTextHelper.Error(ex); MessageDxUtil.ShowError(ex.Message); } } }
/// <summary> /// 导出Excel的操作 /// </summary> private void btnExport_Click(object sender, EventArgs e) { if (!HasFunction("OperationLog/Export")) { MessageDxUtil.ShowError(Const.NoAuthMsg); return; } string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName)); if (!string.IsNullOrEmpty(file)) { string where = GetConditionSql(); List <OperationLogInfo> list = BLLFactory <OperationLog> .Instance.Find(where); DataTable dtNew = DataTableHelper.CreateTable("序号|int,登录用户ID,登录名,真实名称,所属公司ID,所属公司名称,操作表名称,操作类型,日志描述,IP地址,Mac地址,创建时间"); DataRow dr; int j = 1; for (int i = 0; i < list.Count; i++) { dr = dtNew.NewRow(); dr["序号"] = j++; dr["登录用户ID"] = list[i].User_ID; dr["登录名"] = list[i].LoginName; dr["真实名称"] = list[i].FullName; dr["所属公司ID"] = list[i].Company_ID; dr["所属公司名称"] = list[i].CompanyName; dr["操作表名称"] = list[i].TableName; dr["操作类型"] = list[i].OperationType; dr["日志描述"] = list[i].Note; dr["IP地址"] = list[i].IPAddress; dr["Mac地址"] = list[i].MacAddress; dr["创建时间"] = list[i].CreateTime; dtNew.Rows.Add(dr); } try { string error = ""; AsposeExcelTools.DataTableToExcel2(dtNew, file, out error); if (!string.IsNullOrEmpty(error)) { MessageDxUtil.ShowError(string.Format("导出Excel出现错误:{0}", error)); } else { if (MessageDxUtil.ShowYesNoAndTips("导出成功,是否打开文件?") == System.Windows.Forms.DialogResult.Yes) { System.Diagnostics.Process.Start(file); } } } catch (Exception ex) { LogHelper.WriteLog(LogLevel.LOG_LEVEL_CRIT, ex, typeof(FrmOperationLog)); MessageDxUtil.ShowError(ex.Message); } } }
public void ProcessRequest(HttpContext context) { HttpRequest request = System.Web.HttpContext.Current.Request; string StartTime = request["StartTime"]; string EndTime = request["EndTime"]; int Flag = Convert.ToInt32(request["Flag"]); //按天,flag=2,按小时,flag=1 string st_no = request["st_no"]; string method = request["method"]; string JsonStr = "[]"; DataTable outtable; if (string.IsNullOrWhiteSpace(method)) { volumn_report_BLL.GetAddupProducts(method, StartTime, EndTime, Flag, st_no, out outtable); //ExcelHelper.ExportDTtoExcel(outtable, "产量报表", HttpContext.Current.Request.MapPath("~/App_Data/产量报表.xlsx")); if (outtable != null) { JsonStr = FunCommon.DataTableToJson(outtable); } context.Response.ContentType = "text/plain"; context.Response.Write(JsonStr); context.Response.End(); } else { //DataReader.GetAddupProducts(method, StartTime, EndTime, Flag, st_no, out outtable); volumn_report_BLL.GetAddupProducts(method, StartTime, EndTime, Flag, st_no, out outtable); if (outtable != null) { try { string fileName = HttpContext.Current.Request.MapPath("~/App_Data/产量报表.xlsx"); // ExcelHelper.ExportDTtoExcel(outtable, "产量报表", HttpContext.Current.Request.MapPath("~/App_Data/产量报表.xlsx")); string err = ""; AsposeExcelTools.DataTableToExcel2(outtable, fileName, out err); string ss = "true"; if (err.Length < 1) { ss = "true"; } else { ss = "false"; } JsonStr = ss; } catch { JsonStr = "false"; } } context.Response.ContentType = "json"; context.Response.Write(JsonStr); context.Response.End(); } }
private void NormalExport() { string columns = @"流水号,备注,供货商,操作员,库房名称,备件编号(pm码),备件名称,图号,规格型号,材质,备件属类,备件类别,单位,最新单价(元),出库数量,总价,出库日期,来源,库位,成本中心,使用位置"; DataTable dt = DataTableHelper.CreateTable(columns); DataRow row = null; for (int i = 0; i < this.lvwDetail.Items.Count; i++) { PurchaseDetailInfo info = this.lvwDetail.Items[i].Tag as PurchaseDetailInfo; if (info != null) { row = dt.NewRow(); row["流水号"] = this.txtHandNo.Text; row["备注"] = this.txtNote.Text; row["供货商"] = this.txtManufacture.Text; row["操作员"] = this.txtCreator.Text; row["库房名称"] = this.txtWareHouse.Text; row["备件编号(pm码)"] = info.ItemNo; row["备件名称"] = info.ItemName; row["图号"] = info.MapNo; row["规格型号"] = info.Specification; row["材质"] = info.Material; row["备件属类"] = info.ItemBigType; row["备件类别"] = info.ItemType; row["单位"] = info.Unit; row["最新单价(元)"] = info.Price.ToString("C2"); row["出库数量"] = info.Quantity.ToString(); row["总价"] = info.Amount.ToString("C2"); row["出库日期"] = this.txtCreateDate.DateTime.ToString(); row["来源"] = info.Source; row["库位"] = info.StoragePos; row["成本中心"] = this.txtCostCenter.Text; row["使用位置"] = info.UsagePos; dt.Rows.Add(row); } } try { string fileName = FileDialogHelper.SaveExcel(); string outError = ""; AsposeExcelTools.DataTableToExcel2(dt, fileName, out outError); if (!string.IsNullOrEmpty(outError)) { MessageDxUtil.ShowError(outError); LogTextHelper.Error(outError); } else { Process.Start(fileName); } } catch (Exception ex) { MessageDxUtil.ShowError(ex.Message); LogTextHelper.Error(ex); } }
/// <summary> /// 导出Excel的操作 /// </summary> private void btnExport_Click(object sender, EventArgs e) { string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", "优惠券信息数据" + DateTime.Now.ToString("yyyyMMddHHmmss"))); if (!string.IsNullOrEmpty(file)) { string where = GetConditionSql(); List <CouponInfo> list = BLLFactory <Coupon> .Instance.Find(where); DataTable dtNew = DataTableHelper.CreateTable("序号|int,优惠券序列号,分类名称,操作公司,创建人,创建人ID,创建时间,使用人,使用人ID,使用时间,联系电话,联系人,有效开始日期,有效结束日期,是否使用"); DataRow dr; int j = 1; for (int i = 0; i < list.Count; i++) { dr = dtNew.NewRow(); dr["序号"] = j++; dr["优惠券序列号"] = list[i].ID; dr["分类名称"] = list[i].CouponCategory_Name; dr["操作公司"] = list[i].Company_Name; dr["创建人"] = list[i].Creator; dr["创建人ID"] = list[i].Creator_ID; dr["创建时间"] = list[i].CreateTime; dr["使用人"] = list[i].Editor; dr["使用人ID"] = list[i].Editor_ID; dr["使用时间"] = list[i].EditTime; dr["联系电话"] = list[i].MobilePhone; dr["联系人"] = list[i].FullName; dr["有效开始日期"] = list[i].StartTime; dr["有效结束日期"] = list[i].EndTime; dr["是否使用"] = list[i].DELETED == 0?"否":"是"; dtNew.Rows.Add(dr); } try { string error = ""; AsposeExcelTools.DataTableToExcel2(dtNew, file, out error); if (!string.IsNullOrEmpty(error)) { MessageDxUtil.ShowError(string.Format("导出Excel出现错误:{0}", error)); } else { if (MessageDxUtil.ShowYesNoAndTips("导出成功,是否打开文件?") == System.Windows.Forms.DialogResult.Yes) { System.Diagnostics.Process.Start(file); } } } catch (Exception ex) { LogHelper.WriteLog(LogLevel.LOG_LEVEL_CRIT, ex, typeof(FrmCouponCategory)); MessageDxUtil.ShowError(ex.Message); } } }
/// <summary> /// 导出的操作 /// </summary> private void ExportData() { string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName)); if (!string.IsNullOrEmpty(file)) { string where = GetConditionSql(); List <物料ng替换记录表Info> list = BLLFactory <物料ng替换记录表> .Instance.Find(where); DataTable dtNew = DataTableHelper.CreateTable("序号|int,NG替换时间,物料生产批次号,设备ID,工序ID,工位号,物料GUID,替换前治具GUID,替换前治具RFID,替换前治具孔号,前治具生产批次号,替换后治具GUID,替换后治具RFID,替换后治具孔号,后治具生产批次号"); DataRow dr; int j = 1; for (int i = 0; i < list.Count; i++) { dr = dtNew.NewRow(); dr["序号"] = j++; dr["NG替换时间"] = list[i].Ng替换时间; dr["物料生产批次号"] = list[i].物料生产批次号; dr["设备ID"] = list[i].设备id; dr["工序ID"] = list[i].设备名称; dr["工位号"] = list[i].工位号; dr["物料GUID"] = list[i].物料guid; dr["替换前治具GUID"] = list[i].替换前治具guid; dr["替换前治具RFID"] = list[i].替换前治具rfid; dr["替换前治具孔号"] = list[i].替换前治具孔号; dr["前治具生产批次号"] = list[i].前治具生产批次号; dr["替换后治具GUID"] = list[i].替换后治具guid; dr["替换后治具RFID"] = list[i].替换后治具rfid; dr["替换后治具孔号"] = list[i].替换后治具孔号; dr["后治具生产批次号"] = list[i].后治具生产批次号; dtNew.Rows.Add(dr); } try { string error = ""; AsposeExcelTools.DataTableToExcel2(dtNew, file, out error); if (!string.IsNullOrEmpty(error)) { MessageDxUtil.ShowError(string.Format("导出Excel出现错误:{0}", error)); } else { if (MessageDxUtil.ShowYesNoAndTips("导出成功,是否打开文件?") == System.Windows.Forms.DialogResult.Yes) { System.Diagnostics.Process.Start(file); } } } catch (Exception ex) { LogTextHelper.Error(ex); MessageDxUtil.ShowError(ex.Message); } } }
/// <summary> /// 导出Excel的操作 /// </summary> private void btnExport_Click(object sender, EventArgs e) { string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName)); if (!string.IsNullOrEmpty(file)) { string where = GetConditionSql(); List <CardInfo> list = BLLFactory <Card> .Instance.Find(where); DataTable dtNew = DataTableHelper.CreateTable("序号|int,车卡号|CardID,车牌号|CarNo,司机|Driver,运输单位|TransportUnit,注册时间|RegisterTime,,过期时间|ExpireTime,操作员|Operator,货物种类|Goods,联系电话|TelNo,生成时间|InsertTime,数据状态|DataStatus,备注|Reamark"); DataRow dr; int j = 1; for (int i = 0; i < list.Count; i++) { dr = dtNew.NewRow(); dr["序号"] = j++; dr["车卡号"] = list[i].CardID; dr["车牌号"] = list[i].CarNo; dr["司机"] = list[i].Driver; dr["运输单位"] = list[i].TransportUnit; dr["注册时间"] = list[i].RegisterTime; dr["过期时间"] = list[i].ExpireTime; dr["操作员"] = list[i].Operator; dr["货物种类"] = list[i].Goods; dr["联系电话"] = list[i].TelNo; dr["生成时间"] = list[i].InsertTime; dr["数据状态"] = list[i].DataStatus; dr["备注"] = list[i].Reamark; dtNew.Rows.Add(dr); } try { string error = ""; AsposeExcelTools.DataTableToExcel2(dtNew, file, out error); if (!string.IsNullOrEmpty(error)) { MessageDxUtil.ShowError(string.Format("导出Excel出现错误:{0}", error)); } else { if (MessageDxUtil.ShowYesNoAndTips("导出成功,是否打开文件?") == System.Windows.Forms.DialogResult.Yes) { System.Diagnostics.Process.Start(file); } } } catch (Exception ex) { LogTextHelper.Error(ex); MessageDxUtil.ShowError(ex.Message); } } }
/// <summary> /// 导出Excel的操作 /// </summary> private void btnExport_Click(object sender, EventArgs e) { string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName)); if (!string.IsNullOrEmpty(file)) { string where = GetConditionSql(); List <LoginLogInfo> list = BLLFactory <LoginLog> .Instance.Find(where); DataTable dtNew = DataTableHelper.CreateTable("序号|int,登录用户ID,登录名,真实名称,所属公司ID,所属公司名称,日志描述,IP地址,Mac地址,更新时间,系统编号"); DataRow dr; int j = 1; for (int i = 0; i < list.Count; i++) { dr = dtNew.NewRow(); dr["序号"] = j++; dr["用户Id"] = list[i].UserId; dr["用户名"] = list[i].Name; dr["登陆名"] = list[i].LoginName; dr["公司Id"] = list[i].CompanyId; //dr["公司名字"] = list[i].CompanyName; dr["备注"] = list[i].Remark; dr["IP地址"] = list[i].IP; dr["Mac地址"] = list[i].Mac; dr["最后更新时间"] = list[i].LastUpdateTime; dr["系统编号"] = list[i].SystemtypeId; dtNew.Rows.Add(dr); } try { string error = ""; AsposeExcelTools.DataTableToExcel2(dtNew, file, out error); if (!string.IsNullOrEmpty(error)) { MessageDxUtil.ShowError(string.Format("导出Excel出现错误:{0}", error)); } else { if (MessageDxUtil.ShowYesNoAndTips("导出成功,是否打开文件?") == System.Windows.Forms.DialogResult.Yes) { System.Diagnostics.Process.Start(file); } } } catch (Exception ex) { LogHelper.WriteLog(LogLevel.LOG_LEVEL_CRIT, ex, typeof(FrmLoginLog)); MessageDxUtil.ShowError(ex.Message); } } }
public void ProcessRequest(HttpContext context) {//excel HttpRequest request = System.Web.HttpContext.Current.Request; string StartTime = request["StartTime"]; string EndTime = request["EndTime"]; int Flag = Convert.ToInt32(request["Flag"]); string st_no = request["st_no"]; string method = request["method"]; if (string.IsNullOrWhiteSpace(method)) { DataTable resTable = Time_ReportBLL.TimeProducts(StartTime, EndTime, Flag, st_no); string JsonStr = "[]"; if (resTable != null) { JsonStr = FunCommon.DataTableToJson(resTable); } context.Response.ContentType = "text/plain"; context.Response.Write(JsonStr); context.Response.End(); } else { string json = ""; try { DataTable resTable = Time_ReportBLL.TimeProducts(StartTime, EndTime, Flag, st_no); //ExcelHelper.ExportDTtoExcel(resTable, "", HttpContext.Current.Request.MapPath("~/App_Data/时间信息报表.xlsx")); string fileName = HttpContext.Current.Request.MapPath("~/App_Data/时间信息报表.xlsx"); string err = ""; AsposeExcelTools.DataTableToExcel2(resTable, fileName, out err); string ss = "true"; if (err.Length < 1) { ss = "true"; } else { ss = "false"; } json = ss; } catch { json = "false"; } context.Response.ContentType = "json"; context.Response.Write(json); } }
//do the new excel document work using the background worker private void bg_DoWork(object sender, DoWorkEventArgs e) { DataTable dtExport = this.dataSource; if (TableToExport != null && isExportAllPage) { dtExport = TableToExport; } string outError = ""; AsposeExcelTools.DataTableToExcel2(dtExport, (String)e.Argument, out outError); }
/// <summary> /// 导出Excel的操作 /// </summary> private void btnExport_Click(object sender, EventArgs e) { string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName)); if (!string.IsNullOrEmpty(file)) { List <MenuInfo> list = BLLFactory <Menus> .Instance.GetAll(); DataTable dtNew = DataTableHelper.CreateTable("序号|int,父ID,显示名称,图标,排序,功能ID,菜单可见,Winform窗体类型,Web界面的菜单图标,Web界面Url地址,系统编号"); DataRow dr; int j = 1; for (int i = 0; i < list.Count; i++) { dr = dtNew.NewRow(); dr["序号"] = j++; dr["父ID"] = list[i].PID; dr["显示名称"] = list[i].Name; dr["图标"] = list[i].Icon; dr["排序"] = list[i].Seq; dr["功能ID"] = list[i].FunctionId; dr["菜单可见"] = list[i].Visible; dr["Winform窗体类型"] = list[i].WinformType; dr["Web界面的菜单图标"] = list[i].WebIcon; dr["Web界面Url地址"] = list[i].Url; dr["系统编号"] = list[i].SystemType_ID; dtNew.Rows.Add(dr); } try { string error = ""; AsposeExcelTools.DataTableToExcel2(dtNew, file, out error); if (!string.IsNullOrEmpty(error)) { MessageDxUtil.ShowError(string.Format("导出Excel出现错误:{0}", error)); } else { if (MessageDxUtil.ShowYesNoAndTips("导出成功,是否打开文件?") == System.Windows.Forms.DialogResult.Yes) { System.Diagnostics.Process.Start(file); } } } catch (Exception ex) { LogHelper.WriteLog(LogLevel.LOG_LEVEL_CRIT, ex, typeof(FrmMenu)); MessageDxUtil.ShowError(ex.Message); } } }
/// <summary> /// 使用背景线程导出Excel文档 /// </summary> private void All_DoWork(object sender, DoWorkEventArgs e) { string where = "1=1"; PagerInfo info = new PagerInfo(); info.PageSize = int.MaxValue; info.CurrenetPageIndex = 1; DataTable table = FindToDataTable(where, info); string outError = ""; string filePath = (String)e.Argument; AsposeExcelTools.DataTableToExcel2(table, filePath, out outError); e.Result = filePath; }
/// <summary> /// 导出的操作 /// </summary> private void ExportData() { string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName)); if (!string.IsNullOrEmpty(file)) { string where = GetConditionSql(); List <设备状态表Info> list = BLLFactory <设备状态表> .Instance.Find(where); DataTable dtNew = DataTableHelper.CreateTable("序号|int,发生时间,设备id,设备名称,设备状态,报警信息"); DataRow dr; int j = 1; for (int i = 0; i < list.Count; i++) { dr = dtNew.NewRow(); dr["序号"] = j++; dr["发生时间"] = list[i].发生时间; dr["设备id"] = list[i].设备id; dr["设备名称"] = list[i].设备名称; dr["设备状态"] = list[i].设备状态; dr["报警信息"] = list[i].报警信息; dtNew.Rows.Add(dr); } try { string error = ""; AsposeExcelTools.DataTableToExcel2(dtNew, file, out error); if (!string.IsNullOrEmpty(error)) { MessageDxUtil.ShowError(string.Format("导出Excel出现错误:{0}", error)); } else { if (MessageDxUtil.ShowYesNoAndTips("导出成功,是否打开文件?") == System.Windows.Forms.DialogResult.Yes) { System.Diagnostics.Process.Start(file); } } } catch (Exception ex) { LogTextHelper.Error(ex); MessageDxUtil.ShowError(ex.Message); } } }
/// <summary> /// 导出Excel的操作 /// </summary> private void btnExport_Click(object sender, EventArgs e) { string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName)); if (!string.IsNullOrEmpty(file)) { string where = GetConditionSql(); List <AddressGroupInfo> list = BLLFactory <AddressGroup> .Instance.Find(where); DataTable dtNew = DataTableHelper.CreateTable("序号|int,排序序号,分组名称,备注"); DataRow dr; int j = 1; for (int i = 0; i < list.Count; i++) { dr = dtNew.NewRow(); dr["序号"] = j++; dr["排序序号"] = list[i].Seq; dr["分组名称"] = list[i].Name; dr["备注"] = list[i].Remark; dtNew.Rows.Add(dr); } try { string error = ""; AsposeExcelTools.DataTableToExcel2(dtNew, file, out error); if (!string.IsNullOrEmpty(error)) { MessageDxUtil.ShowError(string.Format("导出Excel出现错误:{0}", error)); } else { if (MessageDxUtil.ShowYesNoAndTips("导出成功,是否打开文件?") == System.Windows.Forms.DialogResult.Yes) { System.Diagnostics.Process.Start(file); } } } catch (Exception ex) { LogHelper.WriteLog(LogLevel.LOG_LEVEL_CRIT, ex, typeof(FrmAddressGroup)); MessageDxUtil.ShowError(ex.Message); } } }
/// <summary> /// 导出Excel的操作 /// </summary> private void btnExport_Click(object sender, EventArgs e) { string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName)); if (!string.IsNullOrEmpty(file)) { string where = GetConditionSql(); List <ProcCardEmployeeInfo> list = BLLFactory <ProcCardEmployee> .Instance.Find(where); DataTable dtNew = DataTableHelper.CreateTable("序号|int,班组,姓名,代号"); DataRow dr; int j = 1; for (int i = 0; i < list.Count; i++) { dr = dtNew.NewRow(); dr["序号"] = j++; dr["班组"] = list[i].TeamId; dr["姓名"] = list[i].Name; dr["代号"] = list[i].Code; dtNew.Rows.Add(dr); } try { string error = ""; AsposeExcelTools.DataTableToExcel2(dtNew, file, out error); if (!string.IsNullOrEmpty(error)) { MessageDxUtil.ShowError(string.Format("导出Excel出现错误:{0}", error)); } else { if (MessageDxUtil.ShowYesNoAndTips("导出成功,是否打开文件?") == DialogResult.Yes) { System.Diagnostics.Process.Start(file); } } } catch (Exception ex) { LogTextHelper.Error(ex); MessageDxUtil.ShowError(ex.Message); } } }
public void Export(string type, string pd) { string ret = ""; try { ReportOP op = new ReportOP(); DataSet dsExport = null; string strJson = Server.UrlDecode(Request["w"]); //string strjson2 = Server.UrlDecode(pd); List <I.MES.Models.WhereCondition> whereList; List <I.MES.Models.ExportCell> whereList2; if (!string.IsNullOrWhiteSpace(strJson)) { whereList = strJson.ToEntities <List <I.MES.Models.WhereCondition> >(); whereList2 = pd.ToEntities <List <ExportCell> >(); dsExport = op.GetAllReport(whereList, whereList2, type); } Workbook workbook = AsposeExcelTools.DataTableToExcel2(dsExport.Tables[1]); if (workbook != null) { this.DeleteDownLoadTempFile(); //直接导出 Stream outputStream = Response.OutputStream; string filename = "/DownLoad/" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xlsx"; workbook.Save(Server.MapPath(filename), SaveFormat.Xlsx); ret = filename; } } catch (Exception ex) { throw ex; } // Response.Buffer = false; Response.AppendHeader("Content-Disposition", "attachment;filename=" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xlsx"); Response.ContentEncoding = System.Text.Encoding.UTF8; Response.ContentType = "application/vnd.ms-excel"; Response.Write(ret); Response.Flush(); Response.End(); }
/// <summary> /// 导出Excel的操作 /// </summary> private void btnExport_Click(object sender, EventArgs e) { string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName)); if (!string.IsNullOrEmpty(file)) { string where = GetConditionSql(); List <StaffInfo> list = CallerFactory <IStaffService> .Instance.Find(where); DataTable dtNew = DataTableHelper.CreateTable("序号|int,Id,Number,Name,Gender,Birthday,NativePlace,Nationality,IdentityCard,Phone,OfficePhone,Email,HomeAddress,Political,PartyDate,Education,Degree,WorkingDate,Marriage,ChildStatus,Titles,Duty,JobType,Introduce,Remark,AttachId,CompanyId,DepartmentId,PositionId,Creator,CreatorId,CreateTime,EditorId,Deleted,Enabled"); DataRow dr; int j = 1; for (int i = 0; i < list.Count; i++) { dr = dtNew.NewRow(); dr["序号"] = j++; dr["Id"] = list[i].Id; dr["Number"] = list[i].Number; dr["Name"] = list[i].Name; dr["Gender"] = list[i].Gender; dr["Birthday"] = list[i].Birthday; dr["NativePlace"] = list[i].NativePlace; dr["Nationality"] = list[i].Nationality; dr["IdentityCard"] = list[i].IdentityCard; dr["Phone"] = list[i].Phone; dr["OfficePhone"] = list[i].OfficePhone; dr["Email"] = list[i].Email; dr["HomeAddress"] = list[i].HomeAddress; dr["Political"] = list[i].Political; dr["PartyDate"] = list[i].PartyDate; dr["Education"] = list[i].Education; dr["Degree"] = list[i].Degree; dr["WorkingDate"] = list[i].WorkingDate; dr["Marriage"] = list[i].Marriage; dr["ChildStatus"] = list[i].ChildStatus; dr["Titles"] = list[i].Titles; dr["Duty"] = list[i].Duty; dr["JobType"] = list[i].JobType; dr["Introduce"] = list[i].Introduce; dr["Remark"] = list[i].Remark; dr["AttachId"] = list[i].AttachId; dr["CompanyId"] = list[i].CompanyId; dr["DepartmentId"] = list[i].DepartmentId; dr["PositionId"] = list[i].PositionId; dr["Creator"] = list[i].Creator; dr["CreatorId"] = list[i].CreatorId; dr["CreateTime"] = list[i].CreateTime; dr["EditorId"] = list[i].EditorId; dr["Deleted"] = list[i].Deleted; dr["Enabled"] = list[i].Enabled; dtNew.Rows.Add(dr); } try { string error = ""; AsposeExcelTools.DataTableToExcel2(dtNew, file, out error); if (!string.IsNullOrEmpty(error)) { MessageDxUtil.ShowError(string.Format("导出Excel出现错误:{0}", error)); } else { if (MessageDxUtil.ShowYesNoAndTips("导出成功,是否打开文件?") == System.Windows.Forms.DialogResult.Yes) { System.Diagnostics.Process.Start(file); } } } catch (Exception ex) { LogTextHelper.Error(ex); MessageDxUtil.ShowError(ex.Message); } } }
/// <summary> /// 导出的操作 /// </summary> private void ExportData() { string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName)); if (!string.IsNullOrEmpty(file)) { string where = GetConditionSql(); List <生产批次生成表Info> list = BLLFactory <生产批次生成表> .Instance.Find(where); DataTable dtNew = DataTableHelper.CreateTable("序号|int,时间,班次,组装线体号,机种,镜框日期,镜筒模穴号,镜框批次,穴号105,穴号104,穴号102,日期105,日期104,日期102,角度,系列号,镜框投料数,隔圈模穴号113B,成型日113B,隔圈模穴号112,成型日112,隔圈投料数,G3来料供应商,G3镜片来料日期,G1来料供应商,G1来料日期,镜片105投料数,镜片104投料数,镜片G3投料数,镜片102投料数,镜片95B投料数,配对监控批次,计划投入数,上线数,下线数,状态,生成出的生产批次号"); DataRow dr; int j = 1; for (int i = 0; i < list.Count; i++) { dr = dtNew.NewRow(); dr["序号"] = j++; dr["时间"] = list[i].时间; dr["班次"] = list[i].班次; dr["组装线体号"] = list[i].组装线体号; dr["机种"] = list[i].机种; dr["镜框日期"] = list[i].镜框日期; dr["镜筒模穴号"] = list[i].镜筒模穴号; dr["镜框批次"] = list[i].镜框批次; dr["穴号105"] = list[i].穴号105; dr["穴号104"] = list[i].穴号104; dr["穴号102"] = list[i].穴号102; dr["日期105"] = list[i].日期105; dr["日期104"] = list[i].日期104; dr["日期102"] = list[i].日期102; dr["角度"] = list[i].角度; dr["系列号"] = list[i].系列号; dr["镜框投料数"] = list[i].镜框投料数; dr["隔圈模穴号113B"] = list[i].隔圈模穴号113b; dr["成型日113B"] = list[i].成型日113b; dr["隔圈模穴号112"] = list[i].隔圈模穴号112; dr["成型日112"] = list[i].成型日112; dr["隔圈投料数"] = list[i].隔圈投料数; dr["G3来料供应商"] = list[i].G3来料供应商; dr["G3镜片来料日期"] = list[i].G3镜片来料日期; dr["G1来料供应商"] = list[i].G1来料供应商; dr["G1来料日期"] = list[i].G1来料日期; dr["镜片105投料数"] = list[i].镜片105投料数; dr["镜片104投料数"] = list[i].镜片104投料数; dr["镜片G3投料数"] = list[i].镜片g3投料数; dr["镜片102投料数"] = list[i].镜片102投料数; dr["镜片95B投料数"] = list[i].镜片95b投料数; dr["配对监控批次"] = list[i].配对监控批次; dr["计划投入数"] = list[i].计划投入数; dr["上线数"] = list[i].线数; dr["下线数"] = list[i].线数; dr["状态"] = list[i].状态; dr["生成出的生产批次号"] = list[i].生产批次号; dtNew.Rows.Add(dr); } try { string error = ""; AsposeExcelTools.DataTableToExcel2(dtNew, file, out error); if (!string.IsNullOrEmpty(error)) { MessageDxUtil.ShowError(string.Format("导出Excel出现错误:{0}", error)); } else { if (MessageDxUtil.ShowYesNoAndTips("导出成功,是否打开文件?") == System.Windows.Forms.DialogResult.Yes) { System.Diagnostics.Process.Start(file); } } } catch (Exception ex) { LogTextHelper.Error(ex); MessageDxUtil.ShowError(ex.Message); } } }
private void btnExportBill_Click(object sender, EventArgs e) { #region 准备数据 string columns = @"流水号,备注,供货商,操作员,库房名称,备件编号(pm码),备件名称,图号,规格型号,材质,备件属类,备件类别,单位,最新单价(元),入库数量,总价,入库日期,来源,库位,部门,使用位置"; DataTable dt = DataTableHelper.CreateTable(columns); DataRow row = null; for (int i = 0; i < this.lvwDetail.Items.Count; i++) { PurchaseDetailInfo info = this.lvwDetail.Items[i].Tag as PurchaseDetailInfo; if (info != null) { row = dt.NewRow(); row["流水号"] = this.txtHandNo.Text; row["备注"] = this.txtNote.Text; row["供货商"] = this.txtManufacture.Text; row["操作员"] = this.txtCreator.Text; row["入库日期"] = this.txtCreateDate.DateTime.ToString(); row["库房名称"] = info.WareHouse; row["备件编号(pm码)"] = info.ItemNo; row["备件名称"] = info.ItemName; row["图号"] = info.MapNo; row["规格型号"] = info.Specification; row["材质"] = info.Material; row["备件属类"] = info.ItemBigType; row["备件类别"] = info.ItemType; row["单位"] = info.Unit; row["最新单价(元)"] = info.Price.ToString("C2"); row["入库数量"] = info.Quantity.ToString(); row["总价"] = info.Amount.ToString("C2"); row["来源"] = info.Source; row["库位"] = info.StoragePos; row["部门"] = info.Dept; row["使用位置"] = info.UsagePos; dt.Rows.Add(row); } } #endregion #region 导出数据 try { SpecialDirectories sp = new SpecialDirectories(); string fileName = FileDialogHelper.SaveExcel(string.Format("入库单({0})", DateTime.Now.ToString("yyyy-MM-dd")), sp.Desktop); if (string.IsNullOrEmpty(fileName)) { return; } string outError = ""; AsposeExcelTools.DataTableToExcel2(dt, fileName, out outError); if (!string.IsNullOrEmpty(outError)) { MessageDxUtil.ShowError(outError); LogTextHelper.Error(outError); } else { Process.Start(fileName); } } catch (Exception ex) { MessageDxUtil.ShowError(ex.Message); LogTextHelper.Error(ex); } #endregion }
private void btnExportDetail_Click(object sender, EventArgs e) { if (this.winGridView1.gridView1.RowCount == 0) { return; } #region 构造数据列表 //HandNo,ItemNo,ItemName,MapNo,Specification,Material,ItemBigType,ItemType,Unit,Price,Quantity,Amount,Source,StoragePos,UsagePos,d.WareHouse,d.Dept string columns = "货单号,项目编号,项目名称,图号,规格型号,材质,备件属类,备件类别,单位,单价|decimal,数量|int,金额|decimal,来源,库位,使用位置,库房,部门"; DataTable dtDetail = DataTableHelper.CreateTable(columns); DataGridViewRow row; for (int i = 0; i < winGridView1.gridView1.RowCount; i++) { string ID = this.winGridView1.gridView1.GetRowCellDisplayText(i, "ID"); if (!string.IsNullOrEmpty(ID)) { DataTable dt = BLLFactory <PurchaseDetail> .Instance.GetPurchaseDetailReportByID(Convert.ToInt32(ID)); dt.Rows.Add(dt.NewRow()); //复制到中文列的表中 for (int k = 0; k < dt.Rows.Count; k++) { DataRow r = dtDetail.NewRow(); for (int j = 0; j < dt.Columns.Count; j++) { r[j] = dt.Rows[k][j]; } dtDetail.Rows.Add(r); } } } #endregion #region 导出数据操作 SpecialDirectories sp = new SpecialDirectories(); string fileToSave = FileDialogHelper.SaveExcel(string.Format("入库单明细({0})", DateTime.Now.ToString("yyyy-MM-dd")), sp.Desktop); if (string.IsNullOrEmpty(fileToSave)) { return; } try { string fileName = fileToSave; string outError = ""; AsposeExcelTools.DataTableToExcel2(dtDetail, fileName, out outError); if (!string.IsNullOrEmpty(outError)) { MessageDxUtil.ShowError(outError); LogTextHelper.Error(outError); } else { Process.Start(fileName); } } catch (Exception ex) { MessageDxUtil.ShowError(ex.Message); LogTextHelper.Error(ex); } #endregion }
/// <summary> /// 使用背景线程导出Excel文档 /// </summary> private void bg_DoWork(object sender, DoWorkEventArgs e) { DataTable table = new DataTable(); if (AllToExport != null && isExportAllPage) { if (AllToExport is DataView) { DataView dv = (DataView)AllToExport;//默认导出显示内容 table = dv.ToTable(); } else if (AllToExport is DataTable) { table = AllToExport as DataTable; } else { table = ReflectionUtil.CreateTable(AllToExport); } //解析标题 string originalName = string.Empty; foreach (DataColumn column in table.Columns) { originalName = column.Caption; if (columnNameAlias.ContainsKey(originalName.ToUpper())) { column.Caption = columnNameAlias[originalName.ToUpper()]; column.ColumnName = columnNameAlias[originalName.ToUpper()]; } } //for (int i = 0; i < this.gridView1.Columns.Count; i++) //{ // if (!this.gridView1.Columns[i].Visible) // { // table.Columns.Remove(this.gridView1.Columns[i].FieldName); // } //} } else { DataColumn column; DataRow row; for (int i = 0; i < this.gridView1.Columns.Count; i++) { if (this.gridView1.Columns[i].Visible) { column = new DataColumn(this.gridView1.Columns[i].FieldName, typeof(string)); column.Caption = this.gridView1.Columns[i].Caption; table.Columns.Add(column); } } object cellValue = ""; string fieldName = ""; for (int i = 0; i < gridView1.RowCount; i++) { row = table.NewRow(); for (int j = 0; j < gridView1.Columns.Count; j++) { if (this.gridView1.Columns[j].Visible) { fieldName = gridView1.Columns[j].FieldName; cellValue = gridView1.GetRowCellValue(i, fieldName); row[fieldName] = cellValue ?? ""; } } table.Rows.Add(row); } } string outError = ""; AsposeExcelTools.DataTableToExcel2(table, (String)e.Argument, out outError); }
public void Export(HttpContext context) { string start_time = context.Request["start_time"]; string end_time = context.Request["end_time"]; string fl_id = context.Request["fl_id"]; int PageSize = Convert.ToInt32(context.Request["rows"]); int PageIndex = Convert.ToInt32(context.Request["page"]); StringBuilder commandText = new StringBuilder(); string where = ""; if (string.IsNullOrEmpty(start_time)) { DateTime t = DateTime.Now; start_time = t.ToString("yyyy-MM-dd HH:mm:ss"); } string StartTime = start_time; if (string.IsNullOrEmpty(end_time)) { DateTime t = DateTime.Now; end_time = t.ToString("yyyy-MM-dd HH:mm:ss"); } string EndTime = end_time; // DataListModel<Production_AlarmModel> userList = Production_AlarmTrendReport_BLL.GetWaringListNew(fl_id, StartTime, EndTime, StartIndex, EndIndex); // string json = JSONTools.ScriptSerialize<DataListModel<Production_AlarmModel>>(userList); string json = ""; string fileName = HttpContext.Current.Request.MapPath("~/App_Data/报警信息报表.xlsx"); try { int StartIndex = 1; int EndIndex = -1; int totalcount = 0; DataTable resTable = Production_AlarmTrendReport_BLL.GetWaringDataTable(fl_id, StartTime, EndTime, StartIndex, EndIndex); //ExcelHelper.ExportDTtoExcel(resTable, "报警信息报表", fileName); string err = ""; AsposeExcelTools.DataTableToExcel2(resTable, fileName, out err); string ss = "true"; if (err.Length < 1) { ss = "true"; } else { ss = "false"; } /// ////// json = "{\"Result\":\"" + ss + "\"}"; } catch (Exception e) { string ss1 = "false"; json = "{\"Result\":\"" + ss1 + "\"}"; } context.Response.ContentType = "json"; context.Response.Write(json); }
void Export() //点检查询结果导出 { string json = ""; DataTable ResTable = new DataTable(); JavaScriptSerializer s = new JavaScriptSerializer(); HttpRequest request = HttpContext.Current.Request; string AssemblyLine = request.Params["fl_name"]; string Station = request.Params["st_no"]; string StartTime = request.Params["StartTime"]; string EndTime = request.Params["EndTime"]; int PageIndex = Convert.ToInt32(request["page"]); int PageSize = Convert.ToInt32(request["rows"]); string where = ""; if (!string.IsNullOrEmpty(AssemblyLine)) { where = " and a.StationNO LIKE '" + AssemblyLine + "%'"; } if (!string.IsNullOrEmpty(Station)) { where = " and a.StationNO = '" + Station + "'"; } if (!string.IsNullOrEmpty(StartTime)) { where += " and cast(a.CreateTime as datetime) > '" + StartTime + "'"; } if (!string.IsNullOrEmpty(EndTime)) { where += " and cast(a.CreateTime as datetime) < '" + EndTime + "'"; } int StartIndex = PageSize * (PageIndex - 1) + 1; int EndIndex = StartIndex + PageSize - 1; int totalcount; ResTable = checkReport_BLL.getTableExcel(PageSize, PageIndex, StartIndex, EndIndex, sort, order, where, out totalcount); //} try { #region 导出代码 //ExcelHelper.ExportDTtoExcel(ResTable, "", HttpContext.Current.Request.MapPath("~/App_Data/点检记录报表.xlsx")); string fileName = HttpContext.Current.Request.MapPath("~/App_Data/点检记录报表.xlsx"); string err = ""; AsposeExcelTools.DataTableToExcel2(ResTable, fileName, out err); string ss = "true"; if (err.Length < 1) { ss = "true"; } else { ss = "false"; } json = ss; #endregion } catch { json = "false"; } Response.Write(json); }
/// <summary> /// 导出Excel的操作 /// </summary> private void btnExport_Click(object sender, EventArgs e) { string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName)); if (!string.IsNullOrEmpty(file)) { string where = GetConditionSql(); List <AddressInfo> list = new List <AddressInfo>(); TreeNode selectedNode = this.treeView1.SelectedNode; if (isUserGroupName && selectedNode != null) { string groupName = ""; //只有是数据库的分组才使用条件 if (selectedNode.Text != "所有联系人" && selectedNode.Text != "未分组联系人") { groupName = this.treeView1.SelectedNode.Text; } list = BLLFactory <Address> .Instance.FindByGroupName(LoginUserInfo.Id, groupName); } else { list = BLLFactory <Address> .Instance.Find(where); } DataTable dtNew = DataTableHelper.CreateTable("序号|int,姓名,性别,出生日期,手机,电子邮箱,QQ,家庭电话,办公电话,家庭住址,办公地址,传真号码,公司单位,部门,职位,其他,备注,创建人,创建时间"); DataRow dr; int j = 1; for (int i = 0; i < list.Count; i++) { dr = dtNew.NewRow(); dr["序号"] = j++; dr["姓名"] = list[i].Name; dr["性别"] = list[i].Gender; dr["出生日期"] = list[i].Birthday; dr["手机"] = list[i].MobilePhone; dr["电子邮箱"] = list[i].Email; dr["QQ"] = list[i].QQ; dr["家庭电话"] = list[i].HomePhone; dr["办公电话"] = list[i].OfficePhone; dr["家庭住址"] = list[i].HomeAddress; dr["办公地址"] = list[i].OfficeAddress; dr["传真号码"] = list[i].Fax; dr["公司单位"] = list[i].CompanyName; dr["部门"] = list[i].DeptName; dr["职位"] = list[i].WorkPosition; dr["其他"] = list[i].Other; dr["备注"] = list[i].Remark; dr["创建人"] = list[i].CreatorId; dr["创建时间"] = list[i].CreatorTime; dtNew.Rows.Add(dr); } try { string error = ""; AsposeExcelTools.DataTableToExcel2(dtNew, file, out error); if (!string.IsNullOrEmpty(error)) { MessageDxUtil.ShowError(string.Format("导出Excel出现错误:{0}", error)); } else { if (MessageDxUtil.ShowYesNoAndTips("导出成功,是否打开文件?") == System.Windows.Forms.DialogResult.Yes) { System.Diagnostics.Process.Start(file); } } } catch (Exception ex) { LogHelper.WriteLog(LogLevel.LOG_LEVEL_CRIT, ex, typeof(FrmAddress)); MessageDxUtil.ShowError(ex.Message); } } }
public void ProcessRequest(HttpContext context) { HttpRequest request = System.Web.HttpContext.Current.Request; string StartTime = request["start_time"]; string EndTime = request["end_time"]; string clnameid = request["clnameid"]; string method = context.Request["method"]; int PageSize = Convert.ToInt32(request["rows"]); int PageIndex = Convert.ToInt32(request["page"]); string SortFlag = request["sort"]; string sortOrder = request["order"]; string where = ""; if (!string.IsNullOrEmpty(StartTime)) { where += " and cl_starttime>='" + StartTime + "'"; } if (!string.IsNullOrEmpty(EndTime)) { where += " and cl_endtime<='" + EndTime + "'"; } if (!string.IsNullOrEmpty(clnameid)) { where += " and cl_name like'%" + clnameid + "%'"; } int totalcount; DataTable resTable = new DataTable(); sort = SortFlag; order = sortOrder; int StartIndex = PageSize * (PageIndex - 1) + 1; int EndIndex = StartIndex + PageSize - 1; if (string.IsNullOrEmpty(method)) { resTable = FTT_BLL.getTable(PageSize, PageIndex, StartIndex, EndIndex, sort, order, where, out totalcount); string JsonStr = FunCommon.DataTableToJson2(totalcount, resTable); context.Response.ContentType = "text/plain"; context.Response.Write(JsonStr); context.Response.End(); } if (method == "Export") { string json = ""; string fileName = HttpContext.Current.Request.MapPath("~/App_Data/FTT数据查询.xlsx"); try { string err = ""; StartIndex = 1; EndIndex = -1; totalcount = 0; resTable = FTT_BLL.getTableExcel(PageSize, PageIndex, StartIndex, EndIndex, sort, order, where, out totalcount); // ExcelHelper.ExportDTtoExcel(resTable, "生产线报警趋势报表", fileName); AsposeExcelTools.DataTableToExcel2(resTable, fileName, out err); string ss = "true"; if (err.Length < 1) { ss = "true"; } else { ss = "false"; } json = "{\"Result\":\"" + ss + "\"}"; } catch (Exception e) { string ss1 = "false"; json = "{\"Result\":\"" + ss1 + "\"}"; } context.Response.ContentType = "json"; context.Response.Write(json); } }
public void ProcessRequest(HttpContext context) { JavaScriptSerializer s = new JavaScriptSerializer(); HttpRequest request = HttpContext.Current.Request; string StartTime = request["StartTime"]; string EndTime = request["EndTime"]; string OrderCode = request["OrderCode"]; string StationNo = request["StationNo"]; string method = request["method"]; if (string.IsNullOrEmpty(StartTime)) { DateTime t = DateTime.Now.AddMonths(-1); StartTime = t.ToString("yyyy-MM-dd HH:mm:ss"); } if (string.IsNullOrEmpty(EndTime)) { DateTime t = DateTime.Now; EndTime = t.ToString("yyyy-MM-dd HH:mm:ss"); } if (OrderCode == "请选择") { OrderCode = ""; } if (StationNo == "请选择") { StationNo = "FSA210"; } int totalcount; string JsonStr = ""; DateTime date = DateTime.Now; string JsonStr3 = ""; string neirong = ""; string yee = ""; int PageIndex = Convert.ToInt32(request["page"]); int PageSize = Convert.ToInt32(request["rows"]); if (string.IsNullOrWhiteSpace(method)) { JsonStr3 = checkRepair_BLL.getTableString(StartTime, EndTime, OrderCode, StationNo, PageIndex, out totalcount); context.Response.ContentType = "json"; context.Response.Write(JsonStr3); } else if (method == "GetListNew") { JsonStr3 = checkRepair_BLL.GetListNew(StartTime, EndTime, OrderCode, StationNo, PageIndex, PageSize, out totalcount); context.Response.ContentType = "json"; context.Response.Write(JsonStr3); } #region 导出代码 else if (method == "Export") { DataTable ResTable4 = checkRepair_BLL.getTableExcel(StartTime, EndTime, OrderCode, StationNo, PageIndex, out totalcount); string str = ""; try { // ExcelHelper.ExportDTtoExcel(ResTable4, "", HttpContext.Current.Request.MapPath("~/App_Data/检测返修报表.xlsx")); AsposeExcelTools.DataTableToExcel2(ResTable4, HttpContext.Current.Request.MapPath("~/App_Data/检测返修报表.xlsx"), out str); if (str.Length < 1) { JsonStr3 = "true"; } else { JsonStr3 = "false"; } } catch { JsonStr3 = "false"; } context.Response.ContentType = "json"; context.Response.Write(JsonStr3); } #endregion }
public void Export(HttpContext context) { string start_time = context.Request["start_time"]; string end_time = context.Request["end_time"]; int PageSize = Convert.ToInt32(context.Request["rows"]); int PageIndex = Convert.ToInt32(context.Request["page"]); StringBuilder commandText = new StringBuilder(); string where = ""; if (string.IsNullOrEmpty(start_time)) { DateTime t = DateTime.Now.AddMonths(-1); start_time = t.ToString("yyyy-MM-dd"); } string StartTime = start_time.Substring(0, 10); if (string.IsNullOrEmpty(end_time)) { DateTime t = DateTime.Now; end_time = t.ToString("yyyy-MM-dd"); } string EndTime = end_time.Substring(0, 10); string sidx = RequstString("sidx"); //排序名称 string sort = RequstString("sord"); //排序方式 if ("-1" == sort) { sort = "id"; } if ("-1" == order) { order = "asc"; } string err = ""; string json = ""; string fileName = HttpContext.Current.Request.MapPath("~/App_Data/生产线报警趋势报表.xlsx"); try { int StartIndex = 1; int EndIndex = -1; int totalcount = 0; DataTable resTable = Production_AlarmTrendReport_BLL.getTable(StartTime, EndTime, PageSize, StartIndex, EndIndex, sort, order, where, out totalcount); // ExcelHelper.ExportDTtoExcel(resTable, "生产线报警趋势报表", fileName); AsposeExcelTools.DataTableToExcel2(resTable, fileName, out err); string ss = "true"; if (err.Length < 1) { ss = "true"; } else { ss = "false"; } json = "{\"Result\":\"" + ss + "\"}"; } catch (Exception e) { string ss1 = "false"; json = "{\"Result\":\"" + ss1 + "\"}"; } context.Response.ContentType = "json"; context.Response.Write(json); }