/// <summary> /// 평가별 주기 /// </summary> /// <param name="ddl"></param> /// <param name="est_id"></param> public static void BindEstTermSub(DropDownList ddl, int comp_id, string est_id, string year_yn) { Biz_TermSubEstMaps termSubEstMap = new Biz_TermSubEstMaps(); DataSet ds = termSubEstMap.GetTermSubEstMap(comp_id, est_id, year_yn); ddl.DataTextField = "ESTTERM_SUB_NAME"; ddl.DataValueField = "ESTTERM_SUB_ID"; ddl.DataSource = ds; ddl.DataBind(); if (ds.Tables[0].Rows.Count == 0) { ddl.Style.Add("display", "none"); } else { ddl.Style.Remove("display"); } //if(ds.Tables[0].Rows.Count == 1) //{ // ddl.Visible = false; //} //else //{ // ddl.Visible = false; //} }
private void BindCblEstTermSub(int comp_id, string est_id) { Biz_TermSubEstMaps termSubEstMaps = new Biz_TermSubEstMaps(); DT_ESTTERM_SUB_MAP = termSubEstMaps.GetTermSubEstMap(comp_id, est_id, "").Tables[0]; Biz_TermSubs termSub = new Biz_TermSubs(); DataSet ds = termSub.GetTermSubByYearYN(COMP_ID, "N"); uGridSub.DataSource = ds; uGridSub.DataBind(); }
/// <summary> /// 평가주기의 총가중치 합 반환 /// </summary> /// <param name="est_id"></param> /// <returns></returns> public static double GetTotalWeightEstTermSub(int comp_id, string est_id) { Biz_TermSubEstMaps estterm = new Biz_TermSubEstMaps(); DataTable dataTable = estterm.GetTermSubEstMap(comp_id, est_id, "").Tables[0]; double total = 0; foreach (DataRow dataRow in dataTable.Rows) { total += DataTypeUtility.GetToDouble(dataRow["WEIGHT"]); } if (total == 0) { return(100); } return(total); }
private bool SaveEstTermSubMap() { Biz_TermSubEstMaps termSubEstMap = new Biz_TermSubEstMaps(); DataTable dataTable = termSubEstMap.GetDataTableSchema(); DataRow dataRow = null; TemplatedColumn ckb_use_yn = null; CheckBox ckbUseYN = null; TemplatedColumn weight_col = null; TextBox txtWeight = null; for (int i = 0; i < uGridSub.Rows.Count; i++) { UltraGridRow row = uGridSub.Rows[i]; ckb_use_yn = (TemplatedColumn)row.Band.Columns.FromKey("USE_YN"); ckbUseYN = (CheckBox)((CellItem)ckb_use_yn.CellItems[row.BandIndex]).FindControl("cBox"); weight_col = (TemplatedColumn)row.Band.Columns.FromKey("WEIGHT"); txtWeight = (TextBox)((CellItem)weight_col.CellItems[row.BandIndex]).FindControl("txtWeight"); if (ckbUseYN.Checked) { dataRow = dataTable.NewRow(); dataRow["COMP_ID"] = COMP_ID; dataRow["EST_ID"] = TreeView1.SelectedValue; dataRow["ESTTERM_SUB_ID"] = uGridSub.Rows[i].Cells.FromKey("ESTTERM_SUB_ID").Value; dataRow["WEIGHT"] = txtWeight.Text; dataRow["DATE"] = DateTime.Now; dataRow["USER"] = EMP_REF_ID; dataTable.Rows.Add(dataRow); } } return(termSubEstMap.SaveTermSubEstMap(dataTable, COMP_ID, TreeView1.SelectedValue)); }
/// <summary> /// 평가 주기의 가중치 String /// </summary> /// <param name="comp_id"></param> /// <param name="est_id"></param> /// <returns></returns> public static string GetWeightStringByEstTermSub(int comp_id, string est_id) { Biz_TermSubEstMaps estterm = new Biz_TermSubEstMaps(); DataTable dataTable = estterm.GetTermSubEstMap(comp_id, est_id, "").Tables[0]; string temp = ""; bool isFirst = true; foreach (DataRow dataRow in dataTable.Rows) { if (isFirst) { temp += DataTypeUtility.GetToDouble(dataRow["WEIGHT"]).ToString("#,##0.00"); isFirst = false; } else { temp += " : " + DataTypeUtility.GetToDouble(dataRow["WEIGHT"]).ToString("#,##0.00"); } } return(temp); }