private void SetTradeBillInfo(string strSaleBillNo) { string strSql = null; DataTable dt = null; RetailSaleTradeBill tstb = new RetailSaleTradeBill(); strSql = "Select * From SaleTradeBill Where SaleBillNo = '" + strSaleBillNo + "'"; dt = tstb.GetDataTable(strSql); if (dt.Rows.Count > 0) { if (this.Tag.ToString() == "Add") { SetTradeBillControlsState(false); } //赋值 txtReceiptMoney.Text = dt.Rows[0]["ReceiptMoney"].ToString(); txtTradeBillNo.Text = dt.Rows[0]["TradeBillNo"].ToString(); if (dt.Rows[0]["SignDate1"] == DBNull.Value) { dtpSignDate1.Checked = false; } else { dtpSignDate1.Value = Convert.ToDateTime(dt.Rows[0]["SignDate1"]); } if (dt.Rows[0]["SignDate2"] == DBNull.Value) { dtpSignDate2.Checked = false; } else { dtpSignDate2.Value = Convert.ToDateTime(dt.Rows[0]["SignDate2"]); } if (dt.Rows[0]["SignDate3"] == DBNull.Value) { dtpSignDate3.Checked = false; } else { dtpSignDate3.Value = Convert.ToDateTime(dt.Rows[0]["SignDate3"]); } dtpSaleDate.Value = Convert.ToDateTime(dt.Rows[0]["SaleDate"]); cbxBankCode.SelectedValue = dt.Rows[0]["BankCode"]; cbxPayTypeCode.SelectedValue = dt.Rows[0]["PayTypeCode"]; cbxEmployeeCode1.SelectedValue = dt.Rows[0]["EmployeeCode1"]; cbxEmployeeCode2.SelectedValue = dt.Rows[0]["EmployeeCode2"]; cbxEmployeeCode3.SelectedValue = dt.Rows[0]["EmployeeCode3"]; txtRemark1.Text = dt.Rows[0]["Remark1"].ToString(); } else { SetTradeBillControlsState(true); } }
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 void RetrieveTradeBillInfo(string strSaleBillNo) { string strSql = null; DataTable dt = null; RetailSaleTradeBill tstb = new RetailSaleTradeBill(); strSql = "Select * From SaleTradeBill Where SaleBillNo = '" + strSaleBillNo + "'"; dt = tstb.GetDataTable(strSql); if (dt.Rows.Count > 0) { SetTradeBillInfo(dt.Rows[0]); } else { MessageBox.Show("该订单未录入交易单!", "软件提示"); txtSaleBillNo.Focus(); return; } }
private void btnQuery_Click(object sender, EventArgs e) { RetailSaleTradeBill rstb = new RetailSaleTradeBill(); string strSql = null; if (!chbIsCDNo.Checked) //没有选中光盘号查询 { strSql = "Select SaleTradeBill.* From SaleTradeBill,Customer,SaleOrderBill " + "Where SaleTradeBill.SaleBillNo = SaleOrderBill.SaleBillNo and SaleOrderBill.CustomerId = Customer.CustomerId "; if (!String.IsNullOrEmpty(txtCustomerName.Text.Trim())) { strSql += " and CustomerName like '%" + txtCustomerName.Text.Trim() + "%'"; } if (!(cbxProvinceCode.SelectedValue == null)) { strSql += " and ProvinceCode = '" + cbxProvinceCode.SelectedValue.ToString() + "'"; } if (!String.IsNullOrEmpty(txtAddress.Text.Trim())) { strSql += " and Address like '%" + txtAddress.Text.Trim() + "%'"; } if (!String.IsNullOrEmpty(txtPhoneNumber.Text.Trim())) { strSql += " and PhoneNumber like '%" + txtPhoneNumber.Text.Trim() + "%'"; } if (dtpSaleDate.Checked) { strSql += " and SaleDate = '" + dtpSaleDate.Value.Date + "'"; } if (!String.IsNullOrEmpty(txtSaleBillNo.Text.Trim())) { strSql += " and SaleOrderBill.SaleBillNo like '%" + txtSaleBillNo.Text.Trim() + "'"; } if (!(cbxBankCode.SelectedValue == null)) { strSql += " and SaleTradeBill.BankCode = '" + cbxBankCode.SelectedValue.ToString() + "'"; } if (!(cbxPayTypeCode.SelectedValue == null)) { strSql += " and SaleTradeBill.PayTypeCode = '" + cbxPayTypeCode.SelectedValue.ToString() + "'"; } if (!String.IsNullOrEmpty(txtTradeBillNo.Text.Trim())) { strSql += " and SaleTradeBill.TradeBillNo like '%" + txtTradeBillNo.Text.Trim() + "'"; } } if (chbIsCDNo.Checked) //选中光盘号查询 { if (String.IsNullOrEmpty(txtCDNo.Text.Trim())) { MessageBox.Show("请输入光盘号!", "软件提示"); txtCDNo.Focus(); return; } strSql = "Select SaleTradeBill.* From SaleCDRecord,SaleConsignBill,SaleTradeBill " + "Where SaleCDRecord.SaleConsignBillId = SaleConsignBill.Id and SaleConsignBill.SaleBillNo = SaleTradeBill.SaleBillNo and SaleCDRecord.CDNo = '" + txtCDNo.Text.Trim() + "'"; } formRetailSaleTradeBill.bsSaleTradeBill.DataSource = rstb.GetDataTable(strSql); formRetailSaleTradeBill.dgvSaleTradeBill.DataSource = formRetailSaleTradeBill.bsSaleTradeBill; this.Close(); }
private void btnSave_Click(object sender, EventArgs e) { RetailSaleTradeBill rstb = new RetailSaleTradeBill(); if (String.IsNullOrEmpty(txtCustomerName.Text.Trim())) { MessageBox.Show("销售订单信息不许为空!", "软件提示"); txtSaleBillNo.Focus(); return; } if (cbxPayTypeCode.SelectedValue == null) { MessageBox.Show("交易方式不许为空!", "软件提示"); cbxPayTypeCode.Focus(); return; } if (cbxPayTypeCode.SelectedValue.ToString() == "02") //银行存款 { if (cbxBankCode.SelectedValue == null) { MessageBox.Show("预存银行不许为空!", "软件提示"); cbxBankCode.Focus(); return; } } if (String.IsNullOrEmpty(txtTradeBillNo.Text.Trim())) { MessageBox.Show("交易单号不许为空!", "软件提示"); txtTradeBillNo.Focus(); return; } if (String.IsNullOrEmpty(txtReceiptMoney.Text.Trim())) { MessageBox.Show("实收金额不许为空!", "软件提示"); txtReceiptMoney.Focus(); return; } else { if (Convert.ToDecimal(txtReceiptMoney.Text.Trim()) == 0) { MessageBox.Show("实收金额不许为零!", "软件提示"); txtReceiptMoney.Focus(); return; } } if (cbxEmployeeCode1.SelectedValue == null) { MessageBox.Show("查款人不许为空!", "软件提示"); cbxEmployeeCode1.Focus(); return; } if (this.Tag.ToString() == "Add") { DataGridViewRow dgvr = rstb.AddDataGridViewRow(formRetailSaleTradeBill.dgvSaleTradeBill, formRetailSaleTradeBill.bsSaleTradeBill); dgvr.Cells["SaleBillNo"].Value = txtSaleBillNo.Text.Trim(); dgvr.Cells["PayTypeCode"].Value = cbxPayTypeCode.SelectedValue; dgvr.Cells["BankCode"].Value = cbxBankCode.SelectedValue; dgvr.Cells["SaleDate"].Value = dtpSaleDate.Value.Date; dgvr.Cells["TradeBillNo"].Value = txtTradeBillNo.Text.Trim(); dgvr.Cells["ReceiptMoney"].Value = Convert.ToDecimal(txtReceiptMoney.Text.Trim()); dgvr.Cells["EmployeeCode1"].Value = cbxEmployeeCode1.SelectedValue; if (dtpSignDate1.Checked == false) { dgvr.Cells["SignDate1"].Value = DBNull.Value; } else { dgvr.Cells["SignDate1"].Value = dtpSignDate1.Value.Date; } dgvr.Cells["EmployeeCode2"].Value = cbxEmployeeCode2.SelectedValue; if (dtpSignDate2.Checked == false) { dgvr.Cells["SignDate2"].Value = DBNull.Value; } else { dgvr.Cells["SignDate2"].Value = dtpSignDate2.Value.Date; } dgvr.Cells["EmployeeCode3"].Value = cbxEmployeeCode3.SelectedValue; if (dtpSignDate3.Checked == false) { dgvr.Cells["SignDate3"].Value = DBNull.Value; } else { dgvr.Cells["SignDate3"].Value = dtpSignDate3.Value.Date; } dgvr.Cells["Remark1"].Value = txtRemark1.Text.Trim(); dgvr.Cells["OperatorCode"].Value = GlobalProperty.OperatorCode; dgvr.Cells["AppendDate"].Value = GlobalProperty.DBTime.Date; if (rstb.Insert(formRetailSaleTradeBill.bsSaleTradeBill)) { MessageBox.Show("保存成功!", "软件提示"); formRetailSaleTradeBill.bsSaleTradeBill.DataSource = rstb.GetDataTable("SaleTradeBill", "Where OperatorCode = '" + GlobalProperty.OperatorCode + "' and AppendDate = '" + GlobalProperty.DBTime.Date + "'"); formRetailSaleTradeBill.dgvSaleTradeBill.DataSource = formRetailSaleTradeBill.bsSaleTradeBill; InitOrderBillControls(); InitTradeBillControls(); txtSaleBillNo.Text = ""; } else { MessageBox.Show("保存失败!", "软件提示"); } } if (this.Tag.ToString() == "Edit") { DataGridViewRow dgvr = formRetailSaleTradeBill.dgvSaleTradeBill.CurrentRow; dgvr.Cells["PayTypeCode"].Value = cbxPayTypeCode.SelectedValue; dgvr.Cells["BankCode"].Value = cbxBankCode.SelectedValue; dgvr.Cells["SaleDate"].Value = dtpSaleDate.Value.Date; dgvr.Cells["TradeBillNo"].Value = txtTradeBillNo.Text.Trim(); dgvr.Cells["ReceiptMoney"].Value = Convert.ToDecimal(txtReceiptMoney.Text.Trim()); dgvr.Cells["EmployeeCode1"].Value = cbxEmployeeCode1.SelectedValue; if (dtpSignDate1.Checked == false) { dgvr.Cells["SignDate1"].Value = DBNull.Value; } else { dgvr.Cells["SignDate1"].Value = dtpSignDate1.Value.Date; } dgvr.Cells["EmployeeCode2"].Value = cbxEmployeeCode2.SelectedValue; if (dtpSignDate2.Checked == false) { dgvr.Cells["SignDate2"].Value = DBNull.Value; } else { dgvr.Cells["SignDate2"].Value = dtpSignDate2.Value.Date; } dgvr.Cells["EmployeeCode3"].Value = cbxEmployeeCode3.SelectedValue; if (dtpSignDate3.Checked == false) { dgvr.Cells["SignDate3"].Value = DBNull.Value; } else { dgvr.Cells["SignDate3"].Value = dtpSignDate3.Value.Date; } dgvr.Cells["Remark1"].Value = txtRemark1.Text.Trim(); if (rstb.Update(formRetailSaleTradeBill.bsSaleTradeBill)) { MessageBox.Show("保存成功!", "软件提示"); this.Close(); } else { MessageBox.Show("保存失败!", "软件提示"); } } }