/// <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));
}
