/// <summary>
/// 获取实体分页
/// </summary>
public DataTable GetCall_FAQList(Call_FAQListTO TO, int pageIndex, int pageSize, string orderBy, out int rowCount)
{
string table = " [Call_FAQList] ";
string pk = " CF_ID ";
string fields = " * ";
string filter = "1=1";// string.Format(" Status={0} ", ConstantsManager.JiLuZhuangTai.Normal);
#region 组织查询条件
if (TO.CF_SoftTypeID > 0)
{
filter += string.Format(" and CF_SoftTypeID = {0} ", TO.CF_SoftTypeID);
}
if (!string.IsNullOrEmpty(TO.CF_ErrorList))
{
filter += string.Format(" and CF_ErrorList like '%{0}%' ", StringHelper.SQLFilter(TO.CF_ErrorList));
}
if (TO.CF_AddDate > Convert.ToDateTime("1980-01-01"))
{
filter += string.Format(" and CF_AddDate >= '{0}' ", TO.CF_AddDate.ToString("yyyy-MM-dd"));
}
if (TO.CF_EndDate > Convert.ToDateTime("1980-01-01"))
{
filter += string.Format(" and CF_AddDate < '{0}' ", TO.CF_EndDate.AddDays(1).ToString("yyyy-MM-dd"));
}
#endregion
string sort = " CF_ID DESC ";//排序
if (!string.IsNullOrEmpty(orderBy))
{
sort = orderBy;
}
SqlParameter[] parameters =
{
new SqlParameter("@Tables", SqlDbType.VarChar, 1000),
new SqlParameter("@PK", SqlDbType.VarChar, 100),
new SqlParameter("@Fields", SqlDbType.VarChar, 1000),
new SqlParameter("@Pageindex", SqlDbType.Int),
new SqlParameter("@PageSize", SqlDbType.Int),
new SqlParameter("@Filter", SqlDbType.VarChar, 1000),
new SqlParameter("@Sort", SqlDbType.VarChar, 200),
new SqlParameter("@RowCount", SqlDbType.Int)
};
parameters[0].Value = table;
parameters[1].Value = pk;
parameters[2].Value = fields;
parameters[3].Value = pageIndex;
parameters[4].Value = pageSize;
parameters[5].Value = filter;
parameters[6].Value = sort;
parameters[7].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.RunProcedure("SP_DividePage", parameters, "Call_FAQList");
rowCount = (int)parameters[7].Value;
return(ds.Tables[0]);
}
/// <summary>
/// 获得数据列表分页
/// </summary>
/// <returns></returns>
public DataTable GetCall_FAQListList(Call_FAQListTO TO, int pageIndex, int pageSize, string orderBy, out int rowCount)
{
return(service.GetCall_FAQList(TO, pageIndex, pageSize, orderBy, out rowCount));
}
private void DataBind()
{
Call_FAQListTO sto = new Call_FAQListTO();
#region 条件
if (!string.IsNullOrEmpty(Request["sltType"]))
{
sto.CF_SoftTypeID = Convert.ToInt32(Request["sltType"].ToString().Trim());//类型
}
if (!string.IsNullOrEmpty(Request["pErrorList"]))
{
sto.CF_ErrorList = Request["pErrorList"].ToString().Trim();//标题
}
//else
// sto.CF_SoftTypeID = Convert.ToInt32(Request["uname"].ToString().Trim());//存 用户名称
if (!string.IsNullOrEmpty(Request["stime"]))
{
DateTime dtStime = Convert.ToDateTime("1980-01-01");
DateTime.TryParse(Request["stime"].ToString().Trim(), out dtStime);
sto.CF_AddDate = dtStime;//保存操作开始时间
}
if (!string.IsNullOrEmpty(Request["etime"]))
{
DateTime dtEtime = Convert.ToDateTime("2250-01-01");
DateTime.TryParse(Request["etime"].ToString().Trim(), out dtEtime);
sto.CF_EndDate = dtEtime;//保存操作结束时间
}
#endregion
if (!string.IsNullOrEmpty(Request.QueryString["pageIndex"]))
{
int.TryParse(Request.QueryString["pageIndex"], out pageIndex);
}
HYTD.BLL.Call_FAQListBLL bll = new HYTD.BLL.Call_FAQListBLL();
DataTable dt = bll.GetCall_FAQListList(sto, pageIndex, pageSize, "", out rowCount);
//分页
string getUrl = "";
if (Request.Url.Query.Length > 0 && Request.Url.Query.IndexOf("pageIndex") > -1 && Request.Url.Query.IndexOf("&") > -1)
{
getUrl = Request.Url.Query.Substring(Request.Url.Query.IndexOf("&"));
}
else if (Request.Url.Query.Length > 0)
{
getUrl = Request.Url.Query.Substring(1);
}
string url = "FAQList.aspx?pageIndex={0}&" + getUrl.Trim('&');
strtt = DividePage.Pager(pageSize, rowCount, pageIndex, url);
if (dt.Rows.Count > 0)
{
int num = 0;
StringBuilder sbContent = new StringBuilder();
//string strNew = string.Empty;
string strEdit = string.Empty;
string strDelete = string.Empty;
foreach (DataRow dr in dt.Rows)
{
num++;
//strNew = string.Format("<a href=\"javascript:;\" name=\"NewFAQ\" onclick=\"NewFAQ({0})\" >新建</a> ", dr["CF_ID"]);
strEdit = string.Format("<a href=\"javascript:;\" name=\"EditFAQ\" onclick=\"EditFAQ({0})\">修改</a>", dr["CF_ID"].ToString());
strDelete = string.Format("<a href=\"javascript:;\" name=\"DeleteFAQ\" onclick=\"DeleteFAQ({0})\">删除</a>", dr["CF_ID"].ToString());
sbContent.AppendFormat("<tbody>");
sbContent.AppendFormat("<tr>");
sbContent.AppendFormat("<td class=\"num\" title=\"{0}\">{0} </td>", num);
sbContent.AppendFormat("<td class=\"num\" title=\"{0}\"><a href=\"javascript:;\" onclick=\"ShowFAQ({1})\">{0}</a></td>", dr["CF_ErrorList"].ToString(), dr["CF_ID"].ToString());
sbContent.AppendFormat("<td class=\"num\" title=\"{0}\">{0} </td>", dr["CF_Describe"]);
sbContent.AppendFormat("<td class=\"num\" title=\"{0}\">{0} </td>", dr["CF_AddDate"]);
sbContent.AppendFormat("<td class=\"num\" title=\"{0}\">{0} </td>", getSoftTypename(dr["CF_SoftTypeID"].ToString()));
sbContent.AppendFormat("<td class=\"num\" title=\"{0}\">{0} </td>", getUsername(dr["CF_UserID"].ToString()));
sbContent.AppendFormat("<td class=\"num\">{0} {1}</td>", strEdit, strDelete);
sbContent.AppendFormat("</tr>");
sbContent.AppendFormat("</tbody>");
}
script = sbContent.ToString();
}
else
{
script = "没有搜索到相关内容！";
}
//获取当前页
//if (rowCount % pageSize == 0)
//{
// pageNum = rowCount / pageSize;
//}
//else
//{
// pageNum = (rowCount / pageSize) + 1;
//}
}
