protected void ddlEstID_SelectedIndexChanged(object sender, EventArgs e)
{
UltraWebGrid1.Clear();
ClearValueControls();
DropDownListCommom.BindQuestionObject(ddlQObjID, hdfSearchEstID.Value, true);
}
private void SearchEmpInfo()
{
EmpInfos emp = new EmpInfos();
string searchType = WebUtility.GetByValueDropDownList(ddlSchType);
string searchText = this.txtSearch.Text.Trim();
int useYN = WebUtility.GetIntByValueRadioButtonList(radType);
if (useYN == 0)
{
ibtnRollback.Visible = true;
}
else
{
ibtnRollback.Visible = false;
}
UltraWebGrid1.Clear();
DataSet ds = emp.GetEmpInfoSearch(searchType, searchText, useYN);
UltraWebGrid1.DataSource = ds;
UltraWebGrid1.DataBind();
lblRowCount.Text = ds.Tables[0].Rows.Count.ToString();
}
private void DoBinding_Project()
{
UltraWebGrid1.Clear();
MicroBSC.Integration.COM.Biz.Biz_NHIT bizNHIT = new MicroBSC.Integration.COM.Biz.Biz_NHIT();
DataTable dtNHIT = bizNHIT.GetProjectDetail(CR_YEAR, GRP_ONE_B_CODE, GRP_ONE_C_CODE, GRP_ONE_D_CODE);
UltraWebGrid1.DataSource = dtNHIT;
UltraWebGrid1.DataBind();
string title = "{0} 프로젝트 현황";
string gubun = string.Empty;
if (GRP_ONE_B_CODE.Length > 0)
{
gubun = "고객사 별";
}
if (GRP_ONE_C_CODE.Length > 0)
{
gubun = "사업유형 별";
}
if (GRP_ONE_D_CODE.Length > 0)
{
gubun = "본부 별";
}
if (dtNHIT.Rows.Count > 0)
{
lblTitle.Text = string.Format(title, gubun);
lblProjectTotal.Text = string.Format("(Total : {0})", dtNHIT.Rows.Count);
}
}
private void SetSelectTree()
{
if (TreeView1.SelectedNode == null)
{
return;
}
string deptId = TreeView1.SelectedNode.Value;
SetFormData(int.Parse(deptId));
UltraWebGrid1.Clear();
DataSet ds = GetEmpInfoList(deptId);
UltraWebGrid1.DataSource = ds;
UltraWebGrid1.DataBind();
lblRowCount.Text = ds.Tables[0].Rows.Count.ToString();
if (!hImgNew.Visible)
{
hImgNew.Visible = true;
}
if (!ibtnDelete.Visible)
{
ibtnDelete.Visible = true;
}
}
private void DoBinding(int estTermRefID, int deptID)
{
UltraWebGrid1.Clear();
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info bizBscKpiInfo = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info();
DataTable dtBscKpiInfo = bizBscKpiInfo.Get_GoalTongDashboard(estTermRefID, deptID);
if (dtBscKpiInfo.Rows.Count > 0)
{
this.ChartView.Visible = true;
UltraWebGrid1.DataSource = dtBscKpiInfo;
UltraWebGrid1.DataBind();
UltraWebGrid1.Rows[0].Activated = true;
int kpi_ref_id = DataTypeUtility.GetToInt32(dtBscKpiInfo.Rows[0]["KPI_REF_ID"]);
string kpi_name = DataTypeUtility.GetValue(dtBscKpiInfo.Rows[0]["KPI_NAME"]);
DoCharting(kpi_ref_id, kpi_name);
}
else
{
this.ChartView.Visible = false;
//chartMM.Visible = false;
//chartDal.Visible = false;
}
}
private void GridBinding(int comp_id)
{
if (CheckParam() == false)
{
ltrScript.Text = JSHelper.GetAlertScript("평가정보나 평가방법이 설정되지 않았습니다.");
return;
}
Biz_ScaleInfos scaleInfo = new Biz_ScaleInfos();
DataTable dtScale = scaleInfo.GetScaleInfos(comp_id).Tables[0];
_dwScale = dtScale.DefaultView;
_dwScale.Sort = "SCALE_ID";
Biz_DeptEstDetails deptEstDetail = new Biz_DeptEstDetails();
_dtEstScale = deptEstDetail.GetDeptEstDetail(comp_id, ESTTERM_REF_ID, 0, EST_ID).Tables[0];
UltraWebGrid1.Clear();
UltraWebGrid1.DataSource = BizUtility.GetDeptTree(" ");
UltraWebGrid1.DataBind();
EstJobUtility.SetConfirmButtonVisible(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, EST_JOB_ID
, ibnConfirm
, ibnConfirmCancel);
}
protected void ibnSearch_Click(object sender, ImageClickEventArgs e)
{
DropDownListCommom.BindQuestionObject(ddlQObjID, hdfSearchEstID.Value, true);
DropDownListCommom.BindQuestionDefine(ddlQDfnID, hdfSearchEstID.Value, true);
UltraWebGrid1.Clear();
ClearValueControls();
}
private void BindGrid()
{
UltraWebGrid1.Clear();
UltraWebGrid1.DataSource = _questionDefine.GetQuestionDefine(EST_ID);
UltraWebGrid1.DataBind();
}
protected void ibnSearch_Click(object sender, ImageClickEventArgs e)
{
UltraWebGrid1.Clear();
UltraWebGrid2.Clear();
UltraWebGrid3.Clear();
DoBinding_Dept();
}
private void Reload()
{
UltraWebGrid1.Clear();
UltraWebGrid2.Clear();
DataBindingUnitType();
DataBindingUnit(hdfUnitGroup.Value);
txtUnitGroup.Text = "";
}
private void DoBinding()
{
Biz_EstDeptOrgScoreInfos bizEDOS = new Biz_EstDeptOrgScoreInfos();
DataTable dt = bizEDOS.GetEstDeptOrgScoreInfos(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo)).Tables[0];
UltraWebGrid1.Clear();
UltraWebGrid1.DataSource = dt;
UltraWebGrid1.DataBind();
}
private void BindQuestionGrid()
{
Biz_QuestionEstMaps questionEstMaps = new Biz_QuestionEstMaps();
UltraWebGrid1.Clear();
ugrdPrjList.Clear();
UltraWebGrid1.DataSource = questionEstMaps.GetQuestionEstMap(EST_ID, "");
UltraWebGrid1.DataBind();
}
protected void iBtnSearch_Click(object sender, ImageClickEventArgs e)
{
UltraWebGrid1.Clear();
UltraWebGrid2.Clear();
UltraWebGrid2.Bands[0].ResetColumns();
UltraWebGrid3.Clear();
this.TxtBox_Soosik.Text = "";
Project_Bind();
}
private void GridBinding()
{
this.SetGridHeader();
DataTable rDt = GetDataTable();
UltraWebGrid1.Clear();
UltraWebGrid1.DataSource = rDt.DefaultView;
UltraWebGrid1.DataBind();
this.BindingChart(Chart1, rDt);
}
protected void SetFreightEasyData(string txtSQL)
{
UltraWebGrid1.Clear();
FEData = new FreightEasy.DataManager.FreightEasyData();
FEData.AddToDataSet("SearchList", txtSQL);
UltraWebGrid1.DataSource = FEData.Tables["SearchList"].DefaultView;
UltraWebGrid1.DataBind();
UltraWebGrid1.DisplayLayout.Pager.CurrentPageIndex = 1;
txtResultBox.Text = FEData.Tables["SearchList"].Rows.Count.ToString() + " Records Found.";
btnExcelExport.Visible = true;
}
protected void lBtnGridReload_Click(object sender, EventArgs e)
{
string deptId = TreeView1.SelectedNode.Value;
UltraWebGrid1.Clear();
DataSet ds = GetEmpInfoList(deptId);
UltraWebGrid1.DataSource = ds;
UltraWebGrid1.DataBind();
lblRowCount.Text = ds.Tables[0].Rows.Count.ToString();
}
private void BindGrid()
{
UltraWebGrid1.Clear();
UltraWebGrid1.DataSource = _questionItems.GetQuestionItem("", "", PageUtility.GetByValueDropDownList(ddlQObjID));
UltraWebGrid1.DataBind();
if (!Page.ClientScript.IsStartupScriptRegistered(Page.GetType(), "Search"))
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Search", string.Format("<script>GetDataSet('GetDataSet.aspx','ddlQSbjID','Q_SBJ_NAME','Q_SBJ_ID', 'Survey', 'B', '{0}');"
+ "document.forms[0].ddlQSbjID.value={1}; </script>"
, PageUtility.GetByValueDropDownList(ddlQObjID), 0));
}
}
private void DoBinding_Dept()
{
UltraWebGrid1.Clear();
UltraWebGrid2.Clear();
Biz_Mul_Est_Data bizMulEstData = new Biz_Mul_Est_Data();
DataTable DT = bizMulEstData.Get_Est_Status_By_Dept(hdfEstID.Value, ESTTERM_REF_ID.ToString(), ESTTERM_SUB_ID.ToString());
UltraWebGrid1.DataSource = DT;
UltraWebGrid1.DataBind();
}
private void DoBinding_JeonSa()
{
UltraWebGrid1.Clear();
MicroBSC.Integration.COM.Biz.Biz_NHIT bizNHIT = new MicroBSC.Integration.COM.Biz.Biz_NHIT();
DataTable dtNHIT = bizNHIT.GetJeonSa(GRP_ONE_ID.A.ToString()
, (int)GRP_TWO_ID.GTO_10
, CR_YEAR
, CR_MONTH, TG_GUBUN);
UltraWebGrid1.DataSource = dtNHIT;
UltraWebGrid1.DataBind();
}
private void DoLoading(int comp_id, string est_id, int estterm_ref_id, int estterm_sub_id)
{
UltraWebGrid1.Clear();
Biz_JobEstMaps biz = new Biz_JobEstMaps();
DataSet ds = biz.GetJobEstMap(comp_id
, est_id
, estterm_ref_id
, estterm_sub_id
, "");
UltraWebGrid1.DataSource = ds.Tables[0];
UltraWebGrid1.DataBind();
}
private void SetGrid1()
{
UltraWebGrid1.Clear();
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Intro_Score bizObj = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Intro_Score();
DataTable dtObj = bizObj.GetOrgRank(IEstTermRefID, IYmd, 0);
if (dtObj.Rows.Count > 0)
{
UltraWebGrid1.DataSource = dtObj;
UltraWebGrid1.DataBind();
}
}
private void GridBinding2(int comp_id, int estterm_ref_id, string est_id)
{
Biz_DeptEstDetails deptEstDetail = new Biz_DeptEstDetails();
_dtEstDetail = deptEstDetail.GetDeptEstDetail(comp_id, estterm_ref_id, 0, est_id).Tables[0];
Biz_DeptPosDetails deptPosDetail = new Biz_DeptPosDetails();
_dtPosDetail = deptPosDetail.GetDeptPosDetail(comp_id, estterm_ref_id, 0, est_id).Tables[0];
UltraWebGrid1.Clear();
UltraWebGrid1.DataSource = BizUtility.GetDeptTree(" ");
UltraWebGrid1.DataBind();
}
private void SearchDB()
{
UltraWebGrid1.Clear();
UltraWebGrid1.DataSource = GetSearchData();
UltraWebGrid1.DataBind();
if (UltraWebGrid1.Rows.Count <= 0)
{
this.iBtnRoleDel.Visible = false;
}
else
{
this.iBtnRoleDel.Visible = true;
}
}
private void BindEstJob(string est_id)
{
UltraWebGrid1.Clear();
Biz_JobEstMaps biz = new Biz_JobEstMaps();
DataSet ds = biz.GetJobEstMap(COMP_ID
, est_id
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, "");
UltraWebGrid1.DataSource = ds.Tables[0];
UltraWebGrid1.DataBind();
//lblRowCount.Text = ds.Tables[0].Rows.Count.ToString();
}
protected void doBind_project()
{
UltraWebGrid1.Clear();
UltraWebGrid2.Clear();
string est_id = "3Q";
MicroBSC.Integration.PRJ.Biz.Biz_Prj_Data bizPrjData = new Biz_Prj_Data();
DT_ENDED_PRJ = bizPrjData.Get_Ended_Prj_Est(COMP_ID, est_id, ESTTERM_REF_ID, ESTTERM_SUB_ID, ESTTERM_STEP_ID);
this.lblRowCount.Text = DT_ENDED_PRJ.Rows.Count.ToString();
UltraWebGrid1.DataSource = DT_ENDED_PRJ;
UltraWebGrid1.DataBind();
}
protected void ibnSavePool_Click(object sender, ImageClickEventArgs e)
{
if (doSave_Est_Target_Pool())
{
this.ltrScript.Text = JSHelper.GetAlertScript("저장하였습니다.");
}
else
{
this.ltrScript.Text = JSHelper.GetAlertScript("실패했습니다.");
}
UltraWebGrid1.Clear();
UltraWebGrid2.Clear();
UltraWebGrid3.Clear();
DoBinding_Dept();
}
protected void doBindKpiPool()
{
MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Pool objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Pool();
DataSet ds = objBSC.GetDetailAllList(txtKpiName.Text.Trim()
, ""
, ""
, 0
, 0
, 0
, "");
DataTable dt_filtered = DataTypeUtility.FilterSortDataTable(ds.Tables[0], "KPI_EXTERNAL_TYPE='EXT'");
UltraWebGrid1.Clear();
UltraWebGrid1.DataSource = dt_filtered;
UltraWebGrid1.DataBind();
}
protected void doBind_est()
{
UltraWebGrid1.Clear();
int estterm_step_id = 2;
string PRJ_NAME = this.txtPRJ_NAME.Text;
string gubun = this.GUBUN.SelectedValue;
DataTable DT = bizPrjInfo.Get_Pms_Info_Join_PRj_Info_List(EST_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID, estterm_step_id, PRJ_NAME, EST_EMP_ID, gubun);
this.lblRowCount.Text = DT.Rows.Count.ToString();
UltraWebGrid1.DataSource = DT;
UltraWebGrid1.DataBind();
}
private void GridBinding()
{
Biz_EstDeptOrgDetails estDeptOrgDetail = new Biz_EstDeptOrgDetails();
Biz_DeptTypeInfo deptTypeInfo = new Biz_DeptTypeInfo();
if (rtlDrildownYN.SelectedIndex == 1)
{
if (TreeView1.Nodes.Count > 0)
{
UltraWebGrid1.Clear();
UltraWebGrid1.DataSource = estDeptOrgDetail.GetEstDeptOrgDetail(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo), Convert.ToInt32(TreeView1.Nodes[0].Value));
UltraWebGrid1.DataBind();
}
else
{
UltraWebGrid1.DataSource = deptTypeInfo.GetDeptTypeList();
UltraWebGrid1.DataBind();
}
}
else
{
if (TreeView1.Nodes.Count > 0)
{
if (TreeView1.SelectedNode != null)
{
UltraWebGrid1.Clear();
DataSet ds = estDeptOrgDetail.GetEstDeptOrgDetail(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo), Convert.ToInt32(TreeView1.SelectedNode.Value));
UltraWebGrid1.DataSource = ds;
UltraWebGrid1.DataBind();
}
else
{
UltraWebGrid1.DataSource = deptTypeInfo.GetDeptTypeList();
UltraWebGrid1.DataBind();
}
}
else
{
UltraWebGrid1.DataSource = deptTypeInfo.GetDeptTypeList();
UltraWebGrid1.DataBind();
}
}
}
private void _queryGrid()
{
string strYMD = (cboYY.SelectedValue + cboMM.SelectedValue);
OracleConnection _connection = new OracleConnection();
_connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["MainDB_Oracle"].ConnectionString;
OracleCommand objCmdGrid = new OracleCommand("PKG_SEM_Fina_R025.PROC_Fina_R025_01", _connection);
_connection.Open();
objCmdGrid.CommandType = CommandType.StoredProcedure;
//================================================================== Grid Query
OracleParameter[] arrOpmGrid = new OracleParameter[3];
arrOpmGrid[0] = new OracleParameter("i_YYMM", OracleType.VarChar, 6);
arrOpmGrid[0].Value = (strYMD);
arrOpmGrid[1] = new OracleParameter("i_BANK", OracleType.VarChar, 12);
arrOpmGrid[1].Value = cboBank.SelectedValue;
arrOpmGrid[2] = new OracleParameter("O_Fina_R025", OracleType.Cursor);
arrOpmGrid[2].Direction = ParameterDirection.Output;
for (int i = 0; i < arrOpmGrid.Length; i++)
{
objCmdGrid.Parameters.Add(arrOpmGrid[i]);
}
DataSet dsGrid = new DataSet();
OracleDataAdapter daGrid = new OracleDataAdapter(objCmdGrid);
daGrid.Fill(dsGrid);
//this.setGridData(dsGrid);
UltraWebGrid1.Clear();
if (dsGrid.Tables.Count > 0)
{
UltraWebGrid1.DataSource = dsGrid;
UltraWebGrid1.DataBind();
}
}