public IList<Core.Business.ClassInfo> GetClassInfoByAccountId(long accId)
{
IList<Core.Business.ClassInfo> classlist = new List<Core.Business.ClassInfo>();
SqlServerUtility sql = new SqlServerUtility(SqlConnectionString);
sql.AddParameter("@AccountId", SqlDbType.BigInt, accId);
SqlDataReader reader = sql.ExecuteSPReader("USP_ClassInfo_Select_By_AccountId");
if (reader != null)
{
while (reader.Read())
{
Core.Business.ClassInfo classInfo = new Core.Business.ClassInfo();
if (!reader.IsDBNull(0)) classInfo.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) classInfo.PersonsNum = reader.GetInt32(1);
if (!reader.IsDBNull(2)) classInfo.MajorId = reader.GetInt32(2);
if (!reader.IsDBNull(3)) classInfo.GradeId = reader.GetInt32(3);
if (!reader.IsDBNull(4)) classInfo.GradeYear = reader.GetInt32(4);
if (!reader.IsDBNull(5)) classInfo.DateCreated = reader.GetDateTime(5);
if (!reader.IsDBNull(6)) classInfo.Name = reader.GetString(6);
classInfo.MarkOld();
classlist.Add(classInfo);
}
reader.Close();
}
return classlist;
}
/// <summary>
/// SqlFillWithParam "SELECT [Id], [ClassCode],[GradeCode],[ProCode],[OrStdNum] FROM [ClassInfo] WHERE [ProCode]=@Profess AND [GradeCode]=@Grade";
/// </summary>
/// <param name="profess"></param>
/// <param name="grade"></param>
/// <returns></returns>
public IList<ClassInfo> Fill(Profess profess, Grade grade)
{
if (profess == null || grade == null)
return null;
IList<Core.Business.ClassInfo> classInfolist = new List<Core.Business.ClassInfo>();
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Profess", SqlDbType.NVarChar, profess.ProCode, 30);
sql.AddParameter("@Grade", SqlDbType.NVarChar, grade.GradeCode, 30);
SqlDataReader reader = sql.ExecuteSqlReader(SqlFillWithParam);
if (reader != null)
{
while (reader.Read())
{
Core.Business.ClassInfo classInfo = new Core.Business.ClassInfo();
if (!reader.IsDBNull(0)) classInfo.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) classInfo.ClassCode = reader.GetString(1);
if (!reader.IsDBNull(2)) classInfo.GradeCode = reader.GetString(2);
if (!reader.IsDBNull(3)) classInfo.ProCode = reader.GetString(3);
if (!reader.IsDBNull(4)) classInfo.OrStdNum = reader.GetInt32(4);
if (!reader.IsDBNull(5)) classInfo.ClassName = reader.GetString(5);
classInfo.MarkOld();
classInfolist.Add(classInfo);
}
reader.Close();
}
return classInfolist;
}
public IList<Core.Business.ClassInfo> GetClassInfoByMIdAndGIdAndName(int majorId, int gradeId, string name,Core.PagingInfo pageInfo)
{
IList<Core.Business.ClassInfo> classlist = new List<Core.Business.ClassInfo>();
SqlServerUtility sql = new SqlServerUtility(SqlConnectionString);
#region ����
string tables = "ClassInfo";
string pK = "Id";
string sort = "Id DESC";
int pageNum = pageInfo.CurrentPage;
int pageSize = pageInfo.PageSize;
string fields = "[ID], [PersonsNum],[MajorId],[GradeId],[GradeYear],[DateCreated],[Name]";
string filter = "1=1";
StringBuilder strFilter = new StringBuilder();
if (majorId != 0)
{
strFilter.Append(" and [MajorId] =" + majorId.ToString());
}
if (gradeId != 0)
{
strFilter.Append(" and [GradeId] =" + gradeId.ToString());
}
if (name.Length != 0)
{
strFilter.Append(" AND [Name] like '%" + name + "%'");
}
filter += strFilter.ToString();
string group = String.Empty;
#endregion
sql.AddParameter("@Tables",SqlDbType.VarChar,tables);
sql.AddParameter("@PK", SqlDbType.VarChar, pK);
sql.AddParameter("@Sort", SqlDbType.VarChar, sort);
sql.AddParameter("@PageNumber", SqlDbType.Int, pageNum);
sql.AddParameter("@PageSize", SqlDbType.Int, pageSize);
sql.AddParameter("@Fields", SqlDbType.VarChar, fields);
sql.AddParameter("@Filter",SqlDbType.VarChar,filter);
sql.AddParameter("@Group",SqlDbType.VarChar,group);
SqlDataReader reader = sql.ExecuteSPReader("Paging_RowCount");
//sql.AddParameter("@MajorID", SqlDbType.Int, majorId);
//sql.AddParameter("@GradeID", SqlDbType.Int, gradeId);
//sql.AddParameter("@Name", SqlDbType.Int, name);
//SqlDataReader reader = sql.ExecuteSPReader("USP_ClassInfo_Select_By_MajorId_And_GradeId_And_Name");
if (reader != null)
{
while (reader.Read())
{
Core.Business.ClassInfo classInfo = new Core.Business.ClassInfo();
if (!reader.IsDBNull(0)) classInfo.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) classInfo.PersonsNum = reader.GetInt32(1);
if (!reader.IsDBNull(2)) classInfo.MajorId = reader.GetInt32(2);
if (!reader.IsDBNull(3)) classInfo.GradeId = reader.GetInt32(3);
if (!reader.IsDBNull(4)) classInfo.GradeYear = reader.GetInt32(4);
if (!reader.IsDBNull(5)) classInfo.DateCreated = reader.GetDateTime(5);
if (!reader.IsDBNull(6)) classInfo.Name = reader.GetString(6);
classInfo.MarkOld();
classlist.Add(classInfo);
}
reader.Close();
}
return classlist;
}
public Core.Business.ClassInfo Select(int id)
{
SqlServerUtility sql = new SqlServerUtility(SqlConnectionString);
sql.AddParameter("@ID", SqlDbType.Int, id);
SqlDataReader reader = sql.ExecuteSPReader("USP_ClassInfo_Select_By_Id");
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.ClassInfo classInfo = new Core.Business.ClassInfo();
if (!reader.IsDBNull(0)) classInfo.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) classInfo.PersonsNum = reader.GetInt32(1);
if (!reader.IsDBNull(2)) classInfo.MajorId = reader.GetInt32(2);
if (!reader.IsDBNull(3)) classInfo.GradeId = reader.GetInt32(3);
if (!reader.IsDBNull(4)) classInfo.GradeYear = reader.GetInt32(4);
if (!reader.IsDBNull(5)) classInfo.DateCreated = reader.GetDateTime(5);
if (!reader.IsDBNull(6)) classInfo.Name = reader.GetString(6);
reader.Close();
return classInfo;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
public IList<ClassInfo> Fill(string QueryParam)
{
if (string.IsNullOrEmpty(QueryParam))
{
return null;
}
IList<Core.Business.ClassInfo> classInfolist = new List<Core.Business.ClassInfo>();
SqlServerUtility sql = new SqlServerUtility();
SqlDataReader reader = sql.ExecuteSqlReader(SqlFillClassInfoCurriculmArrange);
if (reader != null)
{
while (reader.Read())
{
Core.Business.ClassInfo classInfo = new Core.Business.ClassInfo();
if (!reader.IsDBNull(0)) classInfo.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) classInfo.ClassCode = reader.GetString(1);
if (!reader.IsDBNull(2)) classInfo.GradeCode = reader.GetString(2);
if (!reader.IsDBNull(3)) classInfo.ProCode = reader.GetString(3);
if (!reader.IsDBNull(4)) classInfo.OrStdNum = reader.GetInt32(4);
if (!reader.IsDBNull(5)) classInfo.ClassName = reader.GetString(5);
classInfo.MarkOld();
classInfolist.Add(classInfo);
}
reader.Close();
}
return classInfolist;
}
public Core.Business.ClassInfo Select(int id)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Id", SqlDbType.Int, id);
SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectClassInfo);
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.ClassInfo classInfo = new Core.Business.ClassInfo();
if (!reader.IsDBNull(0)) classInfo.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) classInfo.ClassCode = reader.GetString(1);
if (!reader.IsDBNull(2)) classInfo.GradeCode = reader.GetString(2);
if (!reader.IsDBNull(3)) classInfo.ProCode = reader.GetString(3);
if (!reader.IsDBNull(4)) classInfo.OrStdNum = reader.GetInt32(4);
if (!reader.IsDBNull(5)) classInfo.ClassName = reader.GetString(5);
reader.Close();
return classInfo;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
public IList<ClassInfo> GetListByProCode(string proCode)
{
IList<Core.Business.ClassInfo> classInfolist = new List<Core.Business.ClassInfo>();
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@ProCode", SqlDbType.NVarChar, proCode, 30);
SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectByProCodeSearch);
if (reader != null)
{
while (reader.Read())
{
Core.Business.ClassInfo classInfo = new Core.Business.ClassInfo();
if (!reader.IsDBNull(0)) classInfo.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) classInfo.ClassCode = reader.GetString(1);
if (!reader.IsDBNull(2)) classInfo.GradeCode = reader.GetString(2);
if (!reader.IsDBNull(3)) classInfo.ProCode = reader.GetString(3);
if (!reader.IsDBNull(4)) classInfo.OrStdNum = reader.GetInt32(4);
if (!reader.IsDBNull(5)) classInfo.ClassName = reader.GetString(5);
classInfo.MarkOld();
classInfolist.Add(classInfo);
}
reader.Close();
}
return classInfolist;
}
public Core.Business.ClassInfo GetbyName(string stext)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@ClassName", SqlDbType.NVarChar, stext);
SqlDataReader reader = sql.ExecuteSqlReader(SqlGetByName);
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.ClassInfo classInfo = new Core.Business.ClassInfo();
if (!reader.IsDBNull(0)) classInfo.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) classInfo.ClassCode = reader.GetString(1);
if (!reader.IsDBNull(2)) classInfo.GradeCode = reader.GetString(2);
if (!reader.IsDBNull(3)) classInfo.ProCode = reader.GetString(3);
if (!reader.IsDBNull(4)) classInfo.OrStdNum = reader.GetInt32(4);
if (!reader.IsDBNull(5)) classInfo.ClassName = reader.GetString(5);
reader.Close();
classInfo.MarkOld();
return classInfo;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
public IList<Core.Business.ClassInfo> GetAllClassInfo()
{
IList<Core.Business.ClassInfo> classInfolist = new List<Core.Business.ClassInfo>();
SqlServerUtility sql = new SqlServerUtility();
SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllClassInfo);
if (reader != null)
{
while (reader.Read())
{
Core.Business.ClassInfo classInfo = new Core.Business.ClassInfo();
if (!reader.IsDBNull(0)) classInfo.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) classInfo.ClassCode = reader.GetString(1);
if (!reader.IsDBNull(2)) classInfo.GradeCode = reader.GetString(2);
if (!reader.IsDBNull(3)) classInfo.ProCode = reader.GetString(3);
if (!reader.IsDBNull(4)) classInfo.OrStdNum = reader.GetInt32(4);
if (!reader.IsDBNull(5)) classInfo.ClassName = reader.GetString(5);
classInfo.MarkOld();
classInfolist.Add(classInfo);
}
reader.Close();
}
return classInfolist;
}
