protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //项目类别 ProjectType.DataSource = WebBLL.Tbl_ClassManager.GetTbl_ClassByParentID(56); ProjectType.DataTextField = "ClassName"; ProjectType.DataValueField = "ClassName"; ProjectType.DataBind(); ProjectType.Items.Insert(0, new ListItem("选择项目类别", "")); ProjectID.Items.Insert(0, new ListItem("选择项目", "")); //专业 ClassName1.DataSource = WebBLL.Tbl_ClassManager.GetTbl_ClassByParentID(15); ClassName1.DataTextField = "ClassName"; ClassName1.DataValueField = "ID"; ClassName1.DataBind(); ClassName1.Items.Insert(0, new ListItem("选择专业", "")); lishitizi.Visible = false; //卷册 ClassName2.Items.Insert(0, new ListItem("选择卷", "")); //卷册 //ClassName3.DataSource = WebBLL.Tbl_ClassManager.GetTbl_ClassByParentID(60); //ClassName3.DataTextField = "ClassName"; //ClassName3.DataValueField = "ClassName"; //ClassName3.DataBind(); //ClassName3.Items.Insert(0, new ListItem("选择册", "")); } }
protected void ProjectID_SelectedIndexChanged(object sender, EventArgs e) { ClassName1.DataSource = WebBLL.Tbl_ClassManager.GetDataTableByPage(20, 1, "parentid=15 and classname in(select classname from tbl_projectdesigner where projectid=" + ProjectID.SelectedValue + ")", ""); ClassName1.DataTextField = "ClassName"; ClassName1.DataValueField = "ID"; ClassName1.DataBind(); ClassName1.Items.Insert(0, new ListItem("选择专业", "")); }
//如果选择了公共档案 protected void PA_Type1_SelectedIndexChanged(object sender, EventArgs e) { ClassName1.DataSource = WebBLL.Tbl_ClassManager.GetTbl_ClassByParentID(227); ClassName1.DataTextField = "ClassName"; ClassName1.DataValueField = "ID"; ClassName1.DataBind(); ClassName1.Items.Insert(0, new ListItem("一级分类", "")); ClassName2.Items[0].Text = "二级分类"; ClassName3.Items[0].Text = "三级分类"; }
protected void ClassName_SelectedIndexChanged(object sender, EventArgs e) { //选择卷 ClassName1.DataSource = WebBLL.Tbl_ClassManager.GetTbl_ClassByParentID(Convert.ToInt32(this.ClassName.SelectedValue)); ClassName1.DataTextField = "ClassName"; ClassName1.DataValueField = "ID"; ClassName1.DataBind(); ClassName1.Items.Insert(0, new ListItem("选择卷", "")); if (ProjectName.SelectedValue != "") { BindList(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //绑定专业 ClassName1.DataSource = WebBLL.Tbl_ClassManager.GetTbl_ClassByParentID(15); ClassName1.DataTextField = "ClassName"; ClassName1.DataValueField = "ClassName"; ClassName1.DataBind(); ClassName1.Items.Insert(0, new ListItem("全部专业", "")); //绑定列表 Bind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Title = Request.QueryString["limit"]; if (Title == "借阅申请") { this.RequestType.SelectedValue = "借阅申请"; } else { this.RequestType.SelectedValue = "出版申请"; } //项目类别 ProjectType.DataSource = WebBLL.Tbl_ClassManager.GetTbl_ClassByParentID(56); ProjectType.DataTextField = "ClassName"; ProjectType.DataValueField = "ClassName"; ProjectType.DataBind(); ProjectType.Items.Insert(0, new ListItem("选择项目类别", "")); ProjectID.Items.Insert(0, new ListItem("选择项目", "")); //专业 ClassName1.DataSource = WebBLL.Tbl_ClassManager.GetTbl_ClassByParentID(15); ClassName1.DataTextField = "ClassName"; ClassName1.DataValueField = "ID"; ClassName1.DataBind(); ClassName1.Items.Insert(0, new ListItem("选择专业", "")); //卷册 ClassName2.Items.Insert(0, new ListItem("选择卷", "")); ClassName3.Items.Insert(0, new ListItem("选择册", "")); PA_Name.Items.Insert(0, new ListItem("选择档案", "")); //如果通过借阅查询列表点过来的借阅 //int ID = Convert.ToInt32(Request.QueryString["aid"]); //if (ID > 0) //{ // WebModels.Tbl_ProjectArchiveRequest project = WebBLL.Tbl_ProjectArchiveRequestManager.GetTbl_ProjectArchiveRequestById(ID); // this.ProjectID.SelectedValue = project.ProjectID.ToString(); // this.PA_Name.SelectedValue = project.ProjectArchiveID.ToString(); // this.Remark.InnerText = project.Remark; // this.RequestType.SelectedValue = project.RequestType; // this.Status.SelectedValue = project.Status; // PA_Type2.SelectedValue = project.PA_Type2; //} } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //专业 ClassName1.DataSource = WebBLL.Tbl_ClassManager.GetTbl_ClassByParentID(15); ClassName1.DataTextField = "ClassName"; ClassName1.DataValueField = "ID"; ClassName1.DataBind(); //ClassName1.Items.Insert(0, new ListItem("选择专业", "")); //ClassName2.Items.Insert(0, new ListItem("选择卷册", "")); //删除 if (Request.QueryString["limit"] == "del") { int ids = Convert.ToInt32(Request.QueryString["id"].ToString()); int count = WebCommon.Public.DataTableDel("Tbl_DesignVolume", "id in(" + ids + ")"); if (count > 0) { ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('删除成功!');", true); } else { WebCommon.Script.AlertAndGoBack("删除失败!"); } } if (WebCommon.Public.ToString(Request.QueryString["ClassName1"]) != "") { ClassName1.Items.Insert(0, new ListItem(Request.QueryString["ClassName1"], Request.QueryString["ClassName1"])); ClassName2.Items.Insert(0, new ListItem(Request.QueryString["ClassName2"], Request.QueryString["ClassName2"])); BindList(); } else { ClassName1.Items.Insert(0, new ListItem("选择专业", "")); ClassName2.Items.Insert(0, new ListItem("选择卷册", "")); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //删除 if (Request.QueryString["limit"] == "del") { int ids = Convert.ToInt32(Request.QueryString["id"].ToString()); int count = WebCommon.Public.DataTableDel("Tbl_DesignTask", "id in(" + ids + ")"); if (count > 0) { //ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('删除成功!');window.external.close()", true); WebCommon.Script.AlertAndGoBack("删除成功!"); } else { WebCommon.Script.AlertAndGoBack("删除失败!"); } } //项目ID ProjectID.DataSource = WebBLL.Tbl_ClassManager.GetTbl_ClassByParentID(56); ProjectID.DataTextField = "ClassName"; ProjectID.DataValueField = "ClassName"; ProjectID.DataBind(); ProjectID.Items.Insert(0, new ListItem("选择项目类别", "")); ProjectName.Items.Insert(0, new ListItem("选择项目", "")); //专业 ClassName1.DataSource = WebBLL.Tbl_ClassManager.GetTbl_ClassByParentID(15); ClassName1.DataTextField = "ClassName"; ClassName1.DataValueField = "ID"; ClassName1.DataBind(); ClassName1.Items.Insert(0, new ListItem("选择专业", "")); //遍历绑定人员列表 WebBLL.Tbl_UserManager.GetUsersByDropDownList(DesignManager); DesignManager.Items.Insert(0, new ListItem("选择设总", "")); //遍历绑定人员列表 WebBLL.Tbl_UserManager.GetUsersByDropDownList(DesignMain); DesignMain.Items.Insert(0, new ListItem("选择主设", "")); DT_SheJiRen.DataSource = WebBLL.Tbl_UserManager.GetDataTableByPage(100, 1, "status='在职' and u_designlimit like '%设计人%'", "username asc"); DT_SheJiRen.DataTextField = "UserName"; DT_SheJiRen.DataValueField = "UserName"; DT_SheJiRen.DataBind(); DT_SheJiRen.Items.Insert(0, new ListItem("选设计人", "")); DT_JiaoDuiRen.DataSource = WebBLL.Tbl_UserManager.GetDataTableByPage(100, 1, "status='在职' and u_designlimit like '%校对人%'", "username asc"); DT_JiaoDuiRen.DataTextField = "UserName"; DT_JiaoDuiRen.DataValueField = "UserName"; DT_JiaoDuiRen.DataBind(); DT_JiaoDuiRen.Items.Insert(0, new ListItem("选校对人", "")); DT_ShenHeRen.DataSource = WebBLL.Tbl_UserManager.GetDataTableByPage(50, 1, "status='在职' and u_designlimit like '%审核人%'", "username asc"); DT_ShenHeRen.DataTextField = "UserName"; DT_ShenHeRen.DataValueField = "UserName"; DT_ShenHeRen.DataBind(); DT_ShenHeRen.Items.Insert(0, new ListItem("选审核人", "")); DT_ShenDingRen.DataSource = WebBLL.Tbl_UserManager.GetDataTableByPage(50, 1, "status='在职' and u_designlimit like '%审定人%'", "username asc"); DT_ShenDingRen.DataTextField = "UserName"; DT_ShenDingRen.DataValueField = "UserName"; DT_ShenDingRen.DataBind(); DT_ShenDingRen.Items.Insert(0, new ListItem("选审定人", "")); //卷册 ClassName1.Items.Insert(0, new ListItem("选择专业", "")); ClassName2.Items.Insert(0, new ListItem("选择卷", "")); ClassName3.Items.Insert(0, new ListItem("选择册", "")); //如果是通过任务明细连接过来 int projectid = WebCommon.Public.ToInt(Request.QueryString["ProjectID"]); if (projectid > 0) { ProjectName.SelectedValue = projectid.ToString(); WebModels.Tbl_Project project = WebBLL.Tbl_ProjectManager.GetTbl_ProjectById(Convert.ToInt32(Request.QueryString["ProjectID"])); ProjectName.Items.Insert(0, new ListItem(project.ProjectName, Request.QueryString["ProjectID"])); ProjectID.SelectedValue = project.ProjectTypes; ProjectNo.Value = project.ProjectNo; ProjectName.Enabled = false; ProjectID.Enabled = false; ProjectNo.Attributes.Add("readonly", "readonly"); //设总默认 DesignManager.Items.Insert(0, new ListItem(project.ProjectMainDesigner, project.ProjectMainDesigner)); DesignManager.Enabled = false; //主设默认 DesignMain.Items.Insert(0, new ListItem(WebCommon.Public.GetUserName(), WebCommon.Public.GetUserName())); DesignMain.Enabled = false; //专业默认 //string classname = WebBLL.Tbl_UserManager.GetTbl_UserByUserName(WebCommon.Public.GetUserName()).U_Specialty; //if (WebCommon.Public.ToString(Request.QueryString["ClassName"]) != "") classname = Request.QueryString["ClassName"]; //ClassName1.DataSource = null; ClassName1.DataSource = WebBLL.Tbl_ProjectDesignerManager.GetDataTableByPage(10, 1, "UserName='******' and projectid=" + project.ID.ToString(), ""); ClassName1.DataTextField = "ClassName"; ClassName1.DataValueField = "ClassName"; ClassName1.DataBind(); ClassName1.Items.Insert(0, new ListItem("选择专业", "")); //卷默认 //ClassName2.DataSource = WebBLL.Tbl_ClassManager.GetDataTableByPage(50, 1, "parentid=(select top 1 id from tbl_class where parentid=15 and classname='" + classname + "')", "id asc"); //ClassName2.DataTextField = "ClassName"; //ClassName2.DataValueField = "ID"; //ClassName2.DataBind(); //ClassName2.Items.Insert(0, new ListItem("选择卷", "")); //绑定当前任务 BindList(); } } }