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