/// <summary> /// 更新一条数据 /// </summary> public void Update(Wuyiju.Model.Visitor model) { StringBuilder sql = new StringBuilder(); sql.Append("update Visitor set "); sql.Append(" in_time = @in_time , "); sql.Append(" ip = @ip , "); sql.Append(" country = @country , "); sql.Append(" province = @province , "); sql.Append(" city = @city , "); sql.Append(" isp = @isp , "); sql.Append(" platform = @platform , "); sql.Append(" browser = @browser , "); sql.Append(" version = @version , "); sql.Append(" entrance = @entrance , "); sql.Append(" http_referer = @http_referer "); 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 Add(Wuyiju.Model.Visitor obj) { if (obj == null) { throw new ApplicationException("参数不能为空"); } dao.Insert(obj); }
/// <summary> /// 删除一条数据 /// </summary> public void Remove(Wuyiju.Model.Visitor 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 Insert(Wuyiju.Model.Visitor model) { StringBuilder sql = new StringBuilder(); sql.Append("insert into ec_visitor("); sql.Append("in_time,ip,country,province,city,isp,platform,browser,version,entrance,http_referer"); sql.Append(") values ("); sql.Append("@in_time,@ip,@country,@province,@city,@isp,@platform,@browser,@version,@entrance,@http_referer"); sql.Append(") "); DynamicParameters param = new DynamicParameters(); if (model != null) { param.AddDynamicParams(model); } var rows = db.Execute(sql, param); if (rows < 1) { throw new ApplicationException("插入数据无效"); } }