SQLServer Decimal数据类型怎么赋值
217
2022-09-16
.NET的语法优化
1.多参数
判断 条件
//判断 var fileKey = new { DateStart = search.DateStart.IsNull(), //关开始时间 DateEnd = search.DateEnd.IsNull(), //结束时间 UserName = search.UserName.IsNullOrEmpty(), //用户名 NickName = search.NickName.IsNullOrEmpty(), //昵称 PhoneNumber = search.PhoneNumber.IsNullOrEmpty(), //电话号码 ProblemCatey = search.ProblemCatey.IsNullOrEmpty(), //问题种类 };
IsNull() 和 IsNullOrEmpry() 是扩展静态方法:
///
使用如下
//查询 var list = from p in unitOfWork.FeedBack.Get(p => (fileKey.ProblemCatey || p.ProblemCatey.Contains(search.ProblemCatey))) join m in unitOfWork.Member.Get() on p.UserID equals m.Id where fileKey.UserName || m.UserName.Contains(search.UserName) where fileKey.NickName || m.NickName.Contains(search.NickName) where fileKey.PhoneNumber || m.PhoneNumber.Contains(search.PhoneNumber) where fileKey.DateStart || p.CreatedOn >= search.DateStart where fileKey.DateEnd || p.CreatedOn <= search.DateEnd select new FeedBackModelExd { Id = p.Id, ProblemCatey = p.ProblemCatey, CreatedOn = p.CreatedOn, UserName = m.UserName, NickName = m.NickName, PhoneNumber = m.PhoneNumber, Content = p.Content, };
2.单一参数
改造前
private static bool TraditionalVerify(int number) { if ((number > 0) && (number >= 10) && (number % 2 > 0) && (number * 2 > 100)) { return true; } return false; }
改造后:
private static bool UseFunc(int number) { var conditionlist = new List
版权声明:本文内容由网络用户投稿,版权归原作者所有,本站不拥有其著作权,亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容,请联系我们jiasou666@gmail.com 处理,核实后本网站将在24小时内删除侵权内容。
发表评论
暂时没有评论,来抢沙发吧~