Example #1
0
        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;
        }
Example #3
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 = "保存";
            }
        }