/// <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)); }