/// <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();
BizProcess.Data.Model.WorkFlowData wfdata = new BizProcess.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">BizProcess.Data.Model.WorkFlowData实体类</param>
public int Update(BizProcess.Data.Model.WorkFlowData model)
{
string sql = @"UPDATE WorkFlowData SET
InstanceID=@InstanceID,LinkID=@LinkID,TableName=@TableName,FieldName=@FieldName,Value=@Value
WHERE ID=@ID" ;
MySqlParameter[] parameters = new MySqlParameter[] {
new MySqlParameter("@InstanceID", MySqlDbType.VarChar, -1)
{
Value = model.InstanceID
},
new MySqlParameter("@LinkID", MySqlDbType.VarChar, -1)
{
Value = model.LinkID
},
new MySqlParameter("@TableName", MySqlDbType.VarChar, 500)
{
Value = model.TableName
},
new MySqlParameter("@FieldName", MySqlDbType.VarChar, 500)
{
Value = model.FieldName
},
new MySqlParameter("@Value", MySqlDbType.VarChar, 8000)
{
Value = model.Value
},
new MySqlParameter("@ID", MySqlDbType.VarChar, -1)
{
Value = model.ID
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 添加记录
/// </summary>
/// <param name="model">BizProcess.Data.Model.WorkFlowData实体类</param>
/// <returns>操作所影响的行数</returns>
public int Add(BizProcess.Data.Model.WorkFlowData model)
{
string sql = @"INSERT INTO WorkFlowData
(ID,InstanceID,LinkID,TableName,FieldName,Value)
VALUES(@ID,@InstanceID,@LinkID,@TableName,@FieldName,@Value)" ;
MySqlParameter[] parameters = new MySqlParameter[] {
new MySqlParameter("@ID", MySqlDbType.VarChar, -1)
{
Value = model.ID
},
new MySqlParameter("@InstanceID", MySqlDbType.VarChar, -1)
{
Value = model.InstanceID
},
new MySqlParameter("@LinkID", MySqlDbType.VarChar, -1)
{
Value = model.LinkID
},
new MySqlParameter("@TableName", MySqlDbType.VarChar, 500)
{
Value = model.TableName
},
new MySqlParameter("@FieldName", MySqlDbType.VarChar, 500)
{
Value = model.FieldName
},
new MySqlParameter("@Value", MySqlDbType.VarChar, 8000)
{
Value = model.Value
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 更新记录
/// </summary>
/// <param name="model">BizProcess.Data.Model.WorkFlowData实体类</param>
public int Update(BizProcess.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.Char, 36)
{
Value = model.InstanceID
},
new OracleParameter(":LinkID", OracleDbType.Char, 36)
{
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, 8000)
{
Value = model.Value
},
new OracleParameter(":ID", OracleDbType.Char, 36)
{
Value = model.ID
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 添加记录
/// </summary>
/// <param name="model">BizProcess.Data.Model.WorkFlowData实体类</param>
/// <returns>操作所影响的行数</returns>
public int Add(BizProcess.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.Char, 36)
{
Value = model.ID
},
new OracleParameter(":InstanceID", OracleDbType.Char, 36)
{
Value = model.InstanceID
},
new OracleParameter(":LinkID", OracleDbType.Char, 36)
{
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, 8000)
{
Value = model.Value
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 将DataRedar转换为List
/// </summary>
private List <BizProcess.Data.Model.WorkFlowData> DataReaderToList(MySqlDataReader dataReader)
{
List <BizProcess.Data.Model.WorkFlowData> List = new List <BizProcess.Data.Model.WorkFlowData>();
BizProcess.Data.Model.WorkFlowData model = null;
while (dataReader.Read())
{
model = new BizProcess.Data.Model.WorkFlowData();
model.ID = dataReader.GetGuid(0);
model.InstanceID = dataReader.GetGuid(1);
model.LinkID = dataReader.GetGuid(2);
model.TableName = dataReader.GetString(3);
model.FieldName = dataReader.GetString(4);
model.Value = dataReader.GetString(5);
List.Add(model);
}
return(List);
}
/// <summary>
/// 更新
/// </summary>
public int Update(BizProcess.Data.Model.WorkFlowData model)
{
return(dataWorkFlowData.Update(model));
}
/// <summary>
/// 新增
/// </summary>
public int Add(BizProcess.Data.Model.WorkFlowData model)
{
return(dataWorkFlowData.Add(model));
}