/// <summary>
/// 获取实体分页(可设定返回值)
/// </summary>
public DataTable GetDownloadCenterListByFileds(DownloadCenterTO TO, int pageIndex, int pageSize, string orderBy, string fileds, out int rowCount)
{
string table = " [DownloadCenter] ";
string pk = " ID ";
string fields = fileds;
string filter = "";// string.Format(" Status={0} ", ConstantsManager.JiLuZhuangTai.Normal);
#region 组织查询条件
//if (!string.IsNullOrEmpty(TO.MC))
//{
// filter += string.Format(" and MC like '%{0}%' ", StringHelper.SQLFilter(TO.MC));
//}
filter += " isdel=1 ";
if (!string.IsNullOrEmpty(TO.Title))
{
filter += string.Format(" and Title like '%{0}%' ", StringHelper.SQLFilter(TO.Title));
}
#endregion
string sort = " 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, "DownloadCenterList");
rowCount = (int)parameters[7].Value;
return(ds.Tables[0]);
}
/// <summary>
/// 获取参数
/// </summary>
private DownloadCenterTO GetCriteria()
{
DownloadCenterTO criteria = new DownloadCenterTO();
if (this.txtStartDate.Text.Trim() != "")
{
criteria.StartDt = Convert.ToDateTime(this.txtStartDate.Text.Trim());
}
if (this.txtEndDate.Text.Trim() != "")
{
criteria.EndDt = Convert.ToDateTime(this.txtEndDate.Text.Trim());
}
criteria.Title = this.txtTitle.Text.Trim();
criteria.PubDepId = Check.GetInt32(ddlDep.SelectedValue);
return(criteria);
}
/// <summary>
/// 获取实体分页
/// 后台使用
/// </summary>
public DataTable GetDownloadCenterListByBack(DownloadCenterTO TO, int pageIndex, int pageSize, string orderBy, out int rowCount)
{
return(service.GetDownloadCenterListByBack(TO, pageIndex, pageSize, orderBy, out rowCount));
}
/// <summary>
/// 获取实体分页
/// 后台使用
/// </summary>
public DataTable GetDownloadCenterListByBack(DownloadCenterTO TO, int pageIndex, int pageSize, string orderBy, out int rowCount)
{
string table = " DownloadCenter b left join UserInfo u on b.PublishUserCode=u.UserCode left join Department d on u.DepartmentId=d.Id ";
string pk = " b.ID ";
string fields = " b.Id,b.PublishUserCode,b.Title,b.AffixOldName,b.PublishTime,u.UserName as PubName,d.RoleName as PubDep ";
string filter = "";// string.Format(" Status={0} ", ConstantsManager.JiLuZhuangTai.Normal);
#region 组织查询条件
//if (!string.IsNullOrEmpty(TO.MC))
//{
// filter += string.Format(" and MC like '%{0}%' ", StringHelper.SQLFilter(TO.MC));
//}
filter += " b.isdel=1 ";
if (!string.IsNullOrEmpty(TO.Title))
{
filter += string.Format(" and b.Title like '%{0}%' ", StringHelper.SQLFilter(TO.Title));
}
if (!string.IsNullOrEmpty(TO.PubName))
{
filter += string.Format(" and u.PubName like '%{0}%' ", StringHelper.SQLFilter(TO.PubName));
}
if (TO.PubDepId > 0)
{
filter += string.Format(" and d.id={0} ", TO.PubDepId);
}
//根据开始日期进行选择
if (TO.StartDt.HasValue)
{
DateTime beginDt = DateTime.Parse(TO.StartDt.Value.ToShortDateString());
filter += string.Format(" and b.PublishTime>='{0}' ", beginDt);
}
//根据结束日期进行选择
if (TO.EndDt.HasValue)
{
var endDate = DateTime.Parse(TO.EndDt.Value.ToShortDateString() + " 23:59:59");
filter += string.Format(" and b.PublishTime<='{0}' ", endDate);
}
#endregion
string sort = " b.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, "BulletinList");
rowCount = (int)parameters[7].Value;
return(ds.Tables[0]);
}
