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; }