有关于radiobutton的
private void btnQuery_Click(object sender, EventArgs e)
{
BindGrid();
} private void PJWJA_Load(object sender, EventArgs e)
{
this.dgvPrdt.AutoGenerateColumns = false;
}
private void BindGrid()
{
string strSql;
strSql = @"SELECT TI_NO,TI_DD,NAME,BIL_NO FROM MF_TI LEFT OUTER JOIN SALM ON SALM.SAL_NO=MF_TI.SAL_NO WHERE CLOSE_ID='F' AND 1=1 "; if (RdoSfpjy.Checked = true)
{
strSql += "AND BIL_ID = 'PO'";
}
if (RdoZcpjy.Text.Trim().Length > 0)
{
strSql += "AND BIL_ID = 'MO'";
}
if (RdoTwjy.Text.Trim().Length > 0)
{
strSql += "AND BIL_ID = 'TW'";
}
if (RdoGxjy.Text.Trim().Length > 0)
{
strSql += "AND BIL_ID = 'TZ'";
} RemoteCallReturnWithDataset rmtPrdt = ErpBasic.Cls_Common.GetDataFromDB(strSql);
DataTable dtbPrdt = rmtPrdt.ExecuteReturnData.Tables[0]; this.dgvPrdt.DataSource = dtbPrdt;
if (null != dtbPrdt)
{
this.txtInfo.Text = "查询完成,共 " + dtbPrdt.Rows.Count + "条信息.";
} }原代码如下,我的问题是我在点击查询的时候,我的radiobutton按钮里面我已经赋值了,在if哪里。可能为什么查询后没结果呢?RadioButton
private void btnQuery_Click(object sender, EventArgs e)
{
BindGrid();
} private void PJWJA_Load(object sender, EventArgs e)
{
this.dgvPrdt.AutoGenerateColumns = false;
}
private void BindGrid()
{
string strSql;
strSql = @"SELECT TI_NO,TI_DD,NAME,BIL_NO FROM MF_TI LEFT OUTER JOIN SALM ON SALM.SAL_NO=MF_TI.SAL_NO WHERE CLOSE_ID='F' AND 1=1 "; if (RdoSfpjy.Checked = true)
{
strSql += "AND BIL_ID = 'PO'";
}
if (RdoZcpjy.Text.Trim().Length > 0)
{
strSql += "AND BIL_ID = 'MO'";
}
if (RdoTwjy.Text.Trim().Length > 0)
{
strSql += "AND BIL_ID = 'TW'";
}
if (RdoGxjy.Text.Trim().Length > 0)
{
strSql += "AND BIL_ID = 'TZ'";
} RemoteCallReturnWithDataset rmtPrdt = ErpBasic.Cls_Common.GetDataFromDB(strSql);
DataTable dtbPrdt = rmtPrdt.ExecuteReturnData.Tables[0]; this.dgvPrdt.DataSource = dtbPrdt;
if (null != dtbPrdt)
{
this.txtInfo.Text = "查询完成,共 " + dtbPrdt.Rows.Count + "条信息.";
} }原代码如下,我的问题是我在点击查询的时候,我的radiobutton按钮里面我已经赋值了,在if哪里。可能为什么查询后没结果呢?RadioButton
{
strSql += "AND BIL_ID = 'PO'";
}
改成这样
if(RdoSfpjy.Checked )
如果两个if语句都满足条件,查询结果肯定是0