Question

我有这样的问询。

  levelnumber = (from b in bv.baLevels
                 where b.ba_Level_Code == ("0" + SqlFunctions.StringConvert((double)cl.Level_Num.Value)) && b.isActive == 1
                 select (b.ba_Level_Code + " - " + b.ba_Level_Desc)).FirstOrDefault(),

我的问题是b.ba_level_ 法典正在阐明。

页: 1 一级

ba级表我有这一ba。

但是,这cl是BaCodeLibrary表。一级:8

如果我对硬编码价值提出疑问,

 levelnumber = (from b in bv.baLevels
                where b.ba_Level_Code == "008" && b.isActive == 1
                select (b.ba_Level_Code + " - " + b.ba_Level_Desc)).FirstOrDefault(),

如何显示08? 包括: 我已经到了8个。我需要将这一价值改为08。

增编

Answer 1

您可使用<条码>。页: 1 • 一级改为最低数字级:

string.Format("{0:D3}", cl.Level_Num.Value) // would ouput "008" value 8

因此:

levelnumber = (from b in bv.baLevels
               where b.ba_Level_Code == string.Format("{0:D3}", cl.Level_Num.Value) && b.isActive == 1
               select (b.ba_Level_Code + " - " + b.ba_Level_Desc)).FirstOrDefault()

Answer 2

我看不出这样做的好办法。假设您不能修改<代码>ba_level_Code的数据类型。在一栏中,我认为你的最佳选择是,在表格中添加一个持久性的

例如,如果你界定一栏

ba_Level_Code_Int as (case when isnumeric(ba_Level_Code)= 1 then cast(ba_Level_Code as int) end) persisted

之后,可请您回答问题。

levelnumber = (from b in bv.baLevels   
               where b.ba_Level_Code_Int == cl.Level_Num.Value && b.isActive == 1   
               select (b.ba_Level_Code + " - " + b.ba_Level_Desc)).FirstOrDefault();

友情链接