/// <summary>
/// 更新记录
/// </summary>
/// <param name="model">RoadFlow.Data.Model.WorkFlowData实体类</param>
public int Update(RoadFlow.Data.Model.WorkFlowData model)
{
string sql = @"UPDATE WorkFlowData SET
InstanceID=:InstanceID,LinkID=:LinkID,TableName=:TableName,FieldName=:FieldName,Value=:Value
WHERE ID=:ID" ;
OracleParameter[] parameters = new OracleParameter[] {
new OracleParameter(":InstanceID", OracleDbType.Varchar2, 40)
{
Value = model.InstanceID
},
new OracleParameter(":LinkID", OracleDbType.Varchar2, 40)
{
Value = model.LinkID
},
new OracleParameter(":TableName", OracleDbType.Varchar2, 500)
{
Value = model.TableName
},
new OracleParameter(":FieldName", OracleDbType.Varchar2, 500)
{
Value = model.FieldName
},
new OracleParameter(":Value", OracleDbType.Varchar2, 4000)
{
Value = model.Value
},
new OracleParameter(":ID", OracleDbType.Varchar2, 40)
{
Value = model.ID
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 创建流程单个实例数据
/// </summary>
/// <param name="flowID"></param>
/// <param name="pkValue"></param>
/// <returns>实例ID</returns>
public Guid CreateData(Guid flowID, string pkValue)
{
var wfi = new WorkFlow().GetWorkFlowRunModel(flowID);
if (wfi == null)
{
return(Guid.Empty);
}
var dbs = wfi.DataBases;
if (dbs.Count() == 0)
{
return(Guid.Empty);
}
var db = dbs.First();
WorkFlowData wfData = new WorkFlowData();
RoadFlow.Data.Model.WorkFlowData wfdata = new RoadFlow.Data.Model.WorkFlowData();
wfdata.ID = Guid.NewGuid();
wfdata.InstanceID = Guid.NewGuid();
wfdata.LinkID = db.LinkID;
wfdata.TableName = db.Table;
wfdata.FieldName = db.PrimaryKey;
wfdata.Value = pkValue;
wfData.Add(wfdata);
return(wfdata.InstanceID);
}
/// <summary>
/// 更新记录
/// </summary>
/// <param name="model">RoadFlow.Data.Model.WorkFlowData实体类</param>
public int Update(RoadFlow.Data.Model.WorkFlowData model)
{
string sql = @"UPDATE WorkFlowData SET
InstanceID=@InstanceID,LinkID=@LinkID,TableName=@TableName,FieldName=@FieldName,Value=@Value
WHERE ID=@ID" ;
SqlParameter[] parameters = new SqlParameter[] {
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, parameters));
}
/// <summary>
/// 添加记录
/// </summary>
/// <param name="model">RoadFlow.Data.Model.WorkFlowData实体类</param>
/// <returns>操作所影响的行数</returns>
public int Add(RoadFlow.Data.Model.WorkFlowData model)
{
string sql = @"INSERT INTO WorkFlowData
(ID,InstanceID,LinkID,TableName,FieldName,Value)
VALUES(:ID,:InstanceID,:LinkID,:TableName,:FieldName,:Value)" ;
OracleParameter[] parameters = new OracleParameter[] {
new OracleParameter(":ID", OracleDbType.Varchar2, 40)
{
Value = model.ID
},
new OracleParameter(":InstanceID", OracleDbType.Varchar2, 40)
{
Value = model.InstanceID
},
new OracleParameter(":LinkID", OracleDbType.Varchar2, 40)
{
Value = model.LinkID
},
new OracleParameter(":TableName", OracleDbType.Varchar2, 500)
{
Value = model.TableName
},
new OracleParameter(":FieldName", OracleDbType.Varchar2, 500)
{
Value = model.FieldName
},
new OracleParameter(":Value", OracleDbType.Varchar2, 4000)
{
Value = model.Value
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 添加记录
/// </summary>
/// <param name="model">RoadFlow.Data.Model.WorkFlowData实体类</param>
/// <returns>操作所影响的行数</returns>
public int Add(RoadFlow.Data.Model.WorkFlowData model)
{
string sql = @"INSERT INTO WorkFlowData
(ID,InstanceID,LinkID,TableName,FieldName,Value)
VALUES(@ID,@InstanceID,@LinkID,@TableName,@FieldName,@Value)" ;
SqlParameter[] parameters = new SqlParameter[] {
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, parameters));
}
/// <summary>
/// 将DataRedar转换为List
/// </summary>
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 model = null;
while (dataReader.Read())
{
model = new RoadFlow.Data.Model.WorkFlowData();
model.ID = dataReader.GetString(0).ToGuid();
model.InstanceID = dataReader.GetString(1).ToGuid();
model.LinkID = dataReader.GetString(2).ToGuid();
model.TableName = dataReader.GetString(3);
model.FieldName = dataReader.GetString(4);
model.Value = dataReader.GetString(5);
List.Add(model);
}
return(List);
}
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[] sqlParameterArray = new SqlParameter[6];
int index1 = 0;
SqlParameter sqlParameter1 = new SqlParameter("@InstanceID", SqlDbType.UniqueIdentifier, -1);
sqlParameter1.Value = (object)model.InstanceID;
sqlParameterArray[index1] = sqlParameter1;
int index2 = 1;
SqlParameter sqlParameter2 = new SqlParameter("@LinkID", SqlDbType.UniqueIdentifier, -1);
sqlParameter2.Value = (object)model.LinkID;
sqlParameterArray[index2] = sqlParameter2;
int index3 = 2;
SqlParameter sqlParameter3 = new SqlParameter("@TableName", SqlDbType.VarChar, 500);
sqlParameter3.Value = (object)model.TableName;
sqlParameterArray[index3] = sqlParameter3;
int index4 = 3;
SqlParameter sqlParameter4 = new SqlParameter("@FieldName", SqlDbType.VarChar, 500);
sqlParameter4.Value = (object)model.FieldName;
sqlParameterArray[index4] = sqlParameter4;
int index5 = 4;
SqlParameter sqlParameter5 = new SqlParameter("@Value", SqlDbType.VarChar, 8000);
sqlParameter5.Value = (object)model.Value;
sqlParameterArray[index5] = sqlParameter5;
int index6 = 5;
SqlParameter sqlParameter6 = new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1);
sqlParameter6.Value = (object)model.ID;
sqlParameterArray[index6] = sqlParameter6;
SqlParameter[] parameter = sqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
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";
OracleParameter[] oracleParameterArray = new OracleParameter[6];
int index1 = 0;
OracleParameter oracleParameter1 = new OracleParameter(":InstanceID", OracleDbType.Varchar2, 40);
oracleParameter1.Value = (object)model.InstanceID;
oracleParameterArray[index1] = oracleParameter1;
int index2 = 1;
OracleParameter oracleParameter2 = new OracleParameter(":LinkID", OracleDbType.Varchar2, 40);
oracleParameter2.Value = (object)model.LinkID;
oracleParameterArray[index2] = oracleParameter2;
int index3 = 2;
OracleParameter oracleParameter3 = new OracleParameter(":TableName", OracleDbType.Varchar2, 500);
oracleParameter3.Value = (object)model.TableName;
oracleParameterArray[index3] = oracleParameter3;
int index4 = 3;
OracleParameter oracleParameter4 = new OracleParameter(":FieldName", OracleDbType.Varchar2, 500);
oracleParameter4.Value = (object)model.FieldName;
oracleParameterArray[index4] = oracleParameter4;
int index5 = 4;
OracleParameter oracleParameter5 = new OracleParameter(":Value", OracleDbType.Varchar2, 4000);
oracleParameter5.Value = (object)model.Value;
oracleParameterArray[index5] = oracleParameter5;
int index6 = 5;
OracleParameter oracleParameter6 = new OracleParameter(":ID", OracleDbType.Varchar2, 40);
oracleParameter6.Value = (object)model.ID;
oracleParameterArray[index6] = oracleParameter6;
OracleParameter[] parameter = oracleParameterArray;
return(this.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)";
OracleParameter[] oracleParameterArray = new OracleParameter[6];
int index1 = 0;
OracleParameter oracleParameter1 = new OracleParameter(":ID", OracleDbType.Varchar2, 40);
oracleParameter1.Value = (object)model.ID;
oracleParameterArray[index1] = oracleParameter1;
int index2 = 1;
OracleParameter oracleParameter2 = new OracleParameter(":InstanceID", OracleDbType.Varchar2, 40);
oracleParameter2.Value = (object)model.InstanceID;
oracleParameterArray[index2] = oracleParameter2;
int index3 = 2;
OracleParameter oracleParameter3 = new OracleParameter(":LinkID", OracleDbType.Varchar2, 40);
oracleParameter3.Value = (object)model.LinkID;
oracleParameterArray[index3] = oracleParameter3;
int index4 = 3;
OracleParameter oracleParameter4 = new OracleParameter(":TableName", OracleDbType.Varchar2, 500);
oracleParameter4.Value = (object)model.TableName;
oracleParameterArray[index4] = oracleParameter4;
int index5 = 4;
OracleParameter oracleParameter5 = new OracleParameter(":FieldName", OracleDbType.Varchar2, 500);
oracleParameter5.Value = (object)model.FieldName;
oracleParameterArray[index5] = oracleParameter5;
int index6 = 5;
OracleParameter oracleParameter6 = new OracleParameter(":Value", OracleDbType.Varchar2, 4000);
oracleParameter6.Value = (object)model.Value;
oracleParameterArray[index6] = oracleParameter6;
OracleParameter[] parameter = oracleParameterArray;
return(this.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)";
MySqlParameter[] mySqlParameterArray = new MySqlParameter[6];
int index1 = 0;
MySqlParameter mySqlParameter1 = new MySqlParameter("@ID", MySqlDbType.VarChar, -1);
mySqlParameter1.Value = (object)model.ID;
mySqlParameterArray[index1] = mySqlParameter1;
int index2 = 1;
MySqlParameter mySqlParameter2 = new MySqlParameter("@InstanceID", MySqlDbType.VarChar, -1);
mySqlParameter2.Value = (object)model.InstanceID;
mySqlParameterArray[index2] = mySqlParameter2;
int index3 = 2;
MySqlParameter mySqlParameter3 = new MySqlParameter("@LinkID", MySqlDbType.VarChar, -1);
mySqlParameter3.Value = (object)model.LinkID;
mySqlParameterArray[index3] = mySqlParameter3;
int index4 = 3;
MySqlParameter mySqlParameter4 = new MySqlParameter("@TableName", MySqlDbType.VarChar, 500);
mySqlParameter4.Value = (object)model.TableName;
mySqlParameterArray[index4] = mySqlParameter4;
int index5 = 4;
MySqlParameter mySqlParameter5 = new MySqlParameter("@FieldName", MySqlDbType.VarChar, 500);
mySqlParameter5.Value = (object)model.FieldName;
mySqlParameterArray[index5] = mySqlParameter5;
int index6 = 5;
MySqlParameter mySqlParameter6 = new MySqlParameter("@Value", MySqlDbType.VarChar, 8000);
mySqlParameter6.Value = (object)model.Value;
mySqlParameterArray[index6] = mySqlParameter6;
MySqlParameter[] parameter = mySqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
/// <summary>
/// 更新
/// </summary>
public int Update(RoadFlow.Data.Model.WorkFlowData model)
{
return(dataWorkFlowData.Update(model));
}
/// <summary>
/// 新增
/// </summary>
public int Add(RoadFlow.Data.Model.WorkFlowData model)
{
return(dataWorkFlowData.Add(model));
}
