实体层
public class GroupFindtemplate
{
private string _cboField1;
private string _cboField2;
private string _cboField3;
private string _cboMark1;
private string _cboMark2;
private string _cboMark3;
private string _content1;
private string _content2;
private string _content3;
private string _relationship1;
private string _relationship2;
private string _dbtable;
public string CboField1 { get => _cboField1; set => _cboField1 = value; }
public string CboField2 { get => _cboField2; set => _cboField2 = value; }
public string CboField3 { get => _cboField3; set => _cboField3 = value; }
public string CboMark1 { get => _cboMark1; set => _cboMark1 = value; }
public string CboMark2 { get => _cboMark2; set => _cboMark2 = value; }
public string CboMark3 { get => _cboMark3; set => _cboMark3 = value; }
public string Content1 { get => _content1; set => _content1 = value; }
public string Content2 { get => _content2; set => _content2 = value; }
public string Content3 { get => _content3; set => _content3 = value; }
public string Relationship1 { get => _relationship1; set => _relationship1 = value; }
public string Relationship2 { get => _relationship2; set => _relationship2 = value; }
public string Dbtable { get => _dbtable; set => _dbtable = value; }
}
存储过程
ALTER PROCEDURE [dbo].[PROC_GroupCheck]
-- Add the parameters for the stored procedure here
@cboFiled1 varchar(20),
@cboFiled2 varchar(20),
@cboFiled3 varchar(20),
@cboMark1 varchar(10),
@cboMark2 varchar(10),
@cboMark3 varchar(10),
@Content1 varchar(20),
@Content2 varchar(20),
@Content3 varchar(20),
@Relationship1 varchar(10),
@Relationship2 varchar(10),
@DbtableName varchar(20)
AS
declare @TemSql varchar(500)
BEGIN
--将具体的查询语句通过字符串拼接起来,char(39)是单引号,char(32)是空格
set @TemSql='select * from '+@DbtableName +' where '+@cboFiled1+@cboMark1+char(39)+@Content1+char(39)
if(@Relationship1 !='')
begin
set @TemSql =@TemSql+@Relationship1+char(32)+@cboFiled2+@cboMark2+char(39)+@Content2+char(39)
if(@Relationship2!='')
begin
set @TemSql=@TemSql+@Relationship2+char(32)+@cboFiled3+@cboMark3+char(39)+@Content3+char(39)
end
end
execute(@TemSql)
END