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));
}
