/// <summary>
/// 取得所有年份
/// </summary>
public DataSet GetYearList()
{
StringBuilder sb = new StringBuilder();
sb.AppendLine(" select * from TB_Period ");
OleDbCommand cmd = new OleDbCommand(sb.ToString());
cmd.CommandType = CommandType.Text;
DataSet ds = SQLOle.QueryDS(cmd);
return(ds);
}
/// <summary>
/// 取得需要修改InDate的資料
/// </summary>
public DataSet GetACCMemberPInDate()
{
StringBuilder sb = new StringBuilder();
sb.AppendLine(" select * from 個人會員 where not INDATE is null ");
OleDbCommand cmd = new OleDbCommand(sb.ToString());
cmd.CommandType = CommandType.Text;
DataSet ds = SQLOle.QueryDS(cmd);
return(ds);
}
/// <summary>
/// 取得所有Fee
/// </summary>
public DataSet GetFeeList()
{
StringBuilder sb = new StringBuilder();
sb.AppendLine(" select * from TB_Fee where not RecDate is null");
OleDbCommand cmd = new OleDbCommand(sb.ToString());
cmd.CommandType = CommandType.Text;
DataSet ds = SQLOle.QueryDS(cmd);
return(ds);
}
/// <summary>
/// 取得所有論文Suggestion
/// </summary>
public DataSet GetPaperSuggestionListByPaperID(int intPaperID)
{
StringBuilder sb = new StringBuilder();
sb.AppendLine(" select * from TB_PaperSuggestion where PaperID=" + intPaperID);
OleDbCommand cmd = new OleDbCommand(sb.ToString());
cmd.CommandType = CommandType.Text;
DataSet ds = SQLOle.QueryDS(cmd);
return(ds);
}
//SELECT *
//FROM 個人會員
//LEFT JOIN
//(
// SELECT * FROM
// (SELECT * FROM TB_Member where MemberType='P' )
// )AS Table2
//ON 個人會員.MARK=Table2.MemberID
//;
/// <summary>
/// 取得所有的個人會員
/// </summary>
public DataSet GetACCMemberP()
{
StringBuilder sb = new StringBuilder();
sb.AppendLine(" SELECT * FROM 個人會員 ");
sb.AppendLine(" LEFT JOIN ");
sb.AppendLine(" ( ");
sb.AppendLine(" SELECT * FROM ");
sb.AppendLine(" (SELECT * FROM TB_Member where MemberType='P' ) ");
sb.AppendLine(" )AS Table2 ");
sb.AppendLine(" ON 個人會員.MARK=Table2.MemberID order by MARK ; ");
OleDbCommand cmd = new OleDbCommand(sb.ToString());
cmd.CommandType = CommandType.Text;
DataSet ds = SQLOle.QueryDS(cmd);
return(ds);
}
//SELECT *
//FROM 團體會員
//LEFT JOIN
//(
// SELECT * FROM
// (SELECT * FROM TB_Member where MemberType='G' )
// )AS Table2
//ON 團體會員.MARK=Table2.MemberID
/// <summary>
/// 團體會員
/// </summary>
public DataSet GetACCMemberG()
{
StringBuilder sb = new StringBuilder();
sb.AppendLine(" SELECT * FROM 團體會員 ");
sb.AppendLine(" LEFT JOIN ");
sb.AppendLine(" ( ");
sb.AppendLine(" SELECT * FROM ");
sb.AppendLine(" (SELECT * FROM TB_Member where MemberType='G' ) ");
sb.AppendLine(" )AS Table2 ");
sb.AppendLine(" ON 團體會員.MARK=Table2.MemberID ; ");
//string strTSQL = "select * from 團體會員";
OleDbCommand cmd = new OleDbCommand(sb.ToString());
cmd.CommandType = CommandType.Text;
DataSet ds = SQLOle.QueryDS(cmd);
return(ds);
}