private void 客户资料管理_Load(object sender, EventArgs e) { rbYes.Checked = true; //添加省市cmb var mTable1 = new T_PromaryTableAdapter().GetData(); cmbPromary.DisplayMember = "proName"; cmbPromary.ValueMember = "proID"; cmbPromary.DataSource = mTable1; cmbPromary.SelectedIndex = -1; tCustomersBindingSource.DataSource = t_CustomersTableAdapter.GetDataAndCountByUserId(Classes.PubClass.UserId); if (!Common.AuthenticateRight.AuthOperation(110101) && Common.CommonClass.SttUser.blSuperUser == false) { cmbUserName.Items.Add(Classes.PubClass.UserName); cmbUserName.Items.Add("全部"); cmbUserName.SelectedIndex = 0; } else { cmbUserName.DataSource = new T_UsersTableAdapter().GetData(); cmbUserName.DisplayMember = "UserName"; cmbUserName.ValueMember = "ID"; cmbUserName.SelectedValue = Classes.PubClass.UserId; } }
private void 销售记录查询_Load(object sender, EventArgs e) { cmbProducts1.Items.Add("查询所有"); var mTable = new T_ProductsTableAdapter().GetDataByLevel(1); //获取level1的产品 foreach (销售管理.DAL.DataSetProducts.T_ProductsRow mRow in mTable.Rows) { cmbProducts1.Items.Add(new Classes.PubClass.MyCmbList(mRow.Id, mRow.Name)); } cmbProducts1.SelectedIndex = 0; //获取销售列表 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; //获取省 不用数据绑定是因为要添加 查询所有 cmbPromary.Items.Add("查询所有"); var mTable2 = new T_PromaryTableAdapter().GetData(); foreach (销售管理.DAL.DataSetPromary.T_PromaryRow mRow in mTable2.Rows) { cmbPromary.Items.Add(new Classes.PubClass.MyCmbList(mRow.proID, mRow.proName)); } cmbPromary.SelectedIndex = 0; rbDetails.Checked = true; //是否开票选项 lbInvoiceFlag.Visible = true; CmbInvoiceFlag.Visible = true; //MakeLineChart(); if (!Common.AuthenticateRight.AuthOperation(140101) && !CommonClass.SttUser.blSuperUser) { cmbUsername.SelectedIndex = cmbUsername.FindStringExact(Classes.PubClass.UserName); cmbUsername.Enabled = false; rbSalerSum.Visible = false; } //是否开票 CmbInvoiceFlag.SelectedIndex = 0; }
private void 客户资料维护_Load(object sender, EventArgs e) { //添加省市cmb var mTable1 = new T_PromaryTableAdapter().GetData(); cmbPromary.DisplayMember = "proName"; cmbPromary.ValueMember = "proID"; cmbPromary.DataSource = mTable1; cmbPromary.SelectedIndex = -1; if (mId == -1) { btnSave.Text = "增加"; } else { var mTable = new T_CustomersTableAdapter().GetDataById(mId); if (mTable.Rows.Count > 0) { var mRow = (销售管理.DAL.DataSetCustomers.T_CustomersRow)mTable.Rows[0]; txtComName.Text = mRow.CompanyName; txtComAddr.Text = mRow.CompanyAddress; txtBusinessName.Text = mRow.BusinessContactName; if (mRow.IsDeliverAddressNull() == false) { txtDeliverAddr.Text = mRow.DeliverAddress; } if (mRow.IsDeliverNameNull() == false) { txtDeliverName.Text = mRow.DeliverName; } if (mRow.IsDeliverPhoneNull() == false) { txtDeliverPhone.Text = mRow.DeliverPhone; } if (mRow.IsCityIDNull() == false) { var mTable2 = new T_CityTableAdapter().GetDataByID(mRow.CityID); if (mTable2.Rows.Count > 0) { cmbPromary.SelectedValue = mTable2[0].proID; cmbCity.SelectedValue = mRow.CityID; } } txtBusinessTel.Text = mRow.BusinessContactTel; txtBusinessPhone.Text = mRow.BusinessContactPhone; txtBusinessEmail.Text = mRow.BusinessContactEmail; txtTechName.Text = mRow.TechContactName; txtTechTel.Text = mRow.TechContactTel; txtTechPhone.Text = mRow.TechContactPhone; txtTechEmail.Text = mRow.TechContactEmail; } else { MessageBox.Show("获取客户资料错误"); this.Close(); return; } btnSave.Text = "保存"; } }