コード例 #1
0
ファイル: Get.cs プロジェクト: Xiaoyuyexi/LMS
        new public static List<M1> M1(int PageSize, int CurrentPage, string Filter, out int Count)
        {
            var l = new List<M1>();
            try
            {
                SqlParameter[] param =
                {
                    new SqlParameter("@PageSize",PageSize),
                    new SqlParameter("@CurrentPage",CurrentPage),
                    new SqlParameter("@Filter",Filter)
                };
                SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.Local, CommandType.StoredProcedure, "M_Get_MemberList", param);
                while (dr.Read())
                {
                    var m = new M1();
                    m.ID = Convert.ToInt32(dr["ID"]);
                    m.MID = Convert.ToInt32(dr["MID"]);
                    m.PID = Convert.ToInt32(dr["PID"]);
                    m.Name = Convert.ToString(dr["Name"]);
                    m.Year = Convert.ToInt32(dr["Year"]);
                    m.IDCard = Convert.ToString(dr["IDCard"]);
                    m.IDSN = Convert.ToString(dr["IDSN"]);
                    m.Level = Convert.ToInt32(dr["Level"]);
                    m.Type = Convert.ToInt32(dr["Type"]);
                    m.Phone = Convert.ToString(dr["Phone"]);
                    m.IID = Convert.ToInt32(dr["IID"]);
                    m.Status = Convert.ToInt32(dr["Status"]);
                    m.Minutes = Convert.ToDecimal(dr["Minutes"]);
                    m.Score = Convert.ToInt32(dr["Score"]);
                    if (dr["RegDate"] != DBNull.Value)
                        m.RegDate = Convert.ToDateTime(dr["RegDate"]);
                    if (dr["CommitDate"] != DBNull.Value)
                        m.CommitDate = Convert.ToDateTime(dr["CommitDate"]);
                    if (dr["RegionCode"] != DBNull.Value)
                        m.RegionCode = Convert.ToInt32(dr["RegionCode"]);
                    if (dr["RegionName"] != DBNull.Value)
                        m.RegionName = Convert.ToString(dr["RegionName"]);

                    l.Add(m);
                }
                dr.Close();
                //取总记录
                SqlParameter[] param2 =
                {
                    new SqlParameter("@Filter",Filter)
                };
                var oCount = SqlHelper.ExecuteScalar(SqlHelper.Local, CommandType.StoredProcedure, "M_Get_MemberListCount", param2);

                Count = Convert.ToInt32(oCount);


            }
            catch (Exception ex)
            {
                log.Fatal("{0},{1}", ex.Message, ex.Source);
                Count = 0;
            }
            return l;
        }
コード例 #2
0
ファイル: Get.cs プロジェクト: Xiaoyuyexi/LMS
        public static List<M1> M1(string keyword, int AID)
        {
            var l = new List<M1>();
            try
            {
                SqlParameter[] param =
                {
                    new SqlParameter("@keyword",keyword),
                    new SqlParameter("@AID",AID) 
                };
                var dr = SqlHelper.ExecuteReader(SqlHelper.Local, CommandType.StoredProcedure, "M_Get_Member", param);
                while (dr.Read())
                {
                    var m = new M1();
                    m.ID = Convert.ToInt32(dr["ID"]);
                    m.MID = Convert.ToInt32(dr["MID"]);
                    if (dr["PID"] != DBNull.Value)
                        m.PID = Convert.ToInt32(dr["PID"]);
                    m.Name = Convert.ToString(dr["Name"]);
                    m.Year = Convert.ToInt32(dr["Year"]);
                    m.IDCard = Convert.ToString(dr["IDCard"]);
                    m.IDSN = Convert.ToString(dr["IDSN"]);
                    m.Level = Convert.ToInt32(dr["Level"]);
                    m.Type = Convert.ToInt32(dr["Type"]);
                    m.Phone = Convert.ToString(dr["Phone"]);
                    m.IID = Convert.ToInt32(dr["IID"]);
                    m.Status = Convert.ToInt32(dr["Status"]);
                    m.Minutes = Convert.ToDecimal(dr["Minutes"]);
                    m.Score = Convert.ToInt32(dr["Score"]);
                    if (dr["RegDate"] != DBNull.Value)
                        m.RegDate = Convert.ToDateTime(dr["RegDate"]);
                    if (dr["RegionCode"] != DBNull.Value)
                        m.RegionCode = Convert.ToInt32(dr["RegionCode"]);
                    if (dr["RegionName"] != DBNull.Value)
                        m.RegionName = Convert.ToString(dr["RegionName"]);
                    l.Add(m);
                }

                dr.Close();
            }
            catch (Exception ex)
            {
                log.Fatal("{0},{1}", ex.Message, ex.Source);
            }
            return l;
        }