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