protected void btnSave_Click(object sender, ImageClickEventArgs e) { GridViewRow gridRow = null; GridView grid_sub = null; GridViewRow grid_sub_Row = null; RadioButtonList rBtnColSys_Sub = null; DropDownList ddlColSys_Sub = null; Literal ltrSysKey_Sub = null; Literal ltrSysCtrlType_Sub = null; empSysInfo = new EmpSysInfos_Biz(gUserInfo.Emp_Ref_ID); IDbConnection conn = DbAgentHelper.CreateDbConnection(); conn.Open(); IDbTransaction trx = conn.BeginTransaction(); try { for (int i = 0; i < GridView1.Rows.Count; i++) { gridRow = GridView1.Rows[i]; grid_sub = gridRow.Cells[1].FindControl("gView_Sub") as GridView; for (int k = 0; k < grid_sub.Rows.Count; k++) { grid_sub_Row = grid_sub.Rows[k]; rBtnColSys_Sub = grid_sub_Row.Cells[2].FindControl("rBtnColSys_Sub") as RadioButtonList; ddlColSys_Sub = grid_sub_Row.Cells[2].FindControl("ddlColSys_Sub") as DropDownList; ltrSysKey_Sub = grid_sub_Row.Cells[2].FindControl("ltrSysKey_Sub") as Literal; ltrSysCtrlType_Sub = grid_sub_Row.Cells[2].FindControl("ltrSysCtrlType_Sub") as Literal; if (ltrSysCtrlType_Sub.Text.Equals("RADIO_BUTTON")) { empSysInfo.SetEmpSysDetailUpdate(Convert.ToInt32(ltrSysKey_Sub.Text), rBtnColSys_Sub.SelectedValue); empSysInfo.SetEmpSysDetail(conn, trx, int.Parse(ltrSysKey_Sub.Text), rBtnColSys_Sub.SelectedValue); } else if (ltrSysCtrlType_Sub.Text.Equals("DROPDOWNLIST")) { empSysInfo.SetEmpSysDetailUpdate(Convert.ToInt32(ltrSysKey_Sub.Text), rBtnColSys_Sub.SelectedValue); empSysInfo.SetEmpSysDetail(conn, trx, int.Parse(ltrSysKey_Sub.Text), ddlColSys_Sub.SelectedValue); } } } trx.Commit(); } catch (SqlException ex) { trx.Rollback(); conn.Close(); ltrScript.Text = JSHelper.GetAlertScript("처리 중 오류가 발생하였습니다.", false); return; } finally { conn.Close(); } ltrScript.Text = JSHelper.GetAlertScript("정상적으로 설정되었습니다.", false); DataBindingGrid(); }
private void DataBindingGrid() { empSysInfo = new EmpSysInfos_Biz(gUserInfo.Emp_Ref_ID); GridView1.DataSource = empSysInfo.GetEmpSysCategory(); GridView1.DataBind(); }
private void SetQueryStringData() { _empSysInfo = new EmpSysInfos_Biz(gUserInfo.Emp_Ref_ID); if (GetRequest("ESTTERM_REF_ID").Equals("")) { TermInfos term = new TermInfos(); DataView dw = term.GetAllTermInfo().Tables[0].DefaultView; for (int i = 0; i < dw.Table.Rows.Count; i++) { if (Convert.ToInt32(dw.Table.Rows[i]["EST_STATUS"]) == 1) { ESTTERM_REF_ID = int.Parse(dw.Table.Rows[i]["ESTTERM_REF_ID"].ToString()); return; } } } else { ESTTERM_REF_ID = GetRequestByInt("ESTTERM_REF_ID"); } if (GetRequest("EST_DEPT_REF_ID").Equals("")) { EST_DEPT_REF_ID = _estDeptInfo.GetRootEstDeptID(ESTTERM_REF_ID); } else { EST_DEPT_REF_ID = GetRequestByInt("EST_DEPT_REF_ID"); } MAP_VERSION_ID = GetRequestByInt("MAP_VERSION_ID"); if (GetRequest("TMCODE").Equals("")) { MicroBSC.BSC.Biz.Biz_Bsc_Term_Detail objTerm = new MicroBSC.BSC.Biz.Biz_Bsc_Term_Detail(); TMCODE = objTerm.GetReleasedMonth(); } else { TMCODE = GetRequest("TMCODE"); } string lineType = ""; string showKpiList = ""; if (GetRequest("LINE_TYPE").Equals("")) { lineType = _empSysInfo.GetSysValueByEmpID(1000); } else { lineType = GetRequest("LINE_TYPE"); } if (GetRequest("SHOW_KPI_LIST").Equals("")) { showKpiList = _empSysInfo.GetSysValueByEmpID(1002); } else { showKpiList = GetRequest("SHOW_KPI_LIST"); } ENUMLINETYPE = (lineType == "0") ? LineType.Diagonal : LineType.Straight; ISKPILISTVIEW = (showKpiList == "1") ? true : false; DRAWING_YN = GetRequest("DRAWING_YN", "N"); if (!IsPostBack) { IWORKINGMAP_YN = GetRequest("WORKINGMAPYN", "N"); } FULLSCREEN = GetRequest("FULLSCREEN", "N"); }