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