public static void SuaHangJoa(Hanghoa hh) { SqlConnection conn = SqlConnect.Connect(); SqlCommand cmd = new SqlCommand("SUA_HANG_HOA", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MA_HANG", SqlDbType.Int); cmd.Parameters.Add("@TEN_HANG", SqlDbType.NVarChar, 50); cmd.Parameters.Add("@MA_NUOC_SX", SqlDbType.Int); cmd.Parameters.Add("@KICH_THUOC", SqlDbType.NVarChar, 50); cmd.Parameters.Add("@MA_LOAI_HANG", SqlDbType.Int); cmd.Parameters.Add("@DON_VI_TINH", SqlDbType.NVarChar, 50); cmd.Parameters.Add("@LUONG_TON", SqlDbType.Int); cmd.Parameters.Add("@MA_KHO", SqlDbType.Int); cmd.Parameters["@MA_HANG"].Value = hh.Mahang; cmd.Parameters["@TEN_HANG"].Value = hh.Tenhang; cmd.Parameters["@MA_NUOC_SX"].Value = hh.Manuocsx; cmd.Parameters["@KICH_THUOC"].Value = hh.Kichthuoc; cmd.Parameters["@MA_LOAI_HANG"].Value = hh.Maloaihang; cmd.Parameters["@DON_VI_TINH"].Value = hh.Donvitinh; cmd.Parameters["@LUONG_TON"].Value = hh.Luongton; cmd.Parameters["@MA_KHO"].Value = hh.Makho; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); }
public static void ThemLoaiHang(LoaiHang Lh) { SqlConnection conn = SqlConnect.Connect(); SqlCommand cmd = new SqlCommand("THEM_LOAI_HANG", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@LOAI_HANG", SqlDbType.NVarChar, 50); cmd.Parameters["@LOAI_HANG"].Value = Lh.Tenlh; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); }
public static void XoaKho(int makho) { SqlConnection conn = SqlConnect.Connect(); SqlCommand cmd = new SqlCommand("XOA_KHO", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MA_KHO", SqlDbType.Int); cmd.Parameters["@MA_KHO"].Value = makho; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); }
public static void XoaLoaiHang(int maLh) { SqlConnection conn = SqlConnect.Connect(); SqlCommand cmd = new SqlCommand("XOA_LOAI_HANG", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MA_LOAI_HANG", SqlDbType.Int); cmd.Parameters["@MA_LOAI_HANG"].Value = maLh; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); }
public static DataView getAll() { SqlConnection connection = SqlConnect.Connect(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand("NuocSX_getAll", connection); da.SelectCommand.CommandType = CommandType.StoredProcedure; DataTable dt = new DataTable(); da.Fill(dt); DataView dv = new DataView(dt); return(dv); }
public static DataSet getHangHoa() { SqlConnection conn = SqlConnect.Connect(); SqlCommand command = new SqlCommand("SELECT MA_HANG,TEN_HANG FROM Danh_Muc_Hang_Hoa", conn); conn.Open(); SqlDataAdapter da = new SqlDataAdapter(command); da.SelectCommand = command; DataSet dt = new DataSet(); da.Fill(dt); conn.Close(); return(dt); }
public static DataSet getNuocsx() { SqlConnection conn = SqlConnect.Connect(); SqlCommand command = new SqlCommand("SELECT * FROM Nuoc_SX", conn); conn.Open(); SqlDataAdapter da = new SqlDataAdapter(command); da.SelectCommand = command; DataSet dt = new DataSet(); da.Fill(dt); conn.Close(); return(dt); }
public static DataSet getMakho() { SqlConnection conn = SqlConnect.Connect(); SqlCommand command = new SqlCommand("SELECT MA_KHO, TEN_KHO FROM Danh_Muc_Kho", conn); conn.Open(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = command; DataSet dt = new DataSet(); da.Fill(dt); conn.Close(); return(dt); }
public static DataTable loadHanghoa() { SqlConnection conn = SqlConnect.Connect(); SqlCommand command = new SqlCommand("XEM_KHO", conn); command.CommandType = CommandType.StoredProcedure; conn.Open(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = command; DataTable dt = new DataTable(); da.Fill(dt); conn.Close(); return(dt); }
public static DataView chiTietPhieuNhap_find(int mapn) { SqlConnection connection = SqlConnect.Connect(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand("chiTietPhieuNhap_find", connection); da.SelectCommand.Parameters.Add("@mapn", SqlDbType.Int); da.SelectCommand.Parameters["@mapn"].Value = mapn; da.SelectCommand.CommandType = CommandType.StoredProcedure; DataTable dt = new DataTable(); da.Fill(dt); DataView dv = new DataView(dt); return(dv); }
public static void ThemKhachHang(KhachHang kh) { SqlConnection conn = SqlConnect.Connect(); SqlCommand cmd = new SqlCommand("THEM_KH", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@TEN_KH", SqlDbType.NVarChar, 50); cmd.Parameters.Add("@DIA_CHI", SqlDbType.NVarChar, 50); cmd.Parameters.Add("@DIEN_THOAI", SqlDbType.NVarChar, 50); cmd.Parameters["@TEN_KH"].Value = kh.Tenkh; cmd.Parameters["@DIA_CHI"].Value = kh.Diachi; cmd.Parameters["@DIEN_THOAI"].Value = kh.Dienthoai; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); }
public static bool delete(string manuoc) { SqlConnection connection = SqlConnect.Connect(); connection.Open(); SqlCommand cmd = new SqlCommand("NuocSX_delete", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@maNuoc", Int32.Parse(manuoc))); int msg = cmd.ExecuteNonQuery(); if (msg > 0) { return(true); } else { return(false); } }
public static bool insert(string tennuoc) { SqlConnection connection = SqlConnect.Connect(); connection.Open(); SqlCommand cmd = new SqlCommand("NuocSX_insert", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@tenNuoc", tennuoc)); int msg = cmd.ExecuteNonQuery(); if (msg > 0) { return(true); } else { return(false); } }
public static bool delete(int mapn) { SqlConnection connection = SqlConnect.Connect(); connection.Open(); SqlCommand cmd = new SqlCommand("ChiTietPhieuNhap_delete", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@mapn", mapn)); int msg = cmd.ExecuteNonQuery(); if (msg > 0) { return(true); } else { return(false); } }
public static bool PhieuNhap_add(PhieuNhap phieuNhap) { SqlConnection connection = SqlConnect.Connect(); connection.Open(); SqlCommand cmd = new SqlCommand("PhieuNhap_insert", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@ngayNhap", new SqlDateTime(phieuNhap.NgayNhap))); cmd.Parameters.Add(new SqlParameter("@maNCC", phieuNhap.MaNCC)); cmd.Parameters.Add(new SqlParameter("@maKho", phieuNhap.MaKho)); int msg = cmd.ExecuteNonQuery(); if (msg > 0) { return(true); } else { return(false); } }
public static bool insert(PhieuXuat phieuxuat) { SqlConnection connection = SqlConnect.Connect(); connection.Open(); SqlCommand cmd = new SqlCommand("PhieuXuat_insert", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@ngayXuat", new SqlDateTime(phieuxuat.NgayXuat))); cmd.Parameters.Add(new SqlParameter("@lyDo", phieuxuat.LyDo)); cmd.Parameters.Add(new SqlParameter("@maKho", phieuxuat.MaKho)); cmd.Parameters.Add(new SqlParameter("@maKH", phieuxuat.MaKhachHang)); int msg = cmd.ExecuteNonQuery(); if (msg > 0) { return(true); } else { return(false); } }
public static bool add(ChiTietPhieuXuat chiTiet) { SqlConnection connection = SqlConnect.Connect(); connection.Open(); SqlCommand cmd = new SqlCommand("ChiTietPhieuXuat_add", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@maPX", chiTiet.MaPhieuXuat)); cmd.Parameters.Add(new SqlParameter("@maHang", chiTiet.MaHang)); cmd.Parameters.Add(new SqlParameter("@soLuong", chiTiet.SoLuong)); cmd.Parameters.Add(new SqlParameter("@donGia", chiTiet.DonGia)); int msg = cmd.ExecuteNonQuery(); if (msg > 0) { return(true); } else { return(false); } }
public static bool insert(NhaCungCap ncc) { SqlConnection connection = SqlConnect.Connect(); connection.Open(); SqlCommand cmd = new SqlCommand("NhaCungCap_insert", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@tenNhaCC", ncc.tenNhaCC)); cmd.Parameters.Add(new SqlParameter("@diachi", ncc.diachi)); cmd.Parameters.Add(new SqlParameter("@dienthoai", ncc.dienthoai)); cmd.Parameters.Add(new SqlParameter("@maNuoc", ncc.maNuoc)); int msg = cmd.ExecuteNonQuery(); if (msg > 0) { return(true); } else { return(false); } }
public static void SuaKho(KhoHang kh) { SqlConnection conn = SqlConnect.Connect(); SqlCommand cmd = new SqlCommand("SUA_KHO", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MA_KHO", SqlDbType.Int); cmd.Parameters.Add("@TEN_KHO", SqlDbType.NVarChar, 50); cmd.Parameters.Add("@DIA_CHI", SqlDbType.NVarChar, 50); cmd.Parameters.Add("@SDT", SqlDbType.NVarChar, 50); cmd.Parameters.Add("@TEN_THU_KHO", SqlDbType.NVarChar, 50); cmd.Parameters["@MA_KHO"].Value = kh.Makho; cmd.Parameters["@TEN_KHO"].Value = kh.Tenkho; cmd.Parameters["@DIA_CHI"].Value = kh.Diachi; cmd.Parameters["@SDT"].Value = kh.Dienthoai; cmd.Parameters["@TEN_THU_KHO"].Value = kh.Tenthukho; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); }
public static bool insert(ChiTietPhieuNhap ctpn) { SqlConnection connection = SqlConnect.Connect(); connection.Open(); SqlCommand cmd = new SqlCommand("ChiTietPhieuNhap_insert", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@mapn", ctpn.MaPhieuNhap)); cmd.Parameters.Add(new SqlParameter("@mahang", ctpn.MaHang)); cmd.Parameters.Add(new SqlParameter("@slgia", ctpn.SlTheoChungTu)); cmd.Parameters.Add(new SqlParameter("@slthuc", ctpn.SlThuc)); cmd.Parameters.Add(new SqlParameter("@dongia", ctpn.DonGia)); int msg = cmd.ExecuteNonQuery(); if (msg > 0) { return(true); } else { return(false); } }