public string ToUser_1_3()
{
ApiResult result = new ApiResult();
try
{
var UserNumber = ZNRequest.GetString("UserNumber");
if (string.IsNullOrWhiteSpace(UserNumber))
{
result.message = new { records = 0, totalpage = 1 };
return(JsonConvert.SerializeObject(result));
}
var query = new SubSonic.Query.Select(provider).From <Order>().Where <Order>(x => x.Status == Enum_Status.Approved);
query = query.And("CreateUserNumber").IsEqualTo(UserNumber);
var recordCount = query.GetRecordCount();
if (recordCount == 0)
{
result.message = new { records = 0, totalpage = 1 };
return(JsonConvert.SerializeObject(result));
}
var pager = new Pager();
var totalPage = recordCount % pager.Size == 0 ? recordCount / pager.Size : recordCount / pager.Size + 1;
var list = query.Paged(pager.Index, pager.Size).OrderDesc("ID").ExecuteTypedList <Order>();
var userarray = list.Select(x => x.ToUserNumber).Distinct().ToList();
var allusers = new SubSonic.Query.Select(provider, "ID", "NickName", "Avatar", "Number", "Cover").From <User>().And("Number").In(userarray.ToArray()).ExecuteTypedList <User>();
List <OrdersJson> newlist = new List <OrdersJson>();
list.ForEach(x =>
{
var user = allusers.FirstOrDefault(y => y.Number == x.ToUserNumber);
if (user != null)
{
OrdersJson model = new OrdersJson();
model.ID = x.ID;
model.CreateDate = x.CreateDate.ToString("yyyy-MM-dd hh:mm:ss");
model.Price = x.Price;
model.UserID = user.ID;
model.UserNumber = user.Number;
model.UserAvatar = user.Avatar;
model.UserName = user.NickName;
model.UserCover = user.Cover;
newlist.Add(model);
}
});
result.result = true;
result.message = new
{
currpage = pager.Index,
records = recordCount,
totalpage = totalPage,
list = newlist
};
}
catch (Exception ex)
{
LogHelper.ErrorLoger.Error("Api_Order_ToUser_1_3:" + ex.Message);
result.message = ex.Message;
}
return(JsonConvert.SerializeObject(result));
}
public static async Task <List <RestockOrder> > GetRestockOrdersJSON()
{
WebRequest request = WebRequest.Create(orders);
request.Method = "GET";
try
{
return(await Task.Factory.StartNew(() =>
{
HttpWebResponse response = request.GetResponse() as HttpWebResponse;
var encod = ASCIIEncoding.ASCII;
using var readOrders = new System.IO.StreamReader(response.GetResponseStream(), encod);
myjson = readOrders.ReadToEnd();
OrdersJson cs = JsonConvert.DeserializeObject <OrdersJson>(myjson);
foreach (var order in cs.Orders)
{
WebRequest productsRequest = WebRequest.Create(products + order.Id);
productsRequest.Method = "GET";
HttpWebResponse productResponse = productsRequest.GetResponse() as HttpWebResponse;
using var readProducts = new System.IO.StreamReader(productResponse.GetResponseStream(), encod);
myjson = readProducts.ReadToEnd();
OrdersProductsJson opj = JsonConvert.DeserializeObject <OrdersProductsJson>(myjson);
order.RequiredProducts = opj.Products;
}
return cs.Orders;
}));
}
catch (Exception)
{
return(new List <RestockOrder>());
}
}
public string Apply_1_3()
{
ApiResult result = new ApiResult();
try
{
var UserNumber = ZNRequest.GetString("UserNumber");
if (string.IsNullOrWhiteSpace(UserNumber))
{
result.message = new { records = 0, totalpage = 1 };
return(JsonConvert.SerializeObject(result));
}
var query = new SubSonic.Query.Select(provider).From <ApplyMoney>().Where <ApplyMoney>(x => x.Status == Enum_Status.Approved);
query = query.And("CreateUserNumber").IsEqualTo(UserNumber);
var recordCount = query.GetRecordCount();
if (recordCount == 0)
{
result.message = new { records = 0, totalpage = 1 };
return(JsonConvert.SerializeObject(result));
}
var pager = new Pager();
var totalPage = recordCount % pager.Size == 0 ? recordCount / pager.Size : recordCount / pager.Size + 1;
var list = query.Paged(pager.Index, pager.Size).OrderDesc("ID").ExecuteTypedList <ApplyMoney>();
List <OrdersJson> newlist = new List <OrdersJson>();
list.ForEach(x =>
{
OrdersJson model = new OrdersJson();
model.ID = x.ID;
model.CreateDate = x.CreateDate.ToString("yyyy-MM-dd hh:mm:ss");
model.Price = Tools.SafeInt(System.Configuration.ConfigurationManager.AppSettings["applymoney"]) * 100;
newlist.Add(model);
});
result.result = true;
result.message = new
{
currpage = pager.Index,
records = recordCount,
totalpage = totalPage,
list = newlist
};
}
catch (Exception ex)
{
LogHelper.ErrorLoger.Error("Api_Order_Apply_1_3:" + ex.Message);
result.message = ex.Message;
}
return(JsonConvert.SerializeObject(result));
}
