/// <summary> /// 将DataRedar转换为List /// </summary> private List <MyCreek.Data.Model.WorkFlow> DataReaderToList(OracleDataReader dataReader) { List <MyCreek.Data.Model.WorkFlow> List = new List <MyCreek.Data.Model.WorkFlow>(); MyCreek.Data.Model.WorkFlow model = null; while (dataReader.Read()) { model = new MyCreek.Data.Model.WorkFlow(); model.ID = dataReader.GetString(0).ToGuid(); model.Name = dataReader.GetString(1); model.Type = dataReader.GetString(2).ToGuid(); model.Manager = dataReader.GetString(3); model.InstanceManager = dataReader.GetString(4); model.CreateDate = dataReader.GetDateTime(5); model.CreateUserID = dataReader.GetString(6).ToGuid(); if (!dataReader.IsDBNull(7)) { model.DesignJSON = dataReader.GetString(7); } if (!dataReader.IsDBNull(8)) { model.InstallDate = dataReader.GetDateTime(8); } if (!dataReader.IsDBNull(9)) { model.InstallUserID = dataReader.GetString(9).ToGuid(); } if (!dataReader.IsDBNull(10)) { model.RunJSON = dataReader.GetString(10); } model.Status = dataReader.GetInt32(11); List.Add(model); } return(List); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">MyCreek.Data.Model.WorkFlow实体类</param> public int Update(MyCreek.Data.Model.WorkFlow model) { string sql = @"UPDATE WorkFlow SET Name=:Name,Type=:Type,Manager=:Manager,InstanceManager=:InstanceManager,CreateDate=:CreateDate,CreateUserID=:CreateUserID,DesignJSON=:DesignJSON,InstallDate=:InstallDate,InstallUserID=:InstallUserID,RunJSON=:RunJSON,Status=:Status WHERE ID=:ID" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":Name", OracleDbType.NVarchar2, 1000) { Value = model.Name }, new OracleParameter(":Type", OracleDbType.Varchar2, 40) { Value = model.Type }, new OracleParameter(":Manager", OracleDbType.Varchar2, 5000) { Value = model.Manager }, new OracleParameter(":InstanceManager", OracleDbType.Varchar2, 5000) { Value = model.InstanceManager }, new OracleParameter(":CreateDate", OracleDbType.Date, 8) { Value = model.CreateDate }, new OracleParameter(":CreateUserID", OracleDbType.Varchar2, 40) { Value = model.CreateUserID }, model.DesignJSON == null ? new OracleParameter(":DesignJSON", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":DesignJSON", OracleDbType.Clob) { Value = model.DesignJSON }, model.InstallDate == null ? new OracleParameter(":InstallDate", OracleDbType.Date, 8) { Value = DBNull.Value } : new OracleParameter(":InstallDate", OracleDbType.Date, 8) { Value = model.InstallDate }, model.InstallUserID == null ? new OracleParameter(":InstallUserID", OracleDbType.Varchar2, 40) { Value = DBNull.Value } : new OracleParameter(":InstallUserID", OracleDbType.Varchar2, 40) { Value = model.InstallUserID }, model.RunJSON == null ? new OracleParameter(":RunJSON", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":RunJSON", OracleDbType.Clob) { Value = model.RunJSON }, new OracleParameter(":Status", OracleDbType.Int32) { Value = model.Status }, new OracleParameter(":ID", OracleDbType.Varchar2, 40) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">MyCreek.Data.Model.WorkFlow实体类</param> /// <returns>操作所影响的行数</returns> public int Add(MyCreek.Data.Model.WorkFlow model) { string sql = @"INSERT INTO WorkFlow (ID,Name,Type,Manager,InstanceManager,CreateDate,CreateUserID,DesignJSON,InstallDate,InstallUserID,RunJSON,Status) VALUES(:ID,:Name,:Type,:Manager,:InstanceManager,:CreateDate,:CreateUserID,:DesignJSON,:InstallDate,:InstallUserID,:RunJSON,:Status)" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":ID", OracleDbType.Varchar2, 40) { Value = model.ID }, new OracleParameter(":Name", OracleDbType.NVarchar2, 1000) { Value = model.Name }, new OracleParameter(":Type", OracleDbType.Varchar2, 40) { Value = model.Type }, new OracleParameter(":Manager", OracleDbType.Varchar2, 5000) { Value = model.Manager }, new OracleParameter(":InstanceManager", OracleDbType.Varchar2, 5000) { Value = model.InstanceManager }, new OracleParameter(":CreateDate", OracleDbType.Date, 8) { Value = model.CreateDate }, new OracleParameter(":CreateUserID", OracleDbType.Varchar2, 40) { Value = model.CreateUserID }, model.DesignJSON == null ? new OracleParameter(":DesignJSON", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":DesignJSON", OracleDbType.Clob) { Value = model.DesignJSON }, model.InstallDate == null ? new OracleParameter(":InstallDate", OracleDbType.Date, 8) { Value = DBNull.Value } : new OracleParameter(":InstallDate", OracleDbType.Date, 8) { Value = model.InstallDate }, model.InstallUserID == null ? new OracleParameter(":InstallUserID", OracleDbType.Varchar2, 40) { Value = DBNull.Value } : new OracleParameter(":InstallUserID", OracleDbType.Varchar2, 40) { Value = model.InstallUserID }, model.RunJSON == null ? new OracleParameter(":RunJSON", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":RunJSON", OracleDbType.Clob) { Value = model.RunJSON }, new OracleParameter(":Status", OracleDbType.Int32) { Value = model.Status } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">MyCreek.Data.Model.WorkFlow实体类</param> public int Update(MyCreek.Data.Model.WorkFlow model) { string sql = @"UPDATE WorkFlow SET Name=@Name,Type=@Type,Manager=@Manager,InstanceManager=@InstanceManager,CreateDate=@CreateDate,CreateUserID=@CreateUserID,DesignJSON=@DesignJSON,InstallDate=@InstallDate,InstallUserID=@InstallUserID,RunJSON=@RunJSON,Status=@Status WHERE ID=@ID" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Name", SqlDbType.NVarChar, 1000) { Value = model.Name }, new SqlParameter("@Type", SqlDbType.UniqueIdentifier, -1) { Value = model.Type }, new SqlParameter("@Manager", SqlDbType.VarChar, 5000) { Value = model.Manager }, new SqlParameter("@InstanceManager", SqlDbType.VarChar, 5000) { Value = model.InstanceManager }, new SqlParameter("@CreateDate", SqlDbType.DateTime, 8) { Value = model.CreateDate }, new SqlParameter("@CreateUserID", SqlDbType.UniqueIdentifier, -1) { Value = model.CreateUserID }, model.DesignJSON == null ? new SqlParameter("@DesignJSON", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@DesignJSON", SqlDbType.VarChar, -1) { Value = model.DesignJSON }, model.InstallDate == null ? new SqlParameter("@InstallDate", SqlDbType.DateTime, 8) { Value = DBNull.Value } : new SqlParameter("@InstallDate", SqlDbType.DateTime, 8) { Value = model.InstallDate }, model.InstallUserID == null ? new SqlParameter("@InstallUserID", SqlDbType.UniqueIdentifier, -1) { Value = DBNull.Value } : new SqlParameter("@InstallUserID", SqlDbType.UniqueIdentifier, -1) { Value = model.InstallUserID }, model.RunJSON == null ? new SqlParameter("@RunJSON", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@RunJSON", SqlDbType.VarChar, -1) { Value = model.RunJSON }, new SqlParameter("@Status", SqlDbType.Int, -1) { Value = model.Status }, new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">MyCreek.Data.Model.WorkFlow实体类</param> /// <returns>操作所影响的行数</returns> public int Add(MyCreek.Data.Model.WorkFlow model) { string sql = @"INSERT INTO WorkFlow (ID,Name,Type,Manager,InstanceManager,CreateDate,CreateUserID,DesignJSON,InstallDate,InstallUserID,RunJSON,Status) VALUES(@ID,@Name,@Type,@Manager,@InstanceManager,@CreateDate,@CreateUserID,@DesignJSON,@InstallDate,@InstallUserID,@RunJSON,@Status)" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID }, new SqlParameter("@Name", SqlDbType.NVarChar, 1000) { Value = model.Name }, new SqlParameter("@Type", SqlDbType.UniqueIdentifier, -1) { Value = model.Type }, new SqlParameter("@Manager", SqlDbType.VarChar, 5000) { Value = model.Manager }, new SqlParameter("@InstanceManager", SqlDbType.VarChar, 5000) { Value = model.InstanceManager }, new SqlParameter("@CreateDate", SqlDbType.DateTime, 8) { Value = model.CreateDate }, new SqlParameter("@CreateUserID", SqlDbType.UniqueIdentifier, -1) { Value = model.CreateUserID }, model.DesignJSON == null ? new SqlParameter("@DesignJSON", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@DesignJSON", SqlDbType.VarChar, -1) { Value = model.DesignJSON }, model.InstallDate == null ? new SqlParameter("@InstallDate", SqlDbType.DateTime, 8) { Value = DBNull.Value } : new SqlParameter("@InstallDate", SqlDbType.DateTime, 8) { Value = model.InstallDate }, model.InstallUserID == null ? new SqlParameter("@InstallUserID", SqlDbType.UniqueIdentifier, -1) { Value = DBNull.Value } : new SqlParameter("@InstallUserID", SqlDbType.UniqueIdentifier, -1) { Value = model.InstallUserID }, model.RunJSON == null ? new SqlParameter("@RunJSON", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@RunJSON", SqlDbType.VarChar, -1) { Value = model.RunJSON }, new SqlParameter("@Status", SqlDbType.Int, -1) { Value = model.Status } }; return(dbHelper.Execute(sql, parameters)); }