public string QuestionReply_Add()
{
int Qid = DataConverter.CLng(Request["Qid"]);
M_IServerReply repMod = new M_IServerReply();
if (Mid > 0)
{
repMod = repBll.SelReturnModel(Mid);
if (repMod.UserId != mu.UserID)
{
function.WriteErrMsg("你无权修改该回复"); return(null);
}
}
repMod.UserId = mu.UserID;
repMod.UserName = mu.UserName;
repMod.Title = Request.Form["Title_T"];
repMod.Content = Request.Form["Content_T"];
repMod.Path = Request.Form["Attach_Hid"];
if (repMod.Id > 0)
{
repBll.UpdateByID(repMod);
}
else
{
repMod.QuestionId = Qid;
repBll.Add(repMod);
}
return("<script>parent.location=parent.location;</script>");
}
/// <summary>
/// 确认回复
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button1_Click(object sender, EventArgs e)
{
M_UserInfo info = buser.GetLogin();
M_IServerReply reply = new M_IServerReply();
reply.UserId = info.UserID;
reply.Title = txtTitle.Value.Trim();
reply.Content = textarea1.Value;
reply.Path = Attach_Hid.Value;
reply.QuestionId = DataConverter.CLng(lblQuestionId.Text.ToString());
reply.ReplyTime = DateTime.Now;
if (reply.Content == "" || reply.Content == null)
{
function.WriteErrMsg("请输入回复内容!");
return;
}
else
{
if (B_IServerReply.Add(reply) && UpdateIServer())
{
SendMess(info.UserID, reply.QuestionId);
if (IsEmail.Checked == true)
{
//SendEmailToUser(info.UserID, reply.QuestionId);
//SendEmailToAdmin(info.UserID, reply.QuestionId);
function.WriteSuccessMsg("回复成功!", "BiServer.aspx");
}
}
else
{
function.WriteErrMsg("回复失败");
return;
}
}
}
public ActionResult ISReplyAdd()
{
M_IServerReply repMod = new M_IServerReply();
if (Mid > 0)
{
repMod = repBll.SelReturnModel(Mid);
if (repMod.UserId != mu.UserID)
{
function.WriteErrMsg("你无权修改该回复"); return(null);
}
}
else
{
repMod.QuestionId = DataConverter.CLng(Request.QueryString["Qid"]);
}
return(View(repMod));
}
/// <summary>
/// 根据ID查询一条记录
/// </summary>
//添加回复信息
public static bool Add(M_IServerReply ReplyInfo)
{
string sqlStr = "INSERT INTO ZL_IServerReply(QuestionId,UserId,Title,ReplyTime,Content,Path,isRead)VALUES(@QuestionId,@UserId,@Title,@ReplyTime,@Content,@Path,@isRead);";
SqlParameter[] parameter = new SqlParameter[7];
parameter[0] = new SqlParameter("@QuestionId", SqlDbType.Int);
parameter[0].Value = ReplyInfo.QuestionId;
parameter[1] = new SqlParameter("@UserId", SqlDbType.Int);
parameter[1].Value = ReplyInfo.UserId;
parameter[2] = new SqlParameter("@Title", SqlDbType.NVarChar, 100);
parameter[2].Value = ReplyInfo.Title;
parameter[3] = new SqlParameter("@ReplyTime", SqlDbType.DateTime);
parameter[3].Value = ReplyInfo.ReplyTime;
parameter[4] = new SqlParameter("@Content", SqlDbType.NText);
parameter[4].Value = ReplyInfo.Content;
parameter[5] = new SqlParameter("@Path", SqlDbType.VarChar, 1000);
parameter[5].Value = ReplyInfo.Path;
parameter[6] = new SqlParameter("@isRead", SqlDbType.Int);
parameter[6].Value = ReplyInfo.IsRead;
return(SqlHelper.ExecuteSql(sqlStr, parameter));
}
//编辑回复内容
public bool UpdateByID(M_IServerReply model)
{
return(DBCenter.UpdateByID(model, model.Id));
}
//添加回复信息
public bool Add(M_IServerReply model)
{
return(DBCenter.Insert(model) > 0);
}
