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);
}
