private void BindGrid() { SqlCommand cmd = new SqlCommand("select * from tblUser", con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Columns.Count; i++) { if (i == 0) { HyperLinkField b = new HyperLinkField(); b.HeaderText = dt.Columns[i].ColumnName; b.DataTextField = dt.Columns[i].ColumnName; b.DataNavigateUrlFormatString = "Default.aspx?Id={0}"; b.DataNavigateUrlFields = new string[] { dt.Columns[i].ColumnName }; b.Target = "_blank"; GridView1.Columns.Add(b); } else { BoundField b = new BoundField(); b.HeaderText = dt.Columns[i].ColumnName; b.DataField = dt.Columns[i].ColumnName; GridView1.Columns.Add(b); } } GridView1.DataSource = dt; GridView1.DataBind(); } }
protected void bindDataByDate(GridView gv) { DataSet ds = getBookingsDataThisyear(getSegmentID(), getSalesOrgID()); if (ds != null) { gv.Width = Unit.Pixel(300); gv.AutoGenerateColumns = false; gv.AllowPaging = false; gv.Visible = true; //Calculate the VAR column and Total row of next year. try { ds.Tables[0].Columns.Add("VAR"); if (ds.Tables[0].Rows[0][0] != DBNull.Value) { foreach (DataRow dr in ds.Tables[0].Rows) { float tmp = 0; if (float.Parse(dr[2].ToString()) != 0) { tmp = (float.Parse(dr[1].ToString()) - float.Parse(dr[2].ToString())) * 100 / float.Parse(dr[2].ToString()); dr["VAR"] = Convert.ToInt32(tmp).ToString() + "%"; } } } } catch { log.WriteLog(LogUtility.LogErrorLevel.LOG_ERROR, "Format string to float Error."); Response.Redirect("~/Executive/ExecutiveError.aspx"); } for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { BoundField bf = new BoundField(); bf.DataField = ds.Tables[0].Columns[i].ColumnName.ToString(); bf.HeaderText = ds.Tables[0].Columns[i].Caption.ToString(); bf.ItemStyle.HorizontalAlign = HorizontalAlign.Right; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Right; if (i == 0) { bf.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Left; } bf.ReadOnly = true; gv.Columns.Add(bf); } gv.Caption = "Total(" + year.Substring(2, 2) + ")"; gv.CaptionAlign = TableCaptionAlign.Top; gv.AllowSorting = true; gv.DataSource = ds.Tables[0]; gv.DataBind(); } else gv.Visible = false; }
/// <summary> /// Use for displaying out a data table by gridview /// </summary> /// <param name="gridview"></param> /// <param name="str_caption">caption of gridview</param> /// <param name="ds">DataSet</param> protected void bindDataSource(GridView gridview, string str_caption, DataSet ds) { bool flag = true; if (ds != null) { if (ds.Tables[0].Rows.Count == 0) { flag = false; sql.getNullDataSet(ds); } //By Lhy 20110512 ITEM18 DEL Start //gridview.Width = Unit.Pixel(260); //By Lhy 20110512 ITEM18 DEL End gridview.AutoGenerateColumns = false; //BY lhy 20110511 DEL Start; // gridview.AllowPaging = true; //BY lhy 20110511 DEL End; //BY lhy 20110511 ADD Start; gridview.AllowPaging = false; //BY lhy 20110511 ADD End; gridview.Visible = true; for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { BoundField bf = new BoundField(); bf.DataField = ds.Tables[0].Columns[i].ColumnName.ToString(); bf.HeaderText = ds.Tables[0].Columns[i].Caption.ToString(); bf.ItemStyle.Width = 200; bf.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Left; bf.HeaderStyle.Wrap = false; gridview.Columns.Add(bf); } CommandField cf_Delete = new CommandField(); cf_Delete.ButtonType = ButtonType.Image; cf_Delete.ShowDeleteButton = true; cf_Delete.ShowCancelButton = true; cf_Delete.CausesValidation = false; cf_Delete.DeleteImageUrl = "~/images/del.jpg"; cf_Delete.DeleteText = "Delete"; gridview.Columns.Add(cf_Delete); gridview.AllowSorting = true; //By Lhy 20110512 ITEM18 DEL End //gridview.Caption = str_caption; //gridview.CaptionAlign = TableCaptionAlign.Top; //By Lhy 20110512 ITEM18 DEL End gridview.DataSource = ds.Tables[0]; gridview.DataBind(); gridview.Columns[0].Visible = false; gridview.Columns[gridview.Columns.Count - 1].Visible = flag; if (getRoleID(getRole()) != "0") gridview.Columns[gridview.Columns.Count - 1].Visible = false; } }
protected void bindDataSource(DataSet ds_channel) { bool notNullFlag = true; if (ds_channel.Tables[0].Rows.Count == 0) { notNullFlag = false; sql.getNullDataSet(ds_channel); } gv_channel.Width = Unit.Pixel(600); gv_channel.AutoGenerateColumns = false; //By Wsy 20110512 ITEM 18 DEL Start //gv_channel.AllowPaging = true; //By Wsy 20110512 ITEM 18 DEL End //By Wsy 20110512 ITEM 18 ADD Start gv_channel.AllowPaging = false; //By Wsy 20110512 ITEM 18 ADD End gv_channel.Visible = true; gv_channel.HeaderStyle.Wrap = false; for (int i = 0; i < ds_channel.Tables[0].Columns.Count; i++) { BoundField bf = new BoundField(); bf.DataField = ds_channel.Tables[0].Columns[i].ColumnName.ToString(); bf.HeaderText = ds_channel.Tables[0].Columns[i].Caption.ToString(); bf.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Left; bf.ReadOnly = true; //By Wsy 20110512 ITEM 18 ADD Start bf.ItemStyle.Width = 500; //By Wsy 20110512 ITEM 18 ADD End bf.ControlStyle.Width = bf.ItemStyle.Width; gv_channel.Columns.Add(bf); } CommandField cf_Delete = new CommandField(); cf_Delete.ButtonType = ButtonType.Image; cf_Delete.ShowDeleteButton = true; cf_Delete.ShowCancelButton = true; cf_Delete.CausesValidation = false; cf_Delete.DeleteImageUrl = "~/images/del.jpg"; cf_Delete.DeleteText = "Delete"; gv_channel.Columns.Add(cf_Delete); gv_channel.AllowSorting = true; gv_channel.DataSource = ds_channel.Tables[0]; gv_channel.DataBind(); gv_channel.Columns[0].Visible = false; gv_channel.Columns[gv_channel.Columns.Count - 1].Visible = notNullFlag; if (getRoleID(getRole()) != "0") { gv_channel.Columns[gv_channel.Columns.Count - 1].Visible = false; } lbtn_channel.Visible = true; }
/// <summary> /// Adds new column to specified GridView control. /// </summary> /// <param name="gv">GridView control.</param> /// <param name="dataField">Name of the data field.</param> /// <param name="headerText">Header text.</param> private void AddColumnToGridView(GridView gv, string dataField, string headerText) { // Define first header column BoundField boundfield = new BoundField { DataField = dataField, HeaderText = headerText }; gv.Columns.Add(boundfield); }
private void createColumns(DataSet ds) { gvResult.Columns.Clear(); foreach (DataColumn column in ds.Tables[0].Columns) { BoundField boundField = new BoundField(); boundField.DataField = column.ColumnName; boundField.HeaderText = column.ColumnName; gvResult.Columns.Add(boundField); } }
public void BindGrid() { DataTable dtCost = getTable(); if (dtCost != null) { if (dtCost.Rows.Count > 0) { btnExport.Visible = true; grdCostReport.DataSource = dtCost; BoundField bnd = new BoundField(); bnd.DataField = "Field"; bnd.HeaderText = "Model"; grdCostReport.Columns.Add(bnd); string strQuarterQuery = "Select distinct Quarter from vw_QuarterWiseBudgetCost"; DataTable dtQuarter = objQueryController.ExecuteQuery(strQuarterQuery); if (dtQuarter != null) { if (dtQuarter.Rows.Count > 0) { foreach (DataRow drQuarter in dtQuarter.Rows) { BoundField bndf = new BoundField(); bndf.DataField = drQuarter["Quarter"].ToString(); bndf.HeaderText = drQuarter["Quarter"].ToString(); grdCostReport.Columns.Add(bndf); } } } strGroup = "ModelGroupName"; helper = new GridViewHelper(this.grdCostReport, false); string[] cols = new string[1]; cols[0] = strGroup; helper.RegisterGroup(cols, true, true); helper.GroupHeader += new GroupEvent(helper_GroupHeader); grdCostReport.DataBind(); } else { btnExport.Visible = false; grdCostReport.DataSource = null; grdCostReport.DataBind(); } } else { btnExport.Visible = false; grdCostReport.DataSource = null; grdCostReport.DataBind(); } }
protected void bound(string nombreCampo, string nombreLabel) { if (dt.Rows[0][nombreCampo].ToString() != "0" && dt.Rows[0][nombreCampo] != null && dt.Rows[0][nombreCampo].ToString() != "") { BoundField bound = new BoundField(); if (nombreCampo == "PrecioVenta") { if (dt.Rows[0]["MonedaVenta"].ToString() == "P") { bound.HeaderText = nombreLabel + " (ARS$)"; } else if (dt.Rows[0]["MonedaVenta"].ToString() == "D") { bound.HeaderText = nombreLabel + " (US$)"; } } else if (nombreCampo == "PrecioVenta2") { if (dt.Rows[0]["MonedaVenta2"].ToString() == "P") { bound.HeaderText = nombreLabel + " (ARS$)"; } else if (dt.Rows[0]["MonedaVenta2"].ToString() == "D") { bound.HeaderText = nombreLabel + " (US$)"; } } else if (nombreCampo == "PrecioAlquiler") { if (dt.Rows[0]["MonedaAlquiler"].ToString() == "P") { bound.HeaderText = nombreLabel + " (ARS$)"; } else if (dt.Rows[0]["MonedaAlquiler"].ToString() == "D") { bound.HeaderText = nombreLabel + " (US$)"; } } else { bound.HeaderText = nombreLabel; } bound.DataField = nombreCampo; bound.HeaderStyle.HorizontalAlign = HorizontalAlign.Right; bound.ItemStyle.HorizontalAlign = HorizontalAlign.Left; DetailsView1.Fields.Add(bound); } }
protected override void OnPreRender(EventArgs e) { base.OnPreRender(e); this.Visible = false; if (this.Table != null) { // Get the log table DataTable dt = this.Table; if (!DataHelper.DataSourceIsEmpty(dt)) { this.Visible = true; // Set the column names foreach (DataColumn dc in dt.Columns) { BoundField col = new BoundField(); col.DataField = dc.ColumnName; col.HeaderText = GetString(ResourcePrefix + dc.ColumnName); // Set style col.ItemStyle.BorderColor = Color.FromArgb(204, 204, 204); col.ItemStyle.BorderStyle = BorderStyle.Solid; col.ItemStyle.BorderWidth = 1; col.ItemStyle.HorizontalAlign = HorizontalAlign.Left; if (dc.DataType != typeof(string)) { col.ItemStyle.Wrap = false; } col.HeaderStyle.CopyFrom(col.ItemStyle); gridValues.Columns.Add(col); } // Bind the data gridValues.DataSource = dt; gridValues.DataBind(); if (!String.IsNullOrEmpty(this.Title)) { this.ltlInfo.Text = "<div style=\"padding: 5px 2px 2px 2px;\"><strong>" + this.Title + "</strong></div>"; } } } }
protected void bindDataSource(DataSet ds_region) { bool notNullFlag = true; if (ds_region.Tables[0].Rows.Count == 0) { notNullFlag = false; sql.getNullDataSet(ds_region); } gv_Region.Width = Unit.Pixel(800); gv_Region.AutoGenerateColumns = false; gv_Region.AllowPaging = false; gv_Region.Visible = true; for (int i = 0; i < ds_region.Tables[0].Columns.Count; i++) { BoundField bf = new BoundField(); bf.DataField = ds_region.Tables[0].Columns[i].ColumnName.ToString(); bf.HeaderText = ds_region.Tables[0].Columns[i].Caption.ToString(); bf.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Left; bf.HeaderStyle.Wrap = false; gv_Region.Columns.Add(bf); } //CommandField cf_Delete = new CommandField(); //cf_Delete.ButtonType = ButtonType.Image; //cf_Delete.ShowDeleteButton = true; //cf_Delete.ShowCancelButton = true; //cf_Delete.CausesValidation = false; //cf_Delete.DeleteImageUrl = "~/images/del.jpg"; //cf_Delete.DeleteText = "Delete"; //gv_Region.Columns.Add(cf_Delete); gv_Region.AllowSorting = true; gv_Region.DataSource = ds_region.Tables[0]; gv_Region.DataBind(); gv_Region.Columns[gv_Region.Columns.Count - 1].Visible = notNullFlag; gv_Region.Columns[0].Visible = false; gv_Region.Columns[1].Visible = false; gv_Region.Columns[2].Visible = false; gv_Region.Columns[3].Visible = false; if (getRoleID(getRole()) != "0") gv_Region.Columns[gv_Region.Columns.Count - 1].Visible = false; }
//private SqlDataSource _sqlDataSource; private void _SetupGridView() { var idBoundField = new ButtonField { DataTextField = "ID", ButtonType = ButtonType.Link, CommandName = "Select", HeaderText = "Select" }; var firstNameField = new BoundField { DataField = "FirstName", HeaderText = "First Name", SortExpression = "FirstName, LastName" }; var lastNameField = new BoundField { DataField = "LastName", HeaderText = "Last Name", SortExpression = "LastName, FirstName" }; var phoneField = new BoundField { DataField = "Phone", HeaderText = "Phone", SortExpression = "Phone" }; var emailField = new BoundField { DataField = "EmailAddress", HeaderText = "Email Address", SortExpression = "EmailAddress" }; _gridView.Columns.Add(idBoundField); _gridView.Columns.Add(firstNameField); _gridView.Columns.Add(lastNameField); _gridView.Columns.Add(phoneField); _gridView.Columns.Add(emailField); _gridView.DataSourceID = "_sqlDataSource"; _gridView.DataKeyNames = new[] {"Id"}; _gridView.RowCommand += GridCommand; }
/// <summary> /// bindDataSource /// </summary> /// <param name="gridview"></param> /// <param name="str_caption"></param> /// <param name="ds"></param> /// <param name="sel"></param> /// protected void bindDataSource(GridView gridview, string str_caption, DataSet ds, bool sel) { bool bflag = true; if (ds.Tables[0].Rows.Count == 0) { bflag = false; sql.getNullDataSet(ds); } gridview.Width = Unit.Pixel(370); gridview.AutoGenerateColumns = false; gridview.AllowPaging = false; gridview.Visible = true; for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { BoundField bf = new BoundField(); bf.DataField = ds.Tables[0].Columns[i].ColumnName.ToString(); bf.ItemStyle.Width = 200; bf.HeaderText = ds.Tables[0].Columns[i].Caption.ToString(); bf.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Left; gridview.Columns.Add(bf); } CommandField cf_Delete = new CommandField(); cf_Delete.ButtonType = ButtonType.Image; cf_Delete.ShowDeleteButton = true; cf_Delete.ShowCancelButton = true; cf_Delete.CausesValidation = false; cf_Delete.DeleteImageUrl = "~/images/del.jpg"; cf_Delete.DeleteText = "Delete"; gridview.Columns.Add(cf_Delete); gridview.Caption = str_caption; gridview.CaptionAlign = TableCaptionAlign.Top; gridview.AllowSorting = true; gridview.DataSource = ds.Tables[0]; gridview.DataBind(); gridview.Columns[0].Visible = false; gridview.Columns[gridview.Columns.Count - 1].Visible = bflag; }
protected void bindDataSource() { DataSet ds_Country = sql.getOperationBySegment(ddlist_segment.SelectedItem.Value); if (ds_Country.Tables[0].Rows.Count > 0) { gv_opAbbr.Width = Unit.Pixel(200); gv_opAbbr.AutoGenerateColumns = false; gv_opAbbr.AllowPaging = true; gv_opAbbr.Visible = true; for (int i = 2; i < ds_Country.Tables[0].Columns.Count; i++) { BoundField bf = new BoundField(); bf.DataField = ds_Country.Tables[0].Columns[i].ColumnName.ToString(); bf.HeaderText = ds_Country.Tables[0].Columns[i].Caption.ToString(); bf.ItemStyle.Width = 100; bf.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Left; bf.ReadOnly = true; gv_opAbbr.Columns.Add(bf); } gv_opAbbr.AllowSorting = true; gv_opAbbr.DataSource = ds_Country.Tables[0]; gv_opAbbr.DataBind(); panel_enter.Visible = true; panel_enter.Enabled = true; } else { panel_enter.Visible = true; gv_opAbbr.Visible = false; panel_enter.Enabled = false; } }
/// <summary> /// Bind user information /// </summary> /// <param name="ds">dataset</param> protected void bindDataSource(DataSet ds) { if (ds.Tables[0].Rows.Count == 0) { sql.getNullDataSet(ds); } gv_administrator.Width = Unit.Pixel(800); gv_administrator.AutoGenerateColumns = false; gv_administrator.AllowPaging = true; gv_administrator.Visible = true; //add columns addOperationCol(ds); addCountryCol(ds); addSegmentCol(ds); for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { BoundField bf = new BoundField(); bf.DataField = ds.Tables[0].Columns[i].ColumnName.ToString(); bf.HeaderText = ds.Tables[0].Columns[i].Caption.ToString(); bf.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Left; gv_administrator.Columns.Add(bf); } gv_administrator.AllowSorting = true; gv_administrator.DataSource = ds.Tables[0]; gv_administrator.DataBind(); gv_administrator.Columns[0].Visible = false; gv_administrator.Columns[6].Visible = false; gv_administrator.Columns[7].Visible = false; gv_administrator.Columns[8].Visible = false; gv_administrator.Columns[9].Visible = false; }
protected override void OnPreRender(EventArgs e) { base.OnPreRender(e); Visible = false; if (Table != null) { // Get the log table DataTable dt = Table; if (!DataHelper.DataSourceIsEmpty(dt)) { Visible = true; // Set the column names foreach (DataColumn dc in dt.Columns) { BoundField col = new BoundField(); col.DataField = dc.ColumnName; col.HeaderText = GetString(ResourcePrefix + dc.ColumnName); col.HeaderStyle.CopyFrom(col.ItemStyle); gridValues.Columns.Add(col); } // Bind the data gridValues.DataSource = dt; gridValues.DataBind(); if (!String.IsNullOrEmpty(Title)) { ltlInfo.Text = "<div style=\"padding: 5px 2px 2px 2px;\"><strong>" + Title + "</strong></div>"; } } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { BoundField dcf = new BoundField(); dcf.HeaderText = "Nome"; dcf.DataField = "Name"; GridViewSubscriptions.Columns.Add(dcf); dcf = new BoundField(); dcf.HeaderText = "Cognome"; dcf.DataField = "Surname"; GridViewSubscriptions.Columns.Add(dcf); dcf = new BoundField(); dcf.HeaderText = "Gruppo"; dcf.DataField = "Club"; GridViewSubscriptions.Columns.Add(dcf); dcf = new BoundField(); dcf.HeaderText = "Mail"; dcf.DataField = "EMail"; GridViewSubscriptions.Columns.Add(dcf); dcf = new BoundField(); dcf.HeaderText = "Data di nascita"; dcf.DataField = "BirthDateFormatted"; GridViewSubscriptions.Columns.Add(dcf); dcf = new BoundField(); dcf.HeaderText = "Sesso"; dcf.DataField = "GenderDescription"; GridViewSubscriptions.Columns.Add(dcf); } LoadSubscriptors(); }
//private DataSet fillDataSet() //{ // IAppointment FormManager; // DataSet theDtSet; // IQCareUtils clsUtil = new IQCareUtils(); // FormManager = (IAppointment)ObjectFactory.CreateInstance("BusinessProcess.Scheduler.BAppointment, BusinessProcess.Scheduler"); // IQCareUtils theUtil = new IQCareUtils(); // theDtSet = new DataSet(); // grdSearchResult.Columns.Clear(); // grdSearchResult.DataSource = null; // return theDtSet; //} private void BindGrid() { BoundField theCol0 = new BoundField(); theCol0.HeaderText = "SubTestID"; theCol0.DataField = "SubTestID"; theCol0.ItemStyle.CssClass = " textstyle"; theCol0.ReadOnly = true; grdSearchResult.Columns.Add(theCol0); grdSearchResult.Columns[0].Visible = false; BoundField theCol1 = new BoundField(); theCol1.HeaderText = "SubTestName"; theCol1.DataField = "SubTestName"; theCol1.ItemStyle.CssClass = "textstyle"; theCol1.ReadOnly = true; grdSearchResult.Columns.Add(theCol1); grdSearchResult.Columns[1].Visible = false; BoundField theCol2 = new BoundField(); theCol2.HeaderText = "UnitID"; theCol2.DataField = "UnitID"; theCol2.ItemStyle.CssClass = "textstyle"; theCol2.ReadOnly = true; grdSearchResult.Columns.Add(theCol2); grdSearchResult.Columns[2].Visible = false; BoundField theCol3 = new BoundField(); theCol3.HeaderText = "Units"; theCol3.DataField = "UnitName"; theCol3.ItemStyle.CssClass = "textstyle"; theCol3.SortExpression = "UnitName"; theCol3.ReadOnly = true; grdSearchResult.Columns.Add(theCol3); grdSearchResult.Columns[3].Visible = true; BoundField theCol4 = new BoundField(); theCol4.HeaderText = "Lower Boundary"; theCol4.DataField = "MinBoundaryValue"; theCol4.ItemStyle.CssClass = "textstyle"; theCol4.SortExpression = "MinBoundaryValue"; theCol4.ReadOnly = true; grdSearchResult.Columns.Add(theCol4); grdSearchResult.Columns[4].Visible = true; BoundField theCol5 = new BoundField(); theCol5.HeaderText = "Upper Boundary"; theCol5.DataField = "MaxBoundaryValue"; theCol5.ItemStyle.CssClass = "textstyle"; theCol5.SortExpression = "MaxBoundaryValue"; theCol5.ReadOnly = true; grdSearchResult.Columns.Add(theCol5); grdSearchResult.Columns[5].Visible = true; BoundField theCol6 = new BoundField(); theCol6.HeaderText = "Default"; theCol6.DataField = "DefaultUnit"; theCol6.ItemStyle.CssClass = "textstyle"; theCol6.ReadOnly = true; theCol6.SortExpression = "DefaultUnit"; grdSearchResult.Columns.Add(theCol6); grdSearchResult.Columns[6].Visible = true; BoundField theCol7 = new BoundField(); theCol7.HeaderText = "ID"; theCol7.DataField = "ID"; theCol7.ItemStyle.CssClass = "textstyle"; theCol7.ReadOnly = true; grdSearchResult.Columns.Add(theCol7); grdSearchResult.Columns[7].Visible = false; BoundField theCol8 = new BoundField(); theCol8.HeaderText = "Undetectable"; theCol8.DataField = "undetectable"; theCol8.ItemStyle.CssClass = "textstyle"; theCol8.ReadOnly = true; theCol8.SortExpression = "undetectable"; grdSearchResult.Columns.Add(theCol8); grdSearchResult.Columns[8].Visible = true; //grdSearchResult.DataSource = ((DataSet)ViewState["MstDS"]).Tables[1]; grdSearchResult.DataBind(); }
protected void bindDataSource() { tbox_date.Text = ddlist_meetingdate.SelectedItem.Text.Trim(); DataSet ds_currency = getCurrencyInfo(ddlist_meetingdate.SelectedItem.Value.Trim()); if (ds_currency != null) { gv_currency.Width = Unit.Pixel(600); gv_currency.AutoGenerateColumns = false; // update by SJ 20110511 Start //gv_currency.AllowPaging = true; gv_currency.AllowPaging = false; // update by SJ 20110511 End gv_currency.Visible = true; for (int i = 0; i < ds_currency.Tables[0].Columns.Count; i++) { BoundField bf = new BoundField(); bf.DataField = ds_currency.Tables[0].Columns[i].ColumnName.ToString(); bf.HeaderText = ds_currency.Tables[0].Columns[i].Caption.ToString(); if (ds_currency.Tables[0].Columns[i].ColumnName == "ID" || ds_currency.Tables[0].Columns[i].ColumnName == "Currency") bf.ReadOnly = true; else { bf.ItemStyle.Width = 120; bf.ReadOnly = false; } bf.ControlStyle.Width = bf.ItemStyle.Width; bf.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Left; gv_currency.Columns.Add(bf); } CommandField cf_Update = new CommandField(); cf_Update.ButtonType = ButtonType.Image; cf_Update.ShowEditButton = true; cf_Update.ShowCancelButton = true; cf_Update.EditImageUrl = "~/images/edit.jpg"; cf_Update.EditText = "Edit"; cf_Update.CausesValidation = false; cf_Update.CancelImageUrl = "~/images/cancel.jpg"; cf_Update.CancelText = "Cancel"; cf_Update.UpdateImageUrl = "~/images/ok.jpg"; cf_Update.UpdateText = "Update"; gv_currency.Columns.Add(cf_Update); CommandField cf_Delete = new CommandField(); cf_Delete.ButtonType = ButtonType.Image; cf_Delete.ShowDeleteButton = true; cf_Delete.ShowCancelButton = true; cf_Delete.CausesValidation = false; cf_Delete.DeleteImageUrl = "~/images/del.jpg"; cf_Delete.DeleteText = "Delete"; gv_currency.Columns.Add(cf_Delete); gv_currency.AllowSorting = true; gv_currency.DataSource = ds_currency.Tables[0]; gv_currency.DataBind(); gv_currency.Columns[0].Visible = false; if (getRoleID(getRole()) != "0") { gv_currency.Columns[gv_currency.Columns.Count - 1].Visible = false; gv_currency.Columns[gv_currency.Columns.Count - 2].Visible = false; } } }
/// <summary> /// 绑定Gridview /// </summary> private void BindGridView() { using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { if (!string.IsNullOrEmpty(Request.QueryString["QCBatch"])) { QCbatch = Request.QueryString["QCBatch"]; } BoundField bfColumn; foreach (var kvp in Titlelist) { bfColumn = new BoundField(); bfColumn.HeaderText = kvp.Split(':')[0]; bfColumn.DataField = kvp.Split(':')[1]; this.gv.Columns.Add(bfColumn); } //添加选择列 TemplateField reportNum = new TemplateField(); reportNum.ItemTemplate = new MulTextBoxTemplate("请选择", DataControlRowType.DataRow, "", "MaterialsLeaderID", "txtgentaojianNum"); reportNum.HeaderTemplate = new MulTextBoxTemplate("根/台/套/件(合格)", DataControlRowType.Header); reportNum.ItemStyle.Width = 150; this.gv.Columns.Insert(5, reportNum); TemplateField f_reportNum = new TemplateField(); f_reportNum.ItemTemplate = new MulTextBoxTemplate("请选择", DataControlRowType.DataRow, "", "MaterialsLeaderID", "txtgentaojianNums"); f_reportNum.HeaderTemplate = new MulTextBoxTemplate("根/台/套/件(不合格)", DataControlRowType.Header); f_reportNum.ItemStyle.Width = 150; this.gv.Columns.Insert(6, f_reportNum); TemplateField metreNum = new TemplateField(); metreNum.ItemTemplate = new MulTextBoxTemplate("请选择", DataControlRowType.DataRow, "", "MaterialsLeaderID", "txtmetreNum"); metreNum.HeaderTemplate = new MulTextBoxTemplate("米(合格)", DataControlRowType.Header); metreNum.ItemStyle.Width = 150; this.gv.Columns.Insert(8, metreNum); TemplateField f_metreNum = new TemplateField(); f_metreNum.ItemTemplate = new MulTextBoxTemplate("请选择", DataControlRowType.DataRow, "", "MaterialsLeaderID", "txtmetreNums"); f_metreNum.HeaderTemplate = new MulTextBoxTemplate("米(不合格)", DataControlRowType.Header); f_metreNum.ItemStyle.Width = 150; this.gv.Columns.Insert(9, f_metreNum); TemplateField tonNum = new TemplateField(); tonNum.ItemTemplate = new MulTextBoxTemplate("请选择", DataControlRowType.DataRow, "", "MaterialsLeaderID", "txttonNum"); tonNum.HeaderTemplate = new MulTextBoxTemplate("吨(合格)", DataControlRowType.Header); tonNum.ItemStyle.Width = 150; this.gv.Columns.Insert(11, tonNum); TemplateField f_tonNum = new TemplateField(); f_tonNum.ItemTemplate = new MulTextBoxTemplate("请选择", DataControlRowType.DataRow, "", "MaterialsLeaderID", "txttonNums"); f_tonNum.HeaderTemplate = new MulTextBoxTemplate("吨(不合格)", DataControlRowType.Header); f_tonNum.ItemStyle.Width = 150; this.gv.Columns.Insert(12, f_tonNum); TemplateField testReport = new TemplateField(); testReport.ItemTemplate = new MulTextBoxTemplate("请选择", DataControlRowType.DataRow, "", "MaterialsLeaderID", "txtreportNum"); testReport.HeaderTemplate = new MulTextBoxTemplate("质检报告号", DataControlRowType.Header); testReport.ItemStyle.Width = 150; this.gv.Columns.Insert(13, testReport); //HyperLinkField hlTask = new HyperLinkField(); //hlTask.HeaderText = "上传质检报告"; //this.gv.Columns.Insert(14, hlTask); this.gv.DataSource = from a in db.StorageInMaterialsLeader join b in db.StorageInMain on a.StorageInMaterials.StorageProduce.StorageInID equals b.StorageInID where a.StorageInMaterials.StorageProduce.StorageInID == _storageInID && a.StorageInMaterials.StorageProduce.BatchIndex == (string.IsNullOrEmpty(QCbatch) ? a.StorageInMaterials.StorageProduce.BatchIndex : QCbatch) select new { a.MaterialsLeaderID, a.StorageInMaterials.StorageProduce.MaterialInfo.MaterialName, a.StorageInMaterials.StorageProduce.MaterialInfo.SpecificationModel, a.StorageInMaterials.StorageProduce.MaterialInfo.FinanceCode, b.StorageInCode, a.StorageInMaterials.RealGentaojian, a.StorageInMaterials.RealMetre, a.StorageInMaterials.RealTon, a.StorageInMaterials.StorageProduce.ProjectInfo.ProjectName, a.StorageInMaterials.StorageProduce.ExpectedTime, a.StorageInMaterials.StorageProduce.BatchIndex, a.Remark }; this.gv.RowDataBound += new GridViewRowEventHandler(gv_RowDataBound); this.gv.DataBind(); this.gv.Columns[this.gv.Columns.Count - 1].Visible = false; Panel p1 = (Panel)GetControltByMaster("Panel1"); p1.Controls.Add(this.gv); } }
protected void btnExport_Click(object sender, EventArgs e) { string sWhereSQL = " And SignStatus=" + ddlSignStatus.SelectedValue.ToString(); if (txtUserSalaryOpCode.Text.Length > 0) { sWhereSQL = sWhereSQL + " And a.OpCode = '" + txtUserSalaryOpCode.Text + "'"; } if (txtSalaryYears.Text.Length > 0) { sWhereSQL += " And a.SalaryYears = '" + txtSalaryYears.Text + "'"; } if (ddlImportRec.SelectedIndex > 0) { sWhereSQL += " And a.SalaryRecGuid='" + ddlImportRec.SelectedValue.ToString() + "'"; } string sSQL = "select a.ID, a.OpCode, b.OpName, b.Sex, b.IdNumber, a.SalaryYears, a.SalaryDate"; SqlDataReader sdr = SysClass.SysUserSalary.GetUserSalaryFieldsLstByReader(txtSalaryYears.Text); //gvLists.Columns.Clear(); while (sdr.Read()) { sSQL += "," + sdr["FieldName"].ToString(); string sPDSQL = " Select top 1 1 From UserSalary_Info a" + " left join SysUser_Info b on b.Status=0 And a.OpCode=b.OpCode" + " Where a.Status=0 " + sWhereSQL; if ((sdr["FieldName"].ToString() == "TotalSalary") || (sdr["FieldType"].ToString() != "1")) { sPDSQL += " And IsNull(" + sdr["FieldName"].ToString() + ",0) > 0 "; } else { sPDSQL += " And IsNull(" + sdr["FieldName"].ToString() + ",'') <> '' "; } if (SysClass.SysGlobal.GetExecSqlIsExist(sPDSQL)) { BoundField nameColumn = new BoundField(); nameColumn.HeaderText = sdr["UserFieldTitle"].ToString(); nameColumn.DataField = sdr["FieldName"].ToString(); gvLists.Columns.Add(nameColumn); } } sdr.Close(); sSQL += " from UserSalary_Info a " + " left join SysUser_Info b on b.Status=0 And a.OpCode=b.OpCode" + " Where a.Status=0 " + sWhereSQL; sSQL += " Order By a.SalaryYears Desc"; CyxPack.CommonOperation.DataBinder.BindGridViewData(gvLists, CyxPack.OperateSqlServer.DataCommon.GetDataByReader(sSQL)); if (gvLists.Rows.Count > 0) { //调用导出方法 ExportGridViewForUTF8(gvLists, DateTime.Now.ToString() + ".xls"); } else { } }
private string GenerateExportData(string dataFormat) { border = (dataFormat == "Print" ? "0" : "1"); dtExcelData = Session["ListDetail"] as DataTable; string styleSheet = "<style>.text { mso-number-format:\\@; } .barcode {font-size : 12pt; font-family : IDAutomationC39S; }</style>"; string headerContent = string.Empty; string footerContent = string.Empty; string excelContent = string.Empty; headerContent = "<table border='0' width='800px'>"; headerContent += "<tr><td colspan='7' align='center'><span style='font-size : 12pt; font-family : IDAutomationC39S; '>*" + Request.QueryString["ListName"].ToString() + "*</span></td></tr>"; headerContent += "<tr><td colspan='7' align='center' style='color:blue;font-family: Arial, Helvetica, sans-serif;font-size: 14px; font-weight: bold;'><center>Shipping List</center></td></tr>"; headerContent += "<tr><td style='padding-left:40px'><b>List Name :" + Request.QueryString["ListName"].ToString() + "</b></td><td><b>Location:" + Request.QueryString["Location"].ToString() + "</b></td><td colspan='5'><b>Change ID: " + Request.QueryString["ChangeID"].ToString() + "</b></td></tr>"; headerContent += "<tr><td style='padding-left:40px'><b>Entry ID:" + Request.QueryString["EntryID"].ToString() + "</b></td>" + "<td><b>Entry Date: " + Request.QueryString["EntryDt"].ToString() + "</b></td>" + "<td colspan='5'><b>Change Date: " + Request.QueryString["ChangeDt"].ToString() + "</></td></tr>"; headerContent += "<tr><th colspan='7' style='color:blue' align=left></th></tr>"; if (dtExcelData.Rows.Count > 0) { dv.AutoGenerateColumns = false; dv.ShowHeader = true; dv.ShowFooter = true; dv.RowDataBound += new GridViewRowEventHandler(dv_RowDataBound); BoundField bfExcel = new BoundField(); bfExcel.HeaderText = "Document No"; bfExcel.DataField = "OrderNo"; bfExcel.ItemStyle.Height = 25; bfExcel.FooterStyle.Height = 25; bfExcel.HeaderStyle.Height = 25; bfExcel.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bfExcel.FooterStyle.HorizontalAlign = HorizontalAlign.Right; dv.Columns.Add(bfExcel); bfExcel = new BoundField(); bfExcel.HeaderText = "Customer Name"; bfExcel.DataField = "CustName"; bfExcel.ItemStyle.Width = 150; bfExcel.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bfExcel.FooterStyle.HorizontalAlign = HorizontalAlign.Right; dv.Columns.Add(bfExcel); bfExcel = new BoundField(); bfExcel.HeaderText = "Pallet No"; bfExcel.DataField = "PalletNo"; bfExcel.ItemStyle.Width = 80; bfExcel.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bfExcel.FooterStyle.HorizontalAlign = HorizontalAlign.Right; dv.Columns.Add(bfExcel); bfExcel = new BoundField(); bfExcel.HeaderText = "Doc Lbs"; bfExcel.DataField = "ShipWght"; bfExcel.DataFormatString = "{0:#,##0.00}"; bfExcel.ItemStyle.Width = 60; bfExcel.ItemStyle.HorizontalAlign = HorizontalAlign.Right; bfExcel.FooterStyle.HorizontalAlign = HorizontalAlign.Right; bfExcel.FooterStyle.Font.Bold = true; dv.Columns.Add(bfExcel); bfExcel = new BoundField(); bfExcel.HeaderText = "Entry ID"; bfExcel.DataField = "EntryID"; bfExcel.ItemStyle.Width = 80; bfExcel.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bfExcel.FooterStyle.HorizontalAlign = HorizontalAlign.Right; dv.Columns.Add(bfExcel); bfExcel = new BoundField(); bfExcel.HeaderText = "Change ID"; bfExcel.DataField = "ChangeID"; bfExcel.ItemStyle.Width = 80; bfExcel.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bfExcel.FooterStyle.HorizontalAlign = HorizontalAlign.Right; dv.Columns.Add(bfExcel); bfExcel = new BoundField(); bfExcel.HeaderText = "PO #"; bfExcel.DataField = "CustPONo"; bfExcel.ItemStyle.Width = 170; bfExcel.ItemStyle.HorizontalAlign = HorizontalAlign.Left; dv.Columns.Add(bfExcel); bfExcel = new BoundField(); bfExcel.HeaderText = "Status"; bfExcel.DataField = "StatusCd"; bfExcel.ItemStyle.Width = 60; bfExcel.FooterStyle.HorizontalAlign = HorizontalAlign.Right; dv.Columns.Add(bfExcel); dv.DataSource = dtExcelData; dv.DataBind(); System.Text.StringBuilder sb = new System.Text.StringBuilder(); System.IO.StringWriter sw = new System.IO.StringWriter(sb); HtmlTextWriter htw = new HtmlTextWriter(sw); dv.RenderControl(htw); excelContent += "<table><tr><th colspan='7' style='padding-left:40px;padding-top:10px;' align=left>"; excelContent += sb.ToString(); excelContent += "</th></tr></table>"; } else { excelContent = "<tr ><th width='100%' align ='center' colspan='7' > No records found</th></tr> </table>"; } return(styleSheet + headerContent + excelContent); }
private void BindGrid() { //Bind the fields of the gridview BoundField theCol0 = new BoundField(); theCol0.HeaderText = "Lab Test ID"; theCol0.DataField = "LabTestID"; theCol0.ItemStyle.CssClass = "textstyle"; theCol0.ReadOnly = true; BoundField theCol1 = new BoundField(); theCol1.HeaderText = "Priority"; theCol1.DataField = "Sequence"; theCol1.ItemStyle.CssClass = "textstyle"; theCol1.SortExpression = "Sequence"; theCol1.ItemStyle.Font.Underline = true; theCol1.ReadOnly = true; BoundField theCol2 = new BoundField(); theCol2.HeaderText = "Lab Type"; theCol2.ItemStyle.CssClass = "textstyle"; theCol2.DataField = "LabTypeName"; theCol2.SortExpression = "LabTypeName"; theCol2.ReadOnly = true; BoundField theCol3 = new BoundField(); theCol3.HeaderText = "Department"; theCol3.ItemStyle.CssClass = "textstyle"; theCol3.DataField = "LabDepartmentName"; theCol3.SortExpression = "LabDepartmentName"; theCol3.ReadOnly = true; BoundField theCol4 = new BoundField(); theCol4.HeaderText = "Test Name"; theCol4.ItemStyle.CssClass = "textstyle"; theCol4.DataField = "LabName"; theCol4.SortExpression = "LabName"; theCol4.ReadOnly = true; BoundField theCol5 = new BoundField(); theCol5.HeaderText = "Status"; theCol5.DataField = "Status"; theCol5.ItemStyle.CssClass = "textstyle"; theCol5.SortExpression = "Status"; theCol5.ReadOnly = true; ButtonField theBtn = new ButtonField(); theBtn.ButtonType = ButtonType.Link; theBtn.CommandName = "Select"; theBtn.HeaderStyle.CssClass = "textstylehidden"; theBtn.ItemStyle.CssClass = "textstylehidden"; grdLab.Columns.Add(theCol0); grdLab.Columns.Add(theCol1); /////grdLab.Columns.Add(theCol2); ----- Sanjay 13 Sept 2006 grdLab.Columns.Add(theCol3); grdLab.Columns.Add(theCol4); grdLab.Columns.Add(theCol5); grdLab.Columns.Add(theBtn); grdLab.DataBind(); grdLab.Columns[0].Visible = false; }
void RefreshGridView() { GlobalMethods.DeleteOldFile(); GridView1.RowDeleting += new GridViewDeleteEventHandler(GridView1_RowDeleting); GridView1.RowEditing += new GridViewEditEventHandler(GridView1_RowEditing); GridView1.SelectedIndexChanged += new EventHandler(GridView1_SelectedIndexChanged); string[] files = System.IO.Directory.GetFiles(Server.MapPath("~/dumpfiles")); DataTable dt = new DataTable(); dt.Columns.Add("Filename"); foreach (string s in files) { if (!s.EndsWith("sql")) { continue; } dt.Rows.Add(System.IO.Path.GetFileName(s)); } if (Session["filedeleted"] != null) { Label1.Text = Session["filedeleted"] + " is deleted.<br />"; Session["filedeleted"] = null; } else { Label1.Text = string.Empty; } if (dt.Rows.Count == 0) { Label1.Text += "No files."; } else { Label1.Text += string.Empty; } GridView1.DataSource = null; GridView1.DataBind(); GridView1.Columns.Clear(); GridView1.DataSource = dt; GridView1.AutoGenerateColumns = false; BoundField colnName = new BoundField(); colnName.HeaderText = "Filename"; colnName.DataField = "Filename"; colnName.ReadOnly = true; CommandField colnDel = new CommandField(); colnDel.DeleteText = "Delete"; colnDel.ShowDeleteButton = true; CommandField colnDownload = new CommandField(); colnDownload.EditText = "Download"; colnDownload.ShowEditButton = true; CommandField colnView = new CommandField(); colnView.ShowSelectButton = true; colnView.SelectText = "View"; GridView1.Columns.Add(colnName); GridView1.Columns.Add(colnDel); GridView1.Columns.Add(colnDownload); GridView1.Columns.Add(colnView); GridView1.Columns[0].ItemStyle.Width = Unit.Pixel(150); GridView1.Columns[1].ItemStyle.Width = Unit.Pixel(55); GridView1.Columns[2].ItemStyle.Width = Unit.Pixel(70); GridView1.Columns[3].ItemStyle.Width = Unit.Pixel(70); GridView1.SelectedIndex = -1; GridView1.DataBind(); Session.Clear(); }
public override void SetStylesAndFormats(BoundField column, string format) { base.SetStylesAndFormats(column, format); column.DataFormatString = format != string.Empty ? string.Format("{{0:{0}}}", format) : "{0:g}"; }
private void InitializeCustomControls() { InitBar(); //***初始化新建物资列表***// this.spgvMaterial = new SPGridView(); this.spgvMaterial.AutoGenerateColumns = false; this.spgvMaterial.Attributes.Add("style", "word-break:keep-all;word-wrap:normal"); Panel p1 = (Panel)GetControltByMaster("Panel1"); p1.Controls.Add(this.spgvMaterial);//应用分页模版,必须先将spgvMaterial加入到页面中 //分页 this.spgvMaterial.AllowPaging = true; this.spgvMaterial.PageSize = 10; this.spgvMaterial.PageIndexChanging += new GridViewPageEventHandler(spgvMaterial_PageIndexChanging); this.spgvMaterial.PagerTemplate = new PagerTemplate("{0} - {1}", spgvMaterial); this.spgvMaterial.Columns.Clear();//应用分页模版,必须清除所有列 //添加选择列 TemplateField tfieldCheckbox = new TemplateField(); tfieldCheckbox.ItemTemplate = new CheckBoxTemplate("选择", DataControlRowType.DataRow); tfieldCheckbox.HeaderTemplate = new CheckBoxTemplate("选择", DataControlRowType.Header); this.spgvMaterial.Columns.Add(tfieldCheckbox); BoundField bfColumn; foreach (var kvp in Titlelist) { bfColumn = new BoundField(); bfColumn.HeaderText = kvp.Split(':')[0]; bfColumn.DataField = kvp.Split(':')[1]; this.spgvMaterial.Columns.Add(bfColumn); } //加入调拨数量(根/台/套/件)列 TemplateField tfGentaojian = new TemplateField(); tfGentaojian.HeaderText = "调拨数量(根/台/套/件)"; tfGentaojian.ItemTemplate = new TextBoxTemplate("Gentaojian", string.Empty, "^(-?\\d+)(\\.\\d+)?$", "0", 80); this.spgvMaterial.Columns.Insert(5, tfGentaojian); //加入调拨数量(米)列 TemplateField tfMetre = new TemplateField(); tfMetre.HeaderText = "调拨数量(米)"; tfMetre.ItemTemplate = new TextBoxTemplate("Metre", string.Empty, "^(-?\\d+)(\\.\\d+)?$", "0", 80); this.spgvMaterial.Columns.Insert(7, tfMetre); //加入调拨数量(吨)列 TemplateField tfTon = new TemplateField(); tfTon.HeaderText = "调拨数量(吨)"; tfTon.ItemTemplate = new TextBoxTemplate("Ton", string.Empty, "^(-?\\d+)(\\.\\d+)?$", "0", 80); this.spgvMaterial.Columns.Insert(9, tfTon); //加入备注 TemplateField tfRemark = new TemplateField(); tfRemark.HeaderText = "备注"; tfRemark.ItemTemplate = new TextBoxTemplate("Remark", DataControlRowType.DataRow); this.spgvMaterial.Columns.Insert(10, tfRemark); //***初始化已加入物资列表***// this.spgvExistMaterial = new SPGridView(); this.spgvExistMaterial.AutoGenerateColumns = false; this.spgvExistMaterial.Attributes.Add("style", "word-break:keep-all;word-wrap:normal"); foreach (var kvp in ExistTitlelist) { bfColumn = new BoundField(); bfColumn.HeaderText = kvp.Split(':')[0]; bfColumn.DataField = kvp.Split(':')[1]; this.spgvExistMaterial.Columns.Add(bfColumn); } btnOK = (Button)GetControltByMaster("btnOK"); btnOK.Click += new EventHandler(btnOK_Click); btnSearch = (Button)GetControltByMaster("btnSearch"); btnSearch.Click += new EventHandler(btnSearch_Click); chbShowAll = (CheckBox)GetControltByMaster("chbShowAll"); chbShowAll.CheckedChanged += new EventHandler(chbShowAll_CheckedChanged); txtMaterialName = GetControltByMaster("txtMaterialName") as TextBox; txtFinanceCode = GetControltByMaster("txtFinanceCode") as TextBox; txtSpecificationModel = GetControltByMaster("txtSpecificationModel") as TextBox; }
protected bool sendEmail(string RequestNo, string requestEmail) { bool mailSent = false; try { GridView objGV = new GridView(); objGV.AutoGenerateColumns = false; BoundField bfLabourCategory = new BoundField(); bfLabourCategory.HeaderText = "LabourCategory"; bfLabourCategory.DataField = "LabourCategory"; objGV.Columns.Add(bfLabourCategory); //BoundField bfDateofAttendance = new BoundField(); //bfDateofAttendance.HeaderText = "DateOfAttendance"; //bfDateofAttendance.DataField = "DateOfAttendance"; //bfDateofAttendance.DataFormatString = "{0:dd-MMM-yyyy}"; //objGV.Columns.Add(bfDateofAttendance); BoundField bfLabourNo = new BoundField(); bfLabourNo.HeaderText = "LabourNo"; bfLabourNo.DataField = "LabourNo"; objGV.Columns.Add(bfLabourNo); BoundField bfJustification = new BoundField(); bfJustification.HeaderText = "Justification"; bfJustification.DataField = "Justification"; objGV.Columns.Add(bfJustification); BoundField bfRemarks = new BoundField(); bfRemarks.HeaderText = "Remarks"; bfRemarks.DataField = "Remarks"; objGV.Columns.Add(bfRemarks); SqlConnection sqlConnection = new SqlConnection(); sqlConnection.ConnectionString = connectionString; //Connection Details //select fields to mail example student details SqlCommand sqlCommand = new SqlCommand("select LabourCategory,LabourNo,Justification,Remarks from vwLabourRequestFormDetails where RequestNo = @RequestNo", sqlConnection); //select query command SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(); sqlDataAdapter.SelectCommand = sqlCommand; //add selected rows to sql data adapter sqlDataAdapter.SelectCommand.Parameters.Add("@RequestNo", SqlDbType.VarChar).Value = RequestNo; DataSet dataSetStud = new DataSet(); //create new data set sqlConnection.Open(); sqlDataAdapter.Fill(dataSetStud); objGV.DataSource = dataSetStud; objGV.DataBind(); using (StringWriter sw = new StringWriter()) { using (HtmlTextWriter hw = new HtmlTextWriter(sw)) { objGV.RenderControl(hw); StringReader sr = new StringReader(sw.ToString()); string mailSubject = "LABOUR REQUEST-" + dlCompany.SelectedItem.Text; string message = "Dear GDLC, <br><br>"; message += "Please find below labour request submitted by <strong>" + dlCompany.SelectedItem.Text + "</strong> from the Client Portal. <br><br> "; message += "Request No: " + RequestNo + "<br>"; message += "Terminal : " + txtTerminal.Text + "<br>"; message += "Request Date : " + dpReqdate.SelectedDate.Value.ToString("dd-MMM-yyyy") + "<br>"; message += "Vessel : " + txtVessel.Text + "<br>"; message += "DOA : " + dpDOA.SelectedDate.Value.ToString("dd-MMM-yyyy") + "<br>"; message += "Activity : " + dlActivity.SelectedText + "<br>"; message += "WorkShift : " + dlWorkShift.SelectedText + "<br>"; message += sw.ToString() + "<br><br>"; message += "<strong><a href='https://gdlcwave.com/' target='_blank'>Click here</a></strong> to log on to the portal for more details. <br /><br />"; message += "<strong>This is an auto generated email. Please do not reply.</strong>"; MailMessage myMessage = new MailMessage(); myMessage.From = (new MailAddress("*****@*****.**", "GDLC Client Portal")); myMessage.To.Add(new MailAddress(requestEmail)); myMessage.Bcc.Add(new MailAddress("*****@*****.**")); myMessage.Subject = mailSubject; myMessage.Body = message; myMessage.IsBodyHtml = true; SmtpClient mySmtpClient = new SmtpClient(); mySmtpClient.Send(myMessage); ScriptManager.RegisterStartupScript(this, this.GetType(), "mailsuccess", "toastr.success('Email Sent Successfully', 'Success');", true); mailSent = true; } } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, this.GetType(), "mailerror", "toastr.error('" + ex.Message.Replace("'", "").Replace("\r\n", "") + "', 'Error');", true); } return(mailSent); }
public void RowChangeCell(DataTable _dt) { try { DataTable Rdt = new DataTable(); decimal[] Tol; //为Rdt添加列 Rdt.Columns.Add(new DataColumn("PX", System.Type.GetType("System.String"))); Rdt.Columns.Add(new DataColumn("Tol", System.Type.GetType("System.Decimal"))); Rdt.Columns.Add(new DataColumn("DATETIME", System.Type.GetType("System.DateTime"))); Rdt.Columns.Add(new DataColumn("Note", System.Type.GetType("System.String"))); if (_dt.Rows.Count > 0) { string ControlInfo = _dt.Rows[0]["ControlInfo"].ToString(); string[] arr = ControlInfo.Split('|'); Tol = new decimal[arr.Length]; //总数列 //为每一个列赋值 for (int i = 0; i < Tol.Length; i++) { Tol[i] = 0; } for (int i = 0; i < arr.Length; i++) { string[] a = arr[i].Split(','); Rdt.Columns.Add(new DataColumn(a[1], System.Type.GetType("System.Decimal"))); } DataRow _dRow; int Rnum = 1; //为每行赋值 foreach (DataRow ds in _dt.Rows) { _dRow = Rdt.NewRow(); _dRow["PX"] = Rnum.ToString(); _dRow["DATETIME"] = ds["DATETIME"]; string[] _arr = ds["ControlInfo"].ToString().Split('|'); for (int i = 0; i < _arr.Length; i++) { string[] a = _arr[i].Split(','); _dRow[a[1]] = decimal.Parse(a[2]); decimal D = 0; if (!string.IsNullOrEmpty(_dRow["Tol"].ToString())) { D = decimal.Parse(_dRow["Tol"].ToString()); } _dRow["Tol"] = D + decimal.Parse(a[2]); Tol[i] = Tol[i] + decimal.Parse(a[2]); } _dRow["Note"] = ds["NOTES"]; Rdt.Rows.Add(_dRow); Rnum++; } //汇总值添加进表中,同时为gridview添加新列 _dRow = Rdt.NewRow(); _dRow["PX"] = "汇总"; decimal dec = 0; for (int i = 4; i < Rdt.Columns.Count; i++) { dec += Tol[i - 4]; _dRow[i] = Tol[i - 4]; BoundField f = new BoundField(); f.DataField = Rdt.Columns[i].ColumnName; f.HeaderText = Rdt.Columns[i].ColumnName; f.HeaderStyle.CssClass = "HeaderStyle11"; f.ItemStyle.CssClass = "ItemStyle11"; GridView1.Columns.Add(f); } _dRow["Tol"] = dec; Rdt.Rows.Add(_dRow); BoundField bf = new BoundField(); bf.DataField = "Tol"; bf.HeaderText = "总金额"; bf.HeaderStyle.CssClass = "HeaderStyle12"; bf.ItemStyle.CssClass = "ItemStyle12"; GridView1.Columns.Add(bf); //最后添加时间列 bf = new BoundField(); bf.DataField = "DATETIME"; bf.HeaderText = "时间"; bf.HeaderStyle.CssClass = "HeaderStyle12"; bf.ItemStyle.CssClass = "ItemStyle12"; bf.DataFormatString = "{0:yyyy-MM-dd}"; GridView1.Columns.Add(bf); //付全文 2013-4-11 备注 bf = new BoundField(); bf.DataField = "Note"; bf.HeaderText = "备注"; bf.HeaderStyle.CssClass = "HeaderStyle12"; bf.ItemStyle.CssClass = "ItemStyle12"; GridView1.Columns.Add(bf); } GridView1.Visible = true; GridView1.DataSource = Rdt; //指定GridView1的数据是dv GridView1.DataBind(); //将上面指定的信息绑定到GridView1上 } catch { } }
/// <summary> /// 绑定Gridview /// </summary> private void BindGridView() { using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { BoundField bfColumn; //添加选择列 foreach (var kvp in Titlelist) { bfColumn = new BoundField(); bfColumn.HeaderText = kvp.Split(':')[0]; bfColumn.DataField = kvp.Split(':')[1]; this.gv.Columns.Add(bfColumn); } this.gv.DataSource = from a in db.StorageInQualified join b in db.StorageIn on a.StorageInID equals b.StorageInID join c in db.MaterialInfo on a.MaterialID equals c.MaterialID join d in db.PileInfo on a.PileID equals d.PileID join e in db.SupplierInfo on a.SupplierID equals e.SupplierID where a.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"]) && a.BatchIndex == Request.QueryString["QCBatch"].ToString() select new { a.StorageInQualifiedID, b.StorageInCode, a.SpecificationModel, a.BatchIndex, c.MaterialName, c.MaterialCode, a.Quantity, a.QuantityGentaojian, a.QuantityMetre, a.QuantityTon, a.CurUnit, a.UnitPrice, a.Amount, a.NumberQualified, a.InspectionReportNum, a.InspectionTime, d.StorageInfo.StorageName, d.PileCode, a.financeCode, a.StorageTime, e.SupplierName, MaterialsManager = db.EmpInfo.SingleOrDefault(u => u.EmpID == a.MaterialsManager).EmpName, WarehouseWorker = db.EmpInfo.SingleOrDefault(u => u.EmpID == a.WarehouseWorker).EmpName, a.Remark }; this.gv.DataBind(); //btnSend = new Button(); //btnSend.Text ="发送审核"; //btnSend.Click +=new EventHandler(btnSend_Click); //btnCannel = new Button(); //btnCannel.Text = "取消"; //btnCannel.Click += new EventHandler(btnCannel_Click); Panel p1 = (Panel)GetControltByMaster("Panel1"); p1.Controls.Add(this.gv); //p1.Controls.Add(btnSend); //p1.Controls.Add(btnCannel); } }
private void BindGrid() { if (ViewState["Sorted"] != null) { IPatientTransfer PatientTransferMgr = (IPatientTransfer)ObjectFactory.CreateInstance("BusinessProcess.Clinical.BPatientTransfer, BusinessProcess.Clinical"); DataSet theDS = PatientTransferMgr.GetSatelliteLocation(PatientId.ToString(), TransferId, 0, Session["SystemId"].ToString()); txtLocationName.Text = theDS.Tables[0].Rows[0]["CurrentSatName"].ToString(); BindFunctions BindManager = new BindFunctions(); IQCareUtils theUtils = new IQCareUtils(); DataView theDV = new DataView(theDS.Tables[1]); DataTable theDT = new DataTable(); if (theDV.Table != null) { theDT = (DataTable)theUtils.CreateTableFromDataView(theDV); BindManager.BindCombo(ddSatellite, theDT, "Name", "ID"); theDV.Dispose(); theDT.Clear(); } GrdTransfer.DataSource = theDS.Tables[2]; if (ViewState["grdDataSource"] == null) { ViewState["grdDataSource"] = theDS.Tables[2]; } } ViewState["Sorted"] = ""; BoundField theCol0 = new BoundField(); theCol0.HeaderText = "ID"; theCol0.DataField = "ID"; theCol0.HeaderStyle.CssClass = "textstylehidden"; theCol0.ItemStyle.CssClass = "textstylehidden"; theCol0.ReadOnly = true; BoundField theCol1 = new BoundField(); theCol1.HeaderText = "From Location"; theCol1.DataField = "TransferfromSatellite"; theCol1.ItemStyle.CssClass = "textstyle"; theCol1.SortExpression = "TransferfromSatellite"; theCol1.ReadOnly = true; BoundField theCol2 = new BoundField(); theCol2.HeaderText = "To Location"; theCol2.DataField = "TransfertoSatellite"; theCol2.ItemStyle.CssClass = "textstyle"; theCol2.SortExpression = "TransfertoSatellite"; theCol2.ReadOnly = true; BoundField theCol3 = new BoundField(); theCol3.HeaderText = "Transferred Date"; theCol3.DataField = "TransferredDate"; theCol3.ItemStyle.CssClass = "textstyle"; theCol3.SortExpression = "TransferredDate"; theCol3.ReadOnly = true; ButtonField theBtn = new ButtonField(); theBtn.ButtonType = ButtonType.Link; theBtn.CommandName = "Select"; theBtn.HeaderStyle.CssClass = "textstylehidden"; theBtn.ItemStyle.CssClass = "textstylehidden"; GrdTransfer.Columns.Add(theCol0); GrdTransfer.Columns.Add(theCol1); GrdTransfer.Columns.Add(theCol2); GrdTransfer.Columns.Add(theCol3); GrdTransfer.Columns.Add(theBtn); GrdTransfer.DataBind(); }
void BindShippingCalculationTable(bool addInsertRow) { //clear the columns to prevent duplicates ShippingGrid.Columns.Clear(); //We're going to assemble the datasource that we need by putting it together manually here. using (DataTable gridData = new DataTable()) { //We'll need shipping method shipping charge amounts to work with in building the data source using (DataTable methodAmountsData = new DataTable()) { //Populate shipping methods data using (SqlConnection sqlConnection = new SqlConnection(DB.GetDBConn())) { sqlConnection.Open(); string getShippingMethodMapping = "exec aspdnsf_GetStoreShippingMethodMapping @StoreID = @StoreId, @IsRTShipping = 0, @OnlyMapped = @FilterByStore"; var getShippingMethodMappingParams = new[] { new SqlParameter("@StoreId", SelectedStoreId), new SqlParameter("@FilterByStore", FilterShipping), }; using (IDataReader rs = DB.GetRS(getShippingMethodMapping, getShippingMethodMappingParams, sqlConnection)) methodAmountsData.Load(rs); } if (methodAmountsData.Rows.Count == 0) { AlertMessage.PushAlertMessage(String.Format("You do not have any shipping methods setup for the selected store. Please <a href=\"{0}\">click here</a> to set them up.", AppLogic.AdminLinkUrl("shippingmethods.aspx")), AspDotNetStorefrontControls.AlertMessage.AlertType.Error); ShippingRatePanel.Visible = false; return; } using (DataTable shippingRangeData = new DataTable()) { using (SqlConnection sqlConnection = new SqlConnection(DB.GetDBConn())) { //populate the shipping range data var sqlShipping = @"SELECT DISTINCT sw.RowGuid, sw.LowValue, sw.HighValue FROM ShippingWeightByZone sw WITH (NOLOCK) INNER JOIN ShippingMethod sm WITH (NOLOCK) ON sm.ShippingMethodid = sw.ShippingMethodId AND (@FilterByStore = 0 or @StoreId = sw.StoreID) WHERE sw.ShippingZoneID = @ZoneId ORDER BY LowValue" ; var shippingRangeDataParams = new[] { new SqlParameter("@StoreId", SelectedStoreId), new SqlParameter("@FilterByStore", FilterShipping), new SqlParameter("@ZoneId", SelectedZoneId), }; sqlConnection.Open(); using (IDataReader rs = DB.GetRS(sqlShipping, shippingRangeDataParams, sqlConnection)) shippingRangeData.Load(rs); } //Add the data columns we'll need on our table and add grid columns to match gridData.Columns.Add(new DataColumn("RowGuid", typeof(string))); gridData.Columns.Add(new DataColumn("LowValue", typeof(string))); BoundField boundField = new BoundField(); boundField.DataField = "LowValue"; boundField.HeaderText = "Low"; boundField.ControlStyle.CssClass = "text-xs"; ShippingGrid.Columns.Add(boundField); gridData.Columns.Add(new DataColumn("HighValue", typeof(string))); boundField = new BoundField(); boundField.DataField = "HighValue"; boundField.HeaderText = "High"; boundField.ControlStyle.CssClass = "text-xs"; ShippingGrid.Columns.Add(boundField); //Add shipping method columns to our grid data foreach (DataRow methodAmountsRow in methodAmountsData.Rows) { var columnName = String.Format("MethodAmount_{0}", DB.RowField(methodAmountsRow, "ShippingMethodID")); gridData.Columns.Add(new DataColumn(columnName, typeof(string))); //add a column to the gridview to hold the data boundField = new BoundField(); boundField.DataField = columnName; boundField.HeaderText = DB.RowFieldByLocale(methodAmountsRow, "Name", LocaleSetting); boundField.ControlStyle.CssClass = "text-xs"; ShippingGrid.Columns.Add(boundField); } //now that our columns are setup add rows to our table foreach (DataRow rangeRow in shippingRangeData.Rows) { var newRow = gridData.NewRow(); //add the range data newRow["RowGuid"] = rangeRow["RowGuid"]; newRow["LowValue"] = rangeRow["LowValue"]; newRow["HighValue"] = rangeRow["HighValue"]; //add shipping method amounts to our grid data foreach (DataRow methodAmountsRow in methodAmountsData.Rows) { var shippingMethodId = DB.RowFieldInt(methodAmountsRow, "ShippingMethodID"); var shippingRangeGuid = DB.RowFieldGUID(rangeRow, "RowGUID"); var amount = Shipping.GetShipByWeightAndZoneCharge(SelectedZoneId, shippingMethodId, shippingRangeGuid); var localizedAmount = Localization.CurrencyStringForDBWithoutExchangeRate(amount); var colName = String.Format("MethodAmount_{0}", shippingMethodId); newRow[colName] = localizedAmount; } gridData.Rows.Add(newRow); } //if we're inserting, add an empty row to the end of the table if (addInsertRow) { var newRow = gridData.NewRow(); //add the range data newRow["RowGuid"] = 0; newRow["LowValue"] = 0; newRow["HighValue"] = 0; //add shipping method columns to our insert row foreach (DataRow methodAmountsRow in methodAmountsData.Rows) { var shippingMethodId = DB.RowFieldInt(methodAmountsRow, "ShippingMethodID"); var amount = 0; var localizedAmount = Localization.CurrencyStringForDBWithoutExchangeRate(amount); var colName = String.Format("MethodAmount_{0}", shippingMethodId); newRow[colName] = localizedAmount; } gridData.Rows.Add(newRow); //if we're inserting than we'll want to make the insert row editable ShippingGrid.EditIndex = gridData.Rows.Count - 1; } //add the delete button column ButtonField deleteField = new ButtonField(); deleteField.ButtonType = ButtonType.Link; deleteField.Text = "<i class=\"fa fa-times\"></i> Delete"; deleteField.CommandName = "Delete"; deleteField.ControlStyle.CssClass = "delete-link"; deleteField.ItemStyle.Width = 94; ShippingGrid.Columns.Add(deleteField); //add the edit button column CommandField commandField = new CommandField(); commandField.ButtonType = ButtonType.Link; commandField.ShowEditButton = true; commandField.ShowDeleteButton = false; commandField.ShowCancelButton = true; commandField.ControlStyle.CssClass = "edit-link"; commandField.EditText = "<i class=\"fa fa-share\"></i> Edit"; commandField.CancelText = "<i class=\"fa fa-reply\"></i> Cancel"; commandField.UpdateText = "<i class=\"fa fa-floppy-o\"></i> Save"; commandField.ItemStyle.Width = 84; ShippingGrid.Columns.Add(commandField); ShippingGrid.DataSource = gridData; ShippingGrid.DataBind(); } } } btnInsert.Visible = !addInsertRow; //Hide the 'add new row' button while editing/inserting to avoid confusion and lost data }
public override void SetStylesAndFormats(BoundField column, string format) { column.DataFormatString = format == string.Empty ? "{0:#,###,##0.0###}" : string.Format("{{0:{0}}}", format); column.HeaderStyle.HorizontalAlign = HorizontalAlign.Right; column.ItemStyle.HorizontalAlign = HorizontalAlign.Right; }
private void TestFarmerBinding() { string seasonYr = "2014"; DataTable dtSeasonDetails = cp.GetSeasonDetails(seasonYr); DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("Product Id", typeof(int))); dt.Columns.Add(new DataColumn("Product Name", typeof(string))); foreach (DataRow item in dtSeasonDetails.Rows) { DataColumn dc = new DataColumn(Convert.ToString(item["SeasonName"]), typeof(string)); dt.Columns.Add(dc); dc = new DataColumn(Convert.ToString(item["SeasonId"]), typeof(string)); dt.Columns.Add(dc); } DataTable dtProds = prod.GetProductDetailsNew(); foreach (DataRow item in dtProds.Rows) { DataRow newRow = dt.NewRow(); newRow[0] = Convert.ToInt32(item["ProductId"]); newRow[1] = Convert.ToString(item["ProductName"]); for (int i = 2; i < dt.Columns.Count; i++) { if (i % 2 == 0) { newRow[i] = bool.FalseString; } else { newRow[i] = Convert.ToString(dt.Columns[i].ColumnName); } } dt.Rows.Add(newRow); } //dt = dt; gvfarmdetails.Columns.Clear(); for (int i = 0; i < dt.Columns.Count; i++) { if (i == 1) { BoundField boundField = new BoundField(); boundField.DataField = "Product Name"; boundField.HeaderText = ""; gvfarmdetails.Columns.Add(boundField); } else if (i == 0) { BoundField boundField = new BoundField(); boundField.DataField = "Product Id"; boundField.HeaderText = ""; //boundField.Visible = false; gvfarmdetails.Columns.Add(boundField); } else if (i % 2 == 0 && i >= 2) { TemplateField templateField = new TemplateField(); templateField.HeaderText = dt.Columns[i].ColumnName; gvfarmdetails.Columns.Add(templateField); } else if (i % 2 == 1 && i >= 2) { BoundField boundField = new BoundField(); boundField.DataField = dt.Columns[i].ColumnName; boundField.HeaderText = dt.Columns[i].ColumnName; //boundField.Visible = false; gvfarmdetails.Columns.Add(boundField); } } gvfarmdetails.DataSource = dt; gvfarmdetails.DataBind(); }
protected GridView bindDataByCountry(GridView gv, DataSet ds, string header) { if (ds != null) { gv.Visible = true; gv.Width = Unit.Pixel(650); gv.AutoGenerateColumns = false; gv.AllowPaging = false; for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { BoundField bf = new BoundField(); bf.DataField = ds.Tables[0].Columns[i].ColumnName.ToString(); bf.HeaderText = ds.Tables[0].Columns[i].Caption.ToString(); bf.ItemStyle.HorizontalAlign = HorizontalAlign.Right; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Right; if (i == 0) { bf.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Left; if (header != "") bf.ItemStyle.Width = 250; } bf.ReadOnly = true; gv.Columns.Add(bf); } if (header != "") { gv.Caption = "<br />" + header; gv.CaptionAlign = TableCaptionAlign.Left; gv.AllowSorting = true; gv.DataSource = ds.Tables[0]; DataRow drSum = ds.Tables[0].NewRow(); float[] Sum = new float[50]; for (int j = 1; j < ds.Tables[0].Columns.Count; j++) { Sum[j] = 0; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Sum[j] += float.Parse(ds.Tables[0].Rows[i][j].ToString()); } } for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { if (i == 0) { if (header.Substring(0, 3) != "Tot") drSum[0] = "Total(" + header + ")"; else drSum[0] = header; } else { drSum[i] = Sum[i].ToString(); } } ds.Tables[0].Rows.InsertAt(drSum, ds.Tables[0].Rows.Count); gv.DataBind(); return gv; } else { gv.Caption = "<br />" + "GROUP REGION"; gv.CaptionAlign = TableCaptionAlign.Left; gv.DataSource = ds.Tables[0]; gv.DataBind(); return gv; } } else { gv.Visible = false; return gv; } }
/// <summary> /// Bind the data. /// </summary> public void Bind() { if (!string.IsNullOrEmpty(ObjectType)) { pnlGrid.Visible = true; // Initialize strings btnAllTasks.Text = GetString("ImportExport.All"); btnNoneTasks.Text = GetString("export.none"); lblTasks.Text = GetString("Export.Tasks"); // Get object info GeneralizedInfo info = ModuleManager.GetReadOnlyObject(ObjectType); if (info != null) { gvTasks.RowDataBound += gvTasks_RowDataBound; plcGrid.Visible = true; codeNameColumnName = info.CodeNameColumn; displayNameColumnName = info.DisplayNameColumn; // Task fields TemplateField taskCheckBoxField = (TemplateField)gvTasks.Columns[0]; taskCheckBoxField.HeaderText = GetString("General.Export"); TemplateField titleField = (TemplateField)gvTasks.Columns[1]; titleField.HeaderText = GetString("Export.TaskTitle"); BoundField typeField = (BoundField)gvTasks.Columns[2]; typeField.HeaderText = GetString("general.type"); BoundField timeField = (BoundField)gvTasks.Columns[3]; timeField.HeaderText = GetString("Export.TaskTime"); // Load tasks int siteId = (SiteObject ? Settings.SiteId : 0); DataSet ds = ExportTaskInfoProvider.SelectTaskList(siteId, ObjectType, null, "TaskTime DESC", 0, null, CurrentOffset, CurrentPageSize, ref pagerForceNumberOfResults); // Set correct ID for direct page contol pagerElem.DirectPageControlID = ((float)pagerForceNumberOfResults / pagerElem.CurrentPageSize > 20.0f) ? "txtPage" : "drpPage"; // Call page binding event if (OnPageBinding != null) { OnPageBinding(this, null); } if (!DataHelper.DataSourceIsEmpty(ds) && (ValidationHelper.GetBoolean(Settings.GetSettings(ImportExportHelper.SETTINGS_TASKS), true))) { plcTasks.Visible = true; gvTasks.DataSource = ds; gvTasks.DataBind(); } else { plcTasks.Visible = false; } } else { plcGrid.Visible = false; } } else { pnlGrid.Visible = false; } }
private string GenerateExportData(string dataFormat) { border = (dataFormat == "Print" ? "0" : "1"); DataSet _dsPriceData = Session["PriceAnalysisData"] as DataSet; dtExcelData = new DataTable(); string styleSheet = "<style>.text { mso-number-format:\\@; } </style>"; string headerContent = string.Empty; string footerContent = string.Empty; string excelContent = string.Empty; dtExcelData = _dsPriceData.Tables[1]; headerContent = "<table border='" + border + "' width='100%'>"; headerContent += "<tr><th colspan='14' style='color:blue' align=left><center>Price Analysis Report</center></th></tr>"; headerContent += "<tr>" + "<td colspan='3'><b>"+ lblBeginDate.Text + "</b></td>" + "<td colspan='3'><b>" + lblEndDate.Text + "</b></td>" + "<td colspan='3'><b>" + lblBranch.Text + "</b></td>" + "<td colspan='3'><b>" + lblCustomerNumber.Text + "</b></td>" + "<td colspan='2'></td>" + "</tr>"; headerContent += "<tr>" + "<td colspan='3'><b>" + lblHistExtSell.Text + "</b></td>" + "<td colspan='3'><b>" + lblHistExtGM.Text + "</b></td>" + "<td colspan='3'><b>" + lblHistGMPct.Text + "</b></td>" + "<td colspan='3'><b>" + lblSAvgSuggGMPct.Text + "</b></td>" + "<td colspan='2'><b>" + (hidShowAvgCost.Value == "TRUE" ? lblSuggGMPct.Text : "") + "</b></td>" + "</tr>"; headerContent += "<tr>" + "<td colspan='3'><b>" + lblHistExtLbs.Text + "</b></td>" + "<td colspan='3'><b>" + lblHistSellPerLb.Text + "</b></td>" + "<td colspan='3'><b>" + lblHistGMPerLb.Text + "</b></td>" + "<td colspan='3'><b>Run By: " + Session["UserName"].ToString() + " Run Date: " + DateTime.Now.ToShortDateString() + "</b></td>" + "<td colspan='2'></td>" + "</tr>"; headerContent += "<tr><th colspan='14' style='color:blue' align=left></th></tr>"; if (dtExcelData.Rows.Count > 0) { dv.AutoGenerateColumns = false; dv.ShowHeader = true; dv.ShowFooter = true; BoundField bfExcel = new BoundField(); bfExcel.HeaderText = "Item No"; bfExcel.DataField = "ItemNo"; bfExcel.ItemStyle.HorizontalAlign = HorizontalAlign.Left; dv.Columns.Add(bfExcel); bfExcel = new BoundField(); bfExcel.HeaderText = "Sugg Price Alt"; bfExcel.DataField = "SuggestedPriceAlt"; bfExcel.ItemStyle.HorizontalAlign = HorizontalAlign.Right; dv.Columns.Add(bfExcel); bfExcel = new BoundField(); bfExcel.HeaderText = "Hist Sell Price Alt"; bfExcel.DataField = "SellUM"; bfExcel.ItemStyle.HorizontalAlign = HorizontalAlign.Left; dv.Columns.Add(bfExcel); bfExcel = new BoundField(); bfExcel.HeaderText = "Sugg Price Method"; bfExcel.DataField = "SuggestedPriceMethod"; bfExcel.ItemStyle.HorizontalAlign = HorizontalAlign.Left; dv.Columns.Add(bfExcel); if (hidShowAvgCost.Value == "TRUE") { bfExcel = new BoundField(); bfExcel.HeaderText = "Avg Sugg GM Pct"; bfExcel.DataField = "AVGSuggGMPct"; bfExcel.DataFormatString = "{0:0.0%}"; bfExcel.ItemStyle.HorizontalAlign = HorizontalAlign.Right; dv.Columns.Add(bfExcel); } bfExcel = new BoundField(); bfExcel.HeaderText = "SAvg Sugg GM Pct"; bfExcel.DataField = "SMTHAVGSuggGMPct"; bfExcel.DataFormatString = "{0:0.0%}"; bfExcel.ItemStyle.HorizontalAlign = HorizontalAlign.Right; dv.Columns.Add(bfExcel); bfExcel = new BoundField(); bfExcel.HeaderText = "GM Pct"; bfExcel.DataField = "GMPct"; bfExcel.DataFormatString = "{0:0.0%}"; bfExcel.ItemStyle.HorizontalAlign = HorizontalAlign.Right; dv.Columns.Add(bfExcel); bfExcel = new BoundField(); bfExcel.HeaderText = "Qty Shipped"; bfExcel.DataField = "QtyShipped"; bfExcel.DataFormatString = "{0:#,##}"; bfExcel.ItemStyle.HorizontalAlign = HorizontalAlign.Right; dv.Columns.Add(bfExcel); bfExcel = new BoundField(); bfExcel.HeaderText = "Ext. Lines"; bfExcel.DataField = "ExtLines"; bfExcel.DataFormatString = "{0:#,##}"; bfExcel.ItemStyle.HorizontalAlign = HorizontalAlign.Right; dv.Columns.Add(bfExcel); bfExcel = new BoundField(); bfExcel.HeaderText = "Ext. Sell"; bfExcel.DataField = "ExtSell"; bfExcel.DataFormatString = "{0:#,##0.00}"; bfExcel.ItemStyle.HorizontalAlign = HorizontalAlign.Right; dv.Columns.Add(bfExcel); bfExcel = new BoundField(); bfExcel.HeaderText = "Ext. GM"; bfExcel.DataField = "ExtGM"; bfExcel.DataFormatString = "{0:#,##0.00}"; bfExcel.ItemStyle.HorizontalAlign = HorizontalAlign.Right; dv.Columns.Add(bfExcel); bfExcel = new BoundField(); bfExcel.HeaderText = "Ext. Lbs"; bfExcel.DataField = "ExtLbs"; bfExcel.DataFormatString = "{0:#,##0.00}"; bfExcel.ItemStyle.HorizontalAlign = HorizontalAlign.Right; dv.Columns.Add(bfExcel); bfExcel = new BoundField(); bfExcel.HeaderText = "Sell Per Lb"; bfExcel.DataField = "SellPerLb"; bfExcel.DataFormatString = "{0:#,##0.000}"; bfExcel.ItemStyle.HorizontalAlign = HorizontalAlign.Right; dv.Columns.Add(bfExcel); bfExcel = new BoundField(); bfExcel.HeaderText = "GM Per Lb"; bfExcel.DataField = "GMPerLb"; bfExcel.DataFormatString = "{0:#,##0.000}"; bfExcel.ItemStyle.HorizontalAlign = HorizontalAlign.Right; dv.Columns.Add(bfExcel); dv.DataSource = dtExcelData; dv.DataBind(); System.Text.StringBuilder sb = new System.Text.StringBuilder(); System.IO.StringWriter sw = new System.IO.StringWriter(sb); HtmlTextWriter htw = new HtmlTextWriter(sw); dv.RenderControl(htw); excelContent = sb.ToString(); } else { excelContent = "<tr ><th width='100%' align ='center' colspan='21' > No records found</th></tr> </table>"; } return styleSheet + headerContent + excelContent; }
protected GridView showBookingsByProduct(DataSet ds, GridView gv, string header) { if (ds != null) { gv.AutoGenerateColumns = false; gv.Width = Unit.Pixel(300); gv.Columns.Clear(); //Calculate the VAR column and Total row of next year. try { ds.Tables[0].Columns.Add("VAR"); if (ds.Tables[0].Rows[0][0] != DBNull.Value) { foreach (DataRow dr in ds.Tables[0].Rows) { float tmp = 0; if (float.Parse(dr[2].ToString()) != 0) { tmp = (float.Parse(dr[1].ToString()) - float.Parse(dr[2].ToString())) * 100 / float.Parse(dr[2].ToString()); dr["VAR"] = Convert.ToInt32(tmp).ToString() + "%"; } } } } catch { log.WriteLog(LogUtility.LogErrorLevel.LOG_ERROR, "Format string to float Error."); Response.Redirect("~/Admin/AdminError.aspx"); } for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { BoundField bf = new BoundField(); bf.DataField = ds.Tables[0].Columns[i].ColumnName.ToString(); bf.HeaderText = ds.Tables[0].Columns[i].Caption.ToString(); bf.ItemStyle.HorizontalAlign = HorizontalAlign.Right; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Right; if (i == 0) { bf.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Left; } bf.ReadOnly = true; gv.Columns.Add(bf); } gv.Caption = header; gv.CaptionAlign = TableCaptionAlign.Top; gv.DataSource = ds; gv.DataBind(); } return gv; }
/// <summary> /// 绑定Gridview /// </summary> private void BindGridView() { using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { BoundField bfColumn; foreach (var kvp in Titlelist) { bfColumn = new BoundField(); bfColumn.HeaderText = kvp.Split(':')[0]; bfColumn.DataField = kvp.Split(':')[1]; this.gv.Columns.Add(bfColumn); } //添加选择列 TemplateField tfieldCheckbox = new TemplateField(); tfieldCheckbox.ItemTemplate = new CheckBoxTemplate("请选择", DataControlRowType.DataRow, "StorageInID"); tfieldCheckbox.HeaderTemplate = new CheckBoxTemplate("请选择", DataControlRowType.Header); this.gv.Columns.Insert(0, tfieldCheckbox); SPMenuField colMenu = new SPMenuField(); colMenu.HeaderText = "交货通知单编号"; colMenu.TextFields = "StorageInCode"; colMenu.MenuTemplateId = "actionMenu"; colMenu.NavigateUrlFields = "StorageInID"; //定义方式:"列名1,列名2..." colMenu.NavigateUrlFormat = "StorageDetailedManage.aspx?StorageInID={0}"; colMenu.TokenNameAndValueFields = "curStorageID=StorageInID"; //定义方式:"别名1=列名1,别名2=列名2...." MenuTemplate menuItemCollection = new MenuTemplate(); menuItemCollection.ID = "actionMenu"; MenuItemTemplate createMenuItem = new MenuItemTemplate("送往物资组", "/_layouts/images/newitem.gif"); createMenuItem.ClientOnClickNavigateUrl = "QualityControlMessage.aspx?StorageInID=%curStorageID%&&state=物资组员&&storageInType=正常入库"; //editMenuItem.ClientOnClickScript = "if(!window.confirm('确认删除所选项?')) return false;window.location.href='StorageEdit.aspx?StorageID=%curStorageID%'";//%curStorageID%代表别名curStorageID,而StorageID代表数据库的表中的列名 //editMenuItem.ClientOnClickScript = "window.location.href='StorageEdit.aspx?StorageID=%curStorageID%&curTime=" + DateTime.Now.ToString() + "'"; menuItemCollection.Controls.Add(createMenuItem); this.Controls.Add(menuItemCollection); this.gv.Columns.Insert(1, colMenu); //this.gv.Columns.Add(hlTask); HyperLinkField hlTask = new HyperLinkField(); hlTask.HeaderText = "任务详情"; this.gv.Columns.Insert(5, hlTask); //hlTask.DataNavigateUrlFields={} // hlTask.DataNavigateUrlFormatString = "javaScript:onClick=window.showModalDialog('../PublicPage/ErrorInfo.aspx?StorageInID={0}')"; this.gv.DataSource = from a in db.StorageInMain where a.Creator == UserLoginId select new { a.StorageInID, a.StorageInCode, a.ReceivingTypeInfo.ReceivingTypeName, a.Remark, a.CreateTime }; this.gv.RowDataBound += new GridViewRowEventHandler(gv_RowDataBound); this.gv.DataBind(); this.gv.Columns[6].Visible = false; Panel p1 = (Panel)GetControltByMaster("Panel1"); p1.Controls.Add(this.gv); } }
protected void bindDataNextVSThisByDate(GridView gv) { DataSet ds = getBookingsDataNextYearVSThis(getProductBySegment(getSegmentID()), getSegmentID(), getSalesOrgID()); if (ds != null) { gv.Visible = true; gv.Width = Unit.Pixel(700); gv.AutoGenerateColumns = false; gv.AllowPaging = false; ; //Calculate the total column of next year. ds.Tables[0].Columns.Add("Total"); try { if (ds.Tables[0].Rows[0][0] != DBNull.Value) { foreach (DataRow dr in ds.Tables[0].Rows) { float tmp = 0; for (int count2 = 3; count2 < ds.Tables[0].Columns.Count - 1; count2 += 2) { tmp += float.Parse(dr[count2].ToString()); } dr["Total"] = tmp.ToString(); } } } catch { log.WriteLog(LogUtility.LogErrorLevel.LOG_ERROR, "Format string to float Error."); Response.Redirect("~/Admin/AdminError.aspx"); } for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { BoundField bf = new BoundField(); bf.DataField = ds.Tables[0].Columns[i].ColumnName.ToString(); bf.HeaderText = ds.Tables[0].Columns[i].Caption.ToString(); bf.ItemStyle.HorizontalAlign = HorizontalAlign.Right; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Right; if (i == 0) { bf.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Left; } bf.ReadOnly = true; gv.Columns.Add(bf); } gv.Caption = "Total" + nextyear.Substring(2, 2) + "(" + year.Substring(2, 2) + ")"; gv.CaptionAlign = TableCaptionAlign.Top; gv.AllowSorting = true; gv.DataSource = ds.Tables[0]; gv.DataBind(); } else gv.Visible = false; }
/// <summary> /// 绑定Gridview /// </summary> private void BindGridView() { this.spgviewRelation.Columns.Clear(); if (this.rbtnBusiness.Checked) { Tlist[0] = "项目名称:ProjectName"; Tlist[1] = "项目编码:ProjectCode"; Tlist[2] = "井性:ProjectProperty"; } else { Tlist[0] = "施工方名称:BusinessUnitName"; Tlist[1] = "施工方编码:BusinessUnitCode"; Tlist[2] = "施工方所属单位:BusinessUnitTypeName"; } using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { BoundField bfColumn; //添加选择列 TemplateField tfieldCheckbox = new TemplateField(); if (this.rbtnBusiness.Checked) { tfieldCheckbox.ItemTemplate = new CheckBoxTemplate("请选择", DataControlRowType.DataRow, "ProjectID"); } else { tfieldCheckbox.ItemTemplate = new CheckBoxTemplate("请选择", DataControlRowType.DataRow, "BusinessUnitID"); } tfieldCheckbox.HeaderTemplate = new CheckBoxTemplate("请选择", DataControlRowType.Header); this.spgviewRelation.Columns.Add(tfieldCheckbox); foreach (var kvp in Tlist) { bfColumn = new BoundField(); bfColumn.HeaderText = kvp.Split(':')[0]; bfColumn.DataField = kvp.Split(':')[1]; this.spgviewRelation.Columns.Add(bfColumn); } if (this.rbtnBusiness.Checked) { this.spgviewRelation.DataSource = from a in db.RelationProjectBusiness where a.BusinessUnitID == int.Parse(this.lboxLeft.SelectedValue) select new { a.ProjectID, a.ProjectInfo.ProjectCode, a.ProjectInfo.ProjectName, a.ProjectInfo.ProjectProperty }; } else { this.spgviewRelation.DataSource = from a in db.RelationProjectBusiness where a.ProjectID == int.Parse(this.lboxLeft.SelectedValue) select new { a.BusinessUnitID, a.BusinessUnitInfo.BusinessUnitName, a.BusinessUnitInfo.BusinessUnitCode, a.BusinessUnitInfo.BusinessUnitType.BusinessUnitTypeName }; } this.spgviewRelation.DataBind(); //SPMenuField spm = new SPMenuField(); } }
protected void bindDataTotalNextVSThisByDate(GridView gv) { DataSet ds = getBookingDataTotalNextYearVSThis(getProductBySegment(getSegmentID()), getSegmentID(), getSalesOrgID()); if (ds != null) { gv.Visible = true; gv.Width = Unit.Pixel(700); gv.AutoGenerateColumns = false; gv.AllowPaging = false; //Calculate the total column of next year. ds.Tables[0].Columns.Add("Total"); try { if (ds.Tables[0].Rows[0][0] != DBNull.Value) { foreach (DataRow dr in ds.Tables[0].Rows) { float tmp = 0; for (int count2 = 1; count2 < ds.Tables[0].Columns.Count - 1; count2++) { tmp += float.Parse(dr[count2].ToString()); } dr["Total"] = tmp.ToString(); } } } catch { log.WriteLog(LogUtility.LogErrorLevel.LOG_ERROR, "Format string to float Error."); Response.Redirect("~/Admin/AdminError.aspx"); } for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { BoundField bf = new BoundField(); bf.DataField = ds.Tables[0].Columns[i].ColumnName.ToString(); bf.HeaderText = ds.Tables[0].Columns[i].Caption.ToString(); bf.ItemStyle.HorizontalAlign = HorizontalAlign.Right; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Right; if (i == 0) { bf.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Left; } bf.ReadOnly = true; gv.Columns.Add(bf); } gv.AllowSorting = true; gv.DataSource = ds.Tables[0]; DataRow drSum = ds.Tables[0].NewRow(); DataRow[] rows = ds.Tables[0].Select(); float[] Sum = new float[20]; for (int j = 1; j < ds.Tables[0].Columns.Count; j++) { Sum[j] = 0; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Sum[j] += float.Parse(ds.Tables[0].Rows[i][j].ToString()); } } for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { if (i == 0) { drSum[0] = "TTL/" + getAbbrBySalesOrg(getSalesOrgID()); } else { drSum[i] = Sum[i].ToString(); } } ds.Tables[0].Rows.InsertAt(drSum, 0); gv.DataBind(); } else gv.Visible = false; }
private void BindGrid() { BoundField theCol0 = new BoundField(); theCol0.HeaderText = "Patientid"; theCol0.DataField = "Ptn_Pk"; theCol0.ItemStyle.Width = Unit.Percentage(3); //theCol0.ItemStyle.CssClass = "textstyle"; theCol0.ReadOnly = true; BoundField theCol1 = new BoundField(); theCol1.HeaderText = "Last Name"; theCol1.DataField = "lastname"; theCol1.SortExpression = "lastname"; //theCol1.ItemStyle.CssClass = "textstyle"; theCol1.ItemStyle.Width = Unit.Percentage(5); theCol1.ReadOnly = true; BoundField theCol2 = new BoundField(); theCol2.HeaderText = "Middle Name"; theCol2.DataField = "middlename"; theCol2.SortExpression = "middlename"; //theCol2.ItemStyle.CssClass = "textstyle"; theCol2.ItemStyle.Width = Unit.Percentage(5); theCol2.ReadOnly = true; BoundField theCol3 = new BoundField(); theCol3.HeaderText = "First Name"; theCol3.DataField = "firstname"; //theCol3.ItemStyle.CssClass = "textstyle"; theCol3.SortExpression = "firstname"; theCol3.ItemStyle.Font.Underline = true; theCol3.ItemStyle.Width = Unit.Percentage(5); theCol3.ReadOnly = true; BoundField theCol4 = new BoundField(); theCol4.HeaderText = "IQ Number"; //theCol4.ItemStyle.CssClass = "textstyle"; theCol4.DataField = "PatientID"; theCol4.SortExpression = "PatientID"; theCol4.ItemStyle.Width = Unit.Percentage(7); theCol4.ItemStyle.HorizontalAlign = HorizontalAlign.Left; theCol4.ItemStyle.VerticalAlign = VerticalAlign.Top; theCol4.ReadOnly = true; BoundField theCol5 = new BoundField(); theCol5.HeaderText = "Services"; //theCol5.ItemStyle.CssClass = "textstyle"; theCol5.DataField = "PatientIDType"; theCol5.SortExpression = "PatientIDType"; theCol5.ItemStyle.Width = Unit.Percentage(30); theCol5.ItemStyle.HorizontalAlign = HorizontalAlign.Left; theCol5.ItemStyle.VerticalAlign = VerticalAlign.Top; theCol5.ReadOnly = true; BoundField theCol6 = new BoundField(); if (((DataSet)ViewState["FacilityDS"]).Tables[0].Rows.Count > 0) { theCol6.HeaderText = ((DataSet)ViewState["FacilityDS"]).Tables[0].Rows[1][0].ToString(); } //theCol4.HeaderText = "Existing Hosp/Clinic"; //theCol6.ItemStyle.CssClass = "textstyle"; theCol6.DataField = "PatientClinicID"; theCol6.SortExpression = "PatientClinicID"; theCol5.ItemStyle.Width = Unit.Percentage(7); theCol6.ReadOnly = true; BoundField theCol7 = new BoundField(); theCol7.HeaderText = "Sex"; //theCol7.ItemStyle.CssClass = "textstyle"; theCol7.DataField = "Name"; theCol7.SortExpression = "Name"; theCol7.ItemStyle.Width = Unit.Percentage(3); theCol7.ReadOnly = true; BoundField theCol8 = new BoundField(); theCol8.HeaderText = "DOB"; theCol8.DataField = "dob"; //theCol8.ItemStyle.CssClass = "textstyle"; theCol8.SortExpression = "dob"; theCol8.ItemStyle.Width = Unit.Percentage(5); theCol8.ReadOnly = true; ////BoundField theCol8 = new BoundField(); ////theCol8.HeaderText = "Village"; ////theCol8.DataField = "VillageName"; ////theCol8.ItemStyle.CssClass = "textstyle"; ////theCol8.SortExpression = "VillageName"; ////theCol8.ReadOnly = true; BoundField theCol9 = new BoundField(); theCol9.HeaderText = "Status"; theCol9.DataField = "status"; //theCol9.ItemStyle.CssClass = "textstyle"; theCol9.SortExpression = "status"; theCol9.ItemStyle.Width = Unit.Percentage(3); theCol9.ReadOnly = true; BoundField theCol10 = new BoundField(); theCol10.HeaderText = "Patient Location"; //theCol10.ItemStyle.CssClass = "textstyle"; theCol10.DataField = "FacilityName"; theCol10.SortExpression = "FacilityName"; theCol10.ItemStyle.Width = Unit.Percentage(3); theCol10.ReadOnly = true; BoundField theCol11 = new BoundField(); theCol11.HeaderText = "LocationId"; theCol11.DataField = "locationID"; theCol10.ItemStyle.Width = Unit.Percentage(5); //theCol11.ItemStyle.CssClass = "textstyle"; theCol11.ReadOnly = true; //ButtonField theBtn = new ButtonField(); //theBtn.ButtonType = ButtonType.Link; //theBtn.CommandName = "Select"; //theBtn.HeaderStyle.CssClass = "textstylehidden"; //theBtn.ItemStyle.CssClass = "textstylehidden"; //grdSearchResult.Columns.Add(theCol); grdSearchResult.Columns.Add(theCol0); grdSearchResult.Columns.Add(theCol1); grdSearchResult.Columns.Add(theCol2); grdSearchResult.Columns.Add(theCol3); grdSearchResult.Columns.Add(theCol4); grdSearchResult.Columns.Add(theCol5); grdSearchResult.Columns.Add(theCol6); grdSearchResult.Columns.Add(theCol7); grdSearchResult.Columns.Add(theCol8); grdSearchResult.Columns.Add(theCol9); grdSearchResult.Columns.Add(theCol10); grdSearchResult.Columns.Add(theCol11); //grdSearchResult.Columns.Add(theBtn); grdSearchResult.DataBind(); grdSearchResult.Columns[0].Visible = false; grdSearchResult.Columns[6].Visible = false; grdSearchResult.Columns[11].Visible = false; if (Convert.ToString(Session["SystemId"]) == "1") { grdSearchResult.Columns[2].Visible = false; } }
protected void bindDataSource() { bool flag = true; lbtn_add.Visible = false; DataSet dsPro = getProductInfoBySegmentID(ddlist_segment.SelectedItem.Value); if (dsPro.Tables[0].Rows.Count > 0) { string str_operationID = getOperationInfoByGeneralMarketingID(getGeneralMarketingID()); if (str_operationID != "") { DataSet ds = getBacklog(dsPro, str_operationID, ddlist_saleorg.SelectedItem.Value.Trim(), ddlist_segment.SelectedItem.Value.Trim()); if (ds.Tables[0].Rows.Count == 0) { sql.getNullDataSet(ds); flag = false; } if (ds.Tables[0].Rows.Count < 2) { lbtn_add.Visible = true; } gv_actualBaclog.Width = Unit.Pixel(800); gv_actualBaclog.AutoGenerateColumns = false; gv_actualBaclog.AllowPaging = true; gv_actualBaclog.Visible = true; for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { BoundField bf = new BoundField(); bf.DataField = ds.Tables[0].Columns[i].ColumnName.ToString(); bf.HeaderText = ds.Tables[0].Columns[i].Caption.ToString(); bf.ItemStyle.HorizontalAlign = HorizontalAlign.Right; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Right; bf.ReadOnly = false; if (i == 0) { bf.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Left; bf.ReadOnly = true; } gv_actualBaclog.Columns.Add(bf); } //by yyan itemW42 20110621 del start //if (flag) //{ // CommandField cf_Update = new CommandField(); // cf_Update.ButtonType = ButtonType.Image; // cf_Update.ShowEditButton = true; // cf_Update.ShowCancelButton = true; // cf_Update.EditImageUrl = "~/images/edit.jpg"; // cf_Update.EditText = "Edit"; // cf_Update.CausesValidation = false; // cf_Update.CancelImageUrl = "~/images/cancel.jpg"; // cf_Update.CancelText = "Cancel"; // cf_Update.UpdateImageUrl = "~/images/ok.jpg"; // cf_Update.UpdateText = "Update"; // gv_actualBaclog.Columns.Add(cf_Update); //} //by yyan itemW42 20110621 del end gv_actualBaclog.AllowSorting = true; gv_actualBaclog.DataSource = ds.Tables[0]; gv_actualBaclog.DataBind(); } else { label_note.Visible = true; label_note.ForeColor = System.Drawing.Color.Red; label_note.Text = "The general marketing manager has not managed any operations."; } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["No.Empleado"] == null) { Response.Redirect("login.aspx"); } //if (Session["permisos"].ToString() != "Admin") //{ // liUsuario.Visible = false; //} if (Request["seleccionarVisita"] != null) { Response.Redirect("Visita.aspx?idVisita=" + Request["seleccionarVisita"]); } if (!IsPostBack) { RequisDrop.SelectedValue = "todas"; } if (Session["Permisos"].ToString() == "Requi") { RequisDrop.Visible = false; } /*En los siguientes GridView se muestran las visitas que sean registrado filtrandolas entre pendientes y no pendientes * colocando todas las requisiciones si es aprobador */ //GridView1(PENDIENTES) string con = ConfigurationManager.ConnectionStrings["IDDVisitas"].ConnectionString; SqlConnection conexion = new SqlConnection(con); conexion.Open(); string que = @"SET LANGUAGE Spanish SELECT IdVisita, ([nombreEmple] + ' ' + [apellido1] + ' ' + [apellido2] + ' (' + [No.Empleado_Requi] + ')') AS [Requisitor], [Nombre_Visitante] AS [Visitante], [Nombre_compania] AS [Compañia], ([Ciudad]+', ' +[Estado])AS [Ciudad-Estado], [Proposito_Visita] AS [Proposito de la visita], CASE WHEN [Aprobado] = 1 THEN 'Aprobado' ELSE 'Rechazado' END AS [Aprobado], DATENAME(DD,Fecha_requi) + ' de ' + DATENAME(mm, Fecha_requi) + ' de ' + DATENAME(YYYY,Fecha_requi) AS [Fecha] FROM [Visitantes] WHERE [Abierto] = 0 "; /*Filtro del DropDownList*/ if (RequisDrop.SelectedValue == "mias") { que += " AND [No.Empleado_Requi] = '" + Session["No.Empleado"].ToString() + "'"; } if (RequisDrop.SelectedValue == "ajenas") { que += " AND [No.Empleado_Requi] != '" + Session["No.Empleado"].ToString() + "'"; } /*Cuando se es requisitor se ejecuta esta condicion para que solamente muuestre las requisiciones que el a realizado esto por medio del numero de empleado*/ if (Session["permisos"].ToString() == "Requi") { que += " AND [No.Empleado_Requi] = '" + Session["No.Empleado"].ToString() + "'"; } SqlCommand conx = new SqlCommand(que, conexion); SqlDataReader slqDR = conx.ExecuteReader(); GridView1.DataSource = slqDR; if (!IsPostBack) { BoundField columnaSeleccionar = new BoundField(); columnaSeleccionar.HeaderText = ""; GridView1.Columns.Add(columnaSeleccionar); } GridView1.DataBind(); slqDR.Close(); slqDR = conx.ExecuteReader(); var contador0 = 0; while (slqDR.Read()) { var celdaSeleccionar = GridView1.Rows[contador0].Cells[0]; System.Web.UI.HtmlControls.HtmlButton botonSeleccionar = new System.Web.UI.HtmlControls.HtmlButton(); botonSeleccionar.Attributes.Add("value", slqDR["IdVisita"].ToString()); botonSeleccionar.Attributes.Add("name", "seleccionarVisita"); botonSeleccionar.Attributes.Add("class", "fa fa-eye buttonSpecial"); //botonSeleccionar.InnerHtml = "Ver"; celdaSeleccionar.Controls.Add(botonSeleccionar); contador0++; } conexion.Close(); //GridView2 (NO PENDIENTES) string conn = ConfigurationManager.ConnectionStrings["IDDVisitas"].ConnectionString; SqlConnection conexion1 = new SqlConnection(con); conexion.Open(); string que2 = @" SET LANGUAGE Spanish SELECT IdVisita, ([nombreEmple] + ' ' + [apellido1] + ' ' + [apellido2] + ' (' + [No.Empleado_Requi] + ')') AS [Requisitor], [Nombre_Visitante] AS [Visitante], [Nombre_compania] AS [Compañia], ([Ciudad]+', ' +[Estado])AS [Ciudad-Estado], [Proposito_Visita] AS [Proposito de la visita], DATENAME(DD,Fecha_requi) + ' de ' + DATENAME(mm, Fecha_requi) + ' de ' + DATENAME(YYYY,Fecha_requi) AS [Fecha] FROM [Visitantes] WHERE [Abierto] = 1 "; /*Filtro del DropDownList*/ if (RequisDrop.SelectedValue == "mias") { que2 += " AND [No.Empleado_Requi] = '" + Session["No.Empleado"].ToString() + "'"; } if (RequisDrop.SelectedValue == "ajenas") { que2 += " AND [No.Empleado_Requi] != '" + Session["No.Empleado"].ToString() + "'"; } /*Cuando se es requisitor se ejecuta esta condicion para que solamente muuestre las requisiciones que el a realizado esto por medio del numero de empleado*/ if (Session["permisos"].ToString() == "Requi") { que2 += " AND [No.Empleado_Requi] = '" + Session["No.Empleado"].ToString() + "'"; } SqlCommand con1 = new SqlCommand(que2, conexion); SqlDataReader slqDR1 = con1.ExecuteReader(); GridView2.DataSource = slqDR1; if (!IsPostBack) { BoundField columnaSeleccionar = new BoundField(); columnaSeleccionar.HeaderText = ""; GridView2.Columns.Add(columnaSeleccionar); } GridView2.DataBind(); slqDR1.Close(); slqDR1 = con1.ExecuteReader(); var contadorNp0 = 0; while (slqDR1.Read()) { var celdaSeleccionar = GridView2.Rows[contadorNp0].Cells[0]; System.Web.UI.HtmlControls.HtmlButton botonSeleccionar = new System.Web.UI.HtmlControls.HtmlButton(); botonSeleccionar.Attributes.Add("value", slqDR1["IdVisita"].ToString()); botonSeleccionar.Attributes.Add("name", "seleccionarVisita"); botonSeleccionar.Attributes.Add("class", "fa fa-eye buttonSpecial"); //botonSeleccionar.InnerHtml = "Ver"; celdaSeleccionar.Controls.Add(botonSeleccionar); contadorNp0++; } conexion.Close(); }
protected void LoadHeader() { grvList.Columns.Clear(); ButtonField b = new ButtonField(); b.Text = " " + "<img border=0 align=absmiddle src=../img/unselected.gif>" + " "; b.HeaderText = GetGlobalResourceObject("WebGlobalResource", "Select").ToString(); //选择 b.CommandName = "Select"; b.ItemStyle.HorizontalAlign = HorizontalAlign.Center; b.HeaderStyle.HorizontalAlign = HorizontalAlign.Center; b.ItemStyle.Width = new Unit("30px"); grvList.Columns.Add(b); string _sql = "select NAME,DESCR,OTHER_LANGUAGE_DESCR,CONTROL_LIST_WIDTH,CONTROL_LIST_DISPLAY_FORMAT,CONTROL_LIST_DISPLAY_ALIGN,TYPE from DMIS_SYS_COLUMNS where TABLE_ID=" + Session["MainTableId"].ToString() + " and ISDISPLAY=1 order by ORDER_ID"; DataTable _dt = DBOpt.dbHelper.GetDataTable(_sql); for (int i = 0; i < _dt.Rows.Count; i++) { BoundField bf = new BoundField(); if (Session["Culture"] == null || Session["Culture"].ToString() == "zh-CN") { bf.HeaderText = _dt.Rows[i]["DESCR"] == Convert.DBNull ? "" : _dt.Rows[i]["DESCR"].ToString(); } else { bf.HeaderText = _dt.Rows[i]["OTHER_LANGUAGE_DESCR"] == Convert.DBNull ? "" : _dt.Rows[i]["OTHER_LANGUAGE_DESCR"].ToString(); } bf.DataField = _dt.Rows[i]["NAME"].ToString(); if (_dt.Rows[i]["CONTROL_LIST_WIDTH"] != Convert.DBNull) { bf.ItemStyle.Width = new Unit(_dt.Rows[i]["CONTROL_LIST_WIDTH"].ToString() + "px"); } if (_dt.Rows[i]["CONTROL_LIST_DISPLAY_FORMAT"] != Convert.DBNull && _dt.Rows[i]["CONTROL_LIST_DISPLAY_FORMAT"].ToString().Trim().Length > 0) { bf.DataFormatString = _dt.Rows[i]["CONTROL_LIST_DISPLAY_FORMAT"].ToString(); if (_dt.Rows[i]["TYPE"].ToString() == "Datetime") { bf.HtmlEncode = false; } } if (_dt.Rows[i]["CONTROL_LIST_DISPLAY_ALIGN"] != Convert.DBNull) { if (_dt.Rows[i]["CONTROL_LIST_DISPLAY_ALIGN"].ToString() == "1") { bf.ItemStyle.HorizontalAlign = HorizontalAlign.Center; } else if (_dt.Rows[i]["CONTROL_LIST_DISPLAY_ALIGN"].ToString() == "0") { bf.ItemStyle.HorizontalAlign = HorizontalAlign.Left; } else if (_dt.Rows[i]["CONTROL_LIST_DISPLAY_ALIGN"].ToString() == "2") { bf.ItemStyle.HorizontalAlign = HorizontalAlign.Right; } else if (_dt.Rows[i]["CONTROL_LIST_DISPLAY_ALIGN"].ToString() == "3") { bf.ItemStyle.HorizontalAlign = HorizontalAlign.Justify; } } grvList.Columns.Add(bf); } }
//by yyan item8 20110614 add end //by yyan item8 20110614 del start //protected GridView bindDataBySalesOrgByOperation(DataSet ds, GridView gv, string header, string salesOrgID) //by yyan item8 20110614 del end //by yyan item8 20110614 add start protected GridView bindDataBySalesOrgByOperation(DataSet ds, GridView gv, string header, string salesOrgID, int flagMoney, bool flag) { if (ds != null) { gv.Visible = true; gv.AutoGenerateColumns = false; gv.Width = Unit.Pixel(600); gv.Columns.Clear(); //Calculate the total column of next year. ds.Tables[0].Columns.Add("Total"); if (ds.Tables[0].Rows[0][0] != DBNull.Value) { foreach (DataRow dr in ds.Tables[0].Rows) { float tmp = 0; for (int count2 = 1; count2 < ds.Tables[0].Columns.Count - 1; count2++) { tmp += float.Parse(dr[count2].ToString()); } dr["Total"] = tmp.ToString(); } } for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { BoundField bf = new BoundField(); bf.DataField = ds.Tables[0].Columns[i].ColumnName.ToString(); bf.HeaderText = ds.Tables[0].Columns[i].Caption.ToString(); bf.ItemStyle.HorizontalAlign = HorizontalAlign.Right; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Right; if (i == 0) { bf.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Left; bf.ItemStyle.Width = 100; } gv.Columns.Add(bf); } gv.Caption = header; gv.CaptionAlign = TableCaptionAlign.Left; gv.DataSource = ds; DataRow[] rows = new DataRow[2]; rows[0] = ds.Tables[0].NewRow(); rows[1] = ds.Tables[0].NewRow(); float[] Sum1 = new float[20]; float[] Sum2 = new float[20]; for (int j = 1; j < ds.Tables[0].Columns.Count - 1; j++) { string str_productAbbr = ds.Tables[0].Columns[j].ColumnName.Trim(); string str_productID = getProductIDBySegmentIDByProductAbbr(getSegmentID(), str_productAbbr); if (salesOrgID != "") { //by yyan item8 20110614 del start //string str_bl = sql.getBackLogBySalesOrgByOperation(ddlist_operation.SelectedItem.Value, getSegmentID(), str_productID, meeting.getyear(), meeting.getmonth(), salesOrgID, meeting.getyear().Substring(2, 2).Trim()); //by yyan item8 20110614 del end //by yyan item8 20110614 add start string str_bl = sql.getBackLogBySalesOrgByOperation(ddlist_operation.SelectedItem.Value, getSegmentID(), str_productID, meeting.getyear(), meeting.getmonth(), salesOrgID, meeting.getyear().Substring(2, 2).Trim(), flagMoney); //by yyan item8 20110614 add end if (str_bl == "") str_bl = "0"; Sum1[j] = float.Parse(str_bl); //by yyan item8 20110614 del start //string str_blnext = sql.getBackLogBySalesOrgByOperation(ddlist_operation.SelectedItem.Value, getSegmentID(), str_productID, meeting.getyear(), meeting.getmonth(), salesOrgID, meeting.getnextyear().Substring(2, 2).Trim()); //by yyan item8 20110614 del end //by yyan item8 20110614 add start string str_blnext = sql.getBackLogBySalesOrgByOperation(ddlist_operation.SelectedItem.Value, getSegmentID(), str_productID, meeting.getyear(), meeting.getmonth(), salesOrgID, meeting.getnextyear().Substring(2, 2).Trim(), flagMoney); //by yyan item8 20110614 add end if (str_blnext == "") str_blnext = "0"; Sum2[j] = float.Parse(str_blnext); } else { //by yyan item8 20110614 del start //string str_bl = sql.getBackLogByOperation(ddlist_operation.SelectedItem.Value, getSegmentID(), str_productID, meeting.getyear(), meeting.getmonth(), meeting.getyear().Substring(2, 2).Trim()); //by yyan item8 20110614 del end //by yyan item8 20110614 add start string str_bl = sql.getBackLogByOperation(ddlist_operation.SelectedItem.Value, getSegmentID(), str_productID, meeting.getyear(), meeting.getmonth(), meeting.getyear().Substring(2, 2).Trim(), flagMoney); //by yyan item8 20110614 add end if (str_bl == "") str_bl = "0"; Sum1[j] = float.Parse(str_bl); //by yyan item8 20110614 del start //string str_blnext = sql.getBackLogByOperation(ddlist_operation.SelectedItem.Value, getSegmentID(), str_productID, meeting.getyear(), meeting.getmonth(), meeting.getnextyear().Substring(2, 2).Trim()); //by yyan item8 20110614 del end //by yyan item8 20110614 add start string str_blnext = sql.getBackLogByOperation(ddlist_operation.SelectedItem.Value, getSegmentID(), str_productID, meeting.getyear(), meeting.getmonth(), meeting.getnextyear().Substring(2, 2).Trim(), flagMoney); //by yyan item8 20110614 add end if (str_blnext == "") str_blnext = "0"; Sum2[j] = float.Parse(str_blnext); } } for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { if (i == 0) { if (meeting.getmonth() == "10") rows[0][0] = meeting.getyear().Substring(2, 2) + "Actual Sales"; else rows[0][0] = meeting.getyear().Substring(2, 2) + "Actual Sales+B/L"; rows[1][0] = meeting.getnextyear().Substring(2, 2) + "B/L"; } else { rows[0][i] = Sum1[i]; rows[1][i] = Sum2[i]; } } float tempY = 0; float tempNY = 0; for (int i = 0; i < ds.Tables[0].Columns.Count - 1; i++) { tempY += Sum1[i]; tempNY += Sum2[i]; } rows[0][ds.Tables[0].Columns.Count - 1] = tempY; rows[1][ds.Tables[0].Columns.Count - 1] = tempNY; ds.Tables[0].Rows.InsertAt(rows[0], 0); ds.Tables[0].Rows.InsertAt(rows[1], 1); if (salesOrgID != "") { //by yyan item8 20110614 del start //getSalesForecast(ds, salesOrgID, meeting.getyear().Substring(2, 2)); //getSalesForecast(ds, salesOrgID, meeting.getnextyear().Substring(2, 2)); //by yyan item8 20110614 del end //by yyan item8 20110614 add start getSalesForecast(ds, salesOrgID, meeting.getyear().Substring(2, 2), flagMoney); getSalesForecast(ds, salesOrgID, meeting.getnextyear().Substring(2, 2), flagMoney); //by yyan item8 20110614 add end } else { //by yyan item8 20110614 del start //getSalesForecast(ds, "", meeting.getyear().Substring(2, 2)); //getSalesForecast(ds, "", meeting.getnextyear().Substring(2, 2)); //by yyan item8 20110614 del end //by yyan item8 20110614 add start getSalesForecast(ds, "", meeting.getyear().Substring(2, 2), flagMoney); getSalesForecast(ds, "", meeting.getnextyear().Substring(2, 2), flagMoney); //by yyan item8 20110614 add end } //by yyan itemw93 add start bool bz = false; int k = 0; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (ds.Tables[0].Rows[i][0].ToString().Contains("F/C")) { bz = true; k = i; break; } } if (bz) { if (flag) { for (int i = ds.Tables[0].Rows.Count - 1; i >= k; i--) { ds.Tables[0].Rows[i].Delete(); } } else { for (int i = k - 1; i >= 0; i--) { ds.Tables[0].Rows[i].Delete(); } } } //by yyan itemw93 add end gv.DataBind(); } else gv.Visible = false; return gv; }
protected override void CreateChildControls() { try { #region Creacion de controles pnlFormulario = new Panel(); pnlFormulario.ID = "pnlFormulario"; pnlAdjuntos = new Panel(); pnlAdjuntos.ID = "pnlAdjuntos"; pnlAdjuntos.Visible = false; lblTipoCarta = new Label(); lblTipoCarta.Text = "Tipo <span class='ms-formvalidation'>*</span>"; lblDescTipoCarta = new Label(); lblDescTipoCarta.Text = "Tipo de correspondencia recibida"; rblTipoCarta = new RadioButtonList(); rblTipoCarta.ID = "rblTipoCarta"; rblTipoCarta.Items.Add("INTERNA"); rblTipoCarta.Items.Add("EXTERNA"); rfvTipoCarta = new RequiredFieldValidator(); rfvTipoCarta.ID = "rfvTipoCarta"; rfvTipoCarta.Text = "<br/>Tiene que especificar un valor para este campo requerido."; rfvTipoCarta.Display = ValidatorDisplay.Dynamic; rfvTipoCarta.ControlToValidate = "rblTipoCarta"; rfvTipoCarta.SetFocusOnError = true; lblOrigenCarta = new Label(); lblOrigenCarta.Text = "Origen <span class='ms-formvalidation'>*</span>"; lblDescOrigenCarta = new Label(); lblDescOrigenCarta.Text = "Origen de la correspondencia"; rblOrigenCarta = new RadioButtonList(); rblOrigenCarta.ID = "rblOrigenCarta"; rblOrigenCarta.Items.Add(new ListItem("", "COMBO")); rblOrigenCarta.Items.Add(new ListItem("", "TEXTO")); rblOrigenCarta.SelectedIndex = 0; ddlOrigenCarta = new DropDownList(); ddlOrigenCarta.ID = "ddlOrigenCarta"; ddlOrigenCarta.Attributes.Add("style", "width:385px;"); ddlOrigenCarta.DataSource = ConectorWebPart.RecuperarOrigenesCorrespondencia(); ddlOrigenCarta.DataTextField = "text"; ddlOrigenCarta.DataValueField = "value"; ddlOrigenCarta.DataBind(); ddlOrigenCarta.Items.Insert(0, new ListItem("", string.Empty)); ddlOrigenCarta.SelectedIndex = 0; txbOrigenCarta = new TextBox(); txbOrigenCarta.ID = "txbOrigenCarta"; txbOrigenCarta.Attributes.Add("style", "width:385px;"); ctvOrigenCarta = new CustomValidator(); ctvOrigenCarta.ID = "ctvOrigenCarta"; ctvOrigenCarta.Text = "<br/>Tiene que especificar un valor para este campo requerido."; ctvOrigenCarta.Display = ValidatorDisplay.Dynamic; ctvOrigenCarta.ControlToValidate = "rblOrigenCarta"; ctvOrigenCarta.ServerValidate += new ServerValidateEventHandler(ctvOrigenCarta_ServerValidate); //rfvDdlOrigenCarta = new RequiredFieldValidator(); //rfvDdlOrigenCarta.ID = "rfvDdlOrigenCarta"; //rfvDdlOrigenCarta.Text = "<br/>Tiene que especificar un valor para este campo requerido."; //rfvDdlOrigenCarta.InitialValue = string.Empty; //rfvDdlOrigenCarta.Display = ValidatorDisplay.Dynamic; //rfvDdlOrigenCarta.ControlToValidate = "ddlOrigenCarta"; //rfvDdlOrigenCarta.Enabled = false; //rfvTxbOrigenCarta = new RequiredFieldValidator(); //rfvTxbOrigenCarta.ID = "rfvTxbOrigenCarta"; //rfvTxbOrigenCarta.Text = "<br/>Tiene que especificar un valor para este campo requerido."; //rfvTxbOrigenCarta.Display = ValidatorDisplay.Dynamic; //rfvTxbOrigenCarta.ControlToValidate = "txbOrigenCarta"; //rfvTxbOrigenCarta.Enabled = false; lblReferencia = new Label(); lblReferencia.Text = "Referencia <span class='ms-formvalidation'>*</span>"; lblDescReferencia = new Label(); lblDescReferencia.Text = "<br/>Referencia de la carta"; txbReferencia = new InputFormTextBox(); txbReferencia.ID = "txbReferencia"; txbReferencia.Attributes.Add("style", "width:385px;"); txbReferencia.RichText = false; txbReferencia.RichTextMode = SPRichTextMode.Compatible; txbReferencia.Rows = 5; txbReferencia.TextMode = TextBoxMode.MultiLine; rfvReferencia = new RequiredFieldValidator(); rfvReferencia.ID = "rfvReferencia"; rfvReferencia.Text = "<br/>Tiene que especificar un valor para este campo requerido."; rfvReferencia.Display = ValidatorDisplay.Dynamic; rfvReferencia.ControlToValidate = "txbReferencia"; rfvReferencia.SetFocusOnError = true; lblFechaCarta = new Label(); lblFechaCarta.Text = "Fecha origen <span class='ms-formvalidation'>*</span>"; lblDescFechaCarta = new Label(); lblDescFechaCarta.Text = "Fecha de la correspondencia"; dtcFechaCarta = new DateTimeControl(); dtcFechaCarta.ID = "dtcFechaCarta"; dtcFechaCarta.IsRequiredField = true; dtcFechaCarta.DateOnly = true; lblFechaRecibida = new Label(); lblFechaRecibida.Text = "Fecha recibida <span class='ms-formvalidation'>*</span>"; lblDescFechaRecibida = new Label(); lblDescFechaRecibida.Text = "Fecha de recepción de la carta"; dtcFechaRecibida = new DateTimeControl(); dtcFechaRecibida.ID = "dtcFechaRecibida"; dtcFechaRecibida.IsRequiredField = true; dtcFechaRecibida.SelectedDate = DateTime.Now; lblDestinatario = new Label(); lblDestinatario.Text = "Destinatario <span class='ms-formvalidation'>*</span>"; lblDescDestinatario = new Label(); lblDescDestinatario.Text = "<br/>Destinatario indicado en la carta"; txbDestinatario = new TextBox(); txbDestinatario.ID = "txbDestinatario"; txbDestinatario.Attributes.Add("style", "width:385px;"); rfvDestinatario = new RequiredFieldValidator(); rfvDestinatario.ID = "rfvDestinatario"; rfvDestinatario.Text = "<br/>Tiene que especificar un valor para este campo requerido."; rfvDestinatario.Display = ValidatorDisplay.Dynamic; rfvDestinatario.ControlToValidate = "txbDestinatario"; rfvDestinatario.SetFocusOnError = true; lblDirigidaA = new Label(); lblDirigidaA.Text = "Dirigida a <span class='ms-formvalidation'>*</span>"; lblDescDirigidaA = new Label(); lblDescDirigidaA.Text = "Usuario(s) al(os) cual(es) será enviada la notificación de correspondencia. El primero usuario definido en este campo será el dueño de esta correspondencia."; pedDirigidaA = new PeopleEditor(); pedDirigidaA.ID = "pedDirigidaA"; pedDirigidaA.AllowEmpty = false; pedDirigidaA.MultiSelect = true; pedDirigidaA.Rows = 1; pedDirigidaA.PlaceButtonsUnderEntityEditor = false; rfvDirigidaA = new RequiredFieldValidator(); rfvDirigidaA.ID = "rfvDirigidaA"; rfvDirigidaA.Text = "<br/>Tiene que especificar un valor para este campo requerido."; rfvDirigidaA.Display = ValidatorDisplay.Dynamic; rfvDirigidaA.ControlToValidate = "pedDirigidaA"; rfvDirigidaA.SetFocusOnError = true; lblNumCarta = new Label(); lblNumCarta.Text = "Num. ó Cite"; lblDescNumCarta = new Label(); lblDescNumCarta.Text = "<br/>Código de indentificación de la carta"; txbNumCarta = new TextBox(); txbNumCarta.ID = "txbNumCarta"; txbNumCarta.Attributes.Add("style", "width:385px;"); lblAdjunto = new Label(); lblAdjunto.Text = "Adjunto <span class='ms-formvalidation'>*</span>"; lblDescAdjunto = new Label(); lblDescAdjunto.Text = "<br/>Indica si la correspondencia trae documentos adjuntos o no"; txbAdjunto = new TextBox(); txbAdjunto.ID = "txbAdjunto"; txbAdjunto.Attributes.Add("style", "width:385px;"); rfvAdjunto = new RequiredFieldValidator(); rfvAdjunto.ID = "rfvAdjunto"; rfvAdjunto.Text = "<br/>Tiene que especificar un valor para este campo requerido."; rfvAdjunto.Display = ValidatorDisplay.Dynamic; rfvAdjunto.ControlToValidate = "txbAdjunto"; rfvAdjunto.SetFocusOnError = true; lblClase = new Label(); lblClase.Text = "Clase de documento <span class='ms-formvalidation'>*</span>"; lblDescClase = new Label(); lblDescClase.Text = ""; txbClase = new TextBox(); txbClase.ID = "txbClase"; txbClase.Attributes.Add("style", "width:385px;"); rfvClase = new RequiredFieldValidator(); rfvClase.ID = "rfvClase"; rfvClase.Text = "<br/>Tiene que especificar un valor para este campo requerido."; rfvClase.Display = ValidatorDisplay.Dynamic; rfvClase.ControlToValidate = "txbClase"; rfvClase.SetFocusOnError = true; lblPrioridad = new Label(); lblPrioridad.Text = "Prioridad <span class='ms-formvalidation'>*</span>"; lblDescPrioridad = new Label(); lblDescPrioridad.Text = "<br/>Prioridad de la correspondencia"; ddlPrioridad = new DropDownList(); ddlPrioridad.ID = "ddlPrioridad"; ddlPrioridad.Attributes.Add("style", "width:150px;"); ddlPrioridad.Items.Add("NORMAL"); ddlPrioridad.Items.Add("URGENTE"); ddlPrioridad.SelectedIndex = 0; lblPrivada = new Label(); lblPrivada.Text = "Privada"; lblDescPrivada = new Label(); lblDescPrivada.Text = "<br/>Si se marca, esta carta será leida solo por el(los) usuario(s) indicado(s) en el campo \"Dirigida a\""; chkPrivada = new CheckBox(); chkPrivada.ID = "chkPrivada"; chkPrivada.Checked = true; lblHojaDeRuta = new Label(); lblHojaDeRuta.Text = "Hoja de ruta"; lblDescHojaDeRuta = new Label(); lblDescHojaDeRuta.Text = "<br/>Si se marca, imprime la hoja de ruta"; chkHojaDeRuta = new CheckBox(); chkHojaDeRuta.ID = "chkHojaDeRuta"; chkHojaDeRuta.Checked = true; lblArchivo = new Label(); lblArchivo.Text = "Archivo"; lblDescArchivo = new Label(); lblDescArchivo.Text = "<br/>Descripción de la ubicación física final de la correspondencia"; txbArchivo = new InputFormTextBox(); txbArchivo.ID = "txbArchivo"; txbArchivo.Attributes.Add("style", "width:385px;"); txbArchivo.RichText = false; txbArchivo.RichTextMode = SPRichTextMode.Compatible; txbArchivo.Rows = 5; txbArchivo.TextMode = TextBoxMode.MultiLine; lblAdjuntos = new Label(); lblAdjuntos.Text = "Adjuntos"; lblDescAdjuntos = new Label(); lblDescAdjuntos.Text = "Seleccione el o los archivos que desea adjuntar a este registro de correspondencia"; grvAdjuntos = new GridView(); grvAdjuntos.ID = "grvAdjuntos"; grvAdjuntos.GridLines = GridLines.None; grvAdjuntos.ForeColor = Color.FromArgb(51, 51, 51); grvAdjuntos.CellPadding = 4; grvAdjuntos.AutoGenerateColumns = false; grvAdjuntos.DataKeyNames = new string[] { "RutaArchivo" }; grvAdjuntos.RowStyle.BackColor = Color.FromArgb(227, 234, 235); //grvAdjuntos.HeaderStyle.BackColor = Color.FromArgb(28, 94, 85); grvAdjuntos.HeaderStyle.Font.Bold = true; //grvAdjuntos.HeaderStyle.ForeColor = Color.FromArgb(255, 255, 255); grvAdjuntos.AlternatingRowStyle.BackColor = Color.White; grvAdjuntos.Width = Unit.Percentage(100); //grvAdjuntos.RowDataBound += new GridViewRowEventHandler(grvAdjuntos_RowDataBound); #region Adicion de columnas al Grid TemplateField chkAdjuntar = new TemplateField(); CheckBoxTemplate chkBox = new CheckBoxTemplate(); chkAdjuntar.ItemTemplate = chkBox; BoundField bflNombreArchivo = new BoundField(); bflNombreArchivo.HeaderText = "Nombre archivo"; bflNombreArchivo.DataField = "NombreArchivo"; BoundField bflTipoArchivo = new BoundField(); bflTipoArchivo.HeaderText = "Tipo"; bflTipoArchivo.DataField = "TipoArchivo"; ImageField imfVistaPrevia = new ImageField(); imfVistaPrevia.HeaderText = "Vista Previa"; imfVistaPrevia.DataImageUrlField = "VistaPrevia"; BoundField bflRutaArchivo = new BoundField(); bflRutaArchivo.HeaderText = "URL"; bflRutaArchivo.DataField = "RutaArchivo"; bflRutaArchivo.Visible = false; grvAdjuntos.Columns.Add(chkAdjuntar); grvAdjuntos.Columns.Add(bflNombreArchivo); grvAdjuntos.Columns.Add(bflTipoArchivo); grvAdjuntos.Columns.Add(imfVistaPrevia); grvAdjuntos.Columns.Add(bflRutaArchivo); grvAdjuntos.DataSource = ConectorWebPart.RecuperarDocumentosEP().Tables["DataTable"]; grvAdjuntos.DataBind(); #endregion btnAdjuntarArchivos = new LinkButton(); btnAdjuntarArchivos.ID = "btnAdjuntarArchivos"; btnAdjuntarArchivos.Text = "Adjuntar Archivos"; btnAdjuntarArchivos.ToolTip = "Ver el panel de adjuntar archivos."; btnAdjuntarArchivos.Attributes.Add("style", "font-size:8.5pt;"); btnAdjuntarArchivos.Click += new EventHandler(btnAdjuntarArchivos_Click); btnAdjuntarArchivos.CausesValidation = false; //OJO btnFinalizarRegistro = new Button(); btnFinalizarRegistro.ID = "btnFinalizarRegistro"; btnFinalizarRegistro.Text = "Finalizar"; btnFinalizarRegistro.ToolTip = "Finalizar el registro de nueva correspondencia."; btnFinalizarRegistro.Visible = true; btnFinalizarRegistro.Attributes.Add("style", "width:140px; font-size:8.5pt;"); btnFinalizarRegistro.Click += new EventHandler(btnFinalizarRegistro_Click); //btnIrAtras = new Button(); //btnIrAtras.ID = "btnIrAtras"; //btnIrAtras.Text = "Ir Atras"; //btnIrAtras.ToolTip = "Volver al formulario de registro"; //btnIrAtras.Visible = false; //btnIrAtras.Attributes.Add("style", "width:140px; font-size:8.5pt;"); //btnIrAtras.Click += new EventHandler(btnIrAtras_Click); btnCancelar = new GoBackButton(); btnCancelar.ID = "btnCancelar"; btnCancelar.ControlMode = SPControlMode.New; #endregion #region Adiccion de controles pnlFormulario.Controls.Add(new LiteralControl("<table border='0' cellspacing='0' width='100%'>")); pnlFormulario.Controls.Add(new LiteralControl("<tr><td colspan='2' style='border-bottom:1px black solid'><b>Datos de la Correspondencia</b></td></tr>")); pnlFormulario.Controls.Add(new LiteralControl("<tr><td width='190px' valign='top' class='ms-formlabel'><H3 class='ms-standardheader'><nobr>")); pnlFormulario.Controls.Add(lblTipoCarta); pnlFormulario.Controls.Add(new LiteralControl("</nobr></H3></td><td width='500px' valign='top' class='ms-formbody'>")); pnlFormulario.Controls.Add(rblTipoCarta); pnlFormulario.Controls.Add(lblDescTipoCarta); pnlFormulario.Controls.Add(rfvTipoCarta); pnlFormulario.Controls.Add(new LiteralControl("</td></tr>")); pnlFormulario.Controls.Add(new LiteralControl("<tr><td width='190px' valign='top' class='ms-formlabel'><H3 class='ms-standardheader'><nobr>")); pnlFormulario.Controls.Add(lblOrigenCarta); pnlFormulario.Controls.Add(new LiteralControl("</nobr></H3></td><td width='500px' valign='top' class='ms-formbody'>")); pnlFormulario.Controls.Add(new LiteralControl("<table><tr><td>")); pnlFormulario.Controls.Add(rblOrigenCarta); pnlFormulario.Controls.Add(new LiteralControl("</td><td>")); pnlFormulario.Controls.Add(ddlOrigenCarta); pnlFormulario.Controls.Add(new LiteralControl("<br/>")); pnlFormulario.Controls.Add(txbOrigenCarta); pnlFormulario.Controls.Add(new LiteralControl("</td></tr></table>")); pnlFormulario.Controls.Add(lblDescOrigenCarta); pnlFormulario.Controls.Add(ctvOrigenCarta); pnlFormulario.Controls.Add(new LiteralControl("</td></tr>")); pnlFormulario.Controls.Add(new LiteralControl("<tr><td width='190px' valign='top' class='ms-formlabel'><H3 class='ms-standardheader'><nobr>")); pnlFormulario.Controls.Add(lblReferencia); pnlFormulario.Controls.Add(new LiteralControl("</nobr></H3></td><td width='500px' valign='top' class='ms-formbody'>")); pnlFormulario.Controls.Add(txbReferencia); pnlFormulario.Controls.Add(lblDescReferencia); pnlFormulario.Controls.Add(rfvReferencia); pnlFormulario.Controls.Add(new LiteralControl("</td></tr>")); pnlFormulario.Controls.Add(new LiteralControl("<tr><td width='190px' valign='top' class='ms-formlabel'><H3 class='ms-standardheader'><nobr>")); pnlFormulario.Controls.Add(lblFechaCarta); pnlFormulario.Controls.Add(new LiteralControl("</nobr></H3></td><td width='500px' valign='top' class='ms-formbody'>")); pnlFormulario.Controls.Add(dtcFechaCarta); pnlFormulario.Controls.Add(lblDescFechaCarta); pnlFormulario.Controls.Add(new LiteralControl("</td></tr>")); pnlFormulario.Controls.Add(new LiteralControl("<tr><td width='190px' valign='top' class='ms-formlabel'><H3 class='ms-standardheader'><nobr>")); pnlFormulario.Controls.Add(lblFechaRecibida); pnlFormulario.Controls.Add(new LiteralControl("</nobr></H3></td><td width='500px' valign='top' class='ms-formbody'>")); pnlFormulario.Controls.Add(dtcFechaRecibida); pnlFormulario.Controls.Add(lblDescFechaRecibida); pnlFormulario.Controls.Add(new LiteralControl("</td></tr>")); pnlFormulario.Controls.Add(new LiteralControl("<tr><td width='190px' valign='top' class='ms-formlabel'><H3 class='ms-standardheader'><nobr>")); pnlFormulario.Controls.Add(lblDestinatario); pnlFormulario.Controls.Add(new LiteralControl("</nobr></H3></td><td width='500px' valign='top' class='ms-formbody'>")); pnlFormulario.Controls.Add(txbDestinatario); pnlFormulario.Controls.Add(lblDescDestinatario); pnlFormulario.Controls.Add(rfvDestinatario); pnlFormulario.Controls.Add(new LiteralControl("</td></tr>")); pnlFormulario.Controls.Add(new LiteralControl("<tr><td width='190px' valign='top' class='ms-formlabel'><H3 class='ms-standardheader'><nobr>")); pnlFormulario.Controls.Add(lblDirigidaA); pnlFormulario.Controls.Add(new LiteralControl("</nobr></H3></td><td width='500px' valign='top' class='ms-formbody'>")); pnlFormulario.Controls.Add(pedDirigidaA); pnlFormulario.Controls.Add(lblDescDirigidaA); pnlFormulario.Controls.Add(rfvDirigidaA); pnlFormulario.Controls.Add(new LiteralControl("</td></tr>")); pnlFormulario.Controls.Add(new LiteralControl("<tr><td width='190px' valign='top' class='ms-formlabel'><H3 class='ms-standardheader'><nobr>")); pnlFormulario.Controls.Add(lblNumCarta); pnlFormulario.Controls.Add(new LiteralControl("</nobr></H3></td><td width='500px' valign='top' class='ms-formbody'>")); pnlFormulario.Controls.Add(txbNumCarta); pnlFormulario.Controls.Add(lblDescNumCarta); pnlFormulario.Controls.Add(new LiteralControl("</td></tr>")); pnlFormulario.Controls.Add(new LiteralControl("<tr><td width='190px' valign='top' class='ms-formlabel'><H3 class='ms-standardheader'><nobr>")); pnlFormulario.Controls.Add(lblAdjunto); pnlFormulario.Controls.Add(new LiteralControl("</nobr></H3></td><td width='500px' valign='top' class='ms-formbody'>")); pnlFormulario.Controls.Add(txbAdjunto); pnlFormulario.Controls.Add(lblDescAdjunto); pnlFormulario.Controls.Add(rfvAdjunto); pnlFormulario.Controls.Add(new LiteralControl("</td></tr>")); pnlFormulario.Controls.Add(new LiteralControl("<tr><td width='190px' valign='top' class='ms-formlabel'><H3 class='ms-standardheader'><nobr>")); pnlFormulario.Controls.Add(lblClase); pnlFormulario.Controls.Add(new LiteralControl("</nobr></H3></td><td width='500px' valign='top' class='ms-formbody'>")); pnlFormulario.Controls.Add(txbClase); pnlFormulario.Controls.Add(lblDescClase); pnlFormulario.Controls.Add(rfvClase); pnlFormulario.Controls.Add(new LiteralControl("</td></tr>")); pnlFormulario.Controls.Add(new LiteralControl("<tr><td width='190px' valign='top' class='ms-formlabel'><H3 class='ms-standardheader'><nobr>")); pnlFormulario.Controls.Add(lblPrioridad); pnlFormulario.Controls.Add(new LiteralControl("</nobr></H3></td><td width='500px' valign='top' class='ms-formbody'>")); pnlFormulario.Controls.Add(ddlPrioridad); pnlFormulario.Controls.Add(lblDescPrioridad); pnlFormulario.Controls.Add(new LiteralControl("</td></tr>")); pnlFormulario.Controls.Add(new LiteralControl("<tr><td width='190px' valign='top' class='ms-formlabel'><H3 class='ms-standardheader'><nobr>")); pnlFormulario.Controls.Add(lblPrivada); pnlFormulario.Controls.Add(new LiteralControl("</nobr></H3></td><td width='500px' valign='top' class='ms-formbody'>")); pnlFormulario.Controls.Add(chkPrivada); pnlFormulario.Controls.Add(lblDescPrivada); pnlFormulario.Controls.Add(new LiteralControl("</td></tr>")); pnlFormulario.Controls.Add(new LiteralControl("<tr><td width='190px' valign='top' class='ms-formlabel'><H3 class='ms-standardheader'><nobr>")); pnlFormulario.Controls.Add(lblHojaDeRuta); pnlFormulario.Controls.Add(new LiteralControl("</nobr></H3></td><td width='500px' valign='top' class='ms-formbody'>")); pnlFormulario.Controls.Add(chkHojaDeRuta); pnlFormulario.Controls.Add(lblDescHojaDeRuta); pnlFormulario.Controls.Add(new LiteralControl("</td></tr>")); pnlFormulario.Controls.Add(new LiteralControl("<tr><td width='190px' valign='top' class='ms-formlabel'><H3 class='ms-standardheader'><nobr>")); pnlFormulario.Controls.Add(lblArchivo); pnlFormulario.Controls.Add(new LiteralControl("</nobr></H3></td><td width='500px' valign='top' class='ms-formbody'>")); pnlFormulario.Controls.Add(txbArchivo); pnlFormulario.Controls.Add(lblDescArchivo); pnlFormulario.Controls.Add(new LiteralControl("</td></tr>")); pnlFormulario.Controls.Add(new LiteralControl("</table>")); pnlAdjuntos.Controls.Add(new LiteralControl("<table border='0' cellspacing='0' width='100%'>")); pnlAdjuntos.Controls.Add(new LiteralControl("<tr><td colspan='2' style='border-bottom:1px black solid'><b>Archivos Adjuntos</b></td></tr>")); pnlAdjuntos.Controls.Add(new LiteralControl("<tr><td width='190px' valign='top' class='ms-formlabel'><H3 class='ms-standardheader'><nobr>")); pnlAdjuntos.Controls.Add(lblAdjuntos); pnlAdjuntos.Controls.Add(new LiteralControl("</nobr></H3></td><td width='500px' valign='top' class='ms-formbody'>")); pnlAdjuntos.Controls.Add(lblDescAdjuntos); pnlAdjuntos.Controls.Add(grvAdjuntos); pnlAdjuntos.Controls.Add(new LiteralControl("</td></tr>")); pnlAdjuntos.Controls.Add(new LiteralControl("</table>")); this.Controls.Add(pnlFormulario); this.Controls.Add(pnlAdjuntos); this.Controls.Add(new LiteralControl("<table border='0' cellspacing='0' width='100%'>")); this.Controls.Add(new LiteralControl("<tr><td style='text-align:right' class='ms-toolbar'>")); this.Controls.Add(new LiteralControl("<table><tr><td width='99%' class='ms-toolbar'><IMG SRC='/_layouts/images/blank.gif' width='1' height='18'/></td>")); this.Controls.Add(new LiteralControl("<td nowrap='nowrap' class='ms-toolbar'>")); this.Controls.Add(btnAdjuntarArchivos); this.Controls.Add(new LiteralControl("</td><td class='ms-separator'> </td><td class='ms-toolbar' align='right'>")); this.Controls.Add(btnFinalizarRegistro); this.Controls.Add(new LiteralControl("</td><td class='ms-separator'> </td><td class='ms-toolbar' align='right'>")); this.Controls.Add(btnCancelar); //this.Controls.Add(btnIrAtras); this.Controls.Add(new LiteralControl("</td></tr></table>")); this.Controls.Add(new LiteralControl("</td></tr>")); this.Controls.Add(new LiteralControl("</table>")); #endregion } catch (Exception ex) { Literal error = new Literal(); error.Text = ex.Message; this.Controls.Clear(); this.Controls.Add(error); } }
//By Lhy 20110505 ITEM 6 ADD End protected void bindDataSource(DataSet ds) { bool notNullFlag = true; if (ds.Tables[0].Rows.Count == 0) { notNullFlag = false; sql.getNullDataSet(ds); } //By Lhy 20110504 ITEM 6 DEL start //gv_option.Width = Unit.Pixel(450); //By Lhy 20110504 ITEM 6 DEL End gv_option.AutoGenerateColumns = false; gv_option.AllowPaging = false; gv_option.Visible = true; for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { BoundField bf = new BoundField(); bf.DataField = ds.Tables[0].Columns[i].ColumnName.ToString(); //By Lhy 20110504 ITEM 6 DEL start //ds.Tables[0].Columns[i].Caption.ToString(); //By Lhy 20110504 ITEM 6 DEL End //By Lhy 20110504 ITEM 6 ADD start bf.HeaderText = ddlist_description.SelectedItem.Text + " Name"; //By Lhy 20110504 ITEM 6 ADD End bf.ItemStyle.Width = 350; //By Lhy 20110510 ITEM 6 ADD start if (string.Equals(ddlist_description.SelectedValue, "0")) { this.divflow.Attributes.Add("Style", "overflow: auto; height: 480px; width: 221px; position: relative; padding-top: 22px;"); } else if (string.Equals(ddlist_description.SelectedValue, "1")) { this.divflow.Attributes.Add("Style", "overflow: auto; height: 480px; width: 221px; position: relative; padding-top: 22px;"); } else if (string.Equals(ddlist_description.SelectedValue, "2")) { this.divflow.Attributes.Add("Style", "overflow: auto; height: 480px; width: 440px; position: relative; padding-top: 22px;"); } else if (string.Equals(ddlist_description.SelectedValue, "3")) { this.divflow.Attributes.Add("Style", "overflow: auto; height: 480px; width: 320px; position: relative; padding-top: 22px;"); } //By Lhy 20110504 ITEM 10 ADD End bf.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Left; bf.HeaderStyle.Wrap = false; gv_option.Columns.Add(bf); } gv_option.AllowSorting = true; gv_option.DataSource = ds.Tables[0]; gv_option.DataBind(); gv_option.Columns[0].Visible = false; }
private void AtualizarGrid() { DataTable dados = M17_Food4U.Models.User.ListarUtilizadores(); dgv_utilizadores.Columns.Clear(); dgv_utilizadores.DataSource = null; dgv_utilizadores.DataBind(); dgv_utilizadores.DataSource = dados; dgv_utilizadores.AutoGenerateColumns = false; // id,email,name,nif,data_nasc,saldo,estado,perfil BoundField bfID = new BoundField(); bfID.HeaderText = "ID"; bfID.DataField = "id"; dgv_utilizadores.Columns.Add(bfID); BoundField bfNome = new BoundField(); bfNome.HeaderText = "Email"; bfNome.DataField = "email"; dgv_utilizadores.Columns.Add(bfNome); BoundField bfDescription = new BoundField(); bfDescription.HeaderText = "Nome"; bfDescription.DataField = "name"; dgv_utilizadores.Columns.Add(bfDescription); BoundField bfEstrelas = new BoundField(); bfEstrelas.HeaderText = "NIF"; bfEstrelas.DataField = "nif"; dgv_utilizadores.Columns.Add(bfEstrelas); BoundField bfStock = new BoundField(); bfStock.HeaderText = "Data Nascimento"; bfStock.DataField = "data_nasc"; bfStock.DataFormatString = "{0:d}"; dgv_utilizadores.Columns.Add(bfStock); BoundField bfPreco = new BoundField(); bfPreco.HeaderText = "Saldo"; bfPreco.DataField = "saldo"; bfPreco.DataFormatString = "{0:C}"; dgv_utilizadores.Columns.Add(bfPreco); BoundField bfState = new BoundField(); bfState.HeaderText = "Estado"; bfState.DataField = "estado"; dgv_utilizadores.Columns.Add(bfState); BoundField bfPerfil = new BoundField(); bfPerfil.HeaderText = "Perfil"; bfPerfil.DataField = "perfil"; dgv_utilizadores.Columns.Add(bfPerfil); ButtonField dcOpcoes = new ButtonField(); dcOpcoes.HeaderText = "Opções"; dcOpcoes.ButtonType = ButtonType.Link; dgv_utilizadores.Columns.Add(dcOpcoes); DataColumn dcDetalhes = new DataColumn(); dcDetalhes.ColumnName = "Histórico Pedidos"; dcDetalhes.DataType = Type.GetType("System.String"); dados.Columns.Add(dcDetalhes); HyperLinkField hldetalhes = new HyperLinkField(); hldetalhes.HeaderText = "Histórico Pedidos"; hldetalhes.DataTextField = "Histórico Pedidos"; hldetalhes.Text = "Histórico Pedidos"; hldetalhes.DataNavigateUrlFormatString = "~/admin/historicopedidos.aspx?user={0}"; hldetalhes.DataNavigateUrlFields = new string[] { "id" }; dgv_utilizadores.Columns.Add(hldetalhes); DataColumn dcDetalhes2 = new DataColumn(); dcDetalhes2.ColumnName = "Histórico Transações"; dcDetalhes2.DataType = Type.GetType("System.String"); dados.Columns.Add(dcDetalhes2); HyperLinkField hldetalhes2 = new HyperLinkField(); hldetalhes2.HeaderText = "Histórico Transações"; hldetalhes2.DataTextField = "Histórico Transações"; hldetalhes2.Text = "Histórico Transações"; hldetalhes2.DataNavigateUrlFormatString = "~/admin/historicotransacoes.aspx?user={0}"; hldetalhes2.DataNavigateUrlFields = new string[] { "id" }; dgv_utilizadores.Columns.Add(hldetalhes2); dgv_utilizadores.DataBind(); }
protected void bindDataByDateByProduct(GridView gv, string bookingY, string deliverY) { DataSet ds_product = getProductBySegment(getSegmentID()); DataSet ds = getBookingDataByDateByProduct(ds_product, getSegmentID(), bookingY, deliverY, getSalesOrgID()); if (ds != null) { gv.Width = Unit.Pixel(650); gv.AutoGenerateColumns = false; gv.AllowPaging = false; gv.Visible = true; for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { BoundField bf = new BoundField(); bf.DataField = ds.Tables[0].Columns[i].ColumnName.ToString(); bf.HeaderText = ds.Tables[0].Columns[i].Caption.ToString(); bf.ItemStyle.HorizontalAlign = HorizontalAlign.Right; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Right; if (i == 0 || i == 1) { bf.ItemStyle.Width = 100; bf.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Left; } gv.Columns.Add(bf); } if (deliverY == "YTD") gv.Caption = bookingY + deliverY; else gv.Caption = bookingY + " for " + deliverY; gv.CaptionAlign = TableCaptionAlign.Top; gv.AllowSorting = true; gv.DataSource = ds.Tables[0]; gv.DataBind(); flag = true; } else { flag = false; gv.Visible = false; } }
public void Bind4(GridView G1) { BoundField bf11 = G1.Columns[0] as BoundField; bf11.ItemStyle.Font.Bold = true; ButtonField bf88 = G1.Columns[9] as ButtonField; bf88.ControlStyle.BorderStyle = BorderStyle.None; bf88.ControlStyle.BackColor = System.Drawing.Color.White; }
protected GridView showTotalByProduct(DataSet ds, GridView gv, string productName) { if (ds != null) { gv.AutoGenerateColumns = false; gv.Width = Unit.Pixel(300); gv.Columns.Clear(); //Calculate the VAR column and Total row of next year. try { ds.Tables[0].Columns.Add("VAR"); if (ds.Tables[0].Rows[0][0] != DBNull.Value) { foreach (DataRow dr in ds.Tables[0].Rows) { float tmp = 0; if (float.Parse(dr[2].ToString()) != 0) { tmp = (float.Parse(dr[1].ToString()) - float.Parse(dr[2].ToString())) * 100 / float.Parse(dr[2].ToString()); dr["VAR"] = Convert.ToInt32(tmp).ToString() + "%"; } } } } catch { log.WriteLog(LogUtility.LogErrorLevel.LOG_ERROR, "Format string to float Error."); Response.Redirect("~/Admin/AdminError.aspx"); } for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { BoundField bf = new BoundField(); bf.DataField = ds.Tables[0].Columns[i].ColumnName.ToString(); bf.HeaderText = ds.Tables[0].Columns[i].Caption.ToString(); bf.ItemStyle.HorizontalAlign = HorizontalAlign.Right; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Right; if (i == 0) { bf.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Left; } bf.ReadOnly = true; bf.ReadOnly = true; gv.Columns.Add(bf); } gv.DataSource = ds; DataRow drSum = ds.Tables[0].NewRow(); DataRow[] rows = ds.Tables[0].Select(); float[] Sum = new float[20]; for (int j = 1; j < ds.Tables[0].Columns.Count - 1; j++) { Sum[j] = 0; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Sum[j] += float.Parse(ds.Tables[0].Rows[i][j].ToString()); } } for (int i = 0; i < ds.Tables[0].Columns.Count - 1; i++) { if (i == 0) { drSum[0] = "TTL/" + getAbbrBySalesOrg(getSalesOrgID()); } else { drSum[i] = Sum[i].ToString(); } } ds.Tables[0].Rows.InsertAt(drSum, 0); if (float.Parse(ds.Tables[0].Rows[0][2].ToString()) != 0) { ds.Tables[0].Rows[0][3] = (Convert.ToInt32((float.Parse(ds.Tables[0].Rows[0][1].ToString()) - float.Parse(ds.Tables[0].Rows[0][2].ToString())) * 100 / float.Parse(ds.Tables[0].Rows[0][2].ToString()))).ToString() + "%"; } gv.DataBind(); } return gv; }
protected void AddDynamicControls(ContentChannel channel) { // Remove all columns gContentChannelItems.Columns.Clear(); phAttributeFilters.Controls.Clear(); if (channel != null) { // Add Reorder column var reorderField = new ReorderField(); gContentChannelItems.Columns.Add(reorderField); // Add Title column var titleField = new BoundField(); titleField.DataField = "Title"; titleField.HeaderText = "Title"; titleField.SortExpression = "Title"; gContentChannelItems.Columns.Add(titleField); // Add Attribute columns int entityTypeId = EntityTypeCache.Get(typeof(Rock.Model.ContentChannelItem)).Id; string channelId = channel.Id.ToString(); string channelTypeId = channel.ContentChannelTypeId.ToString(); foreach (var attribute in AvailableAttributes) { var control = attribute.FieldType.Field.FilterControl(attribute.QualifierValues, "filter_" + attribute.Id.ToString(), false, Rock.Reporting.FilterMode.SimpleFilter); if (control != null) { if (control is IRockControl) { var rockControl = (IRockControl)control; rockControl.Label = attribute.Name; rockControl.Help = attribute.Description; phAttributeFilters.Controls.Add(control); } else { var wrapper = new RockControlWrapper(); wrapper.ID = control.ID + "_wrapper"; wrapper.Label = attribute.Name; wrapper.Controls.Add(control); phAttributeFilters.Controls.Add(wrapper); } string savedValue = gfFilter.GetUserPreference(MakeKeyUniqueToChannel(channel.Id, attribute.Key)); if (!string.IsNullOrWhiteSpace(savedValue)) { try { var values = JsonConvert.DeserializeObject <List <string> >(savedValue); attribute.FieldType.Field.SetFilterValues(control, attribute.QualifierValues, values); } catch { // intentionally ignore } } } string dataFieldExpression = attribute.Key; bool columnExists = gContentChannelItems.Columns.OfType <AttributeField>().FirstOrDefault(a => a.DataField.Equals(dataFieldExpression)) != null; if (!columnExists) { AttributeField boundField = new AttributeField(); boundField.DataField = dataFieldExpression; boundField.AttributeId = attribute.Id; boundField.HeaderText = attribute.Name; boundField.ItemStyle.HorizontalAlign = attribute.FieldType.Field.AlignValue; gContentChannelItems.Columns.Add(boundField); } } if (channel.ContentChannelType.DateRangeType != ContentChannelDateType.NoDates) { RockBoundField startDateTimeField; RockBoundField expireDateTimeField; if (channel.ContentChannelType.IncludeTime) { startDateTimeField = new DateTimeField(); expireDateTimeField = new DateTimeField(); } else { startDateTimeField = new DateField(); expireDateTimeField = new DateField(); } startDateTimeField.DataField = "StartDateTime"; startDateTimeField.HeaderText = channel.ContentChannelType.DateRangeType == ContentChannelDateType.DateRange ? "Start" : "Date"; startDateTimeField.SortExpression = "StartDateTime"; gContentChannelItems.Columns.Add(startDateTimeField); expireDateTimeField.DataField = "ExpireDateTime"; expireDateTimeField.HeaderText = "Expire"; expireDateTimeField.SortExpression = "ExpireDateTime"; if (channel.ContentChannelType.DateRangeType == ContentChannelDateType.DateRange) { gContentChannelItems.Columns.Add(expireDateTimeField); } } if (!channel.ContentChannelType.DisablePriority) { // Priority column var priorityField = new BoundField(); priorityField.DataField = "Priority"; priorityField.HeaderText = "Priority"; priorityField.SortExpression = "Priority"; priorityField.DataFormatString = "{0:N0}"; priorityField.ItemStyle.HorizontalAlign = HorizontalAlign.Right; gContentChannelItems.Columns.Add(priorityField); } // Status column if (channel.RequiresApproval) { var statusField = new BoundField(); gContentChannelItems.Columns.Add(statusField); statusField.DataField = "Status"; statusField.HeaderText = "Status"; statusField.SortExpression = "Status"; statusField.HtmlEncode = false; } // Add occurrences Count column var occurrencesField = new BoolField(); occurrencesField.DataField = "Occurrences"; occurrencesField.HeaderText = "Event Occurrences"; gContentChannelItems.Columns.Add(occurrencesField); // Add Created By column var createdByPersonNameField = new BoundField(); createdByPersonNameField.DataField = "CreatedByPersonName"; createdByPersonNameField.HeaderText = "Created By"; createdByPersonNameField.HtmlEncode = false; gContentChannelItems.Columns.Add(createdByPersonNameField); // Add Tag Field if (channel.IsTaggingEnabled) { var tagField = new BoundField(); gContentChannelItems.Columns.Add(tagField); tagField.DataField = "Tags"; tagField.HeaderText = "Tags"; tagField.ItemStyle.CssClass = "taglist"; tagField.HtmlEncode = false; } bool canEditChannel = channel.IsAuthorized(Rock.Security.Authorization.EDIT, CurrentPerson); gContentChannelItems.Actions.ShowAdd = canEditChannel; gContentChannelItems.IsDeleteEnabled = canEditChannel; if (canEditChannel) { var deleteField = new DeleteField(); gContentChannelItems.Columns.Add(deleteField); deleteField.Click += gContentChannelItems_Delete; } } }
protected void bindDataTotalByDateByProduct(GridView gv, string bookingY, string deliverY) { DataSet ds_product = getProductBySegment(getSegmentID()); DataSet ds = getBookingDataTotalByDateByProduct(ds_product, getSegmentID(), getSalesOrgID(), bookingY, deliverY); if (ds != null) { gv.Width = Unit.Pixel(650); gv.AutoGenerateColumns = false; gv.AllowPaging = false; gv.Visible = true; for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { BoundField bf = new BoundField(); bf.DataField = ds.Tables[0].Columns[i].ColumnName.ToString(); bf.HeaderText = ds.Tables[0].Columns[i].Caption.ToString(); bf.ItemStyle.HorizontalAlign = HorizontalAlign.Right; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Right; if (i == 0) { bf.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Left; bf.ItemStyle.Width = 200; } bf.ReadOnly = true; gv.Columns.Add(bf); } gv.AllowSorting = true; gv.DataSource = ds.Tables[0]; DataRow drSum = ds.Tables[0].NewRow(); DataRow[] rows = ds.Tables[0].Select(); float[] Sum = new float[20]; for (int j = 1; j < ds.Tables[0].Columns.Count; j++) { Sum[j] = 0; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Sum[j] += float.Parse(ds.Tables[0].Rows[i][j].ToString()); } } for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { if (i == 0) { drSum[0] = "TTL/" + getAbbrBySalesOrg(getSalesOrgID()); } else { drSum[i] = Sum[i].ToString(); } } ds.Tables[0].Rows.InsertAt(drSum, 0); gv.DataBind(); } else gv.Visible = false; }
private DataTable ShowGrid() { DataTable dt = this.bfield.GetModelFieldList(DataConverter.CLng(this.HdnModelID.Value)).Tables[0]; DetailsView1.AutoGenerateRows = false; DataControlFieldCollection dcfc = DetailsView1.Fields; dcfc.Clear(); BoundField bf2 = new BoundField(); bf2.HeaderText = "ID"; bf2.DataField = "ID"; bf2.HeaderStyle.Width = Unit.Percentage(15); bf2.HeaderStyle.CssClass = "tdbgleft"; bf2.HeaderStyle.HorizontalAlign = HorizontalAlign.Center; bf2.ItemStyle.HorizontalAlign = HorizontalAlign.Left; dcfc.Add(bf2); BoundField bf5 = new BoundField(); bf5.HeaderText = "用户名"; bf5.DataField = "PubUserName"; bf5.HeaderStyle.CssClass = "tdbgleft"; bf5.HeaderStyle.Width = Unit.Percentage(15); bf5.HeaderStyle.HorizontalAlign = HorizontalAlign.Center; bf5.ItemStyle.HorizontalAlign = HorizontalAlign.Left; dcfc.Add(bf5); BoundField bf1 = new BoundField(); bf1.HeaderText = "标题"; bf1.DataField = "PubTitle"; bf1.HeaderStyle.CssClass = "tdbgleft"; bf1.HeaderStyle.Width = Unit.Percentage(15); bf1.HeaderStyle.HorizontalAlign = HorizontalAlign.Center; bf1.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bf1.HtmlEncode = false; dcfc.Add(bf1); BoundField bfa = new BoundField(); bfa.HeaderText = "内容"; bfa.DataField = "PubContent"; bfa.HeaderStyle.CssClass = "tdbgleft"; bfa.HeaderStyle.Width = Unit.Percentage(15); bfa.HeaderStyle.HorizontalAlign = HorizontalAlign.Center; bfa.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bfa.HtmlEncode = false; dcfc.Add(bfa); BoundField bf3 = new BoundField(); bf3.HeaderText = "IP地址"; bf3.DataField = "PubIP"; bf3.HeaderStyle.CssClass = "tdbgleft"; bf3.HeaderStyle.Width = Unit.Percentage(15); bf3.HeaderStyle.HorizontalAlign = HorizontalAlign.Center; bf3.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bf3.HtmlEncode = false; dcfc.Add(bf3); BoundField bf4 = new BoundField(); bf4.HeaderText = "添加时间"; bf4.DataField = "PubAddTime"; bf4.HeaderStyle.CssClass = "tdbgleft"; bf4.HeaderStyle.Width = Unit.Percentage(15); bf4.HeaderStyle.HorizontalAlign = HorizontalAlign.Center; bf4.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bf4.HtmlEncode = false; dcfc.Add(bf4); foreach (DataRow dr in dt.Rows) { BoundField bf = new BoundField(); bf.HeaderText = dr["FieldAlias"].ToString(); bf.DataField = dr["FieldName"].ToString(); bf.HeaderStyle.Width = Unit.Percentage(15); bf.HeaderStyle.CssClass = "tdbgleft"; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Center; bf.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bf.HtmlEncode = false; dcfc.Add(bf); } return(dt); }
private void grid() { Int32 i; for (i = 0; i < DropDownList3.Items.Count+2; i++) { if (i == 0) { BoundField bf = new BoundField(); bf.DataField = "s_id"; bf.HeaderText = "Student ID"; GridView1.Columns.Add(bf); } if (i == 1) { BoundField bf = new BoundField(); bf.DataField = "s_name"; bf.HeaderText = "Student Name"; GridView1.Columns.Add(bf); } if(i>1) { BoundField bf = new BoundField(); //bf.DataField = "NameField"; bf.HeaderText = DropDownList3.Items[i-2].ToString(); GridView1.Columns.Add(bf); } } }
/// <summary> /// Adds the attribute columns. /// </summary> private void AddDynamicControls() { // Clear the filter controls phAttributeFilters.Controls.Clear(); // Remove attribute columns foreach (var column in gEventCalendarItems.Columns.OfType <AttributeField>().ToList()) { gEventCalendarItems.Columns.Remove(column); } // Remove status columns foreach (var column in gEventCalendarItems.Columns.OfType <BoundField>() .Where(c => c.DataField == "Instances" || c.DataField == "Status" || c.DataField == "ApprovalStatus") .ToList()) { gEventCalendarItems.Columns.Remove(column); } // Remove Delete column foreach (var column in gEventCalendarItems.Columns.OfType <DeleteField>().ToList()) { gEventCalendarItems.Columns.Remove(column); } if (AvailableAttributes != null) { foreach (var attribute in AvailableAttributes) { var control = attribute.FieldType.Field.FilterControl(attribute.QualifierValues, "filter_" + attribute.Id.ToString(), false, Rock.Reporting.FilterMode.SimpleFilter); if (control != null) { if (control is IRockControl) { var rockControl = (IRockControl)control; rockControl.Label = attribute.Name; rockControl.Help = attribute.Description; phAttributeFilters.Controls.Add(control); } else { var wrapper = new RockControlWrapper(); wrapper.ID = control.ID + "_wrapper"; wrapper.Label = attribute.Name; wrapper.Controls.Add(control); phAttributeFilters.Controls.Add(wrapper); } string savedValue = rFilter.GetUserPreference(MakeKeyUniqueToEventCalendar(attribute.Key)); if (!string.IsNullOrWhiteSpace(savedValue)) { try { var values = JsonConvert.DeserializeObject <List <string> >(savedValue); attribute.FieldType.Field.SetFilterValues(control, attribute.QualifierValues, values); } catch { } } } string dataFieldExpression = attribute.Key; bool columnExists = gEventCalendarItems.Columns.OfType <AttributeField>().FirstOrDefault(a => a.DataField.Equals(dataFieldExpression)) != null; if (!columnExists) { AttributeField boundField = new AttributeField(); boundField.DataField = dataFieldExpression; boundField.AttributeId = attribute.Id; boundField.HeaderText = attribute.Name; var attributeCache = Rock.Web.Cache.AttributeCache.Get(attribute.Id); if (attributeCache != null) { boundField.ItemStyle.HorizontalAlign = attributeCache.FieldType.Field.AlignValue; } gEventCalendarItems.Columns.Add(boundField); } } } // Add occurrences Count column var occurrencesField = new BadgeField(); occurrencesField.DangerMin = int.MaxValue; occurrencesField.WarningMin = 0; occurrencesField.WarningMax = 0; occurrencesField.InfoMin = 1; occurrencesField.InfoMax = int.MaxValue; occurrencesField.DataField = "Occurrences"; occurrencesField.HeaderText = "Occurrences"; occurrencesField.HtmlEncode = false; gEventCalendarItems.Columns.Add(occurrencesField); // Add Status column var statusField = new BoundField(); statusField.DataField = "Status"; statusField.SortExpression = "EventItem.IsActive"; statusField.HeaderText = "Status"; statusField.HtmlEncode = false; gEventCalendarItems.Columns.Add(statusField); // Add Approval Status column var approvalStatusField = new BoundField(); approvalStatusField.DataField = "ApprovalStatus"; approvalStatusField.SortExpression = "EventItem.IsApproved"; approvalStatusField.HeaderText = "Approval Status"; approvalStatusField.HtmlEncode = false; gEventCalendarItems.Columns.Add(approvalStatusField); // Add delete column if (_canEdit) { var deleteField = new DeleteField(); gEventCalendarItems.Columns.Add(deleteField); deleteField.Click += DeleteEventCalendarItem_Click; } }
protected void bound(string nombreCampo, string nombreLabel) { if (dt.Rows[0][nombreCampo].ToString() != "0" && dt.Rows[0][nombreCampo] != null && dt.Rows[0][nombreCampo].ToString() != "") { ////if (nombreCampo == "PrecioAlquiler") ////{ //// dt.Rows[0].BeginEdit(); //// dt.Rows[0][nombreCampo] = Moneda(dt.Rows[0]["MonedaAlquiler"].ToString()) + " " + precio(dt.Rows[0][nombreCampo].ToString()); //// dt.Rows[0].EndEdit(); ////} ////else if (nombreCampo == "PrecioVenta") ////{ //// dt.Rows[0].SetModified(); //// dt.Rows[0][nombreCampo] = Moneda(dt.Rows[0]["MonedaVenta"].ToString()) + " " + precio(dt.Rows[0][nombreCampo].ToString()); ////} BoundField bound = new BoundField(); HiddenFieldimagen.Value = IdInmueble; HiddenFieldFechaAlta.Value = dt.Rows[0]["FechaAlta"].ToString(); HiddenFieldFechaActualiza.Value = dt.Rows[0]["FechaActualiza"].ToString(); HiddenFieldNombreInmobiliaria.Value = dt.Rows[0]["NombreInmobiliaria"].ToString(); HiddenFieldNombreUsuario.Value = dt.Rows[0]["NombreUsuario"].ToString(); HiddenFieldApellidoUsuario.Value = dt.Rows[0]["ApellidoUsuario"].ToString(); HiddenFieldTelefonoUsuario.Value = dt.Rows[0]["TelefonoUsuario"].ToString(); HiddenFieldCelularUsuario.Value = dt.Rows[0]["CelularUsuario"].ToString(); HiddenFieldMailUsuario.Value = dt.Rows[0]["MailUsuario"].ToString(); HiddenFieldObservaciones.Value = dt.Rows[0]["Observaciones"].ToString(); HiddenFieldimagen.Value = this.Page.ResolveClientUrl(IdInmueble + "-" + "01" + "_thumb.jpg"); HiddenFieldgooglemapsimage.Value = "http://maps.googleapis.com/maps/api/staticmap?markers=" + GoogleMap1.Latitude.ToString().Replace(",", ".") + "," + GoogleMap1.Longitude.ToString().Replace(",", ".") + "&zoom=15&size=260x194&sensor=false"; if (nombreCampo == "PrecioVenta") { if (dt.Rows[0]["MonedaVenta"].ToString() == "P") { bound.HeaderText = nombreLabel + " (ARS$)"; } else if (dt.Rows[0]["MonedaVenta"].ToString() == "D") { bound.HeaderText = nombreLabel + " (US$)"; } precioVentaMoneda = bound.HeaderText.ToString(); } else if (nombreCampo == "PrecioVenta2") { if (dt.Rows[0]["MonedaVenta2"].ToString() == "P") { bound.HeaderText = nombreLabel + " (ARS$)"; } else if (dt.Rows[0]["MonedaVenta2"].ToString() == "D") { bound.HeaderText = nombreLabel + " (US$)"; } precioVenta2Moneda = bound.HeaderText.ToString(); } else if (nombreCampo == "PrecioAlquiler") { if (dt.Rows[0]["MonedaAlquiler"].ToString() == "P") { bound.HeaderText = nombreLabel + " (ARS$)"; } else if (dt.Rows[0]["MonedaAlquiler"].ToString() == "D") { bound.HeaderText = nombreLabel + " (US$)"; } precioAlquilerMoneda = bound.HeaderText.ToString(); HiddenFieldPrecioAlquiler.Value = dt.Rows[0]["PrecioAlquiler"].ToString(); HiddenFieldPrecioAlquilerLabel.Value = precioAlquilerMoneda.ToString(); } else { bound.HeaderText = nombreLabel; } bound.DataField = nombreCampo; bound.HeaderStyle.HorizontalAlign = HorizontalAlign.Right; bound.ItemStyle.HorizontalAlign = HorizontalAlign.Left; DetailsView1.Fields.Add(bound); } }
private void BindGrid() { BoundField theCol0 = new BoundField(); theCol0.HeaderText = "Appointment Date"; theCol0.DataField = "Appointment Date"; theCol0.SortExpression = "Appointment Date"; theCol0.ItemStyle.CssClass = "textstyle"; theCol0.ReadOnly = true; BoundField theCol1 = new BoundField(); theCol1.HeaderText = "Met Date"; theCol1.DataField = "Met Date"; theCol1.SortExpression = "Met Date"; theCol1.ItemStyle.CssClass = " textstyle"; theCol1.ReadOnly = true; BoundField theCol2 = new BoundField(); theCol2.HeaderText = "Status"; theCol2.DataField = "Status"; theCol2.ItemStyle.CssClass = "textstyle"; theCol2.SortExpression = "Status"; theCol2.ItemStyle.Font.Underline = true; theCol2.ReadOnly = true; BoundField theCol3 = new BoundField(); theCol3.HeaderText = "Purpose"; theCol3.ItemStyle.CssClass = "Purpose"; theCol3.DataField = "Purpose"; theCol3.SortExpression = "Purpose"; theCol3.ReadOnly = true; BoundField theCol4 = new BoundField(); theCol4.HeaderText = "Appdate"; theCol4.ItemStyle.CssClass = "textstyle"; theCol4.DataField = "Appdate"; theCol4.SortExpression = "Appdate"; theCol4.ReadOnly = true; BoundField theCol5 = new BoundField(); theCol5.HeaderText = "LocationName"; theCol5.ItemStyle.CssClass = "textstyle"; theCol5.DataField = "LocationName"; theCol5.SortExpression = "LocationName"; theCol5.ReadOnly = true; ButtonField theBtn = new ButtonField(); theBtn.ButtonType = ButtonType.Link; theBtn.CommandName = "Select"; theBtn.HeaderStyle.CssClass = "textstylehidden"; theBtn.ItemStyle.CssClass = "textstylehidden"; grdSearchResult.Columns.Add(theCol0); grdSearchResult.Columns.Add(theCol1); grdSearchResult.Columns.Add(theCol2); grdSearchResult.Columns.Add(theCol3); grdSearchResult.Columns.Add(theCol4); grdSearchResult.Columns.Add(theCol5); grdSearchResult.Columns.Add(theBtn); grdSearchResult.DataBind(); grdSearchResult.Columns[4].Visible = false; }
protected GridView bindDataByOperation(DataSet ds, GridView gv, string header, DataSet ds_budget) { if (ds != null && ds.Tables[0].Rows.Count > 0) { gv.Visible = true; gv.AutoGenerateColumns = false; gv.Width = Unit.Pixel(600); gv.Columns.Clear(); //Calculate the total column of next year. ds.Tables[0].Columns.Add("Total"); if (ds.Tables[0].Rows[0][0] != DBNull.Value) { foreach (DataRow dr in ds.Tables[0].Rows) { float tmp = 0; for (int count2 = 1; count2 < ds.Tables[0].Columns.Count - 1; count2++) { tmp += float.Parse(dr[count2].ToString()); } dr["Total"] = tmp.ToString(); } } for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { BoundField bf = new BoundField(); bf.DataField = ds.Tables[0].Columns[i].ColumnName.ToString(); bf.HeaderText = ds.Tables[0].Columns[i].Caption.ToString(); bf.ItemStyle.HorizontalAlign = HorizontalAlign.Right; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Right; if (i == 0) { bf.ItemStyle.HorizontalAlign = HorizontalAlign.Left; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Left; bf.ItemStyle.Width = 150; } gv.Columns.Add(bf); } gv.Caption = header; gv.CaptionAlign = TableCaptionAlign.Left; gv.DataSource = ds; if (header == "") { DataRow drSum = ds.Tables[0].NewRow(); DataRow[] rows = ds.Tables[0].Select(); float[] Sum = new float[20]; for (int j = 1; j < ds.Tables[0].Columns.Count - 1; j++) { if (ds_budget.Tables[0].Rows.Count != 0) Sum[j] = float.Parse(ds_budget.Tables[0].Rows[0][j].ToString().Trim()); else Sum[j] = 0; } float tmp = 0; for (int i = 0; i < ds.Tables[0].Columns.Count - 1; i++) { if (i == 0) { drSum[0] = meeting.getnextyear() + "-BDGT"; } else { drSum[i] = Sum[i]; tmp += Sum[i]; } } drSum[ds.Tables[0].Columns.Count - 1] = tmp.ToString().Trim(); ds.Tables[0].Rows.InsertAt(drSum, ds.Tables[0].Rows.Count); } gv.DataBind(); } else gv.Visible = false; return gv; }
private void AtualizaGrelhaJogos() { gvJogos.Columns.Clear(); gvJogos.DataSource = null; gvJogos.DataBind(); DataTable dados = BaseDados.Instance.ListaJogos(); if (dados == null || dados.Rows.Count == 0) { return; } DataColumn dcRemover = new DataColumn(); dcRemover.ColumnName = "Remover"; dcRemover.DataType = Type.GetType("System.String"); dados.Columns.Add(dcRemover); DataColumn dcEditar = new DataColumn(); dcEditar.ColumnName = "Editar"; dcEditar.DataType = Type.GetType("System.String"); dados.Columns.Add(dcEditar); gvJogos.DataSource = dados; gvJogos.AutoGenerateColumns = false; HyperLinkField hlRemover = new HyperLinkField(); hlRemover.HeaderText = "Remover"; hlRemover.DataTextField = "Remover"; hlRemover.Text = "Remover jogo"; hlRemover.DataNavigateUrlFormatString = "removerjogo.aspx?id_jogo={0}"; hlRemover.DataNavigateUrlFields = new string[] { "id_jogo" }; gvJogos.Columns.Add(hlRemover); HyperLinkField hlEditar = new HyperLinkField(); hlEditar.HeaderText = "Editar"; hlEditar.DataTextField = "Editar"; hlEditar.Text = "Editar jogo"; hlEditar.DataNavigateUrlFormatString = "editarjogo.aspx?id_jogo={0}"; hlEditar.DataNavigateUrlFields = new string[] { "id_jogo" }; gvJogos.Columns.Add(hlEditar); BoundField bfIdJogo = new BoundField(); bfIdJogo.DataField = "id_jogo"; bfIdJogo.HeaderText = "NºJogo"; gvJogos.Columns.Add(bfIdJogo); BoundField bfNome = new BoundField(); bfNome.DataField = "nome"; bfNome.HeaderText = "Nome"; gvJogos.Columns.Add(bfNome); BoundField bfPreco = new BoundField(); bfPreco.DataField = "preco"; bfPreco.HeaderText = "Preço"; gvJogos.Columns.Add(bfPreco); BoundField bfDescricao = new BoundField(); bfDescricao.DataField = "descricao"; bfDescricao.HeaderText = "Descrição"; gvJogos.Columns.Add(bfDescricao); BoundField bfAvaliacao = new BoundField(); bfAvaliacao.DataField = "avaliacao"; bfAvaliacao.HeaderText = "Avaliação"; gvJogos.Columns.Add(bfAvaliacao); BoundField bfSo = new BoundField(); bfSo.DataField = "sistema_operativo"; bfSo.HeaderText = "Sistema Operativo"; gvJogos.Columns.Add(bfSo); BoundField bfTag = new BoundField(); bfTag.DataField = "tag"; bfTag.HeaderText = "Tag"; gvJogos.Columns.Add(bfTag); BoundField bfEmpresa = new BoundField(); bfEmpresa.DataField = "empresa"; bfEmpresa.HeaderText = "Empresa"; gvJogos.Columns.Add(bfEmpresa); BoundField bfStock = new BoundField(); bfStock.DataField = "stock"; bfStock.HeaderText = "Stock"; gvJogos.Columns.Add(bfStock); BoundField bfAno = new BoundField(); bfAno.DataField = "ano"; bfAno.HeaderText = "Ano"; gvJogos.Columns.Add(bfAno); BoundField bfEstado = new BoundField(); bfEstado.DataField = "estado"; bfEstado.HeaderText = "Estado"; gvJogos.Columns.Add(bfEstado); //capa ImageField ifCapa = new ImageField(); ifCapa.HeaderText = "Capa"; int rand = new Random().Next(999999999); ifCapa.DataImageUrlFormatString = "~/Imagens/{0}.jpg?" + rand; ifCapa.DataImageUrlField = "id_jogo"; ifCapa.ControlStyle.Width = 100; gvJogos.Columns.Add(ifCapa); //databind gvJogos.DataBind(); }