IList疑问

[westqy]

先贴代码!

///<summary>
        ///获取所有分类信息
        ///</summary>
        public IList GetAll(string OrderNum)
        {
            CompanyTypeModels type = new CompanyTypeModels();

            using (SqlConnection conn = new SqlConnection(connString))
            {
                //T-SQL查询语句
                string SelectID = "select * from CompanyType " + OrderNum + "";

                SqlCommand objCommand = new SqlCommand(SelectID, conn);

                objCommand.CommandType = System.Data.CommandType.Text;

                conn.Open();

                using (SqlDataReader objRead = objCommand.ExecuteReader(CommandBehavior.CloseConnection))
                {
                    if (objRead.Read())
                    {
                        type.CTypeID = Convert.ToString(objRead["CompanyTypeID"]);
                        type.CTypeName = Convert.ToString(objRead["CompanyTypeName"]);
                        type.OName = Convert.ToInt32(objRead["OrderNum"]);
                    }
                    objCommand.Dispose();
                }

                conn.Close();
                conn.Dispose();

            }

            return type;
        }

请问上述代码是否正确?

返回值是否有问题?

请求高人解答!

[大神来了丶]

...

[zgke]

这是什么返回类型就不对...

IList<CompanyTypeModels> GetAll()


IList<CompanyTypeModels> _type =new List<CompanyTypeModels>();


type.Add(new CompanyTypeModels());

[RHCL]

.....2楼已解.

[zzxap]

IList <CompanyTypeModels> GetAll()


IList <CompanyTypeModels> _type =new List <CompanyTypeModels>();


type.Add(new CompanyTypeModels());

[westqy]

该如何该上面的代码段啊?

烦请高人帮忙改下~~~

[CutBug]

 ///<summary>
        ///获取所有分类信息
        ///</summary>
        public IList<CompanyTypeModels> GetAll(string OrderNum)
        {
            IList<CompanyTypeModels> list = new List<CompanyTypeModels>();
            using (SqlConnection conn = new SqlConnection(connString))
            {
                //T-SQL查询语句
                string SelectID = "select * from CompanyType " + OrderNum + "";

                SqlCommand objCommand = new SqlCommand(SelectID, conn);

                objCommand.CommandType = System.Data.CommandType.Text;

                conn.Open();

                using (SqlDataReader objRead = objCommand.ExecuteReader(CommandBehavior.CloseConnection))
                {
                    if (objRead.Read())
                    {
                        CompanyTypeModels type = new CompanyTypeModels();
                        type.CTypeID = Convert.ToString(objRead["CompanyTypeID"]);
                        type.CTypeName = Convert.ToString(objRead["CompanyTypeName"]);
                        type.OName = Convert.ToInt32(objRead["OrderNum"]);
                        list.Add(type);
                    }
                    objCommand.Dispose();
                }

                conn.Close();
                conn.Dispose();
            }

            return list;
        }

[westqy]

[Quote=引用 6 楼 CutBug 的回复:]
C# code ///<summary>
///获取所有分类信息
///</summary>
public IList<CompanyTypeModels> GetAll(string OrderNum)
{
IList<CompanyTypeModels> list = new List<CompanyTypeModels>();
using (SqlConnection conn = new SqlConnection(connString))
{
//T-SQL查询语句
string SelectID = "select * from Com…
[/Quote]

错误提示:

return list

list缺少强制转换....

[homepgdn]

IList <CompanyTypeModels> list = new ArrayList <CompanyTypeModels>();

[CutBug]

[Quote=引用 6 楼 CutBug 的回复:]
C# code ///<summary>
///获取所有分类信息
///</summary>
public IList<CompanyTypeModels> GetAll(string OrderNum)
{
IList<CompanyTypeModels> list = new List<CompanyTypeModels>();
using (SqlConnection conn = new SqlConnection(connString))
{
//T-SQL查询语句
string SelectID = "select * from Com…
[/Quote]
IList <CompanyTypeModels>
public IList<CompanyTypeModels> GetAll(string OrderNum)

[wenblue7]

///<summary>
///获取所有分类信息
///</summary>
public IList GetAll(string OrderNum)
{
IList<>CompanyTypeModels li=new IList<CompanyTypeModels >();
CompanyTypeModels type = new CompanyTypeModels();

using (SqlConnection conn = new SqlConnection(connString))
{
//T-SQL查询语句
string SelectID = "select * from CompanyType " + OrderNum + "";

SqlCommand objCommand = new SqlCommand(SelectID, conn);

objCommand.CommandType = System.Data.CommandType.Text;

conn.Open();

using (SqlDataReader objRead = objCommand.ExecuteReader(CommandBehavior.CloseConnection))
{
if (objRead.Read())
{
type.CTypeID = Convert.ToString(objRead["CompanyTypeID"]);
type.CTypeName = Convert.ToString(objRead["CompanyTypeName"]);
type.OName = Convert.ToInt32(objRead["OrderNum"]);
li.Add(type);
}
objCommand.Dispose();
}

conn.Close();
conn.Dispose();

}

return li;
}

[阿非]

        ///<summary>
        ///获取所有分类信息
         ///</summary>
        public IList<CompanyTypeModels> GetAll(string OrderNum)
        {
            IList<CompanyTypeModels> list = new List<CompanyTypeModels>();
            using (SqlConnection conn = new SqlConnection(connString))
            {
                //T-SQL查询语句
                string SelectID = "select * from CompanyType " + OrderNum + "";

                SqlCommand objCommand = new SqlCommand(SelectID, conn);

                objCommand.CommandType = System.Data.CommandType.Text;

                conn.Open();

                using (SqlDataReader objRead = objCommand.ExecuteReader(CommandBehavior.CloseConnection))
                {
                    CompanyTypeModels type;
                    while (objRead.Read())
                    {
                        type = new CompanyTypeModels();
                        type.CTypeID = Convert.ToString(objRead["CompanyTypeID"]);
                        type.CTypeName = Convert.ToString(objRead["CompanyTypeName"]);
                        type.OName = Convert.ToInt32(objRead["OrderNum"]);
                        list.Add(type);
                    }
                    objCommand.Dispose();
                }

                conn.Close();
                conn.Dispose();
            }

            return list;
        }