如下一段代码
public List<Model.MaterialInfos> getMaterialInfosByOrToVery(string MaterialInfo_Code, string MaterialInfo_BarCode, string ProduceArea_id, string Brands_Id, string MaterialInfo_Name)
{
if (MaterialInfo_Code != "")
{
sql += "MaterialInfo_Code like '%" + MaterialInfo_Code + "%'";
} if (MaterialInfo_BarCode != "")
{
sql += "MaterialInfo_BarCode like '%" + MaterialInfo_BarCode + "%'";
} if (ProduceArea_id != "")
{
sql += "ProduceArea_id like '%" + ProduceArea_id + "%'";
} if (Brands_Id != "")
{
sql += "Brands_Id like '%" + Brands_Id + "%'";
} if (MaterialInfo_Name != "")
{
sql += "MaterialInfo_Name like '%" + MaterialInfo_Name + "%'";
}
我想让 其中某一个变量有值就进行查询,并且跳出If语句!请各位指点 在线等。
public List<Model.MaterialInfos> getMaterialInfosByOrToVery(string MaterialInfo_Code, string MaterialInfo_BarCode, string ProduceArea_id, string Brands_Id, string MaterialInfo_Name)
{
if (MaterialInfo_Code != "")
{
sql += "MaterialInfo_Code like '%" + MaterialInfo_Code + "%'";
} if (MaterialInfo_BarCode != "")
{
sql += "MaterialInfo_BarCode like '%" + MaterialInfo_BarCode + "%'";
} if (ProduceArea_id != "")
{
sql += "ProduceArea_id like '%" + ProduceArea_id + "%'";
} if (Brands_Id != "")
{
sql += "Brands_Id like '%" + Brands_Id + "%'";
} if (MaterialInfo_Name != "")
{
sql += "MaterialInfo_Name like '%" + MaterialInfo_Name + "%'";
}
我想让 其中某一个变量有值就进行查询,并且跳出If语句!请各位指点 在线等。
{
if (MaterialInfo_Code != "")
{
sql += "MaterialInfo_Code like '%" + MaterialInfo_Code + "%'";
//写上执行查询的语句
return 查询结果;
}
if (MaterialInfo_BarCode != "")
{
sql += "MaterialInfo_BarCode like '%" + MaterialInfo_BarCode + "%'";
//写上执行查询的语句
return 查询结果;
}
if (ProduceArea_id != "")
{
sql += "ProduceArea_id like '%" + ProduceArea_id + "%'";
//写上执行查询的语句
return 查询结果;
} if (Brands_Id != "")
{
sql += "Brands_Id like '%" + Brands_Id + "%'";
//写上执行查询的语句
return 查询结果;
} if (MaterialInfo_Name != "")
{
sql += "MaterialInfo_Name like '%" + MaterialInfo_Name + "%'";
//写上执行查询的语句
return 查询结果;
}
用if(){}else if(){}这样吧 不用改动太多