public ActionResult Index(int?pageIndex) { pageIndex = pageIndex ?? 1; int totalCount = 0; var listUsers = withDrawDao.GetPaged(10, pageIndex.Value, out totalCount, "1=1"); JArray list = new JArray(); if (listUsers != null) { list = JArray.FromObject(listUsers); } //if (list.Count > 0) //{ // foreach (var item in list) // { // item["BaseRealName"] = "--"; // var BaseUserId = item["BaseUserId"].ToInt(); // if (BaseUserId != 0) // { // Users user = userDao.Single(BaseUserId); // item["BaseRealName"] = user.RealName; // } // } //} return(View(new ResultModel(list, totalCount))); }
public string QueryWithDrawList(int cid = 0, int UserId = 0, int pageIndex = 1, int pageSize = 10, int State = 0) { #region 验证参数 if (UserId <= 0) { return(ApiReturnStr.getError(-100, "用户ID不能为0")); } if (pageIndex < 1) { return(ApiReturnStr.getError(-100, "页码不能小于1")); } if (pageSize < 1) { return(ApiReturnStr.getError(-100, "每页数量不能小于1")); } #endregion int totalCount = 0; object param = null; string where = "UserId=@UserId "; if (State != -200) { where += " and State=@State "; param = new { UserId, State }; } else { where += " and State<>0 "; param = new { UserId }; } var listpay = withDrawDao.GetPaged(pageSize, pageIndex, out totalCount, where, param, "order by CTime desc"); JArray list = new JArray(); if (listpay != null && listpay.Count > 0) { foreach (var item in listpay) { JObject obj = new JObject(); obj["Amount"] = item.Amount.ToString("F2"); obj["Receiver"] = item.Receiver; obj["Fee"] = item.Fee.ToString("F2"); obj["BasicFee"] = item.BasicFee.ToString("F2"); obj["ActualAmount"] = item.ActualAmount.ToString("F2"); obj["ReceiverBankCardNo"] = Util.GetHiddenString(item.ReceiverBankCardNo, 6, 4); obj["ReceiverBank"] = item.ReceiverBank; obj["CTime"] = item.CTime.ToString("yyyy-MM-dd HH:mm:ss"); obj["HandleTime"] = item.State != 0 ? item.HandleTime.ToString("yyyy-MM-dd HH:mm:ss") : ""; obj["State"] = ((WithDrawState)item.State).ToString(); obj["Message"] = item.State < 0 ? "" : item.Message; list.Add(obj); } } return(ApiReturnStr.getApiDataListByPage(list, totalCount, pageIndex, pageSize)); }