private void FormRetailUntreadGatherBill_Load(object sender, EventArgs e)
        {
            ControlBindDataSource cbds = new ControlBindDataSource();

            cbds.DataGridViewComboBoxColumnBindDataSource(GoodsTypeCode, "GoodsTypeCode", "GoodsTypeName", "Select * From GoodsType", "GoodsType");
            cbds.DataGridViewComboBoxColumnBindDataSource(GoodsSeriesCode, "GoodsSeriesCode", "GoodsSeriesName", "Select * From GoodsSeries", "GoodsSeries");
            cbds.DataGridViewComboBoxColumnBindDataSource(EmployeeCode2, "EmployeeCode", "EmployeeName", "Select * From Employee", "Employee");
            cbds.DataGridViewComboBoxColumnBindDataSource(OperatorCode, "OperatorCode", "OperatorName", "Select * From Operator", "Operator");
        }
Beispiel #2
0
        private void FormRetailBarterExchangeBill_Load(object sender, EventArgs e)
        {
            ControlBindDataSource cbds = new ControlBindDataSource();

            cbds.DataGridViewComboBoxColumnBindDataSource(PayTypeCode, "PayTypeCode", "PayTypeName", "Select * From PayType", "PayType");
            cbds.DataGridViewComboBoxColumnBindDataSource(BankCode, "BankCode", "BankName", "Select * From Bank", "Bank");
            cbds.DataGridViewComboBoxColumnBindDataSource(EmployeeCode2, "EmployeeCode", "EmployeeName", "Select * From Employee", "Employee");
            cbds.DataGridViewComboBoxColumnBindDataSource(OperatorCode, "OperatorCode", "OperatorName", "Select * From Operator", "Operator");
        }
        private void FormBrowseRetailCustomer_Load(object sender, EventArgs e)
        {
            formRetailOperation = (FormRetailSaleOrderBill)this.Owner;
            ControlBindDataSource cbds = new ControlBindDataSource();

            cbds.ComboBoxBindDataSource(cbxProvinceCode, "ProvinceCode", "ProvinceName", "Select * From Province", "Province");
            cbds.DataGridViewComboBoxColumnBindDataSource(ProvinceCode, "ProvinceCode", "ProvinceName", "Select * From Province", "Province");
            cbds.DataGridViewComboBoxColumnBindDataSource(CustomerType, "CustomerType", "Remark", "Select * From SysCustomerType", "SysCustomerType");
            cbxProvinceCode.SelectedIndex = -1;
        }
        private void FormRetailUntreadBaseBill_Load(object sender, EventArgs e)
        {
            ControlBindDataSource cbds = new ControlBindDataSource();

            cbds.DataGridViewComboBoxColumnBindDataSource(GoodsSeriesCode, "GoodsSeriesCode", "GoodsSeriesName", "Select * From GoodsSeries", "GoodsSeries");
            cbds.DataGridViewComboBoxColumnBindDataSource(GoodsTypeCode, "GoodsTypeCode", "GoodsTypeName", "Select * From GoodsType", "GoodsType");
            cbds.DataGridViewComboBoxColumnBindDataSource(EmployeeCode1, "EmployeeCode", "EmployeeName", "Select * From Employee", "Employee");
            cbds.DataGridViewComboBoxColumnBindDataSource(OperatorCode, "OperatorCode", "OperatorName", "Select * From Operator", "Operator");
            bsUntreadBaseBill.DataSource  = rubb.GetDataTable("UntreadBaseBill", "Where UntreadBillNo is null");
            dgvUntreadBaseBill.DataSource = bsUntreadBaseBill;
            toolStrip1.Tag = "";
        }
