/// <summary>
/// 添加数据
/// <param name="es">数据实体对象数组</param>
/// <returns></returns>
/// </summary>
public bool Insert(GenBless e)
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdInsertGenBless = cmdInsertGenBless.Clone() as MySqlCommand;
bool returnValue = false;
_cmdInsertGenBless.Connection = oc;
try
{
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
_cmdInsertGenBless.Parameters["@Bid"].Value = e.Bid;
_cmdInsertGenBless.Parameters["@Content"].Value = e.Content;
_cmdInsertGenBless.Parameters["@CreateTime"].Value = e.CreateTime;
_cmdInsertGenBless.Parameters["@CreateId"].Value = e.CreateId;
_cmdInsertGenBless.ExecuteNonQuery();
return(returnValue);
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdInsertGenBless.Dispose();
_cmdInsertGenBless = null;
}
}
/// <summary>
/// 获取指定记录
/// <param name="id">Id值</param>
/// </summary>
public GenBless Get(int Bid)
{
GenBless returnValue = null;
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdGetGenBless = cmdGetGenBless.Clone() as MySqlCommand;
_cmdGetGenBless.Connection = oc;
try
{
_cmdGetGenBless.Parameters["@Bid"].Value = Bid;
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
MySqlDataReader reader = _cmdGetGenBless.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
returnValue = new GenBless().BuildSampleEntity(reader);
}
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdGetGenBless.Dispose();
_cmdGetGenBless = null;
GC.Collect();
}
return(returnValue);
}
/// <summary>
/// 修改指定的数据
/// <param name="e">修改后的数据实体对象</param>
/// <para>数据对应的主键必须在实例中设置</para>
/// </summary>
public void Update(GenBless e)
{
MySqlConnection oc = ConnectManager.Create();
MySqlCommand _cmdUpdateGenBless = cmdUpdateGenBless.Clone() as MySqlCommand;
_cmdUpdateGenBless.Connection = oc;
try
{
if (oc.State == ConnectionState.Closed)
{
oc.Open();
}
_cmdUpdateGenBless.Parameters["@Bid"].Value = e.Bid;
_cmdUpdateGenBless.Parameters["@Content"].Value = e.Content;
_cmdUpdateGenBless.Parameters["@CreateTime"].Value = e.CreateTime;
_cmdUpdateGenBless.Parameters["@CreateId"].Value = e.CreateId;
_cmdUpdateGenBless.ExecuteNonQuery();
}
finally
{
oc.Close();
oc.Dispose();
oc = null;
_cmdUpdateGenBless.Dispose();
_cmdUpdateGenBless = null;
GC.Collect();
}
}
//获取心愿贴
/// <summary>
/// 获取心愿贴
/// </summary>
/// <param name="blessID"></param>
/// <returns></returns>
public AdvancedResult <GenBless> GetBless(int blessID)
{
AdvancedResult <GenBless> result = new AdvancedResult <GenBless>();
try
{
GenBless bless = new GenBless();
bless = GenBlessAccessor.Instance.Get(blessID);
result.Data = bless;
result.Error = AppError.ERROR_SUCCESS;
}
catch (Exception e)
{
result.Error = AppError.ERROR_FAILED;
result.ExMessage = e.ToString();
}
return(result);
}
/// <summary>
/// 发布心愿单
/// </summary>
/// <param name="content"></param>
/// <returns></returns>
public RespResult Bless(string content)
{
RespResult result = new RespResult();
try
{
GenBless bless = new GenBless();
bless.Content = content;
bless.CreateTime = System.DateTime.Now;
GenBlessAccessor.Instance.Insert(bless);
result.Error = AppError.ERROR_SUCCESS;
}
catch (Exception e)
{
result.Error = AppError.ERROR_FAILED;
result.ExMessage = e.ToString();
}
return(result);
}
/// <summary>
/// 回复心愿贴
/// </summary>
/// <param name="blessID"></param>
/// <param name="refReplyID"></param>
/// <param name="Content"></param>
/// <param name="token"></param>
/// <returns></returns>
public RespResult ReplyBless(int blessID, int refReplyID, string Content, string token)
{
RespResult result = new RespResult();
try
{
if (!CacheManagerFactory.GetMemoryManager().Contains(token))
{
result.Error = AppError.ERROR_PERSON_NOT_LOGIN;
}
else
{
int userid = Convert.ToInt32(CacheManagerFactory.GetMemoryManager().Get(token));
GenBless bless = GetBless(blessID).Data;
if (bless != null)
{
GenReply reply = new GenReply();
reply.ObjId = blessID;
reply.ObjType = (int)ReplyType.Bless;
reply.Content = Content;
reply.CreateId = userid;
reply.RefUserId = bless.CreateId;
reply.RefReplyId = refReplyID;
GenReplyAccessor.Instance.Insert(reply);
result.Error = AppError.ERROR_SUCCESS;
}
else
{
result.Error = AppError.ERROR_FAILED;
}
}
}
catch (Exception e)
{
result.Error = AppError.ERROR_FAILED;
result.ExMessage = e.ToString();
}
return(result);
}
