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 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 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; }