public static bool UpdateBaoCaoThang(DTO.DTO_BaoCaoThang baoCaoThang)
{
String sqlCommand = String.Format(@"Update BAOCAOTHANG SET TongSoLuongTiecCuoi = {0}, TongDoanhThu = {1} WHERE MaBCT = {2}", baoCaoThang.TongSoLuongTiecCuoi, baoCaoThang.TongDoanhThu, baoCaoThang.MaBCT);
if (DatabaseHelper.ExcuteSql(sqlCommand) > 0)
{
return(true);
}
return(false);
}
public static bool InsertBaoCaoThang(DTO.DTO_BaoCaoThang baoCaoThang)
{
String sqlCommand = String.Format(@"INSERT INTO BAOCAOTHANG(Thang, Nam, TongSoLuongTiecCuoi, TongDoanhThu) VALUES ({0}, {1}, {2}, {3})", baoCaoThang.Thang, baoCaoThang.Nam, 0, 0);
if (DatabaseHelper.ExcuteSql(sqlCommand) > 0)
{
return(true);
}
return(false);
}
