/// <summary> /// 增加一条数据 /// </summary> public void Add(Wuyiju.Model.Suggest obj) { if (obj == null) { throw new ApplicationException("参数不能为空"); } dao.Insert(obj); }
/// <summary> /// 删除一条数据 /// </summary> public void Remove(Wuyiju.Model.Suggest obj) { if (obj == null) { throw new ApplicationException("参数不能为空"); } var old = dao.Get(obj.Id); if (old == null) { throw new ApplicationException("非法操作记录不存在"); } dao.Delete(obj.Id); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Wuyiju.Model.Suggest model) { StringBuilder sql = new StringBuilder(); sql.Append("update ec_suggest set "); sql.Append(" title = @title , "); sql.Append(" `from` = @from , "); sql.Append(" img = @img , "); sql.Append(" url = @url , "); sql.Append(" resp = @resp , "); sql.Append(" info = @info , "); sql.Append(" add_time = @add_time , "); sql.Append(" sort_order = @sort_order , "); sql.Append(" resp_time = @resp_time , "); sql.Append(" is_best = @is_best , "); sql.Append(" status = @status , "); sql.Append(" seo_title = @seo_title , "); sql.Append(" seo_keys = @seo_keys , "); sql.Append(" seo_desc = @seo_desc , "); sql.Append(" filename = @filename , "); sql.Append(" click = @click , "); sql.Append(" user_id = @user_id "); sql.Append(" where id=@id "); DynamicParameters param = new DynamicParameters(); if (model != null) { param.AddDynamicParams(model); } var rows = db.Execute(sql, param); if (rows < 1) { throw new ApplicationException("更新数据无效"); } }
/// <summary> /// 增加一条数据 /// </summary> public void Insert(Wuyiju.Model.Suggest model) { StringBuilder sql = new StringBuilder(); sql.Append("insert into ec_suggest("); sql.Append("title,`from`,img,url,resp,info,add_time,sort_order,resp_time,is_best,status,seo_title,seo_keys,seo_desc,filename,click,user_id"); sql.Append(") values ("); sql.Append("@title,@from,@img,@url,@resp,@info,@add_time,@sort_order,@resp_time,@is_best,@status,@seo_title,@seo_keys,@seo_desc,@filename,@click,@user_id"); sql.Append(") "); DynamicParameters param = new DynamicParameters(); if (model != null) { param.AddDynamicParams(model); } var rows = db.Execute(sql, param); if (rows < 1) { throw new ApplicationException("插入数据无效"); } }