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;
}
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;
}