//insert Equipment Data into ST_EQUIPMENT_DATA table
public int insertEquipData(DsPSMS.ST_EQUIPMENT_DATARow dr)
{
if (dr == null)
{
return(-1);
}
Open();
query = "INSERT INTO ST_EQUIPMENT_DATA (EDU_YEAR, EQUIPMENT_ID, DATE, QUANTITY, TYPE, REMARK, CRT_DT_TM, CRT_USER_ID, UPD_DT_TM, UPD_USER_ID, DEL_FLG)";
data += " '" + dr.EDU_YEAR + "'";
data += ", '" + dr.EQUIPMENT_ID + "'";
data += ", '" + dr.DATE + "'";
data += ", '" + dr.QUANTITY + "'";
data += ", '" + dr.TYPE + "'";
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);
}
public bool SaveEquipmentData(DsPSMS.ST_EQUIPMENT_DATARow dr, out string msg)
{
bool isOk = true;
if (dr == null)
{
msg = "data is empty ";
return(false);
}
try
{
Open();
int result = equipDb.insertEquipData(dr);
msg = "insert complete";
}
catch
{
msg = "error occurs when inserting data Student Cash Information";
return(false);
}
finally
{
Close();
}
return(isOk);
}
public bool removeEquipmentData(DsPSMS.ST_EQUIPMENT_DATARow dr, out string msg)
{
bool isOk = true;
if (dr == null)
{
msg = "data is empty ";
return(false);
}
try
{
Open();
int result = equipDb.deleteEquipData(dr);
msg = "Deleted";
}
catch
{
msg = "error occurs when deleting the Equipment Data";
return(false);
}
finally
{
Close();
}
return(isOk);
}
// delet the Equipment Data of ST_EQUIPMENT_DATA but not delete just update the DEL_FLG
public int deleteEquipData(DsPSMS.ST_EQUIPMENT_DATARow dr)
{
if (dr == null)
{
return(-1);
}
Open();
query = "UPDATE ST_EQUIPMENT_DATA SET DEL_FLG = " + 1 + " WHERE ID =" + dr["ID"];
SqlCommand cmd = new SqlCommand(query, conn);
result = cmd.ExecuteNonQuery();
Close();
return(result);
}
// update the Equipment Data of ST_EQUIPMENT_DATA
public int updateEquipData(DsPSMS.ST_EQUIPMENT_DATARow dr)
{
if (dr == null)
{
return(-1);
}
Open();
query = "UPDATE ST_EQUIPMENT_DATA SET ";
data += " EDU_YEAR = '" + dr.EDU_YEAR + "'";
data += ", EQUIPMENT_ID = '" + dr.EQUIPMENT_ID + "'";
data += ", DATE = '" + dr.DATE + "'";
data += ", QUANTITY = '" + dr.QUANTITY + "'";
data += ", TYPE = '" + dr.TYPE + "'";
data += ", REMARK = '" + dr.REMARK + "'";
data += ", UPD_DT_TM = '" + dr.UPD_DT_TM + "'";
query += data + " WHERE ID =" + dr.ID + "AND DEL_FLG=" + 0;
SqlCommand cmd = new SqlCommand(query, conn);
result = cmd.ExecuteNonQuery();
Close();
return(result);
}
