随笔

判断是否为空：

if(!string.IsNullOrEmpty(request.Code)){}

取数据库数据总个数

var sqlEx = CurDb.From<V_Manager_Doctor_Wallet_Record>().Select(Sql.Count("*"));

去数据库数据总和

var sqlEx = CurDb.From<PaymentPay>().Select("Sum(Amount)");

倒叙、正序

OrderByDescending  OrderBy

拼接查询条件

			if (!string.IsNullOrEmpty(request.PatientName))
            {
                sqlEx = sqlEx.Where(x => x.Name.Contains(request.PatientName.Trim()));
            }
            if (!string.IsNullOrEmpty(request.LoginId))
            {
                sqlEx = sqlEx.Where(x => x.LoginId == request.LoginId.Trim());
            }
            .Trim()//去空格
            .Contains()//包含

查询遍历

var sqlEx1 = CurDb.From<PersonDocument>().Where(x => x.PatientId == item1.Id);
                var sqlEx2 = sqlEx1.Limit(request.Page * request.Take, request.Take);
                var model1 = CurDb.Select<VmManagerPD>(sqlEx2);
                foreach (var item in model1)//遍历
                {
                    item.PatientName = request.PatientName;//赋值
                    item.PatientPhone = request.LoginId;
                }
                res.EntityList.AddRange(model1);//累加（返回集合，需累加）
                total += (int)CurDb.Count(sqlEx1);