public int updateHangHoa(DTOHangHoa hanghoa)
{
var _cmd = new SqlCommand();
_cmd.CommandText = "update HANGHOA set VatTu=@VatTu,DichVu=@DichVu,MaKhoHang=@MaKhoHang,PhanLoai=@PhanLoai,MaHH=@MaHH,TENHH=@TENHH,MaVachNSX=@MaVachNSX,MaDonVi=@MaDonVi,XuatXu=@XuatXu,Thue=@Thue,TonKhoToiThieu=@TonKhoToiThieu,TonKhoHienTai=@TonKhoHienTai,MaNhaCungCap=@MaNhaCungCap,GiaMua=@GiaMua,GiaSi=@GiaSi,GiaLe=@GiaLe where MaHH=@MaHH ";
_cmd.CommandType = CommandType.Text;
_cmd.Connection = connection;
_cmd.Parameters.Add("@MaKhoHang", SqlDbType.NVarChar).Value = hanghoa.MaKhoHang;
_cmd.Parameters.Add("@PhanLoai", SqlDbType.NVarChar).Value = hanghoa.PhanLoai;
_cmd.Parameters.Add("@MaHH", SqlDbType.NVarChar).Value = hanghoa.MaHH;
_cmd.Parameters.Add("@TENHH", SqlDbType.NVarChar).Value = hanghoa.TENHH;
_cmd.Parameters.Add("@MaVachNSX", SqlDbType.NVarChar).Value = hanghoa.MaVachNSX;
_cmd.Parameters.Add("@MaDonVi", SqlDbType.NVarChar).Value = hanghoa.MaDonVi;
_cmd.Parameters.Add("@XuatXu", SqlDbType.NVarChar).Value = hanghoa.XuatXu;
_cmd.Parameters.Add("@Thue", SqlDbType.Float).Value = Convert.ToDouble(hanghoa.Thue);
_cmd.Parameters.Add("@TonKhoToiThieu", SqlDbType.Int).Value = Convert.ToInt32(hanghoa.TonKhoToiThieu);
_cmd.Parameters.Add("@TonKhoHienTai", SqlDbType.Int).Value = Convert.ToInt32(hanghoa.TonKhoHienTai);
_cmd.Parameters.Add("@MaNhaCungCap", SqlDbType.NVarChar).Value = hanghoa.MaNhaCungCap;
_cmd.Parameters.Add("@GiaMua", SqlDbType.Money).Value = Convert.ToDecimal(hanghoa.GiaMua);
_cmd.Parameters.Add("@GiaSi", SqlDbType.Money).Value = Convert.ToDecimal(hanghoa.GiaSi);
_cmd.Parameters.Add("@GiaLe", SqlDbType.Money).Value = Convert.ToDecimal(hanghoa.GiaLe);
_cmd.Parameters.Add("@VatTu", SqlDbType.Bit).Value = Convert.ToBoolean(hanghoa.VatTu);
_cmd.Parameters.Add("@DichVu", SqlDbType.Bit).Value = Convert.ToBoolean(hanghoa.DichVu);
OpenConn();
var i = _cmd.ExecuteNonQuery();
CloseConn();
return(i);
}
public DTOHangHoa getHangHoaDetail(string mahanghoa)
{
DALKhoHang um = new DALKhoHang();
DataTable dt = um.getHangHoaDetail(mahanghoa);
DTOHangHoa a = new DTOHangHoa();
a.id = dt.Rows[0]["id"].ToString();
a.VatTu = Convert.ToBoolean(dt.Rows[0]["VatTu"].ToString());
a.DichVu = Convert.ToBoolean(dt.Rows[0]["DichVu"].ToString());
a.MaKhoHang = dt.Rows[0]["MaKhoHang"].ToString();
a.PhanLoai = dt.Rows[0]["PhanLoai"].ToString();
a.MaHH = dt.Rows[0]["MaHH"].ToString();
a.TENHH = dt.Rows[0]["TENHH"].ToString();
a.MaVachNSX = dt.Rows[0]["MaVachNSX"].ToString();
a.MaDonVi = dt.Rows[0]["MaDonVi"].ToString();
a.XuatXu = dt.Rows[0]["XuatXu"].ToString();
a.Thue = dt.Rows[0]["Thue"].ToString();
a.TonKhoToiThieu = dt.Rows[0]["TonKhoToiThieu"].ToString();
a.TonKhoHienTai = dt.Rows[0]["TonKhoHienTai"].ToString();
a.MaNhaCungCap = dt.Rows[0]["MaNhaCungCap"].ToString();
a.GiaMua = dt.Rows[0]["GiaMua"].ToString();
a.GiaSi = dt.Rows[0]["GiaSi"].ToString();
a.GiaLe = dt.Rows[0]["GiaLe"].ToString();
return(a);
}
public int updateHangHoa(DTOHangHoa hanghoa)
{
DALKhoHang um = new DALKhoHang();
int dt = um.updateHangHoa(hanghoa);
return(dt);
}
public bool insertHangHoa(DTOHangHoa hanghoa)
{
DALKhoHang um = new DALKhoHang();
bool dt = um.insertHangHoa(hanghoa);
return(dt);
}
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
BUSKhoHang b = new BUSKhoHang();
DTOHangHoa dtoHangHoa = new DTOHangHoa();
dtoHangHoa.VatTu = radioButton1.Checked;
dtoHangHoa.DichVu = radioButton1.Checked;
dtoHangHoa.XuatXu = textEdit1.Text;
dtoHangHoa.MaHH = textEdit2.Text;
dtoHangHoa.MaVachNSX = textEdit3.Text;
dtoHangHoa.TENHH = textEdit4.Text;
dtoHangHoa.MaKhoHang = comboBoxEdit1.Text;
dtoHangHoa.PhanLoai = comboBoxEdit2.Text;
dtoHangHoa.MaDonVi = comboBoxEdit3.Text;
dtoHangHoa.MaNhaCungCap = comboBoxEdit7.Text;
dtoHangHoa.Thue = comboBoxEdit4.Text;
dtoHangHoa.TonKhoToiThieu = comboBoxEdit5.Text;
dtoHangHoa.TonKhoHienTai = comboBoxEdit6.Text;
dtoHangHoa.GiaMua = comboBoxEdit8.Text;
dtoHangHoa.GiaSi = comboBoxEdit9.Text;
dtoHangHoa.GiaLe = comboBoxEdit10.Text;
if (isAddForm)
{
if (b.insertHangHoa(dtoHangHoa))
{
MessageBox.Show("Thao tác thành công");
}
else
{
MessageBox.Show("Thao tác không thành công");
}
}
else
{
b.updateHangHoa(dtoHangHoa);
MessageBox.Show("Thao tác hóa thành công");
}
}
public bool insertHangHoa(DTOHangHoa hanghoa)
{
string query = string.Format($"select * from HANGHOA where MaHH='{hanghoa.MaHH}'");
if (ExecSelectedCount(query) == 0)
{
var _cmd = new SqlCommand();
_cmd.CommandText = "insert into HANGHOA values (@VatTu,@DichVu,@MaKhoHang,@PhanLoai,@MaHH,@TENHH,@MaVachNSX,@MaDonVi,@XuatXu,@Thue,@TonKhoToiThieu,@TonKhoHienTai,@MaNhaCungCap,@GiaMua,@GiaSi,@GiaLe)";
_cmd.CommandType = CommandType.Text;
_cmd.Connection = connection;
_cmd.Parameters.Add("@MaKhoHang", SqlDbType.Text).Value = hanghoa.MaKhoHang;
_cmd.Parameters.Add("@PhanLoai", SqlDbType.Text).Value = hanghoa.PhanLoai;
_cmd.Parameters.Add("@MaHH", SqlDbType.Text).Value = hanghoa.MaHH;
_cmd.Parameters.Add("@TENHH", SqlDbType.Text).Value = hanghoa.TENHH;
_cmd.Parameters.Add("@MaVachNSX", SqlDbType.Text).Value = hanghoa.MaVachNSX;
_cmd.Parameters.Add("@MaDonVi", SqlDbType.Text).Value = hanghoa.MaDonVi;
_cmd.Parameters.Add("@XuatXu", SqlDbType.Text).Value = hanghoa.XuatXu;
_cmd.Parameters.Add("@Thue", SqlDbType.Float).Value = Convert.ToDouble(hanghoa.Thue);
_cmd.Parameters.Add("@TonKhoToiThieu", SqlDbType.Int).Value = Convert.ToInt32(hanghoa.TonKhoToiThieu);
_cmd.Parameters.Add("@TonKhoHienTai", SqlDbType.Int).Value = Convert.ToInt32(hanghoa.TonKhoHienTai);
_cmd.Parameters.Add("@MaNhaCungCap", SqlDbType.Text).Value = hanghoa.MaNhaCungCap;
_cmd.Parameters.Add("@GiaMua", SqlDbType.Money).Value = Convert.ToDecimal(hanghoa.GiaMua);
_cmd.Parameters.Add("@GiaSi", SqlDbType.Money).Value = Convert.ToDecimal(hanghoa.GiaSi);
_cmd.Parameters.Add("@GiaLe", SqlDbType.Money).Value = Convert.ToDecimal(hanghoa.GiaLe);
_cmd.Parameters.Add("@VatTu", SqlDbType.Bit).Value = Convert.ToBoolean(hanghoa.VatTu);
_cmd.Parameters.Add("@DichVu", SqlDbType.Bit).Value = Convert.ToBoolean(hanghoa.DichVu);
OpenConn();
var i = _cmd.ExecuteNonQuery();
CloseConn();
return(true);
}
else
{
return(false);
}
}
private void frmHangHoa_Add_Load(object sender, EventArgs e)
{
DataTable dt2 = new DataTable();
BUSKhoHang bus = new BUSKhoHang();
dt2 = bus.getKho();
if (dt2.Rows.Count > 0)
{
foreach (DataRow row in dt2.Rows)
{
comboBoxEdit1.Properties.Items.Add(row["TenKho"]);
}
}
dt2 = new DataTable();
dt2 = bus.getBangNhomHang();
if (dt2.Rows.Count > 0)
{
foreach (DataRow row in dt2.Rows)
{
comboBoxEdit2.Properties.Items.Add(row["TenNH"]);
}
}
dt2 = new DataTable();
dt2 = bus.getBangDonVi();
if (dt2.Rows.Count > 0)
{
foreach (DataRow row in dt2.Rows)
{
comboBoxEdit3.Properties.Items.Add(row["TenDV"]);
}
}
dt2 = new DataTable();
BUSDoiTac bus2 = new BUSDoiTac();
dt2 = bus2.getNhaPhanPhoi();
if (dt2.Rows.Count > 0)
{
foreach (DataRow row in dt2.Rows)
{
comboBoxEdit7.Properties.Items.Add(row["TenNPP"]);
}
}
////////////////////
if (!isAddForm)
{
BUSKhoHang b = new BUSKhoHang();
DTOHangHoa dtoHangHoa = b.getHangHoaDetail(gotID);
radioButton1.Checked = dtoHangHoa.VatTu;
radioButton1.Checked = dtoHangHoa.DichVu;
textEdit1.Text = dtoHangHoa.XuatXu;
textEdit2.Text = dtoHangHoa.MaHH;
textEdit3.Text = dtoHangHoa.MaVachNSX;
textEdit4.Text = dtoHangHoa.TENHH;
comboBoxEdit1.Text = dtoHangHoa.MaKhoHang;
comboBoxEdit2.Text = dtoHangHoa.PhanLoai;
comboBoxEdit3.Text = dtoHangHoa.MaDonVi;
comboBoxEdit7.Text = dtoHangHoa.MaNhaCungCap;
comboBoxEdit4.Text = dtoHangHoa.Thue;
comboBoxEdit5.Text = dtoHangHoa.TonKhoToiThieu;
comboBoxEdit6.Text = dtoHangHoa.TonKhoHienTai;
comboBoxEdit8.Text = dtoHangHoa.GiaMua;
comboBoxEdit9.Text = dtoHangHoa.GiaSi;
comboBoxEdit10.Text = dtoHangHoa.GiaLe;
}
else
{
textEdit2.ReadOnly = false;
comboBoxEdit6.Text = "0";
}
}
