/// <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();
FoWoSoft.Data.Model.WorkFlowData wfdata = new FoWoSoft.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">FoWoSoft.Data.Model.WorkFlowData实体类</param>
public int Update(FoWoSoft.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">FoWoSoft.Data.Model.WorkFlowData实体类</param>
/// <returns>操作所影响的行数</returns>
public int Add(FoWoSoft.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 <FoWoSoft.Data.Model.WorkFlowData> DataReaderToList(SqlDataReader dataReader)
{
List <FoWoSoft.Data.Model.WorkFlowData> List = new List <FoWoSoft.Data.Model.WorkFlowData>();
FoWoSoft.Data.Model.WorkFlowData model = null;
while (dataReader.Read())
{
model = new FoWoSoft.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(FoWoSoft.Data.Model.WorkFlowData model)
{
return(dataWorkFlowData.Update(model));
}
/// <summary>
/// 新增
/// </summary>
public int Add(FoWoSoft.Data.Model.WorkFlowData model)
{
return(dataWorkFlowData.Add(model));
}
