protected void RG_NeedDataSource(object sender, GridNeedDataSourceEventArgs e) { int totalCount; RefundsMoneyInfo_SeachModel seachModel = new RefundsMoneyInfo_SeachModel() { OrderNumber = OrderNumber, StartTime = StartTime, EndTime = EndTime, Status = Convert.ToInt32(Status), SaleFilialeId = SaleFilialeId, SalePlatformId = SalePlatformId, PageIndex = RG.CurrentPageIndex + 1, PageSize = RG.PageSize, listStatus = new List <int>() { (int)RefundsMoneyStatusEnum.PendingPayment, (int)RefundsMoneyStatusEnum.HadPayment, } }; var list = _refundsMoneySerivce.GetRefundsMoneyList(seachModel, out totalCount); RG.DataSource = list; RG.VirtualItemCount = totalCount; }
/// <summary> /// 获取分页的列表 /// </summary> /// <param name="model"></param> /// <param name="recordCount"></param> /// <returns></returns> public IList <RefundsMoneyInfo> GetRefundsMoneyList(RefundsMoneyInfo_SeachModel model, out int recordCount) { var sqlStr = new StringBuilder(); sqlStr.Append(@"SELECT ID,OrderNumber,ThirdPartyOrderNumber,ThirdPartyAccountName,SalePlatformId,SaleFilialeId,RefundsAmount,BankName,BankAccountNo,UserName, Fees,TransactionNumber,AccountID,RejectReason,Status,CreateTime,CreateUser,IsDelete,ModifyTime,ModifyUser,AfterSalesNumber,Remark FROM RefundsMoney WHERE 1=1 "); #region 筛选条件 if (!string.IsNullOrEmpty(model.OrderNumber)) { sqlStr.Append(" AND (OrderNumber ='").Append(model.OrderNumber).Append("'"); sqlStr.Append(" or ThirdPartyOrderNumber ='").Append(model.OrderNumber).Append("'"); sqlStr.Append(" or AfterSalesNumber ='").Append(model.OrderNumber).Append("')"); } if (model.StartTime.HasValue) { sqlStr.Append(" AND CreateTime >= '").Append(model.StartTime).Append("'"); } if (model.EndTime.HasValue) { sqlStr.Append(" AND CreateTime <= '").Append(model.EndTime).Append("'"); } if (model.Status != 0) { sqlStr.Append(" AND Status =").Append(model.Status); } else if (model.listStatus != null && model.listStatus.Count > 0) { string strStatus = string.Join(",", model.listStatus.ToArray()); sqlStr.Append(" AND Status in(" + strStatus + ")"); } if (model.SalePlatformId != Guid.Empty) { sqlStr.Append(" AND SalePlatformId = '").Append(model.SalePlatformId).Append("'"); } if (model.SaleFilialeId != Guid.Empty) { sqlStr.Append(" AND SaleFilialeId = '").Append(model.SaleFilialeId).Append("'"); } #endregion 筛选条件 using (SqlConnection conn = Databases.GetSqlConnection(GlobalConfig.ERP_DB_NAME, false)) { recordCount = conn.ExecuteScalar <int>(string.Format("select count(*) from ({0}) T", sqlStr.ToString())); var result = conn.QueryPaged <RefundsMoneyInfo>(sqlStr.ToString(), model.PageIndex, model.PageIndex, " ID DESC"); return(result.AsList()); } }
public void TestMethod_GetList() { Init(); int totalCount = 0; var model = new RefundsMoneyInfo_SeachModel() { //OrderNumber = "", //EndTime=DateTime.Now, //SaleFilialeId=Guid.NewGuid(), //SalePlatformId=Guid.NewGuid(), //StartTime=DateTime.Now, //Status=0, PageSize = 10, PageIndex = 1, }; IList <RefundsMoneyInfo> result = _refundsMoneyDal.GetRefundsMoneyList(model, out totalCount); Assert.IsNotNull(result); }
public IList <RefundsMoneyInfo> GetRefundsMoneyList(RefundsMoneyInfo_SeachModel seachModel, out int Totalcount) { return(_refundsMoneyDal.GetRefundsMoneyList(seachModel, out Totalcount)); }