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 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 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 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 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 void Docload(int docID) { string sql = "select * from document where docID=" + SQLString.GetQuotedString(Convert.ToString(docID)); Database db = new Database(); DataRow dr = db.GetDataRow(sql); if (dr != null) { this._docID = GetSafeData.ValidateDataRow_N(dr, "docID"); this._docTime = GetSafeData.ValidateDataRow_T(dr, "docTime"); this._docTitle = GetSafeData.ValidateDataRow_S(dr, "docTitle"); this._docTitleEn = GetSafeData.ValidateDataRow_S(dr, "docTitleEn"); this._docAbstract = GetSafeData.ValidateDataRow_S(dr, "docAbstract"); this._docAbstractEn = GetSafeData.ValidateDataRow_S(dr, "docAbstractEn"); this._docKeywords = GetSafeData.ValidateDataRow_S(dr, "docKeywords"); this._docKeywordsEn = GetSafeData.ValidateDataRow_S(dr, "docKeywordsEn"); this._docLetters = GetSafeData.ValidateDataRow_N(dr, "docLetters"); this._docAuthor = GetSafeData.ValidateDataRow_S(dr, "docAuthor"); this._docColumnID = GetSafeData.ValidateDataRow_S(dr, "docColumnID"); this._authorID = GetSafeData.ValidateDataRow_S(dr, "authorID"); this._docState = GetSafeData.ValidateDataRow_S(dr, "docState"); this._docReason = GetSafeData.ValidateDataRow_S(dr, "docReason"); } }