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;
}
