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