C# Class CCN.Modules.Customer.DataAccess.CustomerDA

Inheritance: CustomerDataAccessBase

Show file Open project: Chinaccn/surfboard

Public Methods

Method	Description
AddAuthentication ( CustAuthenticationModel model ) : int	用户添加认证信息
AddCompanyApplyUpdate ( CompanyApplyUpdateModel model ) : int	申请企业信息修改
AddCompanyPictureList ( List pathList, string settid ) : int	批量保存图片(添加)
AddCustWeChatPay ( CustWxPayModel model ) : int	保存会员的订单
AddLaudator ( CustLaudator model ) : int	保存点赞人信息
AddSiteAdvice ( SiteAdviceModel model ) : int	保存投诉建议
AddTag ( CustTagModel model ) : int	添加标签
AddUser ( UserModel userInfo ) : int	C用户用户注册
AuditAuthentication ( CustAuthenticationModel model ) : int	审核认证信息
CancelAuditAuthentication ( string custid ) : int	撤销审核
CheckComment ( string ip, string companyid ) : int	验证重复评论
CheckEmail ( string email ) : int	会员注册检查Email是否被注册
CheckMobile ( string mobile ) : int	会员注册检查手机号是否被注册
CheckPraise ( string ip, string companyid ) : int	验证重复点赞
CustInfoByCarid ( string carid ) : CustModel	根据carid获取会员基本信息
CustInfoByOpenid ( string openid ) : CustModel	根据openid获取会员基本信息
CustLogin ( CustLoginInfo loginInfo ) : CustModel	用户登录
CustLoginByOpenid ( string openid ) : CustModel	用户登录(openid登录)
CustRegister ( CustModel userInfo ) : int	用户注册
CustWeChatPayByCustid ( string custid ) : CustWxPayModel	获取会员的订单
CustWeChatPayByorderno ( string orderno ) : CustWxPayModel	根据订单号获取订单信息
CustWechatByOpenid ( string openid ) : CustWechat	获取微信信息
CustomerDA ( ) : System
DelCompanyPictureList ( List idList, string settid ) : int	批量保存图片(删除)
DelTagRelation ( string innerid ) : int	删除标签关系
DeleteAll ( ) : int	清除所有数据(除基础数据)
DeleteComment ( string innerid ) : int	删除评论（逻辑删除）
DeleteCustomer ( string mobile ) : int	删除会员所有信息
DeleteTag ( string innerid ) : int	删除标签
DoComment ( CommentModel model ) : int	企业评论
DoPraise ( PraiseModel model ) : int	企业点赞
DoTagRelation ( CustTagRelation model ) : int	打标签
GetApplyModel ( string applyid ) : CompanyApplyUpdateModel	获取申请的信息
GetCommentPageList ( CommentQueryModel query ) : BasePageList	评论列表
GetCommentViewByID ( string innerid ) : CommentListModel	根据ID获取详情
GetCompanyById ( string innerid ) : CompanyViewModel	获取公司详情
GetCompanyModelById ( string innerid ) : CompanyModel	获取公司model
GetCompanyPageList ( CompanyQueryModel query ) : BasePageList	公司列表
GetCompanyPictureById ( string settid ) : IEnumerable	获取公司图片
GetCompanyPictureByIds ( List idList ) : IEnumerable	获取需要删除的图片列表
GetCompanyPictureListById ( string settid ) : IEnumerable	获取公司图片
GetCustAuthByCustid ( string custid ) : CustAuthenticationModel	获取会员认证信息 by custid
GetCustAuthById ( string innerid ) : CustAuthenticationModel	获取会员认证信息 by innerid
GetCustById ( string innerid ) : CustViewModel	获取会员详情
GetCustByMobile ( string mobile ) : CustModel	获取会员详情（根据手机号）
GetCustByOpenid ( string openid ) : CustModel	根据openid获取会员信息
GetCustLaudatorByOpenid ( string openid, string tocustid ) : CustLaudator	获取点赞人信息 by openid
GetCustPageList ( CustQueryModel query ) : BasePageList	获取会员列表
GetCustWeChatList ( CustWeChatQueryModel query ) : BasePageList	获取cust_wechat信息列表
GetCustomerAllPicture ( string mobile ) : DeleteCustAllPic	删除会员所有信息
GetLaudatorListByCustid ( string custid ) : IEnumerable	根据会员id获取所有点赞人列表
GetScoreList ( string settid ) : ScoreListModel	评分列表
GetTagById ( string innerid ) : CustTagModel	获取标签详情
GetTagPageList ( CustTagQueryModel query ) : BasePageList	获取标签列表
GetTagRelation ( string custid ) : IEnumerable	获取会员拥有的标签
GetTagRelationWithOper ( string custid, string tagid ) : IEnumerable	获取会员该标签的操作者
GetUpdateApplyById ( string applyid ) : CompanyApplyUpdateViewModel	获取申请的信息view
GetUpdateApplyPageList ( CompanyUpdateApplyQueryModel query ) : BasePageList	修改申请列表
GetUserInfoById ( string innerid ) : UserViewModel	C用户获取会员详情
GetUserInfoByMobile ( string mobile ) : UserViewModel	C用户获取会员详情（根据手机号）
GetUserPageList ( UserQueryModel query ) : BasePageList	C用户获取会员列表
ImportCompany ( DataTable dt ) : int	导入公司
RebindFans ( CustRebindFansModel model ) : int
SaveCompanyPicture ( CompanyPictureListModel model ) : int	批量保存图片(添加+删除)
SaveLaudatorRelation ( CustLaudatorRelation relModel ) : int	保存关系表
SaveTotalRecord ( CustTotalRecordModel model ) : int
SendWelfare ( int refreshnum, int topnum ) : int	发福利
UpdateApplyStatus ( CompanyApplyUpdateModel model ) : int	更新申请表状态
UpdateAuthentication ( CustAuthenticationModel model ) : int	用户修改认证信息
UpdateCompanyModel ( CompanyModel model ) : int	更新企业信息（后台系统）
UpdateCompanyModel ( CompanyModel model, string pictures ) : int	更新企业信息
UpdateCustInfo ( CustModel model ) : int	修改会员信息
UpdateCustStatus ( string innerid, int status ) : int	修改会员状态(冻结和解冻)
UpdateCustTotalCount ( string custid, int type, int count, int oper = 1 ) : int	更新会员的刷新次数
UpdateCustType ( string innerid ) : CustModel	修改会员类型(修改成功后返回会员信息)
UpdateCustWeChatPay ( CustWxPayModel model ) : int	保存会员的订单
UpdateCustWeChatPayBack ( string orderNo ) : int	支付回调更新会员信息
UpdateLaudator ( CustLaudator model ) : int	用户修改认证信息
UpdateOpenid ( string custid, string openid ) : int	更新绑定openid
UpdatePassword ( CustRetrievePassword mRetrievePassword ) : int	修改密码
UpdateQrCode ( string innerid, string qrcode ) : int	更新会员二维码
UpdateTag ( CustTagModel model ) : int	修改标签
UpdateTagStatus ( string innerid, int status ) : int	修改标签状态
UpdateUserInfo ( UserModel model ) : int	C用户修改会员信息
UpdateUserPassword ( UserRetrievePassword mRetrievePassword ) : int	C用户修改密码
UpdateUserQrCode ( string innerid, string qrcode ) : int	C用户更新会员二维码
UpdateUserStatus ( string innerid, int status ) : int	C用户修改会员状态(冻结和解冻)
UpgradeBoutique ( string innerid ) : int	升级为精品车商
UserCheckMobile ( string mobile ) : int	会员注册检查手机号是否被注册
UserLogin ( UserLoginInfo loginInfo ) : UserViewModel	C用户用户登录

