protected void ibnSave_Click(object sender, ImageClickEventArgs e) { string strGradeID = txtGradeID.Text; string strGradeName = txtGradeName.Text; string strGradeDesc = txtGradeDesc.Text; Biz_Grades grades = new Biz_Grades(); bool bResult = false; if (PageWriteMode == WriteMode.New) { bool bDuplicate = grades.IsExist(COMP_ID, strGradeID); if (bDuplicate) { ltrScript.Text = JSHelper.GetAlertScript("존재하는 등급 ID 입니다."); return; } bResult = grades.AddEstGrade(COMP_ID , strGradeID , strGradeName , strGradeDesc , DateTime.Now , EMP_REF_ID); if (bResult) { GridBinding(COMP_ID); ButtonStatusInit(); } else { ltrScript.Text = JSHelper.GetAlertScript("저장 중 오류가 발생하였습니다."); } } else { bResult = grades.ModifyEstGrade(COMP_ID , strGradeID , strGradeName , strGradeDesc , DateTime.Now , EMP_REF_ID); if (bResult) { GridBinding(COMP_ID); ButtonStatusInit(); } else { ltrScript.Text = JSHelper.GetAlertScript("수정 중 오류가 발생하였습니다."); } } }
public static void BindGrade(DropDownList ddl, int comp_id) { Biz_Grades grade = new Biz_Grades(); DataSet ds = grade.GetEstGrades(comp_id); ddl.DataValueField = "GRADE_ID"; ddl.DataTextField = "GRADE_NAME"; ddl.DataSource = ds; ddl.DataBind(); }
private void ViewOne(int comp_id, string grade_id) { Biz_Grades grades = new Biz_Grades(comp_id, grade_id); txtGradeID.Text = grades.Grade_ID; txtGradeName.Text = grades.Grade_Name; txtGradeDesc.Text = grades.Grade_Desc; hdfGradeID.Value = grade_id; }
private void GridBinding(int comp_id) { Biz_Grades grades = new Biz_Grades(); DataSet ds = grades.GetEstGrades(comp_id); UltraWebGrid1.DataSource = ds; UltraWebGrid1.DataBind(); lblRowCount.Text = ds.Tables[0].Rows.Count.ToString(); }
private void BindGrid(int comp_id, string est_id, string scale_id) { Biz_Scopes scopes = new Biz_Scopes(); DataSet ds = scopes.GetScopeGradeEstID(comp_id, est_id, scale_id); if (ds.Tables[0].Rows.Count == 0) { Biz_Grades grades = new Biz_Grades(); DataSet dsGrade = grades.GetEstGrades(comp_id); UltraWebGrid1.DataSource = dsGrade; UltraWebGrid1.DataBind(); } else { UltraWebGrid1.DataSource = ds; UltraWebGrid1.DataBind(); } }
protected void ibnDelete_Click(object sender, ImageClickEventArgs e) { string strGradeID = hdfGradeID.Value; Biz_Grades grades = new Biz_Grades(); bool bResult = grades.RemoveEstGrade(COMP_ID, strGradeID); if (bResult) { ltrScript.Text = JSHelper.GetAlertScript("정상적으로 삭제되었습니다.", false); GridBinding(COMP_ID); ButtonStatusInit(); } else { ltrScript.Text = JSHelper.GetAlertScript("삭제 중 오류가 발생하였습니다."); } }
protected void ibnCheckID_Click(object sender, ImageClickEventArgs e) { string strGradeID = txtGradeID.Text; if (strGradeID == "") { ltrScript.Text = JSHelper.GetAlertScript("등급 ID를 입력해주세요."); return; } Biz_Grades grades = new Biz_Grades(); bool bDuplicate = grades.IsExist(COMP_ID, strGradeID); if (bDuplicate) { ltrScript.Text = JSHelper.GetAlertScript("존재하는 등급 ID 입니다."); } else { ltrScript.Text = JSHelper.GetAlertScript("사용가능한 등급 ID 입니다."); } }
private void DataBindingGrid(int comp_id , string est_id , int estterm_ref_id , int estterm_sub_id , int estterm_step_id , string year_yn , string merge_yn , string owner_type) { _eOwnerType = BizUtility.GetOwnerType(owner_type); 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 , _eOwnerType).Tables[0]; Biz_Grades grade = new Biz_Grades(); DT_GRADE = grade.GetEstGrades(comp_id).Tables[0]; DataTable dataDept = BizUtility.GetDeptTree(" "); if (_eOwnerType == OwnerType.Dept) { dataDept.Columns.Add("B_POINT", typeof(double)); dataDept.Columns.Add("A_POINT", typeof(double)); dataDept.Columns.Add("B_GRADE", typeof(string)); dataDept.Columns.Add("A_GRADE", typeof(string)); dataDept.Columns.Add("IS_EST", typeof(string)); foreach (DataRow dataRow in dataDept.Rows) { dataRow["B_POINT"] = "0"; dataRow["A_POINT"] = "0"; dataRow["B_GRADE"] = "-"; dataRow["A_GRADE"] = "-"; dataRow["IS_EST"] = "N"; } foreach (DataRow drDept in dataDept.Rows) { DataRow[] drEstData = DT_EST_DATA.Select(string.Format("TGT_DEPT_ID = {0}", drDept["DEPT_REF_ID"])); foreach (DataRow dataEstData in drEstData) { drDept["A_POINT"] = DataTypeUtility.GetToDouble(dataEstData["POINT"]); drDept["A_GRADE"] = DataTypeUtility.GetValue(dataEstData["GRADE_ID"]);; drDept["IS_EST"] = "Y"; } } } else if (_eOwnerType == OwnerType.Emp_User) { foreach (DataRow drGrade in DT_GRADE.Rows) { dataDept.Columns.Add("B_" + drGrade["GRADE_ID"].ToString(), typeof(string)); dataDept.Columns.Add("A_" + drGrade["GRADE_ID"].ToString(), typeof(string)); } dataDept.Columns.Add("IS_EST", typeof(string)); foreach (DataRow dataRow in dataDept.Rows) { foreach (DataRow drGrade in DT_GRADE.Rows) { dataRow["B_" + drGrade["GRADE_ID"].ToString()] = "0"; dataRow["A_" + drGrade["GRADE_ID"].ToString()] = "0"; dataRow["IS_EST"] = "N"; } } foreach (DataRow drDept in dataDept.Rows) { DataRow[] drEstData = DT_EST_DATA.Select(string.Format("TGT_DEPT_ID = {0}", drDept["DEPT_REF_ID"])); foreach (DataRow dataEstData in drEstData) { if (dataEstData["GRADE_ID"] != DBNull.Value) { drDept["A_" + DataTypeUtility.GetValue(dataEstData["GRADE_ID"])] = DataTypeUtility.GetToInt32(drDept["A_" + DataTypeUtility.GetValue(dataEstData["GRADE_ID"])]) + 1; } drDept["IS_EST"] = "Y"; } } DataRow dr = dataDept.NewRow(); dr["DEPT_REF_ID"] = -9999; dr["DEPT_NAME"] = "<div align='center'><b>합 계</b></center>"; dr["IS_EST"] = "T"; dataDept.Rows.Add(dr); foreach (DataRow drGrade in DT_GRADE.Rows) { foreach (DataRow drEstSum in dataDept.Rows) { if (DataTypeUtility.GetToInt32(drEstSum["DEPT_REF_ID"]) > 0) { dataDept.Rows[dataDept.Rows.Count - 1]["B_" + DataTypeUtility.GetValue(drGrade["GRADE_ID"])] = DataTypeUtility.GetToInt32(dataDept.Rows[dataDept.Rows.Count - 1]["B_" + DataTypeUtility.GetValue(drGrade["GRADE_ID"])]) + DataTypeUtility.GetToInt32(drEstSum["B_" + DataTypeUtility.GetValue(drGrade["GRADE_ID"])]); dataDept.Rows[dataDept.Rows.Count - 1]["A_" + DataTypeUtility.GetValue(drGrade["GRADE_ID"])] = DataTypeUtility.GetToInt32(dataDept.Rows[dataDept.Rows.Count - 1]["A_" + DataTypeUtility.GetValue(drGrade["GRADE_ID"])]) + DataTypeUtility.GetToInt32(drEstSum["A_" + DataTypeUtility.GetValue(drGrade["GRADE_ID"])]); } } } } UltraWebGrid1.DataSource = dataDept; UltraWebGrid1.DataBind(); //GridView1.DataSource = dataDept; //GridView1.DataBind(); }