S机房设备远程监控管理系统V1.0源代码

using System;using System.Collections.Generic;using System.Linq;using System.Text;using Component;using System.Data;using System.Collections;namespace LinkLib{public class tb_liucheng_definition{DBExecute db = new DBExecute();/// <summary>/// 构造函数///author:/// </summary>public tb_liucheng_definition(){int Id = 0;string Streamname = "";int levelcount = 0;int Isdelete = 0;int department = 0;DateTime Updatetime = DateTime.Now;int Userids = 0;int Typeid = 0;int Userid = 0;}#region 属性和字段int m_Id = 0;public int Id{set { m_Id = value; }get { return m_Id; }}string m_Streamname = "";public string Streamname{set { m_Streamname = value; }get { return m_Streamname; }}int m_levelcount = 0;public int levelcount{set { m_levelcount = value; }get { return m_levelcount; }}int m_Isdelete = 0;public int Isdelete{set { m_Isdelete = value; }get { return m_Isdelete; }}int m_department = 0;public int department{set { m_department = value; }get { return m_department; }}DateTime m_Updatetime = DateTime.Now;public DateTime Updatetime{set { m_Updatetime = value; }get { return m_Updatetime; }}int m_Userids = 0;public int Userids{set { m_Userids = value; }get { return m_Userids; }}int m_Typeid = 0;public int Typeid{set { m_Typeid = value; }get { return m_Typeid; }}int m_Userid = 0;public int Userid{set { m_Userid = value; }get { return m_Userid; }}#endregion#region 新增记录/// <summary>/// 插入一条记录/// </summary>/// <param name="out error">返回错误信息</param>/// <returns>true成功false 失败</returns>///author:public int Insert(out string error){int lastid = 0;bool breturn = false;error = "";try{string sql = "";sql = " insert into tb_liucheng_definition (Streamname , levelcount , Isdelete , department , Updatetime , Userids , Typeid , Userid) values( @Streamname,@levelcount,@Isdelete,@department,@Updatetime,@Userids,@Typeid,@Useri d)";Hashtable hs = new Hashtable();hs.Add("@Streamname", Streamname);hs.Add("@levelcount", levelcount);hs.Add("@Isdelete", Isdelete);hs.Add("@department", department);hs.Add("@Updatetime", Updatetime);hs.Add("@Userids", Userids);hs.Add("@Typeid", Typeid);hs.Add("@Userid", Userid);lastid = db.ExecuteSQLreturnid(sql, hs);breturn = true;}catch (System.Exception ex){error = ex.ToString();}return lastid;}#endregion#region 修改记录/// <summary>/// 修改一条记录/// </summary>/// <param name="out error">返回错误信息</param>/// <returns>true成功false 失败</returns>///author:public bool update(out string error){bool breturn = false;error = "";try{string sql = "";sql = " update tb_liucheng_definition setStreamname=@Streamname,levelcount=@levelcount,Isdelete=@Isdelete,department=@departme nt,Updatetime=@Updatetime,Userids=@Userids,Typeid=@Typeid,Userid=@Userid whereId=@Id";Hashtable hs = new Hashtable();hs.Add("@Id", Id);hs.Add("@Streamname", Streamname);hs.Add("@levelcount", levelcount);hs.Add("@Isdelete", Isdelete);hs.Add("@department", department);hs.Add("@Updatetime", Updatetime);hs.Add("@Userids", Userids);hs.Add("@Typeid", Typeid);hs.Add("@Userid", Userid);db.ExecuteSQL(sql, hs);breturn = true;}catch (System.Exception ex){error = ex.ToString();}return breturn;}#endregion#region 删除记录/// <summary>/// 删除一条记录/// </summary>/// <param name="type">删除类型0 删除记录，1 标示isdelete字段</param>/// <param name="out error">返回错误信息</param>/// <returns>true成功false 失败</returns>///author:public bool delete(int type, string id, out string error){bool breturn = false;error = "";try{string sql = "";if (type == 0)sql = "delete from tb_liucheng_definition where Id=@Id";elsesql = "update tb_liucheng_definition set isdelete=1 where Id=@Id";Hashtable hs = new Hashtable();hs.Add("@Id", id);db.ExecuteSQL(sql, hs);breturn = true;}catch (System.Exception ex){error = ex.ToString();}return breturn;}#endregion#region 得到所有设备监控数据/// <summary>/// 得到所有数据/// </summary>/// <param name="out error">返回错误信息</param>/// <returns>数据列表</returns>///author:public DataTable GetList(out string error){DataTable table = new DataTable();error = "";try{string sql = "select * from tb_liucheng_definition where isdelete =0 order by Id desc"; table = db.Getdatable(sql);}catch (System.Exception ex){error = ex.ToString();}return table;}#endregion#region 得到所有监控总数/// <summary>/// 得到所有监控总数/// </summary>/// <returns>记录的集合</returns>///author:public int getcount(string where){string error;DataTable table = new DataTable();error = "";try{string sql = "select Id from tb_liucheng_definition where " + where;table = db.Getdatable(sql);}catch (System.Exception ex){error = ex.ToString();}return table.Rows.Count;}#endregion#region 根据页数得到当前页的数据/// <summary>/// 根据页数得到当前页的数据/// </summary>/// <param name="no">每页显示的数量</param>/// <param name="pageno">当前页数</param>/// <param name="order">排序字段</param>/// <param name="where">条件</param>/// <returns></returns>///author:public DataTable GetDatabyPage(int no, int pageno, string order, string where){DataTable table = new DataTable();string sql = "SELECT TOP " + no + " * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY " + order + " ) AS RowNumber,* FROM tb_liucheng_definition where " + where + " ) A WHERE " + where + " and RowNumber > " + ((pageno - 1) * no);table = db.Getdatable(sql);return table;}#endregion#region 根据主键得到一条记录/// <summary>/// 根据主键得到一条记录/// </summary>/// <param name="id">主键</param>/// <param name="out error">返回错误信息</param>/// <returns>数据列表</returns>public tb_liucheng_definition GetdataByid(int id, out string error){DataTable table = new DataTable();error = "";tb_liucheng_definition obj = new tb_liucheng_definition(); try{string sql = "select * from tb_liucheng_definition where isdelete =0 and Id =@Id"; Hashtable hs = new Hashtable();hs.Add("@Id", id);table = db.Getdatable(sql, hs);if (table.Rows.Count != 0){obj.Id = Convert.ToInt32(table.Rows[0]["Id"].ToString());obj.Streamname = table.Rows[0]["Streamname"].ToString();obj.levelcount = Convert.ToInt32(table.Rows[0]["levelcount"].ToString());obj.Isdelete = Convert.ToInt32(table.Rows[0]["Isdelete"].ToString());obj.department = Convert.ToInt32(table.Rows[0]["department"].ToString());obj.Updatetime = Convert.ToDateTime(table.Rows[0]["Updatetime"].ToString());erids = Convert.ToInt32(table.Rows[0]["Userids"].ToString());obj.Typeid = Convert.ToInt32(table.Rows[0]["Typeid"].ToString());erid = Convert.ToInt32(table.Rows[0]["Userid"].ToString());}}catch (System.Exception ex){error = ex.ToString();}return obj;}#endregion#region 根据条件得到记录/// <summary>/// 根据条件得到记录/// </summary>/// <param name="sqlConditon"></param>///author:public DataTable GetDataByWhere(string sqlConditon){string sql = "SELECT * FROM tb_liucheng_definition where 1=1 and {0}";string sqlText = string.Format(sql, sqlConditon);return db.Getdatable(sqlText);}#endregion}}using System;using System.Collections.Generic;using System.Text;using System.Data;using System.Data.SqlClient;namespace Component{public class Cauditmanager{public void Addaudit(Caudit cd){SqlConnection conn = Common.GetConn();string sql = "INSERT INTOAudit_table(ConferencerTitle,username,Noticeneirong,UseConfroom,Auditusername,AuditTime,i sAudit,Istongguo)VALUES(@ConferencerTitle,@username,@Noticeneirong,@UseConfroom,@Auditusername,@ AuditTime,@isAudit,@Istongguo)";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@ConferencerTitle", cd.Conferencertitle);comm.Parameters.AddWithValue("@username", erName);comm.Parameters.AddWithValue("@Noticeneirong", cd.NoticeNeirong);comm.Parameters.AddWithValue("@UseConfroom", econfroom);comm.Parameters.AddWithValue("@Auditusername", cd.AuditUsername);comm.Parameters.AddWithValue("@AuditTime", cd.Audittime);comm.Parameters.AddWithValue("@isAudit", cd.IsAudit);comm.Parameters.AddWithValue("@Istongguo", cd.IstongGuo);comm.ExecuteNonQuery();conn.Close();}public void dalete(string name){SqlConnection conn = Common.GetConn();string sql = "UPDATE Audit_table SET Istongguo=2 WHERE Isdelete=1 and ConferencerTitle=@ConferencerTitle";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@ConferencerTitle", name);comm.ExecuteNonQuery();conn.Close();}public DataTable selectcad(){SqlConnection conn = Common.GetConn();string sql = "SELECT * FROM Audit_table where isAudit=0 and Isdelete=1";SqlDataAdapter sda = new SqlDataAdapter(sql, conn);DataSet ds = new DataSet();sda.Fill(ds);return ds.Tables[0];conn.Close();}public DataTable selectcAudit(){SqlConnection conn = Common.GetConn();string sql = "SELECTa.AuditID,a.ConferencerTitle,ername,eConfroom,a.Istongguo,b.BookTime,b.NeedTime FROM Audit_table a,Conference_table b where (a.Istongguo=1 or a.Istongguo=2) anda.Isdelete=1 and a.isAudit=0 and a.ConferencerTitle=b.ConferencerTitle";SqlDataAdapter sda = new SqlDataAdapter(sql, conn);DataSet ds = new DataSet();sda.Fill(ds);return ds.Tables[0];conn.Close();}public DataTable selectcquxiao(string name){SqlConnection conn = Common.GetConn();string sql = "SELECT * FROM Conference_table a,Audit_table b wherea.ConferencerTitle=b.ConferencerTitle and ername=@username and a.Isdelete=1 andb.Istongguo<>2";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@username", name);SqlDataAdapter sda = new SqlDataAdapter(comm);DataSet ds = new DataSet();sda.Fill(ds);return ds.Tables[0];conn.Close();}}}namespace Component{using System;using System.Data;using System.Data.SqlClient;public class Cbwangmanager{public void Addbwang(Cbwang cb){SqlConnection conn = Common.GetConn();string sql = "INSERT INTOMemorandum_table(userName,MemorandumName,Memorandumneirong,MemorandumTime,Me morandumchengdu)VALUES(@userName,@MemorandumName,@Memorandumneirong,@MemorandumTime,@M emorandumchengdu)";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@userName", ername);comm.Parameters.AddWithValue("@MemorandumName", cb.Memorandumname);comm.Parameters.AddWithValue("@Memorandumneirong", cb.MemorandumNeirong);comm.Parameters.AddWithValue("@MemorandumTime", cb.Memorandumtime);comm.Parameters.AddWithValue("@Memorandumchengdu", cb.MemorandumChengdu);comm.ExecuteNonQuery();conn.Close();}public void deletebwang(string username, string mname, DateTime mtime){SqlConnection conn = Common.GetConn();string sql = "UPDATE Memorandum_table SET Isdelete = 0 WHERE MemorandumName=@MemorandumName and userName=@userName and MemorandumTime=@MemorandumTime";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@userName", username);comm.Parameters.AddWithValue("@MemorandumName", mname);comm.Parameters.AddWithValue("@MemorandumTime", mtime);comm.ExecuteNonQuery();conn.Close();}public DataTable selectbg(string username, DateTime mstime,DateTime metime){SqlConnection conn = Common.GetConn();string sql = "SELECT * FROM Memorandum_table where Isdelete=1 anduserName=@userName and MemorandumTime between @sTime AND @eTime";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@userName", username);comm.Parameters.AddWithValue("@sTime", mstime);comm.Parameters.AddWithValue("@eTime", metime);comm.ExecuteNonQuery();SqlDataAdapter sda = new SqlDataAdapter(comm);DataSet ds = new DataSet();sda.Fill(ds);return ds.Tables[0];conn.Close();}public DataTable selectbwang(string username){SqlConnection conn = Common.GetConn();string sql = "SELECT * FROM Memorandum_table where userName=@userName and Isdelete=1";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@userName", username);comm.ExecuteNonQuery();SqlDataAdapter sda = new SqlDataAdapter(comm);DataSet ds = new DataSet();sda.Fill(ds);return ds.Tables[0];conn.Close();}public DataTable selectbwang(string username, DateTime time){SqlConnection conn = Common.GetConn();string sql = "SELECT * FROM Memorandum_table where userName=@userName and Isdelete=1 and MemorandumTime=@MemorandumTime";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@userName", username);comm.Parameters.AddWithValue("@MemorandumTime", time);comm.ExecuteNonQuery();SqlDataAdapter sda = new SqlDataAdapter(comm);DataSet ds = new DataSet();sda.Fill(ds);return ds.Tables[0];conn.Close();}public DataTable selectcb(string username, string mname, DateTime mtime){SqlConnection conn = Common.GetConn();string sql = "SELECT * FROM Memorandum_table whereMemorandumName=@MemorandumName and userName=@userName and MemorandumTime=@MemorandumTime and Isdelete=1";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@MemorandumName", mname);comm.Parameters.AddWithValue("@userName", username);comm.Parameters.AddWithValue("@MemorandumTime", mtime);comm.ExecuteNonQuery();SqlDataAdapter sda = new SqlDataAdapter(comm);DataSet ds = new DataSet();sda.Fill(ds);return ds.Tables[0];conn.Close();}public DataTable selectxiangxi(string username, string mname){SqlConnection conn = Common.GetConn();string sql = "SELECT * FROM Memorandum_table where userName=@userName and Isdelete=1 and MemorandumName=@MemorandumName";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@userName", username);comm.Parameters.AddWithValue("@MemorandumName", mname);comm.ExecuteNonQuery();SqlDataAdapter sda = new SqlDataAdapter(comm);DataSet ds = new DataSet();sda.Fill(ds);return ds.Tables[0];conn.Close();}public void updatebwang(Cbwang cb, string mname){SqlConnection conn = Common.GetConn();string sql = "UPDATE Memorandum_table SET userName =@userName,MemorandumName = @MemorandumName,Memorandumneirong =@Memorandumneirong,MemorandumTime = @MemorandumTime,Memorandumchengdu = @Memorandumchengdu WHERE Isdelete = 1 and MemorandumName=@mname";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@userName", ername);comm.Parameters.AddWithValue("@MemorandumName", cb.Memorandumname);comm.Parameters.AddWithValue("@Memorandumneirong", cb.MemorandumNeirong);comm.Parameters.AddWithValue("@MemorandumTime", cb.Memorandumtime);comm.Parameters.AddWithValue("@Memorandumchengdu", cb.MemorandumChengdu);comm.Parameters.AddWithValue("@mname", mname);comm.ExecuteNonQuery();conn.Close();}}}namespace Component{using System;using System.Data;using System.Data.SqlClient;public class CDocumentmanager{public void AddDocument(CDocument cd){SqlConnection conn = Common.GetConn();string sql = "INSERT INTODocument_table(bumenName,username,Documentbiaoti,DocumentMeSH,DocumentPriorities,Do cumentContent,DocumentAnnex,DocumentAudit,DocumentReviewed,DocumentTime) VALUES(@bumenName,@username,@Documentbiaoti,@DocumentMeSH,@DocumentPrioritie s,@DocumentContent,@DocumentAnnex,@DocumentAudit,@DocumentReviewed,@Document Time)";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@bumenName", cd.BumenName);comm.Parameters.AddWithValue("@username", erName);comm.Parameters.AddWithValue("@Documentbiaoti", cd.DocumentBiaoti);comm.Parameters.AddWithValue("@DocumentMeSH", cd.DocumentmeSH);comm.Parameters.AddWithValue("@DocumentPriorities", cd.Documentpriorities);comm.Parameters.AddWithValue("@DocumentContent", cd.Documentcontent);comm.Parameters.AddWithValue("@DocumentAnnex", cd.Documentannex);comm.Parameters.AddWithValue("@DocumentAudit", cd.Documentaudit);comm.Parameters.AddWithValue("@DocumentReviewed", cd.Documentreviewed);comm.Parameters.AddWithValue("@DocumentTime", cd.Documenttime);comm.ExecuteNonQuery();conn.Close();}public DataTable chongfu(string username, string biaoti){SqlConnection conn = Common.GetConn();string sql = "SELECT * FROM Document_table where Isdelete=1 andusername=@username and Documentbiaoti=@Documentbiaoti";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@username", username);comm.Parameters.AddWithValue("@Documentbiaoti", biaoti);comm.ExecuteNonQuery();SqlDataAdapter sda = new SqlDataAdapter(comm);DataSet ds = new DataSet();sda.Fill(ds);return ds.Tables[0];conn.Close();}public void deletecaogao(string username,string bname){SqlConnection conn = Common.GetConn();string sql = "UPDATE Document_table SET Isdelete=0 WHEREDocumentType=@DocumentType and username=@username";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@username", username);comm.Parameters.AddWithValue("@DocumentType", 1);comm.Parameters.AddWithValue("@Documentbiaoti", bname);comm.ExecuteNonQuery();conn.Close();}public DataTable selectcaogao(string username){SqlConnection conn = Common.GetConn();string sql = "SELECT * FROM Document_table where DocumentType=1 and Isdelete=1 and username=@username";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@username", username);comm.ExecuteNonQuery();SqlDataAdapter sda = new SqlDataAdapter(comm);DataSet ds = new DataSet();sda.Fill(ds);return ds.Tables[0];conn.Close();}public DataTable selectfa(string username){SqlConnection conn = Common.GetConn();string sql = "SELECT * FROM Document_table where DocumentType=0 and Isdelete=1 and username=@username";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@username", username);comm.ExecuteNonQuery();SqlDataAdapter sda = new SqlDataAdapter(comm);DataSet ds = new DataSet();sda.Fill(ds);return ds.Tables[0];conn.Close();}public DataTable selectfaID(int ID){SqlConnection conn = Common.GetConn();string sql = "SELECT * FROM Document_table where DocumentType=0 and Isdelete=1 and DocumentID=@DocumentID";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@DocumentID", ID);comm.ExecuteNonQuery();SqlDataAdapter sda = new SqlDataAdapter(comm);DataSet ds = new DataSet();sda.Fill(ds);return ds.Tables[0];conn.Close();}public DataTable selectFSbiaoti(string biaoti){SqlConnection conn = Common.GetConn();string sql = "SELECT top 1a.bumenName,ername,a.Documentbiaoti,a.DocumentMeSH,a.DocumentContent,a.Document Priorities,a.DocumentAnnex,b.AuditViews,b.DocumentAudit,b.DocumentReviewed FROM Document_table a,DocumentSH_table b where a.DocumentType=0 and a.Isdelete=1 anda.Documentbiaoti=@Documentbiaoti and a.Documentbiaoti=b.Documentbiaoti andb.Iszhuanfa=1";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@Documentbiaoti", biaoti);comm.ExecuteNonQuery();SqlDataAdapter sda = new SqlDataAdapter(comm);DataSet ds = new DataSet();sda.Fill(ds);return ds.Tables[0];conn.Close();}public DataTable selectgwcaogao(int ID){SqlConnection conn = Common.GetConn();string sql = "SELECT * FROM Document_table where Isdelete=1 andDocumentID=@DocumentID";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@DocumentID", ID);comm.ExecuteNonQuery();SqlDataAdapter sda = new SqlDataAdapter(comm);DataSet ds = new DataSet();sda.Fill(ds);return ds.Tables[0];conn.Close();}public DataTable selectShen(string username){SqlConnection conn = Common.GetConn();string sql = "SELECT * FROM Document_table where DocumentType=0 and Isdelete=1 and DocumentReviewed=@DocumentReviewed and isshenhe=1";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@DocumentReviewed", username);comm.ExecuteNonQuery();SqlDataAdapter sda = new SqlDataAdapter(comm);DataSet ds = new DataSet();sda.Fill(ds);return ds.Tables[0];conn.Close();}public DataTable selectSHFujian(string biaoti){SqlConnection conn = Common.GetConn();string sql = "SELECT DocumentAnnex FROM Document_table where DocumentType=0 and Isdelete=1 and Documentbiaoti=@Documentbiaoti";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@Documentbiaoti", biaoti);comm.ExecuteNonQuery();SqlDataAdapter sda = new SqlDataAdapter(comm);DataSet ds = new DataSet();sda.Fill(ds);return ds.Tables[0];conn.Close();}public DataTable selectSHID(int ID){SqlConnection conn = Common.GetConn();string sql = "SELECT * FROM Document_table where DocumentType=0 and Isdelete=1 and DocumentID=@DocumentID and isshenhe=1";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@DocumentID", ID);comm.ExecuteNonQuery();SqlDataAdapter sda = new SqlDataAdapter(comm);DataSet ds = new DataSet();sda.Fill(ds);return ds.Tables[0];conn.Close();}public void UpdateDocument(CDocument cd, int ID){SqlConnection conn = Common.GetConn();string sql = "UPDATE Document_table SET bumenName = @bumenName,username = @username,Documentbiaoti = @Documentbiaoti,DocumentMeSH =@DocumentMeSH,DocumentPriorities = @DocumentPriorities,DocumentContent =@DocumentContent,DocumentAnnex = @DocumentAnnex,DocumentAudit =@DocumentAudit,DocumentReviewed = @DocumentReviewed,DocumentTime =@DocumentTime WHERE Isdelete=1 and DocumentID=@DocumentID";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@bumenName", cd.BumenName);comm.Parameters.AddWithValue("@username", erName);comm.Parameters.AddWithValue("@Documentbiaoti", cd.DocumentBiaoti);comm.Parameters.AddWithValue("@DocumentMeSH", cd.DocumentmeSH);comm.Parameters.AddWithValue("@DocumentPriorities", cd.Documentpriorities);comm.Parameters.AddWithValue("@DocumentContent", cd.Documentcontent);comm.Parameters.AddWithValue("@DocumentAnnex", cd.Documentannex);comm.Parameters.AddWithValue("@DocumentAudit", cd.Documentaudit);comm.Parameters.AddWithValue("@DocumentReviewed", cd.Documentreviewed);comm.Parameters.AddWithValue("@DocumentTime", cd.Documenttime);comm.Parameters.AddWithValue("@DocumentID", ID);comm.ExecuteNonQuery();conn.Close();}public void updateSH(string biaoti){SqlConnection conn = Common.GetConn();string sql = "UPDATE Document_table SET isshenhe=0 WHEREDocumentbiaoti=@Documentbiaoti and isdelete=1";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@Documentbiaoti", biaoti);comm.ExecuteNonQuery();conn.Close();}public void updateSHB(string biaoti){SqlConnection conn = Common.GetConn();string sql = "UPDATE Document_table SET isshenhe=2 WHEREDocumentbiaoti=@Documentbiaoti and isdelete=1";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@Documentbiaoti", biaoti);comm.ExecuteNonQuery();conn.Close();}public void updatetype(string biaoti){SqlConnection conn = Common.GetConn();string sql = "UPDATE Document_table SET DocumentType=0 WHERE Documentbiaoti=@Documentbiaoti and isdelete=1";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@Documentbiaoti", biaoti);comm.ExecuteNonQuery();conn.Close();}}}namespace Component{using System;using System.Data;using System.Data.SqlClient;public class CDocumentSHmanager{public void addDocumentSH(CDocumentSH cd){SqlConnection conn = Common.GetConn();string sql = "INSERT INTODocumentSH_table(username,Documentbiaoti,DocumentAudit,DocumentReviewed,AuditViews , DocumentTime)V ALUES(@username,@Documentbiaoti,@DocumentAudit,@DocumentReviewed,@AuditViews ,@DocumentTime)";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@username", erName);comm.Parameters.AddWithValue("@Documentbiaoti", cd.DocumentBiaoti);comm.Parameters.AddWithValue("@DocumentAudit", cd.Documentaudit);comm.Parameters.AddWithValue("@DocumentReviewed", cd.Documentreviewed);comm.Parameters.AddWithValue("@AuditViews", cd.Auditviews);comm.Parameters.AddWithValue("@DocumentTime", cd.Documenttime);comm.ExecuteNonQuery();conn.Close();}public DataTable selectFA(string username){SqlConnection conn = Common.GetConn();string sql = "SELECT * FROM DocumentSH_table whereDocumentReviewed=@DocumentReviewed and istongguo=1 and Iszhuanfa=1";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@DocumentReviewed", username);comm.ExecuteNonQuery();SqlDataAdapter sda = new SqlDataAdapter(comm);DataSet ds = new DataSet();sda.Fill(ds);return ds.Tables[0];conn.Close();}public DataTable selectliulan(int ID){SqlConnection conn = Common.GetConn();string sql = "SELECT * FROM DocumentSH_table whereDocumentSHID=@DocumentSHID and Iszhuanfa=1 and Isfa=0 and Isdelete=1";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@DocumentSHID", ID);comm.ExecuteNonQuery();SqlDataAdapter sda = new SqlDataAdapter(comm);DataSet ds = new DataSet();sda.Fill(ds);return ds.Tables[0];conn.Close();}public void updateFAS(string biaoti){SqlConnection conn = Common.GetConn();string sql = "UPDATE DocumentSH_table SET Isfa=0 WHEREDocumentbiaoti=@Documentbiaoti and Isdelete=1";SqlCommand comm = new SqlCommand(sql, conn);comm.Parameters.AddWithValue("@Documentbiaoti", biaoti);comm.ExecuteNonQuery();conn.Close();}。