コード例 #1
0
        /// <summary>
        /// 查询所有
        /// </summary>
        /// <returns></returns>
        public List <Model.UserSystem> GetList(int PageCount, int PageSize)
        {
            string strSql      = "";
            string RedCountsql = "";
            int    RowTotal    = (PageCount - 1) * PageSize;//

            RedCountsql = "(select count(TR_ID) from [AP_TRAINEE_USER]) as RowTotal";
            strSql      = "Select Top " + PageSize + " [TR_ID],[TR_POSITION],[TR_NICKNAME],[TR_NAME],[TR_SEX],[TR_CITY],[TR_PHONE],[TR_EMAIL],[TR_COMPANY_TEL],[TR_QR_CODE]," + RedCountsql + " FROM AP_TRAINEE_USER  where [TR_ID] not in (Select Top " + RowTotal + " [TR_ID] from AP_TRAINEE_USER ORDER BY TR_ID DESC) ORDER BY TR_ID DESC";
            List <Model.UserSystem> List = new List <Model.UserSystem>();

            SqlParameter[] parameters =
            {
            };
            SqlDataReader DR;

            if (GetUserSysSetupInfo())
            {
                DR = UserSys.ExecuteReader(strSql.ToString(), parameters);
            }
            else
            {
                DR = ExamSys.ExecuteReader(strSql.ToString(), parameters);
            }

            using (DR)
            {
                while (DR.Read())
                {
                    Model.UserSystem model = new Model.UserSystem();
                    model.ID       = int.Parse(DR["TR_ID"].ToString());
                    model.cnName   = DR["TR_NAME"].ToString();
                    model.enName   = DR["TR_NICKNAME"].ToString();
                    model.Sex      = DR["TR_SEX"].ToString();
                    model.ZipCode  = DR["TR_QR_CODE"].ToString();
                    model.Address  = DR["TR_CITY"].ToString();
                    model.Mobile   = DR["TR_COMPANY_TEL"].ToString();
                    model.Phone    = DR["TR_PHONE"].ToString();
                    model.Email    = DR["TR_EMAIL"].ToString();
                    model.RowTotal = int.Parse(DR["RowTotal"].ToString());
                    List.Add(model);
                }
                DR.Close();
                DR.Dispose();
            }
            return(List);
        }
コード例 #2
0
        /// <summary>
        /// 查询所有
        /// </summary>
        /// <param name="UserName">用户名(可中可英)</param>
        /// <returns></returns>
        public List <Model.UserSystem> GetList(string UserName)
        {
            string strSql = "";

            strSql = "Select * FROM [AP_TRAINEE_USER] Where [TR_NAME] like '%" + UserName + "%' or [TR_NICKNAME] like '%" + UserName + "%'";
            List <Model.UserSystem> List = new List <Model.UserSystem>();

            SqlParameter[] parameters =
            {
            };
            SqlDataReader DR;

            if (GetUserSysSetupInfo())
            {
                DR = UserSys.ExecuteReader(strSql.ToString(), parameters);
            }
            else
            {
                DR = ExamSys.ExecuteReader(strSql.ToString(), parameters);
            }

            using (DR)
            {
                while (DR.Read())
                {
                    Model.UserSystem model = new Model.UserSystem();
                    model.ID      = int.Parse(DR["TR_ID"].ToString());
                    model.cnName  = DR["TR_NAME"].ToString();
                    model.enName  = DR["TR_NICKNAME"].ToString();
                    model.Sex     = DR["TR_SEX"].ToString();
                    model.ZipCode = DR["TR_QR_CODE"].ToString();
                    model.Address = DR["TR_CITY"].ToString();
                    model.Mobile  = DR["TR_COMPANY_TEL"].ToString();
                    model.Phone   = DR["TR_PHONE"].ToString();
                    model.Email   = DR["TR_EMAIL"].ToString();
                    List.Add(model);
                }
                DR.Close();
                DR.Dispose();
            }
            return(List);
        }