Ejemplo n.º 1
0
        private void ShowMeDistributionReport()
        {
            ClearWorkSpace();
            tbTotalSum.Text = "";
            WindowMode      = (int)Mods.Distribution;
            cbProjectName.Items.Clear();
            cbProjectName.FontSize           = 16;
            dgReportDistribution.ItemsSource = null;
            //Отображение
            cStartDate.Visibility           = Visibility.Visible;
            cFinishDate.Visibility          = Visibility.Visible;
            dgReportDistribution.Visibility = Visibility.Visible;
            gDistributionSum.Visibility     = Visibility.Visible;
            //tbAlltime.Visibility = Visibility.Visible;
            cbAlltime.Visibility     = Visibility.Visible;
            cbProjectName.Visibility = Visibility.Visible;
            //OldSize = new Size(this.Width, this.Height);
            //this.MinWidth = 535;
            //this.Width = 535;
            //this.MinHeight = 435;
            //this.Height = 435;
            //комбобокс с именами акционеров
            lst.Clear();
            lst = DataWork.GetDistributionNamesForReport(ActiveUser.UserID);
            cbProjectName.Items.Add("Введите акционера");
            foreach (ComboBoxItem cbi in lst)
            {
                if ((!cbProjectName.Items.Contains(cbi.Content)) && (cbi.Content != ""))
                {
                    cbProjectName.Items.Add(cbi.Content);
                }
            }

            cbProjectName.SelectedIndex = 0;
        }
Ejemplo n.º 2
0
 private void NewSearch_combobox(object sender, SelectionChangedEventArgs e)
 {
     if (((ComboBox)sender).Text != "")
     {
         MainWindow main = this.Owner as MainWindow;
         //if (gSearch.IsVisible == true)
         //main.Search(str, lst);
         addlist();
         str = DataWork.GetRequestForSearch(lst, ActiveUser.UserID);
         if (str == "SELECT * FROM Transactions WHERE ORDER BY id_of_transaction DESC")
         {
             main.RefreshTable(null, null);
         }
         else
         {
             if (ActiveUser.UserType == 1)
             {
                 main.dgUser1.ItemsSource = DataWork.SearchFirstUser(str, lst);
             }
             else
             {
                 main.dgUser2.ItemsSource = DataWork.SearchFirstUser(str, lst);
             }
         }
     }
 }
Ejemplo n.º 3
0
 private void tbBank_PreviewLostKeyboardFocus(object sender, KeyboardFocusChangedEventArgs e)
 {
     if (tbBank.Text == "")
     {
         tbBank.Text = "Банк";
         MainWindow main = this.Owner as MainWindow;
         addlist();
         str = DataWork.GetRequestForSearch(lst, ActiveUser.UserID);
         //main.Search(str, lst);
         if (str == "SELECT * FROM Transactions WHERE ORDER BY id_of_transaction DESC")
         {
             main.RefreshTable(null, null);
         }
         else
         {
             if (ActiveUser.UserType == 1)
             {
                 main.dgUser1.ItemsSource = DataWork.SearchFirstUser(str, lst);
             }
             else
             {
                 main.dgUser2.ItemsSource = DataWork.SearchFirstUser(str, lst);
             }
         }
     }
 }
Ejemplo n.º 4
0
    private void Awake()
    {
        DataBaseMusic data = DataWork.LoadMusic();

        musicSlider.value   = data.musicVolume;
        effectsSlider.value = data.effectsVolume;
    }
Ejemplo n.º 5
0
        public void RefreshTable(object sender, EventArgs e)//сбивается поиск тут
        {
            /*if ((ActiveUser.wnAddMenu == null) && (ActiveUser.wnDistribution == null) &&
             *  (ActiveUser.wnDeleteTransaction == null) && (ActiveUser.wnSettings == null))
             * {
             *  this.IsEnabled = true;
             * }*/
            //if (!search_start)
            //{
            lStatusBar.Content = "Обновление таблиц...";
            switch (ActiveUser.UserType)
            {
            case 1:
                dgUser1.ItemsSource = DataWork.GetInfoUser1();
                break;

            case 2:
                dgUser2.ItemsSource = DataWork.GetInfoUser2(ActiveUser.UserID);
                break;

            case 3:
                dgUser2.ItemsSource = DataWork.GetInfoUser2(ActiveUser.UserID);
                break;

            case 22:
                dgUser2.ItemsSource = DataWork.GetInfoUser2(ActiveUser.UserID);
                break;
            }
            lStatusBar.Content = "Таблицы обновлены";
            //}
        }
Ejemplo n.º 6
0
    public DataWork MakeData(SQLiteQuery _qr)
    {
        DataWork data = new DataWork();

        if (m_bDebugLog)
        {
            //Debug.Log( "key  :" + strKey );
            //Debug.Log( "value:" + strValue );
        }
        data.work_id         = _qr.GetInteger("work_id");
        data.status          = _qr.GetInteger("status");
        data.title           = _qr.GetString("title");
        data.description     = _qr.GetString("description");
        data.type            = _qr.GetInteger("type");
        data.level           = _qr.GetInteger("level");
        data.appear_work_id  = _qr.GetInteger("appear_work_id");
        data.exp             = _qr.GetInteger("exp");
        data.difficulty      = _qr.GetString("difficulty");
        data.prize_ticket    = _qr.GetInteger("prize_ticket");
        data.prize_coin      = _qr.GetInteger("prize_coin");
        data.prize_monster   = _qr.GetInteger("prize_monster");
        data.mission_level   = _qr.GetInteger("mission_level");
        data.mission_monster = _qr.GetInteger("mission_monster");
        data.mission_staff   = _qr.GetInteger("mission_staff");
        data.mission_item    = _qr.GetInteger("mission_item");
        data.mission_collect = _qr.GetInteger("mission_collect");
        data.mission_tweet   = _qr.GetInteger("mission_tweet");
        data.mission_login   = _qr.GetInteger("mission_login");
        data.mission_num     = _qr.GetInteger("mission_num");

        return(data);
    }
