值更新

写了一个值更新
public class zhiup : AbstractBillPlugIn
{
public override void DataChanged(DataChangedEventArgs e)
{
base.DataChanged(e);
DynamicObjectCollection obj = null;
switch (e.Field.Key)
{
case "FSalesManID":
string sid = Convert.ToString(e.NewValue);
string strSql = "select FMOBILE from T_HR_EMPINFO a inner join V_BD_SALESMAN b on b.FNUMBER=a.FNUMBER and b.fid= " + sid;
obj= DBUtils.ExecuteDynamicObject(this.Context, strSql);

if (obj != null && obj.Count > 0)
{
foreach (DynamicObject sobj in obj)
{
this.Model.SetItemValueByID("F_dianhua", Convert.ToString(sobj["FMOBILE"]), 0);
}
}
break;
}
}
}