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