UCML针对数据表的修改自定义维护数据变更记录

1、BPO新建服务端函数，在服务端业务提交后调用，参数:VCName

DBLayer.ProjectM.yq_projectplan objyq_projectplan = new DBLayer.ProjectM.yq_projectplan();
DBLayer.ProjectM.yq_projectplanInfo objyq_projectplanInfo = new DBLayer.ProjectM.yq_projectplanInfo();
string result = "";
DataTable deltaTable = BC_projectplansLBase.deltaTable;
//获取VC字段
DataTable fieldArray = GetFieldArray(vcname);
//用户信息
string userID = base.loginUserInfo.UserOID.ToString();
string userName = base.loginUserInfo.PersonName .ToString();
string tableName = "yq_projectplan";
string oldValue = "",newValue = "";
UCMLCommon.DataChangeLog dlog = new UCMLCommon.DataChangeLog();

for (int i = 0; i < deltaTable.Rows.Count; i++)
{
   if (deltaTable.Rows[i].RowState == DataRowState.Modified){
        string COID = deltaTable.Rows[i]["yq_projectplanOID"].ToString();//数据主键 
           string NewOID = Guid.NewGuid().ToString();
           for(int j=0;j<fieldArray.Rows.Count;j++){
               string fieldname = fieldArray.Rows[j]["FieldName"].ToString();
               string fielddesc = fieldArray.Rows[j]["ChineseName"].ToString();
               //遍历判断每个字段
               if (!deltaTable.Rows[i][""+fieldname+""].Equals(deltaTable.Rows[i][""+fieldname+"", DataRowVersion.Original]))
            {
                   oldValue = deltaTable.Rows[i][""+fieldname+"", DataRowVersion.Original].ToString();
                newValue = deltaTable.Rows[i][""+fieldname+""].ToString();
　　　　　　　　　　　　　//插入单个字段的修改记录　
                   string resultlog = dlog.SetInsertLog(NewOID,userID,userName,tableName,COID,fieldname,fielddesc,oldValue,newValue,"修改","数据修改");
               }               
           }      
           //插入针对数据行变更的修改记录
           string resultlogm = dlog.SetInsertLogM(NewOID,userID,userName,tableName,COID,"修改","修改保存成功");
   }
}

2、辅助函数

//查询当前VC前台显示的字段集合，用作辅助遍历判断是否修改值
StringBuilder commandText = new StringBuilder();
commandText.Append(" select FieldName,ChineseName from AppletColumn where AppletOID =(select AppletOID from Applet where AppletName = '"+vcname+"')");
SysDBModel.CodeValue Codeobj = new SysDBModel.CodeValue();
DataTable CodeTable = new DataTable();
Codeobj.ExecuteQuery(commandText.ToString(), CodeTable);
return CodeTable;