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