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);
}
