public float tongtien()
{
float tongtien = 0;
String Query = String.Format("select * from nhaphang");
DataTable data = new DataTable();
data = SQLconnect.Instance.ExecuteQuery(Query);
foreach (DataRow item in data.Rows)
{
nhaphangDTO nh = new nhaphangDTO(item);
tongtien = tongtien + nh.Thanhtien;
}
return(tongtien);
}
public List <nhaphangDTO> shownhaphang()
{
List <nhaphangDTO> list = new List <nhaphangDTO>();
String Query = "select * from nhaphang";
DataTable data = new DataTable();
data = SQLconnect.Instance.ExecuteQuery(Query);
foreach (DataRow item in data.Rows)
{
nhaphangDTO nh = new nhaphangDTO(item);
list.Add(nh);
}
return(list);
}
public List <nhaphangDTO> loctheongaytheoten(DateTime tungay, DateTime denngay, String noidung)
{
string tungay1 = tungay.ToString("yyyy-MM-dd");
string denngay1 = tungay.ToString("yyyy-MM-dd");
List <nhaphangDTO> list = new List <nhaphangDTO>();
String Query = String.Format("select * from nhaphang where ngaynhap >= '{0}' and ngaynhap <= '{1}' and mahh like '%{2}%' or tenhh like '%{2}%'", tungay1, denngay1, noidung);
DataTable data = new DataTable();
data = SQLconnect.Instance.ExecuteQuery(Query);
foreach (DataRow item in data.Rows)
{
nhaphangDTO nh = new nhaphangDTO(item);
list.Add(nh);
}
return(list);
}
