C# Class CCN.Modules.Rewards.DataAccess.RewardsDataAccess

Inheritance: Cedar.Framework.Common.Server.BaseClasses.DataAccessBase

Show file Open project: Chinaccn/surfboard

Public Methods

Method	Description
AddCoupon ( CouponInfoModel model ) : int	添加礼券
AddSettLog ( SettlementLogModel model ) : int	添加结算记录
AddShop ( ShopModel model ) : int	添加商户
AddShopStaff ( ShopStaffModel model ) : int	添加职员
BindWechatProduct ( CouponCardProduct model ) : int	礼券与微信小店产品绑定
CancelCoupon ( string code ) : int	礼券核销
ChangePoint ( CustPointModel model ) : int	会员积分变更
CheckShopName ( string shopname ) : int	验证商户名重复
CheckShopStaffLoginName ( string staffname ) : int	验证商户职员登录名重复
CheckShopStaffName ( string staffname ) : int	验证商户职员名重复
CouponToCustomer ( CouponSendModel model ) : int	批量发放礼券给会员
DelSettLog ( string innerid ) : int	删除结算记录
DeleteShop ( string innerid ) : int	删除商户
DeleteShopStaff ( string innerid ) : int	删除商户Staff
GetAuthPointRecord ( string custid ) : IEnumerable	获取认证积分记录
GetCode ( string code ) : CodeCancelQueryModel	根据code查询详情
GetCodeInfo ( string code ) : MyCodeViewModel	我的礼券详情
GetCodeRecord ( CodeQueryModel query ) : BasePageList	车商核销记录列表
GetCodeRecordTotal ( CodeQueryModel query ) : CodeListSummaryModel	车商核销记录列表合计
GetCoupon ( CardCancelSummaryQueryModel query ) : IEnumerable	查询已核销的礼券
GetCouponById ( string innerid ) : CouponViewModel	获取礼券信息
GetCouponByProductId ( string productid ) : CouponInfoModel	根据商品id获取礼券信息
GetCouponCode ( CodeQueryModel query ) : BasePageList	获取礼券实例
GetCouponPageList ( CouponQueryModel query ) : BasePageList	获取获取礼券列表
GetCouponRecord ( string custid, int sourceid ) : IEnumerable	获取认证获得的礼券
GetCouponRule ( ) : IEnumerable	获取礼券奖励规则
GetCustPointLogPageList ( CustPointQueryModel query ) : BasePageList	获取会员积分记录列表
GetCustTotalInfo ( string custid ) : CustTotalModel	获取会员统计信息
GetCustidByOpenid ( string openid ) : string	根据openid获取custid
GetLoginPointRecord ( string custid ) : IEnumerable	登录奖励验证
GetMallCouponPageList ( CouponMallQuery query ) : BasePageList	获取礼券列表（购买）
GetMallShopCardTypeNameList ( string shopid ) : IEnumerable	查询该商户下有多少种券
GetMallShopPageList ( ShopMallQueryModel query ) : BasePageList	商城搜索商户列表
GetMaxCode ( ) : int	获取最大
GetMyCodeList ( MyCodeQueryModel query ) : BasePageList	获取我的礼券
GetMyUsableCodeTotal ( string custid ) : int	我的可用礼券总数
GetOrderInfo ( string innerid ) : OrderViewList	修改购买订单处理结果
GetOrderList ( OrderQuery query ) : BasePageList	获取发送礼券失败的订单
GetSettLogById ( string innerid ) : SettlementLogModel	根据id获取结算记录信息
GetSettLogPageList ( SettlementLogQueryModel query ) : BasePageList	结算记录列表
GetSettedCodePageList ( SettedCodeQueryModel query ) : BasePageList	根据settid获取已结算的code列表
GetSharePointRecord ( string custid ) : int	获取今天分享获得积分记录
GetShopAreaByCityid ( string cityid ) : IEnumerable	根据城市id获取区列表
GetShopByCountyid ( string countyid ) : IEnumerable	根据区id获取商户列表
GetShopById ( string innerid ) : ShopModel	根据id获取商户信息
GetShopList ( ) : IEnumerable	根据id获取商户信息
GetShopModel ( string shopcode, string password ) : ShopModel	商户登录
GetShopPageList ( ShopQueryModel query ) : BasePageList	商户列表
GetShopStaffById ( string innerid ) : ShopStaffModel	根据id获取商户职员信息
GetShopStaffModel ( string loginname, string password ) : ShopStaffInfo	商户登录
GetShopStaffPageList ( ShopStaffQueryModel query ) : BasePageList	商户职员列表
GetShopViewById ( string innerid ) : ShopInfoViewModel	根据id获取商户信息（包含关联信息）
GetUsedCodePageList ( UsedCodeQueryModel query ) : BasePageList	根据cardid获取已核销的code列表
PointExchangeCoupon ( CustPointExChangeCouponModel model ) : int	积分兑换礼券
PointToCoupon ( CustPointToCouponModel model ) : int	积分兑换礼券
SaveOrder ( CouponBuyModel model ) : int	保存购买订单信息
UnBindWechatProduct ( string cardid ) : int	礼券与微信小店产品解除绑定
UpdateCoupon ( CouponInfoModel model ) : int	修改礼券
UpdateOrderResult ( CouponBuyModel model ) : int	修改购买订单处理结果
UpdateQrcode ( string code, string qrcode ) : int	根据id更新qrcode 根据code更新qrcode
UpdateSettLog ( SettlementLogModel model ) : int	修改结算记录
UpdateSettLogPic ( string innerid, string pictures ) : int	更新结算记录图片
UpdateShop ( ShopModel model ) : int	更新商户
UpdateShopPassword ( string innerid, string password ) : int	修改商户密码
UpdateShopStaff ( ShopStaffModel model ) : int	更新商户Staff
UpdateShopStaffStatus ( string innerid, int status ) : int	修改商户Staff状态(冻结和解冻)
UpdateShopStatus ( string innerid, int status ) : int	修改商户状态(冻结和解冻)
UpdateStatus ( string cardid, int status ) : int	获取礼券信息 by code 更新礼券状态
UpdateStock ( CouponInfoModel model ) : int	修改礼券库存
UpdateValidity ( CouponInfoModel model ) : int	修改礼券有效期
ValidatedBindRepeat ( string productid ) : int	礼券与微信小店产品绑定

