public string RenderAccounts(TransitAccount[] accounts) { HtmlTable table = new HtmlTable(); table.Border = 0; table.BorderColor = "White"; HtmlTableRow row = new HtmlTableRow(); table.Rows.Add(row); foreach (TransitAccount ta in accounts) { HtmlTableCell cell = new HtmlTableCell(); cell.Controls.Add(new LiteralControl(string.Format( "<div><a href='AccountView.aspx?id={0}'>" + "<img border=0 style='width: 50%;' src='AccountPictureThumbnail.aspx?id={1}'></a></div>" + "<div class=sncore_link><a href='AccountView.aspx?id={0}'>{2}</a>", ta.Id, ta.PictureId, Render(ta.Name)))); row.Cells.Add(cell); if (row.Cells.Count % 4 == 0) { row = new HtmlTableRow(); table.Rows.Add(row); } } StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); table.RenderControl(new HtmlTextWriter(sw)); return(sb.ToString()); }
/// <summary> /// Render this control to the output parameter specified. /// </summary> /// <param name="output"> The HTML writer to write out to </param> protected override void RenderContents(HtmlTextWriter output) { //Show all the messages in the ENTValidationErrorsAL //Check if there are an items in the array list if (ValidationErrors.Count != 0) { //There are items so create a table with the list of messages. var table = new HtmlTable(); var trHeader = new HtmlTableRow(); var tcHeader = new HtmlTableCell(); tcHeader.InnerText = "Please review the following issues:"; tcHeader.Attributes.Add("class", "validatioErrorMessageHeader"); trHeader.Cells.Add(tcHeader); table.Rows.Add(trHeader); foreach (var ve in ValidationErrors) { var tr = new HtmlTableRow(); var tc = new HtmlTableCell(); tc.InnerText = ve.ErrorMessage; tc.Attributes.Add("class", "validationErrorMessage"); tr.Cells.Add(tc); table.Rows.Add(tr); } table.RenderControl(output); } else { //Write nothing. output.Write(""); } }
public static string ToHtml(this Dictionary <string, string> dic, string title) { using (MetricTracker.Track(MethodBase.GetCurrentMethod())) { var table = new HtmlTable(); var html = string.Format(Constants.TitleFormat, title); var flag = false; var isFirstItem = true; foreach (var item in dic) { table.Rows.Add(new HtmlTableRow { Cells = { new HtmlTableCell { InnerHtml = item.Key }, new HtmlTableCell{ InnerHtml = item.Value } }, BgColor = isFirstItem ? Constants.HeaderColor : (flag ? Constants.Grey : Constants.White) }); isFirstItem = false; flag = !flag; } using (var sw = new StringWriter()) { table.RenderControl(new HtmlTextWriter(sw)); html += sw.ToString(); } return(html); } }
public static MvcHtmlString CheckBoxList(this HtmlHelper helper, IDictionary <string, int> items, IList <int> selectedCheckBoxes, CheckBoxListSettings settings) { var htmlTable = new HtmlTable(); var tempTableRow = new HtmlTableRow(); foreach (var item in items) { if (tempTableRow.Cells.Count >= ((int)settings.CblRepeatColumns)) { htmlTable.Rows.Add(tempTableRow); tempTableRow = new HtmlTableRow(); } var tableCell = GetCompleteHtmlTableCell(item, settings, selectedCheckBoxes); tempTableRow.Cells.Add(tableCell); } if (tempTableRow.Cells.Count > 0) { htmlTable.Rows.Add(tempTableRow); } string result; using (var sw = new StringWriter()) { htmlTable.RenderControl(new HtmlTextWriter(sw)); result = sw.ToString(); } return(new MvcHtmlString(result)); }
public string RenderAccounts(TransitAccount[] accounts) { HtmlTable table = new HtmlTable(); table.Border = 0; table.BorderColor = "White"; HtmlTableRow row = new HtmlTableRow(); table.Rows.Add(row); foreach (TransitAccount ta in accounts) { HtmlTableCell cell = new HtmlTableCell(); cell.Controls.Add(new LiteralControl(string.Format( "<div><a href='AccountView.aspx?id={0}'>" + "<img border=0 style='width: 50%;' src='AccountPictureThumbnail.aspx?id={1}'></a></div>" + "<div class=sncore_link><a href='AccountView.aspx?id={0}'>{2}</a>", ta.Id, ta.PictureId, Render(ta.Name)))); row.Cells.Add(cell); if (row.Cells.Count % 4 == 0) { row = new HtmlTableRow(); table.Rows.Add(row); } } StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); table.RenderControl(new HtmlTextWriter(sw)); return sb.ToString(); }
private static MvcHtmlString WriteToHtml(HtmlTable table) { var sw = new StringWriter(new StringBuilder()); var htw = new HtmlTextWriter(sw); table.RenderControl(htw); return(new MvcHtmlString(sw.ToString())); }
private void RenderWebPartWithElevatedPermissions(HtmlTextWriter output) { var wp = WebPartManager.GetCurrentWebPartManager(Page); if (wp != null && ((String.IsNullOrEmpty(PropChartSelectedList.Trim()) && wp.DisplayMode.Name == "Design") || (PropChartSelectedList.Trim() == "<Select List>" && wp.DisplayMode.Name == "Browse"))) { ConfigureChartVerbiageLiteral.RenderControl(output); } else { MainTable.RenderControl(output); } }
public static String RenderTable(HtmlTable tbl) { String strRet; StringBuilder sb = new StringBuilder( ); StringWriter sw = new StringWriter(sb); HtmlTextWriter htw = new HtmlTextWriter(sw); tbl.RenderControl(htw); strRet = sb.ToString( ); strRet += "<br><br>"; return(strRet); }
private string ComposeUpdateTable(List <AssignedExerciseViewModal> tableData, string name) { var table = new HtmlTable(); var mailMessage = new StringBuilder(); string html; string leadingText = "<p>Hi, " + name + ". There has been an update in your exerises. Look below or vist https://asclepiusdis.azurewebsites.net/ </p>"; string htmlTableStart = "<table style=\"border-collapse:collapse; text-align:center;\" >"; string htmlTableEnd = "</table>"; string htmlHeaderRowStart = "<tr style =\"background-color:#6FA1D2; color:#ffffff;\">"; string htmlHeaderRowEnd = "</tr>"; string htmlTrStart = "<tr style =\"color:#555555;\">"; string htmlTrEnd = "</tr>"; string htmlTdStart = "<td style=\" border-color:#5c87b2; border-style:solid; border-width:thin; padding: 5px;\">"; string htmlTdEnd = "</td>"; mailMessage.AppendFormat(leadingText); mailMessage.AppendFormat(htmlTableStart); mailMessage.AppendFormat(htmlHeaderRowStart); mailMessage.AppendFormat(htmlTdStart + "Name " + htmlTdEnd); mailMessage.AppendFormat(htmlTdStart + "Description " + htmlTdEnd); mailMessage.AppendFormat(htmlTdStart + "Type " + htmlTdEnd); mailMessage.AppendFormat(htmlTdStart + "Sets " + htmlTdEnd); mailMessage.AppendFormat(htmlTdStart + "Repetitions " + htmlTdEnd); mailMessage.AppendFormat(htmlHeaderRowEnd); foreach (var tableRow in tableData) { mailMessage.AppendFormat(htmlTrStart); mailMessage.AppendFormat(htmlTdStart + tableRow.Name + htmlTdEnd); mailMessage.AppendFormat(htmlTdStart + tableRow.Description + htmlTdEnd); mailMessage.AppendFormat(htmlTdStart + tableRow.Type + htmlTdEnd); mailMessage.AppendFormat(htmlTdStart + tableRow.Sets.ToString() + htmlTdEnd); mailMessage.AppendFormat(htmlTdStart + tableRow.Repetitions.ToString() + htmlTdEnd); mailMessage.AppendFormat(htmlTrEnd); } mailMessage.AppendFormat(htmlTableEnd); using (var sw = new StringWriter()) { table.RenderControl(new HtmlTextWriter(sw)); html = sw.ToString(); } mailMessage.AppendFormat(html); return(mailMessage.ToString()); }
/// <summary> /// Comverts the HtmlTable control to a GraphViz escString format /// </summary> /// <param name="instance"></param> /// <returns></returns> public static lblString ToGraphvizLabelFormat(this HtmlTable instance) { if (instance == null) { return(null); } var sb = new StringBuilder(); var tw = new StringWriter(sb); var hw = new HtmlTextWriter(tw, ""); instance.RenderControl(hw); return(new lblString(sb.Replace("\r\n", "").ToString())); }
/// <summary> /// Implementação do evento Render /// </summary> /// <param name="output"></param> protected override void Render(HtmlTextWriter output) { //------------------------------------------------------------ // Definição da classe para este tipo de controlo //------------------------------------------------------------ base.CssClass = "OWListBox"; if (RenderItemsAsCheckBoxes) { HtmlTable itemTable = new HtmlTable(); itemTable.Width = this.Width.ToString(); itemTable.CellPadding = 0; itemTable.CellSpacing = 0; itemTable.Border = 0; for (int i = 0; i <= this.Items.Count - 1; i++) { itemTable.Rows.Add(new HtmlTableRow()); HtmlTableCell cell = new HtmlTableCell(); itemTable.Rows[i].Cells.Add(cell); OWCheckBox chkValue = new OWCheckBox(); //chkValue.Enabled = !this.ReadOnly; chkValue.ReadOnly = this.ReadOnly; if (this.Items[i].Selected) { chkValue.Checked = true; } else { chkValue.Checked = false; } chkValue.Text = this.Items[i].Value; cell.Controls.Add(chkValue); } itemTable.RenderControl(output); } else { base.Render(output); } }
public string GetDataBlockUI(string[] fieldNames) { int ct = RecordCount; if (ct <= 0) { return(""); } HtmlTable table = new HtmlTable(); if (!IsFormStyle) { for (int i = 0; i < ct; i++) { HtmlTableRow tr = new HtmlTableRow(); table.Rows.Add(tr); foreach (string s in fieldNames) { HtmlTableCell tc = new HtmlTableCell(); tr.Cells.Add(tc); BuildFieldView(i, s, tc); } } } else { foreach (string s in fieldNames) { HtmlTableRow tr = new HtmlTableRow(); table.Rows.Add(tr); for (int i = 0; i < ct; i++) { HtmlTableCell tc = new HtmlTableCell(); tr.Cells.Add(tc); BuildFieldView(i, s, tc); } } } StringWriter sw = new StringWriter(); table.RenderControl(new HtmlTextWriter(sw)); sw.Close(); return(sw.ToString()); }
public string TableContentDesigner() { StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); HtmlTable t = new HtmlTable(); t.CellPadding = 3; t.CellSpacing = 0; t.BorderColor = "#6699cc"; t.BgColor = "#6699cc"; t.Width = ptbc.Width.ToString(); t.Height = ptbc.Height.ToString(); HtmlTableRow tr = new HtmlTableRow(); HtmlTableCell td = new HtmlTableCell(); td.VAlign = "top"; td.Align = "center"; // inner table for iframe HtmlTable iframe = new HtmlTable(); iframe.BgColor = "#FFFFFF"; iframe.Width = "600px"; iframe.Height = "500px"; iframe.CellPadding = 0; iframe.CellSpacing = 0; iframe.Style.Add("border", "1 solid " + "#6699cc"); HtmlTableRow tr2 = new HtmlTableRow(); HtmlTableCell td2 = new HtmlTableCell(); td2.VAlign = "middle"; td2.Align = "center"; td2.Controls.Add(new LiteralControl("<b><font face=arial size=2><font color=green>Power</font>TalkBox:</b> " + ptbc.ID + "</font>")); tr2.Cells.Add(td2); iframe.Rows.Add(tr2); td.Controls.Add(iframe); td.Controls.Add(new LiteralControl("<br><br><br>")); tr.Cells.Add(td); t.Rows.Add(tr); t.RenderControl(htw); return(sw.ToString()); }
/// <summary> /// 获取用于在设计时表示关联控件的 HTML。 /// </summary> /// <returns>用于在设计时表示控件的 HTML。</returns> public override string GetDesignTimeHtml() { StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); HtmlTable t = new HtmlTable(); t.CellPadding = 3; t.CellSpacing = 0; t.BorderColor = ColorTranslator.ToHtml(Color.Black); t.BgColor = ColorTranslator.ToHtml(this.bigFileUpload.BackColor); t.Width = "200px"; t.Height = "50px"; HtmlTableRow tr = new HtmlTableRow(); HtmlTableCell td = new HtmlTableCell(); td.VAlign = "top"; td.Align = "center"; // inner table for iframe HtmlTable iframe = new HtmlTable(); iframe.BgColor = "#FFFFFF"; iframe.Width = "100%"; iframe.Height = "100%"; iframe.CellPadding = 0; iframe.CellSpacing = 0; iframe.Style.Add("border", "1px solid " + ColorTranslator.ToHtml(Color.DarkBlue)); HtmlTableRow tr2 = new HtmlTableRow(); HtmlTableCell td2 = new HtmlTableCell(); td2.VAlign = "middle"; td2.Align = "center"; td2.Controls.Add(new LiteralControl(this.bigFileUpload.ID)); tr2.Cells.Add(td2); iframe.Rows.Add(tr2); td.Controls.Add(iframe); tr.Cells.Add(td); t.Rows.Add(tr); t.RenderControl(htw); return(sw.ToString()); }
/// <summary> /// Renders lines in the background to indicate markers in the Gant Chart. /// </summary> /// <param name="writer"></param> private void RenderGantBackground(HtmlTextWriter writer) { HtmlTable gantBackground = new HtmlTable(); gantBackground.CellPadding = 0; gantBackground.CellSpacing = 0; gantBackground.Attributes.Add("class", "GantBackgroundTable"); HtmlTableRow row = new HtmlTableRow(); gantBackground.Rows.Add(row); for (int i = 0; i < markerCount; i++) { HtmlTableCell cell = new HtmlTableCell(); Label l = new Label(); cell.Controls.Add(l); row.Cells.Add(cell); } gantBackground.RenderControl(writer); }
static void MainMethod(string[] args) { HtmlGenericControl htmlControl = new HtmlGenericControl("html"); HtmlForm hf = new HtmlForm(); StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); HtmlTextWriter htw = new HtmlTextWriter(sw); htmlControl.RenderControl(htw); Console.WriteLine(sw.ToString()); Console.WriteLine(sb); string contents = null; using (StringWriter swriter = new StringWriter()) { HtmlTextWriter writer = new HtmlTextWriter(swriter); htmlControl.RenderControl(writer); contents = swriter.ToString(); } Console.WriteLine(contents); Control ht = new HtmlTable(); HtmlTableRow htr = new HtmlTableRow(); HtmlTableCell cell1 = new HtmlTableCell(); HtmlTableCell cell2 = new HtmlTableCell(); cell1.Controls.Add(new LiteralControl("1")); cell2.Controls.Add(new LiteralControl("2")); htr.Controls.Add(cell1); htr.Controls.Add(cell2); ht.Controls.Add(htr); using (StringWriter swriter = new StringWriter()) { HtmlTextWriter writer = new HtmlTextWriter(swriter); ht.RenderControl(writer); contents = swriter.ToString(); } Console.WriteLine(contents); Console.ReadKey(); }
/// <summary> /// 导出Excel文件,自动返回可下载的文件流 /// </summary> /// <param name="dtData"></param> public static void ControlExcel(HtmlTable table, string FileName) { HttpContext curContext = HttpContext.Current; StringWriter strWriter = null; HtmlTextWriter htmlWriter = null; if (table.Rows.Count > 0) { HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8); curContext.Response.AddHeader("content-disposition", "attachment;filename=" + FileName + ".xls"); curContext.Response.ContentType = "application nd.ms-excel"; curContext.Response.ContentEncoding = System.Text.Encoding.UTF8; curContext.Response.Charset = "GB2312"; strWriter = new StringWriter(); htmlWriter = new HtmlTextWriter(strWriter); table.RenderControl(htmlWriter); curContext.Response.Write(strWriter.ToString()); curContext.Response.End(); } }
private string RenderHtmlTableToString(HtmlTable table) { using (MemoryStream dataStream = new MemoryStream()) { using (StreamWriter textWriter = new StreamWriter(dataStream, Encoding.UTF8)) { using (HtmlTextWriter htmlWriter = new HtmlTextWriter(textWriter)) { table.RenderControl(htmlWriter); textWriter.Flush(); dataStream.Seek(0, SeekOrigin.Begin); using (StreamReader dataReader = new StreamReader(dataStream)) { string htmlContent = dataReader.ReadToEnd(); return(htmlContent); } } } } }
/// <summary> /// Tables the specified data. /// </summary> /// <param name="helper">The helper.</param> /// <param name="Data">The data.</param> /// <param name="class">The class.</param> /// <returns></returns> public static IHtmlString Table(this HtmlHelper helper, List <UserComment> usrcmt, string @class) { if (helper is null) { throw new ArgumentNullException(nameof(helper)); } HtmlTable ht = new HtmlTable(); ht.Attributes.Add("class", @class); //Get the columns HtmlTableRow htColumnsRow = new HtmlTableRow(); typeof(UserComment).GetProperties().Select(prop => { HtmlTableCell htCell = new HtmlTableCell(); htCell.InnerText = prop.Name; return(htCell); }).ToList().ForEach(cell => htColumnsRow.Cells.Add(cell)); ht.Rows.Add(htColumnsRow); //Get the remaining rows usrcmt.ForEach(delegate(UserComment obj) { HtmlTableRow htRow = new HtmlTableRow(); obj.GetType().GetProperties().ToList().ForEach(delegate(PropertyInfo prop) { HtmlTableCell htCell = new HtmlTableCell(); htCell.InnerText = prop.GetValue(obj, null).ToString(); htRow.Cells.Add(htCell); }); ht.Rows.Add(htRow); }); StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); HtmlTextWriter hw = new HtmlTextWriter(sw); ht.RenderControl(hw); String HTMLContent = sb.ToString(); return(new MvcHtmlString(sb.ToString())); }
private void ExportTableToExcel(HtmlTable table, string title) { using (StringWriter stringWriter = new StringWriter()) { using (HtmlTextWriter textWriter = new HtmlTextWriter(stringWriter)) { table.RenderControl(textWriter); Response.Clear(); Response.ContentType = "application/vnd.ms-excel"; Response.Charset = "65001"; byte[] b = new byte[] { 0xEF, 0xBB, 0xBF }; Response.BinaryWrite(b); Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", title + ".xls")); // style to format numbers to string string style = @"<style> .textmode { mso-number-format:\@; } </style>"; Response.Write(style); Response.Write(stringWriter.ToString()); Response.End(); } } }
/// <summary> /// Tables the specified data. /// </summary> /// <param name="helper">The helper.</param> /// <param name="Data">The data.</param> /// <param name="class">The class.</param> /// <returns></returns> public static IHtmlString Table(this HtmlHelper helper, List <Employee> Data, string @class) { HtmlTable ht = new HtmlTable(); ht.Attributes.Add("class", @class); //Get the columns HtmlTableRow htColumnsRow = new HtmlTableRow(); typeof(Employee).GetProperties().Select(prop => { HtmlTableCell htCell = new HtmlTableCell(); htCell.InnerText = prop.Name; return(htCell); }).ToList().ForEach(cell => htColumnsRow.Cells.Add(cell)); ht.Rows.Add(htColumnsRow); //Get the remaining rows Data.ForEach(delegate(Employee obj) { HtmlTableRow htRow = new HtmlTableRow(); obj.GetType().GetProperties().ToList().ForEach(delegate(PropertyInfo prop) { HtmlTableCell htCell = new HtmlTableCell(); htCell.InnerText = prop.GetValue(obj, null).ToString(); htRow.Cells.Add(htCell); }); ht.Rows.Add(htRow); }); StringBuilder sb = new StringBuilder(); StringWriter tw = new StringWriter(sb); HtmlTextWriter hw = new HtmlTextWriter(tw); ht.RenderControl(hw); String HTMLContent = sb.ToString(); return(new MvcHtmlString(sb.ToString())); }
public void ASPXToPDF(HtmlTable objhtml1, HtmlTable objhtml2) { string fileName = "AsignacionFolios.pdf"; HttpContext.Current.Response.ClearContent(); HttpContext.Current.Response.Clear(); StringWriter sw1 = new StringWriter(); HtmlTextWriter hw1 = new HtmlTextWriter(sw1); objhtml1.RenderControl(hw1); StringWriter sw2 = new StringWriter(); HtmlTextWriter hw2 = new HtmlTextWriter(sw2); objhtml2.RenderControl(hw2); StringReader sr1 = new StringReader(sw1.ToString()); StringReader sr2 = new StringReader(sw2.ToString()); Document pdfDoc = new Document(PageSize.A2, 5f, 5f, 5f, 5f); HTMLWorker htmlparser = new HTMLWorker(pdfDoc); PdfWriter.GetInstance(pdfDoc, HttpContext.Current.Response.OutputStream); pdfDoc.Open(); htmlparser.Parse(sr1); pdfDoc.NewPage(); htmlparser.Parse(sr2); pdfDoc.Close(); HttpContext.Current.Response.ContentType = "application/pdf"; HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + fileName); HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache); HttpContext.Current.Response.Write(pdfDoc); HttpContext.Current.Response.End(); }
protected override void RenderContents(HtmlTextWriter output) { // Show all the messages in ENTValidationErrors if (ValidationErrors.Count != 0) { var table = new HtmlTable(); var trHeader = new HtmlTableRow(); var tcHeader = new HtmlTableCell(); tcHeader.InnerText = "Please review the following issues:"; tcHeader.Attributes.Add("class", "validatioErrorMessageHeader"); trHeader.Cells.Add(tcHeader); table.Rows.Add(trHeader); foreach (var ve in ValidationErrors) { var tr = new HtmlTableRow(); var tc = new HtmlTableCell(); tc.InnerText = ve.ErrorMessage; tc.Attributes.Add("class", "validatioErrorMessageHeader"); tr.Cells.Add(tc); table.Rows.Add(tr); tc = null; tr = null; } table.RenderControl(output); tcHeader = null; trHeader = null; table = null; } else { output.Write(""); } }
public void CreateVgHtmlTable() { var table = new HtmlTable(); //var mailMessage = new StringBuilder(); string html = "<html><head><title>VG list</title><script type=\"text/javascript\" src=\"jquery-3.2.1.min.js\"></script><script type=\"text/javascript\" src=\"sorttable.js\"></script></head><body>\n"; HtmlTableRow row; foreach (VGame vg in VGames) { row = new HtmlTableRow(); row.Cells.Add(new HtmlTableCell { InnerText = vg.Title }); //row.Cells.Add(new HtmlTableCell { InnerText = vg.AltTitle }); row.Cells.Add(new HtmlTableCell { InnerText = vg.Platform }); row.Cells.Add(new HtmlTableCell { InnerText = vg.Status.ToString() }); row.Cells.Add(new HtmlTableCell { InnerText = vg.ScoreStr }); row.Cells.Add(new HtmlTableCell { InnerText = vg.DateFinishedStr }); table.Rows.Add(row); } using (var sw = new StringWriter()) { table.RenderControl(new HtmlTextWriter(sw)); html += sw.ToString().Insert(7, "<tr><th>Title</th><th>Platform</th><th>Status</th><th>Status</th><th>Date of finishing</th></tr>").Insert(6, " class=\"sortable\" border=\"2\""); } html += "</body></html>"; System.IO.File.WriteAllText(pathHtml, html); }
//------------------------------------------------------------------------------------------------------------- private string GetRptHead() { string strTemp = ""; HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; string FontSize = "14px"; table.Border = 0; table.CellPadding = 0; table.CellSpacing = 0; table.Align = "center"; css = table.Style; css.Add("font-size", "12px"); css.Add("font-family", "標楷體"); css.Add("width", "100%"); //**************************************** row = new HtmlTableRow(); cell = new HtmlTableCell(); //查詢城市代碼名稱 DataTable dt = GetDataTable(); //查詢城市代碼名稱 string Age = ""; string Sex = ""; string Firstphone = ""; string time = ""; string Christian = ""; if (ddlAge.SelectedValue != "") { Age += "約" + ddlAge.SelectedValue + "歲"; } if (rdoSex.SelectedValue != "" && rdoSex.SelectedValue != "全部") { Sex += rdoSex.SelectedValue + "生"; } if (CKB_Firstphone.Checked == true) { Firstphone = "第一次來電"; } if (CKB_Christian.Checked.ToString() == "True") { Christian += " 是基督徒"; } if (txtBegCreateDate.Text != "" && txtEndCreateDate.Text != "") { time = txtBegCreateDate.Text + "~" + txtEndCreateDate.Text; } foreach (DataRow dr in dt.Rows) { string city = ""; if (ddlCity.SelectedValue != "") city += dr["縣市"].ToString(); strTemp = city; strTemp += " 個案數分布表"; if (time != "" || Firstphone != "" || Age != "" || Christian != "") { strTemp += "(" + time + Firstphone + Christian + Age + Sex + ")"; } } cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; //教會跨行置中 cell.ColSpan = 5; //cell.ColSpan = 8; css.Add("text-align", "center"); css.Add("font-size", "24px"); css.Add("font-family", "標楷體"); css.Add("border-style", "none"); css.Add("font-weight", "bold"); row.Cells.Add(cell); table.Rows.Add(row); //************************************* //轉成 html 碼 StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); table.RenderControl(htw); return htw.InnerWriter.ToString(); }
private string GetReport() { string[] Items = { "�з|�W��", //"����", //"�ϰ�", "�з|�a�}", "�з|�q��", "�з|Email", "�D����v", "�D����v�q��", "�D����vEmail", "�з|�Ƥu", "�p�����f", "�p�����f���", "�p�����fEmail", }; //�� table string strTemp = ""; HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; table.Border = 0; table.BorderColor = "black"; table.CellPadding = 0; table.CellSpacing = 0; table.Align = "center"; css = table.Style; css.Add("font-size", "12pt"); css.Add("font-family", "�з���"); css.Add("width", "800px"); //��1�� row = new HtmlTableRow(); for (int i = 0; i < Items.Length; i++) { cell = new HtmlTableCell(); strTemp = Items[i].ToString(); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "25px"); //���Y�r���j�p if (i == 0) { Util.AddTDLine(css, 123); } if (i == 1) { Util.AddTDLine(css, 23); } if (i == 2) { Util.AddTDLine(css, 23); } if (i == 3) { Util.AddTDLine(css, 23); } if (i == 4) { Util.AddTDLine(css, 23); } if (i == 5) { Util.AddTDLine(css, 23); } if (i == 6) { Util.AddTDLine(css, 23); } if (i == 7) { Util.AddTDLine(css, 23); } if (i == 8) { Util.AddTDLine(css, 23); } if (i == 9) { Util.AddTDLine(css, 23); } if (i == 10) { Util.AddTDLine(css, 23); } //if (i == 11) //{ // Util.AddTDLine(css, 23); //} //if (i == 12) //{ // Util.AddTDLine(css, 23); //} row.Cells.Add(cell); } cell = new HtmlTableCell(); string strTemp1 = ""; cell.InnerHtml = strTemp1; css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", "12px"); cell.Width = "8"; row.Cells.Add(cell); table.Rows.Add(row); //-------------------------------------------- //��2��,������ //*********�Ĥ@��********* string strFontSize = "18px"; DataTable dt = GetDataTable(); foreach (DataRow dr in dt.Rows) { row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; cell.InnerHtml = dr["�з|�W��"].ToString(); //�qGetDataTable()��Name�� css.Add("text-align", "center"); //excel��r�m�� css.Add("font-size", strFontSize); //excel��r�j�p Util.AddTDLine(css, 1234); //excel �@���x�s�楪(1)�W(2)�k(3)�U(4) �ؽu row.Cells.Add(cell); //cell = new HtmlTableCell(); //css = cell.Style; //cell.InnerHtml = dr["����"].ToString(); //css.Add("text-align", "center"); //css.Add("font-size", strFontSize); //Util.AddTDLine(css, 1234); //row.Cells.Add(cell); //cell = new HtmlTableCell(); //css = cell.Style; //cell.InnerHtml = dr["�ϰ�"].ToString(); //css.Add("text-align", "center"); //css.Add("font-size", strFontSize); //Util.AddTDLine(css, 1234); //row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; cell.InnerHtml = dr["�з|�a�}"].ToString(); css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 1234); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; cell.InnerHtml = dr["�з|�q��"].ToString(); css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("mso-number-format", "\\@"); Util.AddTDLine(css, 1234); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; cell.InnerHtml = dr["�з|Email"].ToString(); css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 1234); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; cell.InnerHtml = dr["�D����v"].ToString(); css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 1234); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; cell.InnerHtml = dr["�D����v�q��"].ToString(); css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("mso-number-format", "\\@"); Util.AddTDLine(css, 1234); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; cell.InnerHtml = dr["�D����vEmail"].ToString(); css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 1234); row.Cells.Add(cell); string Churchministry = ""; if (dr["�з|�Ƥu"].ToString() != "") { string tmp = dr["�з|�Ƥu"].ToString(); string[] split = tmp.Split(new Char[] { ',' }); split[0].ToString(); split[1].ToString(); split[2].ToString(); split[3].ToString(); split[4].ToString(); split[5].ToString(); split[6].ToString(); if (split[0] == "�B�e") Churchministry = "�B�e,"; // Churchministry = ","; if (split[1] == "�B��") Churchministry += "�B��,"; if (split[2] == "�C��") Churchministry = "�C��,"; if (split[3] == "�ѤH") Churchministry += "�ѤH,"; if (split[4] == "�a�x���h") Churchministry += "�a�x���h,"; if (split[5] == "��ͻ���") Churchministry += "��ͻ���,"; if (split[6] == "��L") Churchministry += "��L"; } cell = new HtmlTableCell(); css = cell.Style; cell.InnerHtml = Churchministry; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 1234); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; cell.InnerHtml = dr["�p�����f"].ToString(); css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 1234); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; cell.InnerHtml = dr["���f�q��"].ToString(); css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("mso-number-format", "\\@"); Util.AddTDLine(css, 1234); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; cell.InnerHtml = dr["���fEmail"].ToString(); css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 1234); row.Cells.Add(cell); table.Rows.Add(row); } //�ন html �X StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); table.RenderControl(htw); return htw.InnerWriter.ToString(); }
//顯示來來電諮詢別(分項) 筆數------------------------------------------------------ private string GetRptHead2() { //---------------------------------------------------------------------- string[] O2 = new string[22]; O2[0] = getCnt2("經濟"); O2[1] = getCnt2("情緒"); O2[2] = getCnt2("信仰"); O2[3] = getCnt2("人際"); O2[4] = getCnt2("婆媳"); O2[5] = getCnt2("翁媳"); O2[6] = getCnt2("妯娌"); O2[7] = getCnt2("手足"); O2[8] = getCnt2("職場"); O2[9] = getCnt2("教會"); O2[10] = getCnt2("溝通"); O2[11] = getCnt2("性生活"); O2[12] = getCnt2("精神疾病"); O2[13] = getCnt2("身體疾病"); O2[14] = getCnt2("個性"); O2[15] = getCnt2("外遇"); O2[16] = getCnt2("暴力"); O2[17] = getCnt2("教育"); O2[18] = getCnt2("霸凌"); O2[19] = getCnt2("學業"); O2[20] = getCnt2("隱症"); O2[21] = getCnt2("性別問題"); int sum = int.Parse(O2[0]) + int.Parse(O2[1]) + int.Parse(O2[2]) + int.Parse(O2[3]) + int.Parse(O2[4]); sum += int.Parse(O2[5]) + int.Parse(O2[6]) + int.Parse(O2[7]) + int.Parse(O2[8]) + int.Parse(O2[9]); sum += int.Parse(O2[10]) + int.Parse(O2[11]) + int.Parse(O2[12]) + int.Parse(O2[13]) + int.Parse(O2[14]); sum += int.Parse(O2[15]) + int.Parse(O2[16]) + int.Parse(O2[17]) + int.Parse(O2[18]) + int.Parse(O2[19]); sum += int.Parse(O2[20]) + int.Parse(O2[21]); //設定框架---------------------------------------------------------------------- string strTemp = ""; HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; string strColor = "BLACK"; string FontSize = "14px"; table.Border = 0; table.CellPadding = 0; table.CellSpacing = 0; table.Align = "center"; css = table.Style; css.Add("font-size", "12px"); css.Add("font-family", "標楷體"); css.Add("width", "100%"); //---------------------------------------------------------- if (sum != 0) { row = new HtmlTableRow(); cell = new HtmlTableCell(); strTemp = "來電諮詢別(分項)"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "28px"); css.Add("font-family", "標楷體"); css.Add("border-style", "none"); cell.ColSpan = 6; row.Cells.Add(cell); table.Rows.Add(row); } ///////////////////////////////////////// 第一行 by apple ////////////////////////////////////////////////////////////////// //經濟O2[0]---------------------------------------------------------- row = new HtmlTableRow(); if (int.Parse(O2[0]) != 0) { cell = new HtmlTableCell(); strTemp = "經濟"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 1234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //情緒 O2[1]---------------------------------------------------------------- if (int.Parse(O2[1]) != 0) { cell = new HtmlTableCell(); strTemp = "情緒"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //信仰 O2[2]---------------------------------------------------------------- if (int.Parse(O2[2]) != 0) { cell = new HtmlTableCell(); strTemp = "信仰"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //人際O2[3]---------------------------------------------------------------- if (int.Parse(O2[3]) != 0) { cell = new HtmlTableCell(); strTemp = "人際"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //婆媳O2[4]---------------------------------------------------------------- if (int.Parse(O2[4]) != 0) { cell = new HtmlTableCell(); strTemp = "婆媳"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //翁媳O2[5]---------------------------------------------------------------- if (int.Parse(O2[5]) != 0) { cell = new HtmlTableCell(); strTemp = "翁媳"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //妯娌O2[6]---------------------------------------------------------------- if (int.Parse(O2[6]) != 0) { cell = new HtmlTableCell(); strTemp = "妯娌"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //手足O2[7]---------------------------------------------------------------- if (int.Parse(O2[7]) != 0) { cell = new HtmlTableCell(); strTemp = "手足"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //職場O2[8]---------------------------------------------------------------- if (int.Parse(O2[8]) != 0) { cell = new HtmlTableCell(); strTemp = "職場"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //教會O2[9]---------------------------------------------------------------- if (int.Parse(O2[9]) != 0) { cell = new HtmlTableCell(); strTemp = "教會"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //溝通O2[10]---------------------------------------------------------------- if (int.Parse(O2[10]) != 0) { cell = new HtmlTableCell(); strTemp = "溝通"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //性生活O2[11]---------------------------------------------------------------- if (int.Parse(O2[11]) != 0) { cell = new HtmlTableCell(); strTemp = "性生活"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //精神疾病O2[12]---------------------------------------------------------------- if (int.Parse(O2[12]) != 0) { cell = new HtmlTableCell(); strTemp = "精神疾病"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //身體疾病O2[13]---------------------------------------------------------------- if (int.Parse(O2[13]) != 0) { cell = new HtmlTableCell(); strTemp = "身體疾病"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //個性O2[14]---------------------------------------------------------------- if (int.Parse(O2[14]) != 0) { cell = new HtmlTableCell(); strTemp = "個性"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //外遇O2[15]---------------------------------------------------------------- if (int.Parse(O2[15]) != 0) { cell = new HtmlTableCell(); strTemp = "外遇"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //暴力O2[16]---------------------------------------------------------------- if (int.Parse(O2[16]) != 0) { cell = new HtmlTableCell(); strTemp = "暴力"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //教育O2[17]---------------------------------------------------------------- if (int.Parse(O2[17]) != 0) { cell = new HtmlTableCell(); strTemp = "教育"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //霸凌O2[18]---------------------------------------------------------------- if (int.Parse(O2[18]) != 0) { cell = new HtmlTableCell(); strTemp = "霸凌"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //學業O2[19]---------------------------------------------------------------- if (int.Parse(O2[19]) != 0) { cell = new HtmlTableCell(); strTemp = "學業"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //隱症O2[20]---------------------------------------------------------------- if (int.Parse(O2[20]) != 0) { cell = new HtmlTableCell(); strTemp = "隱症"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //性別問題O2[21]---------------------------------------------------------------- if (int.Parse(O2[21]) != 0) { cell = new HtmlTableCell(); strTemp = "性別問題"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //---------------- table.Rows.Add(row); ///////////////////////////////////////// 第二行by apple ////////////////////////////////////////////////////////////////// //經濟O2[0]---------------------------------------------------------- row = new HtmlTableRow(); if (int.Parse(O2[0]) != 0) { cell = new HtmlTableCell(); strTemp = O2[0]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 134, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //情緒O2[1]---------------------------------------------------------------- if (int.Parse(O2[1]) != 0) { cell = new HtmlTableCell(); strTemp = O2[1]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //信仰O2[2]---------------------------------------------------------------- if (int.Parse(O2[2]) != 0) { cell = new HtmlTableCell(); strTemp = O2[2]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //人際O2[3]---------------------------------------------------------------- if (int.Parse(O2[3]) != 0) { cell = new HtmlTableCell(); strTemp = O2[3]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //婆媳O2[4]---------------------------------------------------------------- if (int.Parse(O2[4]) != 0) { cell = new HtmlTableCell(); strTemp = O2[4]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //翁媳O2[5]---------------------------------------------------------------- if (int.Parse(O2[5]) != 0) { cell = new HtmlTableCell(); strTemp = O2[5]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //妯娌O2[6]---------------------------------------------------------------- if (int.Parse(O2[6]) != 0) { cell = new HtmlTableCell(); strTemp = O2[6]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //手足O2[7]---------------------------------------------------------------- if (int.Parse(O2[7]) != 0) { cell = new HtmlTableCell(); strTemp = O2[7]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //職場O2[8]---------------------------------------------------------------- if (int.Parse(O2[8]) != 0) { cell = new HtmlTableCell(); strTemp = O2[8]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //教會O2[9]---------------------------------------------------------------- if (int.Parse(O2[9]) != 0) { cell = new HtmlTableCell(); strTemp = O2[9]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //溝通O2[10]---------------------------------------------------------------- if (int.Parse(O2[10]) != 0) { cell = new HtmlTableCell(); strTemp = O2[10]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //性生活O2[11]---------------------------------------------------------------- if (int.Parse(O2[11]) != 0) { cell = new HtmlTableCell(); strTemp = O2[11]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //精神疾病O2[12]---------------------------------------------------------------- if (int.Parse(O2[12]) != 0) { cell = new HtmlTableCell(); strTemp = O2[12]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //身體疾病O2[13]---------------------------------------------------------------- if (int.Parse(O2[13]) != 0) { cell = new HtmlTableCell(); strTemp = O2[13]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //個性O2[14]---------------------------------------------------------------- if (int.Parse(O2[14]) != 0) { cell = new HtmlTableCell(); strTemp = O2[14]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //外遇O2[15]---------------------------------------------------------------- if (int.Parse(O2[15]) != 0) { cell = new HtmlTableCell(); strTemp = O2[15]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //暴力O2[16]---------------------------------------------------------------- if (int.Parse(O2[16]) != 0) { cell = new HtmlTableCell(); strTemp = O2[16]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //教育O2[17]---------------------------------------------------------------- if (int.Parse(O2[17]) != 0) { cell = new HtmlTableCell(); strTemp = O2[17]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //霸凌O2[18]---------------------------------------------------------------- if (int.Parse(O2[18]) != 0) { cell = new HtmlTableCell(); strTemp = O2[18]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //學業O2[19]---------------------------------------------------------------- if (int.Parse(O2[19]) != 0) { cell = new HtmlTableCell(); strTemp = O2[19]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //隱症O2[20]---------------------------------------------------------------- if (int.Parse(O2[20]) != 0) { cell = new HtmlTableCell(); strTemp = O2[20]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //性別問題O2[21]---------------------------------------------------------------- if (int.Parse(O2[21]) != 0) { cell = new HtmlTableCell(); strTemp = O2[21]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //---------------- table.Rows.Add(row); //************************************* //轉成 html 碼 StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); table.RenderControl(htw); return htw.InnerWriter.ToString(); }
private string GetTable(string strTitle) { DataTable dt = GetDataTable(); //組 table string strTemp = ""; HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; table.Border = 0; table.BorderColor = "black"; table.CellPadding = 0; table.CellSpacing = 0; table.Align = "center"; css = table.Style; css.Add("font-size", "12pt"); css.Add("font-family", "標楷體"); css.Add("width", "800px"); // css.Add("line-height", TableWidth); //intRow = intRow + dt.Rows.Count; //第1行 row = new HtmlTableRow(); for (int i = 0; i < Items.Length; i++) { cell = new HtmlTableCell(); strTemp = Items[i].ToString(); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "25px"); //抬頭字型大小 if (i == 0) { Util.AddTDLine(css, 123); } if (i == 1) { Util.AddTDLine(css, 23); } if (i == 2) { Util.AddTDLine(css, 23); } if (i == 3) { Util.AddTDLine(css, 23); } if (i == 4) { Util.AddTDLine(css, 23); } if (i == 5) { Util.AddTDLine(css, 23); } if (i == 6) { Util.AddTDLine(css, 23); } if (i == 7) { Util.AddTDLine(css, 23); } if (i == 8) { Util.AddTDLine(css, 23); } if (i == 9) { Util.AddTDLine(css, 23); } row.Cells.Add(cell); } cell = new HtmlTableCell(); string strTemp1 = "";// "" + strTitle + ""; cell.InnerHtml = strTemp1; css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", "12px"); //cell.RowSpan = intRow; cell.Width = "8"; row.Cells.Add(cell); table.Rows.Add(row); //-------------------------------------------- //第2行,資料顯示 row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 123); cell.InnerHtml = "morning"; row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 123); cell.InnerHtml = ""; foreach (DataRow dr in dt.Rows) { row = new HtmlTableRow(); for (int i = 0; i < Items.Length; i++) { string Align = "left"; cell = new HtmlTableCell(); strTemp = dr["UserName"].ToString(); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", Align); css.Add("font-size", strFontSize); if (i == 0) { Util.AddTDLine(css, 123); } if (i == 1) { Util.AddTDLine(css, 23); } if (i == 2) { Util.AddTDLine(css, 23); } if (i == 3) { Util.AddTDLine(css, 23); } if (i == 4) { Util.AddTDLine(css, 23); } if (i == 5) { Util.AddTDLine(css, 23); } if (i == 6) { Util.AddTDLine(css, 23); } if (i == 7) { Util.AddTDLine(css, 23); } //if (i == 8) //{ // Util.AddTDLine(css, 23); //} //if (i == 9) //{ // Util.AddTDLine(css, 23); //} row.Cells.Add(cell); } //cell.InnerHtml = "A"; //row.Cells.Add(cell); table.Rows.Add(row); } //table.Rows.Add(row); //轉成 html 碼 StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); table.RenderControl(htw); return htw.InnerWriter.ToString(); }
public string SessionDetails(HttpListenerRequest request) { SessionID sessionId = new SessionID(request.QueryString["beginstring"], request.QueryString["sendercompid"], request.QueryString["targetcompid"]); Session sessionDetails = Session.LookupSession(sessionId); if (sessionDetails == null) { throw new Exception("Session not found"); } StringBuilder sbHtmlPageBody = _sbHtmlHeader; string url = request.Url.OriginalString; string urlOriginalString = request.Url.OriginalString; if (request.QueryString["enabled"] != null) { if (!Convert.ToBoolean(request.QueryString["enabled"])) { sessionDetails.Logout(); } else { sessionDetails.Logon(); } url = RemoveQueryStringByKey(urlOriginalString, "Enabled"); } if (request.QueryString["next incoming"] != null) { int value = Convert.ToInt16(request.QueryString["next incoming"]); sessionDetails.NextTargetMsgSeqNum = value <= 0 ? 1 : value; url = RemoveQueryStringByKey(urlOriginalString, "next incoming"); } if (request.QueryString["Next Outgoing"] != null) { int value = Convert.ToInt16(request.QueryString["Next Outgoing"]); sessionDetails.NextSenderMsgSeqNum = value <= 0 ? 1 : value; url = RemoveQueryStringByKey(urlOriginalString, "Next Outgoing"); } if (request.QueryString["SendRedundantResendRequests"] != null) { sessionDetails.SendRedundantResendRequests = Convert.ToBoolean(request.QueryString["SendRedundantResendRequests"]); url = RemoveQueryStringByKey(urlOriginalString, "SendRedundantResendRequests"); } if (request.QueryString["CheckCompId"] != null) { sessionDetails.CheckCompID = Convert.ToBoolean(request.QueryString["CheckCompId"]); url = RemoveQueryStringByKey(urlOriginalString, "CheckCompId"); } if (request.QueryString["CheckLatency"] != null) { sessionDetails.CheckLatency = Convert.ToBoolean(request.QueryString["CheckLatency"]); url = RemoveQueryStringByKey(urlOriginalString, "CheckLatency"); } if (request.QueryString["MaxLatency"] != null) { int value = Convert.ToInt16(request.QueryString["MaxLatency"]); sessionDetails.MaxLatency = value <= 0 ? 1 : value; url = RemoveQueryStringByKey(urlOriginalString, "MaxLatency"); } if (request.QueryString["LogonTimeout"] != null) { int value = Convert.ToInt16(request.QueryString["LogonTimeout"]); sessionDetails.LogonTimeout = value <= 0 ? 1 : value; url = RemoveQueryStringByKey(urlOriginalString, "LogonTimeout"); } if (request.QueryString["LogoutTimeout"] != null) { int value = Convert.ToInt16(request.QueryString["LogoutTimeout"]); sessionDetails.LogoutTimeout = value <= 0 ? 1 : value; url = RemoveQueryStringByKey(urlOriginalString, "LogoutTimeout"); } if (request.QueryString["ResetOnLogon"] != null) { sessionDetails.ResetOnLogon = Convert.ToBoolean(request.QueryString["ResetOnLogon"]); url = RemoveQueryStringByKey(urlOriginalString, "ResetOnLogon"); } if (request.QueryString["ResetOnLogout"] != null) { sessionDetails.ResetOnLogout = Convert.ToBoolean(request.QueryString["ResetOnLogout"]); url = RemoveQueryStringByKey(urlOriginalString, "ResetOnLogout"); } if (request.QueryString["ResetOnDisconnect"] != null) { sessionDetails.ResetOnDisconnect = Convert.ToBoolean(request.QueryString["ResetOnDisconnect"]); url = RemoveQueryStringByKey(urlOriginalString, "ResetOnDisconnect"); } if (request.QueryString["RefreshOnLogon"] != null) { sessionDetails.RefreshOnLogon = Convert.ToBoolean(request.QueryString["RefreshOnLogon"]); url = RemoveQueryStringByKey(urlOriginalString, "RefreshOnLogon"); } if (request.QueryString["MillisecondsInTimestamp"] != null) { sessionDetails.MillisecondsInTimeStamp = Convert.ToBoolean(request.QueryString["MillisecondsInTimestamp"]); url = RemoveQueryStringByKey(urlOriginalString, "MillisecondsInTimestamp"); } if (request.QueryString["PersistMessages"] != null) { sessionDetails.PersistMessages = Convert.ToBoolean(request.QueryString["PersistMessages"]); url = RemoveQueryStringByKey(urlOriginalString, "PersistMessages"); } sbHtmlPageBody.AppendFormat(@"<CENTER>{0}</CENTER><HR/>", sessionId); sbHtmlPageBody.AppendFormat(@"<CENTER>[<A HREF='/resetSession?{0}'>RESET</A>] [<A HREF='/refreshSession?{0}'>REFRESH</A>]</CENTER><HR/></HEADER><BODY>", GetParameterList(urlOriginalString)); HtmlTable table = new HtmlTable { Border = 1, ID = "session_details", CellPadding = 2, Width = "100%" }; table.Rows.Add(AddRow("Enabled", sessionDetails.IsEnabled, url)); table.Rows.Add(AddRow("ConnectionType", sessionDetails.IsInitiator?"initiator": "acceptor")); table.Rows.Add(AddRow("SessionTime", sessionDetails.IsSessionTime)); table.Rows.Add(AddRow("LoggedOn", sessionDetails.IsLoggedOn)); table.Rows.Add(AddRow("Next Incoming", sessionDetails.NextTargetMsgSeqNum, url)); table.Rows.Add(AddRow("Next Outgoing", sessionDetails.NextSenderMsgSeqNum, url)); table.Rows.Add(AddRow("SendRedundantResendRequests", sessionDetails.SendRedundantResendRequests, url)); table.Rows.Add(AddRow("CheckCompId", sessionDetails.CheckCompID, url)); table.Rows.Add(AddRow("CheckLatency", sessionDetails.CheckLatency, url)); table.Rows.Add(AddRow("MaxLatency", sessionDetails.MaxLatency, url)); table.Rows.Add(AddRow("LogonTimeout", sessionDetails.LogonTimeout, url)); table.Rows.Add(AddRow("LogoutTimeout", sessionDetails.LogoutTimeout, url)); table.Rows.Add(AddRow("ResetOnLogon", sessionDetails.ResetOnLogon, url)); table.Rows.Add(AddRow("ResetOnLogout", sessionDetails.ResetOnLogout, url)); table.Rows.Add(AddRow("ResetOnDisconnect", sessionDetails.ResetOnDisconnect, url)); table.Rows.Add(AddRow("RefreshOnLogon", sessionDetails.RefreshOnLogon, url)); table.Rows.Add(AddRow("MillisecondsInTimestamp", sessionDetails.MillisecondsInTimeStamp, url)); table.Rows.Add(AddRow("PersistMessages", sessionDetails.PersistMessages, url)); StringWriter sr = new StringWriter(); HtmlTextWriter hText = new HtmlTextWriter(sr); table.RenderControl(hText); return(sbHtmlPageBody + hText.InnerWriter.ToString()); }
private void Refresh(string fi, string ff) { string json = ""; ws = Session["wsac"] as wsac.IsacClient; json = ws.GetReporteConciliacion(fi, ff); repconc rep = JsonConvert.DeserializeObject <repconc>(json); foreach (DataRow dr in rep.recargas.Rows) { HtmlTableRow row = new HtmlTableRow(); Label lbl = new Label(); if (dr["err"] is DBNull) { lbl.Text = "<a id=\"\" style='background-color:yellow;' class=\"btn default btn-xs\"</a>"; } else { switch (dr["err"].ToString()) { case "0": lbl.Text = "<a id=\"\" style='background-color:#00ff00;' class=\"btn default btn-xs\"</a>"; break; case "1": lbl.Text = "<a id=\"\" style='background-color:#0000ff;' class=\"btn default btn-xs\"</a>"; break; case "2": lbl.Text = "<a id=\"\" style='background-color:#ff0000;' class=\"btn default btn-xs\"</a>"; break; case "-1": case "3": lbl.Text = "<a id=\"\" style='background-color:yellow;' class=\"btn default btn-xs\"</a>"; break; } } row.Cells.Add(new HtmlTableCell() { Width = "2%;" }); row.Cells[0].Controls.Add(lbl); row.Cells.Add(new HtmlTableCell() { Width = "10%;", InnerHtml = dr["operadora"].ToString() }); row.Cells.Add(new HtmlTableCell() { Width = "10%;", InnerHtml = dr["paquete"].ToString() }); row.Cells.Add(new HtmlTableCell() { Width = "10%;", InnerHtml = dr["numerorecarga"].ToString() }); row.Cells.Add(new HtmlTableCell() { Width = "10%;", InnerHtml = dr["fecha"].ToString() }); row.Cells.Add(new HtmlTableCell() { Width = "10%;", InnerHtml = dr["PaymentID"].ToString() }); row.Cells.Add(new HtmlTableCell() { Width = "10%;", InnerHtml = (rep.recargas.Columns.Contains("rstransactionid") ? dr["rstransactionid"].ToString() : "") }); row.Cells.Add(new HtmlTableCell() { Width = "10%;", InnerHtml = (rep.recargas.Columns.Contains("rsrcode") ? dr["rsrcode"].ToString() : "") }); row.Cells.Add(new HtmlTableCell() { Width = "28%;", InnerHtml = dr["errvestadetallado"].ToString() }); tbReporte.Rows.Add(row); HtmlTable tbInterna = new HtmlTable(); HtmlTableRow row2 = null, rowint = null;; List <string> ls = new List <string> { "0", "1", "2" }; if (ls.Contains(dr["err"].ToString())) { DataRow[] drvesta = (rep.vesta.Rows.Count > 0 ? rep.vesta.Select("paymentid = '" + dr["PaymentID"].ToString() + "'") : new DataRow[0]); DataRow[] drrs = (rep.rs.Rows.Count > 0 ? rep.rs.Select("idtransaccion = '" + dr["rstransactionid"].ToString() + "'") : new DataRow[0]); if (drvesta.Count() > 0) { row2 = new HtmlTableRow() { BgColor = "#ffffff" }; rowint = new HtmlTableRow() { BgColor = "#ffffff" }; rowint.Cells.Add(new HtmlTableCell() { Width = "2%", InnerHtml = "<img width='40' src='assets/images/vesta.png'>" }); rowint.Cells.Add(new HtmlTableCell() { Width = "10%", InnerHtml = drvesta[0]["paymentid"].ToString() }); rowint.Cells.Add(new HtmlTableCell() { Width = "10%", InnerHtml = (decimal.Parse(drvesta[0]["amount"].ToString())).ToString("c") }); rowint.Cells.Add(new HtmlTableCell() { Width = "10%", InnerHtml = drvesta[0]["vestadate"].ToString() }); rowint.Cells.Add(new HtmlTableCell() { Width = "10%", InnerHtml = PaymentStatus(int.Parse(drvesta[0]["paymentstatus"].ToString())) }); rowint.Cells.Add(new HtmlTableCell() { Width = "10%", InnerHtml = drvesta[0]["paymentstatusreason"].ToString() }); } if (dr["err"].ToString() == "0") { if (drrs.Count() > 0) { if (rowint == null) { rowint = new HtmlTableRow() { BgColor = "#ffffff" } } ; if (row2 == null) { row2 = new HtmlTableRow() { BgColor = "#ffffff" } } ; rowint.Cells.Add(new HtmlTableCell() { Width = "2%", InnerHtml = "<img width='30' src='assets/images/rs.png'>" }); rowint.Cells.Add(new HtmlTableCell() { Width = "10%", InnerHtml = drrs[0]["idtransaccion"].ToString() }); rowint.Cells.Add(new HtmlTableCell() { Width = "10%", InnerHtml = drrs[0]["fecha"].ToString() }); rowint.Cells.Add(new HtmlTableCell() { Width = "10%", InnerHtml = drrs[0]["celular"].ToString() }); rowint.Cells.Add(new HtmlTableCell() { Width = "10%", InnerHtml = (decimal.Parse(drrs[0]["monto"].ToString())).ToString("c") }); rowint.Cells.Add(new HtmlTableCell() { Width = "10%", InnerHtml = drrs[0]["carrier"].ToString() }); rowint.Cells.Add(new HtmlTableCell() { Width = "10%", InnerHtml = drrs[0]["folio"].ToString() }); } tbInterna.Width = "100%"; } else { tbInterna.Width = "50%"; } if (drvesta.Count() > 0 || drrs.Count() > 0) { tbInterna.Rows.Add(rowint); StringBuilder sb = new StringBuilder(); StringWriter tw = new StringWriter(sb); HtmlTextWriter hw = new HtmlTextWriter(tw); tbInterna.RenderControl(hw); row2.Cells.Add(new HtmlTableCell() { Width = "100%", ColSpan = 9, InnerHtml = sb.ToString() }); tbReporte.Rows.Add(row2); } } } } }
//------------------------------------------------------------------------- public string Render() { //�� table string strTemp = ""; HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; table.Border = 1; table.CellPadding = 3; table.CellSpacing = 0; css = table.Style; css.Add("font-size", _fontSize); css.Add("font-family", _fontFamily); css.Add("width", "100%"); //-------------------------------------------- //��1�� row = new HtmlTableRow(); for (int i = 0; i < _dataTable.Columns.Count; i++) { string ColumnName = _dataTable.Columns[i].ColumnName; if (_disableColumn.Contains(ColumnName)) { continue; } cell = new HtmlTableCell(); strTemp = _dataTable.Columns[i].ColumnName; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", _columnAlign); css.Add("font-size", _columnFontSize); row.Cells.Add(cell); } table.Rows.Add(row); //-------------------------------------------- //��2��,������ foreach (DataRow dr in _dataTable.Rows) { row = new HtmlTableRow(); for (int i = 0; i < _dataTable.Columns.Count; i++) { string ColumnName = _dataTable.Columns[i].ColumnName; if (_disableColumn.Contains(ColumnName)) { continue; } cell = new HtmlTableCell(); strTemp = dr[_dataTable.Columns[i].ColumnName].ToString(); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; if (_forceText.Contains(ColumnName)) { css.Add("mso-number-format", "\\@"); } css.Add("text-align", _textAlign[i]); css.Add("font-size", _fontSize); row.Cells.Add(cell); } table.Rows.Add(row); } //-------------------------------------------- //�ন html �X StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); table.RenderControl(htw); return htw.InnerWriter.ToString(); }
//顯示騷擾電話 筆數---------------------------------------------------------------- private string GetRptHead3() { //---------------------------------------------------------------------- string[] O3 = new string[5]; O3[0] = getCnt3("猥褻"); O3[1] = getCnt3("攻擊"); O3[2] = getCnt3("沉默"); O3[3] = getCnt3("精神錯亂"); O3[4] = getCnt3("其他"); int sum = int.Parse(O3[0]) + int.Parse(O3[1]) + int.Parse(O3[2]) + int.Parse(O3[3]) + int.Parse(O3[4]); //設定框架---------------------------------------------------------------------- string strTemp = ""; HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; string strColor = "BLACK"; string FontSize = "14px"; table.Border = 0; table.CellPadding = 0; table.CellSpacing = 0; table.Align = "center"; css = table.Style; css.Add("font-size", "12px"); css.Add("font-family", "標楷體"); css.Add("width", "100%"); //---------------------------------------------------------- if (sum != 0) { row = new HtmlTableRow(); cell = new HtmlTableCell(); strTemp = "騷擾電話"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "28px"); css.Add("font-family", "標楷體"); css.Add("border-style", "none"); cell.ColSpan = 2; row.Cells.Add(cell); table.Rows.Add(row); } ///////////////////////////////////////// 第一行 by apple ////////////////////////////////////////////////////////////////// //猥褻O3[0]---------------------------------------------------------- row = new HtmlTableRow(); if (int.Parse(O3[0]) != 0) { cell = new HtmlTableCell(); strTemp = "猥褻"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 1234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //攻擊O3[1]---------------------------------------------------------------- if (int.Parse(O3[1]) != 0) { cell = new HtmlTableCell(); strTemp = "攻擊"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //沉默O3[2]---------------------------------------------------------------- if (int.Parse(O3[2]) != 0) { cell = new HtmlTableCell(); strTemp = "沉默"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //精神錯亂O3[3]---------------------------------------------------------------- if (int.Parse(O3[3]) != 0) { cell = new HtmlTableCell(); strTemp = "精神錯亂"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //其他O3[4]---------------------------------------------------------------- if (int.Parse(O3[4]) != 0) { cell = new HtmlTableCell(); strTemp = "其他"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //---------------- table.Rows.Add(row); ///////////////////////////////////////// 第二行by apple ////////////////////////////////////////////////////////////////// //猥褻O3[0]---------------------------------------------------------- row = new HtmlTableRow(); if (int.Parse(O3[0]) != 0) { cell = new HtmlTableCell(); strTemp = O3[0]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 134, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //攻擊O3[1]---------------------------------------------------------------- if (int.Parse(O3[1]) != 0) { cell = new HtmlTableCell(); strTemp = O3[1]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //沉默O3[2]---------------------------------------------------------------- if (int.Parse(O3[2]) != 0) { cell = new HtmlTableCell(); strTemp = O3[2]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "150px"); row.Cells.Add(cell); } //精神錯亂O3[3]---------------------------------------------------------------- if (int.Parse(O3[3]) != 0) { cell = new HtmlTableCell(); strTemp = O3[3]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //其他O3[4]---------------------------------------------------------------- if (int.Parse(O3[4]) != 0) { cell = new HtmlTableCell(); strTemp = O3[4]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //---------------- table.Rows.Add(row); //************************************* //轉成 html 碼 StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); table.RenderControl(htw); return htw.InnerWriter.ToString(); }
// 報表************************************************************************************************************************ private string GetReport() { HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); //table.Border = 0; //table.BorderColor = "black"; //table.CellPadding = 0; //table.CellSpacing = 0; //table.Align = "center"; //css = table.Style; //css.Add("font-size", "32pt"); //css.Add("font-family", "標楷體"); //css.Add("width", "900px"); //-------------------------------------------- DataTable dt = GetDataTable(); if (dt.Rows.Count == 0) { lblReport.Text = ""; ShowSysMsg("查無資料"); return ""; } foreach (DataRow dr in dt.Rows) { string strFontSize = "16px"; table = new HtmlTable(); table.Border = 1; table.BorderColor = "black"; table.CellPadding = 0; table.CellSpacing = 0; table.Align = "center"; css = table.Style; css.Add("font-size", strFontSize); css.Add("font-family", "標楷體"); css.Add("width", "900px"); string strColor = "lightgrey"; //字的顏色 string strBackGround = "darkseagreen"; //cell 顏色 string strMarkColor = "'background-color:'''"; // 字的底色 string strMemberColor = "color:crimson"; //聯絡人的字顏色 string strWeight = "bold"; //字體 string strHeight = "20px";//欄高 row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("font-weight", strWeight); css.Add("height", "20px"); Util.AddTDLine(css, 123, strColor); cell.InnerHtml = "1.電話:<span style= " + strMemberColor + " >" + dr["Phone"].ToString() + "</span>";// font-weight:bold; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("font-weight", strWeight); Util.AddTDLine(css, 23, strColor); cell.InnerHtml = "4.年齡約:<span style=" + strMemberColor + "> " + dr["age"].ToString() + "</span>"; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("font-weight", strWeight); Util.AddTDLine(css, 23, strColor); cell.InnerHtml = "7.轉介教會:<span style=" + strMemberColor + ">" + dr["ChurchYN"].ToString() + "</span>"; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("font-weight", strWeight); css.Add("height", "25px"); Util.AddTDLine(css, 123, strColor); cell.InnerHtml = "2.姓名:<span style=" + strMemberColor + " >" + dr["Cname"].ToString() + "</span> "; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("font-weight", strWeight); Util.AddTDLine(css, 23, strColor); cell.InnerHtml = "5.婚姻:<span style=" + strMemberColor + " >" + Util.TrimLastChar(dr["Marry"].ToString(), ',') + "</span> "; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("font-weight", strWeight); Util.AddTDLine(css, 23, strColor); cell.RowSpan = 2; //cell.ColSpan = 2; if (dr["FullAddress"].ToString() != "") { cell.InnerHtml = "8.地址:<span style=" + strMemberColor + " >" + dr["FullAddress"].ToString() + "</span> "; } else { cell.InnerHtml = "8.地址:<span style=" + strMemberColor + " >" + dr["Overseas"].ToString().TrimEnd(',') + "</span> "; } row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("font-weight", strWeight); css.Add("height", "30px"); Util.AddTDLine(css, 123, strColor); cell.InnerHtml = "3.性別:<span style=" + strMemberColor + " >" + dr["Sex"].ToString() + "</span>"; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("font-weight", strWeight); Util.AddTDLine(css, 23, strColor); cell.InnerHtml = "6.基督徒:<span style=" + strMemberColor + " >" + dr["Christian"].ToString() + "</span>"; row.Cells.Add(cell); table.Rows.Add(row); //table.RenderControl(htw); //table = new HtmlTable(); //table.Border = 0; //table.BorderColor = "black"; //table.CellPadding = 0; //table.CellSpacing = 0; //table.Align = "center"; //css = table.Style; //css.Add("font-size", strFontSize); //css.Add("font-family", "標楷體"); //css.Add("width", "900px"); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("font-weight", strWeight); Util.AddTDLine(css, 123, strColor); cell.ColSpan = 3; cell.InnerHtml = "備註:<span style=" + strMemberColor + " >" + dr["M_Memo"].ToString() + "</span>"; row.Cells.Add(cell); table.Rows.Add(row); table.RenderControl(htw); table = new HtmlTable(); table.Border = 0; table.BorderColor = "black"; table.CellPadding = 0; table.CellSpacing = 0; table.Align = "center"; css = table.Style; css.Add("font-size", strFontSize); css.Add("font-family", "標楷體"); css.Add("width", "900px"); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("font-weight", strWeight); css.Add("height", "30px"); Util.AddTDLine(css, 123, strColor); cell.ColSpan = 1; cell.InnerHtml = "志工:<span style=color:darkseagreen >" + dr["ServiceUser"].ToString() + "</span>"; row.Cells.Add(cell); string TotalTalkTime = ""; DateTime t1, t2; if (dr["CreateDate"].ToString() != "" && dr["EndDate"].ToString() != "") { t1 = DateTime.Parse(Util.DateTime2String(dr["CreateDate"].ToString(), DateType.yyyyMMddHHmmss, EmptyType.ReturnNull)); t2 = DateTime.Parse(Util.DateTime2String(dr["EndDate"].ToString(), DateType.yyyyMMddHHmmss, EmptyType.ReturnNull)); TotalTalkTime = DateDiff(t1, t2); } cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("font-weight", strWeight); Util.AddTDLine(css, 23, strColor); cell.ColSpan = 3; cell.InnerHtml = "建檔時間:<span style=" + strMarkColor + " >" + Util.DateTime2String(dr["CreateDate"].ToString(), DateType.yyyyMMddHHmmss, EmptyType.ReturnNull) + " " + "</span> 結束時間:<span style=" + strMarkColor + " >" + Util.DateTime2String(dr["EndDate"].ToString(), DateType.yyyyMMddHHmmss, EmptyType.ReturnNull) + "</span> " + TotalTalkTime; row.Cells.Add(cell); table.Rows.Add(row); table.RenderControl(htw); table = new HtmlTable(); table.Border = 0; table.BorderColor = "black"; table.CellPadding = 0; table.CellSpacing = 0; table.Align = "center"; css = table.Style; css.Add("font-size", strFontSize); css.Add("font-family", "標楷體"); css.Add("width", "900px"); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "26px"); css.Add("background", strBackGround); Util.AddTDLine(css, 123, strColor); cell.Width = "88mm"; cell.RowSpan = 6; cell.InnerHtml = "S"; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("background", strBackGround); Util.AddTDLine(css, 23, strColor); cell.InnerHtml = "<span style=font-weight:bold>求助者的主訴(用第一人稱 '我' 敘述)</span>"; cell.ColSpan = 3; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); //css.Add("font-weight", strWeight); css.Add("height", strHeight); Util.AddTDLine(css, 23, strColor); cell.ColSpan = 3; cell.InnerHtml = "<span style=font-weight:bold>A(事件):</span>" + dr["Event"].ToString() + " "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("height", strHeight); // css.Add("font-weight", strWeight); Util.AddTDLine(css, 23, strColor); cell.InnerHtml = "<span style=font-weight:bold>B(想法):</span>" + dr["Think"].ToString() + " "; cell.ColSpan = 3; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("height", strHeight); // css.Add("font-weight", strWeight); Util.AddTDLine(css, 23, strColor); cell.InnerHtml = "<span style=font-weight:bold>C(感受):</span>" + dr["Feel"].ToString() + " "; cell.ColSpan = 3; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("height", strHeight); //css.Add("font-weight", strWeight); Util.AddTDLine(css, 23, strColor); cell.ColSpan = 3; cell.InnerHtml = "<span style=font-weight:bold>補充說明:</span>" + dr["Comment"].ToString() + " "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23, strColor); cell.ColSpan = 3; cell.InnerHtml = " "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "26px"); css.Add("background", strBackGround); Util.AddTDLine(css, 123, strColor); cell.RowSpan = 6; cell.InnerHtml = "O"; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("background", strBackGround); //css.Add("font-weight", strWeight); Util.AddTDLine(css, 23, strColor); cell.ColSpan = 3; cell.InnerHtml = "<span style=font-weight:bold>客觀分析(諮商類別)</span>"; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); // css.Add("font-weight", strWeight) css.Add("height", strHeight); ; Util.AddTDLine(css, 23, strColor); cell.ColSpan = 3; cell.InnerHtml = "<span style=font-weight:bold>來電諮詢別(大類):</span>" + Util.TrimLastChar(dr["ConsultantMain"].ToString(), ',') + " "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); // css.Add("font-weight", strWeight); css.Add("height", strHeight); Util.AddTDLine(css, 23, strColor); cell.ColSpan = 3; cell.InnerHtml = "<span style=font-weight:bold >來電諮詢別(分項):</span>" + Util.TrimLastChar(dr["ConsultantItem"].ToString(), ',') + " "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("height", strHeight); // css.Add("font-weight", strWeight); Util.AddTDLine(css, 23, strColor); cell.ColSpan = 3; if (dr["HarassOther"].ToString() != "") { cell.InnerHtml = "<span style=font-weight:bold >騷擾電話:</span>" + Util.TrimLastChar(dr["HarassPhone"].ToString().Replace("其他", ""), ',').TrimEnd(',') + "<span style=font-weight:bold >其他: </span>" + dr["HarassOther"].ToString() + " "; //cell.InnerHtml = "<span style=font-weight:bold >騷擾電話:</span>" + Util.TrimLastChar(dr["HarassPhone"].ToString(), ',') + "<span style=font-weight:bold >其他: </span>" + dr["HarassOther"].ToString() + " "; } else { cell.InnerHtml = "<span style=font-weight:bold>騷擾電話:</span>" + Util.TrimLastChar(dr["HarassPhone"].ToString(), ',') + " "; } row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23, strColor); css.Add("height", strHeight); // css.Add("font-weight", strWeight); cell.ColSpan = 3; cell.InnerHtml = "<span style= font-weight:bold>轉介單位(告知電話):</span>" + Util.TrimLastChar(dr["IntroductionUnit"].ToString(), ',') + " "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); // css.Add("font-weight", strWeight); css.Add("height", strHeight); Util.AddTDLine(css, 23, strColor); cell.ColSpan = 3; cell.InnerHtml = "<span style= font-weight:bold>緊急轉介(撥打電話):</span>" + Util.TrimLastChar(dr["CrashIntroduction"].ToString(), ',') + " "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "26px"); css.Add("background", strBackGround); css.Add("font-weight", strWeight); Util.AddTDLine(css, 123, strColor); cell.RowSpan = 2; cell.InnerHtml = "A"; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("background", strBackGround); // css.Add("font-weight", strWeight); Util.AddTDLine(css, 23, strColor); cell.ColSpan = 3; cell.InnerHtml = "<span style=font-weight:bold >問題評估</span> "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("height", strHeight); Util.AddTDLine(css, 23, strColor); cell.ColSpan = 1; cell.InnerHtml = "<span style=" + strMarkColor + " > " + dr["Problem"].ToString() + " </span> "; row.Cells.Add(cell); table.Rows.Add(row); //row = new HtmlTableRow(); //cell = new HtmlTableCell(); //css = cell.Style; //css.Add("text-align", "left"); //css.Add("font-size", strFontSize); //Util.AddTDLine(css, 23); //cell.ColSpan = 3; //cell.InnerHtml = "2.因" + dr["Reason2"].ToString() + "造成" + dr["Trouble2"].ToString() + "問題"; //row.Cells.Add(cell); //table.Rows.Add(row); //row = new HtmlTableRow(); //cell = new HtmlTableCell(); //css = cell.Style; //css.Add("text-align", "left"); //css.Add("font-size", strFontSize); //Util.AddTDLine(css, 23); //cell.ColSpan = 3; //cell.InnerHtml = "3.因" + dr["Reason3"].ToString() + "造成" + dr["Trouble3"].ToString() + "問題"; //row.Cells.Add(cell); //table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "26px"); css.Add("background", strBackGround); css.Add("height", strHeight); //css.Add("font-weight", strWeight); Util.AddTDLine(css, 1234, strColor); cell.RowSpan = 8; cell.InnerHtml = "P"; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("background", strBackGround); //css.Add("font-weight", strWeight); Util.AddTDLine(css, 23, strColor); cell.ColSpan = 3; cell.InnerHtml = "<span style= font-weight:bold>計畫</span>"; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); // css.Add("font-weight", strWeight); css.Add("height", strHeight); Util.AddTDLine(css, 23, strColor); cell.ColSpan = 3; cell.InnerHtml = "<span style=font-weight:bold >1.找出案主心中的假設:</span>" + dr["FindAssume"].ToString() + "</span> "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); //css.Add("font-weight", strWeight); css.Add("height", strHeight); Util.AddTDLine(css, 23, strColor); cell.ColSpan = 3; cell.InnerHtml = "<span style=font-weight:bold >2.與案主討論與解釋假設: </span>" + dr["Discuss"].ToString() + "</span> "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("height", strHeight); // css.Add("font-weight", strWeight); Util.AddTDLine(css, 23, strColor); cell.ColSpan = 3; cell.InnerHtml = "<span style=font-weight:bold >3.加入新的元素:</span>" + dr["Element"].ToString() + " "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("height", strHeight); //css.Add("font-weight", strWeight); Util.AddTDLine(css, 23, strColor); cell.ColSpan = 3; cell.InnerHtml = " <span style=font-weight:bold >4.改變案主原先的期待:</span>" + dr["Expect"].ToString() + " "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("height", strHeight); // css.Add("font-weight", strWeight); Util.AddTDLine(css, 23, strColor); cell.InnerHtml = " <span style=font-weight:bold >5.給予案主祝福與盼望:</span>" + dr["Blessing"].ToString() + " "; cell.ColSpan = 3; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("height", strHeight); // css.Add("font-weight", strWeight); Util.AddTDLine(css, 23, strColor); cell.ColSpan = 3; cell.InnerHtml = "<span style=font-weight:bold >6.帶領決志禱告:</span>" + dr["IntroductionChurch"].ToString() + " "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("height", strHeight); // css.Add("font-weight", strWeight); Util.AddTDLine(css, 234, strColor); cell.ColSpan = 3; cell.InnerHtml = "<span style=font-weight:bold >7.我對個案的幫助程度:</span>" + dr["HelpLvMark"].ToString() + " "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("height", strHeight); css.Add("font-size", strFontSize); //css.Add("font-weight", strWeight); Util.AddTDLine(css, 134, strColor); cell.ColSpan = 6; cell.InnerHtml = "<span style=font-weight:bold >小叮嚀:</span>" + dr["Memo"].ToString() + " "; row.Cells.Add(cell); table.Rows.Add(row); cell = new HtmlTableCell(); row = new HtmlTableRow(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); cell.InnerHtml = " <BR>"; row.Cells.Add(cell); table.Rows.Add(row); table.RenderControl(htw); } //轉成 html 碼======================================================================== return htw.InnerWriter.ToString(); }
//顯示特殊諮詢 筆數---------------------------------------------------------------- private string GetRptHead4() { //---------------------------------------------------------------------- string[] O4 = new string[3]; O4[0] = getCnt4("感恩祝福"); O4[1] = getCnt4("宗教問題"); O4[2] = getCnt4("代禱"); int sum = int.Parse(O4[0]) + int.Parse(O4[1]) + int.Parse(O4[2]); //設定框架---------------------------------------------------------------------- string strTemp = ""; HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; string strColor = "BLACK"; string FontSize = "14px"; table.Border = 0; table.CellPadding = 0; table.CellSpacing = 0; table.Align = "center"; css = table.Style; css.Add("font-size", "12px"); css.Add("font-family", "標楷體"); css.Add("width", "100%"); //---------------------------------------------------------- if (sum != 0) { row = new HtmlTableRow(); cell = new HtmlTableCell(); strTemp = "特殊諮詢"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "28px"); css.Add("font-family", "標楷體"); css.Add("border-style", "none"); cell.ColSpan = 1; row.Cells.Add(cell); table.Rows.Add(row); } ///////////////////////////////////////// 第一行 by apple ////////////////////////////////////////////////////////////////// //感恩祝福O4[0]---------------------------------------------------------- row = new HtmlTableRow(); if (int.Parse(O4[0]) != 0) { cell = new HtmlTableCell(); strTemp = "感恩祝福"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 1234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //宗教問題O4[1]---------------------------------------------------------------- if (int.Parse(O4[1]) != 0) { cell = new HtmlTableCell(); strTemp = "宗教問題"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //代禱O4[2]---------------------------------------------------------------- if (int.Parse(O4[2]) != 0) { cell = new HtmlTableCell(); strTemp = "代禱"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //---------------- table.Rows.Add(row); ///////////////////////////////////////// 第二行by apple ////////////////////////////////////////////////////////////////// //感恩祝福O4[0]---------------------------------------------------------- row = new HtmlTableRow(); if (int.Parse(O4[0]) != 0) { cell = new HtmlTableCell(); strTemp = O4[0]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 134, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //宗教問題O4[1]---------------------------------------------------------------- if (int.Parse(O4[1]) != 0) { cell = new HtmlTableCell(); strTemp = O4[1]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //代禱O4[2]---------------------------------------------------------------- if (int.Parse(O4[2]) != 0) { cell = new HtmlTableCell(); strTemp = O4[2]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "150px"); row.Cells.Add(cell); } //---------------- table.Rows.Add(row); //************************************* //轉成 html 碼 StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); table.RenderControl(htw); return htw.InnerWriter.ToString(); }
//顯示轉介單位(告知電話) 筆數-------------------------------------------------------- private string GetRptHead5() { //---------------------------------------------------------------------- string[] O5 = new string[7]; O5[0] = getCnt5("諮商協談"); O5[1] = getCnt5("未婚懷孕"); O5[2] = getCnt5("各癮症"); O5[3] = getCnt5("社會福利"); O5[4] = getCnt5("法律諮商"); O5[5] = getCnt5("精神醫療"); O5[6] = getCnt5("性問題"); int sum = int.Parse(O5[0]) + int.Parse(O5[1]) + int.Parse(O5[2]) + int.Parse(O5[3]) + int.Parse(O5[4]) + int.Parse(O5[5]) + int.Parse(O5[6]); //設定框架---------------------------------------------------------------------- string strTemp = ""; HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; string strColor = "BLACK"; string FontSize = "14px"; table.Border = 0; table.CellPadding = 0; table.CellSpacing = 0; table.Align = "center"; css = table.Style; css.Add("font-size", "12px"); css.Add("font-family", "標楷體"); css.Add("width", "100%"); //---------------------------------------------------------- if (sum != 0) { row = new HtmlTableRow(); cell = new HtmlTableCell(); strTemp = "轉介單位(告知電話)"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "28px"); css.Add("font-family", "標楷體"); css.Add("border-style", "none"); cell.ColSpan = 2; row.Cells.Add(cell); table.Rows.Add(row); } ///////////////////////////////////////// 第一行 by apple ////////////////////////////////////////////////////////////////// //諮商協談O5[0]---------------------------------------------------------- row = new HtmlTableRow(); if (int.Parse(O5[0]) != 0) { cell = new HtmlTableCell(); strTemp = "諮商協談"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 1234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //未婚懷孕O5[1]---------------------------------------------------------------- if (int.Parse(O5[1]) != 0) { cell = new HtmlTableCell(); strTemp = "未婚懷孕"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //各癮症O5[2]---------------------------------------------------------------- if (int.Parse(O5[2]) != 0) { cell = new HtmlTableCell(); strTemp = "各癮症"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //社會福利O5[3]---------------------------------------------------------------- if (int.Parse(O5[3]) != 0) { cell = new HtmlTableCell(); strTemp = "社會福利"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //法律諮商O5[4]---------------------------------------------------------------- if (int.Parse(O5[4]) != 0) { cell = new HtmlTableCell(); strTemp = "法律諮商"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //精神醫療O5[5]---------------------------------------------------------------- if (int.Parse(O5[5]) != 0) { cell = new HtmlTableCell(); strTemp = "精神醫療"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //性問題O5[6]---------------------------------------------------------------- if (int.Parse(O5[6]) != 0) { cell = new HtmlTableCell(); strTemp = "性問題"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //---------------- table.Rows.Add(row); ///////////////////////////////////////// 第二行by apple ////////////////////////////////////////////////////////////////// //諮商協談O5[0]---------------------------------------------------------- row = new HtmlTableRow(); if (int.Parse(O5[0]) != 0) { cell = new HtmlTableCell(); strTemp = O5[0]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 134, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //未婚懷孕O5[1]---------------------------------------------------------------- if (int.Parse(O5[1]) != 0) { cell = new HtmlTableCell(); strTemp = O5[1]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //各癮症O5[2]---------------------------------------------------------------- if (int.Parse(O5[2]) != 0) { cell = new HtmlTableCell(); strTemp = O5[2]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "150px"); row.Cells.Add(cell); } //社會福利O5[3]---------------------------------------------------------------- if (int.Parse(O5[3]) != 0) { cell = new HtmlTableCell(); strTemp = O5[3]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //法律諮商O5[4]---------------------------------------------------------------- if (int.Parse(O5[4]) != 0) { cell = new HtmlTableCell(); strTemp = O5[4]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //精神醫療O5[5]---------------------------------------------------------------- if (int.Parse(O5[5]) != 0) { cell = new HtmlTableCell(); strTemp = O5[5]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //性問題O5[6]---------------------------------------------------------------- if (int.Parse(O5[6]) != 0) { cell = new HtmlTableCell(); strTemp = O5[6]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //---------------- table.Rows.Add(row); //************************************* //轉成 html 碼 StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); table.RenderControl(htw); return htw.InnerWriter.ToString(); }
private string GetRptHead() { string strTemp = ""; HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; string FontSize = "14px"; table.Border = 0; table.CellPadding = 0; table.CellSpacing = 0; table.Align = "center"; css = table.Style; css.Add("font-size", "12px"); css.Add("font-family", "標楷體"); css.Add("width", "100%"); //**************************************** row = new HtmlTableRow(); cell = new HtmlTableCell(); //查詢城市代碼名稱 DataTable dt = GetDataTable(); foreach (DataRow dr in dt.Rows) { string city = dr["城市"].ToString(); strTemp = city+ "分布表"; } cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; //教會跨行置中 cell.ColSpan = 7; css.Add("text-align", "center"); css.Add("font-size", "24px"); css.Add("font-family", "標楷體"); css.Add("border-style", "none"); css.Add("font-weight", "bold"); row.Cells.Add(cell); table.Rows.Add(row); //************************************* //轉成 html 碼 StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); table.RenderControl(htw); return htw.InnerWriter.ToString(); }
//顯示緊急單位(撥打電話) 筆數-------------------------------------------------------- private string GetRptHead6() { //---------------------------------------------------------------------- string[] O6 = new string[8]; O6[0] = getCnt6("自殺"); O6[1] = getCnt6("企圖自殺"); O6[2] = getCnt6("緊急求救"); O6[3] = getCnt6("暴力"); O6[4] = getCnt6("隱症"); O6[5] = getCnt6("性侵"); O6[6] = getCnt6("身心疾病"); O6[7] = getCnt6("求助"); int sum = int.Parse(O6[0]) + int.Parse(O6[1]) + int.Parse(O6[2]) + int.Parse(O6[3]) + int.Parse(O6[4]) + int.Parse(O6[5]) + int.Parse(O6[6]) + int.Parse(O6[7]); //設定框架---------------------------------------------------------------------- string strTemp = ""; HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; string strColor = "BLACK"; string FontSize = "14px"; table.Border = 0; table.CellPadding = 0; table.CellSpacing = 0; table.Align = "center"; css = table.Style; css.Add("font-size", "12px"); css.Add("font-family", "標楷體"); css.Add("width", "100%"); //---------------------------------------------------------- if (sum != 0) { row = new HtmlTableRow(); cell = new HtmlTableCell(); strTemp = "緊急單位(撥打電話)"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "28px"); css.Add("font-family", "標楷體"); css.Add("border-style", "none"); cell.ColSpan = 2; row.Cells.Add(cell); table.Rows.Add(row); } ///////////////////////////////////////// 第一行 by apple ////////////////////////////////////////////////////////////////// //自殺O6[0]---------------------------------------------------------- row = new HtmlTableRow(); if (int.Parse(O6[0]) != 0) { cell = new HtmlTableCell(); strTemp = "自殺"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 1234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //企圖自殺O6[1]---------------------------------------------------------------- if (int.Parse(O6[1]) != 0) { cell = new HtmlTableCell(); strTemp = "企圖自殺"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //緊急求救O6[2]---------------------------------------------------------------- if (int.Parse(O6[2]) != 0) { cell = new HtmlTableCell(); strTemp = "緊急求救"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //暴力O6[3]---------------------------------------------------------------- if (int.Parse(O6[3]) != 0) { cell = new HtmlTableCell(); strTemp = "暴力"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //隱症O6[4]---------------------------------------------------------------- if (int.Parse(O6[4]) != 0) { cell = new HtmlTableCell(); strTemp = "隱症"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //性侵O6[5]---------------------------------------------------------------- if (int.Parse(O6[5]) != 0) { cell = new HtmlTableCell(); strTemp = "性侵"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //身心疾病O6[6]---------------------------------------------------------------- if (int.Parse(O6[6]) != 0) { cell = new HtmlTableCell(); strTemp = "身心疾病"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //求助O6[7]---------------------------------------------------------------- if (int.Parse(O6[7]) != 0) { cell = new HtmlTableCell(); strTemp = "求助"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 234, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //---------------- table.Rows.Add(row); ///////////////////////////////////////// 第二行by apple ////////////////////////////////////////////////////////////////// //自殺O6[0]---------------------------------------------------------- row = new HtmlTableRow(); if (int.Parse(O6[0]) != 0) { cell = new HtmlTableCell(); strTemp = O6[0]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 134, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //企圖自殺O6[1]---------------------------------------------------------------- if (int.Parse(O6[1]) != 0) { cell = new HtmlTableCell(); strTemp = O6[1]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //緊急求助O6[2]---------------------------------------------------------------- if (int.Parse(O6[2]) != 0) { cell = new HtmlTableCell(); strTemp = O6[2]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "150px"); row.Cells.Add(cell); } //暴力O6[3]---------------------------------------------------------------- if (int.Parse(O6[3]) != 0) { cell = new HtmlTableCell(); strTemp = O6[3]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //隱症O6[4]---------------------------------------------------------------- if (int.Parse(O6[4]) != 0) { cell = new HtmlTableCell(); strTemp = O6[4]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //性侵O6[5]---------------------------------------------------------------- if (int.Parse(O6[5]) != 0) { cell = new HtmlTableCell(); strTemp = O6[5]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //身心疾病O6[6]---------------------------------------------------------------- if (int.Parse(O6[6]) != 0) { cell = new HtmlTableCell(); strTemp = O6[6]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //求助O6[7]---------------------------------------------------------------- if (int.Parse(O6[7]) != 0) { cell = new HtmlTableCell(); strTemp = O6[7]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); Util.AddTDLine(css, 34, strColor); css.Add("width", "130px"); row.Cells.Add(cell); } //---------------- table.Rows.Add(row); //************************************* //轉成 html 碼 StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); table.RenderControl(htw); return htw.InnerWriter.ToString(); }
private string GetReport() { string[] Items = { "�B�e", "�B��", "���", "�ˤl", "���ծa�x", "�j�N�a�x", "�q�B�a�x", "�����a�x", "���~���D", "�Ѧ~���D" }; //�� table string strTemp = ""; HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; table.Border = 0; table.BorderColor = "black"; table.CellPadding = 0; table.CellSpacing = 0; table.Align = "center"; css = table.Style; css.Add("font-size", "12pt"); css.Add("font-family", "�з���"); css.Add("width", "800px"); //��1�� row = new HtmlTableRow(); for (int i = 0; i < Items.Length; i++) { cell = new HtmlTableCell(); strTemp = Items[i].ToString(); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "25px"); //���Y�r���j�p if (i == 0) { Util.AddTDLine(css, 1234); } if (i == 1) { Util.AddTDLine(css, 234); } if (i == 2) { Util.AddTDLine(css, 234); } if (i == 3) { Util.AddTDLine(css, 234); } if (i == 4) { Util.AddTDLine(css, 234); } if (i == 5) { Util.AddTDLine(css, 234); } if (i == 6) { Util.AddTDLine(css, 234); } if (i == 7) { Util.AddTDLine(css, 234); } if (i == 8) { Util.AddTDLine(css, 234); } if (i == 9) { Util.AddTDLine(css, 234); } if (i == 10) { Util.AddTDLine(css, 234); } if (i == 11) { Util.AddTDLine(css, 234); } if (i == 12) { Util.AddTDLine(css, 234); } row.Cells.Add(cell); } cell = new HtmlTableCell(); string strTemp1 = "";// "" + strTitle + ""; cell.InnerHtml = strTemp1; css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", "12px"); cell.Width = "8"; row.Cells.Add(cell); table.Rows.Add(row); //-------------------------------------------- //��2��,������ //*********�Ĥ@��********* string strFontSize = "18px"; row = new HtmlTableRow(); cell = new HtmlTableCell(); //------------------------------------------------------------- Yvalue[0] = int.Parse(getConsultant("�B�e", ddlYear.SelectedValue.ToString(), "�j��")); Yvalue[1] = int.Parse(getConsultant("�B��", ddlYear.SelectedValue.ToString(), "�j��")); Yvalue[2] = int.Parse(getConsultant("���", ddlYear.SelectedValue.ToString(), "�j��")); Yvalue[3] = int.Parse(getConsultant("�ˤl", ddlYear.SelectedValue.ToString(), "�j��")); Yvalue[4] = int.Parse(getConsultant("���ծa�x", ddlYear.SelectedValue.ToString(), "�j��")); Yvalue[5] = int.Parse(getConsultant("�j�N�a�x", ddlYear.SelectedValue.ToString(), "�j��")); Yvalue[6] = int.Parse(getConsultant("�q�B�a�x", ddlYear.SelectedValue.ToString(), "�j��")); Yvalue[7] = int.Parse(getConsultant("�����a�x", ddlYear.SelectedValue.ToString(), "�j��")); Yvalue[8] = int.Parse(getConsultant("���~���D", ddlYear.SelectedValue.ToString(), "�j��")); Yvalue[9] = int.Parse(getConsultant("�Ѧ~���D", ddlYear.SelectedValue.ToString(), "�j��")); //Yvalue[10] = int.Parse(getConsultant("�g��", ddlYear.SelectedValue.ToString(), "����")); //Yvalue[11] = int.Parse(getConsultant("����", ddlYear.SelectedValue.ToString(), "����")); //Yvalue[12] = int.Parse(getConsultant("�H��", ddlYear.SelectedValue.ToString(), "����")); //Yvalue[13] = int.Parse(getConsultant("�H��", ddlYear.SelectedValue.ToString(), "����")); //Yvalue[14] = int.Parse(getConsultant("�C�@", ddlYear.SelectedValue.ToString(), "����")); //Yvalue[15] = int.Parse(getConsultant("�o�[", ddlYear.SelectedValue.ToString(), "����")); //Yvalue[16] = int.Parse(getConsultant("�⨬", ddlYear.SelectedValue.ToString(), "����")); //Yvalue[17] = int.Parse(getConsultant("¾��", ddlYear.SelectedValue.ToString(), "����")); //Yvalue[18] = int.Parse(getConsultant("�з|", ddlYear.SelectedValue.ToString(), "����")); //Yvalue[19] = int.Parse(getConsultant("���q", ddlYear.SelectedValue.ToString(), "����")); //Yvalue[20] = int.Parse(getConsultant("�ʥͬ�", ddlYear.SelectedValue.ToString(), "����")); //Yvalue[21] = int.Parse(getConsultant("�믫�e�f", ddlYear.SelectedValue.ToString(), "����")); //Yvalue[22] = int.Parse(getConsultant("����e�f", ddlYear.SelectedValue.ToString(), "����")); //Yvalue[23] = int.Parse(getConsultant("�ө�", ddlYear.SelectedValue.ToString(), "����")); //Yvalue[24] = int.Parse(getConsultant("�~�J", ddlYear.SelectedValue.ToString(), "����")); //Yvalue[25] = int.Parse(getConsultant("�ɤO", ddlYear.SelectedValue.ToString(), "����")); //Yvalue[26] = int.Parse(getConsultant("�Ш|", ddlYear.SelectedValue.ToString(), "����")); //Yvalue[27] = int.Parse(getConsultant("�Q��", ddlYear.SelectedValue.ToString(), "����")); //Yvalue[28] = int.Parse(getConsultant("�Ƿ~", ddlYear.SelectedValue.ToString(), "����")); //Yvalue[29] = int.Parse(getConsultant("��g", ddlYear.SelectedValue.ToString(), "����")); //Yvalue[30] = int.Parse(getConsultant("�ʧO���D", ddlYear.SelectedValue.ToString(), "����")); //--------------------------------------------------------------- css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 1234); cell.InnerHtml = Yvalue[0].ToString(); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 234); cell.InnerHtml = Yvalue[1].ToString(); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 234); cell.InnerHtml = Yvalue[2].ToString(); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("mso-number-format", "\\@"); Util.AddTDLine(css, 234); cell.InnerHtml = Yvalue[3].ToString(); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 234); cell.InnerHtml = Yvalue[4].ToString(); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("mso-number-format", "\\@"); Util.AddTDLine(css, 234); cell.InnerHtml = Yvalue[5].ToString(); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("mso-number-format", "\\@"); Util.AddTDLine(css, 234); cell.InnerHtml = Yvalue[6].ToString(); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("mso-number-format", "\\@"); Util.AddTDLine(css, 234); cell.InnerHtml = Yvalue[7].ToString(); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("mso-number-format", "\\@"); Util.AddTDLine(css, 234); cell.InnerHtml = Yvalue[8].ToString(); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("mso-number-format", "\\@"); Util.AddTDLine(css, 234); cell.InnerHtml = Yvalue[9].ToString(); row.Cells.Add(cell); table.Rows.Add(row); //-------------------------------------------- //��3��,������ row = new HtmlTableRow(); cell = new HtmlTableCell(); //�έp int sum = Yvalue[0] + Yvalue[1] + Yvalue[2] + Yvalue[3] + Yvalue[4]+ Yvalue[5] + Yvalue[6] + Yvalue[7] + Yvalue[8] + Yvalue[9]; //--------------------------------------------------------------- css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 134); if (sum != 0) { cell.InnerHtml = Math.Round(((float.Parse(Yvalue[0].ToString()) / sum) * 100), 2, MidpointRounding.AwayFromZero).ToString() + "%"; } else { cell.InnerHtml = "0%"; } row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 34); if (sum != 0) { cell.InnerHtml = Math.Round(((float.Parse(Yvalue[1].ToString()) / sum) * 100), 2, MidpointRounding.AwayFromZero).ToString() + "%"; } else { cell.InnerHtml = "0%"; } row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("mso-number-format", "\\@"); Util.AddTDLine(css, 34); if (sum != 0) { cell.InnerHtml = Math.Round(((float.Parse(Yvalue[2].ToString()) / sum) * 100), 2, MidpointRounding.AwayFromZero).ToString() + "%"; } else { cell.InnerHtml = "0%"; } row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 34); if (sum != 0) { cell.InnerHtml = Math.Round(((float.Parse(Yvalue[3].ToString()) / sum) * 100), 2, MidpointRounding.AwayFromZero).ToString() + "%"; } else { cell.InnerHtml = "0%"; } row.Cells.Add(cell); table.Rows.Add(row); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 34); if (sum != 0) { cell.InnerHtml = Math.Round(((float.Parse(Yvalue[4].ToString()) / sum) * 100), 2, MidpointRounding.AwayFromZero).ToString() + "%"; } else { cell.InnerHtml = "0%"; } row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 34); if (sum != 0) { cell.InnerHtml = Math.Round(((float.Parse(Yvalue[5].ToString()) / sum) * 100), 2, MidpointRounding.AwayFromZero).ToString() + "%"; } else { cell.InnerHtml = "0%"; } row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 34); if (sum != 0) { cell.InnerHtml = Math.Round(((float.Parse(Yvalue[6].ToString()) / sum) * 100), 2, MidpointRounding.AwayFromZero).ToString() + "%"; } else { cell.InnerHtml = "0%"; } row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 34); if (sum != 0) { cell.InnerHtml = Math.Round(((float.Parse(Yvalue[7].ToString()) / sum) * 100), 2, MidpointRounding.AwayFromZero).ToString() + "%"; } else { cell.InnerHtml = "0%"; } row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 34); if (sum != 0) { cell.InnerHtml = Math.Round(((float.Parse(Yvalue[8].ToString()) / sum) * 100), 2, MidpointRounding.AwayFromZero).ToString() + "%"; } else { cell.InnerHtml = "0%"; } row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 34); if (sum != 0) { cell.InnerHtml = Math.Round(((float.Parse(Yvalue[9].ToString()) / sum) * 100), 2, MidpointRounding.AwayFromZero).ToString() + "%"; } else { cell.InnerHtml = "0%"; } row.Cells.Add(cell); //�ন html �X StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); table.RenderControl(htw); return htw.InnerWriter.ToString(); }
private string GetRptHead() { string strTemp = ""; HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; string FontSize = "14px"; table.Border = 0; table.CellPadding = 0; table.CellSpacing = 0; table.Align = "center"; css = table.Style; css.Add("font-size", "12px"); css.Add("font-family", "�з���"); css.Add("width", "100%"); //**************************************** row = new HtmlTableRow(); cell = new HtmlTableCell(); string time = ""; string Year1 = ""; string Querter = ""; string Data = ""; if (txtBegCreateDate.Text != "" && txtEndCreateDate.Text != "") { time = txtBegCreateDate.Text + "~" + txtEndCreateDate.Text; } if (ddlYear1.SelectedValue != "") { Year1 = ddlYear1.SelectedValue; } strTemp = "���h�M�u�ӹq" + ddlYear.SelectedValue + Year1 + "�~�ײέp" + time ; if (ddlQuerter.SelectedValue != "") { Querter = ddlQuerter.SelectedValue; strTemp = "���h�M�u�ӹq" + ddlYear.SelectedValue + Year1 + "��" + Querter + "�u�~�ײέp" + time ; } cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "24px"); css.Add("font-family", "�з���"); css.Add("border-style", "none"); css.Add("font-weight", "bold"); //ColSpan���m���X�� cell.ColSpan = 5; row.Cells.Add(cell); table.Rows.Add(row); //************************************* //�ন html �X StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); table.RenderControl(htw); return htw.InnerWriter.ToString(); }
public static string GetData(long IdContrato, string Periodo) { using (EntidadesConosud dc = new EntidadesConosud()) { Dictionary <string, object> resultado = new Dictionary <string, object>(); List <InformeMapaHojasRutaTemp> datos = new List <InformeMapaHojasRutaTemp>(); List <Entidades.CabeceraHojasDeRuta> cabs = null; if (Periodo == "") { cabs = (from C in dc.CabeceraHojasDeRuta .Include("ContratoEmpresas.Empresa") .Include("ContratoEmpresas") .Include("HojasDeRuta") where (C.ContratoEmpresas.Contrato.IdContrato == IdContrato) && ((C.Periodo.Month < DateTime.Now.Month && C.Periodo.Year == DateTime.Now.Year) || (C.Periodo.Year < DateTime.Now.Year)) orderby C.Periodo ascending select C).ToList <Entidades.CabeceraHojasDeRuta>(); } else { int año = int.Parse(Periodo.Substring(3, 4)); int mes = int.Parse(Periodo.Substring(0, 2)); cabs = (from C in dc.CabeceraHojasDeRuta .Include("ContratoEmpresas.Empresa") .Include("ContratoEmpresas") .Include("HojasDeRuta") where C.ContratoEmpresas.Contrato.IdContrato == IdContrato && C.Periodo.Month == mes && C.Periodo.Year == año orderby C.Periodo ascending select C).ToList <Entidades.CabeceraHojasDeRuta>(); } foreach (var item in cabs) { InformeMapaHojasRutaTemp reg = new InformeMapaHojasRutaTemp(); reg.IdCabecera = item.IdCabeceraHojasDeRuta.ToString(); reg.Estado = item.Aprobada; reg.Empresa = item.ContratoEmpresas.Empresa.RazonSocial; reg.Periodo = string.Format("{0:MM/yyyy}", item.Periodo); if (reg.Estado == "Aprobada") { reg.EstadoValor = 0; } else { reg.EstadoValor = 1; } if (item.ContratoEmpresas.EsContratista.Value) { reg.OrdenEmpresas = 0; } else { reg.OrdenEmpresas = 1; } datos.Add(reg); string EstadoAdicional = ""; if (item.FechaAprobacion == null) { int SinDoc = (from H in item.HojasDeRuta where H.DocComentario != null && H.DocComentario.Trim() != "" select H).Count(); if (SinDoc == 0) { /// Si no tiene comentarios de pendientes y no tiene todos los items aprobados, /// entonces no se ha aprobado porque alguna de las sub contratistas /// no esta aprobada y por lo tanto no puede aprobarce esta hoja. int ItemsAprobados = item.HojasDeRuta.Where(w => w.HojaFechaAprobacion.HasValue).Count(); if (ItemsAprobados == 0) { EstadoAdicional = " (No Presentó Documentación)"; } else { List <CabeceraHojasDeRuta> cabsPeriodo = cabs.Where(w => w.Periodo == item.Periodo).ToList(); if (cabsPeriodo.Any(c => c.HojasDeRuta.Any(w => w.HojaComentario != null && w.HojaComentario.Trim() != ""))) { EstadoAdicional = " (Por pendientes de Subcontratista)"; } else { EstadoAdicional = ""; } } } else { if (item.ContratoEmpresas.EsContratista.Value) { List <CabeceraHojasDeRuta> cabsPeriodo = cabs.Where(w => w.Periodo == item.Periodo).ToList(); if (cabsPeriodo.Any(c => c.IdCabeceraHojasDeRuta != item.IdCabeceraHojasDeRuta && c.HojasDeRuta.Any(w => w.HojaComentario != null && w.HojaComentario.Trim() != ""))) { EstadoAdicional = " (Por pendientes de Subcontratista)"; } else if (cabsPeriodo.Any(c => c.IdCabeceraHojasDeRuta != item.IdCabeceraHojasDeRuta && c.HojasDeRuta.Any(w => !w.HojaFechaAprobacion.HasValue))) { EstadoAdicional = " (Por Subcontratista)"; } } } int CantComentarios = (from H in item.HojasDeRuta where H.HojaComentario != null && H.HojaComentario.Trim() != "" select H).Count(); if (CantComentarios > 0) { EstadoAdicional = " (Con Pendientes)"; } } reg.Estado += EstadoAdicional; } var ratingTypes = datos.Select(i => new { i.OrdenEmpresas, i.Empresa }).Distinct().OrderBy(i => i.OrdenEmpresas).Select(w => w.Empresa).ToArray(); var datosAgrupado = datos.GroupBy(i => i.Periodo) .Select(g => new { Periodo = g.Key, Estados = ratingTypes.GroupJoin(g, o => o, i => i.Empresa, (o, i) => i.Select(x => new { x.Estado, x.IdCabecera }).FirstOrDefault()).ToArray() }) .ToArray(); List <string> columnNames = new List <string>(); columnNames.Add("Periodo"); columnNames.AddRange(ratingTypes.ToArray()); columnNames.Add("Reporte"); HtmlTable tabla = new HtmlTable(); tabla.Attributes.Add("class", "TSunset"); tabla.Attributes.Add("cellpadding", "0"); tabla.Attributes.Add("cellspacing", "0"); tabla.Attributes.Add("width", "100%"); HtmlTableRow rowHeader = new HtmlTableRow(); // Header HtmlTableCell cellHeader = new HtmlTableCell(); //cellHeader.InnerText = "Periodo"; //rowHeader.Cells.Add(cellHeader); foreach (var item in columnNames) { cellHeader = new HtmlTableCell(); cellHeader.InnerText = item; cellHeader.Attributes.Add("class", "Theader"); rowHeader.Cells.Add(cellHeader); } tabla.Rows.Add(rowHeader); /// body foreach (var item in datosAgrupado) { rowHeader = new HtmlTableRow(); /// Columna de Periodo cellHeader = new HtmlTableCell(); cellHeader.InnerText = item.Periodo; cellHeader.Attributes.Add("class", "tdSimple"); rowHeader.Cells.Add(cellHeader); // Columnas de Empresas string idCabPrincipal = ""; for (int i = 0; i < ratingTypes.Count(); i++) { string estado = " "; string idCab = ""; if (item.Estados.Skip(i).Take(1).FirstOrDefault() != null) { estado = item.Estados.Skip(i).Take(1).FirstOrDefault().Estado; idCab = item.Estados.Skip(i).Take(1).FirstOrDefault().IdCabecera; if (i == 0) { idCabPrincipal = idCab; } } HtmlAnchor a = new HtmlAnchor(); a.InnerText = estado; a.HRef = "GestionHojadeRuta.aspx?IdCabecera=" + idCab; a.Target = "_blank"; //HttpContext.Current.Request.ApplicationPath + cellHeader = new HtmlTableCell(); cellHeader.Controls.Add(a); cellHeader.Attributes.Add("class", "tdSimple"); rowHeader.Cells.Add(cellHeader); } // Columna de Reporte Historico HtmlAnchor linkReporteMensual = new HtmlAnchor(); linkReporteMensual.InnerText = "Reporte Mensual"; linkReporteMensual.HRef = "ReporteViewerPeriodoHistorico.aspx?Id=" + idCabPrincipal + "&EsHistorico=false"; linkReporteMensual.Target = "_blank"; cellHeader = new HtmlTableCell(); cellHeader.Controls.Add(linkReporteMensual); cellHeader.Attributes.Add("class", "tdSimple"); rowHeader.Cells.Add(cellHeader); tabla.Rows.Add(rowHeader); } StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); tabla.RenderControl(htw); return(htw.InnerWriter.ToString()); } }
//------------------------------------------------------------------------------------- private string GetReport() { string[] Items = { "教會名稱", "教會地址", "教會電話", "教會Email", "主任牧師", "主任牧師電話", "主任牧師Email", "聯絡窗口", "窗口手機", "窗口Email", "教會事工", }; //組 table string strTemp = ""; HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; table.Border = 0; table.BorderColor = "black"; table.CellPadding = 0; table.CellSpacing = 0; table.Align = "center"; css = table.Style; css.Add("font-size", "12pt"); css.Add("font-family", "標楷體"); css.Add("width", "800px"); //第1行 row = new HtmlTableRow(); for (int i = 0; i < Items.Length; i++) { cell = new HtmlTableCell(); strTemp = Items[i].ToString(); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "25px"); //抬頭字型大小 if (i == 0) { Util.AddTDLine(css, 1234); } if (i == 1) { Util.AddTDLine(css, 234); } if (i == 2) { Util.AddTDLine(css, 234); } if (i == 3) { Util.AddTDLine(css, 234); } if (i == 4) { Util.AddTDLine(css, 234); } if (i == 5) { Util.AddTDLine(css, 234); } if (i == 6) { Util.AddTDLine(css, 234); } if (i == 7) { Util.AddTDLine(css, 234); } if (i == 8) { Util.AddTDLine(css, 234); } if (i == 9) { Util.AddTDLine(css, 234); } if (i == 10) { Util.AddTDLine(css, 234); } if (i == 11) { Util.AddTDLine(css, 234); } if (i == 12) { Util.AddTDLine(css, 234); } row.Cells.Add(cell); } cell = new HtmlTableCell(); string strTemp1 = "";// "" + strTitle + ""; cell.InnerHtml = strTemp1; css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", "12px"); cell.Width = "8"; row.Cells.Add(cell); table.Rows.Add(row); //-------------------------------------------- //第2行,資料顯示 //*********第一排********* string strFontSize = "18px"; row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 234); cell.InnerHtml = txtName.Text; row.Cells.Add(cell); string Address = ""; //呼叫資料庫GetDataTable DataTable dt = GetDataTable(); foreach (DataRow dr in dt.Rows) { Address = dr["City"].ToString() + dr["Area"].ToString() ; } cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 234); cell.InnerHtml = txtZipCode.Text + Address + txtAddress.Text; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("mso-number-format", "\\@"); Util.AddTDLine(css, 234); cell.InnerHtml = txtChurchPhone.Text; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 234); cell.InnerHtml = txtChurchEmail2.Text; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 234); cell.InnerHtml = txtPriest.Text; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("mso-number-format", "\\@"); Util.AddTDLine(css, 234); cell.InnerHtml = txtPriestPhone.Text; row.Cells.Add(cell); table.Rows.Add(row); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("mso-number-format", "\\@"); Util.AddTDLine(css, 234); cell.InnerHtml = txtPriestEmail.Text; row.Cells.Add(cell); table.Rows.Add(row); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 234); cell.InnerHtml = txtContact.Text; row.Cells.Add(cell); table.Rows.Add(row); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("mso-number-format", "\\@"); Util.AddTDLine(css, 234); cell.InnerHtml = txtChurchMphone.Text; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 234); cell.InnerHtml = txtChurchEmail.Text; row.Cells.Add(cell); string Mministry = ""; if (CHK_Mministry1.Checked == true) Mministry = CHK_Mministry1.Text + ","; if (CHK_Mministry2.Checked == true) Mministry += CHK_Mministry2.Text + ","; if (CHK_Mministry3.Checked == true) Mministry += CHK_Mministry3.Text + ","; if (CHK_Mministry4.Checked == true) Mministry += CHK_Mministry4.Text + ","; if (CHK_Mministry5.Checked == true) Mministry += CHK_Mministry5.Text + ","; if (CHK_Mministry6.Checked == true) Mministry += CHK_Mministry6.Text + ","; if (CHK_Mministry7.Checked == true) Mministry += "其他:("+txt_Mministry7.Text+")"; cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 234); cell.InnerHtml = Mministry; row.Cells.Add(cell); table.Rows.Add(row); //轉成 html 碼 StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); table.RenderControl(htw); return htw.InnerWriter.ToString(); }
private string PrintReportByDataTable(DataTable dt) { //組 table string strTemp = ""; HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; table.Border = 1; table.CellPadding = 3; table.CellSpacing = 0; css = table.Style; css.Add("font-size", "12px"); css.Add("font-family", "標楷體"); css.Add("width", "100%"); css.Add("line-height", "24px"); string strFontSize = "16px"; //-------------------------------------------- //第1行 row = new HtmlTableRow(); for (int i = 0; i < dt.Columns.Count; i++) { cell = new HtmlTableCell(); strTemp = dt.Columns[i].ColumnName; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("font-weight", "bold"); css.Add("vertical-align", "middle"); row.Cells.Add(cell); } table.Rows.Add(row); //-------------------------------------------- //第2行,資料顯示 foreach (DataRow dr in dt.Rows) { row = new HtmlTableRow(); for (int i = 0; i < dt.Columns.Count; i++) { string Align = "center"; cell = new HtmlTableCell(); strTemp = dr[dt.Columns[i].ColumnName].ToString(); if (strTemp.Contains("H")) { continue; } cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", Align); css.Add("font-size", strFontSize); css.Add("line-height", "24px"); if (dt.Columns[i].ColumnName == "年度") { if (strTemp == "合計") { cell.RowSpan = 2; } else { cell.RowSpan = 8; } } if (dt.Columns[i].ColumnName == "出租對象" || dt.Columns[i].ColumnName == "租金金額") { cell.RowSpan = 2; } row.Cells.Add(cell); } table.Rows.Add(row); } //-------------------------------------------- //轉成 html 碼 StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); table.RenderControl(htw); return htw.InnerWriter.ToString(); }
private string ProcessRoot(HttpListenerRequest request) { HtmlTable table = new HtmlTable { Border = 1, ID = "sessionlist", CellPadding = 2, Width = "100%" }; StringBuilder sbHtmlPageBody = _sbHtmlHeader; //Session count sbHtmlPageBody.AppendFormat("<CENTER><b><i>{0} Sessions managed by QuickFIX</b></i></CENTER><HR/>", _sessionSettings.GetSessions().Count); //session management links sbHtmlPageBody.AppendFormat(@"<CENTER><A HREF='/resetSessions{0}'>RESET</A> <A HREF='/refreshSessions'>REFRESH</A> <A HREF='/enableSessions'>ENABLE</A> <A HREF='/disableSessions'>DISABLE</A></CENTER><HR/></HEADER><BODY>", GetParameterList(request.Url.OriginalString)); HtmlTableRow row = new HtmlTableRow(); var headerRow = new HtmlTableRow(); headerRow.Cells.Add(new HtmlTableCell { InnerText = "Session", Align = "center" }); headerRow.Cells.Add(new HtmlTableCell { InnerText = "Type", Align = "center" }); headerRow.Cells.Add(new HtmlTableCell { InnerText = "Enabled", Align = "center" }); headerRow.Cells.Add(new HtmlTableCell { InnerText = "Session Time", Align = "center" }); headerRow.Cells.Add(new HtmlTableCell { InnerText = "Logged On", Align = "center" }); headerRow.Cells.Add(new HtmlTableCell { InnerText = "Next Incoming", Align = "center" }); headerRow.Cells.Add(new HtmlTableCell { InnerText = "Next Outgoing", Align = "center" }); table.Rows.Add(headerRow); foreach (SessionID session in _sessionSettings.GetSessions()) { Session sessionDetails = Session.LookupSession(session); row = new HtmlTableRow(); row.Cells.Add(new HtmlTableCell { InnerHtml = String.Format("<a href=\"session?BeginString={0}&SenderCompID={1}&TargetCompID={2}\">{0}:{1}->{2}</a>", session.BeginString, session.SenderCompID, session.TargetCompID) }); row.Cells.Add(new HtmlTableCell { InnerHtml = sessionDetails.IsInitiator ? "initiator" : "acceptor" }); row.Cells.Add(new HtmlTableCell { InnerHtml = sessionDetails.IsEnabled ? "yes" : "no" }); row.Cells.Add(new HtmlTableCell { InnerHtml = sessionDetails.IsSessionTime ? "yes" : "no" }); row.Cells.Add(new HtmlTableCell { InnerHtml = sessionDetails.IsLoggedOn ? "yes" : "no" }); row.Cells.Add(new HtmlTableCell { InnerHtml = sessionDetails.NextTargetMsgSeqNum.ToString() }); row.Cells.Add(new HtmlTableCell { InnerHtml = sessionDetails.NextSenderMsgSeqNum.ToString() }); table.Rows.Add(row); } table.Rows.Add(row); StringWriter sr = new StringWriter(); HtmlTextWriter hText = new HtmlTextWriter(sr); table.RenderControl(hText); return(sbHtmlPageBody + hText.InnerWriter.ToString()); }
// ����************************************************************************************************************************ private string GetReport() { HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); row = new HtmlTableRow(); //-------------------------------------------- DataTable dt = GetDataTable(); GetDataTableSum(); table.Align = "center"; string[] Items = new string[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { Items[i] = dt.Rows[i]["Name"].ToString(); } for (int i = 0; i < Items.Length; i++) { cell = new HtmlTableCell(); string strTemp = Items[i].ToString(); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "25px"); //���Y�r���j�p //css.Add("width", "800px"); row.Cells.Add(cell); Util.AddTDLine(css, 1234); } table.Rows.Add(row); //*********************************************** if (dt.Rows.Count == 0) { // lblReport.Text = ""; ShowSysMsg("�d�L���"); return ""; } row = new HtmlTableRow(); foreach (DataRow dr in dt.Rows) { string strFontSize = "16px"; css = table.Style; css.Add("font-size", strFontSize); css.Add("font-family", "�з���"); //css.Add("width", "900px"); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); //css.Add("font-weight", strWeight); css.Add("height", "20px"); cell.InnerHtml = dr["Cnt"].ToString(); row.Cells.Add(cell); table.Rows.Add(row); for (int i = 0; i < Items.Length; i++) { if (i == 0) { Util.AddTDLine(css, 134); } Util.AddTDLine(css, 34); } table.Rows.Add(row); } row = new HtmlTableRow(); foreach (DataRow dr in dt.Rows) { string strFontSize = "16px"; css = table.Style; css.Add("font-size", strFontSize); css.Add("font-family", "�з���"); //css.Add("width", "900px"); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); //css.Add("font-weight", strWeight); css.Add("height", "20px"); css.Add("mso-number-format", "\\@"); cell.InnerHtml = Math.Round(((float.Parse(dr["Cnt"].ToString()) / sum) * 100), 2, MidpointRounding.AwayFromZero).ToString() + "%"; //"���" = dr["Cnt"].ToString() / sum *100; row.Cells.Add(cell); table.Rows.Add(row); for (int i = 0; i < Items.Length; i++) { if (i == 0) { Util.AddTDLine(css, 134); } Util.AddTDLine(css, 34); } table.Rows.Add(row); } table.RenderControl(htw); //�ন html �X======================================================================== return htw.InnerWriter.ToString(); }
//--------------------------------------------------------------------------- public string GetTitle(string Title, int ColSpan) { //�� table string strTemp = ""; HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; table.Border = 0; table.CellPadding = 3; table.CellSpacing = 0; css = table.Style; css.Add("font-size", _titleFontSize); css.Add("font-family", _titleFontFamily); css.Add("width", "100%"); css.Add("font-weight", _titleFontWeight); //-------------------------------------------- row = new HtmlTableRow(); cell = new HtmlTableCell(); strTemp = Title; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", _titleAlign); css.Add("font-size", _titleFontSize); cell.ColSpan = ColSpan; row.Cells.Add(cell); table.Rows.Add(row); //-------------------------------------------- //�ন html �X StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); table.RenderControl(htw); return htw.InnerWriter.ToString(); }
//������Y private string GetRptHead() { string strTemp = ""; HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; string FontSize = "14px"; table.Border = 0; table.CellPadding = 0; table.CellSpacing = 0; table.Align = "center"; css = table.Style; css.Add("font-size", "12px"); css.Add("font-family", "�з���"); css.Add("width", "100%"); //**************************************** row = new HtmlTableRow(); cell = new HtmlTableCell(); strTemp = "�श�D����ЭӮײ{�p"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "24px"); css.Add("font-family", "�з���"); css.Add("border-style", "none"); css.Add("font-weight", "bold"); //ColSpan���m���X�� cell.ColSpan = 5; row.Cells.Add(cell); table.Rows.Add(row); //************************************* //�ন html �X StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); table.RenderControl(htw); return htw.InnerWriter.ToString(); }
private string GetTableA() { DataTable dt = GetDataTable(); //組 table string strTemp = ""; HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; table.Border = 0; //table.BorderColor = "black"; table.CellPadding = 0; table.CellSpacing = 0; css = table.Style; css.Add("font-size", "12px"); css.Add("font-family", "標楷體"); // css.Add("width", "0"); css.Add("line-height", LineHeight); intRow = intRow + dt.Rows.Count; //第1行 row = new HtmlTableRow(); for (int i = 0; i < Items.Length; i++) { cell = new HtmlTableCell(); strTemp = Items[i].ToString(); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; if (i == 0) { Util.AddTDLine(css, 123); } if (i == 1) { Util.AddTDLine(css, 23); } if (i == 2) { Util.AddTDLine(css, 23); } if (i == 3) { Util.AddTDLine(css, 23); } if (i == 4) { Util.AddTDLine(css, 23); } if (i == 5) { Util.AddTDLine(css, 23); } if (i == 6) { Util.AddTDLine(css, 23); } if (i == 7) { Util.AddTDLine(css, 23); } if (i == 8) { Util.AddTDLine(css, 23); } if (i == 9) { Util.AddTDLine(css, 23); } css.Add("text-align", "center"); css.Add("font-size", strFontSize); row.Cells.Add(cell); } cell = new HtmlTableCell(); string strTemp1 = "第<br>二<br>聯<br> <br> 會<br>計<br>聯<br>︵<br>此<br>聯<br>由<br>會<br>計<br>單<br>位<br>存<br>查<br>︶"; cell.InnerHtml = strTemp1; //cell.Width = "500px"; css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", "12px"); //css.Add("line-height", "20px"); //css.Add("width", "10px"); //cell.Width = "5px"; cell.RowSpan = intRow; cell.Width = "8"; row.Cells.Add(cell); table.Rows.Add(row); //-------------------------------------------- //第2行,資料顯示 foreach (DataRow dr in dt.Rows) { row = new HtmlTableRow(); for (int i = 0; i < Items.Length; i++) { string Align = "left"; cell = new HtmlTableCell(); strTemp = dr[Items[i]].ToString(); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", Align); css.Add("font-size", strFontSize); //cell.Width = "10"; if (i == 0) { Util.AddTDLine(css, 123); } if (i == 1) { Util.AddTDLine(css, 23); } if (i == 2) { Util.AddTDLine(css, 23); } if (i == 3) { Util.AddTDLine(css, 23); } if (i == 4) { Util.AddTDLine(css, 23); } if (i == 5) { Util.AddTDLine(css, 23); } if (i == 6) { Util.AddTDLine(css, 23); } if (i == 7) { Util.AddTDLine(css, 23); } if (i == 8) { Util.AddTDLine(css, 23); } if (i == 9) { Util.AddTDLine(css, 23); } row.Cells.Add(cell); } table.Rows.Add(row); } //-------------------------------------------- //table2 //組 table table.Border = 0; table.CellPadding = 3; table.CellSpacing = 0; css = table.Style; css.Add("font-size", "12px"); css.Add("font-family", "標楷體"); css.Add("width", TableWidth); // css.Add("line-height", LineHeight); row = new HtmlTableRow(); cell = new HtmlTableCell(); strTemp = "經辦單位:"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); cell.ColSpan = 2; Util.AddTDLine(css, 1234); //cell.Height = "20"; row.Cells.Add(cell); cell = new HtmlTableCell(); strTemp = "使用單位:"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 234); cell.ColSpan = 2; row.Cells.Add(cell); cell = new HtmlTableCell(); strTemp = "會 計 單 位" + "           "; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; cell.ColSpan = 6; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 234); row.Cells.Add(cell); table.Rows.Add(row); table.Border = 0; table.CellPadding = 0; table.CellSpacing = 0; css = table.Style; css.Add("font-size", "12px"); css.Add("font-family", "標楷體"); css.Add("width", TableWidth); css.Add("line-height", LineHeight); //Util.AddTDLine(css, 1234); row = new HtmlTableRow(); cell = new HtmlTableCell(); strTemp = "主管"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 134); row.Cells.Add(cell); // table.Rows.Add(row); cell = new HtmlTableCell(); strTemp = "經辦"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 34); row.Cells.Add(cell); //table.Rows.Add(row); cell = new HtmlTableCell(); strTemp = "主管"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 34); row.Cells.Add(cell); //table.Rows.Add(row); cell = new HtmlTableCell(); strTemp = "經辦"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 34); // cell.ColSpan = 3; row.Cells.Add(cell); //table.Rows.Add(row); cell = new HtmlTableCell(); strTemp = "主管"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); row.Cells.Add(cell); Util.AddTDLine(css, 34); // table.Rows.Add(row); cell = new HtmlTableCell(); strTemp = "財產登記"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 34); row.Cells.Add(cell); // table.Rows.Add(row); cell = new HtmlTableCell(); strTemp = "審核"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 34); row.Cells.Add(cell); //table.Rows.Add(row); cell = new HtmlTableCell(); strTemp = "費用編號"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 34); row.Cells.Add(cell); //table.Rows.Add(row); cell = new HtmlTableCell(); strTemp = "   "; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 34); cell.ColSpan = 2; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); for (int i = 0; i < 9; i++) { cell = new HtmlTableCell(); if (i == 7) { strTemp = "預算編號"; } else { strTemp = " "; } //strTemp = " "; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 34); if (i == 0) { Util.AddTDLine(css, 13); } if (i == 8) { cell.ColSpan = 2; } cell.Height = "20"; row.Cells.Add(cell); } table.Rows.Add(row); //轉成 html 碼 StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); table.RenderControl(htw); return htw.InnerWriter.ToString(); }
//---------------------------------------------------------------------------------------------------------- // ����************************************************************************************************************************ private string GetReport() { string[] Items = { "�P��", "�P���@", "�P���G", "�P���T", "�P���|", "�P����", "�P����", "�P����", }; //�� table string strTemp = ""; HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; table.Border = 0; table.BorderColor = "black"; table.CellPadding = 0; table.CellSpacing = 0; table.Align = "center"; css = table.Style; css.Add("font-size", "12pt"); css.Add("font-family", "�з���"); css.Add("width", "800px"); //��1�� row = new HtmlTableRow(); for (int i = 0; i < Items.Length; i++) { cell = new HtmlTableCell(); strTemp = Items[i].ToString(); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "25px"); //���Y�r���j�p if (i == 0) { Util.AddTDLine(css, 123); } if (i == 1) { Util.AddTDLine(css, 23); } if (i == 2) { Util.AddTDLine(css, 23); } if (i == 3) { Util.AddTDLine(css, 23); } if (i == 4) { Util.AddTDLine(css, 23); } if (i == 5) { Util.AddTDLine(css, 23); } if (i == 6) { Util.AddTDLine(css, 23); } if (i == 7) { Util.AddTDLine(css, 23); } if (i == 8) { Util.AddTDLine(css, 23); } if (i == 9) { Util.AddTDLine(css, 23); } row.Cells.Add(cell); } cell = new HtmlTableCell(); string strTemp1 = "";// "" + strTitle + ""; cell.InnerHtml = strTemp1; css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", "12px"); cell.Width = "8"; row.Cells.Add(cell); table.Rows.Add(row); //-------------------------------------------- //��2��,������ //*********���Z********* string strFontSize = "12px"; row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "12px"); Util.AddTDLine(css, 123); cell.InnerHtml = "���Z"; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.InnerHtml = lblMon1.Text; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.InnerHtml = lblTue1.Text; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.InnerHtml = lblWed1.Text; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.InnerHtml = lblThu1.Text; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.InnerHtml = lblFri1.Text; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.InnerHtml = lblSat1.Text; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.InnerHtml = lblSun1.Text; row.Cells.Add(cell); table.Rows.Add(row); //*********���Z********* row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "12px"); Util.AddTDLine(css, 123); cell.InnerHtml = "���Z"; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.InnerHtml = lblMon2.Text; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.InnerHtml = lblTue2.Text; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.InnerHtml = lblWed2.Text; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.InnerHtml = lblThu2.Text; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.InnerHtml = lblFri2.Text; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.InnerHtml = lblSat2.Text; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.InnerHtml = lblSun2.Text; row.Cells.Add(cell); table.Rows.Add(row); //*********�߯Z********* row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "12px"); Util.AddTDLine(css, 1234); cell.InnerHtml = "�߯Z"; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 234); cell.InnerHtml = lblMon3.Text; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 234); cell.InnerHtml = lblTue3.Text; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 234); cell.InnerHtml = lblWed3.Text; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 234); cell.InnerHtml = lblThu3.Text; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 234); cell.InnerHtml = lblFri3.Text; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 234); cell.InnerHtml = lblSat3.Text; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 234); cell.InnerHtml = lblSun3.Text; row.Cells.Add(cell); table.Rows.Add(row); //�ন html �X StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); table.RenderControl(htw); return htw.InnerWriter.ToString(); }
private string GetReport() { string[] Items = { "���~", "í�w�E�|", "���ӻE�|", "���ֶi�J�з|", "���h��", }; //�� table string strTemp = ""; HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; table.Border = 0; table.BorderColor = "black"; table.CellPadding = 0; table.CellSpacing = 0; table.Align = "center"; css = table.Style; css.Add("font-size", "12pt"); css.Add("font-family", "�з���"); css.Add("width", "800px"); //��1�� row = new HtmlTableRow(); for (int i = 0; i < Items.Length; i++) { cell = new HtmlTableCell(); strTemp = Items[i].ToString(); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "25px"); //���Y�r���j�p if (i == 0) { Util.AddTDLine(css, 1234); } if (i == 1) { Util.AddTDLine(css, 234); } if (i == 2) { Util.AddTDLine(css, 234); } if (i == 3) { Util.AddTDLine(css, 234); } if (i == 4) { Util.AddTDLine(css, 234); } if (i == 5) { Util.AddTDLine(css, 234); } if (i == 6) { Util.AddTDLine(css, 234); } if (i == 7) { Util.AddTDLine(css, 234); } if (i == 8) { Util.AddTDLine(css, 234); } if (i == 9) { Util.AddTDLine(css, 234); } if (i == 10) { Util.AddTDLine(css, 234); } if (i == 11) { Util.AddTDLine(css, 234); } if (i == 12) { Util.AddTDLine(css, 234); } row.Cells.Add(cell); } cell = new HtmlTableCell(); string strTemp1 = "";// "" + strTitle + ""; cell.InnerHtml = strTemp1; css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", "12px"); cell.Width = "8"; row.Cells.Add(cell); table.Rows.Add(row); //-------------------------------------------- //��2��,������ //*********�Ĥ@��********* string strFontSize = "18px"; row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 1234); cell.InnerHtml = LB_FollowUp1.Text; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 234); cell.InnerHtml = LB_FollowUp2.Text; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 234); cell.InnerHtml = LB_FollowUp3.Text; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("mso-number-format", "\\@"); Util.AddTDLine(css, 234); cell.InnerHtml = LB_FollowUp4.Text; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 234); cell.InnerHtml = LB_FollowUp5.Text; row.Cells.Add(cell); table.Rows.Add(row); //�ন html �X StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); table.RenderControl(htw); return htw.InnerWriter.ToString(); }
//---------------------------------------------------------------------- private string GetHtmlText(HtmlTable table) { StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); table.RenderControl(htw); return htw.InnerWriter.ToString(); }
private string GetReport() { string[] Items = { "姓名", "備註", "電話", "建檔時間", "城市", "來電諮詢別(大類)", "來電諮詢別(分項)", }; //組 table string strTemp = ""; HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; table.Border = 0; table.BorderColor = "black"; table.CellPadding = 0; table.CellSpacing = 0; table.Align = "center"; css = table.Style; css.Add("font-size", "12pt"); css.Add("font-family", "標楷體"); css.Add("width", "800px"); //第1行 row = new HtmlTableRow(); for (int i = 0; i < Items.Length; i++) { cell = new HtmlTableCell(); strTemp = Items[i].ToString(); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "25px"); //抬頭字型大小 if (i == 0) { Util.AddTDLine(css, 123); } if (i == 1) { Util.AddTDLine(css, 23); } if (i == 2) { Util.AddTDLine(css, 23); } if (i == 3) { Util.AddTDLine(css, 23); } if (i == 4) { Util.AddTDLine(css, 23); } if (i == 5) { Util.AddTDLine(css, 23); } if (i == 6) { Util.AddTDLine(css, 23); } if (i == 7) { Util.AddTDLine(css, 23); } if (i == 8) { Util.AddTDLine(css, 23); } if (i == 9) { Util.AddTDLine(css, 23); } row.Cells.Add(cell); } cell = new HtmlTableCell(); string strTemp1 = ""; cell.InnerHtml = strTemp1; css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", "12px"); cell.Width = "8"; row.Cells.Add(cell); table.Rows.Add(row); //-------------------------------------------- //第2行,資料顯示 //*********第一排********* string strFontSize = "18px"; DataTable dt = GetDataTable(); foreach (DataRow dr in dt.Rows) { row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; cell.InnerHtml = dr["姓名"].ToString(); //從GetDataTable()抓Name值 css.Add("text-align", "center"); //excel文字置中 css.Add("font-size", strFontSize); //excel文字大小 Util.AddTDLine(css, 1234); //excel 一個儲存格左(1)上(2)右(3)下(4) 框線 row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; cell.InnerHtml = dr["備註"].ToString(); css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 1234); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; cell.InnerHtml = dr["電話"].ToString(); css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 1234); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; cell.InnerHtml = dr["建檔時間"].ToString(); css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 1234); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; cell.InnerHtml = dr["城市"].ToString(); css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 1234); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; cell.InnerHtml = dr["來電諮詢別(大類)"].ToString(); css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 1234); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; cell.InnerHtml = dr["來電諮詢別(分項)"].ToString(); css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 1234); row.Cells.Add(cell); table.Rows.Add(row); } //轉成 html 碼 StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); table.RenderControl(htw); return htw.InnerWriter.ToString(); }
// 報表************************************************************************************************************************ private string GetReport() { HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; table.Border = 0; table.BorderColor = "black"; table.CellPadding = 0; table.CellSpacing = 0; table.Align = "center"; css = table.Style; css.Add("font-size", "32pt"); css.Add("font-family", "標楷體"); css.Add("width", "900px"); //-------------------------------------------- DataTable dt = GetDataTable(); foreach (DataRow dr in dt.Rows) { string strFontSize = "18px"; row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 123); cell.InnerHtml = "1.電話:" + dr["Phone"].ToString(); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.InnerHtml = "4.年齡約:" + dr["age"].ToString() + "歲"; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.InnerHtml = "7.轉介教會:" + dr["ChurchYN"].ToString(); row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 123); cell.InnerHtml = "2.姓名:" + dr["Cname"].ToString(); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.InnerHtml = "5.婚姻:" + Util.TrimLastChar(dr["Marry"].ToString(), ',') + " "; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.RowSpan = 2; //cell.ColSpan = 2; cell.InnerHtml = "8.地址:" + dr["FullAddress"].ToString(); row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 123); cell.InnerHtml = "3.性別:" + dr["Sex"].ToString(); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.InnerHtml = "6.基督徒:" + dr["ChurchYN"].ToString(); row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 123); cell.ColSpan = 2; cell.InnerHtml = "志工:" + dr["ServiceUser"].ToString(); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.ColSpan = 2; cell.InnerHtml = "建檔時間:" + Util.DateTime2String(dr["CreateDate"].ToString(), DateType.yyyyMMddHHmmss, EmptyType.ReturnNull) + " 結束時間:" + Util.DateTime2String(dr["EndDate"].ToString(), DateType.yyyyMMddHHmmss, EmptyType.ReturnNull); row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "26px"); Util.AddTDLine(css, 123); cell.RowSpan = 6; cell.InnerHtml = "S"; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.InnerHtml = "求助者的主訴(用第一人稱 '我' 敘述)"; cell.ColSpan = 3; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.ColSpan = 3; cell.InnerHtml = "A(事件):" + dr["Event"].ToString() + " "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.InnerHtml = "B(想法):" + dr["Think"].ToString() + " "; cell.ColSpan = 3; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.InnerHtml = "C(感受):" + dr["Feel"].ToString() + " "; cell.ColSpan = 3; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.ColSpan = 3; cell.InnerHtml = "補充說明:" + dr["Comment"].ToString() + " "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.ColSpan = 3; cell.InnerHtml = " "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "26px"); Util.AddTDLine(css, 123); cell.RowSpan = 6; cell.InnerHtml = "O"; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.ColSpan = 3; cell.InnerHtml = "客觀分析(諮商類別)"; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.ColSpan = 3; cell.InnerHtml = "來電諮詢別(大類):" + Util.TrimLastChar(dr["ConsultantMain"].ToString(), ',') + " "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.ColSpan = 3; cell.InnerHtml = "來電諮詢別(分項):" + Util.TrimLastChar(dr["ConsultantItem"].ToString(), ',') + " "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.ColSpan = 3; if (dr["HarassOther"].ToString() != "") { cell.InnerHtml = "騷擾電話:" + Util.TrimLastChar(dr["HarassPhone"].ToString().Replace("其他", ""), ',') + "其他" + dr["HarassOther"].ToString() + " "; } else { cell.InnerHtml = "騷擾電話:" + Util.TrimLastChar(dr["HarassPhone"].ToString(), ',') + " "; } row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.ColSpan = 3; cell.InnerHtml = "轉介單位(告知電話):" + Util.TrimLastChar(dr["IntroductionUnit"].ToString(), ',') + " "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.ColSpan = 3; cell.InnerHtml = "緊急轉介(撥打電話):" + Util.TrimLastChar(dr["CrashIntroduction"].ToString(), ',') + " "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "26px"); Util.AddTDLine(css, 123); cell.RowSpan = 4; cell.InnerHtml = "A"; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.ColSpan = 3; cell.InnerHtml = "問題評估"; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.ColSpan = 3; cell.InnerHtml = "1.因" + dr["Reason1"].ToString() + "造成" + dr["Trouble1"].ToString() + "問題"; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.ColSpan = 3; cell.InnerHtml = "2.因" + dr["Reason2"].ToString() + "造成" + dr["Trouble2"].ToString() + "問題"; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.ColSpan = 3; cell.InnerHtml = "3.因" + dr["Reason3"].ToString() + "造成" + dr["Trouble3"].ToString() + "問題"; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "26px"); Util.AddTDLine(css, 1234); cell.RowSpan = 8; cell.InnerHtml = "P"; row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.ColSpan = 3; cell.InnerHtml = "計畫"; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.ColSpan = 3; cell.InnerHtml = "1.找出案主心中的假設:" + dr["FindAssume"].ToString() + " "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.ColSpan = 3; cell.InnerHtml = "2.與案主討論與解釋假設: " + dr["Discuss"].ToString() + " "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.ColSpan = 3; cell.InnerHtml = "3.加入新的元素:" + dr["Element"].ToString() + " "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.ColSpan = 3; cell.InnerHtml = "4.改變案主原先的期待: " + dr["Expect"].ToString() + " "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.InnerHtml = "5.給予案主祝福與盼望: " + dr["Blessing"].ToString() + " "; cell.ColSpan = 3; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23); cell.ColSpan = 3; cell.InnerHtml = "6.帶領決志禱告:" + dr["IntroductionChurch"].ToString() + " "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 234); cell.ColSpan = 3; cell.InnerHtml = "7.我對個案的幫助程度:" + dr["HelpLvMark"].ToString() + " "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 134); cell.ColSpan = 6; cell.InnerHtml = "小叮嚀:" + dr["Memo"].ToString() + " "; row.Cells.Add(cell); table.Rows.Add(row); cell = new HtmlTableCell(); row = new HtmlTableRow(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); cell.InnerHtml = " <BR>"; row.Cells.Add(cell); table.Rows.Add(row); } //轉成 html 碼======================================================================== StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); table.RenderControl(htw); return htw.InnerWriter.ToString(); }
//----專線來電年度統計第二季 private string GetRptHead2() { //------------------------------------------------------------- int[] year = new int[5]; year[0] = int.Parse(getYear2("情緒", ddlYear.SelectedValue.ToString())); year[1] = int.Parse(getYear2("經濟", ddlYear.SelectedValue.ToString())); year[2] = int.Parse(getYear2("信仰", ddlYear.SelectedValue.ToString())); year[3] = int.Parse(getYear2("身體疾病", ddlYear.SelectedValue.ToString())); year[4] = int.Parse(getYear2("性生活", ddlYear.SelectedValue.ToString())); int sumyear1 = year[0] + year[1] + year[2] + year[3] + year[4]; //--------------------------------------------------------------- string strTemp = ""; HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; string strColor = "BLACK"; string FontSize = "14px"; table.Border = 0; table.CellPadding = 0; table.CellSpacing = 0; table.Align = "center"; css = table.Style; css.Add("font-size", "12px"); css.Add("font-family", "標楷體"); css.Add("width", "100%"); //**************************************** ////----------------------------------- 1 //row = new HtmlTableRow(); //cell = new HtmlTableCell(); //strTemp = "1. 第二季志工總值班人次:___人次(值班人數X每天3班次X每周五天)"; //cell.InnerHtml = strTemp == "" ? " " : strTemp; //css = cell.Style; //css.Add("text-align", "left"); //css.Add("font-size", "18px"); //css.Add("font-family", "標楷體"); //css.Add("border-style", "none"); //Util.AddTDLine(css, 1234, strColor); ////css.Add("font-weight", "bold"); //cell.ColSpan = 8; //row.Cells.Add(cell); //table.Rows.Add(row); ////----------------------------------- 2 //row = new HtmlTableRow(); //cell = new HtmlTableCell(); //strTemp = "2. 第二季值班總班數:__周*_天*_班 共___班次"; //cell.InnerHtml = strTemp == "" ? " " : strTemp; //css = cell.Style; //css.Add("text-align", "left"); //css.Add("font-size", "18px"); //css.Add("font-family", "標楷體"); //css.Add("border-style", "none"); //Util.AddTDLine(css, 134, strColor); ////css.Add("font-weight", "bold"); //cell.ColSpan = 8; //row.Cells.Add(cell); //table.Rows.Add(row); //----------------------------------- 3 row = new HtmlTableRow(); cell = new HtmlTableCell(); strTemp = "第二季總計來電數為" + sumyear1 + "通"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); //css.Add("border-style", "none"); Util.AddTDLine(css, 134, strColor); css.Add("width", "400px"); //css.Add("font-weight", "bold"); cell.ColSpan = 1; cell.RowSpan = 3; row.Cells.Add(cell); //row = new HtmlTableRow(); cell = new HtmlTableCell(); strTemp = "諮商類別:A婚姻B親屬C情緒D經濟E信仰F身心疾病G性生活"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); css.Add("border-style", "none"); Util.AddTDLine(css, 34, strColor); //css.Add("font-weight", "bold"); cell.ColSpan = 7; row.Cells.Add(cell); table.Rows.Add(row); //----------------------------------- 4.1 row = new HtmlTableRow(); cell = new HtmlTableCell(); strTemp = "A"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); //css.Add("border-style", "none"); css.Add("width", "100px"); Util.AddTDLine(css, 34, strColor); //css.Add("font-weight", "bold"); //cell.ColSpan = 7; row.Cells.Add(cell); //----------------------------------- 4.2 //row = new HtmlTableRow(); cell = new HtmlTableCell(); strTemp = "B"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); //css.Add("border-style", "none"); css.Add("width", "100px"); Util.AddTDLine(css, 34, strColor); //css.Add("font-weight", "bold"); //cell.ColSpan = 7; row.Cells.Add(cell); //----------------------------------- 4.3 //row = new HtmlTableRow(); cell = new HtmlTableCell(); strTemp = "C"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); //css.Add("border-style", "none"); css.Add("width", "100px"); Util.AddTDLine(css, 34, strColor); //css.Add("font-weight", "bold"); //cell.ColSpan = 7; row.Cells.Add(cell); //----------------------------------- 4.4 //row = new HtmlTableRow(); cell = new HtmlTableCell(); strTemp = "D"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); //css.Add("border-style", "none"); css.Add("width", "100px"); Util.AddTDLine(css, 34, strColor); //css.Add("font-weight", "bold"); //cell.ColSpan = 7; row.Cells.Add(cell); //----------------------------------- 4.5 //row = new HtmlTableRow(); cell = new HtmlTableCell(); strTemp = "E"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); //css.Add("border-style", "none"); css.Add("width", "100px"); Util.AddTDLine(css, 34, strColor); //css.Add("font-weight", "bold"); //cell.ColSpan = 7; row.Cells.Add(cell); //----------------------------------- 4.6 //row = new HtmlTableRow(); cell = new HtmlTableCell(); strTemp = "F"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); //css.Add("border-style", "none"); css.Add("width", "100px"); Util.AddTDLine(css, 34, strColor); //css.Add("font-weight", "bold"); //cell.ColSpan = 7; row.Cells.Add(cell); //----------------------------------- 4.7 //row = new HtmlTableRow(); cell = new HtmlTableCell(); strTemp = "G"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); //css.Add("border-style", "none"); css.Add("width", "100px"); Util.AddTDLine(css, 34, strColor); //css.Add("font-weight", "bold"); //cell.ColSpan = 7; row.Cells.Add(cell); table.Rows.Add(row); //----------------------------------- 5.1 row = new HtmlTableRow(); cell = new HtmlTableCell(); strTemp = "A"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); //css.Add("border-style", "none"); css.Add("width", "100px"); Util.AddTDLine(css, 34, strColor); //css.Add("font-weight", "bold"); //cell.ColSpan = 7; row.Cells.Add(cell); //----------------------------------- 5.2 //row = new HtmlTableRow(); cell = new HtmlTableCell(); strTemp = "B"; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); //css.Add("border-style", "none"); css.Add("width", "100px"); Util.AddTDLine(css, 34, strColor); //css.Add("font-weight", "bold"); //cell.ColSpan = 7; row.Cells.Add(cell); //----------------------------------- 5.3 //row = new HtmlTableRow(); cell = new HtmlTableCell(); strTemp = year[0].ToString(); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); //css.Add("border-style", "none"); css.Add("width", "100px"); Util.AddTDLine(css, 34, strColor); //css.Add("font-weight", "bold"); //cell.ColSpan = 7; row.Cells.Add(cell); //----------------------------------- 5.4 //row = new HtmlTableRow(); cell = new HtmlTableCell(); strTemp = year[1].ToString(); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); //css.Add("border-style", "none"); css.Add("width", "100px"); Util.AddTDLine(css, 34, strColor); //css.Add("font-weight", "bold"); //cell.ColSpan = 7; row.Cells.Add(cell); //----------------------------------- 5.5 //row = new HtmlTableRow(); cell = new HtmlTableCell(); strTemp = year[2].ToString(); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); //css.Add("border-style", "none"); css.Add("width", "100px"); Util.AddTDLine(css, 34, strColor); //css.Add("font-weight", "bold"); //cell.ColSpan = 7; row.Cells.Add(cell); //----------------------------------- 5.6 //row = new HtmlTableRow(); cell = new HtmlTableCell(); strTemp = year[3].ToString(); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); //css.Add("border-style", "none"); css.Add("width", "100px"); Util.AddTDLine(css, 34, strColor); //css.Add("font-weight", "bold"); //cell.ColSpan = 7; row.Cells.Add(cell); //----------------------------------- 5.7 //row = new HtmlTableRow(); cell = new HtmlTableCell(); strTemp = year[4].ToString(); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "18px"); css.Add("font-family", "標楷體"); //css.Add("border-style", "none"); css.Add("width", "100px"); Util.AddTDLine(css, 34, strColor); //css.Add("font-weight", "bold"); //cell.ColSpan = 7; row.Cells.Add(cell); table.Rows.Add(row); //************************************* //轉成 html 碼 StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); table.RenderControl(htw); return htw.InnerWriter.ToString(); }
public static void Write(DataView dataView, int[] columnIndexes, TextWriter textWriter) { var htmlTable = new HtmlTable(); htmlTable.Border = 1; htmlTable.CellPadding = 1; htmlTable.CellSpacing = 0; //Font font = DataCommander.Providers.Application.Instance.MainForm.SelectedFont; //htmlTable.Style["font-family"] = font.FontFamily.Name; //htmlTable.Style["font-size"] = font.SizeInPoints.ToString(CultureInfo.InvariantCulture) + "pt"; htmlTable.Style["font-family"] = "Tahoma"; htmlTable.Style["font-size"] = "8pt"; var row = new HtmlTableRow(); var dataTable = dataView.Table; var columns = dataTable.Columns; for (var i = 0; i < columnIndexes.Length; i++) { var cell = new HtmlTableCell("TH"); var columnIndex = columnIndexes[i]; var column = columns[columnIndex]; var columnName = column.ColumnName; string html; if (columnName.Length > 0) { columnName = columnName.Trim(); } html = !string.IsNullOrEmpty(columnName) ? HttpUtility.HtmlEncode(column.ColumnName) : HtmlEntity.NonBreakingSpace; html = "<nobr><handled>" + html + "</handled></nobr>"; cell.InnerHtml = html; row.Cells.Add(cell); } htmlTable.Rows.Add(row); var count = dataTable.Columns.Count; foreach (DataRowView dataRowView in dataView) { row = new HtmlTableRow(); for (var i = 0; i < columnIndexes.Length; i++) { var cell = new HtmlTableCell(); var columnIndex = columnIndexes[i]; var dataColumn = columns[columnIndex]; var type = (Type)dataColumn.ExtendedProperties[0]; if (type == null) { type = (Type)dataColumn.DataType; } var typeCode = Type.GetTypeCode(type); if (typeCode == TypeCode.Byte || typeCode == TypeCode.SByte || typeCode == TypeCode.Int16 || typeCode == TypeCode.Int32 || typeCode == TypeCode.Decimal || typeCode == TypeCode.Single || typeCode == TypeCode.Double) { cell.Align = "right"; } var value = dataRowView[i]; string valueStr; if (value == DBNull.Value) { valueStr = "(null)"; } else { valueStr = value.ToString().Trim(); if (valueStr.Length > 0) { if (valueStr.IndexOf('\r') >= 0 || valueStr.IndexOf('\n') >= 0) { var sb = new StringBuilder(); sb.Append("<pre>"); var s = HttpUtility.HtmlEncode(valueStr); sb.Append(s); sb.Append("</pre>"); valueStr = sb.ToString(); } else { valueStr = HttpUtility.HtmlEncode(valueStr); valueStr = "<nobr>" + valueStr + "</nobr>"; } } else { valueStr = HtmlEntity.NonBreakingSpace; } } cell.InnerHtml = valueStr; row.Cells.Add(cell); } htmlTable.Rows.Add(row); } var htmlTextWriter = new HtmlTextWriter(textWriter); htmlTable.RenderControl(htmlTextWriter); }
/// <summary> /// Renders the legeng used to signal dates which aren't valid. /// </summary> /// <param name="writer"></param> private void RenderGantLegend(HtmlTextWriter writer) { if (ShowGantLegend) { HtmlTable gantLegend = new HtmlTable(); HtmlTableRow legendRow = new HtmlTableRow(); gantLegend.Rows.Add(legendRow); string iconStyleWidth = "15px"; HtmlTableCell noValidDateIcon = new HtmlTableCell(); noValidDateIcon.Style[HtmlTextWriterStyle.BackgroundColor] = NO_VALID_DATE_COLOR; noValidDateIcon.Style[HtmlTextWriterStyle.Width] = iconStyleWidth; legendRow.Cells.Add(noValidDateIcon); HtmlTableCell noValidDateTextField = new HtmlTableCell(); noValidDateTextField.InnerText = "No Valid Dates"; legendRow.Cells.Add(noValidDateTextField); HtmlTableCell noValidStartDateIcon = new HtmlTableCell(); noValidStartDateIcon.Style[HtmlTextWriterStyle.BackgroundColor] = NO_VALID_START_DATE_COLOR; noValidStartDateIcon.Style[HtmlTextWriterStyle.Width] = iconStyleWidth; legendRow.Cells.Add(noValidStartDateIcon); HtmlTableCell noValidStartDateField = new HtmlTableCell(); noValidStartDateField.InnerText = "No Valid Start Date"; legendRow.Cells.Add(noValidStartDateField); HtmlTableCell noValidEndDateIcon = new HtmlTableCell(); noValidEndDateIcon.Style[HtmlTextWriterStyle.BackgroundColor] = NO_VALID_END_DATE_COLOR; noValidEndDateIcon.Style[HtmlTextWriterStyle.Width] = iconStyleWidth; legendRow.Cells.Add(noValidEndDateIcon); HtmlTableCell noValidEndDateField = new HtmlTableCell(); noValidEndDateField.InnerText = "No Valid End Date"; legendRow.Cells.Add(noValidEndDateField); HtmlTableCell showLabelsCell = new HtmlTableCell(); showLabelsCell.Style["width"] = iconStyleWidth; // Create a checkbox which executes inline js to show/hide labels CheckBox showHideLabelsCheckBox = new CheckBox(); showHideLabelsCheckBox.Checked = true; string inlineJSShowHideLabels = "var c = this.checked;var g=document.getElementById('" + this.ClientID + "');var gi=g.getElementsByTagName('DIV'); for(var i=0;i<gi.length;i++){ if(gi[i].className=='GantItemDescription') gi[i].style.display = c ? '' : 'none'; }"; showHideLabelsCheckBox.Attributes["onclick"] = inlineJSShowHideLabels; showLabelsCell.Controls.Add(showHideLabelsCheckBox); legendRow.Cells.Add(showLabelsCell); HtmlTableCell showLabelsText = new HtmlTableCell(); showLabelsText.InnerText = "Show Labels"; legendRow.Cells.Add(showLabelsText); foreach (HtmlTableCell cell in new HtmlTableCell[] { noValidDateTextField, noValidStartDateField, noValidEndDateField, showLabelsText }) { cell.Style["font-size"] = "8px"; cell.Style["text-align"] = "center"; } gantLegend.CellPadding = 0; gantLegend.CellSpacing = 0; gantLegend.Style[HtmlTextWriterStyle.Position] = ABSOLUTE_POSITION; gantLegend.Style[HtmlTextWriterStyle.ZIndex] = LEGEND_ZINDEX.ToString(); gantLegend.Style["width"] = "350px"; gantLegend.Style["background-color"] = "#ffffff"; gantLegend.Style["border"] = "1px solid #333333"; gantLegend.Style["height"] = "10px"; gantLegend.Style["table-layout"] = "fixed"; if (LegendPosition == GantPositioning.BottomRight) { gantLegend.Style["bottom"] = "5px"; gantLegend.Style["right"] = "5px"; } // Render Legend Table gantLegend.RenderControl(writer); } }
public static void createSummaryReport(string uftWorkingFolder, ref List <ReportMetaData> reportList) { HtmlTable table = new HtmlTable(); HtmlTableRow header = new HtmlTableRow(); HtmlTableCell h1 = new HtmlTableCell(); h1.InnerText = "Test name"; h1.Width = "100"; h1.Align = "center"; header.Cells.Add(h1); HtmlTableCell h2 = new HtmlTableCell(); h2.InnerText = "Timestamp"; h2.Width = "150"; h2.Align = "center"; header.Cells.Add(h2); HtmlTableCell h3 = new HtmlTableCell(); h3.InnerText = "Status"; h3.Width = "50"; h3.Align = "center"; header.Cells.Add(h3); /*HtmlTableCell h4 = new HtmlTableCell(); * h4.InnerText = "HTML report"; * h4.Width = "100"; * h4.Align = "center"; * header.Cells.Add(h4);*/ header.BgColor = KnownColor.Azure.ToString(); table.Rows.Add(header); //create table content foreach (ReportMetaData report in reportList) { HtmlTableRow row = new HtmlTableRow(); HtmlTableCell cell1 = new HtmlTableCell(); cell1.InnerText = getTestName(report.getDisplayName()); cell1.Align = "center"; row.Cells.Add(cell1); HtmlTableCell cell2 = new HtmlTableCell(); cell2.InnerText = report.getDateTime(); cell2.Align = "center"; row.Cells.Add(cell2); HtmlTableCell cell3 = new HtmlTableCell(); HtmlImage statusImage = new HtmlImage(); if (report.getStatus().Equals("pass")) { statusImage.Src = "https://extensionado.blob.core.windows.net/uft-extension-images/passed.png"; } else { statusImage.Src = "https://extensionado.blob.core.windows.net/uft-extension-images/failed.png"; } cell3.Align = "center"; cell3.Controls.Add(statusImage); row.Cells.Add(cell3); /*HtmlTableCell cell4 = new HtmlTableCell(); * HtmlAnchor reportLink = new HtmlAnchor(); * * reportLink.HRef = "C:\\Users\\laakso.CORPDOM\\TFS\\TFS_project\\UFTWorking\\res\\run_results.html"; //Path.GetFullPath(Resources.run_results); * reportLink.InnerText = "report"; * * cell4.Controls.Add(reportLink); * cell4.Align = "center"; * row.Cells.Add(cell4);*/ table.Rows.Add(row); } //add table to file string html; var reportMessage = new System.Text.StringBuilder(); using (var sw = new StringWriter()) { table.RenderControl(new System.Web.UI.HtmlTextWriter(sw)); html = sw.ToString(); } reportMessage.AppendFormat(html); System.IO.File.WriteAllText(uftWorkingFolder + @"\res\UFT Report", reportMessage.ToString()); }
// 報表************************************************************************************************************************ private string GetReport() { HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); DataTable dt = GetDataTable(); if (dt.Rows.Count == 0) { //lblReport.Text = ""; ShowSysMsg("查無資料"); return ""; } foreach (DataRow dr in dt.Rows) { string strFontSize = "14px"; table = new HtmlTable(); table.Border = 1; table.BorderColor = "black"; table.CellPadding = 0; table.CellSpacing = 0; table.Align = "center"; css = table.Style; css.Add("font-size", strFontSize); css.Add("font-family", "標楷體"); css.Add("width", "700px"); string strColor = "lightgrey"; //字的顏色 string strBackGround = "darkseagreen"; //cell 顏色 string strMarkColor = "'background-color:'''"; // 字的底色 string strMemberColor = "color:red"; //聯絡人的字顏色 string strDtaeColor = "color:black"; //聯絡人的字顏色 string strWeight = ""; //字體 string strHeight = "20px";//欄高 //------------------------------------------------ row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("font-weight", strWeight); css.Add("height", "20px"); Util.AddTDLine(css, 123, strColor); cell.InnerHtml = "<span style= " + strMemberColor + " >103 年 月 日</span>"; row.Cells.Add(cell); //---------------------------------------------------- row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("font-weight", strWeight); css.Add("height", "20px"); Util.AddTDLine(css, 123, strColor); cell.InnerHtml = "<span style= " + strDtaeColor + " >轉介日期:" + DateTime.Now.ToShortDateString() + "</span>";// font-weight:bold; row.Cells.Add(cell); //--------------------------------------------------- cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("font-weight", strWeight); css.Add("height", "20px"); Util.AddTDLine(css, 123, strColor); cell.InnerHtml = "<span style= " + strMemberColor + " >轉介教會:" + Name; row.Cells.Add(cell); table.Rows.Add(row); //---------------------------------------------------- row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("font-weight", strWeight); css.Add("height", "20px"); Util.AddTDLine(css, 123, strColor); cell.InnerHtml = "<span style= " + strMemberColor + " >電話:" + dr["Phone"].ToString() + "</span>";// font-weight:bold; row.Cells.Add(cell); //--------------------------------------------------- cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); // css.Add("font-weight", strWeight) css.Add("height", strHeight); ; Util.AddTDLine(css, 23, strColor); cell.InnerHtml = "<span style=" + strMemberColor + ">來電諮詢別(大類):" + Util.TrimLastChar(dr["ConsultantMain"].ToString(), ',') + " </span>"; row.Cells.Add(cell); table.Rows.Add(row); //------------------------------------------------------------------ row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("font-weight", strWeight); css.Add("height", "25px"); Util.AddTDLine(css, 123, strColor); cell.InnerHtml = "<span style=" + strMemberColor + " >姓名:" + dr["Cname"].ToString() + "</span> "; row.Cells.Add(cell); //table.Rows.Add(row); //------------------------------------------------------------------ cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); // css.Add("font-weight", strWeight); css.Add("height", strHeight); Util.AddTDLine(css, 23, strColor); cell.RowSpan = 3; cell.InnerHtml = "<span style=" + strMemberColor + " >來電諮詢別(分項):" + Util.TrimLastChar(dr["ConsultantItem"].ToString(), ',') + " </span>"; row.Cells.Add(cell); table.Rows.Add(row); //------------------------------------------------- row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("font-weight", strWeight); css.Add("height", "30px"); Util.AddTDLine(css, 123, strColor); cell.InnerHtml = "<span style=" + strMemberColor + " >性別:" + dr["Sex"].ToString() + "</span>"; row.Cells.Add(cell); table.Rows.Add(row); //------------------------------------------------------------------ row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("font-weight", strWeight); Util.AddTDLine(css, 23, strColor); cell.InnerHtml = "<span style=" + strMemberColor + " >婚姻:" + Util.TrimLastChar(dr["Marry"].ToString(), ',') + "</span> "; row.Cells.Add(cell); table.Rows.Add(row); //------------------------------------------------------------------ row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("font-weight", strWeight); Util.AddTDLine(css, 23, strColor); //cell.RowSpan = 2; cell.ColSpan = 2; if (dr["FullAddress"].ToString() != "") { cell.InnerHtml = "<span style=" + strMemberColor + " >8.地址:" + dr["FullAddress"].ToString() + "</span> "; } else { cell.InnerHtml = "<span style=" + strMemberColor + " >8.地址:" + dr["Overseas"].ToString().TrimEnd(',') + "</span> "; } row.Cells.Add(cell); table.Rows.Add(row); table.RenderControl(htw); table = new HtmlTable(); table.Border = 1; table.BorderColor = "black"; table.CellPadding = 0; table.CellSpacing = 0; table.Align = "center"; css = table.Style; css.Add("font-size", strFontSize); css.Add("font-family", "標楷體"); css.Add("width", "700px"); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("background", strBackGround); Util.AddTDLine(css, 23, strColor); cell.InnerHtml = "<span style=font-weight:bold>求助者的主訴(用第一人稱 '我' 敘述)</span>"; cell.ColSpan = 3; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); //css.Add("font-weight", strWeight); css.Add("height", strHeight); Util.AddTDLine(css, 23, strColor); cell.ColSpan = 3; cell.InnerHtml = "<span style=font-weight:bold>A(事件):</span>" + dr["Event"].ToString() + " "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("height", strHeight); // css.Add("font-weight", strWeight); Util.AddTDLine(css, 23, strColor); cell.InnerHtml = "<span style=font-weight:bold>B(想法):</span>" + dr["Think"].ToString() + " "; cell.ColSpan = 3; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("height", strHeight); // css.Add("font-weight", strWeight); Util.AddTDLine(css, 23, strColor); cell.InnerHtml = "<span style=font-weight:bold>C(感受):</span>" + dr["Feel"].ToString() + " "; cell.ColSpan = 3; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); css.Add("height", strHeight); //css.Add("font-weight", strWeight); Util.AddTDLine(css, 23, strColor); cell.ColSpan = 3; cell.InnerHtml = "<span style=font-weight:bold>補充說明:</span>" + dr["Comment"].ToString() + " "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23, strColor); cell.ColSpan = 3; cell.InnerHtml = " "; row.Cells.Add(cell); table.Rows.Add(row); table.RenderControl(htw); table = new HtmlTable(); table.Border = 1; table.BorderColor = "black"; table.CellPadding = 0; table.CellSpacing = 0; table.Align = "center"; css = table.Style; css.Add("font-size", strFontSize); css.Add("font-family", "標楷體"); css.Add("width", "700px"); row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 23, strColor); cell.ColSpan = 3; cell.InnerHtml = " 由轉介之教會填寫 (敬請一個月內回覆告知) "; row.Cells.Add(cell); table.Rows.Add(row); row = new HtmlTableRow(); cell = new HtmlTableCell(); cell.InnerHtml = " <span style=font-weight:bold >A、問題摘要: <P>"; cell.InnerHtml += " <span style=font-weight:bold >關懷簡述: : <P>"; cell.InnerHtml += " <span style=font-weight:bold >B、後續跟進: <br>"; cell.InnerHtml += " <span style=font-weight:bold >1.□受洗: <br>"; cell.InnerHtml += " <span style=font-weight:bold >2.□穩定聚會(有參加主日或其他小組聚會): <br>"; cell.InnerHtml += " <span style=font-weight:bold >3.□偶而參加聚會: <br>"; cell.InnerHtml += " <span style=font-weight:bold >4.□不肯進入教會 (原因: ) : <br>"; cell.InnerHtml += " <span style=font-weight:bold >5.□其他: <P>"; cell.InnerHtml += " <span style=font-weight:bold >C、關懷方式: <BR>"; cell.InnerHtml += " <span style=font-weight:bold >1.□進入教會的關懷系統(小組/團契等) : <P>"; cell.InnerHtml += " <span style=font-weight:bold >2.□繼續保持聯繫(電話或探訪): <br>"; cell.InnerHtml += " <span style=font-weight:bold >3.□曾經聯繫過但目前中斷,原因: <br>"; cell.InnerHtml += " <span style=font-weight:bold >4.□其他: <P>"; cell.InnerHtml += " <span style=font-weight:bold >D、建 議: <br>"; cell.InnerHtml += " <span style=font-weight:bold > <br> <br> <br>"; row.Cells.Add(cell); table.Rows.Add(row); table.RenderControl(htw); } //轉成 html 碼======================================================================== return htw.InnerWriter.ToString(); //再改就翻掉 // <table border="1" bordercolor="black" cellpadding="0" cellspacing="0" align="center" style="font-size:14px;font-family:標楷體;width:700px;"> // <tr> // <td style="text-align:left;font-size:14px;font-weight:;height:20px;border-left:1px solid lightgrey;border-top: 1px solid lightgrey;border-right:1px solid lightgrey;"><span style= color:black >轉介日期:2015/4/9</span></td> // <td style="text-align:left;font-size:14px;font-weight:;height:20px;border-left:1px solid lightgrey;border-top: 1px solid lightgrey;border-right:1px solid lightgrey;"><span style= color:red >轉介教會:士林靈糧堂</td> // </tr> // <tr> // <td style="text-align:left;font-size:14px;font-weight:;height:20px;border-left:1px solid lightgrey;border-top: 1px solid lightgrey;border-right:1px solid lightgrey;"><span style= color:red >電話:0</span></td> // <td style="text-align:left;font-size:14px;height:20px;border-top:1px solid lightgrey;border-right:1px solid lightgrey;"><span style=color:red>來電諮詢別(大類):親子 </span></td> // </tr> // <tr> // <td style="text-align:left;font-size:14px;font-weight:;height:25px;border-left:1px solid lightgrey;border-top: 1px solid lightgrey;border-right:1px solid lightgrey;"><span style=color:red >姓名:李小姐-板橋 網路電話77</span> </td> // <td style="text-align:left;font-size:14px;height:20px;border-top:1px solid lightgrey;border-right:1px solid lightgrey;" rowspan="3"><span style=color:red >來電諮詢別(分項): </span></td> // </tr> // <tr> // <td style="text-align:left;font-size:14px;font-weight:;height:30px;border-left:1px solid lightgrey;border-top: 1px solid lightgrey;border-right:1px solid lightgrey;"><span style=color:red >性別:女</span></td> // </tr> // <tr> // <td style="text-align:left;font-size:14px;font-weight:;border-top:1px solid lightgrey;border-right:1px solid lightgrey;"><span style=color:red >婚姻:已婚</span> </td> // </tr> // <tr> // <td style="text-align:left;font-size:14px;font-weight:;border-top:1px solid lightgrey;border-right:1px solid lightgrey;" colspan="2"><span style=color:red >8.地址:</span> </td> // </tr> //</table> //<table border="1" bordercolor="black" cellpadding="0" cellspacing="0" align="center" style="font-size:14px;font-family:標楷體;width:700px;"> // <tr> // <td style="text-align:center;font-size:14px;background:darkseagreen;border-top:1px solid lightgrey;border-right:1px solid lightgrey;" colspan="3"><span style=font-weight:bold>求助者的主訴(用第一人稱 '我' 敘述)</span></td> // </tr> // <tr> // <td style="text-align:left;font-size:14px;height:20px;border-top:1px solid lightgrey;border-right:1px solid lightgrey;" colspan="3"><span style=font-weight:bold>A(事件):</span>幫朋友問親子相處問題 </td> // </tr> // <tr> // <td style="text-align:left;font-size:14px;height:20px;border-top:1px solid lightgrey;border-right:1px solid lightgrey;" colspan="3"><span style=font-weight:bold>B(想法):</span> </td> // </tr> // <tr> // <td style="text-align:left;font-size:14px;height:20px;border-top:1px solid lightgrey;border-right:1px solid lightgrey;" colspan="3"><span style=font-weight:bold>C(感受):</span> </td> // </tr> // <tr> // <td style="text-align:left;font-size:14px;height:20px;border-top:1px solid lightgrey;border-right:1px solid lightgrey;" colspan="3"><span style=font-weight:bold>補充說明:</span> </td> // </tr> // <tr> // <td style="text-align:left;font-size:14px;border-top:1px solid lightgrey;border-right:1px solid lightgrey;" colspan="3"> </td> // </tr> //</table> //<table border="1" bordercolor="black" cellpadding="0" cellspacing="0" align="center" style="font-size:14px;font-family:標楷體;width:700px;"> // <tr> // <td style="text-align:center;font-size:14px;border-top:1px solid lightgrey;border-right:1px solid lightgrey;" colspan="3"> 由轉介之教會填寫 (敬請一個月內回覆告知) </td> // </tr> // <tr> // <td> <span style=font-weight:bold >A、問題摘要: <P> <span style=font-weight:bold >關懷簡述: : <P> <span style=font-weight:bold >B、後續跟進: <br> <span style=font-weight:bold >1.□受洗: <br> <span style=font-weight:bold >2.□穩定聚會(有參加主日或其他小組聚會): <br> <span style=font-weight:bold >3.□偶而參加聚會: <br> <span style=font-weight:bold >4.□不肯進入教會 (原因: ) : <br> <span style=font-weight:bold >5.□其他: <P> <span style=font-weight:bold >C、關懷方式: <BR> <span style=font-weight:bold >1.□進入教會的關懷系統(小組/團契等) : <P> <span style=font-weight:bold >2.□繼續保持聯繫(電話或探訪): <br> <span style=font-weight:bold >3.□曾經聯繫過但目前中斷,原因: <br> <span style=font-weight:bold >4.□其他: <P> <span style=font-weight:bold >D、建 議: <br> <span style=font-weight:bold > <br> <br> <br></td> // </tr> //</table> }
private string GetReport() { string[] Items = { "�з|�W��", "�ϰ�", "�з|�a�}", "�D����v", "�p�����f", "�p�����f���", "�p�����fEmail", "�[�J�ɶ�", }; //�� table string strTemp = ""; HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; table.Border = 0; table.BorderColor = "black"; table.CellPadding = 0; table.CellSpacing = 0; table.Align = "center"; css = table.Style; css.Add("font-size", "12pt"); css.Add("font-family", "�з���"); css.Add("width", "800px"); //��1�� row = new HtmlTableRow(); for (int i = 0; i < Items.Length; i++) { cell = new HtmlTableCell(); strTemp = Items[i].ToString(); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "25px"); //���Y�r���j�p if (i == 0) { Util.AddTDLine(css, 123); } if (i == 1) { Util.AddTDLine(css, 23); } if (i == 2) { Util.AddTDLine(css, 23); } if (i == 3) { Util.AddTDLine(css, 23); } if (i == 4) { Util.AddTDLine(css, 23); } if (i == 5) { Util.AddTDLine(css, 23); } if (i == 6) { Util.AddTDLine(css, 23); } if (i == 7) { Util.AddTDLine(css, 23); } if (i == 8) { Util.AddTDLine(css, 23); } if (i == 9) { Util.AddTDLine(css, 23); } row.Cells.Add(cell); } cell = new HtmlTableCell(); string strTemp1 = ""; cell.InnerHtml = strTemp1; css = cell.Style; css.Add("text-align", "left"); css.Add("font-size", "12px"); cell.Width = "8"; row.Cells.Add(cell); table.Rows.Add(row); //-------------------------------------------- //��2��,������ //*********�Ĥ@��********* string strFontSize = "18px"; DataTable dt = GetDataTable(); foreach (DataRow dr in dt.Rows) { row = new HtmlTableRow(); cell = new HtmlTableCell(); css = cell.Style; cell.InnerHtml = dr["�з|�W��"].ToString(); //�qGetDataTable()��Name�� css.Add("text-align", "center"); //excel��r�m�� css.Add("font-size", strFontSize); //excel��r�j�p Util.AddTDLine(css, 1234); //excel �@���x�s�楪(1)�W(2)�k(3)�U(4) �ؽu row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; cell.InnerHtml = dr["�ϰ�"].ToString(); css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 1234); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; cell.InnerHtml = dr["�з|�a�}"].ToString(); css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 1234); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; cell.InnerHtml = dr["�D����v"].ToString(); css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 1234); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; cell.InnerHtml = dr["�p�����f"].ToString(); css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 1234); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; cell.InnerHtml = dr["���f�q��"].ToString(); css.Add("text-align", "center"); css.Add("mso-number-format", "\\@"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 1234); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; cell.InnerHtml = dr["���fEmail"].ToString(); css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 1234); row.Cells.Add(cell); cell = new HtmlTableCell(); css = cell.Style; cell.InnerHtml = dr["�[�J�ɶ�"].ToString(); css.Add("text-align", "center"); css.Add("font-size", strFontSize); Util.AddTDLine(css, 1234); row.Cells.Add(cell); table.Rows.Add(row); } //�ন html �X StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); table.RenderControl(htw); return htw.InnerWriter.ToString(); }
private string GetRptHead() { string strTemp = ""; HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; string FontSize = "14px"; table.Border = 0; table.CellPadding = 0; table.CellSpacing = 0; table.Align = "center"; css = table.Style; css.Add("font-size", "12px"); css.Add("font-family", "標楷體"); css.Add("width", "100%"); //**************************************** row = new HtmlTableRow(); cell = new HtmlTableCell(); strTemp = " ";// "" + ddlYear.SelectedValue + "年熱線志工班表 第 " + ddlQuerter.SelectedValue + " 季 "; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", "24px"); css.Add("font-family", "標楷體"); css.Add("border-style", "none"); css.Add("font-weight", "bold"); cell.ColSpan = 8; row.Cells.Add(cell); table.Rows.Add(row); //************************************* //轉成 html 碼 StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); table.RenderControl(htw); return htw.InnerWriter.ToString(); }
//---------------------------------------------------------------------------- private string GetBody() { string strTemp = ""; HtmlTable table = new HtmlTable(); HtmlTableRow row; HtmlTableCell cell; CssStyleCollection css; table.Border = 1; table.CellPadding = 3; table.CellSpacing = 0; css = table.Style; css.Add("font-size", "24px"); css.Add("font-family", "標楷體"); css.Add("background", "#fff"); string strFontSize = "14px"; List<ControlData> list = new List<ControlData>(); list.Clear(); //------------------------------------------------------------------------ //先取得所有的 Menu List, menuList 有 Level 資訊 List<clsMenuList> menuList = new List<clsMenuList>(); GetMenuList("0", 1, menuList); HFD_TotalMenuItem.Value = menuList.Count.ToString(); //顯示內容 for (int i = 0; i < menuList.Count; i++) { string[] LevelName = { "", "", "", "" }; clsMenuList item = menuList[i]; LevelName[item.Level - 1] = item.Name; row = new HtmlTableRow(); cell = new HtmlTableCell(); strTemp = (i + 1).ToString(); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("width", "14px"); cell.Attributes.Add("id", "MenuID" + i.ToString()); cell.Attributes.Add("value", item.menuID); row.Cells.Add(cell); //共4 層 for (int j = 0; j < 4; j++) { cell = new HtmlTableCell(); strTemp = LevelName[j]; cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("width", "60px"); row.Cells.Add(cell); } //取得 Menu 權限 string strSql = " select * from AdminRight where MenuID=@MenuID and GroupID=@GroupID"; Dictionary<string, object> dict = new Dictionary<string, object>(); dict.Add("MenuID", item.menuID); dict.Add("GroupID", ddlGroup.SelectedValue); DataTable dt = NpoDB.GetDataTableS(strSql, dict); bool bAdd = false, bUpdate = false, bDelete = false, bQuery = false; bool bExamine1 = false, bExamine2 = false, bExamine3 = false; bool bPrint = false, bFocus = false; if (dt.Rows.Count > 0) { bAdd = dt.Rows[0]["_AddNew"].ToString() == "True" ? true : false; bUpdate = dt.Rows[0]["_Update"].ToString() == "True" ? true : false; bDelete = dt.Rows[0]["_Delete"].ToString() == "True" ? true : false; bQuery = dt.Rows[0]["_Query"].ToString() == "True" ? true : false; bPrint = dt.Rows[0]["_Print"].ToString() == "True" ? true : false; bFocus = dt.Rows[0]["_Focus"].ToString() == "True" ? true : false; bExamine1 = dt.Rows[0]["_Examine"].ToString() == "True" ? true : false; bExamine2 = dt.Rows[0]["_ReExamine"].ToString() == "True" ? true : false; bExamine3 = dt.Rows[0]["_Approve"].ToString() == "True" ? true : false; } //---------------------------------------------------------------------------- string strWidth = "46px"; //新 增 cell = new HtmlTableCell(); list.Clear(); list.Add(new ControlData("Checkbox", "GN_Add", "CB_ColAdd" + i.ToString(), i.ToString(), "", false, null)); list[0].Checked = bAdd; strTemp = HtmlUtil.RenderControl(list); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("width", strWidth); row.Cells.Add(cell); //修 改 cell = new HtmlTableCell(); list.Clear(); list.Add(new ControlData("Checkbox", "GN_Update", "CB_ColUpdate" + i.ToString(), i.ToString(), "", false, null)); list[0].Checked = bUpdate; strTemp = HtmlUtil.RenderControl(list); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("width", strWidth); row.Cells.Add(cell); //刪 除 Delete cell = new HtmlTableCell(); list.Clear(); list.Add(new ControlData("Checkbox", "GN_Delete", "CB_ColDelete" + i.ToString(), i.ToString(), "", false, null)); list[0].Checked = bDelete; strTemp = HtmlUtil.RenderControl(list); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("width", strWidth); row.Cells.Add(cell); //查 詢 cell = new HtmlTableCell(); list.Clear(); list.Add(new ControlData("Checkbox", "GN_Query", "CB_ColQuery" + i.ToString(), i.ToString(), "", false, null)); list[0].Checked = bQuery; strTemp = HtmlUtil.RenderControl(list); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("width", strWidth); row.Cells.Add(cell); //輸 出 cell = new HtmlTableCell(); list.Clear(); list.Add(new ControlData("Checkbox", "GN_Print", "CB_ColPrint" + i.ToString(), i.ToString(), "", false, null)); list[0].Checked = bPrint; strTemp = HtmlUtil.RenderControl(list); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("width", strWidth); row.Cells.Add(cell); //進入 cell = new HtmlTableCell(); list.Clear(); list.Add(new ControlData("Checkbox", "GN_Focus", "CB_ColFocus" + i.ToString(), i.ToString(), "", false, null)); list[0].Checked = bFocus; strTemp = HtmlUtil.RenderControl(list); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("width", strWidth); row.Cells.Add(cell); //審 核 cell = new HtmlTableCell(); list.Clear(); list.Add(new ControlData("Checkbox", "GN_Examine1", "CB_ColExamine1" + i.ToString(), i.ToString(), "", false, null)); list[0].Checked = bExamine1; strTemp = HtmlUtil.RenderControl(list); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("width", strWidth); row.Cells.Add(cell); //複 審 Examine2 cell = new HtmlTableCell(); list.Clear(); list.Add(new ControlData("Checkbox", "GN_Examine2", "CB_ColExamine2" + i.ToString(), i.ToString(), "", false, null)); list[0].Checked = bExamine2; strTemp = HtmlUtil.RenderControl(list); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("width", strWidth); row.Cells.Add(cell); //核 示 cell = new HtmlTableCell(); list.Clear(); list.Add(new ControlData("Checkbox", "GN_Examine3", "CB_ColExamine3" + i.ToString(), i.ToString(), "", false, null)); list[0].Checked = bExamine3; strTemp = HtmlUtil.RenderControl(list); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("width", strWidth); row.Cells.Add(cell); //---------------------------------------------------------------------------- //全 選 cell = new HtmlTableCell(); list.Clear(); list.Add(new ControlData("Checkbox", "GN_RowSelectAll", "CB_RowSelectAll" + i.ToString(), i.ToString(), "", false, null)); list[0].Checked = false; strTemp = HtmlUtil.RenderControl(list); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("width", "45px"); row.Cells.Add(cell); //全不選 cell = new HtmlTableCell(); list.Clear(); list.Add(new ControlData("Checkbox", "GN_RowUnSelectAll", "CB_RowUnSelectAll" + i.ToString(), i.ToString(), "", false, null)); list[0].Checked = false; strTemp = HtmlUtil.RenderControl(list); cell.InnerHtml = strTemp == "" ? " " : strTemp; css = cell.Style; css.Add("text-align", "center"); css.Add("font-size", strFontSize); css.Add("width", "45px"); row.Cells.Add(cell); table.Rows.Add(row); } //轉成 html 碼 StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); table.RenderControl(htw); return htw.InnerWriter.ToString(); }