protected void btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { //创建用户数据表操作类对象 QuestionOperate questions = new QuestionOperate(); string ancontent = this.txtAnwser.Text.Trim(); string name = Session["UserID"].ToString(); string id = Request.QueryString["ID"].ToString(); //增加用户数据 if (questions.ReplyQues(id, name, ancontent)) { Common.ShowMsg("回复成功!"); string newsname = this.txtQuesName.Text; string subNewName = newsname; //记录操作员操作 if (newsname.Length > 16) { subNewName = newsname.Substring(0, 16) + "..."; } RecordOperate.SaveRecord(Session["UserID"].ToString(), "系统功能", "回复问题反馈信息:" + subNewName); } else { return; } } Server.Transfer("System_QuestionFB_View.aspx"); }
protected void btnDelete_Click(object sender, EventArgs e) { //创建用户数据表操作类对象 QuestionOperate questions = new QuestionOperate(); string Id = Request.QueryString["ID"].ToString(); //删除用户数据 if (questions.DelQues(Id)) { Common.ShowMsg("删除成功!"); string newsname = this.txtQuesName.Text; string subNewName = newsname; //记录操作员操作 if (newsname.Length > 16) { subNewName = newsname.Substring(0, 16) + "..."; } RecordOperate.SaveRecord(Session["UserID"].ToString(), "系统功能", "删除问题反馈信息:" + subNewName); } else { return; } Server.Transfer("System_QuestionFB_View.aspx"); }
protected void GoodsDataGrid_ItemCommand(object source, DataGridCommandEventArgs e) { if (e.CommandName == "Delete") { //创建用户数据表操作类对象 QuestionOperate question = new QuestionOperate(); string Id = ((Label)e.Item.Cells[1].Controls[1]).Text; //删除用户数据 if (question.DelQues(Id)) { Common.ShowMsg("删除成功!"); string newsname = ((Label)e.Item.Cells[2].Controls[1]).Text; string subNewName = newsname; //记录操作员操作 if (newsname.Length > 16) { subNewName = newsname.Substring(0, 16) + "..."; } RecordOperate.SaveRecord(Session["UserID"].ToString(), "系统功能", "删除问题反馈信息:" + subNewName); } Server.Transfer("System_QuestionFB_View.aspx"); } else if (e.CommandName == "Select") { string Url = "System_QuestionFB_Reply.aspx?Id=" + ((Label)e.Item.Cells[1].Controls[1]).Text; Server.Transfer(Url); } else { string Url = "System_QuestionFB_Edit.aspx?Id=" + ((Label)e.Item.Cells[1].Controls[1]).Text; Server.Transfer(Url); } }
/// <summary> /// 绑定数据到DataGrid控件GoodsDataGrid上 /// </summary> private void BindDataGrid() { //创建操作员记录数据表类实例 QuestionOperate question = new QuestionOperate(); //获取记录数据 DataTable dt = question.Bind(Session["UserGroupID"].ToString(), Session["UserID"].ToString()); DataView dv = new DataView(); dt.TableName = "Questions"; if (dt != null) { dv.Table = dt; dv.Sort = " QuestionTime DESC"; if (ViewState["Condition"] != null && ViewState["Condition"].ToString() != "") { dv.RowFilter = ViewState["Condition"].ToString(); } else { dv = dt.DefaultView; } //新增ID自增值列绑定 dt.Columns.Add(new DataColumn("idno", Type.GetType("System.Int32"))); int intCountRecNum = dv.Count; //获取数据表记录数 for (int i = 0; i < intCountRecNum; i++) { dv[i]["idno"] = i + 1; } GoodsDataGrid.DataSource = dv; int PageCount = 0; if (intCountRecNum % GoodsDataGrid.PageSize == 0) { PageCount = intCountRecNum / GoodsDataGrid.PageSize; } else { PageCount = intCountRecNum / GoodsDataGrid.PageSize + 1; } if (PageCount != 0 && GoodsDataGrid.CurrentPageIndex >= PageCount) { GoodsDataGrid.CurrentPageIndex = PageCount - 1; } GoodsDataGrid.DataBind(); lblRecNum.Text = intCountRecNum.ToString(); //显示总记录数 ShowStats(); //显示页数信息 } }
/// <summary> /// 填充数据到表单文本控件,下拉框控件 /// </summary> /// <param name="IsFill"></param> private void FillDataToCtrl(bool IsFill) { DBManager db = DBManager.Instance(); QuestionOperateDB questionsdb = new QuestionOperateDB(); if (IsFill) { QuestionOperate questions = new QuestionOperate(); questionsdb = questions.FindQues(Request.QueryString["ID"].ToString()); txtQuesName.Text = Common.CCToEmpty(questionsdb.QAName); txtQuesContent.Text = Common.CCToEmpty(questionsdb.Question); lblQer.Text = Common.CCToEmpty(questionsdb.Qer); lblTime.Text = Common.CCToEmpty(questionsdb.QuestionTime.ToString()); txtAnwser.Text = Common.CCToEmpty(questionsdb.Anwser); lblAer.Text = Common.CCToEmpty(questionsdb.Aer); lblATime.Text = Common.CCToEmpty(questionsdb.AnwserTime.ToString()); } else { questionsdb = new QuestionOperateDB(); } }
protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { //程序模块权限验证 Authorization clsRighter = new Authorization("0609"); btnAdd.Enabled = clsRighter.Modify | clsRighter.Add; if (clsRighter.Read) { //创建操作员记录数据表类实例 QuestionOperate question = new QuestionOperate(); //获取记录数据 DataTable dt = question.ShowQuestion(); DataRow df = dt.NewRow(); df["UserName"] = "******"; dt.Rows.InsertAt(df, 0); ddlQues.DataSource = dt; ddlQues.DataTextField = "UserName"; ddlQues.DataValueField = "UserId"; ddlQues.DataBind(); //控制前台的“编辑”“回复”的显示方式 //DBManager db = DBManager.Instance();//通用数据操作类 //string sql = db.GetValue("select GroupId from Sys_User where UserId='" + Session["UserID"].ToString() + "'").ToString(); //int count = int.Parse(sql); ButtonColumn sel = (ButtonColumn)GoodsDataGrid.Columns[8]; EditCommandColumn edit = (EditCommandColumn)GoodsDataGrid.Columns[6]; if (Session["UserGroupID"].ToString() != "2" && Session["UserGroupID"].ToString() != "3") { sel.Visible = true; edit.Visible = false; this.btnAdd.Visible = false; } else { sel.Visible = false; edit.Visible = true; this.btnAdd.Visible = true; ddlQues.SelectedValue = Session["UserID"].ToString(); ddlQues.Enabled = false; } BindDataGrid(); int icount = this.GoodsDataGrid.Columns.Count; if (!clsRighter.Add) { this.btnAdd.Visible = false; } //if (!clsRighter.Modify) //{ // this.GoodsDataGrid.Columns[icount - 2].Visible = false; //} if (!clsRighter.Delete) { this.GoodsDataGrid.Columns[icount - 2].Visible = false; } } } }
protected void btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { //创建用户数据表操作类对象 QuestionOperate questions = new QuestionOperate(); if (ViewState["OperateStatus"].ToString() == "AddData") { string quesname = this.txtQuesName.Text.Trim(); string quescontent = this.txtQuesContent.Text.Trim(); string name = Session["UserID"].ToString(); this.showtr.Visible = false; //增加用户数据 if (questions.AddQues(quesname, quescontent, name)) { Common.ShowMsg("添加成功!"); string newsname = this.txtQuesName.Text; string subNewName = newsname; //记录操作员操作 if (newsname.Length > 16) { subNewName = newsname.Substring(0, 16) + "..."; } RecordOperate.SaveRecord(Session["UserID"].ToString(), "系统功能", "添加问题反馈信息:" + subNewName); } else { return; } } if (ViewState["OperateStatus"].ToString() == "EditData") { string quesname = this.txtQuesName.Text.Trim(); string quescontent = ""; if (this.trNew.Visible == false) { quescontent = this.txtQuesContent.Text.Trim(); } else { quescontent = this.txtNewContent.Text.Trim(); } string id = Request.QueryString["ID"].ToString(); this.showtr.Visible = true; //更新用户数据 if (questions.UpdateQues(id, quesname, quescontent)) { Common.ShowMsg("更新成功!"); string newsname = this.txtQuesName.Text; string subNewName = newsname; //记录操作员操作 if (newsname.Length > 16) { subNewName = newsname.Substring(0, 16) + "..."; } RecordOperate.SaveRecord(Session["UserID"].ToString(), "系统功能", "修改问题反馈信息:" + subNewName); } else { return; } } } Server.Transfer("System_QuestionFB_View.aspx"); }