using Kingdee.BOS.Core.Bill.PlugIn;using Kingdee.BOS.Core.DynamicForm;using Kingdee.BOS.Core.DynamicForm.PlugIn.Args;

public override void BarItemClick(BarItemClickEventArgs e){base.BarItemClick(e);if (e.BarItemKey == "HelloWorld"){this.View.ShowMessage("Hello world!",MessageBoxType.Notice);}}

AbstractDynamicFormDataBinder

动态表单数据绑定器抽象类

AbstractDynamicFormPlugIn

动态表单插件抽象基类

AbstractDynamicWebFormBuilderPlugIn

动态表单页面元数据构建插件

AbstractOperationServicePlugIn

操作服务插件抽象类

IDynamicFormModelPlugIn

动态表单Model层插件控制接口；实现本接口的插件，可以接收Model层的事件

IDynamicFormViewPlugIn

动态表单View层插件接口；实现本接口的插件可以接收动态表单View层事件

表单插件

单据插件

Kingdee.BOS.Core.Bill.PlugIn.AbstractBillPlugIn

基础资料插件

Kingdee.BOS.Core.Base.PlugIn.AbstractBasePlugIn

动态表单插件

Kingdee.BOS.Core.DynamicForm.PlugIn.AbstractDynamicFormPlugIn

列表插件

列表插件

Kingdee.BOS.Core.List.PlugIn.AbstractListPlugIn

AfterBarItemClick

菜单单击事件完成后处理扩展接口

AfterBindData

绑定数据后事件处理后扩展接口

AfterButtonClick

按钮单击之后调用

AfterCopyRow

分录行拷贝后调用

AfterDoOperation

操作完成后调用

AfterEntryBarItemClick

分录菜单单击事件处理扩展接口

AfterF7Select

基础资料选择返回后调用

AfterToolBarItemClick

工具栏单击事件处理扩展接口

BarItemClick

主菜单单击事件处理扩展接口

BeforeBindData

绑定数据前事件处理后扩展接口，主要用于加载数据到界面前对控件状态进行设置

BeforeClosed

页面准备关闭

BeforeDoOperation

操作开始前调用

BeforeF7Select

基础资料界面调出之前抛出

ButtonClick

按钮单击时调用

EntityRowClick

分录行单击事件

EntityRowDoubleClick

分录行双击事件

EntryBarItemClick

分录菜单单击事件处理扩展接口

EntryButtonCellClick

表格按钮单击时调用

FieldLabelClick

字段标题单击事件

FireEntryCheck

单据体列全选事件

ListViewClick

列表控件单击事件

OnInitialize

页面初始化

TabItemSelectedChange

页签控件的页签选中事件

ToolBarItemClick

工具栏单击事件处理扩展接口

TreeDragDrop

KDTree 拖拽事件

TreeNodeClick

TreeView 节点单击之后调用

TreeNodeDoubleClick

TreeView 节点双击之后调用

AfterCreateNewData

业务对象创建后的扩展接口

AfterCreateNewEntryRow

新增、插入、多行输入后调用

BeforeUpdateValue

值改变更新前的扩展接口

CreateNewData

创建新业务对象扩展接口，插件可以更加需要自己创建对象

DataChanged

字段值改变后扩展接口

///<summary>///界面初始化///</summary>///<param name="e"></param>public override void OnInitialize(Core.DynamicForm.PlugIn.Args.InitializeEventArgs e){//根据列表的formid，获取元数据metadata = (FormMetadata)ServiceHelper.MetaDataServiceHelper.Load(this.View.Context, this.View.ParentFormView.BillBusinessInfo.GetForm().Id);//设置标题 - -！string strTitle = string.Format("{1}-[{0}]",metadata.GetLayoutInfo().GetFormAppearance().Caption,this.View.LayoutInfo.GetFormAppearance().Caption);LocaleValue formTitle =new LocaleValue();formTitle.Add(new KeyValuePair<int, string>(this.Context.UserLocale.LCID, strTitle));this.View.SetFormTitle(formTitle);List<EnumItem> list =new List<EnumItem>();//循环检测哪些字段允许批量修改,加入列表foreach (Field fieldin metadata.BusinessInfo.GetFieldList()){if ((field.FunControl &Field.FUNCONTROL_BULK_EDIT) !=Field.FUNCONTROL_BULK_EDIT) continue;//修改时隐藏的字段不予显示Appearance app = metadata.GetLayoutInfo().GetAppearance(field.Key);if (app != null){if ((app.Visible &Appearance.VIS_EDIT) != Appearance.VIS_EDIT)continue;}_lstFields.Add(field);EnumItem item = new EnumItem();item.Value = field.Key;item.Caption = field.Name;list.Add(item);}//排序并将list加入到下拉列表list = list.OrderBy(p => p.Caption[this.View.Context.UserLocale.LCID]).ToList();if (list.Count != 0){selectedFielKey = list.FirstOrDefault().Value;}this.View.GetControl<ComboFieldEditor>("FCombo").SetComboItems(list);}

