private void setGridData(DataSet iDsSet)
{
double dblPlan = 0.00;
double dblActl = 0.00;
double dblRlan = 0.00;
double dblRslt = 0.00;
int intRow = iDsSet.Tables[0].Rows.Count;
for (int i = 0; i < intRow; i++)
{
dblPlan += double.Parse(iDsSet.Tables[0].Rows[i]["계획"].ToString());
dblActl += double.Parse(iDsSet.Tables[0].Rows[i]["실적"].ToString());
dblRslt += double.Parse(iDsSet.Tables[0].Rows[i]["전년동기실적"].ToString());
}
DataRow drTmp = iDsSet.Tables[0].NewRow();
drTmp["구분"] = "합 계";
drTmp["계획"] = dblPlan;
drTmp["실적"] = dblActl;
drTmp["전년동기실적"] = dblRslt;
drTmp["차이"] = dblActl - dblPlan;
drTmp["달성율(%)"] = (dblPlan == 0) ? 0.00 : Math.Round((dblActl / dblPlan) * 100, 2);
drTmp["차 이"] = dblActl - dblRslt;
drTmp["증가율(%)"] = (dblRslt == 0) ? 0.00 : Math.Round((dblActl / dblRslt) * 100, 2);
iDsSet.Tables[0].Rows.InsertAt(drTmp, 0);
UltraWebGrid1.DataSource = iDsSet;
UltraWebGrid1.DataBind();
}
protected void btnReset_Click(object sender, System.EventArgs e)
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.ResetBands();
PerformSearch();
PerformDataBind();
}
private void setGridData(DataSet iDsSet)
{
double dblPlan = 0.00;
double dblActl = 0.00;
double dblRslt = 0.00;
int intRow = iDsSet.Tables[0].Rows.Count;
for (int i = 0; i < intRow; i++)
{
dblPlan += double.Parse(iDsSet.Tables[0].Rows[i]["S_PLAN"].ToString());
dblActl += double.Parse(iDsSet.Tables[0].Rows[i]["S_RSLT"].ToString());
dblRslt += double.Parse(iDsSet.Tables[0].Rows[i]["L_RSLT"].ToString());
}
DataRow drTmp = iDsSet.Tables[0].NewRow();
drTmp["SGBUN_NM"] = "합 계";
drTmp["S_PLAN"] = dblPlan;
drTmp["S_RSLT"] = dblActl;
drTmp["L_RSLT"] = dblRslt;
drTmp["S_DIFF"] = dblActl - dblPlan;
drTmp["ACHV_RATE"] = (dblPlan == 0) ? 0.00 : Math.Round((dblActl / dblPlan) * 100, 1);
drTmp["S_ADD"] = dblActl - dblRslt;
drTmp["GROW_RATE"] = (dblRslt == 0) ? 0.00 : Math.Round((dblActl / dblRslt) * 100, 1);
iDsSet.Tables[0].Rows.InsertAt(drTmp, 0);
UltraWebGrid1.DataSource = iDsSet;
UltraWebGrid1.DataBind();
}
protected void llenarvacio()
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns.Add("Clave única");
UltraWebGrid1.Columns.Add("Clave defecto");
UltraWebGrid1.Columns.Add("Descripción");
UltraWebGrid1.Columns.Add("Tipo defecto");
UltraWebGrid1.Columns.Add("Proceso");
UltraWebGrid1.Columns.Add("Responsable");
UltraWebGrid1.Columns[0].Header.Caption = "Clave única";
UltraWebGrid1.Columns[1].Header.Caption = "Clave defecto";
UltraWebGrid1.Columns[2].Header.Caption = "Descripción";
UltraWebGrid1.Columns[3].Header.Caption = "Tipo defecto";
UltraWebGrid1.Columns[4].Header.Caption = "Proceso";
UltraWebGrid1.Columns[5].Header.Caption = "Responsable";
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center;
}
private void BindGrid()
{
UltraWebGrid1.Clear();
UltraWebGrid1.DataSource = _questionDefine.GetQuestionDefine(EST_ID);
UltraWebGrid1.DataBind();
}
protected void llenarvacio()
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns.Add("Fecha");
UltraWebGrid1.Columns.Add("Densidad");
UltraWebGrid1.Columns.Add("BU");
UltraWebGrid1.Columns.Add("Autorización");
UltraWebGrid1.Columns.Add("Activo");
UltraWebGrid1.Columns.Add("Baroi");
UltraWebGrid1.Columns.Add("Turno");
UltraWebGrid1.Columns[0].Header.Caption = "Fecha";
UltraWebGrid1.Columns[1].Header.Caption = "Densidad";
UltraWebGrid1.Columns[2].Header.Caption = "BU";
UltraWebGrid1.Columns[3].Header.Caption = "Autorización";
UltraWebGrid1.Columns[4].Header.Caption = "Activo";
UltraWebGrid1.Columns[5].Header.Caption = "Baroi";
UltraWebGrid1.Columns[6].Header.Caption = "Turno";
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[6].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Width = 80;
UltraWebGrid1.Columns[1].Width = 70;
}
protected void llenarvacio()
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns.Add("Clave única");
UltraWebGrid1.Columns.Add("Clave artículo");
UltraWebGrid1.Columns.Add("Descripción");
UltraWebGrid1.Columns.Add("Tipo artículo");
UltraWebGrid1.Columns.Add("Activo");
UltraWebGrid1.Columns[0].Header.Caption = "Clave única";
UltraWebGrid1.Columns[1].Header.Caption = "Clave artículo";
UltraWebGrid1.Columns[2].Header.Caption = "Descripción";
UltraWebGrid1.Columns[3].Header.Caption = "Tipo artículo";
UltraWebGrid1.Columns[4].Header.Caption = "Activo";
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Width = 110;
UltraWebGrid1.Columns[3].Width = 110;
}
protected void llenarvacio()
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns.Add("Clave única");
UltraWebGrid1.Columns.Add("Clave máquina");
UltraWebGrid1.Columns.Add("Descripción");
UltraWebGrid1.Columns.Add("Tipo de máquina");
UltraWebGrid1.Columns.Add("Proceso");
UltraWebGrid1.Columns.Add("Centro de trabajo");
UltraWebGrid1.Columns[0].Header.Caption = "Clave única";
UltraWebGrid1.Columns[1].Header.Caption = "Clave máquina";
UltraWebGrid1.Columns[2].Header.Caption = "Descripción";
UltraWebGrid1.Columns[3].Header.Caption = "Tipo de máquina";
UltraWebGrid1.Columns[4].Header.Caption = "Proceso";
UltraWebGrid1.Columns[5].Header.Caption = "Centro de trabajo";
UltraWebGrid1.Columns[2].Width = 160;
UltraWebGrid1.Columns[3].Width = 120;
UltraWebGrid1.Columns[5].Width = 120;
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center;
}
private void BindingTgtEmp(int est_emp_id)
{
Biz_Datas data = new Biz_Datas();
DataTable dataTable = data.GetEstData(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, 0
, est_emp_id
, 0
, 0
, YEAR_YN
, MERGE_YN
, OwnerType.Emp_User).Tables[0];
dataTable = DataTypeUtility.GetGroupByDataTable(dataTable
, new string[] { "TGT_EMP_ID", "TGT_EMP_NAME", "TGT_POS_CLS_ID", "TGT_POS_CLS_NAME", "TGT_POS_DUT_ID", "TGT_POS_DUT_NAME", "TGT_POS_GRP_ID", "TGT_POS_GRP_NAME", "TGT_POS_RNK_ID", "TGT_POS_RNK_NAME", "TGT_POS_KND_ID", "TGT_POS_KND_NAME" });
dataTable = DataTypeUtility.FilterSortDataTable(dataTable, "", "TGT_EMP_NAME");
UltraWebGrid1.DataSource = dataTable;
UltraWebGrid1.DataBind();
lblRowCount.Text = dataTable.Rows.Count.ToString("#,##0");
}
private void SearchDB()
{
UltraWebGrid1.DataSource = GetSearchData();
UltraWebGrid1.DataBind();
// 추가시에는 현재타입의 갯수만큼만 처리되도록 확인처리한다.
////int iRowCnt = UltraWebGrid1.Rows.Count;
////int iType = Convert.ToInt32(PageUtility.GetByValueDropDownList(ddlType));
////string sAddScript = "";
////if (iType > iRowCnt)
////{
//// sAddScript = string.Format(
//// "return gfConfirmWait(this, '{0}');"
//// , "추가 등급을 적용하려면,\\n\\n"
//// + "KPI 의 THRESHOLD 들을 재설정하셔야 합니다.\\n\\n"
//// + "추가 하시겠습니까?"
//// );
////}
////else
////{
//// sAddScript = string.Format(
//// "alert('{0}');return false;"
//// , "현재측정단계에서는 더이상 추가하실 수 없습니다!"
//// );
////}
////iBtnAdd.Attributes.Remove("onclick");
////iBtnAdd.Attributes["onclick"] = sAddScript;
}
private void SearchDB()
{
UltraWebGrid1.DataSource = GetSearchData();
UltraWebGrid1.DataBind();
//SearchDetail("0");
}
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 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_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);
}
}
protected void llenarvacio()
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns.Add("Clave única");
UltraWebGrid1.Columns.Add("Clave centro trabajo");
UltraWebGrid1.Columns.Add("Descripción");
UltraWebGrid1.Columns.Add("Proceso");
UltraWebGrid1.Columns.Add("Línea de producción");
UltraWebGrid1.Columns[0].Header.Caption = "Clave única";
UltraWebGrid1.Columns[1].Header.Caption = "Clave centro de trabajo";
UltraWebGrid1.Columns[2].Header.Caption = "Descripción";
UltraWebGrid1.Columns[3].Header.Caption = "Proceso";
UltraWebGrid1.Columns[4].Header.Caption = "Línea de producción";
UltraWebGrid1.Columns[1].Header.Style.Wrap = true;
UltraWebGrid1.Columns[4].Header.Style.Wrap = true;
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[0].Width = 100;
UltraWebGrid1.Columns[1].Width = 100;
UltraWebGrid1.Columns[2].Width = 150;
UltraWebGrid1.Columns[3].Width = 120;
UltraWebGrid1.Columns[4].Width = 120;
}
public void SetGridHeader()
{
int iRow = UltraWebGrid1.Columns.Count;
for (int i = iRow; i > 0; i--)
{
UltraWebGrid1.Columns.RemoveAt(iRow);
}
UltraWebGrid1.ResetColumns();
DataTable dtCol = this.CODE_TABLE;
iRow = dtCol.Rows.Count;
UltraGridColumn cn = null;
cn = new UltraGridColumn("YY", "년도", ColumnType.NotSet, "");
cn.BaseColumnName = "YY";
cn.Width = Unit.Pixel(120);
cn.CellStyle.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns.Add(cn);
for (int i = 0; i < iRow; i++)
{
cn = new UltraGridColumn(dtCol.Rows[i][0].ToString(), dtCol.Rows[i][1].ToString(), ColumnType.NotSet, 0);
cn.BaseColumnName = dtCol.Rows[i][0].ToString();
cn.Width = Unit.Pixel(165);
cn.DataType = "System.Double";
cn.Format = "#,###,###,###,###,###,###,###,###,##0.00";
cn.CellStyle.HorizontalAlign = HorizontalAlign.Right;
UltraWebGrid1.Columns.Add(cn);
}
}
protected void llenarvacio()
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns.Add("Fecha");
UltraWebGrid1.Columns.Add("Tiempo espejo");
UltraWebGrid1.Columns.Add("Viscosidad");
UltraWebGrid1.Columns.Add("Densidad");
UltraWebGrid1.Columns.Add("Espesor");
UltraWebGrid1.Columns.Add("Autorización");
UltraWebGrid1.Columns.Add("Activo");
UltraWebGrid1.Columns[0].Header.Caption = "Fecha";
UltraWebGrid1.Columns[1].Header.Caption = "Tiempo espejo";
UltraWebGrid1.Columns[2].Header.Caption = "Viscosidad";
UltraWebGrid1.Columns[3].Header.Caption = "Densidad";
UltraWebGrid1.Columns[4].Header.Caption = "Espesor";
UltraWebGrid1.Columns[5].Header.Caption = "Autorización";
UltraWebGrid1.Columns[6].Header.Caption = "Activo";
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[6].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Width = 100;
}
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;
}
}
protected void llenarvacioP()
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns.Add("Fecha");
UltraWebGrid1.Columns.Add("Proceso");
UltraWebGrid1.Columns.Add("Centro de trabajo");
UltraWebGrid1.Columns.Add("Maquina");
UltraWebGrid1.Columns.Add("Posicion");
UltraWebGrid1.Columns.Add("Operador");
UltraWebGrid1.Columns.Add("Defectos");
UltraWebGrid1.Columns[0].Header.Caption = "Fecha";
UltraWebGrid1.Columns[1].Header.Caption = "Proceso";
UltraWebGrid1.Columns[2].Header.Caption = "Centro de trabajo";
UltraWebGrid1.Columns[3].Header.Caption = "Maquina";
UltraWebGrid1.Columns[4].Header.Caption = "Posicion";
UltraWebGrid1.Columns[5].Header.Caption = "Operador";
UltraWebGrid1.Columns[6].Header.Caption = "Defectos";
UltraWebGrid1.Columns[4].Hidden = true;
UltraWebGrid1.Columns[2].Width = 120;
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[6].Header.Style.HorizontalAlign = HorizontalAlign.Center;
}
private void DoBinding_JeonSa()
{
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
, "T");
UltraWebGrid1.DataSource = dtNHIT;
UltraWebGrid1.DataBind();
//dtNHIT = bizNHIT.GetJeonSa(GRP_ONE_ID.A.ToString()
// , (int)GRP_TWO_ID.GTO_10
// , GRP_THREE_ID.ME.ToString()
// , CR_YEAR
// , CR_MONTH);
DoDrawingJunsaChart1(dtNHIT, chart1);
dtNHIT = bizNHIT.GetJeonSa(GRP_ONE_ID.A.ToString()
, (int)GRP_TWO_ID.GTO_10
, GRP_THREE_ID.DN.ToString()
, CR_YEAR
, ""
, "T");
DoDrawingJunsaChart2(dtNHIT, chartMM);
}
protected void TreeView1_SelectedNodeChanged(object sender, EventArgs e)
{
string deptId = TreeView1.SelectedNode.Value;
UltraWebGrid1.DataSource = GetEmpInfoList(deptId);
UltraWebGrid1.DataBind();
}
protected void llenarvacio()
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns.Add("Código");
UltraWebGrid1.Columns.Add("Proceso");
UltraWebGrid1.Columns.Add("Proceso Padre");
UltraWebGrid1.Columns.Add("Manufacturing");
UltraWebGrid1.Columns.Add("Requerido");
UltraWebGrid1.Columns.Add("Orden");
UltraWebGrid1.Columns[0].Header.Caption = "Código";
UltraWebGrid1.Columns[1].Header.Caption = "Proceso";
UltraWebGrid1.Columns[2].Header.Caption = "Proceso Padre";
UltraWebGrid1.Columns[3].Header.Caption = "MFG";
UltraWebGrid1.Columns[4].Header.Caption = "Requerido";
UltraWebGrid1.Columns[5].Header.Caption = "Orden";
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Width = 70;
UltraWebGrid1.Columns[4].Width = 70;
UltraWebGrid1.Columns[5].Width = 70;
}
private void BindingGrid(int comp_id, string est_id, int estterm_ref_id, int estterm_sub_id)
{
Biz_Datas data = new Biz_Datas();
DT_EST_DATA = data.GetData(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, 0
, 0
, 0
, 0
, YEAR_YN
, MERGE_YN
, OwnerType.Dept).Tables[0];
DataTable dataTable = BizUtility.GetDeptTree(" ");
UltraWebGrid1.DataSource = dataTable;
UltraWebGrid1.DataBind();
lblRowCount.Text = dataTable.Rows.Count.ToString();
}
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 llenargrid()
{
svcSCPP.SCPPClient svc = new svcSCPP.SCPPClient();
List <Common.SolutionEntityFramework.BaseSolutionEntity> Lista = svc.ObtenerAlmacen();
UltraWebGrid1.DataSource = Lista;
if (Lista.Count <= 0)
{
llenarvacio();
}
else
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns[3].Hidden = true;
UltraWebGrid1.Columns[0].Header.Caption = "Clave única";
UltraWebGrid1.Columns[1].Header.Caption = "Clave almacén";
UltraWebGrid1.Columns[2].Header.Caption = "Descripción";
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Width = 180;
UltraWebGrid1.Columns[0].CellStyle.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].CellStyle.HorizontalAlign = HorizontalAlign.Center;
}
}
private void PerformDataBind()
{
UltraWebGrid1.DataSource = ds.Tables[ParentTable].DefaultView;
UltraWebGrid1.DataBind();
this.UltraWebGrid1.DisplayLayout.Pager.PageCount = iPageCount;
// if(UltraWebGrid1.Rows.Count<1)
// {
// UltraWebGrid1.Visible = false;
// lblNoData.Text = "No Data was found!";
// lblNoData.Visible = true;
// }
// else
// {
// lblNoData.Visible = false;
// }
// foreach(UltraGridColumn aColumn in this.UltraWebGrid1.Columns)
// {
// if(aColumn.DataType == "System.DateTime")
// {
// aColumn.Format = "MM/dd/yyyy";
// }
// }
}
private void GridDataBinding()
{
string query = @"
SELECT ISNULL(CE.EMP_REF_ID,0) as EMP_REF_ID,
RTRIM(ISNULL(DE.DEPT_NAME,'')) as DEPT_NAME,
ISNULL(CE.EMP_NAME,'') as EMP_NAME,
MAX(ISNULL(CE.EMP_EMAIL,'')) as EMP_EMAIL
FROM KPI_INFO KI,
COM_EMP_INFO CE,
COM_DEPT_INFO DE,
REL_DEPT_EMP RD,
KPI_RESULT KR,
(SELECT " + hdnMM.Value + @" as TMCODE, MON_" + hdnMM.Value + @"_FLAG as CHECK_YN, KPI_REF_ID FROM KPI_TERM WHERE KPI_TERM_TYPE = 0) TM
WHERE KI.KPI_REF_ID *= KR.KPI_REF_ID
AND KI.KPI_REF_ID *= TM.KPI_REF_ID
AND KI.CHAMPION_EMP_ID *= CE.EMP_REF_ID
AND RD.EMP_REF_ID = CE.EMP_REF_ID
AND RD.DEPT_REF_ID = DE.DEPT_REF_ID
AND TM.CHECK_YN = 1
AND KR.CHECKSTATUS IN (" + ddlApplyYN.SelectedValue + @")
AND KR.TMCODE = " + hdnMM.Value + @"
GROUP BY DE.DEPT_REF_ID,DE.DEPT_NAME,CE.EMP_REF_ID, CE.EMP_NAME
";
MicroBSC.Data.DBAgent gDbAgent = new MicroBSC.Data.DBAgent(System.Configuration.ConfigurationManager.ConnectionStrings["MainDB"].ConnectionString);
DataSet ds = gDbAgent.FillDataSet(query, "data");
EmpInfos emp = new EmpInfos();
UltraWebGrid1.DataSource = ds.Tables[0].DefaultView;
UltraWebGrid1.DataBind();
}
protected void llenarvacio()
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns.Add("Clave turno");
UltraWebGrid1.Columns.Add("Descripción");
UltraWebGrid1.Columns.Add("Hora inicio");
UltraWebGrid1.Columns.Add("Hora fin");
UltraWebGrid1.Columns.Add("Activo");
UltraWebGrid1.Columns[0].Header.Caption = "Clave turno";
UltraWebGrid1.Columns[1].Header.Caption = "Descripción";
UltraWebGrid1.Columns[2].Header.Caption = "Hora inicio";
UltraWebGrid1.Columns[3].Header.Caption = "Hora fin";
UltraWebGrid1.Columns[4].Header.Caption = "Activo";
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Width = 70;
}
private void setGridData(DataSet iDsSet)
{
/*
* double dblCYActl = 0.00;
* double dblPYActl = 0.00;
* double dblDiff = 0.00;
* double dblRate = 0.00;
*
*
* int intRow = iDsSet.Tables[0].Rows.Count;
* for (int i = 0; i < intRow; i++)
* {
* dblCYActl += double.Parse(iDsSet.Tables[0].Rows[i]["월실적"].ToString());
* dblPYActl += double.Parse(iDsSet.Tables[0].Rows[i]["전년동기실적"].ToString());
* }
*
* DataRow drTmp = iDsSet.Tables[0].NewRow();
* drTmp["지역명"] = "합 계";
* drTmp["월실적"] = dblCYActl;
* drTmp["전년동기실적"] = dblPYActl;
* drTmp["전년대비증감"] = (dblCYActl - dblPYActl);
* drTmp["증감율"] = (dblPYActl == 0) ? 0.00 : Math.Round((dblCYActl / dblPYActl) * 100, 2);
* iDsSet.Tables[0].Rows.InsertAt(drTmp, 0);
*
*/
UltraWebGrid1.DataSource = iDsSet;
UltraWebGrid1.DataBind();
}
private void PerformDataBind()
{
performDetailDataRefine();
UltraWebGrid1.DataSource = ds.Tables[ParentTable].DefaultView;
UltraWebGrid1.DataBind();
if (UltraWebGrid1.Rows.Count < 1)
{
UltraWebGrid1.Visible = false;
lblNoData.Text = "No Data was found!";
lblNoData.Visible = true;
}
else
{
lblNoData.Visible = false;
}
foreach (UltraGridColumn aColumn in this.UltraWebGrid1.Columns)
{
if (aColumn.DataType == "System.DateTime")
{
aColumn.Format = "MM/dd/yyyy";
}
}
}
