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