|
/**
|
* OA_DeliverPlanBLL.cs
|
*
|
* 功 能： 合作客户业务逻辑类
|
* 类 名： OA_DeliverPlanBLL
|
*
|
* 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.IDAL;
|
using CY.Model;
|
using AbstractFactory;
|
using CY.IBaseDAL;
|
using CY.Infrastructure.DESEncrypt;
|
using CY.Infrastructure.Query;
|
|
namespace CY.BLL
|
{
|
public class OA_DeliverPlanPaicheBLL
|
{
|
IOA_DeliverPlanPaicheDAL _IOA_DeliverPlanPaicheDAL = null;
|
|
/// <summary>
|
/// 初始化构造
|
/// </summary>
|
public OA_DeliverPlanPaicheBLL()
|
{
|
//获取OA_DeliverPlan DAL实现
|
_IOA_DeliverPlanPaicheDAL = Factory.GetDALByInterfaceName(DALInterface.IOA_DeliverPlanPaicheDAL) as IOA_DeliverPlanPaicheDAL;
|
|
|
}
|
|
/// <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_DeliverPlan m_OA_DeliverPlan)
|
{
|
try
|
{
|
if (m_OA_DeliverPlan.Yichangchuli == null)
|
{
|
m_OA_DeliverPlan.Yichangchuli = "";
|
}
|
if (m_OA_DeliverPlan.Xingzhengzhuize == null)
|
{
|
m_OA_DeliverPlan.Xingzhengzhuize = "";
|
}
|
return _IOA_DeliverPlanPaicheDAL.InserModel(m_OA_DeliverPlan);
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
}
|
|
/// <summary>
|
/// 修改送货安排
|
/// </summary>
|
/// <param name="rType"></param>
|
/// <returns></returns>
|
public bool UpdateModel(CY.Model.OA_DeliverPlan m_OA_DeliverPlan)
|
{
|
try
|
{
|
if (m_OA_DeliverPlan.Yichangchuli == null)
|
{
|
m_OA_DeliverPlan.Yichangchuli = "";
|
}
|
if (m_OA_DeliverPlan.Xingzhengzhuize == null)
|
{
|
m_OA_DeliverPlan.Xingzhengzhuize = "";
|
}
|
return _IOA_DeliverPlanPaicheDAL.UpdateModel(m_OA_DeliverPlan);
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
}
|
|
/// <summary>
|
/// 获取全部合作客户
|
/// </summary>
|
/// <param name="Keyid">主键id</param>
|
/// <returns></returns>
|
public IEnumerable<OA_DeliverPlan> GetModelList()
|
{
|
Query query = new Query();
|
return _IOA_DeliverPlanPaicheDAL.SelectAllModel(query);
|
}
|
|
|
/// <summary>
|
/// 根据formid获得信息
|
/// </summary>
|
/// <param name="Keyid">编号</param>
|
/// <returns></returns>
|
public IEnumerable<Model.OA_DeliverPlan> GetModelByformid(Guid formid)
|
{
|
|
return _IOA_DeliverPlanPaicheDAL.GetModelByformid(formid);
|
}
|
|
|
/// <summary>
|
/// 根据formid获得信息
|
/// </summary>
|
/// <param name="Keyid">编号</param>
|
/// <returns></returns>
|
public IEnumerable<Model.OA_DeliverPlan> GetModelByDeliveredTime(Guid FirmId, DateTime DeliverTime)
|
{
|
|
return _IOA_DeliverPlanPaicheDAL.GetModelByDeliveredTime(FirmId, DeliverTime);
|
}
|
|
|
|
|
/// <summary>
|
/// 获取全部合作客户
|
/// </summary>
|
/// <param name="Keyid">主键id</param>
|
/// <returns></returns>
|
public OA_DeliverPlan GetModelByKeyid(Guid? keyid, Guid? BuyerId, DateTime? DeliveryTime)
|
{
|
|
return _IOA_DeliverPlanPaicheDAL.GetModelByKeyid(keyid, BuyerId, DeliveryTime);
|
}
|
|
/// <summary>
|
/// 删除合作客户
|
/// </summary>
|
/// <param name="rType"></param>
|
/// <returns></returns>
|
public bool DeleteModel(CY.Model.OA_DeliverPlan rType)
|
{
|
try
|
{
|
_IOA_DeliverPlanPaicheDAL.DeleteModel(rType);
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
return true;
|
}
|
|
/// <summary>
|
/// 查询合作客户分页列表
|
/// </summary>
|
/// <param name="pa"></param>
|
/// <returns></returns>
|
public IEnumerable<OA_DeliverPlan> SelectModelPage(Pagination pa, Guid FirmId, string DeliveredTime,
|
string CarId, string DriverId, string DeliveredTimeStart, string DeliveredTimeEnd, string trueMemberId = "", string CustormerName = "", string BusinessManager = "", string wancheng = "")
|
{
|
string Condition = " and od.FirmId ='" + FirmId + "' and od.shifouDelivery = 1 ";
|
string sort = " [Sort] asc ";
|
if (string.IsNullOrEmpty(DeliveredTimeStart) && string.IsNullOrEmpty(DeliveredTimeEnd) && !string.IsNullOrEmpty(DeliveredTime))
|
{
|
if (DeliveredTime != "一周后")
|
{
|
Condition += " and DATEDIFF(day,od.[DeliverTime],'" + DeliveredTime + "')=0 ";
|
|
}
|
else
|
{
|
Condition += " and DATEDIFF(day,GETDATE(),od.[DeliverTime]) >= 6 ";
|
//sort = " DeliverTime desc,[Sort] asc ";
|
|
}
|
}
|
|
if (!string.IsNullOrEmpty(DeliveredTimeStart))
|
{
|
Condition += " and DATEDIFF(day,'"+ DeliveredTimeStart + "',od.[DeliverTime]) >= 0 ";
|
sort = " DeliverTime desc,[Sort] asc ";
|
}
|
|
if (!string.IsNullOrEmpty(DeliveredTimeEnd))
|
{
|
Condition += " and DATEDIFF(day,'" + DeliveredTimeEnd + "',od.[DeliverTime]) <= 0 ";
|
sort = " DeliverTime desc,[Sort] asc ";
|
}
|
|
|
if (!string.IsNullOrEmpty(CarId))
|
Condition += " and od.CarId = '" + CarId + "'";
|
if (!string.IsNullOrEmpty(DriverId))
|
Condition += " and od.DriverId = '" + DriverId + "'";
|
if (!string.IsNullOrEmpty(trueMemberId))
|
Condition += " and oss.MemberId = '" + trueMemberId + "'";
|
if (!string.IsNullOrEmpty(BusinessManager))
|
Condition += " and od.BusinessManagerId = '" + BusinessManager + "'";
|
if (!string.IsNullOrEmpty(CustormerName))
|
Condition += " and od.CompanyName like '%" + CustormerName + "%'";
|
if (!string.IsNullOrEmpty(wancheng))
|
{
|
if (wancheng == "1")
|
{
|
Condition += " and od.DeliveredTime is not null ";
|
}
|
else
|
{
|
Condition += " and od.DeliveredTime is null";
|
}
|
|
}
|
|
|
Query query = new Query();
|
IList<Criterion> criterias = new List<Criterion>()
|
{
|
new Criterion("", Condition),
|
|
new Criterion("orderBy",sort)
|
};
|
query.Criteria = criterias;
|
return _IOA_DeliverPlanPaicheDAL.SelectModelPage(query, pa);
|
}
|
|
|
|
|
|
|
|
/// <summary>
|
/// 查询合作客户分页列表
|
/// </summary>
|
/// <param name="pa"></param>
|
/// <returns></returns>
|
public IEnumerable<OA_DeliverPlan> SelectModelPageWenti(Pagination pa, Guid FirmId,
|
string DeliveredTimeStart, string DeliveredTimeEnd, string DriverId, string Zerenren , string CustormerName , string Wanjiestatus )
|
{
|
string Condition = " and od.FirmId ='" + FirmId + "' and od.DeliveredTime is not null and od.wentifankui is not null and od.wentifankui!='' "; // and od.shifouDelivery = 1
|
string sort = "DeliveredTime desc ";
|
|
|
if (!string.IsNullOrEmpty(DeliveredTimeStart))
|
{
|
Condition += " and DATEDIFF(day,'" + DeliveredTimeStart + "',od.[DeliveredTime]) >= 0 ";
|
}
|
|
if (!string.IsNullOrEmpty(DeliveredTimeEnd))
|
{
|
Condition += " and DATEDIFF(day,'" + DeliveredTimeEnd + "',od.[DeliveredTime]) <= 0 ";
|
}
|
|
if (!string.IsNullOrEmpty(DriverId))
|
Condition += " and od.DriverId = '" + DriverId + "'";
|
|
if (!string.IsNullOrEmpty(Zerenren))
|
Condition += " and od.Zerenren = '" + Zerenren + "'";
|
if (!string.IsNullOrEmpty(CustormerName))
|
Condition += " and od.CompanyName like '%" + CustormerName + "%'";
|
|
|
|
|
if (!string.IsNullOrEmpty(Wanjiestatus))
|
{
|
if (Wanjiestatus == "1")
|
{
|
Condition += " and od.Wanjiestatus = 1 ";
|
}
|
else
|
{
|
Condition += " and ( od.Wanjiestatus is null or od.Wanjiestatus = 0 )";
|
}
|
|
}
|
|
|
Query query = new Query();
|
IList<Criterion> criterias = new List<Criterion>()
|
{
|
new Criterion("", Condition),
|
|
new Criterion("orderBy",sort)
|
};
|
query.Criteria = criterias;
|
return _IOA_DeliverPlanPaicheDAL.SelectModelPageWenti(query, pa);
|
}
|
|
|
}
|
}
|
