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);
}
}
//-------订单
//-------交易
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("保存失败！", "软件提示");
}
}
}