public void gird_data_binding()
{
foreach (DataGridViewRow dtRow in dataGridView1.Rows)
{
String LIC_CODE = dtRow.Cells["자격면허코드"].FormattedValue.ToString();
String LIC_GRADE = dtRow.Cells["급수"].FormattedValue.ToString();
String LIC_ACQDATE = dtRow.Cells["취득일"].FormattedValue.ToString();
String LIC_ORGAN = dtRow.Cells["발급기관"].FormattedValue.ToString();
String check = dtRow.Cells["정보상태"].FormattedValue.ToString();
if (check.Equals("Insert"))
{
thrm_add(insaSide.select_empno, LIC_CODE, LIC_GRADE, common.ParseString(LIC_ACQDATE, "yyyyMMdd"), LIC_ORGAN);
}
else if (check.Equals("Update"))
{
thrm_update(insaSide.select_empno, LIC_CODE, LIC_GRADE, common.ParseString(LIC_ACQDATE, "yyyyMMdd"), LIC_ORGAN);
}
}
if (getDeleteREL.Count != 0)
{
foreach (string getDeleteREL in getDeleteREL)
{
thrm_delete(insaSide.select_empno, getDeleteREL);
}
}
}
public void gird_data_binding()
{
foreach (DataGridViewRow dtRow in dataGridView1.Rows)
{
String AWARD_DATE = dtRow.Cells["상벌일자"].FormattedValue.ToString();
String AWARD_TYPE = dtRow.Cells["상벌구분"].FormattedValue.ToString();
String AWARD_NO = dtRow.Cells["상벌번호"].FormattedValue.ToString();
String AWARD_KIND = dtRow.Cells["상벌종별"].FormattedValue.ToString();
String AWARD_ORGAN = dtRow.Cells["시행처"].FormattedValue.ToString();
String AWARD_CONTENT = dtRow.Cells["상벌내용"].FormattedValue.ToString();
String AWARD_INOUT = dtRow.Cells["내외구분"].FormattedValue.ToString();
String AWARD_POS = dtRow.Cells["직급"].FormattedValue.ToString();
String AWARD_DEPT = dtRow.Cells["소속"].FormattedValue.ToString();
String check = dtRow.Cells["정보상태"].FormattedValue.ToString();
if (check.Equals("Insert"))
{
thrm_add(insaSide.select_empno, common.ParseString(AWARD_DATE, "yyyyMMdd"), AWARD_TYPE, AWARD_NO, AWARD_KIND, AWARD_ORGAN, AWARD_CONTENT, AWARD_INOUT, AWARD_POS, AWARD_DEPT);
}
else if (check.Equals("Update"))
{
thrm_update(insaSide.select_empno, common.ParseString(AWARD_DATE, "yyyyMMdd"), AWARD_TYPE, AWARD_NO, AWARD_KIND, AWARD_ORGAN, AWARD_CONTENT, AWARD_INOUT, AWARD_POS, AWARD_DEPT);
}
}
if (getDeleteREL.Count != 0)
{
foreach (string getDeleteREL in getDeleteREL)
{
thrm_delete(insaSide.select_empno, getDeleteREL);
}
}
}
public void gird_data_binding()
{
foreach (DataGridViewRow dtRow in dataGridView1.Rows)
{
String EDU_LOE = dtRow.Cells["학력구분"].FormattedValue.ToString();
String EDU_ENTDATE = dtRow.Cells["입학일자"].FormattedValue.ToString();
String EDU_GRADATE = dtRow.Cells["졸업일자"].FormattedValue.ToString();
String EDU_SCHNM = dtRow.Cells["학교명"].FormattedValue.ToString();
String EDU_DEPT = dtRow.Cells["학과"].FormattedValue.ToString();
String EDU_DEGREE = dtRow.Cells["학위"].FormattedValue.ToString();
String EDU_GRADE = dtRow.Cells["성적"].FormattedValue.ToString();
String EDU_GRA = dtRow.Cells["졸업구분"].FormattedValue.ToString();
String EDU_LAST = dtRow.Cells["최종여부"].FormattedValue.ToString();
String check = dtRow.Cells["정보상태"].FormattedValue.ToString();
if (check.Equals("Insert"))
{
thrm_add(insaSide.select_empno, EDU_LOE, common.ParseString(EDU_ENTDATE, "yyyyMMdd"), common.ParseString(EDU_GRADATE, "yyyyMMdd"), EDU_SCHNM, EDU_DEPT, EDU_DEGREE, EDU_GRADE, EDU_GRA, EDU_LAST);
}
else if (check.Equals("Update"))
{
thrm_update(insaSide.select_empno, EDU_LOE, common.ParseString(EDU_ENTDATE, "yyyyMMdd"), common.ParseString(EDU_GRADATE, "yyyyMMdd"), EDU_SCHNM, EDU_DEPT, EDU_DEGREE, EDU_GRADE, EDU_GRA, EDU_LAST);
}
}
if (getDeleteREL.Count != 0)
{
foreach (string getDeleteREL in getDeleteREL)
{
thrm_delete(insaSide.select_empno, getDeleteREL);
}
}
}
public void gird_data_binding()
{
foreach (DataGridViewRow dtRow in dataGridView1.Rows)
{
String DEPT_CODE = dtRow.Cells["코드"].FormattedValue.ToString();
String DEPT_NAME = dtRow.Cells["이름"].FormattedValue.ToString();
String DEPT_SEQ = dtRow.Cells["SEQ"].FormattedValue.ToString();
String DEPT_SDATE = dtRow.Cells["생성날짜"].FormattedValue.ToString();
String DEPT_EDATE = dtRow.Cells["종료날짜"].FormattedValue.ToString();
String check = dtRow.Cells["정보상태"].FormattedValue.ToString();
if (check.Equals("Insert"))
{
// 데이터타입..여기도 뜸 수정해야함
thrm_add(DEPT_CODE, DEPT_NAME, DEPT_SEQ, DEPT_SDATE, DEPT_EDATE);
}
else if (check.Equals("Update"))
{
thrm_update(DEPT_CODE, DEPT_NAME, DEPT_SEQ, common.ParseString(DEPT_SDATE, "yyyyMMdd"), common.ParseString(DEPT_EDATE, "yyyyMMdd"));
}
}
if (dgv.getDeleteREL.Count != 0)
{
foreach (string getDeleteREL in dgv.getDeleteREL)
{
thrm_delete(getDeleteREL);
}
}
}
public void gird_data_binding()
{
//CD_GRPCD, CD_CODE, CD_SEQ, CD_CODNMS, CD_USE, CD_SDATE, CD_EDATE
foreach (DataGridViewRow dtRow in dataGridView1.Rows)
{
String CDG_GRPCD = dtRow.Cells["코드"].FormattedValue.ToString();
String CD_CODE = dtRow.Cells["코드값"].FormattedValue.ToString();
String CD_SEQ = dtRow.Cells["SEQ"].FormattedValue.ToString();
String CD_CODNMS = dtRow.Cells["코드이름"].FormattedValue.ToString();
String CDG_USE = dtRow.Cells["사용여부"].FormattedValue.ToString();
String CD_SDATE = dtRow.Cells["생성날짜"].FormattedValue.ToString();
String CD_EDATE = dtRow.Cells["종료날짜"].FormattedValue.ToString();
String check = dtRow.Cells["정보상태"].FormattedValue.ToString();
if (check.Equals("Insert"))
{
thrm_add(CDG_GRPCD, CD_CODE, CD_SEQ, CD_CODNMS, dgv.CheckboxToString(CDG_USE), CD_SDATE, CD_EDATE);
}
else if (check.Equals("Update"))
{
thrm_update(CDG_GRPCD, CD_CODE, CD_SEQ, CD_CODNMS, dgv.CheckboxToString(CDG_USE), common.ParseString(CD_SDATE, "yyyyMMdd"), common.ParseString(CD_EDATE, "yyyyMMdd"));
}
}
if (dgv.getDeleteREL.Count != 0)
{
foreach (string getDeleteREL in dgv.getDeleteREL)
{
thrm_delete(combo_code, getDeleteREL);
}
}
}