private void SetDataBind_gridView1() { M_WsMember.WsMember wSvc = null; string reCode = ""; string reMsg = ""; M_WsMember.DataSiteDB[] getData = null; try { wSvc = new M_WsMember.WsMember(); wSvc.Url = "http://" + AppInfo.SsWsvcServer2 + "/WebSvc/Sys/MemberSite/WsMember.svc"; wSvc.Timeout = 1000; string pUsing_Flag = ""; if (cmbMember.SelectedValue != null) { //CMB BOX SELECTED reCode = wSvc.sSite(cmbMember.SelectedValue.ToString(), pUsing_Flag, 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_SITE_CD"].Value = getData[i].SITE_CD.ToString(); dataGridView1.Rows[i].Cells["dgv1_MEMCO_CD"].Value = getData[i].MEMCO_CD.ToString(); dataGridView1.Rows[i].Cells["dgv1_SITE_NM"].Value = getData[i].SITE_NM.ToString(); dataGridView1.Rows[i].Cells["dgv1_USING_FLAG"].Value = getData[i].USING_FLAG.ToString(); dataGridView1.Rows[i].Cells["dgv1_SORT_NO"].Value = getData[i].SORT_NO.ToString(); dataGridView1.Rows[i].Cells["dgv1_MEMO"].Value = getData[i].MEMO.ToString(); } SetRowNumber(dataGridView1); } } } catch (Exception ex) { logs.SaveLog("[error] (page)::FrmSite.cs (Function)::SetDataBind_gridView1 (Detail)::reMsg=[" + reMsg + "]", "Error"); logs.SaveLog("[error] (page)::FrmSite.cs (Function)::SetDataBind_gridView1 (Detail):: " + "\r\n" + ex.ToString(), "Error"); } finally { if (wSvc != null) { wSvc.Dispose(); } } }
private void SetDataBind_gridView1(string pMemcoCD) { M_WsMember.WsMember wSvc = null; string reCode = ""; string reMsg = ""; M_WsMember.DataMemberDB[] getData = null; try { wSvc = new M_WsMember.WsMember(); // 시스템 코드 보여주기 wSvc.Url = "http://" + AppInfo.SsWsvcServer2 + "/WebSvc/Sys/MemberSite/WsMember.svc"; wSvc.Timeout = 1000; reCode = wSvc.sMember(pMemcoCD, 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_CHK"].Value = "0"; dataGridView1.Rows[i].Cells["dgv1_MEMCO_CD"].Value = getData[i].MEMCO_CD.ToString(); dataGridView1.Rows[i].Cells["dgv1_MEMCO_NM"].Value = getData[i].MEMCO_NM.ToString(); dataGridView1.Rows[i].Cells["dgv1_USING_FLAG"].Value = getData[i].USING_FLAG.ToString(); dataGridView1.Rows[i].Cells["dgv1_SORT_NO"].Value = getData[i].SORT_NO.ToString(); dataGridView1.Rows[i].Cells["dgv1_MEMO"].Value = getData[i].MEMO.ToString(); } SetRowNumber(dataGridView1); } else { dataGridView1.Rows.Clear(); //MessageBox.Show("데이터가 없습니다"); } } } catch (Exception ex) { logs.SaveLog("[error] (page)::FrmMember.cs (Function)::SetDataBind_gridView1 (Detail)::pMemcoCD=[" + pMemcoCD + "]", "Error"); logs.SaveLog("[error] (page)::FrmMember.cs (Function)::SetDataBind_gridView1 (Detail)::reMsg=[" + reMsg + "]", "Error"); logs.SaveLog("[error] (page)::FrmMember.cs (Function)::SetDataBind_gridView1 (Detail):: " + "\r\n" + ex.ToString(), "Error"); } finally { if (wSvc != null) { wSvc.Dispose(); } } }
//추가버튼 클릭 private void dataGridView2_CellClick(object sender, DataGridViewCellEventArgs e) { int reCnt = 0; string colNm = dataGridView2.Columns[e.ColumnIndex].Name; if (colNm == "dgv2_BTNADD") { string reVal = ChkDgv2Param(); if (reVal != "") { MessageBox.Show(wRM.GetString("wCheck") + " :: " + reVal); } else { string memcoCd_val = cmbMember.SelectedValue.ToString(); string siteNm_val = dataGridView2.Rows[0].Cells["dgv2_SITE_NM"].Value.ToString(); string sortNo_val = "10"; if (dataGridView2.Rows[0].Cells["dgv2_SORT_NO"].Value != null) { sortNo_val = dataGridView2.Rows[0].Cells["dgv2_SORT_NO"].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; string headcoCd_val = ""; if (dataGridView2.Rows[0].Cells["dgv2_HEADCO_CD"].Value != null) { headcoCd_val = dataGridView2.Rows[0].Cells["dgv2_HEADCO_CD"].Value.ToString(); } M_WsMember.WsMember wSvc = null; string reCode = ""; string reMsg = ""; string reData = ""; try { wSvc = new M_WsMember.WsMember(); wSvc.Url = "http://" + AppInfo.SsWsvcServer2 + "/WebSvc/Sys/MemberSite/WsMember.svc"; wSvc.Timeout = 1000; string[] param = new string[6]; param[0] = memcoCd_val; param[1] = siteNm_val; param[2] = sortNo_val; param[3] = memo_val; param[4] = pInputId; param[5] = headcoCd_val; reCode = wSvc.aSite(_dbNm, param, out reMsg, out reData); if (reCode == "Y" && reData != "0") { 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)::FrmMember.cs (Function)::dataGridView2_CellClick (Detail):: " + "\r\n" + ex.ToString(), "Error"); } finally { if (wSvc != null) { wSvc.Dispose(); } } } } }
//수정 private void btnSave_Click(object sender, EventArgs e) { M_WsMember.WsMember wSvc = null; string reCode = ""; string reMsg = ""; string reData = "0"; try { wSvc = new M_WsMember.WsMember(); wSvc.Url = "http://" + AppInfo.SsWsvcServer2 + "/WebSvc/Sys/MemberSite/WsMember.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; 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") { string siteCd_val = dataGridView1.Rows[i].Cells["dgv1_SITE_CD"].Value.ToString(); string memcoCd_val = dataGridView1.Rows[i].Cells["dgv1_MEMCO_CD"].Value.ToString(); //string memcoNm_val = dataGridView1.Rows[i].Cells["dgv1_SITE_NM"].Value.ToString(); string siteNm_val = dataGridView1.Rows[i].Cells["dgv1_SITE_NM"].Value.ToString(); string usingFlag_val = dataGridView1.Rows[i].Cells["dgv1_USING_FLAG"].Value.ToString(); string sortNo_val = "1"; if (dataGridView1.Rows[i].Cells["dgv1_SORT_NO"].Value != null) { sortNo_val = dataGridView1.Rows[i].Cells["dgv1_SORT_NO"].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.mSite(siteCd_val, siteNm_val, usingFlag_val, sortNo_val, memo_val, out reMsg, out reData); if (reCode == "Y" && reData != "0") { reCnt += Convert.ToInt16(reData); } } } } if (reCnt > 0) { MessageBox.Show(wRM.GetString("wSave") + " " + wRM.GetString("wSuccess") + " : " + reCnt.ToString()); } else { MessageBox.Show(wRM.GetString("wSave") + " " + wRM.GetString("wFail")); } SetDataBind_gridView1(); } catch (Exception ex) { logs.SaveLog("[error] (page)::FrmSite.cs (Function)::btnSave_Click (Detail):: " + "\r\n" + ex.ToString(), "Error"); } finally { if (wSvc != null) { wSvc.Dispose(); } } }
private void SetDataBind_treeView1() { treeView1.Nodes.Clear(); M_WsMember.WsMember wSvc = null; string reCode = ""; string reMsg = ""; M_WsMember.DataMemberDB[] getData = null; try { wSvc = new M_WsMember.WsMember(); wSvc.Url = "http://" + AppInfo.SsWsvcServer2 + "/WebSvc/Sys/MemberSite/WsMember.svc"; wSvc.Timeout = 1000; ImageList myimageList = new ImageList(); myimageList.Images.Add(Image.FromFile(@"Image\treeicon1.png")); treeView1.ImageList = myimageList; treeView1.ImageIndex = 0; TreeNode root = new TreeNode(); root.Tag = ""; root.Text = wRM.GetString("wTotal"); reCode = wSvc.sMember_UsingFlag("", out getData, out reMsg); if (reCode == "Y") { if (getData != null && getData.Length > 0) { for (int i = 0; i < getData.Length; i++) { string scodeGrp_val = getData[i].MEMCO_CD.ToString(); string scodeNm_val = getData[i].MEMCO_NM.ToString(); TreeNode node1 = new TreeNode(); node1.Tag = scodeGrp_val; node1.Text = scodeNm_val; root.Nodes.Add(node1); } treeView1.Nodes.Add(root); if (treeView1.Nodes.Count > 0) { treeView1.SelectedNode = treeView1.GetNodeAt(0, 0); } treeView1.ExpandAll(); } } } catch (Exception ex) { logs.SaveLog("[error] (page)::FrmMember.cs (Function)::setDataBind_treeView1 (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 pMemcoNm = dataGridView2.Rows[0].Cells["dgv2_MEMCO_NM"].Value.ToString(); string pDb_Nm = AppInfo.SsDbNm; string sortNo_val = "10"; if (dataGridView2.Rows[0].Cells["dgv2_SORT_NO"].Value != null) { sortNo_val = dataGridView2.Rows[0].Cells["dgv2_SORT_NO"].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 usingFlag_val = "1"; string pInputId = AppInfo.SsLabNo; M_WsMember.WsMember wSvc = null; string reCode = ""; string reMsg = ""; string reData = ""; try { wSvc = new M_WsMember.WsMember(); wSvc.Url = "http://" + AppInfo.SsWsvcServer2 + "/WebSvc/Sys/MemberSite/WsMember.svc"; wSvc.Timeout = 1000; int reCnt = 0; reCode = wSvc.exMember(AppInfo.SsMemcoCd, pMemcoNm, out reMsg, out reData); if (reCode == "Y" && reData != "0") { //중복데이터 체크 후 USING FLAG 1로 업데이트 //본인이 소속된 SiteCd reCode = wSvc.mMember(AppInfo.SsSiteCd, pMemcoNm, usingFlag_val, sortNo_val, memo_val, out reMsg, out reData); MessageBox.Show(wRM.GetString("msgDuplicated") + " " + wRM.GetString("msgChangeUsingFlag")); } else { //중복 없으면 인서트 reCode = ""; reCode = wSvc.aMember(pMemcoNm, AppInfo.SsDbNm, usingFlag_val, sortNo_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") + " : " + reCnt.ToString()); } else { MessageBox.Show(wRM.GetString("wSave") + " " + wRM.GetString("wFail")); } } SetDataBind_gridView1(AppInfo.SsMemcoCd); SetDataBind_treeView1(); } catch (Exception ex) { logs.SaveLog("[error] (page)::FrmMember.cs (Function)::dataGridView2_CellClick (Detail):: " + "\r\n" + ex.ToString(), "Error"); } finally { if (wSvc != null) { wSvc.Dispose(); } } } } }