public void themoisp(EC_tb_Hanghoa sp)
{
if (!spsql.kiemtrasp(sp.MAHANG))
{
spsql.themmoisp(sp);
}
else
{
MessageBox.Show("Mã này đã tồn tại,xin chọn Mã khác", "Chú Ý", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public void suasp(EC_tb_Hanghoa sp)
{
SqlConnection con = cn.getcon();
try
{
con.Open();
string sql = @"UPDATE tb_Hanghoa
SET tenhang =N'" + sp.TENHANG + "', manhom =N'" + sp.MANHOM + "', maloai =N'" + sp.MALOAI + "', madonvi =N'" + sp.MADONVI + "', machatlieu =N'" + sp.MACHATLIEU + "', manuoc =N'" + sp.MANUOC + "', soluong =N'" + sp.SOLUONG + "', dongianhap =N'" + sp.DONGIANHAP + "', dongiaban =N'" + sp.DONGIABAN + "', thoigianbh =N'" + sp.THOAIGIANBH + "', hinhanh =hinhanh, ghichu =N'" + sp.GHICHU + "' where mahang=N'" + sp.MAHANG + "'";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.Add(new SqlParameter("@hinhanh", (object)sp.HINHANH));
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
}
public void suasp(EC_tb_Hanghoa sp)
{
SqlConnection con = cn.getcon();
try
{
con.Open();
string sql = @"UPDATE tb_Hanghoa
SET tenhang =N'" + sp.TENHANG + "', matheloai =N'" + sp.MATHELOAI + "', manhaphathanh =N'" + sp.MANHAPHATHANH + "', manuoc =N'" + sp.MANUOC + "', soluong =N'" + sp.SOLUONG + "', dongianhap =N'" + sp.DONGIANHAP + "', dongiaban =N'" + sp.DONGIABAN + "', thoigianrm =N'" + sp.THOAIGIANRM + "', ghichu =N'" + sp.GHICHU + "' where mahang=N'" + sp.MAHANG + "'";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
}
public void themmoisp(EC_tb_Hanghoa sp)
{
SqlConnection con = cn.getcon();
try
{
con.Open();
string sql = @"INSERT INTO tb_Hanghoa
(mahang, tenhang, manhom, maloai, madonvi, machatlieu, manuoc, soluong, dongianhap, dongiaban, thoigianbh, hinhanh, ghichu)
VALUES (N'" + sp.MAHANG + "',N'" + sp.TENHANG + "',N'" + sp.MANHOM + "',N'" + sp.MALOAI + "',N'" + sp.MADONVI + "',N'" + sp.MACHATLIEU + "',N'" + sp.MANUOC + "',N'" + sp.SOLUONG + "',N'" + sp.DONGIANHAP + "',N'" + sp.DONGIABAN + "',N'" + sp.THOAIGIANBH + "',@hinhanh,N'" + sp.GHICHU + "')";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.Add(new SqlParameter("@hinhanh", (object)sp.HINHANH));
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
}
public void themmoisp(EC_tb_Hanghoa sp)
{
SqlConnection con = cn.getcon();
try
{
con.Open();
string sql = @"INSERT INTO tb_Hanghoa
(mahang, tenhang, matheloai, manhaphathanh, manuoc, soluong, dongianhap, dongiaban, thoigianrm, ghichu)
VALUES (N'" + sp.MAHANG + "',N'" + sp.TENHANG + "',N'" + sp.MATHELOAI + "',N'" + sp.MANHAPHATHANH + "',N'" + sp.MANUOC + "',N'" + sp.SOLUONG + "',N'" + sp.DONGIANHAP + "',N'" + sp.DONGIABAN + "',N'" + sp.THOAIGIANRM + "',N'" + sp.GHICHU + "')";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
}
public void xoasp(EC_tb_Hanghoa sp)
{
spsql.xoasp(sp);
}
public void suasp(EC_tb_Hanghoa sp)
{
spsql.suasp(sp);
}
public void xoasp(EC_tb_Hanghoa sp)
{
cn.ExcuteNonQuery("DELETE FROM [tb_Hanghoa] WHERE mahang=N'" + sp.MAHANG + "'");
}
