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