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();
}
