Beispiel #1
0
        public void Insert_LowFare_Detail(List<Entity.LowFare_Detail> p_LowFare_Detail)
        {
            if (p_LowFare_Detail == null)
                return;

            List<Entity.LowFare_Detail> o_LowFare_Detail = new List<Entity.LowFare_Detail>();
            foreach (Entity.LowFare_Detail e_LowFare_Detail in p_LowFare_Detail)
            {
                Entity.LowFare_Detail c_LowFare_Detail = new Entity.LowFare_Detail();
                c_LowFare_Detail.LowFare_Detail_ID = e_LowFare_Detail.LowFare_Detail_ID;
                c_LowFare_Detail.LowFare_Detail_LowFare_ID = e_LowFare_Detail.LowFare_Detail_LowFare_ID;
                c_LowFare_Detail.LowFare_Detail_From = FilterUtility.FilterSQL(e_LowFare_Detail.LowFare_Detail_From);
                c_LowFare_Detail.LowFare_Detail_To = FilterUtility.FilterSQL(e_LowFare_Detail.LowFare_Detail_To);
                c_LowFare_Detail.LowFare_Detail_Departing = e_LowFare_Detail.LowFare_Detail_Departing;
                c_LowFare_Detail.LowFare_Detail_Time1 = FilterUtility.FilterSQL(e_LowFare_Detail.LowFare_Detail_Time1);
                c_LowFare_Detail.LowFare_Flexibility1 = FilterUtility.FilterSQL(e_LowFare_Detail.LowFare_Flexibility1);
                c_LowFare_Detail.LowFare_Detail_Returning = e_LowFare_Detail.LowFare_Detail_Returning;
                c_LowFare_Detail.LowFare_Detail_Time2 = FilterUtility.FilterSQL(e_LowFare_Detail.LowFare_Detail_Time2);
                c_LowFare_Detail.LowFare_Flexibility2 = FilterUtility.FilterSQL(e_LowFare_Detail.LowFare_Flexibility2);

                o_LowFare_Detail.Add(c_LowFare_Detail);
            }

            d_LowFare_Detail.Insert_LowFare_Detail(o_LowFare_Detail);
        }
Beispiel #2
0
        public int LowFare_Detail_Next_LowFare_ID()
        {
            DataTable o_DataTable = d_LowFare_Detail.Select_LowFare_Detail(1, 1, ref g_TotalCount, ref g_TotalPage);
            if (o_DataTable == null)
                return 1;
            else
            {
                DataRow o_DataRow = o_DataTable.Rows[0];

                Entity.LowFare_Detail e_LowFare_Detail = new Entity.LowFare_Detail();
                DateRow_LowFare_Detail(o_DataRow, e_LowFare_Detail);

                return e_LowFare_Detail.LowFare_Detail_LowFare_ID + 1;
            }
        }
Beispiel #3
0
        public Entity.LowFare_Detail Select_LowFare_Detail(int p_LowFare_Detail_ID, int p_PageSize, int p_PageIndex)
        {
            DataTable o_DataTable = d_LowFare_Detail.Select_LowFare_Detail(p_LowFare_Detail_ID, p_PageSize, p_PageIndex, ref g_TotalCount, ref g_TotalPage);
            if (o_DataTable == null)
                return null;
            else
            {
                DataRow o_DataRow = o_DataTable.Rows[0];

                Entity.LowFare_Detail e_LowFare_Detail = new Entity.LowFare_Detail();
                DateRow_LowFare_Detail(o_DataRow, e_LowFare_Detail);

                return e_LowFare_Detail;
            }
        }
Beispiel #4
0
        public Entity.LowFare_Detail[] Select_LowFare_Detail_LowFare_ID(int p_LowFare_Detail_LowFare_ID, int p_PageSize, int p_PageIndex)
        {
            DataTable o_DataTable = d_LowFare_Detail.Select_LowFare_Detail_LowFare_ID(p_LowFare_Detail_LowFare_ID, p_PageSize, p_PageIndex, ref g_TotalCount, ref g_TotalPage);
            if (o_DataTable == null)
                return null;
            else
            {
                Entity.LowFare_Detail[] e_LowFare_Detail = new Entity.LowFare_Detail[o_DataTable.Rows.Count];

                int i = 0;
                foreach (DataRow o_DataRow in o_DataTable.Rows)
                {
                    e_LowFare_Detail[i] = new Entity.LowFare_Detail();
                    DateRow_LowFare_Detail(o_DataRow, e_LowFare_Detail[i]);

                    i++;
                }

                return e_LowFare_Detail;
            }
        }