public async Task <RpcResult <GetProductRes> > GetProduct(GetProductReq req)
{
var result = new RpcResult <GetProductRes>();
try
{
await Task.CompletedTask;
//await Task.Delay(1);
var userService = _rpcServiceProxy.GetService <IUserService>();
var user = await userService.GetUser(new UserService.DTO.GetUserReq {
UserId = req.ProductId
});
result.Data = new GetProductRes
{
ProductId = req.ProductId,
ProductName = "商品名称" + req.ProductId,
Price = 100.50M
};
}
catch (Exception ex)
{
result.Code = ExceptionCode.INTETNAL_ERROR;
result.Message = "内部错误";
}
return(result);
}
/// <summary>
/// 1a: danh sách sản phẩm
/// </summary>
/// <param name="req"></param>
/// <returns>danh sách sản phẩm không có đơn hàng</returns>
public List <object> ProductNotOrder(GetProductReq req)
{
List <object> res = new List <object>();
var cnn = (SqlConnection)Context.Database.GetDbConnection();
if (cnn.State == ConnectionState.Closed)
{
cnn.Open();
}
try
{
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
var cmd = cnn.CreateCommand();
cmd.CommandText = "sp_ProductsNotOrder";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@date", req.Date);
cmd.Parameters.AddWithValue("@page", req.Page);
cmd.Parameters.AddWithValue("@size", req.Size);
da.SelectCommand = cmd;
da.Fill(ds);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
var x = new
{
STT = row["STT"],
ProductId = row["ProductId"],
ProductName = row["ProductName"],
SupplierId = row["SupplierId"],
CategoryId = row["CategoryId"],
QuantityPerUnit = row["QuantityPerUnit"],
UnitPrice = row["UnitPrice"],
UnitsInStock = row["UnitsInStock"],
UnitsOnOrder = row["UnitsOnOrder"],
ReorderLevel = row["ReorderLevel"],
Discontinued = row["Discontinued"]
};
res.Add(x);
}
}
}
catch (Exception ex)
{
res = null;
}
return(res);
}
public List <object> ProductNotOrder(GetProductReq req)
{
return(_rep.ProductNotOrder(req));
}
public IActionResult ProductNotOrder([FromBody] GetProductReq req)
{
var res = _svc.ProductNotOrder(req);
return(Ok(res));
}
