/// <summary>
/// 添加评论
/// </summary>
/// <param name="inModel"></param>
/// <returns></returns>
public static int InsertRemark(Model.MRemarks inModel)
{
StringBuilder sql = new StringBuilder();
sql.Append(" INSERT INTO nw_Remarks ( ");
sql.Append(" ArticleID, UID, UName, Remark, RTime ) VALUES ( ");
sql.Append(" @inArticleID, @inUID, @inUName, @inRemark, @inRTime ) ");
//sql.Append(" SELECT @@IDENTITY AS RID ");
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@inArticleID", SqlDbType.BigInt),
new SqlParameter("@inUID", SqlDbType.Int),
new SqlParameter("@inUName", SqlDbType.NVarChar, 50),
new SqlParameter("@inRemark", SqlDbType.NVarChar, 500),
new SqlParameter("@inRTime", SqlDbType.DateTime)
};
paras[0].Value = inModel.ArticleID;
paras[1].Value = inModel.UID;
paras[2].Value = inModel.UName;
paras[3].Value = inModel.Remark;
paras[4].Value = inModel.RTime;
int result = SqlHelper.ExecuteNonQuery(CommandType.Text, sql.ToString(), paras);
//DataTable dt = SqlHelper.ExecuteDataTable(CommandType.Text, sql.ToString(), "", paras);
//int result = dt.Rows.Count > 0 ? Convert.ToInt32(dt.Rows[0]["RID"]) : 0;
return(result);
}
/// <summary>
/// 获取文章评论
/// </summary>
/// <param name="inArticleID"></param>
/// <returns></returns>
public static List <Model.MRemarks> GetRemarks(long inArticleID)
{
string sql = @" SELECT * FROM nw_Remarks WHERE ArticleID = @inArticleID ";
SqlParameter para = new SqlParameter("@inArticleID", SqlDbType.BigInt)
{
Value = inArticleID
};
DataTable dt = SqlHelper.ExecuteDataTable(CommandType.Text, sql, "", para);
List <Model.MRemarks> list = new List <Model.MRemarks>();
foreach (DataRow item in dt.Rows)
{
Model.MRemarks model = new Model.MRemarks
{
RID = Convert.ToInt32(item["RID"]),
ArticleID = Convert.ToInt64(item["ArticleID"]),
UID = Convert.ToInt32(item["UID"]),
UName = item["UName"].ToString(),
Remark = item["Remark"].ToString(),
RTime = Convert.ToDateTime(item["RTime"])
};
list.Add(model);
}
return(list);
}
public JsonResult InsertRemark(VMRemark inModel)
{
JsonResult json = new JsonResult();
bool result = false;
if (Session["LoginUser"] is VMUser user)
{
Model.MRemarks model = new Model.MRemarks
{
ArticleID = inModel.ArticleID,
UID = user.UID,
UName = user.UserName,
Remark = inModel.Remark,
RTime = DateTime.Now
};
result = Logic.LRemarks.InsertRemark(model) > 0;
}
json.Data = result;
return(json);
}
/// <summary>
/// 添加评论
/// </summary>
/// <param name="inModel"></param>
/// <returns></returns>
public static int InsertRemark(Model.MRemarks inModel)
{
return(Data.DRemarks.InsertRemark(inModel));
}
