private void SetDataBind_gridView1() { Mem_WsSysAuthMemberDB.WsSysAuthMemberDB wSvc = null; string reCode = ""; string reMsg = ""; Mem_WsSysAuthMemberDB.DataSysAuthMemberDB[] getData = null; try { wSvc = new Mem_WsSysAuthMemberDB.WsSysAuthMemberDB(); wSvc.Url = "http://" + AppInfo.SsWsvcServer1 + "/WebSvc/Sys/SysAuth/WsSysAuthMemberDB.svc"; wSvc.Timeout = 1000; reCode = wSvc.sSysAuthMemberDB(DBNM, cmbUse.SelectedValue.ToString(), out getData, out reMsg); if (reCode == "Y") { if (getData != null && getData.Length > 0) { dataGridView1.Rows.Clear(); for (int i = 0; i < getData.Length; i++) { dataGridView1.Rows.Add(); dataGridView1.Rows[i].Cells["dgv1_AUTH_CD"].Value = getData[i].AUTH_CD.ToString(); dataGridView1.Rows[i].Cells["dgv1_AUTH_NM"].Value = getData[i].AUTH_NM.ToString(); dataGridView1.Rows[i].Cells["dgv1_MYBLOCK_FLAG"].Value = getData[i].MYBLOCK_FLAG.ToString(); dataGridView1.Rows[i].Cells["dgv1_MYCON_FLAG"].Value = getData[i].MYCON_FLAG.ToString(); dataGridView1.Rows[i].Cells["dgv1_MYCOM_FLAG"].Value = getData[i].MYCOM_FLAG.ToString(); dataGridView1.Rows[i].Cells["dgv1_MYTEAM_FLAG"].Value = getData[i].MYTEAM_FLAG.ToString(); dataGridView1.Rows[i].Cells["dgv1_USING_FLAG"].Value = getData[i].USING_FLAG.ToString(); dataGridView1.Rows[i].Cells["dgv1_AUTH_LEVEL"].Value = getData[i].AUTH_LEVEL.ToString(); dataGridView1.Rows[i].Cells["dgv1_MEMO"].Value = getData[i].MEMO.ToString(); } SetRowNumber(dataGridView1); } } } catch (Exception ex) { logs.SaveLog("[error] (page)::FrmSysAuthMemberDB.cs (Function)::SetDataBind_gridView1 (Detail)::reMsg=[" + reMsg + "]", "Error"); logs.SaveLog("[error] (page)::FrmSysAuthMemberDB.cs (Function)::SetDataBind_gridView1 (Detail):: " + "\r\n" + ex.ToString(), "Error"); } finally { if (wSvc != null) { wSvc.Dispose(); } } }
//CmbBox -> SITE private void SetDataBind_CmbSite() { Mem_WsSysAuthMemberDB.WsSysAuthMemberDB wSvc = null; string reCode = ""; string reMsg = ""; Mem_WsSysAuthMemberDB.DataSiteMainDB[] getData = null; try { wSvc = new Mem_WsSysAuthMemberDB.WsSysAuthMemberDB(); wSvc.Url = "http://" + AppInfo.SsWsvcServer1 + "/WebSvc/Sys/SysAuth/WsSysAuthMemberDB.svc"; wSvc.Timeout = 1000; reCode = wSvc.sSiteMainDB(AppInfo.SsMemcoCd, out getData, out reMsg); if (reCode == "Y") { if (getData != null && getData.Length > 0) { Class.Common.ComboBoxItemSet setCmb = null; setCmb = new Class.Common.ComboBoxItemSet(); setCmb.AddColumn(); for (int i = 0; i < getData.Length; i++) { setCmb.AddRow(getData[i].SITE_NM.ToString(), getData[i].SITE_CD.ToString()); } setCmb.Bind(cmbSite); } } } catch (Exception ex) { logs.SaveLog("[error] (page)::FrmSysAuthSiteDB.cs (Function)::SetDataBind_CmbMember (Detail):: " + "\r\n" + ex.ToString()); } }
private void GetDbNm() { Mem_WsSysAuthMemberDB.WsSysAuthMemberDB wSvc = null; string reCode = ""; string reMsg = ""; string reData = ""; try { wSvc = new Mem_WsSysAuthMemberDB.WsSysAuthMemberDB(); wSvc.Url = "http://" + AppInfo.SsWsvcServer1 + "/WebSvc/Sys/SysAuth/WsSysAuthMemberDB.svc"; wSvc.Timeout = 1000; reCode = wSvc.sDbNm(AppInfo.SsMemcoCd, out reData, out reMsg); if (reCode == "Y") { if (!string.IsNullOrEmpty(reData)) { _dbNm = reData; } } } catch (Exception ex) { logs.SaveLog("[error] (page)::FrmSysAuthMemberDB.cs (Function)::GetDbNm (Detail)::reCode=[" + reCode + "], reMsg=[" + reMsg + "]", "Error"); logs.SaveLog("[error] (page)::FrmSysAuthMemberDB.cs (Function)::GetDbNm (Detail)::" + "\r\n" + ex.ToString(), "Error"); } finally { if (wSvc != null) { wSvc.Dispose(); } } }
//수정 private void btnSave_Click(object sender, EventArgs e) { Mem_WsSysAuthMemberDB.WsSysAuthMemberDB wSvc = null; string reCode = ""; string reMsg = ""; string reData = "0"; try { wSvc = new Mem_WsSysAuthMemberDB.WsSysAuthMemberDB(); wSvc.Url = "http://" + AppInfo.SsWsvcServer1 + "/WebSvc/Sys/SysAuth/WsSysAuthMemberDB.svc"; wSvc.Timeout = 1000; int reCnt = 0; for (int i = 0; i < dataGridView1.Rows.Count; i++) { if (dataGridView1.Rows[i].Cells["dgv1_CHK"].Value != null) { if (dataGridView1.Rows[i].Cells["dgv1_CHK"].Value.ToString() == "1") { reCnt++; } } } if (reCnt < 1) { MessageBox.Show(msgRM.GetString("msgNotSelected")); return; } reCnt = 0; int reCnt2 = 0; int reCnt3 = 0; for (int i = 0; i < dataGridView1.Rows.Count; i++) { if (dataGridView1.Rows[i].Cells["dgv1_AUTH_CD"].Value != null) { if (dataGridView1.Rows[i].Cells["dgv1_CHK"].Value != null) { if (dataGridView1.Rows[i].Cells["dgv1_CHK"].Value.ToString() == "1") { string sauthCd_val = dataGridView1.Rows[i].Cells["dgv1_AUTH_CD"].Value.ToString(); //readonly string sauthNm_val = dataGridView1.Rows[i].Cells["dgv1_AUTH_NM"].Value.ToString(); //readonly string sauthLevel_val = dataGridView1.Rows[i].Cells["dgv1_AUTH_LEVEL"].Value.ToString(); //readonly string lab_aprv_Flag_val = dataGridView1.Rows[i].Cells["dgv1_LAB_APRV_FLAG"].Value.ToString(); string usingFlag_val = dataGridView1.Rows[i].Cells["dgv1_USING_FLAG"].Value.ToString(); string memo_val = ""; if (dataGridView1.Rows[i].Cells["dgv1_MEMO"].Value != null) { memo_val = dataGridView1.Rows[i].Cells["dgv1_MEMO"].Value.ToString(); } reCode = wSvc.mSysAuthSiteDB(DBNM, cmbSite.SelectedValue.ToString(), sauthCd_val, lab_aprv_Flag_val, usingFlag_val, memo_val, out reMsg, out reData); if (reCode == "Y") { //SITE DB 업데이트 실패시 INSERT 해준다. if (Convert.ToInt16(reData) < 1) { string pInputId = AppInfo.SsLabNo; if (usingFlag_val == "1") { reCode = wSvc.aSysAuthSiteDB(DBNM, cmbSite.SelectedValue.ToString(), sauthCd_val, lab_aprv_Flag_val, usingFlag_val, sauthLevel_val, memo_val, pInputId, out reMsg, out reData); if (reCode == "Y" && reData != "0") { reCnt += Convert.ToInt16(reData); } } else { reCnt3++; } } else { reCnt += Convert.ToInt16(reData); } } else { reCnt2++; } } } } } if (reCnt > 0) { MessageBox.Show(wRM.GetString("wSuccess") + "[" + reCnt.ToString() + "], " + wRM.GetString("wFail") + "[" + reCnt2.ToString() + "], " + wRM.GetString("wNotUsing") + "[" + reCnt3.ToString() + "]"); } else { MessageBox.Show(wRM.GetString("wSuccess") + "[" + reCnt.ToString() + "], " + wRM.GetString("wFail") + "[" + reCnt2.ToString() + "], " + wRM.GetString("wNotUsing") + "[" + reCnt3.ToString() + "]"); } SetDataBind_gridView1(); } catch (Exception ex) { logs.SaveLog("[error] (page)::FrmSysAuthSiteDB.cs (Function)::btnSave_Click (Detail):: " + "\r\n" + ex.ToString(), "Error"); } finally { if (wSvc != null) { wSvc.Dispose(); } } }
//추가버튼 클릭 private void dataGridView2_CellClick(object sender, DataGridViewCellEventArgs e) { string colNm = dataGridView2.Columns[e.ColumnIndex].Name; if (colNm == "dgv2_BTNADD") { string reVal = ChkDgv2Param(); if (reVal != "") { MessageBox.Show(wRM.GetString("wCheck") + " :: " + reVal); } else { string sauthCd_val = dataGridView2.Rows[0].Cells["dgv2_AUTH_CD"].Value.ToString(); string sauthNm_val = dataGridView2.Rows[0].Cells["dgv2_AUTH_NM"].Value.ToString(); string myblockFlag_val = dataGridView2.Rows[0].Cells["dgv2_MYBLOCK_FLAG"].Value.ToString(); string myconFlag_val = dataGridView2.Rows[0].Cells["dgv2_MYCON_FLAG"].Value.ToString(); string mycomFlag_val = dataGridView2.Rows[0].Cells["dgv2_MYCOM_FLAG"].Value.ToString(); string myteamFlag_val = dataGridView2.Rows[0].Cells["dgv2_MYTEAM_FLAG"].Value.ToString(); string usingFlag_val = "1"; string sauthLevel_val = dataGridView2.Rows[0].Cells["dgv2_AUTH_LEVEL"].Value.ToString(); string memo_val = ""; if (dataGridView2.Rows[0].Cells["dgv2_MEMO"].Value != null) { memo_val = dataGridView2.Rows[0].Cells["dgv2_MEMO"].Value.ToString(); } string pInputId = AppInfo.SsLabNo; Mem_WsSysAuthMemberDB.WsSysAuthMemberDB wSvc = null; string reCode = ""; string reMsg = ""; string reData = ""; try { int reCnt = 0; wSvc = new Mem_WsSysAuthMemberDB.WsSysAuthMemberDB(); wSvc.Url = "http://" + AppInfo.SsWsvcServer1 + "/WebSvc/Sys/SysAuth/WsSysAuthMemberDB.svc"; wSvc.Timeout = 1000; //중복 확인 MAINDB를 확인한다. param = 코드, 이름 reCode = wSvc.exSysAuthMainDB(sauthCd_val, sauthNm_val, out reMsg, out reData); if (reCode == "Y") { if (reData != "0") { MessageBox.Show(msgRM.GetString("msgDuplicated")); } else { reCode = ""; // * 메인 디비에 인서트를 해준다. reCode = wSvc.aSysAuthMainDB(sauthCd_val, sauthNm_val, myblockFlag_val, myconFlag_val, mycomFlag_val, myteamFlag_val, usingFlag_val, sauthLevel_val, memo_val, pInputId, out reMsg, out reData); if (reCode == "Y") { if (reData != "") { reCode = ""; // * 멤버 디비에 인서트를 해준다. reCode = wSvc.aSysAuthMemberDB(DBNM, sauthCd_val, sauthNm_val, myblockFlag_val, myconFlag_val, mycomFlag_val, myteamFlag_val, usingFlag_val, sauthLevel_val, memo_val, pInputId, out reMsg, out reData); if (reCode == "Y" && reData != "") { reCnt = Convert.ToInt16(reData); } } } if (reCnt > 0) { MessageBox.Show(wRM.GetString("wSave") + " " + wRM.GetString("wSuccess")); } else { MessageBox.Show(wRM.GetString("wSave") + " " + wRM.GetString("wFail")); } SetDataBind_gridView1(); SetDataBind_gridView2(); } } } catch (Exception ex) { logs.SaveLog("[error] (page)::FrmSysAuthMemberDB.cs (Function)::dataGridView2_CellClick (Detail):: " + "\r\n" + ex.ToString(), "Error"); } finally { if (wSvc != null) { wSvc.Dispose(); } } } } }