Method Details

AddAuthentication() public method

用户添加认证信息

public AddAuthentication ( CustAuthenticationModel model ) : int
model	CCN.Modules.Customer.BusinessEntity.CustAuthenticationModel	认证信息
return	int

AddCompanyApplyUpdate() public method

申请企业信息修改

public AddCompanyApplyUpdate ( CompanyApplyUpdateModel model ) : int
model	CCN.Modules.Customer.BusinessEntity.CompanyApplyUpdateModel
return	int

AddCompanyPictureList() public method

批量保存图片(添加)

public AddCompanyPictureList ( List pathList, string settid ) : int
pathList	List
settid	string
return	int

AddCustWeChatPay() public method

保存会员的订单

public AddCustWeChatPay ( CustWxPayModel model ) : int
model	CCN.Modules.Customer.BusinessEntity.CustWxPayModel
return	int

AddLaudator() public method

保存点赞人信息

public AddLaudator ( CustLaudator model ) : int
model	CCN.Modules.Customer.BusinessEntity.CustLaudator	点赞人信息
return	int

AddSiteAdvice() public method

保存投诉建议

public AddSiteAdvice ( SiteAdviceModel model ) : int
model	CCN.Modules.Customer.BusinessEntity.SiteAdviceModel
return	int

AddTag() public method

