/// <summary> /// 根据单位编号获得单位实体类对象 /// </summary> /// <param name="RD_ID"></param> /// <returns></returns> public static RoadDepart Get_RoadDepartEntity(int RD_ID) { RoadDepart depart = null; string sqlStr = "select * from R_RoadDepart where RD_ID=" + RD_ID; DataTable dt = DBHelper.GetDataSet(sqlStr); if (dt != null && dt.Rows.Count > 0) { depart = new RoadDepart(); depart.RD_ID = RD_ID; depart.RD_Name = dt.Rows[0]["RD_Name"].ToString(); depart.RD_Manager = dt.Rows[0]["RD_Manager"].ToString(); depart.RD_Phone = dt.Rows[0]["RD_Phone"].ToString(); depart.RD_Fax = dt.Rows[0]["RD_Fax"].ToString(); depart.RD_Email = dt.Rows[0]["RD_Email"].ToString(); depart.RD_PostCode = dt.Rows[0]["RD_QQ"].ToString(); depart.RD_QQ = dt.Rows[0]["RD_QQ"].ToString(); int CI_ID = Convert.ToInt32(dt.Rows[0]["RD_City"]); depart.RD_City = CityInfoService.Get_CityInfoEntity(CI_ID); depart.RD_Address = dt.Rows[0]["RD_Address"].ToString(); depart.RD_Honour = dt.Rows[0]["RD_Honour"].ToString(); depart.RD_Slogon = dt.Rows[0]["RD_Slogon"].ToString(); depart.RD_Remark = dt.Rows[0]["RD_Remark"].ToString(); depart.RD_MainPhoto = dt.Rows[0]["RD_MainPhoto"].ToString(); depart.RD_ViewPhoto = dt.Rows[0]["RD_ViewPhoto"].ToString(); depart.RD_Logo = dt.Rows[0]["RD_Logo"].ToString(); depart.RD_Report = dt.Rows[0]["RD_Report"].ToString(); } return(depart); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { CommonFunction.isLoginCheck("timeout.aspx"); bindcitydata(); if (Request.QueryString["rdid"] == null) { ViewState["rdid"] = ((UserInfo)Session["RoadUser"]).U_RoadDepart.RD_ID; } else { ViewState["rdid"] = Request.QueryString["rdid"].ToString(); } RoadDepart depart = RoadDepartService.Get_RoadDepartEntity(Convert.ToInt32(ViewState["rdid"])); txtName.Text = depart.RD_Name; txtFax.Text = depart.RD_Fax; txtRen.Text = depart.RD_Manager; txtPhone.Text = depart.RD_Phone; txtEmail.Text = depart.RD_Email; txtPostCode.Text = depart.RD_PostCode; txtReport.Text = depart.RD_Report; txtHonour.Text = depart.RD_Honour; txtAddress.Text = depart.RD_Address; txtSlogon.Text = depart.RD_Slogon; txtQQ.Text = depart.RD_QQ; txtRemark.Text = depart.RD_Remark; ddlCity.SelectedValue = depart.RD_City.CI_ID.ToString(); Image1.ImageUrl = "../RoadPhoto/" + depart.RD_MainPhoto; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["roadid"] != null) { int RoadId = Convert.ToInt32(Request.QueryString["roadid"]); RoadDepart depart = RoadDepartService.Get_RoadDepartEntity(RoadId); if (depart != null) { Session["roadinfo"] = depart; Session.Timeout = 600; Response.Redirect("index.aspx"); } else { Response.Redirect("RoadDepartList.aspx"); } } else { Response.Redirect("RoadDepartList.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int RD_ID = Convert.ToInt32(Request.QueryString["rdid"]); RoadDepart depart = RoadDepartService.Get_RoadDepartEntity(RD_ID); Image1.ImageUrl = "../Logo/" + depart.RD_Logo; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataTable dtNews = NewsInfoService.Get_NewsView(Convert.ToInt32(Request.QueryString["nid"])); ViewState["dtNews"] = dtNews; RoadDepart depart = (RoadDepart)Session["roadinfo"]; this.Title = dtNews.Rows[0]["N_Title"].ToString() + "-" + dtNews.Rows[0]["T_Name"].ToString() + "-" + depart.RD_Name + "门户网站"; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataTable dtType = DBHelper.GetDataSet("select T_ID,T_Name from R_NewsType where T_ID='" + Request.QueryString["tid"].ToString() + "'"); ViewState["tid"] = Request.QueryString["tid"].ToString(); RoadDepart depart = (RoadDepart)Session["roadinfo"]; this.Title = dtType.Rows[0]["T_Name"].ToString() + "-" + depart.RD_Name + "门户网站"; lblNewsType.Text = dtType.Rows[0]["T_Name"].ToString(); binddata(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { RoadDepart depart = (RoadDepart)Session["roadinfo"];//获取一个路政单位的实体信息 this.Title = "网站首页门户网站"; DataTable dtLZFG = NewsInfoService.Get_NewsViewList(depart.RD_ID, 2, 7); //2代表类型是路政法规 rptLZFG.DataSource = dtLZFG; //路政法规 rptLZFG.DataBind(); DataTable dtGZDT = NewsInfoService.Get_NewsViewList(depart.RD_ID, 1, 7); //1代表是工作动态 rptGZDT.DataSource = dtGZDT; //工作动态 rptGZDT.DataBind(); DataTable dtDWRY = NewsInfoService.Get_NewsViewList(depart.RD_ID, 3, 0); //3代表是单位荣誉 rptRongYu.DataSource = dtDWRY; //单位荣誉 rptRongYu.DataBind(); DataTable dtGGGS = NewsInfoService.Get_NewsViewList(depart.RD_ID, 4, 7); rptGGGS.DataSource = dtGGGS; rptGGGS.DataBind(); } }