单据下推的问题,需要大神们提供方法
金蝶云社区-Fibo
Fibo
0人赞赏了该文章 944次浏览 未经作者许可,禁止转载编辑于2014年03月24日 16:31:19

要求是单据下推之后激活AfterConvert 方法,之后我需要一个 sql语句把值取出来,再附给下游单据。我在下游单据以前写过一个插件,但下推后不启动Datachanged方法,没办法,只能写两个插件,当然如果能激活Datachanged就更好了。单据插件是这样的,[code] public override void DataChanged(DataChangedEventArgs e)
{
if (e.Field.Key == "FSETTLETYPEID")
{
base.DataChanged(e);
DynamicObject settleTypeId = this.View.Model.GetValue("FSETTLETYPEID", e.Row) as DynamicObject;
if (settleTypeId != null &&
settleTypeId["Number"] as string == "JSFS01_SYS")
{
DynamicObject useorgid = this.View.Model.GetValue("FPAYORGID") as DynamicObject;
DynamicObject mappingorgid = this.View.Model.GetValue("FSETTLEORGID") as DynamicObject;
string strSql = string.Format(@"select FID from t_Cn_Inneraccount
where fnumber like '%现金%'and fuseorgid={0} and FMAPPINGORGID!={0} and FMAPPINGORGID={1}
", useorgid["Id"], mappingorgid["Id"]);
DynamicObjectCollection collections = DBServiceHelper.ExecuteDynamicObject(this.Context, strSql);
if (collections.IsEmpty() == false)
{
this.View.Model.SetValue("FINNERACCOUNTID", collections[0]["FID"], e.Row);
}[/code]希望各位神仙写稍微细一点,楼主是战斗力为5的渣渣,谢谢哈。。