//[ResponseType(typeof(Models.Return.R_Users.R_GetRechargeApplyList))] public Task <IApiResult <R_Users.GetRechargeApplyList_Result> > GetRechargeApplyList([FromUri] P_Users.P_GetRechargeApplyList pars) { pars.SetHost(Request.RequestUri.Host, Request.RequestUri.Port); return(ApiAsync <P_Users.P_GetRechargeApplyList, R_Users.GetRechargeApplyList_Result>(pars, new BLL.UsersManager.Users().GetRechargeApplyList)); }
public Task <IApiResult <R_Users.GetRechargeApplyList_Result> > GetRechargeApplyList(P_Users.P_GetRechargeApplyList arg) { return(Task.Run(() => { IApiResult <R_Users.GetRechargeApplyList_Result> ar = new IApiResult <R_Users.GetRechargeApplyList_Result>(); try { string host = ""; var prot = 80; arg.GetHost(out host, out prot); if (prot != 80) { host += ":" + prot + "/"; } //select new //{ // r.RID, // r.IsCheck, // r.Created, // r.Bank, // r.PaymentMethod, // Rroof = host + r.ProofImg, // r.TransferTime, // u.UserName, // u.UserID //}; using (DAL.CarRentEntities db = new DAL.CarRentEntities()) { var rr = from r in db.RechargeRecord join u in db.Users on r.UserID equals u.UserID where r.Deleted == false select new Models.Return.R_Users.GetRechargeApplyList_Result.GetRechargeApplyList_PageList { PaymentMethod = r.PaymentMethod, IsCheck = r.IsCheck, TransferMethod = r.TransferMethod, RID = r.RID, Proof = host + r.ProofImg, TransferTime = r.TransferTime, UserID = u.UserID, UserName = u.UserName, Remark = r.Remark, Fee = r.Money, Created = r.Created }; if (arg.type != 2) { bool a = arg.type == 1 ? true : false; rr = rr.Where(r => r.IsCheck == a); } if (arg.start_time != null) { rr.Where(r => r.TransferTime >= arg.start_time); } if (arg.end_time != null) { rr.Where(r => r.TransferTime <= arg.end_time); } if (arg.transfer_method != null) { rr.Where(r => r.PaymentMethod == arg.transfer_method); } int count = rr.Count(); var index = (arg.p - 1) * arg.pagesize; var list = rr.OrderBy((r) => r.RID).Skip(index).Take(arg.pagesize).ToList(); list.ForEach((s) => { s.RowIndex = ++index; }); ar.message = $"There are {count} data"; //ar.result = new //{ // total = count, // pages = Math.Ceiling(count/arg.pagesize+0.0) + 1, // list = list //}; ar.result = new R_Users.GetRechargeApplyList_Result { total = count, list = list, pages = count % arg.pagesize == 0 ? count / arg.pagesize : count / arg.pagesize + 1, }; } } catch (Exception ex) { Log.Error(this, ex); ar.code = Interface.StatusCode.error; ar.message = ex.Message; } return ar; })); }