Esempio n. 1
0
        /// <summary>
        /// 更新一条数据


        /// </summary>
        public bool Update(SCZM.Model.System.sys_Department model, out string message)
        {
            //----------------------------检查新上级是否为自己或子部门-------第一位是0 所以index最小是1---2018/3/19------------------
            if (model.SupList.IndexOf("," + model.ID + ",") > 0 ? false : true)
            {
                message = "修改成功!";
                //----------------------------检查Suplist是否变动-----------2018/3/19-----------------
                bool Result = dal.Exists(model.ID, model.SupList);
                //------------------------------------------------------------------------------------
                int rows = dal.Update(model);
                if (rows == 0)
                {
                    message = "对不起,该条数据已被其他人删除!";
                    return(false);
                }
                else
                {
                    //-----------------------针对变更后子部门上级列表无法随父部门变更的修复--2018/3/8---zhx------------------
                    //所需 ID:model.ID SupListNew:model.SupList
                    if (!Result)
                    {
                        dal.UpdateChildDepartment(model.ID, model.SupList);
                    }
                    //-------------------------------------------------------------------------------------------------------
                    SetDepartmentCache();
                    return(true);
                }
                //------------------------------------------------------------------------------------------------------------
            }
            else
            {
                message = "对不起,不能变更到当前下属单位内!";
                return(false);
            }
        }
Esempio n. 2
0
        /// <summary>
        /// 增加一条数据


        /// </summary>
        public int Add(SCZM.Model.System.sys_Department model, out string message)
        {
            message = "新增成功!";
            int rowId = dal.Add(model);

            if (rowId < 1)
            {
                message = "新增失败!";
            }
            SetDepartmentCache();
            return(rowId);
        }
Esempio n. 3
0
        /// <summary>
        /// 更新一条数据


        /// </summary>
        public int Update(SCZM.Model.System.sys_Department model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update sys_Department set ");
            strSql.Append("DepName=@DepName,");
            strSql.Append("LevelId=@LevelId,");
            strSql.Append("SupId=@SupId,");
            strSql.Append("SupList=@SupList,");
            strSql.Append("SortId=@SortId,");
            strSql.Append("DepTypeId=@DepTypeId,");
            strSql.Append("QDCode=@QDCode,");
            strSql.Append("DepTel=@DepTel,");
            strSql.Append("FlagUse=@FlagUse,");
            strSql.Append("FlagDel=@FlagDel,");
            strSql.Append("OperaName=@OperaName,");
            strSql.Append("OperaTime=@OperaTime");
            strSql.Append(" where FlagDel=0 and ID=@ID ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@DepName",   SqlDbType.NVarChar,  50),
                new SqlParameter("@LevelId",   SqlDbType.Int,        4),
                new SqlParameter("@SupId",     SqlDbType.Int,        4),
                new SqlParameter("@SupList",   SqlDbType.VarChar,   50),
                new SqlParameter("@SortId",    SqlDbType.Int,        4),
                new SqlParameter("@DepTypeId", SqlDbType.Int,        4),
                new SqlParameter("@QDCode",    SqlDbType.VarChar,   20),
                new SqlParameter("@DepTel",    SqlDbType.VarChar,   50),
                new SqlParameter("@FlagUse",   SqlDbType.Bit,        1),
                new SqlParameter("@FlagDel",   SqlDbType.Bit,        1),
                new SqlParameter("@OperaName", SqlDbType.NVarChar,  20),
                new SqlParameter("@OperaTime", SqlDbType.DateTime),
                new SqlParameter("@ID",        SqlDbType.Int, 4)
            };
            parameters[0].Value  = model.DepName;
            parameters[1].Value  = model.LevelId;
            parameters[2].Value  = model.SupId;
            parameters[3].Value  = model.SupList;
            parameters[4].Value  = model.SortId;
            parameters[5].Value  = model.DepTypeId;
            parameters[6].Value  = model.QDCode;
            parameters[7].Value  = model.DepTel;
            parameters[8].Value  = model.FlagUse;
            parameters[9].Value  = model.FlagDel;
            parameters[10].Value = model.OperaName;
            parameters[11].Value = model.OperaTime;
            parameters[12].Value = model.ID;


            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);

            return(rows);
        }
