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