protected void Button1_Click(object sender, EventArgs e) { var query = ProductDataManage.Instance.GetLambdaQuery(); query.Select(b => new { b.InterFaceUser, b.ProductName, b.PurchasePrice });//选择查询的字段 int? n2 = 10; classA a = new classA() { Name = "ffffff" }; query.Top(100); //取多少条 query.Where(b => b.Id < 700); //查询条件 query.Where(b => b.ProductName.Contains("w2") || b.ProductName.Contains("sss")); string s = "ssss"; int n = 10; query.Where(b => b.ProductName == s && b.Id > n || b.ProductName.Contains("sss")); query.Where(b => b.Id == n2.Value); query.Where(b => b.ProductName == a.Name); query.Where(b => b.ProductName == a.Method()); query.Where(b => b.ProductName.Contains("sss")); query.OrderBy(b => b.Id, true); //排序条件 query.OrderBy(b => b.Number, false); //多列排序调用多次 txtOutput.Visible = true; txtOutput.Text = query.PrintQuery(); var list = query.ToList(); Response.Write(string.Format("解析语法用时:{0}ms 数据查询用时:{1}ms 对象映射用时:{2}ms {3}行", query.AnalyticalTime, query.ExecuteTime, query.MapingTime, list.Count)); }
protected void Button1_Click(object sender, EventArgs e) { var query = Code.ProductDataManage.Instance.GetLamadaQuery(); query = query.Select(b => new { b.InterFaceUser, b.ProductName, b.PurchasePrice });//选择查询的字段 int?n2 = 10; query = query.Top(10); //取多少条 query = query.Where(b => b.Id < 700 && b.InterFaceUser == "USER1"); //查询条件 query.Where(b => b.ProductName.Contains("w2") || b.ProductName.Contains("sss")); string s = "ssss"; int n = 10; classA a = new classA() { Name = "ffffff" }; query.Where(b => b.ProductName == s && b.Id > n || b.ProductName.Contains("sss")); query.Where(b => b.Id == n2.Value); query.Where(b => b.ProductName == a.Name); query.Where(b => b.ProductName == a.Method()); query.Where(b => b.ProductName.Contains("sss")); query = query.OrderBy(b => b.Id, true);//排序条件 var list = Code.ProductDataManage.Instance.QueryList(query); }
protected void Button1_Click(object sender, EventArgs e) { var query = Code.ProductDataManage.Instance.GetLambdaQuery(); query.Select(b => new { b.InterFaceUser, b.ProductName, b.PurchasePrice });//选择查询的字段 int? n2 = 10; classA a = new classA() { Name = "ffffff" }; query.Top(100);//取多少条 query.Where(b => b.Id < 700);//查询条件 query.Where(b => b.ProductName.Contains("w2") || b.ProductName.Contains("sss")); string s = "ssss"; int n = 10; query.Where(b => b.ProductName == s && b.Id > n || b.ProductName.Contains("sss")); query.Where(b => b.Id == n2.Value); query.Where(b => b.ProductName == a.Name); query.Where(b => b.ProductName == a.Method()); query.Where(b => b.ProductName.Contains("sss")); query.OrderBy(b => b.Id, true);//排序条件 query.OrderBy(b => b.Number, false);//多列排序调用多次 txtOutput.Visible = true; txtOutput.Text = query.PrintQuery(); var list = query.ToList(); Response.Write(string.Format("解析语法用时:{0}ms 数据查询用时:{1}ms 对象映射用时:{2}ms {3}行", query.AnalyticalTime, query.ExecuteTime, query.MapingTime, list.Count)); }
protected void Button1_Click(object sender, EventArgs e) { var query = Code.ProductDataManage.Instance.GetLamadaQuery(); query = query.Select(b => new { b.InterFaceUser, b.ProductName, b.PurchasePrice });//选择查询的字段 int? n2 = 10; query = query.Top(10);//取多少条 query = query.Where(b => b.Id < 700 && b.InterFaceUser == "USER1");//查询条件 query.Where(b => b.ProductName.Contains("w2") || b.ProductName.Contains("sss")); string s="ssss"; int n = 10; classA a = new classA() { Name = "ffffff" }; query.Where(b => b.ProductName == s && b.Id > n || b.ProductName.Contains("sss")); query.Where(b => b.Id == n2.Value); query.Where(b => b.ProductName == a.Name); query.Where(b => b.ProductName == a.Method()); query.Where(b=>b.ProductName.Contains("sss")); query = query.OrderBy(b => b.Id, true);//排序条件 var list = Code.ProductDataManage.Instance.QueryList(query); }