Ejemplo n.º 7
0
        private void LogOut(object sender, RoutedEventArgs e)
        {
            DataWork.CheckOut(ActiveUser.login, ActiveUser.password);
            Window w = new UserLogin();

            w.Show();
            this.Close();
        }
Ejemplo n.º 8
0
 private void ClearDB(object sender, RoutedEventArgs e)
 {
     if (pbPass.Password == ActiveUser.password)
     {
         DataWork.DELETE_DB();
         gDeleteDB.Visibility = System.Windows.Visibility.Collapsed;
     }
 }
Ejemplo n.º 9
0
 private void Window_Activated(object sender, EventArgs e)
 {
     dgUsers.ItemsSource = DataWork.FillUsersTable();
     if (ActiveUser.wnAdminUsers == null)
     {
         this.IsEnabled = true;
     }
 }
Ejemplo n.º 10
0
 private void Awake()
 {
     if (itLevelCheker)
     {
         DataBaseLevel data = DataWork.LoadLevel();
         levelProgress = data.levelProgress;
     }
 }
Ejemplo n.º 11
0
        /* private void CancelAdd(object sender, RoutedEventArgs e)
         * {
         *   this.Close();
         * } */

        private void U1_ChangeInfo(object sender, SelectionChangedEventArgs e)
        {
            if (cbIDu1.SelectedIndex != -1)
            {
                if (ActiveUser.UserType == 1)
                {
                    //string str = cbIDu1.SelectedItem.ToString().Remove(0, 38);
                    List <string> lst = DataWork.GetCollection(Convert.ToInt32(cbIDu1.SelectedItem.ToString().Remove(0, 38)));
                    tbProjectName.Text = lst[0];
                    projectName        = lst[0];
                    cDate.SelectedDate = Convert.ToDateTime(lst[1]);
                    tbSum.Text         = lst[2];
                    if (lst[3] == "UAH")
                    {
                        cbCurrency.SelectedIndex = 0;
                    }
                    else
                    if (lst[3] == "USD")
                    {
                        cbCurrency.SelectedIndex = 1;
                    }
                    else
                    {
                        cbCurrency.SelectedIndex = 2;
                    }
                    tbMarks.Text = lst[4];
                    tbNotes.Text = lst[5];
                }
                else
                {
                    List <string> lst = DataWork.GetCollection(Convert.ToInt32(cbIDu1.SelectedItem.ToString().Remove(0, 38)));
                    tbSum.Text         = lst[2];
                    tbProjectName.Text = lst[0];
                    projectName        = lst[0];
                    cDate.SelectedDate = Convert.ToDateTime(lst[1]);
                    if (lst[3] == "UAH")
                    {
                        cbCurrency.SelectedIndex = 0;
                    }
                    else
                    if (lst[3] == "USD")
                    {
                        cbCurrency.SelectedIndex = 1;
                    }
                    else
                    {
                        cbCurrency.SelectedIndex = 2;
                    }
                    tbMarks.Text       = lst[4];
                    tbNotes.Text       = lst[5];
                    tbRKO.Text         = lst[6];
                    tbRates.Text       = lst[7];
                    tbReceiver.Text    = lst[8];
                    tbWhoReceived.Text = lst[9];
                    tbBank.Text        = lst[10];
                }
            }
        }
Ejemplo n.º 12
0
    // please check BannerBase

    public void Initialize(DataWork _data)
    {
        m_buttonBase = GetComponent <ButtonBase> ();
        Debug.Log(m_buttonBase);
        m_eStep    = STEP.IDLE;
        m_eStepPre = STEP.MAX;

        // 一旦消しておく
        m_sprNew.enabled = false;

        string strHeader = "";

        if (PlayerPrefs.HasKey(Define.GetWorkNewKey(_data.work_id)))
        {
            if (PlayerPrefs.GetInt(Define.GetWorkNewKey(_data.work_id)) == 0)
            {
            }
            else
            {
                strHeader        = string.Format("[FF0000]NEW[-]");
                m_sprNew.enabled = true;
                PlayerPrefs.SetInt(Define.GetWorkNewKey(_data.work_id), 0);
            }
        }
        // Newはテキストから画像に変更
        strHeader       = "";
        m_lbTitle.text  = string.Format("{0}{1}", strHeader, _data.title);
        m_lbTitle2.text = m_lbTitle.text;

        m_lbDescription.text = _data.description;
        if (0 < _data.prize_ticket)
        {
            m_lbPrize.text = "チケット" + _data.prize_ticket.ToString() + "枚";
        }
        else
        {
            m_lbPrize.text = _data.prize_coin.ToString() + "G";
        }
        m_lbPrizeExp.text   = _data.exp.ToString();
        m_lbDifficulty.text = _data.difficulty;

        if (_data.status == (int)Define.Work.STATUS.CLEARD)
        {
            m_goFinished.SetActive(true);
        }
        else
        {
            m_goFinished.SetActive(false);
        }

        m_dataWork = _data;
        string  strIcon = GetSpriteName(_data);
        UIAtlas atlas   = AtlasManager.Instance.GetAtlas(strIcon);

        m_sprIcon.atlas      = atlas;
        m_sprIcon.spriteName = strIcon;
        return;
    }
