C# (CSharp) DepartmentLanguages示例

示例#1

        public bool Insert(DepartmentLanguages departmentlanguages)
        {
            int autonumber = 0;
            DepartmentLanguagesDAC departmentlanguagesComponent = new DepartmentLanguagesDAC();
            bool endedSuccessfuly = departmentlanguagesComponent.InsertNewDepartmentLanguages(ref autonumber, departmentlanguages.DepartmentId, departmentlanguages.LanguageId, departmentlanguages.DepartmentName, departmentlanguages.DepartmentDescription, departmentlanguages.AddressLine1, departmentlanguages.AddressLine2);

            if (endedSuccessfuly)
            {
                departmentlanguages.DepartmentLanguagesId = autonumber;
            }
            return(endedSuccessfuly);
        }

示例#2

        public List <DepartmentLanguages> GetAll()
        {
            DepartmentLanguagesDAC     _departmentLanguagesComponent = new DepartmentLanguagesDAC();
            IDataReader                reader = _departmentLanguagesComponent.GetAllDepartmentLanguages().CreateDataReader();
            List <DepartmentLanguages> _departmentLanguagesList = new List <DepartmentLanguages>();

            while (reader.Read())
            {
                if (_departmentLanguagesList == null)
                {
                    _departmentLanguagesList = new List <DepartmentLanguages>();
                }
                DepartmentLanguages _departmentLanguages = new DepartmentLanguages();
                if (reader["DepartmentLanguagesId"] != DBNull.Value)
                {
                    _departmentLanguages.DepartmentLanguagesId = Convert.ToInt32(reader["DepartmentLanguagesId"]);
                }
                if (reader["DepartmentId"] != DBNull.Value)
                {
                    _departmentLanguages.DepartmentId = Convert.ToInt32(reader["DepartmentId"]);
                }
                if (reader["LanguageId"] != DBNull.Value)
                {
                    _departmentLanguages.LanguageId = Convert.ToInt32(reader["LanguageId"]);
                }
                if (reader["DepartmentName"] != DBNull.Value)
                {
                    _departmentLanguages.DepartmentName = Convert.ToString(reader["DepartmentName"]);
                }
                if (reader["DepartmentDescription"] != DBNull.Value)
                {
                    _departmentLanguages.DepartmentDescription = Convert.ToString(reader["DepartmentDescription"]);
                }
                if (reader["AddressLine1"] != DBNull.Value)
                {
                    _departmentLanguages.AddressLine1 = Convert.ToString(reader["AddressLine1"]);
                }
                if (reader["AddressLine2"] != DBNull.Value)
                {
                    _departmentLanguages.AddressLine2 = Convert.ToString(reader["AddressLine2"]);
                }
                _departmentLanguages.NewRecord = false;
                _departmentLanguagesList.Add(_departmentLanguages);
            }
            reader.Close();
            return(_departmentLanguagesList);
        }

示例#3

        public DepartmentLanguages GetByID(int _departmentLanguagesId)
        {
            DepartmentLanguagesDAC _departmentLanguagesComponent = new DepartmentLanguagesDAC();
            IDataReader            reader = _departmentLanguagesComponent.GetByIDDepartmentLanguages(_departmentLanguagesId);
            DepartmentLanguages    _departmentLanguages = null;

            while (reader.Read())
            {
                _departmentLanguages = new DepartmentLanguages();
                if (reader["DepartmentLanguagesId"] != DBNull.Value)
                {
                    _departmentLanguages.DepartmentLanguagesId = Convert.ToInt32(reader["DepartmentLanguagesId"]);
                }
                if (reader["DepartmentId"] != DBNull.Value)
                {
                    _departmentLanguages.DepartmentId = Convert.ToInt32(reader["DepartmentId"]);
                }
                if (reader["LanguageId"] != DBNull.Value)
                {
                    _departmentLanguages.LanguageId = Convert.ToInt32(reader["LanguageId"]);
                }
                if (reader["DepartmentName"] != DBNull.Value)
                {
                    _departmentLanguages.DepartmentName = Convert.ToString(reader["DepartmentName"]);
                }
                if (reader["DepartmentDescription"] != DBNull.Value)
                {
                    _departmentLanguages.DepartmentDescription = Convert.ToString(reader["DepartmentDescription"]);
                }
                if (reader["AddressLine1"] != DBNull.Value)
                {
                    _departmentLanguages.AddressLine1 = Convert.ToString(reader["AddressLine1"]);
                }
                if (reader["AddressLine2"] != DBNull.Value)
                {
                    _departmentLanguages.AddressLine2 = Convert.ToString(reader["AddressLine2"]);
                }
                _departmentLanguages.NewRecord = false;
            }
            reader.Close();
            return(_departmentLanguages);
        }

示例#4

        public bool Update(DepartmentLanguages departmentlanguages, int old_departmentLanguagesId)
        {
            DepartmentLanguagesDAC departmentlanguagesComponent = new DepartmentLanguagesDAC();

            return(departmentlanguagesComponent.UpdateDepartmentLanguages(departmentlanguages.DepartmentId, departmentlanguages.LanguageId, departmentlanguages.DepartmentName, departmentlanguages.DepartmentDescription, departmentlanguages.AddressLine1, departmentlanguages.AddressLine2, old_departmentLanguagesId));
        }