添加标签

public AddTag ( CustTagModel model ) : int
model	CustTagModel	标签信息
return	int

AddUser() public method

C用户用户注册

public AddUser ( UserModel userInfo ) : int
userInfo	CCN.Modules.Customer.BusinessEntity.UserModel	用户信息
return	int

AuditAuthentication() public method

审核认证信息

public AuditAuthentication ( CustAuthenticationModel model ) : int
model	CCN.Modules.Customer.BusinessEntity.CustAuthenticationModel	会员相关信息
return	int

CancelAuditAuthentication() public method

撤销审核

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

CheckComment() public method

验证重复评论

public CheckComment ( string ip, string companyid ) : int
ip	string
companyid	string
return	int

CheckEmail() public method

会员注册检查Email是否被注册

public CheckEmail ( string email ) : int
email	string	Email
return	int

CheckMobile() public method

会员注册检查手机号是否被注册

public CheckMobile ( string mobile ) : int
mobile	string	手机号
return	int

CheckPraise() public method

验证重复点赞

public CheckPraise ( string ip, string companyid ) : int
ip	string
companyid	string
return	int

CustInfoByCarid() public method

根据carid获取会员基本信息

public CustInfoByCarid ( string carid ) : CustModel
carid	string	车辆id
return	CCN.Modules.Customer.BusinessEntity.CustModel

CustInfoByOpenid() public method

根据openid获取会员基本信息

public CustInfoByOpenid ( string openid ) : CustModel
openid	string	openid
return	CCN.Modules.Customer.BusinessEntity.CustModel

CustLogin() public method

用户登录

public CustLogin ( CustLoginInfo loginInfo ) : CustModel
loginInfo	CCN.Modules.Customer.BusinessEntity.CustLoginInfo	登录账户
return	CCN.Modules.Customer.BusinessEntity.CustModel

CustLoginByOpenid() public method

用户登录(openid登录)

public CustLoginByOpenid ( string openid ) : CustModel
openid	string	openid
return	CCN.Modules.Customer.BusinessEntity.CustModel

CustRegister() public method

用户注册

public CustRegister ( CustModel userInfo ) : int
userInfo	CCN.Modules.Customer.BusinessEntity.CustModel	用户信息
return	int

CustWeChatPayByCustid() public method

获取会员的订单

public CustWeChatPayByCustid ( string custid ) : CustWxPayModel
custid	string
return	CCN.Modules.Customer.BusinessEntity.CustWxPayModel

CustWeChatPayByorderno() public method

根据订单号获取订单信息

public CustWeChatPayByorderno ( string orderno ) : CustWxPayModel
orderno	string
return	CCN.Modules.Customer.BusinessEntity.CustWxPayModel

CustWechatByOpenid() public method

获取微信信息

public CustWechatByOpenid ( string openid ) : CustWechat
openid	string	openid
return	CCN.Modules.Customer.BusinessEntity.CustWechat

CustomerDA() public method

public CustomerDA ( ) : System
return	System

DelCompanyPictureList() public method

批量保存图片(删除)

public DelCompanyPictureList ( List idList, string settid ) : int
idList	List
settid	string
return	int

DelTagRelation() public method

删除标签关系

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

DeleteAll() public method

清除所有数据(除基础数据)

public DeleteAll ( ) : int
return	int

