/**
* OA_ShejijijianBLL.cs
*
* 功 能: 合作客户业务逻辑类
* 类 名: OA_ShejijijianBLL
*
* 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_ShejijijianBLL
{
IOA_ShejijijianDAL _IOA_ShejijijianDAL = null;
///
/// 初始化构造
///
public OA_ShejijijianBLL()
{
//获取OA_Shejijijian DAL实现
_IOA_ShejijijianDAL = Factory.GetDALByInterfaceName(DALInterface.IOA_ShejijijianDAL) as IOA_ShejijijianDAL;
}
///
/// 新增送货安排
///
///
///
///
///
public bool InsertModel(CY.Model.OA_Shejijijian m_OA_Shejijijian)
{
try
{
return _IOA_ShejijijianDAL.InserModel(m_OA_Shejijijian);
}
catch (Exception ex)
{
throw ex;
}
}
///
/// 修改送货安排
///
///
///
public bool UpdateModel(CY.Model.OA_Shejijijian m_OA_Shejijijian)
{
try
{
return _IOA_ShejijijianDAL.UpdateModel(m_OA_Shejijijian);
}
catch (Exception ex)
{
throw ex;
}
}
///
/// 获取全部合作客户
///
/// 主键id
///
public IEnumerable GetModelList()
{
Query query = new Query();
return _IOA_ShejijijianDAL.SelectAllModel(query);
}
///
/// 根据formid获得信息
///
/// 编号
///
public IEnumerable GetModelByformid(Guid formid, string Dingdanleixing, string Fengmianneiye, string Shejileixing, int? Status)
{
return _IOA_ShejijijianDAL.GetModelByformid(formid, Dingdanleixing, Fengmianneiye, Shejileixing, Status);
}
///
/// 获取全部合作客户
///
/// 主键id
///
public OA_Shejijijian GetModelByKeyid(int keyid)
{
return _IOA_ShejijijianDAL.GetModelByKeyid(keyid);
}
///
/// 删除合作客户
///
///
///
public bool DeleteModel(CY.Model.OA_Shejijijian rType)
{
try
{
_IOA_ShejijijianDAL.DeleteModel(rType);
}
catch (Exception ex)
{
throw ex;
}
return true;
}
///
/// 查询合作客户分页列表
///
///
///
public IEnumerable SelectModelPage(Pagination pa, Guid FirmId, string CreateTimeStart, string CreateTimeEnd,
string Dingdanleixing, string Fengmianneiye, string Shejileixing, int? Status)
{
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(Dingdanleixing))
Condition += " and ok.Dingdanleixing = '" + Dingdanleixing + "'";
if (!string.IsNullOrEmpty(Fengmianneiye))
Condition += " and ok.Fengmianneiye = '" + Fengmianneiye + "' ";
if (!string.IsNullOrEmpty(Shejileixing))
Condition += " and ok.Shejileixing = '" + Shejileixing + "'";
if (Status.HasValue && Status > 0)
Condition += " and ok.[Status] = " + Status + "";
Query query = new Query();
IList criterias = new List()
{
new Criterion("", Condition),
new Criterion("orderBy"," CreateTime desc ")
};
query.Criteria = criterias;
return _IOA_ShejijijianDAL.SelectModelPage(query, pa);
}
///
/// 批量删除
///
///
///
///
public bool DelAllModel(string keyids, Guid Memberid)
{
return _IOA_ShejijijianDAL.DelAllModel(keyids, Memberid);
}
}
}