Ejemplo n.º 13
0
        private void ShowMeBriefReport()
        {
            ClearWorkSpace();
            tbTotalMinus.Text = "";
            tbTotalPlus.Text  = "";
            tbTotalShort.Text = "";
            dgDistributionPercents.ItemsSource = null;
            dgPlus.ItemsSource  = null;
            dgMinus.ItemsSource = null;
            WindowMode          = (int)Mods.Brief;
            //cbProjectName.FontSize = 19;
            //Подготовка среды

            lst.Clear();
            cbProjectName.Items.Clear();
            //ComboBoxItem tmp = new ComboBoxItem();
            //tmp.Content = "Введите проект";
            cbProjectName.Items.Insert(0, "Введите проект");

            if (ActiveUser.UserType == 4)
            {
                lst = DataWork.GetCollection("project_name_user4");
            }
            else
            {
                lst = DataWork.GetCollection("name_of_project");
            }
            //lst.Insert(0, tmp);
            foreach (ComboBoxItem cbi in lst)
            {
                cbProjectName.Items.Add(cbi);
            }

            cbProjectName.SelectedIndex = 0;

            //Отображение
            cbMarks_Report.Visibility    = Visibility.Visible;
            cbCurrency_Report.Visibility = Visibility.Visible;
            gBriefReport.Visibility      = Visibility.Visible;
            cStartDate.Visibility        = Visibility.Visible;
            cFinishDate.Visibility       = Visibility.Visible;
            cbProjectName.Visibility     = Visibility.Visible;
            cbAlltime.Visibility         = Visibility.Visible;

            if ((ActiveUser.UserType == 1) || (ActiveUser.UserType == 22))
            {
                dgDistributionPercents.Visibility = Visibility.Hidden;
            }

            else
            {
                Thickness marginThickness = gSum.Margin;
                gSum.Width = 371;
                gSum.HorizontalAlignment = HorizontalAlignment.Right;
                marginThickness.Right    = 10;
                marginThickness.Bottom   = 0;
            }
        }
Ejemplo n.º 14
0
        void AddID(ComboBox cb)
        {
            cbIDu1.Items.Clear();
            List <ComboBoxItem> tmp = DataWork.GetIdCollection(ActiveUser.UserID);

            foreach (ComboBoxItem cbi in tmp)
            {
                cb.Items.Add(cbi);
            }
        }
Ejemplo n.º 15
0
        void Update()
        {
            cbID.Items.Clear();
            List <ComboBoxItem> lst = DataWork.GetIdCollection(ActiveUser.UserID);

            foreach (ComboBoxItem cbi in lst)
            {
                cbID.Items.Add(cbi);
            }
        }
Ejemplo n.º 16
0
        private void ShowMeMainWindow()
        {
            ClearWorkSpace();
            WindowMode = (int)Mods.Main;
            //отобразить нужные элементы
            //bSearch.Visibility = Visibility.Visible;
            //bAdd.Visibility = Visibility.Visible;
            //bDelete.Visibility = Visibility.Visible;
            switch (ActiveUser.UserType)
            {
            case 1:
                //добавить, настройки пользователя, выход, обновить, поиск.
                bDReport.Visibility = Visibility.Collapsed;
                //bDelete.Visibility = Visibility.Collapsed;
                dgUser1.Visibility           = Visibility.Visible;
                dgUser1.ItemsSource          = DataWork.GetInfoUser1();
                Distribution_menu.Visibility = Visibility.Collapsed;
                break;

            case 2:
                dgUser2.Visibility  = Visibility.Visible;
                dgUser2.ItemsSource = DataWork.GetInfoUser2(ActiveUser.UserID);
                //все кнопки на панели(добавить, удалить, поиск, обновить, настройки пользователя, выход, оба отчета, печать) В окне "настройки пользователя" отсутствует кнопка "к настройкам администратора"
                break;

            case 3:
                dgUser2.Visibility       = Visibility.Visible;
                dgUser2.ItemsSource      = DataWork.GetInfoUser2(ActiveUser.UserID);
                AdminSettings.Visibility = Visibility.Visible;
                break;

            case 4:
                ShowMeBriefReport();
                bReport.Background = SystemColors.ControlLightLightBrush;
                //bAdd.Visibility = Visibility.Collapsed;
                bMain.Visibility = Visibility.Collapsed;
                bReport.Margin   = new Thickness(83, 0, 0, 0);
                bDReport.Margin  = new Thickness(203, 0, 0, 0);
                //bDelete.Visibility = Visibility.Collapsed;
                //bSearch.Visibility = Visibility.Collapsed;
                Distribution_menu.Visibility = Visibility.Collapsed;
                Transaction.Visibility       = Visibility.Collapsed;
                //оба отчета, обновить, печать, настройки пользователя, выход
                break;

            case 22:
                //Projects.Visibility = Visibility.Visible;
                bDReport.Visibility          = Visibility.Collapsed;
                bDReport.IsEnabled           = false;
                dgUser2.Visibility           = Visibility.Visible;
                dgUser2.ItemsSource          = DataWork.GetInfoUser2(ActiveUser.UserID);
                Distribution_menu.Visibility = Visibility.Collapsed;
                break;
            }
        }
