public void GetBarterExchangeInfo(string strBarterBillNo)
{
string strSql = null;
DataTable dt = null;
strSql = "Select BarterExchangeBill.* From BarterExchangeBill Where BarterBillNo = '" + strBarterBillNo + "'";
dt = rbcb.GetDataTable(strSql);
if (dt.Rows.Count > 0)
{
cbxPayTypeCode.SelectedValue = dt.Rows[0]["PayTypeCode"];
txtTradeMoney.Text = dt.Rows[0]["TradeMoney"].ToString();
cbxBankCode.SelectedValue = dt.Rows[0]["BankCode"];
txtTradeBillNo.Text = dt.Rows[0]["TradeBillNo"].ToString();
dtpTradeDate.Value = Convert.ToDateTime(dt.Rows[0]["TradeDate"]); //交易日期不许为空！
cbxEmployeeCode2.SelectedValue = dt.Rows[0]["EmployeeCode2"];
if (dt.Rows[0]["SignDate2"] == DBNull.Value) //签字日期可以为空
{
dtpSignDate2.Checked = false;
}
else
{
dtpSignDate2.Value = Convert.ToDateTime(dt.Rows[0]["SignDate2"]);
}
}
}
private void btnQuery_Click(object sender, EventArgs e)
{
string strSql = String.Empty; //声明string变量并初始化
RetailBarterConsignBill rbcb = new RetailBarterConsignBill();
if (!chbIsCDNo.Checked) //没有选中光盘号查询
{
strSql = rbcb.BarterConsignBillSql + GetQueryInfoString(); //设置基本的Sql语句
}
if (chbIsCDNo.Checked) //选中光盘号查询
{
if (String.IsNullOrEmpty(txtCDNo.Text.Trim()))
{
MessageBox.Show("请输入光盘号！", "软件提示");
txtCDNo.Focus();
return;
}
strSql = rbcb.BarterConsignBill_CDNo_Sql + " and BarterConsignCDRecord.CDNo = '" + txtCDNo.Text.Trim() + "'";
}
formRetailBarterConsignBill.dgvBarterConsignBill.DataSource = rbcb.GetDataTable(strSql);
this.Close();
}