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