/// <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(); }
/// <summary> /// 文档格式预定义好的,只填写内容 /// </summary> /// <param name="obj"></param> public void ExportExcelProjectCKD(string orgid, string strProject, string strfenProject) { ////lgm ExcelAccess ex = new ExcelAccess(); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); string fname = Application.StartupPath + "\\00记录模板\\出库单.xls"; ex.Open(fname); bool isadd = false; string strfirst = ""; string filter = ""; string filter2 = ""; string filter3 = ""; string filter4 = ""; if (strProject != "全部") filter2 = " where 1=1 and ssgc='" + strProject + "' and type = '撤旧材料出库单' "; else filter2 = " where 1=1 and type = '撤旧材料出库单' "; IList mclist = ClientHelper.PlatformSqlMap.GetList("SelectOneStr", "select distinct ssgc from PJ_clcrkd " + filter2 + " order by ssgc"); foreach (string mc in mclist) { if (strfenProject == "全部") filter3 = " where 1=1 and type = '撤旧材料出库单' "; else filter3 = " where ssxm='" + strfenProject + "' and type = '撤旧材料出库单' "; IList xmlist = ClientHelper.PlatformSqlMap.GetList("SelectOneStr", "select distinct ssxm from PJ_clcrkd " + filter3 + " order by ssxm"); foreach (string xm in xmlist) { filter4 = " where 1=1 and type = '撤旧材料出库单'" + " and ssgc='" + mc + "' " + " and ssxm='" + xm + "' "; //IList sjlist = ClientHelper.PlatformSqlMap.GetList("SelectOneStr", "select distinct CONVERT(varchar(50) ,indate, 112 ) from PJ_clcrkd " + filter4 + " "); IList sjlist = ClientHelper.PlatformSqlMap.GetList("SelectOneStr", "select distinct num from PJ_clcrkd " + filter4 + " "); foreach (string sj in sjlist) { filter = " where 1=1 and type = '撤旧材料出库单'" + " and ssgc='" + mc + "' " + " and ssxm='" + xm + "' and num= '" + sj + "' "; 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_clcrkd> datalist = Client.ClientHelper.PlatformSqlMap.GetListByWhere<PJ_clcrkd>( filter ); if (datalist.Count > 0) isadd = true; ExportExcel(ex, datalist); } } } if (isadd) ex.DeleteSheet(1); ex.ShowExcel(); }
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 filter = ""; 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 void ExportExcelSubmit(ref LP_Temple parentTemple, string orgid, bool isShow) { DSOFramerControl dsoFramerWordControl1 = new DSOFramerControl(); string fname = Application.StartupPath + "\\00记录模板\\线路设备责任区划分明白表.xls"; dsoFramerWordControl1.FileOpen(fname); if (parentTemple == null) { parentTemple = new LP_Temple(); parentTemple.Status = "文档生成"; } parentTemple.DocContent = dsoFramerWordControl1.FileDataGzip; dsoFramerWordControl1.FileSave(); dsoFramerWordControl1.FileClose(); dsoFramerWordControl1.FileDataGzip = parentTemple.DocContent; ExcelAccess ex = new ExcelAccess(); Microsoft.Office.Interop.Excel.Workbook wb = dsoFramerWordControl1.AxFramerControl.ActiveDocument as Microsoft.Office.Interop.Excel.Workbook; ex.MyWorkBook = wb; ex.MyExcel = wb.Application; string filter = ""; int i = 0; string sdtrorg = " "; if (orgid != "") { sdtrorg += " and OrgCode='" + orgid + "'"; } IList mclist = ClientHelper.PlatformSqlMap.GetList("SelectOneStr", "select distinct zrr from PJ_xlsbzrqhfmbb where 1=1 " + sdtrorg); List<WF_ModleRecordWorkTaskIns> mrwtlist = new List<WF_ModleRecordWorkTaskIns>(); foreach (string mc in mclist) { filter = " where 1=1 and zrr='" + mc + "' "; if (orgid != "") filter = " and OrgCode='" + orgid + "'"; if (isWorkflowCall) { filter = filter + " and (id not in (select ModleRecordID from WF_ModleRecordWorkTaskIns where WorkFlowInsId='" + WorkFlowData.Rows[0]["WorkFlowInsId"].ToString() + "') " + " or id in (select ModleRecordID from WF_ModleRecordWorkTaskIns where " + " RecordID='" + currRecord.ID + "')) " ; } IList<PJ_xlsbzrqhfmbb> datalist = Client.ClientHelper.PlatformSqlMap.GetListByWhere<PJ_xlsbzrqhfmbb>( filter ); ExportExcel(ex, datalist,mc); } ex.DeleteSheet(1); if (parentTemple == null) { parentTemple = new LP_Temple(); parentTemple.Status = "文档生成"; } dsoFramerWordControl1.FileSave(); parentTemple.DocContent = dsoFramerWordControl1.FileDataGzip; dsoFramerWordControl1.FileSave(); dsoFramerWordControl1.FileClose(); }
public void ExportExcelProjectCKD(string orgid, string strProject, string strfenProject) { ////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 (strProject != "全部") filter2 = " where 1=1 and ssgc='" + strProject + "' "; else filter2 = " where 1=1 "; IList mclist = ClientHelper.PlatformSqlMap.GetList("SelectOneStr", "select distinct ssgc from PJ_wgclrkysd " + filter2 + " order by ssgc"); foreach (string mc in mclist) { if (strfenProject == "全部") filter3 = " where 1=1 "; else filter3 = " where ssxm='" + strfenProject + "' "; IList xmlist = ClientHelper.PlatformSqlMap.GetList("SelectOneStr", "select distinct ssxm from PJ_wgclrkysd " + filter3 + " order by ssxm"); foreach (string xm in xmlist) { filter4 = " where 1=1" + " and ssgc='" + mc + "' " +" and ssxm='" + xm + "' "; IList sjlist = ClientHelper.PlatformSqlMap.GetList("SelectOneStr", "select distinct dhht from PJ_wgclrkysd " + filter4 + " "); foreach (string sj in sjlist) { filter = " where 1=1" + " and ssgc='" + mc + "' " + " and ssxm='" + xm + "' and dhht='" + sj + "' "; 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_wgclrkysd> datalist = Client.ClientHelper.PlatformSqlMap.GetListByWhere<PJ_wgclrkysd>( filter ); ExportExcel(ex, datalist); } } } try { ex.DeleteSheet(1); } catch { } ex.ShowExcel(); }