public IList <ProductOrderViewModel> GetOrderList(SearchParameter search)
{
var description = "前台获取订购/续费动态列表";
try
{
var tbName = "ProductOrder(nolock) po left join ProductUser(nolock) pu on po.ProductUserId=pu.Id";
var filter = "po.*,pu.ResourceOwner as ProductUserName";
var where = "";
var orderBy = " po.BuyDateTime desc";
var searchPara = search as ProductOrderSearchParameter;
var sqlParameter = new List <SqlParameter>();
var pageCount = DataBaseManager.GetCountString(tbName, where);
RPoney.Log.LoggerManager.Debug(GetType().Name, $"{description}pageCount:{pageCount},参数:{search.SerializeToJSON()}");
search.Count = DataBaseManager.MainDb().ExecuteScalar(pageCount, sqlParameter.ToArray()).CInt(0, false);
if (search.Count > 0)
{
var pageSql = DataBaseManager.GetPageString(tbName, filter, orderBy, where, search.Page, search.PageSize);
RPoney.Log.LoggerManager.Debug(GetType().Name, $"{description}pageSql:{pageSql},参数:{search.SerializeToJSON()}");
return(RPoney.Data.ModelConvertHelper <ProductOrderViewModel> .ToModels(DataBaseManager.MainDb().ExecuteFillDataTable(pageSql, sqlParameter.ToArray())));
}
return(Enumerable.Empty <ProductOrderViewModel>().ToList());
}
catch (Exception ex)
{
RPoney.Log.LoggerManager.Error(GetType().Name, $"{description}异常", ex);
return(Enumerable.Empty <ProductOrderViewModel>().ToList());
}
}
public IList <ShareArticleEntity> GetRecommendShareArticle(SearchParameter search)
{
var description = "获取推荐分享文章";
try
{
var tbName = "ShareArticle(nolock) sa";
var filter = "sa.*";
var where = "";
var orderBy = " UpdatedTime desc";
var searchPara = search as ShareArticleSearchParameter;
var sqlParameter = new List <SqlParameter>();
if (searchPara.ArticleType.HasValue)
{
sqlParameter.Add(new SqlParameter("@ArticleType", SqlDbType.Int)
{
Value = (int)searchPara.ArticleType
});
}
var pageCount = DataBaseManager.GetCountString(tbName, where);
RPoney.Log.LoggerManager.Debug(GetType().Name, $"{description}pageCount:{pageCount},参数:{search.SerializeToJSON()}");
search.Count = DataBaseManager.MainDb().ExecuteScalar(pageCount, sqlParameter.ToArray()).CInt(0, false);
if (search.Count > 0)
{
var pageSql = DataBaseManager.GetPageString(tbName, filter, orderBy, where, search.Page, search.PageSize);
RPoney.Log.LoggerManager.Debug(GetType().Name, $"{description}pageSql:{pageSql},参数:{search.SerializeToJSON()}");
return(RPoney.Data.ModelConvertHelper <ShareArticleEntity> .ToModels(DataBaseManager.MainDb().ExecuteFillDataTable(pageSql, sqlParameter.ToArray())));
}
return(Enumerable.Empty <ShareArticleEntity>().ToList());
}
catch (Exception ex)
{
RPoney.Log.LoggerManager.Error(GetType().Name, $"{description}异常", ex);
return(Enumerable.Empty <ShareArticleEntity>().ToList());
}
}
public IList <SystemDicEntity> GetList(SearchParameter search)
{
var description = "获取全局配置列表";
try
{
var tbName = "[SystemDic](nolock)";
var filter = "*";
var orderBy = "[key] asc";
var where = "";
var searchParameter = search as SystemDicSearchParameter;
var sqlParameter = new List <SqlParameter>();
if (null != searchParameter)
{
if (!string.IsNullOrWhiteSpace(searchParameter.Key))
{
where += " and [key]=@key";
sqlParameter.Add(new SqlParameter("@key", SqlDbType.VarChar)
{
Value = searchParameter.Key
});
}
}
var pageCount = DataBaseManager.GetCountString(tbName, where);
RPoney.Log.LoggerManager.Debug(GetType().Name, $"{description}pageCount:{pageCount},参数:{search.SerializeToJSON()}");
search.Count = DataBaseManager.MainDb().ExecuteScalar(pageCount, sqlParameter.ToArray()).CInt(0, false);
if (search.Count > 0)
{
var pageSql = DataBaseManager.GetPageString(tbName, filter, orderBy, where, search.Page, search.PageSize, search.IsAll);
RPoney.Log.LoggerManager.Debug(GetType().Name, $"{description}pageSql:{pageSql},参数:{search.SerializeToJSON()}");
return(RPoney.Data.ModelConvertHelper <SystemDicEntity> .ToModels(DataBaseManager.MainDb().ExecuteFillDataTable(pageSql, sqlParameter.ToArray())));
}
return(Enumerable.Empty <SystemDicEntity>().ToList());
}
catch (Exception ex)
{
RPoney.Log.LoggerManager.Error(GetType().Name, $"{description}异常", ex);
return(Enumerable.Empty <SystemDicEntity>().ToList());
}
}
public IList <ShareArticleEntity> GetList(SearchParameter search)
{
var description = "获取分享文章列表";
try
{
var tbName = "ShareArticle(nolock) sa";
var filter = "sa.*";
var where = "";
var orderBy = " UpdatedTime desc";
var searchPara = search as ShareArticleSearchParameter;
var sqlParameter = new List <SqlParameter>();
if (!string.IsNullOrWhiteSpace(searchPara.Title))
{
where += " and Title like @Title";
sqlParameter.Add(new SqlParameter("@Title", SqlDbType.NVarChar)
{
Value = $"%{searchPara.Title}%"
});
}
var pageCount = DataBaseManager.GetCountString(tbName, where);
RPoney.Log.LoggerManager.Debug(GetType().Name, $"{description}pageCount:{pageCount},参数:{search.SerializeToJSON()}");
search.Count = DataBaseManager.MainDb().ExecuteScalar(pageCount, sqlParameter.ToArray()).CInt(0, false);
if (search.Count > 0)
{
var pageSql = DataBaseManager.GetPageString(tbName, filter, orderBy, where, search.Page, search.PageSize, search.IsAll);
RPoney.Log.LoggerManager.Debug(GetType().Name, $"{description}pageSql:{pageSql},参数:{search.SerializeToJSON()}");
return(RPoney.Data.ModelConvertHelper <ShareArticleEntity> .ToModels(DataBaseManager.MainDb().ExecuteFillDataTable(pageSql, sqlParameter.ToArray())));
}
return(Enumerable.Empty <ShareArticleEntity>().ToList());
}
catch (Exception ex)
{
RPoney.Log.LoggerManager.Error(GetType().Name, $"{description}异常", ex);
return(Enumerable.Empty <ShareArticleEntity>().ToList());
}
}