baseclass.cs

基于SQLSERVER C#2.0的企业ERP管理系统

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;

namespace HRP.BaseClass
{
    class BaseClass
    {
        SqlClass sqlclass = new SqlClass();
        /// <summary>
        /// 删除部门信息
        /// </summary>
        /// <param name="strDeptname">部门名称</param>
        public void SqlComDept(string strDeptname)
        {
            SqlConnection con =sqlclass.SqlConBind();
            con.Open();
            SqlCommand scd = new SqlCommand("delete from tb_dept where DeptName=@DeptName", con);
            SqlParameter para = new SqlParameter("@DeptName", SqlDbType.VarChar, 50);
            para.Value = strDeptname;
            scd.Parameters.Add(para);
            scd.ExecuteNonQuery();
            con.Close();
        }
        /// <summary>
        /// 添加部门信息
        /// </summary>
        /// <param name="strDeptName">部门名称</param>
        /// <param name="strDeptDirector">部门主管</param>
        /// <param name="strDeptTel">部门电话</param>
        /// <param name="strParentIndex">上级部门索引</param>
        public void SqlComDeptAdd(string strDeptName,string strDeptDirector,string strDeptTel,string strParentIndex)
        {
            SqlConnection con = sqlclass.SqlConBind();
            con.Open();
            SqlCommand scd = new SqlCommand("insert into tb_Dept (DeptName,DeptDirector,DeptTel,ParentIndex)values(@DeptName,@DeptDirector,@DeptTel,@ParentIndex)", con);
            SqlParameter para = new SqlParameter("@DeptName", SqlDbType.VarChar, 50);
            para.Value = strDeptName;
            scd.Parameters.Add(para);
            para = new SqlParameter("@DeptDirector", SqlDbType.VarChar, 50);
            para.Value = strDeptDirector;
            scd.Parameters.Add(para);
            para = new SqlParameter("@DeptTel", SqlDbType.VarChar, 50);
            para.Value = strDeptTel;
            scd.Parameters.Add(para);
            para = new SqlParameter("@ParentIndex", SqlDbType.VarChar, 50);
            para.Value = strParentIndex;
            scd.Parameters.Add(para);
            scd.ExecuteNonQuery();
            con.Close();
        }
        /// <summary>
        /// 修改部门信息
        /// </summary>
        /// <param name="strDeptName">部门名称</param>
        /// <param name="strDeptDirector">部门主管</param>
        /// <param name="strDeptTel">部门电话</param>
        /// <param name="strDeptID">部门ID</param>
        public void SqlComDeptEdit(string strDeptName, string strDeptDirector, string strDeptTel, string strDeptID)
        {
            SqlConnection con = sqlclass.SqlConBind();
            con.Open();
            SqlCommand scd = new SqlCommand("update tb_Dept set DeptName=@DeptName,DeptDirector=@DeptDirector,DeptTel=@DeptTel where DeptID=@DeptID", con);
            SqlParameter para = new SqlParameter("@DeptName", SqlDbType.VarChar, 50);
            para.Value = strDeptName;
            scd.Parameters.Add(para);
            para = new SqlParameter("@DeptDirector", SqlDbType.VarChar, 50);
            para.Value = strDeptDirector;
            scd.Parameters.Add(para);
            para = new SqlParameter("@DeptTel", SqlDbType.VarChar, 50);
            para.Value = strDeptTel;
            scd.Parameters.Add(para);
            para = new SqlParameter("@DeptID", SqlDbType.VarChar, 50);
            para.Value = strDeptID;
            scd.Parameters.Add(para);
            scd.ExecuteNonQuery();
            con.Close();
        }
        /// <summary>
        /// 判断部门名称是否重复
        /// </summary>
        /// <param name="strDeptName">部门名称</param>
        /// <param name="strType">操作类型</param>
        /// <returns>返回bool型</returns>
        public bool RepeatName(string strDeptName,string strType)
        {
            bool blRepeat;
            SqlConnection con = sqlclass.SqlConBind();
            con.Open();
            SqlCommand scd = new SqlCommand("select count(*) from tb_Dept where DeptName=@DeptName",con);
            SqlParameter para = new SqlParameter("@DeptName", SqlDbType.VarChar, 50);
            para.Value = strDeptName;
            scd.Parameters.Add(para);
            int intCount=Convert.ToInt32(scd.ExecuteScalar());
            if (intCount > 0)
            {
                if (strType == "edit" && intCount == 1)
                {
                    blRepeat = false;
                }
                else
                {
                    blRepeat = true;
                }
            }
            else
            {
                blRepeat = false;
            }
            con.Close();
            return blRepeat;
        }
        /// <summary>
        /// 判断部门是否有下级部门
        /// </summary>
        /// <param name="strDeptID">部门ID</param>
        /// <returns>返回bool型</returns>
        public bool InferiorDept(string strDeptID)
        {
            bool blRepeat;
            SqlConnection con = sqlclass.SqlConBind();
            con.Open();
            SqlCommand scd = new SqlCommand("select count(*) from tb_Dept where ParentIndex=@DeptID", con);
            SqlParameter para = new SqlParameter("@DeptID", SqlDbType.VarChar, 50);
            para.Value = strDeptID;
            scd.Parameters.Add(para);
            int intCount = Convert.ToInt32(scd.ExecuteScalar());
            if (intCount > 0)
            {
                blRepeat = true;
            }
            else
            {
                blRepeat = false;
            }
            con.Close();
            return blRepeat;
        }
        /// <summary>
        /// 添加基本信息
        /// </summary>
        /// <param name="strName">名称</param>
        /// <param name="strTable">表名</param>
        public void AddNew(string strName,string strTable)
        {
            SqlConnection con = sqlclass.SqlConBind();
            con.Open();
            SqlCommand scd = new SqlCommand("insert into " + strTable + " (Name)values(@Name)", con);
            SqlParameter para = new SqlParameter("@Name", SqlDbType.VarChar, 50);
            para.Value = strName;
            scd.Parameters.Add(para);
            scd.ExecuteNonQuery();
            con.Close();
        }
        /// <summary>
        /// 修改基本信息
        /// </summary>
        /// <param name="strName">名称</param>
        /// <param name="strTable">表名</param>
        /// <param name="strid">要修改名称的ID</param>
        public void Edit(string strName, string strTable, string strid)
        {
            SqlConnection con = sqlclass.SqlConBind();
            con.Open();
            SqlCommand scd = new SqlCommand("update " + strTable + " set Name=@Name where id=@strid", con);
            SqlParameter para = new SqlParameter("@Name", SqlDbType.VarChar, 50);
            para.Value = strName;
            scd.Parameters.Add(para);
            para = new SqlParameter("@strid", SqlDbType.VarChar, 50);
            para.Value = strid;
            scd.Parameters.Add(para);
            scd.ExecuteNonQuery();
            con.Close();
        }
        /// <summary>
        /// 删除基本信息
        /// </summary>
        /// <param name="strTable">表名</param>
        /// <param name="strid">名称ID</param>
        public void del(string strTable,string strid)
        {
            SqlConnection con = sqlclass.SqlConBind();
            con.Open();
            SqlCommand scd = new SqlCommand("delete from  " + strTable + " where id=@strid", con);
            SqlParameter para = new SqlParameter("@strid", SqlDbType.VarChar, 50);
            para.Value = strid;
            scd.Parameters.Add(para);
            scd.ExecuteNonQuery();
            con.Close();
        }
    }
}