引用2个DLL
public static bool GetSelectMockBomSql(out string getSqlWhere)
{
try
{
UFGeneralFilter.FilterSrv fltSrv = new UFGeneralFilter.FilterSrv();
object errinfo = null;
bool bSuccess = fltSrv.OpenFilter(GlobalParameters.U8Login, "B1BC7376-FB99-48A0-AC4E-86DC72765F03", "", "AA", ref errinfo);
if (!bSuccess)
{
if (errinfo != null)
{
MessageBox.Show("调用过滤窗口失败!" + errinfo.ToString());
}
getSqlWhere = "";
return false;
}
getSqlWhere = fltSrv.GetSQLWhere() ?? " 1=1";
return true;
}
catch (Exception ex)
{
getSqlWhere = "";
MessageBox.Show("查询模拟BOM出错:" + ex.Message);
return false;
}
}
使用方法
string _strMockWhere = "";
private void btnSearch_Click(object sender, EventArgs e)
{
if (Tools.GetSelectMockBomSql(out _strMockWhere))
{
SetSelectDataSet(_strMockWhere);
}
}
如何获取B1BC7376-FB99-48A0-AC4E-86DC72765F03 打开UAP
新建过滤器
PS: SQL语句 以及枚举用法如下
枚举串:如果没有在数据库中预制枚举类型,也可以通过此项输入一个枚举串。格式为“0{#}1{##}A{#}B”,在“{##}”前的为返回值,之后的则为显示值,并且在返回值与显示值中分别以“{#}”分隔。
SELECT so.cSOCode AS [销售订单], sod.iRowNo AS [行号], sod.iSOsID AS [销售订单子表ID]
FROM dbo.SO_SOMain so LEFT JOIN dbo.SO_SODetails sod ON sod.ID = so.ID LEFT JOIN SaleType st on so.cSTCode=st.cSTCode LEFT JOIN dbo.Inventory i ON i.cInvCode = sod.cInvCode where 1=1
fld1