Esempio n. 1
0
        public void UpdateFunctionPowers(int DepartmentID, int AppinfoID, int[] functionPowerIDList)
        {
            if (functionPowerIDList == null)
            {
                functionPowerIDList = new int[0];
            }
            var oldFunctionPowers = GetPowers(DepartmentID, AppinfoID);

            int[] oldFunctionPowerIDList = oldFunctionPowers.Select(x => x.FunctionPowerID).ToArray();
            var   deleteFunctionPowers   = oldFunctionPowerIDList.Except(functionPowerIDList);
            var   insertFunctionPowers   = functionPowerIDList.Except(oldFunctionPowerIDList);

            _dbHelper.BeginTran();
            try
            {
                foreach (var deleteItem in deleteFunctionPowers)
                {
                    var functionPower
                        = oldFunctionPowers.Where(x => x.FunctionPowerID == deleteItem).First().ID;
                    _dbHelper.DeleteAsTran <DepartmentFunctionPower>(new DepartmentFunctionPower {
                        ID = functionPower
                    });
                }
                foreach (var insertItem in insertFunctionPowers)
                {
                    _dbHelper.InsertAsTran <DepartmentFunctionPower>(new DepartmentFunctionPower
                    {
                        DepartmentID = DepartmentID, FunctionPowerID = insertItem
                    });
                }
                _dbHelper.CommitTran();
            }
            catch (Exception ex)
            {
                _dbHelper.RollbackTran();
                throw ex;
            }
        }