Esempio n. 4
0
        /// <summary>
        /// 增加一条数据


        /// </summary>
        public int Add(SCZM.Model.System.sys_Department model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into sys_Department(");
            strSql.Append("DepName,LevelId,SupId,SupList,SortId,DepTypeId,QDCode,DepTel,FlagUse,FlagDel,OperaName,OperaTime)");
            strSql.Append(" values (");
            strSql.Append("@DepName,@LevelId,@SupId,@SupList,@SortId,@DepTypeId,@QDCode,@DepTel,@FlagUse,@FlagDel,@OperaName,@OperaTime)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@DepName",   SqlDbType.NVarChar, 50),
                new SqlParameter("@LevelId",   SqlDbType.Int,       4),
                new SqlParameter("@SupId",     SqlDbType.Int,       4),
                new SqlParameter("@SupList",   SqlDbType.VarChar,  50),
                new SqlParameter("@SortId",    SqlDbType.Int,       4),
                new SqlParameter("@DepTypeId", SqlDbType.Int,       4),
                new SqlParameter("@QDCode",    SqlDbType.VarChar,  20),
                new SqlParameter("@DepTel",    SqlDbType.VarChar,  50),
                new SqlParameter("@FlagUse",   SqlDbType.Bit,       1),
                new SqlParameter("@FlagDel",   SqlDbType.Bit,       1),
                new SqlParameter("@OperaName", SqlDbType.NVarChar, 20),
                new SqlParameter("@OperaTime", SqlDbType.DateTime)
            };
            parameters[0].Value  = model.DepName;
            parameters[1].Value  = model.LevelId;
            parameters[2].Value  = model.SupId;
            parameters[3].Value  = model.SupList;
            parameters[4].Value  = model.SortId;
            parameters[5].Value  = model.DepTypeId;
            parameters[6].Value  = model.QDCode;
            parameters[7].Value  = model.DepTel;
            parameters[8].Value  = model.FlagUse;
            parameters[9].Value  = model.FlagDel;
            parameters[10].Value = model.OperaName;
            parameters[11].Value = model.OperaTime;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(1);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
Esempio n. 5
0
        /// <summary>
        /// 得到一个对象实体


        /// </summary>
        public SCZM.Model.System.sys_Department GetModel(int ID)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 ID,DepName,LevelId,SupId,SupList,SortId,DepTypeId,QDCode,DepTel,FlagUse,FlagDel,OperaName,OperaTime from sys_Department ");
            strSql.Append(" where FlagDel=0 and ID=@ID ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@ID", SqlDbType.Int, 4)
            };
            parameters[0].Value = ID;

            SCZM.Model.System.sys_Department model = new SCZM.Model.System.sys_Department();
            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
Esempio n. 6
0
        /// <summary>
        /// 得到一个对象实体 子方法 从DataRow中


        /// </summary>
        public SCZM.Model.System.sys_Department DataRowToModel(DataRow row)
        {
            SCZM.Model.System.sys_Department model = new SCZM.Model.System.sys_Department();
            if (row != null)
            {
                if (row["ID"] != null && row["ID"].ToString() != "")
                {
                    model.ID = int.Parse(row["ID"].ToString());
                }
                if (row["DepName"] != null)
                {
                    model.DepName = row["DepName"].ToString();
                }
                if (row["LevelId"] != null && row["LevelId"].ToString() != "")
                {
                    model.LevelId = int.Parse(row["LevelId"].ToString());
                }
                if (row["SupId"] != null && row["SupId"].ToString() != "")
                {
                    model.SupId = int.Parse(row["SupId"].ToString());
                }
                if (row["SupList"] != null)
                {
                    model.SupList = row["SupList"].ToString();
                }
                if (row["SortId"] != null && row["SortId"].ToString() != "")
                {
                    model.SortId = int.Parse(row["SortId"].ToString());
                }
                if (row["DepTypeId"] != null && row["DepTypeId"].ToString() != "")
                {
                    model.DepTypeId = int.Parse(row["DepTypeId"].ToString());
                }
                if (row["QDCode"] != null)
                {
                    model.QDCode = row["QDCode"].ToString();
                }
                if (row["DepTel"] != null)
                {
                    model.DepTel = row["DepTel"].ToString();
                }
                if (row["FlagUse"] != null && row["FlagUse"].ToString() != "")
                {
                    if ((row["FlagUse"].ToString() == "1") || (row["FlagUse"].ToString().ToLower() == "true"))
                    {
                        model.FlagUse = true;
                    }
                    else
                    {
                        model.FlagUse = false;
                    }
                }
                if (row["FlagDel"] != null && row["FlagDel"].ToString() != "")
                {
                    if ((row["FlagDel"].ToString() == "1") || (row["FlagDel"].ToString().ToLower() == "true"))
                    {
                        model.FlagDel = true;
                    }
                    else
                    {
                        model.FlagDel = false;
                    }
                }
                if (row["OperaName"] != null)
                {
                    model.OperaName = row["OperaName"].ToString();
                }
                if (row["OperaTime"] != null && row["OperaTime"].ToString() != "")
                {
                    model.OperaTime = DateTime.Parse(row["OperaTime"].ToString());
                }
            }
            return(model);
        }