public DataSet LoadInfo()
{
string sql = "select * from [column] order by columnID asc";
Database db = new Database();
DataSet ds = db.GetDataSet(sql);
return ds;
}
public DataSet Loadauthor(string userID)
{
string sql = "select * from author where 1=1";
if (userID.Trim() != "")
{
sql += "and authorID like '%" + userID + "%'";
}
Database db = new Database();
DataSet ds = db.GetDataSet(sql);
return ds;
}
public DataSet Loadassess(int docID)
{
string sql = "select assess.*,expert.expertName,expert.expertID from assess,expert where assess.expertID=expert.expertID and assess.docID=" + SQLString.GetQuotedString(Convert.ToString(docID));
Database db = new Database();
DataSet ds = db.GetDataSet(sql);
return ds;
}
public DataSet LoadInfo(string ID, string column, string Name)
{
string sql = "SELECT editor.editorID, editor.editorName, editor.editorPhone, editor.editorMail, editor.editorColumn, [column].columnName FROM [editor],[column] where[column].columnID = editor.editorColumn";
if (ID != "")
{
sql += " and editorID like '%" + ID + "%'";
}
if (column != "")
{
sql += " and editorColumn like '%" + column + "%'";
}
if (Name != "")
{
sql += " and editorName like '%" + Name + "%'";
}
Database db = new Database();
DataSet ds = db.GetDataSet(sql);
return ds;
}
//主编加载稿件版面信息
public DataSet Asign_board(string title, string author)
{
string sql = "select document.docID,document.docTitle,document.authorID,board.boardRank,board.boardMoney,board.boardState from document,board where document.docID=board.docID";
if (title != "")
{
sql += " and docTitle like '%" + title + "%'";
}
if (author != "")
{
sql += " and authorID like '%" + author + "%'";
}
Database db = new Database();
DataSet ds = db.GetDataSet(sql);
return ds;
}
//作者加载稿件版面信息
public DataSet Load_board(string author)
{
string sql = "select document.docID,document.docTitle,document.authorID,board.boardRank,board.boardMoney,board.boardState from document,board where document.docID=board.docID and document.authorID=" + SQLString.GetQuotedString(author);
Database db = new Database();
DataSet ds = db.GetDataSet(sql);
return ds;
}
//加载作者返修稿件
public DataSet LoadRepairdoc(string author)
{
string sql = " SELECT [document].docID, [document].docTime, [document].docTitle, [document].docReason, state.stateText FROM document,state where [document].docState = state.stateID and docState like " + SQLString.GetQuotedString("_2") + "and authorID=" + SQLString.GetQuotedString(author);
Database db = new Database();
DataSet ds = db.GetDataSet(sql);
return ds;
}
//专家审核稿件 assess为0 未审稿件，否则为已审稿件
public DataSet expertload(string expert, string title, string author, int assess)
{
string sql;
if (assess == 0)
{
sql = "select document.docID,document.docTitle,docTime,document.authorID,attach.attachName,assess.expertID from document,attach,assess where document.docID=attach.docID and document.docID=assess.docID and assess.expertID=" + SQLString.GetQuotedString(expert) + "and assess.assessment is null";
}
else
{
sql = "select document.docID,document.docTitle,docTime,document.authorID,attach.attachName,assess.expertID,assess.assessment from document,attach,assess where document.docID=attach.docID and document.docID=assess.docID and assess.expertID=" + SQLString.GetQuotedString(expert) + "and assess.assessment is not null";
}
if (title != "")
{
sql += " and docTitle like '%" + title + "%'";
}
if (author != "")
{
sql += " and authorID like '%" + author + "%'";
}
Database db = new Database();
DataSet ds = db.GetDataSet(sql);
return ds;
}
//根据投稿栏目加载编辑稿件信息
public DataSet editorload(string editor, string title, string author, string state)
{
string sql = "";
if (state != "")
{
sql = "select document.*,attach.* from document,attach where document.docID=attach.docID and docState=" + SQLString.GetQuotedString(state) + " and document.docColumnID=" + SQLString.GetQuotedString(editor);
}
else
{
sql = "select document.*,attach.*,state.stateText from document,attach,state where document.docID=attach.docID and document.docState=state.stateID and docState !=" + SQLString.GetQuotedString("0") + " and document.docColumnID=" + SQLString.GetQuotedString(editor);
}
if (title != "")
{
sql += "and docTitle like '%" + title + "%'";
}
if (author != "")
{
sql += "and authorID like '%" + author + "%'";
}
Database db = new Database();
DataSet ds = db.GetDataSet(sql);
return ds;
}
//稿件统计信息
public DataSet AllDoc(string title, string column, string Keywords, string timeF, string timeT)
{
string sql = "SELECT [document].docID,[document].docTime, [document].docTitle, [document].docKeywords, [document].authorID, [column].columnName,attach.attachName FROM [column],[document],[attach] where document.docID=attach.docID and [column].columnID = [document].docColumnID and [document].docTime between " + SQLString.GetQuotedString(timeF) + "and " + SQLString.GetQuotedString(timeT);
if (title != "")
{
sql += "and docTitle like '%" + title + "%'";
}
if (column != "")
{
sql += "and docColumnID like '%" + column + "%'";
}
if (Keywords != "")
{
sql += "and docTitle like '%" + Keywords + "%'";
}
Database db = new Database();
DataSet ds = db.GetDataSet(sql);
return ds;
}
//主编未审稿件信息
public DataSet adminload(string title, string author, string state)
{
string sql = "";
if (state == "")
{
sql = "select document.*,attach.* from document,attach where document.docID=attach.docID and docState !=" + SQLString.GetQuotedString(state) + " and docState like '2_'";
}
else
{
sql = "select document.*,attach.* from document,attach where document.docID=attach.docID and docState=" + SQLString.GetQuotedString(state);
}
if (title != "")
{
sql += "and docTitle like '%" + title + "%'";
}
if (author != "")
{
sql += "and authorID like '%" + author + "%'";
}
Database db = new Database();
DataSet ds = db.GetDataSet(sql);
return ds;
}
//加载消息
public DataSet LoadMsg(string user)
{
string sql = "select * from message where messageTo=" + SQLString.GetQuotedString(user) + "order by messageState asc,messageTime desc";
Database db = new Database();
DataSet ds = db.GetDataSet(sql);
return ds;
}