/// <summary>
/// 多表连接查询
/// </summary>
public DataTable GetJournalListByTB(JournalTO TO, int pageIndex, int pageSize, string orderBy, out int rowCount)
{
string table = " Journal j left join UserInfo u on j.PublishUserCode=u.UserCode ";
string pk = " j.ID ";
string fields = " j.Id,j.Contents,j.PublishTime,j.PublishUserCode,u.UserName,u.HeadImg ";
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 += " j.IsDel=1 and u.UserStatus=1 ";
if (!string.IsNullOrEmpty(TO.Contents))
{
filter += string.Format(" and j.Contents like '%{0}%' ", StringHelper.SQLFilter(TO.Contents));
}
if (TO.DepId > 0)
{
filter += string.Format(" and u.DepartmentId={0} ", TO.DepId);
}
if (!string.IsNullOrEmpty(TO.SearchTime))
{
filter += string.Format(" and datediff(day,publishTime,'{0}')=0", StringHelper.SQLFilter(TO.SearchTime));
}
#endregion
string sort = " j.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, "JournalList");
rowCount = (int)parameters[7].Value;
return(ds.Tables[0]);
}
/// <summary>
/// 多表连接查询
/// </summary>
public DataTable GetJournalListByTB(JournalTO TO, int pageIndex, int pageSize, string orderBy, out int rowCount)
{
return(service.GetJournalListByTB(TO, pageIndex, pageSize, orderBy, out rowCount));
}