DeleteComment() public method

删除评论（逻辑删除）

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

DeleteCustomer() public method

删除会员所有信息

public DeleteCustomer ( string mobile ) : int
mobile	string	手机号
return	int

DeleteTag() public method

删除标签

public DeleteTag ( string innerid ) : int
innerid	string	标签id
return	int

DoComment() public method

企业评论

public DoComment ( CommentModel model ) : int
model	CCN.Modules.Customer.BusinessEntity.CommentModel
return	int

DoPraise() public method

企业点赞

public DoPraise ( PraiseModel model ) : int
model	CCN.Modules.Customer.BusinessEntity.PraiseModel
return	int

DoTagRelation() public method

打标签

public DoTagRelation ( CustTagRelation model ) : int
model	CustTagRelation
return	int

GetApplyModel() public method

获取申请的信息

public GetApplyModel ( string applyid ) : CompanyApplyUpdateModel
applyid	string
return	CCN.Modules.Customer.BusinessEntity.CompanyApplyUpdateModel

GetCommentPageList() public method

评论列表

public GetCommentPageList ( CommentQueryModel query ) : BasePageList
query	CCN.Modules.Customer.BusinessEntity.CommentQueryModel
return	BasePageList

GetCommentViewByID() public method

根据ID获取详情

public GetCommentViewByID ( string innerid ) : CommentListModel
innerid	string
return	CCN.Modules.Customer.BusinessEntity.CommentListModel

GetCompanyById() public method

获取公司详情

public GetCompanyById ( string innerid ) : CompanyViewModel
innerid	string
return	CCN.Modules.Customer.BusinessEntity.CompanyViewModel

GetCompanyModelById() public method

获取公司model

public GetCompanyModelById ( string innerid ) : CompanyModel
innerid	string
return	CCN.Modules.Customer.BusinessEntity.CompanyModel

GetCompanyPageList() public method

公司列表

public GetCompanyPageList ( CompanyQueryModel query ) : BasePageList
query	CCN.Modules.Customer.BusinessEntity.CompanyQueryModel
return	BasePageList

GetCompanyPictureById() public method

获取公司图片

public GetCompanyPictureById ( string settid ) : IEnumerable
settid	string
return	IEnumerable

GetCompanyPictureByIds() public method

获取需要删除的图片列表

public GetCompanyPictureByIds ( List idList ) : IEnumerable
idList	List	车辆ids
return	IEnumerable

GetCompanyPictureListById() public method

获取公司图片

public GetCompanyPictureListById ( string settid ) : IEnumerable
settid	string
return	IEnumerable

GetCustAuthByCustid() public method

获取会员认证信息 by custid

public GetCustAuthByCustid ( string custid ) : CustAuthenticationModel
custid	string	会员id
return	CCN.Modules.Customer.BusinessEntity.CustAuthenticationModel

GetCustAuthById() public method

获取会员认证信息 by innerid

public GetCustAuthById ( string innerid ) : CustAuthenticationModel
innerid	string	id
return	CCN.Modules.Customer.BusinessEntity.CustAuthenticationModel

GetCustById() public method

获取会员详情

public GetCustById ( string innerid ) : CustViewModel
innerid	string	会员id
return	CCN.Modules.Customer.BusinessEntity.CustViewModel

GetCustByMobile() public method

获取会员详情（根据手机号）

public GetCustByMobile ( string mobile ) : CustModel
mobile	string	会员手机号
return	CCN.Modules.Customer.BusinessEntity.CustModel

GetCustByOpenid() public method

根据openid获取会员信息

public GetCustByOpenid ( string openid ) : CustModel
openid	string	openid
return	CCN.Modules.Customer.BusinessEntity.CustModel

GetCustLaudatorByOpenid() public method

获取点赞人信息 by openid

public GetCustLaudatorByOpenid ( string openid, string tocustid ) : CustLaudator
openid	string	点赞者的openid
tocustid	string	被点赞者的会员id
return	CCN.Modules.Customer.BusinessEntity.CustLaudator

GetCustPageList() public method

获取会员列表

