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