//insert expanse info into ST_EXP_HED table
public int insertExpanseHed(DataSet.DsPSMS.ST_EXP_HEDRow dr)
{
if (dr == null)
{
return(-1);
}
Open();
query = "INSERT INTO ST_EXP_HED (EDU_YEAR, EXP_TITLE, EXP_DATE, REMARK, CRT_DT_TM, CRT_USER_ID, UPD_DT_TM, UPD_USER_ID, DEL_FLG)";
data += " '" + dr.EDU_YEAR + "'";
// data += ", '" + dr.EXP_ID + "'";
data += ", '" + dr.EXP_TITLE + "'";
data += ", '" + dr.EXP_DATE + "'";
data += ", '" + dr.REMARK + "'";
data += ", '" + dr.CRT_DT_TM + "'";
data += ", '" + dr.CRT_USER_ID + "'";
data += ", '" + dr.UPD_DT_TM + "'";
data += ", '" + dr.UPD_USER_ID + "'";
data += ", " + 0;
query += " VALUES (" + data + ");";
SqlCommand cmd = new SqlCommand(query, conn);
result = cmd.ExecuteNonQuery();
Close();
return(result);
}
// update the cash information from ST_EXP_HED table
public int updateExpanseHed(DataSet.DsPSMS.ST_EXP_HEDRow dr)
{
if (dr == null)
{
return(-1);
}
Open();
query = "UPDATE ST_EXP_HED SET ";
data += " EDU_YEAR = '" + dr["EDU_YEAR"] + "'";
//data += ", EXP_ID = '" + dr["EXP_ID"] + "'";
data += ", EXP_TITLE = '" + dr["EXP_TITLE"] + "'";
data += ", EXP_DATE = '" + dr["EXP_DATE"] + "'";
data += ", REMARK = '" + dr["REMARK"] + "'";
//data += ", CRT_DT_TM = '" + dr["CRT_DT_TM"] + "'";
//data += ", CRT_USER_ID = '" + dr["CRT_USER_ID"] + "'";
data += ", UPD_DT_TM = '" + dr["UPD_DT_TM"] + "'";
data += ", UPD_USER_ID = '" + dr["CRT_USER_ID"] + "'";
query += data + " WHERE EXP_ID =" + dr["EXP_ID"] + " AND DEL_FLG = " + 0;
SqlCommand cmd = new SqlCommand(query, conn);
result = cmd.ExecuteNonQuery();
Close();
return(result);
}
// delete the cash information from ST_EXP_HED tabel
public void deleteExpHed(DataSet.DsPSMS.ST_EXP_HEDRow dr)
{
Open();
string query = "";
query = "UPDATE ST_EXP_HED SET DEL_FLG =" + 1 + " WHERE EXP_ID = " + dr.EXP_ID + " AND CRT_DT_TM='" + dr.CRT_DT_TM + "'";
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
Close();
}