public override void CreateNewData(BizDataEventArgs e){if (!billFormId.IsNullOrEmptyOrWhiteSpace()){DynamicObject obj =BusinessDataServiceHelper.LoadBillTypePara(context,businessInfo, formId, false);e.BizDataObject = obj;}base.CreateNewData(e);}

///<summary>///创建数据包事件处理；由插件处理数据包的创建过程，界面仅展示///</summary>///<param name="e"></param>public override void CreateNewData(BizDataEventArgs e){// 创建本界面需要的数据对象e.BizDataObject = new DynamicObject(this.View.OpenParameter.FormMetaData.BusinessInfo.GetDynamicObjectType());BusinessInfo info = this.View.OpenParameter.FormMetaData.BusinessInfo;// 给角色表格赋值Entity resultEntity = info.GetEntity("FEntity");Field seqField = info.GetField("FSeq");Field nameField = info.GetField("FName");Field statusField = info.GetField("FStatus");Field messageField = info.GetField("FMessage");Field typeField = info.GetField("FType");DynamicObjectCollection resultEntityData = (DynamicObjectCollection)resultEntity.DynamicProperty.GetValue(e.BizDataObject);int row = 0;foreach (OperateResult rowResultin _results){// 添加新行DynamicObject rowData =new DynamicObject(resultEntity.DynamicObjectType);// 给行中的字段赋值seqField.DynamicProperty.SetValue(rowData, row + 1);nameField.DynamicProperty.SetValue(rowData, rowResult.Name);statusField.DynamicProperty.SetValue(rowData, (rowResult.SuccessStatus ?"1" : "0"));messageField.DynamicProperty.SetValue(rowData, rowResult.Message);typeField.DynamicProperty.SetValue(rowData, ((int)rowResult.MessageType).ToString());resultEntityData.Add(rowData);row++;}}

///<summary>///创建新的分录行事件///</summary>///<param name="e"></param>public override void AfterCreateNewEntryRow(CreateNewEntryEventArgs e){base.AfterCreateNewEntryRow(e);if (e.Entity.Key.Equals(CONST_ENG_Route.CONST_FSubEntity.ENTITY_FSubEntity)){IEnumerable<DynamicObject> subEntryDataCol =this.Model.GetEntityDataObject(e.Entity);if (e.Row == subEntryDataCol.Count() - 1)  // 插入行不赋值{// 设置工序号=上取整((MAX(工序号)+1)/10)*10，且不大于9999int maxOperNumber = subEntryDataCol.Select(w => w.GetDynamicObjectItemValue<int>(CONST_ENG_Route.CONST_FSubEntity.ORM_OperNumber)).Max();int newOperNumber = (int)Math.Ceiling(((decimal)maxOperNumber + 1) / 10) * 10;this.Model.SetValue(CONST_ENG_Route.CONST_FSubEntity.KEY_FOperNumber, newOperNumber > 9999 ? 9999 : newOperNumber, e.Row);}}}

public override void AfterCreateNewData(EventArgs e){base.AfterCreateNewData(e);OQLFilter ofilter = new OQLFilter();ofilter.Add(new OQLFilterHeadEntityItem { FilterString = string.Format(" FORGID ={0} ",this.Model.Context.CurrentOrganizationInfo.ID) });DynamicObject[] obj =BusinessDataServiceHelper.Load(this.View.Context,"BAS_MAILDEFAULTSET", null, ofilter);if (obj != null && obj.Count() > 0){DynamicObject defaultSet = obj[0];this.View.Model.SetValue("FMessageType", defaultSet["FMessageType"]);this.View.Model.SetValue("FServer", defaultSet["FOutgoingMailServer"]);this.View.Model.SetValue("FSMTPPort", defaultSet["FSMTPPort"]);}}

