/**
|
* IOA_CorporateClientsDAL.cs
|
*
|
* 功 能： 合作客户数据访问接口
|
* 类 名： IOA_CorporateClientsDAL
|
*
|
* Ver 变更日期 负责人 变更内容
|
* ───────────────────────────────────
|
* V0.01 2013-4-2 15:11 吴辉 初版
|
* V0.02 2013-5-29 17:43 吴崎均 增加转换在线会员为厂商客户方法
|
*
|
*
|
*
|
*
|
*
|
*
|
*/
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using CY.IBaseDAL;
|
using CY.Model;
|
|
namespace CY.IDAL
|
{
|
/// <summary>
|
/// 办公系统合作客户-数据库操作接口
|
/// </summary>
|
public interface IOA_CorporateClientsDAL : ICommonDAL, IPaging<OA_CorporateClients>, IGetAllModel<OA_CorporateClients>
|
{
|
/// <summary>
|
/// 单个查询
|
/// </summary>
|
/// <param name="Keyid">编号</param>
|
/// <returns></returns>
|
OA_CorporateClients SelectModelByKeyid(Guid Keyid);
|
|
/// <summary>
|
/// 单个查询详细
|
/// </summary>
|
/// <param name="Keyid">编号</param>
|
/// <returns></returns>
|
OA_CorporateClients SelectModelDetailByKeyid(Guid Keyid);
|
|
/// <summary>
|
/// 单个查询
|
/// </summary>
|
/// <param name="FirmId">厂商编号</param>
|
/// <returns></returns>
|
OA_CorporateClients SelectModelByFirmId(Guid FirmId);
|
|
/// <summary>
|
/// 新增合作客户
|
/// </summary>
|
/// <param name="rType"></param>
|
/// <param name="m_OA_CustomerCommunications"></param>
|
/// <param name="m_EC_AcceptWayByCustomers"></param>
|
/// <returns></returns>
|
bool InsertModel(CY.Model.OA_CorporateClients rType, OA_CustomerCommunications m_OA_CustomerCommunications, EC_AcceptWayByCustomers m_EC_AcceptWayByCustomers);
|
|
/// <summary>
|
/// 修改合作客户
|
/// </summary>
|
/// <param name="rType"></param>
|
/// <returns></returns>
|
bool UpdateModel(CY.Model.OA_CorporateClients rType, OA_CustomerCommunications m_OA_CustomerCommunications, EC_AcceptWayByCustomers m_EC_AcceptWayByCustomers);
|
|
/// <summary>
|
/// 根据厂商编号查询全部会员
|
/// </summary>
|
/// <param name="FirmId">编号</param>
|
/// <returns></returns>
|
IEnumerable<OA_CorporateClients> SelectListByFirmId(Guid FirmId);
|
|
/// <summary>
|
/// 根据厂商编号查询全部外协厂商
|
/// </summary>
|
/// <param name="MemberId">编号</param>
|
/// <returns></returns>
|
IEnumerable<OA_CorporateClients> SelectListByMemberId(Guid MemberId);
|
|
/// <summary>
|
/// 设置自动外协
|
/// </summary>
|
/// <param name="Keyid"></param>
|
/// <param name="i"></param>
|
/// <returns></returns>
|
bool EditModel(Guid Keyid, string i);
|
|
/// <summary>
|
/// 获取询价编号
|
/// </summary>
|
/// <param name="FirmId"></param>
|
/// <param name="MemberId"></param>
|
/// <returns></returns>
|
Guid GetInquiryId(Guid FirmId, Guid CustormId);
|
|
/// <summary>
|
/// 根据厂商以及会员编号查询客户信息
|
/// </summary>
|
/// <param name="Keyid">编号</param>
|
/// <returns></returns>
|
OA_CorporateClients SelectModelByFirmIdandMemberId(Guid FirmId, Guid MemberId);
|
|
/// <summary>
|
/// 判断会员是否是厂商的客户
|
/// </summary>
|
/// <param name="FirmId"></param>
|
/// <param name="MemberId"></param>
|
/// <returns></returns>
|
bool IsCustormByFirmIdandMemberId(Guid FirmId, Guid MemberId);
|
|
/// <summary>
|
/// 分页查询外协厂商
|
/// </summary>
|
/// <param name="pagination"></param>
|
/// <param name="MemberId"></param>
|
/// <param name="OutVendorName"></param>
|
/// <returns></returns>
|
IEnumerable<Model.OA_CorporateClients> SelectModelPage(Infrastructure.Query.Pagination pagination, Guid MemberId, string OutVendorName);
|
|
/// <summary>
|
/// 模糊查询外协公司名称
|
/// </summary>
|
/// <param name="CompanyName">公司名</param>
|
/// <returns></returns>
|
IEnumerable<OA_CorporateClients> SelectListListByName(string CompanyName, Guid MemberId);
|
|
/// <summary>
|
/// 根据会员id和厂商id获取客户编号
|
/// </summary>
|
/// <param name="FirmId"></param>
|
/// <param name="MemberId"></param>
|
/// <returns></returns>
|
Guid GetCustormId(Guid FirmId, Guid MemberId);
|
|
/// <summary>
|
/// 订单收款，外协付款使用预付款
|
/// </summary>
|
/// <param name="MemberId">订单收款传客户编号，外协付款传自己的会员编号</param>
|
/// <param name="FirmId">订单收款传自己的会员编号，外协付款传外协厂商的编号</param>
|
/// <param name="Money">操作金额</param>
|
/// <param name="SubjectName">科目名称</param>
|
/// <param name="Operator">操作人</param>
|
/// <param name="OperatTypeId">操作类型</param>
|
/// <returns></returns>
|
bool OrderReciveMoney(Guid MemberId, Guid FirmId, decimal? Money, string SubjectName, string Operator, int? OperatTypeId);
|
|
/// <summary>
|
/// 转化在线用户为某厂商客户方法
|
/// </summary>
|
/// <param name="firmId">厂商编号</param>
|
/// <param name="memberId">会员编号</param>
|
/// <param name="theOperator">操作人</param>
|
/// <returns></returns>
|
int ConvertToCorporateClient(Guid firmId, Guid memberId, string theOperator);
|
|
/// <summary>
|
/// 判断企业网站能否登陆成功
|
/// </summary>
|
/// <param name="LoginPhone"></param>
|
/// <param name="PwdNum"></param>
|
/// <param name="MemberId"></param>
|
/// <returns></returns>
|
OA_CorporateClients IfHasMember(string LoginPhone, string PwdNum, Guid MemberId);
|
|
/// <summary>
|
/// 根据客户编号获取客户
|
/// </summary>
|
/// <param name="CustomId">客户编号</param>
|
/// <returns></returns>
|
IEnumerable<OA_CorporateClients> SelectListListByCustomId(string CustomId, Guid MemberId);
|
|
/// <summary>
|
/// 意向客户导入合作客户
|
/// </summary>
|
/// <param name="m_OA_CorporateClients"></param>
|
/// <param name="m_OA_CustomerCommunications"></param>
|
/// <param name="m_EC_AcceptWayByCustomers"></param>
|
/// <param name="m_OA_IntentionCustomer"></param>
|
/// <returns></returns>
|
bool IntIntoModel(OA_CorporateClients m_OA_CorporateClients, OA_CustomerCommunications m_OA_CustomerCommunications, EC_AcceptWayByCustomers m_EC_AcceptWayByCustomers, OA_IntentionCustomer m_OA_IntentionCustomer);
|
|
/// <summary>
|
/// 获取总的预付款余额
|
/// </summary>
|
/// <param name="MemberId"></param>
|
/// <returns></returns>
|
decimal GetAllPrepayments(Guid MemberId);
|
|
/// <summary>
|
/// 模糊查询客户公司名称
|
/// </summary>
|
/// <param name="CompanyName"></param>
|
/// <param name="MemberId"></param>
|
/// <returns></returns>
|
IEnumerable<OA_CorporateClients> SelectCustomListByName(string CompanyName, Guid MemberId);
|
|
/// <summary>
|
/// 转移客户
|
/// </summary>
|
/// <param name="BussinessManager"></param>
|
/// <param name="CostomManager"></param>
|
/// <param name="type"></param>
|
/// <param name="keyids"></param>
|
/// <returns></returns>
|
bool ShiftIntOrCus(int? BussinessManager, int? CostomManager, string type, string keyids);
|
|
/// <summary>
|
/// 检测厂商是否存在
|
/// </summary>
|
/// <param name="CompanyName"></param>
|
/// <param name="FirmId"></param>
|
/// <param name="Keyid"></param>
|
/// <returns></returns>
|
bool isExistCompanyName(String CompanyName, Guid FirmId, Guid Keyid);
|
|
/// <summary>
|
/// 根据厂商以及会员编号查询外协厂商
|
/// </summary>
|
/// <param name="FirmId"></param>
|
/// <param name="MemberId"></param>
|
/// <returns></returns>
|
OA_CorporateClients SelectOutsourceByFirmIdandMemberId(Guid FirmId, Guid MemberId);
|
|
/// <summary>
|
/// 合并客户
|
/// </summary>
|
/// <param name="DefaultId"></param>
|
/// <param name="DelId"></param>
|
/// <param name="InquiryId"></param>
|
/// <returns></returns>
|
bool MergerCustom(Guid DefaultId, Guid DelId, Guid InquiryId);
|
|
/// <summary>
|
/// 根据个人网店编号查询自动外协厂商
|
/// </summary>
|
/// <param name="MemberId"></param>
|
/// <returns></returns>
|
OA_CorporateClients GetDefaultOutFirm(Guid MemberId);
|
|
/// <summary>
|
/// 统计金额
|
/// </summary>
|
/// <param name="query"></param>
|
/// <param name="pagination"></param>
|
/// <returns></returns>
|
Model.OA_CorporateClients SumRecordMoney(Infrastructure.Query.Query query, Infrastructure.Query.Pagination pagination);
|
|
/// <summary>
|
/// 根据会员编号查询所有已添加我为客户的厂商
|
/// </summary>
|
/// <param name="MemberId">编号</param>
|
/// <returns></returns>
|
IEnumerable<OA_CorporateClients> SelectListByMyId(Guid MemberId);
|
/// <summary>
|
/// 根据会员ID和外协厂商名称获取外协厂商
|
/// </summary>
|
/// <param name="MemberId"></param>
|
/// <param name="OutVendorName"></param>
|
/// <returns></returns>
|
OA_CorporateClients GetModelByMemberIdAndName(Guid MemberId, string OutVendorName);
|
|
|
/// <summary>
|
/// 新增合作客户拜访
|
/// </summary>
|
/// <param name="rType"></param>
|
/// <param name="m_OA_CustomerCommunications"></param>
|
/// <param name="m_EC_AcceptWayByCustomers"></param>
|
/// <returns></returns>
|
bool InsertModelVisit(CY.Model.OA_CorporateClientsVisit rType);
|
|
/// <summary>
|
/// 修改合作客户拜访
|
/// </summary>
|
/// <param name="rType"></param>
|
/// <returns></returns>
|
bool UpdateModelVisit(CY.Model.OA_CorporateClientsVisit rType);
|
|
/// <summary>
|
/// 根据客户id查询拜访记录
|
/// </summary>
|
/// <param name="MemberId">编号</param>
|
/// <returns></returns>
|
IEnumerable<OA_CorporateClientsVisit> SelectVisitListByCorId(Guid kehuId);
|
|
|
/// <summary>
|
/// 新增合作客户订单需求
|
/// </summary>
|
/// <param name="rType"></param>
|
/// <param name="m_OA_CustomerCommunications"></param>
|
/// <param name="m_EC_AcceptWayByCustomers"></param>
|
/// <returns></returns>
|
bool InsertModelPrint(CY.Model.OA_CorporateClientsPrint rType);
|
|
/// <summary>
|
/// 修改合作客户订单需求
|
/// </summary>
|
/// <param name="rType"></param>
|
/// <returns></returns>
|
bool UpdateModelPrint(CY.Model.OA_CorporateClientsPrint rType);
|
|
/// <summary>
|
/// 根据客户id查询订单需求
|
/// </summary>
|
/// <param name="MemberId">编号</param>
|
/// <returns></returns>
|
IEnumerable<OA_CorporateClientsPrint> SelectPrintListByCorId(Guid kehuId);
|
|
/// <summary>
|
/// 根据客户id查询订单需求
|
/// </summary>
|
/// <param name="MemberId">编号</param>
|
/// <returns></returns>
|
OA_CorporateClientsPrint SelectPrintListByPrintId(int PrintId);
|
|
|
|
/// <summary>
|
/// 新增合作客户订单印刷选项
|
/// </summary>
|
/// <param name="rType"></param>
|
/// <param name="m_OA_CustomerCommunications"></param>
|
/// <param name="m_EC_AcceptWayByCustomers"></param>
|
/// <returns></returns>
|
bool InsertModelParameter(CY.Model.OA_CorporateClientsParameter rType);
|
|
/// <summary>
|
/// 修改合作客户订单印刷选项
|
/// </summary>
|
/// <param name="rType"></param>
|
/// <returns></returns>
|
bool UpdateModelParameter(CY.Model.OA_CorporateClientsParameter rType);
|
|
|
|
|
/// <summary>
|
/// 新增合作客户订单印刷选项
|
/// </summary>
|
/// <param name="rType"></param>
|
/// <param name="m_OA_CustomerCommunications"></param>
|
/// <param name="m_EC_AcceptWayByCustomers"></param>
|
/// <returns></returns>
|
bool InsertModelBiddingcompany(CY.Model.OA_CorporateClients rType);
|
|
/// <summary>
|
/// 根据客户id查询订单需求
|
/// </summary>
|
/// <param name="MemberId">编号</param>
|
/// <returns></returns>
|
IEnumerable<OA_CorporateClients> SelectBiddingcompanyByFirmId(Guid FirmId);
|
|
|
|
/// <summary>
|
/// 根据客户id查询拜访记录
|
/// </summary>
|
/// <param name="MemberId">编号</param>
|
/// <returns></returns>
|
IEnumerable<OA_CorporateClientsVisit> SelectVisitListByBuzAndTime(int? BusinessManagerId,string chaxuntime);
|
|
}
|
}
|
