/// <summary> /// 修改 /// </summary> /// <param name="model">VoteDetail對象</param> /// <returns>更新結果</returns> public int Update(VoteDetail model) { int result = 0; StringBuilder sbSql = new StringBuilder(); model.Replace4MySQL(); sbSql.Append("set sql_safe_updates=0;"); sbSql.AppendFormat("UPDATE vote_detail set article_id='{0}',user_id='{1}',ip='{2}',create_user='******',update_user='******',create_time='{5}',update_time='{6}' WHERE vote_id='{7}';", model.article_id, model.user_id, model.ip, model.create_user, model.update_user, CommonFunction.DateTimeToString(model.create_time), CommonFunction.DateTimeToString(model.update_time), model.vote_id); sbSql.Append("set sql_safe_updates=1;"); try { result = _access.execCommand(sbSql.ToString()); } catch (Exception ex) { throw new Exception("VoteDetailDao-->Update-->" + ex.Message + sbSql.ToString(), ex); } return result; }
/// <summary> /// 新增 /// </summary> /// <param name="model">VoteDetail對象</param> /// <returns>新增后的標識</returns> public int Add(VoteDetail model) { StringBuilder sbSql = new StringBuilder(); model.Replace4MySQL(); sbSql.Append("INSERT INTO vote_detail(article_id,user_id,ip,vote_status,create_user,update_user,create_time,update_time) "); sbSql.AppendFormat(" VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}');SELECT @@IDENTITY;", model.article_id, model.user_id, model.ip, model.vote_status, model.create_user, model.update_user, CommonFunction.DateTimeToString(model.create_time), CommonFunction.DateTimeToString(model.update_time)); try { DataTable _dt = _access.getDataTable(sbSql.ToString()); if (_dt.Rows.Count > 0) { return Convert.ToInt32(_dt.Rows[0][0]); } else { return 0; } } catch (Exception ex) { throw new Exception("VoteDetailDao-->Add-->" + ex.Message + sbSql.ToString(), ex); } }