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 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 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 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 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 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 Delete(string ID)
{
string sql = "delete from [column] where columnID=" + SQLString.GetQuotedString(ID);
Database db = new Database();
db.ExecuteSQL(sql);
}
//打开消息后改变状态
public void Update_state(int messageID)
{
string sql = "update message set messageState=" + SQLString.GetQuotedString("1") + "where messageID=" + SQLString.GetQuotedString(Convert .ToString (messageID));
Database db = new Database();
db.ExecuteSQL(sql);
}
//删除消息
public void Delete_msg(int messageID)
{
string sql = "delete from message where messageID=" + SQLString.GetQuotedString(Convert.ToString(messageID));
Database db = new Database();
db.ExecuteSQL(sql);
}