Ejemplo n.º 17
0
    void Awake()
    {
        _source = GetComponent <AudioSource>();
        DataBaseMusic data = DataWork.LoadMusic();

        _source.volume = data.musicVolume;
        if (main)
        {
            DontDestroyOnLoad(this.gameObject);
        }
    }
Ejemplo n.º 18
0
        void update_comboboxes(int type)
        {
            if (type != 1)
            {
                List <ComboBoxItem> lst1 = new List <ComboBoxItem>();
                lst1.Clear();
                cbReceiver.Items.Clear();
                lst1 = DataWork.GetCollection("receiver");
                //var sortedList = lst1.OrderBy(x => x);
                foreach (ComboBoxItem cbi in lst1)
                {
                    if (!cbReceiver.Items.Contains(cbi.Content) & cbi.Content.ToString() != "")
                    {
                        cbReceiver.Items.Add(cbi.Content);
                    }
                }


                /* cbReceiver.Items.SortDescriptions.Add(
                 * new SortDescription("Content", ListSortDirection.Ascending));*/
                cbReceiver.Items.Add("Новый");

                tbReceiver.Visibility = Visibility.Hidden;
                List <ComboBoxItem> lst2 = new List <ComboBoxItem>();
                lst2.Clear();
                сbWhoReceived.Items.Clear();
                lst2 = DataWork.GetCollection("who_received");

                foreach (ComboBoxItem cbi in lst2)
                {
                    if (!сbWhoReceived.Items.Contains(cbi.Content) & cbi.Content.ToString() != "")
                    {
                        сbWhoReceived.Items.Add(cbi.Content);
                    }
                }

                /*сbWhoReceived.Items.SortDescriptions.Add(
                 * new SortDescription("Items", ListSortDirection.Ascending));
                 * lst2.Sort();*/
                сbWhoReceived.Items.Add("Новый");
            }

            List <ComboBoxItem> lst = new List <ComboBoxItem>();

            lst.Clear();
            cbProjectName.Items.Clear();
            lst = DataWork.GetCollection("name_of_project");
            foreach (ComboBoxItem cbi in lst)
            {
                cbProjectName.Items.Add(cbi);
            }

            //lst.Sort();
        }
Ejemplo n.º 19
0
        public AddMenu(int user_atr)
        {
            InitializeComponent();
            ActiveUser.wnAddMenu = this;
            projectName          = "";
            cDate.SelectedDate   = DateTime.Today;
            AddID(cbIDu1);
            tbID.Text = DataWork.GetNexID("id_of_transaction").ToString();
            update_comboboxes(ActiveUser.UserType);
            tbID.IsReadOnly = true;
            if (user_atr == 1)
            {
                scrvAdd.VerticalScrollBarVisibility = ScrollBarVisibility.Disabled;
                this.Height = 370;
            }
            else
            {
                Show_second_user();
            }

            //Заполнение Controls
            tbID.PreviewKeyDown          += MoveBetweenControls;
            cbProjectName.PreviewKeyDown += MoveBetweenControls;
            cDate.PreviewKeyDown         += MoveBetweenControls;
            tbSum.PreviewKeyDown         += MoveBetweenControls;
            cbCurrency.PreviewKeyDown    += MoveBetweenControls;
            tbMarks.PreviewKeyDown       += MoveBetweenControls;
            tbNotes.PreviewKeyDown       += MoveBetweenControls;
            tbRates.PreviewKeyDown       += MoveBetweenControls;
            tbRKO.PreviewKeyDown         += MoveBetweenControls;
            cbReceiver.PreviewKeyDown    += MoveBetweenControls;
            сbWhoReceived.PreviewKeyDown += MoveBetweenControls;
            tbBank.PreviewKeyDown        += MoveBetweenControls;
            //end Controls
            Controls.Add(tbID);
            Controls.Add(cbProjectName);
            Controls.Add(cDate);
            Controls.Add(tbSum);
            Controls.Add(cbCurrency);
            Controls.Add(tbMarks);
            Controls.Add(tbNotes);
            if (ActiveUser.UserType != 1)
            {
                Controls.Add(tbRates);
                Controls.Add(tbRKO);
            }
            Controls.Add(cbReceiver);
            Controls.Add(сbWhoReceived);
            if (ActiveUser.UserType != 1)
            {
                Controls.Add(tbBank);
            }
        }
