表单插件批量修改子单据体数据库数据
public class buchonggongxu : AbstractDynamicFormPlugIn { public override void AfterBarItemClick(AfterBarItemClickEventArgs e) { if (e.BarItemKey == "Test") { EntryEntity FEntity = this.View.BusinessInfo.GetEntryEntity("FSubEntity"); DynamicObjectCollection d = this.View.Model.GetEntityDataObject(FEntity); var sql = "UPDATE T_SFC_OPERPLANNINGDETAIL SET F_BEC_SGX=@FbecSgx , F_BEC_XGX=@FbecXgx WHERE FDETAILID=@Id"; var SqlObjectList=new List<SqlObject>(); for (int i = 0; i < d.Count; i++) { var sqlParameterList = new List<SqlParam>(); sqlParameterList.Add(new SqlParam("@Id", KDDbType.Int32, d[i]["Id"])); sqlParameterList.Add(new SqlParam("@FbecSgx", KDDbType.Int32, d[i - 1]["ProcessId_Id"])); sqlParameterList.Add(new SqlParam("@FbecXgx", KDDbType.Int32, d[i + 1]["ProcessId_Id"])); var sqlObj = new SqlObject(sql, sqlParameterList); SqlObjectList.Add(sqlObj); } var returnValue = DBUtils.ExecuteBatch(this.Context, SqlObjectList); } this.View.UpdateView(); } }
表单插件批量修改子单据体数据库数据
public class buchonggongxu : AbstractDynamicFormPlugIn { public override void AfterBarItemClick(AfterBarItemClickEventArgs e)...
点击下载文档
本文2024-09-16 17:13:23发表“云星空知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3cloud-14320.html
您需要登录后才可以发表评论, 登录登录 或者 注册
最新文档
热门文章