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 CoreDeliverOrderBLL
|
{
|
ICoreDeliverOrderDAL _ICoreDeliverOrderDAL = null;
|
OA_StaffBLL staffBLL = null;
|
|
/// <summary>
|
/// 初始化构造
|
/// </summary>
|
public CoreDeliverOrderBLL()
|
{
|
//获取CoreDeliverOrder DAL实现
|
_ICoreDeliverOrderDAL = Factory.GetDALByInterfaceName(DALInterface.ICoreDeliverOrderDAL) as ICoreDeliverOrderDAL;
|
staffBLL = new OA_StaffBLL();
|
|
|
}
|
|
/// <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.CoreDeliverOrder m_CoreDeliverOrder)
|
{
|
try
|
{
|
|
return _ICoreDeliverOrderDAL.InserModel(m_CoreDeliverOrder);
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
}
|
|
/// <summary>
|
/// 新增送货安排
|
/// </summary>
|
/// <param name="rType"></param>
|
/// <param name="m_OA_CustomerCommunications"></param>
|
/// <param name="m_EC_AcceptWayByCustomers"></param>
|
/// <returns></returns>
|
public int InsertModelIden(CY.Model.CoreDeliverOrder m_CoreDeliverOrder)
|
{
|
try
|
{
|
|
return _ICoreDeliverOrderDAL.InsertModelIden(m_CoreDeliverOrder);
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
}
|
|
|
|
|
/// <summary>
|
/// 修改送货安排
|
/// </summary>
|
/// <param name="rType"></param>
|
/// <returns></returns>
|
public bool UpdateModel(CY.Model.CoreDeliverOrder m_CoreDeliverOrder)
|
{
|
try
|
{
|
return _ICoreDeliverOrderDAL.UpdateModel(m_CoreDeliverOrder);
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
}
|
|
|
|
|
|
|
/// <summary>
|
/// 获取全部合作客户
|
/// </summary>
|
/// <param name="Keyid">主键id</param>
|
/// <returns></returns>
|
public IEnumerable<CoreDeliverOrder> GetModelList()
|
{
|
Query query = new Query();
|
return _ICoreDeliverOrderDAL.SelectAllModel(query);
|
}
|
|
|
/// <summary>
|
/// 根据formid获得信息
|
/// </summary>
|
/// <param name="Keyid">编号</param>
|
/// <returns></returns>
|
public IEnumerable<Model.CoreDeliverOrder> GetModelByformid(Guid formid)
|
{
|
|
return _ICoreDeliverOrderDAL.GetModelByformid(formid);
|
}
|
|
|
/// <summary>
|
/// 根据formid获得信息
|
/// </summary>
|
/// <param name="Keyid">编号</param>
|
/// <returns></returns>
|
public IEnumerable<Model.CoreDeliverOrder> GetModelByorderid(int orderid)
|
{
|
|
return _ICoreDeliverOrderDAL.GetModelByorderid(orderid);
|
}
|
|
|
/// <summary>
|
/// 获取全部合作客户
|
/// </summary>
|
/// <param name="Keyid">主键id</param>
|
/// <returns></returns>
|
public CoreDeliverOrder GetModelByKeyid(string keyid)
|
{
|
|
return _ICoreDeliverOrderDAL.GetModelByKeyid(keyid);
|
}
|
|
/// <summary>
|
/// 删除合作客户
|
/// </summary>
|
/// <param name="rType"></param>
|
/// <returns></returns>
|
public bool DeleteModel(CY.Model.CoreDeliverOrder rType)
|
{
|
try
|
{
|
_ICoreDeliverOrderDAL.DeleteModel(rType);
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
return true;
|
}
|
|
/// <summary>
|
/// 查询合作客户分页列表
|
/// </summary>
|
/// <param name="pa"></param>
|
/// <returns></returns>
|
public IEnumerable<CoreDeliverOrder> SelectModelPage(Pagination pa, Guid FirmId, int? DriverId, string shipAddress,
|
string BuyerName, string createTimeStart, string createTimeEnd)
|
{
|
string Condition = " and b.FirmId ='" + FirmId + "' and a.OrderState = 0 ";
|
if (DriverId.HasValue)
|
{
|
var oA_Staff = staffBLL.GetModelByKeyid(DriverId);
|
Condition += " and ( a.DeliveryMoble = '" + oA_Staff.MobieNum + "' or a.DriverId = '" + DriverId + "' )";
|
}
|
|
if (!string.IsNullOrEmpty(shipAddress))
|
Condition += " and b.shipAddress = '" + shipAddress + "'";
|
|
if (!string.IsNullOrEmpty(BuyerName))
|
Condition += " and c.BuyerName like '%" + BuyerName + "%'";
|
|
|
if (!string.IsNullOrEmpty(createTimeStart))
|
Condition += " and DATEDIFF(day,a.[MakeTime],'" + createTimeStart + "')<=0 ";
|
|
if (!string.IsNullOrEmpty(createTimeEnd))
|
Condition += " and DATEDIFF(day,a.[MakeTime],'" + createTimeEnd + "')>=0 ";
|
|
|
|
Query query = new Query();
|
IList<Criterion> criterias = new List<Criterion>()
|
{
|
new Criterion("", Condition),
|
|
new Criterion("orderBy"," MakeTime desc ")
|
};
|
query.Criteria = criterias;
|
return _ICoreDeliverOrderDAL.SelectModelPage(query, pa);
|
}
|
|
|
|
/// <summary>
|
/// 查询合作客户分页列表
|
/// </summary>
|
/// <param name="pa"></param>
|
/// <returns></returns>
|
public IEnumerable<CoreDeliverOrder> SelectModelPageLishi(Pagination pa, Guid FirmId, int? DriverId, string shipAddress,
|
string BuyerName, string createTimeStart, string createTimeEnd,string OrderState,string shifou)
|
{
|
string Condition = " and b.FirmId ='" + FirmId + "' ";
|
|
if (!string.IsNullOrEmpty(OrderState))
|
{
|
Condition += " and a.OrderState = " + OrderState + " ";
|
}
|
else
|
{
|
if (!string.IsNullOrEmpty(shifou))
|
{
|
Condition += " and a.OrderState in( 0,1 ) ";
|
}
|
else
|
{
|
Condition += " and a.OrderState in( 0,1,2 ) ";
|
}
|
|
|
}
|
if (DriverId.HasValue)
|
{
|
var oA_Staff = staffBLL.GetModelByKeyid(DriverId);
|
Condition += " and ( a.DeliveryMoble = '" + oA_Staff.MobieNum + "' or a.DriverId = '" + DriverId + "' )";
|
}
|
|
if (!string.IsNullOrEmpty(shipAddress))
|
Condition += " and b.shipAddress = '" + shipAddress + "'";
|
|
if (!string.IsNullOrEmpty(BuyerName))
|
Condition += " and c.BuyerName like '%" + BuyerName + "%'";
|
|
|
if (!string.IsNullOrEmpty(createTimeStart))
|
Condition += " and DATEDIFF(day,a.[MakeTime],'" + createTimeStart + "')<=0 ";
|
|
if (!string.IsNullOrEmpty(createTimeEnd))
|
Condition += " and DATEDIFF(day,a.[MakeTime],'" + createTimeEnd + "')>=0 ";
|
|
|
|
Query query = new Query();
|
IList<Criterion> criterias = new List<Criterion>()
|
{
|
new Criterion("", Condition),
|
|
new Criterion("orderBy"," MakeTime desc ")
|
};
|
query.Criteria = criterias;
|
return _ICoreDeliverOrderDAL.SelectModelPage(query, pa);
|
}
|
|
|
}
|
}
|
