public int UpdateState(VoteEvent ve)
{
ve.Replace4MySQL();
StringBuilder sql = new StringBuilder();
sql.AppendFormat(@"UPDATE vote_event SET event_status='{0}',update_user='******',", ve.event_status, ve.update_user);
sql.AppendFormat(@"update_time='{0}' ", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
sql.AppendFormat(@" where event_id='{0}';", ve.event_id);
try
{
return _access.execCommand(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("VoteEventDao-->UpdateState" + ex.Message + sql.ToString(), ex);
}
}
public int Save(VoteEvent ve)
{
StringBuilder sql = new StringBuilder();
ve.Replace4MySQL();
try
{
sql.AppendFormat(@" INSERT INTO vote_event(event_name,event_desc,event_banner,event_start,");
sql.AppendFormat(@" event_end,word_length,vote_everyone_limit,vote_everyday_limit,number_limit, ");
sql.AppendFormat(@" present_event_id,create_user,create_time,update_user,update_time,is_repeat,event_status)");
sql.AppendFormat(@" VALUES ('{0}','{1}','{2}','{3}',", ve.event_name, ve.event_desc, ve.event_banner, ve.event_start.ToString("yyyy-MM-dd HH:mm;ss"));
sql.AppendFormat(" '{0}','{1}','{2}','{3}','{4}',", ve.event_end.ToString("yyyy-MM-dd HH:mm;ss"), ve.word_length, ve.vote_everyone_limit, ve.vote_everyday_limit, ve.number_limit);
sql.AppendFormat(@" '{0}','{1}','{2}','{3}','{4}', ", ve.present_event_id, ve.create_user, ve.create_time.ToString("yyyy-MM-dd HH:mm;ss"), ve.update_user, ve.update_time.ToString("yyyy-MM-dd HH:mm;ss"));
sql.AppendFormat(@"'{0}','{1}')", ve.is_repeat,ve.event_status);
return _access.execCommand(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("VoteEventDao-->Save-->" + ex.Message + sql.ToString(), ex);
}
}
public int Update(VoteEvent ve)
{
StringBuilder sql = new StringBuilder();
ve.Replace4MySQL();
try
{
sql.AppendFormat(@"UPDATE vote_event set ");
sql.AppendFormat(@" event_name='{0}',event_desc='{1}',event_banner='{2}',", ve.event_name, ve.event_desc, ve.event_banner);
sql.AppendFormat(@" event_start='{0}',event_end='{1}',", ve.event_start.ToString("yyyy-MM-dd HH:mm:ss"), ve.event_end.ToString("yyyy-MM-dd HH:mm:ss"));
sql.AppendFormat(@" word_length='{0}',vote_everyone_limit='{1}',vote_everyday_limit='{2}',", ve.word_length, ve.vote_everyone_limit, ve.vote_everyday_limit);
sql.AppendFormat(@" number_limit='{0}',present_event_id='{1}',", ve.number_limit, ve.present_event_id);
sql.AppendFormat(@" update_user='******',update_time='{1}',is_repeat='{2}' ", ve.update_user, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), ve.is_repeat);
sql.AppendFormat(" WHERE event_id='{0}' ;", ve.event_id);
return _access.execCommand(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("VoteEventDao-->Update-->" + ex.Message + sql.ToString(), ex);
}
}
