private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { BUSKhoHang b = new BUSKhoHang(); DTODonViTinh d = new DTODonViTinh(); d.MaDV = textEdit1.Text; d.TenDV = textEdit2.Text; d.GhiChu = textEdit3.Text; d.ConQuanLy = checkEdit1.Checked; if (isAddForm) { if (b.insertBangDonVi(d)) { MessageBox.Show("Thao tác thành công"); } else { MessageBox.Show("Thao tác không thành công"); } } else { b.updateBangDonVi(d); MessageBox.Show("Thao tác hóa thành công"); } }
public int updateBangDonVi(DTODonViTinh hanghoa) { DALKhoHang um = new DALKhoHang(); int dt = um.updateBangDonVi(hanghoa); return(dt); }
public bool insertBangDonVi(DTODonViTinh hanghoa) { DALKhoHang um = new DALKhoHang(); bool dt = um.insertBangDonVi(hanghoa); return(dt); }
public DTODonViTinh getBanDonViDetail(string mahanghoa) { DALKhoHang um = new DALKhoHang(); DataTable dt = um.getBanDonViDetail(mahanghoa); DTODonViTinh a = new DTODonViTinh(); a.MaDV = dt.Rows[0]["MaDV"].ToString(); a.TenDV = dt.Rows[0]["TenDV"].ToString(); a.GhiChu = dt.Rows[0]["GhiChu"].ToString(); a.ConQuanLy = Convert.ToBoolean(dt.Rows[0]["ConQuanLy"].ToString()); return(a); }
private void frmDonViTinh_Add_Load(object sender, EventArgs e) { if (!isAddForm) { BUSKhoHang b = new BUSKhoHang(); DTODonViTinh dtoHangHoa = b.getBanDonViDetail(gotID); textEdit1.Text = dtoHangHoa.MaDV; textEdit2.Text = dtoHangHoa.TenDV; textEdit3.Text = dtoHangHoa.GhiChu; checkEdit1.Checked = dtoHangHoa.ConQuanLy; } else { textEdit1.ReadOnly = false; } }
public int updateBangDonVi(DTODonViTinh hanghoa) { var _cmd = new SqlCommand(); _cmd.CommandText = "update BANGDONVI set MaDV=@MaDV,TenDV=@TenDV,GhiChu=@GhiChu,ConQuanLy=@ConQuanLy where MaDV=@MaDV"; _cmd.CommandType = CommandType.Text; _cmd.Connection = connection; _cmd.Parameters.Add("@MaDV", SqlDbType.NVarChar).Value = hanghoa.MaDV; _cmd.Parameters.Add("@TenDV", SqlDbType.NVarChar).Value = hanghoa.TenDV; _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 insertBangDonVi(DTODonViTinh hanghoa) { string query = string.Format($"select * from BANGDONVI where MaDV='{hanghoa.MaDV}'"); if (ExecSelectedCount(query) == 0) { var _cmd = new SqlCommand(); _cmd.CommandText = "insert into BANGDONVI values (@MaDV,@TenDV,@GhiChu,@ConQuanLy)"; _cmd.CommandType = CommandType.Text; _cmd.Connection = connection; _cmd.Parameters.Add("@MaDV", SqlDbType.Text).Value = hanghoa.MaDV; _cmd.Parameters.Add("@TenDV", SqlDbType.Text).Value = hanghoa.TenDV; _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); } }