public bool CapNhaphang(BEL_Hang hang, string mahang) { bool ketqua = false; try { GetCon(); string sql = "Update tbHang set MaHang ='" + hang.MaHang + "' ,TenHang = N'" + hang.TenHang + "' , SoLuong ='" + hang.SoLuong + "' , Loai ='" + hang.Loai + "', NhaCungCap = '" + hang.NCC + "' ,TThai ='" + hang.TThai + "', Hinh = N'" + hang.Hinh + "' Where MaHang ='" + mahang + "'"; SqlCommand commmand = new SqlCommand(sql, con); if (commmand.ExecuteNonQuery() > 0) { ketqua = true; } } catch (Exception err) { } finally { con.Close(); } return(ketqua); }
public bool Themhang(BEL_Hang hang) { bool ketqua = false; try { GetCon(); string sql = "INSERT INTO tbHang(MaHang,TenHang,SoLuong,Loai,Gia,NhaCungCap,Hinh,TThai) VALUES('" + hang.MaHang + "',N'" + hang.TenHang + "','" + hang.SoLuong + "','" + hang.Loai + "','" + hang.Gia + "',N'" + hang.NCC + "','" + hang.Hinh + "','" + hang.TThai + "')"; SqlCommand commmand = new SqlCommand(sql, con); if (commmand.ExecuteNonQuery() > 0) { ketqua = true; } } catch (Exception err) { } finally { con.Close(); } return(ketqua); }
public bool CapNhaphang(BEL_Hang hang, string mahang) { var xuly = new DAL_Hang(); return(xuly.CapNhaphang(hang, mahang)); }
public bool Themhang(BEL_Hang hang) { var xuly = new DAL_Hang(); return(xuly.Themhang(hang)); }