Ejemplo n.º 20
0
    // ミッションをクリア状態にして、他のミッションが開放されないか確認する
    public void MissionClear()
    {
        //Debug.LogError (string.Format( "mission clear work_id:{0}", work_id));
        //string strNow = TimeManager.StrNow ();
        Dictionary <string, string> dict = new Dictionary <string, string> ();

        dict.Add("status", ((int)Define.Work.STATUS.CLEARD).ToString());
        GameMain.dbWork.Update(work_id, dict);

        // ふういんされているモンスターを解き放つ
        List <DataMonsterMaster> list_monster = GameMain.dbMonsterMaster.Select(string.Format(" status = 0 and open_work_id = {0} ", work_id));

        foreach (DataMonsterMaster data_monster_master in list_monster)
        {
            Dictionary <string, string> monster_master_dict = new Dictionary <string, string> ();
            monster_master_dict.Add("status", "1");
            GameMain.dbMonsterMaster.Update(data_monster_master.monster_id, monster_master_dict);
        }


        GameMain.Instance.AddFukidashi(work_id, title + " を[FF0000]達成![-]");

        if (0 < prize_coin)
        {
            DataManager.user.AddGold(prize_coin);
        }
        if (0 < prize_ticket)
        {
            DataManager.user.AddTicket(prize_ticket);
        }
        if (0 < prize_monster)
        {
            GameMain.dbMonster.Insert(prize_monster, 0);
        }

        // お仕事の開放は絞られた仕事idと、レベルによって開放されます。
        // 先に仕事idの制限を切って,レベルでの制限に引っかかってないか確認する

        // この完了した仕事につられて起きる仕事
        List <DataWork>             list_work   = GameMain.dbWork.Select(" status = 0 and appear_work_id = " + work_id.ToString() + " ");
        Dictionary <string, string> dict_appear = new Dictionary <string, string> ();

        dict_appear.Add("appear_work_id", "0");
        foreach (DataWork appear_work in list_work)
        {
            GameMain.dbWork.Update(appear_work.work_id, dict_appear);
        }

        DataWork.WorkOpen();

        return;
    }
Ejemplo n.º 21
0
    private void Start()
    {
        source = GetComponent <AudioSource>();
        DataBaseMusic data = DataWork.LoadMusic();

        source.volume = data.musicVolume;
        GameEngine.Engine.soundEffectVolume = data.effectsVolume;

        if (GameObject.Find("MusicBox") != null)
        {
            Destroy(GameObject.Find("MusicBox"));
        }
    }
Ejemplo n.º 22
0
    static public void WorkCheck()
    {
        List <DataWork> check_work_list = GameMain.dbWork.Select(string.Format(" status = {0} ", (int)Define.Work.STATUS.APPEAR));

        foreach (DataWork work in check_work_list)
        {
            if (work.ClearCheck())
            {
                work.MissionClear();
            }
        }
        DataWork.WorkOpen();
    }
Ejemplo n.º 23
0
        private void Delete(object sender, RoutedEventArgs e)
        {
            if (cbID.SelectedIndex > -1)
            {
                string str = cbID.SelectedItem.ToString().Remove(0, 38);
                DataWork.Delete(Convert.ToInt32(str), "Transactions");
                Update();
                this.Close();
            }

            /*else
             * {
             *  Window wn = new wnError("Не все поля были заполнены", this);
             *  wn.ShowDialog();
             *  //ActiveUser.wnError= wn;
             *  //this.IsEnabled=false;
             *  //ActiveUser.wnError = wn;
             * }*/
        }
Ejemplo n.º 24
0
 private void NewSearch(object sender, TextChangedEventArgs e) //несколько раз запускается
 {
     if (((TextBox)sender).Text != "Проект" & ((TextBox)sender).Text != "На кого получено" & ((TextBox)sender).Text != "Получатель" & ((TextBox)sender).Text != "Банк" & ((TextBox)sender).Text != "")
     {
         MainWindow main = this.Owner as MainWindow;
         addlist();
         str = DataWork.GetRequestForSearch(lst, ActiveUser.UserID);
         //main.Search(str, lst);
         if (ActiveUser.UserType == 1)
         {
             main.dgUser1.ItemsSource = DataWork.SearchFirstUser(str, lst);
         }
         else
         {
             main.dgUser2.ItemsSource = DataWork.SearchFirstUser(str, lst);
         }
         //lst.Clear();
     }
 }
Ejemplo n.º 25
0
    //DBへ保存
    public void Replace(DataWork _replocalData)
    {
        m_soDataWork.list.Add(_replocalData);
        return;

        /*
         * //データの上書きのコマンドを設定する 
         * string strQuery = "replace into " + TABLE_NAME + " (work_id, status, title, description, type, level, appear_work_id, exp, difficulty, prize_ticket, prize_coin, prize_monster, mission_level, mission_monster, mission_staff, mission_item, mission_collect, mission_tweet, mission_login, mission_num) values( '" +
         *                _replocalData.work_id.ToString () + "','" +
         *                _replocalData.status.ToString () + "',\"" +
         *                _replocalData.title.ToString () + "\",\"" +
         *                _replocalData.description.ToString () + "\",'" +
         *                _replocalData.type.ToString () + "','" +
         *                _replocalData.level.ToString () + "','" +
         *                _replocalData.appear_work_id.ToString () + "','" +
         *                _replocalData.exp.ToString () + "','" +
         *                _replocalData.difficulty.ToString () + "','" +
         *                _replocalData.prize_ticket.ToString () + "','" +
         *                _replocalData.prize_coin.ToString () + "','" +
         *                _replocalData.prize_monster.ToString () + "','" +
         *                _replocalData.mission_level.ToString () + "','" +
         *                _replocalData.mission_monster.ToString () + "','" +
         *                _replocalData.mission_staff.ToString () + "','" +
         *                _replocalData.mission_item.ToString () + "','" +
         *                _replocalData.mission_collect.ToString () + "','" +
         *                _replocalData.mission_tweet.ToString () + "','" +
         *                _replocalData.mission_login.ToString () + "','" +
         *                _replocalData.mission_num.ToString () + "');";
         *
         * Debug.Log( "DBPark:"+strQuery);
         *
         * //m_sqlDBはDBDataBaseのプロテクト変数
         * SQLiteQuery query = new SQLiteQuery(m_sqlDB,strQuery);
         *
         * query.Step ();      //
         * query.Release ();   //解放
         */
    }
