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 + "'"); }