不让用static,那就直接存储在Applicatio中啊。

解决方案 »

  1.   

    晕si 
            public List<MemberMessage> GetMemberAll()
            {
                SqlConnection conn = SqlConn.GetConn();
                List<MemberMessage> logList = new List<MemberMessage>();
                try
                {
                    conn.Open();
                    string sql = "SELECT MEMBER_ID,MEMBER_NAME,MEMBER_AUTH,UPDATE_DATE FROM MEMBER_MASTER";
                    SqlCommand cmd = new SqlCommand(sql, conn);
                    SqlDataAdapter adp = new SqlDataAdapter(cmd);
                    DataTable dt = new DataTable();
                    adp.Fill(dt);                foreach (DataRow row in dt.Rows)
                    {
                        MemberMessage log = new MemberMessage();
                        log.MemberID = row["MEMBER_ID"].ToString();
                        log.MemberName = row["MEMBER_NAME"].ToString();
                        log.MemberAuth = row["MEMBER_AUTH"].ToString();
                        log.UpdateDate = Convert.ToDateTime(row["UPDATE_DATE"]);
                        logList.Add(log);
                    }
                }
                catch (Exception ex)
                {
                    throw ex;
                }
                finally
                {
                    conn.Close();
                }
                return logList;
            }
    刚才同事告诉我了 这里的人不热情啊 难道我给的分少?