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);
}
}
