//insert student's cash information into ST_STUDENT_CASH table
public int insertStuCash(DataSet.DsPSMS.ST_STUDENT_CASHRow dr)
{
if (dr == null)
{
return(-1);
}
Open();
query = "INSERT INTO ST_STUDENT_CASH (EDU_YEAR, STUDENT_ID, CASH_TITLE, CASH_DATE, ACCOUNT_NO, AMOUNT, CRT_DT_TM, CRT_USER_ID, UPD_DT_TM, UPD_USER_ID, DEL_FLG)";
data += " '" + dr.EDU_YEAR + "'";
//data += ", '" + dr.CASH_ID + "'";
data += ", '" + dr.STUDENT_ID + "'";
data += ", '" + dr.CASH_TITLE + "'";
data += ", '" + dr.CASH_DATE + "'";
data += ", '" + dr.ACCOUNT_NO + "'";
data += ", '" + dr.AMOUNT + "'";
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);
}
//select Cash information from ST_STUDENT_CASH table
public DataSet.DsPSMS.ST_STUDENT_CASHDataTable selectCashDataByIdYear(DataSet.DsPSMS.ST_STUDENT_CASHRow dr)
{
DsPSMS.ST_STUDENT_CASHDataTable stuCashDt = new DsPSMS.ST_STUDENT_CASHDataTable();
Open();
query = "SELECT* FROM ST_STUDENT_CASH WHERE STUDENT_ID='" + dr.STUDENT_ID + "' AND EDU_YEAR='" + dr.EDU_YEAR + "'";
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(stuCashDt);
Close();
return(stuCashDt);
}
public DataSet.DsPSMS.ST_STUDENT_CASHDataTable getCashData(DataSet.DsPSMS.ST_STUDENT_CASHRow dr, out string msg)
{
DsPSMS.ST_STUDENT_CASHDataTable stuCashDt = new DsPSMS.ST_STUDENT_CASHDataTable();
try
{
Open();
stuCashDt = stuCashDb.selectCashDataByIdYear(dr);
msg = "Have data";
}
catch
{
msg = "error occurs when selecting cash data";
return(null);
}
finally
{
Close();
}
return(stuCashDt);
}