public bool UpdateData(DTO.CTHDDTO chiTietHoaDon)
{
string query = string.Format("EXEC UPDATE_SOLUONG_MASP_MAHD @MAHD = '{0}',@MASP ='{1}',@SOLUONG = {2}", chiTietHoaDon.MaHD, chiTietHoaDon.MaSP, chiTietHoaDon.SoLuong);
int result = DataProvider.Instance.ExecuteNonQuery(query);
return(result > 0);
}
public bool InsertData(DTO.CTHDDTO chiTietHoaDon)
{
//string query = string.Format("INSERT INTO dbo.CTHD( MAHD, MASP, SOLUONG )VALUES ( '{0}','{1}',{2})",chiTietHoaDon.MaHD,chiTietHoaDon.MaSP,chiTietHoaDon.SoLuong);
string query = string.Format("EXEC dbo.INSERT_CTHD @MAHD = '{0}',@MASP = '{1}',@SOLUONG = {2}", chiTietHoaDon.MaHD, chiTietHoaDon.MaSP, chiTietHoaDon.SoLuong);
int result = DataProvider.Instance.ExecuteNonQuery(query);
return(result > 0);
}
public int GetSoLuongByMaSPAndMaHD(string maSP, string maHD)
{
//string query = string.Format("SELECT * FROM CTHD WHERE MASP = '{0}' AND MAHD='{1}'", maSP,maHD);
string query = string.Format("EXEC LOAD_CTHD_BYMASP_MAHD @MASP = '{0}', @MAHD ='{1}'", maSP, maHD);
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
DTO.CTHDDTO cthd = new DTO.CTHDDTO(item);
return(cthd.SoLuong);
}
return(0);
}
public List <DTO.CTHDDTO> LoadChiTietHoaDonByMaHD(string maHD)
{
List <DTO.CTHDDTO> cthdList = new List <DTO.CTHDDTO>();
//string query = string.Format("SELECT * FROM dbo.CTHD WHERE MAHD = '{0}'",maHD);
string query = string.Format("EXEC dbo.LOAD_CTHD_MAHD @MAHD = '{0}'", maHD);
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
DTO.CTHDDTO cthd = new DTO.CTHDDTO(item);
cthdList.Add(cthd);
}
return(cthdList);
}
public bool InsertCTHD(string maHD, string maSP, int soLuong)
{
DTO.CTHDDTO cthd = new DTO.CTHDDTO(maHD, maSP, soLuong);
return(DAL.CTHDDAL.Instance.InsertData(cthd));
}