Beispiel #5
0
        private void FormRetailSaleConsignBill_Load(object sender, EventArgs e)
        {
            ControlBindDataSource cbds = new ControlBindDataSource();

            //销售订单
            cbds.DataGridViewComboBoxColumnBindDataSource(GoodsTypeCode1, "GoodsTypeCode", "GoodsTypeName", "Select * From GoodsType", "GoodsType");
            cbds.DataGridViewComboBoxColumnBindDataSource(GoodsSeriesCode1, "GoodsSeriesCode", "GoodsSeriesName", "Select * From GoodsSeries", "GoodsSeries");
            cbds.DataGridViewComboBoxColumnBindDataSource(ConsignCorpCode, "ConsignCorpCode", "ConsignCorpName", "Select * From ConsignCorp", "ConsignCorp");
            cbds.DataGridViewComboBoxColumnBindDataSource(EmployeeCode4, "EmployeeCode", "EmployeeName", "Select * From Employee", "Employee");
            cbds.DataGridViewComboBoxColumnBindDataSource(OperatorCode, "OperatorCode", "OperatorName", "Select * From Operator", "Operator");
            //空绑定
            bsSaleConsignBill.DataSource  = rscb.GetDataTable("SaleConsignBill", "Where SaleBillNo is null");
            dgvSaleConsignBill.DataSource = bsSaleConsignBill;
            toolStrip1.Tag = "";
        }
        private void FormRetailOperation_Load(object sender, EventArgs e)
        {
            ControlBindDataSource cbds = new ControlBindDataSource();

            //用户的基本信息
            cbds.ComboBoxBindDataSource(cbxProvinceCode, "ProvinceCode", "ProvinceName", "Select * From Province", "Province");
            cbds.ComboBoxBindDataSource(cbxCustomerId, "CustomerId", "CustomerName", "Select * From V_AgentRecord", "V_AgentRecord");
            //销售订单
            cbds.DataGridViewComboBoxColumnBindDataSource(GoodsTypeCode, "GoodsTypeCode", "GoodsTypeName", "Select * From GoodsType", "GoodsType");
            cbds.DataGridViewComboBoxColumnBindDataSource(GoodsSeriesCode, "GoodsSeriesCode", "GoodsSeriesName", "Select * From GoodsSeries", "GoodsSeries");
            cbds.DataGridViewComboBoxColumnBindDataSource(OperatorCode, "OperatorCode", "OperatorName", "Select * From Operator", "Operator");
            //空绑定
            bsSaleOrderBill.DataSource  = rsb.GetDataTable("SaleOrderBill", "Where CustomerId = 0");
            dgvSaleOrderBill.DataSource = bsSaleOrderBill;
            toolStrip1.Tag = "";
        }
Beispiel #7
0
        private void FormAgentRecord_Load(object sender, EventArgs e)
        {
            ControlBindDataSource cbds = new ControlBindDataSource();

            cbds.DataGridViewComboBoxColumnBindDataSource(ProvinceCode, "ProvinceCode", "ProvinceName", "Select * From Province", "Province");
            bsAgentRecord.DataSource  = ar.GetDataTable("Customer", "Where CustomerType = '1' ");
            dgvAgentRecord.DataSource = bsAgentRecord;
        }
        private void FormBrowseRetailSaleOrderBill_Load(object sender, EventArgs e)
        {
            if (this.Owner.GetType() == typeof(FormRetailSaleTradeBillInput))
            {
                formRetailSaleTradeBillInput = (FormRetailSaleTradeBillInput)this.Owner;
                chbIsTrade.Visible           = true;
                strJoinTag = "Inner";
            }
            if (this.Owner.GetType() == typeof(FormRetailSaleOrderBill))
            {
                lbSaleBillNo.Visible    = true;
                txtSaleBillNo.Visible   = true;
                formRetailSaleOrderBill = (FormRetailSaleOrderBill)this.Owner;
                strJoinTag = "Left";
                this.Text  = "用户和订单信息";
            }
            if (this.Owner.GetType() == typeof(FormRetailSaleConsignBillInput))
            {
                chbConsign.Visible             = true;
                formRetailSaleConsignBillInput = (FormRetailSaleConsignBillInput)this.Owner;
                strJoinTag = "Inner";
            }
            if (this.Owner.GetType() == typeof(FormRetailUntreadBaseBillInput))
            {
                txtSaleBillNo.Visible          = true;
                lbSaleBillNo.Visible           = true;
                formRetailUntreadBaseBillInput = (FormRetailUntreadBaseBillInput)this.Owner;
                strJoinTag = "Inner";
            }
            if (this.Owner.GetType() == typeof(FormRetailBarterBaseBillInput))
            {
                formRetailBarterBaseBillInput = (FormRetailBarterBaseBillInput)this.Owner;
                strJoinTag = "Left";
                this.Text  = "用户和订单信息";
            }


            ControlBindDataSource cbds = new ControlBindDataSource();

            cbds.ComboBoxBindDataSource(cbxProvinceCode, "ProvinceCode", "ProvinceName", "Select * From Province", "Province");
            cbds.DataGridViewComboBoxColumnBindDataSource(GoodsTypeCode, "GoodsTypeCode", "GoodsTypeName", "Select * From GoodsType", "GoodsType");
            cbds.DataGridViewComboBoxColumnBindDataSource(GoodsSeriesCode, "GoodsSeriesCode", "GoodsSeriesName", "Select * From GoodsSeries", "GoodsSeries");
            cbds.DataGridViewComboBoxColumnBindDataSource(EmployeeCode, "EmployeeCode", "EmployeeName", "Select * From Employee", "Employee");
            cbxProvinceCode.SelectedIndex = -1;
        }
