//private sara.dd.ldsw.model.tbl_ld_khb _model_tbl_ld_khb = new sara.dd.ldsw.model.tbl_ld_khb(); //private sara.dd.ldsw.idal.Itbl_ld_khb _idal_tbl_ld_khb = commonclass.dalfactory.Create<sara.dd.ldsw.idal.Itbl_ld_khb>(); //new sara.dd.ldsw.dal.tbl_ld_khb(); #endregion #region 公有方法 /// <summary> /// /// </summary> /// <param name="fk_tbl_ld_yhb_sys_id"></param> /// <param name="p"></param> /// <returns></returns> public string ReportExcel(DataTable dt_data, string column, string columnname) { #region 导出CSV _cc.ClearReportFile(); string[] columnarr = columnname.Split(','); for (int i = 0; i < columnarr.Length; i++) { dt_data.Columns[i].ColumnName = columnarr[i]; } string filepath = Eva.Library.Format.FormatTextTool.GetMapPath(Eva.Library.Configuration.ConfigurationManager.AppSettings["ExportYCHKRootPath"].ToString(), HttpContext.Current.Server); string filename = "远传表导出" + Eva.Library.Text.NumberTool.GetNoRepeatNumber() + ".csv"; sara.dd.ldsw.commonclass.commonclass.SaveCSV(dt_data, filepath + filename); return(Eva.Library.Configuration.ConfigurationManager.AppSettings["ExportYCHKRootPath"].ToString() + filename); #endregion }
private sara.dd.ldsw.idal.Itbl_ld_ickss _idal_tbl_ld_ickss = commonclass.dalfactory.Create <sara.dd.ldsw.idal.Itbl_ld_ickss>(); //new sara.dd.ldsw.dal.tbl_maintable(); #endregion #region 公有方法 /// <summary> /// 缴费历史报表 /// </summary> /// <param name="fk_tbl_maintable_sys_id"></param> /// <returns></returns> public string Report_ickss(DataTable dl_data) { #region 执行操作 #region 报表导出 //数据项 DataSet ds_base = new DataSet(); //合并单元格 DataSet ds_merge = new DataSet(); //表格 DataSet ds_table = new DataSet(); //报表名称(唯一标识) string reportname = "tbl_ld_ickss"; //传入值:是否需要html预览(true,false);传出值:html文件路径或false string html = "false"; //要导出文件名(用于对导出的文件命名) string outfilename = "IC卡售水记录"; //错误代码:为空时:说明成功;不为空时:请查阅错误表 string errormessage = ""; //文件路径:用于接受要导出文件的全路径 string filepath = ""; #region 组织数据 #region 获取数据 for (int i = 0; i < dl_data.Columns.Count; i++) { dl_data.Columns[i].ColumnName = dl_data.Columns[i].ColumnName.ToString().ToUpper(); } // //操作时间 // dl_data.Columns.Add(new DataColumn("CZSJ_TEXT")); //for (int i = 0; i < dl_data.Rows.Count; i++) //{ // dl_data.Rows[i]["CZSJ_TEXT"] = (DateTime.Parse(dl_data.Rows[i]["f_czsj"].ToString())).ToString("yyyy-MM-dd HH:mm:ss"); //} #endregion //数据项 #region 数据项 DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("DATANAME")); //数据项名称 dt.Columns.Add(new DataColumn("DATAVALUE")); //数据据项值(如果数据项是值,此处填写数据项的值,否则为空) dt.Columns.Add(new DataColumn("TABLENAME")); //数据据项关联表名(如果数据项是表格,此处填写表格名称,否则为空) dt.Columns.Add(new DataColumn("LOCATION")); //定位信息:一般为空,在报表服务中设置 dt.Columns.Add(new DataColumn("STYLE")); //样式信息:一般为空,在报表服务中设置 DataRow dr = dt.NewRow(); //添加数据项 dr["DATANAME"] = "<@_TABLE_@>"; //数据项名称--与配置信息中数据项名称对应 //ws20130626 dr["DATAVALUE"] = ""; // _model_tbl_100_xm_qkdcb.f_qsdwmc.ToString(); //因为此数项为表格,所以此处空 //dr["DATAVALUE"] = _model_tbl_100_xm_qkdcb.f_qsdwmc.ToString(); //因为此数项为表格,所以此处空 dr["TABLENAME"] = "data"; //因为此数项为表格,所以此处填写表格名称(1) dt.Rows.Add(dr); ds_base.Tables.Add(dt); #region 数据 #endregion //表格 #region 表格 //表格 DataTable dt_table = dl_data.Copy(); //第一行用于存列数据类型 dr = dt_table.NewRow(); dt_table.Rows.InsertAt(dr, 0); dt_table.TableName = "data"; //与上文(1)处的表格名称相对应 ds_table.Tables.Add(dt_table); #endregion #endregion //合并单元格 #region 合并单元格 DataTable dt_merge = new DataTable("data");//与上文(1)处的表格名称相对应 dt_merge.Columns.Add(new DataColumn("startrow")); dt_merge.Columns.Add(new DataColumn("startcolumn")); dt_merge.Columns.Add(new DataColumn("endrow")); dt_merge.Columns.Add(new DataColumn("endcolumn")); ds_merge.Tables.Add(dt_merge); #endregion #endregion //if (ds_table != null && ds_table.Tables.Count > 0 && ds_table.Tables[0] != null) //{ // for (int i_c = 0; i_c < ds_table.Tables[0].Columns.Count; i_c++) // { // ds_table.Tables[0].Columns[i_c].ColumnName = ds_table.Tables[0].Columns[i_c].ColumnName.ToUpper(); // } //} _cc.ClearReportFile(); if (sara.dd.ldsw.commonclass.commonclass.GetPlatformServiceModel() == "dll") { filepath = sara.platform.service.report.Service.CreatReport(ds_base, ds_table, ds_merge, reportname, ref html, ref outfilename, ref errormessage); } else { filepath = _ir.CreatReport(ds_base, ds_table, ds_merge, reportname, ref html, ref outfilename, ref errormessage); } if (errormessage == "") { string path = filepath; string filename = ""; int count = path.LastIndexOf('\\'); filename = path.Substring(count, path.Length - count); filename = filename.TrimStart('\\'); return(Eva.Library.Configuration.ConfigurationManager.AppSettings["ReportFileDownLoadLoadRootPath"].ToString() + filename); } else { throw new Exception(errormessage); } #endregion #endregion }
private sara.dd.ldsw.idal.Itbl_ld_khb _idal_tbl_ld_khb = commonclass.dalfactory.Create <sara.dd.ldsw.idal.Itbl_ld_khb>(); //new sara.dd.ldsw.dal.tbl_ld_khb(); #endregion #region 公有方法 /// <summary> /// /// </summary> /// <param name="fk_tbl_ld_khb_sys_id"></param> /// <param name="p"></param> /// <returns></returns> public string ReportExcel(DataTable dt_data) { #region 执行操作 #region 报表导出 //数据项 DataSet ds_base = new DataSet(); //合并单元格 DataSet ds_merge = new DataSet(); //表格 DataSet ds_table = new DataSet(); //报表名称(唯一标识) string reportname = "tbl_ld_khb_qfxxtj"; //传入值:是否需要html预览(true,false);传出值:html文件路径或false string html = "false"; //要导出文件名(用于对导出的文件命名) string outfilename = ""; //错误代码:为空时:说明成功;不为空时:请查阅错误表 string errormessage = ""; //文件路径:用于接受要导出文件的全路径 string filepath = ""; #region 组织数据 //#region 获取数据 //_model_tbl_ld_khb = _idal_tbl_ld_khb.GetList(" sys_id='" + fk_tbl_ld_khb_sys_id + "'", "", "*", "", "", null)[0]; //#endregion //数据项 #region 数据项 DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("DATANAME")); //数据项名称 dt.Columns.Add(new DataColumn("DATAVALUE")); //数据据项值(如果数据项是值,此处填写数据项的值,否则为空) dt.Columns.Add(new DataColumn("TABLENAME")); //数据据项关联表名(如果数据项是表格,此处填写表格名称,否则为空) dt.Columns.Add(new DataColumn("LOCATION")); //定位信息:一般为空,在报表服务中设置 dt.Columns.Add(new DataColumn("STYLE")); //样式信息:一般为空,在报表服务中设置 DataRow dr; #region 数据 //表格 dr = dt.NewRow(); dr["DATANAME"] = "<@_TABLE_@>"; dr["DATAVALUE"] = ""; dr["TABLENAME"] = "TABLE"; dt.Rows.Add(dr); ds_base.Tables.Add(dt); #endregion //表格 DataTable dt_table = dt_data.Clone(); //第一行用于存列数据类型 dr = dt_table.NewRow(); dt_table.Rows.Add(dr); //输入数据 DataRow dr_temp; for (int i = 0; i < dt_data.Rows.Count; i++) { dr_temp = dt_table.NewRow(); for (int j = 0; j < dt_data.Columns.Count; j++) { dr_temp[j] = dt_data.Rows[i][j].ToString(); } dt_table.Rows.Add(dr_temp); } dt_table.TableName = "TABLE"; //与上文(1)处的表格名称相对应 ds_table.Tables.Add(dt_table); //合并单元格 #region 合并单元格 DataTable dt_merge = new DataTable("TABLE");//与上文(1)处的表格名称相对应 dt_merge.Columns.Add(new DataColumn("startrow")); dt_merge.Columns.Add(new DataColumn("startcolumn")); dt_merge.Columns.Add(new DataColumn("endrow")); dt_merge.Columns.Add(new DataColumn("endcolumn")); DataRow dr_merge; ////从下向上,从右向左,录入合并信息 //int count_datasource = datasource.Rows.Count; ////合计 //dr_merge = dt_merge.NewRow(); //dr_merge["startrow"] = count_datasource.ToString(); //dr_merge["startcolumn"] = "1"; //dr_merge["endrow"] = count_datasource.ToString(); //dr_merge["endcolumn"] = "2"; //dt_merge.Rows.Add(dr_merge); ds_merge.Tables.Add(dt_merge); #endregion #endregion #endregion #endregion _cc.ClearReportFile(); if (sara.dd.ldsw.commonclass.commonclass.GetPlatformServiceModel() == "dll") { filepath = sara.platform.service.report.Service.CreatReport(ds_base, ds_table, ds_merge, reportname, ref html, ref outfilename, ref errormessage); } else { filepath = _ir.CreatReport(ds_base, ds_table, ds_merge, reportname, ref html, ref outfilename, ref errormessage); } if (errormessage == "") { string path = filepath; string filename = ""; int count = path.LastIndexOf('\\'); filename = path.Substring(count, path.Length - count); filename = filename.TrimStart('\\'); return(Eva.Library.Configuration.ConfigurationManager.AppSettings["ReportFileDownLoadLoadRootPath"].ToString() + filename); } else { throw new Exception(errormessage); } #endregion }
private sara.dd.ldsw.idal.Itbl_ld_khb _idal_tbl_ld_khb = commonclass.dalfactory.Create <sara.dd.ldsw.idal.Itbl_ld_khb>(); //new sara.dd.ldsw.dal.tbl_ld_khb(); #endregion #region 公有方法 /// <summary> /// /// </summary> /// <param name="fk_tbl_ld_khb_sys_id"></param> /// <param name="p"></param> /// <returns></returns> public string ReportExcel(DataTable dt_data, string column, string columnname) { #region //#region 执行操作 //#region 报表导出 //数据项 //DataSet ds_base = new DataSet(); //合并单元格 //DataSet ds_merge = new DataSet(); //表格 //DataSet ds_table = new DataSet(); //报表名称(唯一标识) //string reportname = "tbl_ld_report_khzdybb"; //传入值:是否需要html预览(true,false);传出值:html文件路径或false //string html = "false"; //要导出文件名(用于对导出的文件命名) //string outfilename = ""; //错误代码:为空时:说明成功;不为空时:请查阅错误表 //string errormessage = ""; //文件路径:用于接受要导出文件的全路径 //string filepath = ""; //#region 组织数据 //#region 获取数据 //_model_tbl_ld_khb = _idal_tbl_ld_khb.GetList(" sys_id='" + fk_tbl_ld_khb_sys_id + "'", "", "*", "", "", null)[0]; //#endregion //数据项 //#region 数据项 //DataTable dt = new DataTable(); //dt.Columns.Add(new DataColumn("DATANAME")); //数据项名称 //dt.Columns.Add(new DataColumn("DATAVALUE")); //数据据项值(如果数据项是值,此处填写数据项的值,否则为空) //dt.Columns.Add(new DataColumn("TABLENAME")); //数据据项关联表名(如果数据项是表格,此处填写表格名称,否则为空) //dt.Columns.Add(new DataColumn("LOCATION")); //定位信息:一般为空,在报表服务中设置 //dt.Columns.Add(new DataColumn("STYLE")); //样式信息:一般为空,在报表服务中设置 //DataRow dr; //#region 数据 //表格 //dr = dt.NewRow(); //dr["DATANAME"] = "<@_TABLE_@>"; //dr["DATAVALUE"] = ""; //dr["TABLENAME"] = "TABLE"; //dt.Rows.Add(dr); //ds_base.Tables.Add(dt); //#endregion //表格 //DataTable dt_table = dt_data.Clone(); //第一行用于存列数据类型 //dr = dt_table.NewRow(); //DataRow dr2 = dt_table.NewRow(); //string[] columnarr = columnname.Split(','); //for (int i = 0; i < columnarr.Length; i++) //{ // dr[i] = "0"; // dr2[i] = columnarr[i]; //} //dt_table.Rows.Add(dr); //dt_table.Rows.Add(dr2); //输入数据 //DataRow dr_temp; //for (int i = 0; i < dt_data.Rows.Count; i++) //{ // dr_temp = dt_table.NewRow(); // for (int j = 0; j < dt_data.Columns.Count; j++) // { // dr_temp[j] = dt_data.Rows[i][j].ToString(); // } // dt_table.Rows.Add(dr_temp); //} //dt_table.TableName = "TABLE"; //与上文(1)处的表格名称相对应 //ds_table.Tables.Add(dt_table); //合并单元格 //#region 合并单元格 //DataTable dt_merge = new DataTable("TABLE");//与上文(1)处的表格名称相对应 //dt_merge.Columns.Add(new DataColumn("startrow")); //dt_merge.Columns.Add(new DataColumn("startcolumn")); //dt_merge.Columns.Add(new DataColumn("endrow")); //dt_merge.Columns.Add(new DataColumn("endcolumn")); //DataRow dr_merge; ////从下向上,从右向左,录入合并信息 //int count_datasource = datasource.Rows.Count; ////合计 //dr_merge = dt_merge.NewRow(); //dr_merge["startrow"] = count_datasource.ToString(); //dr_merge["startcolumn"] = "1"; //dr_merge["endrow"] = count_datasource.ToString(); //dr_merge["endcolumn"] = "2"; //dt_merge.Rows.Add(dr_merge); //ds_merge.Tables.Add(dt_merge); #endregion #region 导出CSV _cc.ClearReportFile(); string[] columnarr = columnname.Split(','); for (int i = 0; i < columnarr.Length; i++) { dt_data.Columns[i].ColumnName = columnarr[i]; } string filepath = Eva.Library.Format.FormatTextTool.GetMapPath(Eva.Library.Configuration.ConfigurationManager.AppSettings["ReportFileDownLoadLoadRootPath"].ToString(), HttpContext.Current.Server); string filename = "客户信息自定义" + Eva.Library.Text.NumberTool.GetNoRepeatNumber() + ".csv"; sara.dd.ldsw.commonclass.commonclass.SaveCSV(dt_data, filepath + filename); return(Eva.Library.Configuration.ConfigurationManager.AppSettings["ReportFileDownLoadLoadRootPath"].ToString() + filename); #endregion }
private sara.dd.ldsw.idal.Itbl_maintable _idal_tbl_maintable = commonclass.dalfactory.Create <sara.dd.ldsw.idal.Itbl_maintable>(); //new sara.dd.ldsw.dal.tbl_maintable(); #endregion #region 公有方法 /// <summary> /// /// </summary> /// <param name="fk_tbl_maintable_sys_id"></param> /// <param name="p"></param> /// <returns></returns> public string ReportWord(string fk_tbl_maintable_sys_id) { #region 执行操作 #region 报表导出 //数据项 DataSet ds_base = new DataSet(); //合并单元格 DataSet ds_merge = new DataSet(); //表格 DataSet ds_table = new DataSet(); //报表名称(唯一标识) string reportname = "40_tbl_maintable"; //传入值:是否需要html预览(true,false);传出值:html文件路径或false string html = "false"; //要导出文件名(用于对导出的文件命名) string outfilename = ""; //错误代码:为空时:说明成功;不为空时:请查阅错误表 string errormessage = ""; //文件路径:用于接受要导出文件的全路径 string filepath = ""; #region 组织数据 _model_tbl_maintable = _idal_tbl_maintable.GetList(" sys_id='" + fk_tbl_maintable_sys_id + "'", "", "*", "", "", null)[0]; //数据项 #region 数据项 DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("DATANAME")); //数据项名称 dt.Columns.Add(new DataColumn("DATAVALUE")); //数据据项值(如果数据项是值,此处填写数据项的值,否则为空) dt.Columns.Add(new DataColumn("TABLENAME")); //数据据项关联表名(如果数据项是表格,此处填写表格名称,否则为空) dt.Columns.Add(new DataColumn("LOCATION")); //定位信息:一般为空,在报表服务中设置 dt.Columns.Add(new DataColumn("STYLE")); //样式信息:一般为空,在报表服务中设置 //项目名称 DataRow dr = dt.NewRow(); dr["DATANAME"] = "<@_TBL_MAINTABLE_XMMC_@>"; dr["DATAVALUE"] = _model_tbl_maintable.xmmc; dr["TABLENAME"] = ""; dt.Rows.Add(dr); //单位名称 dr = dt.NewRow(); dr["DATANAME"] = "<@_TBL_MAINTABLE_DWMC_@>"; dr["DATAVALUE"] = _model_tbl_maintable.dwmc; dr["TABLENAME"] = ""; dt.Rows.Add(dr); ds_base.Tables.Add(dt); #endregion //表格 #region 表格 //DataTable dt_data = _bll_tbl_100_xm_qsqk_xx.GetList(" fk_tbl_maintable_sys_id='" + fk_tbl_maintable_sys_id + "'").Tables[0]; //DataTable dt_table = dt_data.Clone(); ////第一行用于存列数据类型 //dr = dt_table.NewRow(); //dt_table.Rows.Add(dr); //dt_table.TableName = "TBL_100_XM_QSQK_XX_MODALPOPUPLIST"; //与上文(1)处的表格名称相对应 //ds_table.Tables.Add(dt_table); //与上文(1)处的表格名称相对应 #endregion //合并单元格 #region 合并单元格 DataTable dt_merge = new DataTable("TBL_MAINTABLE");//与上文(1)处的表格名称相对应 dt_merge.Columns.Add(new DataColumn("startrow")); dt_merge.Columns.Add(new DataColumn("startcolumn")); dt_merge.Columns.Add(new DataColumn("endrow")); dt_merge.Columns.Add(new DataColumn("endcolumn")); //DataRow dr_merge; //从下向上,从右向左,录入合并信息 ds_merge.Tables.Add(dt_merge); #endregion #endregion #endregion _cc.ClearReportFile(); if (sara.dd.ldsw.commonclass.commonclass.GetPlatformServiceModel() == "dll") { filepath = sara.platform.service.report.Service.CreatReport(ds_base, ds_table, ds_merge, reportname, ref html, ref outfilename, ref errormessage); } else { filepath = _ir.CreatReport(ds_base, ds_table, ds_merge, reportname, ref html, ref outfilename, ref errormessage); } if (errormessage == "") { string path = filepath; string filename = ""; int count = path.LastIndexOf('\\'); filename = path.Substring(count, path.Length - count); filename = filename.TrimStart('\\'); return(Eva.Library.Configuration.ConfigurationManager.AppSettings["ReportFileDownLoadLoadRootPath"].ToString() + filename); } else { throw new Exception(errormessage); } #endregion }