/// <summary>
/// lay hang hóa theo ma hang hoa
/// </summary>
/// <param name="giatri"></param>
/// <returns></returns>
public Entities.HienThi_ChiTiet_DonDatHang sp_LayHangHoaTheoMaHangHoa(Entities.HienThi_ChiTiet_DonDatHang giatri)
{
Entities.HienThi_ChiTiet_DonDatHang data = null;
try
{
data = new BizLogic.HangHoaGoiHang().Select(giatri.MaHangHoa);
//string sql = "exec sp_LayHangHoaTheoMaHangHoa @MaHangHoa";
//conn = new Connection();
//cn = conn.openConnection();
//cmd = new SqlCommand(sql, cn);
//cmd.Parameters.Add("MaHangHoa", SqlDbType.NVarChar, 50).Value = giatri.MaHangHoa;
//dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
//while (dr.Read())
//{
// data.MaHangHoa = dr[0].ToString();
// data.TenHangHoa = dr[1].ToString();
// data.SoLuongDat = 1;
// data.GiaGoc = dr[2].ToString();
// data.GiaNhap = dr[2].ToString();
// data.Giabanbuon = dr[3].ToString();
// data.Giabanle = dr[4].ToString();
// data.PhanTramChietKhau = "0";
// data.Thuegiatrigiatang = dr[5].ToString();
// data.ChietKhau = "0";
//}
}
catch (Exception ex)
{ string s = ex.Message.ToString(); data = null; }
return(data);
}
/// <summary>
/// lay hang hóa theo ma hang hoa
/// </summary>
/// <param name="giatri"></param>
/// <returns></returns>
public Entities.HienThi_ChiTiet_DonDatHang sp_LayHangHoaTheoMaHangHoa(Entities.HienThi_ChiTiet_DonDatHang giatri)
{
Entities.HienThi_ChiTiet_DonDatHang data = null;
try
{
data = new BizLogic.HangHoaGoiHang().Select(giatri.MaHangHoa);
//string sql = "exec sp_LayHangHoaTheoMaHangHoa @MaHangHoa";
//conn = new Connection();
//cn = conn.openConnection();
//cmd = new SqlCommand(sql, cn);
//cmd.Parameters.Add("MaHangHoa", SqlDbType.NVarChar, 50).Value = giatri.MaHangHoa;
//dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
//while (dr.Read())
//{
// data.MaHangHoa = dr[0].ToString();
// data.TenHangHoa = dr[1].ToString();
// data.SoLuongDat = 1;
// data.GiaGoc = dr[2].ToString();
// data.GiaNhap = dr[2].ToString();
// data.Giabanbuon = dr[3].ToString();
// data.Giabanle = dr[4].ToString();
// data.PhanTramChietKhau = "0";
// data.Thuegiatrigiatang = dr[5].ToString();
// data.ChietKhau = "0";
//}
}
catch (Exception ex)
{ string s = ex.Message.ToString(); data = null; }
return data;
}
