private void HY_Permissions_Load(object sender, EventArgs e) { this.chkALL.Checked =false; this.checkedListBox.DataSource = hyset.userSecurity(sql).DefaultView; this.checkedListBox.ValueMember = "s_QID"; this.checkedListBox.DisplayMember = "s_QName"; //绑定用户信息 HY_BLL.HY_UserListBLL hyul = new HY_UserListBLL(); this.comboBoxuserName.DataSource = hyul.back_SupplierPrice(); this.comboBoxuserName.DisplayMember = "h_UserName"; this.comboBoxuserName.ValueMember = "h_ID"; }
//自定义绑定数据 private void requistionDate(string sql) { HY_BLL.HY_UserListBLL hyul = new HY_UserListBLL(); this.listView1.View = View.Details; this.listView1.FullRowSelect = true; SqlDataReader sdr = hyul.f_hyUserLiset(sql); while (sdr.Read()) { ListViewItem lv = new ListViewItem(sdr[0].ToString()); lv.SubItems.Add(sdr[1].ToString()); lv.SubItems.Add(sdr[5].ToString()); this.listView1.Items.Add(lv); } }
private void toolStripAdd_Click(object sender, EventArgs e) { this.toolStripEdit.Enabled = false; this.toolStripAdd.Enabled = false; this.toolStripSave.Enabled = true; this.toolStripCEL.Enabled = true; this.groupA.Enabled = true; this.groupB.Enabled = true; string d = "DH"; this.p_ID.Text = hyNO.JhGoodsID(d); intFalg = 1; //绑定供应商信息 HY_BLL.HY_SupplierBLL hysup = new HY_SupplierBLL(); this.p_gyName.DataSource = hysup.back_Supplier(); this.p_gyName.DisplayMember = "s_gyName"; this.p_gyName.ValueMember = "s_ID"; //绑定用户信息 HY_BLL.HY_UserListBLL hyul = new HY_UserListBLL(); this.p_rPerson.DataSource = hyul.back_SupplierPrice(); this.p_rPerson.DisplayMember = "h_UserName"; this.p_rPerson.ValueMember = "h_ID"; }