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