62,050
社区成员
发帖
与我相关
我的任务
分享
var order = OrderManage.Instance.QueryItem(b=>b.Id==1 && b.UserId==2);
等效为
select * from Order where id=1 and UserId=2
更新删除同理
var query = Code.ProductDataManage.Instance.GetLamadaQuery();//创查完整查询
query = query.Where(b => b.Id < 700);
int exp = 10;//过期分钟
var list = Code.ProductDataManage.Instance.QueryList(query, exp);//返回一个查询缓存,条件不一样,缓存也不一样
调用对象数据缓存
var list = Code.ProductDataManage.Instance.QueryFromAllCache(b => b.Id < 700);//在内部缓存数据中查找
var query = Code.ProductDataManage.Instance.GetLamadaQuery();
query = query.Where(b => b.Id < 700);
string name = Request["name"];
query = query.Where(b => b.InterFaceUser == name);
var list = Code.ProductDataManage.Instance.QueryList(query, compileSp: true);
将会创建并调用等效存储过程
CREATE PROCEDURE [dbo].[ZautoSp_6B517FF62BDE99E6] (@id0 nvarchar(500),@InterFaceUser1 nvarchar(500)) AS set nocount on select t1.[AddTime],t1.[BarCode],t1.[CategoryName],t1.[Id],t1.[InterFaceUser],t1.[Number],t1.[ProductChannel],t1.[ProductId],t1.[ProductName],t1.[PurchasePrice],t1.[SoldPrice],t1.[Style],t1.[SupplierId],t1.[SupplierName],t1.[TransType] from ProductData t1 with(nolock) where (t1.Id<@Id0) and InterFaceUser=@InterFaceUser1
var user = new User(){Name="test"};
UserManage.Instance.Login(user,"user",false);//实现Form验证登录,并设定票据
//按对象差异更新
var p = Code.ProductDataManage.Instance.QueryItem(b => b.Id >0);
p.BarCode = "ssss" + DateTime.Now.Second;
Code.ProductDataManage.Instance.Update(p);//按对象差异更新,对象需由查询创建