public static DataTable BaoCaoThang(int thang)
{
string sql = "select * from BAOCAOCONGNO where Month(NgayPhatSinh) like '%" + thang + "%' ";
return(DataAccess.ExcuQuery(sql));
}
public static void Insert(BaoCaoCongNoDTO baoCao)
{
string sql = "insert into BAOCAOCONGNO(MaKhachHang,NgayPhatSinh,NoDau,PhatSinh,NoCuoi) values(" + baoCao.MaKhachHang + ",'" + baoCao.NgayPhatSinh + "'," + baoCao.NoDau + ",'" + baoCao.PhatSinh + "'," + baoCao.NoCuoi + ")";
DataAccess.ExcuNonQuery(sql);
}