public void CreateComplaintReply(ComplaintReply compReply)
{
SqlParameter[] param = new SqlParameter[] {
SqlUtilities.GenerateInputIntParameter("@complaint_id", compReply.ComplaintId),
SqlUtilities.GenerateInputIntParameter("@replier_id",compReply.ReplierId),
SqlUtilities.GenerateInputNVarcharParameter("@replier_name",50,compReply.ReplierName),
SqlUtilities.GenerateInputParameter("@content",SqlDbType.Text,compReply.Content),
SqlUtilities.GenerateInputDateTimeParameter("@reply_time",compReply.ReplyTime)
};
string sql = "INSERT INTO complaint_replies(complaint_id, replier_id, replier_name, content, reply_time) VALUES(@complaint_id, @replier_id, @replier_name, @content, @reply_time) ";
SqlHelper.ExecuteNonQuery(CommandType.Text, sql, param);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
AdminCookie cookie = (AdminCookie)RuleAuthorizationManager.GetCurrentSessionObject(Context, true);
User user = UserOperation.GetUserByUsername(cookie.Username);
string content = Request.Form[txtContent.ID].Trim();
if (string.IsNullOrEmpty(content))
{
lblMsg.Text = "回复内容不能为空！";
return;
}
ComplaintReply compReply = new ComplaintReply();
compReply.ComplaintId = comp.Id;
compReply.ReplierId = user.Id;
compReply.ReplierName = user.RealName;
compReply.Content = content;
compReply.ReplyTime = DateTime.Now;
ComplaintOperation.CreateComplaintReply(compReply);
comp.IsReply = true;
ComplaintOperation.UpdateComplaintIsReply(comp);
divComplaintReplyDataBind();
lblMsg.Text = "";
}
public static void CreateComplaintReply(ComplaintReply compReply)
{
dal.CreateComplaintReply(compReply);
}
public ComplaintReply GetComplaintReplyByComplaintId(int compId)
{
ComplaintReply cr = null;
SqlParameter[] param = new SqlParameter[] {
SqlUtilities.GenerateInputIntParameter("@complaint_id", compId)
};
string sql = "SELECT id, complaint_id, replier_id, replier_name, content, reply_time FROM complaint_replies WHERE complaint_id = @complaint_id ";
using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql, param))
{
while (dr.Read())
{
cr = new ComplaintReply();
cr.Id = dr.GetInt32(0);
cr.ComplaintId = dr.GetInt32(1);
cr.ReplierId = dr.GetInt32(2);
cr.ReplierName = dr.GetString(3);
cr.Content = dr.GetString(4);
cr.ReplyTime = dr.GetDateTime(5);
}
}
return cr;
}
