/// <summary> /// 添加数据 /// <param name="es">数据实体对象数组</param> /// <returns></returns> /// </summary> public bool Insert(GenVoteType e) { MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdInsertGenVoteType = cmdInsertGenVoteType.Clone() as MySqlCommand; bool returnValue = false; _cmdInsertGenVoteType.Connection = oc; try { if (oc.State == ConnectionState.Closed) { oc.Open(); } _cmdInsertGenVoteType.Parameters["@VtId"].Value = e.VtId; _cmdInsertGenVoteType.Parameters["@VtTitle"].Value = e.VtTitle; _cmdInsertGenVoteType.Parameters["@VtDescription"].Value = e.VtDescription; _cmdInsertGenVoteType.Parameters["@TotalVoteNum"].Value = e.TotalVoteNum; _cmdInsertGenVoteType.Parameters["@ImgUrl"].Value = e.ImgUrl; _cmdInsertGenVoteType.Parameters["@CreateTime"].Value = e.CreateTime; _cmdInsertGenVoteType.Parameters["@CreateId"].Value = e.CreateId; _cmdInsertGenVoteType.Parameters["@State"].Value = e.State; _cmdInsertGenVoteType.ExecuteNonQuery(); return(returnValue); } finally { oc.Close(); oc.Dispose(); oc = null; _cmdInsertGenVoteType.Dispose(); _cmdInsertGenVoteType = null; } }
/// <summary> /// 获取指定记录 /// <param name="id">Id值</param> /// </summary> public GenVoteType Get(int VtId) { GenVoteType returnValue = null; MySqlConnection oc = ConnectManager.Create(); MySqlCommand _cmdGetGenVoteType = cmdGetGenVoteType.Clone() as MySqlCommand; _cmdGetGenVoteType.Connection = oc; try { _cmdGetGenVoteType.Parameters["@VtId"].Value = VtId; if (oc.State == ConnectionState.Closed) { oc.Open(); } MySqlDataReader reader = _cmdGetGenVoteType.ExecuteReader(); if (reader.HasRows) { reader.Read(); returnValue = new GenVoteType().BuildSampleEntity(reader); } } finally { oc.Close(); oc.Dispose(); oc = null; _cmdGetGenVoteType.Dispose(); _cmdGetGenVoteType = null; GC.Collect(); } return(returnValue); }