private void KhoiTao(string MaNhomHang) { if (grdvDSMatHang.ColumnCount > 0) { grdvDSMatHang.Columns.Clear(); grdvDSMatHang.DataSource = null; bindingSource1 = new BindingSource(); } DataTable Bang; if (MaNhomHang == "") { Bang = MatHangBus.LayBang(); } else { Bang = MatHangBus.LayBang(MaNhomHang); } DataColumn Cot = new DataColumn(); Cot.ColumnName = "NgungBan"; Cot.Caption = "Ngưng Bán"; Bang.Columns.Add(Cot); foreach (DataRow Dong in Bang.Rows) { Dong["ThueVAT"] = Double.Parse(Dong["ThueVAT"].ToString()) / 100; if (Dong["TrangThai"].ToString().Trim() == "2") { Dong["NgungBan"] = "Ngưng bán"; } else { Dong["NgungBan"] = ""; } } //Bang.Columns["TrangThai"].DataType = //Loc thong tin mat hang bindingSource1.DataSource = Bang; string sql = ""; if (radioTheoMa.Checked == true) { sql = " CONVERT([MaMatHang], 'System.String') = '" + txtMatHang.Text.Trim() + "' "; } else { sql = " CONVERT([TenMatHang], 'System.String') LIKE '%" + txtMatHang.Text.Trim() + "%' "; } if (txtMatHang.Text.Trim() != "") { bindingSource1.Filter = sql; } grdvDSMatHang.DataSource = bindingSource1; AnCotTrenLuoi(); DinhDangCot(); }
private void KhoiTao(string MaNhomHang) { if (grdvDSMatHang.ColumnCount > 0) { grdvDSMatHang.Columns.Clear(); grdvDSMatHang.DataSource = null; bindingSource1 = new BindingSource(); } DataTable Bang; if (MaNhomHang == "TatCa") { Bang = MatHangBus.LayBang(); } else { Bang = MatHangBus.LayBang(MaNhomHang); } DataColumn Cot = new DataColumn("ThucHien"); Cot.DefaultValue = "BinhThuong"; Bang.Columns.Add(Cot); foreach (DataRow Dong in Bang.Rows) { Dong["ThueVAT"] = Double.Parse(Dong["ThueVAT"].ToString()) / 100; } //Loc thong tin mat hang bindingSource1.DataSource = Bang; string sql = ""; if (radioTheoMa.Checked == true) { sql = " CONVERT([MaMatHang], 'System.String') = '" + txtMatHang.Text.Trim() + "' "; } else { sql = " CONVERT([TenMatHang], 'System.String') LIKE '%" + txtMatHang.Text.Trim() + "%' "; } if (txtMatHang.Text.Trim() != "") { bindingSource1.Filter = sql; } grdvDSMatHang.DataSource = bindingSource1; AnCotTrenLuoi(); DinhDangCot(); }