protected void Button5_Click(object sender, EventArgs e) { int score = 0; try { score = int.Parse(txtScore.Text.Trim()); } catch { ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addAward", "alert('您输入的积分数不正确,请重新输入!');", true); ModalPopupExtender1.Show(); } QA_QuestionMod m_quest = QA_QuestionBll.GetInstance().GetModel(SysNo); int usedAward = QA_AnswerBll.GetInstance().GetUsedAward(SysNo); if (score > m_quest.Award - usedAward) { ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addAward", "alert('您输入的积分数不可超过" + (m_quest.Award - usedAward) + ",请重新输入!');", true); ModalPopupExtender1.Show(); return; } try { QA_AnswerMod m_answer = QA_AnswerBll.GetInstance().GetModel(int.Parse(HiddenField1.Value)); QA_AnswerBll.GetInstance().SetAward(m_answer, m_quest, score); ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addAward", "alert('悬赏分配成功!');", true); } catch { ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addAward", "alert('系统故障,请联系管理员');", true); } BindList(); }
public void SetOrder(QA_OrderMod order, QA_AnswerMod answer) { TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { int sysno = QA_AnswerBll.GetInstance().AddAnswer(answer); USR_CustomerBll.GetInstance().AddCount(answer.CustomerSysNo, 0, 0, 0, 0, 0, 0, 1, 0, 0); order.AnswerSysNo = sysno; Add(order); QA_QuestionMod m_qa = QA_QuestionBll.GetInstance().GetModel(order.QuestionSysNo); m_qa.OrderCount++; QA_QuestionBll.GetInstance().Update(m_qa); AppMod.User.USR_RecordMod m_record = new AppMod.User.USR_RecordMod(); m_record.CustomerSysNo = order.CustomerSysNo; m_record.TargetSysNo = sysno; m_record.TS = DateTime.Now; m_record.Type = (int)AppEnum.ActionType.SetOrder; User.USR_RecordBll.GetInstance().Add(m_record); scope.Complete(); } }
public void SetAward(QA_AnswerMod m_answer, QA_QuestionMod m_quest, int score) { TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { if (m_answer.Award == AppConst.IntNull) { m_answer.Award = score; } else { m_answer.Award += score; } QA_AnswerBll.GetInstance().Update(m_answer); USR_CustomerBll.GetInstance().AddPoint(score, m_answer.CustomerSysNo); USR_CustomerBll.GetInstance().AddCount(m_answer.CustomerSysNo, 0, 0, 1, 0, 0, 0, 0, 0, 0); int usedAward = QA_AnswerBll.GetInstance().GetUsedAward(m_quest.SysNo); if (score == m_quest.Award - usedAward) { m_quest.EndTime = DateTime.Now; QA_QuestionBll.GetInstance().Update(m_quest); } scope.Complete(); } }
//protected void lkbReply_Click(object sender, EventArgs e) //{ // if (GetSession().CustomerEntity == null || GetSession().CustomerEntity.SysNo == AppConst.IntNull) // { // return; // } // QA_AnswerMod m_answer = new QA_AnswerMod(); // m_answer.Award = 0; // m_answer.Context = Server.HtmlEncode(txtReply.Text.Trim()); // m_answer.CustomerSysNo = GetSession().CustomerEntity.SysNo; // m_answer.DR = (int)AppEnum.State.normal; // m_answer.Hate = 0; // m_answer.Love = 0; // m_answer.QuestionSysNo = SysNo; // m_answer.Title = ""; // m_answer.TS = DateTime.Now; // SaveReply(m_answer); // ClearReply(); // BindList(); //} protected void lkbReply2_Click(object sender, EventArgs e) { QA_AnswerMod m_answer = new QA_AnswerMod(); m_answer.Award = 0; m_answer.Context = AppCmn.CommonTools.SystemInputFilter(txtReply2.Text.Trim()); if (GetSession().CustomerEntity == null || GetSession().CustomerEntity.SysNo == AppConst.IntNull) { m_answer.CustomerSysNo = 0; } else { m_answer.CustomerSysNo = GetSession().CustomerEntity.SysNo; } m_answer.DR = (int)AppEnum.State.normal; m_answer.Hate = 0; m_answer.Love = 0; m_answer.QuestionSysNo = SysNo; m_answer.Title = ""; m_answer.TS = DateTime.Now; if (SaveReply(m_answer)) { ClearReply(); BindList(); } }
public int AddAnswer(QA_AnswerMod 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.ReplyQuest; User.USR_RecordBll.GetInstance().Add(m_record); User.USR_CustomerBll.GetInstance().AddPoint(AppConst.AnswerPoint, model.CustomerSysNo); User.USR_CustomerBll.GetInstance().AddExp(AppConst.AnswerExp, model.CustomerSysNo); if (model.CustomerSysNo != m_qa.CustomerSysNo) { AppMod.User.USR_MessageMod m_notice = new AppMod.User.USR_MessageMod(); m_notice.CustomerSysNo = m_qa.CustomerSysNo; m_notice.Context = ""; m_notice.DR = 0; m_notice.IsRead = 0; m_notice.Title = AppConst.AnswerReport.Replace("@url", AppConfig.HomeUrl() + "Quest/Question.aspx?id=" + m_qa.SysNo).Replace("@question", m_qa.Title); m_notice.TS = DateTime.Now; m_notice.Type = (int)AppEnum.MessageType.notice; User.USR_MessageBll.GetInstance().AddMessage(m_notice); if (isquest) { User.USR_CustomerBll.GetInstance().AddCount(model.CustomerSysNo, 0, 1, 0, 0, 0, 0, 0, 0, 0); } else { User.USR_CustomerBll.GetInstance().AddCount(model.CustomerSysNo, 0, 0, 0, 0, 0, 1, 0, 0, 0); } } else { User.USR_CustomerBll.GetInstance().AddCount(model.CustomerSysNo, 0, 0, 0, 0, 0, 1, 0, 0, 0); } scope.Complete(); return(sysno); } }
public ReturnValue <QA_QuestionShow <AstroMod> > SetAward(int answersysno, int score, string msg) { QA_AnswerMod m_anser = QA_AnswerBll.GetInstance().GetModel(answersysno); QA_AnswerBll.GetInstance().SetAward(m_anser, QA_QuestionBll.GetInstance().GetModel(m_anser.QuestionSysNo), score); return(GetQuestionForAstro(m_anser.SysNo)); }
public int AddAnswer(QA_AnswerMod 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.ReplyQuest; User.USR_RecordBll.GetInstance().Add(m_record); User.USR_CustomerBll.GetInstance().AddPoint(AppConst.AnswerPoint, model.CustomerSysNo); User.USR_CustomerBll.GetInstance().AddExp(AppConst.AnswerExp, model.CustomerSysNo); if (model.CustomerSysNo != m_qa.CustomerSysNo) { AppMod.User.USR_MessageMod m_notice = new AppMod.User.USR_MessageMod(); m_notice.CustomerSysNo = m_qa.CustomerSysNo; m_notice.Context = ""; m_notice.DR = 0; m_notice.IsRead = 0; m_notice.Title = AppConst.AnswerReport.Replace("@url", AppConfig.HomeUrl() + "Quest/Question.aspx?id=" + m_qa.SysNo).Replace("@question", m_qa.Title); m_notice.TS = DateTime.Now; m_notice.Type = (int)AppEnum.MessageType.notice; User.USR_MessageBll.GetInstance().AddMessage(m_notice); if (isquest) { User.USR_CustomerBll.GetInstance().AddCount(model.CustomerSysNo, 0, 1, 0, 0, 0, 0, 0, 0, 0); } else { User.USR_CustomerBll.GetInstance().AddCount(model.CustomerSysNo, 0, 0, 0, 0, 0, 1, 0, 0, 0); } } else { User.USR_CustomerBll.GetInstance().AddCount(model.CustomerSysNo, 0, 0, 0, 0, 0, 1, 0, 0, 0); } scope.Complete(); return sysno; } }
/// <summary> /// 得到一个对象实体 /// </summary> public QA_AnswerMod GetModel(int SysNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select SysNo, QuestionSysNo, CustomerSysNo, Title, Context, Love, Hate, Award, DR, TS from QA_Answer"); strSql.Append(" where SysNo=@SysNo "); SqlParameter[] parameters = { new SqlParameter("@SysNo", SqlDbType.Int, 4) }; parameters[0].Value = SysNo; QA_AnswerMod model = new QA_AnswerMod(); 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]["CustomerSysNo"].ToString() != "") { model.CustomerSysNo = int.Parse(ds.Tables[0].Rows[0]["CustomerSysNo"].ToString()); } model.Title = ds.Tables[0].Rows[0]["Title"].ToString(); model.Context = ds.Tables[0].Rows[0]["Context"].ToString(); if (ds.Tables[0].Rows[0]["Love"].ToString() != "") { model.Love = int.Parse(ds.Tables[0].Rows[0]["Love"].ToString()); } if (ds.Tables[0].Rows[0]["Hate"].ToString() != "") { model.Hate = int.Parse(ds.Tables[0].Rows[0]["Hate"].ToString()); } if (ds.Tables[0].Rows[0]["Award"].ToString() != "") { model.Award = int.Parse(ds.Tables[0].Rows[0]["Award"].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); } }
private void SaveReply(QA_AnswerMod m_answer) { try { QA_AnswerBll.GetInstance().AddAnswer(m_answer); RefreshSession(); ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addanswer", "alert('回答发布成功!');", true); } catch { ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addanswer", "alert('系统故障,发布失败!');", true); } }
public ReturnValue <bool> RemoveAnswer(int AnswerSysNo) { QA_AnswerMod m_anser = QA_AnswerBll.GetInstance().GetModel(AnswerSysNo); if (m_anser != null) { m_anser.DR = (int)AppEnum.State.deleted; QA_AnswerBll.GetInstance().Update(m_anser); return(ReturnValue <bool> .Get200OK(false)); } else { throw new BusinessException("该回复不存在!"); } }
/// <summary> /// 删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Delete() { try { QA_AnswerMod m_famous = QA_AnswerBll.GetInstance().GetModel(int.Parse(Request.QueryString["delete"])); m_famous.DR = (int)AppEnum.State.deleted; QA_AnswerBll.GetInstance().Update(m_famous); ltrNotice.Text = "该记录已删除!"; this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('noticediv').style.display='';", true); } catch { ltrError.Text = "系统错误,删除失败!"; this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('errordiv').style.display='';", true); } }
public bool IfReplyed(int answersysno, int questsysno) { bool ret = false; QA_QuestionMod m_qa = QA_QuestionBll.GetInstance().GetModel(questsysno); QA_AnswerMod m_answer = QA_AnswerBll.GetInstance().GetModel(answersysno); DataTable m_dt = GetListByAnswer(answersysno); for (int i = 0; i < m_dt.Rows.Count; i++) { if (m_dt.Rows[i]["CustomerSysNo"].ToString() == m_qa.CustomerSysNo.ToString()) { ret = true; break; } } return(ret); }
public ReturnValue<USR_CustomerShow> AddAnswer(int CustomerSysNo, int QuestionSysNo, string Title, string Context) { QA_AnswerMod m_answer = new QA_AnswerMod(); m_answer.Award = 0; m_answer.Title = Title; m_answer.Context = AppCmn.CommonTools.SystemInputFilter(Context.DoTrim()); m_answer.CustomerSysNo = CustomerSysNo; m_answer.DR = (int)AppEnum.State.normal; m_answer.Hate = 0; m_answer.Love = 0; m_answer.QuestionSysNo = QuestionSysNo; m_answer.Title = ""; m_answer.TS = DateTime.Now; QA_AnswerBll.GetInstance().AddAnswer(m_answer); USR_CustomerShow ret = new USR_CustomerShow(); USR_CustomerBll.GetInstance().GetModel(CustomerSysNo).MemberwiseCopy(ret); return ReturnValue<USR_CustomerShow>.Get200OK(ret); }
public ReturnValue <USR_CustomerShow> AddAnswer(int CustomerSysNo, int QuestionSysNo, string Title, string Context) { QA_AnswerMod m_answer = new QA_AnswerMod(); m_answer.Award = 0; m_answer.Title = Title; m_answer.Context = AppCmn.CommonTools.SystemInputFilter(Context.DoTrim()); m_answer.CustomerSysNo = CustomerSysNo; m_answer.DR = (int)AppEnum.State.normal; m_answer.Hate = 0; m_answer.Love = 0; m_answer.QuestionSysNo = QuestionSysNo; m_answer.Title = ""; m_answer.TS = DateTime.Now; QA_AnswerBll.GetInstance().AddAnswer(m_answer); USR_CustomerShow ret = new USR_CustomerShow(); USR_CustomerBll.GetInstance().GetModel(CustomerSysNo).MemberwiseCopy(ret); return(ReturnValue <USR_CustomerShow> .Get200OK(ret)); }
public void SetOrder(QA_OrderMod order,QA_AnswerMod answer) { TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { int sysno = QA_AnswerBll.GetInstance().AddAnswer(answer); USR_CustomerBll.GetInstance().AddCount(answer.CustomerSysNo, 0, 0, 0, 0, 0, 0, 1, 0, 0); order.AnswerSysNo = sysno; Add(order); QA_QuestionMod m_qa = QA_QuestionBll.GetInstance().GetModel(order.QuestionSysNo); m_qa.OrderCount++; QA_QuestionBll.GetInstance().Update(m_qa); AppMod.User.USR_RecordMod m_record = new AppMod.User.USR_RecordMod(); m_record.CustomerSysNo = order.CustomerSysNo; m_record.TargetSysNo = sysno; m_record.TS = DateTime.Now; m_record.Type = (int)AppEnum.ActionType.SetOrder; User.USR_RecordBll.GetInstance().Add(m_record); scope.Complete(); } }
private bool SaveReply(QA_AnswerMod m_answer) { try { QA_AnswerBll.GetInstance().AddAnswer(m_answer); RefreshSession(); ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addanswer", "alert('回答发布成功!');", true); return true; } catch { ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "addanswer", "alert('系统故障,发布失败!');", true); return false; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(QA_AnswerMod model) { return dal.Add(model); }
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 Update(QA_AnswerMod model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update QA_Answer set "); strSql.Append("QuestionSysNo=@QuestionSysNo,"); strSql.Append("CustomerSysNo=@CustomerSysNo,"); strSql.Append("Title=@Title,"); strSql.Append("Context=@Context,"); strSql.Append("Love=@Love,"); strSql.Append("Hate=@Hate,"); strSql.Append("Award=@Award,"); 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("@CustomerSysNo",SqlDbType.Int,4), new SqlParameter("@Title",SqlDbType.NVarChar,600), new SqlParameter("@Context",SqlDbType.NVarChar,-1), new SqlParameter("@Love",SqlDbType.Int,4), new SqlParameter("@Hate",SqlDbType.Int,4), new SqlParameter("@Award",SqlDbType.Int,4), 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.CustomerSysNo != AppConst.IntNull) parameters[2].Value = model.CustomerSysNo; else parameters[2].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[2]); if (model.Title != AppConst.StringNull) parameters[3].Value = model.Title; 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.Love != AppConst.IntNull) parameters[5].Value = model.Love; else parameters[5].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[5]); if (model.Hate != AppConst.IntNull) parameters[6].Value = model.Hate; else parameters[6].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[6]); if (model.Award != AppConst.IntNull) parameters[7].Value = model.Award; else parameters[7].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[7]); if (model.DR != AppConst.IntNull) parameters[8].Value = model.DR; else parameters[8].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[8]); if (model.TS != AppConst.DateTimeNull) parameters[9].Value = model.TS; else parameters[9].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[9]); return SqlHelper.ExecuteNonQuery(cmd, parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public QA_AnswerMod GetModel(int SysNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select SysNo, QuestionSysNo, CustomerSysNo, Title, Context, Love, Hate, Award, DR, TS from QA_Answer"); strSql.Append(" where SysNo=@SysNo "); SqlParameter[] parameters = { new SqlParameter("@SysNo", SqlDbType.Int,4 ) }; parameters[0].Value = SysNo; QA_AnswerMod model = new QA_AnswerMod(); 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]["CustomerSysNo"].ToString() != "") { model.CustomerSysNo = int.Parse(ds.Tables[0].Rows[0]["CustomerSysNo"].ToString()); } model.Title = ds.Tables[0].Rows[0]["Title"].ToString(); model.Context = ds.Tables[0].Rows[0]["Context"].ToString(); if (ds.Tables[0].Rows[0]["Love"].ToString() != "") { model.Love = int.Parse(ds.Tables[0].Rows[0]["Love"].ToString()); } if (ds.Tables[0].Rows[0]["Hate"].ToString() != "") { model.Hate = int.Parse(ds.Tables[0].Rows[0]["Hate"].ToString()); } if (ds.Tables[0].Rows[0]["Award"].ToString() != "") { model.Award = int.Parse(ds.Tables[0].Rows[0]["Award"].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; } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(QA_AnswerMod model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(QA_AnswerMod model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into QA_Answer("); strSql.Append("QuestionSysNo,CustomerSysNo,Title,Context,Love,Hate,Award,DR,TS)"); strSql.Append(" values ("); strSql.Append("@QuestionSysNo,@CustomerSysNo,@Title,@Context,@Love,@Hate,@Award,@DR,@TS)"); strSql.Append(";select SCOPE_IDENTITY()"); SqlCommand cmd = new SqlCommand(strSql.ToString()); SqlParameter[] parameters = { new SqlParameter("@QuestionSysNo", SqlDbType.Int, 4), new SqlParameter("@CustomerSysNo", SqlDbType.Int, 4), new SqlParameter("@Title", SqlDbType.NVarChar, 600), new SqlParameter("@Context", SqlDbType.NVarChar, -1), new SqlParameter("@Love", SqlDbType.Int, 4), new SqlParameter("@Hate", SqlDbType.Int, 4), new SqlParameter("@Award", SqlDbType.Int, 4), 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.CustomerSysNo != AppConst.IntNull) { parameters[1].Value = model.CustomerSysNo; } else { parameters[1].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[1]); if (model.Title != AppConst.StringNull) { parameters[2].Value = model.Title; } 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.Love != AppConst.IntNull) { parameters[4].Value = model.Love; } else { parameters[4].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[4]); if (model.Hate != AppConst.IntNull) { parameters[5].Value = model.Hate; } else { parameters[5].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[5]); if (model.Award != AppConst.IntNull) { parameters[6].Value = model.Award; } else { parameters[6].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[6]); if (model.DR != AppConst.IntNull) { parameters[7].Value = model.DR; } else { parameters[7].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[7]); if (model.TS != AppConst.DateTimeNull) { parameters[8].Value = model.TS; } else { parameters[8].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[8]); return(Convert.ToInt32(SqlHelper.ExecuteScalar(cmd, parameters))); }
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 Add(QA_AnswerMod model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into QA_Answer("); strSql.Append("QuestionSysNo,CustomerSysNo,Title,Context,Love,Hate,Award,DR,TS)"); strSql.Append(" values ("); strSql.Append("@QuestionSysNo,@CustomerSysNo,@Title,@Context,@Love,@Hate,@Award,@DR,@TS)"); strSql.Append(";select SCOPE_IDENTITY()"); SqlCommand cmd = new SqlCommand(strSql.ToString()); SqlParameter[] parameters = { new SqlParameter("@QuestionSysNo",SqlDbType.Int,4), new SqlParameter("@CustomerSysNo",SqlDbType.Int,4), new SqlParameter("@Title",SqlDbType.NVarChar,600), new SqlParameter("@Context",SqlDbType.NVarChar,-1), new SqlParameter("@Love",SqlDbType.Int,4), new SqlParameter("@Hate",SqlDbType.Int,4), new SqlParameter("@Award",SqlDbType.Int,4), 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.CustomerSysNo != AppConst.IntNull) parameters[1].Value = model.CustomerSysNo; else parameters[1].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[1]); if (model.Title != AppConst.StringNull) parameters[2].Value = model.Title; 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.Love != AppConst.IntNull) parameters[4].Value = model.Love; else parameters[4].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[4]); if (model.Hate != AppConst.IntNull) parameters[5].Value = model.Hate; else parameters[5].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[5]); if (model.Award != AppConst.IntNull) parameters[6].Value = model.Award; else parameters[6].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[6]); if (model.DR != AppConst.IntNull) parameters[7].Value = model.DR; else parameters[7].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[7]); if (model.TS != AppConst.DateTimeNull) parameters[8].Value = model.TS; else parameters[8].Value = System.DBNull.Value; cmd.Parameters.Add(parameters[8]); return Convert.ToInt32(SqlHelper.ExecuteScalar(cmd, parameters)); }
protected void LinkButton1_Click(object sender, EventArgs e) { Login(Request.Url.ToString()); if (order == 0) { #region 判断输入项 decimal price = 0; try { price = decimal.Parse(TextBox3.Text.Trim()); pricetip.InnerHtml = ""; } catch { pricetip.InnerHtml = "<samp>预计消费金额只可填写数字,请重新输入</samp>"; } int words = 0; try { words = int.Parse(TextBox2.Text.Trim()); wordstip.InnerHtml = ""; } catch { wordstip.InnerHtml = "<samp>最少字数只可填写数字,请重新输入</samp>"; } #endregion QA_AnswerMod m_answer = new QA_AnswerMod(); m_answer.Award = 0; m_answer.Context = ""; if (GetSession().CustomerEntity == null || GetSession().CustomerEntity.SysNo == AppConst.IntNull) { m_answer.CustomerSysNo = 0; } else { m_answer.CustomerSysNo = GetSession().CustomerEntity.SysNo; } m_answer.DR = (int)AppEnum.State.normal; m_answer.Hate = 0; m_answer.Love = 0; m_answer.QuestionSysNo = SysNo; m_answer.Title = ""; m_answer.TS = DateTime.Now; QA_OrderMod m_order = new QA_OrderMod(); m_order.CustomerSysNo = m_answer.CustomerSysNo; m_order.Description = txtDescription.Text.Trim(); m_order.Price = price; m_order.QuestionSysNo = m_answer.QuestionSysNo; m_order.Score = AppConst.IntNull; m_order.Status = (int)AppEnum.ConsultOrderStatus.beforepay; m_order.Trial = txtTrial.Text.Trim(); m_order.TS = DateTime.Now; m_order.Words = words; try { QA_OrderBll.GetInstance().SetOrder(m_order, m_answer); Page.ClientScript.RegisterStartupScript(this.GetType(), "ok", "alert('报价发布成功!');location.href='" + AppConfig.HomeUrl() + "Quest/Consult/" + SysNo + "'", true); } catch (Exception ex) { Page.ClientScript.RegisterStartupScript(this.GetType(), "nook", "alert('系统故障,发布失败!');", true); } } else { QA_AnswerMod m_answer = QA_AnswerBll.GetInstance().GetModel(old_order.AnswerSysNo); m_answer.Context = txtContext.Text; old_order.Status = (int)AppEnum.ConsultOrderStatus.beforeconfirm; try { QA_AnswerBll.GetInstance().Update(m_answer); QA_OrderBll.GetInstance().Update(old_order); Page.ClientScript.RegisterStartupScript(this.GetType(), "ok", "alert('解答提交成功!');location.href='" + AppConfig.HomeUrl() + "Quest/Consult/" + SysNo + "'", true); } catch (Exception ex) { Page.ClientScript.RegisterStartupScript(this.GetType(), "nook", "alert('系统故障,提交失败!');", true); } } }
/// <summary> /// 更新一条数据 /// </summary> public int Update(QA_AnswerMod model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update QA_Answer set "); strSql.Append("QuestionSysNo=@QuestionSysNo,"); strSql.Append("CustomerSysNo=@CustomerSysNo,"); strSql.Append("Title=@Title,"); strSql.Append("Context=@Context,"); strSql.Append("Love=@Love,"); strSql.Append("Hate=@Hate,"); strSql.Append("Award=@Award,"); 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("@CustomerSysNo", SqlDbType.Int, 4), new SqlParameter("@Title", SqlDbType.NVarChar, 600), new SqlParameter("@Context", SqlDbType.NVarChar, -1), new SqlParameter("@Love", SqlDbType.Int, 4), new SqlParameter("@Hate", SqlDbType.Int, 4), new SqlParameter("@Award", SqlDbType.Int, 4), 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.CustomerSysNo != AppConst.IntNull) { parameters[2].Value = model.CustomerSysNo; } else { parameters[2].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[2]); if (model.Title != AppConst.StringNull) { parameters[3].Value = model.Title; } 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.Love != AppConst.IntNull) { parameters[5].Value = model.Love; } else { parameters[5].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[5]); if (model.Hate != AppConst.IntNull) { parameters[6].Value = model.Hate; } else { parameters[6].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[6]); if (model.Award != AppConst.IntNull) { parameters[7].Value = model.Award; } else { parameters[7].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[7]); if (model.DR != AppConst.IntNull) { parameters[8].Value = model.DR; } else { parameters[8].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[8]); if (model.TS != AppConst.DateTimeNull) { parameters[9].Value = model.TS; } else { parameters[9].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[9]); return(SqlHelper.ExecuteNonQuery(cmd, parameters)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(QA_AnswerMod model) { return(dal.Add(model)); }