import clr
clr.AddReference('System')
clr.AddReference('System.Data')
clr.AddReference('Kingdee.BOS')
clr.AddReference('Kingdee.BOS.DataEntity')
clr.AddReference('Kingdee.BOS.Core')
clr.AddReference('Kingdee.BOS.App')
clr.AddReference('Kingdee.BOS.App.Core')
clr.AddReference('Kingdee.BOS.ServiceHelper')
from Kingdee.BOS import *
from Kingdee.BOS.Core import *
from Kingdee.BOS.Core.DependencyRules import *
from Kingdee.BOS.Core.Bill import *
from Kingdee.BOS.Core.DynamicForm.PlugIn import *
from Kingdee.BOS.Core.DynamicForm.PlugIn.ControlModel import *
from System import *
from System.Data import *
from Kingdee.BOS.App.Data import *
from System.Collections.Generic import List
from Kingdee.BOS.ServiceHelper import *
from Kingdee.BOS.Core.DynamicForm import *
from Kingdee.BOS.Core.Metadata.EntityElement import *
from Kingdee.BOS.Core.Metadata.FieldElement import *
from Kingdee.BOS.Orm.DataEntity import *
def DataChanged(e):
billObj = this.View.Model.DataObject;
entity=billObj["SaleOrderEntry"];
FBillTypeID= this.Model.GetValue("FBillTypeID")["Number"]
if e.Key=="FMaterialId":
row=e.Row;
number= this.Model.GetValue("FMaterialID",row)["Number"]
FMaterialID= this.Model.GetValue("FMaterialID",row)["ID"]
dbsql = ("SELECT FNUMBER,deptName,CSSName,xmName,xmjd,empName,FMATERIALID FROM [WDI_YFXM] where FNUMBER='{0}' ").format(number);
dbresult = DBServiceHelper.ExecuteDynamicObject(this.Context, dbsql)
if len(dbresult) > 0:
this.Model.SetValue("F_VCDB_Text1",dbresult[0][2],row)
this.Model.SetValue("F_VCDB_Text2",dbresult[0][4],row)
this.Model.SetValue("F_VCDB_Text4",dbresult[0][3],row)
this.Model.SetValue("F_VCDB_Text3",dbresult[0][5],row)