public override void DataChanged(DataChangedEventArgs e)
{
base.DataChanged(e);
if (e.Field.Key== "FSETTLETYPEID")
{
//获取供应商字段值
DynamicObject obj =this.View.Model.GetValue("FRECTUNIT")as DynamicObject;
if (obj==null)
{
this.View.ShowWarnningMessage("请先填写收款单位名称");
this.View.Model.SetValue("FSETTLETYPEID",0,e.Row);
this.View.UpdateView("FSETTLETYPEID",e.Row);
return;
}
//获取当前结算方式
DynamicObject jsfs =this.View.Model.GetValue("FSETTLETYPEID") as DynamicObject;
//组装sql
string sql = string.Format(@"/*dialect*/SELECT t1.FOPENBANKNAME,t0.FBANKCODE,t0.F_AI_TEXT,t0.F_AI_JSFS FROM t_BD_SupplierBank t0 inner join t_BD_SupplierBank_L t1 on(t0.FBANKID=t1.FBANKID) where FSUPPLIERID={0}", obj["Id"]);
//执行sql
DynamicObjectCollection doc = DBUtils.ExecuteDynamicObject(this.Context,sql);
foreach (DynamicObject dyo in doc)
{
if (Convert.ToInt64(dyo["F_AI_JSFS"])==Convert.ToInt64(jsfs["Id"]))
{
if (Convert.ToInt64(dyo["F_AI_JSFS"])==674201)
{
this.View.StyleManager.SetVisible("F_JH_DFYHHH","",true);
this.View.Model.SetValue("F_JH_DFYHHH", dyo["F_AI_Text"], e.Row);
this.View.UpdateView("F_JH_DFYHHH", e.Row);
}
this.View.Model.SetValue("FEACHBANKACCOUNT", dyo["FBANKCODE"], e.Row);
this.View.Model.SetValue("FEACHBANKNAME", dyo["FOPENBANKNAME"], e.Row);
this.View.UpdateView("FEACHBANKACCOUNT", e.Row);
this.View.UpdateView("FEACHBANKNAME", e.Row);
}
}
}
推荐阅读
您的鼓励与嘉奖将成为创作者们前进的动力,如果觉得本文还不错,可以给予作者创作打赏哦!
请选择打赏金币数 *