【机房重构】组合查询

实体层

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