public GridHelper(UltraWebGrid grid, System.Web.UI.WebControls.CheckBox chbSelectAll) { this._grid = grid; this._chbSelectAll = chbSelectAll; this.InitGridHelper(); }
private void AddBand(Infragistics.WebUI.UltraWebGrid.UltraWebGrid grid) { UltraGridBand newBand = new UltraGridBand(); grid.Bands.Add(newBand); newBand.ColHeadersVisible = ShowMarginInfo.No; newBand.DataKeyField = grid.Bands[0].DataKeyField; newBand.Columns.CopyFrom(grid.Bands[0].Columns); ((TemplatedColumn)newBand.Columns[1]).CellTemplate = ((TemplatedColumn)grid.Bands[0].Columns[1]).CellTemplate; }
private void InitializeComponent() { this.gridWebGrid = this.GetWebGrid(); this.languageComponent = this.GetLanguageComponent(); this.Load += new System.EventHandler(this.Page_Load); this.components = new System.ComponentModel.Container(); this.excelExporter = new BenQGuru.eMES.Web.Helper.ExcelExporter(this.components); this.excelExporter.Page = this; this.excelExporter.LanguageComponent = this.languageComponent; }
public bool IsInExport = false; // Added by Icyer 2006/12/26 @ YHI 标识是否导出操作,如果是导出则不用计算总数 public WebQueryHelper( HtmlInputButton queryButton, HtmlInputButton exportButton, UltraWebGrid grid, PagerSizeSelector selector, PagerToolBar toolBar, ControlLibrary.Web.Language.LanguageComponent languageComponent) { //variable this.cmdQuery = queryButton; this.cmdGridExport = exportButton; this.gridWebGrid = grid; this.pagerSizeSelector = selector; this.pagerToolBar = toolBar; this.languageComponent1 = languageComponent; //export this.excelExporter = new BenQGuru.eMES.Web.Helper.ExcelExporter(); this.excelExporter.Page = this.gridWebGrid.Page; this.excelExporter.FormatExportRecordHandle = new FormatExportRecordDelegate(this.FormatExportRecord); this.excelExporter.LoadExportDataHandle = new LoadExportDataDelegate(this.LoadDataSource); this.excelExporter.LanguageComponent = this.languageComponent1; this.excelExporter.GetColumnHeaderTextHandle = new GetColumnHeaderTextDelegate(GetColumnHeaderText); //register event if (this.cmdQuery != null) { this.cmdQuery.ServerClick += new EventHandler(cmdQuery_ServerClick); } if (this.cmdGridExport != null) { this.cmdGridExport.ServerClick += new EventHandler(cmdGridExport_ServerClick); } if (this.gridWebGrid != null) { this.gridWebGrid.ClickCellButton += new ClickCellButtonEventHandler(gridWebGrid_ClickCellButton); } if (this.pagerToolBar != null) { this.pagerToolBar.OnPagerToolBarClick += new EventHandler(this.PagerToolBar_OnPagerToolBarClick); } if (this.pagerSizeSelector != null) { this.pagerSizeSelector.OnPagerSizeChanged += new BenQGuru.eMES.Web.Helper.PagerSizeSelector.PagerSizeChangedHandle(pagerSizeSelector_OnPagerSizeChanged); } }
private void AddThresholdStep(Infragistics.WebUI.UltraWebGrid.UltraWebGrid uGrid) { string[,] saPKID; saPKID = GetSelectedThresholdCode_ID(uGrid); if (saPKID.GetUpperBound(0) <= -1) { PageUtility.AlertMessage("추가할 대상을 선택하셔야 합니다."); return; } if (ddlLevel.SelectedValue.Equals("")) { PageUtility.AlertMessage("추가할 평가단계를 선택하셔야 합니다."); return; } string thresholdlevel = ddlLevel.SelectedValue; decimal point = 0; int emp_ref_id = gUserInfo.Emp_Ref_ID; Biz_Bsc_Threshold_Step biz = new Biz_Bsc_Threshold_Step(); int iRet = biz.InsertThresholdStep(saPKID, thresholdlevel, point, "N", emp_ref_id); //string sScript = ""; //sScript += string.Format( // "[{0}]건이 추가되었습니다!" // , iRet // ); //PageUtility.AlertMessage(sScript); SearchBind(); }
private string[,] GetSelectedThresholdCode_ID(Infragistics.WebUI.UltraWebGrid.UltraWebGrid uGrid) { Infragistics.WebUI.UltraWebGrid.UltraGridRow ugRow; string sPKID = ""; string[,] saPKID; bool bCheck = false; for (int i = 0; i < uGrid.Rows.Count; i++) { ugRow = uGrid.Rows[i]; bCheck = Convert.ToBoolean(ugRow.Cells.FromKey("selChk").Value); if (bCheck) { sPKID += GetValue(ugRow.Cells.FromKey("THRESHOLD_REF_ID").Value) + ";"; } } saPKID = TypeUtility.GetSplit(sPKID); return(saPKID); }
private void DelThresholdStep(Infragistics.WebUI.UltraWebGrid.UltraWebGrid uGrid) { string[,] saPKID; saPKID = GetSelectedThresholdCode_ID(uGrid); if (saPKID.GetUpperBound(0) <= -1) { PageUtility.AlertMessage("제거할 대상을 선택하셔야 합니다."); return; } if (ddlLevel.SelectedValue.Equals("")) { PageUtility.AlertMessage("제거할 평가단계를 선택하셔야 합니다."); return; } Biz_Bsc_Threshold_Step biz = new Biz_Bsc_Threshold_Step(); string thresholdlevel = ddlLevel.SelectedValue; int emp_ref_id = gUserInfo.Emp_Ref_ID; if (biz.IsDelStepValidate(saPKID, thresholdlevel)) { PageUtility.AlertMessage("이미사용되고 있는 평가단계코드이므로 삭제할수 없습니다."); return; } //return; int iRet = biz.DelThresholdStep(saPKID, thresholdlevel); //string sScript = ""; //sScript += string.Format( // "[{0}]건이 제거되었습니다!" // , iRet // ); //PageUtility.AlertMessage(sScript); BindThresholdStepSearch(); bool chkSelect = false; for (int i = 0; i < ddlLevel.Items.Count; i++) { if (ddlLevel.Items[i].Value == thresholdlevel) { ddlLevel.SelectedValue = thresholdlevel; chkSelect = true; SearchBind(); return; } } if (!chkSelect) { PageUtility.FindByValueDropDownList(ddlLevel, CS_DEFAULT_TYPE); } SearchBind(); }
public GridHelper(UltraWebGrid grid) { this._grid = grid; this.InitGridHelper(); }
private void DataBinding() { DataTable dtIndex = new DataTable(); DataRow dr = null; dtIndex.Columns.Add("IDX", typeof(int)); dtIndex.Columns.Add("BU", typeof(string)); dr = dtIndex.NewRow(); dr["IDX"] = 1; dr["BU"] = "CJ"; dtIndex.Rows.Add(dr); dr = dtIndex.NewRow(); dr["IDX"] = 2; dr["BU"] = "CJ"; dtIndex.Rows.Add(dr); dr = dtIndex.NewRow(); dr["IDX"] = 3; dr["BU"] = "CJ"; dtIndex.Rows.Add(dr); dr = dtIndex.NewRow(); dr["IDX"] = 4; dr["BU"] = "CJ"; dtIndex.Rows.Add(dr); dr = dtIndex.NewRow(); dr["IDX"] = 5; dr["BU"] = "CJ"; dtIndex.Rows.Add(dr); dr = dtIndex.NewRow(); dr["IDX"] = 6; dr["BU"] = "CJ"; dtIndex.Rows.Add(dr); dr = dtIndex.NewRow(); dr["IDX"] = 7; dr["BU"] = "CJ"; dtIndex.Rows.Add(dr); dr = dtIndex.NewRow(); dr["IDX"] = 8; dr["BU"] = "CJ"; dtIndex.Rows.Add(dr); dr = dtIndex.NewRow(); dr["IDX"] = 9; dr["BU"] = "CJ"; dtIndex.Rows.Add(dr); dr = dtIndex.NewRow(); dr["IDX"] = 10; dr["BU"] = "CJ"; dtIndex.Rows.Add(dr); dr = dtIndex.NewRow(); dr["IDX"] = 11; dr["BU"] = "CJ"; dtIndex.Rows.Add(dr); HtmlTable tbl = Page.FindControl("tbl") as HtmlTable; foreach (Control con in tbl.Controls) { if (con is HtmlTableRow) { int idx = DataTypeUtility.GetToInt32(con.ID.Replace("tr", "")); Infragistics.WebUI.UltraWebGrid.UltraWebGrid grid = Page.FindControl(string.Format("Grid{0}", idx)) as Infragistics.WebUI.UltraWebGrid.UltraWebGrid; if (grid != null) { DataTable dt = DataTypeUtility.FilterSortDataTable(DT_DATA, string.Format("SORT_ORDER1 = {0}", idx), "SORT_ORDER2"); dt.Columns.Add("ITM_NAME", typeof(string)); foreach (DataRow dr_I in dt.Rows) { if (DataTypeUtility.GetToInt32(dr_I["SORT_ORDER2"]) == 1) { dr_I["ITM_NAME"] = "생산수율"; } else if (DataTypeUtility.GetToInt32(dr_I["SORT_ORDER2"]) == 2) { dr_I["ITM_NAME"] = "공정불량율"; } } grid.DataSource = dt; grid.DataBind(); if (dt.Rows.Count == 0) { con.Visible = false; } } } else { con.Visible = false; } } }
private void InitializeComponent() { this.gridWebGrid = this.GetWebGrid(); this.languageComponent = this.GetLanguageComponent(); this.Load += new System.EventHandler(this.Page_Load); }