Method Details

AddCoupon() public method

添加礼券

public AddCoupon ( CouponInfoModel model ) : int
model	CCN.Modules.Rewards.BusinessEntity.CouponInfoModel	礼券信息
return	int

AddSettLog() public method

添加结算记录

public AddSettLog ( SettlementLogModel model ) : int
model	CCN.Modules.Rewards.BusinessEntity.SettlementLogModel
return	int

AddShop() public method

添加商户

public AddShop ( ShopModel model ) : int
model	ShopModel
return	int

AddShopStaff() public method

添加职员

public AddShopStaff ( ShopStaffModel model ) : int
model	CCN.Modules.Rewards.BusinessEntity.ShopStaffModel
return	int

BindWechatProduct() public method

礼券与微信小店产品绑定

public BindWechatProduct ( CouponCardProduct model ) : int
model	CCN.Modules.Rewards.BusinessEntity.CouponCardProduct
return	int

CancelCoupon() public method

礼券核销

public CancelCoupon ( string code ) : int
code	string
return	int

ChangePoint() public method

会员积分变更

public ChangePoint ( CustPointModel model ) : int
model	CCN.Modules.Rewards.BusinessEntity.CustPointModel	变更信息
return	int

CheckShopName() public method

验证商户名重复

public CheckShopName ( string shopname ) : int
shopname	string
return	int

CheckShopStaffLoginName() public method

验证商户职员登录名重复

public CheckShopStaffLoginName ( string staffname ) : int
staffname	string
return	int

CheckShopStaffName() public method

验证商户职员名重复

public CheckShopStaffName ( string staffname ) : int
staffname	string
return	int

