private void 费用分配查询_Load(object sender, EventArgs e) { rbDetails.Checked = true; var mTable1 = new T_UsersTableAdapter().GetSalers(); foreach (销售管理.DAL.DataSetUsers.T_UsersRow mRow in mTable1.Rows) { cmbUsername.Items.Add(new Classes.PubClass.MyCmbList(mRow.id, mRow.UserName)); } cmbUsername.Items.Insert(0, "查询所有"); cmbUsername.SelectedIndex = 0; cmbType.SelectedIndex = 0; cmbCompanyName.ValueMember = "Id"; cmbCompanyName.DisplayMember = "CompanyName"; DataTable mTable = new T_CustomersTableAdapter().GetData(); 销售管理.DAL.DataSetCustomers.T_CustomersRow mDataRow = (销售管理.DAL.DataSetCustomers.T_CustomersRow)mTable.NewRow(); mDataRow.id = 0; mDataRow.CompanyName = "全部"; mTable.Rows.InsertAt(mDataRow, 0); cmbCompanyName.DataSource = mTable; if (!Common.AuthenticateRight.AuthOperation(140201) && !CommonClass.SttUser.blSuperUser) { cmbUsername.SelectedIndex = cmbUsername.FindStringExact(Classes.PubClass.UserName); cmbUsername.Enabled = false; rbUserSum.Visible = false; rbDepartSum.Visible = false; } }
private void cmbUsername_SelectedIndexChanged(object sender, EventArgs e) { cmbCompanyName.DisplayMember = "CompanyName"; cmbCompanyName.ValueMember = "Id"; DataTable mTable; if (cmbUsername.Text != "查询所有" && cmbUsername.Text != "") { mTable = new T_CustomersTableAdapter().GetDataByUserId(Convert.ToInt64((cmbUsername.SelectedItem as Classes.PubClass.MyCmbList).Id)); } else { mTable = new T_CustomersTableAdapter().GetData(); } 销售管理.DAL.DataSetCustomers.T_CustomersRow mDataRow = (销售管理.DAL.DataSetCustomers.T_CustomersRow)mTable.NewRow(); mDataRow.id = 0; mDataRow.CompanyName = "全部"; mTable.Rows.InsertAt(mDataRow, 0); cmbCompanyName.DataSource = mTable; cmbCompanyName.SelectedIndex = -1; }