Beispiel #9
0
        private void FormBrowseRetailUntreadBaseBillOther_Load(object sender, EventArgs e)
        {
            if (this.Owner.GetType() == typeof(FormRetailUntreadGatherBillInput))
            {
                formRetailUntreadGatherBillInput = (FormRetailUntreadGatherBillInput)this.Owner;
                chbIsGather.Visible = true;
            }
            if (this.Owner.GetType() == typeof(FormRetailUntreadRefundBillInput))
            {
                formRetailUntreadRefundBillInput = (FormRetailUntreadRefundBillInput)this.Owner;
                chbIsRefund.Visible = true;
            }
            ControlBindDataSource cbds = new ControlBindDataSource();

            cbds.BindDataSource(this);
            cbds.DataGridViewComboBoxColumnBindDataSource(GoodsTypeCode, "GoodsTypeCode", "GoodsTypeName", "Select * From GoodsType", "GoodsType");
            cbds.DataGridViewComboBoxColumnBindDataSource(GoodsSeriesCode, "GoodsSeriesCode", "GoodsSeriesName", "Select * From GoodsSeries", "GoodsSeries");
            cbds.DataGridViewComboBoxColumnBindDataSource(EmployeeCode1, "EmployeeCode", "EmployeeName", "Select * From Employee", "Employee");
            cbds.DataGridViewComboBoxColumnBindDataSource(OperatorCode, "OperatorCode", "OperatorName", "Select * From Operator", "Operator");
            useful.InitFormContros(this, null);
            dtpUntreadBillDate.Checked = false;
        }
        private void FormRetailSaleTradeBill_Load(object sender, EventArgs e)
        {
            ControlBindDataSource cbds = new ControlBindDataSource();

            //销售订单
            cbds.DataGridViewComboBoxColumnBindDataSource(PayTypeCode, "PayTypeCode", "PayTypeName", "Select * From PayType", "PayType");
            cbds.DataGridViewComboBoxColumnBindDataSource(BankCode, "BankCode", "BankName", "Select * From Bank", "Bank");
            cbds.DataGridViewComboBoxColumnBindDataSource(EmployeeCode1, "EmployeeCode", "EmployeeName", "Select * From Employee", "Employee");
            cbds.DataGridViewComboBoxColumnBindDataSource(EmployeeCode2, "EmployeeCode", "EmployeeName", "Select * From Employee", "Employee");
            cbds.DataGridViewComboBoxColumnBindDataSource(EmployeeCode3, "EmployeeCode", "EmployeeName", "Select * From Employee", "Employee");
            cbds.DataGridViewComboBoxColumnBindDataSource(OperatorCode, "OperatorCode", "OperatorName", "Select * From Operator", "Operator");
            //空绑定
            bsSaleTradeBill.DataSource  = rstb.GetDataTable("SaleTradeBill", "Where SaleBillNo is null");
            dgvSaleTradeBill.DataSource = bsSaleTradeBill;
            toolStrip1.Tag = "";
        }