CouponToCustomer() public method

批量发放礼券给会员

public CouponToCustomer ( CouponSendModel model ) : int
model	CCN.Modules.Rewards.BusinessEntity.CouponSendModel	礼券信息
return	int

DelSettLog() public method

删除结算记录

public DelSettLog ( string innerid ) : int
innerid	string
return	int

DeleteShop() public method

删除商户

public DeleteShop ( string innerid ) : int
innerid	string
return	int

DeleteShopStaff() public method

删除商户Staff

public DeleteShopStaff ( string innerid ) : int
innerid	string
return	int

GetAuthPointRecord() public method

获取认证积分记录

public GetAuthPointRecord ( string custid ) : IEnumerable
custid	string	会员id
return	IEnumerable

GetCode() public method

根据code查询详情

public GetCode ( string code ) : CodeCancelQueryModel
code	string
return	CCN.Modules.Rewards.BusinessEntity.CodeCancelQueryModel

GetCodeInfo() public method

我的礼券详情

public GetCodeInfo ( string code ) : MyCodeViewModel
code	string
return	CCN.Modules.Rewards.BusinessEntity.MyCodeViewModel

GetCodeRecord() public method

车商核销记录列表

public GetCodeRecord ( CodeQueryModel query ) : BasePageList
query	CCN.Modules.Rewards.BusinessEntity.CodeQueryModel
return	BasePageList

GetCodeRecordTotal() public method

车商核销记录列表合计

public GetCodeRecordTotal ( CodeQueryModel query ) : CodeListSummaryModel
query	CCN.Modules.Rewards.BusinessEntity.CodeQueryModel
return	CCN.Modules.Rewards.BusinessEntity.CodeListSummaryModel

GetCoupon() public method

查询已核销的礼券

public GetCoupon ( CardCancelSummaryQueryModel query ) : IEnumerable
query	CCN.Modules.Rewards.BusinessEntity.CardCancelSummaryQueryModel
return	IEnumerable

GetCouponById() public method

获取礼券信息

public GetCouponById ( string innerid ) : CouponViewModel
innerid	string	id
return	CCN.Modules.Rewards.BusinessEntity.CouponViewModel

GetCouponByProductId() public method

根据商品id获取礼券信息

public GetCouponByProductId ( string productid ) : CouponInfoModel
productid	string	商品id
return	CCN.Modules.Rewards.BusinessEntity.CouponInfoModel

GetCouponCode() public method

获取礼券实例

public GetCouponCode ( CodeQueryModel query ) : BasePageList
query	CCN.Modules.Rewards.BusinessEntity.CodeQueryModel
return	BasePageList

GetCouponPageList() public method

获取获取礼券列表

public GetCouponPageList ( CouponQueryModel query ) : BasePageList
query	CCN.Modules.Rewards.BusinessEntity.CouponQueryModel	查询条件
return	BasePageList

GetCouponRecord() public method

获取认证获得的礼券

public GetCouponRecord ( string custid, int sourceid ) : IEnumerable
custid	string	会员id
sourceid	int
return	IEnumerable

GetCouponRule() public method

获取礼券奖励规则

public GetCouponRule ( ) : IEnumerable
return	IEnumerable

GetCustPointLogPageList() public method

获取会员积分记录列表

public GetCustPointLogPageList ( CustPointQueryModel query ) : BasePageList
query	CCN.Modules.Rewards.BusinessEntity.CustPointQueryModel	查询条件
return	BasePageList

GetCustTotalInfo() public method

获取会员统计信息

public GetCustTotalInfo ( string custid ) : CustTotalModel
custid	string	会员id
return	CCN.Modules.Rewards.BusinessEntity.CustTotalModel

GetCustidByOpenid() public method

根据openid获取custid

public GetCustidByOpenid ( string openid ) : string
openid	string	商品id
return	string

GetLoginPointRecord() public method

登录奖励验证

public GetLoginPointRecord ( string custid ) : IEnumerable
custid	string	会员id
return	IEnumerable

