public Guid CreateData(Guid flowID, string pkValue)
{
WorkFlowInstalled workFlowRunModel = new WorkFlow().GetWorkFlowRunModel(flowID);
if (workFlowRunModel == null)
{
return(Guid.Empty);
}
IEnumerable <DataBases> dataBases = workFlowRunModel.DataBases;
if (dataBases.Count() == 0)
{
return(Guid.Empty);
}
DataBases dataBases2 = dataBases.First();
WorkFlowData workFlowData = new WorkFlowData();
RoadFlow.Data.Model.WorkFlowData workFlowData2 = new RoadFlow.Data.Model.WorkFlowData
{
ID = Guid.NewGuid(),
InstanceID = Guid.NewGuid(),
LinkID = dataBases2.LinkID,
TableName = dataBases2.Table,
FieldName = dataBases2.PrimaryKey,
Value = pkValue
};
workFlowData.Add(workFlowData2);
return(workFlowData2.InstanceID);
}
public int Update(RoadFlow.Data.Model.WorkFlowData model)
{
string sql = "UPDATE WorkFlowData SET \r\n\t\t\t\tInstanceID=@InstanceID,LinkID=@LinkID,TableName=@TableName,FieldName=@FieldName,Value=@Value\r\n\t\t\t\tWHERE ID=@ID";
SqlParameter[] parameter = new SqlParameter[6]
{
new SqlParameter("@InstanceID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.InstanceID
},
new SqlParameter("@LinkID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.LinkID
},
new SqlParameter("@TableName", SqlDbType.VarChar, 500)
{
Value = model.TableName
},
new SqlParameter("@FieldName", SqlDbType.VarChar, 500)
{
Value = model.FieldName
},
new SqlParameter("@Value", SqlDbType.VarChar, 8000)
{
Value = model.Value
},
new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ID
}
};
return(dbHelper.Execute(sql, parameter));
}
public int Add(RoadFlow.Data.Model.WorkFlowData model)
{
string sql = "INSERT INTO WorkFlowData\r\n\t\t\t\t(ID,InstanceID,LinkID,TableName,FieldName,Value) \r\n\t\t\t\tVALUES(@ID,@InstanceID,@LinkID,@TableName,@FieldName,@Value)";
SqlParameter[] parameter = new SqlParameter[6]
{
new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ID
},
new SqlParameter("@InstanceID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.InstanceID
},
new SqlParameter("@LinkID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.LinkID
},
new SqlParameter("@TableName", SqlDbType.VarChar, 500)
{
Value = model.TableName
},
new SqlParameter("@FieldName", SqlDbType.VarChar, 500)
{
Value = model.FieldName
},
new SqlParameter("@Value", SqlDbType.VarChar, 8000)
{
Value = model.Value
}
};
return(dbHelper.Execute(sql, parameter));
}
public Guid CreateData(Guid flowID, string pkValue)
{
WorkFlowInstalled workFlowRunModel = new WorkFlow().GetWorkFlowRunModel(flowID, true);
if (workFlowRunModel == null)
{
return(Guid.Empty);
}
IEnumerable <DataBases> dataBases1 = workFlowRunModel.DataBases;
if (dataBases1.Count <DataBases>() == 0)
{
return(Guid.Empty);
}
DataBases dataBases2 = dataBases1.First <DataBases>();
WorkFlowData workFlowData1 = new WorkFlowData();
RoadFlow.Data.Model.WorkFlowData workFlowData2 = new RoadFlow.Data.Model.WorkFlowData();
workFlowData2.ID = Guid.NewGuid();
workFlowData2.InstanceID = Guid.NewGuid();
workFlowData2.LinkID = dataBases2.LinkID;
workFlowData2.TableName = dataBases2.Table;
workFlowData2.FieldName = dataBases2.PrimaryKey;
workFlowData2.Value = pkValue;
RoadFlow.Data.Model.WorkFlowData model = workFlowData2;
workFlowData1.Add(model);
return(workFlowData2.InstanceID);
}
public int Update(RoadFlow.Data.Model.WorkFlowData model)
{
//IL_0017: Unknown result type (might be due to invalid IL or missing references)
//IL_001c: Unknown result type (might be due to invalid IL or missing references)
//IL_002d: Expected O, but got Unknown
//IL_002e: Expected O, but got Unknown
//IL_0039: Unknown result type (might be due to invalid IL or missing references)
//IL_003e: Unknown result type (might be due to invalid IL or missing references)
//IL_004f: Expected O, but got Unknown
//IL_0050: Expected O, but got Unknown
//IL_005e: Unknown result type (might be due to invalid IL or missing references)
//IL_0063: Unknown result type (might be due to invalid IL or missing references)
//IL_006f: Expected O, but got Unknown
//IL_0070: Expected O, but got Unknown
//IL_007e: Unknown result type (might be due to invalid IL or missing references)
//IL_0083: Unknown result type (might be due to invalid IL or missing references)
//IL_008f: Expected O, but got Unknown
//IL_0090: Expected O, but got Unknown
//IL_009e: Unknown result type (might be due to invalid IL or missing references)
//IL_00a3: Unknown result type (might be due to invalid IL or missing references)
//IL_00af: Expected O, but got Unknown
//IL_00b0: Expected O, but got Unknown
//IL_00bb: Unknown result type (might be due to invalid IL or missing references)
//IL_00c0: Unknown result type (might be due to invalid IL or missing references)
//IL_00d1: Expected O, but got Unknown
//IL_00d2: Expected O, but got Unknown
string sql = "UPDATE WorkFlowData SET \r\n\t\t\t\tInstanceID=:InstanceID,LinkID=:LinkID,TableName=:TableName,FieldName=:FieldName,Value=:Value\r\n\t\t\t\tWHERE ID=:ID";
OracleParameter[] obj = new OracleParameter[6];
OracleParameter val = new OracleParameter(":InstanceID", 126, 40);
((DbParameter)val).Value = model.InstanceID;
obj[0] = val;
OracleParameter val2 = new OracleParameter(":LinkID", 126, 40);
((DbParameter)val2).Value = model.LinkID;
obj[1] = val2;
OracleParameter val3 = new OracleParameter(":TableName", 126, 500);
((DbParameter)val3).Value = model.TableName;
obj[2] = val3;
OracleParameter val4 = new OracleParameter(":FieldName", 126, 500);
((DbParameter)val4).Value = model.FieldName;
obj[3] = val4;
OracleParameter val5 = new OracleParameter(":Value", 126, 4000);
((DbParameter)val5).Value = model.Value;
obj[4] = val5;
OracleParameter val6 = new OracleParameter(":ID", 126, 40);
((DbParameter)val6).Value = model.ID;
obj[5] = val6;
OracleParameter[] parameter = (OracleParameter[])obj;
return(dbHelper.Execute(sql, parameter));
}
public int Add(RoadFlow.Data.Model.WorkFlowData model)
{
//IL_0017: Unknown result type (might be due to invalid IL or missing references)
//IL_001c: Unknown result type (might be due to invalid IL or missing references)
//IL_002d: Expected O, but got Unknown
//IL_002e: Expected O, but got Unknown
//IL_0039: Unknown result type (might be due to invalid IL or missing references)
//IL_003e: Unknown result type (might be due to invalid IL or missing references)
//IL_004f: Expected O, but got Unknown
//IL_0050: Expected O, but got Unknown
//IL_005b: Unknown result type (might be due to invalid IL or missing references)
//IL_0060: Unknown result type (might be due to invalid IL or missing references)
//IL_0071: Expected O, but got Unknown
//IL_0072: Expected O, but got Unknown
//IL_0080: Unknown result type (might be due to invalid IL or missing references)
//IL_0085: Unknown result type (might be due to invalid IL or missing references)
//IL_0091: Expected O, but got Unknown
//IL_0092: Expected O, but got Unknown
//IL_00a0: Unknown result type (might be due to invalid IL or missing references)
//IL_00a5: Unknown result type (might be due to invalid IL or missing references)
//IL_00b1: Expected O, but got Unknown
//IL_00b2: Expected O, but got Unknown
//IL_00c0: Unknown result type (might be due to invalid IL or missing references)
//IL_00c5: Unknown result type (might be due to invalid IL or missing references)
//IL_00d1: Expected O, but got Unknown
//IL_00d2: Expected O, but got Unknown
string sql = "INSERT INTO WorkFlowData\r\n\t\t\t\t(ID,InstanceID,LinkID,TableName,FieldName,Value) \r\n\t\t\t\tVALUES(:ID,:InstanceID,:LinkID,:TableName,:FieldName,:Value)";
OracleParameter[] obj = new OracleParameter[6];
OracleParameter val = new OracleParameter(":ID", 126, 40);
((DbParameter)val).Value = model.ID;
obj[0] = val;
OracleParameter val2 = new OracleParameter(":InstanceID", 126, 40);
((DbParameter)val2).Value = model.InstanceID;
obj[1] = val2;
OracleParameter val3 = new OracleParameter(":LinkID", 126, 40);
((DbParameter)val3).Value = model.LinkID;
obj[2] = val3;
OracleParameter val4 = new OracleParameter(":TableName", 126, 500);
((DbParameter)val4).Value = model.TableName;
obj[3] = val4;
OracleParameter val5 = new OracleParameter(":FieldName", 126, 500);
((DbParameter)val5).Value = model.FieldName;
obj[4] = val5;
OracleParameter val6 = new OracleParameter(":Value", 126, 4000);
((DbParameter)val6).Value = model.Value;
obj[5] = val6;
OracleParameter[] parameter = (OracleParameter[])obj;
return(dbHelper.Execute(sql, parameter));
}
public int Update(RoadFlow.Data.Model.WorkFlowData model)
{
//IL_0019: Unknown result type (might be due to invalid IL or missing references)
//IL_001e: Unknown result type (might be due to invalid IL or missing references)
//IL_002f: Expected O, but got Unknown
//IL_0030: Expected O, but got Unknown
//IL_003d: Unknown result type (might be due to invalid IL or missing references)
//IL_0042: Unknown result type (might be due to invalid IL or missing references)
//IL_0053: Expected O, but got Unknown
//IL_0054: Expected O, but got Unknown
//IL_0065: Unknown result type (might be due to invalid IL or missing references)
//IL_006a: Unknown result type (might be due to invalid IL or missing references)
//IL_0076: Expected O, but got Unknown
//IL_0077: Expected O, but got Unknown
//IL_0088: Unknown result type (might be due to invalid IL or missing references)
//IL_008d: Unknown result type (might be due to invalid IL or missing references)
//IL_0099: Expected O, but got Unknown
//IL_009a: Expected O, but got Unknown
//IL_00ab: Unknown result type (might be due to invalid IL or missing references)
//IL_00b0: Unknown result type (might be due to invalid IL or missing references)
//IL_00bc: Expected O, but got Unknown
//IL_00bd: Expected O, but got Unknown
//IL_00ca: Unknown result type (might be due to invalid IL or missing references)
//IL_00cf: Unknown result type (might be due to invalid IL or missing references)
//IL_00e0: Expected O, but got Unknown
//IL_00e1: Expected O, but got Unknown
string sql = "UPDATE WorkFlowData SET \r\n\t\t\t\tInstanceID=@InstanceID,LinkID=@LinkID,TableName=@TableName,FieldName=@FieldName,Value=@Value\r\n\t\t\t\tWHERE ID=@ID";
MySqlParameter[] obj = new MySqlParameter[6];
MySqlParameter val = new MySqlParameter("@InstanceID", 253, -1);
((DbParameter)val).Value = model.InstanceID;
obj[0] = val;
MySqlParameter val2 = new MySqlParameter("@LinkID", 253, -1);
((DbParameter)val2).Value = model.LinkID;
obj[1] = val2;
MySqlParameter val3 = new MySqlParameter("@TableName", 253, 500);
((DbParameter)val3).Value = model.TableName;
obj[2] = val3;
MySqlParameter val4 = new MySqlParameter("@FieldName", 253, 500);
((DbParameter)val4).Value = model.FieldName;
obj[3] = val4;
MySqlParameter val5 = new MySqlParameter("@Value", 253, 8000);
((DbParameter)val5).Value = model.Value;
obj[4] = val5;
MySqlParameter val6 = new MySqlParameter("@ID", 253, -1);
((DbParameter)val6).Value = model.ID;
obj[5] = val6;
MySqlParameter[] parameter = (MySqlParameter[])obj;
return(dbHelper.Execute(sql, parameter));
}
public int Add(RoadFlow.Data.Model.WorkFlowData model)
{
//IL_0019: Unknown result type (might be due to invalid IL or missing references)
//IL_001e: Unknown result type (might be due to invalid IL or missing references)
//IL_002f: Expected O, but got Unknown
//IL_0030: Expected O, but got Unknown
//IL_003d: Unknown result type (might be due to invalid IL or missing references)
//IL_0042: Unknown result type (might be due to invalid IL or missing references)
//IL_0053: Expected O, but got Unknown
//IL_0054: Expected O, but got Unknown
//IL_0061: Unknown result type (might be due to invalid IL or missing references)
//IL_0066: Unknown result type (might be due to invalid IL or missing references)
//IL_0077: Expected O, but got Unknown
//IL_0078: Expected O, but got Unknown
//IL_0089: Unknown result type (might be due to invalid IL or missing references)
//IL_008e: Unknown result type (might be due to invalid IL or missing references)
//IL_009a: Expected O, but got Unknown
//IL_009b: Expected O, but got Unknown
//IL_00ac: Unknown result type (might be due to invalid IL or missing references)
//IL_00b1: Unknown result type (might be due to invalid IL or missing references)
//IL_00bd: Expected O, but got Unknown
//IL_00be: Expected O, but got Unknown
//IL_00cf: Unknown result type (might be due to invalid IL or missing references)
//IL_00d4: Unknown result type (might be due to invalid IL or missing references)
//IL_00e0: Expected O, but got Unknown
//IL_00e1: Expected O, but got Unknown
string sql = "INSERT INTO WorkFlowData\r\n\t\t\t\t(ID,InstanceID,LinkID,TableName,FieldName,Value) \r\n\t\t\t\tVALUES(@ID,@InstanceID,@LinkID,@TableName,@FieldName,@Value)";
MySqlParameter[] obj = new MySqlParameter[6];
MySqlParameter val = new MySqlParameter("@ID", 253, -1);
((DbParameter)val).Value = model.ID;
obj[0] = val;
MySqlParameter val2 = new MySqlParameter("@InstanceID", 253, -1);
((DbParameter)val2).Value = model.InstanceID;
obj[1] = val2;
MySqlParameter val3 = new MySqlParameter("@LinkID", 253, -1);
((DbParameter)val3).Value = model.LinkID;
obj[2] = val3;
MySqlParameter val4 = new MySqlParameter("@TableName", 253, 500);
((DbParameter)val4).Value = model.TableName;
obj[3] = val4;
MySqlParameter val5 = new MySqlParameter("@FieldName", 253, 500);
((DbParameter)val5).Value = model.FieldName;
obj[4] = val5;
MySqlParameter val6 = new MySqlParameter("@Value", 253, 8000);
((DbParameter)val6).Value = model.Value;
obj[5] = val6;
MySqlParameter[] parameter = (MySqlParameter[])obj;
return(dbHelper.Execute(sql, parameter));
}
private List <RoadFlow.Data.Model.WorkFlowData> DataReaderToList(OracleDataReader dataReader)
{
List <RoadFlow.Data.Model.WorkFlowData> list = new List <RoadFlow.Data.Model.WorkFlowData>();
RoadFlow.Data.Model.WorkFlowData workFlowData = null;
while (((DbDataReader)dataReader).Read())
{
workFlowData = new RoadFlow.Data.Model.WorkFlowData();
workFlowData.ID = ((DbDataReader)dataReader).GetString(0).ToGuid();
workFlowData.InstanceID = ((DbDataReader)dataReader).GetString(1).ToGuid();
workFlowData.LinkID = ((DbDataReader)dataReader).GetString(2).ToGuid();
workFlowData.TableName = ((DbDataReader)dataReader).GetString(3);
workFlowData.FieldName = ((DbDataReader)dataReader).GetString(4);
workFlowData.Value = ((DbDataReader)dataReader).GetString(5);
list.Add(workFlowData);
}
return(list);
}
private List <RoadFlow.Data.Model.WorkFlowData> DataReaderToList(SqlDataReader dataReader)
{
List <RoadFlow.Data.Model.WorkFlowData> list = new List <RoadFlow.Data.Model.WorkFlowData>();
RoadFlow.Data.Model.WorkFlowData workFlowData = null;
while (dataReader.Read())
{
workFlowData = new RoadFlow.Data.Model.WorkFlowData();
workFlowData.ID = dataReader.GetGuid(0);
workFlowData.InstanceID = dataReader.GetGuid(1);
workFlowData.LinkID = dataReader.GetGuid(2);
workFlowData.TableName = dataReader.GetString(3);
workFlowData.FieldName = dataReader.GetString(4);
workFlowData.Value = dataReader.GetString(5);
list.Add(workFlowData);
}
return(list);
}
public int Update(RoadFlow.Data.Model.WorkFlowData model)
{
return(dataWorkFlowData.Update(model));
}
public int Add(RoadFlow.Data.Model.WorkFlowData model)
{
return(dataWorkFlowData.Add(model));
}
