public DataTable Selectusers(string user_name)//查询用户参加了什么活动
{
string sql = "select activity_id,act_name,activity_cont from users,activity where users.user_id=activity.user_id and user_name=@user_name";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@user_name", user_name),
};
return(DBHelper.GetFillData(sql, sp));
}
public DataTable SelectAll()
{
string sql = @"select Tiezi.*,
Users.UserTouxiang as [usertouxiang],
Users.UserName as [username]
from Tiezi, Users
order by t_time desc";
return(DBHelper.GetFillData(sql));
}
public DataTable SelectComments(int ThemeID)
{
string sql = "select a.*,b.UserName from Comments a,UserInfo b where ThemeID='" + ThemeID + "' and a.UserID=b.UserID order by ComTime desc";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("ISID", ThemeID)
};
return(DBHelper.GetFillData(sql, sp));
}
//选项卡
public DataTable selectMallBike(int type_id)
{
string sql = "select * from goods,goods_type where goods.type_id=goods_type.type_id and goods.type_id=@type_id";
SqlParameter[] sp =
{
new SqlParameter("@type_id", type_id),
};
return(DBHelper.GetFillData(sql, sp));
}
public DataTable SelectHotgoods()
{
string sql = "select *,store_name from goods,store where goods.store_id=store.store_id order by stock asc";
//SqlParameter[] sp =
//{
// new SqlParameter("@stock",stock)
//};
return(DBHelper.GetFillData(sql));
}
public DataTable SelectUserRider_art(int user_id)
{
string sql = "select * from rider_article where user_id=@user_id";
SqlParameter[] sp =
{
new SqlParameter("@user_id", user_id)
};
return(DBHelper.GetFillData(sql, sp));
}
public DataTable SelectDiscussion(int discussion_id)
{
string sql = "select *,user_name from discussion,users where discussion.user_id=users.user_id and discussion_id=@discussion_id";
SqlParameter[] sp =
{
new SqlParameter("@discussion_id", discussion_id),
};
return(DBHelper.GetFillData(sql, sp));
}
/// <summary>
/// 按住键查询
/// </summary>
/// <param name="V_Id"></param>
/// <returns>返回查询结果</returns>
public DataTable selectKey(int V_Id)
{
string sql = "select * from Video where V_Id=@V_Id";
SqlParameter[] sp = new SqlParameter[] {
new SqlParameter("@V_Id", V_Id)
};
return(DBHelper.GetFillData(sql, sp));
}
public DataTable SelectActivity(int activity_id)
{
string sql = "select *,user_name where users.user_id=activity.user_id and activity_id=@activity_id";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@activity_id", activity_id),
};
return(DBHelper.GetFillData(sql, sp));
}
public DataTable SelectLeavewords(int VideoID)
{
string sql = "select a.*,b.UserName from Leavewords a,UserInfo b where VideoID='" + VideoID + "' and a.UserID=b.UserID order by LeaveTime desc";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("VideoID", VideoID)
};
return(DBHelper.GetFillData(sql, sp));
}
public DataTable SelectAct_sign(int activity_id)
{
string sql = "select user_name from activity_sign,users where activity_id=@activity_id and users.user_id=activity_sign.user_id";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@activity_id", activity_id),
};
return(DBHelper.GetFillData(sql, sp));
}
public DataTable SelectUserContest(int user_id)
{
string sql = "select b.*,a.con_title from contest a,users b where a.user_id=b.user_id and user_id=@user_id";
SqlParameter[] sp =
{
new SqlParameter("@user_id", user_id),
};
return(DBHelper.GetFillData(sql, sp));
}
public DataTable SelectContestUser(int contest_id)
{
string sql = "select a.*,b.user_name from contest a,users b where a.user_id=b.user_id and contest_id=@contest_id";
SqlParameter[] sp =
{
new SqlParameter("@contest_id", contest_id),
};
return(DBHelper.GetFillData(sql, sp));
}
public DataTable SelectActID(int ActID)
{
string sql = "select * from Activities where ActID=@ActID";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ActID", ActID)
};
return(DBHelper.GetFillData(sql, sp));
}
public DataTable SelectUserTravel_record(string user_id)
{
string sql = "select * from travel_record where user_id=@user_id";
SqlParameter[] sp =
{
new SqlParameter("@user_id", user_id)
};
return(DBHelper.GetFillData(sql, sp));
}
//查看话题的详细信息
public static DataTable Stopid(int topid)
{
string sql = "select * from Topic where top_id=@top_id";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@top_id", topid)
};
return(DBHelper.GetFillData(sql, sp));
}
public DataTable SelectUserrecord_col(int user_id)
{
string sql = "select record_cover,record_title from trrecord_col,travel_record where trrecord_col.user_id=@user_id and travel_record.trrecord_id=trrecord_col.trrecord_id";
SqlParameter[] sp =
{
new SqlParameter("@user_id", user_id)
};
return(DBHelper.GetFillData(sql, sp));
}
public DataTable SelectDiscussion_comt(int discussion_id)
{
string sql = "select discussion_comt.*,user_name,user_photo from discussion_comt,users where discussion_comt.user_id=users.user_id and discussion_id=@discussion_id order by comt_time desc";
SqlParameter[] sp =
{
new SqlParameter("@discussion_id", discussion_id),
};
return(DBHelper.GetFillData(sql, sp));
}
public DataTable getsingleuser(string user_id)
{
string sql = "select * from users where user_id=@user_id";
SqlParameter[] us =
{
new SqlParameter("@user_id", user_id)
};
return(DBHelper.GetFillData(sql, us));
}
public DataTable SelectNews(int NewsId)
{
string sql = "select * from contest_news where news_id=@news_id order by pub_time";
SqlParameter[] sp =
{
new SqlParameter("@news_id", NewsId),
};
return(DBHelper.GetFillData(sql, sp));
}
public DataTable SelectFindID(int FindID)
{
string sql = "select * from Find where FindID=@FindID";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@FindID", FindID)
};
return(DBHelper.GetFillData(sql, sp));
}
public DataTable SelectDayphoto(int photo_id)
{
string sql = "select*,user_name from dayphoto,users where dayphoto.user_id=users.user_id and photo_id=@photo_id";
SqlParameter[] sp =
{
new SqlParameter("@photp_id", photo_id)
};
return(DBHelper.GetFillData(sql, sp));
}
public DataTable SelectShoppingCart(int user_id)
{
string sql = "select * from users a,shoppingcart b,goods c where a.user_id=b.user_id and b.goods_id=c.goods_id and a.user_id=@user_id";
SqlParameter[] sp =
{
new SqlParameter("@user_id", user_id),
};
return(DBHelper.GetFillData(sql, sp));
}
public DataTable SelectAlbumCover(int album_id)
{
string sql = "select * from album where album_id=@album_id order by create_time desc";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@album_id", album_id),
};
return(DBHelper.GetFillData(sql, sp));
}
public DataTable SelectVideoID(int VideoID)
{
string sql = "select * from Video where VideoID like '" + @VideoID + "'";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@VideoID", VideoID)
};
return(DBHelper.GetFillData(sql, sp));
}
public DataTable Selectusers(int user_id)
{
string sql = "select * from album,users where album.creater_id=users.user_id and creater_id=@user_id";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@user_id", user_id)
};
return(DBHelper.GetFillData(sql, sp));
}
public DataTable SelectThemeID(int ThemeID)
{
string sql = "select * from Theme where ThemeID like '" + @ThemeID + "'";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ThemeID", ThemeID)
};
return(DBHelper.GetFillData(sql, sp));
}
public DataTable SelectAll(int UserID)
{
string sql = "select* from Score a left join KaoJuan b on a.KaoJuanID = b.KaoJuanID where a.UserID = @UserID ";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@UserID", UserID)
};
return(DBHelper.GetFillData(sql, sp));
}
public DataTable SelectContest(int ConId)
{
string sql = "select * from contest where contest_id =@contest_id order by con_time ";
SqlParameter[] sp =
{
new SqlParameter("contest_id ", ConId),
};
return(DBHelper.GetFillData(sql, sp));
}
public DataTable SelectArticle(int ArtID)
{
string sql = "select * from Article where ArtID=@ArtID order by Art_clicknum desc";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ArtID", ArtID),
};
return(DBHelper.GetFillData(sql, sp));
}