public string GetNodeData() { List <Model.CCOM.Agency> list = new BLL.CCOM.Agency().GetModelList(" "); LitJson.JsonData data = new LitJson.JsonData(); data.SetJsonType(LitJson.JsonType.Array); int i = 0; foreach (Model.CCOM.Agency org in list) { //if (i++ == 0) // continue; LitJson.JsonData line = new LitJson.JsonData(); line["id"] = org.Agency_id.ToString(); line["pId"] = org.Agency_father.ToString(); line["name"] = org.Agency_name; if (!org.Agency_status) { line["name"] += "(已禁用)"; } line["isParent"] = true; if (org.Agency_type < 2) { line["open"] = true; } data.Add(line); } return(data.ToJson()); }
protected void ddlDepartment_SelectedIndexChanged(object sender, EventArgs e) { this.subjectTable.Rows.Clear(); string departmentId = this.ddlDepartment.SelectedItem.Value; if (departmentId.Equals("#")) { this.ddlMajor.Items.Clear(); ListItem item1 = new ListItem("--请选择专业--", "#"); this.ddlMajor.Items.Insert(0, item1); return; } string sql = " Agency_father = " + departmentId; BLL.CCOM.Agency bll = new BLL.CCOM.Agency(); DataSet ds = bll.GetList(sql); this.ddlMajor.Items.Clear(); this.ddlMajor.DataSource = ds.Tables[0].DefaultView; this.ddlMajor.DataTextField = "Agency_name"; this.ddlMajor.DataValueField = "Agency_id"; this.ddlMajor.DataBind(); ListItem item = new ListItem("--请选择专业--", "#"); this.ddlMajor.Items.Insert(0, item); }
//tab1=================== #region 数据绑定================================= private void RptBind(string _strWhere, string _order) { int pageSize = GetPageSize(15); //每页数量 int page = MyRequest.GetQueryInt("page", 1); //string keywords = MyRequest.GetQueryString("keywords"); string keywords = this.keywordTab0; int start_index = pageSize * (page - 1) + 1; int end_index = pageSize * page; this.txtKeywords.Text = keywords; var bll = new BLL.CCOM.Agency(); //计算数量 int totalCount = bll.GetRecordCount(_strWhere); //绑定当页 this.rptList.DataSource = bll.GetListByPage(_strWhere, _order, start_index, end_index); this.rptList.DataBind(); //绑定页码 txtPageNum.Text = pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("MajorList.aspx", "fun_id={0}&keywords={1}&page={2}", DESEncrypt.Encrypt(this.fun_id), keywords, "__id__"); this.PageContent.InnerHtml = Utils.OutPageList(pageSize, page, totalCount, pageUrl, 8, true); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ListItem list1 = new ListItem("行政机构", "0"); ListItem list2 = new ListItem("部", "1"); ListItem list3 = new ListItem("系", "2"); ListItem list4 = new ListItem("专业", "3"); //this.DropDownList1.Items.Add(list1); //this.DropDownList1.Items.Add(list2); //this.DropDownList1.Items.Add(list3); //this.DropDownList1.Items.Add(list4); Model.CCOM.Agency model = new BLL.CCOM.Agency().GetModel(1); //this.hiduo_id.Value = model.Agency_id.ToString(); //this.ddlAddParentID.DataSource = GetOrgList_DataSet(false); //this.ddlAddParentID.DataTextField = "Agency_name"; //this.ddlAddParentID.DataValueField = "Agency_id"; //this.ddlAddParentID.DataBind(); try { UD_PID = Utils.StrToInt(DESEncrypt.Decrypt(MyRequest.GetString("selectid")), 0); } catch { } //this.ddlAddParentID.SelectedValue = selectOrgan.ToString(); //} } }
protected void bindall() { BLL.CCOM.Agency bll = new BLL.CCOM.Agency(); this.ddlSelectUD.DataSource = GetOrgList_DataSet(false); this.ddlSelectUD.DataTextField = "Agency_name"; this.ddlSelectUD.DataValueField = "Agency_id"; this.ddlSelectUD.DataBind(); //List<Model.admin.Universities_Organization> list = GetAdminUserOrg_List(false); if (MyRequest.GetString("selectid") != "") { this.ddlSelectUD.SelectedValue = MyRequest.GetString("selectid"); } else if (MyRequest.GetString("keywords") != "") { if (Tools.CheckParams(MyRequest.GetString("keywords")) == false) { List <Model.CCOM.Agency> uds = bll.GetModelList(" UO_Name like '%" + MyRequest.GetString("keywords").ToString() + "%' "); if (uds.Count > 0) { this.ddlSelectUD.SelectedValue = uds[0].Agency_id.ToString(); } } } }
private void RalBind() { try { string strWhere = " Agency_type = " + DataDic.CCOM_Major_type; if (agency_id != DataDic.CCOM_Agency_id) { strWhere += (" AND Agency_father = " + agency_id); } BLL.CCOM.Agency Bll = new BLL.CCOM.Agency(); DataSet ds = Bll.GetList(strWhere); this.ddlMajor.DataSource = ds.Tables[0].DefaultView; this.ddlMajor.DataTextField = "Agency_name"; this.ddlMajor.DataValueField = "Agency_id"; this.ddlMajor.DataBind(); this.ddlMajor.SelectedValue = major_id; this.major_id = this.ddlMajor.SelectedValue; ddlMajor_SelectedIndexChanged(null, null); } catch { JscriptMsg("数据出错", "", "Error"); } }
//删除 protected void btnDelete_Click(object sender, EventArgs e) { int selectID = Utils.StrToInt(this.ddlSelectUD.SelectedValue, -1); BLL.CCOM.Admin_agency admin_bll = new BLL.CCOM.Admin_agency(); BLL.CCOM.Agency bll = new BLL.CCOM.Agency(); if (selectID == 1) { JscriptMsg("删除失败,该机构不能删除!", "", "Error"); return; } if (new BLL.CCOM.User_property().GetModel(" Agency_id=" + selectID) != null) { JscriptMsg("该机构下不为空,请先删除机构下用户,再删除机构!", "", "Error"); return; } bool result = false; try { result = bll.Delete(selectID); }catch { JscriptMsg("删除失败!", "", "Error"); } if (result == false) { JscriptMsg("删除失败!", "", "Error"); } else { JscriptMsg("删除成功!", "", "Success"); Response.Redirect(Utils.CombUrlTxt("OrgList.aspx", "fun_id={0}&selectid={1}&keywords={2}", DESEncrypt.Encrypt(fun_id), "", "")); } }
protected void ddlClique_SelectedIndexChanged(object sender, EventArgs e) { this.ddlMajor.Items.Clear(); this.radioSub.Items.Clear(); this.major_id = ""; if (this.ddlClique.SelectedValue == null || this.ddlClique.SelectedValue == "#") { this.LabelExamRoom.Text = ""; JscriptMsg("请选择系", "", "Error"); return; } string father_id = this.ddlClique.SelectedValue; string strWhere = " Agency_type=" + DataDic.CCOM_Major_type + " AND Agency_father = " + father_id; BLL.CCOM.Agency Bll = new BLL.CCOM.Agency(); DataSet ds = Bll.GetList(strWhere); this.ddlMajor.DataSource = ds.Tables[0].DefaultView; this.ddlMajor.DataTextField = "Agency_name"; this.ddlMajor.DataValueField = "Agency_id"; this.ddlMajor.DataBind(); ListItem item = new ListItem("--请选择专业方向--", "#"); this.ddlMajor.Items.Insert(0, item); if (this.major_id != "0" && this.major_id != "") { this.ddlMajor.SelectedValue = major_id; this.major_id = this.ddlMajor.SelectedValue; ddlMajor_SelectedIndexChanged(null, null); } }
public void BindChildAgency(DataTable dt, Model.CCOM.Agency model, int level) { string tag = ""; DataRow dr = dt.NewRow(); if (model == null) { dr["Agency_name"] = "--请选择机构--"; dr["Agency_id"] = "#"; } else { for (int i = 0; i < level; i++) { tag += " "; } tag += "┠"; dr["Agency_name"] = tag + model.Agency_name; dr["Agency_id"] = model.Agency_id; } dt.Rows.Add(dr); BLL.CCOM.Agency bll = new BLL.CCOM.Agency(); List <Model.CCOM.Agency> listAgency = bll.GetModelList(" Agency_father=" + (model == null ? 0 : model.Agency_id)); foreach (Model.CCOM.Agency agencyModel in listAgency) { BindChildAgency(dt, agencyModel, level + 1); } }
protected void Bind() { string strWhere = " Agency_type=" + DataDic.CCOM_Clique_type; BLL.CCOM.Agency Bll = new BLL.CCOM.Agency(); DataSet ds = Bll.GetList(strWhere); this.ddlClique.DataSource = ds.Tables[0].DefaultView; this.ddlClique.DataTextField = "Agency_name"; this.ddlClique.DataValueField = "Agency_id"; this.ddlClique.DataBind(); if (agency_id == 1) { this.ddlClique.SelectedIndex = 0; clique_id = this.ddlClique.SelectedValue; } else { this.ddlClique.SelectedValue = agency_id.ToString(); this.ddlClique.Enabled = false; } clique_id = this.ddlClique.SelectedValue; ddlClique_SelectedIndexChanged(null, null); var bll = new BLL.CCOM.Province(); this.rptList1.DataSource = bll.GetList(""); this.rptList1.DataBind(); }
public void BindChildAgency(Model.CCOM.Agency model, int level) { string tag = ""; DataRow dr = dt.NewRow(); if (model != null) { for (int i = 0; i < level; i++) { tag += " "; } tag += "┠"; dr["Agency_name"] = tag + model.Agency_name; dr["Agency_id"] = model.Agency_id; dt.Rows.Add(dr); } BLL.CCOM.Agency bll = new BLL.CCOM.Agency(); List <Model.CCOM.Agency> listAgency = bll.GetModelList(" Agency_father=" + (model == null ? 0 : model.Agency_id)); if (level <= 2) { foreach (Model.CCOM.Agency agencyModel in listAgency) { BindChildAgency(agencyModel, level + 1); } } }
private void RalBind() { try { string strWhere = ""; if (agency_id == DataDic.CCOM_Agency_id) { strWhere += (" Agency_type = " + DataDic.CCOM_Clique_type); } else { strWhere += (" Agency_id = " + agency_id); } BLL.CCOM.Agency Bll = new BLL.CCOM.Agency(); DataSet ds = Bll.GetList(strWhere); this.ddlClique.DataSource = ds.Tables[0].DefaultView; this.ddlClique.DataTextField = "Agency_name"; this.ddlClique.DataValueField = "Agency_id"; this.ddlClique.DataBind(); ListItem item = new ListItem("--请选择系--", "#"); this.ddlClique.Items.Insert(0, item); if (agency_id != DataDic.CCOM_Agency_id) { this.ddlClique.SelectedValue = agency_id.ToString(); this.ddlClique.Enabled = false; ddlClique_SelectedIndexChanged(null, null); } } catch { JscriptMsg("数据出错", "", "Error"); } }
protected void btnAddSubmit_Click(object sender, EventArgs e) { //BLL.admin.Universities_Organization bll = new BLL.admin.Universities_Organization(); //Model.admin.Universities_Organization modelfather = new Model.admin.Universities_Organization(); //TYPE_ID = Utils.StrToInt(this.DropDownList1.SelectedValue, 0); BLL.CCOM.Agency bll = new BLL.CCOM.Agency(); Model.CCOM.Agency modelfather = new Model.CCOM.Agency(); int UO_ID = 0; try { //UO_ID = Utils.StrToInt(this.ddlAddParentID.SelectedValue, 0); modelfather = bll.GetModel(UO_ID); } catch { modelfather = null; } if (modelfather != null) { Model.CCOM.Agency model = new Model.CCOM.Agency(); //string[] names = this.txtAddName.Text.Split('|'); int result = 0; int i = 0; //foreach (string name in names) //{ // if (name == "") continue; // if (Tools.CheckParams(name)) // { // result = 0; // break; // } // model.Agency_name = name; // model.Agency_father = UO_ID; // model.Agency_type = TYPE_ID; // model.Agency_status = true; // result = bll.Add(model); // if (result == 0) // break; //} if (result == 0) { JscriptMsg("添加失败,输入异常!", "back", "Error"); } else { //bll.ddlBind(this.ddlAddParentID, Utils.StrToInt(this.hiduo_id.Value, -11)); //绑定父级部门 JscriptMsg("添加成功!", "OrgAdd.aspx?fun_id=" + DESEncrypt.Encrypt(this.fun_id), "Success"); } } else { JscriptMsg("添加失败,请选择自己可以管理的机构!", "back", "Error"); } }
public void ShowOtherInfo() { BLL.CCOM.User_information user_bll = new BLL.CCOM.User_information(); Model.CCOM.User_information user_model = user_bll.GetModel(UserID); if (user_model == null) { InnerRedirect(MyEnums.RediirectErrorEnum.ParameterError); } //真实姓名 if (user_model.User_realname == null) { txt_User_realname.Text = "请填写真实姓名"; } else { this.txt_User_realname.Text = user_model.User_realname; } int agency_id = 0; agency_id = user_model.Agency_id; BLL.CCOM.Agency user_agency_bll = new BLL.CCOM.Agency(); Model.CCOM.Agency user_agency_model = user_agency_bll.GetModel(agency_id); if (user_agency_model.Agency_id != 0) { txt_Agency.Text = user_agency_model.Agency_name; } else { div_user_agency.Visible = false; } //移动电话 this.txt_User_number.Text = user_model.User_number; //性别 if ((Boolean)user_model.User_gender) { this.rbl_User_gender.SelectedIndex = 1; } //出生日期 if (user_model.User_birthday == null) { txt_User_birthday.Text = "请填写出生日期"; } else { this.txt_User_birthday.Text = Convert.ToDateTime(user_model.User_birthday).ToString("yyyy-MM-dd"); } //添加日期 this.txt_User_addtime.Text = Convert.ToDateTime(user_model.User_addtime).ToString("yyyy-MM-dd"); }
protected void btnEditSubmit_Click(object sender, EventArgs e) { BLL.CCOM.Agency bll = new BLL.CCOM.Agency(); int UO_ID = 0; try { UO_ID = Utils.StrToInt(MyRequest.GetQueryString("selectid"), 0); } catch { } if (UO_ID == 0 || UO_ID == -1) { JscriptMsg("添加失败,输入异常!", "back", "Error"); return; } Model.CCOM.Agency model = bll.GetModel(UO_ID); String orgName = txtEditName.Text.Trim(); if (Tools.CheckParams(orgName)) { JscriptMsg("添加失败,输入异常!", "back", "Error"); return; } else { model.Agency_name = orgName; } if (rbEditStatus.SelectedItem.Text.Equals("启用")) { model.Agency_status = true; } else if (rbEditStatus.SelectedItem.Text.Equals("停用")) { model.Agency_status = false; } try { model.Agency_type = int.Parse(this.ddlType.SelectedValue); } catch { JscriptMsg("添加失败,输入异常!", "back", "Error"); return; } bool result = bll.Update(model); if (result == false) { JscriptMsg("添加失败,输入异常!", "back", "Error"); } else { JscriptMsg("编辑成功!", "OrgList.aspx?fun_id=" + DESEncrypt.Encrypt(fun_id) + "&selectid=" + DESEncrypt.Encrypt(UO_ID.ToString()), "Success"); } }
//绑定机构树 private void DepartmentTreeBindNoCheck(TreeView tv) { string groupIdStr = Server.UrlDecode(MyRequest.GetQueryString("groupList")); List <String> groupIdList = groupIdStr.Split(',').ToList(); BLL.CCOM.Agency bll = new BLL.CCOM.Agency(); TreeBindNoCheck_UOAndUser(tv, 1); //UpdateTreenodeStatus(tv.Nodes[0], userIdList); UpdateTreenodeStatus(tv.Nodes[0], groupIdList); }
protected void Page_Load(object sender, EventArgs e) { _id = GetAdminInfo_CCOM().User_id; if (!Page.IsPostBack) { Model.CCOM.Agency model = new BLL.CCOM.Agency().GetModel(1); this.ChildUOCount = new BLL.CCOM.Agency().GetModelList(" Agency_father=1").Count; bindall(); } }
public void BindDepartment() { BLL.CCOM.Agency bll = new BLL.CCOM.Agency(); DataSet ds = bll.GetList(" Agency_type = 2"); this.ddlDepartment.DataSource = ds.Tables[0].DefaultView; this.ddlDepartment.DataTextField = "Agency_name"; this.ddlDepartment.DataValueField = "Agency_id"; this.ddlDepartment.DataBind(); ListItem item = new ListItem("--请选择系--", "#"); this.ddlDepartment.Items.Insert(0, item); }
//得到指定部门下所有的机构列表 public string GetSonUOList(int UO_ID) { string res = ""; res += UO_ID.ToString() + ","; List <Model.CCOM.Agency> modellist = new BLL.CCOM.Agency().GetModelList(" Agency_father = " + UO_ID + " and Agency_status=1"); foreach (Model.CCOM.Agency model in modellist) { res += GetSonUOList(model.Agency_id) + ","; } return(Utils.DelLastComma(res)); }
protected void bindall() { Model.CCOM.Agency model = new BLL.CCOM.Agency().GetModel(1); if (model == null) { InnerRedirect(MyEnums.RediirectErrorEnum.NotAdmin); } else { this.hiduoid.Value = model.Agency_id.ToString(); BLL.CCOM.Agency bll = new BLL.CCOM.Agency(); this.ddlEditSelect.DataSource = GetOrgList_DataSet(true); this.ddlEditSelect.DataTextField = "Agency_name"; this.ddlEditSelect.DataValueField = "Agency_id"; this.ddlEditSelect.DataBind(); int UO_ID = 0; try { UO_ID = Utils.StrToInt(MyRequest.GetQueryString("selectid"), 0); } catch { } if (UO_ID == 0 || UO_ID == -1 || UO_ID == 1) { this.txtEditName.Enabled = false; this.rbEditStatus.Enabled = false; this.btnEditSubmit.Enabled = false; this.ddlType.Enabled = false; } else { this.txtEditName.Enabled = true; this.rbEditStatus.Enabled = true; this.btnEditSubmit.Enabled = true; this.ddlType.Enabled = true; Model.CCOM.Agency uo = bll.GetModel(UO_ID); this.ddlEditSelect.SelectedValue = MyRequest.GetString("selectid"); this.txtEditName.Text = uo.Agency_name; this.ddlType.SelectedValue = uo.Agency_type.ToString(); if (uo.Agency_status) { this.rbEditStatus.SelectedValue = "1"; } else { this.rbEditStatus.SelectedValue = "0"; } } } }
protected string getMajorName() { string strWhere = " Agency_id=" + major_id; Model.CCOM.Agency majormodel = new BLL.CCOM.Agency().GetModel(strWhere); string name = ""; if (majormodel != null) { name = majormodel.Agency_name.ToString(); } return(name); }
protected string getMajorName(string _major_id) { string strWhere = " Agency_id=" + _major_id; Model.CCOM.Agency major = new BLL.CCOM.Agency().GetModel(strWhere); string name = ""; if (major != null) { name = major.Agency_name; } return(name); }
private void TreeBindNoCheck_UOAndUser(TreeView tv, int _ID) { tv.Nodes.Clear(); //父节点 var pud = new BLL.CCOM.Agency().GetModel(_ID); if (pud != null) { var tn = new TreeNode(pud.Agency_name, 'O' + pud.Agency_id.ToString()); tn.Expanded = true; tn.ImageUrl = "/images/folder.png"; tv.Nodes.Add(tn); TreeAddChildNoCheck_UOAndUser(tn, pud); } }
public string GetAgencyName(string agency_id) { string agency_name = ""; try { var bll = new BLL.CCOM.Agency(); var model = bll.GetModel(" Agency_id=" + agency_id); agency_name = model.Agency_name; } catch { } return(agency_name); }
protected void Page_Load(object sender, EventArgs e) { //adminuserid = int.Parse(Session[MyKeys.SESSION_USER_STATUSID].ToString()); //adminuserid = GetAdminInfo_CCOM().User_id; if (!Page.IsPostBack) { //Model.admin.View_AdminUser model = new BLL.admin.View_AdminUser().GetModel(Convert.ToInt64(Session[MyKeys.SESSION_USER_STATUSID])); Model.CCOM.Agency model = new BLL.CCOM.Agency().GetModel(1); //this.StuCount = // new BLL.admin.View_AdminUser().GetModelList(" UO_ID in (select UO_ID from dbo.F_ChildOrgTableNosort('" + model.UO_ID.ToString() + "') ) ").Count; // new BLL.admin.View_SchoolUser().GetModelList(" UO_ID in (select UO_ID from dbo.F_ChildOrgTableNosort('" + model.UO_ID.ToString() + "') ) ").Count; this.ChildUOCount = new BLL.CCOM.Agency().GetModelList(" Agency_father=1").Count; bindall(); } }
public void BindFf1_ID() { BLL.CCOM.Agency bll = new BLL.CCOM.Agency(); DataSet ds = new DataSet(); DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("Ff_name", typeof(string))); dt.Columns.Add(new DataColumn("Ff_id", typeof(string))); //加密后的id addOtherDll(dt, DataDic.Father_Function, 0); ds.Tables.Add(dt); this.ddlFf2_ID.DataSource = ds; this.ddlFf2_ID.DataTextField = "Ff_name"; this.ddlFf2_ID.DataValueField = "Ff_id"; this.ddlFf2_ID.DataBind(); }
public string GetAgency(string UserID) { BLL.CCOM.User_property bll = new BLL.CCOM.User_property(); string str = string.Empty; try { Model.CCOM.User_property model = bll.GetModel(" User_id='" + UserID + "'"); str = new BLL.CCOM.Agency().GetModel((int)model.Agency_id).Agency_name; } catch { str = "未设置"; } return(str); }
public void TreeAddChildNoCheck_UOAndUser(TreeNode tn, Model.CCOM.Agency ud) { var bll = new BLL.CCOM.Agency(); var uds = bll.GetModelList(" Agency_father=" + ud.Agency_id.ToString()); if (uds != null) { foreach (var cud in uds) { var ctn = new TreeNode(cud.Agency_name, 'O' + cud.Agency_id.ToString()); ctn.Expanded = false; ctn.ImageUrl = "/images/folder.png"; tn.ChildNodes.Add(ctn); TreeAddChildNoCheck_UOAndUser(ctn, cud); } } }
private void BindDDL() { //一级下拉菜单 var firstList = new BLL.CCOM.Agency().GetList("Agency_father = 1 and Agency_status=1"); if (firstList.Tables[0].DefaultView.Count <= 0) { return; } this.DropDownList0.DataSource = firstList; this.DropDownList0.DataTextField = "Agency_name"; this.DropDownList0.DataValueField = "Agency_id"; this.DropDownList0.DataBind(); this.DropDownList0.Items.Insert(0, new ListItem("请您选择...", "0")); this.DropDownList1.Items.Insert(0, new ListItem("请您选择...", "0")); this.DropDownList2.Items.Insert(0, new ListItem("请您选择...", "0")); }
protected void ddlClique_SelectedIndexChanged(object sender, EventArgs e) { clique_id = this.ddlClique.SelectedValue; string strWhere = " Agency_father=" + clique_id + " AND Agency_type= " + DataDic.CCOM_Major_type; try { var bll = new BLL.CCOM.Agency(); majorList = bll.GetModelList(strWhere); this.rptList.DataSource = bll.GetList(strWhere); this.rptList.DataBind(); } catch { JscriptMsg("获取专业方向出错", "", "Error"); } }