/// <summary> /// Hàm tìm kiếm tuyệt đối với bảng sản phẩm trong csdl /// </summary> /// <param name="sanPham"></param> /// <returns></returns> public DataTable SearchDataAbsolute(DTO.SanPhamDTO sanPham) { string query = string.Format("EXEC TIMKIEM_SANPHAM_TUYETDOI @MASP = '{0}',@TENSP =N'{1}',@SOLUONGTONKHO = {2},@NGAYSX='{3}',@HANSUDUNG='{4}',@DONGIA ={5},@MOTA=N'{6}',@MANSX='{7}',@MANCC='{8}'", sanPham.MaSP, sanPham.TenSP, sanPham.SoLuongTonKho, sanPham.NgaySX, sanPham.HanSuDung, sanPham.DonGia, sanPham.MoTa, sanPham.MaNSX, sanPham.MaNCC); return(DataProvider.Instance.ExecuteQuery(query)); }
public bool Insert(DTO.SanPhamDTO data) { string query = string.Format("EXEC dbo.INSERT_SP '{0}', N'{1}', {2}, '{3}', '{4}', {5}, N'{6}', '{7}', '{8}'", data.MaSP, data.TenSP, data.SoLuongTonKho, data.NgaySanXuat, data.HanSuDung, data.DonGia, data.MoTa, data.MaCC, data.MaSX); int result = DataProvider.Instance.ExecuteNonQuery(query); return(result > 0); }
/// <summary> /// Hàm thực hiện thêm dữ liệu trong bảng SANPHAM /// </summary> /// <param name="sanPham"></param> /// <returns></returns> public bool InsertData(DTO.SanPhamDTO sanPham) { string query = string.Format("EXEC UPDATE_SANPHAM @MASP= '{8}',@TENSP='{0}',@SOLUONGTONKHO ={1} ,@NGAYSX ='{2}',@HANSUDUNG ='{3}',@DONGIA = {4},@MOTA ='{5}',@MANSX ='{6}',@MANCC ='{7}'", sanPham.TenSP, sanPham.SoLuongTonKho, sanPham.NgaySX, sanPham.HanSuDung, sanPham.DonGia, sanPham.MoTa, sanPham.MaNSX, sanPham.MaNCC, sanPham.MaSP); int result = DataProvider.Instance.ExecuteNonQuery(query); return(result > 0); }
public int GetSoLuongTonKhoByMaSP(string maSP) { string query = string.Format("SELECT MASP,TENSP,SOLUONGTONKHO,CONVERT(VARCHAR(10),NGAYSX)AS NGAYSX,CONVERT(VARCHAR(10),HANSUDUNG)AS HANSUDUNG,DONGIA,MOTA,MANSX,MANCC FROM SANPHAM WHERE MASP = '{0}'", maSP); DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in data.Rows) { DTO.SanPhamDTO sanPham = new DTO.SanPhamDTO(item); return(sanPham.SoLuongTonKho); } return(0); }
/// <summary> /// Hàm Update sản phẩm trong csdl /// </summary> /// <param name="maSP"></param> /// <param name="tenSP"></param> /// <param name="soLuongTonKho"></param> /// <param name="ngaySX"></param> /// <param name="hanSuDung"></param> /// <param name="donGia"></param> /// <param name="moTa"></param> /// <param name="maNSX"></param> /// <param name="maNCC"></param> /// <returns></returns> public bool UpdateData(string maSP, string tenSP, int soLuongTonKho, string ngaySX, string hanSuDung, int donGia, string moTa, string maNSX, string maNCC) { if (maSP.Length == 0 || tenSP.Length == 0 || ngaySX.Length == 0 || hanSuDung.Length == 0 || moTa.Length == 0 || maNSX.Length == 0 || maNCC.Length == 0 || soLuongTonKho.ToString().Length == 0 || donGia.ToString().Length == 0) { return(false); } else { DTO.SanPhamDTO sanPham = new DTO.SanPhamDTO(maSP, tenSP, soLuongTonKho, ngaySX, hanSuDung, donGia, moTa, maNSX, maNCC); return(DAL.SanPhamDAL.Instance.UpdateData(sanPham)); } }
/// <summary> /// Hàm tìm kiếm tuyệt đối /// </summary> /// <param name="maSP"></param> /// <param name="tenSP"></param> /// <param name="soLuongTonKho"></param> /// <param name="ngaySX"></param> /// <param name="hanSuDung"></param> /// <param name="donGia"></param> /// <param name="moTa"></param> /// <param name="maNSX"></param> /// <param name="maNCC"></param> /// <returns></returns> public DataTable SearchDataAbsolute(string maSP, string tenSP, int soLuongTonKho, string ngaySX, string hanSuDung, int donGia, string moTa, string maNSX, string maNCC) { if (maSP.Length == 0 || tenSP.Length == 0 || ngaySX.Length == 0 || hanSuDung.Length == 0 || moTa.Length == 0 || maNSX.Length == 0 || maNCC.Length == 0 || soLuongTonKho.ToString().Length == 0 || donGia.ToString().Length == 0) { return(null); } else { DTO.SanPhamDTO sanPham = new DTO.SanPhamDTO(maSP, tenSP, soLuongTonKho, ngaySX, hanSuDung, donGia, moTa, maNSX, maNCC); return(DAL.SanPhamDAL.Instance.SearchDataAbsolute(sanPham)); } }
public bool Insert(string maSp, string tenSP, int soLuong, string ngaySX, string hanSD, double donGia, string moTa, string maNCC, string maNSX) { DTO.SanPhamDTO sanPham = new DTO.SanPhamDTO(maSp, tenSP, soLuong, ngaySX, hanSD, donGia, moTa, maNCC, maNSX); return(DAL.SanPhamDAL.Instance.Insert(sanPham)); }