public CorporationPopupForm(string employeeName, bool IsDataExists, CorporationVO corporation) { InitializeComponent(); this.IsDataExists = IsDataExists; this.employeeName = employeeName; if (IsDataExists == true) { this.corporationVO = corporation; } }
private void dgvCorporationlist_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { CorporationVO corporation = new CorporationVO(); corporation.corporation_id = Convert.ToInt32(dgvCorporationlist.SelectedRows[0].Cells[1].Value); //코드 corporation.corporation_name = dgvCorporationlist.SelectedRows[0].Cells[2].Value.ToString(); // 이름 corporation.corporation_seq = Convert.ToInt32(dgvCorporationlist.SelectedRows[0].Cells[3].Value); //순번 corporation.corporation_note1 = dgvCorporationlist.SelectedRows[0].Cells[4].Value.ToString(); corporation.corporation_note2 = dgvCorporationlist.SelectedRows[0].Cells[5].Value.ToString(); corporation.corporation_use = dgvCorporationlist.SelectedRows[0].Cells[6].Value.ToString(); CorporationPopupForm cp = new CorporationPopupForm(emp.Employee_name, true, corporation); if (cp.ShowDialog() == DialogResult.OK) { dgvCorporationlist.Columns.Clear(); CorporationForm_Load(null, null); } }
private void CorporationSave(string UseCheck, string Status, int corporation_id) { if (MessageBox.Show($"법인을 {Status}하시겠습니까?", "", MessageBoxButtons.YesNo) == DialogResult.Yes) { CorporationVO corporation = new CorporationVO { corporation_id = corporation_id, corporation_name = txtName.Text, corporation_seq = Convert.ToInt32((nudCorporation_seq.Value.ToString().Length > 0) ? nudCorporation_seq.Value.ToString() : "0"), corporation_use = UseCheck, first_regist_employee = employeeName, final_regist_employee = employeeName, corporation_note1 = txtNote1.Text, corporation_note2 = txtNote2.Text }; if (service.SaveCorporation(corporation)) { this.DialogResult = DialogResult.OK; this.Close(); } } }
public bool SaveCorporation(CorporationVO corporationvo) { try { using (SqlConnection conn = new SqlConnection(this.ConnectionString)) { conn.Open(); string sql = "SP_SAVE_CORPORATION"; using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@P_corporation_id", corporationvo.corporation_id); cmd.Parameters.AddWithValue("@P_corporation_name", corporationvo.corporation_name); cmd.Parameters.AddWithValue("@P_corporation_note1", corporationvo.corporation_note1); cmd.Parameters.AddWithValue("@P_corporation_note2", corporationvo.corporation_note2); cmd.Parameters.AddWithValue("@P_corporation_seq", corporationvo.corporation_seq); cmd.Parameters.AddWithValue("@P_corporation_use", corporationvo.corporation_use); cmd.Parameters.AddWithValue("@P_first_regist_employee", corporationvo.first_regist_employee); cmd.Parameters.AddWithValue("@P_final_regist_employee", corporationvo.final_regist_employee); cmd.ExecuteNonQuery(); } return(true); } } catch (Exception err) { return(false); throw err; } }
public bool SaveCorporation(CorporationVO corporationvo) { return(dac.SaveCorporation(corporationvo)); }