private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { btnXoa.Enabled = true; BtnCapnhat.Enabled = true; btnThem.Enabled = false; foreach (DataGridViewRow row in dataGridView1.SelectedRows) { int rowId = int.Parse(row.Cells[0].Value.ToString()); DAL.SanPham sp = bus_sanpham.GetSanPhamByID(rowId); if (sp != null) { txtMasp.Text = sp.MaSP.ToString(); if (sp.MaLoai == 1) { rbHoathat.Checked = true; } else { rbHoaGia.Checked = true; } txtTensp.Text = sp.TenSP; txtDvt.Text = sp.DVT; txtNoisanxuat.Text = sp.NoiSanXuat; txtGianhap.Text = sp.GiaNhap.ToString(); txtGiaban.Text = sp.GiaBan.ToString(); dateTimePicker1.Value = sp.NgayNhap; if (sp.HinhAnh != null) { Byte[] img = sp.HinhAnh; MemoryStream ms = new MemoryStream(img); pictureBox1.Image = Image.FromStream(ms); } } else { MessageBox.Show("Lỗi trong quá trình xử lý"); } } }
partial void DeleteSanPham(SanPham instance);
partial void UpdateSanPham(SanPham instance);
partial void InsertSanPham(SanPham instance);
// Loc San Pham public List <SanPham> LocDanhSachSanhPham(SanPham sp) { try { OpenConnection(); List <SanPham> splist = new List <SanPham>(); SqlCommand sqlCommand = new SqlCommand(); SqlDataReader sqlReader = null; DataTable dt = new DataTable(); if (sp.Search == "Mã Sản Phẩm") { sqlCommand.CommandType = CommandType.Text; sqlCommand.CommandText = "SELECT MASP FROM dbo.SANPHAM"; sqlCommand.Connection = conn; sqlReader = sqlCommand.ExecuteReader(); dt.Load(sqlReader); for (int i = 0; i < dt.Rows.Count; i++) { SanPham sps = new SanPham(); sps.MaSp = int.Parse(dt.Rows[i][0].ToString()); splist.Add(sps); } } else if (sp.Search == "Tên Sản Phẩm") { sqlCommand.CommandText = "SELECT TENSP FROM dbo.SANPHAM"; sqlCommand.Connection = conn; sqlReader = sqlCommand.ExecuteReader(); dt.Load(sqlReader); for (int i = 0; i < dt.Rows.Count; i++) { SanPham sps = new SanPham(); sps.TenSp = dt.Rows[i][0].ToString(); splist.Add(sps); } } else if (sp.Search == "Mã Sản Xuất") { sqlCommand.CommandText = "SELECT DISTINCT(MASX) FROM dbo.SANPHAM"; sqlCommand.Connection = conn; sqlReader = sqlCommand.ExecuteReader(); dt.Load(sqlReader); for (int i = 0; i < dt.Rows.Count; i++) { SanPham sps = new SanPham(); sps.MaSx = int.Parse(dt.Rows[i][0].ToString()); splist.Add(sps); } } else if (sp.Search == "Mã Loại") { sqlCommand.CommandText = "SELECT DISTINCT(MALOAI) FROM dbo.SANPHAM"; sqlCommand.Connection = conn; sqlReader = sqlCommand.ExecuteReader(); dt.Load(sqlReader); for (int i = 0; i < dt.Rows.Count; i++) { SanPham sps = new SanPham(); sps.MaLoai = int.Parse(dt.Rows[i][0].ToString()); splist.Add(sps); } } sqlReader.Close(); return(splist); } catch { throw; } finally { CloseConnection(); } }
// Search Sản Phẩm Theo Mã Sản Phẩm TABLE SANPHAM #region Search Sản Phẩm Theo Mã Sản Phẩm TABLE SANPHAM public DataTable TimKiemSanPham1(SanPham sp) { try { OpenConnection(); DataTable dt1 = new DataTable(); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.Text; command.CommandText = "SELECT *FROM SANPHAM WHERE MASP=@masp"; command.Connection = conn; command.Parameters.Add("@masp", SqlDbType.Int).Value = sp.MaSp; SqlDataAdapter adapter1 = new SqlDataAdapter(command); adapter1.Fill(dt1); return(dt1); } catch { throw; } finally { CloseConnection(); } #region // SqlCommand command = new SqlCommand(); // command.CommandType = CommandType.StoredProcedure; // command.CommandText = "sp_Search_SanPham_Theo_MaSp"; // command.Connection = conn; // command.Parameters.Add("@Masp", SqlDbType.Int).Value = sp.MaSp; // SqlDataAdapter adapter = new SqlDataAdapter(command); // adapter.Fill(dt); // //SqlDataReader reader = command.ExecuteReader(); // //dt.Load(reader); // for (int i = 0; i < dt.Rows.Count; i++) // { // sp.MaSp = int.Parse(dt.Rows[i][0].ToString()); // sp.TenSp = dt.Rows[i][1].ToString(); // sp.MaSx = int.Parse(dt.Rows[i][2].ToString()); // sp.MaLoai = int.Parse(dt.Rows[i][3].ToString()); // sp.GiaThanh = float.Parse(dt.Rows[i][4].ToString()); // sp.Cpu = dt.Rows[i][5].ToString(); // sp.Ram = dt.Rows[i][6].ToString(); // sp.Ocung = dt.Rows[i][7].ToString(); // sp.ManHinh = dt.Rows[i][8].ToString(); // sp.CardManHinh = dt.Rows[i][9].ToString(); // sp.CongKetNoi = dt.Rows[i][10].ToString(); // sp.Hdt = dt.Rows[i][11].ToString(); // sp.AmThanh = dt.Rows[i][12].ToString(); // sp.DiaQuang = dt.Rows[i][13].ToString(); // sp.GiaoTiepMang = dt.Rows[i][14].ToString(); // sp.WebCam = dt.Rows[i][15].ToString(); // sp.Pin = dt.Rows[i][16].ToString(); // sp.TrongLuong = dt.Rows[i][17].ToString(); // sp.BaoHanh = dt.Rows[i][18].ToString(); // } //// reader.Close(); // return dt; #endregion }