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