protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Bind_basic(); if (id != 0)//修改 { Button3.Text = "确认修改"; Button4.Enabled = true; try { GroupCommunicationWork gcw = GroupCommunicationWork.FindById(id); ddl_CommunicationType.SelectedValue = gcw.CommunicationTypeId.ToString(); tb_GroupArea.Text = gcw.GroupArea; tb_GroupName.Text = gcw.GroupName; tb_GroupMonitor.Text = gcw.GroupMonitor; tb_GroupMembers.Value = gcw.GroupMembers; tb_CommunicationGenerate.Value = gcw.CommunicationGenerate; tb_CommunicationSummarize.Value = gcw.CommunicationSummarize; tb_CommunicationReport.Value = gcw.CommunicationReport; tb_CommunicationPhotos.Value = gcw.CommunicationPhotos; } catch (Exception ex) { text(ex.ToString()); Page.ClientScript.RegisterStartupScript(this.GetType(), "alter", "alert('数据加载错误,请重新再试!')", true); } } } }
public static string DeleteGroupCommunication(int groupCommunicationId) { try { DbEntry.UsingTransaction(delegate { GroupCommunicationWork communication = GroupCommunicationWork.FindById(groupCommunicationId); communication.IsDelete = true; communication.Save(); }); } catch { return("false"); } return("ok"); }
public static bool UpdateGroupCommunication(int groupCommunicationId, int communicationTypeId, string groupArea, string groupName, string groupMonitor, string groupMembers, string communicationGenerate, string communicationSummarize, string communicationReport, string communicationPhotos) { try { GroupCommunicationWork gcw = GroupCommunicationWork.FindById(groupCommunicationId); gcw.CommunicationTypeId = communicationTypeId; gcw.GroupArea = groupArea; gcw.GroupName = groupName; gcw.GroupMonitor = groupMonitor; gcw.GroupMembers = groupMembers; gcw.CommunicationGenerate = communicationGenerate; gcw.CommunicationSummarize = communicationSummarize; gcw.CommunicationReport = communicationReport; gcw.CommunicationPhotos = communicationPhotos; gcw.Save(); } catch { return(false); } return(true); }
public static bool AddGroupCommunication(int communicationTypeId, string groupArea, string groupName, string groupMonitor, string groupMembers, string communicationGenerate, string communicationSummarize, string communicationReport, string communicationPhotos) { try { DbEntry.UsingTransaction(delegate { GroupCommunicationWork gcw = new GroupCommunicationWork(); gcw.CommunicationTypeId = communicationTypeId; gcw.GroupArea = groupArea; gcw.GroupName = groupName; gcw.GroupMonitor = groupMonitor; gcw.GroupMembers = groupMembers; gcw.CommunicationGenerate = communicationGenerate; gcw.CommunicationSummarize = communicationSummarize; gcw.CommunicationReport = communicationReport; gcw.CommunicationPhotos = communicationPhotos; gcw.IsDelete = false; gcw.Save(); }); } catch { return(false); } return(true); }
public void Output_Word_zdts() { try { if (id == 0) { //ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "alter", "alert('数据加载错误,请重新再试!')", true); Page.ClientScript.RegisterStartupScript(this.GetType(), "alter", "alert('数据加载错误,请重新再试!')", true); return; } GroupCommunicationWork gcw = GroupCommunicationWork.FindById(id); string basePath = Server.MapPath("../../"); object missing = Type.Missing; object filePath = basePath + "Template/团组交流工作情况表.doc"; var docApp = new Microsoft.Office.Interop.Word.Application(); docApp.Visible = false; //打开Word文件 var doc = docApp.Documents.Open(ref filePath, false, false, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing); object oFalse = false; object oTrue = true; object oMissing = System.Reflection.Missing.Value; //交流形式 doc.Bookmarks["CommunicationTypeText"].Range.Text = CommunicationType.FindOne(CK.K["CommunicationTypeId"] == gcw.CommunicationTypeId).CommunicationTypeText; //组团地区 doc.Bookmarks["GroupArea"].Range.Text = gcw.GroupArea == null ? "" : gcw.GroupArea; //交流团组名称 doc.Bookmarks["GroupName"].Range.Text = gcw.GroupName == null ? "" : gcw.GroupName; //交流团团长 doc.Bookmarks["GroupMonitor"].Range.Text = gcw.GroupMonitor == null ? "" : gcw.GroupMonitor; //团组成员名称 if (gcw.GroupMembers != null) { doc.Bookmarks["GroupMembers"].Range.InsertFile(GenerateHtml(gcw.GroupMembers), ref oMissing, ref oFalse, ref oTrue, ref oFalse); } //交流形成 if (gcw.CommunicationGenerate != null) { doc.Bookmarks["CommunicationGenerate"].Range.InsertFile(GenerateHtml(gcw.CommunicationGenerate), ref oMissing, ref oFalse, ref oTrue, ref oFalse); } //交流工作总结 if (gcw.CommunicationSummarize != null) { doc.Bookmarks["CommunicationSummarize"].Range.InsertFile(GenerateHtml(gcw.CommunicationSummarize), ref oMissing, ref oFalse, ref oTrue, ref oFalse); } //专项工作报告 if (gcw.CommunicationReport != null) { doc.Bookmarks["CommunicationReport"].Range.InsertFile(GenerateHtml(gcw.CommunicationReport), ref oMissing, ref oFalse, ref oTrue, ref oFalse); } //交流照片 if (gcw.CommunicationPhotos != null) { doc.Bookmarks["CommunicationPhotos"].Range.InsertFile(GenerateHtml(gcw.CommunicationPhotos), ref oMissing, ref oFalse, ref oTrue, ref oFalse); } string fileNameWithOutExtention = Guid.NewGuid().ToString(); doc.SaveAs(basePath + "upload/word_tzjlgz/" + fileNameWithOutExtention + ".pdf", Microsoft.Office.Interop.Word.WdSaveFormat.wdFormatPDF); object f = false; doc.Close(ref f, ref missing, ref missing); FileStream fs = new FileStream(basePath + "upload/word_tzjlgz/" + fileNameWithOutExtention + ".pdf", FileMode.Open); byte[] file = new byte[fs.Length]; fs.Read(file, 0, file.Length); fs.Close(); Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("团组交流工作情况表-" + gcw.GroupName + ".pdf", System.Text.Encoding.UTF8)); Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8"); Response.ContentType = "application/octet-stream"; Response.BinaryWrite(file); Response.End(); } catch (Exception ex) { Page.ClientScript.RegisterStartupScript(this.GetType(), "alter", "alert('数据加载错误,请重新再试!')", true); text(ex.ToString()); //ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "alter", "alert('数据加载失败,请重新再试!')", true); return; } }