///<summary>///模型数据包创建完毕，显示订单界面///</summary>///<param name="e"></param>public override void AfterCreateModelData(EventArgs e){if (listVersions != null && listVersions.Count() > 0){baseOrderData = SCMCommon.DeserializeJsonStringToDynamicObject(orderBusinessInfo, listVersions[0].JsonData);ShowOrderBillVersion();}}

public override void BeforeBindData(EventArgs e){base.BeforeBindData(e);//基础资料if (_modelTypeId == ElementType.ELEMENTTYPE_BASE.ToString()){this.View.Model.CreateNewEntryRow("FSearchControl");}else if (_modelTypeId == ElementType.ELEMENTTYPE_BILL.ToString())//业务单据{this.View.Model.CreateNewEntryRow("FFieldParamControl");}// 操作参数this.View.Model.CreateNewEntryRow("FPARAMOPERATION");}

public override void AfterBindData(EventArgs e){base.AfterBindData(e);//隐藏菜单项this.View.GetMainBarItem("tbNew").Visible =false;//显示分录菜单项this.View.GetBarItem("Fentity","tbAdd").Enabled = true;//基础资料if (_modelTypeId == ElementType.ELEMENTTYPE_BASE.ToString()){this.View.StyleManager.SetVisible("FTab_Field",null, false);}else if (_modelTypeId == ElementType.ELEMENTTYPE_BILL.ToString())//业务单据{//单据不含单据类型字段时，字段参数页签屏蔽if (this._metaData.GetLayoutInfo().GetFieldAppearances().Any(f => fis BillTypeFieldAppearance)){this.View.StyleManager.SetVisible("FTab_Field",null, true);}}}

public override void AfterBindData(EventArgs e){//获取单据体表格,参数为单据体Key，示例代码假设为FEntityEntryGrid grid = this.View.GetControl<EntryGrid>("FEntity");//设置第一行的背景色，参数：颜色，6位16进制符号，每2位代表一种基色；从0开始，行序号grid.SetRowBackcolor("#FFC080", 0);//设置第二行F1字段的背景色，参数：字段Key；颜色；行序号grid.SetBackcolor("F1","#FFC080", 1);}

public class SaleCollectFilter : AbstractCommonFilterPlugIn{public override void OnLoad(EventArgs e){base.OnLoad(e);//设置日期缺省值this.View.Model.SetValue("FStartDate", dateFrom.ToString("yyyy-MM-dd"));this.View.Model.SetValue("FEndDate", dateTo.ToString("yyyy-MM-dd"));//隐藏过滤界面排序页签this.View.StyleManager.SetVisible("FTab_P21",null, false);}}

public class SPMPromotionPolicyList : AbstractListPlugIn{public override void OnLoad(EventArgs e){base.OnLoad(e);// 隐藏分组滑动控件（默认不展开）this.View.GetControl<SplitContainer>("FSpliter").HideFirstPanel(true);this.View.GetControl("FPanel").SetCustomPropertyValue("BackColor","#FFEEEEEE");}}

public override void BeforeClosed(BeforeClosedEventArgs e){object isDataChanged = this.View.OpenParameter.GetCustomParameter("Changed");if (isDataChanged != null && (bool)isDataChanged){this.View.ParentFormView.Refresh();this.View.SendDynamicFormAction(this.View.ParentFormView);}base.BeforeClosed(e);}

public override void BeforeClosed(BeforeClosedEventArgs e){this.View.ReturnToParentWindow(_data);base.BeforeClosed(e);}

///<summary>///界面关闭前事件：判断用户是否修改了数据，提示保存///</summary>///<param name="e"></param>public override void BeforeClosed(BeforeClosedEventArgs e){if (this._dataChanged ==true) // 仅关注模型数据发生了改变的情况{e.Cancel = true;string msg = "内容已经修改，是否保存？";this.View.ShowMessage(msg,MessageBoxOptions.YesNoCancel,new Action<MessageBoxResult>((result) =>{if (result == MessageBoxResult.Yes) // 保存{this.View.GetControl("FDesignPanel").InvokeControlMethod("Save");}else if (result == MessageBoxResult.No)// 不要保存{this._dataChanged =false;this.View.Close();}}));}}

public override void BeforeSave(BeforeSaveEventArgs e){DynamicObject doGradeScheme = this.Model.GetValue("FScheme")as DynamicObject;decimal deSumScore =Convert.ToDecimal(this.Model.GetValue("FSumScore"));int iGradeSchemeId =Convert.ToInt32(doGradeScheme["Id"]);// 保存前判断当前信用评分表的综合得分属于哪一个信用等级标准DynamicObjectCollection docGrades = CreditServiceHelper.GetCreditGrades(this.Context, 0, iGradeSchemeId);for (int i = 0; i < docGrades.Count(); i++){DynamicObject doGrade = docGrades[i];decimal deScoreFrom =Convert.ToDecimal(doGrade["FSCOREFROM"]);decimal deScoreTo = Convert.ToDecimal(doGrade["FSCORETO"]);if(deSumScore >= deScoreFrom && deSumScore <= deScoreTo){this.View.Model.SetValue("FGrade",Convert.ToInt32(doGrade["FID"]));this.View.Model.SetValue("FSuggestion", doGrade["FDESCRIPTION"]);}}}

服务插件

Kingdee.BOS.Core.DynamicForm.PlugIn.AbstractOperationServicePlugIn

AfterExecuteOperationTransaction

执行操作事务后的逻辑处理,后续事情不影响当前操作事务的可以放在此处理

BeforeExecuteOperationTransaction

执行操作事务前事件，通知插件对要处理的数据进行排序等预处理

BeginOperationTransaction

调用操作事务前触发

EndOperationTransaction

调用操作事务成功后触发

InitializeOperationResult

操作成功后触发

OnAddValidators

通过此事件，通知插件进行添加自定义数据校验器

OnPrepareOperationServiceOption

通过此事件，通知插件进行选项设置

OnPreparePropertys

准备操作对象实体属性事件，在此事件中可以将校验过程需要的属性对应的Key添加进来以便统一从数据库中加载数据

// 保存操作事务前，计算单据上的“未结算关联数量”public override void BeforeExecuteOperationTransaction(BeforeExecuteOperationTransaction e){if (e.SelectedRows ==null || e.SelectedRows.Count() == 0){// 没有数据，取消操作（通常此类判断应在web端进行，避免不必要的资源消耗，此处仅示例如何取消操作）e.Cancel = true;return;}DynamicObject[] objs = (from pin e.SelectedRows select p.DataEntity).ToArray();foreach (DynamicObject datain objs){DynamicObjectCollection dataentrys = data["TransferDirectEntry"]as DynamicObjectCollection;foreach (DynamicObject entryin dataentrys){//“未结算关联数量”＝“调拨数量”－“关联退货数量”－“结算关联数量”。decimal qty = Convert.ToDecimal(entry["Qty"]);decimal baseQty =Convert.ToDecimal(entry["BaseQty"]);decimal receiveQty =Convert.ToDecimal(entry["ReceiveQty"]);decimal baseJoinQty =Convert.ToDecimal(entry["BaseJoinQty"]);decimal baseSettQty =Convert.ToDecimal(entry["JoinBaseSettQty"]);decimal SettQty =Convert.ToDecimal(entry["JoinSettleQty"]);entry["JoinUnSettleQty"] = qty - receiveQty - SettQty;entry["JoinBaseUnSettQty"] = baseQty - baseJoinQty - baseSettQty;}}}

DataEntitys

本次操作事务处理成功的数据实体集合

SelectedRows

当前操作校验通过的所有行对象

public override void AfterExecuteOperationTransaction(AfterExecuteOperationTransaction e){//审核时，如果弹出信用相关提示警示信息时，e.DataEntitys将没有记录。此时直接退出if (e.DataEntitys.IsNullOrEmpty() || e.DataEntitys.Count() == 0){return;}foreach (var dataEntityin e.DataEntitys){if (this.IsCanSoureBillPush(dataEntity))//申请借款，下推付款申请单{DynamicObject[] objs = new DynamicObject[1] { dataEntity };//初始化备用信息this.OnInit(objs);//生成下游单据this.ProduceBill(this.OperationResultas ConvertOperationResult);}}}

//更新操作前，获取删除的分录数据，在更新后做处理public override void BeginOperationTransaction(BeginOperationTransactionArgs e){//获取删除的行IDbDriver driver = new Kingdee.BOS.App.Data.OLEDbDriver(this.Context);IDataManager manager = DataManagerUtils.GetDataManager(this.BusinessInfo.GetDynamicObjectType(), driver);ISaveDataSet updateData = manager.GetSaveDataSet(e.DataEntitys.ToArray());DeleteRows = updateData.Tables["T_SP_PICKMTRLDATA"].DeleteRows;if (DeleteRows != null && DeleteRows.Length > 0){List<long> lstDeleteIds = DeleteRows.Select(w => w.Oid).ToList();//根据领料单ENTRYID获取关联的源单SRCENTRYIDlistInStockEntryId = ServiceFactory.GetSpInStockService(this.Context).GetInStcokEntryByPickMtrlEntryId(this.Context, lstDeleteIds);base.BeginOperationTransaction(e);}}

//更新操作后，根据更新前获取的删除分录的数据，重新计算领料标识public override void EndOperationTransaction(EndOperationTransactionArgs e){base.EndOperationTransaction(e);ISpInStockService service= ServiceFactory.GetSpInStockService(this.Context);// 检测简单领料分录是否仍存在该分录ID上拉过来的行，否则更新简单入库的分录行领料标识if (listInStockEntryId !=null && listInStockEntryId.Count > 0){// 批量检测service.ResetIsPickInInStcokEntry(this.Context, listInStockEntryId);}foreach (var dataEntityin e.DataEntitys){IEnumerable<long> lstEntryId = dataEntity.GetDynamicObjectItemValue<DynamicObjectCollection>(ENTITY_ORM_Entity).Where(w => w.GetDynamicObjectItemValue<string>( ORM_SrcBillType_Id) == SCMFormIdConst.SpInStockBill).Distinct().Select(w => w.GetDynamicObjectItemValue<long>( ORM_SrcEnteryId));// 根据分录ID重置该分录行的领料标识（批量更新）service.UpdateIsPickInInStcokEntry(this.Context, lstEntryId.ToList());}}

public override void OnInitialize(InitializeEventArgs e){base.OnInitialize(e);List<EnumItem> list =new List<EnumItem>();foreach (Field fieldin this.View.BusinessInfo.GetFieldList()){EnumItem item = new EnumItem();item.Caption = field.Name;item.EnumId = field.Key;item.Value = field.Key;list.Add(item);}this.View.GetControl<ComboFieldEditor>("FCombo").SetComboItems(list);}

public override void EntryBarItemClick(BarItemClickEventArgs e){base.EntryBarItemClick(e);if (e.BarItemKey == "tbQueryInventory"){ShowQueryInventory();}}private void ShowQueryInventory(){DynamicObject row;int rowIndex;// 直接获取当前分录行返回的是分录行对象。if (this.Model.TryGetEntryCurrentRow("FEntity",out row, out rowIndex)){ListShowParameter parameter =new ListShowParameter();parameter.FormId = "STK_Inventory";   // 即时库存的FormIdparameter.MultiSelect = false;parameter.ListFilterParameter.Filter = string.Format(" FMaterialId = '{0}' ",Convert.ToString(row["FBase_Id"]));this.View.ShowForm(parameter);}}

private void ShowQueryInventory(){// 获取当前行int rowIndex = this.Model.GetEntryCurrentRowIndex("FEntity");if (rowIndex > -1) //判断当前行有数据{// 取指定行的物料（ide中设置key为FBase）字段数据DynamicObject materialObj = (DynamicObject)this.Model.GetValue("FBase", rowIndex);ListShowParameter parameter =new ListShowParameter();parameter.FormId = "STK_Inventory";parameter.MultiSelect = false;parameter.ListFilterParameter.Filter = string.Format(" FMaterialId = '{0}' ", materialObj["Id"].ToString());this.View.ShowForm(parameter);}}

public override void AuthPermissionBeforeF7Select(AuthPermissionBeforeF7SelectEventArgs e){base.AuthPermissionBeforeF7Select(e);if (e.FieldKey == "FBase"){e.IsIsolationOrg = false;}}

public override void BeforeDoOperation(BeforeDoOperationEventArgs e){base.BeforeDoOperation(e);if (e.Operation.FormOperation.Operation.Equals("DRAFT",StringComparison.OrdinalIgnoreCase)){this.Model.SetValue("FBillTypeID",null);}}

public override void BeforeF7Select(BeforeF7SelectEventArgs e){base.BeforeF7Select(e);if (e.FieldKey == "FSupplierId1"){string filter = " FCreateDate > '2014-03-20' ";if (string.IsNullOrEmpty(e.ListFilterParameter.Filter)){e.ListFilterParameter.Filter = filter;}else{e.ListFilterParameter.Filter += " AND " + filter;}}}

public override void OnAddValidators(AddValidatorsEventArgs e){base.OnAddValidators(e);SaveValidator saveValidator =new SaveValidator();saveValidator.EntityKey = "FBillHead";e.Validators.Add(saveValidator);}

public override void Validate(ExtendedDataEntity[] dataEntities,ValidateContext validateContext, Kingdee.BOS.Context ctx){if (dataEntities == null || dataEntities.Length == 0){return;}Dictionary<long,decimal> dictErrMaterialId = new Dictionary<long,decimal>();//取所有物料List<long> listMaterialId =new List<long>();foreach (ExtendedDataEntity entityObjin dataEntities){DynamicObjectCollection collection = (DynamicObjectCollection)entityObj["FEntity"];foreach (DynamicObject rowObjin collection){listMaterialId.Add((long)rowObj["FBase_Id"]);}}string sql = " select a.FMATERIALID, sum(a.FBASEQTY) FQTY from  T_STK_INVENTORY a where exists (select 1 from TABLE(fn_StrSplit(@FMATERIALID, ',',1)) t where t.FID = a. FMATERIALID) group by FMATERIALID ";SqlParam param = new SqlParam("@FMATERIALID",KDDbType.udt_inttable, listMaterialId.Distinct().ToArray());using (IDataReader dr =DBUtils.ExecuteReader(this.Context, sql, param)){while (dr.Read()){decimal qty = Convert.ToDecimal(dr["FQTY"]);if (qty > 100){dictErrMaterialId.Add(Convert.ToInt64(dr["FMATERIALID"]), qty);}}}foreach (ExtendedDataEntity entityObjin dataEntities){DynamicObjectCollection collection = (DynamicObjectCollection)entityObj["FEntity"];foreach (DynamicObject rowObjin collection){if (dictErrMaterialId.ContainsKey((long)rowObj["FBase_Id"])){ValidationErrorInfo errinfo =new ValidationErrorInfo("FMATERIALID",Convert.ToString(entityObj.DataEntity["Id"]), entityObj.DataEntityIndex,Convert.ToInt32(rowObj["Id"]),"SaveValidator", "库存数量大于100","校验失败",ErrorLevel.Error);validateContext.AddError(entityObj, errinfo);}}}}

public override void AfterBarItemClick(AfterBarItemClickEventArgs e){base.AfterBarItemClick(e);if (e.BarItemKey == "tbSave"){this.View.LockField("FBase1",true);this.View.LockField("FBase2",true);}}

KDV_ID

日志ID

int

自增长

KDV_UserID

操作用户

Int

关联用户表ID

KDV_Date

操作时间

Datetime

缺省getdate

KDV_Content

日志内容

Nvarchar(2000)

public override void AfterExecuteOperationTransaction(AfterExecuteOperationTransaction e){base.AfterExecuteOperationTransaction(e);MetaDataService metaService =new MetaDataService();FormMetadata formMetaData = (FormMetadata)metaService.Load(this.Context,"1823871d-b9cf-4d8b-93af-39c0c37011a5");DynamicObjectType dt = formMetaData.BusinessInfo.GetDynamicObjectType();DynamicObject obj = new DynamicObject(dt);dt.Properties["KDV_UserID_Id"].SetValueFast(obj,this.Context.UserId);dt.Properties["KDV_Content"].SetValueFast(obj,"保存");ISaveService saveService =ServiceHelper.GetService<ISaveService>();saveService.Save(this.Context,new DynamicObject[] { obj });}

public override void AfterExecuteOperationTransaction(AfterExecuteOperationTransaction e){base.AfterExecuteOperationTransaction(e);SequenceReader sequence =new SequenceReader(this.Context);int[] ids = (int[])sequence.GetSequence("KDV_stk_ReceiptLog", 1);int id = ids[0];string sql = " insert into KDV_stk_ReceiptLog(FID, KDV_UserID, KDV_Content) values (@FID, @KDV_UserID, @KDV_Content) ";SqlParam[] sqlParams =new SqlParam[3];sqlParams[0] = new SqlParam("@FID", KDDbType.Int64, id);sqlParams[1] = new SqlParam("@KDV_UserID",KDDbType.Int64, this.Context.UserId);sqlParams[2] = new SqlParam("@KDV_Content",KDDbType.String, "保存");DBUtils.Execute(this.Context, sql, sqlParams);}