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);
}