Ejemplo n.º 26
0
        private void Login(object sender, RoutedEventArgs args)
        {
            //here login
            try
            {
                //DataWork._ConnectionString = ConfigurationManager.ConnectionStrings
                //["AdamDbCon"].ConnectionString;
                DataWork._ConnectionString = "Data Source=10.111.0.101\\SQLEXPRESS;Initial Catalog=AdamDB;Persist Security Info=True;User ID=AdminNew;Password=ddaedeqq";
                int type = DataWork.GetUsersType(tbLogin.Text, tbPassword.Password);
                if (type == 0)
                {
                    throw new Exception("Логин/пароль не совпадают");
                }
                if (type == -1)
                {
                    throw new Exception("Нет соединения. Запустите Kerio VPN Client и выполните подключение к серверу. Затем, попробуйте снова.");
                }
                if (!DataWork.If_checked(tbLogin.Text, tbPassword.Password))
                {
                    ActiveUser.dt_log.Start();
                    DataWork.CheckIn(tbLogin.Text, tbPassword.Password);
                    ActiveUser.login    = tbLogin.Text;
                    ActiveUser.password = tbPassword.Password;
                    ActiveUser.UserType = type;

                    Window wn = new MainWindow(type);
                    wn.Show();
                    this.Close();
                }
            }
            catch (Exception e)
            {
                Window wn = new wnError(e.Message, 1);
                wn.ShowDialog();
            }
        }
Ejemplo n.º 27
0
    // Update is called once per frame
    void Update()
    {
        //m_fTimer += Time.deltaTime;
        if (10.0f < m_fTimer)
        {
            m_bIsEnd = true;
        }

        if (m_buttonYesNo.IsYes())
        {
            m_bIsEnd = true;
            DataStaff staff;
            int       iStaffCost = 0;
            if (0 < m_iSetStaffSerial)
            {
                //GameMain.dbStaff.Update(
                Debug.Log(string.Format("set staff from backyard:{0}", m_iSetStaffSerial));
                string strNow = TimeManager.StrNow();
                Dictionary <string, string> dict = new Dictionary <string, string> ();
                dict.Add("office_serial", m_dataOffice.item_serial.ToString());
                dict.Add("item_serial", m_dispOffice.SelectingCageSerial.ToString());
                dict.Add("setting_time", "\"" + strNow + "\"");
                staff = GameMain.dbStaff.Update(m_iSetStaffSerial, dict);

                CsvStaffData staff_data = DataManager.GetStaff(m_iSetStaffId);
                iStaffCost = staff_data.coin;
            }
            else
            {
                staff = GameMain.dbStaff.Insert(m_iSetStaffId, m_dataOffice.item_serial, m_dispOffice.SelectingCageSerial);

                CsvStaffData staff_data = DataManager.GetStaff(m_iSetStaffId);
                if (0 < staff_data.coin)
                {
                    DataManager.user.AddGold(-1 * staff_data.coin);
                }
                else if (0 < staff_data.ticket)
                {
                    DataManager.user.AddTicket(-1 * staff_data.ticket);
                }
                else
                {
                    ;                    // エラーちゃう?
                }
                iStaffCost = staff_data.cost;
            }

            CtrlFieldItem fielditem = GameMain.ParkRoot.GetFieldItem(m_dispOffice.SelectingCageSerial);
            GameObject    objIcon   = PrefabManager.Instance.MakeObject("prefab/PrefIcon", fielditem.gameObject);
            CtrlIconRoot  iconRoot  = objIcon.GetComponent <CtrlIconRoot> ();
            iconRoot.Initialize(staff, fielditem);
            fielditem.Add(iconRoot);

            // 仕事の確認
            DataWork.WorkCheck();
            GameMain.Instance.HeaderRefresh();
            GameMain.ListRefresh = true;

            GameMain.Instance.m_iCostNokori -= iStaffCost;
        }
        else if (m_buttonYesNo.IsNo())
        {
            m_bIsEnd = true;
        }
        else
        {
            ;            //
        }

        m_iSelectingCageSerial = m_dispOffice.SelectingCageSerial;

        if (m_iSelectingCageSerialPre != m_iSelectingCageSerial)
        {
            if (0 < m_iSelectingCageSerialPre)
            {
                CtrlFieldItem script = GameMain.ParkRoot.GetFieldItem(m_iSelectingCageSerialPre);
                script.SetColor(Color.white);
            }
            if (0 < m_iSelectingCageSerial)
            {
                m_buttonYesNo.EnableButtonYes(true);

                CtrlFieldItem script = GameMain.ParkRoot.GetFieldItem(m_iSelectingCageSerial);
                script.SetColor(Color.red);
                m_iSelectingCageSerialPre = m_iSelectingCageSerial;
            }
        }
    }
