// lay don dathang doanh thu:
public List <dathangDAL> getDathangdoanhthu(string y)
{
List <dathangDAL> list = new List <dathangDAL>();
SqlConnection cn = cnn.connectToSql();
cn.Open();
string sql = "SELECT * FROM dat_hang where trang_thai ='" + y + "'";
SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
dathangDAL ds = new dathangDAL();
ds.id_dathang = rd.GetInt32(0);
ds.id_user = rd.GetInt32(1);
ds.id_pt = rd.GetInt32(2);
ds.trangthai = rd.GetBoolean(3);
ds.ngaydang = rd.GetDateTime(4);
list.Add(ds);
}
return(list);
cmd.Dispose();
cn.Close();
}
// lay don dathang:
public List <dathangDAL> getDathangP(int row, int hide, string view)
{
List <dathangDAL> list = new List <dathangDAL>();
SqlConnection cn = cnn.connectToSql();
cn.Open();
string sql = "";
if (view != "")
{
sql = "select top " + row + " * from dat_hang where trang_thai= '" + view + "' AND id_dathang not in (select top " + hide + " id_dathang from dat_hang order by id_dathang DESC ) order by id_dathang DESC";
}
else
{
sql = "select top " + row + " * from dat_hang where id_dathang not in (select top " + hide + " id_dathang from dat_hang order by id_dathang DESC ) order by id_dathang DESC";
}
SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
dathangDAL ds = new dathangDAL();
ds.id_dathang = rd.GetInt32(0);
ds.id_user = rd.GetInt32(1);
ds.id_pt = rd.GetInt32(2);
ds.trangthai = rd.GetBoolean(3);
ds.ngaydang = rd.GetDateTime(4);
list.Add(ds);
}
return(list);
cmd.Dispose();
cn.Close();
}
// lay don dathang doanh thu:
public List <dathangDAL> getDathangthanhtoan()
{
List <dathangDAL> list = new List <dathangDAL>();
SqlConnection cn = cnn.connectToSql();
cn.Open();
string sql = "select nguoidung.hoten, dat_hang.ngaydathang from dat_hang, nguoidung where nguoidung.id_user = dat_hang.id_user and dat_hang.trang_thai = 'false' order by ngaydathang ASC";
SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
dathangDAL ds = new dathangDAL();
ds.ten = rd.GetString(0);
ds.ngaydang = rd.GetDateTime(1);
list.Add(ds);
}
return(list);
cmd.Dispose();
cn.Close();
}
