public override void DataChanged(Kingdee.BOS.Core.DynamicForm.PlugIn.Args.DataChangedEventArgs e)
{
base.DataChanged(e);
if (e.Field.Key.EqualsIgnoreCase("FBusDep_Filter"))
{
//设置多选下拉列表_业务部
this.SetMulComBoDep();
}
}
public override void DataChanged(Kingdee.BOS.Core.DynamicForm.PlugIn.Args.DataChangedEventArgs e)
{
base.DataChanged(e);
if (e.Field.Key.EqualsIgnoreCase("FQueryStyle_Filter"))
{
//按照查询方式设置默认值
this.SetDefaultValueByQueryStyle();
}
}
public override void DataChanged(Kingdee.BOS.Core.DynamicForm.PlugIn.Args.DataChangedEventArgs e)
{
base.DataChanged(e);
if (e.Field.Key.EqualsIgnoreCase("FMulSelOrgList_Filter"))
{
//设置多选下拉列表_部门
this.SetMulComboDept();
}
}
public override void DataChanged(Kingdee.BOS.Core.DynamicForm.PlugIn.Args.DataChangedEventArgs e)
{
String key = e.Field.Key.ToUpperInvariant();
if (key == "FPROORDERID")
{
this.GetPH(e);
}
else
{
base.DataChanged(e);
}
}
private void GetPH(Kingdee.BOS.Core.DynamicForm.PlugIn.Args.DataChangedEventArgs e)
{
DynamicObject scOrder = base.Model.GetValue("FPROORDERID", e.Row) as DynamicObject;
if (scOrder != null && scOrder["Number"] != null)
{
string orderNumber = scOrder["Number"].ToString();
string strSql = string.Format(@"select my.F_KD_SCPH from T_PRD_MO m inner join T_PRD_MOENTRY my on m.FID = my.FID where m.FBILLNO = '{0}'", orderNumber);
string queryReslut = DBUtils.ExecuteScalar <string>(base.Context, strSql, "no", null);
if (!queryReslut.Equals("no"))
{
base.Model.SetValue("F_PBCJ_ph", queryReslut, e.Row);
}
}
}
public override void DataChanged(Kingdee.BOS.Core.DynamicForm.PlugIn.Args.DataChangedEventArgs e)
{
base.DataChanged(e);
string key = e.Field.Key.ToUpperInvariant(); //值变化key
string formID = this.Model.BusinessInfo.GetForm().Id; //单据formID ER_ExpReimbursement-费用报销单;ER_ExpReimbursement_Travel-差旅费报销单
if (key.Equals("FPROPOSERID")) //申请人
{
long proPoserId = Convert.ToInt64(e.NewValue);
if (proPoserId > 0)
{
String voucherIds = "";//需要处理的凭证ID
//查询法人账簿中自定义字段年份期间FKLYEARPERIOD为null的凭证id,根据FYEAR,FPERIOD组合，为FKLYEARPERIOD赋值
string strSql = string.Format(@"/*dialect*/SELECT FVOUCHERID FROM T_GL_VOUCHER WHERE FACCOUNTBOOKID = 963793 and FINVALID = 0 and FDOCUMENTSTATUS = 'C' AND (FKLYEARPERIOD = NULL OR FKLYEARPERIOD = ' ' OR FKLYEARPERIOD = '')");
DynamicObjectCollection WaitDealVoucher = DBUtils.ExecuteDynamicObject(this.Context, strSql);
if (WaitDealVoucher != null && WaitDealVoucher.Count() > 0)
{
foreach (DynamicObject item in WaitDealVoucher)
{
voucherIds += ",'" + item["FVOUCHERID"].ToString() + "'";
}
voucherIds = voucherIds.Substring(1);
List <string> updateArray = new List <string>();
string updateSql_1 = string.Format(@"/*dialect*/UPDATE T_GL_VOUCHER SET FKLYEARPERIOD = CONCAT(FYEAR,FPERIOD) WHERE FPERIOD>=10 AND FVOUCHERID IN ({0})", voucherIds);
updateArray.Add(updateSql_1);
string updateSql_2 = string.Format(@"/*dialect*/UPDATE T_GL_VOUCHER SET FKLYEARPERIOD = CONCAT(FYEAR,0,FPERIOD) WHERE FPERIOD<10 AND FVOUCHERID IN ({0})", voucherIds);
updateArray.Add(updateSql_2);
DBUtils.ExecuteBatch(this.Context, updateArray, 100);
}
Decimal borrowAmount = this.ShowCheckedBorrowAmountFormLedger(proPoserId);
//Decimal borrowAmount = this.ShowCheckedBorrowAmount(proPoserId);
this.Model.SetValue("FCheckBorrowAmt", borrowAmount > 0 ? borrowAmount : 0);
}
else
{
this.Model.SetValue("FCheckBorrowAmt", 0);
}
}
if (key.Equals("FCHECKBORROWAMT") && Convert.ToDecimal(this.Model.GetValue("FCheckBorrowAmt")) < 0)//借款余额
{
this.Model.SetValue("FCheckBorrowAmt", 0);
}
}
