protected void Page_Load(object sender, EventArgs e) { var createdColumn = new BoundField(); createdColumn.DataField = "Created"; createdColumn.HeaderText = "Datum"; createdColumn.DataFormatString = "{0:dd-MM-yyyy}"; var deliveryPriceColumn = new BoundField(); deliveryPriceColumn.HeaderText = "Verzendkosten"; deliveryPriceColumn.DataField = "DeliveryPrice"; deliveryPriceColumn.DataFormatString = "{0:C}"; var viewColumn = new HyperLinkField(); viewColumn.Text = "Bekijk"; viewColumn.Target = "_blank"; viewColumn.DataNavigateUrlFormatString = this.Request.Url.AbsolutePath + "?page=Order&order={0}"; viewColumn.DataNavigateUrlFields = new[] { "Id" }; var pdfColumn = new HyperLinkField(); pdfColumn.Text = "PDF"; pdfColumn.Target = "_blank"; pdfColumn.DataNavigateUrlFormatString = this.Request.Url.AbsolutePath + "?page=Order&method=Pdf&order={0}"; pdfColumn.DataNavigateUrlFields = new[] { "Id" }; this.GridViewOrders.Columns.Add(createdColumn); this.GridViewOrders.Columns.Add(deliveryPriceColumn); this.GridViewOrders.Columns.Add(viewColumn); this.GridViewOrders.Columns.Add(pdfColumn); this.GridViewOrders.AutoGenerateColumns = false; this.GridViewOrders.DataSource = new BusinessLogicLayer.Order().GetAll(); this.GridViewOrders.DataBind(); }
protected void OnInit_gridFila(object sender, EventArgs e) { if (!Page.IsPostBack) Session.Remove("acessoMedico"); bool acessoMedico; if (Session["acessoMedico"] == null) { IUsuarioProfissionalUrgence iUsuarioProfissional = Factory.GetInstance<IUsuarioProfissionalUrgence>(); Usuario usuario = (Usuario)Session["Usuario"]; acessoMedico = iUsuarioProfissional.VerificarAcessoMedico(usuario.Codigo, "REALIZAR_CONSULTA_MEDICA", usuario.Unidade.CNES); Session["acessoMedico"] = acessoMedico; } else acessoMedico = (bool)Session["acessoMedico"]; if (!acessoMedico) { gridFila.Columns.RemoveAt(1); BoundField nomepaciente = new BoundField(); nomepaciente.DataField = "NomePacienteToString"; nomepaciente.HeaderText = "Paciente"; nomepaciente.ItemStyle.HorizontalAlign = HorizontalAlign.Center; nomepaciente.ItemStyle.Width = Unit.Pixel(280); gridFila.Columns.Insert(1, nomepaciente); } }
/// <summary> /// 数组方式 /// </summary> /// <param name="dataList"></param> /// <param name="fields"></param> /// <param name="headTexts"></param> /// <param name="title"></param> /// <param name="TableName"></param> public static void ExportToExcel(DataTable dataList, string[] fields, string[] headTexts, string title, string TableName) { var gvw = new GridView(); int ColCount, i; //如果筛选的字段和对应的列头名称个数相对的情况下只导出指定的字段 if (fields.Length != 0 && fields.Length == headTexts.Length) { ColCount = fields.Length; gvw.AutoGenerateColumns = false; for (i = 0; i < ColCount; i++) { var bf = new BoundField(); bf.DataField = fields[i]; bf.HeaderText = headTexts[i]; gvw.Columns.Add(bf); } } else { gvw.AutoGenerateColumns = true; } gvw.DataSource = dataList; SetStype(gvw); // gvw.Columns[] gvw.DataBind(); ExportToExcel(gvw, title, TableName); }
public void can_initalise() { /* * prepare a definied testable structure */ DataControlFieldCollection columns = new DataControlFieldCollection(); Dictionary<string, bool> setupConfig = TrackListing.getKeyboardConfiguration(new HashedSet<string>(), new HashedSet<string>()); foreach(KeyValuePair<string, bool> entry in setupConfig) { BoundField dummy = new BoundField(); dummy.HeaderText = entry.Key; columns.Add(dummy); } Assert.AreEqual(15, columns.Count); foreach(DataControlField dummy in columns) Assert.IsTrue(dummy.Visible); /* * ... more definied structure */ string disabledColumn = Track.Property.Titel.ToString(); string fadedColumn = Track.Property.Year.ToString(); ISet<string> disabled = new HashedSet<string>(new string[] { disabledColumn }); ISet<string> faded = new HashedSet<string>(new string[] { fadedColumn }); Dictionary<string, bool> testConfig = TrackListing.getKeyboardConfiguration(disabled, faded); Assert.AreEqual(14, testConfig.Count); foreach(KeyValuePair<string, bool> entry in testConfig) { if(entry.Key.Equals(fadedColumn)) Assert.IsTrue(entry.Value); else Assert.IsFalse(entry.Value); } StateBag stateBag = new StateBag(); /* * white-box expectations */ Expect.Once.On(view).GetProperty("StateBag").Will(Return.Value(stateBag)); Expect.Once.On(view).GetProperty("DisabledColumns").Will(Return.Value(disabled)); Expect.Once.On(view).GetProperty("FadedColumns").Will(Return.Value(faded)); Expect.Once.On(view).GetProperty("Columns").Will(Return.Value(columns)); /* * do the testing */ presenter.initialise(); Assert.AreEqual(SortDirection.Ascending, (SortDirection)StateBagTask.getSortDirection(stateBag)); Assert.AreEqual(Track.Property.Titel, (Track.Property)StateBagTask.getSortExpression(stateBag)); foreach(DataControlField dummy in columns) { if(dummy.HeaderText.Equals(disabledColumn) || dummy.HeaderText.Equals(fadedColumn)) Assert.IsFalse(dummy.Visible); else Assert.IsTrue(dummy.Visible); } }
private void InitControls() { BoundField column = new BoundField(); column.HeaderText = GetLocalString("ColumnTransferName"); column.DataField = "TransferName"; gvReport.Columns.Add(column); column = new BoundField(); column.HeaderText = GetLocalString("ColumnSourceAccountName"); column.DataField = "SourceAccountName"; gvReport.Columns.Add(column); column = new BoundField(); column.HeaderText = GetLocalString("ColumnTargetAccountName"); column.DataField = "TargetAccountName"; gvReport.Columns.Add(column); column = new BoundField(); column.HeaderText = GetLocalString("ColumnTransactionDate"); column.DataField = "TransactionDate"; gvReport.Columns.Add(column); column = new BoundField(); column.HeaderText = GetLocalString("ColumnTransactionAmount"); column.DataField = "TransactionAmount"; gvReport.Columns.Add(column); }
protected void GenerateColumns() { // remove all previous rows because we set EnableViewState="True" gvScholPrograms.Columns.Clear(); /* set ScholID as the primary keys of each row */ gvScholPrograms.DataKeyNames = new string[] { "ScholID" }; /* 1st column = Scholarship Name */ HyperLinkField hlf = new HyperLinkField(); hlf.HeaderText = TextCode(10421); hlf.HeaderStyle.CssClass = "leftAlign"; hlf.SortExpression = "ScholName"; hlf.DataTextField = "ScholName"; hlf.DataNavigateUrlFields = new string[] { "ScholID" }; hlf.DataNavigateUrlFormatString = "ScholAppDetailsPrinterFriendly.aspx?LoginID=" + LoginID + "&ScholID={0}"; hlf.ItemStyle.CssClass = "leftAlign"; gvScholPrograms.Columns.Add(hlf); /* 2nd column = Deadline */ BoundField bf2 = new BoundField(); bf2.HeaderText = TextCode(10422); bf2.SortExpression = "DeadlineSorting"; bf2.DataField = "Deadline"; bf2.ItemStyle.CssClass = "leftAlign"; gvScholPrograms.Columns.Add(bf2); /* 3rd column = Status */ BoundField bf3 = new BoundField(); bf3.HeaderText = TextCode(10423); bf3.SortExpression = "Status"; bf3.DataField = "Status"; bf3.ItemStyle.CssClass = "leftAlign"; gvScholPrograms.Columns.Add(bf3); }
private void LoadGridViewListaUsuarios() { UsuarioNegocio usuarioNegocio = new UsuarioNegocio(); List<Usuario> listUsuarios = usuarioNegocio.ObterTodosUsuarios(); GridViewListaUsuarios.Columns.Clear(); GridViewListaUsuarios.DataSource = listUsuarios; GridViewListaUsuarios.AutoGenerateColumns = false; BoundField bfNomeUsuario = new BoundField(); bfNomeUsuario.DataField = "Nome"; bfNomeUsuario.HeaderText = "Nome"; GridViewListaUsuarios.Columns.Add(bfNomeUsuario); BoundField bfLogin = new BoundField(); bfLogin.DataField = "Login"; bfLogin.HeaderText = "Login"; GridViewListaUsuarios.Columns.Add(bfLogin); CommandField cmdField = new CommandField(); cmdField.ButtonType = ButtonType.Image; cmdField.DeleteImageUrl = "Icons/cross.png"; cmdField.EditImageUrl = "Icons/page_edit.png"; //cmdField.SelectImageUrl = "Icons/money_add.png"; cmdField.ShowDeleteButton = true; cmdField.ShowEditButton = true; //cmdField.ShowSelectButton = true; cmdField.EditText = "Editar Usuario"; cmdField.DeleteText = "Remover Usuario"; GridViewListaUsuarios.Columns.Add(cmdField); GridViewListaUsuarios.DataBind(); }
private void FOnline() { if (!base.IsPostBack) { this.OdsStat.SelectMethod = "GetStatOnlineList"; this.OdsStat.SelectCountMethod = "GetTotalStatOnline"; this.ExtendedGridView1.Columns.Clear(); System.Web.UI.WebControls.BoundField field = new System.Web.UI.WebControls.BoundField(); System.Web.UI.WebControls.BoundField field2 = new System.Web.UI.WebControls.BoundField(); System.Web.UI.WebControls.BoundField field3 = new System.Web.UI.WebControls.BoundField(); System.Web.UI.WebControls.BoundField field4 = new System.Web.UI.WebControls.BoundField(); System.Web.UI.WebControls.BoundField field5 = new System.Web.UI.WebControls.BoundField(); field.DataField = "id"; field2.DataField = "UserIP"; field4.DataField = "OnTime"; field5.DataField = "LastTime"; field3.DataField = "UserPage"; field.HeaderText = "编号"; field2.HeaderText = "访问者IP"; field4.HeaderText = "上站时间"; field5.HeaderText = "最后刷新时间"; field3.HeaderText = "用户当前浏览页"; this.ExtendedGridView1.EmptyDataText = "当前无人在线!"; this.ExtendedGridView1.Columns.Add(field); this.ExtendedGridView1.Columns.Add(field2); this.ExtendedGridView1.Columns.Add(field4); this.ExtendedGridView1.Columns.Add(field5); this.ExtendedGridView1.Columns.Add(field3); this.LblCount.Text = OtherReport.GetTotalStatOnline().ToString(); this.ExtendedGridView1.DataSourceID = "OdsStat"; } }
protected void Page_Load(object sender, EventArgs e) { var nameColumn = new BoundField(); nameColumn.DataField = "Name"; nameColumn.HeaderText = "Naam"; var heightColumn = new BoundField(); heightColumn.DataField = "Height"; heightColumn.HeaderText = "Hoogte"; var widthColumn = new BoundField(); widthColumn.DataField = "Width"; widthColumn.HeaderText = "Breedte"; var lengthColumn = new BoundField(); lengthColumn.DataField = "Length"; lengthColumn.HeaderText = "Lengte"; var connectionsColumn = new BoundField(); connectionsColumn.DataField = "Connections"; connectionsColumn.HeaderText = "Connecties"; this.GridView.Columns.Add(nameColumn); this.GridView.Columns.Add(heightColumn); this.GridView.Columns.Add(widthColumn); this.GridView.Columns.Add(lengthColumn); this.GridView.Columns.Add(connectionsColumn); this.GridView.AutoGenerateColumns = false; this.GridView.DataSource = this.Ships; this.GridView.DataBind(); }
protected void btnSearch_Click(object sender, EventArgs e) { if (dplstSearchScope.SelectedValue.Equals("all")) { //搜索全部的话,简单刷新即可。 Response.Redirect(Request.Url.ToString()); } else { if (dplstSearchScope.SelectedValue.Equals("alreadyBuy")) { BoundField buyCoursePeople = new BoundField(); buyCoursePeople.DataField = "course_people"; buyCoursePeople.DataFormatString = "{0}"; buyCoursePeople.HeaderText = "购买人数"; //魔法!别动! CourseManageDataSource.SelectCommand = "SELECT [avfun].[dbo].[COURSE].[course_id],[avfun].[dbo].[COURSE].[course_name],[avfun].[dbo].[COURSE].[course_price],[avfun].[dbo].[COURSE].[course_robot_link],[avfun].[dbo].[COURSE].[course_begin_date],[avfun].[dbo].[COURSE].[course_isDeleted],[avfun].[dbo].[COURSE].[course_timestamp],count([user_id]) as course_people" + " FROM [avfun].[dbo].[COURSE],[avfun].[dbo].[UserCourseList]" + " WHERE([avfun].[dbo].[COURSE].[course_id] = order_course )" + " GROUP BY [avfun].[dbo].[COURSE].[course_id],[avfun].[dbo].[COURSE].[course_name],[avfun].[dbo].[COURSE].[course_price],[avfun].[dbo].[COURSE].[course_robot_link],[avfun].[dbo].[COURSE].[course_begin_date],[avfun].[dbo].[COURSE].[course_isDeleted],[avfun].[dbo].[COURSE].[course_timestamp]" + " ORDER BY [avfun].[dbo].[COURSE].[course_begin_date] DESC"; CourseLists.Columns.Add(buyCoursePeople); } else { CourseLists.Columns.RemoveAt(CourseLists.Columns.Count - 1); CourseManageDataSource.SelectCommand = "SELECT [course_id], [course_name], [course_price], [course_begin_date], [course_robot_link], [course_isDeleted] FROM [COURSE] ORDER BY [course_begin_date] DESC"; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { List<SqlParameter> parameterList = new List<SqlParameter>(); SqlDataReader reader = SQLUtilities.RunStoredProcedure("GetAllUsers", parameterList); if (reader != null) { DataTable dt = new DataTable(); BoundField bf = new BoundField(); BoundField bf1 = new BoundField(); dt.Columns.Add("UserID"); dt.Columns.Add("User Name"); while (reader.Read()) { string userID = reader[0].ToString(); string username = reader[1].ToString(); dt.Rows.Add( bf1.DataField.Insert(0, userID), bf.DataField.Insert(0, username) ); } Session["CACHEDATA1"] = dt; GridView1.DataSource = dt; GridView1.DataBind(); } parameterList.Clear(); SqlDataReader reader2 = SQLUtilities.RunStoredProcedure("GetAllSongsAndArtists", parameterList); if (reader2 != null) { DataTable dt = new DataTable(); BoundField bf = new BoundField(); BoundField bf1 = new BoundField(); dt.Columns.Add("Artist"); dt.Columns.Add("Song Title"); while (reader2.Read()) { string artist = reader2[0].ToString(); string song = reader2[1].ToString(); dt.Rows.Add( bf1.DataField.Insert(0, artist), bf.DataField.Insert(0, song) ); } Session["CACHEDATA1"] = dt; GridView2.DataSource = dt; GridView2.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { LinkButton eas_pesquisarcnes = this.EAS.WUC_LinkButton_PesquisarCNES; LinkButton eas_pesquisarnome = this.EAS.WUC_LinkButton_PesquisarNomeFantasia; this.InserirTrigger(eas_pesquisarcnes.UniqueID, "Click", this.UpdatePanel_Unidade); this.InserirTrigger(eas_pesquisarnome.UniqueID, "Click", this.UpdatePanel_Unidade); eas_pesquisarcnes.Click += new EventHandler(OnClick_PesquisarCNES); eas_pesquisarnome.Click += new EventHandler(OnClick_PesquisarNomeFantasiaUnidade); if (!IsPostBack) { if (!Factory.GetInstance<ISeguranca>().VerificarPermissao(((Usuario)Session["Usuario"]).Codigo, "MANTER_ESTABELECIMENTO_SAUDE", Modulo.ESTABELECIMENTO_SAUDE)) { BoundField bound = new BoundField(); bound.HeaderText = "Nome Fantasia"; bound.DataField = "NomeFantasia"; bound.ItemStyle.HorizontalAlign = HorizontalAlign.Center; bound.ItemStyle.Width = Unit.Pixel(500); grid_EstabelecimentoSaude.Columns.RemoveAt(1); grid_EstabelecimentoSaude.Columns.Insert(1, bound); } this.EAS.WUC_EstabelecimentosPesquisados = new List<ViverMais.Model.EstabelecimentoSaude>(); } }
public void AddColumn(string DataField, string Header, GridView gv) { BoundField Field = new BoundField(); Field.DataField = DataField; Field.HeaderText = Header; DataControlField Col = Field; gv.Columns.Add(Col); }
protected override void Page_Init(object sender, EventArgs e) { #region imposto le colonne della gridview #region titolo var col = new BoundField(); col.HeaderText = Etichette.GetItem(Etichette.EtichetteEnum.PopUpOrderListTitleHeaderText, Languages).Valore; col.ItemStyle.HorizontalAlign = HorizontalAlign.Left; __GridView_Prodotti.Columns.Insert(0, col); #endregion #region quantità col = new BoundField(); col.HeaderText = Etichette.GetItem(Etichette.EtichetteEnum.PopUpOrderListAmountHeaderText, Languages).Valore; col.SortExpression = "Quantità"; col.DataField = "Quantità"; col.ItemStyle.HorizontalAlign = HorizontalAlign.Center; col.HeaderStyle.Width = new Unit(90); __GridView_Prodotti.Columns.Insert(1, col); #endregion #region prezzo singolo col = new BoundField(); col.HeaderText = Etichette.GetItem(Etichette.EtichetteEnum.PopUpOrderListPriceHeaderText, Languages).Valore; col.SortExpression = "Prezzo"; col.DataField = "Prezzo"; col.DataFormatString = "{0:C2}"; col.ItemStyle.HorizontalAlign = HorizontalAlign.Center; col.HeaderStyle.Width = new Unit(100); __GridView_Prodotti.Columns.Insert(2, col); #endregion #region prezzo multiplo col = new BoundField(); col.HeaderText = Etichette.GetItem(Etichette.EtichetteEnum.PopUpOrderListPriceTotalHeaderText, Languages).Valore; col.ItemStyle.HorizontalAlign = HorizontalAlign.Center; col.HeaderStyle.Width = new Unit(100); __GridView_Prodotti.Columns.Insert(3, col); #endregion #endregion //La categoria selezionata non contiene nessun prodotto NoProducts = Etichette.GetItem(Etichette.EtichetteEnum.PopUpOrderListNoProducts, Languages).Valore; if (Ordini.GetItem(Ordini.KeyColumnsEnum.Id, GetQueryStringId) == null) return; CaricaOrdini(); }
// 创建GridView列的方法 private void CreateGridColumn(string dataField, string headerText, int width) { System.Web.UI.WebControls.BoundField bc = new System.Web.UI.WebControls.BoundField(); bc.DataField = dataField; bc.HeaderText = headerText; // bc.HeaderStyle.CssClass = headerStyle; //若有默认样式,此行代码及对应的参数可以移除 // bc.ItemStyle.CssClass = itemStyle; //若有默认样式,此行代码及对应的参数可以移除 GridView1.Columns.Add(bc); //把动态创建的列,添加到GridView中 GridView1.Width = new Unit(GridView1.Width.Value + width); //每添加一列后,要增加GridView的总体宽度 }
protected override void OnPreInit(EventArgs e) { BoundField field = new BoundField() { //标记 DataField = "SupplierName", HeaderText = "SupplierName", }; this.relativeLinkGroupGrid.Columns.Insert(2, field); base.OnPreInit(e); }
protected void adminGetAllTestimonials() { TestimonialsObj tObj = new TestimonialsObj(); try { if (tObj.getTestimonials(0, true)) { //bind data BoundField custName = new BoundField(); custName.ReadOnly = true; custName.HeaderText = "Customer Name"; custName.DataField = "cust_Name"; this.gvTestimonials.Columns.Add(custName); BoundField custLoc = new BoundField(); custLoc.ReadOnly = true; custLoc.HeaderText = "Customer Location"; custLoc.DataField = "cust_Location"; this.gvTestimonials.Columns.Add(custLoc); BoundField custBlurb = new BoundField(); custBlurb.ReadOnly = true; custBlurb.HeaderText = "Customer Testimonial"; custBlurb.DataField = "testimonial"; this.gvTestimonials.Columns.Add(custBlurb); BoundField custEvent = new BoundField(); custEvent.ReadOnly = true; custEvent.HeaderText = "Event"; custEvent.DataField = "cust_Event"; this.gvTestimonials.Columns.Add(custEvent); this.gvTestimonials.DataSource = null; this.gvTestimonials.Dispose(); this.gvTestimonials.DataSource = tObj.ds; this.gvTestimonials.DataBind(); this.formPanel.Visible = false; this.viewPanel.Visible = true; } else { this.errMsg.Text = tObj.errMsg; this.errMsg.Visible = true; } } catch (Exception ee) { this.errMsg.Visible = true; this.errMsg.Text = ee.Message.ToString(); } tObj = null; }
public void Url_Map(string ID_Table, string Name_Table) { MapPage.Visible = true; ObjectDataTempGrig.SelectParameters.Clear(); ObjectDataTempGrig.SelectParameters.Add("NameTable", Name_Table.ToString()); ObjectDataTempGrig.SelectParameters.Add("ID_Table", ID_Table.ToString()); TempGrid.DataSourceID = "ObjectDataTempGrig"; TempGrid.DataKeyNames = new string[] { "ID_Table", "ID_Files", "fileName", "fileType", "MapMain" }; TempGrid.DataBind(); for (int i = 0; i < TempGrid.Rows.Count; i++) { FileCoordimateDataSource.SelectParameters.Clear(); FileCoordimateDataSource.SelectParameters.Add("ID_files", TempGrid.DataKeys[i].Values[1].ToString()); } string photoFilePath = Server.MapPath("../Image_Data/"); for (int i = 0; i < TempGrid.Rows.Count; i++) { if (!File.Exists(photoFilePath + TempGrid.DataKeys[i].Values[2].ToString() + "_" + TempGrid.DataKeys[i].Values[1].ToString() + "." + TempGrid.DataKeys[i].Values[3].ToString())) { ImageFilesObjectDataSource.SelectMethod = "TestGetSqlBytes"; ImageFilesObjectDataSource.SelectParameters.Clear(); ImageFilesObjectDataSource.SelectParameters.Add("documentID", TempGrid.DataKeys[i].Values[1].ToString()); ImageFilesObjectDataSource.SelectParameters.Add("filePath", photoFilePath); ImageFilesObjectDataSource.Select(); } MapPage.ImageUrl = "~/Image_Data/" + TempGrid.DataKeys[i].Values[2].ToString() + "_" + TempGrid.DataKeys[i].Values[1].ToString() + "." + TempGrid.DataKeys[i].Values[3].ToString(); break; } //поле для HotSpotsGrid BoundField PageImageGrid = new BoundField(); PageImageGrid.HeaderText = "Связанные элементы"; PageImageGrid.DataField = "AlternateText"; PageImageGrid.Visible = false; // для заполения ссылок и их названий GridView HotSpotsGrid = new GridView(); HotSpotsGrid.DataSourceID = "FileCoordimateDataSource"; HotSpotsGrid.AutoGenerateColumns = false; HotSpotsGrid.DataKeyNames = new string[] { "ID", "ID_files", "Coordinate", "AlternateText", "ID_UrlTable" }; HotSpotsGrid.Columns.Add(PageImageGrid); HotSpotsGrid.Width = 40; DivRightPage.Controls.Add(HotSpotsGrid); HotSpotsGrid.DataBind(); MapPage.HotSpots.Clear(); for (int i = 0; i < HotSpotsGrid.Rows.Count; i++) { PolygonHotSpot Ph = new PolygonHotSpot(); Ph.AlternateText = HotSpotsGrid.DataKeys[i].Values[3].ToString(); Ph.Coordinates = HotSpotsGrid.DataKeys[i].Values[2].ToString(); Ph.PostBackValue = HotSpotsGrid.DataKeys[i].Values[4].ToString(); MapPage.HotSpots.Add(Ph); } }
/// <summary> /// ��̬����GridView��Columns /// </summary> /// <param name="gv">GridView</param> /// <param name="dt">�����ݱ�</param> public static void DynamicGenerateColumns(GridView gv, DataTable dt) { // ��GridView���Զ�����������Ϊfalse,���������ظ��� gv.AutoGenerateColumns = false; gv.Columns.Clear(); foreach (DataColumn dc in dt.Columns) { BoundField field = new BoundField(); field.HeaderText = dc.ColumnName; field.DataField = dc.ColumnName; gv.Columns.Add(field); } }
public static void AddDataBoundControl(GridView grid, string dataField, string headerText, string dataFormatString = "", bool alignRight = false) { BoundField field = new BoundField(); field.DataField = dataField; field.HeaderText = headerText; field.DataFormatString = dataFormatString; if (alignRight) { field.HeaderStyle.CssClass = "text right"; field.ItemStyle.CssClass = "text right"; } grid.Columns.Add(field); }
public static void GenerateColumns(this SPGridView gridView, SPList list, IEnumerable<string> fieldNames) { gridView.AutoGenerateColumns = false; foreach (string fieldName in fieldNames) { SPField field = list.Fields.GetFieldByInternalName(fieldName); BoundField column = new BoundField { DataField = field.InternalName, HeaderText = field.Title }; gridView.Columns.Add(column); } }
private void CreateColumns(DataSet ds) { //Add columns to GridView if (ds != null) { grd.Columns.Clear(); foreach (DataColumn column in ds.Tables[0].Columns) { BoundField fld = new BoundField(); fld.DataField = column.ColumnName; fld.HeaderText = column.ColumnName; grd.Columns.Add(fld); } } }
private void draw_GridView(DataTable ip_dt) { for (int i = 2; i < ip_dt.Columns.Count; i++) { BoundField bfield = new BoundField(); switch (ip_dt.Columns[i].ColumnName) { case "Column1": bfield.HeaderText = "Tổng KH giao"; bfield.HeaderStyle.CssClass = "hiddenCell"; //bfield.ItemStyle.CssClass = "HeaderStyle"; //TuDM sua, bo mau sac o luoi break; case "SoDu": bfield.HeaderText = "Số dư năm trước chuyển sang"; //bfield.ItemStyle.CssClass = "HeaderStyle"; bfield.HeaderStyle.CssClass = "hiddenCell"; break; case "ChinhThuc": bfield.HeaderText = "KH giao chính thức " + CIPConvert.ToDatetime(m_txt_tu_ngay.Text, c_configuration.DEFAULT_DATETIME_FORMAT).Year.ToString(); bfield.HeaderStyle.CssClass = "hiddenCell"; //bfield.ItemStyle.CssClass = "HeaderStyle"; break; case "TongVon": bfield.HeaderText = "Tổng cộng"; //bfield.ItemStyle.CssClass = "HeaderStyle"; break; default: var qd = new US_DM_QUYET_DINH(CIPConvert.ToDecimal(ip_dt.Columns[i].ColumnName.Substring(2))); bfield.HeaderText = qd.strSO_QUYET_DINH; if (qd.dcID_LOAI_QUYET_DINH == 648) { //bfield.ItemStyle.CssClass = "HeaderStyle"; } else { // bfield.ItemStyle.CssClass = "HeaderStyle"; } break; } bfield.DataField = ip_dt.Columns[i].ColumnName; bfield.ItemStyle.HorizontalAlign = HorizontalAlign.Right; bfield.HtmlEncode = false; m_grv_bao_cao_giao_von.Columns.Add(bfield); } }
private void AddKeysAndBoundFields(IDataSourceViewSchema schema) { DataControlFieldCollection columns = ((GridView) base.Component).Columns; if (schema != null) { IDataSourceFieldSchema[] fields = schema.GetFields(); if ((fields != null) && (fields.Length > 0)) { ArrayList list = new ArrayList(); foreach (IDataSourceFieldSchema schema2 in fields) { if (((GridView) base.Component).IsBindableType(schema2.DataType)) { BoundField field; if ((schema2.DataType == typeof(bool)) || (schema2.DataType == typeof(bool?))) { field = new CheckBoxField(); } else { field = new BoundField(); } string name = schema2.Name; if (schema2.PrimaryKey) { list.Add(name); } field.DataField = name; field.HeaderText = name; field.SortExpression = name; field.ReadOnly = schema2.PrimaryKey || schema2.IsReadOnly; field.InsertVisible = !schema2.Identity; columns.Add(field); } } ((GridView) base.Component).AutoGenerateColumns = false; int count = list.Count; if (count > 0) { string[] array = new string[count]; list.CopyTo(array, 0); ((GridView) base.Component).DataKeyNames = array; } } } }
protected void Page_Load(object sender, EventArgs e) { var nameColumn = new BoundField(); nameColumn.DataField = "Name"; nameColumn.HeaderText = "Naam"; var countryColumn = new BoundField(); countryColumn.DataField = "Country"; countryColumn.HeaderText = "Land"; this.GridView.Columns.Add(nameColumn); this.GridView.Columns.Add(countryColumn); this.GridView.AutoGenerateColumns = false; this.GridView.DataSource = this.Ports; this.GridView.DataBind(); }
protected override void Page_Init(object sender, EventArgs e) { #region imposto le colonne della gridview #region data var col = new BoundField(); col.HeaderText = Etichette.GetItem(Etichette.EtichetteEnum.PageAccountingPaypalPaymentsHeaderTextDate, Languages).Valore; col.SortExpression = "Data"; col.DataField = "Data"; col.DataFormatString = "{0:d}"; col.HeaderStyle.Width = new Unit(90); col.HtmlEncode = false; col.ItemStyle.HorizontalAlign = HorizontalAlign.Center; __GridView_Elenco.Columns.Insert(0, col); #endregion #region pagamento totale col = new BoundField(); col.HeaderText = Etichette.GetItem(Etichette.EtichetteEnum.PageAccountingPaypalPaymentsHeaderTextPaymentTotal, Languages).Valore; col.SortExpression = "PaymentTotal"; col.DataField = "PaymentTotal"; col.DataFormatString = "{0:C}"; col.HeaderStyle.Width = new Unit(90); col.ItemStyle.HorizontalAlign = HorizontalAlign.Center; __GridView_Elenco.Columns.Insert(1, col); #endregion #region emailpaypal col = new BoundField(); col.HeaderText = Etichette.GetItem(Etichette.EtichetteEnum.PageAccountingPaypalPaymentsHeaderTextEmailPaypal, Languages).Valore; col.SortExpression = "PayerEmail"; col.DataField = "PayerEmail"; col.ItemStyle.HorizontalAlign = HorizontalAlign.Center; __GridView_Elenco.Columns.Insert(2, col); #endregion #endregion }
private void genRoleMenuTable() { var _msr = new MenuServiceClient(); var _sdsr = new SystemDataServiceClient(); RoleCollecion = _msr.QueryAllRole(); FMCollection = _msr.QueryAllMenu(); RoleMenuRelation = _sdsr.QueryRoleMenuRelation(); gvRoleMenu.DataSource = FMCollection; foreach (var role in RoleCollecion) { BoundField _bf = new BoundField(); _bf.HeaderText = role.RoleName; gvRoleMenu.Columns.Add(_bf); } gvRoleMenu.DataBind(); }
protected void OnInit_gridFila(object sender, EventArgs e) { if (!Page.IsPostBack) { Session.Remove("acessoMedico"); Session.Remove("acessoEnfermeiro"); } bool acessoMedico; bool acessoEnfermeiro; if (Session["acessoMedico"] == null && Session["acessoEnfermeiro"] == null) { IUsuarioProfissionalUrgence iUsuarioProfissional = Factory.GetInstance<IUsuarioProfissionalUrgence>(); Usuario usuario = (Usuario)Session["Usuario"]; acessoMedico = iUsuarioProfissional.VerificarAcessoMedico(usuario.Codigo, "EXECUTAR_ACOLHIMENTO", usuario.Unidade.CNES); acessoEnfermeiro = iUsuarioProfissional.VerificarAcessoEnfermeiro(usuario.Codigo, "EXECUTAR_ACOLHIMENTO", usuario.Unidade.CNES); Session["acessoEnfermeiro"] = acessoEnfermeiro; Session["acessoMedico"] = acessoMedico; } else { acessoMedico = (bool)Session["acessoMedico"]; acessoEnfermeiro = (bool)Session["acessoEnfermeiro"]; } if (!acessoMedico && !acessoEnfermeiro) { gridFila.Columns.RemoveAt(1); BoundField numeroprontuario = new BoundField(); numeroprontuario.DataField = "NumeroToString"; numeroprontuario.HeaderText = "Identificador"; numeroprontuario.ItemStyle.HorizontalAlign = HorizontalAlign.Center; numeroprontuario.ItemStyle.Width = Unit.Pixel(100); gridFila.Columns.Insert(1, numeroprontuario); } }
protected override void CreateChildControls() { _detailsView = new DetailsView { ID = string.Format("{0}_detailsView", base.ID), AutoGenerateRows = false, AllowPaging = true }; //Set Paging Events _detailsView.PageIndexChanging += DetailsView_PageIndexChanging; //Create Custom Field var customField = new TemplateField { HeaderTemplate = new SetTemplate(DataControlRowType.Header, "Name"), ItemTemplate = new SetTemplate(DataControlRowType.DataRow) }; //Add custom field to detailsview field _detailsView.Fields.Add(customField); //Create Bound Field var boundField = new BoundField { DataField = "PhoneNumber", HeaderText = "Phone Number", }; //Set header font to bold boundField.HeaderStyle.Font.Bold = true; //Add bound field to detailsview field _detailsView.Fields.Add(boundField); //Bind Details View DetailsView_DataBind(); //Add detaisview to composite control Controls.Add(_detailsView); }
private void CreateResultsList() { _gvResults = new GridView(); _gvResults.AutoGenerateColumns = false; BoundField captionColumn = new BoundField(); captionColumn.HeaderText = "Device"; captionColumn.DataField = "Caption"; _gvResults.Columns.Add(captionColumn); _gvResults.AutoGenerateSelectButton = true; _gvResults.AutoGenerateDeleteButton = false; _gvResults.AutoGenerateEditButton = false; _gvResults.AllowPaging = true; _gvResults.ShowHeader = true; _gvResults.ShowFooter = false; _gvResults.PageSize = 25; _gvResults.PageIndexChanging += new GridViewPageEventHandler(_gvResults_PageIndexChanging); _gvResults.RowCommand += new GridViewCommandEventHandler(_gvResults_RowCommand); }
protected void Page_Load(object sender, EventArgs e) { this.WUCPesquisarLote.WUC_LnkListarTodos.Click += new EventHandler(OnClick_ListarTodos); this.WUCPesquisarLote.WUC_LnkPesquisar.Click += new EventHandler(OnClick_Pesquisar); if (!IsPostBack) { if (!Factory.GetInstance<ISeguranca>().VerificarPermissao(((Usuario)Session["Usuario"]).Codigo, "MANTER_LOTE_VACINA", Modulo.VACINA)) { this.WUCPesquisarLote.WUC_GridViewLote.Columns.RemoveAt(3); BoundField bound = new BoundField(); bound.HeaderText = "Lote"; bound.DataField = "Identificacao"; bound.ItemStyle.Width = Unit.Pixel(100); bound.ItemStyle.HorizontalAlign = HorizontalAlign.Center; this.WUCPesquisarLote.WUC_GridViewLote.Columns.Insert(3, bound); this.Lnk_NovoLote.Visible = false; } //this.OnClick_ListarTodos(sender, e); } }
/** * Por si quiero iterar solo sobre el panel * ContentPlaceHolder cp = (ContentPlaceHolder)this.Master.FindControl("modalCarga"); **/ protected void GenerarColumnas(GridView gv) { if (gv.Columns.Count == 0) { Type tipoCompleto = gv.DataSource.GetType().GetGenericArguments()[0]; BindingFlags flags = BindingFlags.Public | BindingFlags.Instance; PropertyInfo[] properties = tipoCompleto.GetProperties(flags); string[] palabras = tipoCompleto.ToString().Split('.'); string tipo = palabras.Last(); int totalColumnas = 0; Unit u = new Unit("30px"); foreach (PropertyInfo property in properties) { var oTipo = property.PropertyType; if (!(oTipo.IsGenericType && (oTipo.GetGenericTypeDefinition() == typeof(List<>)))) { BoundField bf = new BoundField(); bf.HeaderText = property.Name; bf.DataField = property.Name; gv.Columns.Add(bf); } } HyperLinkField enlaceEdicion = new HyperLinkField(); enlaceEdicion.Text = "<span class='glyphicon glyphicon-edit'></span>"; enlaceEdicion.DataNavigateUrlFields = new string[] { "Id" }; enlaceEdicion.DataNavigateUrlFormatString = "Edit/" + tipo + "?Id={0}"; enlaceEdicion.ItemStyle.Width = u; gv.Columns.Add(enlaceEdicion); HyperLinkField enlaceBorrado = new HyperLinkField(); enlaceBorrado.Text = "<span class='glyphicon glyphicon-remove'></span>"; enlaceBorrado.DataNavigateUrlFields = new string[] { "Id" }; enlaceBorrado.DataNavigateUrlFormatString = "Remove/" + tipo + "?Id={0}"; enlaceBorrado.ItemStyle.Width = u; gv.Columns.Add(enlaceBorrado); totalColumnas = gv.Columns.Count; } }
protected override void OnInit(EventArgs e) { base.OnInit(e); var sf = new SelectionField(); sf.ItemStyle.CssClass = "GridViewIcon"; InternalGridView.Columns.Add(sf); var nf = new System.Web.UI.WebControls.BoundField(); nf.DataField = "Number"; nf.ItemStyle.CssClass = "GridViewIcon"; InternalGridView.Columns.Add(nf); var imgf = new ImageField(); imgf.DataImageUrlField = "EntityType"; imgf.DataImageUrlFormatString = "~/Icons/Small/{0}.gif"; imgf.ItemStyle.CssClass = "GridViewIcon"; InternalGridView.Columns.Add(imgf); var namefield = new HyperLinkField(); namefield.HeaderText = "Name"; namefield.DataTextField = "Name"; namefield.ItemStyle.CssClass = "GridViewSpan"; namefield.DataNavigateUrlFields = new[] { "EntityType", "Guid" }; namefield.DataNavigateUrlFormatString = "~/" + entityGroup.ToString() + "/{0}Details.aspx?guid={1}"; InternalGridView.Columns.Add(namefield); foreach (DataControlField col in columns) { InternalGridView.Columns.Add(col); } }
protected void SubmitButton1_Click(object sender, EventArgs e) { string smenaN = NumTextBox1.Text; string kashN = CashTextBox1.Text; MySqlConnection cnx = null; cnx = new MySqlConnection(connStr); MySqlDataAdapter adapter = new MySqlDataAdapter(); StringBuilder sb = new StringBuilder(); int i = 1; foreach (ListItem itm in CheckedListBox1.Items) { string id = itm.Value; sb.Append(id); string cmdText2 = "select * from trm_in_classif where owner=" + id + "; "; MySqlCommand cmd2 = new MySqlCommand(cmdText2, cnx); // Create a fill a Dataset DataSet ds2 = new DataSet(); adapter.SelectCommand = cmd2; adapter.Fill(ds2); if (ds2.Tables[0].Rows.Count != 0) { sb.Append(","); int i2 = 1; foreach (DataRow row2 in ds2.Tables[0].Rows) { string id2 = row2.Field <string>("id"); string name2 = row2.Field <string>("name"); sb.Append(id2); // 3 string cmdText3 = "select * from trm_in_classif where owner=" + id2 + "; "; MySqlCommand cmd3 = new MySqlCommand(cmdText3, cnx); // Create a fill a Dataset DataSet ds3 = new DataSet(); adapter.SelectCommand = cmd3; adapter.Fill(ds3); if (ds3.Tables[0].Rows.Count != 0) { sb.Append(","); int i3 = 1; foreach (DataRow row3 in ds3.Tables[0].Rows) { string id3 = row3.Field <string>("id"); string name3 = row3.Field <string>("name"); sb.Append(id3); // 4 string cmdText4 = "select * from trm_in_classif where owner=" + id3 + "; "; MySqlCommand cmd4 = new MySqlCommand(cmdText4, cnx); // Create a fill a Dataset DataSet ds4 = new DataSet(); adapter.SelectCommand = cmd4; adapter.Fill(ds4); if (ds4.Tables[0].Rows.Count != 0) { sb.Append(","); int i4 = 1; foreach (DataRow row4 in ds4.Tables[0].Rows) { string id4 = row4.Field <string>("id"); string name4 = row4.Field <string>("name"); sb.Append(id4); // 5 string cmdText5 = "select * from trm_in_classif where owner=" + id4 + "; "; MySqlCommand cmd5 = new MySqlCommand(cmdText5, cnx); // Create a fill a Dataset DataSet ds5 = new DataSet(); adapter.SelectCommand = cmd5; adapter.Fill(ds5); if (ds5.Tables[0].Rows.Count != 0) { sb.Append(","); int i5 = 1; foreach (DataRow row5 in ds5.Tables[0].Rows) { string id5 = row5.Field <string>("id"); string name5 = row5.Field <string>("name"); sb.Append(id5); // 6 string cmdText6 = "select * from trm_in_classif where owner=" + id5 + "; "; MySqlCommand cmd6 = new MySqlCommand(cmdText6, cnx); // Create a fill a Dataset DataSet ds6 = new DataSet(); adapter.SelectCommand = cmd6; adapter.Fill(ds6); if (ds6.Tables[0].Rows.Count != 0) { sb.Append(","); int i6 = 1; foreach (DataRow row6 in ds6.Tables[0].Rows) { string id6 = row6.Field <string>("id"); string name6 = row6.Field <string>("name"); sb.Append(id6); // 7 string cmdText7 = "select * from trm_in_classif where owner=" + id6 + "; "; MySqlCommand cmd7 = new MySqlCommand(cmdText7, cnx); // Create a fill a Dataset DataSet ds7 = new DataSet(); adapter.SelectCommand = cmd7; adapter.Fill(ds7); if (ds7.Tables[0].Rows.Count != 0) { sb.Append(","); int i7 = 1; foreach (DataRow row7 in ds7.Tables[0].Rows) { string id7 = row7.Field <string>("id"); string name7 = row7.Field <string>("name"); sb.Append(id7); // 8 string cmdText8 = "select * from trm_in_classif where owner=" + id7 + "; "; MySqlCommand cmd8 = new MySqlCommand(cmdText8, cnx); // Create a fill a Dataset DataSet ds8 = new DataSet(); adapter.SelectCommand = cmd8; adapter.Fill(ds8); if (ds8.Tables[0].Rows.Count != 0) { sb.Append(","); int i8 = 1; foreach (DataRow row8 in ds8.Tables[0].Rows) { string id8 = row8.Field <string>("id"); string name8 = row8.Field <string>("name"); sb.Append(id8); if (i8 != ds8.Tables[0].Rows.Count) { sb.Append(","); } i8++; } } // -8 if (i7 != ds7.Tables[0].Rows.Count) { sb.Append(","); } i7++; } } // -7 if (i6 != ds6.Tables[0].Rows.Count) { sb.Append(","); } i6++; } } // -6 if (i5 != ds5.Tables[0].Rows.Count) { sb.Append(","); } i5++; } } if (i4 != ds4.Tables[0].Rows.Count) { sb.Append(","); } // -5 i4++; } } if (i3 != ds3.Tables[0].Rows.Count) { sb.Append(","); } // -4 i3++; } } if (i2 != ds2.Tables[0].Rows.Count) { sb.Append(","); } // -3 i2++; } } if (i != CheckedListBox1.Items.Count) { sb.Append(","); } i++; //--- } string fromSB = sb.ToString(); string fZap = fromSB.Substring(fromSB.Length - 1); if (fZap == ",") { fromSB = fromSB.Substring(0, fromSB.Length - 2); } if (fromSB != "") { // TODO THIS: исправить запрос чтобы выборка фильтровалась по полю items classif StringBuilder cmdText = new StringBuilder(); cmdText.Append("SELECT i.item 'Item', i.name 'Name', classif.id 'classif_id', classif.name 'classif', SUM(IF(h.type IN (0,5), 1, -1) * i.quantity) 'Qty', SUM(IF(h.type IN (0,5), 1, -1) * i.total + i.discount) 'Sum' FROM trm_in_pos c INNER JOIN trm_out_receipt_header h ON h.cash_id = c.cash_id INNER JOIN trm_out_receipt_item i ON i.cash_id = h.cash_id AND i.receipt_header = h.id LEFT JOIN trm_out_receipt_item i2 ON (h.cash_id = i2.cash_id AND h.id = i2.receipt_header AND i2.link_item = i.id) INNER JOIN trm_out_receipt_footer f ON f.cash_id = h.cash_id AND f.id = h.id INNER JOIN trm_in_classif classif ON (i.classif = classif.id ) INNER JOIN trm_out_login lg ON (h.cash_id = lg.cash_id AND h.login = lg.id) INNER JOIN trm_in_users usr ON (c.store_id = usr.store_id AND lg.user_id = usr.id) INNER join trm_out_shift_open so on (so.id = h.shift_open AND so.cash_id = h.cash_id) WHERE i2.link_item IS NULL AND i.type = 0 AND h.type IN (0,5,1,4) AND f.result IN (0) AND classif.id in (" + fromSB + ") AND c.number = '" + kashN + "' AND so.number = '" + smenaN + "' GROUP BY i.item ORDER BY classif.id, i.item;"); MySqlCommand cmd = new MySqlCommand(cmdText.ToString(), cnx); // Create a fill a Dataset DataSet ds = new DataSet(); adapter.SelectCommand = cmd; adapter.Fill(ds); //DebugLabel1.Text = cmdText.ToString(); if (ds.Tables[0].Rows.Count != 0) { object objSum; objSum = ds.Tables[0].Compute("Sum(Sum)", ""); object objQty; objQty = ds.Tables[0].Compute("Sum(Qty)", ""); GridView ReportGridView1 = new GridView(); ReportGridView1.Width = new Unit(950); ReportGridView1.AutoGenerateColumns = false; //BoundField fld10 = new System.Web.UI.WebControls.BoundField(); //fld10.HeaderText = "Магазин"; //fld10.DataField = "Shop"; //ReportGridView1.Columns.Add(fld10); //BoundField fld2 = new System.Web.UI.WebControls.BoundField(); //fld2.HeaderText = "Кассир"; //fld2.DataField = "Casher"; //ReportGridView1.Columns.Add(fld2); //BoundField fld11 = new System.Web.UI.WebControls.BoundField(); //fld11.HeaderText = "Время"; //fld11.DataField = "Time"; //ReportGridView1.Columns.Add(fld11); //BoundField fld1 = new System.Web.UI.WebControls.BoundField(); //fld1.HeaderText = "Касса"; //fld1.DataField = "POSN"; //ReportGridView1.Columns.Add(fld1); //BoundField fld12 = new System.Web.UI.WebControls.BoundField(); //fld12.HeaderText = "Смена"; //fld12.DataField = "Smena"; //ReportGridView1.Columns.Add(fld12); //BoundField fld13 = new System.Web.UI.WebControls.BoundField(); //fld13.HeaderText = "Чек"; //fld13.DataField = "Cheque"; //ReportGridView1.Columns.Add(fld13); BoundField fld3 = new System.Web.UI.WebControls.BoundField(); fld3.HeaderText = "Арт."; fld3.DataField = "Item"; ReportGridView1.Columns.Add(fld3); BoundField fld5 = new System.Web.UI.WebControls.BoundField(); fld5.HeaderText = "Наименование"; fld5.DataField = "Name"; ReportGridView1.Columns.Add(fld5); BoundField fld54 = new System.Web.UI.WebControls.BoundField(); fld54.HeaderText = "Группа"; fld54.DataField = "classif_id"; ReportGridView1.Columns.Add(fld54); BoundField fld55 = new System.Web.UI.WebControls.BoundField(); fld55.HeaderText = "Наим. группы"; fld55.DataField = "classif"; ReportGridView1.Columns.Add(fld55); BoundField fld6 = new System.Web.UI.WebControls.BoundField(); fld6.HeaderText = "Кол."; fld6.DataField = "Qty"; fld6.DataFormatString = "{0:N}"; ReportGridView1.Columns.Add(fld6); BoundField fld7 = new System.Web.UI.WebControls.BoundField(); fld7.HeaderText = "Сумма"; fld7.DataField = "Sum"; fld7.DataFormatString = "{0:N}"; ReportGridView1.Columns.Add(fld7); ReportGridView1.DataSource = ds.Tables[0]; ReportGridView1.DataBind(); ReportPlaceHolder1.Controls.Add(ReportGridView1); Label lblGroup = new Label(); lblGroup.Text = "Итоги: Кол.: " + objQty.ToString() + " Сумма: " + objSum.ToString(); ReportPlaceHolder1.Controls.Add(lblGroup); } else { ErrorLabel1.Text = "В выборке нет данных"; } } NumLabel1.Text = NumTextBox1.Text; CashLabel1.Text = CashTextBox1.Text; Wizard1.ActiveStepIndex = 1; }
protected void SubmitButton1_Click(object sender, EventArgs e) { MySqlConnection cnx = null; cnx = new MySqlConnection(connStr); MySqlDataAdapter adapter = new MySqlDataAdapter(); string dateTod = DateTime.Today.ToString("yyy-MM-dd"); string smenaN = NumTextBox1.Text; string kashN = CashTextBox1.Text; string cmdText = "SELECT cl.name 'Shop', usr.name 'Casher', DATE_FORMAT(f.date, '%d/%m/%Y %H:%i:%s') 'Time', c.number 'POSN', h.shift_open 'Smena', h.local_number 'Cheque', it.item 'Item', it.name 'Name', it.total_quantity 'Qty', it.total + it.discount 'Sum' FROM trm_in_store cl INNER JOIN trm_in_pos c ON c.store_id = cl.store_id INNER JOIN trm_out_receipt_header h ON h.cash_id = c.cash_id INNER JOIN trm_out_receipt_footer f ON (h.cash_id = f.cash_id AND h.id = f.id) INNER JOIN trm_out_receipt_item it ON (h.cash_id = it.cash_id AND h.id = it.receipt_header) INNER JOIN trm_out_shift_open s ON (h.cash_id = s.cash_id AND h.shift_open = s.id) LEFT JOIN trm_out_login lg ON (h.cash_id = lg.cash_id AND h.login = lg.id) LEFT JOIN trm_in_users usr ON (c.store_id = usr.store_id AND lg.user_id = usr.id) WHERE (h.type IN (0, 5)) AND (f.result = 0) AND (it.type IN (1, 2)) AND s.number = '" + smenaN + "' AND c.number = '" + kashN + "' ORDER BY f.date, c.number, s.number, h.local_number, it.position;"; MySqlCommand cmd = new MySqlCommand(cmdText, cnx); // Create a fill a Dataset DataSet ds = new DataSet(); adapter.SelectCommand = cmd; adapter.Fill(ds); if (ds.Tables[0].Rows.Count != 0) { object objSum; objSum = ds.Tables[0].Compute("Sum(Sum)", ""); object objQty; objQty = ds.Tables[0].Compute("Sum(Qty)", ""); Label lblGroup = new Label(); lblGroup.Text = "Кол.: " + objQty.ToString() + " Сумма: " + objSum.ToString(); ReportPlaceHolder1.Controls.Add(lblGroup); GridView ReportGridView1 = new GridView(); ReportGridView1.Width = new Unit(950); ReportGridView1.AutoGenerateColumns = false; BoundField fld10 = new System.Web.UI.WebControls.BoundField(); fld10.HeaderText = "Магазин"; fld10.DataField = "Shop"; ReportGridView1.Columns.Add(fld10); BoundField fld2 = new System.Web.UI.WebControls.BoundField(); fld2.HeaderText = "Кассир"; fld2.DataField = "Casher"; ReportGridView1.Columns.Add(fld2); BoundField fld11 = new System.Web.UI.WebControls.BoundField(); fld11.HeaderText = "Время"; fld11.DataField = "Time"; ReportGridView1.Columns.Add(fld11); BoundField fld1 = new System.Web.UI.WebControls.BoundField(); fld1.HeaderText = "Касса"; fld1.DataField = "POSN"; ReportGridView1.Columns.Add(fld1); BoundField fld12 = new System.Web.UI.WebControls.BoundField(); fld12.HeaderText = "Смена"; fld12.DataField = "Smena"; ReportGridView1.Columns.Add(fld12); BoundField fld13 = new System.Web.UI.WebControls.BoundField(); fld13.HeaderText = "Чек"; fld13.DataField = "Cheque"; ReportGridView1.Columns.Add(fld13); BoundField fld3 = new System.Web.UI.WebControls.BoundField(); fld3.HeaderText = "Арт."; fld3.DataField = "Item"; ReportGridView1.Columns.Add(fld3); BoundField fld5 = new System.Web.UI.WebControls.BoundField(); fld5.HeaderText = "Наименование"; fld5.DataField = "Name"; ReportGridView1.Columns.Add(fld5); BoundField fld6 = new System.Web.UI.WebControls.BoundField(); fld6.HeaderText = "Кол."; fld6.DataField = "Qty"; fld6.DataFormatString = "{0:N}"; ReportGridView1.Columns.Add(fld6); BoundField fld7 = new System.Web.UI.WebControls.BoundField(); fld7.HeaderText = "Сумма"; fld7.DataField = "Sum"; fld7.DataFormatString = "{0:N}"; ReportGridView1.Columns.Add(fld7); ReportGridView1.DataSource = ds.Tables[0]; ReportGridView1.DataBind(); ReportPlaceHolder1.Controls.Add(ReportGridView1); } else { ErrorLabel1.Text = "В выборке нет данных, не было возвратов и аннуляций."; } NumLabel1.Text = NumTextBox1.Text; CashLabel1.Text = CashTextBox1.Text; Wizard1.ActiveStepIndex = 1; }
protected void SubmitButton1_Click(object sender, EventArgs e) { // загружаем данные из ЕРП LoadDataFromSAPERP(); // загружаем цены из укм NewJourPrice_load(); //Connect to the database for Collections Table SqlConnection thisConnection = new SqlConnection(connStrSQL); //Create DataAdapter Object SqlDataAdapter thisAdapter = new SqlDataAdapter(" SELECT ROW_NUMBER() OVER (ORDER BY [MATNR]) as NUM, g.[Name] Name, s.[MATNR] MATNR ,s.[KBETR] KBETR ,s.[KSCHL] KSCHL ,s.[ASSORT] ASSORT ,u.[Artikul] Artikul ,u.[PriceUKM] PriceUKM FROM dbo.SAPPriceTbl s, dbo.UKMPriceTbl u, dbo.Goods g where s.[MATNR] = u.[Artikul] and s.[KBETR] <> u.[PriceUKM] and u.[Artikul] = g.[Articul]", thisConnection); // Create a fill a Dataset DataSet ds = new DataSet(); thisAdapter.Fill(ds); if (ds.Tables[0].Rows.Count != 0) { object objSumSap; objSumSap = ds.Tables[0].Compute("Sum(KBETR)", ""); object objSumUKM; objSumUKM = ds.Tables[0].Compute("Sum(PriceUKM)", ""); GridView ReportGridView1 = new GridView(); ReportGridView1.Width = new Unit(950); ReportGridView1.AutoGenerateColumns = false; BoundField fld0 = new System.Web.UI.WebControls.BoundField(); fld0.HeaderText = "N"; fld0.DataField = "NUM"; ReportGridView1.Columns.Add(fld0); BoundField fld3 = new System.Web.UI.WebControls.BoundField(); fld3.HeaderText = "Арт."; fld3.DataField = "MATNR"; ReportGridView1.Columns.Add(fld3); BoundField fld4 = new System.Web.UI.WebControls.BoundField(); fld4.HeaderText = "Наименование"; fld4.DataField = "NAME"; ReportGridView1.Columns.Add(fld4); BoundField fld5 = new System.Web.UI.WebControls.BoundField(); fld5.HeaderText = "Вид условия"; fld5.DataField = "KSCHL"; ReportGridView1.Columns.Add(fld5); BoundField fld51 = new System.Web.UI.WebControls.BoundField(); fld51.HeaderText = "В ассорт."; fld51.DataField = "ASSORT"; ReportGridView1.Columns.Add(fld51); BoundField fld6 = new System.Web.UI.WebControls.BoundField(); fld6.HeaderText = "SAP цена руб."; fld6.DataField = "KBETR"; fld6.DataFormatString = "{0:N}"; ReportGridView1.Columns.Add(fld6); BoundField fld7 = new System.Web.UI.WebControls.BoundField(); fld7.HeaderText = "УКМ цена руб."; fld7.DataField = "PriceUKM"; fld7.DataFormatString = "{0:N}"; ReportGridView1.Columns.Add(fld7); ReportGridView1.DataSource = ds.Tables[0]; ReportGridView1.DataBind(); ReportPlaceHolder1.Controls.Add(ReportGridView1); Label lblGroup = new Label(); lblGroup.Text = "Итоги: SAP: " + objSumSap.ToString() + " УКМ: " + objSumUKM.ToString() + "."; ReportPlaceHolder1.Controls.Add(lblGroup); } else { ErrorLabel1.Text = "В выборке нет данных, либо в отчете нет расхождений."; } //Close Connection thisConnection.Close(); Wizard1.ActiveStepIndex = 1; }
public virtual void ToUControl(UControl container, WC.GridViewCommandEventHandler handler, WC.GridViewPageEventHandler pagingHandler, WC.GridViewSortEventHandler sortingHandler, string navigateUrl = null) { // take care of all the dependant controls as well WC.GridView grid = new WC.GridView(); string[] DataKeyNames = PKColNames.ToArray(); if (CE.GlobalState == GlobalState.Administer) { // one of our datakeys may have been a FK and its value is now the representative field of the // foreign table, not our key, but in such cases the key will be stored in a prefixed column. for (int i = 0; i < DataKeyNames.Length; i++) { FK fk = FKs.Where(x => x.myColumn == DataKeyNames[i]).FirstOrDefault(); if (fk is FK) { DataKeyNames[i] = CC.TABLE_COLUMN_REAL_VALUE_PREFIX + DataKeyNames[i]; } } } grid.DataKeyNames = DataKeyNames; grid.AutoGenerateColumns = false; WC.TemplateField tf = new WC.TemplateField(); tf.HeaderTemplate = new SummaryGridCommandColumn(WC.ListItemType.Header); tf.FooterTemplate = new SummaryGridCommandColumn(WC.ListItemType.Footer); tf.ItemTemplate = new SummaryGridCommandColumn(WC.ListItemType.Item, actions); grid.Columns.Add(tf); foreach (string col in displayColumns) { WC.BoundField bf = new WC.BoundField(); bf.DataField = col; bf.HeaderText = col + " [-]"; bf.SortExpression = col; grid.Columns.Add(bf); } // must contain the whole PK even if it is not displayed - for the navigator // DataKeyNames are the real ones - including "_" prefixing foreach (string col in DataKeyNames) { if (displayColumns.Contains(col)) { continue; } WC.BoundField bf = new WC.BoundField(); bf.DataField = col; bf.Visible = false; grid.Columns.Add(bf); bf.HeaderText = col; } grid.AllowSorting = true; //PBPR container.Controls.Add(grid); grid.PagerStyle.CssClass = "navTablePaging"; grid.CssClass = "navTable"; grid.AllowPaging = true; grid.PageSize = 25; grid.PageIndexChanging += pagingHandler; grid.Sorting += sortingHandler; grid.DataSource = data.DefaultView; grid.DataBind(); //PBPR grid.RowCommand += handler; grid.ID = "Control" + controlId; }
}//Page_Load /// <summary>PageBuild.</summary> public void PageBuild() { String columnNameCurrent = null; String exceptionMessage = null; String tableName = null; ArrayList columnName = null; GridViewURI = new System.Web.UI.WebControls.GridView(); ServerMapPath = this.MapPath(""); if ( ServerMapPath != null) { FilenameConfigurationXml = ServerMapPath + @"\" + FilenameConfigurationXml; }//if ( ServerMapPath != null) UtilityXml.XmlDocumentNodeInnerText ( FilenameConfigurationXml, ref exceptionMessage, XPathDatabaseConnectionString, ref DatabaseConnectionString ); UtilityXml.XmlDocumentNodeInnerText ( FilenameConfigurationXml, ref exceptionMessage, XPathSQLSelect, ref DatabaseSQLSelect ); UtilityXml.XmlDocumentNodeInnerText ( FilenameConfigurationXml, ref exceptionMessage, XPathXmlStylesheet, ref FilenameXmlStylesheet ); if ( exceptionMessage != null ) { Feedback = exceptionMessage; return; }//if ( exceptionMessage != null ) UtilityDatabase.DataSetTableColumn ( ref DatabaseSQLSelect, ref DataSetURI, ref exceptionMessage, ref tableName, ref columnName ); DataSourceBind(); foreach( object columnNameObject in columnName ) { columnNameCurrent = ( String ) columnNameObject; BoundFieldURI = new BoundField(); BoundFieldURI.DataField = columnNameCurrent; BoundFieldURI.HeaderText = columnNameCurrent; BoundFieldURI.SortExpression = columnNameCurrent; if ( String.Compare( columnNameCurrent, "Dated", true ) == 0 ) { //BoundFieldURI.DataFormatString = "{T}"; //"{0:c}" }//if ( String.Compare( columnNameCurrent, "Dated", true ) == 0 ) GridViewURI.Columns.Add( BoundFieldURI ); }//foreach( object columnNameObject in columnName ) GridViewURI.AllowSorting = true; GridViewURI.AllowPaging = true; GridViewURI.AutoGenerateColumns = false; GridViewURI.AutoGenerateEditButton = true; GridViewURI.AutoGenerateSelectButton = true; GridViewURI.BorderWidth = 1; GridViewURI.CellPadding = 1; GridViewURI.DataKeyNames = PrimaryKeyColumn; GridViewURI.ID = "URI"; GridViewURI.SelectedIndex = 0; // Manually register the event-handling methods. GridViewURI.RowCancelingEdit += new GridViewCancelEditEventHandler( GridViewURI_RowCancelingEdit ); GridViewURI.RowEditing += new GridViewEditEventHandler( GridViewURI_RowEdit ); GridViewURI.RowUpdating += new GridViewUpdateEventHandler( GridViewURI_RowUpdating ); /* GridViewURI.CancelCommand += new GridViewCommandEventHandler(dataGrid_Cancel); GridViewURI.DeleteCommand += new GridViewCommandEventHandler(dataGrid_Delete); GridViewURI.EditCommand += new GridViewCommandEventHandler(dataGrid_Edit); GridViewURI.UpdateCommand += new GridViewCommandEventHandler(dataGrid_Update); */ PlaceHolderURI.Controls.Add( GridViewURI ); }//PageBuild()
protected void SubmitButton1_Click(object sender, EventArgs e) { if (context == null) { context = new SaalutDataClasses1DataContext(); } string[] textParagraphs = txbMaters.Text.Split('\n'); string[] newTP = new string[textParagraphs.Length]; string outMaters = ""; int i = 0; foreach (string str in textParagraphs) { string strT = str.Replace("\r", ""); newTP[i] = strT; i++; } outMaters += "'"; i = 1; foreach (string str in newTP) { outMaters += str; if (i != newTP.Count()) { outMaters += "','"; } else { outMaters += "'"; } i++; } if (cbxGetData.Checked) { // загружаем данные из ЕРП LoadDataFromSAPERP(newTP); // загружаем из укм UKMSold_Info_load(outMaters); } //Connect to the database for Collections Table SqlConnection thisConnection = new SqlConnection(connStrSQL); //Create DataAdapter Object SqlDataAdapter thisAdapter = new SqlDataAdapter(" SELECT ROW_NUMBER() OVER (ORDER BY Artikul) as NUM, [Artikul] ,[GoodName] ,'1000' as Sklad ,Sum([Sold]) as Qty FROM [SaalutExpress].[dbo].[UKMSoldGoods] where [KassaSmena] not in (SELECT [SMENA] FROM [SaalutExpress].[dbo].[SAPOUT_SMENA]) group by [Artikul],[GoodName] ", thisConnection); // Create a fill a Dataset DataSet ds = new DataSet(); thisAdapter.Fill(ds); List <string> artikulsInSap = new List <string>(); DataRow[] result = ds.Tables[0].Select(); foreach (DataRow row in result) { string artikul = row[1].ToString(); string sklad = row[3].ToString(); var sapdata = (from s in context.SAPOUT_REST where s.MATNR == artikul && s.LGORT == sklad select s).FirstOrDefault(); if (sapdata != null) { double ukmqty = Double.Parse(row[4].ToString()); row[4] = sapdata.LABST - ukmqty; row.EndEdit(); ds.Tables[0].AcceptChanges(); artikulsInSap.Add(artikul); } } string[] artikulsIn = artikulsInSap.ToArray(); var sapdanns = from s in context.SAPOUT_REST where (!artikulsIn.Contains(s.MATNR)) select s; i = 0; foreach (SAPOUT_REST so in sapdanns) { if (so.LGORT == "4000" && so.LABST == 0) { continue; } DataRow workRow; workRow = ds.Tables[0].NewRow(); workRow[0] = i; workRow[1] = so.MATNR; workRow[2] = so.MAKTX; workRow[3] = so.LGORT; workRow[4] = so.LABST; ds.Tables[0].Rows.Add(workRow); workRow.EndEdit(); ds.Tables[0].AcceptChanges(); i++; } // счетчик i = 1; result = ds.Tables[0].Select(); foreach (DataRow row in result) { row[0] = i; row.EndEdit(); ds.Tables[0].AcceptChanges(); i++; } // выводим if (ds.Tables[0].Rows.Count != 0) { object objSumUKM; objSumUKM = ds.Tables[0].Compute("Sum(Qty)", ""); GridView ReportGridView1 = new GridView(); ReportGridView1.Width = new Unit(950); ReportGridView1.AutoGenerateColumns = false; BoundField fld0 = new System.Web.UI.WebControls.BoundField(); fld0.HeaderText = "N"; fld0.DataField = "NUM"; ReportGridView1.Columns.Add(fld0); BoundField fld3 = new System.Web.UI.WebControls.BoundField(); fld3.HeaderText = "Арт."; fld3.DataField = "Artikul"; ReportGridView1.Columns.Add(fld3); BoundField fld4 = new System.Web.UI.WebControls.BoundField(); fld4.HeaderText = "Наименование"; fld4.DataField = "GoodName"; ReportGridView1.Columns.Add(fld4); BoundField fld5 = new System.Web.UI.WebControls.BoundField(); fld5.HeaderText = "Склад"; fld5.DataField = "Sklad"; ReportGridView1.Columns.Add(fld5); BoundField fld6 = new System.Web.UI.WebControls.BoundField(); fld6.HeaderText = "Остаток."; fld6.DataField = "Qty"; fld6.DataFormatString = "{0:F3}"; ReportGridView1.Columns.Add(fld6); ReportGridView1.DataSource = ds.Tables[0]; ReportGridView1.DataBind(); ReportPlaceHolder1.Controls.Add(ReportGridView1); Label lblGroup = new Label(); lblGroup.Text = "Итоги: " + objSumUKM.ToString() + "."; ReportPlaceHolder1.Controls.Add(lblGroup); } //Close Connection thisConnection.Close(); Wizard1.ActiveStepIndex = 1; }