/// <summary>
/// 将DataRedar转换为List
/// </summary>
private List <BizProcess.Data.Model.WorkFlow> DataReaderToList(MySqlDataReader dataReader)
{
List <BizProcess.Data.Model.WorkFlow> List = new List <BizProcess.Data.Model.WorkFlow>();
BizProcess.Data.Model.WorkFlow model = null;
while (dataReader.Read())
{
model = new BizProcess.Data.Model.WorkFlow();
model.ID = dataReader.GetGuid(0);
model.Name = dataReader.GetString(1);
model.Type = dataReader.GetGuid(2);
model.Manager = dataReader.GetString(3);
model.InstanceManager = dataReader.GetString(4);
model.CreateDate = dataReader.GetDateTime(5);
model.CreateUserID = dataReader.GetGuid(6);
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.GetGuid(9);
}
if (!dataReader.IsDBNull(10))
{
model.RunJSON = dataReader.GetString(10);
}
model.Status = dataReader.GetInt32(11);
List.Add(model);
}
return(List);
}
/// <summary>
/// 更新记录
/// </summary>
/// <param name="model">BizProcess.Data.Model.WorkFlow实体类</param>
public int Update(BizProcess.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" ;
MySqlParameter[] parameters = new MySqlParameter[] {
new MySqlParameter("@Name", MySqlDbType.VarChar, 500)
{
Value = model.Name
},
new MySqlParameter("@Type", MySqlDbType.VarChar, -1)
{
Value = model.Type
},
new MySqlParameter("@Manager", MySqlDbType.VarChar, 5000)
{
Value = model.Manager
},
new MySqlParameter("@InstanceManager", MySqlDbType.VarChar, 5000)
{
Value = model.InstanceManager
},
new MySqlParameter("@CreateDate", MySqlDbType.DateTime, 8)
{
Value = model.CreateDate
},
new MySqlParameter("@CreateUserID", MySqlDbType.VarChar, -1)
{
Value = model.CreateUserID
},
model.DesignJSON == null ? new MySqlParameter("@DesignJSON", MySqlDbType.Text, -1)
{
Value = DBNull.Value
} : new MySqlParameter("@DesignJSON", MySqlDbType.Text, -1)
{
Value = model.DesignJSON
},
model.InstallDate == null ? new MySqlParameter("@InstallDate", MySqlDbType.DateTime, 8)
{
Value = DBNull.Value
} : new MySqlParameter("@InstallDate", MySqlDbType.DateTime, 8)
{
Value = model.InstallDate
},
model.InstallUserID == null ? new MySqlParameter("@InstallUserID", MySqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new MySqlParameter("@InstallUserID", MySqlDbType.VarChar, -1)
{
Value = model.InstallUserID
},
model.RunJSON == null ? new MySqlParameter("@RunJSON", MySqlDbType.Text, -1)
{
Value = DBNull.Value
} : new MySqlParameter("@RunJSON", MySqlDbType.Text, -1)
{
Value = model.RunJSON
},
new MySqlParameter("@Status", MySqlDbType.Int32, -1)
{
Value = model.Status
},
new MySqlParameter("@ID", MySqlDbType.VarChar, -1)
{
Value = model.ID
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 添加记录
/// </summary>
/// <param name="model">BizProcess.Data.Model.WorkFlow实体类</param>
/// <returns>操作所影响的行数</returns>
public int Add(BizProcess.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)" ;
MySqlParameter[] parameters = new MySqlParameter[] {
new MySqlParameter("@ID", MySqlDbType.VarChar, -1)
{
Value = model.ID
},
new MySqlParameter("@Name", MySqlDbType.VarChar, 500)
{
Value = model.Name
},
new MySqlParameter("@Type", MySqlDbType.VarChar, -1)
{
Value = model.Type
},
new MySqlParameter("@Manager", MySqlDbType.VarChar, 5000)
{
Value = model.Manager
},
new MySqlParameter("@InstanceManager", MySqlDbType.VarChar, 5000)
{
Value = model.InstanceManager
},
new MySqlParameter("@CreateDate", MySqlDbType.DateTime, 8)
{
Value = model.CreateDate
},
new MySqlParameter("@CreateUserID", MySqlDbType.VarChar, -1)
{
Value = model.CreateUserID
},
model.DesignJSON == null ? new MySqlParameter("@DesignJSON", MySqlDbType.Text, -1)
{
Value = DBNull.Value
} : new MySqlParameter("@DesignJSON", MySqlDbType.Text, -1)
{
Value = model.DesignJSON
},
model.InstallDate == null ? new MySqlParameter("@InstallDate", MySqlDbType.DateTime, 8)
{
Value = DBNull.Value
} : new MySqlParameter("@InstallDate", MySqlDbType.DateTime, 8)
{
Value = model.InstallDate
},
model.InstallUserID == null ? new MySqlParameter("@InstallUserID", MySqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new MySqlParameter("@InstallUserID", MySqlDbType.VarChar, -1)
{
Value = model.InstallUserID
},
model.RunJSON == null ? new MySqlParameter("@RunJSON", MySqlDbType.Text, -1)
{
Value = DBNull.Value
} : new MySqlParameter("@RunJSON", MySqlDbType.Text, -1)
{
Value = model.RunJSON
},
new MySqlParameter("@Status", MySqlDbType.Int32, -1)
{
Value = model.Status
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 更新记录
/// </summary>
/// <param name="model">BizProcess.Data.Model.WorkFlow实体类</param>
public int Update(BizProcess.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.Char, 36)
{
Value = model.Type
},
new OracleParameter(":Manager", OracleDbType.Clob)
{
Value = model.Manager
},
new OracleParameter(":InstanceManager", OracleDbType.Clob)
{
Value = model.InstanceManager
},
new OracleParameter(":CreateDate", OracleDbType.Date)
{
Value = model.CreateDate
},
new OracleParameter(":CreateUserID", OracleDbType.Char, 36)
{
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)
{
Value = DBNull.Value
} : new OracleParameter(":InstallDate", OracleDbType.Date)
{
Value = model.InstallDate
},
model.InstallUserID == null ? new OracleParameter(":InstallUserID", OracleDbType.Char, 36)
{
Value = DBNull.Value
} : new OracleParameter(":InstallUserID", OracleDbType.Char, 36)
{
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.Char, 36)
{
Value = model.ID
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 添加记录
/// </summary>
/// <param name="model">BizProcess.Data.Model.WorkFlow实体类</param>
/// <returns>操作所影响的行数</returns>
public int Add(BizProcess.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.Char, 36)
{
Value = model.ID
},
new OracleParameter(":Name", OracleDbType.NVarchar2, 1000)
{
Value = model.Name
},
new OracleParameter(":Type", OracleDbType.Char, 36)
{
Value = model.Type
},
new OracleParameter(":Manager", OracleDbType.Clob)
{
Value = model.Manager
},
new OracleParameter(":InstanceManager", OracleDbType.Clob)
{
Value = model.InstanceManager
},
new OracleParameter(":CreateDate", OracleDbType.Date)
{
Value = model.CreateDate
},
new OracleParameter(":CreateUserID", OracleDbType.Char, 36)
{
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)
{
Value = DBNull.Value
} : new OracleParameter(":InstallDate", OracleDbType.Date)
{
Value = model.InstallDate
},
model.InstallUserID == null ? new OracleParameter(":InstallUserID", OracleDbType.Char, 36)
{
Value = DBNull.Value
} : new OracleParameter(":InstallUserID", OracleDbType.Char, 36)
{
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));
}
