private void InitData() { DataTable dt = DataFactory.SqlDataBase().GetDataTable("Base_Vendor"); ControlBindHelper.BindHtmlSelect(dt, this.BV_ID, "BV_Name", "BV_ID", "开发商"); Hashtable ht = DataFactory.SqlDataBase().GetHashtableById("Contract_Mortgage", "UID", this.UID); if (ht.Count > 0 && ht != null) { DateTime NewDate; if (!string.IsNullOrEmpty(ht["M_REPLY_BEGIN"].ToString())) { NewDate = DateTime.Parse(ht["M_REPLY_BEGIN"].ToString()); ht["M_REPLY_BEGIN"] = NewDate.ToString("yyyy-MM-dd"); } if (!string.IsNullOrEmpty(ht["M_REPLY_END"].ToString())) { NewDate = DateTime.Parse(ht["M_REPLY_END"].ToString()); ht["M_REPLY_END"] = NewDate.ToString("yyyy-MM-dd"); } if (!string.IsNullOrEmpty(ht["M_SIGNDATE"].ToString())) { NewDate = DateTime.Parse(ht["M_SIGNDATE"].ToString()); ht["M_SIGNDATE"] = NewDate.ToString("yyyy-MM-dd"); } ControlBindHelper.SetWebControls(this.Page, ht); } }
private void BindSelect() { DataTable dt = DataFactory.SqlDataBase().GetDataTable("School_Area"); ControlBindHelper.BindHtmlSelect(dt, this.AreaName, "AreaName", "AreaName", "院校所在地"); DataTable dtEduBack = DataFactory.SqlDataBase().GetDataTable("EduBack"); ControlBindHelper.BindHtmlSelect(dtEduBack, this.EduBackName, "name", "name", "学历"); DataTable dtEduType = DataFactory.SqlDataBase().GetDataTable("EduType"); ControlBindHelper.BindHtmlSelect(dtEduType, this.EduTypeName, "name", "name", "教育类型"); DataTable dtCompany = DataFactory.SqlDataBase().GetDataTable("Company"); ControlBindHelper.BindHtmlSelect(dtCompany, this.CompanyID, "companyName", "companyID", "申报单位"); StringBuilder sb = new StringBuilder(); sb.Append("SELECT specName FROM Specialty group by specName"); DataTable dtSpecialty = DataFactory.SqlDataBase().GetDataTableBySQL(sb); ControlBindHelper.BindHtmlSelect(dtSpecialty, this.specName, "specName", "specName", "申报专业"); DataTable dtUserStatus = DataFactory.SqlDataBase().GetDataTable("UserStatus"); ControlBindHelper.BindHtmlSelect(dtUserStatus, this.status, "status", "status", "审核状态"); DataTable dtChecks = DataFactory.SqlDataBase().GetDataTable("Keys"); ControlBindHelper.BindHtmlSelect(dtChecks, this.Checks, "value", "value", "确认简历"); }
/// <summary> /// 初始化绑定下拉框 /// </summary> public void InitBindDrop() { BPMS_ItemDetailsIBLL bpms_itemdetailsibll = new BPMS_ItemDetailsBLL(); IList List = bpms_itemdetailsibll.GetListByItemsId("5fed1313-7355-4cc4-a7ec-73211a361fa6"); ControlBindHelper.BindHtmlSelect(List, Category, "ItemName", "ItemCode", "==请选择=="); }
/// <summary> /// 初始化绑定下拉框 /// </summary> public void InitBindDrop() { BPMS_ItemDetailsIBLL bpms_itemdetailsibll = new BPMS_ItemDetailsBLL(); IList list = bpms_itemdetailsibll.GetList(); //职称 IList TitleIdList = IListHelper.IListToList <BPMS_ItemDetails>(list).FindAll(t => t.ItemsId == "2acba9e8-5fa7-4b6f-8ebd-56e753dd059a"); ControlBindHelper.BindHtmlSelect(TitleIdList, TitleId, "ItemName", "ItemCode", "==请选择=="); //职位 IList DutyIdList = IListHelper.IListToList <BPMS_ItemDetails>(list).FindAll(t => t.ItemsId == "137a2d97-d1d9-4752-9c5e-239097e2ed68"); ControlBindHelper.BindHtmlSelect(DutyIdList, DutyId, "ItemName", "ItemCode", "==请选择=="); }
/// <summary> /// 加载,未选择字段、己选择字段 /// </summary> public void InitBind() { if (!string.IsNullOrEmpty(_Menu_Id)) { IList list = bpms_tablecolumnsibll.GetList(_Menu_Id); //未选择字段 IList itemfrom_sel = IListHelper.IListToList <BPMS_TableColumns>(list).FindAll(t => t.IsPublic == 0); ControlBindHelper.BindHtmlSelect(itemfrom_sel, search_fields_from_sel, "Title", "TableColumnsId", ""); //己选择字段 IList itemto_sel = IListHelper.IListToList <BPMS_TableColumns>(list).FindAll(t => t.IsPublic == 1); ControlBindHelper.BindHtmlSelect(itemto_sel, search_fields_to_sel, "Title", "TableColumnsId", ""); } }
private void BindSelect() { DataTable dt = DataFactory.SqlDataBase().GetDataTable("Company"); ControlBindHelper.BindHtmlSelect(dt, this.CompanyID, "companyName", "CompanyID", "公司名称"); DataTable dtEduBack = DataFactory.SqlDataBase().GetDataTable("EduBack"); ControlBindHelper.BindHtmlSelect(dtEduBack, this.EduBack, "name", "value", "选择学历"); DataTable dtUserStatus = DataFactory.SqlDataBase().GetDataTable("Keys"); ControlBindHelper.BindHtmlSelect(dtUserStatus, this.isLock, "value", "keys", "锁定状态"); }
private void BindSelect() { DataTable dt = DataFactory.SqlDataBase().GetDataTable("Base_UserInfo"); ControlBindHelper.BindHtmlSelect(dt, this.MsgSender, "User_Name", "User_ID", "发送人"); DataTable dtMsgType = DataFactory.SqlDataBase().GetDataTable("UserMessageType"); ControlBindHelper.BindHtmlSelect(dtMsgType, this.MsgType, "TypeName", "MsgType", "消息类型"); DataTable dtISRead = DataFactory.SqlDataBase().GetDataTable("UserMessageStates"); ControlBindHelper.BindHtmlSelect(dtISRead, this.ISRead, "ReadState", "ISRead", "消息状态"); }
protected void Page_Load(object sender, EventArgs e) { this.PID = base.Request["PID"]; this.FlowInfoId = base.Request["FlowInfoId"]; if (!base.IsPostBack) { DataTable dt = DataFactory.SqlDataBase().GetDataTable("Base_Roles"); ControlBindHelper.BindHtmlSelect(dt, this.RoleId, "Roles_Name", "Roles_ID", "审批角色"); if (!string.IsNullOrEmpty(this.PID)) { this.InitData(); } } }
private void InitParentId() { DataTable dt = this.user_idao.InitUserGroupParentId(); if (!string.IsNullOrEmpty(this._key)) { if (DataTableHelper.IsExistRows(dt)) { for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["UserGroup_ID"].ToString() == this._key) { dt.Rows.RemoveAt(i); } } } } ControlBindHelper.BindHtmlSelect(dt, this.ParentId, "UserGroup_Name", "UserGroup_ID", "用户组信息 - 父节"); }
/// <summary> /// 节点位置下拉框绑定 /// </summary> /// <param name="projectid"></param> /// <returns></returns> private void InitParentId() { DataTable dt = system_idao.InitRoleParentId(); if (!string.IsNullOrEmpty(_key)) { if (DataTableHelper.IsExistRows(dt)) { for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["Roles_ID"].ToString() == _key) { dt.Rows.RemoveAt(i); } } } } ControlBindHelper.BindHtmlSelect(dt, ParentId, "Roles_Name", "Roles_ID", "角色信息 - 父节"); }
private void InitMaterialAttr() { DataTable dt = this.system_idao.InitMaterialStatus("物资属性"); if (!string.IsNullOrEmpty(this._key)) { if (DataTableHelper.IsExistRows(dt)) { for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["ValueCode"].ToString() == this._key) { dt.Rows.RemoveAt(i); } } } } ControlBindHelper.BindHtmlSelect(dt, this.Material_Attr01, "ValueName", "ValueCode", "物资属性"); }
private void BindSelect() { DataTable dt = DataFactory.SqlDataBase().GetDataTable("Company"); ControlBindHelper.BindHtmlSelect(dt, this.companyName, "companyName", "companyName", "公司名称"); StringBuilder sb = new StringBuilder(); sb.Append("SELECT specName FROM Specialty group by specName"); DataTable dtSpecialty = DataFactory.SqlDataBase().GetDataTableBySQL(sb); ControlBindHelper.BindHtmlSelect(dtSpecialty, this.specName, "specName", "specName", "申报专业"); //DataTable dtEduBack = DataFactory.SqlDataBase().GetDataTable("Specialty"); //ControlBindHelper.BindHtmlSelect(dtEduBack, this.specName, "specName", "specName", "专业名称"); DataTable dtUserStatus = DataFactory.SqlDataBase().GetDataTable("Keys"); ControlBindHelper.BindHtmlSelect(dtUserStatus, this.isLock, "value", "keys", "锁定状态"); }
private void InitParentId() { DataTable dt = this.systemidal.GetOrgaizationList(RequestSession.GetSessionUser().UserId.ToString()); if (DataTableHelper.IsExistRows(dt)) { for (int i = 0; i < dt.Rows.Count; i++) { if (!string.IsNullOrEmpty(Organization_IDs)) { Organization_IDs = Organization_IDs + ",'" + dt.Rows[i]["Organization_ID"].ToString() + "'"; } else { Organization_IDs = "'" + dt.Rows[i]["Organization_ID"].ToString() + "'"; } } ControlBindHelper.BindHtmlSelect(dt, this.Organization_ID, "Organization_Name", "Organization_ID", "请选择"); } }
/// <summary> /// 初始化绑定下拉框 /// </summary> public void InitBindDrop() { BPMS_ItemDetailsIBLL bpms_itemdetailsibll = new BPMS_ItemDetailsBLL(); IList list = bpms_itemdetailsibll.GetList(); //最高学历 IList EducationList = IListHelper.IListToList <BPMS_ItemDetails>(list).FindAll(t => t.ItemsId == "1559ff6d-8b04-48f7-952c-333305bc526d"); ControlBindHelper.BindHtmlSelect(EducationList, Education, "ItemName", "ItemCode", "==请选择=="); //最高学位 IList DegreeList = IListHelper.IListToList <BPMS_ItemDetails>(list).FindAll(t => t.ItemsId == "964d6a06-5282-4fcb-b805-f192ae0de922"); ControlBindHelper.BindHtmlSelect(DegreeList, Degree, "ItemName", "ItemCode", "==请选择=="); //职称 IList TitleIdList = IListHelper.IListToList <BPMS_ItemDetails>(list).FindAll(t => t.ItemsId == "2acba9e8-5fa7-4b6f-8ebd-56e753dd059a"); ControlBindHelper.BindHtmlSelect(TitleIdList, TitleId, "ItemName", "ItemCode", "==请选择=="); //职称等级 IList TitleLevelList = IListHelper.IListToList <BPMS_ItemDetails>(list).FindAll(t => t.ItemsId == "b65809f0-3b7b-44d1-b2f5-c93ef9afa12d"); ControlBindHelper.BindHtmlSelect(TitleLevelList, TitleLevel, "ItemName", "ItemCode", "==请选择=="); //职位 IList DutyIdList = IListHelper.IListToList <BPMS_ItemDetails>(list).FindAll(t => t.ItemsId == "137a2d97-d1d9-4752-9c5e-239097e2ed68"); ControlBindHelper.BindHtmlSelect(DutyIdList, DutyId, "ItemName", "ItemCode", "==请选择=="); //用工性质 IList WorkingPropertyList = IListHelper.IListToList <BPMS_ItemDetails>(list).FindAll(t => t.ItemsId == "0e08fdaa-8e7a-4890-98d5-e2f36f55c512"); ControlBindHelper.BindHtmlSelect(WorkingPropertyList, WorkingProperty, "ItemName", "ItemCode", "==请选择=="); //政治面貌 IList PartyList = IListHelper.IListToList <BPMS_ItemDetails>(list).FindAll(t => t.ItemsId == "44e210fb-5afd-4511-a56c-a438d947d5bc"); ControlBindHelper.BindHtmlSelect(PartyList, Party, "ItemName", "ItemCode", "==请选择=="); //国籍 IList NationList = IListHelper.IListToList <BPMS_ItemDetails>(list).FindAll(t => t.ItemsId == "e2e78aec-31f7-4de5-af7b-bb5bc7c09a61"); ControlBindHelper.BindHtmlSelect(NationList, Nation, "ItemName", "ItemCode", "==请选择=="); //民族 IList NationalityList = IListHelper.IListToList <BPMS_ItemDetails>(list).FindAll(t => t.ItemsId == "104bfd21-5bbe-4b96-b5c2-448b84dbe0d8"); ControlBindHelper.BindHtmlSelect(NationalityList, Nationality, "ItemName", "ItemCode", "==请选择=="); }
private void InitParentId() { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT MaterialType_ID,\r\n MaterialType_Name+' - '+CASE ParentId WHEN '0' THEN '父节' ELSE '子节' END AS MaterialType_Name\r\n FROM MMS_MaterialType WHERE DeleteMark = 1 ORDER BY SortCode ASC"); DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(strSql); if (!string.IsNullOrEmpty(this._key)) { if (DataTableHelper.IsExistRows(dt)) { for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["MaterialType_ID"].ToString() == this._key) { dt.Rows.RemoveAt(i); } } } } ControlBindHelper.BindHtmlSelect(dt, this.Material_Type, "MaterialType_Name", "MaterialType_Name", "物资类型 - 父节"); }
private void InitParentId() { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT Menu_Id,\r\n Menu_Name+' - '+CASE Menu_Type WHEN '1' THEN '父节' WHEN '2' THEN '子节' END AS Menu_Name\r\n FROM Base_SysMenu WHERE DeleteMark = 1 AND Menu_Type != 3 ORDER BY SortCode ASC"); DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(strSql); if (!string.IsNullOrEmpty(this._key)) { if (DataTableHelper.IsExistRows(dt)) { for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["Menu_Id"].ToString() == this._key) { dt.Rows.RemoveAt(i); } } } } ControlBindHelper.BindHtmlSelect(dt, this.ParentId, "Menu_Name", "Menu_Id", "模块菜单 - 父节"); }
/// <summary> /// 节点位置下拉框绑定 /// </summary> /// <param name="projectid"></param> /// <returns></returns> private void InitParentId() { StringBuilder strSql = new StringBuilder(); strSql.Append(@"SELECT Organization_ID, Organization_Name+' - '+CASE ParentId WHEN '0' THEN '父节' ELSE '子节' END AS Organization_Name FROM Base_Organization WHERE DeleteMark = 1 ORDER BY SortCode ASC"); DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(strSql); if (!string.IsNullOrEmpty(_key)) { if (DataTableHelper.IsExistRows(dt)) { for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["Organization_ID"].ToString() == _key) { dt.Rows.RemoveAt(i); } } } } ControlBindHelper.BindHtmlSelect(dt, ParentId, "Organization_Name", "Organization_ID", "部门信息 - 父节"); }
private void InitClassID() { DataTable dt = DataFactory.SqlDataBase().GetDataTable("Base_User_Class"); ControlBindHelper.BindHtmlSelect(dt, this.ClassID, "UserClass", "ClassID", ""); }
private void InitContractType() { DataTable dt = DataFactory.SqlDataBase().GetDataTable("Contract_Type"); ControlBindHelper.BindHtmlSelect(dt, this.ContractType, "ContractName", "ContractType", ""); }
private void BindState() { DataTable dt = this.systemidal.GetStateList(); ControlBindHelper.BindHtmlSelect(dt, this.Ticket_States, "States_Name", "States_ID", "所有"); }
private void BindSelect() { DataTable dtMsgType = DataFactory.SqlDataBase().GetDataTable("UserMessageType"); ControlBindHelper.BindHtmlSelect(dtMsgType, this.MsgType, "TypeName", "MsgType", "消息类型"); }