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