private void FormBrowseRetailSaleTradeBill_Load(object sender, EventArgs e) { formRetailSaleTradeBill = (FormRetailSaleTradeBill)this.Owner; ControlBindDataSource cbds = new ControlBindDataSource(); cbds.ComboBoxBindDataSource(cbxProvinceCode, "ProvinceCode", "ProvinceName", "Select * From Province", "Province"); cbds.ComboBoxBindDataSource(cbxPayTypeCode, "PayTypeCode", "PayTypeName", "Select * From PayType", "PayType"); cbds.ComboBoxBindDataSource(cbxBankCode, "BankCode", "BankName", "Select * From Bank", "Bank"); cbxBankCode.SelectedIndex = -1; cbxPayTypeCode.SelectedIndex = -1; cbxProvinceCode.SelectedIndex = -1; }
private void FormBrowseRetailSaleConsignBill_Load(object sender, EventArgs e) { formRetailSaleConsignBill = (FormRetailSaleConsignBill)this.Owner; ControlBindDataSource cbds = new ControlBindDataSource(); cbds.ComboBoxBindDataSource(cbxConsignCorpCode, "ConsignCorpCode", "ConsignCorpName", "Select * From ConsignCorp", "ConsignCorp"); cbds.ComboBoxBindDataSource(cbxEmployeeCode4, "EmployeeCode", "EmployeeName", "Select * From Employee", "Employee"); cbds.ComboBoxBindDataSource(cbxProvinceCode, "ProvinceCode", "ProvinceName", "Select * From Province", "Province"); cbxConsignCorpCode.SelectedIndex = -1; cbxEmployeeCode4.SelectedIndex = -1; cbxProvinceCode.SelectedIndex = -1; dtpConsignDate.Value = GlobalProperty.DBTime; dtpConsignDate.Checked = false; }
private void FormRetailSaleTradeBillInput_Load(object sender, EventArgs e) { formRetailSaleTradeBill = (FormRetailSaleTradeBill)this.Owner; ControlBindDataSource cbds = new ControlBindDataSource(); cbds.ComboBoxBindDataSource(cbxBankCode, "BankCode", "BankName", "Select * From Bank", "Bank"); cbds.ComboBoxBindDataSource(cbxEmployeeCode, "EmployeeCode", "EmployeeName", "Select * From Employee", "Employee"); cbds.ComboBoxBindDataSource(cbxEmployeeCode1, "EmployeeCode", "EmployeeName", "Select * From Employee", "Employee"); cbds.ComboBoxBindDataSource(cbxEmployeeCode2, "EmployeeCode", "EmployeeName", "Select * From Employee", "Employee"); cbds.ComboBoxBindDataSource(cbxEmployeeCode3, "EmployeeCode", "EmployeeName", "Select * From Employee", "Employee"); cbds.ComboBoxBindDataSource(cbxGoodsSeriesCode, "GoodsSeriesCode", "GoodsSeriesName", "Select * From GoodsSeries", "GoodsSeries"); cbds.ComboBoxBindDataSource(cbxGoodsTypeCode, "GoodsTypeCode", "GoodsTypeName", "Select * From GoodsType", "GoodsType"); cbds.ComboBoxBindDataSource(cbxPayTypeCode, "PayTypeCode", "PayTypeName", "Select * From PayType", "PayType"); InitOrderBillControls(); InitTradeBillControls(); if (this.Tag.ToString() == "Add") { this.Text = "添加单据"; } if (this.Tag.ToString() == "Edit") { this.Text = "修改单据"; txtSaleBillNo.Text = formRetailSaleTradeBill.dgvSaleTradeBill.CurrentRow.Cells["SaleBillNo"].Value.ToString(); txtSaleBillNo.ReadOnly = true; btnBrowse.Enabled = false; SetOrderBillInfo(txtSaleBillNo.Text.Trim()); SetTradeBillInfo(txtSaleBillNo.Text.Trim()); //是否可以取消检索交易单,直接赋值来提高速度 } }
private void FormDepRegisterInput_Load(object sender, EventArgs e) { ControlBindDataSource cbds = new ControlBindDataSource(); cbds.ComboBoxBindDataSource(cbxAgentLevelCode, "AgentLevelCode", "AgentLevelName", "Select * from AgentLevel", "AgentLevel"); formDepRegister = (FormDepRegister)this.Owner; if (this.Tag.ToString() == "Add") { txtCustomerName.Text = formDepRegister.tvAgentRecord.SelectedNode.Text; cbxAgentLevelCode.SelectedIndex = -1; txtYears.Text = "1"; dtpBeginDate.Value = DateTime.Today; dtpEndDate.Value = dtpBeginDate.Value.AddYears(Convert.ToInt32(txtYears.Text)); } if (this.Tag.ToString() == "Edit") { txtCustomerName.Text = formDepRegister.tvAgentRecord.SelectedNode.Text; cbxAgentLevelCode.SelectedValue = formDepRegister.dgvDepRegister.CurrentRow.Cells["AgentLevelCode"].Value.ToString(); txtLeastMoney.Text = formDepRegister.dgvDepRegister.CurrentRow.Cells["LeastMoney"].Value.ToString(); txtDiscount.Text = formDepRegister.dgvDepRegister.CurrentRow.Cells["Discount"].Value.ToString(); txtYears.Text = formDepRegister.dgvDepRegister.CurrentRow.Cells["Years"].Value.ToString(); dtpBeginDate.Value = Convert.ToDateTime(formDepRegister.dgvDepRegister.CurrentRow.Cells["BeginDate"].Value); dtpEndDate.Value = Convert.ToDateTime(formDepRegister.dgvDepRegister.CurrentRow.Cells["EndDate"].Value); txtRemark.Text = formDepRegister.dgvDepRegister.CurrentRow.Cells["Remark"].Value.ToString(); } }
private void FormAgentRecordInput_Load(object sender, EventArgs e) { ControlBindDataSource cbds = new ControlBindDataSource(); cbds.ComboBoxBindDataSource(cbxProvinceCode, "ProvinceCode", "ProvinceName", "Select * From Province", "Province"); formAgentRecord = (FormAgentRecord)this.Owner; if (this.Tag.ToString() == "Add") { cbxProvinceCode.SelectedIndex = -1; cbIsCancel.Checked = false; //添加是默认未取消 } else { txtCustomerName.Text = formAgentRecord.dgvAgentRecord.CurrentRow.Cells["CustomerName"].Value.ToString(); txtJuridicalPerson.Text = formAgentRecord.dgvAgentRecord.CurrentRow.Cells["JuridicalPerson"].Value.ToString(); txtPhoneNumber.Text = formAgentRecord.dgvAgentRecord.CurrentRow.Cells["PhoneNumber"].Value.ToString(); cbxProvinceCode.SelectedValue = formAgentRecord.dgvAgentRecord.CurrentRow.Cells["ProvinceCode"].Value; txtAddress.Text = formAgentRecord.dgvAgentRecord.CurrentRow.Cells["Address"].Value.ToString(); txtPostalCode.Text = formAgentRecord.dgvAgentRecord.CurrentRow.Cells["PostalCode"].Value.ToString(); txtURL.Text = formAgentRecord.dgvAgentRecord.CurrentRow.Cells["URL"].Value.ToString(); txtOpenAccBankName.Text = formAgentRecord.dgvAgentRecord.CurrentRow.Cells["OpenAccBankName"].Value.ToString(); txtAccountNumber.Text = formAgentRecord.dgvAgentRecord.CurrentRow.Cells["AccountNumber"].Value.ToString(); txtCertificateNumber.Text = formAgentRecord.dgvAgentRecord.CurrentRow.Cells["CertificateNumber"].Value.ToString(); cbIsCancel.Checked = useful.GetCheckedValue(formAgentRecord.dgvAgentRecord.CurrentRow.Cells["IsCancel"].Value.ToString()); txtRemark.Text = formAgentRecord.dgvAgentRecord.CurrentRow.Cells["Remark"].Value.ToString(); } }
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 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 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 FormRetailSaleBill_Load(object sender, EventArgs e) { ControlBindDataSource cbds = new ControlBindDataSource(); cbds.ComboBoxBindDataSource(cbxBankCode, "BankCode", "BankName", "Select * From Bank", "Bank"); cbds.ComboBoxBindDataSource(cbxConsignCorpCode, "ConsignCorpCode", "ConsignCorpName", "Select * From ConsignCorp", "ConsignCorp"); cbds.ComboBoxBindDataSource(cbxEmployeeCode1, "EmployeeCode", "EmployeeName", "Select * From Employee", "Employee"); cbds.ComboBoxBindDataSource(cbxEmployeeCode2, "EmployeeCode", "EmployeeName", "Select * From Employee", "Employee"); cbds.ComboBoxBindDataSource(cbxEmployeeCode3, "EmployeeCode", "EmployeeName", "Select * From Employee", "Employee"); cbds.ComboBoxBindDataSource(cbxEmployeeCode4, "EmployeeCode", "EmployeeName", "Select * From Employee", "Employee"); cbds.ComboBoxBindDataSource(cbxEmployeeCode5, "EmployeeCode", "EmployeeName", "Select * From Employee", "Employee"); cbds.ComboBoxBindDataSource(cbxGoodsSeriesCode, "GoodsSeriesCode", "GoodsSeriesName", "Select * From GoodsSeries", "GoodsSeries"); cbds.ComboBoxBindDataSource(cbxGoodsSeriesCode1, "GoodsSeriesCode", "GoodsSeriesName", "Select * From GoodsSeries", "GoodsSeries"); cbds.ComboBoxBindDataSource(cbxGoodsTypeCode, "GoodsTypeCode", "GoodsTypeName", "Select * From GoodsType", "GoodsType"); cbds.ComboBoxBindDataSource(cbxGoodsTypeCode1, "GoodsTypeCode", "GoodsTypeName", "Select * From GoodsType", "GoodsType"); cbds.ComboBoxBindDataSource(cbxPayTypeCode, "PayTypeCode", "PayTypeName", "Select * From PayType", "PayType"); //formRetailOperation = (FormRetailSaleOrderBill)this.Owner; //txtCustomerName.Text = formRetailOperation.txtCustomerName.Text; //txtPhoneNumber.Text = formRetailOperation.txtPhoneNumber.Text; //txtPostalCode.Text = formRetailOperation.txtPostalCode.Text; //if (this.Tag.ToString() == "Add") //{ // cbxGoodsTypeCode.SelectedIndex = -1; // cbxGoodsTypeCode1.SelectedIndex = -1; // cbxGoodsSeriesCode.SelectedIndex = -1; // cbxGoodsSeriesCode1.SelectedIndex = -1; // cbxEmployeeCode1.SelectedIndex = -1; // cbxEmployeeCode2.SelectedIndex = -1; // cbxEmployeeCode3.SelectedIndex = -1; // cbxEmployeeCode4.SelectedIndex = -1; // cbxEmployeeCode5.SelectedIndex = -1; // cbxBankCode.SelectedIndex = -1; // cbxConsignCorpCode.SelectedIndex = -1; // cbxPayTypeCode.SelectedIndex = -1; // txtDiscount.Text = "1"; //} //if (this.Tag.ToString() == "Edit") //{ //} }
private void FormRetailSaleOrderBillInput_Load(object sender, EventArgs e) { ControlBindDataSource cbds = new ControlBindDataSource(); cbds.ComboBoxBindDataSource(cbxGoodsTypeCode, "GoodsTypeCode", "GoodsTypeName", "Select * From GoodsType", "GoodsType"); cbds.ComboBoxBindDataSource(cbxGoodsSeriesCode, "GoodsSeriesCode", "GoodsSeriesName", "Select * From GoodsSeries", "GoodsSeries"); cbds.ComboBoxBindDataSource(cbxEmployeeCode, "EmployeeCode", "EmployeeName", "Select * From Employee", "Employee"); formRetailSaleOrderBill = (FormRetailSaleOrderBill)this.Owner; if (formRetailSaleOrderBill.chbIsAgent.Checked) { txtCustomerName.Text = formRetailSaleOrderBill.cbxCustomerId.Text; } else { txtCustomerName.Text = formRetailSaleOrderBill.txtCustomerName.Text; } txtPhoneNumber.Text = formRetailSaleOrderBill.txtPhoneNumber.Text; txtPostalCode.Text = formRetailSaleOrderBill.txtPostalCode.Text; txtAddress.Text = formRetailSaleOrderBill.txtAddress.Text; if (this.Tag.ToString() == "Add") { dtpBillDate.Value = GlobalProperty.DBTime; dtpSignDate.Value = GlobalProperty.DBTime; cbxGoodsTypeCode.SelectedIndex = -1; cbxGoodsSeriesCode.SelectedIndex = -1; cbxEmployeeCode.SelectedIndex = -1; txtDiscount.Text = "1"; //若是代理商的话,默认值为代理的折扣系数。 txtSaleBillNo.Text = useful.BuildCode("SaleOrderBill", "Where OperatorCode = '" + GlobalProperty.OperatorCode + "'", "SaleBillNo", "XS" + GlobalProperty.DBTime.Year.ToString(), 7); } if (this.Tag.ToString() == "Edit") { if (GlobalProperty.OperatorCode != formRetailSaleOrderBill.dgvSaleOrderBill.CurrentRow.Cells["OperatorCode"].Value.ToString()) { btnSave.Enabled = false; //非本人录入的记录,不允许修改。 } //chbIsAmendBillNo.Enabled = false; txtSaleBillNo.Text = formRetailSaleOrderBill.dgvSaleOrderBill.CurrentRow.Cells["SaleBillNo"].Value.ToString(); dtpBillDate.Value = Convert.ToDateTime(formRetailSaleOrderBill.dgvSaleOrderBill.CurrentRow.Cells["BillDate"].Value); cbxGoodsTypeCode.SelectedValue = formRetailSaleOrderBill.dgvSaleOrderBill.CurrentRow.Cells["GoodsTypeCode"].Value; cbxGoodsSeriesCode.SelectedValue = formRetailSaleOrderBill.dgvSaleOrderBill.CurrentRow.Cells["GoodsSeriesCode"].Value; txtUnitPrice.Text = formRetailSaleOrderBill.dgvSaleOrderBill.CurrentRow.Cells["UnitPrice"].Value.ToString(); txtDiscount.Text = formRetailSaleOrderBill.dgvSaleOrderBill.CurrentRow.Cells["Discount"].Value.ToString(); txtQuantity.Text = formRetailSaleOrderBill.dgvSaleOrderBill.CurrentRow.Cells["Quantity"].Value.ToString(); if (formRetailSaleOrderBill.dgvSaleOrderBill.CurrentRow.Cells["IsNeedInvoice"].Value.ToString() == "1") //需要发票 { rbIsNeedInvoice1.Checked = true; if (formRetailSaleOrderBill.dgvSaleOrderBill.CurrentRow.Cells["WriteOffType"].Value.ToString() == "1") //个人 { chbWriteOffType1.Checked = true; txtWriteOffName1.Text = formRetailSaleOrderBill.dgvSaleOrderBill.CurrentRow.Cells["WriteOffName"].Value.ToString(); txtCertificateNumber1.Text = formRetailSaleOrderBill.dgvSaleOrderBill.CurrentRow.Cells["CertificateNumber"].Value.ToString(); } else //单位 { chbWriteOffType2.Checked = true; txtWriteOffName2.Text = formRetailSaleOrderBill.dgvSaleOrderBill.CurrentRow.Cells["WriteOffName"].Value.ToString(); txtCertificateNumber2.Text = formRetailSaleOrderBill.dgvSaleOrderBill.CurrentRow.Cells["CertificateNumber"].Value.ToString(); } } else //不需要发票 { rbIsNeedInvoice0.Checked = true; } cbxEmployeeCode.SelectedValue = formRetailSaleOrderBill.dgvSaleOrderBill.CurrentRow.Cells["EmployeeCode"].Value; if (formRetailSaleOrderBill.dgvSaleOrderBill.CurrentRow.Cells["SignDate"].Value == DBNull.Value) { dtpSignDate.Checked = false; } else { dtpSignDate.Value = Convert.ToDateTime(formRetailSaleOrderBill.dgvSaleOrderBill.CurrentRow.Cells["SignDate"].Value); } txtRemark.Text = formRetailSaleOrderBill.dgvSaleOrderBill.CurrentRow.Cells["Remark"].Value.ToString(); } }