public void ExportExcelMonth(DateTime dt, DateTime dt2, string orgid) { //lgm ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\所月度停电计划.xls"; ex.Open(fname); string startday = "20"; IList list = Client.ClientHelper.PlatformSqlMap.GetList("SelectOneStr", string.Format("select nr from pj_dyk where dx='所月度停电计划' and sx like '%{0}%' and nr!=''", "申报截止日期")); if (list.Count > 0) startday=list[0].ToString(); string str = " where (TDtime between '" +dt.Year + "-" + dt.Month + "-" + dt.Day + " 00:00:00' and '" + dt2.Year + "-" + dt2.Month + "-" + dt2.Day + " 23:59:59' ) "; if (orgid != "") str += " and OrgCode='" + orgid + "'"; IList<PJ_tdjh> datalist = Client.ClientHelper.PlatformSqlMap.GetListByWhere<PJ_tdjh>( str ); ExportExcel(dt, ex, datalist); ex.ShowExcel(); }
public static void Print(PrintType printType, BarcodeSample sample, TestResult technic, TestResult reality) { ExcelAccess access = new ExcelAccess(); string path = ConfigurationManager.AppSettings["template"]; string fullPath = Path.GetFullPath(path); access.Open(fullPath); access.IsVisibledExcel = true; access.FormCaption = "商品条码符号检测数据"; switch (printType) { case PrintType.Print: access.Print(); break; case PrintType.PrintView: access.PrintPreview(); break; default: access.Close(); break; } access.Close(); }
/// <summary> /// 文档格式预定义好的,只填写内容 /// </summary> /// <param name="obj"></param> public static void ExportExcel(sdjl_26 obj) { ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\送电17防护通知书.xls"; int sz = 30;//一行最多30个 ex.Open(fname); //此处写填充内容代码 ex.ActiveSheet(1); //通知单位 ex.SetCellValue(obj.tzdw, 5, 1); //电压 ex.SetCellValue(obj.lineVol, 6, 7); //线路 ex.SetCellValue(obj.c1, 6, 9); //发现问题 List<string> fxwtList = GetList(obj.fxwt, sz); for (int i = 0; i < fxwtList.Count; i++) { ex.SetCellValue(fxwtList[i], 7+i, 1); if (i > 1) break; } //处理措施 List<string> clcsList = GetList(obj.clcs, sz); for (int i = 0; i < clcsList.Count; i++) { ex.SetCellValue(obj.clcs, 12+i, 1); if (i > 2) break; } ex.ShowExcel(); }
internal static void ExportCK(string rkid) { ExcelAccess ea = new ExcelAccess(); string filename = AppDomain.CurrentDomain.BaseDirectory + "\\00记录模板\\.xls"; if (!File.Exists(filename)) { //导出资源文件到本机 Stream obj = typeof(PrintHelper).Assembly.GetManifestResourceStream("Ebada.Kcgl._00记录模板..xls"); object[] files = typeof(PrintHelper).Assembly.GetManifestResourceNames(); if (obj != null) { byte[] buff = new byte[obj.Length]; obj.Read(buff, 0, (int)obj.Length); FileStream fs = new FileStream(filename, FileMode.OpenOrCreate); fs.Write(buff, 0, buff.Length); fs.Flush(); fs.Close(); fs.Dispose(); } } ea.Open(filename); //显示文件 ea.Print(); ea.DisPoseExcel(); }
/// <summary> /// 文档格式预定义好的,只填写内容 /// </summary> /// <param name="obj"></param> public void ExportExcel() { ////lgm ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\局设备评级计划.xls"; ex.Open(fname); string strfirst = ""; string filter = ""; filter = " where 1=1 "; if (isWorkflowCall) { filter = filter + " and id not in (select ModleRecordID from WF_ModleRecordWorkTaskIns where WorkFlowId='" + WorkFlowData.Rows[0]["WorkFlowId"].ToString() + "') " + " or id in (select ModleRecordID from WF_ModleRecordWorkTaskIns where " + " RecordID='" + currRecord.ID + "') " ; } IList<PJ_jsbpjjh> datalist = Client.ClientHelper.PlatformSqlMap.GetListByWhere<PJ_jsbpjjh>( filter ); ExportExcel(ex, datalist); ex.ShowExcel(); }
public void ExportExcelYear(string orgid, string year) { ////lgm ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\设备标志缺失变更明细表二.xls"; ex.Open(fname); string strfirst = ""; string filter = ""; filter = " where 1=1 "; if (orgid != "") filter += " and OrgCode='" + orgid + "'"; if (isWorkflowCall) { filter = filter + " and id not in (select ModleRecordID from WF_ModleRecordWorkTaskIns where WorkFlowId='" + WorkFlowData.Rows[0]["WorkFlowId"].ToString() + "') " + " or id in (select ModleRecordID from WF_ModleRecordWorkTaskIns where " + " RecordID='" + currRecord.ID + "') " ; } IList<PJ_sbbzqsbgmxb2> datalist = Client.ClientHelper.PlatformSqlMap.GetListByWhere<PJ_sbbzqsbgmxb2>( filter ); ExportExcel(ex, datalist, orgid); ex.ShowExcel(); }
public static void ExportExcel(Dictionary<string, List<PJ_qxfl>> objdic) { ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\06设备巡视及缺陷消除记录.xls"; ex.Open(fname); int zc = 20; //与会人员之间的间隔符号 char[] jksign = new char[1] { ';' }; int row = 7; int col = 1; int len1 = 3; int pageindex = 1; pageindex = objdic.Count; //根据所有的线路数来确定创建的页数 for (int j = 1; j <= pageindex; j++) { if (j > 1) { ex.CopySheet(1, 1); } } int pags = 0; foreach (KeyValuePair<string, List<PJ_qxfl>> pp in objdic) { List<PJ_qxfl> objlist = pp.Value; ex.ActiveSheet(pags++); } }
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = ""; saveFileDialog1.Filter = "Microsoft Excel (*.xls)|*.xls"; if (saveFileDialog1.ShowDialog() == DialogResult.OK) { fname = saveFileDialog1.FileName; try { dsoFramerControl1.FileSave(saveFileDialog1.FileName, true); if (MsgBox.ShowAskMessageBox("导出成功,是否打开该文档?") != DialogResult.OK) { ExcelAccess ex = new ExcelAccess(); ex.Open(fname); //此处写填充内容代码 ex.ShowExcel(); return; } } catch { MsgBox.ShowSuccessfulMessageBox("无法保存" + fname + "。请用其他文件名保存文件,或将文件存至其他位置。"); return; } } }
public static void ExportExcel10KV(IList<PS_kgjctj> datalist) { ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\10KV用户供电可靠性基础数据统计表.xls"; ex.Open(fname); int rowcount = 1; if (datalist.Count < 1) return; string tablename = "10KV用户供电可靠性基础数据统计表"; if (tablename.Length > 30) { tablename = tablename.Substring(tablename.Length - 31); } // //加页 int pageindex = datalist.Count; for (int j = 1; j < pageindex; j++) { ex.CopySheet(1, j); ex.ReNameWorkSheet(j + 1, tablename + "(" + (j) + ")"); } for (int j = 0; j < datalist.Count; j++) { if (j == 0) { ex.ActiveSheet(tablename); } else { ex.ActiveSheet(tablename + "(" + j + ")"); } // 填值 ex.SetCellValue(datalist[j].OrgName, 3, 2); ex.SetCellValue(datalist[j].CreateTime.ToString("yyyy年MM月dd日"), 5, 9); ex.SetCellValue(datalist[j].kgModel, 5, 2); ex.SetCellValue(datalist[j].iscxkg == true ? "是" : "否", 5, 7); ex.SetCellValue(datalist[j].kgCode, 5, 9); ex.SetCellValue(datalist[j].jkdxcd, 10, 2); ex.SetCellValue(datalist[j].dlxlcd, 10, 7); ex.SetCellValue(datalist[j].publicusercount.ToString(), 11, 2); ex.SetCellValue(datalist[j].publicbtcount.ToString(), 11, 5); ex.SetCellValue(datalist[j].publicbtrlcount.ToString(), 11, 9); ex.SetCellValue(datalist[j].zyusercount.ToString(), 12, 2); ex.SetCellValue(datalist[j].zybtcount.ToString(), 12, 5); ex.SetCellValue(datalist[j].zybtrlcount.ToString(), 12, 9); ex.SetCellValue(datalist[j].sdyusercount.ToString(), 13, 2); ex.SetCellValue(datalist[j].sdyrlcount.ToString(), 13, 5); ex.SetCellValue(datalist[j].zyuserqtsbcount.ToString(), 13, 9); ex.SetCellValue(datalist[j].drqcount.ToString(), 14, 2); ex.SetCellValue(datalist[j].drqrl, 14, 5); ex.SetCellValue(datalist[j].zyuserqtsbrlcount.ToString(), 14, 9); } ex.ActiveSheet(tablename); ex.ShowExcel(); }
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = ""; saveFileDialog1.Filter = "Microsoft Excel (*.xls)|*.xls"; if (saveFileDialog1.ShowDialog() == DialogResult.OK) { fname = saveFileDialog1.FileName; try { dsoFramerControl1.FileSave(saveFileDialog1.FileName, true); //dsoFramerControl1.Dispose(); //dsoExcelControl1.AxFramerControl.Save(fname,true,null,null); // dsoExcelControl1.FileSaveAs(out fname); //if (MsgBox.Show("导出成功!") != DialogResult.Yes) //////MsgBox.Show("导出成功!"); //////dsoExcelControl1.AxFramerControl.Dispose(); //////return; if (MsgBox.ShowAskMessageBox("导出成功,是否打开该文档?") != DialogResult.OK) { //dsoExcelControl1.AxFramerControl.Dispose(); //dsoExcelControl1.Dispose(); ExcelAccess ex = new ExcelAccess(); //SaveFileDialog saveFileDialog1 = new SaveFileDialog(); //string fname = Application.StartupPath + "\\00记录模板\\26防护通知书.xls"; ex.Open(fname); //此处写填充内容代码 ex.ShowExcel(); //Microsoft.Office.Interop.Excel.Application exc = new Microsoft.Office.Interop.Excel.Application(); //引用Excel对象 //Microsoft.Office.Interop.Excel.Workbook book = exc.Application.Workbooks.Add(fname); //引用Excel工作簿 //exc.Visible = true; //使Excel可视 return; } //System.Diagnostics.Process.Start(fname); //ExcelAccess ex = new ExcelAccess(); ////SaveFileDialog saveFileDialog1 = new SaveFileDialog(); ////string fname = Application.StartupPath + "\\00记录模板\\26防护通知书.xls"; //ex.Open(fname); ////此处写填充内容代码 //ex.ShowExcel(); // System.Diagnostics.Process.Start(fname); } catch { MsgBox.ShowSuccessfulMessageBox("无法保存" + fname + "。请用其他文件名保存文件,或将文件存至其他位置。"); return; } } }
/// <summary> /// 文档格式预定义好的,只填写内容 /// </summary> /// <param name="obj"></param> public static void ExportExcel(object obj) { ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\17线路条图.xls"; ex.Open(fname); //此处写填充内容代码 ex.ShowExcel(); }
/// <summary> /// 文档格式预定义好的,只填写内容 /// </summary> /// <param name="obj"></param> public static void ExportExcel(sdjl_23 obj) { ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\送电16电力设备产权、维护范围协议书.xls"; if (obj.BigData != null) { if (obj.BigData.Length > 10) { fname = Path.GetTempPath() + "送电16电力设备产权、维护范围协议书.xls"; //MemoryStream ms = new MemoryStream(obj.BigData); FileStream fs = new FileStream(fname, FileMode.OpenOrCreate); fs.Write(obj.BigData, 0, obj.BigData.Length); fs.Flush(); fs.Close(); } } ex.Open(fname); ex.SetCellValue(obj.jf, 5, 4); ex.SetCellValue(obj.xybh, 4, 11); ex.SetCellValue(obj.cqdw + ":", 6, 4); string linename = ""; if (obj.linename.Contains("线")) { linename = obj.linename.Substring(0, obj.linename.LastIndexOf("线")); } else linename = obj.linename; string[] filtchar = { "V", "v" }; for (int i = 0; i < filtchar.Length; i++) { if (linename.Contains(filtchar[i])) { linename = linename.Substring(linename.LastIndexOf(filtchar[i]) + 1); } } ex.SetCellValue(linename,9, 9); //string fzlinename = ""; //if (obj.fzlinename.Contains("支")) //{ // fzlinename = obj.fzlinename.Substring(0, obj.fzlinename.LastIndexOf("支")); //} //else // fzlinename = obj.fzlinename; //ex.SetCellValue(fzlinename, 10, 10); ex.SetCellValue(obj.cqfw, 10, 4); ex.SetCellValue("'" + obj.gh, 9, 12); ex.SetCellValue(obj.cqdw+"。", 12, 4); ex.SetCellValue(obj.jf, 11, 4); ex.SetCellValue(obj.qxydd, 15, 8); ex.SetCellValue(obj.qdrq.Year.ToString(), 21, 11); ex.SetCellValue(obj.qdrq.Month.ToString(), 21, 13); ex.SetCellValue(obj.qdrq.Day.ToString(), 21, 16); ex.ShowExcel(); }
public void ExportExcelMonth(string orgid) { //lgm ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\客户电力电容器台帐.xls"; ex.Open(fname); ex.ShowExcel(); }
/// <summary> /// 文档格式预定义好的,只填写内容 /// </summary> /// <param name="obj"></param> public void ExportExcel(IList<PJ_sdytz> datalist) { //lgm ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\双电源台账.xls"; ex.Open(fname); ExportExcel(ex, datalist); ex.ShowExcel(); }
/// <summary> /// 文档格式预定义好的,只填写内容 /// </summary> /// <param name="obj"></param> public void ExportExcel(IList<PJ_21dyjcdcbkchild> datalist) { //lgm ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\电压检测点抄表卡.xls"; ex.Open(fname); ExportExcel(ex, datalist); ex.ShowExcel(); }
/// <summary> /// 文档格式预定义好的,只填写内容 /// </summary> /// <param name="obj"></param> public void ExportExcel(IList<PJ_tdjh> datalist) { //lgm ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\所月度停电计划.xls"; ex.Open(fname); ExportExcel(DateTime.Now, ex, datalist); ex.ShowExcel(); }
/// <summary> /// 文档格式预定义好的,只填写内容 /// </summary> /// <param name="obj"></param> public void ExportExcel(IList<PJ_clcrkd> datalist) { //lgm ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\生产台账.xls"; ex.Open(fname); ExportExcel(ex, datalist, "生产物资管理生产台账"); ex.DeleteSheet(1); ex.ShowExcel(); }
public void ExportExcelCunJian(string orgid) { ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\供电所春秋查停电检修计划.xls"; ex.Open(fname); string startmonth = "3", startday= "1", endmonth = "5", endtday = "31"; IList list = Client.ClientHelper.PlatformSqlMap.GetList("SelectOneStr", string.Format("select nr from pj_dyk where dx='供电所春秋查停电检修计划' and sx like '%{0}%' and nr!=''", "春查停电检修开始日期")); if (list.Count > 0) { Regex r1 = new Regex(@"[0-9]+(?=月)"); if(r1.Match(list[0].ToString()).Value!="") { startmonth = r1.Match(list[0].ToString()).Value; } r1 = new Regex(@"(?<=月)[0-9]+"); if (r1.Match(list[0].ToString()).Value != "") { startday = r1.Match(list[0].ToString()).Value; } } list = Client.ClientHelper.PlatformSqlMap.GetList("SelectOneStr", string.Format("select nr from pj_dyk where dx='供电所春秋查停电检修计划' and sx like '%{0}%' and nr!=''", "春查停电检修截止日期")); if (list.Count > 0) { Regex r1 = new Regex(@"[0-9]+(?=月)"); if (r1.Match(list[0].ToString()).Value != "") { endmonth = r1.Match(list[0].ToString()).Value; } r1 = new Regex(@"(?<=月)[0-9]+"); if (r1.Match(list[0].ToString()).Value != "") { endtday = r1.Match(list[0].ToString()).Value; } } string str = " where 1=1 and TDtime between '" + DateTime.Now.Year + "-" + startmonth + "-" + startday + " 00:00:00' and cast('" + DateTime.Now.Year + "-" + endmonth + "-" + endtday + " 23:59:59' as datetime) "; if (orgid != "") str += " and OrgCode='" + orgid + "' "; IList<PJ_cqctdjxjh> datalist = Client.ClientHelper.PlatformSqlMap.GetListByWhere<PJ_cqctdjxjh>( str ); ExportExcel(ex, datalist); ex.ShowExcel(); }
/// <summary> /// 文档格式预定义好的,只填写内容 /// </summary> /// <param name="obj"></param> public void ExportExcel(string orgid) { //lgm ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\设备标志缺失变更明细表二.xls"; ex.Open(fname); string filter = "where 1=1 "; if (orgid != "") filter += " and OrgCode='" + orgid + "'"; IList<PJ_sbbzqsbgmxb2> datalist = Client.ClientHelper.PlatformSqlMap.GetListByWhere<PJ_sbbzqsbgmxb2>( filter ); ExportExcel(ex, datalist, orgid); ex.ShowExcel(); }
/// <summary> /// 文档格式预定义好的,只填写内容 /// </summary> /// <param name="obj"></param> public static void ExportExcel(PJ_23 obj) { ExcelAccess ex = new ExcelAccess(); string fname = Application.StartupPath + "\\00记录模板\\23配电线路产权维护范围协议书.xls"; if (obj.BigData != null && obj.BigData.Length > 10) { fname = Path.GetTempPath() + "23配电线路产权维护范围协议书.xls"; //MemoryStream ms = new MemoryStream(obj.BigData); FileStream fs = new FileStream(fname, FileMode.OpenOrCreate); fs.Write(obj.BigData, 0, obj.BigData.Length); fs.Flush(); fs.Close(); } ex.Open(fname); ExportExcel(obj, ex); ex.ShowExcel(); }
/// <summary> /// 文档格式预定义好的,只填写内容 /// </summary> /// <param name="obj"></param> public void ExportExcel(string orgid) { //lgm ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\电压监测装置设置台帐.xls"; ex.Open(fname); IList<PJ_dyjczzsztz> datalist = Client.ClientHelper.PlatformSqlMap.GetListByWhere<PJ_dyjczzsztz>( " where OrgCode='" + orgid + "' order by id" ); ExportExcel(ex, datalist); ex.ShowExcel(); }
/// <summary> /// 根据入库单id,导出入库单 /// </summary> /// <param name="rkid"></param> internal static void ExportRK(string rkid) { ExcelAccess ea = new ExcelAccess(); string filename=AppDomain.CurrentDomain.BaseDirectory+"\\00记录模板\\.xls"; if (!File.Exists(filename)) { //导出资源文件到本机 Stream obj = typeof(PrintHelper).Assembly.GetManifestResourceStream("Ebada.Kcgl._00记录模板..xls"); object[] files = typeof(PrintHelper).Assembly.GetManifestResourceNames(); if (obj != null) { byte[] buff = new byte[obj.Length]; obj.Read(buff, 0, (int)obj.Length); FileStream fs = new FileStream(filename, FileMode.OpenOrCreate); fs.Write(buff, 0, buff.Length); fs.Flush(); fs.Close(); fs.Dispose(); } } ea.Open(filename); JH_yearks rkobj=Client.ClientHelper.TransportSqlMap.GetOneByKey<JH_yearks>(rkid); if(rkobj==null)return; int brow = 5; int bcol = 2; //填充数据 //for (int i = 0; i < list.Count; i++) { // var obj = list[i]; // ea.SetCellValue((i+1).ToString(), i + brow, bcol-1); // ea.SetCellValue(kcname, i + brow, bcol); // ea.SetCellValue(obj.供货厂家, i + brow, bcol + 1); // ea.SetCellValue(obj.材料名称, i + brow, bcol + 2); // ea.SetCellValue(obj.规格及型号, i + brow, bcol + 3); // ea.SetCellValue(obj.计量单位, i + brow, bcol + 4); // ea.SetCellValue(obj.数量.ToString(), i + brow, bcol + 5); // ea.SetCellValue(obj.备注, i + brow, bcol + 6); //} //显示文件 ea.Print(); ea.DisPoseExcel(); }
/// <summary> /// 文档格式预定义好的,只填写内容 /// </summary> /// <param name="obj"></param> public static void ExportExcel(PJ_24 jl) { ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\24设备变更通知书.xls"; ex.Open(fname); int row = 1; int col = 1; // ex.SetCellValue(jl.sj.Year.ToString(), row + 8, col); ex.SetCellValue(jl.sj.Month.ToString(), row + 8, col+2); ex.SetCellValue(jl.sj.Day.ToString(), row + 8, col+4); ex.SetCellValue(jl.dd, row + 5, col+6); ex.SetCellValue(jl.nr, row + 5, col + 7); ex.SetCellValue(jl.Remark, row + 5, col + 10); ex.ShowExcel(); }
/// <summary> /// 文档格式预定义好的,只填写内容 /// </summary> /// <param name="obj"></param> public void ExportExcelProjectCKD(string orgid, string strNum) { ////lgm ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\供电所安全工器具出库单.xls"; ex.Open(fname); string strfirst = ""; string filter = ""; string filter2 = ""; string filter3 = ""; string filter4 = ""; if (strNum != "全部") filter = " where 1=1 and num='" + strNum + "' and type = '所安全工器具出库单' "; else filter = " where 1=1 and type = '所安全工器具出库单' "; if (isWorkflowCall) { filter = filter + " and id not in (select ModleRecordID from WF_ModleRecordWorkTaskIns where WorkFlowId='" + WorkFlowData.Rows[0]["WorkFlowId"].ToString() + "') " + " or id in (select ModleRecordID from WF_ModleRecordWorkTaskIns where " + " RecordID='" + currRecord.ID + "') " ; } IList<PJ_anqgjcrkd> datalist = Client.ClientHelper.PlatformSqlMap.GetListByWhere<PJ_anqgjcrkd>( filter ); ExportExcel(ex, datalist); try { ex.DeleteSheet(1); } catch { } ex.ShowExcel(); }
/// <summary> /// 文档格式预定义好的,只填写内容 /// </summary> /// <param name="obj"></param> public void ExportExcel(string orgid) { //lgm ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\线路设备责任区划分明白表.xls"; ex.Open(fname); string sdtrorg=" "; if (orgid != "") { sdtrorg += " and OrgCode='" + orgid + "'"; } bool iszero = true; IList mclist = ClientHelper.PlatformSqlMap.GetList("SelectOneStr", "select distinct zrr from PJ_xlsbzrqhfmbb where 1=1 " + sdtrorg); foreach (string mc in mclist) { string str = " where 1=1 and zrr='"+mc+"' "; if (orgid != "") { str += " and OrgCode='" + orgid + "' "; } if (isWorkflowCall) { str = str + " and ( id in (select ModleRecordID from WF_ModleRecordWorkTaskIns where " + " RecordID='" + currRecord.ID + "')) " ; } IList<PJ_xlsbzrqhfmbb> datalist = Client.ClientHelper.PlatformSqlMap.GetListByWhere<PJ_xlsbzrqhfmbb>( str ); if (datalist.Count > 0) { iszero = false; ExportExcel(ex, datalist, mc); } } if (!iszero) ex.DeleteSheet(1); ex.ShowExcel(); }
public static bool Save(BarcodeSample sample, TestResult technic, TestResult reality, string saveFilename, string templateFile) { ExcelAccess access = new ExcelAccess(); access.Open(templateFile); access.IsVisibledExcel = true; access.FormCaption = "商品条码符号检测数据"; bool flag = false; access.SetCellText(2, "F", sample.SerialNumber); access.SetCellText(3, "F", sample.CustomerName); access.SetCellText(3, "Z", reality.BarcodeType); access.SetCellText(4, "F", sample.SampleName); access.SetCellText(4, "Z", sample.PrintFormat); access.SetCellText(6, "F", sample.CustomerContactPersoner); access.SetCellText(6, "N", sample.CustomerContactNumber); access.SetCellText(0x11, "J", "代办点" + sample.RegisterPoint); access.SetCellText(10, "J", technic.SymbolLevel); access.SetCellText(11, "J", technic.DecodingData); access.SetCellText(12, "J", "≥" + technic.LeftBlank); access.SetCellText(13, "J", "≥" + technic.RightBlank); access.SetCellText(14, "J", "≥" + technic.BarHeight.ToString()); access.SetCellText(15, "J", technic.SizeOfZ); access.SetCellText(0x10, "J", technic.IsValidBarcode); access.SetCellText(10, "V", reality.SymbolLevel); access.SetCellText(11, "V", reality.DecodingData); access.SetCellText(12, "V", reality.LeftBlank); access.SetCellText(13, "V", reality.RightBlank); access.SetCellText(14, "V", reality.BarHeight.ToString()); access.SetCellText(15, "V", reality.SizeOfZ.ToString()); access.SetCellText(0x10, "V", reality.IsValidBarcode); access.SetCellText(6, "Z", reality.TestDate.ToString("yyyyMMdd")); if (access.SaveAs(saveFilename, false)) { flag = true; } access.Close(); return(flag); }
public void ImportExcelMethodHandler(Object obj, ImportExcelArgs ev) { #region 实现... ExcelAccess excel = new ExcelAccess(); excel.Open(); excel.MergeCells(1, 1, 1, this._body.Cols); //合并单元格写标题,并设置字体 excel.SetFont(1, 1, 1, this._body.Cols, this._title.Font); excel.SetCellText(1, 1, 1, this._body.Cols, this._title.Text); //打印网格及网格线 excel.SetCellText((System.Data.DataTable) this.DataSource, 3, 1, true); System.Windows.Forms.FileDialog fileDlg = new System.Windows.Forms.SaveFileDialog(); fileDlg.AddExtension = true; fileDlg.DefaultExt = ".xls"; //fileDlg.InitialDirectory = System.IO.Directory.GetCurrentDirectory(); fileDlg.Title = "保存到Excel文件"; fileDlg.Filter = "Microsoft Office Excel 工作簿(*.xls)|*.xls|模板(*.xlt)|*.xlt"; if (fileDlg.ShowDialog() == System.Windows.Forms.DialogResult.OK) { if (excel.SaveAs(fileDlg.FileName, true)) { System.Windows.Forms.MessageBox.Show("数据成功保存到Excel文件!", "GoldPrinter", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information); } } fileDlg.Dispose(); excel.Close(); #endregion }
/// <summary> /// 文档格式预定义好的,只填写内容 /// </summary> /// <param name="obj"></param> public static void ExportExcel(PJ_25 obj) { ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\25双自备电源协议书.xls"; ex.Open(fname); //此处写填充内容代码 IList<PJ_25zbdymx> list = Client.ClientHelper.PlatformSqlMap.GetList<PJ_25zbdymx>("where ParentID='" + obj.ID + "'and Type='发电机'"); IList<PJ_25zbdymx> list1 = Client.ClientHelper.PlatformSqlMap.GetList<PJ_25zbdymx>("where ParentID='" + obj.ID + "'and Type='原动机'"); ex.SetCellValue("甲 方:"+obj.jf, 4, 1); ex.SetCellValue("乙 方:" + obj.cqdw, 5, 1); ex.SetCellValue(obj.qdrq.Year.ToString(), 42, 6); ex.SetCellValue(obj.qdrq.Month.ToString(), 42, 8); ex.SetCellValue(obj.qdrq.Day.ToString(), 42, 10); for (int i = 0; i < list.Count; i++) { ex.SetCellValue(list[i].xh, 26 + i, 1); ex.SetCellValue(list[i].gl.ToString() + "/" + list[i].ts.ToString(), 26 + i, 2); ex.SetCellValue(list[i].dy.ToString(), 26 + i, 3); ex.SetCellValue(list[i].azrq.ToString("yyyy-MM-dd"), 26 + i, 4); ex.SetCellValue(list[i].sccj, 26 + i, 5); } for (int i = 0; i < list1.Count; i++) { ex.SetCellValue(list1[i].xh, 26 + i, 8); ex.SetCellValue(list1[i].gl.ToString() + "/" + list[i].ts.ToString(), 26 + i, 11); ex.SetCellValue(list1[i].dy.ToString(), 26 + i, 12); ex.SetCellValue(list1[i].azrq.ToString("yyyy-MM-dd"), 26 + i, 13); ex.SetCellValue(list1[i].sccj, 26 + i, 14); } ex.SetCellValue(obj.bszz, 30, 2); ex.SetCellValue(obj.fzcs, 31, 2); ex.ShowExcel(); }
/// <summary> /// 文档格式预定义好的,只填写内容 /// </summary> /// <param name="obj"></param> public static void ExportExcel(PS_tqbyq obj) { //lgm //页数 int pagecount =1; ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\11配电变压器卡片.xls"; ex.Open(fname); //此处写填充内容代码 int row = 1; string strwhere1=" where byqID='"+obj.byqID+"'"; IList<PJ_11byqbd> pjbdlist = Client.ClientHelper.PlatformSqlMap.GetList<PJ_11byqbd>("SelectPJ_11byqbdList", strwhere1); IList<PJ_11byqdydl> pjdydllist = Client.ClientHelper.PlatformSqlMap.GetList<PJ_11byqdydl>("SelectPJ_11byqdydlList", strwhere1); IList<PJ_11byqdzcl> pjdzcllist = Client.ClientHelper.PlatformSqlMap.GetList<PJ_11byqdzcl>("SelectPJ_11byqdzclList", strwhere1); if (pjbdlist.Count == 0) { pjbdlist.Add(new PJ_11byqbd() { azrq = obj.byqInstallDate, azdd = obj.byqInstallAdress }); } //计算页数 int byqhdpage = Ecommon.GetPagecount(pjbdlist.Count, 3); if (byqhdpage > pagecount) { pagecount = byqhdpage; } int byqdypage = Ecommon.GetPagecount(pjdydllist.Count, 22); if (byqdypage > pagecount) { pagecount = byqdypage; } int byqdzpage = Ecommon.GetPagecount(pjdzcllist.Count, 9); if (byqdzpage > pagecount) { pagecount = byqdzpage; } //复制空模版 if (pagecount>1) { for (int i = 1; i < pagecount; i++) { ex.CopySheet(1, i); ex.ReNameWorkSheet(i + 1, "Sheet" + (i + 1)); } } PS_tq temptq = Client.ClientHelper.PlatformSqlMap.GetOneByKey<PS_tq>(obj.tqID); //固定内容 ex.ActiveSheet(1); //变压器内容 row = 4; ex.SetCellValue(obj.byqModle, row, 4); ex.SetCellValue(obj.byqFactory, row, 14); ex.SetCellValue(obj.byqVolOne + "KV", row, 23); row++; ex.SetCellValue(obj.byqPhase, row, 4); ex.SetCellValue(obj.byqNumber, row, 14); ex.SetCellValue(obj.byqVolTwo + "KV", row, 23); row++;//6 ex.SetCellValue(obj.byqCapcity.ToString(), row, 4); ex.SetCellValue(obj.byqMadeDate.Year.ToString(), row, 14); ex.SetCellValue(obj.byqMadeDate.Month.ToString(), row, 16); ex.SetCellValue(obj.byqMadeDate.Day.ToString(), row, 18); ex.SetCellValue(obj.byqCurrentOne.ToString(), row, 23); row += 2;//8 ex.SetCellValue(obj.byqLineGroup, row, 4); ex.SetCellValue(obj.byqCycle, row, 14); ex.SetCellValue(obj.byqCurrentTwo.ToString(), row, 23); //活动页 //标题 ex.SetCellValue("配电变压器卡片(" + temptq.tqName + ")", 2, 1); for (int k = 0; k < pagecount; k++) { ex.ActiveSheet(k + 1); //标题 ex.SetCellValue("配电变压器卡片(" + temptq.tqName + ")", 2, 1); //变压器变动内容 row = 12; for (int i = 0; i < 3; i++) { if (k * 3 + i >= pjbdlist.Count) { break; } PJ_11byqbd tempobj = pjbdlist[k * 3 + i]; ex.SetCellValue(tempobj.azrq.Year.ToString(), row + i, 1); ex.SetCellValue(tempobj.azrq.Month.ToString(), row + i, 3); ex.SetCellValue(tempobj.azrq.Day.ToString(), row + i, 5); ex.SetCellValue(tempobj.azdd, row + i, 7); if (tempobj.ccrq.Year != 1900) { ex.SetCellValue(tempobj.ccrq.Year.ToString(), row + i, 14); ex.SetCellValue(tempobj.ccrq.Month.ToString(), row + i, 16); ex.SetCellValue(tempobj.ccrq.Day.ToString(), row + i, 18); ex.SetCellValue(tempobj.ccyy, row + i, 20); } } //电压电流内容 row = 6; for (int j = 0; j < 22; j++) { if (k * 22 + j >= pjdydllist.Count) { break; } PJ_11byqdydl tempobj = pjdydllist[k * 22 + j]; ex.SetCellValue(tempobj.clrq.Year.ToString(), row + j, 26); ex.SetCellValue(tempobj.clrq.Month.ToString(), row + j, 28); ex.SetCellValue(tempobj.clrq.Day.ToString(), row + j, 30); ex.SetCellValue(tempobj.fjtwz, row + j, 32); ex.SetCellValue(tempobj.ao.ToString(), row + j, 33); ex.SetCellValue(tempobj.bo.ToString(), row + j, 34); ex.SetCellValue(tempobj.co.ToString(), row + j, 35); ex.SetCellValue(tempobj.a.ToString(), row + j, 36); ex.SetCellValue(tempobj.b.ToString(), row + j, 37); ex.SetCellValue(tempobj.c.ToString(), row + j, 38); ex.SetCellValue(tempobj.ao2.ToString(), row + j, 39); ex.SetCellValue(tempobj.bo2.ToString(), row + j, 40); ex.SetCellValue(tempobj.co2.ToString(), row + j, 41); } //绝缘电阻测量内容 row = 16; for (int l = 0; l < 9; l++) { if (k*9+l>=pjdzcllist.Count) { break; } if (l % 3 == 0 && l > 0) { row = 16 - l; } PJ_11byqdzcl tempobj = pjdzcllist[k * 9 + l]; if (l < 3) { ex.SetCellValue(tempobj.clrq.Year.ToString(), row + l, 7); ex.SetCellValue(tempobj.clrq.Month.ToString(), row + l, 10); ex.SetCellValue(tempobj.clrq.Day.ToString(), row + l, 12); ex.SetCellValue(tempobj.one2one.ToString(), row + l + 1, 7); ex.SetCellValue(tempobj.one2d.ToString(), row + l + 2, 7); ex.SetCellValue(tempobj.two2d.ToString(), row + l + 3, 7); row++; } else if (3 <= l && l < 6) { ex.SetCellValue(tempobj.clrq.Year.ToString(), row + l, 14); ex.SetCellValue(tempobj.clrq.Month.ToString(), row + l, 16); ex.SetCellValue(tempobj.clrq.Day.ToString(), row + l, 18); ex.SetCellValue(tempobj.one2one.ToString(), row + l + 1, 14); ex.SetCellValue(tempobj.one2d.ToString(), row + l + 2, 14); ex.SetCellValue(tempobj.two2d.ToString(), row + l + 3, 14); row++; } else if (6 <= l && l < 9) { ex.SetCellValue(tempobj.clrq.Year.ToString(), row + l, 20); ex.SetCellValue(tempobj.clrq.Month.ToString(), row + l, 22); ex.SetCellValue(tempobj.clrq.Day.ToString(), row + l, 24); ex.SetCellValue(tempobj.one2one.ToString(), row + l + 1, 20); ex.SetCellValue(tempobj.one2d.ToString(), row + l + 2, 20); ex.SetCellValue(tempobj.two2d.ToString(), row + l + 3, 20); row++; } } } //设第一工作表为当前工作表 ex.ActiveSheet(1); ex.ShowExcel(); }
private void btView_ItemClick_1(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (gridView1.FocusedRowHandle > -1) { PJ_24 OBJECT = gridView1.GetRow(gridView1.FocusedRowHandle) as PJ_24; if (OBJECT.BigData != null) { if (OBJECT.BigData.Length != 0) { DSOFramerControl ds1 = new DSOFramerControl(); ds1.FileData = OBJECT.BigData; string fname = ds1.FileName; ds1.FileClose(); // ds1.FileOpen(ds1.FileName); ExcelAccess ex = new ExcelAccess(); ex.Open(fname); //此处写填充内容代码 ex.ShowExcel(); } else { Export24.ExportExcel(OBJECT); } } else { Export24.ExportExcel(OBJECT); } } }
/// <summary> /// 文档格式预定义好的,只填写内容 /// </summary> /// <param name="obj"></param> public static void ExportExcel(IList<PJ_21gzbxdh> objlist) { ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\21电力故障电话接听记录.xls"; ex.Open(fname); //此处写填充内容代码 int rowcount = 7; //加页 int pageindex = 1; if (pageindex < Ecommon.GetPagecount(objlist.Count, 19)) { pageindex = Ecommon.GetPagecount(objlist.Count, 19); } for (int j = 1; j <= pageindex; j++) { if (j > 1) { ex.CopySheet(1, 1); } } ex.ShowExcel(); for (int j = 1; j <= pageindex; j++) { ex.ActiveSheet(j); ex.ReNameWorkSheet(j, "Sheet" + (j)); int prepageindex = j - 1; //主题 int starow = prepageindex * 19 + 1; int endrow = j * 19; if (objlist.Count > endrow) { for (int i = 0; i < 19; i++) { ex.SetCellValue(objlist[starow - 1 + i].rq.Month.ToString(), rowcount + i, 1); ex.SetCellValue(objlist[starow - 1 + i].rq.Day.ToString(), rowcount + i, 2); ex.SetCellValue(objlist[starow - 1 + i].rq.Hour.ToString(), rowcount + i, 3); ex.SetCellValue(objlist[starow - 1 + i].rq.Minute.ToString(), rowcount + i, 4); ex.SetCellValue(objlist[starow - 1 + i].lxfs, rowcount + i, 5); ex.SetCellValue(objlist[starow - 1 + i].yhdz, rowcount + i, 6); ex.SetCellValue(objlist[starow - 1 + i].gzjk, rowcount + i, 9); // ex.SetCellValue(objlist[starow - 1 + i].djr, rowcount + i,12); // ex.SetCellValue(objlist[starow - 1 + i].clr, rowcount + i, 13); } } else if (objlist.Count <= endrow && objlist.Count >= starow) { for (int i = 0; i < objlist.Count - starow + 1; i++) { ex.SetCellValue(objlist[starow - 1 + i].rq.Month.ToString(), rowcount + i, 1); ex.SetCellValue(objlist[starow - 1 + i].rq.Day.ToString(), rowcount + i, 2); ex.SetCellValue(objlist[starow - 1 + i].rq.Hour.ToString(), rowcount + i, 3); ex.SetCellValue(objlist[starow - 1 + i].rq.Minute.ToString(), rowcount + i, 4); ex.SetCellValue(objlist[starow - 1 + i].lxfs, rowcount + i, 5); ex.SetCellValue(objlist[starow - 1 + i].yhdz, rowcount + i, 6); ex.SetCellValue(objlist[starow - 1 + i].gzjk, rowcount + i, 9); // ex.SetCellValue(objlist[starow - 1 + i].djr, rowcount + i, 12); // ex.SetCellValue(objlist[starow - 1 + i].clr, rowcount + i, 13); } } } ex.ActiveSheet(1); string orgname=""; if (objlist.Count>0) { orgname = objlist[0].OrgName; } //变电所内容 ex.SetCellValue(orgname, 4, 5); //记录 //for (int i = 0; i < objlist.Count;i++ ) //{ // ex.SetCellValue(objlist[i].rq.Month.ToString(), rowcount + i, 1); // ex.SetCellValue(objlist[i].rq.Day.ToString(), rowcount + i, 2); // ex.SetCellValue(objlist[i].rq.Hour.ToString(), rowcount + i, 3); // ex.SetCellValue(objlist[i].rq.Minute.ToString(), rowcount + i, 4); // ex.SetCellValue(objlist[i].lxfs, rowcount + i, 5); // ex.SetCellValue(objlist[i].yhdz, rowcount + i, 6); // ex.SetCellValue(objlist[i].gzjk, rowcount + i, 7); // ex.SetCellValue(objlist[i].djr, rowcount + i,8); // ex.SetCellValue(objlist[i].clr, rowcount + i,9); //} ex.ShowExcel(); }
/// <summary> /// 文档格式预定义好的,只填写内容 /// </summary> /// <param name="obj"></param> public static void ExportExcel(IList<sdjl_07jdzz> objlist) { ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\送电08接地装置检测.xls"; ex.Open(fname); //此处写填充内容代码 int rowcount = 6; //加页 int pageindex = 1; if (pageindex < Ecommon.GetPagecount(objlist.Count, 16)) { pageindex = Ecommon.GetPagecount(objlist.Count, 16); } for (int j = 1; j <= pageindex; j++) { ex.SetCellValue(objlist[0].LineName, 4, 3); if (j > 1) { ex.CopySheet(1, 1); } } for (int j = 1; j <= pageindex; j++) { ex.ActiveSheet(j); ex.ReNameWorkSheet(j, "Sheet" + (j)); int prepageindex = j - 1; //主题 int starow = prepageindex * 16 + 1; int endrow = j * 16; if (objlist.Count > endrow) { for (int i = 0; i < 16; i++) { ex.SetCellValue(objlist[starow - 1 + i].gth, rowcount + 1 + i, 1); ex.SetCellValue(objlist[starow - 1 + i].gzwz, rowcount + 1 + i, 2); ex.SetCellValue(objlist[starow - 1 + i].sbmc, rowcount + 1 + i, 3); ex.SetCellValue(objlist[starow - 1 + i].jddz.ToString(), rowcount + 1 + i, 4); ex.SetCellValue(objlist[starow - 1 + i].CreateDate.Year.ToString(), rowcount + 1 + i, 5); ex.SetCellValue(objlist[starow - 1 + i].CreateDate.Month.ToString(), rowcount + 1 + i, 6); ex.SetCellValue(objlist[starow - 1 + i].CreateDate.Day.ToString(), rowcount + 1 + i, 7); ex.SetCellValue(objlist[starow - 1 + i].trdzr.ToString(), rowcount + 1 + i, 8); ex.SetCellValue(objlist[starow - 1 + i].tz.ToString(), rowcount + 1 + i, 9); ex.SetCellValue(objlist[starow - 1 + i].xhgg, rowcount + 1 + i, 10); ex.SetCellValue(objlist[starow - 1 + i].fzxl, rowcount + 1 + i, 11); ex.SetCellValue(objlist[starow - 1 + i].CreateMan, rowcount + 1 + i, 12); } } else if (objlist.Count <= endrow && objlist.Count >= starow) { for (int i = 0; i < objlist.Count - starow + 1; i++) { ex.SetCellValue(objlist[starow - 1 + i].gth, rowcount + 1 + i, 1); ex.SetCellValue(objlist[starow - 1 + i].gzwz, rowcount + 1 + i, 2); ex.SetCellValue(objlist[starow - 1 + i].sbmc, rowcount + 1 + i, 3); ex.SetCellValue(objlist[starow - 1 + i].jddz.ToString(), rowcount + 1 + i, 4); ex.SetCellValue(objlist[starow - 1 + i].CreateDate.Year.ToString(), rowcount + 1 + i, 5); ex.SetCellValue(objlist[starow - 1 + i].CreateDate.Month.ToString(), rowcount + 1 + i, 6); ex.SetCellValue(objlist[starow - 1 + i].CreateDate.Day.ToString(), rowcount + 1 + i, 7); ex.SetCellValue(objlist[starow - 1 + i].trdzr.ToString(), rowcount + 1 + i, 8); ex.SetCellValue(objlist[starow - 1 + i].tz.ToString(), rowcount + 1 + i, 9); ex.SetCellValue(objlist[starow - 1 + i].xhgg, rowcount + 1 + i, 10); ex.SetCellValue(objlist[starow - 1 + i].fzxl, rowcount + 1 + i, 11); ex.SetCellValue(objlist[starow - 1 + i].CreateMan, rowcount + 1 + i, 12); //ex.SetCellValue(objlist[starow - 1 + i].Remark, rowcount + i, 10); } } } ex.ActiveSheet(1); ex.ShowExcel(); }
/// <summary> /// 文档格式预定义好的,动态填写内容 /// </summary> /// <param name="obj"></param> public static void ExportExceldt(string obj) { ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\10配电变压器汇总表.xls"; ex.Open(fname ); IList list=new ArrayList (); int pagecount=0; //obj = "317"; string strfilter = " and 1=1"; if (obj != "") strfilter = strfilter + " and a.OrgCode='" + obj+"' "; IList caplist = Client.ClientHelper.PlatformSqlMap.GetList("SelectOneInt", "select distinct b.byqCapcity from dbo.mOrg a,dbo.PS_tqbyq b,dbo.PS_xl c, dbo.PS_tq d where a.OrgCode=c.OrgCode and c.LineCode=d.xlCode and d.tqID=b.tqID " + strfilter + " order by b.byqCapcity"); //caplist = Client.ClientHelper.PlatformSqlMap.GetList("SelectOneStr", string.Format("select nr from pj_dyk where len(parentid)>1 and dx='{0}' and sx='{1}'", "11配电变压器卡片", "容量")); //IList modmflist = Client.ClientHelper.PlatformSqlMap.GetList("SelectOneStr", "select distinct UPPER(replace(b.byqModle,'-'+cast(b.byqCapcity as nvarchar(50))+'/'+cast(b.byqVol as nvarchar(50)),'')) from dbo.mOrg a,dbo.PS_tqbyq b,dbo.PS_xl c, dbo.PS_tq d where a.OrgCode=c.OrgCode and c.LineCode=d.xlCode and d.tqID=b.tqID " + strfilter + " and b.omniseal='true'"); //IList modtmlist = Client.ClientHelper.PlatformSqlMap.GetList("SelectOneStr", "select distinct UPPER(replace(b.byqModle,'-'+cast(b.byqCapcity as nvarchar(50))+'/'+cast(b.byqVol as nvarchar(50)),'')) from dbo.mOrg a,dbo.PS_tqbyq b,dbo.PS_xl c, dbo.PS_tq d where a.OrgCode=c.OrgCode and c.LineCode=d.xlCode and d.tqID=b.tqID " + strfilter + " and (b.omniseal!='true' or b.omniseal is null)"); IList modmflist = Client.ClientHelper.PlatformSqlMap.GetList("SelectOneStr", "select distinct UPPER(b.byqModle) from dbo.mOrg a,dbo.PS_tqbyq b,dbo.PS_xl c, dbo.PS_tq d where a.OrgCode=c.OrgCode and c.LineCode=d.xlCode and d.tqID=b.tqID " + strfilter + " and b.omniseal='true'"); IList modtmlist = Client.ClientHelper.PlatformSqlMap.GetList("SelectOneStr", "select distinct UPPER(b.byqModle) from dbo.mOrg a,dbo.PS_tqbyq b,dbo.PS_xl c, dbo.PS_tq d where a.OrgCode=c.OrgCode and c.LineCode=d.xlCode and d.tqID=b.tqID " + strfilter + " and (b.omniseal!='true' or b.omniseal is null)"); int jmax = 18; int i = 0; for ( i = 0; i < modmflist.Count; i++) { if (modmflist[i].ToString().IndexOf("-")>-1) { modmflist[i] = modmflist[i].ToString().Substring(0,modmflist[i].ToString().IndexOf("-")); } } for (i = 0; i < modtmlist.Count; i++) { if (modtmlist[i].ToString().IndexOf("-")>-1) { modtmlist[i] = modtmlist[i].ToString().Substring(0, modtmlist[i].ToString().IndexOf("-")); } } string modtemp = ""; for (i = 0; i < modmflist.Count; i++) { if (modtemp.IndexOf(modmflist[i].ToString())==-1) { if (modtemp!="") modtemp+=","+modmflist[i]; else modtemp = modmflist[i].ToString(); } } if (modtemp != "") { string[] strli = modtemp.Split(','); modmflist.Clear(); for (i = 0; i < strli.Length; i++) { modmflist.Add(strli[i]); } } for (i = 0; i < modtmlist.Count; i++) { if (modtemp.IndexOf(modtmlist[i].ToString()) == -1) { if (modtemp!="") modtemp += "," + modtmlist[i]; else modtemp = modtmlist[i].ToString(); } } if (modtemp != "") { string[] strli = modtemp.Split(','); modtmlist.Clear(); for (i = 0; i < strli.Length; i++) { modtmlist.Add(strli[i]); } } pagecount = (int)Math.Ceiling(caplist.Count / (jmax + 0.0)); int itemp = modtmlist.Count / 6.0 > modmflist.Count / 3.0 ? (int)Math.Ceiling(modtmlist.Count / 6.0) : (int)Math.Ceiling(modmflist.Count / 3.0 ); pagecount = itemp * pagecount; if (pagecount > 1) { ex.DeleteWorkSheet("Sheet2"); ex.DeleteWorkSheet("Sheet3"); } /////计算需要多少个工作表 for (i = 1; i < pagecount; i++) { ex.CopySheet(1,i); ex.ReNameWorkSheet((i + 1), "Sheet" + (i + 1)); } int istart = 7, istart2 = 19, jstart = 4, j=0; string jstrfilter=""; mOrg org = Client.ClientHelper.PlatformSqlMap.GetOneByKey<mOrg>(obj); for ( j = 0; j < caplist.Count; j++) { ex.ActiveSheet("Sheet" + (j / jmax == 0 ? 1 : (int)Math.Ceiling(j / (jmax + 0.0)))); //ex.ActiveSheet("Sheet" + (1 + (j / jmax) * (int)Math.Ceiling(j / (jmax + 0.0)))); if (j % jmax == 0) { jstrfilter = " and 1=1"; ex.ActiveSheet("Sheet" + (1+(j / jmax)*(int)Math.Ceiling(j / (jmax + 0.0)))); list = Client.ClientHelper.PlatformSqlMap.GetList("SelectOneInt", "select b.byqCapcity from dbo.mOrg a,dbo.PS_tqbyq b,dbo.PS_xl c, dbo.PS_tq d where a.OrgCode=c.OrgCode and c.LineCode=d.xlCode and d.tqID=b.tqID " + strfilter + jstrfilter); if (list.Count >0) ex.SetCellValue(list.Count.ToString(), 5, jstart + j % jmax); list = Client.ClientHelper.PlatformSqlMap.GetList("SelectOneInt", "select sum(b.byqCapcity) from dbo.mOrg a,dbo.PS_tqbyq b,dbo.PS_xl c, dbo.PS_tq d where a.OrgCode=c.OrgCode and c.LineCode=d.xlCode and d.tqID=b.tqID " + strfilter + jstrfilter); //if (list[0] == null) list[0] = 0; if (list[0] != null) ex.SetCellValue(list[0].ToString(), 6, jstart + j % jmax); setExceldt(ex, list, caplist, modtmlist, modmflist, jstrfilter, strfilter, jstart, j, jmax, istart, istart2); } ex.ActiveSheet("Sheet" + ((j+1) / jmax == 0 ? 1 : (int)Math.Ceiling((j+1) / (jmax + 0.0)))); jstrfilter = " and 1=1 and b.byqCapcity='" + caplist[j] + "'"; //ex.SetCellValue(caplist[j].ToString(), 4, jstart + j % jmax + 1); setExceldt(ex, list, caplist, modtmlist, modmflist, jstrfilter, strfilter, jstart+1, j, jmax, istart, istart2); } for (i = 0; i < pagecount; i++) { ex.ActiveSheet("Sheet" + (i+1)); int jzu=caplist.Count/jmax+1; int itempmin = 0, itempmax = 0; itempmax = (i % jzu+1) * jmax; itempmin = (i % jzu) * jmax; if (org != null) ex.SetCellValue(org.OrgName, 3, 3); else ex.SetCellValue("全局", 3, 3); for (j = itempmin; j < itempmax && j < caplist.Count ; j++) { ex.SetCellValue(caplist[j].ToString(), 4, jstart + j % jmax + 1); } //ex.SetCellValue(caplist[j].ToString(), 4, jstart + j % jmax + 1); } ex.ActiveSheet(1); ex.ShowExcel(); }