namespace BIP.LHYY.FIN.CB.App.ServicePlugIn

{

/// <summary>

/// 按顺序输出反写插件的事件

/// </summary>

[Kingdee.BOS.Util.HotUpdate]

[Description("成本计算单增加单位数据")]

public class CostCallBillHorizontalCustRpt : CostCalBillHorizontalRpt

{

/// <summary>

/// 记录业务流程跟踪信息之前，触发本事件；

/// 此时，还未分析本单的关联信息

/// </summary>

/// <param name="e"></param>

/// <remarks>

/// 可以在此事件中，强制要求不创建业务流程跟踪数据，不反写

/// </remarks>

public override void BuilderReportSqlAndTempTable(IRptParams filter, string tableName)

{

string tableNameE = GetTableName();

base.BuilderReportSqlAndTempTable(filter, tableNameE);//tableNameE是原数据表内容

string strSql = string.Format("SELECT t.*,5 JinDu, " +

"round(CASE WHEN t.fsumcompleteqty <>0 THEN (ISNULL(t.fsumcomplete20526,0) +ISNULL(t.fsumcomplete20527,0)" +

" +ISNUll(t.fsumcomplete20529,0))/t.fsumcompleteqty ELSE 0 end,5) AS unit1 ," +

"round(CASE WHEN t.fsumcompleteqty <> 0 THEN t.fsumcomplete153555 /t.fsumcompleteqty ELSE 0 END,5) AS F_BIP_unit2, " +

"round(CASE WHEN t.fsumcompleteqty <> 0 THEN t.fsumcomplete153556 /t.fsumcompleteqty ELSE 0 end,5) AS unit3," +

"round(CASE WHEN t.fsumcompleteqty <> 0 THEN t.fsumcomplete154682 / t.fsumcompleteqty ELSE 0 END,5) AS unit4," +

"round(CASE WHEN t.fsumcompleteqty <> 0 THEN t.fsumcomplete193325 / t.fsumcompleteqty ELSE 0 END,5) AS unit5 " +

"INTO {0} FROM {1} AS t",tableName,tableNameE);

DBUtils.Execute(this.Context, strSql);

}

public override ReportHeader GetReportHeaders(IRptParams filter)

{

ReportHeader header = base.GetReportHeaders(filter);

// TODO: 添加新增字段

foreach (var item in header.GetChilds())

{

if (item.Caption.ToString() == "本期完工")

{

item.AddChild("F_BIP_unit2", new LocaleValue("单位原辅料", this.Context.UserLocale.LCID));

item.AddChild("unit3", new LocaleValue("单位包材", this.Context.UserLocale.LCID));

item.AddChild("unit5", new LocaleValue("单位返工成品", this.Context.UserLocale.LCID));

item.AddChild("unit1", new LocaleValue("单位制造费用", this.Context.UserLocale.LCID));

item.AddChild("unit4", new LocaleValue("单位人工", this.Context.UserLocale.LCID));

}

return header;

}

产品问题简单账表，在子列标题，增加字段

产品问题 简单账表，在子列标题，增加字段

恭喜您！

产品问题
简单账表，在子列标题，增加字段

产品问题简单账表，在子列标题，增加字段