/// <summary> /// 加载所属角色的下拉列表 /// </summary> public void Role() { NewFolder1.Customer customer = new NewFolder1.Customer(); DataTable dt = customer.role(); comRoleID.DataSource = dt; comRoleID.ValueMember = "RoleID"; comRoleID.DisplayMember = "RoleName"; }
/// <summary> /// 加载所属部门的下拉列表 /// </summary> public void Dep() { NewFolder1.Customer customer = new NewFolder1.Customer(); DataTable dt = customer.comDepID(); comDepID.DataSource = dt; comDepID.ValueMember = "DepID"; comDepID.DisplayMember = "DepName"; }
/// <summary> /// 经办人下拉列表 /// </summary> public void comNameLoad() { comName.Items.Clear(); NewFolder1.Customer customer = new NewFolder1.Customer(); DataTable dt = customer.SelectListByWhere(""); comName.DataSource = dt; //绑定数据库 comName.ValueMember = "CustomerID"; //显示掩藏的值 comName.DisplayMember = "CustomerName"; //最后加载出来的列 }