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