/// <summary>
/// regisztrációs file elkészítése
/// </summary>
/// <param name="registrationFileNameWithPath"></param>
/// <param name="htmlContent"></param>
public void CreateRegistrationFile(string registrationFileNameWithPath, string htmlContent)
{
//using (FileStream fs = new FileStream("test.htm", FileMode.Create))
//{
// using (StreamWriter w = new StreamWriter(fs, Encoding.UTF8))
// {
// w.WriteLine("<H1>Hello</H1>");
// }
//}
try
{
Helpers.DesignByContract.Require(!String.IsNullOrEmpty(registrationFileNameWithPath), "Registration file name with path cannot be null or empty!");
System.IO.FileStream fs = new System.IO.FileStream(registrationFileNameWithPath, System.IO.FileMode.Create, System.IO.FileAccess.Write); //System.IO.FileShare.Write,
System.IO.StreamWriter streamWriter = new System.IO.StreamWriter(fs, System.Text.Encoding.GetEncoding(28592));
System.IO.StringWriter stringWriter = new System.IO.StringWriter();
stringWriter.Write(htmlContent);
System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(stringWriter);
streamWriter.WriteLine(stringWriter.ToString());
streamWriter.Close();
}
catch (Exception ex)
{
throw ex;
}
}
public static void SendTestmail(string email,
umbraco.cms.businesslogic.property.Property Property,
string fromName, string fromEmail, bool IsHtml)
{
// version
string version = Property.VersionId.ToString();
// Get document
umbraco.cms.businesslogic.web.Document d = new umbraco.cms.businesslogic.web.Document(umbraco.cms.businesslogic.Content.GetContentFromVersion(Property.VersionId).Id);
System.Web.HttpContext.Current.Items["pageID"] = d.Id;
// Format mail
string subject = d.Text;
string sender = "\"" + fromName + "\" <" + fromEmail + ">";
// Get template
System.Text.StringBuilder sb = new System.Text.StringBuilder();
System.IO.StringWriter sw = new StringWriter(sb);
System.Web.UI.HtmlTextWriter writer = new System.Web.UI.HtmlTextWriter(sw);
umbraco.template t = new template(d.Template);
t.ParseWithControls(new umbraco.page(d.Id, d.Version)).RenderControl(writer);
// Embedded emails ;) added by DB, 2005-10-04
EmailMessage message = mailerHelper.CreateEmbeddedEmail(sb.ToString(), Cms.BusinessLogic.web.Document.GetContentFromVersion(Property.VersionId).Id);
message.FromAddress = new EmailAddress(fromEmail, fromName);
message.ToAddresses.Add(new EmailAddress(email));
message.Subject = subject;
message.Send(new SmtpServer(GlobalSettings.SmtpServer));
}
/// <summary>
/// 把DataTable内容导出伟excel并返回客户端
/// </summary>
/// <param name="dgData">待导出的DataTable</param>
/// 创 建 人：陈文凯
/// 创建日期：2005年10月08日
/// 修 改 人：
/// 修改日期：
public static void DataTable2Excel(System.Data.DataTable dtData)
{
System.Web.UI.WebControls.DataGrid dgExport = null;
// 当前对话
System.Web.HttpContext curContext = System.Web.HttpContext.Current;
// IO用于导出并返回excel文件
System.IO.StringWriter strWriter = null;
System.Web.UI.HtmlTextWriter htmlWriter = null;
if (dtData != null)
{
// 设置编码和附件格式
curContext.Response.ContentType = "application/vnd.ms-excel";
curContext.Response.ContentEncoding =System.Text.Encoding.UTF8;
curContext.Response.Charset = "";
// 导出excel文件
strWriter = new System.IO.StringWriter();
htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);
// 为了解决dgData中可能进行了分页的情况，需要重新定义一个无分页的DataGrid
dgExport = new System.Web.UI.WebControls.DataGrid();
dgExport.DataSource = dtData.DefaultView;
dgExport.AllowPaging = false;
dgExport.DataBind();
// 返回客户端
dgExport.RenderControl(htmlWriter);
curContext.Response.Write(strWriter.ToString());
curContext.Response.End();
}
}
public static System.IO.StringWriter CreateExcel_HTML(
DataTable Dt
, ClsExcel_Columns Columns)
{
System.IO.StringWriter Sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter Htw = new System.Web.UI.HtmlTextWriter(Sw);
System.Web.UI.WebControls.Table Tb = new System.Web.UI.WebControls.Table();
System.Web.UI.WebControls.TableRow Tbr_Header = new System.Web.UI.WebControls.TableRow();
foreach (ClsExcel_Columns.Str_Columns? Obj in Columns.pObj)
{
System.Web.UI.WebControls.TableCell Tbc = new System.Web.UI.WebControls.TableCell();
Tbc.Text = Obj.Value.FieldDesc;
Tbc.Width = Obj.Value.Width;
Tbr_Header.Cells.Add(Tbc);
}
Tb.Rows.Add(Tbr_Header);
foreach (DataRow Dr in Dt.Rows)
{
System.Web.UI.WebControls.TableRow Tbr = new System.Web.UI.WebControls.TableRow();
foreach (ClsExcel_Columns.Str_Columns? Obj in Columns.pObj)
{
System.Web.UI.WebControls.TableCell Tbc = new System.Web.UI.WebControls.TableCell();
Tbc.Text = Dr[Obj.Value.FieldName].ToString();
Tbr.Cells.Add(Tbc);
}
Tb.Rows.Add(Tbr);
}
Tb.RenderControl(Htw);
return Sw;
}
public override void WriteHtml(HtmlWriter w)
{
base.WriteHtml(w);
HtmlSerializeHelper<HtmlSimpleQuestion>.WriteRootElementAttributes(w, this);
w.AddAttribute(HtmlAttribute.Name, Control.SingleCase ? "gen:single" : "gen:multy");
w.RenderBeginTag(HtmlTag.Div);
w.RenderBeginTag(HtmlTag.P);
w.Write(Control.Question.HttpEncode());
w.RenderEndTag();
foreach (var tb in Control.textBoxesList)
{
w.AddAttribute(HtmlAttribute.Type, Control.SingleCase ? "radio" : "checkbox");
if (Control.SingleCase)
w.AddAttribute(HtmlAttribute.Name, Name);
w.RenderBeginTag(HtmlTag.Input);
w.RenderEndTag();
w.RenderBeginTag(HtmlTag.Span);
w.Write(tb.Text.HttpEncode());
w.RenderEndTag();
w.RenderBeginTag(HtmlTag.Br);
w.RenderEndTag();
}
w.RenderEndTag();
}
private string GetMarkup()
{
string text;
// optimize for literal content
if (Controls.Count == 1 && Controls[0] is LiteralControl)
text = ((System.Web.UI.LiteralControl)Controls[0]).Text;
else
{
StringBuilder builder = new StringBuilder();
using (TextWriter textWriter = new StringWriter(builder))
{
using (HtmlTextWriter htmlWriter = new HtmlTextWriter(textWriter))
{
foreach (AspControl control in Controls)
{
control.DataBind();
control.RenderControl(htmlWriter);
}
}
text = builder.ToString();
}
}
return text;
}
public override void WriteHtml(HtmlWriter w)
{
base.WriteHtml(w);
HtmlSerializeHelper<HtmlLabel>.WriteRootElementAttributes(w, this);
w.RenderBeginTag(HtmlTag.Span);
w.Write((Control.Text).HttpEncode().Replace(Environment.NewLine, "<br />"));
w.RenderEndTag();
}
public static string RenderControl(System.Web.UI.Control control)
{
StringBuilder html = new StringBuilder();
System.IO.StringWriter stringWriter = new System.IO.StringWriter(html);
System.Web.UI.HtmlTextWriter htmlWriter = new System.Web.UI.HtmlTextWriter(stringWriter);
control.RenderControl(htmlWriter);
return html.ToString();
}
public override void WriteHtml(HtmlWriter w)
{
base.WriteHtml(w);
HtmlSerializeHelper<HtmlButton>.WriteRootElementAttributes(w, this);
w.AddAttribute(HtmlAttribute.Type, "button");
w.AddAttribute(HtmlAttribute.Value, HtmlUtility.QuotesEncode(Control.Text));
w.AddAttribute(HtmlAttribute.Onclick, "scoObj.Commit()");
w.RenderBeginTag(HtmlTag.Input);
w.RenderEndTag();
}
public override void WriteHtml(HtmlWriter w)
{
base.WriteHtml(w);
HtmlSerializeHelper<HtmlCodeSnippet>.WriteRootElementAttributes(w, this);
w.AddAttribute(HtmlAttribute.Name, "snippet");
w.AddStyleAttribute(HtmlStyleAttribute.Overflow, "auto");
w.RenderBeginTag(HtmlTag.Div);
w.Write(((CodeSnippet)Control).HtmlCode);
w.RenderEndTag();
}
/// <summary>
/// 描述：把DataTable内容导出excel并返回客户端
/// 时间：2012-10-18
/// </summary>
/// <param name="dtData"></param>
/// <param name="header"></param>
/// <param name="fileName"></param>
/// <param name="mergeCellNums">要合并的列索引字典 格式：列索引-合并模式(合并模式 1 合并相同项、2 合并空项、3 合并相同项及空项)</param>
/// <param name="mergeKey">作为合并项的标记列索引</param>
public static void DataTable2Excel(System.Data.DataTable dtData, TableCell[] header, string fileName, Dictionary<int, int> mergeCellNums, int? mergeKey)
{
System.Web.UI.WebControls.GridView gvExport = null;
// 当前对话
System.Web.HttpContext curContext = System.Web.HttpContext.Current;
// IO用于导出并返回excel文件
System.IO.StringWriter strWriter = null;
System.Web.UI.HtmlTextWriter htmlWriter = null;
if (dtData != null)
{
// 设置编码和附件格式
curContext.Response.ContentType = "application/vnd.ms-excel";
curContext.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
curContext.Response.Charset = "gb2312";
if (!string.IsNullOrEmpty(fileName))
{
//处理中文名乱码问题
fileName = System.Web.HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8);
curContext.Response.AppendHeader("Content-Disposition", ("attachment;filename=" + (fileName.ToLower().EndsWith(".xls") ? fileName : fileName + ".xls")));
}
// 导出excel文件
strWriter = new System.IO.StringWriter();
htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);
// 重新定义一个无分页的GridView
gvExport = new System.Web.UI.WebControls.GridView();
gvExport.DataSource = dtData.DefaultView;
gvExport.AllowPaging = false;
//优化导出数据显示，如身份证、12-1等显示异常问题
gvExport.RowDataBound += new System.Web.UI.WebControls.GridViewRowEventHandler(dgExport_RowDataBound);
gvExport.DataBind();
//处理表头
if (header != null && header.Length > 0)
{
gvExport.HeaderRow.Cells.Clear();
gvExport.HeaderRow.Cells.AddRange(header);
}
//合并单元格
if (mergeCellNums != null && mergeCellNums.Count > 0)
{
foreach (int cellNum in mergeCellNums.Keys)
{
MergeRows(gvExport, cellNum, mergeCellNums[cellNum], mergeKey);
}
}
// 返回客户端
gvExport.RenderControl(htmlWriter);
curContext.Response.Clear();
curContext.Response.Write("<meta http-equiv=\"content-type\" content=\"application/ms-excel; charset=gb2312\"/>" + strWriter.ToString());
curContext.Response.End();
}
}
public void OutPutExcel()
{
//定义文档类型、字符编码
Response.Clear();
Response.Buffer = true;
Response.Charset = "GB2312";
//下面这行很重要， attachment 参数表示作为附件下载，您可以改成 online在线打开
//filename=FileFlow.xls 指定输出文件的名称，注意其扩展名和指定文件类型相符，可以为：.doc .xls .txt .htm
Response.AppendHeader("Content-Disposition", "attachment;filename=FileFlow.xls");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
//Response.ContentType指定文件类型 可以为application/ms-excel、application/ms-word、application/ms-txt、application/ms-html 或其他浏览器可直接支持文档
Response.ContentType = "application/ms-excel";
this.EnableViewState = false;
// 定义一个输入流
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
var source = GetDataSource();
var obj = source.Select(s => new
{
Id = s.Id,
SumScore = s.Activity_Relay.SumScore,
NickName = s.Activity_Relay.WeixinUser.Nickname.SubHtml(10),
Name = s.name.SubHtml(10),
Phone = s.phone,
AddTime = s.addTime,
SponsorName = GetSponsor(s.Activity_Relay.SponsorId),
AwardName = s.Activity_Awards.name,
IsAward = s.isAward,
IsCheck = s.isCheck,
CheckDate = s.CheckDate,
});
this.gvList.DataSource = obj;
gvList.DataBind();
gvList.RenderControl(oHtmlTextWriter);
//this 表示输出本页，你也可以绑定datagrid,或其他支持obj.RenderControl()属性的控件
Response.Write(oStringWriter.ToString());
FenYe();
Response.End();
}
public void AddAttributesToRender(System.Web.UI.HtmlTextWriter writer)
{
}
protected override void Render(System.Web.UI.HtmlTextWriter writer)
{
base.Render(writer);
}
private void exportToExcel(string path, DataTable dt)
{
if (dt.Columns.Count > 0)
{
string OPath = path + "\\" + TB.TBName + ".xls";
try
{
StreamWriter SW = new StreamWriter(OPath);
System.Web.UI.HtmlTextWriter HTMLWriter = new System.Web.UI.HtmlTextWriter(SW);
System.Web.UI.WebControls.DataGrid grid = new System.Web.UI.WebControls.DataGrid();
grid.DataSource = dt;
grid.DataBind();
using (SW)
{
using (HTMLWriter)
{
grid.RenderControl(HTMLWriter);
}
}
SW.Close();
HTMLWriter.Close();
MessageBox.Show("Your spreadsheet was created at: " + OPath, "Information", MessageBoxButtons.OK);
}
catch (Exception exx)
{
MessageBox.Show("Could not create " + OPath.Trim() + ". Create the directory first." + exx.Message, "Error", MessageBoxButtons.OK);
}
}
else
{
MessageBox.Show("Your spreadsheet could not be created. No columns found in datatable.", "Error Message", MessageBoxButtons.OK);
}
}
protected override void Render(System.Web.UI.HtmlTextWriter writer)
{
MessageManager.RenderControl(writer);
base.Render(writer);
}
/// <summary>
/// Renders the control to the specified HTML writer.
/// </summary>
/// <param name="writer">The System.Web.UI.HtmlTextWriter object that receives the control content.</param>
protected override void Render(System.Web.UI.HtmlTextWriter writer)
{
writer.Write(GenerateLikeButton());
}
public override void RenderBeginTag(System.Web.UI.HtmlTextWriter writer)
{
base.RenderBeginTag(writer);
writer.Write("<div class='inner'>");
}
public virtual new void AddAttributesToRender(System.Web.UI.HtmlTextWriter writer, WebControl owner)
{
Contract.Requires(writer != null);
}
/// <summary>
/// Extension de la méthode toString().
/// Permet à chaque Manager de présenter son propre état.
/// </summary>
/// <param name="writer">Writer HTML.</param>
public void ToHtml(System.Web.UI.HtmlTextWriter writer)
{
HtmlPageRenderer.ToHtml(RequestHyperCube, writer);
}
protected override void RenderContents(System.Web.UI.HtmlTextWriter writer)
{
ListItemCollection items = this.Items;
int count = items.Count;
if (count > 0)
{
bool flag = false;
string prevOptGroup = null;
for (int i = 0; i < count; i++)
{
string tag = OptionTag;
string optgroupLabel = null;
ListItem item = items[i];
if (item.Enabled)
{
if (item.Attributes.Count > 0 && item.Attributes[OptionGroupTag] != null)
{
optgroupLabel = item.Attributes[OptionGroupTag];
if (prevOptGroup != optgroupLabel)
{
if (prevOptGroup != null)
{
writer.WriteEndTag(OptionGroupTag);
}
writer.WriteBeginTag(OptionGroupTag);
if (!string.IsNullOrEmpty(optgroupLabel))
{
writer.WriteAttribute("label", optgroupLabel);
}
writer.Write('>');
}
item.Attributes.Remove(OptionGroupTag);
prevOptGroup = optgroupLabel;
}
else
{
if (prevOptGroup != null)
{
writer.WriteEndTag(OptionGroupTag);
}
prevOptGroup = null;
}
writer.WriteBeginTag(tag);
if (item.Selected)
{
if (flag)
{
this.VerifyMultiSelect();
}
flag = true;
writer.WriteAttribute("selected", "selected");
}
writer.WriteAttribute("value", item.Value, true);
if (item.Attributes.Count > 0)
{
item.Attributes.Render(writer);
}
if (optgroupLabel != null)
{
item.Attributes.Add(OptionGroupTag, optgroupLabel);
}
if (this.Page != null)
{
this.Page.ClientScript.RegisterForEventValidation(this.UniqueID, item.Value);
}
writer.Write('>');
HttpUtility.HtmlEncode(item.Text, writer);
writer.WriteEndTag(tag);
writer.WriteLine();
if (i == count - 1)
{
if (prevOptGroup != null)
{
writer.WriteEndTag(OptionGroupTag);
}
}
}
}
}
}
/// <summary>
/// Renders the specified writer.
/// </summary>
/// <param name="badge">The badge.</param>
/// <param name="writer">The writer.</param>
public override void Render(PersonBadgeCache badge, System.Web.UI.HtmlTextWriter writer)
{
Guid?groupTypeGuid = GetAttributeValue(badge, "GroupType").AsGuidOrNull();
if (groupTypeGuid.HasValue)
{
var lavaTemplate = this.GetAttributeValue(badge, "LavaTemplate");
var slidingDateRangeDelimitedValues = this.GetAttributeValue(badge, "DateRange");
var dateRange = SlidingDateRangePicker.CalculateDateRangeFromDelimitedValues(slidingDateRangeDelimitedValues);
var dateRangeSummary = SlidingDateRangePicker.FormatDelimitedValues(slidingDateRangeDelimitedValues);
var mergeFields = Lava.LavaHelper.GetCommonMergeFields(null, null, new Lava.CommonMergeFieldsOptions {
GetLegacyGlobalMergeFields = false
});
mergeFields.Add("Person", this.Person);
using (var rockContext = new RockContext())
{
var groupType = GroupTypeCache.Get(groupTypeGuid.Value);
int groupTypeId = groupType?.Id ?? 0;
mergeFields.Add("GroupType", groupType);
mergeFields.Add("Badge", badge);
mergeFields.Add("DateRange", new { Dates = dateRange, Summary = dateRangeSummary });
var personAliasIds = Person.Aliases.Select(a => a.Id).ToList();
var attendanceQuery = new AttendanceService(rockContext)
.Queryable()
.Where(a =>
a.Occurrence.Group != null &&
a.Occurrence.Group.GroupTypeId == groupTypeId &&
a.DidAttend == true &&
personAliasIds.Contains(a.PersonAliasId.Value));
if (dateRange.Start.HasValue)
{
attendanceQuery = attendanceQuery.Where(a => a.StartDateTime >= dateRange.Start.Value);
}
if (dateRange.End.HasValue)
{
attendanceQuery = attendanceQuery.Where(a => a.StartDateTime < dateRange.End.Value);
}
var attendanceDateTimes = attendanceQuery.Select(a => a.StartDateTime).ToList();
if (attendanceDateTimes.Any())
{
var attendanceResult = new
{
Count = attendanceDateTimes.Count(),
LastDateTime = attendanceDateTimes.Max()
};
mergeFields.Add("Attendance", attendanceResult);
}
string output = lavaTemplate.ResolveMergeFields(mergeFields);
writer.Write(output);
}
}
}
protected override void Render(System.Web.UI.HtmlTextWriter writer)
{
_contr = new Controller(_report, this.Page);
LoadHtmlTable();
base.Render(writer);
}
void System.Web.UI.WebControls.IRepeatInfoUser.RenderItem(ListItemType itemType, int repeatIndex, RepeatInfo repeatInfo, System.Web.UI.HtmlTextWriter writer)
{
}
protected internal override void RenderContents(System.Web.UI.HtmlTextWriter writer)
{
}
public override void RenderEndTag(System.Web.UI.HtmlTextWriter writer)
{
writer.Write("</div>");
base.RenderEndTag(writer);
}
void manager_PostControllerProcess(IEngineContext context)
{
// only insert on Html pages.
if (htmlOnly && (!context.Response.ContentType.StartsWith("text/html") || context.Request.Headers["x-requested-with"] == "XMLHttpRequest"))
return;
TraceContext tc = context.UnderlyingContext.Trace ?? new TraceContext(context.UnderlyingContext);
if (includePropertyBag)
{
var getdata = typeof(TraceContext).GetMethod("GetData", BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.InvokeMethod);
var renderdata = getdata.Invoke(tc, null) as System.Data.DataSet;
if (renderdata != null)
{
DictionaryToTable(renderdata, "Trace_Application", context.CurrentControllerContext.PropertyBag);
DictionaryToTable(renderdata, "Trace_Session", context.Flash);
}
}
var render = typeof(TraceContext).GetMethod("Render", BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.InvokeMethod);
using (var htw = new System.Web.UI.HtmlTextWriter(context.UnderlyingContext.Response.Output))
{
render.Invoke(tc, new object[] { htw });
}
}
protected virtual new void RenderBeginTag(System.Web.UI.HtmlTextWriter writer)
{
Contract.Requires(writer != null);
}
public void SavePhotoHtmlIndex (int i)
{
System.IO.StreamWriter stream = System.IO.File.CreateText (SubdirPath (PhotoIndexPath (i)));
System.Web.UI.HtmlTextWriter writer = new System.Web.UI.HtmlTextWriter (stream);
//writer.Indent = 4;
//writer.Write ("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
writer.WriteLine ("<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Strict//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd\">");
writer.AddAttribute ("xmlns", "http://www.w3.org/1999/xhtml");
writer.AddAttribute ("xml:lang", this.Language);
writer.RenderBeginTag ("html");
WriteHeader (writer);
writer.AddAttribute ("onload", "checkForTheme()");
writer.RenderBeginTag ("body");
writer.AddAttribute ("class", "container1");
writer.RenderBeginTag ("div");
writer.AddAttribute ("class", "header");
writer.RenderBeginTag ("div");
writer.AddAttribute ("id", "title");
writer.RenderBeginTag ("div");
writer.Write (gallery_name);
writer.RenderEndTag ();
writer.AddAttribute ("class", "navi");
writer.RenderBeginTag ("div");
if (i > 0)
// Abbreviation of previous
WritePageNav (writer, "prev", PhotoIndexPath (i - 1), Catalog.GetString("Prev"));
WritePageNav (writer, "index", IndexPath (i / perpage), Catalog.GetString("Index"));
if (i < collection.Count -1)
WritePageNav (writer, "next", PhotoIndexPath (i + 1), Catalog.GetString("Next"));
writer.RenderEndTag (); //navi
writer.RenderEndTag (); //header
writer.AddAttribute ("class", "photo");
writer.RenderBeginTag ("div");
writer.AddAttribute ("href", PhotoOriginalPath (i));
writer.RenderBeginTag ("a");
writer.AddAttribute ("src", PhotoWebPath (i));
writer.AddAttribute ("alt", "#");
writer.RenderBeginTag ("img");
writer.RenderEndTag ();
writer.RenderEndTag (); // a
writer.AddAttribute ("id", "description");
writer.RenderBeginTag ("div");
writer.Write (collection [i].Description);
writer.RenderEndTag ();
writer.RenderEndTag ();
//Style Selection Box
writer.AddAttribute ("id", "styleboxcontainer");
writer.RenderBeginTag ("div");
writer.AddAttribute ("id", "stylebox");
writer.AddAttribute ("style", "display: none;");
writer.RenderBeginTag ("div");
writer.RenderBeginTag("ul");
writer.RenderBeginTag("li");
writer.AddAttribute ("href", "#");
writer.AddAttribute ("title", dark);
writer.AddAttribute ("onclick", "setActiveStyleSheet('" + dark + "')");
writer.RenderBeginTag("a");
writer.Write (dark);
writer.RenderEndTag (); //a
writer.RenderEndTag (); //li
writer.RenderBeginTag("li");
writer.AddAttribute ("href", "#");
writer.AddAttribute ("title", light);
writer.AddAttribute ("onclick", "setActiveStyleSheet('" + light + "')");
writer.RenderBeginTag("a");
writer.Write (light);
writer.RenderEndTag (); //a
writer.RenderEndTag (); //li
writer.RenderEndTag (); //ul
writer.RenderEndTag (); //div stylebox
writer.RenderBeginTag ("div");
writer.Write ("<span class=\"style_toggle\">");
writer.Write ("<a href=\"javascript:toggle_stylebox()\">");
writer.Write ("<span id=\"showlink\">" + Catalog.GetString ("Show Styles") + "</span><span id=\"hidelink\" ");
writer.Write ("style=\"display:none;\">" + Catalog.GetString ("Hide Styles") + "</span></a></span>" + Environment.NewLine);
writer.RenderEndTag (); //div toggle
writer.RenderEndTag (); //div styleboxcontainer
writer.RenderEndTag (); //container1
WriteFooter (writer);
writer.RenderEndTag (); //body
writer.RenderEndTag (); // html
writer.Close ();
stream.Close ();
}
private void ExportReport(string StartDate, string EndDate, DataTable dt)
{
dt.Columns["EmployeeId"].SetOrdinal(1);
dt.Columns["Name"].SetOrdinal(2);
dt.Columns["Department"].SetOrdinal(3);
dt.Columns["Designation"].SetOrdinal(4);
dt.Columns["MCQ_Status"].SetOrdinal(5);
dt.Columns["PAN_Number"].SetOrdinal(6);
dt.Columns["ActivationPeriod"].SetOrdinal(7);
dt.Columns["MCQ_ExamDate"].SetOrdinal(8);
dt.Columns["MCQ_ExamDate"].ColumnName = "Login Date And Time";
dt.Columns["EmployeeId"].ColumnName = "Employee Id";
dt.Columns["Name"].ColumnName = "Employee Name";
dt.Columns["MCQ_Status"].ColumnName = "MCQ Status";
dt.Columns["PAN_Number"].ColumnName = "PAN Number";
dt.Columns["ActivationPeriod"].ColumnName = "Activation Period";
dt.Columns["FrequencyOfMCQ"].ColumnName = "Frequency Of MCQ";
dt.Columns["LastDateOfMCQ"].ColumnName = "Last Date Of MCQ";
dt.Columns["AttemptNo"].ColumnName = "Attempt No";
dt.Columns["AccountBlocked"].ColumnName = "Account Blocked";
dt.Columns["Dateofblocking"].ColumnName = "Date of blocking";
dt.Columns["Reasonforblocking"].ColumnName = "Reason for blocking";
dt.Columns.Remove("UserInfoID");
dt.Columns.Remove("From_Date");
dt.Columns.Remove("To_Date");
dt.Columns.Remove("StartDate");
dt.Columns.Remove("EndDate");
dt.Columns.Remove("Action");
dt.Columns.Remove("DepartmentID");
dt.Columns.Remove("DesignationID");
dt.Columns.Remove("LoginDateAndTime");
string exlFilename = "MCQ_Report " + Convert.ToDateTime(StartDate).ToString("dd-MMM-yyyy") + " _ " + Convert.ToDateTime(EndDate).ToString("dd-MMM-yyyy") + ".xls";
string sConnectionString = string.Empty;
string spName = string.Empty;
string workSheetName = "MCQ Result";
string cellRange = string.Empty;
if (dt != null && dt.Rows.Count > 0)
{
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.Charset = "";
Response.AddHeader("content-disposition", "attachment;filename=" + exlFilename + "");
StringWriter sWriter = new StringWriter();
System.Web.UI.HtmlTextWriter hWriter = new System.Web.UI.HtmlTextWriter(sWriter);
System.Web.UI.WebControls.GridView dtGrid = new System.Web.UI.WebControls.GridView();
dtGrid.DataSource = dt;
dtGrid.DataBind();
dtGrid.RenderControl(hWriter);
Response.Write(@"<style> TD { mso-number-format:\@; } </style>");
Response.Output.Write(sWriter.ToString());
Response.Flush();
Response.End();
}
}
protected internal override void RenderChildren(System.Web.UI.HtmlTextWriter writer)
{
}
protected override void Render(Writer writer)
{
AddRemoveInstanceButton.RenderControl(writer);
}
public virtual void RenderControl(System.Web.UI.HtmlTextWriter writer)
{
}
protected override void RenderHeader(System.Web.UI.HtmlTextWriter writer)
{
}
protected override void Render(System.Web.UI.HtmlTextWriter writer)
{
if (string.IsNullOrWhiteSpace(scripts))
{
throw new Exception("Scripts attribute cannot be empty.");
}
CacheKey = lw.Utils.Hash.GetHash(scripts, Utils.Hash.HashType.MD5);
scriptsArray = Scripts.Split(new Char[] { ',', '|', ';' }, StringSplitOptions.RemoveEmptyEntries);
string fileLocation = WebContext.Server.MapPath(FileLocation);
if (!File.Exists(fileLocation))
{
using (FileStream streamCache = File.OpenWrite(fileLocation))
{
StringBuilder output = new StringBuilder();
output.AppendLine("/* Script generated at: " + DateTime.Now.ToString() + "*/");
foreach (string file in scriptsArray)
{
output.AppendLine("/* File Name: " + file + "*/");
if (file.EndsWith(".lwjs"))
{
string tempFile = file.Replace(".lwjs", "").Replace("../", "");
IEnumerable <JsXml> query = Engine.XmlFile.Descendants("js").Select(p => new JsXml
{
file = p.Element("file").Value,
version = decimal.Parse(p.Element("version").Value),
dependency = p.Element("dependency").Value,
depversion = p.Element("depversion").Value
});
var jsXmls = query as JsXml[] ?? query.ToArray();
var test = from a in jsXmls
where a.file == tempFile
select a;
if (!test.Any())
{
throw new Exception("Script not found: " + tempFile);
}
query = from a in jsXmls
where a.file == tempFile
orderby a.version descending
select a;
string version = query.First().version.ToString();
version = "_" + version.Replace(".", "._");
string resourceKey = "lw.js.script." + tempFile.Replace("-", "_") + "." + version + "." + tempFile + ".js";
string result = "";
using (Stream stream = typeof(Engine).Assembly.
GetManifestResourceStream(resourceKey))
{
using (var sr = new StreamReader(stream))
{
result = sr.ReadToEnd();
}
}
output.AppendLine(result);
}
else if (file.IndexOf("//") == 0 || file.IndexOf("http") == 0)
{
output.AppendLine(lw.WebTools.WebUtils.GetURLContent(file));
}
else
{
using (Stream stream = File.OpenRead(WebContext.Server.MapPath(WebContext.Root + file)))
{
using (StreamReader sr = new StreamReader(stream))
{
output.AppendLine(sr.ReadToEnd());
}
}
}
}
using (StreamWriter s = new StreamWriter(streamCache))
s.WriteLine(output.ToString());
}
}
writer.Write("<script src=\"" + FileLocation + "\"></script>");
//base.Render(writer);
}
public static void SendMail(umbraco.cms.businesslogic.member.MemberGroup Group, umbraco.cms.businesslogic.property.Property Property, string fromName, string fromEmail, bool IsHtml)
{
// Create ArrayList with emails who've received the e-mail
ArrayList sent = new ArrayList();
// set timeout
System.Web.HttpContext.Current.Server.ScriptTimeout = 43200; // 12 hours
// version
string version = Property.VersionId.ToString();
// Get document
umbraco.cms.businesslogic.web.Document d = new umbraco.cms.businesslogic.web.Document(umbraco.cms.businesslogic.Content.GetContentFromVersion(Property.VersionId).Id);
int id = d.Id;
System.Web.HttpContext.Current.Items["pageID"] = id;
// Format mail
string subject = d.Text;
string sender = "\"" + fromName + "\" <" + fromEmail + ">";
// Get template
System.Text.StringBuilder sb = new System.Text.StringBuilder();
System.IO.StringWriter sw = new StringWriter(sb);
System.Web.UI.HtmlTextWriter writer = new System.Web.UI.HtmlTextWriter(sw);
umbraco.template t = new template(d.Template);
t.ParseWithControls(new umbraco.page(d.Id, d.Version)).RenderControl(writer);
EmailMessage message = mailerHelper.CreateEmbeddedEmail(sb.ToString(), Cms.BusinessLogic.web.Document.GetContentFromVersion(Property.VersionId).Id);
message.FromAddress = new EmailAddress(fromEmail, fromName);
message.Subject = subject;
SmtpServer smtpServer = new SmtpServer(GlobalSettings.SmtpServer);
// Bulk send mails
int counter = 0;
System.Text.StringBuilder sbStatus = new System.Text.StringBuilder();
sbStatus.Append("The Newsletter '" + d.Text + "' was starting at " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString() + "\n");
using(SqlDataReader dr = Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(umbraco.GlobalSettings.DbDSN, CommandType.Text, "select text, email from cmsMember inner join umbracoNode node on node.id = cmsMember.nodeId inner join cmsMember2memberGroup on cmsmember.nodeId = cmsMember2MemberGroup.member where memberGroup = @memberGroupId", new SqlParameter("@memberGroupId", Group.Id)))
{
while(dr.Read())
{
try
{
if (!sent.Contains(dr["email"].ToString()))
{
message.ToAddresses.Clear();
message.ToAddresses.Add(new EmailAddress(dr["email"].ToString(), dr["text"].ToString()));
message.Send(smtpServer);
// add to arraylist of receiptients
sent.Add(dr["email"].ToString());
// Append to status
sbStatus.Append("Sent to " + dr["text"].ToString() + " <" + dr["email"].ToString() + "> \n\r");
}
else
{
// Append to status
sbStatus.Append("E-mail has already been sent to email '" + dr["email"].ToString() + ". You have a duplicate member: " + dr["text"].ToString() + " <" + dr["email"].ToString() + "> \n\r");
}
}
catch(Exception ee)
{
sbStatus.Append("Error sending to " + dr["text"].ToString() + " <" + dr["email"].ToString() + ">: " +
ee.ToString() + " \n");
}
// For progress bar
counter++;
if(counter % 5 == 0)
{
System.Web.HttpContext.Current.Application.Lock();
System.Web.HttpContext.Current.Application["ultraSimpleMailerProgress" + id.ToString() + "Done"] = counter;
System.Web.HttpContext.Current.Application.UnLock();
}
}
}
sbStatus.Append("Finished at " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString() + "\n");
// Send status mail
library.SendMail(fromEmail, fromEmail, "Newsletter status", sbStatus.ToString(), false);
}
private void printHTML(DataTable dt, string TabName)
{
if (dt.Columns.Count > 0)
{
string OPath = "c:\\koos.html";
try
{
StreamWriter SW = new StreamWriter(OPath);
//StringWriter SW = new StringWriter();
System.Web.UI.HtmlTextWriter HTMLWriter = new System.Web.UI.HtmlTextWriter(SW);
System.Web.UI.WebControls.DataGrid grid = new System.Web.UI.WebControls.DataGrid();
grid.DataSource = dt;
grid.DataBind();
using (SW)
{
using (HTMLWriter)
{
HTMLWriter.WriteLine("HARMONY - Phakisa Mine - " + TabName);
HTMLWriter.WriteBreak();
HTMLWriter.WriteLine("==============================");
HTMLWriter.WriteBreak();
HTMLWriter.WriteBreak();
grid.RenderControl(HTMLWriter);
//RearDecorator(HTMLWriter);
}
}
SW.Close();
HTMLWriter.Close();
System.Diagnostics.Process P = new System.Diagnostics.Process();
P.StartInfo.WorkingDirectory = strServerPath + ":\\Program Files\\Internet Explorer";
P.StartInfo.FileName = "IExplore.exe";
P.StartInfo.Arguments = "C:\\koos.html";
P.Start();
P.WaitForExit();
}
catch (Exception exx)
{
MessageBox.Show("Could not create " + OPath.Trim() + ". Create the directory first." + exx.Message, "Error", MessageBoxButtons.OK);
}
}
else
{
MessageBox.Show("Your spreadsheet could not be created. No columns found in datatable.", "Error Message", MessageBoxButtons.OK);
}
}
public override void AddAttributesToRender(System.Web.UI.HtmlTextWriter writer, WebControl owner)
{
}
public void WriteHtml(HtmlWriter w, string name)
{
}
private void imgWord_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
Response.Clear();
Response.Charset = "";
//set the response mime type for excel
Response.ContentType = "application/vnd.ms-word";
Response.AddHeader("content-disposition","attachment; filename=QueryResults.doc");
DataGrid dgQuery = new DataGrid();
DataGrid dgQuery2 = new DataGrid();
if (IsDefault == true)
{
dgQuery.DataSource = DSOrders.tbl_Orders;
dgQuery.DataBind();
dgQuery2.DataSource = DSOrders.tbl_OrderDetails;
dgQuery2.DataBind();
}
else
{
dgQuery.DataSource = dsBrowseGrid.Tables["Data"].DefaultView;
dgQuery.ItemDataBound += new DataGridItemEventHandler(dgQuery_ItemDataBound);
dgQuery.DataBind();
}
//create a string writer
System.IO.StringWriter stringWrite = new StringWriter();
// Ceate an htmltextwriter which uses the stringwriter
System.Web.UI.HtmlTextWriter htmlWriter = new System.Web.UI.HtmlTextWriter(stringWrite);
dgQuery.RenderControl(htmlWriter);
if (IsDefault == true)
{
dgQuery2.RenderControl(htmlWriter);
}
// Output table as HTML
Response.Write(stringWrite.ToString());
Response.End();
}
protected virtual new void RenderVerb(System.Web.UI.HtmlTextWriter writer, WebPartVerb verb)
{
}
public void WriteToHtmlTextWriter(System.Web.UI.HtmlTextWriter html)
{
html.Write(content);
}
/// <summary>
/// 将Datatable转换为Excel
/// </summary>
/// <param name="dtData"></param>
/// <param name="FileName"></param>
public static void DataTableToExcel(System.Data.DataTable dtData, String FileName)
{
if (dtData == null || dtData.Rows.Count == 0)
{
return;
}
System.Web.UI.WebControls.GridView dgExport = null;
//当前对话
System.Web.HttpContext curContext = System.Web.HttpContext.Current;
//IO用于导出并返回excel文件
System.IO.StringWriter strWriter = null;
System.Web.UI.HtmlTextWriter htmlWriter = null;
if (dtData != null)
{
//设置编码和附件格式
//System.Web.HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8)作用是方式中文文件名乱码
curContext.Response.AddHeader("content-disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8) + ".xls");
curContext.Response.ContentType = "application nd.ms-excel";
curContext.Response.ContentEncoding = System.Text.Encoding.UTF8;//.GetEncoding("GB2312");
curContext.Response.Charset = "UTF-8";// "GB2312";
//导出Excel文件
strWriter = new System.IO.StringWriter();
htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);
//为了解决dgData中可能进行了分页的情况,需要重新定义一个无分页的GridView
dgExport = new System.Web.UI.WebControls.GridView();
dgExport.DataSource = dtData.DefaultView;
dgExport.AllowPaging = false;
dgExport.DataBind();
//下载到客户端
dgExport.RenderControl(htmlWriter);
curContext.Response.Write(strWriter.ToString());
curContext.Response.End();
}
}
public static void ExportExcel(Control ctrl,string filename,HttpResponse _Response)
{
HttpResponse Response = HttpContext.Current.Response;
Response.Clear();
Response.Charset = "utf-8";
Response.AddHeader("Content-Type","application/octet-stream");
Response.AddHeader("content-disposition", String.Format("attachment; filename={0}", filename));
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite);
ctrl.RenderControl(htmlWrite);
string Header = "<html><head><meta http-equiv=\"Content-Type\" content=\"application/octet-stream; charset=utf-8\"></head><body>";
string Footer = "</body></html>";
Response.Write(String.Concat(Header,stringWrite.ToString(),Footer));
Response.End();
}
/// <summary>
/// Processes a script and returns the result as a string.
/// </summary>
/// <param name="Page">Name of the page to return</param>
/// <param name="QueryString">Optional query string</param>
/// <returns>script result or null on failure. Script errors are returned as errors in the script result string.</returns>
public virtual string ProcessRequestToString(string Page, string QueryString)
{
StringWriter sw = new StringWriter();
TextWriter Writer = new System.Web.UI.HtmlTextWriter(sw);
// *** Reset the Response settings
this.ResponseHeaders = null;
this.Cookies = null;
this.ResponseStatusCode = 200;
wwWorkerRequest Request = new wwWorkerRequest(Page, QueryString, Writer);
if (this.Context != null)
Request.Context = this.Context;
Request.PostData = this.PostData;
Request.PostContentType = this.PostContentType;
Request.RequestHeaders = this.RequestHeaders;
Request.PhysicalPath = this.PhysicalDirectory;
try
{
HttpRuntime.ProcessRequest(Request);
}
catch (Exception ex)
{
this.ResponseStatusCode = Request.ResponseStatusCode;
this.ErrorMessage = ex.Message;
this.Error = true;
return null;
}
string Result = sw.ToString();
Writer.Close();
this.ResponseHeaders = Request.ResponseHeaders;
this.ResponseStatusCode = Request.ResponseStatusCode;
this.Cookies = Request.Cookies;
this.Context = Request.Context;
return Result;
}
/// <summary>
/// Generates a label element.
/// </summary>
/// <param name="target">The object to get the value from and to be based on to create the element name.</param>
/// <param name="label">Legend</param>
/// <param name="attributes">Attributes for the FormHelper method and for the html element it generates</param>
/// <returns>The generated form element</returns>
public virtual string LabelFor(string target, string label, IDictionary attributes)
{
target = RewriteTargetIfWithinObjectScope(target);
var id = CreateHtmlId(attributes, target);
var sb = new StringBuilder();
var sbWriter = new StringWriter(sb);
var writer = new HtmlTextWriter(sbWriter);
writer.WriteBeginTag("label");
writer.WriteAttribute("for", id);
var strAttributes = GetAttributes(attributes);
if (strAttributes != String.Empty)
{
writer.Write(HtmlTextWriter.SpaceChar);
}
writer.Write(strAttributes);
writer.Write(HtmlTextWriter.TagRightChar);
writer.Write(label);
writer.WriteEndTag("label");
return sbWriter.ToString();
}
private void RenderErrorPage(Bobs.SpottedException spottedEx)
{
HttpResponse resp = HttpContext.Current.Response;
resp.Clear();
resp.StatusCode = 500;
System.Web.UI.WebControls.Literal openPage = new System.Web.UI.WebControls.Literal();
openPage.Text = @"
<html><head><style>
.{
font-family: Verdana;
font-size:12px;
font-weight:bold;
}
p{
font-family: Verdana;
font-size:12px;
font-weight:bold;
margin-bottom:3px;
margin-top:3px;
line-height:130%;
}
a:link,
a:visited { color:#000000; }
a:hover { color:#FF0000; }
</style></head><body> <br>
<center>
<table width=""400"" cellpadding=""0"" cellspacing=""0"" border=""0"">
<tr>
<td valign=bottom align=left width=""100%"" rowspan=""2"">
<center>
<a href=""/""><img src=""/gfx/dsi-sign-100.png"" border=0 style=""border:1px solid #000000;""></a>
</center>
<div style=""padding:10px;"">
<div style=""width:100%;border:solid 1px #000000;padding:2px 4px 2px 4px; margin:0px 0px 13px 0px;"">
";
System.Web.UI.WebControls.Literal closePage = new System.Web.UI.WebControls.Literal();
closePage.Text = @"
</div>
</td></tr></table>
</center></body></html>";
System.Web.UI.WebControls.Label exceptionLabel = new System.Web.UI.WebControls.Label();
exceptionLabel.Text = "<p>";
if (spottedEx != null && spottedEx.ExceptionType == typeof(Bobs.MalformedUrlException).ToString())
{
exceptionLabel.Text += "Page not found.";
}
else if (spottedEx != null && (Bobs.Usr.Current != null && Bobs.Usr.Current.IsAdmin || HttpContext.Current.Request.UserHostAddress.StartsWith("84.45.14.") || HttpContext.Current.Request.UserHostAddress.StartsWith("192.168.113.") || HttpContext.Current.Request.UserHostAddress.Equals("127.0.0.1")))
{
exceptionLabel.Text += spottedEx.Message + "</p><p>" + spottedEx.StackTrace;
}
else if (spottedEx != null && (spottedEx.ShowMessageToUsrs))
{
exceptionLabel.Text += spottedEx.Message;
}
else
{
exceptionLabel.Text += "An error has occurred.";
}
exceptionLabel.Text += "</p><p><br></p><p>If this problem persists, you may wish to report this to an Admin";
if (spottedEx != null && spottedEx.K > 0) exceptionLabel.Text += ", quoting error #" + spottedEx.K;
exceptionLabel.Text += ".</p>";
System.Web.UI.WebControls.Button retryButton = new System.Web.UI.WebControls.Button();
retryButton.Text = "Retry";
retryButton.OnClientClick = "location.reload();";
System.Web.UI.WebControls.Button historyBackButton = new System.Web.UI.WebControls.Button();
historyBackButton.Text = "Back";
historyBackButton.OnClientClick = @"history.back();";
System.Web.UI.WebControls.Button homeButton = new System.Web.UI.WebControls.Button();
homeButton.Text = "Home";
homeButton.OnClientClick = @"location = ""/"";";
System.IO.StringWriter stringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWriter = new System.Web.UI.HtmlTextWriter(stringWriter);
openPage.RenderControl(htmlWriter);
exceptionLabel.RenderControl(htmlWriter);
htmlWriter.RenderBeginTag("center");
retryButton.RenderControl(htmlWriter);
historyBackButton.RenderControl(htmlWriter);
homeButton.RenderControl(htmlWriter);
htmlWriter.RenderEndTag();
closePage.RenderControl(htmlWriter);
resp.Write(stringWriter.ToString());
}
/// <summary>
/// DataTable导出到Excel
/// </summary>
/// <param name="pData">DataTable</param>
/// <param name="pFileName">导出文件名</param>
/// <param name="pHeader">导出标题以|分割</param>
public static void DataTableExcel(System.Data.DataTable pData, string pFileName, string pHeader)
{
System.Web.UI.WebControls.DataGrid dgExport = null;
// 当前对话
System.Web.HttpContext curContext = System.Web.HttpContext.Current;
// IO用于导出并返回excel文件
System.IO.StringWriter strWriter = null;
System.Web.UI.HtmlTextWriter htmlWriter = null;
if (pData != null)
{
string UserAgent = curContext.Request.ServerVariables["http_user_agent"].ToLower();
if (UserAgent.IndexOf("firefox") == -1)//火狐浏览器
{
pFileName = HttpUtility.UrlEncode(pFileName, System.Text.Encoding.UTF8);
}
curContext.Response.AddHeader("Content-Disposition", "attachment; filename=" + pFileName + ".xls");
curContext.Response.ContentType = "application/vnd.ms-excel";
strWriter = new System.IO.StringWriter();
htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);
// 为了解决dgData中可能进行了分页的情况，需要重新定义一个无分页的DataGrid
dgExport = new System.Web.UI.WebControls.DataGrid();
dgExport.DataSource = pData.DefaultView;
dgExport.AllowPaging = false;
dgExport.ShowHeader = false;//去掉标题
dgExport.Attributes.Add("style", "vnd.ms-excel.numberformat:@;font-size:15px;");
for(int i = 0; i < dgExport.Items.Count; i++) {
dgExport.Items[i].Width = dgExport.Items[i].ToString().Length;
}
dgExport.ItemStyle.Height = 36;
//spanRow(dgExport);
dgExport.DataBind();
string[] arrHeader = pHeader.Split('|');
string strHeader = "<table border=\"1\" style=\"font-weight:bold; font-size:15px; \"><tr>";
foreach (string j in arrHeader)
{
strHeader += "<td align='center' height='16px' >" + j.ToString() + "</td>";
}
strHeader += "</tr></table>";
//int num = 1;
//for (int i = 1; i < dgExport.Items.Count; i++)
//{
// if (dgExport.Items[i].Cells[0].Text == " ")//订单号等于空的情况下,此处是遍历行,获取行号i
// {
// num++;
// for (int j = 0; j < dgExport.Items[i].Cells.Count; j++)//寻找空行的列号,此处是遍历单元格
// {
// if (dgExport.Items[i].Cells[j].Text == " ")
// {
// dgExport.Items[i].Cells[j].Visible = false;
// dgExport.Items[i - num + 1].Cells[j].RowSpan = num;
// }
// }
// }
// else { num = 1; }
//}
// 返回客户端
dgExport.RenderControl(htmlWriter);
string strMeta = "<meta http-equiv=\"content-type\" content=\"application/ms-excel; charset=GB2312\"/>";
string strWriter2 = strWriter.ToString().Replace("<tr", "<tr style=\"vertical-align:top\"");
string OutExcel = strMeta + strHeader +strWriter2;
curContext.Response.Write(OutExcel);
curContext.Response.End();
}
}
protected virtual new void RenderVerbs(System.Web.UI.HtmlTextWriter writer)
{
}
/// <summary>
/// Renders the specified writer.
/// </summary>
/// <param name="badge">The badge.</param>
/// <param name="writer">The writer.</param>
public override void Render(BadgeCache badge, System.Web.UI.HtmlTextWriter writer)
{
if (Person == null)
{
return;
}
int?siteId = GetAttributeValue(badge, "Site").AsIntegerOrNull();
if (siteId.HasValue)
{
var site = SiteCache.Get(siteId.Value);
if (site != null)
{
string siteName = site.Name;
// create url for link to details
string detailPageUrl = string.Empty;
if (!String.IsNullOrEmpty(GetAttributeValue(badge, "PageViewDetails")))
{
int pageId = PageCache.Get(Guid.Parse(GetAttributeValue(badge, "PageViewDetails"))).Id;
// NOTE: Since this block shows a history of sites a person visited in Rock, use Person.Guid instead of Person.Id to reduce the risk of somebody manually editing the URL to see somebody else pageview history
detailPageUrl = System.Web.VirtualPathUtility.ToAbsolute($"~/page/{pageId}?PersonGuid={Person.Guid}&SiteId={siteId}");
}
writer.Write($"<div class='badge badge-lastvisitonsite badge-id-{badge.Id}' data-toggle='tooltip' data-original-title=''>");
writer.Write("</div>");
writer.Write($@"
<script>
Sys.Application.add_load(function () {{
$.ajax({{
type: 'GET',
url: Rock.settings.get('baseUrl') + 'api/Badges/LastVisitOnSite/{Person.Id}/{siteId}' ,
statusCode: {{
200: function (data, status, xhr) {{
var badgeHtml = '';
var daysSinceVisit = data;
var cssClass = '';
var linkUrl = '{detailPageUrl}';
var badgeContent = '';
var labelContent = '';
var siteName = '{siteName}';
if (daysSinceVisit >= 0 && daysSinceVisit < 1000) {{
labelContent = 'It has been ' + daysSinceVisit + ' day(s) since the last visit to the ' + siteName + ' site.';
if (daysSinceVisit == 0) {{
daysSinceVisit = 'Today';
cssClass = 'today';
labelContent = 'Visited the ' + siteName + ' site today.';
}} else if (daysSinceVisit < 7) {{
cssClass = 'very-recent';
}} else if (daysSinceVisit < 21 ) {{
cssClass = 'recent';
}} else if (daysSinceVisit < 90 ) {{
cssClass = 'moderate';
}} else if (daysSinceVisit < 365 ) {{
cssClass = 'not-recent';
}} else {{
cssClass = 'old';
}}
if (linkUrl != '') {{
badgeContent = '<a href=\'' + linkUrl + '\'><div class=\'badge-content ' + cssClass + '\'><i class=\'fa fa-desktop badge-icon\'></i><span class=\'duration\'>' + daysSinceVisit + '</span></div></a>';
}} else {{
badgeContent = '<div class=\'badge-content ' + cssClass + '\'><i class=\'fa fa-desktop badge-icon\'></i><span class=\'duration\'>' + daysSinceVisit + '</span></div>';
}}
$('.badge-lastvisitonsite.badge-id-{badge.Id}').html(badgeContent);
$('.badge-lastvisitonsite.badge-id-{badge.Id}').attr('data-original-title', labelContent);
}}
}}
}},
}});
}});
</script>
");
}
}
}
public void SetWriter(ref System.Web.UI.HtmlTextWriter writer)
{
_writer = writer;
}
protected override void RenderWithAscx(System.Web.UI.HtmlTextWriter writer)
{
this.RenderContents(writer);
}
/// <summary>
/// Generates the select.
/// </summary>
/// <param name="target">The target.</param>
/// <param name="selectedValue">The selected value.</param>
/// <param name="dataSource">The data source.</param>
/// <param name="attributes">The attributes.</param>
/// <returns></returns>
protected virtual string GenerateSelect(string target, object selectedValue, IEnumerable dataSource, IDictionary attributes)
{
var id = CreateHtmlId(target);
ApplyValidation(InputElementType.Select, target, ref attributes);
var sb = new StringBuilder();
var sbWriter = new StringWriter(sb);
var writer = new HtmlTextWriter(sbWriter);
string firstOption = null;
string firstOptionValue = null;
var pascalCaseToWord = false;
var name = target;
if (attributes != null)
{
firstOption = CommonUtils.ObtainEntryAndRemove(attributes, "firstoption");
firstOptionValue = CommonUtils.ObtainEntryAndRemove(attributes, "firstoptionvalue");
pascalCaseToWord = Convert.ToBoolean(CommonUtils.ObtainEntryAndRemove(attributes, "pascalCaseToWord"));
if (attributes.Contains("name"))
{
name = (String)attributes["name"];
attributes.Remove("name");
}
if (attributes.Contains("id"))
{
id = (String)attributes["id"];
attributes.Remove("id");
}
}
var state = SetOperation.IterateOnDataSource(selectedValue, dataSource, attributes);
writer.WriteBeginTag("select");
writer.WriteAttribute("id", id);
writer.WriteAttribute("name", name);
writer.Write(" ");
writer.Write(GetAttributes(attributes));
writer.Write(HtmlTextWriter.TagRightChar);
writer.WriteLine();
if (firstOption != null)
{
writer.WriteBeginTag("option");
writer.WriteAttribute("value", (firstOptionValue == null) ? "0" : SafeHtmlEncode(firstOptionValue));
writer.Write(HtmlTextWriter.TagRightChar);
writer.Write(SafeHtmlEncode(firstOption));
writer.WriteEndTag("option");
writer.WriteLine();
}
foreach (SetItem item in state)
{
writer.WriteBeginTag("option");
if (item.IsSelected)
{
writer.Write(" selected=\"selected\"");
}
writer.WriteAttribute("value", SafeHtmlEncode(item.Value));
writer.Write(HtmlTextWriter.TagRightChar);
if (pascalCaseToWord)
{
writer.Write(SafeHtmlEncode(TextHelper.PascalCaseToWord(item.Text)));
}
else
{
writer.Write(SafeHtmlEncode(item.Text));
}
writer.WriteEndTag("option");
writer.WriteLine();
}
writer.WriteEndTag("select");
return sbWriter.ToString();
}
protected override void Render(System.Web.UI.HtmlTextWriter writer)
{
writer.Write(HTMLContent);
//HTMLContent = "";
}
/// <summary>
/// Formats a complete HTML document describing the given
/// <see cref="Error"/> instance.
/// </summary>
public override void Format(TextWriter writer, Error error)
{
if (writer == null)
throw new ArgumentNullException("writer");
if (error == null)
throw new ArgumentNullException("error");
//
// Create a HTML writer on top of the given writer and
// write out the document. Note that the incoming
// writer and error parameters are promoted to members
// during formatting in order to avoid passing them
// as context to each downstream method responsible
// for rendering a part of the document. The important
// assumption here is that Format will never be called
// from more than one thread at the same time.
//
Html32TextWriter htmlWriter = new Html32TextWriter(writer);
htmlWriter.RenderBeginTag(HtmlTextWriterTag.Html);
_writer = htmlWriter;
_error = error;
try
{
RenderHead();
RenderBody();
}
finally
{
_writer = null;
_error = null;
}
htmlWriter.RenderEndTag(); // </html>
htmlWriter.WriteLine();
}
//public Toolmenu()
//{
//}
protected override void DoRender(System.Web.UI.HtmlTextWriter output)
{
base.Icon = this.Icon;
base.DoRender(output);
}
//根据路径和数据table插入excel文件中
public void insertTableByPath(string ExcelPath, DataTable dtData)
{
try
{
System.Web.UI.WebControls.DataGrid dgExport = null;
// 当前对话
//System.Web.HttpContext curContext = System.Web.HttpContext.Current;
// IO用于导出并返回excel文件
System.IO.StringWriter strWriter = null;
System.Web.UI.HtmlTextWriter htmlWriter = null;
if (dtData != null)
{
if (dtData.Rows.Count < 65530)
{
// 设置编码和附件格式
//curContext.Response.ContentType = "application/vnd.ms-excel";
//curContext.Response.ContentEncoding = System.Text.Encoding.UTF8;
//curContext.Response.Charset = "GBK";
DateTime currentNow = DateTime.Now;
// 导出excel文件
strWriter = new System.IO.StringWriter();
htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);
// 为了解决dgData中可能进行了分页的情况，需要重新定义一个无分页的DataGrid
dgExport = new System.Web.UI.WebControls.DataGrid();
dgExport.DataSource = dtData.DefaultView;
dgExport.AllowPaging = false;
dgExport.DataBind();
//string fileName = Name + currentNow.ToString("yyyy-MM-dd") + ".xls";
//string filePath = curContext.Server.MapPath(".") + fileName;
System.IO.StreamWriter sw = System.IO.File.CreateText(ExcelPath);
dgExport.RenderControl(htmlWriter);
sw.Write(strWriter.ToString());
sw.Close();
// 返回客户端
//this.DownFile(curContext.Response, fileName, ExcelPath);
//curContext.Response.End();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public virtual void RenderEndTag(System.Web.UI.HtmlTextWriter writer)
{
}
public void SaveHtmlIndex (int page_num)
{
System.IO.StreamWriter stream = System.IO.File.CreateText (SubdirPath (IndexPath (page_num)));
System.Web.UI.HtmlTextWriter writer = new System.Web.UI.HtmlTextWriter (stream);
//writer.Indent = 4;
//writer.Write ("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
writer.WriteLine ("<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Strict//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd\">");
writer.AddAttribute ("xmlns", "http://www.w3.org/1999/xhtml");
writer.AddAttribute ("xml:lang", this.Language);
writer.RenderBeginTag ("html");
WriteHeader (writer);
writer.AddAttribute ("onload", "checkForTheme()");
writer.RenderBeginTag ("body");
writer.AddAttribute ("class", "container1");
writer.RenderBeginTag ("div");
writer.AddAttribute ("class", "header");
writer.RenderBeginTag ("div");
writer.AddAttribute ("id", "title");
writer.RenderBeginTag ("div");
writer.Write (gallery_name);
writer.RenderEndTag (); //title div
writer.AddAttribute ("class", "navi");
writer.RenderBeginTag ("div");
writer.AddAttribute ("class", "navilabel");
writer.RenderBeginTag ("div");
writer.Write (Catalog.GetString ("Page:"));
writer.RenderEndTag (); //pages div
int i;
for (i = 0; i < PageCount; i++) {
writer.AddAttribute ("class", i == page_num ? "navipage-current" : "navipage");
writer.RenderBeginTag ("div");
writer.AddAttribute ("href", IndexPath (i));
writer.RenderBeginTag ("a");
writer.Write (IndexTitle (i));
writer.RenderEndTag (); //a
writer.RenderEndTag (); //navipage
}
writer.RenderEndTag (); //navi
writer.RenderEndTag (); //header
writer.AddAttribute ("class", "thumbs");
writer.RenderBeginTag ("div");
int start = page_num * perpage;
int end = Math.Min (start + perpage, collection.Count);
for (i = start; i < end; i++) {
writer.AddAttribute ("href", PhotoIndexPath (i));
writer.RenderBeginTag ("a");
writer.AddAttribute ("src", PhotoThumbPath (i));
writer.AddAttribute ("alt", "#");
writer.RenderBeginTag ("img");
writer.RenderEndTag ();
writer.RenderEndTag (); //a
}
writer.RenderEndTag (); //thumbs
writer.AddAttribute ("id", "gallery_description");
writer.RenderBeginTag ("div");
writer.Write (description);
writer.RenderEndTag (); //description
//Style Selection Box
writer.AddAttribute ("id", "styleboxcontainer");
writer.RenderBeginTag ("div");
writer.AddAttribute ("id", "stylebox");
writer.AddAttribute ("style", "display: none;");
writer.RenderBeginTag ("div");
writer.RenderBeginTag("ul");
writer.RenderBeginTag("li");
writer.AddAttribute ("href", "#");
writer.AddAttribute ("title", dark);
writer.AddAttribute ("onclick", "setActiveStyleSheet('" + dark + "')");
writer.RenderBeginTag("a");
writer.Write (dark);
writer.RenderEndTag (); //a
writer.RenderEndTag (); //li
writer.RenderBeginTag("li");
writer.AddAttribute ("href", "#");
writer.AddAttribute ("title", light);
writer.AddAttribute ("onclick", "setActiveStyleSheet('" + light + "')");
writer.RenderBeginTag("a");
writer.Write (light);
writer.RenderEndTag (); //a
writer.RenderEndTag (); //li
writer.RenderEndTag (); //ul
writer.RenderEndTag (); //div stylebox
writer.RenderBeginTag ("div");
writer.Write ("<span class=\"style_toggle\">");
writer.Write ("<a href=\"javascript:toggle_stylebox()\">");
writer.Write ("<span id=\"showlink\">" + Catalog.GetString("Show Styles") + "</span><span id=\"hidelink\" ");
writer.Write ("style=\"display:none;\">" + Catalog.GetString("Hide Styles") + "</span></a></span>" + Environment.NewLine);
writer.RenderEndTag (); //div toggle
writer.RenderEndTag (); //div styleboxcontainer
writer.RenderEndTag (); //container1
WriteFooter (writer);
writer.RenderEndTag (); //body
writer.RenderEndTag (); //html
writer.Close ();
stream.Close ();
}
/// <summary>
/// Renders the controls.
/// </summary>
/// <param name="parentControl">The parent control.</param>
/// <param name="writer">The writer.</param>
/// <param name="controls">The controls.</param>
public override void RenderControls(System.Web.UI.Control parentControl, System.Web.UI.HtmlTextWriter writer, System.Web.UI.Control[] controls)
{
base.RenderControls(parentControl, writer, controls);
}
