/// <summary>
/// 分享链接对应奖励
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public List <ShareCoinAndCount> GetShareCoinList(long userID, ref int count)
{
DataSet ds = dal.GetShareCoinList(userID);
count = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
return(ModelConvertHelper <ShareCoinAndCount> .ConvertToList(ds.Tables[1]));
}
/// <summary>
/// 获取评论列表
/// </summary>
/// <param name="mainID"></param>
/// <param name="mainType">评论对象类型(1贴吧 2文章 3活动 4礼物 5招聘 6求职 7产品服务 8数据分析 9课程)</param>
/// <param name="priseType">点赞类型</param>
/// <param name="userID"></param>
/// <param name="page"></param>
/// <returns></returns>
public _Comments GetCommentCallBack(long mainID, int mainType, int priseType, long userID, Paging page, int sbiMainType = 0)
{
_Comments comments = new _Comments()
{
Comments = new List <_Comment>()
};
//获取问题对应评论
DataSet ds = CommentBLL.Instance.GetCommentsByType(mainID, userID, mainType, sbiMainType, priseType, page.StartIndex, page.EndIndex);
int recordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
if (recordCount > 0)
{
page.RecordCount = recordCount;
comments.Comments = ModelConvertHelper <_Comment> .ConvertToList(ds.Tables[1]);
//获取评论的回复
comments.Comments.ForEach(item =>
{
//(非回答作者)如果该回答需要付费并且没有付过费，则先不加载评论的回复
if (item.CommentUserID == userID || item.IsHideOrFeeToSee != 1 || item.IsFeeAnswer)
{
item.ReplyList = ModelConvertHelper <_ReplyComment> .ConvertToList(dal.GetReplyList(item.CommentId, userID, mainType, priseType));
}
});
}
comments.CommentPage = page;
return(comments);
}
/// <summary>
/// 获取月度签到榜
/// </summary>
/// <returns></returns>
public List <SignUserViewModel> GetSignUsersByMonth()
{
DateTime time = DateTime.Now;
DataTable dt = dal.GetSignUsersByMonth(time.AddDays(-time.Day + 1).Date, time);
return(ModelConvertHelper <SignUserViewModel> .ConvertToList(dt));
}
/// <summary>
/// 获取网站所有客服
/// </summary>
/// <returns></returns>
public CustomerVM GetCustomers()
{
var list = new CustomerVM();
var cache = CSharpCacheHelper.Get(APPConst.Customoer);
if (cache == null)
{
var type1 = CustomerEnumType.QQ.GetHashCode();
var type2 = CustomerEnumType.WeChar.GetHashCode();
var type3 = CustomerEnumType.WeChar_GZH.GetHashCode();
var dt = dal.GetCustomers();
var request = ModelConvertHelper <Customer> .ConvertToList(dt).OrderByDescending(a => a.CreateTime).ToList();
list.QQs = request.Where(a => a.Type == type1).ToList();
list.WXs = request.Where(a => a.Type == type2).ToList();
list.GZHs = request.Where(a => a.Type == type3).ToList();
CSharpCacheHelper.Set(APPConst.Customoer, list, APPConst.ExpriseTime.Week1);
return(list);
}
else
{
return((CustomerVM)cache);
}
}
public List <_Article> GetAllArticles(int startIndex, int endIndex, long tagid = 0)
{
DataSet ds = dal.GetAllArticles(startIndex, endIndex, tagId: tagid);
List <_Article> list = ModelConvertHelper <_Article> .ConvertToList(ds.Tables[1]);
return(list);
}
public List <ClickMsg> FindALL(int isdelete = -1)
{
List <ClickMsg> list;
var objs = CSharpCacheHelper.Get(APPConst.ClickMsgs);
if (objs == null)
{
list = ModelConvertHelper <ClickMsg> .ConvertToList(dal.FindALL());
CSharpCacheHelper.Set(APPConst.ClickMsgs, list, APPConst.ExpriseTime.Week1);
}
else
{
list = (List <ClickMsg>)objs;
}
if (isdelete == -1)
{
return(list);
}
else if (isdelete == 0)
{
return(list.Where(a => { return a.IsDelete == 0; }).ToList());
}
else
{
return(list.Where(a => { return a.IsDelete == 1; }).ToList());
}
}
/// <summary>
/// 获取新用户(30天内注册的)
/// </summary>
/// <param name="count"></param>
/// <returns></returns>
public List <UserViewModel> GetNewUsers()
{
int days = Convert.ToInt32(ConfigHelper.AppSettings("NewUsersDays"));
DataTable dt = dal.GetNewUsers(days);
return(ModelConvertHelper <UserViewModel> .ConvertToList(dt));
}
public List <_Article> GetAllArticleList(string order, Paging page)
{
DataSet ds = dal.GetAllArticleList(order, page.StartIndex, page.EndIndex);
page.RecordCount = ds.Tables[0].Rows[0][0].ToString().ToInt32();
return(ModelConvertHelper <_Article> .ConvertToList(ds.Tables[1]));
}
/// <summary>
/// 根据 所属页面模块类型 分页获取标签
/// </summary>
/// <param name="type"></param>
/// <param name="page"></param>
/// <returns></returns>
public List <_Tag> GetTags(int type, Paging page)
{
var ds = dal.GetTags(type, page.StartIndex, page.EndIndex);
page.RecordCount = ds.Tables[0].Rows[0][0].ToString().ToInt32();
return(ModelConvertHelper <_Tag> .ConvertToList(ds.Tables[1]));
}
/// <summary>
/// 获取红人用户(红人榜按照积分等级进行排名选前20)
/// </summary>
/// <param name="count"></param>
/// <returns></returns>
public List <UserViewModel> GetHotUsers()
{
int count = Convert.ToInt32(ConfigHelper.AppSettings("HotUsersCount"));
DataTable dt = dal.GetHotUsers(count);
return(ModelConvertHelper <UserViewModel> .ConvertToList(dt));
}
public List <_QuestionInfo> GetAllBBSList(string orderType, Paging page)
{
DataSet ds = dal.GetAllBBSList(orderType, page.StartIndex, page.EndIndex);
page.RecordCount = ds.Tables[0].Rows[0][0].ToString().ToInt32();
return(ModelConvertHelper <_QuestionInfo> .ConvertToList(ds.Tables[1]));
}
/// <summary>
/// 根据当前用户ID获取所有对话记录 的 最新一条
/// </summary>
/// <param name="page"></param>
/// <param name="userId"></param>
/// <returns></returns>
public List <_MsgBox> GetMyMessage(Paging page, long userId)
{
DataSet ds = dal.GetMyMessage(page.StartIndex, page.EndIndex, userId);
page.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
return(ModelConvertHelper <_MsgBox> .ConvertToList(ds.Tables[1]));
}
/// <summary>
/// 根据聊天对象ID获取对话记录
/// </summary>
/// <param name="chatPage"></param>
/// <param name="userID"></param>
/// <param name="toUserID"></param>
/// <returns></returns>
public List <_MsgBox> GetDialogByUserID(Paging chatPage, long userID, long toUserID)
{
DataSet ds = dal.GetDialogByUserID(chatPage.StartIndex, chatPage.EndIndex, userID, toUserID);
chatPage.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
return(ModelConvertHelper <_MsgBox> .ConvertToList(ds.Tables[1]));
}
public ProductViewModel SelectByCondition(Paging page, string search_cname, string search_pname, string search_price_min, string search_price_max, string search_endTime)
{
StringBuilder sb = new StringBuilder();
if (IsSafe(search_cname))
{
sb.Append(@" and a.CompanyName like '%{0}%' ".FormatWith(search_cname));
}
if (IsSafe(search_pname))
{
sb.Append(" and a.PTitle like '%{0}%' ".FormatWith(search_pname));
}
if (IsSafe(search_price_min) && IsSafe(search_price_max))
{
sb.Append(" and ISNULL(a.PPrice,0) between {0} and {1} ".FormatWith(search_price_min, search_price_max));
}
if (IsSafe(search_endTime))
{
sb.Append(" and a.CreateTime < {0} ".FormatWith(Convert.ToDateTime(search_endTime).AddDays(-30)));
}
var model = new ProductViewModel();
var ds = dal.SelectByCondition(page.StartIndex, page.EndIndex, sb.ToString());
int count = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
page.RecordCount = count;
model.ProductList = ModelConvertHelper <_Product> .ConvertToList(ds.Tables[1]);
model.ProductPage = page;
return(model);
}
/// <summary>
/// 获取签到榜用户信息(今日签到用户)
/// </summary>
/// <returns></returns>
public List <SignUserViewModel> GetSignUsersByToday()
{
var time = DateTime.Now;
DataTable dt = dal.GetSignUsers(time.Date, time);
return(ModelConvertHelper <SignUserViewModel> .ConvertToList(dt));
}
public List <_Activity> GetCheckList()
{
DataTable ds = dal.GetCheckList();
List <_Activity> list = new List <_Activity>();
list.AddRange(ModelConvertHelper <_Activity> .ConvertToList(ds).OrderByDescending(a => Convert.ToDateTime(a.ActivityCreateTIme).ToString("yyyy-MM-dd")).ThenByDescending(a => a.PVCount).ToList());
return(list);
}
/// <summary>
/// 搜索帖子
/// </summary>
/// <param name="keywords"></param>
/// <param name="page"></param>
/// <returns></returns>
public List <_QuestionInfo> SearchQuestion(string keywords, Paging page)
{
DataSet ds = dal.SearchQuestion(page.StartIndex, page.EndIndex, keywords);
List <_QuestionInfo> list = new List <_QuestionInfo>();
page.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
list.AddRange(ModelConvertHelper <_QuestionInfo> .ConvertToList(ds.Tables[1]).OrderByDescending(a => Convert.ToDateTime(a.CreateTime).ToString("yyyy-MM-dd")).ThenByDescending(a => a.PVCount).ToList());
return(list);
}
/// <summary>
/// 获取老用户（180天以上的）
/// </summary>
/// <returns></returns>
public List <UserViewModel> GetOldUsers()
{
int days = Convert.ToInt32(ConfigHelper.AppSettings("NewUsersDays"));
int count = Convert.ToInt32(ConfigHelper.AppSettings("HotUsersCount"));
DataTable dt = dal.GetOldUsers(days, count);
var model = ModelConvertHelper <UserViewModel> .ConvertToList(dt);
return(model.OrderByDescending(a => { return a.SignCount + a.CommentCount; }).ToList());
}
public List <_Article> GetAllArticles(Paging aRticlePage, string keyWord = null, long tagid = 0)
{
DataSet ds = dal.GetAllArticles(aRticlePage.StartIndex, aRticlePage.EndIndex, keyWord, tagid);
List <_Article> list = ModelConvertHelper <_Article> .ConvertToList(ds.Tables[1]);
aRticlePage.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
return(list);
}
///// <summary>
///// 基本数据查询
///// </summary>
///// <param name="pageIndex">查询页码</param>
///// <returns></returns>
//public Paging Query(int pageIndex)
//{
// Paging paging = new Paging();
//
// int count = Count();
// if (count == 0) return paging;
//
// int pageCount = count % paging.PageSize == 0 ? count / paging.PageSize : count / paging.PageSize + 1;
// if (pageIndex < 1 || pageIndex > pageCount) pageIndex = 1;
//
// DataTable tab = dal.Query(pageIndex, paging.PageSize);
//
// List<Product> li = ModelConvertHelper<Product>.ConvertToList(tab);
// paging.RecordCount = count;
// paging.PageIndex = pageIndex;
// //paging.SetDataSource(li);
// paging.PageCount = pageCount;
//
// return paging;
//}
#endregion
#region query
/// <summary>
/// 基本数据查询
/// </summary>
/// <param name="pageIndex">查询页码</param>
/// <returns></returns>
public Paging SearchByRows(int pageIndex)
{
Paging paging = new Paging(Count(), pageIndex);
if (paging.RecordCount > 0)
{
var tab = dal.SearchByRows(paging.StartIndex, paging.EndIndex);
var li = ModelConvertHelper <Product> .ConvertToList(tab);
}
return(paging);
}
public UserManageViewModel GetUserByKey(string key)
{
var dt = dal.GetUserByKey(key);
UserManageViewModel model = new UserManageViewModel();
if (dt.IsNotNullAndRowCount())
{
model.UserInfoList = ModelConvertHelper <UserInfoViewModel> .ConvertToList(dt);
}
return(model);
}
///// <summary>
///// 基本数据查询
///// </summary>
///// <param name="pageIndex">查询页码</param>
///// <returns></returns>
//public Paging Query(int pageIndex)
//{
// Paging paging = new Paging();
//
// int count = Count();
// if (count == 0) return paging;
//
// int pageCount = count % paging.PageSize == 0 ? count / paging.PageSize : count / paging.PageSize + 1;
// if (pageIndex < 1 || pageIndex > pageCount) pageIndex = 1;
//
// DataTable tab = dal.Query(pageIndex, paging.PageSize);
//
// List<News> li = ModelConvertHelper<News>.ConvertToList(tab);
// paging.RecordCount = count;
// paging.PageIndex = pageIndex;
// //paging.SetDataSource(li);
// paging.PageCount = pageCount;
//
// return paging;
//}
#endregion
#region query
public BaseListViewModel <T> SearchByRows <T>(Paging page) where T : new()
{
var ds = dal.SearchByRows(page.StartIndex, page.EndIndex);
page.RecordCount = ds.Tables[0].Rows[0][0].ToString().ToInt32();
return(new BaseListViewModel <T>()
{
DataList = ModelConvertHelper <T> .ConvertToList(ds.Tables[1]),
Page = page
});
}
public ListenChatAndNotice GetALlUnReadMsg(long userID)
{
var ds = dal.GetAllUnReadMsg(userID);
var model = new ListenChatAndNotice();
model.Chats = ModelConvertHelper <ChatViewModel> .ConvertToList(ds.Tables[0]);
model.Notices = ds.Tables[1].Rows[0][0].ToString().ToInt32();
//return ModelConvertHelper<ChatViewModel>.ConvertToList(dal.GetAllUnReadMsg(userID));
return(model);
}
public BaseListViewModel <ZhaoPin> GetZhaoPinList(long userID, Paging page)
{
var model = new BaseListViewModel <ZhaoPin>();
DataSet ds = dal.GetZhaoPinList(userID, page.StartIndex, page.EndIndex);
model.Page = page;
model.Page.RecordCount = ds.Tables[0].Rows[0][0].ToString().ToInt32();
model.DataList = ModelConvertHelper <ZhaoPin> .ConvertToList(ds.Tables[1]);
return(model);
}
public List <List <HomeTagsViewModel> > GetRandomTag()
{
int newcount = CacheBLL.Instance.Get_TagFixedNumber();
int count = CacheBLL.Instance.Get_TagRandomNumber();
var ds = dal.GetRandomTag(newcount, count);
var list = new List <List <HomeTagsViewModel> >();
list.Add(ModelConvertHelper <HomeTagsViewModel> .ConvertToList(ds.Tables[0]));
list.Add(ModelConvertHelper <HomeTagsViewModel> .ConvertToList(ds.Tables[1]));
return(list);
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="page"></param>
/// <returns></returns>
public ZhaoPinViewModel FindAll(Paging page, string key = null)
{
ZhaoPinViewModel model = new ZhaoPinViewModel();
var ds = dal.SearchByRows(page.StartIndex, page.EndIndex, key);
int count = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
page.RecordCount = count;
model.ZhaoPinList = ModelConvertHelper <_ZhaoPin> .ConvertToList(ds.Tables[1]);
model.ZhaoPinPage = page;
return(model);
}
public PartyCreateViewModel GetEditDetail(long id)
{
var ds = dal.GetEditDetail(id);
PartyCreateViewModel model = new PartyCreateViewModel()
{
Party = ModelConvertHelper <Activity> .ConverToModel(ds.Tables[0]),
PartyFee = ModelConvertHelper <ActivityFee> .ConvertToList(ds.Tables[1]),
JoinItemQues = ModelConvertHelper <JoinItemQuestionExt> .ConvertToList(ds.Tables[2])
};
return(model);
}
public GiftCreateViewModel GetEditDetail(long id, JoinItemTypeEnum joinItemType)
{
var ds = dal.GetEditDetail(id, joinItemType.GetHashCode());
GiftCreateViewModel model = new GiftCreateViewModel()
{
Gift = ModelConvertHelper <Gift> .ConverToModel(ds.Tables[0]),
GiftFees = ModelConvertHelper <GiftFee> .ConvertToList(ds.Tables[1]),
JoinItemQues = ModelConvertHelper <JoinItemQuestionExt> .ConvertToList(ds.Tables[2])
};
return(model);
}
/// <summary>
/// 获取工作相关评论
/// </summary>
/// <param name="type">1 招聘 2 求职</param>
/// <param name="page"></param>
/// <returns></returns>
public List <JobComment> GetJobComments(long id, int type, Paging page)
{
List <JobComment> list = new List <JobComment>();
DataSet ds = dal.GetJobComment(id, type, page.StartIndex, page.EndIndex);
int count = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
if (count > 0)
{
page.RecordCount = count;
list = ModelConvertHelper <JobComment> .ConvertToList(ds.Tables[1]);
}
return(list);
}
///// <summary>
///// 基本数据查询
///// </summary>
///// <param name="pageIndex">查询页码</param>
///// <returns></returns>
//public Paging Query(int pageIndex)
//{
// Paging paging = new Paging();
//
// int count = Count();
// if (count == 0) return paging;
//
// int pageCount = count % paging.PageSize == 0 ? count / paging.PageSize : count / paging.PageSize + 1;
// if (pageIndex < 1 || pageIndex > pageCount) pageIndex = 1;
//
// DataTable tab = dal.Query(pageIndex, paging.PageSize);
//
// List<SoftLink> li = ModelConvertHelper<SoftLink>.ConvertToList(tab);
// paging.RecordCount = count;
// paging.PageIndex = pageIndex;
// //paging.SetDataSource(li);
// paging.PageCount = pageCount;
//
// return paging;
//}
#endregion
#region query
/// <summary>
/// 基本数据查询
/// </summary>
/// <param name="pageIndex">查询页码</param>
/// <returns></returns>
public Paging SearchByRows(int pageIndex)
{
Paging paging = new Paging(Count(), pageIndex);
if (paging.RecordCount > 0)
{
var tab = dal.SearchByRows(paging.StartIndex, paging.EndIndex);
var li = ModelConvertHelper <SoftLink> .ConvertToList(tab);
//paging.SetDataSource(li);
}
return(paging);
}
