public BangKe GetBangKeByID(int ID)
{
BangKe objBangKe = new BangKe();
DataTable dt = new DataTable();
dt = new Data.BangKe().GetBangKe(ID);
if (dt.Rows.Count == 1)
{
objBangKe = getBangKeByRow(dt.Rows[0]);
}
return(objBangKe);
}
public List <BangKe> GetListOfDoiTac()
{
List <BangKe> lstBangKe = new List <BangKe>();
DataTable dt = new DataTable();
dt = new Data.BangKe().GetDoiTac();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
lstBangKe.Add(getBangKeByRow2(dr));
}
}
return(lstBangKe);
}
public List <BangKe> GetListOfBangKes()
{
List <BangKe> lstBangKe = new List <BangKe>();
DataTable dt = new DataTable();
string shortDateNow = DateTime.Now.ToShortDateString();
DateTime fromDate = Convert.ToDateTime(shortDateNow + " 00:00:00");
DateTime toDate = Convert.ToDateTime(shortDateNow + " 23:59:59");
dt = new Data.BangKe().GetDSBangKe("0", "", "0", "", fromDate, toDate);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
lstBangKe.Add(getBangKeByRow(dr));
}
}
return(lstBangKe);
}
public List <BangKe> GetListOfBangKes_BySearch(string MaDoiTac,
string TenDoiTac,
string MaCongTy,
string XeDon,
DateTime NgayDonTu,
DateTime NgayDonDen)
{
List <BangKe> lstBangKe = new List <BangKe>();
DataTable dt = new DataTable();
DateTime fromDate = Convert.ToDateTime(NgayDonTu.ToShortDateString() + " 00:00:00");
DateTime toDate = Convert.ToDateTime(NgayDonDen.ToShortDateString() + " 23:59:59");
dt = new Data.BangKe().GetDSBangKe(MaDoiTac, TenDoiTac, MaCongTy, XeDon, fromDate, toDate);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
lstBangKe.Add(getBangKeByRow(dr));
}
}
return(lstBangKe);
}
