예제 #1
0
        /// <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]);
        }
예제 #2
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);
        }
예제 #3
0
        /// <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);
            }
        }
예제 #4
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)
        {
            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]);
        }
예제 #5
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));
 }
예제 #6
0
 /// <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));
 }
예제 #7
0
        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);
        }
예제 #8
0
 /// <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));
 }