DAL/system/TCWL_D_Unit.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

namespace DAL.system
{
    using Common;
    using Model.system;
    using System;
    using System.Data;
    using System.Data.SqlClient;
    using System.Runtime.InteropServices;
    using System.Text;

    public class TCWL_D_Unit
    {
        public string Add(TCWL_Ｍ＿Ｕnit u)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("insert into TCWL_Unit (");
            builder.Append("unitName,unitMemon,parentID,serviceID)");
            builder.Append(" values (");
            builder.Append("@unitName,@unitMemon,@parentID,@serviceID)");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@unitName", SqlDbType.NVarChar, 50), new SqlParameter("@unitMemon", SqlDbType.NVarChar, 50), new SqlParameter("@parentID", SqlDbType.NVarChar, 0x24), new SqlParameter("@serviceID", SqlDbType.NVarChar, 0x24) };
            cmdParms[0].Value = u.unitName;
            cmdParms[1].Value = u.unitMemon;
            cmdParms[2].Value = u.parentID;
            cmdParms[3].Value = u.serviceID;
            if (DBHelper.ExecuteSql(builder.ToString(), cmdParms) > 0)
            {
                return "success";
            }
            return "error";
        }

        public string addUser(string userID, string departmentID, string userType)
        {
            string sqlString = string.Format("update TCWL_User set belongDeparment='{0}' ,header='{1}' where ID in ({2})", departmentID, userType, userID);
            try
            {
                DBHelper.ExecuteSQL(sqlString);
                return "success";
            }
            catch (Exception)
            {
                return "error";
            }
        }

        public string breakdep(string id)
        {
            try
            {
                DBHelper.ExecuteSQL(string.Format("update TCWL_User set belongDeparment='',personalRole='',header='0',personalUserID='' where ID ='{0}'", id));
                return "success";
            }
            catch (Exception)
            {
                return "error";
            }
        }

        public string del(string ID)
        {