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