求前辈指点,怎么用linq或lambda查询出包含“1”的数据行?
Create table FlowInfo --流程表
(
PK_Flow_ID int primary key identity(1,1),
Flow_FirstCensorPersonID varchar(8000),
Flow_SecondCensorPersonID varchar(8000),
Flow_ThirdCensorPersonID varchar(8000),
Flow_Name varchar(8000),
Flow_FirstApproveType varchar(8000),
Flow_SecondApproveType varchar(8000),
Flow_ThirdApproveType varchar(8000),
Column4 varchar(8000),
Column5 varchar(8000),
Column6 varchar(8000),
Column7 varchar(8000),
Column8 varchar(8000),
Column9 varchar(8000),
Column10 varchar(8000)
)
GO
--添加FlowInfo测试数据
insert into FlowInfo values('113','112','111','IT部专用流程','0','1','1','','','','','','','');
insert into FlowInfo values('1','112','79','财务部专用流程','0','0','0','','','','','','','');
insert into FlowInfo values('113','112','79','总经办专用流程','0','0','0','','','','','','','');
insert into FlowInfo values('113,1','112','111','工程部专用流程','0','1','0','','','','','','','');
insert into FlowInfo values('1','112','79','部门经理专用流程','1','1','0','','','','','','','');
insert into FlowInfo values('6','112','111','财务部专用流程','1','0','0','','','','','','','');
insert into FlowInfo values('11','112,12','111,11','人事部专用流程','1','0','0','','','','','','','');
insert into FlowInfo values('6','1,112','111,1','市场部专用流程','1','0','0','','','','','','','');
insert into FlowInfo values('11','101,1,111','113','品质部专用流程','1','0','0','','','','','','','');
Go
怎么查出在Flow_FirstCensorPersonID,Flow_SecondCensorPersonID ,Flow_ThirdCensorPersonID这三个字段中包含“1”的数据行?就是只查到财务,部门,市场,品质这4个数据,例如“1,” “,1” "11"不查出来
我刚刚写的感觉不行,求前辈指点一下,谢谢了
// var flowlist =(from f in db.FlowInfo
// where f.Flow_FirstCensorPersonID ==item || f.Flow_SecondCensorPersonID == item || f.Flow_ThirdCensorPersonID ==item ||f.Flow_ThirdCensorPersonID.Contains(item )).tolist();