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"); }
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 = ""; }
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 = ""; }
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; }
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 = ""; }