/// <summary>
/// 绑定列表
/// </summary>
/// <param name="page"></param>
private void BindList(int page)
{
int a = 1 + ((page - 1) * pagesize); // 排序
StringBuilder str = new StringBuilder();
DataTable dts = new DataTable();
IList <MySqlParameter> parm = new List <MySqlParameter>();
if (IsRepare)
{
//dts = feedBackMessage.GetAllByWhere(" (fb.Fb_solveUser='******' or fb.Fb_solveUser is null or fb.Fb_solveUser = '')", GetUserID(), " Pf_id, Fb_state, Fb_addTime desc");
dts = feedBackMessage.GetAllByWhere(" (fb.Fb_solveUser=@GetUserID or fb.Fb_solveUser is null or fb.Fb_solveUser = '')", GetUserID(), " Pf_id, Fb_state, Fb_addTime desc", GetUserID());
parm.Add(new MySqlParameter("@GetUserID", GetUserID()));
}
else
{
dts = feedBackMessage.GetAllByWhere(" fb.Fb_addUser=@GetUserID ", GetUserID(), " Pf_id, Fb_state, Fb_addTime desc", GetUserID());
parm.Add(new MySqlParameter("@GetUserID", GetUserID()));
}
DataTable dt = CommonPage.GetPagedTable(dts, page, pagesize);
AspNetPager1.PageSize = pagesize; //每页显示的数据条数
AspNetPager1.RecordCount = dts.Rows.Count; ////获取数据总数
foreach (DataRow dr in dt.Rows) // 循环所有数据
{
str.Append(" <div class=\"box\"> ");
str.Append(" <div class=\"title\"> ");
str.Append(" <table> ");
str.Append(" <tr> ");
str.Append(" <td width=\"45%\" style=\"background-color: #E9F2F7\"> ");
str.Append(" " + a + "、" + dr["Fb_title"] + " ");
str.Append(" </td> ");
str.Append(" <td width=\"220px\" style=\"background-color: #E9F2F7\"> ");
str.Append(dr["Pf_name"].ToString());
str.Append(" </td> ");
str.Append(" <td width=\"100px\" style=\"background-color: #E9F2F7\"> ");
str.Append(" " + dr["Ur_names"].ToString() + " ");
str.Append(" </td> ");
str.Append(" <td width=\"200px\" style=\"background-color: #CADEE8\"> ");
str.Append(" " + dr["Fb_addTime"].ToString() + " ");
str.Append(" </td> ");
if (dr["Fb_state"].ToString() == "0")
{
str.Append(" <td width=\"55px\" style=\"background-color: #6494B6; color: White;\"> ");
str.Append("未解决");
}
else if (dr["Fb_state"].ToString() == "1")
{
str.Append(" <td width=\"55px\" style=\"background-color: #6494B6; color: White;\"> ");
str.Append("解决");
}
else if (dr["Fb_state"].ToString() == "2")
{
str.Append(" <td width=\"55px\" style=\"background-color: #6494B6; color: White;\"> ");
str.Append("保留");
}
else if (dr["Fb_state"].ToString() == "3")
{
str.Append(" <td width=\"55px\" style=\"background-color: #6494B6; color: Red;\"> ");
str.Append("处理中");
}
str.Append("</td> ");
str.Append(" <td width=\"100px\" style=\"background-color: #E9F2F7\"> ");
str.Append(" " + dr["Ur_name"].ToString() + " ");
str.Append(" </td> ");
str.Append(" <td width=\"200px\" style=\"background-color: #CADEE8\"> ");
str.Append(" " + dr["Fb_solveTime"].ToString() + " ");
str.Append(" </td> ");
str.Append(" </tr> ");
str.Append(" </table> ");
str.Append(" </div> ");
str.Append(" <div class=\"text\"> ");
str.Append(" <table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"3\" align=\"center\"> ");
str.Append(" <tr> ");
str.Append(" <td bgcolor=\"#cadee8\" width=\"10%\"> ");
str.Append(" 所属平台: ");
str.Append(" </td> ");
str.Append(" <td bgcolor=\"#e9f2f7\" width=\"40%\"> ");
str.Append(" " + dr["Pf_name"].ToString() + " ");
if (IsRepare)
{
str.Append(" <div style=\"width:15%; float:right;\"><a href=\"javascript:void()\" onclick=\"UpDateState('" + dr["Fb_id"].ToString() + "',3)\"><span style=\"color:Blue\">接受修改该问题</span></a></div>");
}
str.Append(" </td> ");
str.Append(" </tr> ");
str.Append(" <tr> ");
str.Append(" <td bgcolor=\"#cadee8\"> ");
str.Append(" 提交人: ");
str.Append(" </td> ");
str.Append(" <td bgcolor=\"#e9f2f7\"> ");
str.Append(" " + dr["Ur_names"].ToString() + " ");
str.Append(" </td> ");
str.Append(" </tr> ");
str.Append(" <tr> ");
str.Append(" <td bgcolor=\"#cadee8\"> ");
str.Append(" 提交时间: ");
str.Append(" </td> ");
str.Append(" <td bgcolor=\"#e9f2f7\"> ");
str.Append(" " + dr["Fb_addTime"].ToString() + " ");
str.Append(" </td> ");
str.Append(" </tr> ");
str.Append(" <tr> ");
str.Append(" <td bgcolor=\"#cadee8\"> ");
str.Append(" 反馈标题： ");
str.Append(" </td> ");
str.Append(" <td bgcolor=\"#e9f2f7\"> ");
str.Append(" " + dr["Fb_title"].ToString() + " ");
str.Append(" </td> ");
str.Append(" </tr> ");
str.Append(" <tr> ");
str.Append(" <td bgcolor=\"#cadee8\"> ");
str.Append(" 是否上传图片： ");
str.Append(" </td> ");
str.Append(" <td bgcolor=\"#e9f2f7\"> ");
if (dr["Fb_url"].ToString() != "")
{
if (IsRepare)
{
str.Append(" <span style=\"padding-left:50px;\"></span><a href=\"../File/FeedBackFile/" + dr["Fb_url"].ToString() + "\">" + dr["Fb_url"].ToString() + "</a><span style=\"color:Red;\"> (点击文件可直接下载)</span>");
}
else
{
str.Append(" 是");
}
}
else
{
str.Append(" 否 ");
}
str.Append(" </td> ");
str.Append(" </tr> ");
str.Append(" <tr> ");
str.Append(" <td bgcolor=\"#cadee8\"> ");
str.Append(" 反馈内容： ");
str.Append(" </td> ");
str.Append(" <td bgcolor=\"#e9f2f7\"> ");
str.Append(" " + dr["Fb_description"].ToString() + " ");
str.Append(" </td> ");
str.Append(" </tr> ");
str.Append(" <tr> ");
str.Append(" <td bgcolor=\"#cadee8\"> ");
str.Append(" 管理员回复内容： ");
str.Append(" </td> ");
str.Append(" <td bgcolor=\"#e9f2f7\" style=\"color: Red;\"> ");
if (IsRepare)
{
str.Append(" <textarea id=\"txt_solvedescription_" + dr["Fb_id"].ToString() + "\" style=\"width:574px; height:108px\">" + dr["Fb_solvedescription"].ToString() + "</textarea> ");
str.Append(" <div align=\"right\"><a href=\"javascript:void()\" onclick=\"Updatesolvedescription('您确定要提交信息么？状态将被改成解决！','" + dr["Fb_id"].ToString() + "',1)\"><span style=\"color:Blue\">提交回复信息</span></a><div>");
str.Append(" <div align=\"right\"><a href=\"javascript:void()\" onclick=\"Updatesolvedescription('您确定要提交信息么？状态将被改成保留！','" + dr["Fb_id"].ToString() + "',2)\"><span style=\"color:Blue\">状态为保留并回复信息</span></a><div>");
}
else
{
str.Append(" " + dr["Fb_solvedescription"].ToString() + " ");
}
str.Append(" </td> ");
str.Append(" </tr> ");
str.Append(" </table> ");
str.Append(" </div> ");
str.Append(" </div> ");
a++;
}
div_show.InnerHtml = str.ToString();
}
