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", "消息类型");
}
