/// <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();
}
}
