public partial class Form_ShowStaff : Form
{
Command.BusinessCommand.ProjectExplorer.com_Project com = new Command.BusinessCommand.ProjectExplorer.com_Project();
List<LookUpList.simpleLookUpEditList> list = new List<LookUpList.simpleLookUpEditList>();
List<LookUpList.simpleLookUpEditList> jihe = new List<LookUpList.simpleLookUpEditList>();
public Form_ShowStaff()
{
InitializeComponent();
bindComboboxEdit();
}
private void bindComboboxEdit()
{
list = com.returnGroup();
ckb_group.Properties.DataSource = list;
ckb_group.Properties.DisplayMember = "lookname";
ckb_group.Properties.ValueMember = "lookvalue";
ckb_group.Properties.NullText = "";
jihe = com.returnStaff();
ckb_staff.Properties.DataSource = jihe;
ckb_staff.Properties.DisplayMember = "lookname";
ckb_staff.Properties.ValueMember = "lookvalue";
ckb_staff.Properties.NullText = "";
}
}
public List<LookUpList.simpleLookUpEditList> returnGroup()
{
List<LookUpList.simpleLookUpEditList> list = new List<LookUpList.simpleLookUpEditList>();
string sql = "select groupname as lookname,id as lookvalue from userrolegroup where u_state=0";
return list.setListTwithObject<LookUpList.simpleLookUpEditList>(SqlHelper.ExecuteDataTable(sql));
}
public List<LookUpList.simpleLookUpEditList> returnStaff()
{
List<LookUpList.simpleLookUpEditList> list = new List<LookUpList.simpleLookUpEditList>();
string sql = "select id as lookvalue,s_en_name as lookname from staff where s_state=0";
return list.setListTwithObject<LookUpList.simpleLookUpEditList>(SqlHelper.ExecuteDataTable(sql));
}
public class simpleLookUpEditList
{
private string _lookname = "";
private string _lookvalue = "";
/// <summary>
/// 要显示的内容
/// </summary>
public string lookname { get { return _lookname.returnvalue(); } set { _lookname = value; } }
/// <summary>
/// 显示的内容的实际值
/// </summary>
public string lookvalue { get { return _lookvalue.returnvalue(); } set { _lookvalue = value; } }
}