关于Epicor函数中Db
Epicor Function中Db查询默认是不会带上公司过滤的。
实例：
不加公司条件
C# 全选
var data = Db.Company.ToList();
DataTable dt = new DataTable();
dt.Columns.Add("company",typeof(string));
dt.Columns.Add("name",typeof(string));
foreach(var item in data) {
dt.Rows.Add(item.Company1,item.Name);
}
DataSet ds = new DataSet();
ds.Tables.Add(dt);
this.output = ds;Markup 全选
{
"output": {
"Table1": [
{
"company": "EPIC01",
"name": "Epic Corporation"
},
{
"company": "EPIC02",
"name": "Epicor Distribution"
},
{
"company": "EPIC03",
"name": "Epicor USA"
},
{
"company": "EPIC04",
"name": "Epicor Financial Co."
},
{
"company": "EPIC05",
"name": "Epicor Europe"
},
{
"company": "EPIC06",
"name": "Epicor Education"
},
{
"company": "EPIC07",
"name": "Epicor Mexico"
},
{
"company": "EPICPF",
"name": "Epicor Perform"
},
{
"company": "GPC",
"name": "Graphic Printing Co."
}
]
}
}
手动添加公司条件
C# 全选
var data = Db.Company.Where(w=>w.Company1== this.callContextClient.CurrentCompany).ToList();
DataTable dt = new DataTable();
dt.Columns.Add("company",typeof(string));
dt.Columns.Add("name",typeof(string));
foreach(var item in data) {
dt.Rows.Add(item.Company1,item.Name);
}
DataSet ds = new DataSet();
ds.Tables.Add(dt);
this.output = ds;返回内容：
Markup 全选
{
"output": {
"Table1": [
{
"company": "EPIC01",
"name": "Epic Corporation"
}
]
}
}版权声明：本文为YES开发框架网发布内容,转载请附上原文出处连接
epicor 张国生
