/// <summary> /// 更新一条数据 /// </summary> public void Update(Wuyiju.Model.DepositBankCard model) { StringBuilder sql = new StringBuilder(); sql.Append("update DepositBankCard set "); sql.Append(" user_id = @user_id , "); sql.Append(" real_name = @real_name , "); sql.Append(" region_lv1 = @region_lv1 , "); sql.Append(" region_lv2 = @region_lv2 , "); sql.Append(" region_lv3 = @region_lv3 , "); sql.Append(" bank_name = @bank_name , "); sql.Append(" bank_subname = @bank_subname , "); sql.Append(" card_number = @card_number , "); sql.Append(" add_time = @add_time "); 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 Remove(Wuyiju.Model.DepositBankCard 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 Add(Wuyiju.Model.DepositBankCard obj) { if (obj == null) { throw new ApplicationException("参数不能为空"); } if (obj.Bank_Name.IsNullOrWhiteSpace() || obj.Region_Lv2.IsNull() || obj.Region_Lv3.IsNull() || obj.Bank_Name.IsNullOrWhiteSpace() || obj.Bank_Subname.IsNullOrWhiteSpace() || obj.Card_Number.IsNullOrWhiteSpace()) { throw new ApplicationException("必填内容不能为空"); } var lst = dao.GetList(new DepositBankCard.Query { User_Id = obj.User_Id }); if (lst != null && lst.Count > 5) { throw new ApplicationException("绑定银行卡数不能超过5张"); } if (lst != null) { var exists = lst.Where(d => d.Card_Number == obj.Card_Number).ToList().Count; if (exists > 0) { throw new ApplicationException("已经存在此银行卡号"); } } dao.Insert(obj); }
/// <summary> /// 增加一条数据 /// </summary> public void Insert(Wuyiju.Model.DepositBankCard model) { StringBuilder sql = new StringBuilder(); sql.Append("insert into ec_deposit_bank_card("); sql.Append("user_id,real_name,region_lv1,region_lv2,region_lv3,bank_name,bank_subname,card_number,add_time"); sql.Append(") values ("); sql.Append("@user_id,@real_name,@region_lv1,@region_lv2,@region_lv3,@bank_name,@bank_subname,@card_number,@add_time"); sql.Append(") "); DynamicParameters param = new DynamicParameters(); if (model != null) { param.AddDynamicParams(model); } var rows = db.Execute(sql, param); if (rows < 1) { throw new ApplicationException("插入数据无效"); } }