private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { BUSKhoHang b = new BUSKhoHang(); DTONhomHang d = new DTONhomHang(); d.MaNH = textEdit1.Text; d.TenNH = textEdit2.Text; d.GhiChu = textEdit3.Text; d.ConQuanLy = checkEdit1.Checked; if (isAddForm) { if (b.insertBangNhomHang(d)) { MessageBox.Show("Thao tác thành công"); } else { MessageBox.Show("Thao tác không thành công"); } } else { b.updateBangNhomHang(d); MessageBox.Show("Thao tác hóa thành công"); } }
public int updateBangNhomHang(DTONhomHang hanghoa) { DALKhoHang um = new DALKhoHang(); int dt = um.updateBangNhomHang(hanghoa); return(dt); }
public bool insertBangNhomHang(DTONhomHang hanghoa) { DALKhoHang um = new DALKhoHang(); bool dt = um.insertBangNhomHang(hanghoa); return(dt); }
public DTONhomHang getBangNhomHangDetail(string mahanghoa) { DALKhoHang um = new DALKhoHang(); DataTable dt = um.getBangNhomHangDetail(mahanghoa); DTONhomHang a = new DTONhomHang(); a.MaNH = dt.Rows[0]["MaNH"].ToString(); a.TenNH = dt.Rows[0]["TenNH"].ToString(); a.GhiChu = dt.Rows[0]["GhiChu"].ToString(); a.ConQuanLy = Convert.ToBoolean(dt.Rows[0]["ConQuanLy"].ToString()); return(a); }
private void frmNhomHang_Add_Load(object sender, EventArgs e) { if (!isAddForm) { BUSKhoHang b = new BUSKhoHang(); DTONhomHang dtoHangHoa = b.getBangNhomHangDetail(gotID); textEdit1.Text = dtoHangHoa.MaNH; textEdit2.Text = dtoHangHoa.TenNH; textEdit3.Text = dtoHangHoa.GhiChu; checkEdit1.Checked = dtoHangHoa.ConQuanLy; } else { textEdit1.ReadOnly = false; } }
public int updateBangNhomHang(DTONhomHang hanghoa) { var _cmd = new SqlCommand(); _cmd.CommandText = "update BANGNHOMHANG set MaNH=@MaNH,TenNH=@TenNH,GhiChu=@GhiChu,ConQuanLy=@ConQuanLy where MaNH=@MaNH"; _cmd.CommandType = CommandType.Text; _cmd.Connection = connection; _cmd.Parameters.Add("@MaNH", SqlDbType.NVarChar).Value = hanghoa.MaNH; _cmd.Parameters.Add("@TenNH", SqlDbType.NVarChar).Value = hanghoa.TenNH; _cmd.Parameters.Add("@GhiChu", SqlDbType.NVarChar).Value = hanghoa.GhiChu; _cmd.Parameters.Add("@ConQuanLy", SqlDbType.Bit).Value = hanghoa.ConQuanLy; OpenConn(); var i = _cmd.ExecuteNonQuery(); CloseConn(); return(i); }
public bool insertBangNhomHang(DTONhomHang hanghoa) { string query = string.Format($"select * from BANGNHOMHANG where MaNH='{hanghoa.MaNH}'"); if (ExecSelectedCount(query) == 0) { var _cmd = new SqlCommand(); _cmd.CommandText = "insert into BANGNHOMHANG values (@MaNH,@TenNH,@GhiChu,@ConQuanLy)"; _cmd.CommandType = CommandType.Text; _cmd.Connection = connection; _cmd.Parameters.Add("@MaNH", SqlDbType.Text).Value = hanghoa.MaNH; _cmd.Parameters.Add("@TenNH", SqlDbType.Text).Value = hanghoa.TenNH; _cmd.Parameters.Add("@GhiChu", SqlDbType.Text).Value = hanghoa.GhiChu; _cmd.Parameters.Add("@ConQuanLy", SqlDbType.Bit).Value = hanghoa.ConQuanLy; OpenConn(); var i = _cmd.ExecuteNonQuery(); CloseConn(); return(true); } else { return(false); } }