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