public IList<Profess> Fill(string QueryParam)
{
IList<Core.Business.Profess> professlist = new List<Core.Business.Profess>();
SqlServerUtility sql = new SqlServerUtility();
SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllProfess + QueryParam);
if (reader != null)
{
while (reader.Read())
{
Core.Business.Profess profess = new Core.Business.Profess();
if (!reader.IsDBNull(0)) profess.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) profess.ProCode = reader.GetString(1);
if (!reader.IsDBNull(2)) profess.ProName = reader.GetString(2);
if (!reader.IsDBNull(3)) profess.ProShortName = reader.GetString(3);
if (!reader.IsDBNull(4)) profess.ProSetting = reader.GetInt32(4);
if (!reader.IsDBNull(5)) profess.Des = reader.GetString(5);
if (!reader.IsDBNull(6)) profess.SchoolCate = reader.GetString(6);
if (!reader.IsDBNull(7)) profess.IsHighLevel = reader.GetInt32(7);
profess.MarkOld();
professlist.Add(profess);
}
reader.Close();
}
return professlist;
}
public IList<Profess> GetAllProfess(string isHighLevel)
{
IList<Core.Business.Profess> professlist = new List<Core.Business.Profess>();
SqlServerUtility sql = new SqlServerUtility();
SqlDataReader reader;
if (isHighLevel == "0")
{
string where = " where 1=1 and IsHighLevel=0";
reader = sql.ExecuteSqlReader(SqlGetAllProfess + where);
}
else if (isHighLevel == "1")
{
string where = " where 1=1 and IsHighLevel=1";
reader = sql.ExecuteSqlReader(SqlGetAllProfess + where);
}
else if (isHighLevel == "all")
{
reader = sql.ExecuteSqlReader(SqlGetAllProfess);
}
else
{
reader = sql.ExecuteSqlReader(SqlGetAllProfess);
}
if (reader != null)
{
while (reader.Read())
{
Core.Business.Profess profess = new Core.Business.Profess();
if (!reader.IsDBNull(0)) profess.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) profess.ProCode = reader.GetString(1);
if (!reader.IsDBNull(2)) profess.ProName = reader.GetString(2);
if (!reader.IsDBNull(3)) profess.ProShortName = reader.GetString(3);
if (!reader.IsDBNull(4)) profess.ProSetting = reader.GetInt32(4);
if (!reader.IsDBNull(5)) profess.Des = reader.GetString(5);
if (!reader.IsDBNull(6)) profess.SchoolCate = reader.GetString(6);
if (!reader.IsDBNull(7)) profess.IsHighLevel = reader.GetInt32(7);
profess.MarkOld();
professlist.Add(profess);
}
reader.Close();
}
return professlist;
}
public Profess IsExists(int id, string code)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@ProCode", SqlDbType.NVarChar, code);
sql.AddParameter("@Id", SqlDbType.Int, id);
SqlDataReader reader = sql.ExecuteSqlReader(SqlUpdateIsExists);
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.Profess profess = new Core.Business.Profess();
if (!reader.IsDBNull(0)) profess.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) profess.ProCode = reader.GetString(1);
if (!reader.IsDBNull(2)) profess.ProName = reader.GetString(2);
if (!reader.IsDBNull(3)) profess.ProShortName = reader.GetString(3);
if (!reader.IsDBNull(4)) profess.ProSetting = reader.GetInt32(4);
if (!reader.IsDBNull(5)) profess.Des = reader.GetString(5);
if (!reader.IsDBNull(6)) profess.SchoolCate = reader.GetString(6);
if (!reader.IsDBNull(7)) profess.IsHighLevel = reader.GetInt32(7);
reader.Close();
profess.MarkOld();
return profess;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
public IList<Profess> GetProfesses(int Level)
{
IList<Core.Business.Profess> professlist = new List<Core.Business.Profess>();
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@IsHighLevel", SqlDbType.Int, Level);
SqlDataReader reader = sql.ExecuteSqlReader(SqlGetProfesses);
if (reader != null && !reader.IsClosed)
{
Core.Business.Profess profess = null;
while (reader.Read())
{
profess = new Core.Business.Profess();
if (!reader.IsDBNull(0)) profess.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) profess.ProCode = reader.GetString(1);
if (!reader.IsDBNull(2)) profess.ProName = reader.GetString(2);
if (!reader.IsDBNull(3)) profess.ProShortName = reader.GetString(3);
if (!reader.IsDBNull(4)) profess.ProSetting = reader.GetInt32(4);
if (!reader.IsDBNull(5)) profess.Des = reader.GetString(5);
if (!reader.IsDBNull(6)) profess.SchoolCate = reader.GetString(6);
if (!reader.IsDBNull(7)) profess.IsHighLevel = reader.GetInt32(7);
profess.MarkOld();
professlist.Add(profess);
}
reader.Close();
}
return professlist;
}
