public override SqlParameter[] GetParameters()
{
M_Comment model = this;
if (string.IsNullOrEmpty(model.ReportIDS))
{
ReportIDS = "";
}
if (model.CommentTime <= DateTime.MinValue)
{
CommentTime = DateTime.Now;
}
SqlParameter[] sp = GetSP();
sp[0].Value = model.CommentID;
sp[1].Value = model.GeneralID;
sp[2].Value = model.Title;
sp[3].Value = model.Contents;
sp[4].Value = model.Audited;
sp[5].Value = model.UserID;
sp[6].Value = model.CommentTime;
sp[7].Value = model.Score;
sp[8].Value = model.PKS;
sp[9].Value = model.Files;
sp[10].Value = model.Status;
sp[11].Value = model.Pid;
sp[12].Value = model.Type;
sp[13].Value = model.ReportIDS;
return(sp);
}
/// <summary>
/// 发表评论
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button1_Click(object sender, EventArgs e)
{
if(this.Page.IsValid)
{
if (!buser.CheckLogin())
{
function.WriteErrMsg("只有登陆用户才能发表评论！");
}
string UserID = HttpContext.Current.Request.Cookies["UserState"]["UserID"];
M_Comment comment = new M_Comment();
comment.CommentID = 0;
comment.GeneralID = DataConverter.CLng(this.HdnItemID.Value);
m_ItemID = DataConverter.CLng(this.HdnItemID.Value);
comment.UserID = DataConverter.CLng(UserID);
comment.Title = this.HdnTitle.Value;
m_Title = this.HdnTitle.Value;
comment.Contents = this.TxtContents.Text.Trim();
comment.Score = DataConverter.CLng(this.DDLScore.SelectedValue);
comment.PK = DataConverter.CBool(this.RBLPK.SelectedValue);
comment.Audited = true;
comment.CommentTime = DateTime.Now;
bcomment.Add(comment);
Response.Write("<script language=\"javascript\" type=\"text/javascript\">alert(\"评论添加成功\")</script>");
RepBind();
}
}
public M_Comment GetModelFromReader(DbDataReader rdr)
{
M_Comment model = new M_Comment();
model.CommentID = Convert.ToInt32(rdr["CommentID"]);
model.GeneralID = ConvertToInt(rdr["GeneralID"]);
model.Title = ConverToStr(rdr["Title"]);
model.Contents = ConverToStr(rdr["Contents"]);
model.Audited = ConverToBool(rdr["Audited"]);
model.UserID = ConvertToInt(rdr["UserID"]);
model.CommentTime = ConvertToDate(rdr["CommentTime"]);
model.Score = ConvertToInt(rdr["Score"]);
model.PKS = ConverToBool(rdr["PKS"]);
model.Files = ConverToStr(rdr["files"]);
model.Status = ConvertToInt(rdr["status"]);
model.Pid = ConvertToInt(rdr["pid"]);
model.Type = ConvertToInt(rdr["Type"]);
model.ReportIDS = ConverToStr(rdr["ReprotIDS"]);
rdr.Dispose();
return(model);
}
/// <summary>
/// 发表(增加)评论
/// </summary>
/// <param name=commentInfo"></param>
/// <returns>返回True/False</returns>
bool ID_Comment.Add(M_Comment commentInfo)
{
string sqlStr = "PR_Comments_Add";
SqlParameter[] parameter = GetParameters(commentInfo);
return SqlHelper.ExecuteProc(sqlStr, parameter);
}
/// <summary>
/// 传参
/// </summary>
/// <param name="userGroup"></param>
/// <returns>返回SqlParameter[]</returns>
private static SqlParameter[] GetParameters(M_Comment commentInfo)
{
SqlParameter[] parameter = new SqlParameter[9];
parameter[0] = new SqlParameter("@CommentID", SqlDbType.Int); //有时候不需要用这条属性，值为 null 时，会不会报错？比如 Add 添加评论
parameter[0].Value = commentInfo.CommentID;
parameter[1] = new SqlParameter("@GeneralID", SqlDbType.Int);
parameter[1].Value = commentInfo.GeneralID;
parameter[2] = new SqlParameter("@Title", SqlDbType.NVarChar, 255);
parameter[2].Value = commentInfo.Title;
parameter[3] = new SqlParameter("@Contents", SqlDbType.NVarChar, 300);
parameter[3].Value = commentInfo.Contents;
parameter[4] = new SqlParameter("@Audited", SqlDbType.Bit);
parameter[4].Value = commentInfo.Audited;
parameter[5] = new SqlParameter("@UserID", SqlDbType.Int);
parameter[5].Value = commentInfo.UserID;
parameter[6] = new SqlParameter("@CommentTime", SqlDbType.DateTime);
parameter[6].Value = commentInfo.CommentTime;
parameter[7] = new SqlParameter("@Score", SqlDbType.Int);
parameter[7].Value = commentInfo.Score;
parameter[8] = new SqlParameter("@PK", SqlDbType.Bit);
parameter[8].Value = commentInfo.PK;
return parameter;
}
private static M_Comment GetInfoFromReader(SqlDataReader rdr)
{
M_Comment info = new M_Comment();
info.CommentID = DataConverter.CLng(rdr["CommentID"]);
info.GeneralID = DataConverter.CLng(rdr["GeneralID"]);
info.Title = rdr["Title"].ToString();
info.Contents = rdr["Contents"].ToString();
info.Audited = DataConverter.CBool(rdr["Audited"].ToString()); ;
info.UserID = DataConverter.CLng(rdr["UserID"]);
info.CommentTime = DataConverter.CDate(rdr["CommentTime"]);
info.Score = DataConverter.CLng(rdr["Score"]);
info.PK = DataConverter.CBool(rdr["PK"].ToString());
return info;
}
/// <summary>
/// 发表(增加)评论
/// </summary>
/// <param name="commentInfo"></param>
/// <returns></returns>
public bool Add(M_Comment commentInfo)
{
return comment.Add(commentInfo);
}
