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