Ejemplo n.º 28
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.IDLE:
            if (bInit)
            {
                m_buttonBase.TriggerClear();
            }
            if (m_buttonBase.ButtonPushed)
            {
                m_buttonBase.TriggerClear();

                if (m_bAbleUse)
                {
                    Debug.Log("clicked:BannerBase.Mode=" + BannerBase.Mode.ToString());
                    //SoundManager.Instance.PlaySE (SoundName.BUTTON_PUSH);

                    switch (BannerBase.Mode)
                    {
                    case BannerBase.MODE.MONSTER_DETAIL:
                        m_eStep = STEP.DETAIL;
                        break;

                    case BannerBase.MODE.MONSTER_SET_BUY:
                        m_eStep = STEP.SET_BUY;
                        break;

                    case BannerBase.MODE.MONSTER_SET_MINE:
                        m_eStep = STEP.SET_MINE;
                        break;

                    case BannerBase.MODE.MONSTER_SICK:
                        m_eStep = STEP.SICK;
                        break;

                    default:
                        break;
                    }
                }
            }
            break;

        case STEP.DETAIL:
            if (bInit)
            {
                SoundManager.Instance.PlaySE(SoundName.BUTTON_PUSH);
                // この作り方はいただけませんねぇ・・・
                GameObject obj = PrefabManager.Instance.MakeObject("prefab/PrefMonsterDetail", gameObject.transform.parent.parent.parent.parent.gameObject);
                m_monsterDetail = obj.GetComponent <CtrlMonsterDetail> ();
                m_monsterDetail.Initialize(m_dataMonster.monster_serial);
            }
            if (m_monsterDetail.IsEnd())
            {
                SoundManager.Instance.PlaySE(SoundName.BUTTON_PUSH);

                Destroy(m_monsterDetail.gameObject);
                m_monsterDetail = null;
                m_eStep         = STEP.IDLE;
            }
            break;

        case STEP.SET_BUY:
            if (bInit)
            {
                SoundManager.Instance.PlaySE(SoundName.SET_ANIMAL);

                CsvMonsterData monster_data = DataManager.GetMonster(m_dataMonsterMaster.monster_id);
                if (0 < monster_data.coin)
                {
                    DataManager.user.AddGold(-1 * monster_data.coin);
                }
                else if (0 < monster_data.ticket)
                {
                    DataManager.user.AddTicket(-1 * monster_data.ticket);
                }
                else
                {
                    ;                    // エラーちゃう?
                }

                // 0番のページに飛ばす
                DataMonster insertMonster = GameMain.dbMonster.Insert(m_dataMonsterMaster.monster_id, GameMain.Instance.m_iSettingItemSerial);

                m_tabParent.TriggerOn(0);

                CtrlFieldItem fielditem = GameMain.ParkRoot.GetFieldItem(GameMain.Instance.m_iSettingItemSerial);
                GameObject    objIcon   = PrefabManager.Instance.MakeObject("prefab/PrefIcon", fielditem.gameObject);
                CtrlIconRoot  iconRoot  = objIcon.GetComponent <CtrlIconRoot> ();
                iconRoot.Initialize(insertMonster, fielditem);
                fielditem.Add(iconRoot);

                // 仕事の確認
                DataWork.WorkCheck();
                GameMain.Instance.HeaderRefresh();

                if (0 < GameMain.Instance.TutorialMonster)
                {
                    TutorialManager.Instance.Next();
                    GameMain.Instance.TutorialMonster = 0;
                }
            }
            break;

        case STEP.SET_MINE:
            if (bInit)
            {
                SoundManager.Instance.PlaySE(SoundName.SET_ANIMAL);
                Dictionary <string, string> dict = new Dictionary <string, string> ();
                dict.Add("item_serial", GameMain.Instance.m_iSettingItemSerial.ToString());
                dict.Add("collect_time", "\"" + TimeManager.StrNow() + "\"");

                GameMain.dbMonster.Update(m_dataMonster.monster_serial, dict);
                //GameMain.dbMonster.Update (m_dataMonster.monster_serial, GameMain.Instance.m_iSettingItemSerial);

                m_tabParent.TriggerOn(0);

                DataMonster   insertMonster = GameMain.dbMonster.Select(m_dataMonster.monster_serial);
                CtrlFieldItem fielditem     = GameMain.ParkRoot.GetFieldItem(GameMain.Instance.m_iSettingItemSerial);
                GameObject    objIcon       = PrefabManager.Instance.MakeObject("prefab/PrefIcon", fielditem.gameObject);
                CtrlIconRoot  iconRoot      = objIcon.GetComponent <CtrlIconRoot> ();
                iconRoot.Initialize(insertMonster, fielditem);
                fielditem.Add(iconRoot);

                // 仕事の確認
                DataWork.WorkCheck();
                GameMain.Instance.HeaderRefresh();
            }
            break;

        case STEP.SICK:
            if (bInit)
            {
                GameObject objOjisan = PrefabManager.Instance.MakeObject("prefab/PrefOjisanCheck", gameObject.transform.parent.parent.parent.parent.gameObject);

                CsvMonsterData monster = DataManager.GetMonster(m_dataMonster.monster_id);

                int iCost = monster.revenew_coin * (int)(600.0f / (float)monster.revenew_interval);

                bool   bYesOnly = false;
                string strText  = string.Format("こちらの動物を\n治療しますか\n\n治療費:{0}G\n\n{1}G → [FFD900]{2}[-]G", iCost, DataManager.user.m_iGold, DataManager.user.m_iGold - iCost);
                if (DataManager.user.m_iGold < iCost)
                {
                    bYesOnly = true;
                    strText  = string.Format("こちらの動物を\n治療しますか\n治療費:{0}G\n\n[FFD900]GOLDが足りません[-]", iCost);
                }

                m_ojisanCheck = objOjisan.GetComponent <CtrlOjisanCheck> ();
                m_ojisanCheck.Initialize(strText, bYesOnly);
            }
            if (m_ojisanCheck.IsYes())
            {
                SoundManager.Instance.PlaySE("se_cure");
                CsvMonsterData monster = DataManager.GetMonster(m_dataMonster.monster_id);
                int            iCost   = monster.revenew_coin * (int)(600.0f / (float)monster.revenew_interval);
                DataManager.user.AddGold(-1 * iCost);

                GameMain.ListRefresh = true;
                Destroy(m_ojisanCheck.gameObject);

                Dictionary <string, string> dict = new Dictionary <string, string> ();
                int iConditionFine = (int)Define.Monster.CONDITION.FINE;
                dict.Add("condition", iConditionFine.ToString());
                dict.Add("clean_time", string.Format("\"{0}\" ", TimeManager.StrGetTime()));
                Debug.Log(TimeManager.StrGetTime());
                GameMain.dbMonster.Update(m_dataMonster.monster_serial, dict);
                m_eStep = STEP.IDLE;
            }
            else if (m_ojisanCheck.IsNo())
            {
                SoundManager.Instance.PlaySE(SoundName.BUTTON_PUSH);

                Destroy(m_ojisanCheck.gameObject);
                m_eStep = STEP.IDLE;
            }
            else
            {
            }
            break;

        case STEP.SET_CAGE:
            break;

        case STEP.MAX:
        default:
            break;
        }
    }
