protected void Page_Load(object sender, EventArgs e) { this.Title = "资源所属区域维护"; Module_Id = "10400200"; strResource_Class = Rc.Common.Config.Resource_ClassConst.云资源; if (!IsPostBack) { DataTable dt = new DataTable(); //省 dt = new Rc.BLL.Resources.BLL_Regional_Dict().GetList("D_PartentID='' ORDER BY CONVERT(INT,D_Code)").Tables[0]; pfunction.SetDdl(ddlProvince, dt, "D_Name", "Regional_Dict_Id", "省份"); string strWhere = string.Empty; //教材版本 strWhere = " D_Type='3' order by d_order"; dt = new Rc.BLL.Resources.BLL_Common_Dict().GetList(strWhere).Tables[0]; Rc.Cloud.Web.Common.pfunction.SetDdl(ddlResource_Version, dt, "D_Name", "Common_Dict_ID", "请选择"); //文档类型 strWhere = string.Format(" D_Type='1' AND Common_Dict_ID!='{0}' order by d_order", Rc.Common.Config.Resource_TypeConst.属性生成的目录); dt = new Rc.BLL.Resources.BLL_Common_Dict().GetList(strWhere).Tables[0]; Rc.Cloud.Web.Common.pfunction.SetDdl(ddlResource_Type, dt, "D_Name", "Common_Dict_ID", "请选择"); //年级学期 strWhere = " D_Type='6' order by d_order"; dt = new Rc.BLL.Resources.BLL_Common_Dict().GetList(strWhere).Tables[0]; Rc.Cloud.Web.Common.pfunction.SetDdl(ddlGradeTerm, dt, "D_Name", "Common_Dict_ID", "请选择"); //学科 strWhere = " D_Type='7' order by d_order"; dt = new Rc.BLL.Resources.BLL_Common_Dict().GetList(strWhere).Tables[0]; Rc.Cloud.Web.Common.pfunction.SetDdl(ddlSubject, dt, "D_Name", "Common_Dict_ID", "请选择"); //年份 pfunction.SetDdlYear(ddlParticularYear, DateTime.Now.Year - 5, DateTime.Now.Year + 2, true); } StaticUserFun = new Rc.Cloud.BLL.BLL_clsAuth().GetUserFunc(loginUser.SysUser_ID, clsUtility.ReDoStr(loginUser.SysRole_IDs, ','), Module_Id); }
private void isit_load() { DataTable dt = new DataTable(); //省 dt = new Rc.BLL.Resources.BLL_Regional_Dict().GetList("D_PartentID='' ORDER BY CONVERT(INT,D_Code)").Tables[0]; pfunction.SetDdl(ddlProvince, dt, "D_Name", "Regional_Dict_Id", "省份"); string strWhere = string.Empty; StringBuilder html = new StringBuilder(); //年份 int intYear = DateTime.Now.Year; html.Append("<li><a href='##' class='active' ajax-value=''>全部</a></li>"); for (int i = intYear - 5; i <= intYear + 1; i++) { html.AppendFormat(" <li><a href='##' ajax-value='{0}'>{0}</a></li>", i); } ddlYear.Text = html.ToString(); html.Clear(); //教材版本 strWhere = " D_Type='3' order by d_order"; dt = new Rc.BLL.Resources.BLL_Common_Dict().GetList(strWhere).Tables[0]; html.Append("<li><a href='##' class='active' ajax-value=''>全部</a></li>"); foreach (DataRow row in dt.Rows) { html.Append(" <li><a href='##' ajax-value='" + row["Common_Dict_ID"] + "'>" + row["D_Name"] + "</a></li>"); } ddlVersion.Text = html.ToString(); html.Clear(); //年级学期 strWhere = " D_Type='6' order by d_order"; dt = new Rc.BLL.Resources.BLL_Common_Dict().GetList(strWhere).Tables[0]; html.Append("<li><a href='##' class='active' ajax-value=''>全部</a></li>"); foreach (DataRow row in dt.Rows) { html.Append(" <li><a href='##' ajax-value='" + row["Common_Dict_ID"] + "'>" + row["D_Name"] + "</a></li>"); } ddlGradeTerm.Text = html.ToString(); html.Clear(); //学科 strWhere = " D_Type='7' order by d_order"; dt = new Rc.BLL.Resources.BLL_Common_Dict().GetList(strWhere).Tables[0]; html.Append("<li><a href='##' class='active' ajax-value=''>全部</a></li>"); foreach (DataRow row in dt.Rows) { html.Append(" <li><a href='##' ajax-value='" + row["Common_Dict_ID"] + "'>" + row["D_Name"] + "</a></li>"); } ddlSubject.Text = html.ToString(); html.Clear(); }