public override int Query()
{
strWhere = "1=1 ";
if (!string.IsNullOrEmpty(txtpeiliao.Text.Trim()))
{
strWhere = strWhere + " and a.code like '%" + txtpeiliao.Text + "%'";
}
if (!string.IsNullOrEmpty(cmbCodeNumUser.Text.Trim()))
{
strWhere = strWhere + " and a.createUser='******'";
}
if (!string.IsNullOrEmpty(txtfishId.Text.Trim()))
{
strWhere = strWhere + " and d.fishId like'%" + txtfishId.Text + "%'";
}
if (!string.IsNullOrEmpty(txtqualitySpe.Text.Trim()))
{
strWhere = strWhere + " and d.qualitySpe like'%" + txtqualitySpe.Text + "%'";
}
if (!string.IsNullOrEmpty(txtcodeNum.Text.Trim()))
{
strWhere = strWhere + " and d.codeNum like'%" + txtcodeNum.Text + "%'";
}
if (!string.IsNullOrEmpty(txtcodeNumContract.Text.Trim()))
{
strWhere = strWhere + " and d.codeNumContract like'%" + txtcodeNumContract.Text + "%'";
}
if (!string.IsNullOrEmpty(dtpStart.Text.Trim()))
{
strWhere = strWhere + " AND a.productionDate>='" + dtpStart.Text + "'";
}
if (!string.IsNullOrEmpty(dtpEnd.Text.Trim()))
{
strWhere = strWhere + " AND a.productionDate<='" + dtpEnd.Text + "'";
}
tableView = _bll.getTableViewzizhi(strWhere);
dataGridView1.Rows.Clear();
if (tableView == null || tableView.Rows.Count < 1)
{
return(0);
}
setValue();
return(base.Query());
}
