protected void BntReply_Click(object sender, EventArgs e)
{
Model.Reply reply = new Model.Reply();
BLL.ReplyManager replyManager = new ReplyManager();
Model.Reply reply1 = new Model.Reply();
BLL.ReplyManager replyManager1 = new ReplyManager();
string str = "replyID='" + Labeltest.Text + "'";
string id = replyManager1.GetUserID(str);
string str1 = "replyID='" + Labeltest.Text + "'";
string replyFB = replyManager1.GetFBID(str);
BLL.AdminManager adminManager1 = new BLL.AdminManager();
Model.Admin admin1 = adminManager1.GetModel1(Session["SadminID"].ToString());
int s = Convert.ToInt32(admin1.adminID);
reply.feedbackID = Convert.ToInt32(replyFB);
reply.text = txtReply.Text;
reply.replierID = s;
reply.receiverID = Convert.ToInt32(id);
bool bo = replyManager.Add(reply);
if (bo == true)
{
Response.Write("<script language=javascript>alert('回复成功！')</script>");
}
else
{
Response.Write("<script language=javascript>alert('回复失败！请重试')");
}
}
protected void BntReply_Click(object sender, EventArgs e)
{
Model.Reply reply = new Model.Reply();
BLL.ReplyManager replyManager = new ReplyManager();
BLL.AdminManager adminManager1 = new BLL.AdminManager();
Model.Admin admin1 = adminManager1.GetModel1(Session["SadminID"].ToString());
int s = Convert.ToInt32(admin1.adminID);
reply.feedbackID = Convert.ToInt32(Labeltest.Text);
reply.text = txtReply.Text;
reply.replierID = s;
reply.remark = "1";
reply.receiverID = Convert.ToInt32(LabelName.Text.Trim());
bool bo = replyManager.Add(reply);
if (bo == true)
{
Response.Write("<script language=javascript>alert('回复成功！')</script>");
txtReply.Text = "";
}
else
{
Response.Write("<script language=javascript>alert('回复失败！请重试')");
}
}
protected void ReplyNumber()
{
Model.Reply reply1 = new Model.Reply();
BLL.ReplyManager replyManager1 = new ReplyManager();
BLL.AdminManager adminManager = new BLL.AdminManager();
Model.Admin admin = adminManager.GetModel1(Session["SadminID"].ToString());
int s = Convert.ToInt32(admin.adminID);
string str = "0";
int id = s;
replyManager1.UpdateState(str, s);
LabelApply.Text = "0";
LabelApply.Visible = false;
}
protected void Bind()
{
BLL.AdminManager adminManager = new BLL.AdminManager();
Model.Admin admin = adminManager.GetModel1(Session["SadminID"].ToString());
int ID = Convert.ToInt32(admin.adminID);
Model.Reply reply = new Model.Reply();
BLL.ReplyManager replyManager = new BLL.ReplyManager();
string Str = " receiverID='" + ID + "'";
GridView1.DataSource = replyManager.GetFBList(Str);
GridView1.DataBind();
}
protected void ReplyNumber()
{
Model.Reply reply1 = new Model.Reply();
BLL.ReplyManager replyManager1 = new ReplyManager();
BLL.UsersManager usersM = new UsersManager();
Model.Users users = usersM.GetModel1(Session["userID"].ToString());
int s = Convert.ToInt32(users.UserID);
string str = "0";
int id = s;
replyManager1.UpdateState(str, s);
LabelMessage.Text = "0";
LabelMessage.Visible = false;
}
protected void Bind()
{
BLL.UsersManager usersManager = new BLL.UsersManager();
Model.Users users = usersManager.GetModel1(Session["userID"].ToString());
int ID = Convert.ToInt32(users.UserID);
Model.Reply reply = new Model.Reply();
BLL.ReplyManager replyManager = new BLL.ReplyManager();
string Str = " receiverID='" + ID + "'";
GridView1.DataSource = replyManager.GetFBList(Str);
GridView1.DataBind();
}
/// <summary>
/// 是否存在该记录
/// </summary>
public static bool Exists(Model.Reply model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from Reply");
strSql.Append(" where commentId=@commentId and addUser = "******"@commentId", SqlDbType.Int, 4)
};
parameters[0].Value = model.commentId;
return(DBHelperSQL.Exists(strSql.ToString(), parameters));
}
protected void btnAddNewReply_Click(object sender, EventArgs e)
{
if (Session["LoginUser"] == null)
{
Response.Redirect("UserLogin.aspx?LoginInfo=您要先登录才能回复帖子！&LastFormUrl=" + Request.Path + "?DynamicID=" + Request.QueryString["DynamicID"] as string);
return;
}
if (string.IsNullOrEmpty(textReplyContent.Text))
{
Response.Write("<script>alert('请输入回复内容！')</script>");
textReplyContent.Focus();
return;
}
if (string.IsNullOrEmpty(textReplyContent.Text))
{
Response.Write("<script>alert('回复内容不能少于6位！')</script>");
textReplyContent.Focus();
return;
}
string code = textVerCode.Text;
HttpCookie htco = Request.Cookies["ImageV"];
string scode = htco.Value.ToString();
if (string.IsNullOrEmpty(code) || textVerCode.Text.Length < 4 || code.ToLower() != scode.ToLower())
{
Response.Write("<script>alert('验证码输入不正确！')</script>");
textVerCode.Text = "";
textVerCode.Focus();
return;
}
Model.Reply reply = new Model.Reply();
reply.ReplyID = "reply" + DateTime.Now.ToFileTime();
reply.ReplyContent = textReplyContent.Text;
reply.PublishDate = DateTime.Now;
reply.DynamicID = Request.QueryString["DynamicID"] as string;
reply.UserNum = (Session["LoginUser"] as Model.User).UserNum;
if (BLL.ReplyBll.InsertReply(reply) > 0)
{
Response.Write("<script>alert('回复成功！')</script>");
LoadReply();
}
else
{
Response.Write("<script>alert('回复失败，数据操作错误，请联系管理员!！')</script>");
}
}
protected void ReplyNumber()
{
Model.Reply reply = new Model.Reply();
BLL.ReplyManager replyManager = new ReplyManager();
BLL.UsersManager usersM = new UsersManager();
Model.Users users = usersM.GetModel1(Session["userID"].ToString());
int s = Convert.ToInt32(users.UserID);
string str = "remark='" + "1" + "'and receiverID='" + s + "'";
int number = replyManager.GetRecordCount(str);
if (number > 0)
{
LabelMessage.Visible = true;
LabelMessage.Text = Convert.ToString(number);
}
}
protected void ReplyNumber()
{
Model.Reply reply = new Model.Reply();
BLL.ReplyManager replyManager = new ReplyManager();
BLL.AdminManager adminManager1 = new BLL.AdminManager();
Model.Admin admin1 = adminManager1.GetModel1(Session["SadminID"].ToString());
int s = Convert.ToInt32(admin1.adminID);
string str = "remark='" + "1" + "'and receiverID='" + s + "'";
int number = replyManager.GetRecordCount(str);
if (number > 0)
{
LabelMessage.Visible = true;
LabelMessage.Text = Convert.ToString(number);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.Reply model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Reply set ");
strSql.Append("commentId=@commentId,");
strSql.Append("replyContent=@replyContent,");
strSql.Append("status=@status,");
strSql.Append("remark=@remark,");
strSql.Append("addTime=@addTime,");
strSql.Append("addUser=@addUser,");
strSql.Append("infoType=@infoType");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@commentId", SqlDbType.Int, 4),
new SqlParameter("@replyContent", SqlDbType.VarChar, 1500),
new SqlParameter("@status", SqlDbType.Int, 4),
new SqlParameter("@remark", SqlDbType.VarChar, 150),
new SqlParameter("@addTime", SqlDbType.DateTime),
new SqlParameter("@addUser", SqlDbType.Int, 4),
new SqlParameter("@infoType", SqlDbType.Int, 4),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.commentId;
parameters[1].Value = model.replyContent;
parameters[2].Value = model.status;
parameters[3].Value = model.remark;
parameters[4].Value = model.addTime;
parameters[5].Value = model.addUser;
parameters[6].Value = model.infoType;
parameters[7].Value = model.id;
int rows = DBHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public static Model.Reply DataRowToModel(DataRow row)
{
Model.Reply model = new Model.Reply();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["commentId"] != null && row["commentId"].ToString() != "")
{
model.commentId = int.Parse(row["commentId"].ToString());
}
if (row["replyContent"] != null)
{
model.replyContent = row["replyContent"].ToString();
}
if (row["status"] != null && row["status"].ToString() != "")
{
model.status = int.Parse(row["status"].ToString());
}
if (row["remark"] != null)
{
model.remark = row["remark"].ToString();
}
if (row["addTime"] != null && row["addTime"].ToString() != "")
{
model.addTime = DateTime.Parse(row["addTime"].ToString());
}
if (row["addUser"] != null && row["addUser"].ToString() != "")
{
model.addUser = int.Parse(row["addUser"].ToString());
}
if (row["infoType"] != null && row["infoType"].ToString() != "")
{
model.infoType = int.Parse(row["infoType"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public static int Add(Model.Reply model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Reply(");
strSql.Append("commentId,replyContent,status,remark,addTime,addUser,infoType)");
strSql.Append(" values (");
strSql.Append("@commentId,@replyContent,@status,@remark,@addTime,@addUser,@infoType)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@commentId", SqlDbType.Int, 4),
new SqlParameter("@replyContent", SqlDbType.VarChar, 1500),
new SqlParameter("@status", SqlDbType.Int, 4),
new SqlParameter("@remark", SqlDbType.VarChar, 150),
new SqlParameter("@addTime", SqlDbType.DateTime),
new SqlParameter("@addUser", SqlDbType.Int, 4),
new SqlParameter("@infoType", SqlDbType.Int, 4)
};
parameters[0].Value = model.commentId;
parameters[1].Value = model.replyContent;
parameters[2].Value = model.status;
parameters[3].Value = model.remark;
parameters[4].Value = model.addTime;
parameters[5].Value = model.addUser;
parameters[6].Value = model.infoType;
object obj = DBHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个最新的对象实体
/// </summary>
public static Model.Reply GetNewOne(int commentId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,commentId,replyContent,status,remark,addTime,addUser,infoType from Reply ");
strSql.Append(" where commentId=@commentId order by id desc");
SqlParameter[] parameters =
{
new SqlParameter("@commentId", SqlDbType.Int, 4)
};
parameters[0].Value = commentId;
Model.Reply model = new Model.Reply();
DataSet ds = DBHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public static int InsertReply(Model.Reply reply)
{
//return DAL.DBHelper.DataAddMethod<Model.Reply>(reply) > 0 ? "回复成功!" : "回复失败，数据操作错误，请联系管理员!";
return(DAL.DBHelper.DataAddMethod <Model.Reply>(reply));
}
