public void Insert_Booking(Entity.Booking o_Booking)
{
if (o_Booking == null)
return;
Entity.Booking e_Booking = new Entity.Booking();
e_Booking.Booking_ID = o_Booking.Booking_ID;
e_Booking.Booking_Seq = FilterUtility.FilterSQL(o_Booking.Booking_Seq);
e_Booking.Booking_Airline = FilterUtility.FilterSQL(o_Booking.Booking_Airline);
e_Booking.Booking_Contact = FilterUtility.FilterSQL(o_Booking.Booking_Contact);
e_Booking.Booking_Num = o_Booking.Booking_Num;
e_Booking.Booking_Tel = FilterUtility.FilterSQL(o_Booking.Booking_Tel);
e_Booking.Booking_Email = FilterUtility.FilterSQL(o_Booking.Booking_Email);
e_Booking.Booking_AdminUser_ID = o_Booking.Booking_AdminUser_ID;
e_Booking.Booking_Kind = o_Booking.Booking_Kind;
e_Booking.Booking_State = o_Booking.Booking_State;
e_Booking.Booking_AddTime = o_Booking.Booking_AddTime;
e_Booking.Booking_LastTime = o_Booking.Booking_LastTime;
d_Booking.Insert_Booking(e_Booking);
}
public Entity.Booking[] Select_Booking(string p_Search_Content, int p_Search_Method, int p_Search_State, int p_PageSize, int p_PageIndex)
{
switch (p_Search_Method)
{
case 6:
{
BLL.AdminUser b_AdminUser = new AdminUser();
Entity.AdminUser o_AdminUser = b_AdminUser.Select_AdminUser(1, p_Search_Content);
if (o_AdminUser != null)
{
p_Search_Content = o_AdminUser.AdminUser_ID.ToString();
p_Search_Method = 6;
}
else
return null;
}
break;
case 7:
{
BLL.AdminUser b_AdminUser = new AdminUser();
Entity.AdminUser o_AdminUser = b_AdminUser.Select_AdminUser(2, p_Search_Content);
if (o_AdminUser != null)
{
p_Search_Content = o_AdminUser.AdminUser_ID.ToString();
p_Search_Method = 7;
}
else
return null;
}
break;
default:
break;
}
DataTable o_DataTable = d_Booking.Select_Booking(p_Search_Content, p_Search_Method, p_Search_State, p_PageSize, p_PageIndex, ref g_TotalCount, ref g_TotalPage);
if (o_DataTable == null)
return null;
else
{
Entity.Booking[] e_Booking = new Entity.Booking[o_DataTable.Rows.Count];
int i = 0;
foreach (DataRow o_DataRow in o_DataTable.Rows)
{
e_Booking[i] = new Entity.Booking();
DateRow_Booking(o_DataRow, e_Booking[i]);
i++;
}
return e_Booking;
}
}
public Entity.Booking Select_Booking(int p_Booking_ID)
{
DataTable o_DataTable = d_Booking.Select_Booking(p_Booking_ID, ref g_TotalCount, ref g_TotalPage);
if (o_DataTable == null)
return null;
else
{
DataRow o_DataRow = o_DataTable.Rows[0];
Entity.Booking e_Booking = new Entity.Booking();
DateRow_Booking(o_DataRow, e_Booking);
return e_Booking;
}
}