public GetCustPageList ( CustQueryModel query ) : BasePageList
query	CCN.Modules.Customer.BusinessEntity.CustQueryModel	查询条件
return	BasePageList

GetCustWeChatList() public method

获取cust_wechat信息列表

public GetCustWeChatList ( CustWeChatQueryModel query ) : BasePageList
query	CCN.Modules.Customer.BusinessEntity.CustWeChatQueryModel
return	BasePageList

GetCustomerAllPicture() public method

删除会员所有信息

public GetCustomerAllPicture ( string mobile ) : DeleteCustAllPic
mobile	string	手机号
return	CCN.Modules.Customer.BusinessEntity.DeleteCustAllPic

GetLaudatorListByCustid() public method

根据会员id获取所有点赞人列表

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

GetScoreList() public method

评分列表

public GetScoreList ( string settid ) : ScoreListModel
settid	string
return	CCN.Modules.Customer.BusinessEntity.ScoreListModel

GetTagById() public method

获取标签详情

public GetTagById ( string innerid ) : CustTagModel
innerid	string	标签id
return	CustTagModel

GetTagPageList() public method

获取标签列表

public GetTagPageList ( CustTagQueryModel query ) : BasePageList
query	CustTagQueryModel	查询条件
return	BasePageList

GetTagRelation() public method

获取会员拥有的标签

public GetTagRelation ( string custid ) : IEnumerable
custid	string
return	IEnumerable

GetTagRelationWithOper() public method

获取会员该标签的操作者

public GetTagRelationWithOper ( string custid, string tagid ) : IEnumerable
custid	string
tagid	string
return	IEnumerable

GetUpdateApplyById() public method

获取申请的信息view

public GetUpdateApplyById ( string applyid ) : CompanyApplyUpdateViewModel
applyid	string
return	CCN.Modules.Customer.BusinessEntity.CompanyApplyUpdateViewModel

GetUpdateApplyPageList() public method

修改申请列表

public GetUpdateApplyPageList ( CompanyUpdateApplyQueryModel query ) : BasePageList
query	CCN.Modules.Customer.BusinessEntity.CompanyUpdateApplyQueryModel
return	BasePageList

GetUserInfoById() public method

C用户获取会员详情

public GetUserInfoById ( string innerid ) : UserViewModel
innerid	string	会员id
return	CCN.Modules.Customer.BusinessEntity.UserViewModel

GetUserInfoByMobile() public method

C用户获取会员详情（根据手机号）

public GetUserInfoByMobile ( string mobile ) : UserViewModel
mobile	string	会员手机号
return	CCN.Modules.Customer.BusinessEntity.UserViewModel

GetUserPageList() public method

C用户获取会员列表

public GetUserPageList ( UserQueryModel query ) : BasePageList
query	CCN.Modules.Customer.BusinessEntity.UserQueryModel	查询条件
return	BasePageList

ImportCompany() public method

导入公司

public ImportCompany ( DataTable dt ) : int
dt	System.Data.DataTable
return	int

RebindFans() public method

public RebindFans ( CustRebindFansModel model ) : int
model	CCN.Modules.Customer.BusinessEntity.CustRebindFansModel
return	int

SaveCompanyPicture() public method

批量保存图片(添加+删除)

public SaveCompanyPicture ( CompanyPictureListModel model ) : int
model	CCN.Modules.Customer.BusinessEntity.CompanyPictureListModel
return	int

SaveLaudatorRelation() public method

保存关系表

public SaveLaudatorRelation ( CustLaudatorRelation relModel ) : int
relModel	CCN.Modules.Customer.BusinessEntity.CustLaudatorRelation	关系对象
return	int

SaveTotalRecord() public method

public SaveTotalRecord ( CustTotalRecordModel model ) : int
model	CCN.Modules.Customer.BusinessEntity.CustTotalRecordModel
return	int

SendWelfare() public method

发福利

public SendWelfare ( int refreshnum, int topnum ) : int
refreshnum	int
topnum	int
return	int

UpdateApplyStatus() public method

更新申请表状态

public UpdateApplyStatus ( CompanyApplyUpdateModel model ) : int
model	CCN.Modules.Customer.BusinessEntity.CompanyApplyUpdateModel
return	int

