- 当前位置：首页 >域名 >SQL强类型查询的实现
SQL强类型查询的实现
发布时间：2025-11-05 12:46:36 来源：创站工坊 作者：IT科技
复制 class Program 2 { 3 static void Main(string[] args) 4 { 5 6 Exp rs = new Exp("C1") == 25 & new Exp("C2") > 3 | new Exp("C3") <5 ^ new Exp("C4") % "hehe"; 7 Console.WriteLine(rs.Sql); 8 foreach (SqlParameter sp in rs.Sps) 9 { 10 Console.WriteLine(sp.ParameterName); 11 } 12 Console.Read(); 13 } 14 } 15 16 class Exp 17 { 18 private string _Sql; 19 20 private List<SqlParameter> sps; 21 22 public List<SqlParameter> Sps 23 { 24 get { return sps; } 25 set { sps = value; } 26 } 27 28 private SqlParameter sp; 29 30 public string Sql 31 { 32 get { return _Sql; } 33 } 34 35 private Exp() 36 { 37 sps = new List<SqlParameter>(); 38 } 39 40 public Exp(string CollumnName) 41 { 42 _Sql = CollumnName; 43 } 44 45 public static Exp operator ==(Exp Left,类型 Object Value) 46 { 47 Exp Next = new Exp(); 48 Next.sp = new SqlParameter(Left._Sql, Value); 49 Next.sps.Add(Next.sp); 50 Next._Sql = Left._Sql + " = @" + Left.Sql; 51 return Next; 52 } 53 public static Exp operator !=(Exp Left, Object Value) 54 { 55 Exp Next = new Exp(); 56 Next.sp = new SqlParameter(Left._Sql, Value); 57 Next.sps.Add(Next.sp); 58 Next._Sql = Left._Sql + " <> @" + Left._Sql; 59 return Next; 60 } 61 62 public static Exp operator <(Exp Left, Object Value) 63 { 64 Exp Next = new Exp(); 65 Next.sp = new SqlParameter(Left._Sql, Value); 66 Next.sps.Add(Next.sp); 67 Next._Sql = Left._Sql + " < @" + Left._Sql; 68 return Next; 69 } 70 public static Exp operator >(Exp Left, Object Value) 71 { 72 Exp Next = new Exp(); 73 Next.sp = new SqlParameter(Left._Sql, Value); 74 Next.sps.Add(Next.sp); 75 Next._Sql = Left._Sql + " > @" + Left._Sql; 76 return Next; 77 } 78 79 public static Exp operator %(Exp Left, Object Value) 80 { 81 Exp Next = new Exp(); 82 Next.sp = new SqlParameter(Left._Sql, Value); 83 Next.sps.Add(Next.sp); 84 Next._Sql = Left._Sql + " Like @" + Left._Sql; 85 return Next; 86 } 87 88 public static Exp operator &(Exp Left, Exp Right) 89 { 90 Exp Next = new Exp(); 91 foreach (SqlParameter sp in Left.sps) 92 { 93 Next.sps.Add(sp); 94 } 95 foreach (SqlParameter sp in Right.sps) 96 { 97 Next.sps.Add(sp); 98 } 99 Next._Sql = Left.Sql + " AND " + Right.Sql; 100 return Next; 101 } 102 103 104 public static Exp operator |(Exp Left, Exp Right) 105 { 106 Exp Next = new Exp(); 107 foreach (SqlParameter sp in Left.sps) 108 { 109 Next.sps.Add(sp); 110 } 111 foreach (SqlParameter sp in Right.sps) 112 { 113 Next.sps.Add(sp); 114 } 115 Next._Sql = Left.Sql + " OR " + Right.Sql; 116 return Next; 117 } 118 119 public static Exp operator ^(Exp Left, Exp Right) 120 { 121 Exp Next = new Exp(); 122 foreach (SqlParameter sp in Left.sps) 123 { 124 Next.sps.Add(sp); 125 } 126 foreach (SqlParameter sp in Right.sps) 127 { 128 Next.sps.Add(sp); 129 } 130 Next._Sql = Left.Sql + " NOT " + Right.Sql; 131 return Next; 132 } 133 } 134 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.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.52.53.54.55.56.57.58.59.60.61.62.63.64.65.66.67.68.69.70.71.72.73.74.75.76.77.78.79.80.81.82.83.84.85.86.87.88.89.90.91.92.93.94.95.96.97.98.99.100.101.102.103.104.105.106.107.108.109.110.111.112.113.114.115.116.117.118.119.120.121.122.123.124.125.126.127.128.129.130.131.132.133.134.
- 电脑开机时显示脚本错误的解决方法（识别和修复电脑开机时显示脚本错误的常见问题）
- 实用静音，帅康烟机值得拥有（让厨房更清洁，更安静）
- 华硕GFX72VS笔记本电脑的性能和特点（一款出色的游戏本，华硕GFX72VS的亮点和优势）
- 以虎卫V5怎么样？——一款强大的智能安防产品（体验虎卫V5，保护您的家庭安全）
- YADU空气净化器的使用体验与评价（探索YADU空气净化器的功能和效果，解析其适用性及性价比）
- 魅族Re版（一款令人期待的手机重返江湖）
- 4.0环绕效果（探索声道技术的进化，感受立体音效的魅力）
- 探索战龙X8的游戏乐趣（了解游戏机制，拓展冒险世界）
- 手机烧屏了会怎么样？（了解手机烧屏的原因和影响）
- 华硕照明（华硕照明产品优势解析，打造智能舒适的照明体验）
随便看看
香港云服务器企商汇IT技术网亿华云源码下载益华科技IT资讯网源码库服务器租用码上建站思维库亿华云益华科技云站无忧IT资讯网亿华智慧云益强IT技术网全栈开发技术快报益强科技极客编程益华科技益强前沿资讯亿华科技益强资讯优选码力社亿华灵动多维IT资讯益强科技科技前瞻益强编程舍运维纵横益华IT技术论坛创站工坊亿华互联亿华智造益强编程堂益强智囊团极客码头亿华云计算
- Copyright © 2025 Powered by SQL强类型查询的实现,创站工坊 滇ICP备2023006006号-44sitemap