/// <summary>
/// 修改提醒信息
/// </summary>
/// <param name="model">提醒实体</param>
/// <returns>true:成功 false:失败</returns>
public bool UpdateRemind(EyouSoft.Model.CommunityStructure.Remind model)
{
if (model == null)
{
return(false);
}
return(dal.UpdateRemind(model));
}
/// <summary>
/// 分页获取提醒信息列表
/// </summary>
/// <param name="PageSize">每页条数</param>
/// <param name="PageIndex">当前页数</param>
/// <param name="RecordCount">总记录数</param>
/// <param name="IsDisplay">是否显示 =null返回全部</param>
/// <returns>返回顾问团队实体集合</returns>
public virtual IList <EyouSoft.Model.CommunityStructure.Remind> GetRemindLists(int PageSize, int PageIndex, ref int RecordCount, bool?IsDisplay)
{
IList <EyouSoft.Model.CommunityStructure.Remind> List = new List <EyouSoft.Model.CommunityStructure.Remind>();
//构造SQL语句
string strFiles = " [ID],[Operator],[TilteType],[EventTime],[IsDisplay],[Sort] ";
string strOrder = " Sort desc ";
string strWhere = string.Empty;
//是否显示
if (IsDisplay.HasValue)
{
strWhere = string.Format(" IsDisplay='{0}' ", IsDisplay.Value ? "1" : "0");
}
using (IDataReader dr = DbHelper.ExecuteReader(base.SystemStore, PageSize, PageIndex, ref RecordCount, "tbl_Remind", "[ID]", strFiles, strWhere, strOrder))
{
EyouSoft.Model.CommunityStructure.Remind model = null;
while (dr.Read())
{
model = new EyouSoft.Model.CommunityStructure.Remind();
if (!string.IsNullOrEmpty(dr["ID"].ToString()))
{
model.ID = int.Parse(dr["ID"].ToString());
}
model.Operator = dr["Operator"].ToString();
if (!dr.IsDBNull(dr.GetOrdinal("TilteType")))
{
model.TilteType = (EyouSoft.Model.CommunityStructure.TitleTypes) int.Parse(dr["TilteType"].ToString());
}
//生成链接跳转
//if (!dr.IsDBNull(dr.GetOrdinal("TilteType")))
//{
// model.TypeLink = GetLinklingLoader(dr["TilteType"].ToString());
//}
if (!dr.IsDBNull(dr.GetOrdinal("EventTime")))
{
model.EventTime = DateTime.Parse(dr["EventTime"].ToString());
}
if (!string.IsNullOrEmpty(dr["IsDisplay"].ToString()) && dr["IsDisplay"].ToString().Equals("1"))
{
model.IsDisplay = true;
}
if (!string.IsNullOrEmpty(dr["Sort"].ToString()))
{
model.Sort = int.Parse(dr["Sort"].ToString());
}
List.Add(model);
model = null;
}
}
return(List);
}
/// <summary>
/// 更新提醒数据
/// </summary>
/// <param name="model">model</param>
/// <returns>false:失败 true:成功</returns>
public virtual bool UpdateRemind(EyouSoft.Model.CommunityStructure.Remind model)
{
DbCommand dc = this._database.GetSqlStringCommand(Sql_UpdateRemindData);
this._database.AddInParameter(dc, "ID", DbType.Int32, model.ID);
this._database.AddInParameter(dc, "Operator", DbType.String, model.Operator);
this._database.AddInParameter(dc, "TilteType", DbType.Byte, (int)model.TilteType);
this._database.AddInParameter(dc, "EventTime", DbType.DateTime, model.EventTime);
this._database.AddInParameter(dc, "IsDisplay", DbType.AnsiStringFixedLength, model.IsDisplay ? "1" : "0");
this._database.AddInParameter(dc, "Sort", DbType.Int32, model.Sort);
return(DbHelper.ExecuteSql(dc, this._database) > 0 ? true : false);
}
/// <summary>
/// 获取提醒信息的条数
/// </summary>
/// <param name="TopNum">信息条数</param>
/// <param name="IsDisplay">是否显示</param>
/// <returns></returns>
public virtual IList <EyouSoft.Model.CommunityStructure.Remind> GetRemindLists(int TopNum, bool?IsDisplay)
{
IList <EyouSoft.Model.CommunityStructure.Remind> List = new List <EyouSoft.Model.CommunityStructure.Remind>();
//构造SQL语句
string StrSql = string.Format(Sql_GetrRemind, TopNum > 0 ? string.Format(" top {0}", TopNum) : string.Empty);
if (IsDisplay.HasValue)
{
StrSql += string.Format(" where IsDisplay='{0}' ", IsDisplay.Value ? "1" : "0");
}
StrSql += " order by Sort desc";
DbCommand dc = base.SystemStore.GetSqlStringCommand(StrSql);
//执行查询并对实体进行赋值
using (IDataReader dr = DbHelper.ExecuteReader(dc, base.SystemStore))
{
EyouSoft.Model.CommunityStructure.Remind model = null;
while (dr.Read())
{
model = new EyouSoft.Model.CommunityStructure.Remind();
model.Operator = dr["Operator"].ToString();
//if (!dr.IsDBNull(dr.GetOrdinal("TilteType")))
//{
// model.TilteType = (EyouSoft.Model.CommunityStructure.TitleTypes)int.Parse(dr["TilteType"].ToString());
//}
if (!dr.IsDBNull(dr.GetOrdinal("TilteType")))
{
model.TypeLink = GetTitleLink(dr["TilteType"].ToString());
}
if (!dr.IsDBNull(dr.GetOrdinal("EventTime")))
{
model.EventTime = DateTime.Parse(dr["EventTime"].ToString());
}
List.Add(model);
model = null;
}
}
return(List);
}
/// <summary>
/// 获取实体
/// </summary>
/// <param name="ID">编号</param>
/// <returns>返回结果集</returns>
public virtual EyouSoft.Model.CommunityStructure.Remind GetModel(int ID)
{
EyouSoft.Model.CommunityStructure.Remind model = null;
DbCommand dc = this._database.GetSqlStringCommand(SQL_RemindGetModel);
this._database.AddInParameter(dc, "ID", DbType.Int32, ID);
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database))
{
if (dr.Read())
{
model = new EyouSoft.Model.CommunityStructure.Remind();
if (!string.IsNullOrEmpty(dr["ID"].ToString()))
{
model.ID = int.Parse(dr["ID"].ToString());
}
model.Operator = dr["Operator"].ToString();
if (!string.IsNullOrEmpty(dr["TilteType"].ToString()))
{
model.TilteType = (EyouSoft.Model.CommunityStructure.TitleTypes) int.Parse(dr["TilteType"].ToString());
}
if (!string.IsNullOrEmpty(dr["EventTime"].ToString()))
{
model.EventTime = DateTime.Parse(dr["EventTime"].ToString());
}
if (!string.IsNullOrEmpty(dr["IsDisplay"].ToString()) && dr["IsDisplay"].ToString().Equals("1"))
{
model.IsDisplay = true;
}
if (!string.IsNullOrEmpty(dr["Sort"].ToString()))
{
model.Sort = int.Parse(dr["Sort"].ToString());
}
}
}
return(model);
}
//测试用
//private const string SQL_IMFriendList = "select top 16 [uid],friendid,issuetime,case when 1=1 then '10' end as TypeTile from im_friendlist order by issuetime desc";
#endregion
#region ICommunityAdvisor成员
/// <summary>
/// 获取消息提醒的来源数据列表【最新的数据】
/// </summary>
/// <returns></returns>
//public virtual IList<EyouSoft.Model.CommunityStructure.RemindSource> GetList()
//{
// IList<EyouSoft.Model.CommunityStructure.RemindSource> list = new List<EyouSoft.Model.CommunityStructure.RemindSource>();
// //根据SQL语句获取最新的数据
// DbCommand dc = this._database.GetSqlStringCommand(Sql_GetRemindData);
// //操作数据集
// using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database))
// {
// EyouSoft.Model.CommunityStructure.RemindSource model = null;
// while (dr.Read())
// {
// model = new EyouSoft.Model.CommunityStructure.RemindSource();
// model.OperatorName = dr["OperatorName"].ToString();
// model.EventTitle = dr["EventTitle"].ToString();
// if (!dr.IsDBNull(dr.GetOrdinal("EventTime")))
// model.EventTime = DateTime.Parse(dr["EventTime"].ToString());
// list.Add(model);
// model = null;
// }
// }
// return list;
//}
/// <summary>
/// 获取消息提醒的来源数据列表
/// </summary>
/// <returns></returns>
public virtual IList <EyouSoft.Model.CommunityStructure.Remind> GetList()
{
IList <EyouSoft.Model.CommunityStructure.Remind> list = new List <EyouSoft.Model.CommunityStructure.Remind>();
//根据SQL语句获取最新的数据
DbCommand dc = this._database.GetSqlStringCommand(Sql_GetRemindData);
//操作数据集
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database))
{
EyouSoft.Model.CommunityStructure.Remind model = null;
while (dr.Read())
{
model = new EyouSoft.Model.CommunityStructure.Remind();
model.Operator = dr["Operator"].ToString();
if (!dr.IsDBNull(dr.GetOrdinal("TypeTile")))
{
model.Sort = int.Parse(dr["TypeTile"].ToString());
}
//订单ID
model.OrderID = dr["ID"].ToString();
list.Add(model);
model = null;
}
}
//把加MQ为好友的数据添加到数据集里面去
DbCommand dcIm = this._database.GetSqlStringCommand(SQL_IMFriendList);
//操作数据集
using (IDataReader drIm = DbHelper.ExecuteReader(dcIm, this._database))
{
EyouSoft.Model.CommunityStructure.Remind models = null;
int sumCont = 0;
while (drIm.Read())
{
//循环加一
sumCont += 1;
models = new EyouSoft.Model.CommunityStructure.Remind();
//判断是否能被二整除
if (sumCont % 2 == 0)
{
models.Operator = drIm["ContactName"].ToString();
models.Sort = 11;
}
else
{
string strTmp = string.Empty;
if (!string.IsNullOrEmpty(drIm["ContactName"].ToString()))
{
strTmp = (drIm["ContactName"].ToString().Length > 3
? drIm["ContactName"].ToString().Substring(0, 3)
: drIm["ContactName"]) + "加";
}
if (!string.IsNullOrEmpty(drIm["FriendName"].ToString()))
{
strTmp += (drIm["FriendName"].ToString().Length > 3
? drIm["FriendName"].ToString().Substring(0, 3)
: drIm["FriendName"].ToString());
}
models.Operator = strTmp;
if (!drIm.IsDBNull(drIm.GetOrdinal("TypeTile")))
{
models.Sort = int.Parse(drIm["TypeTile"].ToString());
}
}
models.OrderID = drIm["uid"].ToString();
list.Add(models);
models = null;
}
}
//取出随机数
string[] strRandomSum = GetNewRandomSum(list.Count).Split(',');
//遍历LIST添加时间
IList <EyouSoft.Model.CommunityStructure.Remind> lists = new List <EyouSoft.Model.CommunityStructure.Remind>();
int sumRand = 0;
foreach (EyouSoft.Model.CommunityStructure.Remind items in list)
{
sumRand += 1;
EyouSoft.Model.CommunityStructure.Remind model = new EyouSoft.Model.CommunityStructure.Remind();
model.Operator = items.Operator;
if (items.OrderID != null)
{
model.TypeLink = GetLinklingLoader(items.Sort.ToString(), items.OrderID);
}
//数组是从0开始的
model.EventTime = EyouSoft.Common.Utility.GetDateTime(strRandomSum[sumRand - 1].ToString(), DateTime.Now);
lists.Add(model);
model = null;
}
list = null;
//返回值
return(lists);
}
