コード例 #1
0
        //Departemen
        //Site
        private MsDepartment[] GridDepartment()
        {
            dc = new DCAssetDataContext();
            List <MsDepartment> msdepartment = new List <MsDepartment>();

            try
            {
                var query = dc.MsDepartment_View("", "G");
                foreach (var res in query)
                {
                    MsDepartment department = new MsDepartment();

                    department.Id       = res.Id;
                    department.DeptCode = res.DeptCode;
                    department.DeptName = res.DeptName;

                    msdepartment.Add(department);
                }
            }
            catch
            {
                msdepartment = null;
            }
            return(msdepartment.ToArray());
        }
コード例 #2
0
        public MsDepartment[] GetDept()
        {
            List <MsDepartment> mDept = new List <MsDepartment>();

            dc = new DCAssetDataContext();
            try
            {
                var query = dc.MsDepartment_View("", "G");
                foreach (var res in query)
                {
                    MsDepartment dept = new MsDepartment();
                    dept.DeptCode = res.DeptCode;
                    dept.DeptName = res.DeptName;
                    mDept.Add(dept);
                }
            }
            catch (Exception ex)
            {
                ViewBag.Error = ex.Message;
            }
            return(mDept.ToArray());
        }