/// <summary> /// 更新一条数据 /// </summary> public void Update(Wuyiju.Model.CouponsType model) { StringBuilder sql = new StringBuilder(); sql.Append("update CouponsType set "); sql.Append(" type_name = @type_name , "); sql.Append(" type_money = @type_money , "); sql.Append(" send_type = @send_type , "); sql.Append(" min_amount = @min_amount , "); sql.Append(" max_amount = @max_amount , "); sql.Append(" send_start_date = @send_start_date , "); sql.Append(" send_end_date = @send_end_date , "); sql.Append(" use_start_date = @use_start_date , "); sql.Append(" use_end_date = @use_end_date , "); sql.Append(" min_product_amount = @min_product_amount , "); sql.Append(" coupon_img = @coupon_img , "); sql.Append(" points_exchange = @points_exchange "); sql.Append(" where type_id=@type_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.CouponsType obj) { if (obj == null) { throw new ApplicationException("参数不能为空"); } dao.Insert(obj); }
/// <summary> /// 删除一条数据 /// </summary> public void Remove(Wuyiju.Model.CouponsType obj) { if (obj == null) { throw new ApplicationException("参数不能为空"); } var old = dao.Get(obj.Type_Id); if (old == null) { throw new ApplicationException("非法操作记录不存在"); } dao.Delete(obj.Type_Id); }
/// <summary> /// 增加一条数据 /// </summary> public void Insert(Wuyiju.Model.CouponsType model) { StringBuilder sql = new StringBuilder(); sql.Append("insert into ec_coupons_type("); sql.Append("type_name,type_money,send_type,min_amount,max_amount,send_start_date,send_end_date,use_start_date,use_end_date,min_product_amount,coupon_img,points_exchange"); sql.Append(") values ("); sql.Append("@type_name,@type_money,@send_type,@min_amount,@max_amount,@send_start_date,@send_end_date,@use_start_date,@use_end_date,@min_product_amount,@coupon_img,@points_exchange"); sql.Append(") "); DynamicParameters param = new DynamicParameters(); if (model != null) { param.AddDynamicParams(model); } var rows = db.Execute(sql, param); if (rows < 1) { throw new ApplicationException("插入数据无效"); } }