protected void Repeater3_ItemCommand(object source, RepeaterCommandEventArgs e) { QA_CommentMod m_comment = QA_CommentBll.GetInstance().GetModel(int.Parse(e.CommandArgument.ToString())); m_comment.DR = (int)AppEnum.State.deleted; QA_CommentBll.GetInstance().Update(m_comment); ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addhate", "alert('成功删除该评论!');", true); BindList(); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(QA_CommentMod model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into QA_Comment("); strSql.Append("QuestionSysNo,AnswerSysNo,CustomerSysNo,Context,DR,TS)"); strSql.Append(" values ("); strSql.Append("@QuestionSysNo,@AnswerSysNo,@CustomerSysNo,@Context,@DR,@TS)"); strSql.Append(";select @@IDENTITY"); SqlCommand cmd = new SqlCommand(strSql.ToString()); SqlParameter[] parameters = { new SqlParameter("@QuestionSysNo",SqlDbType.Int,4), new SqlParameter("@AnswerSysNo",SqlDbType.Int,4), new SqlParameter("@CustomerSysNo",SqlDbType.Int,4), new SqlParameter("@Context",SqlDbType.NVarChar,2000), new SqlParameter("@DR",SqlDbType.TinyInt,1), new SqlParameter("@TS",SqlDbType.DateTime), }; if (model.QuestionSysNo != AppConst.IntNull) parameters[0].Value = model.QuestionSysNo; else parameters[0].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[0]); if (model.AnswerSysNo != AppConst.IntNull) parameters[1].Value = model.AnswerSysNo; else parameters[1].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[1]); if (model.CustomerSysNo != AppConst.IntNull) parameters[2].Value = model.CustomerSysNo; else parameters[2].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[2]); if (model.Context != AppConst.StringNull) parameters[3].Value = model.Context; else parameters[3].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[3]); if (model.DR != AppConst.IntNull) parameters[4].Value = model.DR; else parameters[4].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[4]); if (model.TS != AppConst.DateTimeNull) parameters[5].Value = model.TS; else parameters[5].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[5]); return Convert.ToInt32(SqlHelper.ExecuteScalar(cmd, parameters)); }
public ReturnValue<USR_CustomerShow> AddComment(int AnswerSysNo, int CustomerSysNo, int QuestionSysNo, string Context) { QA_CommentMod m_comment = new QA_CommentMod(); m_comment.AnswerSysNo = AnswerSysNo; m_comment.Context = AppCmn.CommonTools.SystemInputFilter(Context.DoTrim()); m_comment.DR = (int)AppEnum.State.normal; m_comment.QuestionSysNo = QuestionSysNo; m_comment.TS = DateTime.Now; m_comment.CustomerSysNo = CustomerSysNo; QA_CommentBll.GetInstance().AddComment(m_comment); USR_CustomerShow ret = new USR_CustomerShow(); USR_CustomerBll.GetInstance().GetModel(CustomerSysNo).MemberwiseCopy(ret); return ReturnValue<USR_CustomerShow>.Get200OK(ret); }
/// <summary> /// 得到一个对象实体 /// </summary> public QA_CommentMod GetModel(int SysNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select SysNo, QuestionSysNo, AnswerSysNo, CustomerSysNo, Context, DR, TS from QA_Comment"); strSql.Append(" where SysNo=@SysNo "); SqlParameter[] parameters = { new SqlParameter("@SysNo", SqlDbType.Int, 4) }; parameters[0].Value = SysNo; QA_CommentMod model = new QA_CommentMod(); DataSet ds = SqlHelper.ExecuteDataSet(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["SysNo"].ToString() != "") { model.SysNo = int.Parse(ds.Tables[0].Rows[0]["SysNo"].ToString()); } if (ds.Tables[0].Rows[0]["QuestionSysNo"].ToString() != "") { model.QuestionSysNo = int.Parse(ds.Tables[0].Rows[0]["QuestionSysNo"].ToString()); } if (ds.Tables[0].Rows[0]["AnswerSysNo"].ToString() != "") { model.AnswerSysNo = int.Parse(ds.Tables[0].Rows[0]["AnswerSysNo"].ToString()); } if (ds.Tables[0].Rows[0]["CustomerSysNo"].ToString() != "") { model.CustomerSysNo = int.Parse(ds.Tables[0].Rows[0]["CustomerSysNo"].ToString()); } model.Context = ds.Tables[0].Rows[0]["Context"].ToString(); if (ds.Tables[0].Rows[0]["DR"].ToString() != "") { model.DR = int.Parse(ds.Tables[0].Rows[0]["DR"].ToString()); } if (ds.Tables[0].Rows[0]["TS"].ToString() != "") { model.TS = DateTime.Parse(ds.Tables[0].Rows[0]["TS"].ToString()); } return(model); } else { return(null); } }
public ReturnValue <bool> RemoveComment(int CommentSysNo) { QA_CommentMod m_comment = QA_CommentBll.GetInstance().GetModel(CommentSysNo); if (m_comment != null) { m_comment.DR = (int)AppEnum.State.deleted; QA_CommentBll.GetInstance().Update(m_comment); return(ReturnValue <bool> .Get200OK(true)); } else { throw new BusinessException("该评论不存在!"); } }
public ReturnValue <USR_CustomerShow> AddComment(int AnswerSysNo, int CustomerSysNo, int QuestionSysNo, string Context) { QA_CommentMod m_comment = new QA_CommentMod(); m_comment.AnswerSysNo = AnswerSysNo; m_comment.Context = AppCmn.CommonTools.SystemInputFilter(Context.DoTrim()); m_comment.DR = (int)AppEnum.State.normal; m_comment.QuestionSysNo = QuestionSysNo; m_comment.TS = DateTime.Now; m_comment.CustomerSysNo = CustomerSysNo; QA_CommentBll.GetInstance().AddComment(m_comment); USR_CustomerShow ret = new USR_CustomerShow(); USR_CustomerBll.GetInstance().GetModel(CustomerSysNo).MemberwiseCopy(ret); return(ReturnValue <USR_CustomerShow> .Get200OK(ret)); }
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "Love") { if (!CheckCommentCookies(int.Parse(e.CommandArgument.ToString()))) { QA_AnswerMod m_answer = QA_AnswerBll.GetInstance().GetModel(int.Parse(e.CommandArgument.ToString())); m_answer.Love++; QA_AnswerBll.GetInstance().Update(m_answer); SetCommentCookies(int.Parse(e.CommandArgument.ToString())); ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addlove", "alert('您对该回答表示了赞同!');", true); BindList(); } else { ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addlove", "alert('您已对该回答发表了看法!');", true); } } else if (e.CommandName == "Hate") { if (!CheckCommentCookies(int.Parse(e.CommandArgument.ToString()))) { QA_AnswerMod m_answer = QA_AnswerBll.GetInstance().GetModel(int.Parse(e.CommandArgument.ToString())); m_answer.Hate++; QA_AnswerBll.GetInstance().Update(m_answer); SetCommentCookies(int.Parse(e.CommandArgument.ToString())); ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addhate", "alert('您对该回答表示了不赞同!');", true); BindList(); } else { ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addlove", "alert('您已对该回答发表了看法!');", true); } } else if (e.CommandName == "Award") { QA_QuestionMod m_quest = QA_QuestionBll.GetInstance().GetModel(SysNo); int usedAward = QA_AnswerBll.GetInstance().GetUsedAward(SysNo); ltrMax.Text = "该问题的总悬赏积分为:" + (m_quest.Award - usedAward).ToString(); HiddenField1.Value = e.CommandArgument.ToString(); ModalPopupExtender1.Show(); } else if (e.CommandName == "Reply") { if (((TextBox)e.Item.FindControl("txtRe")).Text.Trim() == "") { ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addComment", "alert('请输入您的回复信息!');", true); return; } try { QA_CommentMod m_comment = new QA_CommentMod(); m_comment.AnswerSysNo = int.Parse(e.CommandArgument.ToString()); m_comment.Context = AppCmn.CommonTools.SystemInputFilter(((TextBox)e.Item.FindControl("txtRe")).Text.Trim()); m_comment.DR = (int)AppEnum.State.normal; m_comment.QuestionSysNo = SysNo; m_comment.TS = DateTime.Now; m_comment.CustomerSysNo = GetSession().CustomerEntity.SysNo; QA_CommentBll.GetInstance().AddComment(m_comment); RefreshSession(); ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addComment", "alert('发表看法成功!');", true); } catch { ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addComment", "alert('系统故障,请联系管理员');", true); } BindList(); } else if (e.CommandName == "Del") { QA_AnswerMod m_answer = QA_AnswerBll.GetInstance().GetModel(int.Parse(e.CommandArgument.ToString())); m_answer.DR = (int)AppEnum.State.deleted; QA_AnswerBll.GetInstance().Update(m_answer); ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addhate", "alert('成功删除该回答!');", true); BindList(); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(QA_CommentMod model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into QA_Comment("); strSql.Append("QuestionSysNo,AnswerSysNo,CustomerSysNo,Context,DR,TS)"); strSql.Append(" values ("); strSql.Append("@QuestionSysNo,@AnswerSysNo,@CustomerSysNo,@Context,@DR,@TS)"); strSql.Append(";select @@IDENTITY"); SqlCommand cmd = new SqlCommand(strSql.ToString()); SqlParameter[] parameters = { new SqlParameter("@QuestionSysNo", SqlDbType.Int, 4), new SqlParameter("@AnswerSysNo", SqlDbType.Int, 4), new SqlParameter("@CustomerSysNo", SqlDbType.Int, 4), new SqlParameter("@Context", SqlDbType.NVarChar, 2000), new SqlParameter("@DR", SqlDbType.TinyInt, 1), new SqlParameter("@TS", SqlDbType.DateTime), }; if (model.QuestionSysNo != AppConst.IntNull) { parameters[0].Value = model.QuestionSysNo; } else { parameters[0].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[0]); if (model.AnswerSysNo != AppConst.IntNull) { parameters[1].Value = model.AnswerSysNo; } else { parameters[1].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[1]); if (model.CustomerSysNo != AppConst.IntNull) { parameters[2].Value = model.CustomerSysNo; } else { parameters[2].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[2]); if (model.Context != AppConst.StringNull) { parameters[3].Value = model.Context; } else { parameters[3].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[3]); if (model.DR != AppConst.IntNull) { parameters[4].Value = model.DR; } else { parameters[4].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[4]); if (model.TS != AppConst.DateTimeNull) { parameters[5].Value = model.TS; } else { parameters[5].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[5]); return(Convert.ToInt32(SqlHelper.ExecuteScalar(cmd, parameters))); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(QA_CommentMod model) { return(dal.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(QA_CommentMod model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update QA_Comment set "); strSql.Append("QuestionSysNo=@QuestionSysNo,"); strSql.Append("AnswerSysNo=@AnswerSysNo,"); strSql.Append("CustomerSysNo=@CustomerSysNo,"); strSql.Append("Context=@Context,"); strSql.Append("DR=@DR,"); strSql.Append("TS=@TS"); strSql.Append(" where SysNo=@SysNo "); SqlCommand cmd = new SqlCommand(strSql.ToString()); SqlParameter[] parameters = { new SqlParameter("@SysNo",SqlDbType.Int,4), new SqlParameter("@QuestionSysNo",SqlDbType.Int,4), new SqlParameter("@AnswerSysNo",SqlDbType.Int,4), new SqlParameter("@CustomerSysNo",SqlDbType.Int,4), new SqlParameter("@Context",SqlDbType.NVarChar,2000), new SqlParameter("@DR",SqlDbType.TinyInt,1), new SqlParameter("@TS",SqlDbType.DateTime) }; if (model.SysNo != AppConst.IntNull) parameters[0].Value = model.SysNo; else parameters[0].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[0]); if (model.QuestionSysNo != AppConst.IntNull) parameters[1].Value = model.QuestionSysNo; else parameters[1].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[1]); if (model.AnswerSysNo != AppConst.IntNull) parameters[2].Value = model.AnswerSysNo; else parameters[2].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[2]); if (model.CustomerSysNo != AppConst.IntNull) parameters[3].Value = model.CustomerSysNo; else parameters[3].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[3]); if (model.Context != AppConst.StringNull) parameters[4].Value = model.Context; else parameters[4].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[4]); if (model.DR != AppConst.IntNull) parameters[5].Value = model.DR; else parameters[5].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[5]); if (model.TS != AppConst.DateTimeNull) parameters[6].Value = model.TS; else parameters[6].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[6]); return SqlHelper.ExecuteNonQuery(cmd,parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public QA_CommentMod GetModel(int SysNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select SysNo, QuestionSysNo, AnswerSysNo, CustomerSysNo, Context, DR, TS from QA_Comment"); strSql.Append(" where SysNo=@SysNo "); SqlParameter[] parameters = { new SqlParameter("@SysNo", SqlDbType.Int,4 ) }; parameters[0].Value = SysNo; QA_CommentMod model = new QA_CommentMod(); DataSet ds = SqlHelper.ExecuteDataSet(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["SysNo"].ToString() != "") { model.SysNo = int.Parse(ds.Tables[0].Rows[0]["SysNo"].ToString()); } if (ds.Tables[0].Rows[0]["QuestionSysNo"].ToString() != "") { model.QuestionSysNo = int.Parse(ds.Tables[0].Rows[0]["QuestionSysNo"].ToString()); } if (ds.Tables[0].Rows[0]["AnswerSysNo"].ToString() != "") { model.AnswerSysNo = int.Parse(ds.Tables[0].Rows[0]["AnswerSysNo"].ToString()); } if (ds.Tables[0].Rows[0]["CustomerSysNo"].ToString() != "") { model.CustomerSysNo = int.Parse(ds.Tables[0].Rows[0]["CustomerSysNo"].ToString()); } model.Context = ds.Tables[0].Rows[0]["Context"].ToString(); if (ds.Tables[0].Rows[0]["DR"].ToString() != "") { model.DR = int.Parse(ds.Tables[0].Rows[0]["DR"].ToString()); } if (ds.Tables[0].Rows[0]["TS"].ToString() != "") { model.TS = DateTime.Parse(ds.Tables[0].Rows[0]["TS"].ToString()); } return model; } else { return null; } }
public void AddComment(QA_CommentMod model) { bool isquest = false; TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { int sysno = Add(model); QA_QuestionMod m_qa = QA_QuestionBll.GetInstance().GetModel(model.QuestionSysNo); m_qa.ReplyCount++; m_qa.LastReplyUser = model.CustomerSysNo; m_qa.LastReplyTime = DateTime.Now; QA_QuestionBll.GetInstance().Update(m_qa); if (QA_CategoryBll.GetInstance().GetModel(m_qa.CateSysNo).TopSysNo == 1) { isquest = true; } AppMod.User.USR_RecordMod m_record = new AppMod.User.USR_RecordMod(); m_record.CustomerSysNo = model.CustomerSysNo; m_record.TargetSysNo = sysno; m_record.TS = DateTime.Now; m_record.Type = (int)AppEnum.ActionType.ReplyAnswer; User.USR_RecordBll.GetInstance().Add(m_record); if (model.CustomerSysNo == m_qa.CustomerSysNo ) { User.USR_CustomerBll.GetInstance().AddPoint(AppConst.ReplyPoint, model.CustomerSysNo); User.USR_CustomerBll.GetInstance().AddExp(AppConst.ReplyExp, model.CustomerSysNo); User.USR_CustomerBll.GetInstance().AddCount(model.CustomerSysNo, 0, 0, 0, 1, 0, 0, 0, 0, 0); } else if (!isquest) { User.USR_CustomerBll.GetInstance().AddCount(model.CustomerSysNo, 0, 0, 0, 0, 0, 1, 0, 0, 0); } User.USR_CustomerBll.GetInstance().AddPoint(AppConst.CommentPoint, model.CustomerSysNo); User.USR_CustomerBll.GetInstance().AddExp(AppConst.CommentExp, model.CustomerSysNo); QA_AnswerMod m_answer = QA_AnswerBll.GetInstance().GetModel(model.AnswerSysNo); AppMod.User.USR_MessageMod m_notice = new AppMod.User.USR_MessageMod(); m_notice.CustomerSysNo = m_answer.CustomerSysNo; if (model.CustomerSysNo == m_qa.CustomerSysNo) { m_notice.Context = ""; m_notice.Title = AppConst.FeedbackReport.Replace("@url", AppConfig.HomeUrl() + "Quest/Question.aspx?id=" + m_qa.SysNo).Replace("@question", m_qa.Title); } else { m_notice.Context = ""; m_notice.Title = AppConst.CommentReport.Replace("@url", AppConfig.HomeUrl() + "Quest/Question.aspx?id=" + m_qa.SysNo); } m_notice.DR = 0; m_notice.IsRead = 0; m_notice.TS = DateTime.Now; m_notice.Type = (int)AppEnum.MessageType.notice; User.USR_MessageBll.GetInstance().AddMessage(m_notice); scope.Complete(); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(QA_CommentMod model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(QA_CommentMod model) { dal.Update(model); }
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) { Login(Request.Url.ToString()); if (e.CommandName == "Love") { if (!CheckCommentCookies(int.Parse(e.CommandArgument.ToString()))) { QA_AnswerMod m_answer = QA_AnswerBll.GetInstance().GetModel(int.Parse(e.CommandArgument.ToString())); m_answer.Love++; QA_AnswerBll.GetInstance().Update(m_answer); SetCommentCookies(int.Parse(e.CommandArgument.ToString())); ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addlove", "alert('您对该回答表示了赞同!');", true); BindList(); } else { ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addlove", "alert('您已对该回答发表了看法!');", true); } } else if (e.CommandName == "Hate") { if (!CheckCommentCookies(int.Parse(e.CommandArgument.ToString()))) { QA_AnswerMod m_answer = QA_AnswerBll.GetInstance().GetModel(int.Parse(e.CommandArgument.ToString())); m_answer.Hate++; QA_AnswerBll.GetInstance().Update(m_answer); SetCommentCookies(int.Parse(e.CommandArgument.ToString())); ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addhate", "alert('您对该回答表示了不赞同!');", true); BindList(); } else { ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addlove", "alert('您已对该回答发表了看法!');", true); } } //else if (e.CommandName == "Award") //{ // QA_QuestionMod m_quest = QA_QuestionBll.GetInstance().GetModel(SysNo); // int usedAward = QA_AnswerBll.GetInstance().GetUsedAward(SysNo); // ltrMax.Text = "该问题的总悬赏积分为:" + (m_quest.Award - usedAward).ToString(); // HiddenField1.Value = e.CommandArgument.ToString(); // ModalPopupExtender1.Show(); //} else if (e.CommandName == "Reply") { if (((TextBox)e.Item.FindControl("txtRe")).Text.Trim() == "") { ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addComment", "alert('请输入您的回复信息!');", true); return; } try { QA_CommentMod m_comment = new QA_CommentMod(); m_comment.AnswerSysNo = int.Parse(e.CommandArgument.ToString()); m_comment.Context = AppCmn.CommonTools.SystemInputFilter(((TextBox)e.Item.FindControl("txtRe")).Text.Trim()); m_comment.DR = (int)AppEnum.State.normal; m_comment.QuestionSysNo = SysNo; m_comment.TS = DateTime.Now; m_comment.CustomerSysNo = GetSession().CustomerEntity.SysNo; QA_CommentBll.GetInstance().AddComment(m_comment); RefreshSession(); ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addComment", "alert('发表看法成功!');", true); } catch { ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addComment", "alert('系统故障,请联系管理员');", true); } BindList(); } else if (e.CommandName == "Del") { QA_AnswerMod m_answer = QA_AnswerBll.GetInstance().GetModel(int.Parse(e.CommandArgument.ToString())); m_answer.DR = (int)AppEnum.State.deleted; QA_AnswerBll.GetInstance().Update(m_answer); ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addhate", "alert('成功删除该回答!');", true); BindList(); } else if (e.CommandName == "buy") { //生成订单 QA_OrderMod m_order = QA_OrderBll.GetInstance().GetModel(int.Parse(e.CommandArgument.ToString())); ORD_CashMod m_mod = new ORD_CashMod(); m_mod.CustomerSysNo = GetSession().CustomerEntity.SysNo; m_mod.CurrentID = ""; m_mod.Discount = 0; m_mod.PayAmount = m_order.Price; m_mod.PayType = AppConst.IntNull; m_mod.Price = m_order.Price; m_mod.ProductSysNo = m_order.SysNo; m_mod.Status = (int)AppEnum.CashOrderStatus.beforepay; m_mod.ProductType = (int)AppEnum.CashOrderType.consultpay; ; m_mod.TS = DateTime.Now; m_mod.OrderID = "C" + m_mod.ProductType.ToString("0") + m_mod.TS.ToString("yyyyMMdd") + m_mod.ProductSysNo+CommonTools.ThrowRandom(0,99999).ToString("00000"); m_mod.SysNo = ORD_CashBll.GetInstance().Add(m_mod); //m_qustion.BuyCount++;//支付成功后修改订单购买数 QA_QuestionBll.GetInstance().Update(m_qustion); Response.Redirect(AppConfig.HomeUrl() + "Order/ConsultOrder.aspx?order=" + m_mod.SysNo); } else if (e.CommandName == "score") { string score = ((HiddenField)e.Item.FindControl("HiddenField3")).Value; if (score == "") { ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "score", "alert('请先选择评价!');", true); return; } else { QA_OrderMod m_order = QA_OrderBll.GetInstance().GetModel(int.Parse(e.CommandArgument.ToString())); m_order.Score = int.Parse(score); m_order.Status = (int)AppEnum.ConsultOrderStatus.confirmed; QA_OrderBll.GetInstance().Update(m_order); ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "score", "alert('已评价成功!');", true); BindList(); } } }
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) { Login(Request.Url.ToString()); if (e.CommandName == "Love") { if (!CheckCommentCookies(int.Parse(e.CommandArgument.ToString()))) { QA_AnswerMod m_answer = QA_AnswerBll.GetInstance().GetModel(int.Parse(e.CommandArgument.ToString())); m_answer.Love++; QA_AnswerBll.GetInstance().Update(m_answer); SetCommentCookies(int.Parse(e.CommandArgument.ToString())); ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addlove", "alert('您对该回答表示了赞同!');", true); BindList(); } else { ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addlove", "alert('您已对该回答发表了看法!');", true); } } else if (e.CommandName == "Hate") { if (!CheckCommentCookies(int.Parse(e.CommandArgument.ToString()))) { QA_AnswerMod m_answer = QA_AnswerBll.GetInstance().GetModel(int.Parse(e.CommandArgument.ToString())); m_answer.Hate++; QA_AnswerBll.GetInstance().Update(m_answer); SetCommentCookies(int.Parse(e.CommandArgument.ToString())); ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addhate", "alert('您对该回答表示了不赞同!');", true); BindList(); } else { ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addlove", "alert('您已对该回答发表了看法!');", true); } } //else if (e.CommandName == "Award") //{ // QA_QuestionMod m_quest = QA_QuestionBll.GetInstance().GetModel(SysNo); // int usedAward = QA_AnswerBll.GetInstance().GetUsedAward(SysNo); // ltrMax.Text = "该问题的总悬赏积分为:" + (m_quest.Award - usedAward).ToString(); // HiddenField1.Value = e.CommandArgument.ToString(); // ModalPopupExtender1.Show(); //} else if (e.CommandName == "Reply") { if (((TextBox)e.Item.FindControl("txtRe")).Text.Trim() == "") { ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addComment", "alert('请输入您的回复信息!');", true); return; } try { QA_CommentMod m_comment = new QA_CommentMod(); m_comment.AnswerSysNo = int.Parse(e.CommandArgument.ToString()); m_comment.Context = AppCmn.CommonTools.SystemInputFilter(((TextBox)e.Item.FindControl("txtRe")).Text.Trim()); m_comment.DR = (int)AppEnum.State.normal; m_comment.QuestionSysNo = SysNo; m_comment.TS = DateTime.Now; m_comment.CustomerSysNo = GetSession().CustomerEntity.SysNo; QA_CommentBll.GetInstance().AddComment(m_comment); RefreshSession(); ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addComment", "alert('发表看法成功!');", true); } catch { ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addComment", "alert('系统故障,请联系管理员');", true); } BindList(); } else if (e.CommandName == "Del") { QA_AnswerMod m_answer = QA_AnswerBll.GetInstance().GetModel(int.Parse(e.CommandArgument.ToString())); m_answer.DR = (int)AppEnum.State.deleted; QA_AnswerBll.GetInstance().Update(m_answer); ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addhate", "alert('成功删除该回答!');", true); BindList(); } else if (e.CommandName == "buy") { //生成订单 QA_OrderMod m_order = QA_OrderBll.GetInstance().GetModel(int.Parse(e.CommandArgument.ToString())); ORD_CashMod m_mod = new ORD_CashMod(); m_mod.CustomerSysNo = GetSession().CustomerEntity.SysNo; m_mod.CurrentID = ""; m_mod.Discount = 0; m_mod.PayAmount = m_order.Price; m_mod.PayType = AppConst.IntNull; m_mod.Price = m_order.Price; m_mod.ProductSysNo = m_order.SysNo; m_mod.Status = (int)AppEnum.CashOrderStatus.beforepay; m_mod.ProductType = (int)AppEnum.CashOrderType.consultpay;; m_mod.TS = DateTime.Now; m_mod.OrderID = "C" + m_mod.ProductType.ToString("0") + m_mod.TS.ToString("yyyyMMdd") + m_mod.ProductSysNo + CommonTools.ThrowRandom(0, 99999).ToString("00000"); m_mod.SysNo = ORD_CashBll.GetInstance().Add(m_mod); //m_qustion.BuyCount++;//支付成功后修改订单购买数 QA_QuestionBll.GetInstance().Update(m_qustion); Response.Redirect(AppConfig.HomeUrl() + "Order/ConsultOrder.aspx?order=" + m_mod.SysNo); } else if (e.CommandName == "score") { string score = ((HiddenField)e.Item.FindControl("HiddenField3")).Value; if (score == "") { ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "score", "alert('请先选择评价!');", true); return; } else { QA_OrderMod m_order = QA_OrderBll.GetInstance().GetModel(int.Parse(e.CommandArgument.ToString())); m_order.Score = int.Parse(score); m_order.Status = (int)AppEnum.ConsultOrderStatus.confirmed; QA_OrderBll.GetInstance().Update(m_order); ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "score", "alert('已评价成功!');", true); BindList(); } } }
/// <summary> /// 更新一条数据 /// </summary> public int Update(QA_CommentMod model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update QA_Comment set "); strSql.Append("QuestionSysNo=@QuestionSysNo,"); strSql.Append("AnswerSysNo=@AnswerSysNo,"); strSql.Append("CustomerSysNo=@CustomerSysNo,"); strSql.Append("Context=@Context,"); strSql.Append("DR=@DR,"); strSql.Append("TS=@TS"); strSql.Append(" where SysNo=@SysNo "); SqlCommand cmd = new SqlCommand(strSql.ToString()); SqlParameter[] parameters = { new SqlParameter("@SysNo", SqlDbType.Int, 4), new SqlParameter("@QuestionSysNo", SqlDbType.Int, 4), new SqlParameter("@AnswerSysNo", SqlDbType.Int, 4), new SqlParameter("@CustomerSysNo", SqlDbType.Int, 4), new SqlParameter("@Context", SqlDbType.NVarChar, 2000), new SqlParameter("@DR", SqlDbType.TinyInt, 1), new SqlParameter("@TS", SqlDbType.DateTime) }; if (model.SysNo != AppConst.IntNull) { parameters[0].Value = model.SysNo; } else { parameters[0].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[0]); if (model.QuestionSysNo != AppConst.IntNull) { parameters[1].Value = model.QuestionSysNo; } else { parameters[1].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[1]); if (model.AnswerSysNo != AppConst.IntNull) { parameters[2].Value = model.AnswerSysNo; } else { parameters[2].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[2]); if (model.CustomerSysNo != AppConst.IntNull) { parameters[3].Value = model.CustomerSysNo; } else { parameters[3].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[3]); if (model.Context != AppConst.StringNull) { parameters[4].Value = model.Context; } else { parameters[4].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[4]); if (model.DR != AppConst.IntNull) { parameters[5].Value = model.DR; } else { parameters[5].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[5]); if (model.TS != AppConst.DateTimeNull) { parameters[6].Value = model.TS; } else { parameters[6].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[6]); return(SqlHelper.ExecuteNonQuery(cmd, parameters)); }
public void AddComment(QA_CommentMod model) { bool isquest = false; TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { int sysno = Add(model); QA_QuestionMod m_qa = QA_QuestionBll.GetInstance().GetModel(model.QuestionSysNo); m_qa.ReplyCount++; m_qa.LastReplyUser = model.CustomerSysNo; m_qa.LastReplyTime = DateTime.Now; QA_QuestionBll.GetInstance().Update(m_qa); if (QA_CategoryBll.GetInstance().GetModel(m_qa.CateSysNo).TopSysNo == 1) { isquest = true; } AppMod.User.USR_RecordMod m_record = new AppMod.User.USR_RecordMod(); m_record.CustomerSysNo = model.CustomerSysNo; m_record.TargetSysNo = sysno; m_record.TS = DateTime.Now; m_record.Type = (int)AppEnum.ActionType.ReplyAnswer; User.USR_RecordBll.GetInstance().Add(m_record); if (model.CustomerSysNo == m_qa.CustomerSysNo) { User.USR_CustomerBll.GetInstance().AddPoint(AppConst.ReplyPoint, model.CustomerSysNo); User.USR_CustomerBll.GetInstance().AddExp(AppConst.ReplyExp, model.CustomerSysNo); User.USR_CustomerBll.GetInstance().AddCount(model.CustomerSysNo, 0, 0, 0, 1, 0, 0, 0, 0, 0); } else if (!isquest) { User.USR_CustomerBll.GetInstance().AddCount(model.CustomerSysNo, 0, 0, 0, 0, 0, 1, 0, 0, 0); } User.USR_CustomerBll.GetInstance().AddPoint(AppConst.CommentPoint, model.CustomerSysNo); User.USR_CustomerBll.GetInstance().AddExp(AppConst.CommentExp, model.CustomerSysNo); QA_AnswerMod m_answer = QA_AnswerBll.GetInstance().GetModel(model.AnswerSysNo); AppMod.User.USR_MessageMod m_notice = new AppMod.User.USR_MessageMod(); m_notice.CustomerSysNo = m_answer.CustomerSysNo; if (model.CustomerSysNo == m_qa.CustomerSysNo) { m_notice.Context = ""; m_notice.Title = AppConst.FeedbackReport.Replace("@url", AppConfig.HomeUrl() + "Quest/Question.aspx?id=" + m_qa.SysNo).Replace("@question", m_qa.Title); } else { m_notice.Context = ""; m_notice.Title = AppConst.CommentReport.Replace("@url", AppConfig.HomeUrl() + "Quest/Question.aspx?id=" + m_qa.SysNo); } m_notice.DR = 0; m_notice.IsRead = 0; m_notice.TS = DateTime.Now; m_notice.Type = (int)AppEnum.MessageType.notice; User.USR_MessageBll.GetInstance().AddMessage(m_notice); scope.Complete(); } }