public override int Query( )
{
strWhere = "1=1 and a.process='采购流程1' ";
if (!string.IsNullOrEmpty(comfishId.Text.Trim( )))
{
strWhere = strWhere + " and b.fishId='" + comfishId.Text + "'";
}
if (!string.IsNullOrEmpty(txtCodeNum.Text.Trim( )))
{
strWhere = strWhere + " and a.codeNum like '%" + txtCodeNum.Text + "%'";
}
if (!string.IsNullOrEmpty(txtCodeNumContract.Text.Trim( )))
{
strWhere = strWhere + " and a.codeNumContract like '%" + txtCodeNumContract.Text + "%'";
}
if (!string.IsNullOrEmpty(cmbCodeNumUser.Text.Trim( )))
{
strWhere = strWhere + " and a.createUser='******'";
}
if (!string.IsNullOrEmpty(txtsupplier.Text.Trim()))
{
strWhere = strWhere + " and a.supplier like'%" + txtsupplier.Text + "%'";
}
if (!string.IsNullOrEmpty(dtpStart.Text.Trim()))
{
strWhere = strWhere + " AND a.signDate>='" + dtpStart.Text + "'";
}
if (!string.IsNullOrEmpty(dtpEnd.Text.Trim()))
{
strWhere = strWhere + " AND a.Signdate<='" + dtpEnd.Text + "'";
}
tableView = _bll.getTableView(strWhere);
dataGridView1.Rows.Clear( );
if (tableView == null || tableView.Rows.Count < 1)
{
return(0);
}
tableErrorFK = _bll.getTableErrorForFK( );
setValue( );
return(base.Query( ));
}
