这是我开发的简单账表，在这里可以授权基础资料的范围。在报表插件中获取就好了。

//创建临时报表

public override void BuilderReportSqlAndTempTable(IRptParams filter, string tableName)

{

DynamicObject customFilter = filter.FilterParameter.CustomFilter;

string strSql = "";

string QYTableName = "";

// string XSYBMTableName = "";

string XSYTableName = "";

string KHTableName = "";

string WLTableName = "";

string seqFld = string.Format(base.KSQL_SEQ, OrderColumn(filter));

string FStartDate = (customFilter["FStartDate"] == null) ? string.Empty : customFilter["FStartDate"].ToString();

string FEndDate = (customFilter["FEndDate"] == null) ? string.Empty : customFilter["FEndDate"].ToString();

string FCustName = this.GetBaseDataNameValue(customFilter["FCustName"] as DynamicObjectCollection);

string FContractNo = (customFilter["FContractNo"] == null) ? string.Empty : customFilter["FContractNo"].ToString();

foreach (var tempTable in filter.BaseDataTempTable)

{

if (tempTable.BaseDataFormId == "BD_Department")//基础资料标识，如果有两个一样的会有问题不能区分，看大神们有没有好办法吧。生成的基础资料临时表好像是自增长id和基础资料的id两列，在存储过程中去过滤就好了。

{

QYTableName = tempTable.TempTable;

}

//if (tempTable.BaseDataFormId == "BD_Department")

//{

// XSYBMTableName = tempTable.TempTable;

//}

if (tempTable.BaseDataFormId == "BD_Saler")

{

XSYTableName = tempTable.TempTable;

}

if (tempTable.BaseDataFormId == "BD_Customer")

{

KHTableName = tempTable.TempTable;

}

if (tempTable.BaseDataFormId == "BD_MATERIAL")

{

WLTableName = tempTable.TempTable;

}

}

string sql = string.Format(@"/*dialect*/exec spyc_OutStock_Productstatistics '{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}'",

FStartDate, FEndDate, FCustName.Replace("'", "&"), FContractNo, this.GetMultiOrgnNameValues(customFilter["FSaleOrgList"].ToString()), tableName, QYTableName, XSYTableName, KHTableName, WLTableName);

//customFilter["FSaleOrgList"].ToString(), FYear, FMount, tableName, DepTableName, SalTableName);

DBUtils.ExecuteDynamicObject(this.Context, sql);

}

产品问题简单账表是否可以设置数据权限

产品问题 简单账表是否可以设置数据权限

恭喜您！

产品问题
简单账表是否可以设置数据权限

产品问题简单账表是否可以设置数据权限