Ejemplo n.º 29
0
 public wnAdminSettings()
 {
     InitializeComponent();
     ActiveUser.wnAdminSettings = this;
     dgUsers.ItemsSource        = DataWork.FillUsersTable();
 }
Ejemplo n.º 30
0
    // Update is called once per frame
    void Update()
    {
        string strPrefab = "prefab/PrefItemDetailDisp";

        bool bInit = false;

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

        switch (m_eStep)
        {
        case STEP.IDLE:
            if (bInit)
            {
                m_buttonBase.TriggerClear();
            }
            if (m_buttonBase.ButtonPushed)
            {
                m_buttonBase.TriggerClear();
                Debug.Log("clicked:BannerBase.Mode=" + BannerBase.Mode.ToString());

                if (m_bAbleUse)
                {
                    switch (BannerBase.Mode)
                    {
                    case BannerBase.MODE.STAFF_SET_BUY:
                        m_eStep = STEP.SETTING;
                        break;

                    case BannerBase.MODE.STAFF_SET_MINE:
                        m_eStep = STEP.SETTING;
                        break;

                    case BannerBase.MODE.STAFF_BACKYARD_CHECK:
                        m_eStep = STEP.BACKYARD_CHECK;
                        break;

                    default:
                        break;
                    }
                }
            }
            break;

        case STEP.SETTING:
            if (bInit)
            {
                // この作り方はいただけませんねぇ・・・
                GameObject obj = PrefabManager.Instance.MakeObject("prefab/PrefStaffSetting", gameObject);
                m_staffSetting = obj.GetComponent <CtrlStaffSetting> ();

                Debug.Log(m_staffSetting);

                // ここで取得するっていうのもなんか良くないっすね
                DataItem officeData = GameMain.dbItem.Select(GameMain.Instance.m_iSettingItemSerial);

                Debug.Log(officeData);
                Debug.Log(m_dataStaff.staff_id);
                Debug.Log(m_dataStaff.staff_serial);

                Debug.Log(m_staffSetting);
                m_staffSetting.Initialize(officeData, m_dataStaff.staff_id, m_dataStaff.staff_serial);
            }
            if (m_staffSetting.IsEnd())
            {
                m_staffSetting.Close();
                Destroy(m_staffSetting.gameObject);
                m_staffSetting = null;
                m_eStep        = STEP.IDLE;
            }
            break;

        case STEP.BACKYARD_CHECK:
            if (bInit)
            {
                GameObject objOjisan = PrefabManager.Instance.MakeObject("prefab/PrefOjisanCheck", gameObject.transform.parent.parent.parent.parent.gameObject);
                m_ojisanCheck = objOjisan.GetComponent <CtrlOjisanCheck> ();
                m_ojisanCheck.Initialize("こちらのスタッフを\n待機室へ\n移動させます。");
            }
            if (m_ojisanCheck.IsYes())
            {
                GameMain.ListRefresh = true;
                m_eStep = STEP.BACKYARD;
            }
            else if (m_ojisanCheck.IsNo())
            {
                Destroy(m_ojisanCheck.gameObject);
                m_eStep = STEP.IDLE;
            }
            else
            {
            }
            break;

        case STEP.BACKYARD:

            CtrlFieldItem field_item = GameMain.ParkRoot.GetFieldItem(m_dataStaff.item_serial);
            field_item.RemoveStaff(m_dataStaff.staff_serial);

            Dictionary <string, string> dict = new Dictionary <string, string> ();
            dict.Add("office_serial", 0.ToString ());
            dict.Add("item_serial", 0.ToString ());
            //dict.Add ("setting_time", "\"" + strNow + "\"");
            GameMain.dbStaff.Update(m_dataStaff.staff_serial, dict);

            CsvStaffData staff_data = DataManager.GetStaff(m_dataStaff.staff_id);
            GameMain.Instance.m_iCostNokori += staff_data.cost;

            GameMain.ListRefresh = true;

            m_eStep = STEP.IDLE;
            // 仕事の確認
            DataWork.WorkCheck();
            GameMain.Instance.HeaderRefresh();
            // バックヤードに戻す場合はこっちでおじさんをけすd
            Destroy(m_ojisanCheck.gameObject);

            break;

        default:
            break;
        }
    }