departmentsbll.cs

CRM管理系统 CRM管理系统

//------------------------------------*/
//版权所有：杭州商易信息技术有限公司
//功能描述：企业部门管理
//    作者：沈伟
//    日期：2008/08/27
//------------------------------------*/
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

namespace Itsv.BLL.SystemManage
{
    /// <summary>
    /// 协会/部门表
    /// </summary>
   public class DepartmentsBLL
    {
       private static readonly Itsv.DAL.SystemManage.DepartmentsDAL dal = new Itsv.DAL.SystemManage.DepartmentsDAL();
       public DepartmentsBLL()
       { }
        #region 成员方法
       ///<summary>
       ///增加一条数据
       ///</summary>
       public bool Add(Itsv.Model.Departments model, ref string msg)
       {
           try
           {
               //if (dal.Exists(model.deparmentcode))
               //{
               //    msg = "单位编号已经存在" + model.deparmentcode;
               //    return false;
               //}
               msg = "创建单位成功";

               dal.Add(model);
               return true;
           }
           catch (Exception ex)
           {
               msg = "创建单位错误" + ex.Message.Replace("'", "");
               return false;
           }
       }
       ///<summary>
       /// 更新一条数据
       /// </summary>
       public bool Update(Itsv.Model.Departments model, ref string msg)
       {
           try
           {
               Itsv.Model.Departments dep = dal.GetModelByDepartmentcode(model.deparmentcode);
               if (dep != null)
               {
                   if (dep.dep_id != model.dep_id)
                   {
                       msg = "编号已经存在" + model.deparmentcode;
                       model = null;
                       dep = null;

                       return false;
                   }
               }

               dal.Update(model);
               return true;
           }
           catch (Exception ex)
           {
               msg = ex.Message.Replace("'", "");
               return false;

           }
       }
        /// <summary>
        /// 删除单位部门
        /// </summary>
        /// <param name="dep_id">单位主键</param>
        /// <param name="msg">返回消息</param>
        /// <returns>删除结果: 成功 True ,失败 false</returns>
        /// <remarks>
        /// 完成人: 
        /// 完成时间: 
        /// </remarks>
       public bool Delete(int dep_id, ref string msg)
       {
           try
           {
               //判断是否存在子
               string s = " ParentCode = (select deparmentcode from dbo.Departments where dep_id=" + dep_id + ")";
               if (dal.GetList(s).Tables[0].Rows.Count > 0)
               {
                   msg = "存在子项,请先删除子项";
                   return false;
               }
               dal.Delete(dep_id);
               return true;
           }
           catch (Exception ex)
           {
               msg = ex.Message.Replace("'", "");
               return false;

           }
       }

       /// <summary>
       /// 得到一个对象实体
       /// </summary>
       public Itsv.Model.Departments GetModel(int dep_id)
       {
           return dal.GetModel(dep_id);
       }

       /// <summary>
       /// 获得数据列表
       /// </summary>
       public DataSet GetList(string strWhere)
       {
           try
           {
               return dal.GetList(strWhere);
           }
           catch
           {
               return null;
           }
       }
       /// <summary>
       /// 
       /// </summary>
       public DataSet GetParentList(string departmentcode)
       {
           try
           {
               string s = " ParentCode = (select ParentCode from Departments where dep_id=" + departmentcode + ")";
               return dal.GetList(s);
           }
           catch
           {
               return null;
           }
       }

       /// <summary>
       /// 统计个人会员和企业会员
       /// </summary>
       public DataSet StatPeopleCount(ref string msg)
       {
           try
           {
               return dal.StatPeopleCount("");
           }
           catch (Exception ex)
           {
               msg = ex.Message;
               return null;
           }
       }

       /// <summary>
       /// 统计个人会员和企业会员
       /// </summary>
       public DataSet StatPeopleCount(string strWhere, ref string msg)
       {
           try
           {
               return dal.StatPeopleCount(strWhere);
           }
           catch (Exception ex)
           {
               msg = ex.Message;
               return null;
           }
       }  
        


 
       
       

        #endregion
    }
}