private void tbSearch_TextChanged(object sender, EventArgs e)
{
HDBanHang_DTO HDBH = new HDBanHang_DTO();
HDBH.MaHoaDon = tbSearch.Text;
List <HDBanHang_DTO> Search = HDBanHang_BUS.Search_HDBH(HDBH);
dataGridView1.DataSource = Search;
if (tbSearch.Text == "")
{
Load();
}
}
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
HDBanHang_DTO CTHD_DTO = new HDBanHang_DTO();
CTHD_DTO.MaHoaDon = this.dataGridView1.CurrentRow.Cells[0].ToString();
frmChiTietHDBH CTHD = new frmChiTietHDBH();
CTHD.tbMaHD.Text = this.dataGridView1.CurrentRow.Cells[0].Value.ToString();
CTHD.tbTenBan.Text = this.dataGridView1.CurrentRow.Cells[2].Value.ToString();
CTHD.tbMaNV.Text = this.dataGridView1.CurrentRow.Cells[3].Value.ToString();
CTHD.tbNgayLap.Text = this.dataGridView1.CurrentRow.Cells[4].Value.ToString();
CTHD.ShowDialog();
}
public static List <HDBanHang_DTO> Search_HDBH(HDBanHang_DTO HDBanHang_DTO)
{
List <HDBanHang_DTO> Danhsach = new List <HDBanHang_DTO>();
HDBanHang_DTO HD;
try
{
con.Open();
SqlCommand cmd = new SqlCommand("proc_SearchHDBH", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SearchHDBH", "%" + HDBanHang_DTO.MaHoaDon + "%");
var reader = cmd.ExecuteReader();
while (reader.Read())
{
HD = new HDBanHang_DTO();
HD.MaHoaDon = reader["MaHoaDon"].ToString();
HD.MaBan = reader["MaBan"].ToString();
HD.TenBan = reader["TenBan"].ToString();
HD.Ma_NV = reader["Ma_NV"].ToString();
HD.NgayLap = DateTime.Parse(reader["NgayLap"].ToString());
Danhsach.Add(HD);
}
reader.Close();
cmd.Dispose();
}
catch
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(Danhsach);
}
public static List <HDBanHang_DTO> GetListHDBH()
{
List <HDBanHang_DTO> Danhsach = new List <HDBanHang_DTO>();
try
{
HDBanHang_DTO HD;
con.Open();
SqlCommand cmd = new SqlCommand("exec proc_CTHD", con);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
HD = new HDBanHang_DTO();
HD.MaHoaDon = reader["MaHoaDon"].ToString();
HD.MaBan = reader["MaBan"].ToString();
HD.TenBan = reader["TenBan"].ToString();
HD.Ma_NV = reader["Ma_NV"].ToString();
HD.NgayLap = DateTime.Parse(reader["NgayLap"].ToString());
Danhsach.Add(HD);
}
reader.Close();
cmd.Dispose();
}
catch (Exception ex)
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(Danhsach);
}
public static List <HDBanHang_DTO> Search_HDBH(HDBanHang_DTO HDBanHang_DTO)
{
return(HDBanHang_DAO.Search_HDBH(HDBanHang_DTO));
}
