111,094
社区成员




create table ERequest(ENO char(10),EName nvarchar(100),EAdress nvarchar(100),EAge nvarchar(50),primary key (ENO))
insert into ERequest
select '0001' ENO,'某某公司' EName,'深圳' EAdress,'20以上' EAge
insert into ERequest
select '0002' ENO,'XX公司' EName,'北京' EAdress,'30以上' EAge
create table EmployerInfo(ENO char(10),EName nvarchar(100),EPhone nvarchar(100),EDate nvarchar(50),primary key (ENO))
insert into EmployerInfo
select '0001' ENO,'XX公司' EName,'0755-888866666' ,'20171213'
/// <summary>
/// 查询方法,自定义参数
/// </summary>
/// <param name="str1"></param>
/// <param name="str2"></param>
/// <returns></returns>
public static DataTable searchFunc(string str1, string str2)
{
DataTable dt = new DataTable();
List<SqlParameter> list1 = new List<SqlParameter>();
StringBuilder sb = new StringBuilder();
sb.Append("select * from ERequest A ");
sb.Append(" left join EmployerInfo B on B.ENO = A.ENO ");
sb.Append(" where 1=1 ");
if (!string.IsNullOrEmpty(str1))
{
sb.Append(" and A.ENO like @ENO" );
list1.Add(new SqlParameter("@ENO", SqlDbType.NVarChar, 100) { Value = "%" + str1 + "%" });
}
if (!string.IsNullOrEmpty(str2))
{
sb.Append(" and A.EName like @EName");
list1.Add(new SqlParameter("@EName", SqlDbType.NVarChar, 100) { Value = "%" + str2 + "%" });
}
SqlParameter[] sqlP = list1.ToArray();
dt = Query(sb.ToString(),sqlP).Tables[0];
return dt;
}