protected void RG_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
int totalCount;
SubsidyPaymentInfo_SeachModel seachModel = new SubsidyPaymentInfo_SeachModel()
{
OrderNumber = OrderNumber,
StartTime = StartTime,
EndTime = EndTime,
Status = Convert.ToInt32(Status),
SaleFilialeId = SaleFilialeId,
SalePlatformId = SalePlatformId,
SubsidyType = Convert.ToInt32(SubsidyType),
PageIndex = RG.CurrentPageIndex + 1,
PageSize = RG.PageSize,
listStatus = new List <int>()
{
(int)SubsidyPaymentStatusEnum.PendingPayment, (int)SubsidyPaymentStatusEnum.HadPayment, (int)SubsidyPaymentStatusEnum.Rejected,
}
};
var list = _SubsidyPaymentSerivce.GetSubsidyPaymentList(seachModel, out totalCount);
RG.DataSource = list;
RG.VirtualItemCount = totalCount;
}
/// <summary>
/// 获取分页的列表
/// </summary>
/// <param name="model"></param>
/// <param name="recordCount"></param>
/// <returns></returns>
public IList <SubsidyPaymentInfo> GetSubsidyPaymentList(SubsidyPaymentInfo_SeachModel model, out int recordCount)
{
var sqlStr = new StringBuilder();
sqlStr.Append(@"SELECT ID,OrderNumber,ThirdPartyOrderNumber,ThirdPartyAccountName,SalePlatformId,SaleFilialeId,OrderAmount,SubsidyAmount,SubsidyType,QuestionType,QuestionName,BankName,BankAccountNo,UserName,RejectReason,Status,CreateTime,CreateUser,IsDelete,ModifyTime,ModifyUser,Fees,TransactionNumber,AccountID,Remark
FROM SubsidyPayment
WHERE 1=1 ");
if (!string.IsNullOrEmpty(model.OrderNumber))
{
sqlStr.Append(" AND (OrderNumber ='").Append(model.OrderNumber).Append("'");
sqlStr.Append(" or ThirdPartyOrderNumber ='").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("'");
}
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 <SubsidyPaymentInfo>(sqlStr.ToString(), model.PageIndex, model.PageSize, "ModifyTime DESC");
return(result.AsList());
}
}
public void TestMethod_GetList()
{
Init();
int totalCount = 0;
var model = new SubsidyPaymentInfo_SeachModel()
{
//OrderNumber = "",
//EndTime=DateTime.Now,
//SaleFilialeId=Guid.NewGuid(),
//SalePlatformId=Guid.NewGuid(),
//StartTime=DateTime.Now,
//Status=0,
PageSize = 10,
PageIndex = 1,
};
IList <SubsidyPaymentInfo> result = _SubsidyPaymentDal.GetSubsidyPaymentList(model, out totalCount);
Assert.IsNotNull(result);
}
public IList <SubsidyPaymentInfo> GetSubsidyPaymentList(SubsidyPaymentInfo_SeachModel seachModel, out int Totalcount)
{
return(_subsidyPaymentDal.GetSubsidyPaymentList(seachModel, out Totalcount));
}
