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); }