public bool deletedata(En_SanPham en)
{
string query = string.Format("DELETE FROM SanPham WHERE MaHang=@MaHang");
SqlParameter[] sqlPara = new SqlParameter[1];
sqlPara[0] = new SqlParameter("@MaHang", en.MaHang);
return(cnn.executeDeleteQuery(query, sqlPara));
}
public bool updatedata(En_SanPham en)
{
string query = string.Format("UPDATE SanPham SET TenHang=@TenHang, SoLuong=@SoLuong, GiaBan=@GiaBan WHERE MaHang=@MaHang");
SqlParameter[] sqlPara = new SqlParameter[4];
sqlPara[0] = new SqlParameter("@TenHang", en.TenHang);
sqlPara[1] = new SqlParameter("@SoLuong", en.SoLuong);
sqlPara[2] = new SqlParameter("@GiaBan", en.GiaBan);
sqlPara[3] = new SqlParameter("@MaHang", en.MaHang);
return(cnn.executeUpdateQuery(query, sqlPara));
}
public bool insertdata(En_SanPham en)
{
string query = string.Format("INSERT INTO SanPham(MaHang, TenHang, SoLuong, GiaBan, MaLoai) VALUES(@MaHang,@TenHang,@SoLuong,@GiaBan,@MaLoai)");
SqlParameter[] sqlPara = new SqlParameter[5];
sqlPara[0] = new SqlParameter("@MaHang", en.MaHang);
sqlPara[1] = new SqlParameter("@TenHang", en.TenHang);
sqlPara[2] = new SqlParameter("@SoLuong", en.SoLuong);
sqlPara[3] = new SqlParameter("@GiaBan", en.GiaBan);
sqlPara[4] = new SqlParameter("@MaLoai", en.MaLoai);
return(cnn.executeInsertQuery(query, sqlPara));
}
//End Controls
public Form1()
{
InitializeComponent();
//Set up the form.
this.MaximizeBox = false;
this.MinimizeBox = false;
this.Size = new System.Drawing.Size(600, 400);
this.Text = "Quản lý sản phẩm theo loại";
this.FormBorderStyle = FormBorderStyle.FixedDialog;
this.StartPosition = FormStartPosition.CenterScreen;
//ComboBox
this.cboLoaiSP.Location = new System.Drawing.Point(94, 12);
this.cboLoaiSP.Size = new System.Drawing.Size(200, 21);
//End ComboBox
//Label
this.lbl1.Text = "Loại sản phẩm";
this.lbl1.Location = new System.Drawing.Point(12, 15);
this.lbl1.Size = new System.Drawing.Size(76, 13);
this.lbl2.Text = "Thông tin sản phẩm dựa vào loại sản phẩm đã chọn";
this.lbl2.Location = new System.Drawing.Point(12, 36);
this.lbl2.Size = new System.Drawing.Size(254, 13);
this.lbl3.Text = "Mã sản phẩm:";
this.lbl3.Location = new System.Drawing.Point(16, 251);
this.lbl3.Size = new System.Drawing.Size(74, 13);
this.lbl4.Text = "Tên sản phẩm:";
this.lbl4.Location = new System.Drawing.Point(12, 277);
this.lbl4.Size = new System.Drawing.Size(78, 13);
this.lbl5.Text = "Số lượng";
this.lbl5.Location = new System.Drawing.Point(12, 277);
this.lbl5.Size = new System.Drawing.Size(49, 13);
this.lbl6.Text = "Giá bán:";
this.lbl6.Location = new System.Drawing.Point(145, 302);
this.lbl6.Size = new System.Drawing.Size(47, 13);
//End Label
//DataGridView
this.dgv.AllowUserToAddRows = false;
this.dgv.AllowUserToDeleteRows = false;
this.dgv.ReadOnly = true;
this.dgv.MultiSelect = false;
this.dgv.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
this.dgv.Location = new System.Drawing.Point(15, 52);
this.dgv.Size = new System.Drawing.Size(557, 190);
//End DataGridView
//NumericUpDown
this.nud.Minimum = 0;
this.nud.Maximum = 999999;
this.nud.Location = new System.Drawing.Point(89, 300);
this.nud.Size = new System.Drawing.Size(50, 20);
//End NumericUpDown
//Textbox
this.txtMaSP.Location = new System.Drawing.Point(89, 248);
this.txtMaSP.Size = new System.Drawing.Size(100, 20);
this.txtTenSP.Location = new System.Drawing.Point(89, 274);
this.txtTenSP.Size = new System.Drawing.Size(300, 20);
this.txtGiaBan.Location = new System.Drawing.Point(198, 300);
this.txtGiaBan.Size = new System.Drawing.Size(191, 20);
//End Textbox
//Button
this.btnThem.Text = "Thêm";
this.btnThem.Location = new System.Drawing.Point(173, 327);
this.btnThem.Size = new System.Drawing.Size(75, 23);
this.btnSua.Text = "Sửa";
this.btnSua.Location = new System.Drawing.Point(254, 326);
this.btnSua.Size = new System.Drawing.Size(75, 23);
this.btnXoa.Text = "Xóa";
this.btnXoa.Location = new System.Drawing.Point(335, 327);
this.btnXoa.Size = new System.Drawing.Size(75, 23);
this.btnHuy.Text = "Hủy";
this.btnHuy.Location = new System.Drawing.Point(416, 327);
this.btnHuy.Size = new System.Drawing.Size(75, 23);
this.btnLuu.Text = "Lưu";
this.btnLuu.Location = new System.Drawing.Point(497, 327);
this.btnLuu.Size = new System.Drawing.Size(75, 23);
//End Button
this.Controls.Add(cboLoaiSP);
this.Controls.Add(lbl1);
this.Controls.Add(lbl2);
this.Controls.Add(lbl3);
this.Controls.Add(lbl4);
this.Controls.Add(lbl5);
this.Controls.Add(lbl6);
this.Controls.Add(dgv);
this.Controls.Add(nud);
this.Controls.Add(txtMaSP);
this.Controls.Add(txtTenSP);
this.Controls.Add(txtGiaBan);
this.Controls.Add(btnThem);
this.Controls.Add(btnSua);
this.Controls.Add(btnXoa);
this.Controls.Add(btnHuy);
this.Controls.Add(btnLuu);
en = new En_SanPham();
NapLoaiSP();
NapSanPham();
EvenButton(0);
EnableOrDisable(true);
this.cboLoaiSP.SelectedIndexChanged += new System.EventHandler(this.cboLoaiSP_SelectedIndexChange);
this.dgv.Click += new System.EventHandler(this.dgv_SelectedIndexChange);
this.btnThem.Click += new System.EventHandler(this.btnThem_Click);
this.btnSua.Click += new System.EventHandler(this.btnSua_Click);
this.btnXoa.Click += new System.EventHandler(this.btnXoa_Click);
this.btnHuy.Click += new System.EventHandler(this.btnHuy_Click);
this.btnLuu.Click += new System.EventHandler(this.btnLuu_Click);
}
public void deletedata(En_SanPham en)
{
dal.deletedata(en);
}
public void updatedata(En_SanPham en)
{
dal.updatedata(en);
}
public void insertdata(En_SanPham en)
{
dal.insertdata(en);
}
