c# - 在空字段搜索中使用查询 linq

Question

我有十个字段的表。我需要在 LINQ 中执行此搜索的搜索查询。我的领域是:

FirstName (string) , LastName (string), FatherName (string), NotationId (int), DebtPrice (int), BranchName (string), DebtId (int), MeliCode (string)

我的问题是:当用户不填写字段时，该字段不应该用于查询搜索
谢谢。

集合是合法的。View_Dossiers

Answer 1

你可以使用这段代码:

var query = from d in datacontext.sample where   
                            (TBoxFName.Text=="" || d.FirstName.Contains(TBoxFName.Text.Trim()))
                            &&(TBoxLName.Text == "" || d.LastName.Contains(TBoxLName.Text.Trim()))
                            &&(TBoxFatherName.Text == "" || d.FatherName.Contains(TBoxFatherName.Text.Trim()))
                            && (TBoxPriceDebt.Text == "" || d.DebtPrice.ToString().Contains(TBoxPriceDebt.Text.Trim()))
                            && (CBoxBranch.Text == "" || d.BranchName.Contains(CBoxBranch.Text.Trim()))
                            &&(TBoxDebt.Text == "" || d.DebtId.Contains(TBoxDebt.Text.Trim()))
                            &&(TBoxMeliCode.Text == "" || d.MeliCode.Contains(TBoxMeliCode.Text.Trim()))
                                select d;