private void Save(object sender, EventArgs e) { string MENU_ID = ""; foreach (DataRow row in dtUserProgram.Rows) { MENU_ID += "," + row["MENU_ID"].ToString(); } int Row = gd_User.SelectedCells[0].RowIndex; ClearSearchData(); SetSearchData("MENU_ID", MENU_ID.Length > 0 ? MENU_ID.Substring(1) : MENU_ID); SetSearchData("USER_ID", gd_User.SelectedRows[0].Cells["USER_ID"].Value.ToString()); SetServiceId("SetPgmList"); try { DTOFactory.Transaction(new AdminDTO()); DataSet ds = DTOFactory.GetDataSet();; ViewMessage.Info("메뉴 저장이 완료 되었습니다."); GetUserProgram(gd_User.SelectedRows[0].Index); } catch (Exception ex) { ViewMessage.Error(ex.Message); } }
private void btnSave_Click(object sender, EventArgs e) { ClearSearchData(); SetSearchData("DOC_TYP_CD", DOC_TYP_CD); SetSearchData("CRT_USER_ID", DTOFactory.UserId); if ("15".Equals(DOC_TYP_CD) || "16".Equals(DOC_TYP_CD)) { SetSearchData("START_TM", dtFrom.Value.ToString("yyyy-MM-dd") + " " + dtFromTime.Value.ToString("HH")); SetSearchData("END_TM", dtTo.Value.ToString("yyyy-MM-dd") + " " + dtToTime.Value.ToString("HH")); } else { SetSearchData("START_TM", dtFrom.Value.ToString("yyyy-MM-dd")); SetSearchData("END_TM", dtTo.Value.ToString("yyyy-MM-dd")); } SetSearchData("DOC_DESC", txtDocDesc.Text); SetServiceId("SetDocList"); try { DTOFactory.Transaction(new DocDTO()); DialogResult = DialogResult.OK; ViewMessage.Info("문서 등록이 완료 되었습니다."); Close(); } catch (Exception ex) { ViewMessage.Error(ex.Message); } }
private void GetCheckResult(object sender, EventArgs e) { ClearSearchData(); SetSearchData("SUBJECT", txtSubject.Text); SetServiceId("GetBusiness"); DTOFactory.SetDTO(_dtSearch); DTOFactory.Transaction(new ReportDTO()); try { DataTable dt = DTOFactory.GetDataTable(); string LINK_CODE = dt.Rows[0]["LINK_CODE"].ToString(); SetSearchData("LINK_CODE", LINK_CODE); foreach (DataRow row in _dtFile.Rows) { new FileSender(LINK_CODE, row["DIR"].ToString()); } } catch (Exception ex) { ViewMessage.Error(ex.Message); } SetServiceId("InsertBusinessDocument"); DTOFactory.Transaction(new ReportDTO()); ViewMessage.Info("사업 등록을 완료 하였습니다."); }
private void CompCheck(object sender, EventArgs e) { ClearSearchData(); SetSearchData("COMP_NAME", txtCompName); SetSearchData("COMP_TYPE", "G"); SetServiceId("GetCompInfo"); try { DTOFactory.Transaction(new MemberDTO()); DataTable dt = DTOFactory.GetDataTable("ds_comp"); if (dt.Rows.Count > 0) { ViewMessage.Info("이미 등록된 기관명 입니다."); } else { ViewMessage.Info("등록이 가능한 기관명 입니다."); btnInsert.Enabled = true; } } catch (Exception ex) { ViewMessage.Error(ex.Message); } }
private void Save(object sender, EventArgs e) { if ("".Equals(ACC_CD)) { FileSender file = new FileSender("", txtBankImage.Text); Link = file.GetLinkCode(); file.Close(); } ClearSearchData(); SetSearchData("ACC_CD", ACC_CD); SetSearchData("ACC_TYPE", cboType.ValueList); SetSearchData("OUT_BANK_NM", cboBank.ValueList); SetSearchData("OUT_BANK_NO", txtBankCode.Text); SetSearchData("USER_ID", cboUser.ValueList); SetSearchData("ACCOUNT_DESC", txtBankDesc.Text); SetSearchData("LINK_CODE", Link); SetSearchData("UPT_USER_ID", DTOFactory.UserId); SetServiceId("SetBankAccountList"); try { DTOFactory.Transaction(new AccountDTO()); DialogResult = DialogResult.OK; ViewMessage.Info("등록이 완료 되었습니다."); Close(); } catch (Exception ex) { ViewMessage.Error(ex.Message); } }
private void AddNewDocument(object sender, EventArgs e) { string link_code = gd_List.GetSelectString("LINK_CD"); OpenFileDialog frm = new OpenFileDialog(); if (frm.ShowDialog() == DialogResult.OK) { new FileSender(link_code, frm.FileName); ClearSearchData(); SetSearchData("LINK_CODE", link_code); SetSearchData("GRP_NO", gd_schedule.SelectedCells.Count > 0 ? gd_schedule.Rows[gd_schedule.SelectedCells[0].RowIndex].Cells["SCH_DESC"].Value : "사업 접수"); SetSearchData("CRT_USER_ID", DTOFactory.UserId); SetServiceId("InsertBusinessDocument"); try { DTOFactory.Transaction(new ReportDTO()); ViewMessage.Info("문서 등록이 완료 되었습니다."); gd_Document.DataSource = DTOFactory.GetDataTable(); } catch (Exception ex) { ViewMessage.Error(ex.Message); } } }
private void SetCompInfo(object sender, DataGridViewCellEventArgs e) { DataGridView view = (DataGridView)sender; if (e.RowIndex > -1) { if ("DEL".Equals(view.Columns[e.ColumnIndex].Name)) { if (!"".Equals(_dtComp.Rows[e.RowIndex]["COMP_CD"].ToString())) { if (System.Windows.Forms.MessageBox.Show( _dtComp.Rows[e.RowIndex]["COMP_NM"].ToString() + " 업체 정보를 삭제 하시겠습니까?", "기관 제거" , MessageBoxButtons.YesNo) == DialogResult.Yes) { ClearSearchData(); SetSearchData("COMP_CODE", _dtComp.Rows[e.RowIndex]["COMP_CD"].ToString()); SetServiceId("RemoveComp"); try { DTOFactory.Transaction(new MemberDTO()); _dtComp.Rows.RemoveAt(e.RowIndex); ViewMessage.Info("기관 정보가 삭제 되었습니다."); } catch (Exception ex) { ViewMessage.Error(ex.Message); } } } } } }
private void ItemClick(object sender, DataGridViewCellEventArgs e) { DataGridView view = (DataGridView)sender; if ("관리".Equals(view.Columns[e.ColumnIndex].HeaderText)) { ClearSearchData(); SetSearchData("ITEM_ID", gd_List.SelectedCells[0].Value); SetSearchData("SEQ_NO", _dtItem.Rows[e.RowIndex]["SEQ_NO"].ToString()); SetSearchData("ITEM_CD", _dtItem.Rows[e.RowIndex]["ITEM_CD"]); SetSearchData("ITEM_NM", _dtItem.Rows[e.RowIndex]["ITEM_NM"]); SetServiceId("SetItemList"); try { DTOFactory.Transaction(new AdminDTO()); ViewMessage.Info("저장이 완료 되었습니다."); } catch (Exception ex) { ViewMessage.Error(ex.Message); } } }
public void Confirm(object sender, EventArgs e) { if (rdbConfirm.Checked || rdbReturn.Checked) { if (rdbConfirm.Checked) { CFM = true; } string cfm_YN; string cfm_YN2; if (CFM == true) { cfm_YN = "승인"; cfm_YN2 = "Y"; } else { cfm_YN = "반려"; cfm_YN2 = "N"; } ClearSearchData(); SetSearchData("STAT_CD", cfm_YN2); SetSearchData("DOC_DESC", txtCfm_DESC.Text); SetSearchData("DOC_ID", DOC_ID); SetSearchData("DOC_TYP_CD", DOC_TYP_CD); SetSearchData("USER_ID", "100000"); SetServiceId("SetConfirmItem"); try { DTOFactory.Transaction(new DocDTO()); Mail.Subject = "[문서 검토] " + txtDocType.Text + "(" + DOC_ID + ") - " + txtCrtUser.Text; Mail.To = EMAIL; Mail.IsDirect = true; string strBody = "하기의 사유로 문서가 " + cfm_YN + "되었습니다.<br><hr>"; strBody += txtCfm_DESC.Text.Replace("\r\n", "<br>"); Mail.Send(strBody); DialogResult = DialogResult.OK; ViewMessage.Info("해당 문서가 검토되었습니다."); } catch (Exception ex) { ViewMessage.Error(ex.Message); } } else { ViewMessage.Warning("승인 여부를 선택해주십시오."); } }
private void ScheduleUpdate(object sender, ToolStripItemClickedEventArgs e) { switch (e.ClickedItem.Text) { case "일정 수정": string desc = Microsoft.VisualBasic.Interaction.InputBox("변경할 일정 내용을 입력 하시오.", "일정 수정", gd_list.SelectedRows[0].Cells["SCH_DESC"].Value.ToString()); if (!"".Equals(desc)) { ClearSearchData(); SetSearchData("USER_ID", DTOFactory.UserId); SetSearchData("SCH_TM", gd_list.SelectedRows[0].Cells["SCH_TM"].Value); SetSearchData("WORK_CD", gd_list.SelectedRows[0].Cells["DEL_YN"].Value); SetSearchData("DESC", desc); SetServiceId("UpdateSchedule"); try { DTOFactory.Transaction(new MemberDTO()); ViewMessage.Info("일정 내용을 수정 하였습니다."); SetCalendar(); } catch (Exception ex) { ViewMessage.Error(ex.Message); } } break; case "일정 취소": if (System.Windows.Forms.MessageBox.Show( "해당 일정을 취소 하시겠습니까?\r\n(타인의 일정은 취소 할 수 없습니다.)", "일정 취소" , MessageBoxButtons.YesNo) == DialogResult.Yes) { ClearSearchData(); SetSearchData("USER_ID", DTOFactory.UserId); SetSearchData("SCH_TM", gd_list.SelectedRows[0].Cells["SCH_TM"].Value); SetServiceId("DisableSchedule"); try { DTOFactory.Transaction(new MemberDTO()); ViewMessage.Info("일정을 취소 하였습니다."); SetCalendar(); } catch (Exception ex) { ViewMessage.Error(ex.Message); } } break; } }
private void Save(object sender, EventArgs e) { if (!"".Equals(txtReceipt.Text)) { FileSender file = new FileSender("", txtReceipt.Text); string Link = file.GetLinkCode(); file.Close(); ClearSearchData(); SetSearchData("ACC_DT", calAccDate.Value.ToString("yyyy-MM-dd")); SetSearchData("CASH", txtAccCash.Text.Replace(",", "")); SetSearchData("CASH_DESC", txtAccDesc.Text); SetSearchData("ACCOUNT_DESC", txtAccInfo.Text); SetSearchData("LINK_CODE", Link); SetSearchData("UPT_USER_ID", DTOFactory.UserId); if (rdoBank.Checked) { SetSearchData("ACC_CD", cboBankCode.ValueList); SetSearchData("IN_BANK_NM", txtInBankName.Text); SetSearchData("IN_BANK_NO", txtInBankNo.Text); SetSearchData("IN_NAME", txtInUserName.Text); SetServiceId("SetBankAccountHistory"); } else if (rdoCard.Checked) { SetSearchData("ACC_TYPE", cboType.ValueList); SetSearchData("ACC_CD", cboCard.ValueList); SetSearchData("ACC_NO", txtAccNo.Text); SetSearchData("OUT_COMP_NM", txtOutName.Text); SetSearchData("OUT_COMP_REG_ID", txtOutRegId.Text); SetServiceId("SetCardAccountHistory"); } else { ViewMessage.Error("잘못된 선택 입니다."); } try { DTOFactory.Transaction(new AccountDTO()); DialogResult = DialogResult.OK; ViewMessage.Info("등록이 완료 되었습니다."); Close(); } catch (Exception ex) { ViewMessage.Error(ex.Message); } } else { ViewMessage.Error("첨부 파일이 없습니다."); } }
private void MenuSave(object sender, EventArgs e) { DataRow[] dr = dtMenu.Select("USE_YN <> 'Y'"); if (dr.Length > 0) { string MENU_ID = ""; string MENU_NM = ""; string MENU_LEVEL = ""; string SEQ_NO = ""; string MENU_PARENT = ""; foreach (DataRow row in dr) { MENU_ID += "," + row["MENU_ID"].ToString(); MENU_NM += "," + row["MENU_NM"].ToString(); MENU_LEVEL += "," + row["MENU_LEVEL"].ToString(); SEQ_NO += "," + row["SEQ_NO"].ToString(); MENU_PARENT += "," + row["MENU_PARENT"].ToString(); } ClearSearchData(); SetSearchData("MENU_ID", MENU_ID.Length > 0 ? MENU_ID.Substring(1) : MENU_ID); SetSearchData("MENU_NM", MENU_NM.Length > 0 ? MENU_NM.Substring(1) : MENU_NM); SetSearchData("MENU_LEVEL", MENU_LEVEL.Length > 0 ? MENU_LEVEL.Substring(1) : MENU_LEVEL); SetSearchData("SEQ_NO", SEQ_NO.Length > 0 ? SEQ_NO.Substring(1) : SEQ_NO); SetSearchData("MENU_PARENT", MENU_PARENT.Length > 0 ? MENU_PARENT.Substring(1) : MENU_PARENT); SetServiceId("SetMenuList"); try { DTOFactory.Transaction(new AdminDTO()); DataSet ds = DTOFactory.GetDataSet(); ViewMessage.Info("메뉴 저장이 완료 되었습니다."); menuView.Nodes.Clear(); dtMenu = ds.Tables["ds_menu"]; if (dtMenu.PrimaryKey.Length == 0) { DataColumn[] col = new DataColumn[1]; col[0] = dtMenu.Columns["MENU_ID"]; dtMenu.PrimaryKey = col; } GetMenuItem(dtMenu); dtProgram = ds.Tables["ds_pgm"]; gd_ProgramList.DataSource = dtProgram; } catch (Exception ex) { ViewMessage.Error(ex.Message); } } }
private void ProgramSave(object sender, EventArgs e) { if (dtMenuProgram.Rows.Count > 0) { string MENU_ID = ""; string MENU_NM = ""; string SEQ_NO = ""; string USE_YN = ""; foreach (DataRow row in dtMenuProgram.Rows) { MENU_ID += "," + row["MENU_ID"].ToString(); MENU_NM += "," + row["MENU_NM"].ToString(); SEQ_NO += "," + row["SEQ_NO"].ToString(); USE_YN += "," + row["USE_YN"].ToString(); } string parent = menuView.SelectedNode.Name; DataRow menu = dtMenu.Rows.Find(parent); ClearSearchData(); SetSearchData("MENU_ID", MENU_ID.Length > 0 ? MENU_ID.Substring(1) : MENU_ID); SetSearchData("MENU_NM", MENU_NM.Length > 0 ? MENU_NM.Substring(1) : MENU_NM); SetSearchData("MENU_LEVEL", int.Parse(menu["MENU_LEVEL"].ToString()) + 1); SetSearchData("SEQ_NO", SEQ_NO.Length > 0 ? SEQ_NO.Substring(1) : SEQ_NO); SetSearchData("MENU_PARENT", parent); SetSearchData("USE_YN", USE_YN.Length > 0 ? USE_YN.Substring(1) : USE_YN); SetServiceId("SetPgmList"); try { DTOFactory.Transaction(new AdminDTO()); DataSet ds = DTOFactory.GetDataSet(); ViewMessage.Info("메뉴 저장이 완료 되었습니다."); menuView.Nodes.Clear(); dtMenu = ds.Tables["ds_menu"]; if (dtMenu.PrimaryKey.Length == 0) { DataColumn[] col = new DataColumn[1]; col[0] = dtMenu.Columns["MENU_ID"]; dtMenu.PrimaryKey = col; } GetMenuItem(dtMenu); dtProgram = ds.Tables["ds_pgm"]; gd_ProgramList.DataSource = dtProgram; } catch (Exception ex) { ViewMessage.Error(ex.Message); } } }
private void Save(object sender, EventArgs e) { DataTable dt_input = new DataTable(); dt_input.Columns.Add("PGM_ID"); dt_input.Columns.Add("PGM_NM"); dt_input.Columns.Add("PGM_DLL"); dt_input.Columns.Add("PGM_CLASS"); dt_input.Columns.Add("PGM_SVR_DLL"); dt_input.Columns.Add("PGM_SVR_CLASS"); foreach (DataGridViewRow row in gd_Program.Rows) { if (row.DefaultCellStyle.BackColor == Color.Yellow) { DataRow dr = dt_input.NewRow(); dr["PGM_ID"] = row.Cells["PGM_ID"].Value; dr["PGM_NM"] = row.Cells["PGM_NM"].Value; dr["PGM_DLL"] = row.Cells["PGM_DLL"].Value; dr["PGM_CLASS"] = row.Cells["PGM_CLASS"].Value; dr["PGM_SVR_DLL"] = row.Cells["PGM_SVR_DLL"].Value; dr["PGM_SVR_CLASS"] = row.Cells["PGM_SVR_CLASS"].Value; dt_input.Rows.Add(dr); } } ClearSearchData(); SetServiceId("SetProgramList"); DTOFactory.SetDTOTable("ds_list", dt_input); try { DTOFactory.Transaction(new AdminDTO()); DataSet ds = DTOFactory.GetDataSet(); dtProgram = ds.Tables["ds_program"]; gd_Program.DataSource = dtProgram; gd_Program.SetGridColumn(ds.Tables["ds_program_column"]); foreach (DataGridViewColumn col in gd_Program.Columns) { col.SortMode = DataGridViewColumnSortMode.NotSortable; } ViewMessage.Info("저장이 완료 되었습니다."); } catch (Exception ex) { ViewMessage.Error(ex.Message); } }
private void BtnSave_Click(object sender, EventArgs e) { string strModelId = ""; string strQty = ""; string strQtyCd = ""; string strUnitCost = ""; string strDeliDt = ""; string strCmt = ""; string strDoc = ""; string strVendor = ""; string strOrderComp = ""; foreach (DataRow gr in dt_Order.Rows) { if (!"".Equals(gr["VENDOR_CD"].ToString())) { strDoc += "," + gr["ORDER_ID"].ToString(); strVendor += "," + gr["VENDOR_CD"].ToString(); strOrderComp += "," + gr["ORDER_COMP_CD"].ToString(); strModelId += "," + gr["MODEL_ID"].ToString(); strQty += "," + gr["QTY"].ToString(); strQtyCd += "," + gr["QTY_CD"].ToString(); strUnitCost += "," + gr["UNIT_COST"].ToString(); string date = gr["DELI_DT"].ToString(); if (!"".Equals(date) && date.Length == 8) { date = date.Substring(0, 4) + "-" + date.Substring(4, 2) + "-" + date.Substring(6, 2); } strDeliDt += "," + date; strCmt += "," + gr["CMT_DESC"].ToString(); } } ClearSearchData(); SetSearchData("DOC_ID", strDoc.Length > 0 ? strDoc.Substring(1) : strDoc); SetSearchData("ORDER_COMP_CD", strOrderComp.Length > 0 ? strOrderComp.Substring(1) : strOrderComp); SetSearchData("COMP_CD", strVendor.Length > 0 ? strVendor.Substring(1) : strVendor); SetSearchData("MODEL_ID", strModelId.Length > 0 ? strModelId.Substring(1) : strModelId); SetSearchData("QTY", strQty.Length > 0 ? strQty.Substring(1) : strQty); SetSearchData("QTY_CD", strQtyCd.Length > 0 ? strQtyCd.Substring(1) : strQtyCd); SetSearchData("UNIT_COST", strUnitCost.Length > 0 ? strUnitCost.Substring(1) : strUnitCost); SetSearchData("DELI_DT", strDeliDt.Length > 0 ? strDeliDt.Substring(1) : strDeliDt); SetSearchData("DESC", strCmt.Length > 0 ? strCmt.Substring(1) : strCmt); SetSearchData("USER_ID", DTOFactory.UserId); SetServiceId("SetOrderRequest"); DTOFactory.Transaction(new ProductDTO()); ViewMessage.Info("발주요청서 저장 처리가 완료 되었습니다."); }
private void InsertData(object sender, EventArgs e) { if (ScheduleFix) { if ("".Equals(cboUser.ValueList)) { ViewMessage.Info("담당자와 내용을 선택해 주시기 바랍니다."); } else { ClearSearchData(); SetSearchData("DOC_ID", DOC_ID); SetSearchData("ACCEPT_TM", DATE.ToString("yyyy-MM-dd HH:mm:ss")); SetSearchData("PROC_TM", dtCreateTime.Value.ToString("yyyy-MM-dd HH:mm:ss")); SetSearchData("USER_ID_LST", cboUser.ValueList); SetSearchData("CRT_USER_ID", DTOFactory.UserId); SetServiceId("SetScheduleManager"); DTOFactory.Transaction(new ReportDTO()); ViewMessage.Info("일정 수정을 완료 하였습니다."); DialogResult = DialogResult.OK; Close(); } } else { if ("".Equals(cboUser.ValueList) || "".Equals(cboPlan.ValueList)) { ViewMessage.Info("담당자와 내용을 선택해 주시기 바랍니다."); } else { ClearSearchData(); SetSearchData("DOC_ID", DOC_ID); SetSearchData("ACCEPT_TM", dtCreateTime.Value.ToString("yyyy-MM-dd HH:mm:ss")); SetSearchData("USER_ID_LST", cboUser.ValueList); SetSearchData("DESC", cboPlan.ValueList); SetSearchData("CRT_USER_ID", DTOFactory.UserId); SetServiceId("SetScheduleManager"); DTOFactory.Transaction(new ReportDTO()); ViewMessage.Info("일정 등록을 완료 하였습니다."); DialogResult = DialogResult.OK; Close(); } } }
private void ModelDelete(object sender, EventArgs e) { if (gd_List.SelectedRows.Count > 0) { DataRow row = _dtModel.Rows[gd_List.SelectedRows[0].Index]; if (System.Windows.Forms.MessageBox.Show( row["CST_MODEL_ID"].ToString() + " 제품의 이력을 일괄 삭제 하겠습니까?", "모델 삭제" , MessageBoxButtons.YesNo) == DialogResult.Yes) { ClearSearchData(); SetSearchData("COMP_CD", row["COMP_CD"]); SetSearchData("MODEL_CD", row["CST_MODEL_ID"]); SetServiceId("DelModelInfo"); try { DTOFactory.Transaction(new MachineDTO()); ViewMessage.Info("삭제가 완료 되었습니다."); _dtModel.Rows.RemoveAt(gd_List.SelectedRows[0].Index); txtModelId.Text = ""; txtModelDesc.Text = ""; txtGrp1.Text = ""; txtGrp2.Text = ""; txtItm.Text = ""; txtSpec.Text = ""; txtSpecDesc.Text = ""; txtEstNo.Text = ""; txtEstSubject.Text = ""; txtEstUnitCost.Text = ""; txtEstDesc.Text = ""; cboCompCode.SetItemChecked(cboComp.ValueList); cbockModel.SetItemChecked(""); cboQtyType.SetItemChecked(""); if (_dtModel.Rows.Count > 0) { GetModelInfo(0); } } catch (Exception ex) { ViewMessage.Error(ex.Message); } } } }
private void AddVerRow(object sender, EventArgs e) { if (gd_Model.Rows.Count > 0) { DataRow dr = _dtVersion.NewRow(); dr["MODEL_ID"] = gd_Model.SelectedRows[0].Cells["MODEL_ID"].Value; dr["SEQ_NO"] = 0; _dtVersion.Rows.Add(dr); } else { ViewMessage.Info("해당 프로젝트에 등록된 모델이 존재하지 않습니다."); } }
private void Confirm(object sender, EventArgs e) { string Link_CD = ""; if (!"".Equals(File_NM)) { FileSender snd = new FileSender(Link_CD, File_NM); Link_CD = snd.GetLinkCode(); } ClearSearchData(); SetSearchData("SUBJECT", txtActSubject.Text); SetSearchData("TYPE1", cboActType1.ValueList); SetSearchData("TYPE2", cboActType2.ValueList); SetSearchData("STATUS", "O"); SetSearchData("ACT_USER_ID", cboActMember.ValueList); SetSearchData("CFM_USER_ID", cboActConfirm.ValueList); SetSearchData("USER_ID", DTOFactory.UserId); SetSearchData("TGT_TM", dtActTarget.Value.ToString("yyyy-MM-dd")); SetSearchData("END_TM", ""); SetSearchData("LINK_CD", Link_CD); SetSearchData("DESC", txtMemo.Text); SetServiceId("CreateActionList"); try { DTOFactory.Transaction(new MemberDTO()); if (chkMail.Checked) { Mail.Subject = "[업무 협조]" + txtActSubject.Text; Mail.To = DTOFactory.GetDataTable().Rows[0]["EMAIL"].ToString(); Mail.IsDirect = true; string strBody = "아래와 같이 업무 협조 요청을 드립니다.<br><hr>"; strBody += txtMemo.Text.Replace("\r\n", "<br>"); Mail.Send(strBody); } DialogResult = DialogResult.OK; ViewMessage.Info("등록이 완료 되었습니다."); Close(); } catch (Exception ex) { ViewMessage.Error(ex.Message); } }
private void BtnSave_Click(object sender, EventArgs e) { ClearSearchData(); if ("".Equals(cboItem.ValueList)) { ViewMessage.Info("항목을 선택하시기 바랍니다."); } else { bool bNew = true; string chkTime = dtTime.Value.ToString("HH:mm:ss"); foreach (DataRow row in _dtSelSch.Rows) { if (chkTime.Equals(row["SCH_TIME"].ToString().Trim())) { bNew = false; } } if (bNew) { SetSearchData("USER_ID", DTOFactory.UserId); SetSearchData("SCH_TM", dtTime.Value.ToString("yyyy-MM-dd HH:mm:ss")); SetSearchData("PLAN_CD", cboItem.ValueList); SetSearchData("DESC", txtDesc.Text); SetServiceId("SetSchedule"); try { DTOFactory.Transaction(new MemberDTO()); ViewMessage.Info("일정을 등록하였습니다."); pnlSetSchedule.Visible = false; SetCalendar(); } catch (Exception ex) { ViewMessage.Error(ex.Message); } } else { ViewMessage.Warning("동일한 시간에 일정이 등록되어 있습니다."); } } }
private void Card_CellContentClick(object sender, DataGridViewCellEventArgs e) { DataGridView view = (DataGridView)sender; int row = gd_Bank.SelectedCells[0].RowIndex; if ("DEL".Equals(view.Columns[e.ColumnIndex].Name)) { if (System.Windows.Forms.MessageBox.Show( " 카드 정보를 삭제 하시겠습니까?", "카드 제거" , MessageBoxButtons.YesNo) == DialogResult.Yes) { ClearSearchData(); SetSearchData("ACC_CD", view.Rows[e.RowIndex].Cells["ACC_CD"].Value.ToString()); SetSearchData("OUT_BANK)NM", gd_Bank.Rows[row].Cells["BNK_COMP_CD"].Value); SetSearchData("OUT_BANK_NO", gd_Bank.Rows[row].Cells["BNK_NO"].Value); SetSearchData("UPT_USER_ID", DTOFactory.UserId); SetServiceId("DelCardAccountList"); try { DTOFactory.Transaction(new AccountDTO()); ViewMessage.Info("카드 정보를 제거 하였습니다."); _dtCard = DTOFactory.GetDataTable("ds_card"); gd_Card.DataSource = _dtCard; } catch (Exception ex) { ViewMessage.Error(ex.Message); } } } else if ("SAVE".Equals(view.Columns[e.ColumnIndex].Name)) { var frm = new Popup.AccountCardInsertPopup() { ACC_CD = view.Rows[e.RowIndex].Cells["ACC_CD"].Value.ToString(), BANK_ACC_CD = gd_Bank.Rows[row].Cells["ACC_CD"].Value.ToString() }; if (frm.ShowDialog() == DialogResult.OK) { ShowBank(); } } }
private void Bank_CellContentClick(object sender, DataGridViewCellEventArgs e) { DataGridView view = (DataGridView)sender; if ("VIEW".Equals(view.Columns[e.ColumnIndex].Name)) { new FileGet(view.Rows[e.RowIndex].Cells["LINK_CD"].Value.ToString()); } else if ("DEL".Equals(view.Columns[e.ColumnIndex].Name)) { if (System.Windows.Forms.MessageBox.Show( " 통장 정보를 삭제 하시겠습니까?", "통장 제거" , MessageBoxButtons.YesNo) == DialogResult.Yes) { ClearSearchData(); SetSearchData("ACC_CD", view.Rows[e.RowIndex].Cells["ACC_CD"].Value.ToString()); SetSearchData("UPT_USER_ID", DTOFactory.UserId); SetServiceId("DelBankAccountList"); try { DTOFactory.Transaction(new AccountDTO()); ViewMessage.Info("통장 정보를 제거 하였습니다."); _dtBank = DTOFactory.GetDataTable("ds_bank"); gd_Bank.DataSource = _dtBank; } catch (Exception ex) { ViewMessage.Error(ex.Message); } } } else if ("SAVE".Equals(view.Columns[e.ColumnIndex].Name)) { var frm = new Popup.AccountBankInsertPopup() { ACC_CD = view.Rows[e.RowIndex].Cells["ACC_CD"].Value.ToString() }; if (frm.ShowDialog() == DialogResult.OK) { ShowBank(); } } }
private void ModelSave(object sender, EventArgs e) { DataRow row = _dtModel.Rows[gd_List.SelectedRows[0].Index]; ClearSearchData(); SetSearchData("MODEL_ID", txtModelId.Text); SetSearchData("MODEL_CD", txtModelCode.Text); SetSearchData("MODEL_NM", txtModelName.Text); SetSearchData("MMDEL_TYPE", cboType.ValueList); SetSearchData("PRODUCT_TYPE", cboProductType.ValueList); SetSearchData("SPEC_W", "".Equals(txtSpecW.Text) ? 0 : float.Parse(txtSpecW.Text)); SetSearchData("SPEC_D", "".Equals(txtSpecD.Text) ? 0 : float.Parse(txtSpecD.Text)); SetSearchData("SPEC_H", "".Equals(txtSpecH.Text) ? 0 : float.Parse(txtSpecH.Text)); SetSearchData("YENDOR_CD", cboVendor.ValueList); SetSearchData("MATERIAL_CD", cboMaterial.ValueList); SetSearchData("PLAN_CD", row["PLAN_CD"]); SetSearchData("ESTIMATE_CD", row["ESTIMATE_CD"]); SetSearchData("LINK_CODE", row["LINK_CD"]); SetSearchData("PROJECT_ID", cboProject.ValueList); SetSearchData("USER_ID", DTOFactory.UserId); SetServiceId("SetModelInfo"); try { DTOFactory.Transaction(new MachineDTO()); DataTable dt = DTOFactory.GetDataTable(); DataRow row2 = dt.Rows[0]; pnlPlan.Enabled = true; pnlEstimate.Enabled = true; pnlDocument.Enabled = true; foreach (DataColumn col in dt.Columns) { row[col.ColumnName] = row2[col.ColumnName].ToString(); } txtModelId.Text = row2["MODEL_ID"].ToString(); ViewMessage.Info("저장이 완료 되었습니다."); } catch (Exception ex) { ViewMessage.Error(ex.Message); } }
private void SaveCompInfo(object sender, EventArgs e) { ClearSearchData(); SetSearchData("COMP_CODE", gd_List.SelectedRows[0].Cells["COMP_CD"].Value); SetSearchData("COMP_NAME", txtCompName.Text); SetSearchData("COMP_TYPE", "M"); SetSearchData("REG_ID", txtRegId.Text); SetSearchData("USER_NAME", txtName.Text); SetSearchData("GRADE_NM", txtGrade.Text); SetSearchData("ADDR_CODE", txtAddrCode.Text); SetSearchData("ADDR", txtAddr.Text); SetSearchData("TEL_1", txtTel.Text); SetSearchData("FAX", txtFax.Text); SetSearchData("HOMEPAGE", txtHomePage.Text); SetSearchData("EMAIL", txtEmail.Text); SetSearchData("UPT_USER_ID", DTOFactory.UserId); SetServiceId("SetCompInfo"); try { DTOFactory.Transaction(new MemberDTO()); DataSet ds = DTOFactory.GetDataSet(); _dtComp = ds.Tables["ds_comp"]; gd_List.DataSource = _dtComp; _dtUser.Clear(); txtCompName.Text = ""; txtRegId.Text = ""; txtName.Text = ""; txtGrade.Text = ""; txtAddrCode.Text = ""; txtAddr.Text = ""; txtTel.Text = ""; txtFax.Text = ""; txtHomePage.Text = ""; txtEmail.Text = ""; ViewMessage.Info("저장이 완료되었습니다."); } catch (Exception ex) { ViewMessage.Error(ex.Message); } }
private void SetVisitHistoryItem(object sender, EventArgs e) { ClearSearchData(); SetSearchData("CST_COMP_CD", cboComp.ValueList); SetSearchData("CST_USER_ID", cboCstUser.ValueList); SetSearchData("SUBJECT", txtSubject.Text); SetSearchData("FROM_DT", CalStartTm.Value.ToString("yyyy-MM-dd HH:mm:ss")); SetSearchData("TO_DT", CalEndTm.Value.ToString("yyyy-MM-dd HH:mm:ss")); SetSearchData("SITE_NM", txtSite.Text); SetSearchData("PRD_NM", txtProduct.Text); SetSearchData("USER_ID_LST", cbockVisitUser.ValueList); SetSearchData("DESC", txtDesc.Text); SetSearchData("CRT_USER_ID", DTOFactory.UserId); SetServiceId("SetVisitHistory"); try { DTOFactory.Transaction(new ReportDTO()); DataRow row = _dtList.Rows[gd_List.SelectedRows[0].Index]; row["SUBJECT"] = txtSubject.Text; row["SITE_NM"] = txtSite.Text; row["PRD_NM"] = txtProduct.Text; row["CMT_DESC"] = txtDesc.Text; row["CST_USER_ID"] = cboCstUser.ValueList; row["VISIT_USER_ID_LVAL"] = cbockVisitUser.ValueList; row["START_TM"] = CalStartTm.Value.ToString("yyyy-MM-dd HH:mm:ss"); row["END_TM"] = CalEndTm.Value.ToString("yyyy-MM-dd HH:mm:ss"); ViewMessage.Info("저장이 완료 되었습니다."); if (dtTo.Value < CalEndTm.Value) { dtTo.Value = CalEndTm.Value; } GetVisitHistory(btnSearch, null); } catch (Exception ex) { ViewMessage.Error(ex.Message); } }
private void btnSave_Click(object sender, EventArgs e) { ClearSearchData(); SetSearchData("DOC_TYP_CD", DOC_TYP_CD); SetSearchData("CRT_USER_ID", DTOFactory.UserId); SetSearchData("START_TM", dtFrom.Value.ToString("yyyy-MM-dd")); SetSearchData("END_TM", dtTo.Value.ToString("yyyy-MM-dd")); SetSearchData("SUBJECT", txtSite.Text); SetSearchData("USER_ID_LVAL", cbockMember.ValueList); SetSearchData("SITE_NM", txtSubject.Text); SetServiceId("SetDocList"); DataTable _dt = new DataTable(); _dt.Columns.Add("GRP_NM"); _dt.Columns.Add("SUBJECT"); _dt.Columns.Add("DOC_DESC"); for (int i = 0; i < lstLbSch.Count; i++) { DataRow row = _dt.NewRow(); row["GRP_NM"] = lstLbSch[i].Text; row["DOC_DESC"] = lstTxtSch[i].Text; _dt.Rows.Add(row); } DTOFactory.SetDTOTable("ds_list", _dt.Copy()); try { DTOFactory.Transaction(new DocDTO()); DialogResult = DialogResult.OK; ViewMessage.Info("문서 등록이 완료 되었습니다."); Close(); } catch (Exception ex) { ViewMessage.Error(ex.Message); } }
//문서 수정 private void DocumentControl(object sender, DataGridViewCellEventArgs e) { DataGridView view = (DataGridView)sender; if (e.RowIndex > -1) { if ("FILE_DESC".Equals(view.Columns[e.ColumnIndex].Name)) { FileGet get = new FileGet(view.Rows[e.RowIndex].Cells["LINK_DESC"].Value.ToString()); get.Close(); } else if ("CREATE".Equals(view.Columns[e.ColumnIndex].Name)) { OpenFileDialog frm = new OpenFileDialog(); if (frm.ShowDialog() == DialogResult.OK) { string desc = Microsoft.VisualBasic.Interaction.InputBox("File 변경사항을 입력하시오.", "문서 등록"); new FileSender(view.Rows[e.RowIndex].Cells["LINK_CD"].Value.ToString(), frm.FileName + "*" + view.Rows[e.RowIndex].Cells["FILE_DESC"].Value.ToString()); ClearSearchData(); SetSearchData("LINK_CODE", view.Rows[e.RowIndex].Cells["LINK_CD"].Value.ToString()); SetSearchData("CRT_USER_ID", DTOFactory.UserId); SetSearchData("DESC", desc); SetSearchData("SEQ_NO", (float.Parse(view.Rows[e.RowIndex].Cells["REV_NO"].Value.ToString()) + 0.1).ToString()); SetSearchData("GRP_NO", gd_schedule.SelectedCells.Count > 0 ? gd_schedule.Rows[gd_schedule.SelectedCells[0].RowIndex].Cells["SCH_DESC"].Value : "사업 접수"); SetServiceId("InsertBusinessDocument"); try { DTOFactory.Transaction(new ReportDTO()); ViewMessage.Info("문서 등록이 완료 되었습니다."); gd_Document.DataSource = DTOFactory.GetDataTable(); } catch (Exception ex) { ViewMessage.Error(ex.Message); } } } } }
private void Save(object sender, EventArgs e) { ClearSearchData(); if ("".Equals(cboType.ValueList)) { ViewMessage.Info("항목을 선택 해 주시기 바랍니다."); return; } if ("".Equals(cboCard.ValueList)) { ViewMessage.Info("카드사를 선택 해 주시기 바랍니다."); return; } if ("".Equals(txtCardCode.Text)) { ViewMessage.Info("카드 번호를 선택 해 주시기 바랍니다."); return; } SetSearchData("ACC_CD", ACC_CD); SetSearchData("ACC_TYPE", cboType.ValueList); SetSearchData("OUT_BANK_NM", cboBank.ValueList); SetSearchData("CARD_NM", cboCard.ValueList); SetSearchData("CARD_NO", txtCardCode.Text); SetSearchData("USER_ID", cboUser.ValueList); SetSearchData("ACCOUNT_DESC", txtCardDesc.Text); SetSearchData("UPT_USER_ID", DTOFactory.UserId); SetServiceId("SetCardAccountList"); try { DTOFactory.Transaction(new AccountDTO()); DialogResult = DialogResult.OK; ViewMessage.Info("등록이 완료 되었습니다."); Close(); } catch (Exception ex) { ViewMessage.Error(ex.Message); } }
private void AddCompRow(object sender, EventArgs e) { var frm = new Popup.FrmInsertGovComp(); if (frm.ShowDialog() == DialogResult.OK) { DataRow dr = _dtComp.NewRow(); dr["COMP_NM"] = frm.CompName; dr["ADDR_CD"] = frm.AddrCode; dr["ADDR"] = frm.Addr; dr["WEB"] = frm.HomePage; _dtComp.Rows.Add(dr); ClearSearchData(); SetSearchData("COMP_NAME", frm.CompName); SetSearchData("COMP_TYPE", "G"); SetSearchData("ADDR_CODE", frm.AddrCode); SetSearchData("ADDR", frm.Addr); SetSearchData("HOMEPAGE", frm.HomePage); SetSearchData("UPT_USER_ID", DTOFactory.UserId); SetServiceId("SetCompInfo"); try { DTOFactory.Transaction(new MemberDTO()); DataSet ds = DTOFactory.GetDataSet(); ViewMessage.Info("저장이 완료되었습니다."); _dtComp = ds.Tables["ds_comp"]; gd_List.DataSource = _dtComp; _dtUser.Rows.Clear(); } catch (Exception ex) { ViewMessage.Error(ex.Message); } } }
private void AddMemberRow(object sender, EventArgs e) { var frm = new Popup.FrmInsertGovMember(); if (frm.ShowDialog() == DialogResult.OK) { DataRow dr = _dtUser.NewRow(); dr["USER_NM"] = frm.UserName; dr["GRADE_CD"] = frm.Grade; dr["LINE_ID"] = frm.Line; dr["WORK_DESC"] = frm.Work; dr["TEL_1"] = frm.Tel; dr["EMAIL"] = frm.Mail; _dtUser.Rows.Add(dr); ClearSearchData(); SetSearchData("USER_ID", ""); SetSearchData("USER_NAME", frm.UserName); SetSearchData("GRADE_NM", frm.Grade); SetSearchData("COMP_CODE", _dtComp.Rows[gd_List.SelectedCells[0].RowIndex]["COMP_CD"].ToString()); SetSearchData("COMP_TYPE", "G"); SetSearchData("USER_TYPE", "G"); SetSearchData("LINE_ID", frm.Line); SetSearchData("WORK_DESC", frm.Work); SetSearchData("TEL_1", frm.Tel); SetSearchData("EMAIL", frm.Mail); SetSearchData("UPT_USER_ID", DTOFactory.UserId); SetServiceId("SetUserInfo"); try { DTOFactory.Transaction(new MemberDTO()); ViewMessage.Info("등록이 완료 되었습니다."); } catch (Exception ex) { ViewMessage.Error(ex.Message); } } }