GetMallCouponPageList() public method

获取礼券列表（购买）

public GetMallCouponPageList ( CouponMallQuery query ) : BasePageList
query	CCN.Modules.Rewards.BusinessEntity.CouponMallQuery	查询条件
return	BasePageList

GetMallShopCardTypeNameList() public method

查询该商户下有多少种券

public GetMallShopCardTypeNameList ( string shopid ) : IEnumerable
shopid	string	查询条件
return	IEnumerable

GetMallShopPageList() public method

商城搜索商户列表

public GetMallShopPageList ( ShopMallQueryModel query ) : BasePageList
query	ShopMallQueryModel	查询条件
return	BasePageList

GetMaxCode() public method

获取最大

public GetMaxCode ( ) : int
return	int

GetMyCodeList() public method

获取我的礼券

public GetMyCodeList ( MyCodeQueryModel query ) : BasePageList
query	CCN.Modules.Rewards.BusinessEntity.MyCodeQueryModel
return	BasePageList

GetMyUsableCodeTotal() public method

我的可用礼券总数

public GetMyUsableCodeTotal ( string custid ) : int
custid	string
return	int

GetOrderInfo() public method

修改购买订单处理结果

public GetOrderInfo ( string innerid ) : OrderViewList
innerid	string
return	CCN.Modules.Rewards.BusinessEntity.OrderViewList

GetOrderList() public method

获取发送礼券失败的订单

public GetOrderList ( OrderQuery query ) : BasePageList
query	CCN.Modules.Rewards.BusinessEntity.OrderQuery
return	BasePageList

GetSettLogById() public method

根据id获取结算记录信息

public GetSettLogById ( string innerid ) : SettlementLogModel
innerid	string
return	CCN.Modules.Rewards.BusinessEntity.SettlementLogModel

GetSettLogPageList() public method

结算记录列表

public GetSettLogPageList ( SettlementLogQueryModel query ) : BasePageList
query	CCN.Modules.Rewards.BusinessEntity.SettlementLogQueryModel	查询条件
return	BasePageList

GetSettedCodePageList() public method

根据settid获取已结算的code列表

public GetSettedCodePageList ( SettedCodeQueryModel query ) : BasePageList
query	CCN.Modules.Rewards.BusinessEntity.SettedCodeQueryModel	查询条件
return	BasePageList

GetSharePointRecord() public method

获取今天分享获得积分记录

public GetSharePointRecord ( string custid ) : int
custid	string	会员id
return	int

GetShopAreaByCityid() public method

根据城市id获取区列表

public GetShopAreaByCityid ( string cityid ) : IEnumerable
cityid	string
return	IEnumerable

GetShopByCountyid() public method

根据区id获取商户列表

public GetShopByCountyid ( string countyid ) : IEnumerable
countyid	string
return	IEnumerable

GetShopById() public method

根据id获取商户信息

public GetShopById ( string innerid ) : ShopModel
innerid	string
return	ShopModel

GetShopList() public method

根据id获取商户信息

public GetShopList ( ) : IEnumerable
return	IEnumerable

GetShopModel() public method

商户登录

public GetShopModel ( string shopcode, string password ) : ShopModel
shopcode	string
password	string
return	ShopModel

GetShopPageList() public method

商户列表

public GetShopPageList ( ShopQueryModel query ) : BasePageList
query	ShopQueryModel	查询条件
return	BasePageList

GetShopStaffById() public method

根据id获取商户职员信息

public GetShopStaffById ( string innerid ) : ShopStaffModel
innerid	string
return	CCN.Modules.Rewards.BusinessEntity.ShopStaffModel

GetShopStaffModel() public method

商户登录

public GetShopStaffModel ( string loginname, string password ) : ShopStaffInfo
loginname	string
password	string
return	CCN.Modules.Rewards.BusinessEntity.ShopStaffInfo

GetShopStaffPageList() public method

商户职员列表

