传感器识别检测系统V1.0usingSystem;usingSystem.Collections;usingSystem.Configuration;usingSystem.Data;usingSystem.Data.SqlClient;usingSystem.Linq;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.HtmlControls;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Xml.Linq;usingComponent;usingSystem.Threading;{Commonocom=newCommono();#region窗体加载protectedvoidPage_Load(objectsender,EventArgse){if(!Page.IsPostBack){if(Session["id"]==null||Session["id"].ToString()==""){//Response.Redirect("../../Login.aspx");Response.Write("window.parent.location.href='"+Component.ServerInfo.GetRootURI()+"/Login.aspx';");return;}if(!com.Purview(Session["actor_id"],"2","39")){Response.Redirect("~/authority.aspx");}if(!com.Purview(Session["actor_id"],"2","183")){Button1.Enabled=false;}if(!com.Purview(Session["actor_id"],"2","184")){Button2.Enabled=false;}BindNews();BindBumen();ddlbumen.Items.Insert(0,newListItem("-请选择-","0"));ddlbumen.Items[0].Selected=true;BindType();ddltype.Items.Insert(0,newListItem("-请选择-","0"));ddltype.Items[0].Selected=true;Button2.Attributes["onClick"]="returnconfirm('您确认删除吗!');";stringsql="select*from(selectid,title,fabiaoshijian,stopshijian,shenpitongguo,center,(selecttrueusernamefromtb_userwhereid=userid)asusername,(selectmingchengfromtb_departmentwhereid=fabubumenid)as-1-传感器识别检测系统V1.0bumen,(select[typename]fromtb_typewhereid=type_id)as[type]fromtb_newswherebiglie='1'andisdelete='0')Awhere1=1orderby1desc";AspNetPager1.AlwaysShow=true;AspNetPager1.RecordCount=getcount();setdate(0,AspNetPager1.PageSize,sql);AspNetPager2.AlwaysShow=true;AspNetPager2.RecordCount=getcount();setdate(0,AspNetPager2.PageSize,sql);}}#endregion#region绑定方法#region绑定数值voidBindNews(){stringsql="select*from(selectid,title,fabiaoshijian,stopshijian,shenpitongguo,center,(selectusernamefromtb_userwhereid=userid)asusername,(selectmingchengfromtb_departmentwhereid=fabubumenid)asbumen,(select[typename]fromtb_typewhereid=type_id)as[type]fromtb_newswherebiglie='1'andisdelete='0')Awhere1=1orderby1desc";GridView1.DataSource=com.Getdatable(sql);GridView1.DataKeyNames=newstring[]{"id"};GridView1.DataBind();}#endregion#region绑定用户voidBindBumen(){stringsql="selectid,mingchengfromtb_departmentwhereisdelete=0orderby1asc";ddlbumen.DataSource=com.Getdatable(sql);ddlbumen.DataTextField="mingcheng";//ddlbumen.DataValueField="id";ddlbumen.DataBind();}#endregion#region绑定类型voidBindType(){stringsql="select*fromtb_typewhereisdelete=0andbiglie='1'orderby1asc";ddltype.DataSource=com.Getdatable(sql);ddltype.DataTextField="typename";//ddltype.DataValueField="id";ddltype.DataBind();}#endregion#endregionbooltxtshijian(stringtext){try{DateTimedt=Convert.ToDateTime(text);returntrue;}-2-传感器识别检测系统V1.0catch{returnfalse;}}#region单击绑定行protectedvoidGridView1_RowDataBound(objectsender,GridViewRowEventArgse){if(e.Row.RowIndex!=-1){intid=e.Row.RowIndex+1;e.Row.Cells[1].Text=id.ToString();}if(e.Row.RowType==DataControlRowType.DataRow){e.Row.Attributes.Add("onMouseOver","Color=this.style.backgroundColor;this.style.backgroundColor='lightBlue'");e.Row.Attributes.Add("onMouseOut","this.style.backgroundColor=Color;");e.Row.Attributes["style"]="Cursor:hand";//e.Row.Attributes...
