//insert expanse info into ST_EXP_DETAIL table public int insertExpanseDet(DataSet.DsPSMS.ST_EXP_DETAILRow dr) { if (dr == null) { return(-1); } Open(); query = "INSERT INTO ST_EXP_DETAIL (EXP_ID, EXP_SUB_TITLE, AMOUNT, CRT_DT_TM, CRT_USER_ID, UPD_DT_TM, UPD_USER_ID, DEL_FLG)"; data += dr.EXP_ID; data += ", '" + dr.EXP_SUB_TITLE + "'"; data += ", '" + dr.AMOUNT + "'"; data += ", '" + DateTime.Now + "'"; 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); }
// delete the cash information from ST_EXP_DETAIL tabel public void deleteExpDet(DataSet.DsPSMS.ST_EXP_DETAILRow dr) { DsPSMS.ST_EXP_DETAILDataTable expDetDt = new DsPSMS.ST_EXP_DETAILDataTable(); Open(); string query = ""; query = "UPDATE ST_EXP_DETAIL 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(); }
// update the cash information from ST_EXP_DETAIL tabel public int updateExpanseDet(DataSet.DsPSMS.ST_EXP_DETAILRow dr) { if (dr == null) { return(-1); } Open(); query = "UPDATE ST_EXP_DETAIL SET "; data += " EXP_ID = " + dr.EXP_ID; data += ", EXP_SUB_TITLE = '" + dr.EXP_SUB_TITLE + "'"; data += ", AMOUNT = '" + dr.AMOUNT + "'"; 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 CRT_DT_TM = '" + dr.CRT_DT_TM + "' AND DEL_FLG = " + 0; SqlCommand cmd = new SqlCommand(query, conn); result = cmd.ExecuteNonQuery(); Close(); return(result); }