/// <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"; //最后加载出来的列
}
