コード例 #1
0
        public List <Staff> GetStaffByCompanyId(int id)
        {
            List <Staff> m_Staff = DBStaff.GetStaffByCompanyId(id);

            return(m_Staff);
        }
コード例 #2
0
        public List <Staff> Pagination(int pageNum, string filter, int mode)
        {
            List <Staff> m_Staffs = DBStaff.Pagination(pageNum, mode, filter);

            return(m_Staffs);
        }
コード例 #3
0
        public int GetNumStaff(string filter, int mode)
        {
            int numStaff = DBStaff.GetNumStaff(filter, mode);

            return(numStaff);
        }
コード例 #4
0
        public Staff RetrieveOne(int id)
        {
            Staff m_Staff = DBStaff.RetrieveOne(id);

            return(m_Staff);
        }
コード例 #5
0
 public void DeleteStaff(int id)
 {
     DBStaff.DeleteStaff(id);
 }
コード例 #6
0
 public void EditStaff(Staff m_Staff)
 {
     DBStaff.UpdateStaff(m_Staff);
 }
コード例 #7
0
 public void AddStaff(Staff m_Staff)
 {
     DBStaff.AddStaff(m_Staff);
 }
コード例 #8
0
    // Update is called once per frame
    void Update()
    {
        bool bInit = false;

        if (m_eStepPre != m_eStep)
        {
            m_eStepPre = m_eStep;
            bInit      = true;
        }

        switch (m_eStep)
        {
        case STEP.DB_SETUP:
            if (bInit)
            {
                m_dbItem          = new DBItem(Define.DB_TABLE_ASYNC_ITEM);
                m_dbItemMaster    = new DBItemMaster(Define.DB_TABLE_ASYNC_ITEM_MASTER);
                m_dbWork          = new DBWork(Define.DB_TABLE_ASYNC_WORK);
                m_dbMonster       = new DBMonster(Define.DB_TABLE_ASYNC_MONSTER);
                m_dbMonsterMaster = new DBMonsterMaster(Define.DB_TABLE_ASYNC_MONSTER_MASTER);
                m_dbStaff         = new DBStaff(Define.DB_TABLE_ASYNC_STAFF);
                if (m_dbKvs == null)
                {
                    m_dbKvs = new DBKvs(Define.DB_TABLE_ASYNC_KVS);
                }

                /*
                 * m_dbItem.Open (Define.DB_NAME_DOUBTSUEN, Define.DB_FILE_DIRECTORY, "");
                 * m_dbItemMaster.Open (Define.DB_NAME_DOUBTSUEN, Define.DB_FILE_DIRECTORY, "");
                 * m_dbWork.Open (Define.DB_NAME_DOUBTSUEN, Define.DB_FILE_DIRECTORY, "");
                 * m_dbMonster.Open (Define.DB_NAME_DOUBTSUEN, Define.DB_FILE_DIRECTORY, "");
                 * m_dbMonsterMaster.Open (Define.DB_NAME_DOUBTSUEN, Define.DB_FILE_DIRECTORY, "");
                 * m_dbStaff.Open (Define.DB_NAME_DOUBTSUEN, Define.DB_FILE_DIRECTORY, "");
                 * m_tkKvsOpen = m_dbKvs.Open (Define.DB_NAME_DOUBTSUEN, Define.DB_FILE_DIRECTORY, ""); // DEFINE.DB_PASSWORD
                 */
            }
            //if (m_tkKvsOpen.Completed) {
            if (true)
            {
                DataManager.itemMaster = m_dbItemMaster.SelectAll();

                m_header.Initialize();
                m_header.RefleshNum();
                m_collectGold.Initialize();
                m_fukidashiWork.Initialize();


                m_eStep = STEP.IDLE;
            }
            break;

        case STEP.IDLE:
            if (bInit)
            {
                m_fBackupInterval      = 10.0f;
                m_fBackupIntervalTimer = 0.0f;
            }

            /*
             * m_fBackupIntervalTimer += Time.deltaTime;
             * if (m_fBackupInterval < m_fBackupIntervalTimer) {
             *      m_fBackupIntervalTimer -= m_fBackupInterval;
             *
             *      m_eStep = STEP.BACKUP_CHECK;
             * }
             */
            if (TutorialManager.Instance.IsTutorial() == false && ReviewManager.Instance.IsReadyReview())
            {
                m_eStep = STEP.REVIEW;
            }
            break;

        case STEP.REVIEW:
            if (bInit)
            {
                GameObject obj = PrefabManager.Instance.MakeObject("prefab/CtrlReviewWindow", m_goPanelFront);
                m_reviewWindow = obj.GetComponent <CtrlReviewWindow> ();
                m_reviewWindow.Initialize();
            }
            if (m_reviewWindow.IsEnd())
            {
                Destroy(m_reviewWindow.gameObject);;
                m_eStep = STEP.IDLE;
            }
            break;

        case STEP.BACKUP_CHECK:
            if (bInit)
            {
                string sourceDB  = System.IO.Path.Combine(Application.persistentDataPath, Define.DB_NAME_DOUBTSUEN);
                string backup2DB = System.IO.Path.Combine(Application.persistentDataPath, Define.DB_NAME_DOUBTSUEN_BK2);
                System.IO.File.Copy(sourceDB, backup2DB, true);

                m_dbItemBackup  = new DBItem(Define.DB_NAME_DOUBTSUEN_BK2);
                m_tkBackupCheck = new ThreadQueue.TaskControl();
                m_tkBackupCheck = m_dbItemBackup.Open(Define.DB_NAME_DOUBTSUEN_BK2, Define.DB_FILE_DIRECTORY, "");
                //Debug.Log ("STEP.BACKUP_CHECK");
            }
            //Debug.Log ("frame");
            if (m_tkBackupCheck.Completed)
            {
                m_eStep = STEP.IDLE;
                try
                {
                    // DBおかしくなってたらここでThrowされる
                    List <DataItem> check = m_dbItemBackup.SelectAll();

                    //Debug.Log( "Copy" );
                    //string sourcePath = System.IO.Path.Combine (Application.streamingAssetsPath, Define.DB_FILE_DIRECTORY + Define.DB_NAME_DOUBTSUEN );
                    string backupDB  = System.IO.Path.Combine(Application.persistentDataPath, Define.DB_NAME_DOUBTSUEN_BK);
                    string backup2DB = System.IO.Path.Combine(Application.persistentDataPath, Define.DB_NAME_DOUBTSUEN_BK2);
                    if (System.IO.File.Exists(backup2DB))
                    {
                        System.IO.File.Copy(backup2DB, backupDB, true);
                    }
                }catch {
                    //Debug.LogError ("まずー");
                }
            }
            break;

        default:
            break;
        }
    }