/// <summary>
/// 添加数据
/// <param name="es">数据实体对象数组</param>
/// <returns></returns>
/// </summary>
public bool Insert(SysRole e)
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdInsertSysRole = cmdInsertSysRole.Clone() as MySqlCommand;
bool returnValue = false;
_cmdInsertSysRole.Connection = oc;
try
{
if (oc.State == ConnectionState.Closed)
oc.Open();
_cmdInsertSysRole.Parameters["@RoleId"].Value = e.RoleId;
_cmdInsertSysRole.Parameters["@RoleName"].Value = e.RoleName;
_cmdInsertSysRole.ExecuteNonQuery();
return returnValue;
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdInsertSysRole.Dispose();
_cmdInsertSysRole = null;
}
}
/// <summary>
/// 修改指定的数据
/// <param name="e">修改后的数据实体对象</param>
/// <para>数据对应的主键必须在实例中设置</para>
/// </summary>
public void Update(SysRole e)
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdUpdateSysRole = cmdUpdateSysRole.Clone() as MySqlCommand;
_cmdUpdateSysRole.Connection = oc;
try
{
if (oc.State == ConnectionState.Closed)
oc.Open();
_cmdUpdateSysRole.Parameters["@RoleId"].Value = e.RoleId;
_cmdUpdateSysRole.Parameters["@RoleName"].Value = e.RoleName;
_cmdUpdateSysRole.ExecuteNonQuery();
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdUpdateSysRole.Dispose();
_cmdUpdateSysRole = null;
GC.Collect();
}
}
/// <summary>
/// 获取指定记录
/// <param name="id">Id值</param>
/// </summary>
public SysRole Get(int RoleId)
{
SysRole returnValue = null;
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdGetSysRole = cmdGetSysRole.Clone() as MySqlCommand;
_cmdGetSysRole.Connection = oc;
try
{
_cmdGetSysRole.Parameters["@RoleId"].Value = RoleId;
if (oc.State == ConnectionState.Closed)
oc.Open();
MySqlDataReader reader = _cmdGetSysRole.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
returnValue = new SysRole().BuildSampleEntity(reader);
}
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdGetSysRole.Dispose();
_cmdGetSysRole = null;
GC.Collect();
}
return returnValue;
}
