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 btnQuery_Click(object sender, EventArgs e)
{
DifferentMonth.DifferentMonthDataTable dmdt = null;
ControlBindDataSource cbds = new ControlBindDataSource();
//判断月份是否合理
if (dtpStartMonth.Value >= dtpEndMonth.Value)
{
MessageBox.Show("开始月份不许大于或等于结束月份!", "软件提示");
return;
}
string strWhere = " Where 1 = 1 ";
dmdt = this.GetDifferentMonthInfo(strWhere) as DifferentMonth.DifferentMonthDataTable;
ReportDocument rd = cbds.CrystalReports(@"\UI\ChartAnalyse\CryReprot\CryDifferentMonthSaleAnalyse.rpt", dmdt);
crvCollect.ReportSource = rd;
TextObject txtNumValue = rd.ReportDefinition.ReportObjects["txtNumValue"] as TextObject;
if (rbQuantity.Checked)
{
txtNumValue.Text = "销售数量(套)";
}
else
{
txtNumValue.Text = "销售金额(元)";
}
TextObject toDateRange = rd.ReportDefinition.ReportObjects["itoDateRange"] as TextObject;
toDateRange.Text = "( " + dtpStartMonth.Value.Year.ToString() + "-" + dtpStartMonth.Value.Month.ToString() + " 至 "
+ dtpEndMonth.Value.Year.ToString() + "-" + dtpEndMonth.Value.Month.ToString() + " )";
}
private void FormRetailUntreadBaseBillInput_Load(object sender, EventArgs e)
{
ControlBindDataSource cbds = new ControlBindDataSource();
cbds.BindDataSource(this);
useful.InitFormContros(groupBox1, null);
formRetailUntreadBaseBill = (FormRetailUntreadBaseBill)this.Owner;
if (this.Tag.ToString() == "Add")
{
this.Text = "添加单据";
btnCD.Enabled = false;
txtUntreadBillNo.Text = useful.BuildCode("UntreadBaseBill", "Where OperatorCode = '" + GlobalProperty.OperatorCode + "'", "UntreadBillNo", "TH" + GlobalProperty.DBTime.Year.ToString(), 7);
}
if (this.Tag.ToString() == "Edit")
{
this.Text = "修改单据";
btnCD.Enabled = true;
//chbIsAmendBillNo.Enabled = false;
txtSaleBillNo.Text = formRetailUntreadBaseBill.dgvUntreadBaseBill.CurrentRow.Cells["SaleBillNo"].Value.ToString();
txtUntreadBillNo.Text = formRetailUntreadBaseBill.dgvUntreadBaseBill.CurrentRow.Cells["UntreadBillNo"].Value.ToString();
RetrieveOrderBillInfo(txtSaleBillNo.Text.Trim());
GetUntreadBillInfo(txtSaleBillNo.Text.Trim());
txtSaleBillNo.ReadOnly = true;
txtSaleBillNo.Enabled = false;
btnBrowse.Enabled = 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 btnQuery_Click(object sender, EventArgs e)
{
AllKinds.AllKindsDataTable akdt = null;
ControlBindDataSource cbds = new ControlBindDataSource();
//判断日期是否合理
if (dtpStartDate.Value.Date > dtpEndDate.Value.Date)
{
MessageBox.Show("开始日期不许大于结束日期!", "软件提示");
return;
}
string strWhere = " Where 1 = 1 ";
akdt = this.GetAllKindsInfo(strWhere) as AllKinds.AllKindsDataTable;
ReportDocument rd = cbds.CrystalReports(@"\UI\ChartAnalyse\CryReprot\CryAllkindsSometimeSaleAnalyse.rpt", akdt);
crvCollect.ReportSource = rd;
TextObject txtNumValue = rd.ReportDefinition.ReportObjects["txtNumValue"] as TextObject;
if (rbQuantity.Checked)
{
txtNumValue.Text = "销售数量(套)";
}
else
{
txtNumValue.Text = "销售金额(元)";
}
TextObject toDateRange = rd.ReportDefinition.ReportObjects["itoDateRange"] as TextObject;
toDateRange.Text = "( " + dtpStartDate.Value.Year.ToString() + "-" + dtpStartDate.Value.Month.ToString() + "-" + dtpStartDate.Value.Day.ToString() + " 至 "
+ dtpEndDate.Value.Year.ToString() + "-" + dtpEndDate.Value.Month.ToString() + "-" + dtpEndDate.Value.Day.ToString() + " )";
}
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 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 btnQuery_Click(object sender, EventArgs e)
{
string strWhere = String.Empty;
OperationCollect.OperationCollectDataTable dtCollect = null;
ControlBindDataSource cbds = new ControlBindDataSource();
//判断日期是否合理
if (dtpStartDate.Value.Date > dtpEndDate.Value.Date)
{
MessageBox.Show("开始日期不许大于结束日期!", "软件提示");
return;
}
//判断是否选择用户类型
if (!chbAgent.Checked && !chbNoAgent.Checked)
{
MessageBox.Show("请选择一种用户类型!", "软件提示");
return;
}
//只选择代理
if (chbAgent.Checked && !chbNoAgent.Checked)
{
strWhere = " Where Customer.CustomerType = '1' ";
}
//只选择普通
if (!chbAgent.Checked && chbNoAgent.Checked)
{
strWhere = " Where (Customer.CustomerType = '2' or Customer.CustomerType = '3') ";
}
//同时选中代理和普通
if (chbAgent.Checked && chbNoAgent.Checked)
{
strWhere = " Where (Customer.CustomerType = '1' or Customer.CustomerType = '2' or Customer.CustomerType = '3') ";
}
dtCollect = this.GetCollectInfo(strWhere) as OperationCollect.OperationCollectDataTable;
ReportDocument rd = cbds.CrystalReports(@"\UI\DataReport\CryReprot\CryOperationCollect.rpt", dtCollect);
crvCollect.ReportSource = rd;
TextObject toDateRange = rd.ReportDefinition.ReportObjects["itoDateRange"] as TextObject;
TextObject toPrintDate = rd.ReportDefinition.ReportObjects["itoPrintDate"] as TextObject;
TextObject toTile = rd.ReportDefinition.ReportObjects["itoTitle"] as TextObject;
toDateRange.Text = "( " + dtpStartDate.Value.Year.ToString() + "-" + dtpStartDate.Value.Month.ToString() + "-" + dtpStartDate.Value.Day.ToString() + " 至 "
+ dtpEndDate.Value.Year.ToString() + "-" + dtpEndDate.Value.Month.ToString() + "-" + dtpEndDate.Value.Day.ToString() + " )";
toPrintDate.Text = GlobalProperty.DBTime.Date.ToString("yyy-MM-dd");
foreach (Control con in gbCollectType.Controls)
{
if (con.GetType() == typeof(RadioButton))
{
if (((RadioButton)con).Checked)
{
toTile.Text = "编程词典" + ((RadioButton)con).Text + "表";
}
}
}
}
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 FormBrowseRetailUntreadRefundBill_Load(object sender, EventArgs e)
{
formRetailUntreadRefundBill = (FormRetailUntreadRefundBill)this.Owner;
ControlBindDataSource cbds = new ControlBindDataSource();
cbds.BindDataSource(this);
useful.InitFormContros(this, null);
dtpAppendDate.Checked = false;
dtpUntreadMoneyDate.Checked = false;
}
private void FormBrowseRetailBarterExchangeBill_Load(object sender, EventArgs e)
{
formRetailBarterExchangeBill = (FormRetailBarterExchangeBill)this.Owner;
ControlBindDataSource cbds = new ControlBindDataSource();
cbds.BindDataSource(this);
useful.InitFormContros(this, null);
dtpAppendDate.Checked = false;
dtpTradeDate.Checked = false;
}
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 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 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 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 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 = "";
}
public fmStudent()
{
InitializeComponent();
this.SetDefaultSetting();
cbxCourse.SetDefaultSetting();
cbxGrade.SetDefaultSetting();
cbxYear.SetDefaultSetting();
cbxStates.SetDefaultSetting();
ControlBindDataSource.BindCourse(cbxCourse);
ControlBindDataSource.BindGrade(cbxGrade);
ControlBindDataSource.BindYear(cbxYear, false, 1);
ControlBindDataSource.BindStates(cbxStates);
txtMoney.KeyPress += new KeyPressEventHandler(EventHelper.TextBox_FilterString_KeyPress);
}
private void Form1_Load(object sender, EventArgs e)
{
this.SetDefaultSetting();
this.ShowInTaskbar = true;
cbxCourse.SetDefaultSetting();
cbxGrade.SetDefaultSetting();
cbxYear.SetDefaultSetting();
cbxStates.SetDefaultSetting();
dataGridView1.SetDefaultSetting();
dataGridView1.BackgroundColor = System.Drawing.SystemColors.Control;
ControlBindDataSource.BindCourse(cbxCourse);
ControlBindDataSource.BindGrade(cbxGrade);
ControlBindDataSource.BindYear(cbxYear);
ControlBindDataSource.BindStates(cbxStates);
BindRegisterList();
}
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 FormRetailBarterExchangeBillInput_Load(object sender, EventArgs e)
{
formRetailBarterExchangeBill = (FormRetailBarterExchangeBill)this.Owner;
ControlBindDataSource cbds = new ControlBindDataSource();
cbds.BindDataSource(this);
useful.InitFormContros(this, null);
if (this.Tag.ToString() == "Add")
{
this.Text = "添加单据";
}
if (this.Tag.ToString() == "Edit")
{
this.Text = "修改单据";
txtBarterBillNo.Text = formRetailBarterExchangeBill.dgvBarterExchangeBill.CurrentRow.Cells["BarterBillNo"].Value.ToString();
RetrieveBarterBaseInfo(txtBarterBillNo.Text);
GetBarterExchangeInfo(txtBarterBillNo.Text);
txtBarterBillNo.Enabled = false;
btnBrowse.Enabled = false;
}
}
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 FormRetailBarterBaseBillInput_Load(object sender, EventArgs e)
{
ControlBindDataSource cbds = new ControlBindDataSource();
cbds.BindDataSource(this);
useful.InitFormContros(groupBox1, null);
formRetailBarterBaseBill = (FormRetailBarterBaseBill)this.Owner;
if (this.Tag.ToString() == "Add")
{
btnCD.Enabled = false;
this.Text = "添加单据";
txtBarterBillNo.Text = useful.BuildCode("BarterBaseBill", "Where OperatorCode = '" + GlobalProperty.OperatorCode + "'", "BarterBillNo", "HH" + GlobalProperty.DBTime.Year.ToString(), 7);
}
else
{
btnCD.Enabled = true;
this.Text = "修改单据";
//chbIsAmendBillNo.Enabled = false;
txtBarterBillNo.Text = formRetailBarterBaseBill.dgvBarterBaseBill.CurrentRow.Cells["BarterBillNo"].Value.ToString();
GetBarterBaseBillInfo(txtBarterBillNo.Text);
}
}
private void FormRetailUntreadGatherBillInput_Load(object sender, EventArgs e)
{
formRetailUntreadGatherBill = (FormRetailUntreadGatherBill)this.Owner;
ControlBindDataSource cbds = new ControlBindDataSource();
cbds.BindDataSource(this);
if (this.Tag.ToString() == "Add")
{
this.Text = "添加单据";
useful.InitFormContros(this, null);
}
if (this.Tag.ToString() == "Edit")
{
this.Text = "修改单据";
useful.SetControlsState(groupBox1, false);
txtUntreadBillNo.Enabled = false;
btnBrowse.Enabled = false;
txtUntreadBillNo.Text = formRetailUntreadGatherBill.dgvUntreadGatherBill.CurrentRow.Cells["UntreadBillNo"].Value.ToString();
RetrieveUntreadBaseBillInfo(txtUntreadBillNo.Text.Trim());
GetUntreadGatherBillInfo(txtUntreadBillNo.Text.Trim());
}
}
private void FormRetailSaleConsignBillInput_Load(object sender, EventArgs e)
{
formRetailSaleConsignBill = (FormRetailSaleConsignBill)this.Owner;
ControlBindDataSource cbds = new ControlBindDataSource();
//cbds.BindDataSource(gbOrder);
//cbds.BindDataSource(gbTrade);
//cbds.BindDataSource(gbConsign);
cbds.BindDataSource(this);
useful.InitFormContros(this, null);
//useful.InitFormContros(gbOrder);
//useful.InitFormContros(gbTrade);
//useful.InitFormContros(gbConsign);
if (this.Tag.ToString() == "Add")
{
this.Text = "添加单据";
btnCD.Enabled = false;
}
if (this.Tag.ToString() == "Edit")
{
this.Text = "修改单据";
m_SaleConsignBillId = Convert.ToInt32(formRetailSaleConsignBill.dgvSaleConsignBill.CurrentRow.Cells["Id"].Value);
btnCD.Enabled = true;
txtSaleBillNo.Text = formRetailSaleConsignBill.dgvSaleConsignBill.CurrentRow.Cells["SaleBillNo"].Value.ToString();
txtSaleBillNo.ReadOnly = true;
btnBrowse.Enabled = false;
//检索并设置订货单信息
RetrieveOrderBillInfo(txtSaleBillNo.Text.Trim());
//检索并设置交易单信息
RetrieveTradeBillInfo(txtSaleBillNo.Text.Trim());
//设置发货单信息
DataTable dt = formRetailSaleConsignBill.bsSaleConsignBill.DataSource as DataTable;
Int32 intId = Convert.ToInt32(formRetailSaleConsignBill.dgvSaleConsignBill.CurrentRow.Cells["Id"].Value);
DataRow dr = dt.AsEnumerable().FirstOrDefault(itm => itm.Field <int>("Id") == intId);
SetConsignBillInfo(dr);
}
}
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();
}
}
private void btnQuery_Click(object sender, EventArgs e)
{
string strCondition = null;
string strWhere = null;
string strReportFileName = null;
string strTableName = null;
ControlBindDataSource cbds = new ControlBindDataSource();
//判断日期是否合理
if (dtpStartDate.Value.Date > dtpEndDate.Value.Date)
{
MessageBox.Show("开始日期不许大于结束日期!", "软件提示");
return;
}
//判断是否选择用户类型
if (!chbAgent.Checked && !chbNoAgent.Checked)
{
MessageBox.Show("请选择一种用户类型!", "软件提示");
return;
}
//只选择代理
if (chbAgent.Checked && !chbNoAgent.Checked)
{
strWhere = " Where Customer.CustomerType = '1' ";
}
//只选择普通
if (!chbAgent.Checked && chbNoAgent.Checked)
{
strWhere = " Where (Customer.CustomerType = '2' or Customer.CustomerType = '3') ";
}
//同时选中代理和普通
if (chbAgent.Checked && chbNoAgent.Checked)
{
strWhere = " Where (Customer.CustomerType = '1' or Customer.CustomerType = '2' or Customer.CustomerType = '3') ";
}
//销售
if (rbSale.Checked)
{
strCondition = "Select SaleOrderBill.* From SaleOrderBill,Customer " + strWhere + " and SaleOrderBill.CustomerId = Customer.CustomerId and SaleOrderBill.SaleBillNo in (Select SaleTradeBill.SaleBillNo From SaleTradeBill) ";
if (dtpStartDate.Checked)
{
strCondition += " and SaleOrderBill.BillDate >= '" + dtpStartDate.Value.ToString("yyyy-MM-dd") + "' ";
}
if (dtpStartDate.Checked)
{
strCondition += " and SaleOrderBill.BillDate <= '" + dtpEndDate.Value.ToString("yyyy-MM-dd") + "' ";
}
strReportFileName = "CrySaleList.rpt";
strTableName = "SaleOrderBill";
}
//退货
if (rbUntread.Checked)
{
strCondition = "Select UntreadBaseBill.* From UntreadBaseBill,Customer " + strWhere + " and UntreadBaseBill.CustomerId = Customer.CustomerId ";
if (dtpStartDate.Checked)
{
strCondition += " and UntreadBaseBill.UntreadBillDate >= '" + dtpStartDate.Value.ToString("yyyy-MM-dd") + "' ";
}
if (dtpStartDate.Checked)
{
strCondition += " and UntreadBaseBill.UntreadBillDate <= '" + dtpEndDate.Value.ToString("yyyy-MM-dd") + "' ";
}
strReportFileName = "CryUntreadList.rpt";
strTableName = "UntreadBaseBill";
}
//调货
if (rbBarter.Checked)
{
strCondition = "Select BarterBaseBill.* From BarterBaseBill,Customer " + strWhere + " and BarterBaseBill.CustomerId = Customer.CustomerId ";
if (dtpStartDate.Checked)
{
strCondition += " and BarterBaseBill.BarterBillDate >= '" + dtpStartDate.Value.ToString("yyyy-MM-dd") + "' ";
}
if (dtpStartDate.Checked)
{
strCondition += " and BarterBaseBill.BarterBillDate <= '" + dtpEndDate.Value.ToString("yyyy-MM-dd") + "' ";
}
strReportFileName = "CryBarterList.rpt";
strTableName = "BarterBaseBill";
}
ReportDocument rd = cbds.CrystalReports(@"\UI\DataReport\CryReprot\" + strReportFileName, strCondition, strTableName);
crvList.ReportSource = rd; //显示数据
TextObject toDateRange = rd.ReportDefinition.ReportObjects["itoDateRange"] as TextObject;
TextObject toPrintDate = rd.ReportDefinition.ReportObjects["itoPrintDate"] as TextObject;
toDateRange.Text = "( " + dtpStartDate.Value.Year.ToString() + "-" + dtpStartDate.Value.Month.ToString() + "-" + dtpStartDate.Value.Day.ToString() + " 至 "
+ dtpEndDate.Value.Year.ToString() + "-" + dtpEndDate.Value.Month.ToString() + "-" + dtpEndDate.Value.Day.ToString() + " )";
toPrintDate.Text = GlobalProperty.DBTime.Date.ToString("yyy-MM-dd");
}
