public List <Staff> GetStaffByCompanyId(int id) { List <Staff> m_Staff = DBStaff.GetStaffByCompanyId(id); return(m_Staff); }
public List <Staff> Pagination(int pageNum, string filter, int mode) { List <Staff> m_Staffs = DBStaff.Pagination(pageNum, mode, filter); return(m_Staffs); }
public int GetNumStaff(string filter, int mode) { int numStaff = DBStaff.GetNumStaff(filter, mode); return(numStaff); }
public Staff RetrieveOne(int id) { Staff m_Staff = DBStaff.RetrieveOne(id); return(m_Staff); }
public void DeleteStaff(int id) { DBStaff.DeleteStaff(id); }
public void EditStaff(Staff m_Staff) { DBStaff.UpdateStaff(m_Staff); }
public void AddStaff(Staff m_Staff) { DBStaff.AddStaff(m_Staff); }
// 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; } }