/** * 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); } } }