/// <summary> /// 按照查询条件查询 /// </summary> /// <param name="query">查询条件</param> /// <param name="order">排序</param> /// <param name="currentPage">页号,-1不分页</param> /// <param name="pageSize">每页记录数</param> /// <param name="totalCount">总行数</param> /// <returns>集合</returns> public DataTable GetProjectInfo(QueryProjectInfo query, string order, int currentPage, int pageSize, out int totalCount, int?userID) { string where = GetWhereStr(query); if (userID.HasValue) { where += UserGroupDataRigth.Instance.GetSqlRightstr("ProjectInfo", "BGID", "CreateUserID", userID.Value); } DataSet ds; SqlParameter[] parameters = { new SqlParameter("@where", SqlDbType.NVarChar, 40000), new SqlParameter("@order", SqlDbType.NVarChar, 200), new SqlParameter("@pagesize", SqlDbType.Int, 4), new SqlParameter("@indexpage", SqlDbType.Int, 4), new SqlParameter("@totalRecorder", SqlDbType.Int, 4) }; parameters[0].Value = where; parameters[1].Value = order; parameters[2].Value = pageSize; parameters[3].Value = currentPage; parameters[4].Direction = ParameterDirection.Output; ds = SqlHelper.ExecuteDataset(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_PROJECTINFO_SELECT, parameters); totalCount = (int)(parameters[4].Value); return(ds.Tables[0]); }
/// 获取项目信息 /// <summary> /// 获取项目信息 /// </summary> /// <param name="projectid"></param> /// <returns></returns> private DataTable GetProject(long projectid) { QueryProjectInfo query = new QueryProjectInfo(); query.ProjectID = projectid; DataTable dt = new DataTable(); int count = 0; dt = BLL.ProjectInfo.Instance.GetProjectInfo(query, string.Empty, 1, 1, out count); return(dt); }
/// <summary> /// 得到一个对象实体 /// </summary> public Entities.ProjectInfo GetProjectInfo(long ProjectID) { QueryProjectInfo query = new QueryProjectInfo(); query.ProjectID = ProjectID; DataTable dt = new DataTable(); int count = 0; dt = GetProjectInfo(query, string.Empty, 1, 1, out count); if (count > 0) { return(LoadSingleProjectInfo(dt.Rows[0])); } else { return(null); } }
/// <summary> /// 根据当前登录人取管辖分组下最近的项目 /// </summary> /// <param name="userid"></param> /// <returns></returns> public DataTable GetLastestProjectByUserID(QueryProjectInfo query, string order, int currentPage, int pageSize, out int totalCount, int userid) { string where = string.Empty; if (!string.IsNullOrEmpty(query.Name)) { where += " and a.Name like '%" + StringHelper.SqlFilter(query.Name) + "%'"; } if (query.BGID != Constant.INT_INVALID_VALUE) { where += " and a.BGID= " + query.BGID; } if (!string.IsNullOrEmpty(query.Sources)) { where += " and a.Source in (" + query.Sources + ")"; } DataSet ds; SqlParameter[] parameters = { new SqlParameter("@where", SqlDbType.NVarChar, 40000), new SqlParameter("@order", SqlDbType.NVarChar, 200), new SqlParameter("@pagesize", SqlDbType.Int, 4), new SqlParameter("@indexpage", SqlDbType.Int, 4), new SqlParameter("@totalRecorder", SqlDbType.Int, 4), new SqlParameter("@userid", SqlDbType.Int, 4) }; parameters[0].Value = where; parameters[1].Value = order; parameters[2].Value = pageSize; parameters[3].Value = currentPage; parameters[4].Direction = ParameterDirection.Output; parameters[5].Value = userid; ds = SqlHelper.ExecuteDataset(CONNECTIONSTRINGS, CommandType.StoredProcedure, "p_ProjectInfoByUserID_Select", parameters); totalCount = (int)(parameters[4].Value); return(ds.Tables[0]); }
/// <summary> /// 根据当前登录人取管辖分组下最近的项目 /// </summary> /// <param name="userid"></param> /// <returns></returns> public DataTable GetLastestProjectByUserID(QueryProjectInfo query, string order, int currentPage, int pageSize, out int totalCount, int userid) { return(Dal.ProjectInfo.Instance.GetLastestProjectByUserID(query, order, currentPage, pageSize, out totalCount, userid)); }
/// <summary> /// 按照查询条件查询 /// </summary> /// <param name="query">查询条件</param> /// <param name="order">排序</param> /// <param name="currentPage">页号,-1不分页</param> /// <param name="pageSize">每页记录数</param> /// <param name="totalCount">总行数</param> /// <returns>集合</returns> public DataTable GetProjectInfo(QueryProjectInfo query, string order, int currentPage, int pageSize, out int totalCount) { return(Dal.ProjectInfo.Instance.GetProjectInfo(query, order, currentPage, pageSize, out totalCount)); }
private static string GetWhereStr(QueryProjectInfo query) { string where = string.Empty; if (query.ProjectID != Constant.INT_INVALID_VALUE) { where += " AND ProjectInfo.ProjectID =" + query.ProjectID + ""; } if (query.Name != Constant.STRING_INVALID_VALUE) { where += " AND ProjectInfo.Name like '%" + StringHelper.SqlFilter(query.Name) + "%'"; } if (query.BGID != Constant.INT_INVALID_VALUE) { where += " AND ProjectInfo.BGID=" + query.BGID; } if (query.PCatageID != Constant.INT_INVALID_VALUE) { where += " AND ProjectInfo.PCatageID=" + query.PCatageID; } if (query.Source != Constant.INT_INVALID_VALUE) { where += " AND ProjectInfo.Source=" + query.Source; } if (query.CreateUserID != Constant.INT_INVALID_VALUE) { where += " AND ProjectInfo.CreateUserID=" + query.CreateUserID; } if (query.BeginTime != Constant.STRING_INVALID_VALUE) { where += " And ProjectInfo.CreateTime>='" + DateTime.Parse(StringHelper.SqlFilter(query.BeginTime)).ToShortDateString() + "'"; } if (query.EndTime != Constant.STRING_INVALID_VALUE) { where += " And ProjectInfo.CreateTime<='" + DateTime.Parse(StringHelper.SqlFilter(query.EndTime)).ToShortDateString() + " 23:59:59'"; } if (query.Statuss != Constant.STRING_INVALID_VALUE) { where += " AND ProjectInfo.Status in (" + Dal.Util.SqlFilterByInCondition(query.Statuss) + ")"; } if (query.DemandID != Constant.STRING_INVALID_VALUE && query.DemandID != Constant.STRING_EMPTY_VALUE) { where += "AND ProjectInfo.DemandID='" + StringHelper.SqlFilter(query.DemandID) + "'"; } if (query.Batch.HasValue) { where += "AND ProjectInfo.Batch='" + query.Batch.Value + "'"; } if (!string.IsNullOrEmpty(query.ISAutoCall)) { if (query.ISAutoCall == "1") { //是 where += " AND ISNULL(b.ProjectID,0)>0"; } else if (query.ISAutoCall == "0") { //否 where += " AND ISNULL(b.ProjectID,0)=0"; } } if (!string.IsNullOrEmpty(query.ACStatus)) { where += " AND ISNULL(b.ProjectID,0)>0"; where += " AND ISNULL(b.ACStatus,0) IN (" + Dal.Util.SqlFilterByInCondition(query.ACStatus) + ")"; } if (!string.IsNullOrEmpty(query.wherePlus)) { where += query.wherePlus; } return(where); }
/// <summary> /// 按照查询条件查询 /// </summary> /// <param name="query">查询条件</param> /// <param name="order">排序</param> /// <param name="currentPage">页号,-1不分页</param> /// <param name="pageSize">每页记录数</param> /// <param name="totalCount">总行数</param> /// <returns>集合</returns> public DataTable GetProjectInfo(QueryProjectInfo query, string order, int currentPage, int pageSize, out int totalCount) { return(GetProjectInfo(query, order, currentPage, pageSize, out totalCount, null)); }