public virtual JArray GetFormAppDirtyFields(HttpContext context) { YZRequest request = new YZRequest(context); string appName = request.GetString("AppName"); string key = request.GetString("Key"); ModifyRecordCollection modifies; using (BPMConnection cn = new BPMConnection()) { cn.WebOpen(); modifies = SpoorService.GetFormAppDirtyFields(cn, appName, key); } JArray rv = new JArray(); foreach (ModifyRecord modify in modifies) { JObject item = new JObject(); rv.Add(item); item["DataSourceName"] = modify.TableIdentity.DataSourceName; item["TableName"] = modify.TableIdentity.TableName; item["PrimaryKey"] = modify.PrimaryKey; item["ColumnName"] = modify.ColumnName; } return(rv); }
public virtual JArray GetTaskDirtyFields(HttpContext context) { YZRequest request = new YZRequest(context); int taskid = request.GetInt32("TaskID"); ModifyRecordCollection modifies; using (BPMConnection cn = new BPMConnection()) { cn.WebOpen(); modifies = SpoorService.GetTaskDirtyFields(cn, taskid); } JArray rv = new JArray(); foreach (ModifyRecord modify in modifies) { JObject item = new JObject(); rv.Add(item); item["DataSourceName"] = modify.TableIdentity.DataSourceName; item["TableName"] = modify.TableIdentity.TableName; item["PrimaryKey"] = modify.PrimaryKey; item["ColumnName"] = modify.ColumnName; } return(rv); }
public virtual JArray GetFieldModifies(HttpContext context) { YZRequest request = new YZRequest(context); string DataSource = request.GetString("DataSource", ""); string TableName = request.GetString("TableName"); string ColumnName = request.GetString("ColumnName"); string CKeyName = request.GetString("CKeyName", ""); string CKeyValue = request.GetString("CKeyValue"); JArray rv = new JArray(); using (BPMConnection cn = new BPMConnection()) { cn.WebOpen(); ModifyRecordCollection modifies = SpoorService.GetFieldSpoor(cn, DataSource, TableName, ColumnName, CKeyValue); foreach (ModifyRecord modify in modifies) { JObject item = new JObject(); rv.Add(item); string userName = modify.Account; User user = User.TryGetUser(cn, modify.Account); if (user != null) { userName = YZStringHelper.GetUserShortName(user.Account, user.DisplayName); } item["Account"] = userName; item["UserSortName"] = userName; item["Value"] = modify.Value; item["ModifyDate"] = YZStringHelper.DateToStringM(modify.ModifyDate); } } return(rv); }