public GetShopStaffPageList ( ShopStaffQueryModel query ) : BasePageList
query	CCN.Modules.Rewards.BusinessEntity.ShopStaffQueryModel	查询条件
return	BasePageList

GetShopViewById() public method

根据id获取商户信息（包含关联信息）

public GetShopViewById ( string innerid ) : ShopInfoViewModel
innerid	string
return	ShopInfoViewModel

GetUsedCodePageList() public method

根据cardid获取已核销的code列表

public GetUsedCodePageList ( UsedCodeQueryModel query ) : BasePageList
query	CCN.Modules.Rewards.BusinessEntity.UsedCodeQueryModel	查询条件
return	BasePageList

PointExchangeCoupon() public method

积分兑换礼券

public PointExchangeCoupon ( CustPointExChangeCouponModel model ) : int
model	CCN.Modules.Rewards.BusinessEntity.CustPointExChangeCouponModel	兑换相关信息
return	int

PointToCoupon() public method

积分兑换礼券

public PointToCoupon ( CustPointToCouponModel model ) : int
model	CCN.Modules.Rewards.BusinessEntity.CustPointToCouponModel	兑换相关信息
return	int

SaveOrder() public method

保存购买订单信息

public SaveOrder ( CouponBuyModel model ) : int
model	CCN.Modules.Rewards.BusinessEntity.CouponBuyModel
return	int

UnBindWechatProduct() public method

礼券与微信小店产品解除绑定

public UnBindWechatProduct ( string cardid ) : int
cardid	string
return	int

UpdateCoupon() public method

修改礼券

public UpdateCoupon ( CouponInfoModel model ) : int
model	CCN.Modules.Rewards.BusinessEntity.CouponInfoModel	礼券信息
return	int

UpdateOrderResult() public method

修改购买订单处理结果

public UpdateOrderResult ( CouponBuyModel model ) : int
model	CCN.Modules.Rewards.BusinessEntity.CouponBuyModel
return	int

UpdateQrcode() public method

根据id更新qrcode 根据code更新qrcode

public UpdateQrcode ( string code, string qrcode ) : int
code	string
qrcode	string
return	int

UpdateSettLog() public method

修改结算记录

public UpdateSettLog ( SettlementLogModel model ) : int
model	CCN.Modules.Rewards.BusinessEntity.SettlementLogModel
return	int

UpdateSettLogPic() public method

更新结算记录图片

public UpdateSettLogPic ( string innerid, string pictures ) : int
innerid	string	记录id
pictures	string
return	int

UpdateShop() public method

更新商户

public UpdateShop ( ShopModel model ) : int
model	ShopModel
return	int

UpdateShopPassword() public method

修改商户密码

public UpdateShopPassword ( string innerid, string password ) : int
innerid	string
password	string
return	int

UpdateShopStaff() public method

更新商户Staff

public UpdateShopStaff ( ShopStaffModel model ) : int
model	CCN.Modules.Rewards.BusinessEntity.ShopStaffModel
return	int

UpdateShopStaffStatus() public method

修改商户Staff状态(冻结和解冻)

public UpdateShopStaffStatus ( string innerid, int status ) : int
innerid	string
status	int
return	int

UpdateShopStatus() public method

修改商户状态(冻结和解冻)

public UpdateShopStatus ( string innerid, int status ) : int
innerid	string
status	int
return	int

UpdateStatus() public method

获取礼券信息 by code 更新礼券状态

public UpdateStatus ( string cardid, int status ) : int
cardid	string
status	int
return	int

UpdateStock() public method

修改礼券库存

public UpdateStock ( CouponInfoModel model ) : int
model	CCN.Modules.Rewards.BusinessEntity.CouponInfoModel	礼券信息
return	int

UpdateValidity() public method

修改礼券有效期

public UpdateValidity ( CouponInfoModel model ) : int
model	CCN.Modules.Rewards.BusinessEntity.CouponInfoModel	礼券信息
return	int

ValidatedBindRepeat() public method

礼券与微信小店产品绑定

public ValidatedBindRepeat ( string productid ) : int
productid	string
return	int