コード例 #1
0
 public static EventVisitModel getEvent(int eventId)
 {
     try
     {
         for (int i = 0; i < _events.Count; i++)
         {
             EventVisitModel ev = _events[i];
             if (ev.id == eventId)
             {
                 return(ev);
             }
         }
     }
     catch (Exception ex)
     {
         SaveLog.fatal(ex.ToString());
         Printf.b_danger("[EventVisitSyncer] Fatal Error!");
     }
     return(null);
 }
コード例 #2
0
 public static EventVisitModel getRunningEvent()
 {
     try
     {
         uint date = uint.Parse(DateTime.Now.ToString("yyMMddHHmm"));
         for (int i = 0; i < _events.Count; i++)
         {
             EventVisitModel ev = _events[i];
             if (ev.startDate <= date && date < ev.endDate)
             {
                 return(ev);
             }
         }
     }
     catch (Exception ex)
     {
         SaveLog.fatal(ex.ToString());
         Printf.b_danger("[EventVisitSyncer] Fatal Error!");
     }
     return(null);
 }
コード例 #3
0
        public static void GenerateList()
        {
            try
            {
                using (NpgsqlConnection connection = SQLjec.getInstance().conn())
                {
                    NpgsqlCommand command = connection.CreateCommand();
                    connection.Open();
                    command.CommandText = "SELECT * FROM events_visit";
                    command.CommandType = CommandType.Text;
                    NpgsqlDataReader data = command.ExecuteReader();
                    while (data.Read())
                    {
                        EventVisitModel ev = new EventVisitModel
                        {
                            id        = data.GetInt32(0),
                            startDate = (UInt32)data.GetInt64(1),
                            endDate   = (UInt32)data.GetInt64(2),
                            title     = data.GetString(3),
                            checks    = data.GetInt32(4)
                        };
                        string goods1  = data.GetString(5);
                        string counts1 = data.GetString(6);
                        string goods2  = data.GetString(7);
                        string counts2 = data.GetString(8);

                        string[] goodsarray1 = goods1.Split(',');
                        string[] goodsarray2 = goods2.Split(',');

                        for (int i = 0; i < goodsarray1.Length; i++)
                        {
                            ev.box[i].reward1.good_id = int.Parse(goodsarray1[i]);
                        }
                        for (int i = 0; i < goodsarray2.Length; i++)
                        {
                            ev.box[i].reward2.good_id = int.Parse(goodsarray2[i]);
                        }

                        string[] countarray1 = counts1.Split(',');
                        string[] countarray2 = counts2.Split(',');
                        for (int i = 0; i < countarray1.Length; i++)
                        {
                            VisitItem item = ev.box[i].reward1;
                            item.SetCount(countarray1[i]);
                        }
                        for (int i = 0; i < countarray2.Length; i++)
                        {
                            VisitItem item = ev.box[i].reward2;
                            item.SetCount(countarray2[i]);
                        }
                        ev.SetBoxCounts();
                        _events.Add(ev);
                    }
                    command.Dispose();
                    data.Close();
                    connection.Dispose();
                    connection.Close();
                }
            }
            catch (Exception ex)
            {
                SaveLog.fatal(ex.ToString());
                Printf.b_danger("[EventVisitSyncer] Fatal Error!");
            }
        }