public DataSet LoadInfo() { string sql = "select * from [column] order by columnID asc"; Database db = new Database(); DataSet ds = db.GetDataSet(sql); return ds; }
public DataRow GetRow(int docID) { string sql = "select * from attach where docID=" + SQLString.GetQuotedString(Convert.ToString(docID)); Database db = new Database(); DataRow dr = db.GetDataRow(sql); return dr; }
public bool Update(Hashtable userInfo, string Xwhere) { Database db = new Database(); if (db.Update("[admin]", userInfo, Xwhere)) { return true; } return false; }
public bool Addcolumn(Hashtable userInfo) { Database db = new Database(); if (db.Insert("[column]", userInfo)) { return true; } return false; }
public void LoadInfo(string adminID) { string sql = "select * from admin where adminID=" + SQLString.GetQuotedString(adminID); Database db = new Database(); DataRow dr = db.GetDataRow(sql); if (dr != null) { this._adminID = GetSafeData.ValidateDataRow_S(dr, "adminID"); this._adminPwd = GetSafeData.ValidateDataRow_S(dr, "adminPwd"); } }
public int Login(string adminID, string adminPwd) { string sql = "select * from admin where adminID=" + SQLString.GetQuotedString(adminID); Database db = new Database(); SqlDataReader sdr = db.GetDataReader(sql); if (sdr.Read()) { if (sdr["adminPwd"].ToString() == adminPwd) { return 1; } else return -1; } return 0; }
public void Delete(int docID) { string sql = "delete from assess where docID=" + SQLString.GetQuotedString(Convert.ToString(docID)); Database db = new Database(); db.ExecuteSQL(sql); }
public void AsignExp(Hashtable ht) { Database db = new Database(); db.Insert("[assess]", ht); }
public bool Update_Column(string editor, string column) { string sql = "update editor set editorColumn=" + SQLString.GetQuotedString(column) + "where editorID=" + SQLString.GetQuotedString(editor); Database db = new Database(); if (db.ExecuteSQL(sql) > 0) { return true; } return false; }
//上传返修稿件后更改状态 public void Update_attach(int docID, string state) { string sql = "update document set docState=" + SQLString.GetQuotedString(state) + "where docID=" + SQLString.GetQuotedString(Convert.ToString(docID)); Database db = new Database(); db.ExecuteSQL(sql); }
public void LoadInfo(string authorID) { string sql="select * from author where authorID="+SQLString .GetQuotedString (authorID); Database db = new Database(); DataRow dr = db.GetDataRow(sql); if (dr != null) { this._authorID = GetSafeData.ValidateDataRow_S(dr, "authorID"); this._authorPwd = GetSafeData.ValidateDataRow_S(dr, "authorPwd"); this._authorName = GetSafeData.ValidateDataRow_S(dr, "authorName"); this._authorSex = GetSafeData.ValidateDataRow_S(dr, "authorSex"); this._authorBirth = GetSafeData.ValidateDataRow_S(dr, "authorBirth"); this._authorRegion = GetSafeData.ValidateDataRow_S(dr, "authorRegion"); this._authorPost = GetSafeData.ValidateDataRow_S(dr, "authorPost"); this._authorMail = GetSafeData.ValidateDataRow_S(dr, "authorMail"); this._authorDegree = GetSafeData.ValidateDataRow_S(dr, "authorDegree"); this._authorMajor = GetSafeData.ValidateDataRow_S(dr, "authorMajor"); this._authorTitle = GetSafeData.ValidateDataRow_S(dr, "authorTitle"); this._authorJob = GetSafeData.ValidateDataRow_S(dr, "authorJob"); this._authorCompany = GetSafeData.ValidateDataRow_S(dr, "authorCompany"); this._authorPhone = GetSafeData.ValidateDataRow_S(dr, "authorPhone"); this._authorAddress = GetSafeData.ValidateDataRow_S(dr, "authorAddress"); this._authorInfo = GetSafeData.ValidateDataRow_S(dr, "authorInfo"); this._exist = true; } else { this._exist = false; } }
public bool Delete(string ID) { string sql = "delete from [author] where authorID=" + SQLString.GetQuotedString(ID); Database db = new Database(); if (db.ExecuteSQL(sql)>0) { return true; } return false; }
public bool Add(Hashtable userInfo) { Database db = new Database(); if (db.Insert("[author]", userInfo)) { return true; } return false; }
public void Adduser(Hashtable userInfo) { Database db = new Database(); db.Insert("[editor]", userInfo); }
//主编加载稿件版面信息 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 void Add(Hashtable ht) { Database db = new Database(); db.Insert("[board]", ht); }
//更新稿件版面信息 public bool Update_board(int ID,string rank,string money,string state) { string sql = "update board set boardRank=" + SQLString.GetQuotedString(rank) + ",boardMoney=" + SQLString.GetQuotedString(money) + ",boardState=" + SQLString.GetQuotedString(state) + "where docID=" + SQLString.GetQuotedString(Convert.ToString(ID)); Database db = new Database(); if (db.ExecuteSQL(sql) > 0) { return true; } return false; }
//作者加载稿件版面信息 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 DataRow viewassess(string expert, int docID) { string sql = "select assessment from assess where docID=" + SQLString.GetQuotedString(Convert.ToString(docID)) + "and expertID=" + SQLString.GetQuotedString(expert); Database db = new Database(); DataRow dr = db.GetDataRow(sql); return dr; }
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 bool Update(Hashtable ht, string Xwhere) { Database db = new Database(); if (db.Update("[assess]", ht, Xwhere)) { return true; } return false; }
public bool Delete(string editor) { string sql = "delete from editor where editorID=" + SQLString.GetQuotedString(editor); Database db = new Database(); if (db.ExecuteSQL(sql)>0) { return true; } else { return false; } }
public bool CheckUser(string authorID) { string sql = "select * from author where authorID=" + SQLString.GetQuotedString(authorID); Database db = new Database(); DataRow dr = db.GetDataRow(sql); if (dr != null) { return false; } return true; }
public void LoadInfo(string editorID) { string sql = "select * from editor where editorID=" + SQLString.GetQuotedString(editorID); Database db = new Database(); DataRow dr = db.GetDataRow(sql); if (dr != null) { this._editorID = GetSafeData.ValidateDataRow_S(dr, "editorID"); this._editorPwd = GetSafeData.ValidateDataRow_S(dr, "editorPwd"); this._editorName = GetSafeData.ValidateDataRow_S(dr, "editorName"); this._editorSex = GetSafeData.ValidateDataRow_S(dr, "editorSex"); this._editorColumn = GetSafeData.ValidateDataRow_S(dr, "editorColumn"); this._editorPhone = GetSafeData.ValidateDataRow_S(dr, "editorPhone"); this._editorMail = GetSafeData.ValidateDataRow_S(dr, "editorMail"); this._editorAddress = GetSafeData.ValidateDataRow_S(dr, "editorAddress"); this._editorInfo = GetSafeData.ValidateDataRow_S(dr, "editorInfo"); } }
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 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; }
public int Login(string editorID, string editorPwd) { string sql = "select * from editor where editorID=" + SQLString.GetQuotedString(editorID); Database db = new Database(); SqlDataReader sdr = db.GetDataReader(sql); if (sdr.Read()) { if (sdr["editorPwd"].ToString() == editorPwd) { return 1; } else return -1; } return 0; }
//更新稿件信息 public bool Update(Hashtable document, string Xwhere) { Database db = new Database(); if (db.Update("[document]", document, Xwhere)) { return true; } return false; }
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 int GetID(string authorID) { int ID; string sql = "select docID from document where authorID=" + SQLString.GetQuotedString(authorID) + "order by docTime desc"; Database db = new Database(); SqlDataReader sdr = db.GetDataReader(sql); if (sdr.Read()) { ID = sdr.GetInt32(0); return ID; } return -1; }