public static int insert(CA_LAM_VIEC clv)
{
string query = "insert into CA_LAM_VIEC values( " + clv.GIO
+ " , '" + clv.BAT_DAU
+ "' , '" + clv.KET_THUC
+ "' ) ";
return(Connect.sendQuery(query));
}
public static int update(CA_LAM_VIEC clv)
{
string query = "update CA_LAM_VIEC set BAT_DAU = '" + clv.BAT_DAU
+ "' , KET_THUC = '" + clv.KET_THUC
+ "' , GIO = " + clv.GIO
+ " where CA = " + clv.CA;
return(Connect.sendQuery(query));
}
public static List <CA_LAM_VIEC> select(string cond)
{
string query = "select * from CA_LAM_VIEC " + cond + " ";
SqlDataReader reader = Connect.select(query);
List <CA_LAM_VIEC> clv = new List <CA_LAM_VIEC>();
while (reader.Read())
{
CA_LAM_VIEC tmp = new CA_LAM_VIEC();
tmp.CA = reader.GetInt32(0);
tmp.GIO = reader.GetInt32(1);
tmp.BAT_DAU = reader.GetTimeSpan(2);
tmp.KET_THUC = reader.GetTimeSpan(3);
clv.Add(tmp);
}
return(clv);
}