private void Report_tblHoadonbanhang_Load(object sender, EventArgs e) { //List<tblHoadonbanhang> listHoadon = new List<tblHoadonbanhang>(); //listHoadon = new XuLy_tblHoadonbanhang().tblHoadonbanhang_Select(0); DataTable t = new DataTable(); t = new XuLy_tblHoadonbanhang().TimKiem(sql); //DataSet dataSet = new DataSet(); //DataTable dataTable = new XuLy_tblHoadonbanhang().TimKiem(sql); //dataSet.Tables.Add(dataTable); Report_Hoadon rp = new Report_Hoadon(); //CrystalReport_tblHoadonbanhang rp = new CrystalReport_tblHoadonbanhang(); rp.SetDataSource(t); crystalReportViewer_tblHoadonbanhang.ReportSource = rp; //crystalReportViewer_tblHoadonbanhang.Show(); }
public BanHang(int HoadonbanhangID) { InitializeComponent(); labelHoadonbanhangID.Visible = txtHoadonbanhangID.Visible = true; dateThoigianban.Enabled = true; Mahoadon = HoadonbanhangID; txtHoadonbanhangID.Text = Mahoadon.ToString(); tblHoadonbanhang hoadon = new XuLy_tblHoadonbanhang().tblHoadonbanhang_Select(Mahoadon)[0]; txtNhanvienID.Text = hoadon.FK_iNhanvienID.ToString(); txtTenKhachhang.Text = hoadon.sTenKhachhang; txtDiachi.Text = hoadon.sDiachi; txtSdt.Text = hoadon.sSdt; dateThoigianban.Value = hoadon.dThoigianban; txtTongtien.Text = hoadon.iTongtien.ToString(); sFilter += string.Format(" and tblHangban.FK_iHoadonbanhangID = '{0}' ", Mahoadon.ToString()); table = new XuLy_tblHangban().TimKiem(sFilter); dataGridViewtblHangban.DataSource = table; dataGridViewtblHangban.ClearSelection(); }
private void TimKiem() { sFilter = " 1>0 "; if (!string.IsNullOrEmpty(txtHoadonbanhangID.Text.Trim())) { if (sFilter == " 1>0 ") { sFilter = string.Format(" PK_iHoadonbanhangID = '{0}' ", txtHoadonbanhangID.Text.Trim().ToString()); } else { sFilter += string.Format("or PK_iHoadonbanhangID = '{0}' ", txtHoadonbanhangID.Text.Trim().ToString()); } } if (!string.IsNullOrEmpty(txtNhanvienID.Text.Trim())) { if (sFilter == " 1>0 ") { sFilter = string.Format(" sTenKhachhang LIKE '%{0}%' ", txtTenKhachhang.Text.Trim()); } else { sFilter += string.Format(" or sTenKhachhang LIKE '%{0}%' ", txtTenKhachhang.Text.Trim()); } } if (!string.IsNullOrEmpty(txtTenKhachhang.Text.Trim())) { if (sFilter == " 1>0 ") { sFilter = string.Format(" sTenKhachhang LIKE '%{0}%' ", txtTenKhachhang.Text.Trim()); } else { sFilter += string.Format(" or sTenKhachhang LIKE '%{0}%' ", txtTenKhachhang.Text.Trim()); } } if (!string.IsNullOrEmpty(txtTenNhanvien.Text.Trim())) { sFilter += string.Format(" or tblNhanvien.sTenNhanvien LIKE '%{0}%' ", txtTenNhanvien.Text.Trim()); } if (!string.IsNullOrEmpty(txtDiachi.Text.Trim())) { sFilter += string.Format(" or sDiachi LIKE '%{0}%' ", txtDiachi.Text.Trim()); } if (!string.IsNullOrEmpty(txtSdt.Text.Trim())) { if (sFilter == " 1>0 ") { sFilter = string.Format(" sSdt LIKE '%{0}%' ", txtSdt.Text.Trim()); } else { sFilter += string.Format(" or sSdt LIKE '%{0}%' ", txtSdt.Text.Trim()); } } if (checkBoxNgay.Checked == true) { sFilter += string.Format(" or dThoigianban = '{0}' ", dateThoigianban.Text.ToString()); } if (checkBoxThang.Checked == true) { sFilter += string.Format(" or MONTH(dThoigianban) = MONTH('{0}') and YEAR(dThoigianban) = YEAR('{0}') ", dateThoigianban.Text.ToString(), dateThoigianban.Text.ToString()); } if (checkBoxNam.Checked == true) { sFilter += string.Format(" or YEAR(dThoigianban) = YEAR('{0}') ", dateThoigianban.Text.ToString()); } DataTable table = new XuLy_tblHoadonbanhang().TimKiem(sFilter); dataGridViewHoadonbanhang.DataSource = table; dataGridViewHoadonbanhang.ClearSelection(); if (dataGridViewHoadonbanhang.Rows.Count == 1) { dataGridViewHoadonbanhang.SelectAll(); buttonSua.Tag = buttonXoa.Tag = dataGridViewHoadonbanhang.Rows[0].Cells[0]; buttonSua.Enabled = true; buttonXoa.Enabled = true; } else { dataGridViewHoadonbanhang.ClearSelection(); buttonSua.Enabled = false; buttonXoa.Enabled = false; } }