protected void Boton_Excel_Dios_Click(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
StringWriter sw = new StringWriter(sb);
HtmlTextWriter htw = new HtmlTextWriter(sw);
Page page = new Page();
HtmlForm form = new HtmlForm();
GridView_Dios.DataSourceID = string.Empty;
GridView_Dios.EnableViewState = false;
GridView_Dios.AllowPaging = false;
GridView_Dios.DataSource = LBPD.Logica_Mostrar_Precios();
GridView_Dios.DataBind();
page.EnableEventValidation = false;
page.DesignerInitialize();
page.Controls.Add(form);
form.Controls.Add(GridView_Dios);
page.RenderControl(htw);
Response.Clear();
Response.Buffer = true;
Response.ContentType = "applicattion/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment;filename=data.xls");
Response.Charset = "UTF-8";
Response.ContentEncoding = Encoding.Default;
Response.Write(sb.ToString());
Response.End();
}
protected override void Render(HtmlTextWriter writer)
{
if (!string.IsNullOrEmpty(this.ID) && this.Text.Length == 0) {
this.Text = LocalizationUtility.GetText(this.ID);
}
base.Render(writer);
}
/// <Summary>RenderEditMode renders the Edit mode of the control</Summary>
/// <Param name="writer">A HtmlTextWriter.</Param>
protected override void RenderEditMode( HtmlTextWriter writer )
{
PortalSettings _portalSettings = Globals.GetPortalSettings();
//Get the Pages
ArrayList tabs = Globals.GetPortalTabs(_portalSettings.PortalId, true, true, false, false, false);
//Render the Select Tag
ControlStyle.AddAttributesToRender(writer);
writer.AddAttribute(HtmlTextWriterAttribute.Name, this.UniqueID);
writer.RenderBeginTag(HtmlTextWriterTag.Select);
for (int tabIndex = 0; tabIndex <= tabs.Count - 1; tabIndex++)
{
TabInfo tab = (TabInfo)tabs[tabIndex];
//Add the Value Attribute
writer.AddAttribute(HtmlTextWriterAttribute.Value, tab.TabID.ToString());
if (tab.TabID == IntegerValue)
{
//Add the Selected Attribute
writer.AddAttribute(HtmlTextWriterAttribute.Selected, "selected");
}
//Render Option Tag
writer.RenderBeginTag(HtmlTextWriterTag.Option);
writer.Write(tab.TabName);
writer.RenderEndTag();
}
//Close Select Tag
writer.RenderEndTag();
}
protected override void RenderBeginTag(HtmlTextWriter writer)
{
writer.Indent++;
// Div
writer.AddAttribute(HtmlTextWriterAttribute.Id, this.Control.ClientID);
// inject the asp.RadioButtonList css entries into the new HTML ouput generated.
string cssClass = String.Empty;
if (!string.IsNullOrEmpty(this.Control.CssClass))
{
cssClass = Helpers.BuildClassList(cssClass, this.Control.CssClass);
}
RadioButtonList controlList = this.Control as RadioButtonList;
if (controlList != null)
{
if (controlList.RepeatDirection == RepeatDirection.Horizontal)
{
cssClass = Helpers.BuildClassList(cssClass, CBootstrapFormInlineLayoutClassName);
}
}
if (!string.IsNullOrEmpty(cssClass.Trim()))
{
writer.AddAttribute(HtmlTextWriterAttribute.Class, cssClass.Trim());
}
}
protected override void Render(HtmlTextWriter writer)
{
Literal itmCaption = new Literal();
itmCaption.Text = "<label for=\"" + this.ClientID + "\" class=\"" + this.CaptionCssClass + "\">" + this.Caption + "</label>";
itmCaption.RenderControl(writer);
base.Render(writer);
}
internal static void WriteSkipLinkStart(HtmlTextWriter writer, Version renderingCompatibility, bool designMode, string skipLinkText, string spacerImageUrl, string clientID) {
if (skipLinkText.Length != 0 && !designMode) {
if (renderingCompatibility >= VersionUtil.Framework45) {
writer.AddAttribute(HtmlTextWriterAttribute.Href, '#' + clientID + SkipLinkContentMark);
writer.AddStyleAttribute(HtmlTextWriterStyle.Position, "absolute");
writer.AddStyleAttribute(HtmlTextWriterStyle.Left, "-10000px");
writer.AddStyleAttribute(HtmlTextWriterStyle.Top, "auto");
writer.AddStyleAttribute(HtmlTextWriterStyle.Width, "1px");
writer.AddStyleAttribute(HtmlTextWriterStyle.Height, "1px");
writer.AddStyleAttribute(HtmlTextWriterStyle.Overflow, "hidden");
writer.RenderBeginTag(HtmlTextWriterTag.A);
writer.Write(skipLinkText);
writer.RenderEndTag();
}
else {
writer.AddAttribute(HtmlTextWriterAttribute.Href, '#' + clientID + SkipLinkContentMark);
writer.RenderBeginTag(HtmlTextWriterTag.A);
writer.AddAttribute(HtmlTextWriterAttribute.Alt, skipLinkText);
writer.AddAttribute(HtmlTextWriterAttribute.Src, spacerImageUrl);
writer.AddStyleAttribute(HtmlTextWriterStyle.BorderWidth, "0px");
writer.AddAttribute(HtmlTextWriterAttribute.Width, "0");
writer.AddAttribute(HtmlTextWriterAttribute.Height, "0");
writer.RenderBeginTag(HtmlTextWriterTag.Img);
writer.RenderEndTag();
writer.RenderEndTag();
}
}
}
public void Render(HtmlTextWriter writer)
{
if (_isAutomatedTool)
{
var console = new StringProgressStatus();
ProcessInternal(console);
HttpContext.Current.Response.ContentType = "text/plain";
HttpContext.Current.Response.Write(Title + "\n\n");
HttpContext.Current.Response.Write(console.Output);
if (console.HasErrors)
{
HttpContext.Current.Response.StatusCode = 500;
HttpContext.Current.Response.TrySkipIisCustomErrors = true;
}
HttpContext.Current.Response.End();
}
else
{
var console = new CustomStyledHtml5WebConsole(HttpContext.Current.Response);
console.Title = Title;
console.Render(ProcessInternal);
}
}
protected void AddParameter(string name, string value, HtmlTextWriter writer)
{
writer.AddAttribute(HtmlTextWriterAttribute.Name, name);
writer.AddAttribute(HtmlTextWriterAttribute.Value, value);
writer.RenderBeginTag(HtmlTextWriterTag.Param);
writer.RenderEndTag();
}
/// <summary>
/// Outputs server control content to a provided <see cref="T:System.Web.UI.HtmlTextWriter" /> object and stores tracing information about the control if tracing is enabled.
/// </summary>
/// <param name="writer">The <see cref="T:System.Web.UI.HtmlTextWriter" /> object that receives the control content.</param>
public override void RenderControl( HtmlTextWriter writer )
{
if ( this.Text.Trim() != string.Empty )
{
writer.AddAttribute( "class", "warning" );
writer.AddAttribute( "href", "#" );
writer.AddAttribute( "tabindex", "-1" );
foreach (var key in this.Style.Keys.OfType<HtmlTextWriterStyle>())
{
writer.AddStyleAttribute( key, this.Style[key] );
}
writer.RenderBeginTag( HtmlTextWriterTag.A );
writer.AddAttribute("class", "fa fa-exclamation-triangle");
writer.RenderBeginTag( HtmlTextWriterTag.I );
writer.RenderEndTag();
writer.RenderEndTag();
writer.AddAttribute( "class", "alert alert-warning warning-message" );
writer.AddAttribute( "style", "display:none" );
writer.RenderBeginTag( HtmlTextWriterTag.Div );
writer.RenderBeginTag( HtmlTextWriterTag.Small );
writer.Write( this.Text.Trim() );
writer.RenderEndTag();
writer.RenderEndTag();
}
}
public static void PrintWebControl(Control ctrl, string Script)
{
StringWriter stringWrite = new StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite);
if (ctrl is WebControl)
{
Unit w = new Unit(100, UnitType.Percentage); ((WebControl)ctrl).Width = w;
}
Page pg = new Page();
pg.EnableEventValidation = false;
if (Script != string.Empty)
{
pg.ClientScript.RegisterStartupScript(pg.GetType(), "PrintJavaScript", Script);
}
HtmlForm frm = new HtmlForm();
pg.Controls.Add(frm);
frm.Attributes.Add("runat", "server");
frm.Controls.Add(ctrl);
pg.DesignerInitialize();
pg.RenderControl(htmlWrite);
string strHTML = stringWrite.ToString();
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Write(strHTML);
HttpContext.Current.Response.Write("<script>window.print();</script>");
HttpContext.Current.Response.End();
}
internal static void WriteSkipLinkEnd(HtmlTextWriter writer, bool designMode, string skipLinkText, string clientID) {
if (skipLinkText.Length != 0 && !designMode) {
writer.AddAttribute(HtmlTextWriterAttribute.Id, clientID + SkipLinkContentMark); // XHTML 1.1 needs id instead of name
writer.RenderBeginTag(HtmlTextWriterTag.A);
writer.RenderEndTag();
}
}
public new void ProcessRequest(IHttpRequest httpReq, IHttpResponse httpRes, string operationName)
{
EndpointHost.Config.AssertFeatures(Feature.Metadata);
var operations = EndpointHost.ServiceOperations;
if (httpReq.QueryString["xsd"] != null)
{
var xsdNo = Convert.ToInt32(httpReq.QueryString["xsd"]);
var schemaSet = XsdUtils.GetXmlSchemaSet(operations.AllOperations.Types);
var schemas = schemaSet.Schemas();
var i = 0;
if (xsdNo >= schemas.Count)
{
throw new ArgumentOutOfRangeException("xsd");
}
httpRes.ContentType = "text/xml";
foreach (XmlSchema schema in schemaSet.Schemas())
{
if (xsdNo != i++) continue;
schema.Write(httpRes.Output);
break;
}
return;
}
var writer = new HtmlTextWriter(httpRes.Output);
httpRes.ContentType = "text/html";
ProcessOperations(writer, httpReq);
writer.Flush();
}
protected override void Render(HtmlTextWriter writer)
{
int num;
int.TryParse(HttpContext.Current.Request.QueryString.Get("id"), out num);
ActivityInfo activity = VshopBrowser.GetActivity(num);
if (activity != null)
{
string format = "<div class=\"qb_mb10 qb_flex\"><input type=\"text\" class=\"mod_input flex_box\" style=\"height:35px;\" placeholder=\"您的{0}\" id=\"{1}\"></div>";
StringBuilder builder = new StringBuilder();
builder.AppendFormat("<input type=\"hidden\" id=\"id\" value=\"{0}\">", num);
if (!string.IsNullOrEmpty(activity.Item1))
{
builder.AppendFormat(format, activity.Item1, "item1");
}
if (!string.IsNullOrEmpty(activity.Item2))
{
builder.AppendFormat(format, activity.Item2, "item2");
}
if (!string.IsNullOrEmpty(activity.Item3))
{
builder.AppendFormat(format, activity.Item3, "item3");
}
if (!string.IsNullOrEmpty(activity.Item4))
{
builder.AppendFormat(format, activity.Item4, "item4");
}
if (!string.IsNullOrEmpty(activity.Item5))
{
builder.AppendFormat(format, activity.Item5, "item5");
}
writer.Write(builder.ToString());
}
}
protected void btnExcel_Click(object sender, EventArgs e)
{
//Create a dummy GridView
GridView GridView1 = new GridView();
GridView1.AllowPaging = false;
GridView1.DataSource = BindGridView();
GridView1.DataBind();
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition",
"attachment;filename=" + DateTime.Now.Year + "-Newly_Hired" + ".xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
for (int i = 0; i < GridView1.Rows.Count; i++)
{
//Apply text style to each Row
GridView1.Rows[i].Attributes.Add("class", "textmode");
}
GridView1.RenderControl(hw);
//style to format numbers to string
string style = @"<style> .textmode { mso-number-format:\@; } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
/// <summary>
/// Accordions the HTML.
/// </summary>
/// <param name="html">The HTML.</param>
/// <param name="items">The items.</param>
/// <param name="headertemplete">The headertemplete.</param>
/// <param name="itemtemplete">The itemtemplete.</param>
public static void AccordionHtml(this HtmlHelper html, List<AccordionItem> items, Func<AccordionItem, string> headertemplete, Func<AccordionLeafItem, string> itemtemplete)
{
if (items != null)
{
StringBuilder buffer = new StringBuilder();
HtmlTextWriter writer = new HtmlTextWriter(new StringWriter(buffer));
foreach (AccordionItem item in items)
{
writer.AddAttribute(HtmlTextWriterAttribute.Class, "accordionheadercontainer");
writer.RenderBeginTag(HtmlTextWriterTag.Div);
writer.Write(headertemplete(item));
writer.RenderEndTag();
writer.AddAttribute(HtmlTextWriterAttribute.Class, "accordionbody");
writer.AddStyleAttribute(HtmlTextWriterStyle.Display, "none");
writer.RenderBeginTag(HtmlTextWriterTag.Div);
writer.RenderBeginTag(HtmlTextWriterTag.Ul);
foreach (AccordionLeafItem leafitem in item.Children)
{
writer.AddAttribute(HtmlTextWriterAttribute.Class, "accordionitemcontainer");
writer.RenderBeginTag(HtmlTextWriterTag.Li);
writer.Write(itemtemplete(leafitem));
writer.RenderEndTag();
}
writer.RenderEndTag();
writer.RenderEndTag();
}
HttpContext.Current.Response.Write(buffer.ToString());
}
}
/// <summary>
/// 导出Excel
/// </summary>
protected void btnExport_Click(object sender, EventArgs e)
{
try
{
HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=\""
+ System.Web.HttpUtility.UrlEncode("高位货架库位使用情况列表", System.Text.Encoding.UTF8) + ".xls\"");
HttpContext.Current.Response.Charset = "GB2312";
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");
HttpContext.Current.Response.ContentType = "application/ms-excel"; //image/JPEG;text/HTML;image/GIF;vnd.ms-excel/msword
this.grid.AllowPaging = false;
this.BindGrid();
this.panel1.Page.EnableViewState = false;
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
this.panel1.RenderControl(hw);
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.End();
}
catch
{
}
}
protected void btnPDF_Click(object sender, ImageClickEventArgs e)
{
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=UserDetails.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
var sw = new StringWriter();
var hw = new HtmlTextWriter(sw);
gvdetails.AllowPaging = false;
gvdetails.DataBind();
gvdetails.RenderControl(hw);
gvdetails.HeaderRow.Style.Add("width", "15%");
gvdetails.HeaderRow.Style.Add("font-size", "10px");
gvdetails.Style.Add("text-decoration", "none");
gvdetails.Style.Add("font-family", "Arial, Helvetica, sans-serif;");
gvdetails.Style.Add("font-size", "8px");
var sr = new StringReader(sw.ToString());
var pdfDoc = new Document(PageSize.A2, 7f, 7f, 7f, 0f);
var htmlparser = new HTMLWorker(pdfDoc);
PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();
htmlparser.Parse(sr);
pdfDoc.Close();
Response.Write(pdfDoc);
Response.End();
}
//- #Render -//
/// <summary>
/// Removes viewstate, event validation and the ASP.NET form element from the page
/// </summary>
/// <param name="originalWriter">The original writer.</param>
protected override void Render(HtmlTextWriter originalWriter)
{
var stringWriter = new StringWriter(CultureInfo.CurrentCulture);
var htmlTextWriter = new HtmlTextWriter(stringWriter);
//+
base.Render(htmlTextWriter);
htmlTextWriter.Close();
//+
String data = stringWriter.GetStringBuilder().ToString();
String pattern = @"<div>([\r\n\s]*)<input type=""hidden"" name=""__VIEWSTATE"" id=""__VIEWSTATE"" value=""(?<viewstate>[+/=a-z0-9]+)"" />([\r\n\s]*)</div>";
data = Regex.Replace(data, pattern, String.Empty, RegexOptions.IgnoreCase);
pattern = @"<div>([\r\n\s]*)<input type=""hidden"" name=""__EVENTVALIDATION"" id=""__EVENTVALIDATION"" value=""(?<eventvalidation>[+/=a-z0-9]+)"" />([\r\n\s]*)</div>";
data = Regex.Replace(data, pattern, String.Empty, RegexOptions.IgnoreCase);
pattern = @"<form name=""ctl([\d]+)"" method=""post"" action="""" id=""ctl([\d]+)"">([\r\n\s]*)";
data = Regex.Replace(data, pattern, String.Empty, RegexOptions.IgnoreCase);
if (!EnableState)
{
pattern = @"<form name=""ctl([\d]+)"" method=""post"">([\r\n\s]*)";
data = Regex.Replace(data, pattern, String.Empty, RegexOptions.IgnoreCase);
}
pattern = @"([\r\n\s]*)</form>";
String replacement = String.Empty;
if (EnableState)
{
replacement = new StateArea().GetRenderData() + @"
</form>";
}
data = Regex.Replace(data, pattern, replacement, RegexOptions.IgnoreCase);
//+
originalWriter.Write(data);
}
public string Render ()
{
StringWriter sw = new StringWriter ();
HtmlTextWriter tw = new HtmlTextWriter (sw);
Render (tw);
return sw.ToString ();
}
public void Render(
HtmlTextWriter writer,
TypeSignature signature,
TypeRenderOption options)
{
Render(writer, signature, options, false);
}
protected override void AddAttributesToRender(HtmlTextWriter writer)
{
string associatedControlID = this.AssociatedControlID;
if (associatedControlID.Length != 0)
{
if (this.AssociatedControlInControlTree)
{
Control control = this.FindControl(associatedControlID);
if (control == null)
{
if (!base.DesignMode)
{
throw new HttpException(System.Web.SR.GetString("LabelForNotFound", new object[] { associatedControlID, this.ID }));
}
}
else
{
writer.AddAttribute(HtmlTextWriterAttribute.For, control.ClientID);
}
}
else
{
writer.AddAttribute(HtmlTextWriterAttribute.For, associatedControlID);
}
}
base.AddAttributesToRender(writer);
}
private string CreateSummary() {
StringWriter stringWriter = new StringWriter();
HtmlTextWriter htmlWriter = new HtmlTextWriter(stringWriter);
htmlWriter.AddAttribute(HtmlTextWriterAttribute.Class,
"table table-bordered");
htmlWriter.RenderBeginTag(HtmlTextWriterTag.Table);
htmlWriter.AddAttribute(HtmlTextWriterAttribute.Class, "success");
htmlWriter.RenderBeginTag(HtmlTextWriterTag.Tr);
htmlWriter.RenderBeginTag(HtmlTextWriterTag.Td);
htmlWriter.Write("Requests");
htmlWriter.RenderEndTag();
htmlWriter.RenderBeginTag(HtmlTextWriterTag.Td);
htmlWriter.Write(requestCount);
htmlWriter.RenderEndTag();
htmlWriter.RenderEndTag();
htmlWriter.AddAttribute(HtmlTextWriterAttribute.Class, "success");
htmlWriter.RenderBeginTag(HtmlTextWriterTag.Tr);
htmlWriter.RenderBeginTag(HtmlTextWriterTag.Td);
htmlWriter.Write("Total Time");
htmlWriter.RenderEndTag();
htmlWriter.RenderBeginTag(HtmlTextWriterTag.Td);
htmlWriter.Write("{0:F5} seconds", totalTime);
htmlWriter.RenderEndTag();
htmlWriter.RenderEndTag();
htmlWriter.RenderEndTag();
return stringWriter.ToString();
}
/// <summary>
/// Outputs server control content to a provided <see cref="T:System.Web.UI.HtmlTextWriter" /> object and stores tracing information about the control if tracing is enabled.
/// </summary>
/// <param name="writer">The <see cref="T:System.Web.UI.HtmlTextWriter" /> object that receives the control content.</param>
public override void RenderControl( HtmlTextWriter writer )
{
if ( this.Visible )
{
string alertType = NotificationBoxType.ToString().ToLower();
bool showMessage = !string.IsNullOrWhiteSpace( Heading ) || !string.IsNullOrWhiteSpace( Title ) || !string.IsNullOrWhiteSpace( this.Text );
if ( showMessage )
{
writer.AddAttribute( "class", "alert alert-" + alertType );
writer.RenderBeginTag( HtmlTextWriterTag.Div );
if ( !string.IsNullOrWhiteSpace( Heading ) )
{
writer.RenderBeginTag( HtmlTextWriterTag.H4 );
writer.Write( Heading );
writer.RenderEndTag();
}
if ( !string.IsNullOrWhiteSpace( Title ) )
{
writer.RenderBeginTag( HtmlTextWriterTag.Strong );
writer.Write( Title + " ");
writer.RenderEndTag();
}
base.RenderControl( writer );
writer.RenderEndTag();
}
}
}
private void ExportToPDF()
{
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter hw = new HtmlTextWriter(sw))
{
//To Export all pages
this.gvExportToPdf.AllowPaging = false;
//this.BindGridView();
this.gvExportToPdf.RenderControl(hw);
StringReader sr = new StringReader(sw.ToString());
Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=DashboardReport.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();
htmlparser.Parse(sr);
pdfDoc.Close();
Response.Write(pdfDoc);
Response.End();
}
}
}
public void GetEmployeesAccessMasterGrid()
{
Grid mastergrid = new Grid
{
DataSourceId = "Employees",
ID = "test",
Page = Testpage,
ConnectionString = ConnectionAccessOleDb
};
Testpage.Controls.Add(mastergrid);
Grid slavegrid = new Grid
{
DataSourceId = "Territories",
ID = "test2",
Page = Testpage,
MasterGrid = "test",
ConnectionString = ConnectionAccessOleDb
};
Testpage.Controls.Add(slavegrid);
StringBuilder sb = new StringBuilder();
StringWriter sw = new StringWriter(sb);
HtmlTextWriter gridwriter = new HtmlTextWriter(sw);
mastergrid.RenderControl(gridwriter);
sb = new StringBuilder();
sw = new StringWriter(sb);
gridwriter = new HtmlTextWriter(sw);
slavegrid.RenderControl(gridwriter);
Assert.Greater(mastergrid.MasterTable.Rows.Count, 1);
Assert.IsTrue(mastergrid.MasterTable.GotSchema);
Assert.IsFalse(slavegrid.MasterTable.GotSchema);
}
protected override void Render(HtmlTextWriter writer)
{
CartBL cartBL = new CartBL();
lblProductCount.Text = cartBL.GetProductsCount(Session["cartID"].ToString()).ToString();
lblCartPrice.Text = string.Format("{0:N2}", cartBL.GetTotal(Session["cartID"].ToString()));
base.Render(writer);
}
protected override void Render(HtmlTextWriter writer)
{
switch (((OrderStatus) this.PurchaseStatusCode))
{
case OrderStatus.WaitBuyerPay:
base.NavigateUrl = Globals.ApplicationPath + "/Admin/purchaseOrder/UnPaymentPurchaseOrderDetails.aspx?PurchaseOrderId=" + this.PurchaseOrderId;
break;
case OrderStatus.BuyerAlreadyPaid:
base.NavigateUrl = Globals.ApplicationPath + "/Admin/purchaseOrder/UnShippingPurchaseOrderDetails.aspx?PurchaseOrderId=" + this.PurchaseOrderId;
break;
case OrderStatus.SellerAlreadySent:
base.NavigateUrl = Globals.ApplicationPath + "/Admin/purchaseOrder/DeliveredPurchaseOrderDetails.aspx?PurchaseOrderId=" + this.PurchaseOrderId;
break;
case OrderStatus.Closed:
base.NavigateUrl = Globals.ApplicationPath + "/Admin/purchaseOrder/ClosedPurchaseOrderDetails.aspx?PurchaseOrderId=" + this.PurchaseOrderId;
break;
case OrderStatus.Finished:
base.NavigateUrl = Globals.ApplicationPath + "/Admin/purchaseOrder/FinishedPurchaseOrderDetails.aspx?PurchaseOrderId=" + this.PurchaseOrderId;
break;
}
base.Render(writer);
}
private void RenderCurrencySign(HtmlTextWriter writer)
{
var cs = GetCurrencySign();
if (!string.IsNullOrEmpty(cs))
writer.Write(cs + " ");
}
public new void ProcessRequest(IHttpRequest httpReq, IHttpResponse httpRes, string operationName)
{
if (!AssertAccess(httpReq, httpRes, httpReq.QueryString["op"])) return;
var operationTypes = EndpointHost.Metadata.GetAllTypes();
if (httpReq.QueryString["xsd"] != null)
{
var xsdNo = Convert.ToInt32(httpReq.QueryString["xsd"]);
var schemaSet = XsdUtils.GetXmlSchemaSet(operationTypes);
var schemas = schemaSet.Schemas();
var i = 0;
if (xsdNo >= schemas.Count)
{
throw new ArgumentOutOfRangeException("xsd");
}
httpRes.ContentType = "text/xml";
foreach (XmlSchema schema in schemaSet.Schemas())
{
if (xsdNo != i++) continue;
schema.Write(httpRes.OutputStream);
break;
}
return;
}
using (var sw = new StreamWriter(httpRes.OutputStream))
{
var writer = new HtmlTextWriter(sw);
httpRes.ContentType = "text/html";
ProcessOperations(writer, httpReq, httpRes);
}
}
/// <summary>
/// 数据导出到Excel
/// </summary>
/// <returns></returns>
private void OutputDataToExcle(string strFilename)
{
string sWhereSQL = " And SignStatus=1";
if (txtUserSalaryOpCode.Text.Length > 0)
{
sWhereSQL = sWhereSQL + " And a.OpCode = '" + txtUserSalaryOpCode.Text + "'";
}
//月份起始和月份结束同时不为空时，按区间查找数据
if (txtSalaryYears.Text.Length > 0 && txtSalaryYears2.Text.Length > 0)
{
sWhereSQL += " And a.SalaryYears >= '" + txtSalaryYears.Text + "'";
if (ddlImportRec.SelectedIndex > 0)
{
sWhereSQL += " And a.SalaryDate>='" + ddlImportRec.SelectedItem.Text + "'";
}
sWhereSQL += " And a.SalaryYears <= '" + txtSalaryYears2.Text + "'";
if (ddlImportRec2.SelectedIndex > 0)
{
sWhereSQL += " And a.SalaryDate <= DateAdd(mi,3,'" + ddlImportRec2.SelectedItem.Text + "')";
}
}
//仅月份起始不为空时，只按月份起始查找数据
else if (txtSalaryYears.Text.Length > 0)
{
sWhereSQL += " And a.SalaryYears = '" + txtSalaryYears.Text + "'";
if (ddlImportRec.SelectedIndex > 0)
{
sWhereSQL += " And a.SalaryRecGuid ='" + ddlImportRec.SelectedValue.ToString() + "'";
}
}
//仅月份结束不为空时，只按月份结束查找数据
else if (txtSalaryYears2.Text.Length > 0)
{
sWhereSQL += " And a.SalaryYears = '" + txtSalaryYears2.Text + "'";
if (ddlImportRec2.SelectedIndex > 0)
{
sWhereSQL += " And a.SalaryRecGuid ='" + ddlImportRec2.SelectedValue.ToString() + "'";
}
}
//月份起始和月份结束同时不为空时，按区间查找数据
if (ddlPlatform.SelectedIndex == 2)
{
sWhereSQL += " And a.SignPlatform = 1 ";
}
else if (ddlPlatform.SelectedIndex == 1)
{
sWhereSQL += " And (a.SignPlatform = 0 or a.SignPlatform is null)";
}
//如果不是从属与最高部门的员工，此页面只能查询其所属子部门员工的数据！
SqlDataReader sdrUser = SysClass.SysUser.GetUserInfoByReader(SysClass.SysGlobal.GetCurrentOpCode());
if (sdrUser.Read())
{
SqlDataReader sdrOrg = SysClass.SysOrgan.GetSingleOrganByReader(Convert.ToInt32(sdrUser["OrganID"]));
if (sdrOrg.Read())
{
if (sdrOrg["POrganID"].ToString() != "0")
{
sWhereSQL += " And b.OrganID = " + Convert.ToInt32(sdrUser["OrganID"]);
}
}
sdrOrg.Close();
}
sdrUser.Close();
DataSet ds = SysClass.SysUserSalary.GetUserSalaryLstByDataSet(sWhereSQL);
//创建DataTable对象
DataTable dt = new DataTable("output");
//构建表结构,往表中添加列
dt.Columns.Add("序号", typeof(int));
dt.Columns.Add("工号", typeof(string));
dt.Columns.Add("姓名", typeof(string));
dt.Columns.Add("工资年月", typeof(string));
dt.Columns.Add("发放日期", typeof(string));
dt.Columns.Add("发放金额", typeof(decimal));
dt.Columns.Add("签收状态", typeof(string));
dt.Columns.Add("签收时间", typeof(string));
dt.Columns.Add("签收端", typeof(string));
for (int iLoop = 0; iLoop < ds.Tables[0].Rows.Count; iLoop++)
{
//创建DataRow对象
DataRow dr = dt.NewRow();
//新增数据
dr[0] = iLoop + 1;
dr[1] = ds.Tables[0].Rows[iLoop]["OpCode"].ToString();
dr[2] = ds.Tables[0].Rows[iLoop]["OpName"].ToString();
dr[3] = ds.Tables[0].Rows[iLoop]["SalaryYears"].ToString();
string SalaryOnlyDate = ds.Tables[0].Rows[iLoop]["SalaryDate"].ToString();
dr[4] = SalaryOnlyDate.Length > 0 ? DateTime.Parse(SalaryOnlyDate).ToString("yyyy-MM-dd") : "";
dr[5] = ds.Tables[0].Rows[iLoop]["TotalSalary"].ToString();
dr[6] = "已签收";
dr[7] = ds.Tables[0].Rows[iLoop]["SignDate"].ToString();
string SignPlatform = ds.Tables[0].Rows[iLoop]["SignPlatform"].ToString();
dr[8] = SignPlatform == "1" ? "手机端" : "PC端";
//把数据添加到表结构中
dt.Rows.Add(dr);
}
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;
// 设置编码和附件格式
curContext.Response.ContentType = "application/vnd.ms-excel";
curContext.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
curContext.Response.Charset = "gb2312";
// 导出excel文件
strWriter = new System.IO.StringWriter();
htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);
// 为了解决dgData中可能进行了分页的情况，需要重新定义一个无分页的DataGrid
dgExport = new System.Web.UI.WebControls.DataGrid();
dgExport.DataSource = dt.DefaultView;
dgExport.AllowPaging = false;
dgExport.DataBind();
// 返回客户端
dgExport.RenderControl(htmlWriter);
curContext.Response.Clear();
curContext.Response.Buffer = true;
curContext.Response.Write("上海动车段工资电子签收系统");
curContext.Response.AddHeader("Content-Disposition", "attachment;filename=" + strFilename);
curContext.Response.Write("<meta http-equiv=\"content-type\" content=\"application/ms-excel; charset=gb2312\"/>" + strWriter.ToString());
curContext.Response.Flush();
curContext.Response.End();
}
protected void OnButtonCommand(object sender, CommandEventArgs e)
{
//Event handler for command button clicked
//Change view to Viewer and reset to clear existing data
Master.Viewer.Reset();
//Get parameters for the query
DateTime _from = Master.FromDate;
DateTime _to = Master.ToDate;
string _client = Master.ClientNumber;
string _clientName = Master.ClientName;
string _div = Master.DivisionNumber;
//Initialize control values
LocalReport report = Master.Viewer.LocalReport;
report.DisplayName = REPORT_NAME;
report.EnableExternalImages = true;
EnterpriseGateway enterprise = new EnterpriseGateway();
DataSet ds = enterprise.FillDataset(USP_REPORT, TBL_REPORT, new object[] { _client, _div, _from.ToString("yyyy-MM-dd"), _to.ToString("yyyy-MM-dd") });
if (ds.Tables[TBL_REPORT].Rows.Count >= 0)
{
switch (e.CommandName)
{
case "Run":
//Set local report and data source
System.IO.Stream stream = Master.GetReportDefinition(REPORT_SRC);
report.LoadReportDefinition(stream);
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT]));
//Set the report parameters for the report
ReportParameter client = new ReportParameter("ClientNumber", _client);
ReportParameter div = new ReportParameter("ClientDivision", _div);
ReportParameter from = new ReportParameter("StartPUDate", _from.ToString("yyyy-MM-dd"));
ReportParameter to = new ReportParameter("EndPUDate", _to.ToString("yyyy-MM-dd"));
ReportParameter clientName = new ReportParameter("ClientName", _clientName);
report.SetParameters(new ReportParameter[] { client, div, from, to, clientName });
//Update report rendering with new data
report.Refresh();
if (!Master.Viewer.Enabled)
{
Master.Viewer.CurrentPage = 1;
}
break;
case "Data":
//Set local export report and data source
report.LoadReportDefinition(Master.CreateExportRdl(ds, REPORT_DS, "RGXSQLR.TSORT"));
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT]));
report.Refresh();
break;
case "Excel":
//Create Excel mime-type page
Response.ClearHeaders();
Response.Clear();
Response.Charset = "";
Response.AddHeader("Content-Disposition", "inline; filename=OnTimeByDay.xls");
Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream";
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
DataGrid dg = new DataGrid();
dg.DataSource = ds.Tables[TBL_REPORT];
dg.DataBind();
dg.RenderControl(hw);
Response.Write(sw.ToString());
Response.End();
break;
}
}
else
{
Master.Status = "There were no records found.";
}
}
protected override void Render(System.Web.UI.HtmlTextWriter writer)
{
base.Render(new RewriteForm(writer));
}
protected void OnButtonCommand(object sender, CommandEventArgs e)
{
//Event handler for command button clicked
try {
//Change view to Viewer and reset to clear existing data
Master.Viewer.Reset();
//Get parameters for the query
string _client = this.cboClient.SelectedValue == "" ? null : this.cboClient.SelectedValue;
DateTime _pustartdate = DateTime.Parse(this.txtFrom.Text);
DateTime _puenddate = DateTime.Parse(this.txtTo.Text);
//Initialize control values
LocalReport report = Master.Viewer.LocalReport;
report.DisplayName = TITLE;
report.EnableExternalImages = true;
EnterpriseRGateway enterprise = new EnterpriseRGateway();
DataSet ds = enterprise.FillDataset(this.mUSPName, mTBLName, new object[] { _client, _pustartdate, _puenddate });
if (ds.Tables[mTBLName] == null)
{
ds.Tables.Add(mTBLName);
}
switch (e.CommandName)
{
case "Run":
//Set local report and data source
System.IO.Stream stream = Master.GetReportDefinition(SOURCE);
report.LoadReportDefinition(stream);
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName]));
//Set the report parameters for the report
ReportParameter client = new ReportParameter("ClientNumber", _client);
ReportParameter pustartdate = new ReportParameter("PickupStartDate", _pustartdate.ToString("yyyy-MM-dd"));
ReportParameter puenddate = new ReportParameter("PickupEndDate", _puenddate.ToString("yyyy-MM-dd"));
report.SetParameters(new ReportParameter[] { client, pustartdate, puenddate });
//Update report rendering with new data
report.Refresh();
if (!Master.Viewer.Enabled)
{
Master.Viewer.CurrentPage = 1;
}
break;
case "Data":
//Set local export report and data source
report.LoadReportDefinition(Master.CreateExportRdl(ds, this.mDSName));
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName]));
report.Refresh();
break;
case "Excel":
//Create Excel mime-type page
Response.ClearHeaders();
Response.Clear();
Response.Charset = "";
Response.AddHeader("Content-Disposition", "inline; filename=InboundTracking.xls");
Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream";
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
DataGrid dg = new DataGrid();
dg.DataSource = ds.Tables[mTBLName];
dg.DataBind();
dg.RenderControl(hw);
Response.Write(sw.ToString());
Response.End();
break;
}
}
catch (Exception ex) { Master.ReportError(ex); }
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "详细";
Page.Title = title;
if (!IsPostBack)
{
try
{
if (!string.IsNullOrEmpty(Request["STAFF_ID"]))
{
valObj = BLLTable <HR_STAFF> .Factory(conn).GetRowData(HR_STAFF.Attribute.STAFF_ID, Request["STAFF_ID"]);
if (valObj == null)
{
return;
}
txtSTAFF_ID.Text = Convert.ToString(valObj.STAFF_ID);//Convert.ToDecimal
txtSTAFF_NO.Text = Convert.ToString(valObj.STAFF_NO);//Convert.ToString
txtNAME.Text = Convert.ToString(valObj.STAFF_NAME);//Convert.ToString
txtDEPT_ID.Text = Convert.ToString(valObj.DEPT_ID);//Convert.ToString
txtGENDER.Text = valObj.GENDER.ToString();
txtPHOTO.Text = Convert.ToString(valObj.PHOTO);//Convert.ToString
txtPOS_NAME.Text = Convert.ToString(valObj.POS_NAME);//Convert.ToString
txtSTATION_CODE.Text = Convert.ToString(valObj.STATION_CODE);//Convert.ToString
txtWORK_TYPE_CODE.Text = valObj.WORK_TYPE_CODE.ToString();
txtTECH_LEVEL_CODE.Text = Convert.ToString(valObj.TECH_LEVEL_CODE);//Convert.ToString
txtYMD.Text = Convert.ToString(valObj.YMD);//Convert.ToString
txtMOBILE.Text = Convert.ToString(valObj.MOBILE);//Convert.ToString
txtOFFICE_TEL.Text = Convert.ToString(valObj.OFFICE_TEL);//Convert.ToString
txtCERT_FLAG.Text = Convert.ToString(valObj.CERT_FLAG);//Convert.ToString
txtFIXED_FLAG.Text = Convert.ToString(valObj.FIXED_FLAG);//Convert.ToString
txtON_POS_FLAG.Text = Convert.ToString(valObj.ON_POS_FLAG);//Convert.ToString
txtPROFESSION_CODE.Text = Convert.ToString(valObj.PROFESSION_CODE);//Convert.ToString
txtPROFESSION_BGN_DATE.Text = Convert.ToString(valObj.PROFESSION_BGN_DATE);//Convert.ToString
txtJOIN_DATE.Text = Convert.ToString(valObj.JOIN_DATE);//Convert.ToString
txtPOLITICAL_STATUS_CODE.Text = Convert.ToString(valObj.POLITICAL_STATUS_CODE);//Convert.ToString
txtTITLE_CODE.Text = Convert.ToString(valObj.TITLE_CODE);//Convert.ToString
txtSTATUS_CODE.Text = Convert.ToString(valObj.STATUS_CODE);//Convert.ToString
txtADDR.Text = Convert.ToString(valObj.ADDR);//Convert.ToString
txtEMAIL.Text = Convert.ToString(valObj.EMAIL);//Convert.ToString
txtNATION.Text = Convert.ToString(valObj.NATION);//Convert.ToString
txtNATIVE_PLACE.Text = Convert.ToString(valObj.NATIVE_PLACE);//Convert.ToString
txtPOST_NO.Text = Convert.ToString(valObj.POST_NO);//Convert.ToString
txtDEGREE_CODE.Text = Convert.ToString(valObj.DEGREE_CODE);//Convert.ToString
txtGRAD_SCHOOL.Text = Convert.ToString(valObj.GRAD_SCHOOL);//Convert.ToString
txtGRAD_DATE.Text = Convert.ToString(valObj.GRAD_DATE);//Convert.ToString
txtMAJOR.Text = Convert.ToString(valObj.MAJOR);//Convert.ToString
txtADDTIME.Text = (valObj.AF_ADDTIME == DateTime.MinValue) ? "" : valObj.AF_ADDTIME.ToString("yyyy-MM-dd HH:mm");
txtEDITIME.Text = (valObj.AF_EDITTIME == DateTime.MinValue) ? "" : valObj.AF_EDITTIME.ToString("yyyy-MM-dd HH:mm");
txtREMARK.Text = Convert.ToString(valObj.REMARK);//Convert.ToString
txtUSER_ID.Text = Convert.ToString(valObj.USER_ID);//Convert.ToDecimal
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
if (Request["ajax"] != null)
{
Response.Clear();
Response.Buffer = true;
Response.Charset = "utf-8";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");//设置输出流为简体中文
//Response.ContentType = "html/text";
this.EnableViewState = false;
System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
divC.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
}
}
protected override void Render(System.Web.UI.HtmlTextWriter writer)
{
writer.Write("<table border=\"0\">");
SPUser currentUser = SPContext.Current.Web.CurrentUser;
if (currentUser.IsSiteAdmin)
{
writer.Write("<tr><td><div class=\"UserSectionTitle\">PowerShell Script</div></td></tr>");
writer.Write("<tr>");
writer.Write("<td>");
writer.Write(string.Format(@"<a href id=""btnPopupScript"" value=""Script"" href=""javascript:powerWebPartEditorShowPopup('{0}')"" >Script ({1} rows)</a>",
script.ClientID, String.IsNullOrEmpty(script.Value) ? "0" : (System.Text.RegularExpressions.Regex.Matches(script.Value, "\n").Count + 1).ToString()));
script.RenderControl(writer);
writer.Write("</td>");
writer.Write("</tr>");
writer.Write("<tr><td><div class=\"UserSectionHead\">Runas AppPool</div>");
runasAppPool.RenderControl(writer);
writer.Write("</td></tr>");
}
writer.Write("<tr><td><div class=\"UserSectionTitle\">Parameters</div></td></tr>");
//Parameter 1
if (currentUser.IsSiteAdmin || String.IsNullOrEmpty(parameterDescription1.Value) == false)
{
writer.Write("<tr><td><div class=\"UserSectionHead\">Parameter 1</div></td></tr>");
writer.Write("<tr>");
writer.Write("<td>");
parameterDescription1.RenderControl(writer);
if (currentUser.IsSiteAdmin)
{
writer.Write(string.Format(@"<a id=""btnAddDescriptionParameter1"" href=""javascript:powerWebPartEditorShowPopup('{0}')"" >{1}</a>",
parameterDescription1.ClientID, string.IsNullOrEmpty(parameterDescription1.Value) ? "add description" : parameterDescription1.Value));
}
else
{
writer.Write(string.Format("<div>{0}</div>", parameterDescription1.Value));
}
writer.Write("</td>");
writer.Write("</tr>");
writer.Write("<tr>");
writer.Write("<td>");
parameter1.RenderControl(writer);
writer.Write("</td>");
writer.Write("</tr>");
}
//Parameter 2
if (currentUser.IsSiteAdmin || String.IsNullOrEmpty(parameterDescription2.Value) == false)
{
writer.Write("<tr><td><div class=\"UserSectionHead\">Parameter 2</div></td></tr>");
writer.Write("<tr>");
writer.Write("<td>");
parameterDescription2.RenderControl(writer);
if (currentUser.IsSiteAdmin)
{
writer.Write(string.Format(@"<a id=""btnAddDescriptionParameter2"" href=""javascript:powerWebPartEditorShowPopup('{0}')"" >{1}</a>",
parameterDescription2.ClientID, string.IsNullOrEmpty(parameterDescription2.Value) ? "add description" : parameterDescription2.Value));
}
else
{
writer.Write(string.Format("<div>{0}</div>", parameterDescription2.Value));
}
writer.Write("</td>");
writer.Write("</tr>");
writer.Write("<tr>");
writer.Write("<td>");
parameter2.RenderControl(writer);
writer.Write("</td>");
writer.Write("</tr>");
}
//Parameter 3
if (currentUser.IsSiteAdmin || String.IsNullOrEmpty(parameterDescription3.Value) == false)
{
writer.Write("<tr><td><div class=\"UserSectionHead\">Parameter 3</div></td></tr>");
writer.Write("<tr>");
writer.Write("<td>");
parameterDescription3.RenderControl(writer);
if (currentUser.IsSiteAdmin)
{
writer.Write(string.Format(@"<a id=""btnAddDescriptionParameter3"" href=""javascript:powerWebPartEditorShowPopup('{0}')"" >{1}</a>",
parameterDescription3.ClientID, string.IsNullOrEmpty(parameterDescription3.Value) ? "add description" : parameterDescription3.Value));
}
else
{
writer.Write(string.Format("<div>{0}</div>", parameterDescription3.Value));
}
writer.Write("</td>");
writer.Write("</tr>");
writer.Write("<tr>");
writer.Write("<td>");
parameter3.RenderControl(writer);
writer.Write("</td>");
writer.Write("</tr>");
}
//Parameter 4
if (currentUser.IsSiteAdmin || String.IsNullOrEmpty(parameterDescription4.Value) == false)
{
writer.Write("<tr><td><div class=\"UserSectionHead\">Parameter 4</div></td></tr>");
writer.Write("<tr>");
writer.Write("<td>");
parameterDescription4.RenderControl(writer);
if (currentUser.IsSiteAdmin)
{
writer.Write(string.Format(@"<a id=""btnAddDescriptionParameter1"" href=""javascript:powerWebPartEditorShowPopup('{0}')"" >{1}</a>",
parameterDescription4.ClientID, string.IsNullOrEmpty(parameterDescription4.Value) ? "add description" : parameterDescription4.Value));
}
else
{
writer.Write(string.Format("<div>{0}</div>", parameterDescription4.Value));
}
writer.Write("</td>");
writer.Write("</tr>");
writer.Write("<tr>");
writer.Write("<td>");
parameter4.RenderControl(writer);
writer.Write("</td>");
writer.Write("</tr>");
}
writer.Write("</table>");
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "详细";
Page.Title = title;
if (!IsPostBack)
{
try
{
if (!string.IsNullOrEmpty(Request["USER_ID"]))
{
valObj = BLLTable <SYS_USER> .Factory(conn).GetRowData(SYS_USER.Attribute.USER_ID, Request["USER_ID"]);
if (valObj == null)
{
return;
}
txtUSER_ID.Text = Convert.ToString(valObj.USER_ID);//Convert.ToDecimal
txtUSER_NAME.Text = Convert.ToString(valObj.USER_NAME);//Convert.ToString
txtPASS.Text = Convert.ToString(valObj.PASS);//Convert.ToString
txtEMAIL.Text = Convert.ToString(valObj.EMAIL);//Convert.ToString
txtLOGIN_IPS.Text = Convert.ToString(valObj.LOGIN_IPS);//Convert.ToString
txtSTATE_FLAG.Text = valObj.USE_FLAG.ToString();
txtEDITIME.Text = (valObj.EDITTIME == DateTime.MinValue) ? "" : valObj.EDITTIME.ToString("yyyy-MM-dd HH:mm");
txtADDTIME.Text = (valObj.ADDTIME == DateTime.MinValue) ? "" : valObj.ADDTIME.ToString("yyyy-MM-dd HH:mm");
txtUSER_TYPE.Text = valObj.USER_TYPE.ToString();
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
if (Request["ajax"] != null)
{
Response.Clear();
Response.Buffer = true;
Response.Charset = "utf-8";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");//设置输出流为简体中文
//Response.ContentType = "html/text";
this.EnableViewState = false;
System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
divC.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
}
}
protected void OnButtonCommand(object sender, CommandEventArgs e)
{
//Event handler for command button clicked
try {
//Change view to Viewer and reset to clear existing data
Master.Viewer.Reset();
//Get parameters for the query
string _fromDate = DateTime.Parse(this.txtFrom.Text).ToString("yyyy-MM-dd");
string _toDate = DateTime.Parse(this.txtTo.Text).ToString("yyyy-MM-dd");
string _client = this.grdClients.SelectedRow.Cells[1].Text;
string _div = this.grdClients.SelectedRow.Cells[2].Text;
string _clientName = this.grdClients.SelectedRow.Cells[3].Text;
string _shipper = "", _shipperName = "";
//Initialize control values
LocalReport report = Master.Viewer.LocalReport;
report.DisplayName = TITLE;
report.EnableExternalImages = true;
EnterpriseRGateway enterprise = new EnterpriseRGateway();
DataSet ds = new DataSet();
string usp = "", reportDS = "", reportFile = "";
if (this.ddlFreightType.SelectedValue.ToLower() == "tsort")
{
usp = USP_REPORT_VENDOR;
reportDS = REPORT_DS_TSORT;
switch (this.cboViewBy.SelectedItem.Text.ToLower())
{
case "state": reportFile = REPORT_SRC_TSORT_STATE; break;
case "zone": reportFile = REPORT_SRC_TSORT_ZONE; break;
case "store": reportFile = REPORT_SRC_TSORT_STORE; break;
}
}
else if (this.ddlFreightType.SelectedValue.ToLower() == "returns")
{
usp = USP_REPORT_AGENT;
reportDS = REPORT_DS_RETURNS;
switch (this.cboViewBy.SelectedItem.Text.ToLower())
{
case "vendor": reportFile = REPORT_SRC_RETURNS_VENDOR; break;
case "store": reportFile = REPORT_SRC_RETURNS_STORE; break;
}
}
foreach (GridViewRow row in selectedShippers)
{
string __shipper = row.Cells[1].Text;
_shipper = _shipper.Length == 0 ? __shipper : _shipper + ", " + __shipper;
DataSet _ds = enterprise.FillDataset(usp, mTBLName, new object[] { _client, _div, __shipper, _fromDate, _toDate });
ds.Merge(_ds);
}
if (ds.Tables[mTBLName] == null)
{
ds.Tables.Add(mTBLName);
}
switch (e.CommandName)
{
case "Run":
//Set local report and data source
System.IO.Stream stream = Master.GetReportDefinition(reportFile);
report.LoadReportDefinition(stream);
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(reportDS, ds.Tables[mTBLName]));
//Set the report parameters for the report
ReportParameter fromDate = new ReportParameter("StartPUDate", _fromDate);
ReportParameter toDate = new ReportParameter("EndPUDate", _toDate);
ReportParameter client = new ReportParameter("ClientNumber", _client);
ReportParameter div = new ReportParameter("ClientDivision", _div);
ReportParameter clientName = new ReportParameter("ClientName", _clientName);
ReportParameter shipper = new ReportParameter(this.ddlShipper.SelectedValue == "0" ? "VendorNumber" : "AgentNumber", _shipper);
ReportParameter shipperName = new ReportParameter(this.ddlShipper.SelectedValue == "0" ? "VendorName" : "AgentName", _shipperName);
report.SetParameters(new ReportParameter[] { client, div, fromDate, toDate, clientName, shipper, shipperName });
//Update report rendering with new data
report.Refresh();
if (!Master.Viewer.Enabled)
{
Master.Viewer.CurrentPage = 1;
}
break;
case "Data":
//Set local export report and data source
report.LoadReportDefinition(Master.CreateExportRdl(ds, reportDS));
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(reportDS, ds.Tables[mTBLName]));
report.Refresh();
break;
case "Excel":
//Create Excel mime-type page
Response.ClearHeaders();
Response.Clear();
Response.Charset = "";
Response.AddHeader("Content-Disposition", "inline; filename=Discrepancy.xls");
Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream";
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
DataGrid dg = new DataGrid();
dg.DataSource = ds.Tables[mTBLName];
dg.DataBind();
dg.RenderControl(hw);
Response.Write(sw.ToString());
Response.End();
break;
}
}
catch (Exception ex) { Master.ReportError(ex); }
}
public override void RenderControl(System.Web.UI.HtmlTextWriter writer)
{
if (this.DesignMode)
{
base.RenderControl(writer);
}
else
{
Panel outerDiv = new Panel();
outerDiv.ID = ClientID;
outerDiv.CssClass = this.CssClass;
outerDiv.ApplyStyle(ControlStyle);
if (tabs == null)
{
tabs = CreateTabs();
tabs.CreateStyle(Page, "#" + ClientID + " ul." + ClientID);
}
outerDiv.Controls.Add(tabs);
/*
* Dim lClear As New Literal
* lClear.Text = "<div style=""clear:both""></div>"
* outerDiv.Controls.Add(lClear)
*/
Panel innerDiv = new Panel();
innerDiv.CssClass = "container";
TabView view = GetCurrentView();
if (view != null)
{
innerDiv.ApplyStyle(view.ControlStyle);
innerDiv.Style["border-top"] = "0 !important";
if (view.ControlStyle.BorderStyle == BorderStyle.None || view.ControlStyle.BorderStyle == BorderStyle.NotSet)
{
innerDiv.BorderStyle = TabBorderStyle;
innerDiv.BorderWidth = TabBorderWidth;
innerDiv.BorderColor = TabBorderColor;
}
//padding: top right bottom left
if (!ContainerPaddingLeft.IsEmpty)
{
innerDiv.Style["padding-left"] = ContainerPaddingLeft.ToString();
}
if (!ContainerPaddingRight.IsEmpty)
{
innerDiv.Style["padding-right"] = ContainerPaddingLeft.ToString();
}
if (!ContainerPaddingTop.IsEmpty)
{
innerDiv.Style["padding-top"] = ContainerPaddingLeft.ToString();
}
if (!ContainerPaddingBottom.IsEmpty)
{
innerDiv.Style["padding-bottom"] = ContainerPaddingLeft.ToString();
}
}
innerDiv.ScrollBars = ScrollBars.Auto;
if (!outerDiv.Height.IsEmpty)
{
innerDiv.Height = new Unit(outerDiv.Height.Value - tabs.RealHeight.Value, UnitType.Pixel);
outerDiv.Height = Unit.Empty;
}
/*
* If outerDiv.Height.IsEmpty Then
* If innerDiv.Height.IsEmpty Then
* innerDiv.Height = New Unit(200 - tabs.RealHeight.Value, UnitType.Pixel)
* End If
* Else
* innerDiv.Height = New Unit(outerDiv.Height.Value - tabs.RealHeight.Value, UnitType.Pixel)
* End If
*/
Literal l = new Literal();
l.Text = "{0}";
innerDiv.Controls.Add(l);
outerDiv.Controls.Add(innerDiv);
System.IO.StringWriter htmlSW = new System.IO.StringWriter();
HtmlTextWriter html32 = new HtmlTextWriter(htmlSW);
outerDiv.RenderControl(html32);
string html = htmlSW.ToString();
writer.WriteLine(html.Substring(0, html.IndexOf("{0}")));
base.RenderControl(writer);
writer.WriteLine(html.Substring(html.IndexOf("{0}") + 3));
}
}
private void @__Render__control1(System.Web.UI.HtmlTextWriter @__w, System.Web.UI.Control parameterContainer)
{
@__w.Write("\r\n\r\n<link href=\"../_layouts/15/LeaveApplication/StyleSheet.css\" rel=\"stylesheet\" " +
"/>\r\n\r\n\r\n");
System.Data.DataTable result = ViewState["Result"] as System.Data.DataTable;
if (result != null && result.Rows.Count > 0)
{
@__w.Write(@"
<div class=""Container"">
<table>
<tr class=""header"">
<th colspan=""4""><h3 class=""font"">Leave Information</h3></th></tr>
<tr class=""header"">
<th class=""font"">
Leave Type
</th>
<th class=""font"">
Leave Balance
</th>
<th class=""font"">
Leave Requested
</th>
<th class=""font"">
Leave Utilized
</th>
</tr>
");
foreach (System.Data.DataRow row in result.Rows)
{
@__w.Write("\r\n <tr class=\"data\">\r\n <td>\r\n ");
@__w.Write(row["Leave Type"].ToString());
@__w.Write("\r\n </td>\r\n <td>\r\n ");
@__w.Write(row["Balance Leave"].ToString());
@__w.Write("\r\n </td>\r\n <td>\r\n ");
@__w.Write(row["Leave Requested"].ToString());
@__w.Write("\r\n </td>\r\n <td>\r\n ");
@__w.Write(row["Leave utilized"].ToString());
@__w.Write("\r\n </td>\r\n </tr>\r\n ");
}
@__w.Write("\r\n </table>\r\n</div>\r\n");
}
else
{
@__w.Write("\r\n<div class=\"Container\">\r\n <table>\r\n <tr class=\"data\">\r\n <t" +
"d colspan=\"2\">\r\n ");
parameterContainer.Controls[0].RenderControl(@__w);
@__w.Write("\r\n </td>\r\n </tr>\r\n <tr class=\"header\">\r\n <th>" +
"\r\n There is no records.\r\n </th>\r\n </tr>\r\n </" +
"table>\r\n</div>\r\n");
}
@__w.Write("<br />\r\n<br />\r\n\r\n");
parameterContainer.Controls[1].RenderControl(@__w);
@__w.Write("\r\n");
parameterContainer.Controls[2].RenderControl(@__w);
}
/// <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);
}
protected void OnButtonCommand(object sender, CommandEventArgs e)
{
//Event handler for command button clicked
//Change view to Viewer and reset to clear existing data
Master.Viewer.Reset();
//Get parameters for the query
string _client = Master.ClientNumber;
string _division = Master.Division;
string _agent = Master.AgentNumber;
string _region = Master.Region;
string _district = Master.District;
string _store = Master.StoreNumber;
int _isException = this.chkExceptionsOnly.Checked ? 1 : 0;
string _start = Master.StartDate;
string _end = Master.EndDate;
//Initialize control values
LocalReport report = Master.Viewer.LocalReport;
report.DisplayName = REPORT_NAME;
report.EnableExternalImages = true;
EnterpriseGateway enterprise = new EnterpriseGateway();
DataSet ds = enterprise.FillDataset(USP_REPORT, TBL_REPORT, new object[] { _client, _division, _agent, _region, _district, _store, _start, _end, _isException });
if (ds.Tables[TBL_REPORT].Rows.Count >= 0)
{
switch (e.CommandName)
{
case "Run":
//Set local report and data source
System.IO.Stream stream = Master.GetReportDefinition(REPORT_SRC);
report.LoadReportDefinition(stream);
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT]));
//Set the report parameters for the report
ReportParameter clientName = new ReportParameter("ClientName", Master.ClientName);
ReportParameter client = new ReportParameter("ClientNumber", _client);
ReportParameter division = new ReportParameter("Division", _division);
ReportParameter agent = new ReportParameter("AgentNumber"); if (_agent != null)
{
agent.Values.Add(_agent);
}
ReportParameter region = new ReportParameter("Region"); if (_region != null)
{
region.Values.Add(_region);
}
ReportParameter district = new ReportParameter("District"); if (_district != null)
{
district.Values.Add(_district);
}
ReportParameter store = new ReportParameter("StoreNumber"); if (_store != null)
{
store.Values.Add(_store);
}
ReportParameter start = new ReportParameter("StartDate", _start);
ReportParameter end = new ReportParameter("EndDate", _end);
ReportParameter isException = new ReportParameter("IsExceptionOnly", _isException.ToString());
report.SetParameters(new ReportParameter[] { client, division, agent, region, district, store, start, end, isException, clientName });
//Update report rendering with new data
report.Refresh();
if (!Master.Viewer.Enabled)
{
Master.Viewer.CurrentPage = 1;
}
break;
case "Data":
//Set local export report and data source
report.LoadReportDefinition(Master.CreateExportRdl(ds, REPORT_DS, "RGXSQLR.TSORT"));
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT]));
report.Refresh(); break;
case "Excel":
//Create Excel mime-type page
Response.ClearHeaders();
Response.Clear();
Response.Charset = "";
Response.AddHeader("Content-Disposition", "inline; filename=ScanningDetailByStore.xls");
Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream";
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
DataGrid dg = new DataGrid();
dg.DataSource = ds.Tables[TBL_REPORT];
dg.DataBind();
dg.RenderControl(hw);
Response.Write(sw.ToString());
Response.End();
break;
}
}
else
{
Master.Status = "There were no records found.";
}
}
protected void OnButtonCommand(object sender, CommandEventArgs e)
{
//Event handler for command button clicked
try {
//Change view to Viewer and reset to clear existing data
Master.Viewer.Reset();
//Get parameters for the query
string _client = Master.ClientNumber;
string _division = Master.Division;
string _agentnumber = Master.AgentNumber;
string _subagentnumber = Master.SubAgentNumber;
string _region = Master.Region;
string _district = Master.District;
string _store = Master.StoreNumber;
string _start = Master.StartDate;
string _end = Master.EndDate;
//Initialize control values
LocalReport report = Master.Viewer.LocalReport;
report.DisplayName = this.mTitle;
report.EnableExternalImages = true;
EnterpriseGateway enterprise = new EnterpriseGateway();
DataSet ds = enterprise.FillDataset(this.mUSPName, mTBLName, new object[] { _client, _division, _agentnumber, _subagentnumber, _region, _district, _store, _start, _end });
if (ds.Tables[mTBLName] == null)
{
ds.Tables.Add(mTBLName);
}
switch (e.CommandName)
{
case "Run":
//Set local report and data source
System.IO.Stream stream = Master.GetReportDefinition(this.mSource);
report.LoadReportDefinition(stream);
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName]));
//Set the report parameters for the report
ReportParameter clientName = new ReportParameter("ClientName", Master.ClientName);
ReportParameter client = new ReportParameter("ClientNumber", _client);
ReportParameter division = new ReportParameter("Division", _division);
ReportParameter agentnumber = new ReportParameter("AgentParentNumber", _agentnumber);
ReportParameter subagentnumber = new ReportParameter("AgentNumber", _subagentnumber);
ReportParameter region = new ReportParameter("Region"); if (_region != null)
{
region.Values.Add(_region);
}
ReportParameter district = new ReportParameter("District"); if (_district != null)
{
district.Values.Add(_district);
}
ReportParameter store = new ReportParameter("StoreNumber"); if (_store != null)
{
store.Values.Add(_store);
}
ReportParameter start = new ReportParameter("StartDate", _start);
ReportParameter end = new ReportParameter("EndDate", _end);
report.SetParameters(new ReportParameter[] { client, division, agentnumber, subagentnumber, region, district, store, start, end, clientName });
//Update report rendering with new data
report.Refresh();
if (!Master.Viewer.Enabled)
{
Master.Viewer.CurrentPage = 1;
}
break;
case "Data":
//Set local export report and data source
report.LoadReportDefinition(Master.CreateExportRdl(ds, this.mDSName));
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName]));
report.Refresh(); break;
case "Excel":
//Create Excel mime-type page
Response.ClearHeaders();
Response.Clear();
Response.Charset = "";
Response.AddHeader("Content-Disposition", "inline; filename=OnTimeDeliverySummaryByAgent.xls");
Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream";
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
DataGrid dg = new DataGrid();
dg.DataSource = ds.Tables[mTBLName];
dg.DataBind();
dg.RenderControl(hw);
Response.Write(sw.ToString());
Response.End();
break;
}
}
catch (Exception ex) { Master.ReportError(ex); }
}
/// <summary>
/// Renders the control to the specified HTML writer.
/// </summary>
/// <param name="writer">The <see cref="T:System.Web.UI.HtmlTextWriter" /> object that receives the control content.</param>
protected override void Render(System.Web.UI.HtmlTextWriter writer)
{
ControlHelper.EnsureCssClassPresent(this, "form-group");
InputSizesHelper.EnsureSizeClassPresent(this, this.InputSize, "form-group-");
base.Render(writer);
}
protected override void RenderContents(System.Web.UI.HtmlTextWriter writer)
{
}
protected void OnButtonCommand(object sender, CommandEventArgs e)
{
//Event handler for command button clicked
//Change view to Viewer and reset to clear existing data
Master.Viewer.Reset();
//Get parameters for the query
string _fromDate = this.ddpPickups.FromDate.ToString("yyyy-MM-dd");
string _toDate = this.ddpPickups.ToDate.ToString("yyyy-MM-dd");
string _client = this.dgdClientShipper.ClientNumber;
string _div = this.dgdClientShipper.ClientDivsionNumber;
string _clientName = this.dgdClientShipper.ClientName;
string _shipper = this.dgdClientShipper.ShipperNumber;
string _shipperName = this.dgdClientShipper.ShipperName;
//Initialize control values
LocalReport report = Master.Viewer.LocalReport;
report.DisplayName = REPORT_NAME;
report.EnableExternalImages = true;
EnterpriseGateway enterprise = new EnterpriseGateway();
DataSet ds = new DataSet();
string reportFile = "", reportDS = "";
if (this.cboFreightType.SelectedValue == "0")
{
//Tsort- set dataset and report types
reportDS = REPORT_DS_TSORT;
switch (this.cboViewBy.SelectedItem.Text)
{
case "State": reportFile = REPORT_SRC_TSORT_STATE; break;
case "Zone": reportFile = REPORT_SRC_TSORT_ZONE; break;
case "Store": reportFile = REPORT_SRC_TSORT_STORE; break;
}
ds = enterprise.FillDataset(USP_REPORT_VENDOR, TBL_REPORT, new object[] { _client, _div, _shipper, _fromDate, _toDate });
}
else if (this.cboFreightType.SelectedValue == "1")
{
//Returns- set dataset and report types
reportDS = REPORT_DS_RETURNS;
switch (this.cboViewBy.SelectedItem.Text)
{
case "Vendor": reportFile = REPORT_SRC_RETURNS_VENDOR; break;
case "Store": reportFile = REPORT_SRC_RETURNS_STORE; break;
}
ds = enterprise.FillDataset(USP_REPORT_AGENT, TBL_REPORT, new object[] { _client, _div, _shipper, _fromDate, _toDate });
}
if (ds.Tables[TBL_REPORT].Rows.Count >= 0)
{
switch (e.CommandName)
{
case "Run":
//Set local report and data source
System.IO.Stream stream = Master.GetReportDefinition(reportFile);
report.LoadReportDefinition(stream);
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(reportDS, ds.Tables[TBL_REPORT]));
//Set the report parameters for the report
ReportParameter fromDate = new ReportParameter("StartPUDate", _fromDate);
ReportParameter toDate = new ReportParameter("EndPUDate", _toDate);
ReportParameter client = new ReportParameter("ClientNumber", _client);
ReportParameter div = new ReportParameter("ClientDivision", _div);
ReportParameter clientName = new ReportParameter("ClientName", _clientName);
ReportParameter shipper = new ReportParameter((this.dgdClientShipper.FreightType == FreightType.Regular ? "VendorNumber" : "AgentNumber"), _shipper);
ReportParameter shipperName = new ReportParameter((this.dgdClientShipper.FreightType == FreightType.Regular ? "VendorName" : "AgentName"), _shipperName);
report.SetParameters(new ReportParameter[] { client, div, fromDate, toDate, clientName, shipper, shipperName });
//Update report rendering with new data
report.Refresh();
if (!Master.Viewer.Enabled)
{
Master.Viewer.CurrentPage = 1;
}
break;
case "Data":
//Set local export report and data source
report.LoadReportDefinition(Master.CreateExportRdl(ds, reportDS, "RGXSQLR.TSORT"));
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(reportDS, ds.Tables[TBL_REPORT]));
report.Refresh();
break;
case "Excel":
//Create Excel mime-type page
Response.ClearHeaders();
Response.Clear();
Response.Charset = "";
Response.AddHeader("Content-Disposition", "inline; filename=Discrepancy.xls");
Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream";
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
DataGrid dg = new DataGrid();
dg.DataSource = ds.Tables[TBL_REPORT];
dg.DataBind();
dg.RenderControl(hw);
Response.Write(sw.ToString());
Response.End();
break;
}
}
else
{
Master.Status = "There were no records found.";
}
}
protected override void Render(System.Web.UI.HtmlTextWriter writer)
{
base.Render(writer);
writer.Write(ScriptHelper.GetScript(macroEditor.Editor.GetValueSetterCommand("wopener.getNestedControlValue('" + selectorId + "')")));
}
protected void OnButtonCommand(object sender, CommandEventArgs e)
{
//Event handler for command button clicked
try {
//Change view to Viewer and reset to clear existing data
Master.Viewer.Reset();
//Get parameters for the query
string _date = this.ddpPickups.ToDate.ToString("yyyy-MM-dd");
string _terminal = this.cboTerminal.SelectedValue;
string _terminalName = this.cboTerminal.SelectedItem.Text;
//Initialize control values
LocalReport report = Master.Viewer.LocalReport;
report.DisplayName = this.mTitle;
report.EnableExternalImages = true;
EnterpriseGateway enterprise = new EnterpriseGateway();
DataSet ds = enterprise.FillDataset(this.mUSPName, mTBLName, new object[] { _terminal, _date, });
if (ds.Tables[mTBLName] == null)
{
ds.Tables.Add(mTBLName);
}
switch (e.CommandName)
{
case "Run":
//Set local report and data source
System.IO.Stream stream = Master.GetReportDefinition(this.mSource);
report.LoadReportDefinition(stream);
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName]));
//Set the report parameters for the report
ReportParameter terminalID = new ReportParameter("TerminalID", _terminal);
ReportParameter terminal = new ReportParameter("TerminalName", _terminalName);
ReportParameter date = new ReportParameter("SortDate", _date);
report.SetParameters(new ReportParameter[] { terminalID, date, terminal });
//Update report rendering with new data
report.Refresh();
if (!Master.Viewer.Enabled)
{
Master.Viewer.CurrentPage = 1;
}
break;
case "Data":
//Set local export report and data source
report.LoadReportDefinition(Master.CreateExportRdl(ds, this.mDSName));
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName]));
report.Refresh(); break;
case "Excel":
//Create Excel mime-type page
Response.ClearHeaders();
Response.Clear();
Response.Charset = "";
Response.AddHeader("Content-Disposition", "inline; filename=DamagedCartons.xls");
Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream";
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
DataGrid dg = new DataGrid();
dg.DataSource = ds.Tables[mTBLName];
dg.DataBind();
dg.RenderControl(hw);
Response.Write(sw.ToString());
Response.End();
break;
}
}
catch (Exception ex) { Master.ReportError(ex); }
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "详细";
Page.Title = title;
if (!IsPostBack)
{
try
{
if (!string.IsNullOrEmpty(Request["ID"]))
{
valObj = BLLTable <WEC_ACTIVITY_SNCODE> .GetRowData(WEC_ACTIVITY_SNCODE.Attribute.ID, Request["ID"]);
if (valObj == null)
{
return;
}
txtID.Text = Convert.ToString(valObj.ID);//Convert.ToDecimal
txtSN_CODE.Text = Convert.ToString(valObj.SN_CODE);//Convert.ToString
txtAWARD_TYPE.Text = Convert.ToString(valObj.AWARD_TYPE);//Convert.ToString
txtSTATUS.Text = valObj.STATUS.ToString();
txtPHONE.Text = Convert.ToString(valObj.PHONE);//Convert.ToString
txtWX_CODE.Text = Convert.ToString(valObj.WX_CODE);//Convert.ToString
txtZJ_TIME.Text = (valObj.ZJ_TIME == DateTime.MinValue) ? "" : valObj.ZJ_TIME.ToString("yyyy-MM-dd HH:mm");
txtSY_TIME.Text = (valObj.SY_TIME == DateTime.MinValue) ? "" : valObj.SY_TIME.ToString("yyyy-MM-dd HH:mm");
txtA_ID.Text = Convert.ToString(valObj.A_ID);//Convert.ToDecimal
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
if (Request["ajax"] != null)
{
Response.Clear();
Response.Buffer = true;
Response.Charset = "utf-8";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");//设置输出流为简体中文
//Response.ContentType = "html/text";
this.EnableViewState = false;
System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
divC.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
}
}
protected void OnButtonCommand(object sender, CommandEventArgs e)
{
//Event handler for command button clicked
try {
//Change view to Viewer and reset to clear existing data
Master.Viewer.Reset();
//Get parameters for the query
string _fromDate = this.ddpPickups.FromDate.ToString("yyyy-MM-dd");
string _toDate = this.ddpPickups.ToDate.ToString("yyyy-MM-dd");
string _client = this.dgdClientVendor.ClientNumber;
string _div = (this.chkAllDivs.Checked) ? null : this.dgdClientVendor.ClientDivsionNumber;
string _clientName = this.dgdClientVendor.ClientName;
string _vendor = this.dgdClientVendor.VendorNumber;
string _vendorName = this.dgdClientVendor.VendorName;
//Initialize control values
LocalReport report = Master.Viewer.LocalReport;
report.DisplayName = this.mTitle;
report.EnableExternalImages = true;
EnterpriseGateway enterprise = new EnterpriseGateway();
DataSet ds = new DataSet();
string reportFile = "", reportDS = "", usp = "";
switch (this.cboType.SelectedItem.Text)
{
case "Over":
reportFile = REPORT_SRC_OVER;
reportDS = REPORT_DS_OVER;
usp = USP_REPORT_OVER;
break;
case "Short":
reportFile = REPORT_SRC_SHORT;
reportDS = REPORT_DS_SHORT;
usp = USP_REPORT_SHORT;
break;
}
ds = enterprise.FillDataset(usp, mTBLName, new object[] { _fromDate, _toDate, _vendor, _client, _div });
if (ds.Tables[mTBLName] == null)
{
ds.Tables.Add(mTBLName);
}
switch (e.CommandName)
{
case "Run":
//Set local report and data source
System.IO.Stream stream = Master.GetReportDefinition(reportFile);
report.LoadReportDefinition(stream);
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(reportDS, ds.Tables[mTBLName]));
//Set the report parameters for the report
ReportParameter fromDate = new ReportParameter("Startdate", _fromDate);
ReportParameter toDate = new ReportParameter("EndDate", _toDate);
ReportParameter client = new ReportParameter("ClientNumber", _client + "-" + (_div == null?"All":_div) + " " + _clientName);
ReportParameter div = new ReportParameter("DivisionNumber", (_div == null?"All":_div));
ReportParameter clientName = new ReportParameter("ClientName", _clientName);
ReportParameter vendor = new ReportParameter("VendorNumber", _vendor + " " + _vendorName);
ReportParameter vendorName = new ReportParameter("VendorName", _vendorName);
report.SetParameters(new ReportParameter[] { fromDate, toDate, vendor, client, div });
//Update report rendering with new data
report.Refresh();
if (!Master.Viewer.Enabled)
{
Master.Viewer.CurrentPage = 1;
}
break;
case "Data":
//Set local export report and data source
report.LoadReportDefinition(Master.CreateExportRdl(ds, reportDS));
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(reportDS, ds.Tables[mTBLName]));
report.Refresh();
break;
case "Excel":
//Create Excel mime-type page
Response.ClearHeaders();
Response.Clear();
Response.Charset = "";
Response.AddHeader("Content-Disposition", "inline; filename=TimePeriodCartonCompare.xls");
Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream";
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
DataGrid dg = new DataGrid();
dg.DataSource = ds.Tables[mTBLName];
dg.DataBind();
dg.RenderControl(hw);
Response.Write(sw.ToString());
Response.End();
break;
}
}
catch (Exception ex) { Master.ReportError(ex); }
}
protected void OnButtonCommand(object sender, CommandEventArgs e)
{
//Event handler for command button clicked
try {
//Change view to Viewer and reset to clear existing data
Master.Viewer.Reset();
//Get parameters for the query
string _clientName = this.dgdClientVendor.ClientName;
string _pickupID = "", _termCode = "";
//Initialize control values
LocalReport report = Master.Viewer.LocalReport;
report.DisplayName = TITLE;
report.EnableExternalImages = true;
EnterpriseRGateway enterprise = new EnterpriseRGateway();
DataSet ds = new DataSet(this.mDSName);
foreach (GridViewRow row in SelectedRows)
{
DataKey dataKey = (DataKey)this.grdPickups.DataKeys[row.RowIndex];
_pickupID += (_pickupID.Length > 0 ? ", " : "") + dataKey["PickupID"].ToString();
_termCode = dataKey["TerminalCode"].ToString();
DataSet _ds = enterprise.FillDataset(this.mUSPName, mTBLName, new object[] { dataKey["TerminalCode"].ToString(), dataKey["PickupID"].ToString() });
ds.Merge(_ds);
}
if (ds.Tables[mTBLName] == null)
{
ds.Tables.Add(mTBLName);
}
switch (e.CommandName)
{
case "Run":
//Set local report and data source
System.IO.Stream stream = Master.GetReportDefinition(SOURCE);
report.LoadReportDefinition(stream);
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName]));
//Set the report parameters for the report
ReportParameter clientName = new ReportParameter("ClientName", _clientName);
ReportParameter puID = new ReportParameter("PickupID", _pickupID);
ReportParameter termCode = new ReportParameter("TerminalCode", _termCode);
ReportParameter store = new ReportParameter("StoreNumber", this.txtStore.Text.Trim().Length > 0 ? this.txtStore.Text.Trim() : null);
ReportParameter zone = new ReportParameter("ZoneCode", this.txtZone.Text.Trim().Length > 0 ? this.txtZone.Text.Trim().PadRight(2) : null);
report.SetParameters(new ReportParameter[] { termCode, puID, clientName, store, zone });
//Update report rendering with new data
report.Refresh();
if (!Master.Viewer.Enabled)
{
Master.Viewer.CurrentPage = 1;
}
break;
case "Data":
//Set local export report and data source
report.LoadReportDefinition(Master.CreateExportRdl(ds, this.mDSName));
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName]));
report.Refresh();
break;
case "Excel":
//Create Excel mime-type page
Response.ClearHeaders();
Response.Clear();
Response.Charset = "";
Response.AddHeader("Content-Disposition", "inline; filename=ASNTracking.xls");
Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream";
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
DataGrid dg = new DataGrid();
dg.DataSource = ds.Tables[mTBLName];
dg.DataBind();
dg.RenderControl(hw);
Response.Write(sw.ToString());
Response.End();
break;
}
}
catch (Exception ex) { Master.ReportError(ex); }
}
protected void OnButtonCommand(object sender, CommandEventArgs e)
{
//Event handler for command button clicked
//Change view to Viewer and reset to clear existing data
Master.Viewer.Reset();
//Get parameters for the query
string dates = this.cboDateValue.SelectedValue;
string _start = dates.Split(':')[0].Trim();
string _end = dates.Split(':')[1].Trim();
int _delivDays = Convert.ToInt32(this.cboDelivDays.Text);
string _locType = this.cboLocType.Text;
string _vendor = this.cboCustomer.SelectedValue;
//Initialize control values
LocalReport report = Master.Viewer.LocalReport;
report.DisplayName = REPORT_NAME;
report.EnableExternalImages = true;
EnterpriseGateway enterprise = new EnterpriseGateway();
DataSet ds = enterprise.FillDataset(USP_REPORT, TBL_REPORT, new object[] { _start, _end, _delivDays, _locType, _vendor });
if (ds.Tables[TBL_REPORT].Rows.Count >= 0)
{
switch (e.CommandName)
{
case "Run":
//Set local report and data source
System.IO.Stream stream = Master.GetReportDefinition(REPORT_SRC);
report.LoadReportDefinition(stream);
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT]));
//Set the report parameters for the report
ReportParameter start = new ReportParameter("StartDate", _start);
ReportParameter end = new ReportParameter("EndDate", _end);
ReportParameter delivDays = new ReportParameter("DeliveryDays", _delivDays.ToString());
ReportParameter locType = new ReportParameter("LocationType", _locType);
report.SetParameters(new ReportParameter[] { start, end, delivDays, locType });
//Update report rendering with new data
report.Refresh();
if (!Master.Viewer.Enabled)
{
Master.Viewer.CurrentPage = 1;
}
break;
case "Data":
//Set local export report and data source
report.LoadReportDefinition(Master.CreateExportRdl(ds, REPORT_DS, "RGXSQLR.TSORT"));
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT]));
report.Refresh();
break;
case "Excel":
//Create Excel mime-type page
Response.ClearHeaders();
Response.Clear();
Response.Charset = "";
Response.AddHeader("Content-Disposition", "inline; filename=BNConsumerDirectCartonDetail.xls");
Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream";
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
DataGrid dg = new DataGrid();
dg.DataSource = ds.Tables[TBL_REPORT];
dg.DataBind();
dg.RenderControl(hw);
Response.Write(sw.ToString());
Response.End();
break;
}
}
else
{
Master.Status = "There were no records found.";
}
}
protected void OnButtonCommand(object sender, CommandEventArgs e)
{
//Event handler for command button clicked
try {
//Change view to Viewer and reset to clear existing data
Master.Viewer.Reset();
//Initialize control values
LocalReport report = Master.Viewer.LocalReport;
report.DisplayName = this.mTitle;
report.EnableExternalImages = true;
report.EnableHyperlinks = true;
EnterpriseService enterprise = new EnterpriseService();
DataSet ds = new DataSet(this.mDSName);
foreach (GridViewRow row in SelectedRows)
{
DataKey dataKey = (DataKey)this.grdPickups.DataKeys[row.RowIndex];
DataSet _ds = enterprise.FillDataset(this.mUSPName, mTBLName, new object[] { dataKey["PickupID"].ToString() });
ds.Merge(_ds);
}
if (ds.Tables[mTBLName] == null)
{
ds.Tables.Add(mTBLName);
}
switch (e.CommandName)
{
case "Run":
//Set local report and data source
System.IO.Stream stream = Master.GetReportDefinition(this.mSource);
report.LoadReportDefinition(stream);
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName]));
report.SetParameters(new ReportParameter[] { new ReportParameter("PickupID", "0") });
report.Refresh();
if (!Master.Viewer.Enabled)
{
Master.Viewer.CurrentPage = 1;
}
break;
case "Data":
//Set local export report and data source
report.LoadReportDefinition(Master.CreateExportRdl(ds, this.mDSName, "RGXVMSQLR.TSORT"));
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName]));
report.Refresh();
break;
case "Excel":
//Create Excel mime-type page
Response.ClearHeaders();
Response.Clear();
Response.Charset = "";
Response.AddHeader("Content-Disposition", "inline; filename=LOccitaneCartonInfo.xls");
Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream";
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
DataGrid dg = new DataGrid();
dg.DataSource = ds.Tables[mTBLName];
dg.DataBind();
dg.RenderControl(hw);
Response.Write(sw.ToString());
Response.End();
break;
}
}
catch (Exception ex) { Master.ReportError(ex, 4); }
}
private void Inicializar()
{
if (this.Request.QueryString["Tipo"] == "SinAgrupar")
{
DsGuiasSeguimientoAdm ds = (DsGuiasSeguimientoAdm)Session["DsGuiasSeguimientoConsul"];
Head = new string[ds.Datos.Columns.Count];
Col = new string[ds.Datos.Columns.Count];
int i = 0;
for (i = 1; i < 22 /*< ds.Datos.Columns.Count*/; i++)
{
Head[i] = ds.Datos.Columns[i].ColumnName;
Col[i] = ds.Datos.Columns[i].ColumnName;
//i++;
}
Title = "Seguimiento de guías - " + DateTime.Today.ToString("dd/MM/yyyy");
Datos = ds.Tables[0];
CustomExport();
}
else if (this.Request.QueryString["Tipo"] == "AgrupaAgOri")
{
DataSet ds = (DataSet)Session["DsSeguimHG"];
DataTable datos = ds.Tables[0];
Head = new string[ds.Tables[1].Columns.Count];
Col = new string[ds.Tables[1].Columns.Count];
int i = 0;
for (i = 1; i < 22 /*< ds.Datos.Columns.Count*/; i++)
{
Head[i] = ds.Tables[1].Columns[i].ColumnName;
Col[i] = ds.Tables[1].Columns[i].ColumnName;
//i++;
}
this.lblTitAgOri.Text = "Seguimiento de guías Agrupado por Agencia origen";
this.EnableViewState = false;
AgenciaOrigenList.DataSource = ds.Tables[0];
AgenciaOrigenList.DataBind();
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "";
Response.ContentEncoding = System.Text.Encoding.Default;
Response.AddHeader("Content-Disposition", "filename=GuiasSeguimientoConsul.xls");
CreateHeader();
CreateTitle();
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
this.tblAgrupaAgOri.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
else if (this.Request.QueryString["Tipo"] == "AgrupaAgDst")
{
DataSet ds = (DataSet)Session["DsSeguimHG"];
DataTable datos = ds.Tables[0];
Head = new string[ds.Tables[1].Columns.Count];
Col = new string[ds.Tables[1].Columns.Count];
int i = 0;
for (i = 1; i < 22 /*< ds.Datos.Columns.Count*/; i++)
{
Head[i] = ds.Tables[1].Columns[i].ColumnName;
Col[i] = ds.Tables[1].Columns[i].ColumnName;
//i++;
}
this.lblTitAgDest.Text = "Seguimiento de guías Agrupado por Agencia Destino";
this.EnableViewState = false;
AgenciaDestinoList.DataSource = ds.Tables[0];
AgenciaDestinoList.DataBind();
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "";
Response.ContentEncoding = System.Text.Encoding.Default;
Response.AddHeader("Content-Disposition", "filename=GuiasSeguimientoConsul.xls");
CreateHeader();
CreateTitle();
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
this.tblAgenciaDestino.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
else if (this.Request.QueryString["Tipo"] == "AgrupaUVenta")
{
DataSet ds = (DataSet)Session["DsSeguimHG"];
DataTable datos = ds.Tables[0];
Head = new string[ds.Tables[1].Columns.Count];
Col = new string[ds.Tables[1].Columns.Count];
int i = 0;
for (i = 1; i < 22 /*< ds.Datos.Columns.Count*/; i++)
{
Head[i] = ds.Tables[1].Columns[i].ColumnName;
Col[i] = ds.Tables[1].Columns[i].ColumnName;
//i++;
}
this.lblTitUV.Text = "Seguimiento de guías Agrupado por Unidad de Venta";
this.EnableViewState = false;
UnidadVentaList.DataSource = ds.Tables[0];
UnidadVentaList.DataBind();
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "";
Response.ContentEncoding = System.Text.Encoding.Default;
Response.AddHeader("Content-Disposition", "filename=GuiasSeguimientoConsul.xls");
CreateHeader();
CreateTitle();
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
this.tblUnidadVenta.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
else if (this.Request.QueryString["Tipo"] == "AgrupaGuia")
{
DataSet ds = (DataSet)Session["DsSeguimHG"];
DataTable datos = ds.Tables[0];
Head = new string[5 /*ds.Tables[1].Columns.Count*/];
Col = new string[5 /*ds.Tables[1].Columns.Count*/];
/*int i = 0;
* for(i=1; i < 4 ;i++)
* {
* Head[i] = ds.Tables[1].Columns[i].ColumnName;
* Col[i] = ds.Tables[1].Columns[i].ColumnName;
* //i++;
* }*/
Head[0] = ds.Tables[1].Columns[2].ColumnName;
Head[1] = ds.Tables[1].Columns[8].ColumnName;
Head[2] = ds.Tables[1].Columns[9].ColumnName;
Head[3] = ds.Tables[1].Columns[10].ColumnName;
Head[4] = ds.Tables[1].Columns[7].ColumnName;
Col[0] = ds.Tables[1].Columns[2].ColumnName;
Col[1] = ds.Tables[1].Columns[8].ColumnName;
Col[2] = ds.Tables[1].Columns[9].ColumnName;
Col[3] = ds.Tables[1].Columns[10].ColumnName;
Col[4] = ds.Tables[1].Columns[7].ColumnName;
this.lblTitGuiaHis.Text = "Seguimiento de guías Agrupado por Históricos de guía.";
this.EnableViewState = false;
GuiaHisList.DataSource = ds.Tables[0];
GuiaHisList.DataBind();
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "";
Response.ContentEncoding = System.Text.Encoding.Default;
Response.AddHeader("Content-Disposition", "filename=GuiasSeguimientoConsul.xls");
CreateHeader();
CreateTitle();
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
this.tblGuiaHistorico.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
}
protected void OnButtonCommand(object sender, CommandEventArgs e)
{
//Event handler for command button clicked
//Change view to Viewer and reset to clear existing data
Master.Viewer.Reset();
//Get parameters for the query
string _start = Master.FromDate.ToString("yyyy-MM-dd");
string _end = Master.ToDate.ToString("yyyy-MM-dd");
string _client = Master.ClientNumber;
string _vendor = Master.VendorNumber;
string _vendorLoc = Master.VendorLocationNumber;
string _agent = Master.AgentNumber;
string _agentLoc = Master.AgentLocationNumber;
string _cutoffTime = DateTime.Now.ToString("yyyy-MM-dd");
//Initialize control values
LocalReport report = Master.Viewer.LocalReport;
report.DisplayName = REPORT_NAME;
report.EnableExternalImages = true;
EnterpriseGateway enterprise = new EnterpriseGateway();
DataSet ds = enterprise.FillDataset(USP_REPORT, TBL_REPORT, new object[] { _start, _end, _agentLoc, _agent, _client, _vendorLoc, _vendor, _cutoffTime });
if (ds.Tables[TBL_REPORT].Rows.Count >= 0)
{
switch (e.CommandName)
{
case "Run":
//Set local report and data source
System.IO.Stream stream = Master.GetReportDefinition(REPORT_SRC);
report.LoadReportDefinition(stream);
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT]));
//Set the report parameters for the report
ReportParameter start = new ReportParameter("StartDate", _start);
ReportParameter end = new ReportParameter("EndDate", _end);
ReportParameter client = new ReportParameter("ClientNumber"); if (_client != null)
{
client.Values.Add(Master.ClientNumber + "- " + Master.ClientName);
}
ReportParameter vendor = new ReportParameter("VendorParentNumber"); if (_vendor != null)
{
vendor.Values.Add(Master.VendorName);
}
ReportParameter vendorLoc = new ReportParameter("VendorNumber"); if (_vendorLoc != null)
{
vendorLoc.Values.Add(Master.VendorName);
}
ReportParameter agent = new ReportParameter("AgentParentNumber"); if (_agent != null)
{
agent.Values.Add(Master.AgentName);
}
ReportParameter agentLoc = new ReportParameter("AgentNumber"); if (_agentLoc != null)
{
agentLoc.Values.Add(Master.AgentName);
}
ReportParameter cutoffTime = new ReportParameter("CutOFFTime", _cutoffTime);
report.SetParameters(new ReportParameter[] { start, end, agent, agentLoc, client, vendor, vendorLoc, cutoffTime });
//Update report rendering with new data
report.Refresh();
if (!Master.Viewer.Enabled)
{
Master.Viewer.CurrentPage = 1;
}
break;
case "Data":
//Set local export report and data source
report.LoadReportDefinition(Master.CreateExportRdl(ds, REPORT_DS, "RGXSQLR.TSORT"));
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT]));
report.Refresh(); break;
case "Excel":
//Create Excel mime-type page
Response.ClearHeaders();
Response.Clear();
Response.Charset = "";
Response.AddHeader("Content-Disposition", "inline; filename=ScanningSummaryByStore.xls");
Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream";
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
DataGrid dg = new DataGrid();
dg.DataSource = ds.Tables[TBL_REPORT];
dg.DataBind();
dg.RenderControl(hw);
Response.Write(sw.ToString());
Response.End();
break;
}
}
else
{
Master.Status = "There were no records found.";
}
}
private void @__Render__control1(System.Web.UI.HtmlTextWriter @__w, System.Web.UI.Control parameterContainer)
{
@__w.Write("\r\n\r\n<link rel=\"stylesheet\" href=\"../../_layouts/15/PagerStyle.css\" />\r\n<style typ" +
"e=\"text/css\">\r\n .btn { font:14px \'Noto Sans\', \'Helvetica Neue\', Helvetica, Ar" +
"ial, sans-serif !important; }\r\n .cDateBox { width:100px; }\r\n .rpsForm{text" +
"-align:left;}\r\n</style>\r\n\r\n<script type=\"text/javascript\" src=\"../../_layouts/15" +
"/MultiOperacion/Operacion.js\"></script>\r\n<script type=\"text/javascript\">\r\n do" +
"cument.onkeydown = function () {\r\n if (window.event && (window.event.keyC" +
"ode == 109 || window.event.keyCode == 56)) {\r\n window.event.keyCode =" +
" 505;\r\n }\r\n\r\n if (window.event.keyCode == 505) {\r\n retu" +
"rn false;\r\n }\r\n\r\n if (window.event && (window.event.keyCode == 13)" +
") {\r\n valor = document.activeElement.value;\r\n if (valor ==" +
" undefined) { return false; } //Evita Enter en página. \r\n else {\r\n " +
" if (document.activeElement.getAttribute(\'type\') == \'select-one\')\r\n " +
" { return false; } //Evita Enter en select. \r\n if (" +
"document.activeElement.getAttribute(\'type\') == \'button\')\r\n { retu" +
"rn false; } //Evita Enter en button. \r\n if (document.activeElemen" +
"t.getAttribute(\'type\') == \'radio\')\r\n { return false; } //Evita En" +
"ter en radio. \r\n if (document.activeElement.getAttribute(\'type\') " +
"== \'checkbox\')\r\n { return false; } //Evita Enter en checkbox. \r\n " +
" if (document.activeElement.getAttribute(\'type\') == \'file\')\r\n " +
" { return false; } //Evita Enter en file. \r\n if (docume" +
"nt.activeElement.getAttribute(\'type\') == \'reset\')\r\n { return fals" +
"e; } //Evita Enter en reset. \r\n if (document.activeElement.getAtt" +
"ribute(\'type\') == \'submit\')\r\n { return false; } //Evita Enter en " +
"submit. \r\n if (document.activeElement.getAttribute(\'type\') == \'in" +
"put\')\r\n { return false; } //Evita Back en input. \r\n " +
" else //Text, textarea o password \r\n {\r\n if (" +
"document.activeElement.value.length == 0)\r\n\r\n { return false;" +
" } //No realiza el backspace(largo igual a 0). \r\n }\r\n\r\n " +
" if (document.getElementById(\'");
@__w.Write(txtNCertificado.ClientID);
@__w.Write("\').val != \'\' && document.getElementById(\'");
@__w.Write(txtRUT.ClientID);
@__w.Write("\').val != \'\' && document.getElementById(\'");
@__w.Write(txtRazonSocial.ClientID);
@__w.Write("\').val != \'\') {\r\n document.getElementById(\'");
@__w.Write(btnBuscar.ClientID);
@__w.Write(@"').click();
}
}
}
}
function MantenSesion() {
SP.SOD.execute('sp.ui.dialog.js', 'SP.UI.ModalDialog.showWaitScreenWithNoClose', 'Por Favor Espere...', 'actualizando su solicitud', 120, 550);
__doPostBack('', '');
return false;
}
setInterval(""MantenSesion()"", (1200000));
</script>
");
parameterContainer.Controls[0].RenderControl(@__w);
@__w.Write("\r\n\r\n");
parameterContainer.Controls[1].RenderControl(@__w);
@__w.Write("\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n");
}
protected void OnButtonCommand(object sender, CommandEventArgs e)
{
//Event handler for command button clicked
//Change view to Viewer and reset to clear existing data
Master.Viewer.Reset();
//Get parameters for the query
string _client = this.dgdClientVendor.ClientNumber;
string _div = this.dgdClientVendor.ClientDivsionNumber;
string _clientName = this.dgdClientVendor.ClientName;
string _pickupIDs = "", _vendor = "", _pudate = "", _punum = "", _pickups = "";
//Initialize control values
LocalReport report = Master.Viewer.LocalReport;
report.DisplayName = REPORT_NAME;
report.EnableExternalImages = true;
EnterpriseGateway enterprise = new EnterpriseGateway();
DataSet ds = new DataSet(REPORT_DS);
foreach (GridViewRow row in SelectedRows)
{
DataKey dataKey = (DataKey)this.grdPickups.DataKeys[row.RowIndex];
_pickupIDs += (_pickupIDs.Length > 0 ? "," : "") + dataKey["PickupID"].ToString();
_vendor = dataKey["VendorNumber"].ToString();
_pudate = DateTime.Parse(dataKey["PUDate"].ToString()).ToString("MM/dd");
_punum = dataKey["PUNumber"].ToString();
_pickups += (_pickups.Length > 0 ? ", " : "") + _vendor + "-" + _pudate + "-" + _punum;
//_pickupIDs += (_pickupIDs.Length > 0 ? "," : "") + dataKey["PickupID"].ToString(); OnExportReport()
}
DataSet _ds = enterprise.FillDataset(USP_REPORT, TBL_REPORT, new object[] { _pickupIDs });
ds.Merge(_ds);
if (ds.Tables[TBL_REPORT].Rows.Count >= 0)
{
switch (e.CommandName)
{
case "Run":
//Set local report and data source
System.IO.Stream stream = Master.GetReportDefinition(REPORT_SRC);
report.LoadReportDefinition(stream);
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT]));
//Set the report parameters for the report
ReportParameter client = new ReportParameter("ClientNumber", _client);
ReportParameter div = new ReportParameter("ClientDivision", _div);
ReportParameter clientName = new ReportParameter("ClientName", _clientName);
ReportParameter pickups = new ReportParameter("Pickups", _pickups);
report.SetParameters(new ReportParameter[] { client, div, clientName, pickups });
//Update report rendering with new data
report.Refresh();
if (!Master.Viewer.Enabled)
{
Master.Viewer.CurrentPage = 1;
}
break;
case "Data":
//Set local export report and data source
report.LoadReportDefinition(Master.CreateExportRdl(ds, REPORT_DS, "RGXSQLR.TSORT"));
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT]));
report.Refresh();
break;
case "Excel":
//Create Excel mime-type page
Response.ClearHeaders();
Response.Clear();
Response.Charset = "";
Response.AddHeader("Content-Disposition", "inline; filename=MultiPickupDiscrepancy.xls");
Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream";
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
DataGrid dg = new DataGrid();
dg.DataSource = ds.Tables[TBL_REPORT];
dg.DataBind();
dg.RenderControl(hw);
Response.Write(sw.ToString());
Response.End();
break;
}
}
else
{
Master.Status = "There were no records found.";
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
try
{
// Put user code to initialize the page here
DataSet dsExport = (DataSet)Session["MyDataSet"];
if (dsExport == null)
{
Response.Write("Your session has timed out. Please re-submit the page");
return;
}
DataView dv = dsExport.Tables[0].DefaultView;
string erpt = (string)Session["MyReportType"];
string csrs = (string)Session["CSRs"];
Page.EnableViewState = false; //Turn off the view state.
System.IO.StringWriter tw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
hw.Write("<HTML><HEAD> <title>Sales & Service Payment Tool</title>");
hw.Write("<link rel=stylesheet type=text/css href=../style.css>");
//PT.Ch1 - START: Added by COGNIZANT - 7/02/2008 - To enable default printing of the Print Version
hw.Write("<script language=javascript>");
hw.Write("window.print();");
hw.Write("</script>");
//PT.Ch1 - END
hw.Write("</HEAD>");
hw.Write("<body>");
tblHeader.RenderControl(hw);
hw.Write("<table width=606 bgcolor=LightYellow class=arial_12>");
hw.Write("<tr><td colspan=2><b>");
hw.Write(Session["RptTitle"]);
hw.Write("</b></td></tr>");
hw.Write("<tr><td colspan=2> </td></tr>");
hw.Write("<tr><td>");
hw.Write("<b>Run Date:</b>");
hw.Write("</td><td>");
//TimeZoneChange.Ch2-Added Text MST Arizona at the end of the current date and time and DateRange by cognizant.
hw.Write(DateTime.Now.ToString() + " " + "MST Arizona");
hw.Write("</td></tr>");
hw.Write("<tr><td>");
hw.Write("<b>Date Range:</b>");
hw.Write("</td><td>");
//TimeZoneChange.Ch2-Added Text MST Arizona at the end of the current date and time and DateRange by cognizant.
hw.Write(Session["DateRange"] + " " + "MST Arizona");
hw.Write("</td></tr>");
//Code Added by Cognizant for Payment Type
hw.Write("<tr><td>");
hw.Write("<b>Payment Type:</b>");
hw.Write("</td><td>");
hw.Write(Session["PaymentName"]);
hw.Write("</td></tr>");
//Code Added by Cognizant for Payment Type
if (csrs != String.Empty)
{
hw.Write("<tr><td>");
hw.Write("<b>Users:</b>");
hw.Write("</td><td>");
hw.Write(Session["CSRs"]);
hw.Write("</td></tr>");
}
hw.Write("</table>");
if (erpt == "4" || erpt == "10")
{
dgGrid.DataSource = dv;
dgGrid.DataBind();
dgGrid.RenderControl(hw);
}
else if (erpt == "5" || erpt == "11")
{
dgGrid1.DataSource = dv;
dgGrid1.DataBind();
dgGrid1.RenderControl(hw);
}
else
{
dgGrid2.DataSource = dv;
dgGrid2.DataBind();
dgGrid2.RenderControl(hw);
}
hw.Write("</body></html>");
Response.Write(tw.ToString()); //Write the HTML back to the browser.
Response.End();
}
catch (Exception ex)
{
Logger.Log(ex);
//Response.Write("Please try clicking the submit button and loading the report again. If that doesn't work , try closing the browser and run the report again.");
//throw;
}
}
/// <summary>
/// 数据导出到Excel
/// </summary>
/// <returns></returns>
private void OutputDataToExcle(string strFilename)
{
string sWhereSQL = " ";
if (SysClass.SysUserSalary.UserSalary_SignStatus != "-1")
{
sWhereSQL += " And SignStatus=" + SysClass.SysUserSalary.UserSalary_SignStatus;
}
if (SysClass.SysUserSalary.UserSalary_UserSalaryOpCode.Length > 0)
{
sWhereSQL += " And a.OpCode = '" + SysClass.SysUserSalary.UserSalary_UserSalaryOpCode + "'";
}
//月份起始和月份结束同时不为空时，按区间查找数据
if (SysClass.SysUserSalary.UserSalary_SearchText.Length > 0 && SysClass.SysUserSalary.UserSalary_SearchText2.Length > 0)
{
sWhereSQL += " And a.SalaryYears >= '" + SysClass.SysUserSalary.UserSalary_SearchText + "'";
if (SysClass.SysUserSalary.UserSalary_ImportRecIndex > 0)
{
sWhereSQL += " And a.SalaryDate>='" + SysClass.SysUserSalary.UserSalary_ImportRecText + "'";
}
sWhereSQL += " And a.SalaryYears <= '" + SysClass.SysUserSalary.UserSalary_SearchText2 + "'";
if (SysClass.SysUserSalary.UserSalary_ImportRecIndex2 > 0)
{
sWhereSQL += " And a.SalaryDate <= DateAdd(mi,3,'" + SysClass.SysUserSalary.UserSalary_ImportRecText2 + "')";
}
}
//仅月份起始不为空时，只按月份起始查找数据
else if (SysClass.SysUserSalary.UserSalary_SearchText.Length > 0)
{
sWhereSQL += " And a.SalaryYears = '" + SysClass.SysUserSalary.UserSalary_SearchText + "'";
if (SysClass.SysUserSalary.UserSalary_ImportRecIndex > 0)
{
sWhereSQL += " And a.SalaryRecGuid ='" + SysClass.SysUserSalary.UserSalary_ImportRecValue + "'";
}
}
//仅月份结束不为空时，只按月份结束查找数据
else if (SysClass.SysUserSalary.UserSalary_SearchText2.Length > 0)
{
sWhereSQL += " And a.SalaryYears = '" + SysClass.SysUserSalary.UserSalary_SearchText2 + "'";
if (SysClass.SysUserSalary.UserSalary_ImportRecIndex2 > 0)
{
sWhereSQL += " And a.SalaryRecGuid ='" + SysClass.SysUserSalary.UserSalary_ImportRecValue2 + "'";
}
}
//如果不是从属与最高部门的员工，此页面只能查询其所属子部门员工的数据！
SqlDataReader sdrUser = SysClass.SysUser.GetUserInfoByReader(SysClass.SysGlobal.GetCurrentOpCode());
if (sdrUser.Read())
{
SqlDataReader sdrOrg = SysClass.SysOrgan.GetSingleOrganByReader(Convert.ToInt32(sdrUser["OrganID"]));
if (sdrOrg.Read())
{
if (sdrOrg["POrganID"].ToString() != "0")
{
sWhereSQL += " And b.OrganID = " + Convert.ToInt32(sdrUser["OrganID"]);
}
}
sdrOrg.Close();
}
sdrUser.Close();
//Add by lk 20160118 start
switch (SysClass.SysUserSalary.UserSalary_FlgValue)
{
//没有选中任何一项
case 0:
sWhereSQL += " And d.Description = ''";
break;
//仅【工资】被选中
case 1:
sWhereSQL += " And d.Description like '%" + chkGongzi.Text + "%'";
break;
//仅【奖金】被选中
case 2:
sWhereSQL += " And d.Description like '%" + chkJiangjin.Text + "%'";
break;
//【工资】和【奖金】被选中
case 3:
sWhereSQL += " And (d.Description like '%" + chkGongzi.Text + "%'";
sWhereSQL += " or d.Description like '%" + chkJiangjin.Text + "%')";
break;
//仅【报销】被选中
case 4:
sWhereSQL += " And d.Description like '%" + chkBaoxiao.Text + "%'";
break;
//【工资】和【报销】被选中
case 5:
sWhereSQL += " And (d.Description like '%" + chkGongzi.Text + "%'";
sWhereSQL += " or d.Description like '%" + chkBaoxiao.Text + "%')";
break;
//【奖金】和【报销】被选中
case 6:
sWhereSQL += " And (d.Description like '%" + chkJiangjin.Text + "%'";
sWhereSQL += " or d.Description like '%" + chkBaoxiao.Text + "%')";
break;
//【工资】【奖金】【报销】都被选中
case 7:
break;
}
//Add by lk 20160118 end
string sSQL = "select a.ID, a.OpCode, b.OpName, b.Sex, b.IdNumber, c.OrganName, a.SalaryYears, a.SalaryDate, a.TotalSalary,d.Description"
+ ", (Case IsNull(SignStatus,0) when 0 then a.TotalSalary else 0 end) As UnSignTotalSalary"
+ ", (Case IsNull(SignStatus,0) when 1 then a.TotalSalary else 0 end) As SignTotalSalary";
sSQL += " from UserSalary_Info a "
+ " left join SysUser_Info b on b.Status=0 And a.OpCode=b.OpCode"
+ " left join SysOrgan_Info c on c.Status=0 And b.OrganID=c.ID"
//Add by lk 20160118 start
+ " left join UserUserImportRec_Info d on d.SalaryRecGuid=a.SalaryRecGuid"
//Add by lk 20160118 end
+ " Where a.Status=0 " + sWhereSQL;
sSQL += " Order By a.SalaryYears Desc,b.OpName";
DataSet ds = CyxPack.OperateSqlServer.DataCommon.GetDataByDataSet(sSQL);
//创建DataTable对象
DataTable dt = new DataTable("output");
//构建表结构,往表中添加列
dt.Columns.Add("序号", typeof(int));
dt.Columns.Add("工号", typeof(string));
dt.Columns.Add("姓名", typeof(string));
dt.Columns.Add("单位部门", typeof(string));
dt.Columns.Add("工资年月", typeof(string));
dt.Columns.Add("发放日期", typeof(string));
dt.Columns.Add("发放金额", typeof(decimal));
dt.Columns.Add("未签收金额", typeof(decimal));
dt.Columns.Add("已签收金额", typeof(decimal));
dt.Columns.Add("备注", typeof(string));
//清空合计结果
mysum = 0;
mysum1 = 0;
mysum2 = 0;
for (int iLoop = 0; iLoop < ds.Tables[0].Rows.Count; iLoop++)
{
//创建DataRow对象
DataRow dr = dt.NewRow();
//新增数据
dr[0] = iLoop + 1;
dr[1] = ds.Tables[0].Rows[iLoop]["OpCode"].ToString();
dr[2] = ds.Tables[0].Rows[iLoop]["OpName"].ToString();
dr[3] = ds.Tables[0].Rows[iLoop]["OrganName"].ToString();
dr[4] = ds.Tables[0].Rows[iLoop]["SalaryYears"].ToString();
if (ds.Tables[0].Rows[iLoop]["SalaryDate"].ToString().Length > 0)
{
dr[5] = DateTime.Parse(ds.Tables[0].Rows[iLoop]["SalaryDate"].ToString()).ToString("yyyy-MM-dd");
}
else
{
dr[5] = "";
}
dr[6] = ds.Tables[0].Rows[iLoop]["TotalSalary"].ToString();
dr[7] = ds.Tables[0].Rows[iLoop]["UnSignTotalSalary"].ToString();
dr[8] = ds.Tables[0].Rows[iLoop]["SignTotalSalary"].ToString();
dr[9] = ds.Tables[0].Rows[iLoop]["Description"].ToString();
//把数据添加到表结构中
dt.Rows.Add(dr);
//合计结果累加
mysum += double.Parse(ds.Tables[0].Rows[iLoop]["TotalSalary"].ToString());
mysum1 += double.Parse(ds.Tables[0].Rows[iLoop]["UnSignTotalSalary"].ToString());
mysum2 += double.Parse(ds.Tables[0].Rows[iLoop]["SignTotalSalary"].ToString());
}
//添加合计部分数据
DataRow foot = dt.NewRow();
foot[5] = "总合计：";
foot[6] = mysum.ToString("0.00");
foot[7] = mysum1.ToString("0.00");
foot[8] = mysum2.ToString("0.00");
dt.Rows.Add(foot);
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;
// 设置编码和附件格式
curContext.Response.ContentType = "application/vnd.ms-excel";
curContext.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
curContext.Response.Charset = "gb2312";
// 导出excel文件
strWriter = new System.IO.StringWriter();
htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);
// 为了解决dgData中可能进行了分页的情况，需要重新定义一个无分页的DataGrid
dgExport = new System.Web.UI.WebControls.DataGrid();
dgExport.DataSource = dt.DefaultView;
dgExport.AllowPaging = false;
dgExport.DataBind();
// 返回客户端
dgExport.RenderControl(htmlWriter);
curContext.Response.Clear();
curContext.Response.Buffer = true;
curContext.Response.Write("上海动车段工资电子签收系统");
curContext.Response.AddHeader("Content-Disposition", "attachment;filename=" + strFilename);
curContext.Response.Write("<meta http-equiv=\"content-type\" content=\"application/ms-excel; charset=gb2312\"/>" + strWriter.ToString());
curContext.Response.Flush();
curContext.Response.End();
}
internal override void RenderItem(System.Web.UI.HtmlTextWriter output, FileViewItem item)
{
output.AddStyleAttribute(HtmlTextWriterStyle.Margin, "1px");
output.AddStyleAttribute(HtmlTextWriterStyle.Width, "120px");
output.AddStyleAttribute(HtmlTextWriterStyle.Display, "inline-block");
output.AddStyleAttribute(HtmlTextWriterStyle.VerticalAlign, "top");
output.RenderBeginTag(HtmlTextWriterTag.Div);
fileView.RenderItemBeginTag(output, item);
output.AddAttribute(HtmlTextWriterAttribute.Cellpadding, "0");
output.AddAttribute(HtmlTextWriterAttribute.Cellspacing, "0");
output.AddAttribute(HtmlTextWriterAttribute.Border, "0");
output.RenderBeginTag(HtmlTextWriterTag.Table);
output.RenderBeginTag(HtmlTextWriterTag.Tr);
output.AddStyleAttribute(HtmlTextWriterStyle.Width, "120px");
output.AddStyleAttribute(HtmlTextWriterStyle.Height, "96px");
output.AddStyleAttribute(HtmlTextWriterStyle.PaddingLeft, "13px");
output.AddStyleAttribute(HtmlTextWriterStyle.PaddingRight, "13px");
output.AddStyleAttribute(HtmlTextWriterStyle.PaddingTop, "2px");
output.RenderBeginTag(HtmlTextWriterTag.Td);
output.AddAttribute(HtmlTextWriterAttribute.Cellpadding, "0");
output.AddAttribute(HtmlTextWriterAttribute.Cellspacing, "0");
output.AddAttribute(HtmlTextWriterAttribute.Border, "0");
output.RenderBeginTag(HtmlTextWriterTag.Table);
output.RenderBeginTag(HtmlTextWriterTag.Tr);
output.AddStyleAttribute(HtmlTextWriterStyle.BorderColor, "#ACA899");
output.AddStyleAttribute(HtmlTextWriterStyle.BorderStyle, "solid");
output.AddStyleAttribute(HtmlTextWriterStyle.BorderWidth, "1px");
output.AddStyleAttribute(HtmlTextWriterStyle.Width, "92px");
output.AddStyleAttribute(HtmlTextWriterStyle.Height, "92px");
output.AddStyleAttribute(HtmlTextWriterStyle.TextAlign, "center");
output.AddStyleAttribute(HtmlTextWriterStyle.VerticalAlign, "middle");
output.AddStyleAttribute("background-image", "url(\"" + item.ThumbnailImage + "\")");
output.AddStyleAttribute("background-position", "center center");
output.AddStyleAttribute("background-repeat", "no-repeat");
if (item.Hidden)
{
fileView.Controller.HiddenItemStyle.AddAttributesToRender(output);
}
output.RenderBeginTag(HtmlTextWriterTag.Td);
output.RenderEndTag();
output.RenderEndTag();
output.RenderEndTag();
output.RenderEndTag();
output.RenderEndTag();
output.RenderBeginTag(HtmlTextWriterTag.Tr);
output.RenderBeginTag(HtmlTextWriterTag.Td);
output.AddStyleAttribute(HtmlTextWriterStyle.Cursor, "default");
output.AddStyleAttribute(HtmlTextWriterStyle.Width, "120px");
output.AddStyleAttribute(HtmlTextWriterStyle.PaddingBottom, "2px");
output.AddStyleAttribute(HtmlTextWriterStyle.Overflow, "hidden");
output.AddStyleAttribute(HtmlTextWriterStyle.TextAlign, "center");
output.AddAttribute(HtmlTextWriterAttribute.Id, item.ClientID + "_Name");
output.RenderBeginTag(HtmlTextWriterTag.Div);
RenderItemName(output, item);
output.RenderEndTag();
output.RenderEndTag();
output.RenderEndTag();
output.RenderEndTag();
fileView.RenderItemEndTag(output);
output.RenderEndTag();
}
public void RenderControl(HtmlTextWriter writer)
{
SetTheme();
if (_version == ReCaptchaVersion.Version1)
{
var scriptCaptchaOptionsTag = new TagBuilder("script");
scriptCaptchaOptionsTag.Attributes.Add("type", MimeTypes.TextJavascript);
scriptCaptchaOptionsTag.InnerHtml =
string.Format("var RecaptchaOptions = {{ theme: '{0}', tabindex: 0 }}; ", Theme);
writer.Write(scriptCaptchaOptionsTag.ToString(TagRenderMode.Normal));
var scriptLoadApiTag = new TagBuilder("script");
scriptLoadApiTag.Attributes.Add("src", string.Format(RECAPTCHA_API_URL_VERSION1, PublicKey));
writer.Write(scriptLoadApiTag.ToString(TagRenderMode.Normal));
}
else if (_version == ReCaptchaVersion.Version2)
{
var scriptCallbackTag = new TagBuilder("script");
scriptCallbackTag.Attributes.Add("type", MimeTypes.TextJavascript);
scriptCallbackTag.InnerHtml = string.Format("var onloadCallback = function() {{grecaptcha.render('{0}', {{'sitekey' : '{1}', 'theme' : '{2}' }});}};", Id, PublicKey, Theme);
writer.Write(scriptCallbackTag.ToString(TagRenderMode.Normal));
var captchaTag = new TagBuilder("div");
captchaTag.Attributes.Add("id", Id);
writer.Write(captchaTag.ToString(TagRenderMode.Normal));
var scriptLoadApiTag = new TagBuilder("script");
scriptLoadApiTag.Attributes.Add("src", RECAPTCHA_API_URL_VERSION2 + (string.IsNullOrEmpty(Language) ? "" : string.Format("&hl={0}", Language)));
scriptLoadApiTag.Attributes.Add("async", null);
scriptLoadApiTag.Attributes.Add("defer", null);
writer.Write(scriptLoadApiTag.ToString(TagRenderMode.Normal));
}
}