UpdateAuthentication() public method

用户修改认证信息

public UpdateAuthentication ( CustAuthenticationModel model ) : int
model	CCN.Modules.Customer.BusinessEntity.CustAuthenticationModel	认证信息
return	int

UpdateCompanyModel() public method

更新企业信息（后台系统）

public UpdateCompanyModel ( CompanyModel model ) : int
model	CCN.Modules.Customer.BusinessEntity.CompanyModel
return	int

UpdateCompanyModel() public method

更新企业信息

public UpdateCompanyModel ( CompanyModel model, string pictures ) : int
model	CCN.Modules.Customer.BusinessEntity.CompanyModel
pictures	string
return	int

UpdateCustInfo() public method

修改会员信息

public UpdateCustInfo ( CustModel model ) : int
model	CCN.Modules.Customer.BusinessEntity.CustModel
return	int

UpdateCustStatus() public method

修改会员状态(冻结和解冻)

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

UpdateCustTotalCount() public method

更新会员的刷新次数

public UpdateCustTotalCount ( string custid, int type, int count, int oper = 1 ) : int
custid	string
type	int
count	int
oper	int	1+ 2-
return	int

UpdateCustType() public method

修改会员类型(修改成功后返回会员信息)

public UpdateCustType ( string innerid ) : CustModel
innerid	string
return	CCN.Modules.Customer.BusinessEntity.CustModel

UpdateCustWeChatPay() public method

保存会员的订单

public UpdateCustWeChatPay ( CustWxPayModel model ) : int
model	CCN.Modules.Customer.BusinessEntity.CustWxPayModel
return	int

UpdateCustWeChatPayBack() public method

支付回调更新会员信息

public UpdateCustWeChatPayBack ( string orderNo ) : int
orderNo	string
return	int

UpdateLaudator() public method

用户修改认证信息

public UpdateLaudator ( CustLaudator model ) : int
model	CCN.Modules.Customer.BusinessEntity.CustLaudator	认证信息
return	int

UpdateOpenid() public method

更新绑定openid

public UpdateOpenid ( string custid, string openid ) : int
custid	string
openid	string
return	int

UpdatePassword() public method

修改密码

public UpdatePassword ( CustRetrievePassword mRetrievePassword ) : int
mRetrievePassword	CCN.Modules.Customer.BusinessEntity.CustRetrievePassword
return	int

UpdateQrCode() public method

更新会员二维码

public UpdateQrCode ( string innerid, string qrcode ) : int
innerid	string
qrcode	string
return	int

UpdateTag() public method

修改标签

public UpdateTag ( CustTagModel model ) : int
model	CustTagModel	标签信息
return	int

UpdateTagStatus() public method

修改标签状态

public UpdateTagStatus ( string innerid, int status ) : int
innerid	string	标签ID
status	int
return	int

UpdateUserInfo() public method

C用户修改会员信息

public UpdateUserInfo ( UserModel model ) : int
model	CCN.Modules.Customer.BusinessEntity.UserModel
return	int

UpdateUserPassword() public method

C用户修改密码

public UpdateUserPassword ( UserRetrievePassword mRetrievePassword ) : int
mRetrievePassword	CCN.Modules.Customer.BusinessEntity.UserRetrievePassword
return	int

UpdateUserQrCode() public method

C用户更新会员二维码

public UpdateUserQrCode ( string innerid, string qrcode ) : int
innerid	string
qrcode	string
return	int

UpdateUserStatus() public method

C用户修改会员状态(冻结和解冻)

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

UpgradeBoutique() public method

升级为精品车商

public UpgradeBoutique ( string innerid ) : int
innerid	string	会员id
return	int

UserCheckMobile() public method

会员注册检查手机号是否被注册

public UserCheckMobile ( string mobile ) : int
mobile	string	手机号
return	int

UserLogin() public method

C用户用户登录

public UserLogin ( UserLoginInfo loginInfo ) : UserViewModel
loginInfo	CCN.Modules.Customer.BusinessEntity.UserLoginInfo	登录账户
return	CCN.Modules.Customer.BusinessEntity.UserViewModel