using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using CY.IDAL;
|
using CY.Model;
|
using AbstractFactory;
|
using CY.IBaseDAL;
|
using CY.Infrastructure.DESEncrypt;
|
using CY.Infrastructure.Query;
|
|
namespace CY.BLL.OA
|
{
|
public class OA_YujihuikuanBLL
|
{
|
IOA_YujihuikuanDAL _IOA_YujihuikuanDAL = null;
|
|
/// <summary>
|
/// 初始化构造
|
/// </summary>
|
public OA_YujihuikuanBLL()
|
{
|
//获取OA_Yujihuikuan DAL实现
|
_IOA_YujihuikuanDAL = Factory.GetDALByInterfaceName(DALInterface.IOA_YujihuikuanDAL) as IOA_YujihuikuanDAL;
|
|
|
}
|
|
/// <summary>
|
/// 新增送货安排
|
/// </summary>
|
/// <param name="rType"></param>
|
/// <param name="m_OA_CustomerCommunications"></param>
|
/// <param name="m_EC_AcceptWayByCustomers"></param>
|
/// <returns></returns>
|
public bool InsertModel(CY.Model.OA_Yujihuikuan m_OA_Yujihuikuan)
|
{
|
try
|
{
|
|
return _IOA_YujihuikuanDAL.InserModel(m_OA_Yujihuikuan);
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
}
|
|
/// <summary>
|
/// 修改送货安排
|
/// </summary>
|
/// <param name="rType"></param>
|
/// <returns></returns>
|
public bool UpdateModel(CY.Model.OA_Yujihuikuan m_OA_Yujihuikuan)
|
{
|
try
|
{
|
return _IOA_YujihuikuanDAL.UpdateModel(m_OA_Yujihuikuan);
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
}
|
|
/// <summary>
|
/// 获取全部合作客户
|
/// </summary>
|
/// <param name="Keyid">主键id</param>
|
/// <returns></returns>
|
public IEnumerable<OA_Yujihuikuan> GetModelList()
|
{
|
Query query = new Query();
|
return _IOA_YujihuikuanDAL.SelectAllModel(query);
|
}
|
|
|
|
|
/// <summary>
|
/// 获取全部合作客户
|
/// </summary>
|
/// <param name="Keyid">主键id</param>
|
/// <returns></returns>
|
public OA_Yujihuikuan GetModelByKeyid(Guid? keyid, Guid? BuyerId, string shoukuanshijian = "")
|
{
|
|
return _IOA_YujihuikuanDAL.GetModelByKeyid(keyid, BuyerId, shoukuanshijian);
|
}
|
|
/// <summary>
|
/// 删除合作客户
|
/// </summary>
|
/// <param name="rType"></param>
|
/// <returns></returns>
|
public bool DeleteModel(CY.Model.OA_Yujihuikuan rType)
|
{
|
try
|
{
|
_IOA_YujihuikuanDAL.DeleteModel(rType);
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
return true;
|
}
|
|
/// <summary>
|
/// 查询合作客户分页列表
|
/// </summary>
|
/// <param name="pa"></param>
|
/// <returns></returns>
|
public IEnumerable<OA_Yujihuikuan> SelectModelPage(Pagination pa, Guid FirmId, string CreateTimeStart, string CreateTimeEnd,
|
string Kaipiaoshenqing, string Kehuqianshou, string BusinessManagerId, string CustormerName)
|
{
|
string Condition = " and ok.FirmId ='" + FirmId + "' ";
|
|
if (!string.IsNullOrEmpty(CreateTimeStart))
|
Condition += " and DATEDIFF(day,ok.[CreateTime],'" + CreateTimeStart + "')<=0 ";
|
|
if (!string.IsNullOrEmpty(CreateTimeEnd))
|
Condition += " and DATEDIFF(day,ok.[CreateTime],'" + CreateTimeEnd + "')>=0 ";
|
|
if (!string.IsNullOrEmpty(Kaipiaoshenqing))
|
Condition += " and ok.Kaipiaoshenqing = '" + Kaipiaoshenqing + "'";
|
if (!string.IsNullOrEmpty(Kehuqianshou))
|
Condition += " and ok.Kehuqianshou = '" + Kehuqianshou + "'";
|
if (!string.IsNullOrEmpty(BusinessManagerId))
|
Condition += " and ok.BusinessManagerId = '" + BusinessManagerId + "'";
|
if (!string.IsNullOrEmpty(CustormerName))
|
Condition += " and oe.CompanyName like '%" + CustormerName + "%'";
|
|
Query query = new Query();
|
IList<Criterion> criterias = new List<Criterion>()
|
{
|
new Criterion("", Condition),
|
|
new Criterion("orderBy"," SellerOrderId desc ")
|
};
|
query.Criteria = criterias;
|
return _IOA_YujihuikuanDAL.SelectModelPage(query, pa);
|
}
|
|
|
}
|
}
|
