/// <summary> /// 获取评论回复列表 /// </summary> /// <param name="inRID"></param> /// <returns></returns> public static List <Model.MReplies> GetReplies(int inRID) { string sql = @" SELECT * FROM nw_Replies WHERE RID = @inRID ORDER BY RTime ASC "; SqlParameter para = new SqlParameter("@inRID", SqlDbType.Int) { Value = inRID }; DataTable dt = SqlHelper.ExecuteDataTable(CommandType.Text, sql, "", para); List <Model.MReplies> list = new List <Model.MReplies>(); foreach (DataRow item in dt.Rows) { Model.MReplies model = new Model.MReplies { ReID = Convert.ToInt32(item["ReID"]), RID = Convert.ToInt32(item["RID"]), BeUID = Convert.ToInt32(item["BeUID"]), BeUName = item["BeUName"].ToString(), UID = Convert.ToInt32(item["UID"]), UName = item["UName"].ToString(), Remark = item["Remark"].ToString(), RTime = Convert.ToDateTime(item["RTime"]) }; list.Add(model); } return(list); }
/// <summary> /// 添加回复 /// </summary> /// <param name="inModel"></param> /// <returns></returns> public static int InsertReply(Model.MReplies inModel) { StringBuilder sql = new StringBuilder(); sql.Append(" INSERT INTO nw_Replies ( "); sql.Append(" RID, BeUID, BeUName, UID, UName, Remark, RTime ) VALUES ( "); sql.Append(" @inRID, @inBeUID, @inBeUName, @inUID, @inUName, @inRemark, @inRTime ) "); SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@inRID", SqlDbType.Int), new SqlParameter("@inBeUID", SqlDbType.Int), new SqlParameter("@inBeUName", SqlDbType.NVarChar, 50), 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.RID; paras[1].Value = inModel.BeUID; paras[2].Value = inModel.BeUName; paras[3].Value = inModel.UID; paras[4].Value = inModel.UName; paras[5].Value = inModel.Remark; paras[6].Value = inModel.RTime; int result = SqlHelper.ExecuteNonQuery(CommandType.Text, sql.ToString(), paras); return(result); }
public JsonResult InsertReply(VMReplies inModel) { JsonResult json = new JsonResult(); bool result = false; if (Session["LoginUser"] is VMUser user) { Model.MReplies model = new Model.MReplies { RID = inModel.RID, BeUID = inModel.BeUID, BeUName = inModel.BeUName, UID = user.UID, UName = user.UserName, Remark = inModel.Remark, RTime = DateTime.Now }; result = Logic.LRemarks.InsertReply(model) > 0; } json.Data = result; return(json); }
/// <summary> /// 添加回复 /// </summary> /// <param name="inModel"></param> /// <returns></returns> public static int InsertReply(Model.MReplies inModel) { return(Data.DRemarks.InsertReply(inModel)); }