예제 #1
0
 void SetEESWaitList(EESWaitData objEESWaitData)
 {
     if (objEESWaitDba == null)
     {
         objEESWaitDba = new EESWaitDba();
     }
     waitListGrid.ItemsSource = objEESWaitDba.GetEESWaitList(objEESWaitData);
 }
예제 #2
0
        private void searchBut_Click(object sender, RoutedEventArgs e)
        {
            EESWaitData objEESWaitSearchData = new EESWaitData();

            objEESWaitSearchData.WaitGate = (string)gateCompo.SelectedItem;

            objEESWaitSearchData.WaitLocationId = (int)locationCompo.SelectedValue;
            objEESWaitSearchData.WaitUpdateTime = waitDatePicker.SelectedDate ?? DateTime.Now;
            SetEESWaitList(objEESWaitSearchData);
        }
예제 #3
0
        private void RefreshBut_Click(object sender, RoutedEventArgs e)
        {
            EESWaitData objEESWaitData = new EESWaitData();

            objEESWaitData.WaitGate       = "";
            objEESWaitData.WaitLocationId = 0;
            objEESWaitData.WaitUpdateTime = System.DateTime.Now;

            waitDatePicker.SelectedDate = objEESWaitData.WaitUpdateTime;
            gateCompo.SelectedItem      = "";
            locationCompo.SelectedValue = 0;

            SetEESWaitList(objEESWaitData);
        }
예제 #4
0
        private void UserControl_Loaded(object sender, RoutedEventArgs e)
        {
            gateCompo.ItemsSource = gateList;
            //gateCompo.i
            locationCompo.ItemsSource = locationDictionary;
            EESWaitData objEESWaitData = new EESWaitData();

            objEESWaitData.WaitGate       = "";
            objEESWaitData.WaitLocationId = 0;
            objEESWaitData.WaitUpdateTime = System.DateTime.Now;

            waitDatePicker.SelectedDate = objEESWaitData.WaitUpdateTime;
            gateCompo.SelectedItem      = "";
            locationCompo.SelectedValue = 0;

            SetEESWaitList(objEESWaitData);
        }
예제 #5
0
        public List <EESWaitData> GetEESWaitList(EESWaitData objEESWaitDataForSearch)
        {
            List <EESWaitData> waitList = null;

            try
            {
                using (OracleConnection con = new OracleConnection(Connection.connectionString))
                {
                    if (con.State == ConnectionState.Closed)
                    {
                        con.Open();
                    }
                    using (OracleCommand command = con.CreateCommand())
                    {
                        string sql = "select rownum sno,WAIT_HIST_ID,WAIT_GATE,WAIT_LOCATION_ID,LOCATION,WAIT_TIME,WAIT_UPDATE_TIME"
                                     + " from "
                                     + " ("
                                     + " select WAIT_HIST_ID,WAIT_GATE,WAIT_LOCATION_ID,(select wait_location from wait_car_location_master where loc_id=WAIT_LOCATION_ID) LOCATION,"
                                     + " WAIT_TIME,WAIT_UPDATE_TIME"
                                     + " from WAIT_CAR_FLOW_EES_HIST order by WAIT_UPDATE_TIME desc"
                                     + " ) where TRUNC(WAIT_UPDATE_TIME)=:WaitUpdateTime ";
                        if (!string.IsNullOrEmpty(objEESWaitDataForSearch.WaitGate))
                        {
                            sql += " and WAIT_GATE=:WaitGate";
                        }
                        if (objEESWaitDataForSearch.WaitLocationId != 0)
                        {
                            sql += " and WAIT_LOCATION_ID=:WaitLocationId";
                        }
                        command.BindByName = true;
                        command.Parameters.Add("WaitUpdateTime", objEESWaitDataForSearch.WaitUpdateTime.ToString("dd-MMM-yyyy"));
                        if (!string.IsNullOrEmpty(objEESWaitDataForSearch.WaitGate))
                        {
                            command.Parameters.Add("WaitGate", objEESWaitDataForSearch.WaitGate);
                        }
                        if (objEESWaitDataForSearch.WaitLocationId != 0)
                        {
                            command.Parameters.Add("WaitLocationId", objEESWaitDataForSearch.WaitLocationId);
                        }

                        command.CommandText = sql;
                        using (OracleDataReader reader = command.ExecuteReader())
                        {
                            if (reader.HasRows)
                            {
                                waitList = new List <EESWaitData>();

                                while (reader.Read())
                                {
                                    EESWaitData objEESWaitData = new EESWaitData();

                                    objEESWaitData.sno        = Int32.Parse(reader["sno"].ToString());
                                    objEESWaitData.WaitHistID = Int32.Parse(reader["WAIT_HIST_ID"].ToString());
                                    objEESWaitData.WaitGate   = reader["WAIT_GATE"].ToString();

                                    DateTime tempDate = new DateTime();
                                    DateTime.TryParse(reader["WAIT_UPDATE_TIME"].ToString(), out tempDate);
                                    objEESWaitData.WaitUpdateTime = tempDate;

                                    objEESWaitData.WaitLocation = reader["LOCATION"].ToString();
                                    objEESWaitData.WaitTime     = reader["WAIT_TIME"].ToString();


                                    waitList.Add(objEESWaitData);
                                }
                            }
                        }
                    }
                }
            }
            catch (Exception errMsg)
            {
                Console.WriteLine(errMsg.Message);
            }
            return(waitList);
        }