摘要: update T_Product set amount=(case when quantity<10 then amount*(1-0.1)when quantity between 10 and 20 then amount*(1-0.2)else amount*(1-0.3)end) 阅读全文
posted @ 2012-06-13 22:43 Tom Fan 阅读(151) 评论(0) 推荐(0) 编辑
摘要: using System;using System.Collections.Generic;using System.Linq;using System.Text;namespace RefAndOutAndParams{ class Program { /// <summary> /// 一个方法中可以动态传递多个参数的方法 /// </summary> /// <param name="list"></param> public static void MyTestParams(params Object [... 阅读全文
posted @ 2012-06-13 22:28 Tom Fan 阅读(268) 评论(0) 推荐(0) 编辑