public static DataSet getAllNews()
{
try
{
string strSql = "select * from News";
return(DBHelp.ExecuteDataSet(strSql, null));
}
catch (Exception ex)
{
throw ex;
}
}
public static DataSet getUserName(string typeSqlname, string where) //取得用户DateSet
{
try
{
string strSql = "select U_Id,U_Name from " + typeSqlname + " where 1=1 " + where;;
return(DBHelp.ExecuteDataSet(strSql, null));
}
catch (Exception ex)
{
throw ex;
}
}
public static DataSet getAllType(string typeSqlname)//取得类型DateSet
{
try
{
string strSql = "select * from " + typeSqlname;
return(DBHelp.ExecuteDataSet(strSql, null));
}
catch (Exception ex)
{
throw ex;
}
}
public static DataSet getUserName(string Where, string where2) //取得用户DateSet
{
try
{
string strSql = "select U_Id ID,U_Number 编号,U_Name 姓名 from U_Custom where 1=1 " + Where + where2;
return(DBHelp.ExecuteDataSet(strSql, null));
}
catch (Exception ex)
{
throw ex;
}
}
public static DataSet getAllSpecialFieldInfo()
{
try
{
string strSql = "select * from SpecialFieldInfo";
return(DBHelp.ExecuteDataSet(strSql, null));
}
catch (Exception ex)
{
throw ex;
}
}
public static DataSet getAllStudentSelectCourseInfo()
{
try
{
string strSql = "select * from StudentSelectCourseInfo";
return(DBHelp.ExecuteDataSet(strSql, null));
}
catch (Exception ex)
{
throw ex;
}
}
