public static bool capNhatBaoCao(DTO.DTO_BaoCaoDoanhSo bc)
{
String sql = String.Format(@"UPDATE BAO_CAO_DOANH_SO SET THANG='{1}', TONG_DOANH_THU={2} WHERE MA_BAO_CAO='{0}'",
bc.MA_BAO_CAO, bc.THANG, bc.TONG_DOANH_THU);
if (DatabaseHelper.ExcuteSql(sql) > 0)
{
return(true);
}
return(false);
}
private void UpdateBC()
{
string ma = lbMaBaoCao.Text.Trim();
int Tong = int.Parse(lbTongDoanhthu.Text.ToString());
DTO.DTO_BaoCaoDoanhSo s = new DTO.DTO_BaoCaoDoanhSo();
s.MA_BAO_CAO = ma;
s.THANG = numNam.Value.ToString() + "-" + numThang.Value.ToString();
s.TONG_DOANH_THU = Tong;
BUS.BUS_BaoCaoThang.capNhatBaoCao(s);
CapNhatChiTiet();
}
public static bool themBaoCao(DTO.DTO_BaoCaoDoanhSo bc)
{
String sql = String.Format(@"INSERT INTO BAO_CAO_DOANH_SO (MA_BAO_CAO, THANG, TONG_DOANH_THU) VALUES ('{0}','{1}',{2})",
bc.MA_BAO_CAO, bc.THANG, bc.TONG_DOANH_THU);
Console.WriteLine(sql);
if (DatabaseHelper.ExcuteSql(sql) > 0)
{
return(true);
}
return(false);
}
public static bool capNhatBaoCao(DTO.DTO_BaoCaoDoanhSo s)
{
return(DAO.DAO_BaoCaoDoanhSo.capNhatBaoCao(s));
}
public static bool themBaoCao(DTO.DTO_BaoCaoDoanhSo s)
{
return(DAO.DAO_BaoCaoDoanhSo.themBaoCao(s));
}
