/// <summary>
/// 回复留言
/// </summary>
public bool UpdateLiuYan(EyouSoft.Model.MTravelArticleLY model)
{
if (model != null && !string.IsNullOrEmpty(model.LiuYanId) && !string.IsNullOrEmpty(model.OperatorId))
{
return(dal.UpdateLiuYan(model));
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条留言
/// </summary>
public bool AddLiuYan(EyouSoft.Model.MTravelArticleLY model)
{
if (model != null && !string.IsNullOrEmpty(model.MemberID) && !string.IsNullOrEmpty(model.ArticleID))
{
model.LiuYanId = Guid.NewGuid().ToString();
return(dal.AddLiuYan(model));
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个留言对象实体
/// </summary>
public EyouSoft.Model.MTravelArticleLY GetLiuYanModel(string LiuYanId)
{
EyouSoft.Model.MTravelArticleLY model = null;
StringBuilder strSql = new StringBuilder();
strSql.Append(" select LiuYanId, ArticleID, MemberID, LiuYanShiJian, LiuYanContet, HuiFuContet,IsCheck, OperatorId, IssueTime, ");
strSql.Append(" (select top 1 ArticleTitle from tbl_TravelArticle where ArticleID=tbl_TravelArticleLY.ArticleID ) as ArticleTitle, ");
strSql.Append(" (select top 1 Account from tbl_Member where MemberID=tbl_TravelArticleLY.MemberID ) as Account, ");
strSql.Append(" (select top 1 ContactName from tbl_User where UserID=tbl_TravelArticleLY.OperatorId ) as Username ");
strSql.Append(" from tbl_TravelArticleLY ");
strSql.Append(" where LiuYanId=@LiuYanId ");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(cmd, "LiuYanId", DbType.AnsiStringFixedLength, LiuYanId);
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db))
{
while (dr.Read())
{
model = new EyouSoft.Model.MTravelArticleLY();
model.LiuYanId = dr.GetString(dr.GetOrdinal("LiuYanId"));
model.ArticleID = dr.GetString(dr.GetOrdinal("ArticleID"));
model.MemberID = dr.GetString(dr.GetOrdinal("MemberID"));
model.LiuYanShiJian = dr.GetDateTime(dr.GetOrdinal("LiuYanShiJian"));
model.LiuYanContet = dr["LiuYanContet"].ToString();
model.HuiFuContet = dr["HuiFuContet"].ToString();
model.IsCheck = dr.GetString(dr.GetOrdinal("IsCheck")) == "1";
model.OperatorId = dr["OperatorId"].ToString();
if (!dr.IsDBNull(dr.GetOrdinal("IssueTime")))
{
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
}
model.ArticleTitle = dr["ArticleTitle"].ToString();
model.Account = dr["Account"].ToString();
model.Username = dr["Username"].ToString();
}
}
return model;
}
/// <summary>
/// 获得留言前几行数据
/// </summary>
public IList<EyouSoft.Model.MTravelArticleLY> GetLiuYanList(int Top, EyouSoft.Model.MTravelArticleLYCX chaxun)
{
IList<EyouSoft.Model.MTravelArticleLY> list = new List<EyouSoft.Model.MTravelArticleLY>();
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
if (Top > 0)
{
strSql.Append(" top " + Top.ToString());
}
strSql.Append(" LiuYanId, ArticleID, MemberID, LiuYanShiJian, LiuYanContet, HuiFuContet,IsCheck, OperatorId, IssueTime, ");
strSql.Append(" (select top 1 ArticleTitle from tbl_TravelArticle where ArticleID=tbl_TravelArticleLY.ArticleID ) as ArticleTitle, ");
strSql.Append(" (select top 1 Account from tbl_Member where MemberID=tbl_TravelArticleLY.MemberID ) as Account, ");
strSql.Append(" (select top 1 ContactName from tbl_User where UserID=tbl_TravelArticleLY.OperatorId ) as Username ");
strSql.Append(" from tbl_TravelArticleLY ");
strSql.Append(" Where 1=1 ");
if (chaxun != null)
{
if (!string.IsNullOrEmpty(chaxun.ArticleID))
{
strSql.AppendFormat(" and ArticleID='{0}' ", chaxun.ArticleID);
}
if (chaxun.IsCheck.HasValue)
{
strSql.AppendFormat(" and IsCheck='{0}' ", chaxun.IsCheck == true ? "1" : "0");
}
if (chaxun.Stime != null)
{
strSql.AppendFormat(" AND LiuYanShiJian>='{0}' ", chaxun.Stime.Value.ToShortDateString() + " 00:00:00");
}
if (chaxun.Etime != null)
{
strSql.AppendFormat(" AND LiuYanShiJian<='{0}' ", chaxun.Etime.Value.ToShortDateString() + " 23:59:59");
}
}
strSql.Append(" Order by IsCheck asc,LiuYanShiJian desc,IssueTime desc ");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db))
{
while (dr.Read())
{
EyouSoft.Model.MTravelArticleLY model = new EyouSoft.Model.MTravelArticleLY();
model.LiuYanId = dr.GetString(dr.GetOrdinal("LiuYanId"));
model.ArticleID = dr.GetString(dr.GetOrdinal("ArticleID"));
model.MemberID = dr.GetString(dr.GetOrdinal("MemberID"));
model.LiuYanShiJian = dr.GetDateTime(dr.GetOrdinal("LiuYanShiJian"));
model.LiuYanContet = dr["LiuYanContet"].ToString();
model.HuiFuContet = dr["HuiFuContet"].ToString();
model.IsCheck = dr.GetString(dr.GetOrdinal("IsCheck")) == "1";
model.OperatorId = dr["OperatorId"].ToString();
if (!dr.IsDBNull(dr.GetOrdinal("IssueTime")))
{
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
}
model.ArticleTitle = dr["ArticleTitle"].ToString();
model.Account = dr["Account"].ToString();
model.Username = dr["Username"].ToString();
list.Add(model);
}
}
return list;
}
/// <summary>
/// 获得留言数据列表
/// </summary>
public IList<EyouSoft.Model.MTravelArticleLY> GetLiuYanList(int PageSize, int PageIndex, ref int RecordCount, EyouSoft.Model.MTravelArticleLYCX chaxun)
{
IList<EyouSoft.Model.MTravelArticleLY> list = new List<EyouSoft.Model.MTravelArticleLY>();
string tableName = "tbl_TravelArticleLY";
StringBuilder fields = new StringBuilder();
fields.Append(" LiuYanId, ArticleID, MemberID, LiuYanShiJian, LiuYanContet, HuiFuContet,IsCheck, OperatorId, IssueTime, ");
fields.Append(" (select top 1 ArticleTitle from tbl_TravelArticle where ArticleID=tbl_TravelArticleLY.ArticleID ) as ArticleTitle, ");
fields.Append(" (select top 1 Account from tbl_Member where MemberID=tbl_TravelArticleLY.MemberID ) as Account, ");
fields.Append(" (select top 1 ContactName from tbl_User where UserID=tbl_TravelArticleLY.OperatorId ) as Username ");
string orderByString = "IsCheck asc,LiuYanShiJian desc,IssueTime desc";
StringBuilder query = new StringBuilder();
query.Append(" 1=1 ");
if (chaxun != null)
{
if (!string.IsNullOrEmpty(chaxun.ArticleID))
{
query.AppendFormat(" and ArticleID='{0}' ", chaxun.ArticleID);
}
if (chaxun.IsCheck.HasValue)
{
query.AppendFormat(" and IsCheck='{0}' ", chaxun.IsCheck == true ? "1" : "0");
}
if (chaxun.Stime != null)
{
query.AppendFormat(" AND LiuYanShiJian>='{0}' ", chaxun.Stime.Value.ToShortDateString() + " 00:00:00");
}
if (chaxun.Etime != null)
{
query.AppendFormat(" AND LiuYanShiJian<='{0}' ", chaxun.Etime.Value.ToShortDateString() + " 23:59:59");
}
}
using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fields.ToString(), query.ToString(), orderByString, null))
{
while (dr.Read())
{
EyouSoft.Model.MTravelArticleLY model = new EyouSoft.Model.MTravelArticleLY();
model.LiuYanId = dr.GetString(dr.GetOrdinal("LiuYanId"));
model.ArticleID = dr.GetString(dr.GetOrdinal("ArticleID"));
model.MemberID = dr.GetString(dr.GetOrdinal("MemberID"));
model.LiuYanShiJian = dr.GetDateTime(dr.GetOrdinal("LiuYanShiJian"));
model.LiuYanContet = dr["LiuYanContet"].ToString();
model.HuiFuContet = dr["HuiFuContet"].ToString();
model.IsCheck = dr.GetString(dr.GetOrdinal("IsCheck")) == "1";
model.OperatorId = dr["OperatorId"].ToString();
if (!dr.IsDBNull(dr.GetOrdinal("IssueTime")))
{
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
}
model.ArticleTitle = dr["ArticleTitle"].ToString();
model.Account = dr["Account"].ToString();
model.Username = dr["Username"].ToString();
list.Add(model);
}
}
return list;
}