string.Format()

 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

汉字 四角码 eg:0,1,2,3,4,5,6,7,8,9   var zeroSijiao = ShuZiService.Fetch(new SqlInfo { ReturnFields = new List<string> { Define.ShuZiEntity.Field.Ncid, Define.ShuZiEntity.Field.Bishuntext, Define.ShuZiEntity.Field.Bihua, Define.ShuZiEntity.Field.ShurufaSijiao, Define.ShuZiEntity.Field.BushouCode, Define.ShuZiEntity.Field.Bishun, Define.ShuZiEntity.Field.Jiegou, Define.ShuZiEntity.Field.Pinyin, Define.ShuZiEntity.Field.Code }, 方法一：Where = string.Format("{0} <10000 and {0}!=0 and {0} is not null",Define.ShuZiEntity.Field.ShurufaSijiao)   方法二：Where = string.Format(" isnull({0},0) between {1} and {2}"<br> Where = string.Format("{0} between {1} and {2}" , Define.ShuZiEntity.Field.ShurufaSijiao   方法三：, sijiaoCode==0?1: sijiaoCode *10000 //等于0时 特殊情况 , sijiaoCode * 10000 , (sijiaoCode + 1) * 10000 - 1 ), Orderby = string.Format("{0} asc", Define.ShuZiEntity.Field.ShurufaSijiao)   });