/// <summary>Phương thức cho phép thêm chức năng vào cho Cột /// Khi thay đổi giá trị của cột nó làm ảnh hưởng giá trị của các /// cột khác /// </summary> /// <param name="Column">Cột mã hàng</param> /// <param name="FieldName">FieldName của Tên hàng hóa, đơn giá, giảm giá ...</param> /// <param name="func">Hàm gán giá trị cho các field</param> public static void AddCalcGridColum(GridView Grid, GridColumn Column, string[] FieldNames, GetInfo Func) { Grid.CellValueChanged += delegate(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { try { GridView grid = (GridView)sender; DataRow row = grid.GetDataRow(grid.FocusedRowHandle); if (e.Column.FieldName.Equals(Column.FieldName)) { object[] Values = Func(row[Column.FieldName]); if (Values != null) { for (int i = 0; i < FieldNames.Length; i++) { grid.SetRowCellValue(grid.FocusedRowHandle, FieldNames[i], Values[i]); } } else { grid.DeleteRow(grid.FocusedRowHandle); } } } catch (Exception ex) { PLException.AddException(ex); } }; }
public GridViewQuickColumnCustomization(GridView view) { this.view = view; View.CustomDrawRowIndicator += new RowIndicatorCustomDrawEventHandler(View_CustomDrawRowIndicator); View.MouseDown += new System.Windows.Forms.MouseEventHandler(View_MouseDown); View.MouseUp += new System.Windows.Forms.MouseEventHandler(View_MouseUp); }
/// <summary> /// 合并GridView中某列相同信息的行(单元格) /// </summary> /// <param name="GridView1">GridView</param> /// <param name="cellNum">第几列</param> public static void GroupRows(GridView grv, int cellNum) { // i行控制器 int i = 0, rowSpanNum = 1; while (i < grv.Rows.Count - 1) { GridViewRow gvr = grv.Rows[i]; for (++i; i < grv.Rows.Count; i++) { GridViewRow gvrNext = grv.Rows[i]; if (gvr.Cells[cellNum].Text == gvrNext.Cells[cellNum].Text) { gvrNext.Cells[cellNum].Visible = false; rowSpanNum++; } else { gvr.Cells[cellNum].RowSpan = rowSpanNum; rowSpanNum = 1; break; } if (i == grv.Rows.Count - 1) { gvr.Cells[cellNum].RowSpan = rowSpanNum; } } } }
public static XtraGridControl Create(string name = null, DockStyle dockStyle = DockStyle.None, int? x = null, int? y = null, int? width = null, int? height = null) { XtraGridControl grid = new XtraGridControl(); GridView gridView = new GridView(); ((ISupportInitialize)grid).BeginInit(); ((ISupportInitialize)gridView).BeginInit(); grid.MainView = gridView; grid.Name = name; grid.Dock = dockStyle; grid.Font = new Font("Courier New", 8.25F, FontStyle.Regular, GraphicsUnit.Point, 0); Point? point = zForm.GetPoint(x, y); if (point != null) grid.Location = (Point)point; Size? size = zForm.GetSize(width, height); if (size != null) grid.Size = (Size)size; //grid.TabIndex = 0; gridView.GridControl = grid; ((ISupportInitialize)grid).EndInit(); ((ISupportInitialize)gridView).EndInit(); return grid; }
public GridViewPrinter(GridControl aGrid, PrintDocument aPrintDocument, GridView aTable) { TheDataGrid = aGrid; ThePrintDocument = aPrintDocument; TheTable = aTable; if (aPrintDocument.DefaultPageSettings.Landscape) { PageWidth = ThePrintDocument.DefaultPageSettings.PaperSize.Height; PageHeight = ThePrintDocument.DefaultPageSettings.PaperSize.Width; TopMargin = ThePrintDocument.DefaultPageSettings.Margins.Right; BottomMargin = ThePrintDocument.DefaultPageSettings.Margins.Left; LeftMargin = ThePrintDocument.DefaultPageSettings.Margins.Top; RightMargin = ThePrintDocument.DefaultPageSettings.Margins.Bottom; } else { PageWidth = ThePrintDocument.DefaultPageSettings.PaperSize.Width; PageHeight = ThePrintDocument.DefaultPageSettings.PaperSize.Height; TopMargin = ThePrintDocument.DefaultPageSettings.Margins.Top; BottomMargin = ThePrintDocument.DefaultPageSettings.Margins.Bottom; } }
public frmClipboardItem(string entity, GridView dgv) { InitializeComponent(); ds = ((DataView)dgv.DataSource).Table.DataSet; gridControlDetails.DataSource = ClipboardMan.Instance.clipboard[entity].Data.Tables[0]; Entity = entity; }
public override void onResume() { base.onResume(); // Load from file "cities.json" first time if (mAdapter == null) { IList<City> cities = null; try { cities = loadCities(); } catch (IOException e) { Console.WriteLine(e.ToString()); Console.Write(e.StackTrace); } //This is the GridView adapter mAdapter = new CityAdapter(this); mAdapter.Data = cities; //This is the GridView which will display the list of cities mGridView = (GridView) findViewById(R.id.cities_list); mGridView.Adapter = mAdapter; mAdapter.notifyDataSetChanged(); mGridView.invalidate(); } }
public GameView(Game game, TextWriter output) { if (game == null) throw new ArgumentNullException("game", "[GameView.Constructor] Game must not be null."); if (output == null) throw new ArgumentNullException("output", "[GameView.Constructor] Output must not be null."); this.game = game; this.output = output; grid = new GridView<Entity>(output) { Descriptor = entity => entity.Symbol, PositionGetter = entity => entity.Position, ItemSource = () => game.AllEntities, GridWidth = game.Map.Width, GridHeight = game.Map.Height, DisplayWidth = 10, DisplayHeight = 10, }; if (output == System.Console.Out) { //grid.PreWrite = entity => System.Console.ForegroundColor = entity.Owner.Color.Value.ToConsoleColor(); //grid.PostWrite = entity => System.Console.ResetColor(); } game.TurnStarted += _ => Draw(); }
public SortSerializer( GridView gridView, IPersistentPairStorage storage, string key) : base(gridView, storage, key) { }
/// <summary> /// /// </summary> /// <param name="sw"></param> public static void Export(StringWriter sw, GridView gv) { using (HtmlTextWriter htw = new HtmlTextWriter(sw)) { // Create a table to contain the grid Table table = new Table(); // include the gridline settings table.GridLines = gv.GridLines; // add the header row to the table if (gv.HeaderRow != null) { table.Rows.Add(gv.HeaderRow); } // add each of the data rows to the table foreach (GridViewRow row in gv.Rows) { table.Rows.Add(row); } // add the footer row to the table if (gv.FooterRow != null) { table.Rows.Add(gv.FooterRow); } // render the table into the htmlwriter table.RenderControl(htw); } }
protected void btn1_Click(object sender, EventArgs e) { ControlClass d = new ControlClass(txtAspContent.Text); List<p1> lst = new List<p1>(); lst.Add(new p1 { Name = "hi1" }); lst.Add(new p1 { Name = "hi2" }); lst.Add(new p1 { Name = "hi3" }); lst.Add(new p1 { Name = "hi4" }); GridView ss = new GridView(); ss = ((GridView)d.ControlGenerated); ss.DataSource = lst; ss.DataBind(); foreach (GridViewRow row in ss.Rows) { if (row.RowType == DataControlRowType.DataRow) { Label myHyperLink = row.FindControl("lbl1") as Label; Label myHyperLnk1 = row.FindControl("Name2") as Label; } } foreach (GridViewRow row in gg1.Rows) { if (row.RowType == DataControlRowType.DataRow) { Label myHyperLink = row.FindControl("lbl1") as Label; } } plcHolder1.Controls.Add(ss); }
public void FormatColumns(GridView view) { foreach (GridColumn col in view.Columns) { switch (col.ColumnType.Name) { case "Boolean": col.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; break; case "Int": col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; col.DisplayFormat.FormatString = "#,##0"; break; case "Float": case "Double": col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; col.DisplayFormat.FormatString = "#,##0.00"; break; case "DateTime": col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime; col.DisplayFormat.FormatString = "dd-MMM-yyyy"; break; } } }
/// <summary> /// Thêm danh sách menu ngữ cảnh vào trong GridView. /// Menu này áp dụng khi click phải trên phần nội dung của lưới /// </summary> public static void AddContextMenu(GridView grid, List<ItemInfo> items) { BarManager manager = new BarManager(); ; PopupMenu menu = new PopupMenu(); if (items == null) return; for (int i = 0; i < items.Count; i++) { if (items[i].Per != null) if (ApplyPermissionAction.checkPermission(items[i].Per) == null || ApplyPermissionAction.checkPermission(items[i].Per) == false) { continue; } Image image = ResourceMan.getImage16(items[i].Image); BarItem item = new BarButtonItem(); item.Caption = items[i].Caption; item.Name = i.ToString(); item.Glyph = image; manager.Items.Add(item); menu.ItemLinks.Add(manager.Items[i]); DelegationLib.CallFunction_MulIn_NoOut del = items[i].Delegates; item.ItemClick += delegate(object sender, ItemClickEventArgs e) { string name = item.Name; List<object> objs = new List<object>(); int[] a = grid.GetSelectedRows(); DataRow dr = grid.GetDataRow(a[0]); objs.Add(dr); del(objs); }; } grid.MouseUp += delegate(object sender, MouseEventArgs e) { if ((e.Button & MouseButtons.Right) != 0 && grid.GridControl.ClientRectangle.Contains(e.X, e.Y)) { menu.ShowPopup(manager, Control.MousePosition); } else { menu.HidePopup(); } }; grid.MouseMove += delegate(object sender, MouseEventArgs e) { if ((e.Button & MouseButtons.Right) != 0 && grid.GridControl.ClientRectangle.Contains(e.X, e.Y)) { menu.ShowPopup(manager, Control.MousePosition); } else { menu.HidePopup(); } }; }
protected override void OnCreate(Bundle bundle) { base.OnCreate (bundle); // set our layout to be the home screen SetContentView(Resource.Layout.DataGridExampleScreen); gridView = FindViewById<GridView> (Resource.Id.offerGridView); var txtTitle = FindViewById<TextView> (Resource.Id.txtTitle); var txtAddColumn = FindViewById<TextView> (Resource.Id.txtAddColumn); var txtAddRow = FindViewById<TextView> (Resource.Id.txtAddRow); txtTitle.SetText ("Data Grid Example", TextView.BufferType.Normal); txtAddColumn.Click += (sender, e) => { dataTable.Columns.Add("New Col " + (dataTable.Columns.Count + 1)); gridView.NumColumns = dataTable.Columns.Count; gridView.InvalidateViews(); }; txtAddRow.Click += (sender, e) => { var row = dataTable.NewRow(); dataTable.Rows.Add(row); gridView.InvalidateViews(); }; }
public override void UpdateTempSub(GridView dgv) { DataTable dt1 = (DataTable)ViewState[FormID + "_Edit_" + dgv.ID]; if (dt1.Rows.Count == 0) { return; } DataRow dr; for (int i = 0; i < dgv.Rows.Count; i++) { dr = dt1.Rows[i + dgv.PageSize * dgv.PageIndex]; dr.BeginEdit(); dr["BillID"] = this.txtID.Text.Trim(); dr["RowID"] = ((Label)dgv.Rows[i].FindControl("RowID")).Text; dr["ProductCode"] = ((TextBox)dgv.Rows[i].FindControl("ProductCode")).Text; dr["ProductName"] = ((TextBox)dgv.Rows[i].FindControl("ProductName")).Text; dr["Quantity"] = ((TextBox)dgv.Rows[i].FindControl("Quantity")).Text; dr["Weight"] = ((TextBox)dgv.Rows[i].FindControl("Weight")).Text.Trim() == "" ? 0 : decimal.Parse(((TextBox)dgv.Rows[i].FindControl("Weight")).Text.Trim()); dr["Barcode"] = ((TextBox)dgv.Rows[i].FindControl("Barcode")).Text; dr["Memo"] = ((TextBox)dgv.Rows[i].FindControl("SubMemo")).Text; dr.EndEdit(); } dt1.AcceptChanges(); object o = dt1.Compute("SUM(Quantity)", ""); this.txtTotalQty.Text = o.ToString(); ViewState[FormID + "_Edit_" + dgv.ID] = dt1; }
public GridColumn[] CreateDM_DANH_BA(GridControl gridControl, GridView gridView) { HelpGridColumn.CotTextLeft( HelpGridColumn.ThemCot(gridView, "ID", -1, -1), "ID"); HelpGridColumn.CotTextLeft( HelpGridColumn.ThemCot(gridView, "Tên tài liệu", 0, 150), "NAME"); HelpGridColumn.CotTextLeft( HelpGridColumn.ThemCot(gridView, "Địa chỉ", 1, 150), "DIA_CHI"); HelpGridColumn.CotTextLeft( HelpGridColumn.ThemCot(gridView, "Số điện thoại", 2, 150), "SO_DIEN_THOAI"); HelpGridColumn.CotTextLeft( HelpGridColumn.ThemCot(gridView, "Di động", 3, 150), "DI_DONG"); HelpGridColumn.CotTextLeft( HelpGridColumn.ThemCot(gridView, "Fax", 4, 150), "SO_FAX"); HelpGridColumn.CotTextLeft( HelpGridColumn.ThemCot(gridView, "Người đại diện", 5, 150), "NGUOI_DAI_DIEN"); HelpGridColumn.CotTextLeft( HelpGridColumn.ThemCot(gridView, "Chức vụ", 6, 150), "CHUC_VU"); HelpGridColumn.CotTextLeft( HelpGridColumn.ThemCot(gridView, "Số tài khoản", 7, 150), "TAI_KHOAN"); XtraGridSupportExt.ComboboxGridColumn(HelpGridColumn.ThemCot(gridView, "Ngân hàng", 1, 150), " DM_BANK", "ID", "NAME", "TEN_NGAN_HANG").NullText = string.Empty; gridView.OptionsView.ColumnAutoWidth = false; gridView.OptionsView.ShowAutoFilterRow = false; gridView.OptionsView.ShowGroupedColumns = false; gridView.OptionsView.ShowFilterPanelMode = DevExpress.XtraGrid.Views.Base.ShowFilterPanelMode.Never; ((PLGridView)gridView).DefaultNewRow = ProtocolVN.Framework.Win.HelpGrid.CheckVisibleDefault; ((PLGridView)gridView)._SetUserLayout(); return null; }
public GridColumn[] CreateDM_NHAN_VIEN(GridControl gridControl, GridView gridView) { XtraGridSupportExt.TextLeftColumn( XtraGridSupportExt.CreateGridColumn(gridView, "ID", -1, -1), "ID"); XtraGridSupportExt.TextLeftColumn( XtraGridSupportExt.CreateGridColumn(gridView, "Mã nhân viên", 0, 150), "MA_NV"); GridColumn Ten = XtraGridSupportExt.CreateGridColumn(gridView, "Tên nhân viên", 1, 150); XtraGridSupportExt.TextLeftColumn( Ten, "NAME"); GridColumn ColPhongBan = XtraGridSupportExt.CreateGridColumn(gridView, "Tên phòng ban", 2, 150); ColPhongBan.FieldName = "DEPARTMENT_ID"; //XtraGridSupportExt.IDGridColumn(ColPhongBan, "ID", "NAME", "DEPARTMENT", "DEPARTMENT_ID"); HelpGridColumn.CotCombobox(ColPhongBan, HelpDB.getDatabase().LoadDataSet(@"SELECT * FROM DEPARTMENT WHERE PARENT_ID IS NOT NULL"), "ID", "NAME", "DEPARTMENT_ID"); ColPhongBan.OptionsColumn.AllowEdit = true; ColPhongBan.OptionsColumn.AllowFocus = false; ColPhongBan.OptionsColumn.ReadOnly = true; Ten.SortOrder = DevExpress.Data.ColumnSortOrder.Ascending; XtraGridSupportExt.TextLeftColumn( XtraGridSupportExt.CreateGridColumn(gridView, "CMND", 3, 150), "CMND"); XtraGridSupportExt.DateTimeGridColumn( XtraGridSupportExt.CreateGridColumn(gridView, "Ngày sinh", 4, 150), "NGAY_SINH"); XtraGridSupportExt.TextLeftColumn( XtraGridSupportExt.CreateGridColumn(gridView, "Điện thoại", 5, 150), "DIEN_THOAI"); XtraGridSupportExt.TextLeftColumn( XtraGridSupportExt.CreateGridColumn(gridView, "Địa chỉ", 6, 150), "DIA_CHI"); XtraGridSupportExt.TextLeftColumn( XtraGridSupportExt.CreateGridColumn(gridView, "Email", 7, 150), "EMAIL"); HelpGridColumn.CotCheckEdit( XtraGridSupportExt.CreateGridColumn(gridView, "Hiển thị", 8, 100), "VISIBLE_BIT"); gridView.OptionsView.ShowGroupedColumns = false; gridView.HorzScrollVisibility = DevExpress.XtraGrid.Views.Base.ScrollVisibility.Always; gridView.OptionsView.ColumnAutoWidth = true; return null; }
//private GridControl _gridResult1; //private GridView _gridView1; private void CreateXtraGrid() { _gridResult1 = new GridControl(); _gridView1 = new GridView(); ((ISupportInitialize)(_gridResult1)).BeginInit(); ((ISupportInitialize)(_gridView1)).BeginInit(); //tab_result.Controls.Add(_gridResult1); // // _gridResult1 // _gridResult1.Dock = DockStyle.Fill; _gridResult1.EmbeddedNavigator.Name = ""; _gridResult1.Font = new Font("Courier New", 8.25F, FontStyle.Regular, GraphicsUnit.Point, ((byte)(0))); _gridResult1.Location = new Point(3, 3); _gridResult1.MainView = _gridView1; _gridResult1.Name = "_gridResult1"; _gridResult1.Size = new Size(1042, 358); _gridResult1.TabIndex = 0; //_gridResult1.Text = "gridControl1"; // // gridView1 // _gridView1.GridControl = _gridResult1; _gridView1.Name = "_gridView1"; ((ISupportInitialize)(_gridResult1)).EndInit(); ((ISupportInitialize)(_gridView1)).EndInit(); tab_result1.Controls.Add(_gridResult1); }
/// <summary> /// 輸出為Excel /// </summary> /// <param name="webpage">傳入目前網頁Page變數</param> /// <param name="Dt">需要匯出的內容</param> /// <param name="FilePath">輸出的檔名</param> public void OutputExcel(Page webpage, DataTable Dt, string FilePath ) { GridView gvExport = new GridView(); gvExport.DataSource = Dt; gvExport.DataBind(); string UTF8FileName = HttpUtility.UrlEncode(FilePath, System.Text.Encoding.UTF8 ); webpage.Response.Clear(); webpage.Response.AddHeader("content-disposition", string.Format("attachment;filename={0}", UTF8FileName) ); webpage.Response.Cache.SetCacheability(HttpCacheability.NoCache); webpage.Response.ContentType = "application/vnd.ms-excel"; webpage.Response.Charset = "big5"; System.IO.StringWriter stringWrite = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); gvExport.RenderControl(htmlWrite); webpage.Response.Write(stringWrite.ToString().Replace("<div>", "").Replace("</div>", "")); webpage.Response.End(); }
public override View OnCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) { var root = inflater.Inflate(Resource.Layout.trakked_shows_gridview_layout, container, false); _gridView = root.FindViewById<GridView>(Resource.Id.trakkedGrid); _gridView.ItemClick += (object sender, AdapterView.ItemClickEventArgs e) => { var intent = new Intent(this.Activity, typeof (OverviewShowActivity)); //Change to show intent.PutExtra("TMDBID", "" + _myShowList[e.Position].TMDBID); StartActivity(intent); }; var fab = root.FindViewById<FloatingActionButton>(Resource.Id.fab); fab.AttachToListView(_gridView); fab.ColorNormal =new Color(255, 255, 0); fab.ColorPressed = new Color(255, 0, 255); fab.Click += delegate { var intent = new Intent(Activity, typeof(AddShowsTabActivity)); StartActivity(intent); }; BuildView(); return root; }
/// <summary>Chỉnh độ rộng của cột theo dạng đẹp nhất có thể /// </summary> public static void BestFitMasterColumns(GridView gridView) { gridView.GridControl.Load += delegate(object sender, EventArgs e) { gridView.BestFitColumns(); }; }
public void GanDuLieu(GridView tmpGrid) { tblTaskList = TaskOBJ.DBConnectionTaskList("SP_TASK_VIEW", Convert.ToInt32(Session["logedUser"]), Convert.ToInt32(Session["TaskType"])); if (tblTaskList.Rows.Count > 0) { dgrTaskList.Caption = "Danh sách công việc";//tblTaskList.Rows[0]["Danh sách hình ảnh đăng tải"].ToString(); tblTaskList.Columns.Add("Số TT", typeof(Int32)); // Add thứ tự công việc vào lưới for (int i = 0; i < tblTaskList.Rows.Count; i++) { tblTaskList.Rows[i]["Số TT"] = i + 1; } tmpGrid.DataSource = tblTaskList; tmpGrid.DataBind(); } else { } }
private void layout(ref GridView grid) { grid.ItemsSource = null; items = new ObservableCollection<Grid>(); index = 0; numbers = select(1, 90, 90); }
protected void ddlBind(GridView gv) { if (gv.BottomPagerRow != null) { //讓下拉式選單顯示頁數 DropDownList ddlSelectPage = (DropDownList)gv.BottomPagerRow.FindControl("ddlSelectPage"); for (int i = 0; i < GD_CATE.PageCount; i++) { ddlSelectPage.Items.Add(new ListItem("第" + (i + 1).ToString() + "頁", i.ToString())); } //顯示目前頁數 ddlSelectPage.SelectedIndex = gv.PageIndex; //下拉選單顯示頁面資料列數 /*DropDownList ddlSelectPageSize = (DropDownList)gv.BottomPagerRow.FindControl("ddlSelectPageSize"); if (ddlSelectPageSize.Items.Count <= 0) { ddlSelectPageSize.Items.Add(new ListItem("每頁1筆", "1")); ddlSelectPageSize.Items.Add(new ListItem("每頁2筆", "2")); ddlSelectPageSize.Items.Add(new ListItem("每頁3筆", "3")); }*/ //顯示目前列數 //ddlSelectPageSize.SelectedValue = gv.PageSize.ToString(); } }
/// <summary> /// 绑定数据到GridView,当表格数据为空时显示表头 /// </summary> /// <param name="gridview"></param> /// <param name="table">not null</param> public static void GridViewDataBind(GridView gridview, DataTable table) { if (table == null) throw new NullReferenceException(); //记录为空重新构造Gridview if (table.Rows.Count == 0) { table = table.Clone(); table.Rows.Add(table.NewRow()); gridview.DataSource = table; gridview.DataBind(); int columnCount = table.Columns.Count; gridview.Rows[0].Cells.Clear(); gridview.Rows[0].Cells.Add(new TableCell()); gridview.Rows[0].Cells[0].ColumnSpan = columnCount; gridview.Rows[0].Cells[0].Text = EmptyText; gridview.Rows[0].Cells[0].Style.Add("text-align", "center"); } else { //数据不为空直接绑定 gridview.DataSource = table; gridview.DataBind(); } //重新绑定取消选择 gridview.SelectedIndex = -1; }
protected void Page_Load(object sender, EventArgs e) { List<Event> events = Event.GetAllEvents(); foreach (Event ev in events) { Panel pnlEvent = new Panel(); pnlEvent.ID = ev.ID.ToString(); Label lblEventName = new Label(); lblEventName.Text = ev.Name; Label lblNumberOfParticipants = new Label(); pnlEvent.Controls.Add(lblEventName); pnlEvent.Controls.Add(lblNumberOfParticipants); GridView grdvwParticipation = new GridView(); grdvwParticipation.DataSource = Event.GetRegisteredParticipants(ev, 0); grdvwParticipation.DataBind(); pnlEvent.Controls.Add(grdvwParticipation); pnlDetails.Controls.Add(pnlEvent); if (ev.IsSinglePlayer) { foreach (GridViewRow row in grdvwParticipation.Rows) { row.Cells[0].Text = "TT" + row.Cells[0].Text; } lblNumberOfParticipants.Text = "Total Participants: " + grdvwParticipation.Rows.Count.ToString(); } else { var numberOfTeams = (from i in grdvwParticipation.Rows.Cast<GridViewRow>() select new { Teamid = i.Cells[0].Text }).Distinct().Count(); lblNumberOfParticipants.Text = "Total Teams: " + numberOfTeams.ToString(); } } }
///<summary> ///绑定数据到GridView,当表格数据为空时显示表头 ///</summary> ///<param name="gridview"></param> ///<param name="table"></param> public static void GridViewDataBind(GridView gridview, DataTable table) { //记录为空重新构造Gridview EmptyText = Resources.MyGlobal.NoDataText; if (table.Rows.Count == 0) { table = table.Clone(); table.Rows.Add(table.NewRow()); int columnCount = table.Columns.Count; gridview.DataSource = table; gridview.DataBind(); gridview.Rows[0].Cells.Clear(); gridview.Rows[0].Cells.Add(new TableCell()); gridview.Rows[0].Cells[0].ColumnSpan = columnCount; gridview.Rows[0].Cells[0].Text = EmptyText; gridview.Rows[0].Cells[0].Style.Add("text-align", "center"); gridview.Rows[0].Cells[0].Style.Add("color", "red"); gridview.Rows[0].Style.Add("height", "24px"); //gridview.HeaderRow.Enabled = false; } else { //数据不为空直接绑定 gridview.DataSource = table; gridview.DataBind(); } //重新绑定取消选择 gridview.SelectedIndex = -1; }
public void CheckDuplicateDIEM_THEO_DOI_NOP_BAI(GridView grid, DataSet GridDataSet, DevExpress.XtraGrid.Views.Base.ValidateRowEventArgs e) { DataRow row = grid.GetDataRow(e.RowHandle); int count = 0; foreach (DataRow r in GridDataSet.Tables[0].Rows) { if (r.RowState != DataRowState.Deleted) { if (r["NHAN_SU"].ToString() == row["NHAN_SU"].ToString() && r["NGUOI_GIAO"].ToString() == row["NGUOI_GIAO"].ToString() && r["NGAY_GIAO"].ToString() == row["NGAY_GIAO"].ToString()) { if (grid.IsNewItemRow(grid.FocusedRowHandle)) { r.RowError = "Dữ liệu bị trùng, xin vui lòng kiểm tra lại."; grid.SetColumnError(grid.Columns["NHAN_SU"], "Nhân sự, người giao và ngày giao bị trùng, xin vui lòng kiểm tra lại."); e.Valid = false; return; } else { count++; if (count == 2) { r.RowError = "Dữ liệu bị trùng, xin vui lòng kiểm tra lại."; grid.SetColumnError(grid.Columns["NHAN_SU"], "Nhân sự, người giao và ngày giao bị trùng, xin vui lòng kiểm tra lại."); e.Valid = false; return; } } } } } }
public static ArrayList ExtractSummaryItems(GridView view) { var items = new ArrayList(); foreach (GridSummaryItem si in view.GroupSummary.Cast<GridSummaryItem>().Where(si => si is GridGroupSummaryItem && si.SummaryType != SummaryItemType.None)) items.Add(si); return items; }
public void ExportExcel(DataTable dt, string title, string from_time, string to_time, string User) { GridView GridView8 = new GridView(); GridView8.AllowPaging = false; DataTable dt_Header = new DataTable(); dt_Header.Columns.Add("Thong_Tin", typeof(string)); dt_Header.Rows.Add(""); dt_Header.Rows.Add("" + title); dt_Header.Rows.Add(""); dt_Header.Rows.Add("User: "******""); dt_Header.Rows.Add("Tu ngay: " + from_time); dt_Header.Rows.Add("Den ngay: " + to_time); dt_Header.Rows.Add(""); GridView GridView7 = new GridView(); GridView7.AllowPaging = false; GridView7.DataSource = dt_Header; GridView7.BorderStyle = BorderStyle.None; GridView7.DataBind(); //Add row if no data found //if (dt.Rows.Count <= 0) //{ // int num_col = dt.Columns.Count; // dt.Rows.Add(); //} GridView8.DataSource = dt; GridView8.DataBind(); Response.Clear(); Response.Buffer = true; Response.AddHeader("content-disposition", "attachment;filename=" + User + "_Report.xls"); Response.Charset = ""; Response.ContentType = "application/vnd.ms-excel"; StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); for (int i = 0; i < GridView7.Rows.Count; i++) { //Apply text style to each Row GridView7.Rows[i].Attributes.Add("class", "textmode"); } GridView7.RenderControl(hw); for (int i = 0; i < GridView8.Rows.Count; i++) { //Apply text style to each Row GridView8.Rows[i].Attributes.Add("class", "textmode"); } GridView8.RenderControl(hw); //style to format numbers to string string style = @"<style> .textmode { mso-number-format:\@; } </style>"; Response.Write(style); Response.Output.Write(sw.ToString()); Response.Flush(); Response.End(); }
private DynamicLayout Init(out GridView gd) { var layout = new DynamicLayout(); layout.DefaultPadding = new Padding(5); layout.DefaultSpacing = new Size(5, 5); var addNew = new Button { Text = "Add" }; addNew.Command = _vm.AddCommand; var duplicate = new Button { Text = "Duplicate" }; duplicate.Command = _vm.DuplicateCommand; var edit = new Button { Text = "Edit" }; edit.Command = _vm.EditCommand; var remove = new Button { Text = "Remove" }; remove.Command = _vm.RemoveCommand; layout.AddSeparateRow("Materials:", null, addNew, duplicate, edit, remove); // search bar var filter = new TextBox() { PlaceholderText = "Filter" }; filter.TextBinding.Bind(_vm, _ => _.FilterKey); layout.AddSeparateRow(filter); gd = GenGridView(); layout.AddSeparateRow(controls: new[] { gd }, xscale: true, yscale: true); // counts var counts = new Label(); counts.TextBinding.Bind(_vm, _ => _.Counts); // unit switchs var unit = new RadioButtonList(); unit.Items.Add("Metric"); unit.Items.Add("Imperial"); unit.SelectedIndex = 0; unit.Spacing = new Size(5, 0); unit.SelectedIndexChanged += (s, e) => _vm.UseIPUnit = unit.SelectedIndex == 1; layout.AddSeparateRow(counts, null, unit); var OKButton = new Button { Text = "OK" }; OKButton.Click += (sender, e) => OkCommand.Execute(null); AbortButton = new Button { Text = "Cancel" }; AbortButton.Click += (sender, e) => Close(); layout.AddSeparateRow(null, OKButton, AbortButton, null); gd.CellDoubleClick += (s, e) => _vm.EditCommand.Execute(null); return(layout); }
protected void drop_page_size_DataBinding(object sender, EventArgs e) { GridView gridData = fnGetNowGridView(); DropDownList dropData = ((DropDownList)sender); GridViewEvent.fnDropPageSizeDataBinding(ref gridData, ref dropData); }
protected void drop_page_size_SelectedIndexChanged(object sender, EventArgs e) { GridView gridData = fnGetNowGridView(); DropDownList dropData = ((DropDownList)sender); GridViewEvent.fnDropPageSizeSelectedIndexChanged(ref gridData, ref dropData); }
protected void linkbtn_previous_Click(object sender, EventArgs e) { GridView gridData = fnGetNowGridView(); GridViewEvent.fnPreviousPageEvent(ref gridData); }
protected void linkbtn_next_Click(object sender, EventArgs e) { GridView gridData = fnGetNowGridView(); GridViewEvent.fnNextPageEvent(ref gridData); }
private GridView GenGridView() { var gd = new GridView(); gd.Bind(_ => _.DataStore, _vm, _ => _.GridViewDataCollection); gd.SelectedItemsChanged += (s, e) => { _vm.SelectedData = gd.SelectedItem as MaterialViewData; }; gd.Height = 250; gd.Columns.Add(new GridColumn { DataCell = new TextBoxCell { Binding = Binding.Delegate <MaterialViewData, string>(r => r.Name) }, HeaderText = "Name", Sortable = true, Width = 200 }); gd.Columns.Add(new GridColumn { DataCell = new TextBoxCell { Binding = Binding.Delegate <MaterialViewData, string>(r => r.CType) }, HeaderText = "Type", Sortable = true, Width = 100 }); gd.Columns.Add(new GridColumn { DataCell = new TextBoxCell { Binding = Binding.Delegate <MaterialViewData, string>(r => r.RValue) }, HeaderText = "RValue", Sortable = true }); gd.Columns.Add(new GridColumn { DataCell = new TextBoxCell { Binding = Binding.Delegate <MaterialViewData, string>(r => r.UValue) }, HeaderText = "UValue", Sortable = true }); gd.Columns.Add(new GridColumn { DataCell = new TextBoxCell { Binding = Binding.Delegate <MaterialViewData, string>(r => r.UFactor) }, HeaderText = "UFactor", Sortable = true }); gd.Columns.Add(new GridColumn { DataCell = new TextBoxCell { Binding = Binding.Delegate <MaterialViewData, string>(r => r.SHGC) }, HeaderText = "SHGC", Sortable = true }); gd.Columns.Add(new GridColumn { DataCell = new TextBoxCell { Binding = Binding.Delegate <MaterialViewData, string>(r => r.TSolar) }, HeaderText = "TSolar", Sortable = true }); gd.Columns.Add(new GridColumn { DataCell = new TextBoxCell { Binding = Binding.Delegate <MaterialViewData, string>(r => r.TVis) }, HeaderText = "TVis", Sortable = true }); gd.Columns.Add(new GridColumn { DataCell = new CheckBoxCell { Binding = Binding.Delegate <MaterialViewData, bool?>(r => r.Locked) }, HeaderText = "Locked", Sortable = true }); gd.Columns.Add(new GridColumn { DataCell = new TextBoxCell { Binding = Binding.Delegate <MaterialViewData, string>(r => r.Source) }, HeaderText = "Source", Sortable = true }); // sorting by header gd.ColumnHeaderClick += OnColumnHeaderClick; return(gd); }
/// <summary> /// Raises the <see cref="E:System.Web.UI.Control.Init"/> event. /// </summary> /// <param name="e">An <see cref="T:System.EventArgs"/> object that contains the event data.</param> protected override void OnInit(EventArgs e) { // // We have to have a ToolkitScriptManager on the page but, we can't require that the // developer add one to the page because this might be a SharePoint environment // so, we added this code to Page.Init to add a ToolkitScriptManager if there isn't one. // Page.Init += delegate(object sender, EventArgs e_Init) { if (ToolkitScriptManager.GetCurrent(Page) == null) { ToolkitScriptManager sMgr = new ToolkitScriptManager(); if (Page.Form == null) { throw new HttpException("Control must be located inside of a <form> tag."); } Page.Form.Controls.AddAt(0, sMgr); } }; // if (!Page.IsCallback) { m_GridView = new GridView(); m_MonitorData = new MonitorDataSource(); m_GridView.DataSource = m_MonitorData; m_GridView.AutoGenerateColumns = false; } if (!DesignMode) { // // Add our stylesheet // HtmlLink link = new HtmlLink(); link.Href = Page.ClientScript.GetWebResourceUrl(this.GetType(), "MVPSI.JAMSWeb.Controls.Resources.JAMSLoadingStyles.css"); link.Attributes.Add("type", "text/css"); link.Attributes.Add("rel", "stylesheet"); Page.Header.Controls.Add(link); HtmlLink link2 = new HtmlLink(); link2.Href = Page.ClientScript.GetWebResourceUrl(this.GetType(), "MVPSI.JAMSWeb.Controls.SubmitDialog.JAMSSubmitStyles.css"); link2.Attributes.Add("type", "text/css"); link2.Attributes.Add("rel", "stylesheet"); Page.Header.Controls.Add(link2); } m_GridView.CssClass = "monitorControl"; UpdatePanel = new UpdatePanel { ID = GetChildControlID("UpdatePanel") }; UpdatePanel.ChildrenAsTriggers = true; UpdatePanel.RenderMode = UpdatePanelRenderMode.Block; //Setup loading dialog var popup = new ModalPopupExtender(); popup.PopupControlID = GetChildControlID("LoadingDialog"); popup.DropShadow = false; popup.RepositionMode = ModalPopupRepositionMode.RepositionOnWindowResize; popup.TargetControlID = GetChildControlID("DummyButton"); popup.ID = GetChildControlID("PopupExtender"); popup.BehaviorID = GetChildControlID("PopupExtender"); Button button = new Button(); button.ID = GetChildControlID("DummyButton"); button.Style["display"] = "none"; button.Height = 0; button.Width = 0; button.UseSubmitBehavior = false; Panel loadingDialog = new Panel(); Label loadingLabel = new Label(); Image img = new Image(); loadingLabel.Style["width"] = "auto"; loadingLabel.Style["margin"] = "4%"; loadingLabel.Text = "Loading..."; img.ImageUrl = Page.ClientScript.GetWebResourceUrl(this.GetType(), "MVPSI.JAMSWeb.Controls.Resources.LoadIcon.gif"); loadingDialog.Controls.Add(img); loadingDialog.Controls.Add(loadingLabel); loadingDialog.ID = GetChildControlID("LoadingDialog"); loadingDialog.Style["height"] = "50px"; loadingDialog.HorizontalAlign = HorizontalAlign.Left; loadingDialog.CssClass = "loadingPopup"; Panel noResultsPanel = new Panel(); Label noResultsLabel = new Label(); noResultsLabel.Text = "No results found"; noResultsLabel.Style["width"] = "auto"; noResultsLabel.Style["margin"] = "4%"; noResultsPanel.ID = GetChildControlID("NoResultsPanel"); noResultsPanel.Controls.Add(noResultsLabel); m_NoResultsPanel = noResultsPanel; m_MonitorDialog.ID = GetChildControlID("MonitorDetail"); m_MonitorDialog.ServerName = this.ServerName; var dialogPopup = new ModalPopupExtender(); dialogPopup.PopupControlID = m_MonitorDialog.ClientID; dialogPopup.DropShadow = false; dialogPopup.RepositionMode = ModalPopupRepositionMode.RepositionOnWindowResize; dialogPopup.TargetControlID = GetChildControlID("DummyButton2"); dialogPopup.ID = GetChildControlID("DialogPopupExtender"); dialogPopup.BackgroundCssClass = "modalBackground"; m_MonitorDialog.Extender = dialogPopup; m_MonitorDialog.ParentMonitor = this; var dummyButton2 = new Button(); dummyButton2.ID = GetChildControlID("DummyButton2"); dummyButton2.Style["display"] = "none"; dummyButton2.Height = 0; dummyButton2.Width = 0; dummyButton2.UseSubmitBehavior = false; var errorDummyButton = new Button { ID = GetChildControlID("ErrorDummyButton"), UseSubmitBehavior = false }; errorDummyButton.Style["Display"] = "None"; m_ErrorPanel = new Panel { ID = GetChildControlID("ErrorDialogPanel") }; m_ErrorPanel.Controls.Add(new Label { Text = "Error", CssClass = "tabContents" }); m_ErrorPanel.Controls.Add(new Button { Text = "OK", ID = GetChildControlID("ErrorOk") }); m_ErrorPanel.CssClass = "modalPopup"; m_ErrorPanel.Style["Display"] = "None"; m_ErrorDialog = new ModalPopupExtender { ID = GetChildControlID("ErrorDialog") }; m_ErrorDialog.PopupControlID = m_ErrorPanel.ClientID; m_ErrorDialog.DropShadow = false; m_ErrorDialog.RepositionMode = ModalPopupRepositionMode.RepositionOnWindowResize; m_ErrorDialog.TargetControlID = errorDummyButton.ClientID; m_ErrorDialog.BackgroundCssClass = "modalBackground"; m_ErrorDialog.CancelControlID = GetChildControlID("ErrorOk"); m_ErrorDialog.BehaviorID = m_ErrorDialog.ID; Control controlContainer = UpdatePanel.ContentTemplateContainer; controlContainer.Controls.Add(m_GridView); controlContainer.Controls.Add(m_MonitorData); controlContainer.Controls.Add(m_MonitorDialog); controlContainer.Controls.Add(m_MonitorDialog.Extender); controlContainer.Controls.Add(dummyButton2); controlContainer.Controls.Add(loadingDialog); controlContainer.Controls.Add(button); controlContainer.Controls.Add(popup); controlContainer.Controls.Add(noResultsPanel); controlContainer.Controls.Add(m_ErrorPanel); controlContainer.Controls.Add(m_ErrorDialog); controlContainer.Controls.Add(errorDummyButton); SubPanel = new Panel(); controlContainer.Controls.Add(SubPanel); base.OnInit(e); }
public LibraryGridViewHandler(GridView view) : base(view) { }
public virtual void HandleExport(HttpContext context, string response) { string exportType = context.Request.Params["exportType"]; context.Response.AddHeader("Content-Disposition", "attachment; filename=" + GetFileName(context) + ";"); if (string.IsNullOrEmpty(exportType)) { context.Response.ContentType = "application/csv"; context.Response.Write(response); } else { GridView gv = CSVtoGridView(response); if (exportType.Equals("excel", StringComparison.CurrentCultureIgnoreCase)) { context.Response.Clear(); context.Response.Buffer = true; context.Response.Charset = ""; context.Response.ContentType = "application/vnd.ms-excel"; StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); for (int i = 0; i < gv.Rows.Count; i++) { //Apply text style to each Row gv.Rows[i].Attributes.Add("class", "textmode"); } gv.RenderControl(hw); //style to format numbers to string string style = @"<style> .textmode { mso-number-format:\@; } </style>"; context.Response.Write(style); context.Response.Output.Write(sw.ToString()); context.Response.Flush(); } else if (exportType.Equals("word", StringComparison.CurrentCultureIgnoreCase)) { context.Response.Clear(); context.Response.Buffer = true; context.Response.Charset = ""; context.Response.ContentType = "application/vnd.ms-word "; StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); gv.RenderControl(hw); context.Response.Output.Write(sw.ToString()); context.Response.Flush(); } else if (exportType.Equals("pdf", StringComparison.CurrentCultureIgnoreCase)) { context.Response.ContentType = "application/pdf"; context.Response.Cache.SetCacheability(HttpCacheability.NoCache); StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); gv.RenderControl(hw); StringReader sr = new StringReader(sw.ToString()); Document pdfDoc = new Document(PageSize.A4.Rotate(), 10f, 10f, 10f, 0f); HTMLWorker htmlparser = new HTMLWorker(pdfDoc); PdfWriter.GetInstance(pdfDoc, context.Response.OutputStream); pdfDoc.Open(); htmlparser.Parse(sr); pdfDoc.Close(); context.Response.Write(pdfDoc); } } context.Response.End(); }
private void FocusNewRow(GridView childView) { gridControl1.FocusedView = childView; childView.ShowEditor(); }
private void ExpandNewRow(GridView view) { view.MasterRowExpanded += new CustomMasterRowEventHandler(OnGridViewMasterRowExpanded); view.SetMasterRowExpanded(view.GetRowHandle(((IList)view.DataSource).Count - 1), true); }
protected void gvrBitacoraPLD_RowDataBound(object sender, GridViewRowEventArgs e) { try { GridView gridView = (GridView)sender; if (e.Row.RowType == DataControlRowType.DataRow) { if (((BitacoraPLD)(e.Row.DataItem)).datFechaRespuesta != null) { e.Row.ForeColor = System.Drawing.Color.Red; } } // gridView.Columns[8].Visible = !chkMuestraHist.Checked; if (gridView.SortExpression.Length > 0) { int cellIndex = -1; //foreach (DataControlField field in gridView.Columns) //{ // if (field.SortExpression == gridView.SortExpression) // { // cellIndex = gridView.Columns.IndexOf(field); // break; // } //} if (((BitacoraPLD)(e.Row.DataItem)).datFechaRespuesta == null) { if (cellIndex > -1) { if (e.Row.RowType == DataControlRowType.Header) { if (gridView.SortDirection == SortDirection.Ascending) { e.Row.Cells[cellIndex].CssClass = "sortascheaderstyle"; } else { e.Row.Cells[cellIndex].CssClass = "sortdescheaderstyle"; } } else if (e.Row.RowType == DataControlRowType.DataRow) { if ((e.Row.RowIndex % 2) == 0) { e.Row.Cells[cellIndex].CssClass = "sortalternatingrowstyle"; } else { e.Row.Cells[cellIndex].CssClass = "sortrowstyle"; } } } } } if (e.Row.RowIndex != -1) { if (((BitacoraPLD)(e.Row.DataItem)).datFechaRespuesta == null) { e.Row.Attributes.Add("onmouseover", "javascript:this.style.color='#FF8000';"); e.Row.Attributes.Add("onmouseout", "javascript:this.style.color='#284775';"); } } if (e.Row.RowType == DataControlRowType.Pager) { Label lblTotalNumberOfPages = (Label)e.Row.FindControl("lblTotalNumberOfPages"); lblTotalNumberOfPages.Text = gridView.PageCount.ToString(); TextBox txtGoToPage = (TextBox)e.Row.FindControl("txtGoToPage"); txtGoToPage.Text = (gridView.PageIndex + 1).ToString(); DropDownList ddlPageSize = (DropDownList)e.Row.FindControl("ddlPageSize"); ddlPageSize.SelectedValue = gridView.PageSize.ToString(); } } catch (Exception ex) { this.wucMensajeSistema.setMensaje(ex.Message, 2); } }
public static void ExportToExcel1(DataTable table) { GridView grid = new GridView { DataSource = table }; grid.DataBind(); HttpContext.Current.Response.Clear(); HttpContext.Current.Response.ClearContent(); HttpContext.Current.Response.ClearHeaders(); HttpContext.Current.Response.Buffer = true; HttpContext.Current.Response.ContentType = "application/ms-excel"; HttpContext.Current.Response.Write(@"<!DOCTYPE HTML PUBLIC ""-//W3C//DTD HTML 4.0 Transitional//EN"">"); HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=Reports.xls"); HttpContext.Current.Response.Charset = "utf-8"; HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("windows-1250"); //sets font HttpContext.Current.Response.Write("<font style='font-size:10.0pt; font-family:Calibri;'>"); HttpContext.Current.Response.Write("<BR><BR><BR>"); //sets the table border, cell spacing, border color, font of the text, background, foreground, font height HttpContext.Current.Response.Write("<Table border='1' bgColor='#ffffff' " + "borderColor='#000000' cellSpacing='0' cellPadding='0' " + "style='font-size:10.0pt; font-family:Calibri; background:white;'> <TR>"); //am getting my grid's column headers int columnscount = grid.Columns.Count; if (columnscount > 0) { for (int j = 0; j < columnscount; j++) { //write in new column HttpContext.Current.Response.Write("<Td>"); //Get column headers and make it as bold in excel columns HttpContext.Current.Response.Write("<B>"); HttpContext.Current.Response.Write(grid.Columns[j].HeaderText.ToString()); HttpContext.Current.Response.Write("</B>"); HttpContext.Current.Response.Write("</Td>"); } } else { foreach (DataColumn column in table.Columns) { HttpContext.Current.Response.Write("<Td>"); HttpContext.Current.Response.Write("<B>"); HttpContext.Current.Response.Write(column.ColumnName); HttpContext.Current.Response.Write("</B>"); HttpContext.Current.Response.Write("</Td>"); } } HttpContext.Current.Response.Write("</TR>"); foreach (DataRow row in table.Rows) {//write in new row HttpContext.Current.Response.Write("<TR>"); for (int i = 0; i < table.Columns.Count; i++) { //HttpContext.Current.Response.Write("<Td>"); HttpContext.Current.Response.Write("<style> .txt " + "\r\n" + " {mso-style-parent:style0;mso-number-format:\"" + @"\@" + "\"" + ";} " + "\r\n" + "</style>"); HttpContext.Current.Response.Write("<Td class='txt'>"); HttpContext.Current.Response.Write(row[i].ToString()); HttpContext.Current.Response.Write("</Td>"); } HttpContext.Current.Response.Write("</TR>"); } HttpContext.Current.Response.Write("</Table>"); HttpContext.Current.Response.Write("</font>"); HttpContext.Current.Response.Flush(); HttpContext.Current.Response.End(); }
protected void Load_ICC(int measureID) { SQL_utils sql = new SQL_utils(); if (print_jminfo) { jminfo.Text += " ==>Load_ICC..<br/>"; } TestICC(); string sqlcode3 = "select measname from uwautism_research_backend..tblMeasure where measureID = " + measureID.ToString(); string measname = sql.StringScalar_from_SQLstring(sqlcode3); //lblPctCoded.Text = ddl.SelectedItem + "<br/>" + x; lblPctCoded.Text = measname; //Pct Agree string sqlcode_pctagree = "exec spRELv2_GET_PCTAgree_by_measure " + _content_studyID.ToString() + ", " + measureID.ToString(); if (print_jminfo) { jminfo.Text += " ==> " + sqlcode_pctagree + "<br/>"; } DataTable dt_pctagree = sql.DataTable_from_SQLstring(sqlcode_pctagree); GridView gv_PctAgree_by_subscale = (GridView)UpdatePanel_ICC.FindControl("gv_PctAgree_by_subscale"); gv_PctAgree_by_subscale.DataSource = dt_pctagree; gv_PctAgree_by_subscale.DataBind(); //PLOTS //UpdatePanel_plots.ContentTemplateContainer.Controls.Clear(); UpdatePanel_ICC.Visible = true; UpdatePanel_ICC.Update(); #region Scatterplots & ICC DataTable dt_score_vars = sql.DataTable_from_SQLstring(" select fldname, minval, maxval, fieldlabel from def.vwFld where measureID=" + measureID.ToString() + " and relitem = 2 "); List <string> vars = dt_score_vars.AsEnumerable().Select(f => f.Field <string>("fldname")).ToList(); //foreach (string v in vars) foreach (DataRow var_row in dt_score_vars.Rows) { string v = var_row["fldname"].ToString(); int minval = utilStats.MakeInt(var_row["minval"].ToString(), 0); int maxval = utilStats.MakeInt(var_row["maxval"].ToString(), 999); Label lbl = new Label(); lbl.Text = v + "</br>" + var_row["fieldlabel"].ToString();; lbl.Font.Bold = true; lbl.Font.Size = 12; // UpdatePanel_plots.ContentTemplateContainer.Controls.Add(lbl); UpdatePanel_plots.Controls.Add(lbl); string x = "exec spRELv2_Get_Scores_for_var '" + v + "', " + Master.Master_studyID.ToString() + ", " + measureID.ToString() + ", 'exclude missing', 2"; string x_missing = "exec spRELv2_Get_Scores_for_var '" + v + "', " + Master.Master_studyID.ToString() + ", " + measureID.ToString() + ", 'missing only', 2"; DataTable dt_scatter = sql.DataTable_from_SQLstring(x); DataTable dt_scatter_missing = sql.DataTable_from_SQLstring(x_missing); if (dt_scatter_missing.Rows.Count > 0) { //show the missing cases here } if (dt_scatter.Rows.Count > 0) { foreach (DataColumn dc in dt_scatter.Columns) { dc.ReadOnly = false; } //var scat1 = utilCharts.ScatterPlots(dt_scatter, "orig_val_float", "rel_val_float", 400, 400); //UpdatePanel_plots.ContentTemplateContainer.Controls.Add(scat1); var data_minval_o = dt_scatter.AsEnumerable().Select(f => f.Field <double>("orig_val_float")).Min(); var data_minval_r = dt_scatter.AsEnumerable().Select(f => f.Field <double>("rel_val_float")).Min(); var data_maxval_o = dt_scatter.AsEnumerable().Select(f => f.Field <double>("orig_val_float")).Max(); var data_maxval_r = dt_scatter.AsEnumerable().Select(f => f.Field <double>("rel_val_float")).Max(); int data_minval = Convert.ToInt32((data_minval_o < data_minval_r) ? data_minval_o : data_minval_r); int data_maxval = Convert.ToInt32((data_maxval_o < data_maxval_r) ? data_maxval_o : data_maxval_r) + 1; //Scatterplot string scat = utilCharts.Highcharts_Scatter("scat2" + v, dt_scatter, "orig_val_float", "rel_val_float", "series_label", "numeric", "Scatterplot of " + v, "Original value", "REL value" , 500, 350, "pointurl", "", "", data_minval, data_maxval, data_minval, data_maxval, true, "x=y"); Literal lit_scat = new Literal(); lit_scat.Text = scat; //F statitics string datatype = dt_scatter.AsEnumerable().Select(f => f.Field <string>("data_type")).First(); double[] orig = utilStats.DataColumn_to_ArrayDouble(dt_scatter, "orig_val", datatype); double[] rel = utilStats.DataColumn_to_ArrayDouble(dt_scatter, "rel_val", datatype); utilStats.ICCstats icc = utilStats.ShroutFleissICC(dt_scatter, "orig_val", "rel_val", datatype); Literal lit_data = new Literal(); lit_data.Text += "<br/><br/><b><i>Reproduce this in R with the following code:</i></b><br/>"; lit_data.Text += "library(psych)<br/>"; lit_data.Text += "Orig <- c( " + String.Join(",", orig.Select(p => p.ToString()).ToArray()) + ")<br/>"; lit_data.Text += "Rel <- c(" + String.Join(",", rel.Select(p => p.ToString()).ToArray()) + ")<br/>"; lit_data.Text += "d <- data.frame(cbind(Orig, Rel))<br/>"; lit_data.Text += "ICC(d, alpha=.05)"; Table tbl = new Table(); TableRow row = new TableRow(); TableCell cell1 = new TableCell(); cell1.VerticalAlign = VerticalAlign.Top; cell1.Controls.Add(lbl); cell1.Controls.Add(lit_scat); TableCell cell2 = new TableCell(); cell2.VerticalAlign = VerticalAlign.Top; cell2.Controls.Add(utilStats.ICCstats_ToHTML(icc)); cell2.Controls.Add(lit_data); row.Cells.Add(cell1); row.Cells.Add(cell2); tbl.Rows.Add(row); //UpdatePanel_plots.ContentTemplateContainer.Controls.Add(tbl); UpdatePanel_plots.Controls.Add(tbl); } else { //No rows returns Label l = new Label(); l.Text = "<br/>No records returned from spRELv2_Get_Scores_for_var for measureID = " + measureID.ToString() + "<br/>Consider updating data via: exec spRELv2_step_0b__loop_thru_meas_byStudy " + Master.Master_studyID.ToString() + ", " + measureID.ToString() + " <br/><br/>"; l.ForeColor = Color.DarkRed; //UpdatePanel_plots.ContentTemplateContainer.Controls.Add(l); UpdatePanel_plots.Controls.Add(l); } } //UpdatePanel_plots.Update(); UpdatePanel_plots.Visible = true; #endregion Scatterplots & ICC sql.Close(); }
// create proc spdatRELv2_items__for_coderpair //(@id varchar(15), @orig_studymeasID int, @rel_studymeasID int, @rel_pkval int, @type int) protected void gv_coderpairs_list_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "coderpair_details") { GridViewRow gvr = (GridViewRow)((Control)e.CommandSource).NamingContainer; int rowIndex = gvr.RowIndex; // The sql_getdetails field is contained in this proc: //spRELv2_GET_RelTracking_CoderPairs_by_measure if (print_jminfo) { jminfo.Text += " (btn)gv_coderpairs_list_RowCommand [coderpair_details]..<br/>"; } //Note that the SQL command text is present in the originating datasource: string sql = e.CommandArgument.ToString(); /////////////////////////////// // Items = 1 // Scores = 2 // Text vars = 3 SqlCommand cmd = new SqlCommand(); cmd.Connection = oConnData; cmd.CommandType = CommandType.Text; DataTable dt = new DataTable(); for (int i = 1; i < 4; i++) { string s = sql + ", " + i.ToString(); cmd.CommandText = s; SqlDataReader dr = cmd.ExecuteReader(); dt.Load(dr); GridView gv_coderpair_details = (GridView)UpdatePanel_coderpair_single.ContentTemplateContainer.FindControl("gv_coderpair_details" + i.ToString()); gv_coderpair_details.DataSource = dt; gv_coderpair_details.DataBind(); //dt.Dispose(); dt.Clear(); dr.Close(); } ////////////////////////////////////////////////// //Hide other rows in the main gridview int counter = 0; foreach (GridViewRow row in gv_coderpairs_list.Rows) { if (counter == rowIndex) { row.Visible = true; } else { row.Visible = false; } counter++; } UpdatePanel_coderpair_single.Visible = true; UpdatePanel_coderpair_single.Update(); } }
protected void ImgbtnArchivo_Click(object sender, ImageClickEventArgs e) { string Hora = DateTime.Now.ToString("dd_MM_yyy_HH_mm"); grid = new GridView(); cn.Open(); string cmd2 = "SELECT Distinct(Usuario.UsuarioID) as UsuarioID, " + " (Usuario.UsuarioNombre+' '+Usuario.UsuarioApellido) as UsuarioNombres, Usuario.UsuarioCedula as UsuarioCedula, " + " PlanEmpresa.TotalClases as TotalClases, " + " Cliente.ClienteNombre as ClienteNombre, " + " CONVERT(VARCHAR(11),PlanEmpresa.fechaUltimo,103) as fechaUltima " + " FROM PlanEmpresa INNER JOIN Usuario ON PlanEmpresa.UsuarioID = " + " Usuario.UsuarioID INNER JOIN UsuarioRol ON Usuario.UsuarioID = " + " UsuarioRol.UsuarioID INNER JOIN Cliente ON UsuarioRol.ClienteID = Cliente.ClienteID " + " WHERE (PlanEmpresa.PlanActivo = 1) AND Cliente.ClienteID > 1 " + ViewState["sWhere"] + " ORDER BY Cliente.ClienteNombre, Usuario.UsuarioCedula ASC "; SqlDataAdapter dAdapter = new SqlDataAdapter(cmd2, cn); ds = new DataSet(); dAdapter.Fill(ds); dt = ds.Tables[0]; string[] TablaID = new string[1]; TablaID[0] = "UsuarioCedula"; try { //Usuarios No Activos string Inactivos = "SELECT Usuario.UsuarioID as UsuarioId, " + " (Usuario.UsuarioNombre+' '+Usuario.UsuarioApellido) as UsuarioNombres, Usuario.UsuarioCedula as UsuarioCedula, " + " Cliente.ClienteNombre as ClienteNombre, Cliente.ClienteID as ClienteID, " + " PlanEmpresa.PlanActivo as PlanActivo, " + " CONVERT(VARCHAR(11),PlanEmpresa.fechaUltimo,103) as fechaUltima, " + " PlanEmpresa.TotalClases as TotalClases " + " FROM PlanEmpresa INNER JOIN Usuario ON PlanEmpresa.UsuarioID = " + " Usuario.UsuarioID INNER JOIN UsuarioRol ON Usuario.UsuarioID = " + " UsuarioRol.UsuarioID INNER JOIN Cliente ON UsuarioRol.ClienteID = Cliente.ClienteID " + " WHERE (PlanEmpresa.PlanActivo = 0) AND Cliente.ClienteID > 1 " + ViewState["sWhere"] + " ORDER BY PlanEmpresa.fechaUltimo DESC"; string InactivosCant = "SELECT COUNT(Usuario.UsuarioID) as UsuarioId " + " FROM PlanEmpresa INNER JOIN Usuario ON PlanEmpresa.UsuarioID = " + " Usuario.UsuarioID INNER JOIN UsuarioRol ON Usuario.UsuarioID = " + " UsuarioRol.UsuarioID INNER JOIN Cliente ON UsuarioRol.ClienteID = Cliente.ClienteID " + " WHERE (PlanEmpresa.PlanActivo = 0) AND Cliente.ClienteID > 1 " + ViewState["sWhere"]; string[] usuarioIn = new string[int.Parse(Utilidades.EjeSQL(InactivosCant, cn, ref Err, true))]; cn.Open(); SqlCommand cmd3 = new SqlCommand(Inactivos, cn); SqlDataReader dr3 = cmd3.ExecuteReader(); int contador = 0; while (dr3.Read()) { usuarioIn[contador] = dr3["UsuarioId"].ToString(); contador++; } cn.Close(); //Comparar cada ID con los inactivos en PlanEmpresaHistorial for (int i = 0; i < usuarioIn.Length; i++) { string query = "SELECT fechaUltimo FROM PlanEmpresa WHERE UsuarioID =" + usuarioIn[i]; MostrarMsjModal(query, ""); int valido = CompararFechas(query); if (valido == 1) { //Usuario Valido y se ingresa al reporte DataRow datos = dt.NewRow(); datos["UsuarioCedula"] = Utilidades.EjeSQL("SELECT UsuarioCedula as UsuarioCedula FROM Usuario WHERE UsuarioID = " + usuarioIn[i], cn, ref Err, true); datos["UsuarioID"] = Utilidades.EjeSQL("SELECT UsuarioID as UsuarioID FROM Usuario WHERE UsuarioID = " + usuarioIn[i], cn, ref Err, true); datos["UsuarioNombres"] = Utilidades.EjeSQL("SELECT (Usuario.UsuarioNombre+' '+Usuario.UsuarioApellido) as UsuarioNombres FROM Usuario WHERE UsuarioID = " + usuarioIn[i], cn, ref Err, true); datos["ClienteNombre"] = Utilidades.EjeSQL("SELECT dbo.Cliente.ClienteNombre FROM dbo.Cliente " + " INNER JOIN dbo.UsuarioRol ON dbo.Cliente.ClienteID = dbo.UsuarioRol.ClienteID INNER JOIN " + " dbo.Usuario ON dbo.UsuarioRol.UsuarioID = dbo.Usuario.UsuarioID " + " WHERE (dbo.Usuario.UsuarioID = " + usuarioIn[i] + ")", cn, ref Err, true); datos["fechaUltima"] = Utilidades.EjeSQL("SELECT TOP 1 CONVERT(VARCHAR(11),PlanEmpresaFecha,103) as PlanEmpresaFecha FROM PlanEmpresaHistorial WHERE PlanEmpresaUsuarioID = " + usuarioIn[i], cn, ref Err, true); datos["TotalClases"] = Utilidades.EjeSQL("SELECT TotalClases FROM PlanEmpresa WHERE UsuarioID = " + usuarioIn[i], cn, ref Err, true); //ds.Tables["dt"].Rows.Add(datos); dt.Rows.Add(datos); } } GridView1.DataKeyNames = TablaID; GridView1.DataSource = dt; GridView1.DataBind(); } catch (Exception ex) { cn.Close(); MostrarMsjModal(ex.Message, "ERR"); } grid.DataKeyNames = TablaID; grid.DataSource = dt; grid.DataBind(); cn.Close(); System.Text.StringBuilder sb = new System.Text.StringBuilder(); System.IO.StringWriter sw = new System.IO.StringWriter(sb); HtmlTextWriter htw = new HtmlTextWriter(sw); Page page = new Page(); System.Web.UI.HtmlControls.HtmlForm form = new System.Web.UI.HtmlControls.HtmlForm(); GridView Grid = new GridView(); grid.AllowPaging = false; grid.DataBind(); grid.EnableViewState = false; page.EnableEventValidation = false; page.DesignerInitialize(); page.Controls.Add(form); form.Controls.Add(grid); page.RenderControl(htw); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("Content-Disposition", "attachment;filename=Usuarios_Activos_" + Hora + ".xls"); Response.Charset = "UTF-8"; Response.ContentEncoding = System.Text.Encoding.Default; Response.Write(sb.ToString()); Response.End(); }
protected internal void SetOwner(GridView owner) { _owner = owner; }
public void RegisterGridView(GridView view) { _View = view; view.TopRowChanged += new EventHandler(view_TopRowChanged); view.LeftCoordChanged += new EventHandler(view_LeftCoordChanged); }
public static void BindGridViewList(IList list, GridView grid) { grid.DataSource = list; grid.DataBind(); }
private void AddPlayerMinionAndEventToGridView(GridView gridView, Minion minion) { MinionManager.AddMinionToGridView(gridView, minion); (gridView.Items.Last() as Grid).DragStarting += Minion_DragStarting; }
protected void grid_data_SelectedIndexChanged(object sender, EventArgs e) { GridView gridData = fnGetNowGridView(); GridViewEvent.fnGridViewSelectedIndexChanged(ref gridData, "#89BBFE"); }
/// <summary> /// Initializes the grid layout. /// </summary> /// <param name="grdView">The GRD view.</param> /// <param name="columnsCollection">The columns collection.</param> public static void InitGridLayout(this GridView grdView, List <XtraColumn> columnsCollection) { foreach (GridColumn grd in grdView.Columns) { //Check column có tồn tại k nếu k thì add thêm -KienNT var columnCheckExits = columnsCollection.FirstOrDefault(r => r.ColumnName == grd.FieldName); if (columnCheckExits == null) { columnsCollection.Add(new XtraColumn { ColumnName = grd.FieldName, ColumnVisible = false }); } //check lại so sánh grid với columnsCollection nếu có thì mới cho bin template -KienNT var column = columnsCollection.FirstOrDefault(r => r.ColumnName == grd.FieldName); if (column != null) { if (grdView.Columns[column.ColumnName] != null) { if (column.ColumnVisible) { try { grdView.Columns[column.ColumnName].Caption = column.ColumnCaption; grdView.Columns[column.ColumnName].VisibleIndex = column.ColumnPosition; grdView.Columns[column.ColumnName].Width = column.ColumnWith; grdView.Columns[column.ColumnName].UnboundType = column.ColumnType; //grdView.Columns[column.ColumnName].Fixed = column.FixedColumn; grdView.Columns[column.ColumnName].OptionsColumn.AllowEdit = column.AllowEdit; grdView.Columns[column.ColumnName].ToolTip = column.ToolTip; grdView.Columns[column.ColumnName].ColumnEdit = column.RepositoryControl; grdView.Columns[column.ColumnName].OptionsColumn.AllowSort = DefaultBoolean.False; if (column.IsSummnary) { grdView.Columns[column.ColumnName].SummaryItem.SummaryType = column.SummaryType; grdView.Columns[column.ColumnName].SummaryItem.DisplayFormat = column.DisplayFormat; } //default summary in some below cases if (column.ColumnName.Contains("AmountOC") || column.ColumnName.Contains("Amount")) { grdView.Columns[column.ColumnName].SummaryItem.SummaryType = SummaryItemType.Sum; grdView.Columns[column.ColumnName].SummaryItem.DisplayFormat = GlobalVariable.CurrencyDisplayString; grdView.Columns[column.ColumnName].SummaryItem.Format = Thread.CurrentThread.CurrentCulture; } if (column.ColumnPosition == 1) { grdView.Columns[column.ColumnName].SummaryItem.SummaryType = SummaryItemType.Count; grdView.Columns[column.ColumnName].SummaryItem.DisplayFormat = @"Số dòng = {0:n0}"; } //if (column.ColumnName.Contains("Amount") || column.ColumnName.Contains("Quantity")) //{ // grdView.Columns[column.ColumnName].DisplayFormat.FormatString = column.DisplayFormat; //} } catch (Exception ex) { XtraMessageBox.Show(ex.Message, column.ColumnName, MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { try { grdView.Columns[column.ColumnName].Visible = false; } catch (Exception ex) { XtraMessageBox.Show(ex.Message, column.ColumnName, MessageBoxButtons.OK, MessageBoxIcon.Error); } } } } } }
protected void grid_data_RowDataBound(object sender, GridViewRowEventArgs e) { GridView gridData = fnGetNowGridView(); GridViewEvent.fnGridViewRowDataBound(this, ref gridData, e.Row, 40, "#89BBFE", "#FFFFFF"); }
protected void grid_data_SelectedIndexChanging(object sender, GridViewSelectEventArgs e) { GridView gridData = fnGetNowGridView(); GridViewEvent.fnGridViewSelectedIndexChanging(this, ref gridData, "#FFFFFF", "#000000"); }
bool Cal(Int32 _Width, GridView view) { view.IndicatorWidth = view.IndicatorWidth < _Width ? _Width : view.IndicatorWidth; return(true); }
/// <summary> /// Sets the numeric format control. /// LinhMC bo sung them dieu kien: /// repositoryCurrencyCalcEdit.Precision = int.Parse(DBOptionHelper.ExchangeRateDecimalDigits)/ int.Parse(DBOptionHelper.CurrencyDecimalDigits); /// mục đích của thằng này là để làm tròn đúng số thập phân như định dạng khi người dùng nhấn công cụ tính toán /// </summary> /// <param name="gridView">The grid view.</param> /// <param name="isSummary">if set to <c>true</c> [is summary].</param> public static void SetNumericFormatControl(this GridView gridView, bool isSummary) { //Get format data from db to format grid control var repositoryCurrencyCalcEdit = new RepositoryItemCalcEdit { AllowMouseWheel = false }; var repositoryNumberCalcEdit = new RepositoryItemCalcEdit { AllowMouseWheel = false }; var repositoryDateEdit = new RepositoryItemDateEdit() { AllowMouseWheel = false }; foreach (GridColumn oCol in gridView.Columns) { if (!oCol.Visible) { continue; } switch (oCol.UnboundType) { case UnboundColumnType.Decimal: repositoryCurrencyCalcEdit.Mask.MaskType = MaskType.Numeric; if (oCol.Name == "ExchangeRate") { repositoryCurrencyCalcEdit.Mask.EditMask = @"c" + GlobalVariable.ExchangeRateDecimalDigits; repositoryCurrencyCalcEdit.Precision = int.Parse(GlobalVariable.ExchangeRateDecimalDigits); } else { repositoryCurrencyCalcEdit.Mask.EditMask = @"c" + GlobalVariable.CurrencyDecimalDigits; repositoryCurrencyCalcEdit.Precision = GlobalVariable.CurrencyDecimalDigits; } repositoryCurrencyCalcEdit.Mask.Culture = Thread.CurrentThread.CurrentCulture; repositoryCurrencyCalcEdit.Mask.UseMaskAsDisplayFormat = true; oCol.ColumnEdit = repositoryCurrencyCalcEdit; if (isSummary) { oCol.SummaryItem.SummaryType = SummaryItemType.Sum; oCol.SummaryItem.DisplayFormat = GlobalVariable.CurrencyDisplayString; oCol.SummaryItem.Format = Thread.CurrentThread.CurrentCulture; } break; case UnboundColumnType.Integer: repositoryNumberCalcEdit.Mask.MaskType = MaskType.Numeric; repositoryNumberCalcEdit.Mask.EditMask = @"n0"; repositoryNumberCalcEdit.Mask.UseMaskAsDisplayFormat = true; repositoryNumberCalcEdit.Mask.Culture = Thread.CurrentThread.CurrentCulture; oCol.ColumnEdit = repositoryNumberCalcEdit; if (oCol.Name.ToLower().Contains("quantity")) { var _numberDecimalDigits = string.IsNullOrEmpty(GlobalVariable.NumberDecimalDigits) ? "0" : GlobalVariable.NumberDecimalDigits; repositoryCurrencyCalcEdit.Mask.EditMask = @"n" + _numberDecimalDigits; repositoryCurrencyCalcEdit.Precision = int.Parse(_numberDecimalDigits); } if (isSummary) { oCol.SummaryItem.SummaryType = SummaryItemType.Sum; oCol.SummaryItem.DisplayFormat = GlobalVariable.NumericDisplayString; oCol.SummaryItem.Format = Thread.CurrentThread.CurrentCulture; } break; case UnboundColumnType.DateTime: //oCol.DisplayFormat.FormatString = // Thread.CurrentThread.CurrentCulture.DateTimeFormat.ShortDatePattern; repositoryDateEdit.Mask.MaskType = MaskType.DateTimeAdvancingCaret; repositoryDateEdit.Mask.EditMask = @"dd/MM/yyyy"; repositoryDateEdit.DisplayFormat.FormatType = FormatType.DateTime; repositoryDateEdit.Mask.UseMaskAsDisplayFormat = true; oCol.ColumnEdit = repositoryDateEdit; //oCol.DisplayFormat.FormatString = "dd/MM/yyyy"; //oCol.DisplayFormat.FormatType = FormatType.DateTime; //oCol.DisplayFormat.Format = Thread.CurrentThread.CurrentCulture.DateTimeFormat; break; } } }
/// <summary> /// 空数据提醒 /// </summary> /// <param name="gv"></param> private void SetViewEmpDataText(GridView gv) { gv.CustomDrawEmptyForeground += new CustomDrawEventHandler(gv_CustomDrawEmptyForeground); }
/// <summary> /// Indicator显示行号 /// </summary> /// <param name="gv"></param> private void SetViewIndicatorRowNum(GridView gv) { gv.IndicatorWidth = 35; gv.CustomDrawRowIndicator += new RowIndicatorCustomDrawEventHandler(gv_CustomDrawRowIndicator); }
public LibraryGridViewInfo(GridView view) : base(view) { }
private bool cal(int _Width, GridView _View) { _View.IndicatorWidth = _View.IndicatorWidth < _Width ? _Width : _View.IndicatorWidth; return(true); }