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