public static DataTable GetCollegeList()
{
SqlConnection conn = DBLink.GetJobsky6Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("select ArticleID,Title,PicSource from [CollegeInfo];", conn);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
cmd.Dispose();
conn.Close();
return(dt);
}
public static void OldArticleClickTimesPlus(int ArticleID)
{
SqlConnection conn = DBLink.GetJobsky6Connection();
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "ClickTimesPlus";
cmd.Parameters.Add(new SqlParameter("@ArticleID", ArticleID));
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
}
public static DataTable GetCollege(int ArticleID)
{
SqlConnection conn = DBLink.GetJobsky6Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("select * from [CollegeInfo] where ArticleID=@id", conn);
cmd.Parameters.Add(new SqlParameter("@id", ArticleID));
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
cmd.Dispose();
conn.Close();
return(dt);
}
public static DataTable SelectFromOldArticle(int ArticleID)
{
SqlConnection conn = DBLink.GetJobsky6Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM Article where Article.ArticleID = @ArticleID", conn);
cmd.Parameters.Add(new SqlParameter("@ArticleID", ArticleID));
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
cmd.Dispose();
conn.Close();
return(dt);
}
public static bool DeleteByDatabase(int ID, int databaseID)
{
SqlConnection conn;
SqlCommand cmd;
if (databaseID == 0)
{
//DatabaseID=0：老数据库Article
conn = DBLink.GetJobsky6Connection();
cmd = new SqlCommand("Delete FROM Article where ArticleID = @ArticleID", conn);
cmd.Parameters.Add(new SqlParameter("@ArticleID", ID));
}
else if (databaseID == 1)
{
//1：新数据库Article
conn = DBLink.GetConnection();
cmd = new SqlCommand("Delete FROM Article where ArticleID = @ArticleID", conn);
cmd.Parameters.Add(new SqlParameter("@ArticleID", ID));
}
else
{
//2：新数据库News
conn = DBLink.GetConnection();
cmd = new SqlCommand("Delete FROM News where NewsID = @NewsID", conn);
cmd.Parameters.Add(new SqlParameter("@NewsID", ID));
}
try
{
conn.Open();
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception)
{
}
finally
{
cmd.Dispose();
conn.Close();
}
return(false);
}
/// <summary>
/// 获取最近信息，使用存储过程，根据属性RecordCount设置信息条数，SmallCID确定文章类型
/// </summary>
/// <returns></returns>
public static DataTable GetRecentRecord(int RecordCount, int TypeID)
{
SqlConnection conn = DBLink.GetJobsky6Connection();
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetRecentRecordFromOldAndNewDatabase";
cmd.Parameters.Add(new SqlParameter("@recordcount", RecordCount));
cmd.Parameters.Add(new SqlParameter("@TypeID", TypeID));
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
cmd.Dispose();
conn.Close();
return(dt);
}
