OA2021/DAL/ServiceBase.cs

using System;
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Data;
using Models;


namespace DAL
{
    /// <summary>
    /// 泛型公共数据读取类
    /// </summary>
    /// <typeparam name="T"></typeparam>
    public static class ServiceBase<T> where T : new()
    {
        /// <summary>
        /// 静态读取方法
        /// </summary>
        /// <param name="t">对象</param>
        /// <param name="type">对象区分</param>
        /// <param name="sql">sql语句</param>
        /// <param name="cmdType">文本类型</param>
        /// <param name="param">可变参数数组</param>
        /// <returns>返回集合</returns>
        public static List<T> excuteSql(T t, string type, string sql, CommandType cmdType, params SqlParameter[] param)
        {
            List<T> tList = null;

            using (SqlDataReader dr = SqlHelper.ExcuteReader(sql, cmdType, param))
            {
                if (dr != null)
                {
                    tList = new List<T>();
                    while (dr.Read())
                    {
                        t = new T();
                        switch (type)
                        {
                            case "SystemMenu":
                                (t as SystemMenu).Id = Convert.ToInt32(dr["Id"]);
                                (t as SystemMenu).Name = dr["Name"].ToString();
                                (t as SystemMenu).ShowName = dr["ShowName"].ToString();
                                (t as SystemMenu).PageName = dr["PageName"].ToString();
                                (t as SystemMenu).Mnid = Convert.ToInt32(dr["Mnid"]);
                                (t as SystemMenu).Ico = dr["Ico"].ToString();
                                (t as SystemMenu).Width = Convert.ToInt32(dr["Width"]);
                                (t as SystemMenu).Height = Convert.ToInt32(dr["Height"]);
                                (t as SystemMenu).IsEnable = Convert.ToInt32(dr["IsEnable"]);
                                (t as SystemMenu).Mid = Convert.ToInt32(dr["Mid"]);
                                (t as SystemMenu).IsDel = Convert.ToInt32(dr["IsDel"]);
                                (t as SystemMenu).IsShow = Convert.ToInt32(dr["IsShow"]);
                                break;
                            case "SystemFunction":
                                (t as SystemFunction).Id = Convert.ToInt32(dr["Id"]);
                                (t as SystemFunction).Name = dr["Name"].ToString();
                                (t as SystemFunction).Code = dr["Code"].ToString();
                                (t as SystemFunction).Remark = dr["Remark"].ToString();
                                (t as SystemFunction).IsEnable = Convert.ToInt32(dr["IsEnable"]);
                                break;
                            case "Competence":
                                (t as Competence).Id = Convert.ToInt32(dr["Id"]);
                                (t as Competence).Uid = Convert.ToInt32(dr["Uid"]);
                                (t as Competence).Sid = Convert.ToInt32(dr["Sid"]);
                                (t as Competence).STable = Convert.ToInt32(dr["STable"]);
                                break;
                            case "SetDataType":
                                (t as SetDataType).Id = Convert.ToInt32(dr["Id"]);
                                (t as SetDataType).Name = dr["Name"].ToString();
                                (t as SetDataType).IsEnable = Convert.ToInt32(dr["IsEnable"]);
                                break;
                            case "SetData":
                                (t as SetData).Id = Convert.ToInt32(dr["Id"]);
                                (t as SetData).Name = dr["Name"].ToString();
                                (t as SetData).Remark = dr["Remark"].ToString();
                                (t as SetData).STid = Convert.ToInt32(dr["STid"]);
                                (t as SetData).IsDel = Convert.ToInt32(dr["IsDel"]);
                                break;
                            case "Users":
                                (t as Users).Id = Convert.ToInt32(dr["Id"]);
                                (t as Users).CnName = dr["CnName"].ToString();
                                (t as Users).EnName = dr["EnName"].ToString();
                                (t as Users).Number = dr["Number"].ToString();
                                (t as Users).Did = Convert.ToInt32(dr["Did"]);
                                (t as Users).Password = dr["Password"].ToString();
                                (t as Users).Sex = Convert.ToInt32(dr["Sex"]);
                                (t as Users).Post = dr["Post"].ToString();
                                (t as Users).Ext = dr["Ext"].ToString();
                                (t as Users).Phone = dr["Phone"].ToString();
                                (t as Users).UrgentPhone = dr["UrgentPhone"].ToString();
                                (t as Users).Email = dr["Email"].ToString();
                                (t as Users).Address = dr["Address"].ToString();
                                (t as Users).Edate = Convert.ToDateTime(dr["Edate"]);
                                (t as Users).Rdate = Convert.ToDateTime(dr["Rdate"]);
                                (t as Users).Seniority = Convert.ToInt32(dr["Seniority"]);
                                (t as Users).Remark = dr["Remark"].ToString();
                                (t as Users).IsDel = Convert.ToInt32(dr["IsDel"]);
                                (t as Users).Company = Convert.ToInt32(dr["Company"]);
                                (t as Users).Birthday = dr["Birthday"].ToString();
                                (t as Users).IDCard = dr["IDCard"].ToString();
                                (t as Users).StartWorkDate = dr["StartWorkDate"].ToString();
                                (t as Users).Education = dr["Education"].ToString();
                                (t as Users).Professional = dr["Professional"].ToString();
                                (t as Users).GraduateInstitutions = dr["GraduateInstitutions"].ToString();
                                (t as Users).TheOrAdultEducation = dr["TheOrAdultEducation"].ToString();
                                (t as Users).MaritalStatus = dr["MaritalStatus"].ToString();
                                (t as Users).HomeAddress = dr["HomeAddress"].ToString();
                                (t as Users).UsePeriod = dr["UsePeriod"].ToString();
                                (t as Users).WorkExperience = dr["WorkExperience"].ToString();
                                (t as Users).CertificateTime = dr["CertificateTime"].ToString();
                                (t as Users).Certificate = dr["Certificate"].ToString();
                                break;
                            case "Calendar":
                                (t as Calendars).Id = Convert.ToInt32(dr["Id"]);
                                (t as Calendars).CalendarDate = dr["CalendarDate"].ToString();
                                (t as Calendars).CTid = Convert.ToInt32(dr["CTid"]);
                                break;
                            case "AttendanceData":
                                (t as AttendanceData).Id = Convert.ToInt32(dr["Id"]);
                                (t as AttendanceData).UserNumber = dr["UserNumber"].ToString();
                                (t as AttendanceData).SwipeDate = dr["SwipeDate"].ToString();
                                (t as AttendanceData).SwipeTime = dr["SwipeTime"].ToString();
                                (t as AttendanceData).InitSwipeTime = dr["InitSwipeTime"].ToString();
                                break;
                            case "YearMonth":
                                (t as YearMonth).YearMonths = dr["YearMonths"].ToString();
                                break;
                            case "UpCardAudit":
                                (t as UpCardAudit).Id = Convert.ToInt32(dr["Id"]);
                                (t as UpCardAudit).Uid = Convert.ToInt32(dr["Uid"]);
                                (t as UpCardAudit).YearMonth = dr["YearMonth"].ToString();
                                (t as UpCardAudit).ApplicationPeriod = dr["ApplicationPeriod"].ToString();
                                (t as UpCardAudit).Attachment = dr["Attachment"].ToString();
                                (t as UpCardAudit).Subject = dr["Subject"].ToString();
                                (t as UpCardAudit).IsAudit = Convert.ToInt32(dr["IsAudit"]);
                                (t as UpCardAudit).AuditRemark = dr["AuditRemark"].ToString();
                                (t as UpCardAudit).Operate = Convert.ToInt32(string.IsNullOrEmpty(dr["Operate"].ToString()) ? 0 : dr["Operate"]);
                                (t as UpCardAudit).OperateTime = dr["OperateTime"].ToString();
                                (t as UpCardAudit).IsDel = Convert.ToInt32(dr["IsDel"]);
                                break;
                            case "UpCardAuditContent":
                                (t as UpCardAuditContent).Id = Convert.ToInt32(dr["Id"]);
                                (t as UpCardAuditContent).UCAid = Convert.ToInt32(dr["UCAid"]);
                                (t as UpCardAuditContent).Did = Convert.ToInt32(dr["Did"]);
                                (t as UpCardAuditContent).UpCardDate = dr["UpCardDate"].ToString();
                                (t as UpCardAuditContent).UpCardPeriod = dr["UpCardPeriod"].ToString();
                                (t as UpCardAuditContent).UpCardHours = Convert.ToDouble(dr["UpCardHours"].ToString());
                                (t as UpCardAuditContent).IsDel = Convert.ToInt32(dr["IsDel"]);
                                break;
                            case "AttendanceAudit":
                                (t as AttendanceAudit).Id = Convert.ToInt32(dr["Id"]);
                                (t as AttendanceAudit).UserId = Convert.ToInt32(dr["UserId"]);
                                (t as AttendanceAudit).Number = dr["Number"].ToString();
                                (t as AttendanceAudit).CnName = dr["CnName"].ToString();
                                (t as AttendanceAudit).ApplicationPeriod = dr["ApplicationPeriod"].ToString();
                                (t as AttendanceAudit).Subject = dr["Subject"].ToString();
                                (t as AttendanceAudit).Attachment = dr["Attachment"].ToString();
                                break;
                            case "ClientData":
                                (t as ClientData).Id = Convert.ToInt32(dr["Id"]);
                                (t as ClientData).Did = Convert.ToInt32(dr["Did"]);
                                (t as ClientData).Name = dr["Name"].ToString();
                                (t as ClientData).Sex = Convert.ToInt32(dr["Sex"]);
                                (t as ClientData).UnitName = dr["UnitName"].ToString();
                                (t as ClientData).UnitAbbreviation = dr["UnitAbbreviation"].ToString();
                                (t as ClientData).Post = dr["Post"].ToString();
                                (t as ClientData).Tel = dr["Tel"].ToString();
                                (t as ClientData).Email = dr["Email"].ToString();
                                (t as ClientData).Fax = dr["Fax"].ToString();
                                (t as ClientData).OtherInformation = dr["OtherInformation"].ToString();
                                (t as ClientData).Operators = Convert.ToInt32(dr["Operator"]);
                                (t as ClientData).OperatorsDate = dr["OperatorDate"].ToString();
                                (t as ClientData).IsDel = Convert.ToInt32(dr["IsDel"]);
                                (t as ClientData).Lid = Convert.ToInt32(dr["Lid"]);
                                (t as ClientData).ClientLvl = dr["ClientLvl"].ToString();
                                break;
                            case "HotelData":
                                (t as HotelData).Id = Convert.ToInt32(dr["Id"]);
                                (t as HotelData).City = dr["City"].ToString();
                                (t as HotelData).Name = dr["Name"].ToString();
                                (t as HotelData).Level = dr["Level"].ToString();
                                (t as HotelData).Address = dr["Address"].ToString();
                                (t as HotelData).Tel = dr["Tel"].ToString();
                                (t as HotelData).Fax = dr["Fax"].ToString();
                                (t as HotelData).Contact = dr["Contact"].ToString();
                                (t as HotelData).ContactPhone = dr["ContactPhone"].ToString();
                                (t as HotelData).OtherInformation = dr["OtherInformation"].ToString();
                                (t as HotelData).Operators = Convert.ToInt32(dr["Operator"]);
                                (t as HotelData).OperatorsDate = dr["OperatorDate"].ToString();
                                (t as HotelData).IsDel = Convert.ToInt32(dr["IsDel"]);
                                break;
                            case "TouristGuideGroundData":
                                (t as TouristGuideGroundData).Id = Convert.ToInt32(dr["Id"]);
                                (t as TouristGuideGroundData).StaffType = dr["StaffType"].ToString();
                                (t as TouristGuideGroundData).UnitArea = dr["UnitArea"].ToString();
                                (t as TouristGuideGroundData).UnitName = dr["UnitName"].ToString();
                                (t as TouristGuideGroundData).Address = dr["Address"].ToString();
                                (t as TouristGuideGroundData).Contact = dr["Contact"].ToString();
                                (t as TouristGuideGroundData).Tel = dr["Tel"].ToString();
                                (t as TouristGuideGroundData).Email = dr["Email"].ToString();
                                (t as TouristGuideGroundData).Fax = dr["Fax"].ToString();
                                (t as TouristGuideGroundData).OtherInformation = dr["OtherInformation"].ToString();
                                (t as TouristGuideGroundData).CompanyOrGuide = Convert.ToInt32(dr["CompanyOrGuide"]);
                                (t as TouristGuideGroundData).Score = Convert.ToInt32(dr["Score"]);
                                (t as TouristGuideGroundData).SuitScore = dr["SuitScore"].ToString();
                                (t as TouristGuideGroundData).ServeScore = dr["ServeScore"].ToString();
                                (t as TouristGuideGroundData).TalkProScore = dr["TalkProScore"].ToString();
                                (t as TouristGuideGroundData).TimeScore = dr["TimeScore"].ToString();
                                (t as TouristGuideGroundData).FitScore = dr["FitScore"].ToString();
                                (t as TouristGuideGroundData).StrainScore = dr["StrainScore"].ToString();
                                (t as TouristGuideGroundData).LocalAndChineseScore = dr["LocalAndChineseScore"].ToString();
                                (t as TouristGuideGroundData).Operators = Convert.ToInt32(dr["Operator"]);
                                (t as TouristGuideGroundData).OperatorsDate = dr["OperatorDate"].ToString();
                                (t as TouristGuideGroundData).IsDel = Convert.ToInt32(dr["IsDel"]);
                                break;
                            case "CarData":
                                (t as CarData).Id = Convert.ToInt32(dr["Id"]);
                                (t as CarData).UnitArea = dr["UnitArea"].ToString();
                                (t as CarData).UnitName = dr["UnitName"].ToString();
                                (t as CarData).Address = dr["Address"].ToString();
                                (t as CarData).Contact = dr["Contact"].ToString();
                                (t as CarData).Tel = dr["Tel"].ToString();
                                (t as CarData).Email = dr["Email"].ToString();
                                (t as CarData).Fax = dr["Fax"].ToString();
                                (t as CarData).CarDes = dr["CarDes"].ToString();
                                (t as CarData).CarAge = dr["CarAge"].ToString();
                                (t as CarData).CarPicName = dr["CarPicName"].ToString();
                                (t as CarData).CarPicPath = dr["CarPicPath"].ToString();
                                (t as CarData).OtherInformation = dr["OtherInformation"].ToString();
                                (t as CarData).CompanyOrGuide = Convert.ToInt32(dr["CompanyOrGuide"]);
                                (t as CarData).Score = Convert.ToInt32(dr["Score"]);
                                (t as CarData).QualificationScore = dr["QualificationScore"].ToString();
                                (t as CarData).CarAgeScore = dr["CarAgeScore"].ToString();
                                (t as CarData).CleanImgScore = dr["CleanImgScore"].ToString();
                                (t as CarData).SmellScore = dr["SmellScore"].ToString();
                                (t as CarData).WaterPaperScore = dr["WaterPaperScore"].ToString();
                                (t as CarData).HardwareScore = dr["HardwareScore"].ToString();
                                (t as CarData).TimeScore = dr["TimeScore"].ToString();
                                (t as CarData).SafetyScore = dr["SafetyScore"].ToString();
                                (t as CarData).DrivingAgeScore = dr["DrivingAgeScore"].ToString();
                                (t as CarData).Operators = Convert.ToInt32(dr["Operator"]);
                                (t as CarData).OperatorsDate = dr["OperatorDate"].ToString();
                                (t as CarData).IsDel = Convert.ToInt32(dr["IsDel"]);
                                break;
                            case "InvitationOfficialActivityData":
                                (t as InvitationOfficialActivityData).Id = Convert.ToInt32(dr["Id"]);
                                (t as InvitationOfficialActivityData).Country = dr["Country"].ToString();
                                (t as InvitationOfficialActivityData).City = dr["City"].ToString();
                                (t as InvitationOfficialActivityData).UnitName = dr["UnitName"].ToString();
                                (t as InvitationOfficialActivityData).UnitWeb = dr["UnitWeb"].ToString();
                                (t as InvitationOfficialActivityData).Field = dr["Field"].ToString();
                                (t as InvitationOfficialActivityData).Address = dr["Address"].ToString();
                                (t as InvitationOfficialActivityData).UnitInfo = dr["UnitInfo"].ToString();
                                (t as InvitationOfficialActivityData).Contact = dr["Contact"].ToString();
                                (t as InvitationOfficialActivityData).Job = dr["Job"].ToString();
                                (t as InvitationOfficialActivityData).Tel = dr["Tel"].ToString();
                                (t as InvitationOfficialActivityData).Email = dr["Email"].ToString();
                                (t as InvitationOfficialActivityData).WeChat = dr["WeChat"].ToString();
                                (t as InvitationOfficialActivityData).FaceBook = dr["FaceBook"].ToString();
                                (t as InvitationOfficialActivityData).Ins = dr["Ins"].ToString();
                                (t as InvitationOfficialActivityData).Delegation = dr["Delegation"].ToString();
                                (t as InvitationOfficialActivityData).FileName = dr["FileName"].ToString();
                                (t as InvitationOfficialActivityData).FilePath = dr["FilePath"].ToString();
                                (t as InvitationOfficialActivityData).SndFileName = dr["SndFileName"].ToString();
                                (t as InvitationOfficialActivityData).SndFilePath = dr["SndFilePath"].ToString();
                                (t as InvitationOfficialActivityData).OtherInformation = dr["OtherInformation"].ToString();
                                (t as InvitationOfficialActivityData).Fax = dr["Fax"].ToString();
                                (t as InvitationOfficialActivityData).Operators = Convert.ToInt32(dr["Operator"]);
                                (t as InvitationOfficialActivityData).OperatorsDate = dr["OperatorDate"].ToString();
                                (t as InvitationOfficialActivityData).IsDel = Convert.ToInt32(dr["IsDel"]);
                                (t as InvitationOfficialActivityData).Backdrop = dr["Backdrop"].ToString();
                                break;
                            case "DelegationInfo":
                                (t as DelegationInfo).Id = Convert.ToInt32(dr["Id"]);
                                (t as DelegationInfo).SalesQuoteNo = dr["SalesQuoteNo"].ToString();
                                (t as DelegationInfo).SalesDate = dr["SalesDate"].ToString();
                                (t as DelegationInfo).ClientName = dr["ClientName"].ToString();
                                (t as DelegationInfo).ClientUnit = dr["ClientUnit"].ToString();
                                (t as DelegationInfo).TourCode = dr["TourCode"].ToString();
                                (t as DelegationInfo).TeamName = dr["TeamName"].ToString();
                                (t as DelegationInfo).TeamDid = Convert.ToInt32(dr["TeamDid"]);
                                (t as DelegationInfo).VisitDate = dr["VisitDate"].ToString();
                                (t as DelegationInfo).VisitStartDate = dr["VisitStartDate"].ToString();
                                (t as DelegationInfo).VisitEndDate = dr["VisitEndDate"].ToString();
                                (t as DelegationInfo).VisitCountry = dr["VisitCountry"].ToString();
                                (t as DelegationInfo).VisitPurpose = dr["VisitPurpose"].ToString();
                                (t as DelegationInfo).VisitDays = Convert.ToInt32(dr["VisitDays"]);
                                (t as DelegationInfo).VisitPNumber = Convert.ToInt32(dr["VisitPNumber"]);
                                (t as DelegationInfo).SpecialNeeds = dr["SpecialNeeds"].ToString();
                                (t as DelegationInfo).OtherNeeds = dr["OtherNeeds"].ToString();
                                (t as DelegationInfo).ClientNeeds = dr["ClientNeeds"].ToString();
                                (t as DelegationInfo).Remark = dr["Remark"].ToString();
                                (t as DelegationInfo).IsState = Convert.ToInt32(dr["IsState"]);
                                (t as DelegationInfo).JietuanOperator = Convert.ToInt32(dr["JietuanOperator"]);
                                (t as DelegationInfo).JietuanTime = dr["JietuanTime"].ToString();
                                (t as DelegationInfo).GroupsOperator = Convert.ToInt32(string.IsNullOrEmpty(dr["GroupsOperator"].ToString()) ? 0 : dr["GroupsOperator"]);
                                (t as DelegationInfo).GroupsTime = dr["GroupsTime"].ToString();
                                (t as DelegationInfo).IsDel = Convert.ToInt32(dr["IsDel"]);
                                (t as DelegationInfo).BudgetCost = dr["BudgetCost"].ToString();
                                (t as DelegationInfo).TellPhone = dr["TellPhone"].ToString();
                                (t as DelegationInfo).IsSure = Convert.ToInt32(dr["IsSure"]);
                                (t as DelegationInfo).TeamLev = dr["TeamLev"].ToString();
                                (t as DelegationInfo).HotelComplain = Convert.ToInt32(dr["HotelComplain"]);
                                (t as DelegationInfo).OPComplain = Convert.ToInt32(dr["OPComplain"]);
                                (t as DelegationInfo).VisaComplain = Convert.ToInt32(dr["VisaComplain"]);
                                (t as DelegationInfo).OAComplain = Convert.ToInt32(dr["OAComplain"]);
                                (t as DelegationInfo).AirComplain = Convert.ToInt32(dr["AirComplain"]);
                                (t as DelegationInfo).Director = Convert.ToInt32(dr["Director"]);
                                (t as DelegationInfo).TontractTime =dr["TontractTime"].ToString();
                                (t as DelegationInfo).PaymentMoney = dr["PaymentMoney"].ToString();
                                (t as DelegationInfo).PayDay = dr["PayDay"].ToString();
                                (t as DelegationInfo).WeChat = dr["WeChat"].ToString();
                                #region 新添加字段
                                (t as DelegationInfo).CGRWSPBMMC = dr["CGRWSPBMMC"].ToString();
                                (t as DelegationInfo).CGRWSPWH = dr["CGRWSPWH"].ToString();
                                (t as DelegationInfo).ZZSCBMMC = dr["ZZSCBMMC"].ToString();
                                (t as DelegationInfo).ZZSCSPWH = dr["ZZSCSPWH"].ToString();
                                #endregion
                                (t as DelegationInfo).OpRoyaltyLv = string.IsNullOrWhiteSpace(dr["OpRoyaltyLv"].ToString()) ? 0 : Convert.ToInt32(dr["OpRoyaltyLv"].ToString());
                                (t as DelegationInfo).OpRoyaltyRemark = dr["OpRoyaltyRemark"].ToString();
                                break;
                            case "HotelReservations":
                                (t as HotelReservations).Id = Convert.ToInt32(dr["Id"]);
                                (t as HotelReservations).DIId = Convert.ToInt32(dr["DIId"]);
                                (t as HotelReservations).GTId = Convert.ToInt32(dr["GTId"]);
                                (t as HotelReservations).CheckNumber = dr["CheckNumber"].ToString();
                                (t as HotelReservations).ReservationsWebsite = Convert.ToInt32(dr["ReservationsWebsite"]);
                                (t as HotelReservations).ReservationsNo = dr["ReservationsNo"].ToString();
                                (t as HotelReservations).DetermineNo = dr["DetermineNo"].ToString();
                                (t as HotelReservations).City = dr["City"].ToString();
                                (t as HotelReservations).HotelName = dr["HotelName"].ToString();
                                (t as HotelReservations).HotelAddress = dr["HotelAddress"].ToString();
                                (t as HotelReservations).HotelTel = dr["HotelTel"].ToString();
                                (t as HotelReservations).HotelFax = dr["HotelFax"].ToString();
                                (t as HotelReservations).GuestName = dr["GuestName"].ToString();
                                (t as HotelReservations).CheckInDate = dr["CheckInDate"].ToString();
                                (t as HotelReservations).CheckOutDate = dr["CheckOutDate"].ToString();
                                (t as HotelReservations).Budget = float.Parse(dr["Budget"].ToString());
                                (t as HotelReservations).BudgetCurrency = Convert.ToInt32(dr["BudgetCurrency"]);
                                (t as HotelReservations).SingleRoomCount = Convert.ToInt32(dr["SingleRoomCount"]);
                                (t as HotelReservations).SingleRoomPrice = float.Parse(dr["SingleRoomPrice"].ToString());
                                (t as HotelReservations).DoubleRoomCount = Convert.ToInt32(dr["DoubleRoomCount"]);
                                (t as HotelReservations).DoubleRoomPrice = float.Parse(dr["DoubleRoomPrice"].ToString());
                                (t as HotelReservations).SuiteRoomCount = Convert.ToInt32(dr["SuiteRoomCount"]);
                                (t as HotelReservations).SuiteRoomPrice = float.Parse(dr["SuiteRoomPrice"].ToString());
                                (t as HotelReservations).OtherRoomCount = Convert.ToInt32(dr["OtherRoomCount"]);
                                (t as HotelReservations).OtherRoomPrice = float.Parse(dr["OtherRoomPrice"].ToString());
                                (t as HotelReservations).Commission = float.Parse(dr["Commission"].ToString());
                                (t as HotelReservations).CommissionCurrency = Convert.ToInt32(dr["CommissionCurrency"]);
                                (t as HotelReservations).CommissionMark = Convert.ToInt32(dr["CommissionMark"]);
                                (t as HotelReservations).RoomExplanation = dr["RoomExplanation"].ToString();
                                (t as HotelReservations).Attachment = dr["Attachment"].ToString();
                                (t as HotelReservations).Remark = dr["Remark"].ToString();
                                (t as HotelReservations).CardPrice = float.Parse(dr["CardPrice"].ToString());
                                (t as HotelReservations).IsCardPrice = Convert.ToInt32(dr["IsCardPrice"]);
                                (t as HotelReservations).Operators = Convert.ToInt32(dr["Operator"]);
                                (t as HotelReservations).OperatorsDate = dr["OperatorDate"].ToString();
                                (t as HotelReservations).IsDel = Convert.ToInt32(dr["IsDel"]);
                                (t as HotelReservations).BreakfastPrice = float.Parse(dr["breakfastPrice"].ToString());
                                (t as HotelReservations).Isoppay = Convert.ToInt32(dr["isoppay"]);
                                (t as HotelReservations).cboOne = Convert.ToInt32(dr["cboOne"]);
                                (t as HotelReservations).cboTwo = Convert.ToInt32(dr["cboTwo"]);
                                (t as HotelReservations).cboThree = Convert.ToInt32(dr["cboThree"]);
                                (t as HotelReservations).cboFour = Convert.ToInt32(dr["cboFour"]);
                                (t as HotelReservations).PredictSingleRoom = string.IsNullOrWhiteSpace(dr["PredictSingleRoom"].ToString()) ? 0 : int.Parse(dr["PredictSingleRoom"].ToString());
                                (t as HotelReservations).PredictDoubleRoom = string.IsNullOrWhiteSpace(dr["PredictDoubleRoom"].ToString()) ? 0 : int.Parse(dr["PredictDoubleRoom"].ToString());
                                (t as HotelReservations).PredictSuiteRoom = string.IsNullOrWhiteSpace(dr["PredictSuiteRoom"].ToString()) ? 0 : int.Parse(dr["PredictSuiteRoom"].ToString());
                                (t as HotelReservations).PredictOtherRoom = string.IsNullOrWhiteSpace(dr["PredictOtherRoom"].ToString()) ? 0 : int.Parse(dr["PredictOtherRoom"].ToString());
                                (t as HotelReservations).GovernmentRent = string.IsNullOrWhiteSpace(dr["GovernmentRent"].ToString()) ? 0.00M : Convert.ToDecimal(dr["GovernmentRent"]);
                                (t as HotelReservations).CityTax = string.IsNullOrWhiteSpace(dr["CityTax"].ToString()) ? 0.00M : Convert.ToDecimal(dr["CityTax"].ToString());
                                (t as HotelReservations).CheckType = dr["CheckType"].ToString();
                                break;
                            case "CreditCardPayment":
                                (t as CreditCardPayment).Id = Convert.ToInt32(dr["Id"]);
                                (t as CreditCardPayment).PayDId = Convert.ToInt32(dr["PayDId"]);
                                (t as CreditCardPayment).ConsumptionPatterns = dr["ConsumptionPatterns"].ToString();
                                (t as CreditCardPayment).ConsumptionDate = dr["ConsumptionDate"].ToString();
                                (t as CreditCardPayment).CTDId = Convert.ToInt32(dr["CTDId"]);
                                (t as CreditCardPayment).BankNo = dr["BankNo"].ToString();
                                (t as CreditCardPayment).CardholderName = dr["CardholderName"].ToString();
                                (t as CreditCardPayment).PayMoney = float.Parse(dr["PayMoney"].ToString());
                                (t as CreditCardPayment).PaymentCurrency = Convert.ToInt32(dr["PaymentCurrency"]);
                                (t as CreditCardPayment).DayRate = dr["DayRate"].ToString();
                                (t as CreditCardPayment).CompanyBankNo = dr["CompanyBankNo"].ToString();
                                (t as CreditCardPayment).OtherBankName = dr["OtherBankName"].ToString();
                                (t as CreditCardPayment).OtherSideNo = dr["OtherSideNo"].ToString();
                                (t as CreditCardPayment).OtherSideName = dr["OtherSideName"].ToString();
                                (t as CreditCardPayment).Remark = dr["Remark"].ToString();
                                (t as CreditCardPayment).Operators = Convert.ToInt32(dr["Operator"]);
                                (t as CreditCardPayment).OperatorsDate = dr["OperatorDate"].ToString();
                                (t as CreditCardPayment).MFOperators = Convert.ToInt32(dr["MFOperator"]);
                                (t as CreditCardPayment).MFOperatorsDate = dr["MFOperatorDate"].ToString();
                                (t as CreditCardPayment).IsAuditDM = Convert.ToInt32(dr["IsAuditDM"]);
                                (t as CreditCardPayment).AuditDMOperate = Convert.ToInt32(dr["AuditDMOperate"]);
                                (t as CreditCardPayment).AuditDMDate = dr["AuditDMDate"].ToString();
                                (t as CreditCardPayment).IsAuditMF = Convert.ToInt32(dr["IsAuditMF"]);
                                (t as CreditCardPayment).AuditMFOperate = Convert.ToInt32(dr["AuditMFOperate"]);
                                (t as CreditCardPayment).AuditMFDate = dr["AuditMFDate"].ToString();
                                (t as CreditCardPayment).IsAuditGM = Convert.ToInt32(dr["IsAuditGM"]);
                                (t as CreditCardPayment).AuditGMOperate = Convert.ToInt32(dr["AuditGMOperate"]);
                                (t as CreditCardPayment).AuditGMDate = dr["AuditGMDate"].ToString();
                                (t as CreditCardPayment).IsPay = Convert.ToInt32(dr["IsPay"]);
                                (t as CreditCardPayment).DIId = Convert.ToInt32(dr["DIId"]);
                                (t as CreditCardPayment).CId = Convert.ToInt32(dr["CId"]);
                                (t as CreditCardPayment).CTable = Convert.ToInt32(dr["CTable"]);
                                (t as CreditCardPayment).IsDel = Convert.ToInt32(dr["IsDel"]);
                                (t as CreditCardPayment).PayPercentage = dr["PayPercentage"].ToString();
                                (t as CreditCardPayment).PayThenMoney = dr["PayThenMoney"].ToString();
                                (t as CreditCardPayment).PayThenMoneyOld = dr["PayThenMoneyOld"].ToString();
                                (t as CreditCardPayment).PayPercentageOld = dr["PayPercentageOld"].ToString();
                                (t as CreditCardPayment).UpdateDate = dr["UpdateDate"].ToString();
                                (t as CreditCardPayment).Payee = dr["Payee"].ToString();
                                try { (t as CreditCardPayment).RMBPrice = float.Parse(dr["RMBPrice"].ToString()); }
                                catch { (t as CreditCardPayment).RMBPrice = 0.00f; }
                                (t as CreditCardPayment).OrbitalPrivateTransfer = dr["OrbitalPrivateTransfer"].ToString();
                                (t as CreditCardPayment).ExceedBudget = float.Parse(dr["ExceedBudget"].ToString());
                                (t as CreditCardPayment).IsMatchCreditCard = int.Parse(dr["IsMatchCreditCard"].ToString());
                                break;
                            case "InvitationOfficialActivities":
                                (t as InvitationOfficialActivities).Id = Convert.ToInt32(dr["Id"]);
                                (t as InvitationOfficialActivities).DIId = Convert.ToInt32(dr["DIId"]);
                                (t as InvitationOfficialActivities).InviterArea = dr["InviterArea"].ToString();
                                (t as InvitationOfficialActivities).Inviter = dr["Inviter"].ToString();
                                (t as InvitationOfficialActivities).InviteTime = dr["InviteTime"].ToString();
                                (t as InvitationOfficialActivities).Attachment = dr["Attachment"].ToString();
                                (t as InvitationOfficialActivities).InviteCosts = float.Parse(dr["InviteCosts"].ToString());
                                (t as InvitationOfficialActivities).Currency = Convert.ToInt32(dr["Currency"]);
                                (t as InvitationOfficialActivities).SendCost = float.Parse(dr["SendCost"].ToString());
                                (t as InvitationOfficialActivities).IsGoOfficaiaBussiness = Convert.ToInt32(dr["IsGoOfficialBusiness"]);
                                (t as InvitationOfficialActivities).Remark = dr["Remark"].ToString();
                                (t as InvitationOfficialActivities).Operators = Convert.ToInt32(dr["Operator"]);
                                (t as InvitationOfficialActivities).OperatorsDate = dr["OperatorDate"].ToString();
                                (t as InvitationOfficialActivities).IsDel = Convert.ToInt32(dr["IsDel"]);
                                (t as InvitationOfficialActivities).EventsCost = string.IsNullOrWhiteSpace(dr["EventsCost"].ToString()) ? 0.00F : float.Parse(dr["EventsCost"].ToString());
                                (t as InvitationOfficialActivities).TranslateCost = string.IsNullOrWhiteSpace(dr["TranslateCost"].ToString()) ? 0.00F : float.Parse(dr["TranslateCost"].ToString());
                                (t as InvitationOfficialActivities).SendCurrency = string.IsNullOrWhiteSpace(dr["SendCurrency"].ToString()) ? 0 : Convert.ToInt32(dr["SendCurrency"]);
                                (t as InvitationOfficialActivities).EventsCurrency = string.IsNullOrWhiteSpace(dr["EventsCurrency"].ToString()) ? 0 : Convert.ToInt32(dr["EventsCurrency"]);
                                (t as InvitationOfficialActivities).TranslateCurrency = string.IsNullOrWhiteSpace(dr["TranslateCurrency"].ToString()) ? 0 : Convert.ToInt32(dr["TranslateCurrency"]);
                                break;
                            case "CarTouristGuideGroundReservations":
                                (t as CarTouristGuideGroundReservations).Id = Convert.ToInt32(dr["Id"]);
                                (t as CarTouristGuideGroundReservations).DIId = Convert.ToInt32(dr["DIId"]);
                                (t as CarTouristGuideGroundReservations).Area = dr["Area"].ToString();
                                (t as CarTouristGuideGroundReservations).ServiceCompany = dr["ServiceCompany"].ToString();
                                (t as CarTouristGuideGroundReservations).ServiceGuide = dr["ServiceGuide"].ToString();
                                (t as CarTouristGuideGroundReservations).ServiceTel = dr["ServiceTel"].ToString();
                                (t as CarTouristGuideGroundReservations).BusName = dr["BusName"].ToString();
                                (t as CarTouristGuideGroundReservations).BusDescription = dr["BusDescription"].ToString();
                                (t as CarTouristGuideGroundReservations).BusTel = (dr["BusTel"].ToString());
                                (t as CarTouristGuideGroundReservations).ServiceStartTime = dr["ServiceStartTime"].ToString();
                                (t as CarTouristGuideGroundReservations).ServiceEndTime = dr["ServiceEndTime"].ToString();
                                (t as CarTouristGuideGroundReservations).ServiceDescription = dr["ServiceDescription"].ToString();
                                (t as CarTouristGuideGroundReservations).ServiceQuotedPrice = float.Parse(dr["ServiceQuotedPrice"].ToString());
                                (t as CarTouristGuideGroundReservations).CId = Convert.ToInt32(dr["CId"]);
                                (t as CarTouristGuideGroundReservations).QuotedPriceExplanation = dr["QuotedPriceExplanation"].ToString();
                                (t as CarTouristGuideGroundReservations).Remark = dr["Remark"].ToString();
                                (t as CarTouristGuideGroundReservations).Operators = Convert.ToInt32(dr["Operator"]);
                                (t as CarTouristGuideGroundReservations).OperatorsDate = dr["OperatorDate"].ToString();
                                (t as CarTouristGuideGroundReservations).IsDel = Convert.ToInt32(dr["IsDel"]);
                                (t as CarTouristGuideGroundReservations).OrbitalPrivateTransfer = Convert.ToInt32(dr["OrbitalPrivateTransfer"]);
                               
                                break;
                            case "CarTouristGuideGroundReservationsContent":
                                (t as CarTouristGuideGroundReservationsContent).Id = Convert.ToInt32(dr["Id"]);
                                (t as CarTouristGuideGroundReservationsContent).DIId = Convert.ToInt32(dr["DIId"]);
                                (t as CarTouristGuideGroundReservationsContent).CTGGRId = Convert.ToInt32(dr["CTGGRId"]);
                                (t as CarTouristGuideGroundReservationsContent).SId = Convert.ToInt32(dr["SId"]);
                                (t as CarTouristGuideGroundReservationsContent).Price = float.Parse(dr["Price"].ToString());
                                (t as CarTouristGuideGroundReservationsContent).Currency = Convert.ToInt32(dr["Currency"]);
                                (t as CarTouristGuideGroundReservationsContent).PriceContent = (dr["PriceContent"].ToString());
                                (t as CarTouristGuideGroundReservationsContent).Remark = dr["Remark"].ToString();
                                (t as CarTouristGuideGroundReservationsContent).Operators = Convert.ToInt32(dr["Operator"]);
                                (t as CarTouristGuideGroundReservationsContent).OperatorsDate = dr["OperatorDate"].ToString();
                                (t as CarTouristGuideGroundReservationsContent).IsDel = Convert.ToInt32(dr["IsDel"]);
                                break;
                            case "Visa":
                                (t as Visa).Id = Convert.ToInt32(dr["Id"]);
                                (t as Visa).DIId = Convert.ToInt32(dr["DIId"]);
                                (t as Visa).VisaClient = dr["VisaClient"].ToString();
                                (t as Visa).VisaPrice = float.Parse(dr["VisaPrice"].ToString());
                                (t as Visa).VisaCurrency = Convert.ToInt32(dr["VisaCurrency"]);
                                (t as Visa).IsThird = Convert.ToInt32(dr["IsThird"]);
                                (t as Visa).VisaAttachment = dr["VisaAttachment"].ToString();
                                (t as Visa).Remark = dr["Remark"].ToString();
                                (t as Visa).Operators = Convert.ToInt32(dr["Operator"]);
                                (t as Visa).OperatorsDate = dr["OperatorDate"].ToString();
                                (t as Visa).IsDel = Convert.ToInt32(dr["IsDel"]);

                                (t as Visa).PassengerType = dr["PassengerType"].ToString();
                                (t as Visa).VisaNumber = Convert.ToInt32(dr["VisaNumber"]);
                                (t as Visa).VisaFreeNumber = Convert.ToInt32(dr["VisaFreeNumber"]);

                                break;
                            case "GroupsCustomers":
                                (t as GroupsCustomers).Id = Convert.ToInt32(dr["Id"]);
                                (t as GroupsCustomers).DIId = Convert.ToInt32(dr["DIId"]);
                                (t as GroupsCustomers).ClientName = dr["ClientName"].ToString();
                                (t as GroupsCustomers).InsuranceCosts = float.Parse(dr["InsuranceCosts"].ToString());
                                (t as GroupsCustomers).Currency = Convert.ToInt32(dr["Currency"]);
                                (t as GroupsCustomers).Attachment = dr["Attachment"].ToString();
                                (t as GroupsCustomers).Remark = dr["Remark"].ToString();
                                (t as GroupsCustomers).Operators = Convert.ToInt32(dr["Operator"]);
                                (t as GroupsCustomers).OperatorsDate = dr["OperatorDate"].ToString();
                                (t as GroupsCustomers).IsDel = Convert.ToInt32(dr["IsDel"]);
                                (t as GroupsCustomers).Iid = Convert.ToInt32(dr["Iid"]);
                                break;
                            case "Stroke":
                                (t as Stroke).Id = Convert.ToInt32(dr["Id"]);
                                (t as Stroke).DIId = Convert.ToInt32(dr["DIId"]);
                                (t as Stroke).StrokeName = dr["StrokeName"].ToString();
                                (t as Stroke).WayCity = dr["WayCity"].ToString();
                                (t as Stroke).Days = Convert.ToInt32(dr["Days"]);
                                (t as Stroke).PNumber = Convert.ToInt32(dr["PNumber"]);
                                (t as Stroke).Remark = dr["Remark"].ToString();
                                (t as Stroke).Operators = Convert.ToInt32(dr["Operator"]);
                                (t as Stroke).OperatorsDate = dr["OperatorDate"].ToString();
                                (t as Stroke).IsDel = Convert.ToInt32(dr["IsDel"]);
                                break;
                            case "StrokeContent":
                                (t as StrokeContent).Id = Convert.ToInt32(dr["Id"]);
                                (t as StrokeContent).SId = Convert.ToInt32(dr["SId"]);
                                (t as StrokeContent).Date = dr["Date"].ToString();
                                (t as StrokeContent).CityRange = dr["CityRange"].ToString();
                                (t as StrokeContent).Traffic = dr["Traffic"].ToString();
                                (t as StrokeContent).Content = dr["Content"].ToString();
                                (t as StrokeContent).Point = Convert.ToInt32(dr["Point"]);
                                break;
                            case "GroupsTaskAssignment":
                                (t as GroupsTaskAssignment).Id = Convert.ToInt32(dr["Id"]);
                                (t as GroupsTaskAssignment).DIId = Convert.ToInt32(dr["DIId"]);
                                (t as GroupsTaskAssignment).CTId = Convert.ToInt32(dr["CTId"]);
                                (t as GroupsTaskAssignment).UId = Convert.ToInt32(dr["UId"]);
                                (t as GroupsTaskAssignment).IsEnable = Convert.ToInt32(dr["IsEnable"]);
                                (t as GroupsTaskAssignment).Operators = Convert.ToInt32(dr["Operator"]);
                                (t as GroupsTaskAssignment).OperatorsDate = dr["OperatorDate"].ToString();
                                break;
                            case "AirTicketReservations":
                                (t as AirTicketReservations).Id = Convert.ToInt32(dr["Id"]);
                                (t as AirTicketReservations).DIId = Convert.ToInt32(dr["DIId"]);
                                (t as AirTicketReservations).FlightsCode = dr["FlightsCode"].ToString();
                                (t as AirTicketReservations).FlightsDate = dr["FlightsDate"].ToString();
                                (t as AirTicketReservations).FlightsTime = dr["FlightsTime"].ToString();
                                (t as AirTicketReservations).ArrivedTime = dr["ArrivedTime"].ToString();
                                (t as AirTicketReservations).IsCheckIn = dr["IsCheckIn"].ToString();
                                (t as AirTicketReservations).IsSetSeat = dr["IsSetSeat"].ToString();
                                (t as AirTicketReservations).IsPackage = dr["IsPackage"].ToString();
                                (t as AirTicketReservations).IsBagHandle = dr["IsBagHandle"].ToString();
                                (t as AirTicketReservations).IsTrain = dr["IsTrain"].ToString();
                                (t as AirTicketReservations).FlightsCity = dr["FlightsCity"].ToString();
                                (t as AirTicketReservations).LeaveDescription = dr["LeaveDescription"].ToString();
                                (t as AirTicketReservations).FlightsDescription = dr["FlightsDescription"].ToString();
                                (t as AirTicketReservations).ReturnDescription = dr["ReturnDescription"].ToString();
                                (t as AirTicketReservations).ClientNum = Convert.ToInt32(dr["ClientNum"]);
                                (t as AirTicketReservations).ClientName = dr["ClientName"].ToString();
                                (t as AirTicketReservations).PrePrice = float.Parse(dr["PrePrice"].ToString());
                                (t as AirTicketReservations).PreCurrency = Convert.ToInt32(dr["PreCurrency"]);
                                (t as AirTicketReservations).Price = float.Parse(dr["Price"].ToString());
                                (t as AirTicketReservations).Currency = Convert.ToInt32(dr["Currency"]);
                                (t as AirTicketReservations).PriceDescription = dr["PriceDescription"].ToString();
                                (t as AirTicketReservations).TicketNumber = dr["TicketNumber"].ToString();
                                (t as AirTicketReservations).TicketCode = dr["TicketCode"].ToString();
                                (t as AirTicketReservations).Remark = dr["Remark"].ToString();
                                (t as AirTicketReservations).Operators = Convert.ToInt32(dr["Operator"]);
                                (t as AirTicketReservations).OperatorsDate = dr["OperatorDate"].ToString();
                                (t as AirTicketReservations).IsDel = Convert.ToInt32(dr["IsDel"]);
                                (t as AirTicketReservations).CType = Convert.ToInt32(dr["CType"]);
                                (t as AirTicketReservations).PassengerType = dr["PassengerType"].ToString();
                                break;
                            case "GroupsDecreasePayments":
                                (t as GroupsDecreasePayments).Id = Convert.ToInt32(dr["Id"]);
                                (t as GroupsDecreasePayments).DIID = Convert.ToInt32(dr["DIID"]);
                                (t as GroupsDecreasePayments).PriceName = dr["PriceName"].ToString();
                                (t as GroupsDecreasePayments).Price = float.Parse(dr["Price"].ToString());
                                (t as GroupsDecreasePayments).Currency = Convert.ToInt32(dr["Currency"]);
                                (t as GroupsDecreasePayments).FilePath = dr["FilePath"].ToString();
                                (t as GroupsDecreasePayments).Remark = dr["Remark"].ToString();
                                (t as GroupsDecreasePayments).Operators = Convert.ToInt32(dr["Operator"]);
                                (t as GroupsDecreasePayments).OperatorsDate = dr["OperatorDate"].ToString();
                                (t as GroupsDecreasePayments).IsDel = Convert.ToInt32(dr["IsDel"]);
                                (t as GroupsDecreasePayments).PriceType = string.IsNullOrWhiteSpace(dr["PriceType"].ToString()) ? 0 : int.Parse(dr["PriceType"].ToString());
                                (t as GroupsDecreasePayments).coefficient = string.IsNullOrWhiteSpace(dr["coefficient"].ToString()) ? 0.00M :decimal.Parse(dr["coefficient"].ToString()) ;
                                (t as GroupsDecreasePayments).PriceTypeDetail = string.IsNullOrWhiteSpace(dr["PriceTypeDetail"].ToString()) ? 0 : int.Parse(dr["PriceTypeDetail"].ToString());
                                break;
                            case "ViewHotelPay":
                                (t as ViewHotelPay).City = dr["City"].ToString();
                                (t as ViewHotelPay).HotelName = dr["HotelName"].ToString();
                                (t as ViewHotelPay).Name = dr["Name"].ToString();
                                (t as ViewHotelPay).SingleRoomPrice = float.Parse(dr["SingleRoomPrice"].ToString());
                                (t as ViewHotelPay).SingleRoomCount = Convert.ToInt32(dr["SingleRoomCount"]);
                                (t as ViewHotelPay).DoubleRoomPrice = float.Parse(dr["DoubleRoomPrice"].ToString());
                                (t as ViewHotelPay).DoubleRoomCount = Convert.ToInt32(dr["DoubleRoomCount"]);
                                (t as ViewHotelPay).SuiteRoomPrice = float.Parse(dr["SuiteRoomPrice"].ToString());
                                (t as ViewHotelPay).SuiteRoomCount = Convert.ToInt32(dr["SuiteRoomCount"]);
                                (t as ViewHotelPay).OtherRoomPrice = float.Parse(dr["OtherRoomPrice"].ToString());
                                (t as ViewHotelPay).OtherRoomCount = Convert.ToInt32(dr["OtherRoomCount"]);
                                (t as ViewHotelPay).Commission = float.Parse(dr["Commission"].ToString());
                                (t as ViewHotelPay).Budget = float.Parse(dr["Budget"].ToString());
                                (t as ViewHotelPay).PayMoney = float.Parse(dr["PayMoney"].ToString());
                                (t as ViewHotelPay).Spread = float.Parse(dr["Spread"].ToString());
                                (t as ViewHotelPay).Moneys = float.Parse(dr["Moneys"].ToString());
                                (t as ViewHotelPay).DayRate = dr["DayRate"].ToString();
                                (t as ViewHotelPay).OperatorDate = dr["OperatorDate"].ToString();
                                (t as ViewHotelPay).CheckInDate = dr["CheckInDate"].ToString();
                                (t as ViewHotelPay).CheckOutDate = dr["CheckOutDate"].ToString();
                                (t as ViewHotelPay).IsPay = dr["IsPay"].ToString();
                                (t as ViewHotelPay).Payee = dr["Payee"].ToString();
                                (t as ViewHotelPay).OrbitalPrivateTransfer = dr["OrbitalPrivateTransfer"].ToString();
                                (t as ViewHotelPay).PayDid = dr["PayDid"].ToString();
                                (t as ViewHotelPay).PaydName = dr["PaydName"].ToString();
                                (t as ViewHotelPay).Operator = dr["Operator"].ToString();
                                (t as ViewHotelPay).BreakfasePrice =float.Parse(dr["BreakfasePrice"].ToString());
                                (t as ViewHotelPay).IsMatchCreditCard = int.Parse(dr["IsMatchCreditCard"].ToString());
                                (t as ViewHotelPay).GovernmentRent = string.IsNullOrWhiteSpace(dr["GovernmentRent"].ToString()) ? 0.00M : decimal.Parse(dr["GovernmentRent"].ToString());
                                (t as ViewHotelPay).CityTax = string.IsNullOrWhiteSpace(dr["CityTax"].ToString()) ? 0.00M : decimal.Parse(dr["CityTax"].ToString());
                                (t as ViewHotelPay).CarType=dr["CarType"].ToString();
                                (t as ViewHotelPay).CheckType=dr["CheckType"].ToString();
                                break;
                            case "ViewVisaPay":
                                (t as ViewVisaPay).VisaClient = dr["VisaClient"].ToString();
                                (t as ViewVisaPay).Name = dr["Name"].ToString();
                                (t as ViewVisaPay).Spread = float.Parse(dr["Spread"].ToString());
                                (t as ViewVisaPay).Remark = dr["Remark"].ToString();
                                (t as ViewVisaPay).DayRate = dr["DayRate"].ToString();
                                try
                                { 
                                    (t as ViewVisaPay).RMBPrice = float.Parse(dr["RMBPrice"].ToString());
                                }
                                catch { (t as ViewVisaPay).RMBPrice = 0f; }
                                (t as ViewVisaPay).PayPercentage = dr["PayPercentage"].ToString();
                                (t as ViewVisaPay).PayThenMoney = dr["PayThenMoney"].ToString();
                                (t as ViewVisaPay).OperatorDate = dr["OperatorDate"].ToString();
                                (t as ViewVisaPay).IsPay = dr["IsPay"].ToString();
                                (t as ViewVisaPay).Payee = dr["Payee"].ToString();
                                (t as ViewVisaPay).OrbitalPrivateTransfer = dr["OrbitalPrivateTransfer"].ToString();
                                (t as ViewVisaPay).PayDid = dr["PayDid"].ToString();
                                (t as ViewVisaPay).PaydName = dr["PaydName"].ToString();
                                (t as ViewVisaPay).AuditGMDate = dr["AuditGMDate"].ToString();
                                (t as ViewVisaPay).Operator = dr["Operator"].ToString();
                                (t as ViewVisaPay).ConsumptionPatterns = dr["consumptionPatterns"].ToString();
                                (t as ViewVisaPay).IsMatchCreditCard = int.Parse(dr["IsMatchCreditCard"].ToString());
                                (t as ViewVisaPay).CarType=dr["CarType"].ToString();
                                break;
                            case "ViewInvitationOfficialActivitiesPay":
                                (t as ViewInvitationOfficialActivitiesPay).InviterArea = dr["InviterArea"].ToString();
                                (t as ViewInvitationOfficialActivitiesPay).Inviter = dr["Inviter"].ToString();
                                (t as ViewInvitationOfficialActivitiesPay).InviteTime = dr["InviteTime"].ToString();
                                (t as ViewInvitationOfficialActivitiesPay).Name = dr["Name"].ToString();
                                (t as ViewInvitationOfficialActivitiesPay).InviteCosts = float.Parse(dr["InviteCosts"].ToString());
                                (t as ViewInvitationOfficialActivitiesPay).PayMoney = float.Parse(dr["PayMoney"].ToString());
                                (t as ViewInvitationOfficialActivitiesPay).DayRate = dr["DayRate"].ToString();
                                (t as ViewInvitationOfficialActivitiesPay).Remark = dr["Remark"].ToString();
                                (t as ViewInvitationOfficialActivitiesPay).OperatorDate = dr["OperatorDate"].ToString();
                                try
                                {
                                    (t as ViewInvitationOfficialActivitiesPay).RMBPrice = float.Parse(dr["RMBPrice"].ToString());
                                }
                                catch { (t as ViewInvitationOfficialActivitiesPay).RMBPrice = 0f; }
                                (t as ViewInvitationOfficialActivitiesPay).IsPay = dr["IsPay"].ToString();
                                (t as ViewInvitationOfficialActivitiesPay).Payee = dr["Payee"].ToString();
                                (t as ViewInvitationOfficialActivitiesPay).OrbitalPrivateTransfer = dr["OrbitalPrivateTransfer"].ToString();
                                (t as ViewInvitationOfficialActivitiesPay).PayDid = dr["PayDid"].ToString();
                                (t as ViewInvitationOfficialActivitiesPay).PaydName = dr["PaydName"].ToString();
                                (t as ViewInvitationOfficialActivitiesPay).AuditGMDate = dr["AuditGMDate"].ToString();
                                (t as ViewInvitationOfficialActivitiesPay).Operator = dr["Operator"].ToString();
                                (t as ViewInvitationOfficialActivitiesPay).IsMatchCreditCard = int.Parse(dr["IsMatchCreditCard"].ToString());
                                (t as ViewInvitationOfficialActivitiesPay).SendCost = string.IsNullOrWhiteSpace(dr["SendCost"].ToString()) ? 0.00F : float.Parse(dr["SendCost"].ToString());
                                (t as ViewInvitationOfficialActivitiesPay).EventsCost = string.IsNullOrWhiteSpace(dr["EventsCost"].ToString()) ? 0.00F : float.Parse(dr["EventsCost"].ToString());
                                (t as ViewInvitationOfficialActivitiesPay).TranslateCost = string.IsNullOrWhiteSpace(dr["TranslateCost"].ToString()) ? 0.00F : float.Parse(dr["TranslateCost"].ToString());
                                (t as ViewInvitationOfficialActivitiesPay).SendCurrency = dr["SendCurrency"].ToString();
                                (t as ViewInvitationOfficialActivitiesPay).EventsCurrency = dr["EventsCurrency"].ToString();
                                (t as ViewInvitationOfficialActivitiesPay).TranslateCurrency = dr["TranslateCurrency"].ToString();
                                break;
                            case "ViewAirTicketReservationsPay":
                                (t as ViewAirTicketReservationsPay).FlightsCode = dr["FlightsCode"].ToString();
                                (t as ViewAirTicketReservationsPay).FlightsCity = dr["FlightsCity"].ToString();
                                (t as ViewAirTicketReservationsPay).FlightsDate = dr["FlightsDate"].ToString();
                                (t as ViewAirTicketReservationsPay).FlightsTime = dr["FlightsTime"].ToString();
                                (t as ViewAirTicketReservationsPay).ClientName = dr["ClientName"].ToString();
                                (t as ViewAirTicketReservationsPay).Name = dr["Name"].ToString();
                                (t as ViewAirTicketReservationsPay).Spread = float.Parse(dr["Spread"].ToString());
                                (t as ViewAirTicketReservationsPay).PrePrice = float.Parse(dr["PrePrice"].ToString());
                                (t as ViewAirTicketReservationsPay).Price = string.IsNullOrEmpty(dr["Price"].ToString()) ? 0 : float.Parse(dr["Price"].ToString());
                                (t as ViewAirTicketReservationsPay).DayRate = dr["DayRate"].ToString();
                                (t as ViewAirTicketReservationsPay).PriceDescription = dr["PriceDescription"].ToString();
                                (t as ViewAirTicketReservationsPay).OperatorDate = dr["OperatorDate"].ToString();
                                (t as ViewAirTicketReservationsPay).FlightsDescription = dr["FlightsDescription"].ToString();
                                try
                                {
                                    (t as ViewAirTicketReservationsPay).RMBPrice = float.Parse(dr["RMBPrice"].ToString());
                                }
                                catch
                                {
                                    (t as ViewAirTicketReservationsPay).RMBPrice = float.Parse(dr["Spread"].ToString()) * float.Parse(dr["DayRate"].ToString());
                                }
                                (t as ViewAirTicketReservationsPay).IsPay = dr["IsPay"].ToString();
                                (t as ViewAirTicketReservationsPay).Payee = dr["Payee"].ToString();
                                (t as ViewAirTicketReservationsPay).OrbitalPrivateTransfer = dr["OrbitalPrivateTransfer"].ToString();
                                (t as ViewAirTicketReservationsPay).PayDid = dr["PayDid"].ToString();
                                (t as ViewAirTicketReservationsPay).PaydName = dr["PaydName"].ToString();
                                (t as ViewAirTicketReservationsPay).AuditGMDate = dr["AuditGMDate"].ToString();
                                (t as ViewAirTicketReservationsPay).Operator = dr["Operator"].ToString();
                                (t as ViewAirTicketReservationsPay).ConsumptionDate = dr["ConsumptionDate"].ToString();
                                (t as ViewAirTicketReservationsPay).CTDId = dr["CTDId"].ToString();
                                (t as ViewAirTicketReservationsPay).CType = dr["CType"].ToString();
                                (t as ViewAirTicketReservationsPay).ArrivedTime = dr["ArrivedTime"].ToString();
                                (t as ViewAirTicketReservationsPay).ClientNum = Convert.ToInt32(dr["ClientNum"]);
                                (t as ViewAirTicketReservationsPay).IsMatchCreditCard = int.Parse(dr["IsMatchCreditCard"].ToString());
                                try
                                {(t as ViewAirTicketReservationsPay).CarType = dr["CarType"].ToString();}
                                catch (Exception)
                                { (t as ViewAirTicketReservationsPay).CarType = "无"; }
                               
                                break;
                            case "ViewGroupsCustomersPay":
                                (t as ViewGroupsCustomersPay).ClientName = dr["ClientName"].ToString();
                                (t as ViewGroupsCustomersPay).Name = dr["Name"].ToString();
                                (t as ViewGroupsCustomersPay).Spread = float.Parse(dr["Spread"].ToString());
                                (t as ViewGroupsCustomersPay).Remark = dr["Remark"].ToString();
                                (t as ViewGroupsCustomersPay).OperatorDate = dr["OperatorDate"].ToString();
                                (t as ViewGroupsCustomersPay).IsPay = dr["IsPay"].ToString();
                                (t as ViewGroupsCustomersPay).Payee = dr["Payee"].ToString();
                                (t as ViewGroupsCustomersPay).OrbitalPrivateTransfer = dr["OrbitalPrivateTransfer"].ToString();
                                (t as ViewGroupsCustomersPay).PayDid = dr["PayDid"].ToString();
                                (t as ViewGroupsCustomersPay).PaydName = dr["PaydName"].ToString();
                                (t as ViewGroupsCustomersPay).AuditGMDate = dr["AuditGMDate"].ToString();
                                (t as ViewGroupsCustomersPay).Operator = dr["Operator"].ToString();
                                (t as ViewGroupsCustomersPay).IsMatchCreditCard = int.Parse(dr["IsMatchCreditCard"].ToString());
                                break;
                            case "ViewGroundPay":
                                (t as ViewGroundPay).Area = dr["Area"].ToString();
                                (t as ViewGroundPay).PriceType = dr["PriceType"].ToString();
                                (t as ViewGroundPay).Price = float.Parse(dr["Price"].ToString());
                                (t as ViewGroundPay).Currency = dr["Currency"].ToString();
                                (t as ViewGroundPay).PriceContent = dr["PriceContent"].ToString();
                                (t as ViewGroundPay).Remark = dr["Remark"].ToString();
                                (t as ViewGroundPay).OperatorDate = dr["OperatorDate"].ToString();
                                (t as ViewGroundPay).IsPay = dr["IsPay"].ToString();
                                (t as ViewGroundPay).Payee = dr["Payee"].ToString();
                                (t as ViewGroundPay).OrbitalPrivateTransfer = dr["OrbitalPrivateTransfer"].ToString();
                                (t as ViewGroundPay).PayDid = dr["PayDid"].ToString();
                                (t as ViewGroundPay).PaydName = dr["PaydName"].ToString();
                                (t as ViewGroundPay).AuditGMDate = dr["AuditGMDate"].ToString();
                                (t as ViewGroundPay).Operator = dr["Operator"].ToString();
                                (t as ViewGroundPay).IsMatchCreditCard = int.Parse(dr["IsMatchCreditCard"].ToString());
                                (t as ViewGroundPay).PayPercentage = Convert.ToDecimal(dr["PayPercentage"].ToString());
                                (t as ViewGroundPay).CarType = dr["CarType"].ToString();
                                break;
                            case "ViewGroupsDecreasePayments":
                                (t as ViewGroupsDecreasePayments).PriceName = dr["PriceName"].ToString();
                                (t as ViewGroupsDecreasePayments).Price = float.Parse(dr["Price"].ToString());
                                (t as ViewGroupsDecreasePayments).Name = dr["Name"].ToString();
                                (t as ViewGroupsDecreasePayments).Spread = float.Parse(dr["Spread"].ToString());
                                (t as ViewGroupsDecreasePayments).DayRate = dr["DayRate"].ToString();
                                (t as ViewGroupsDecreasePayments).Remark = dr["Remark"].ToString();
                                try
                                {
                                    (t as ViewGroupsDecreasePayments).RMBPrice = float.Parse(dr["RMBPrice"].ToString());
                                }
                                catch { (t as ViewGroupsDecreasePayments).RMBPrice = 0f; }
                                (t as ViewGroupsDecreasePayments).OperatorDate = dr["OperatorDate"].ToString();
                                (t as ViewGroupsDecreasePayments).IsPay = dr["IsPay"].ToString();
                                (t as ViewGroupsDecreasePayments).Payee = dr["Payee"].ToString();
                                (t as ViewGroupsDecreasePayments).OrbitalPrivateTransfer = dr["OrbitalPrivateTransfer"].ToString();
                                (t as ViewGroupsDecreasePayments).PayDid = dr["PayDid"].ToString();
                                (t as ViewGroupsDecreasePayments).PaydName = dr["PaydName"].ToString();
                                (t as ViewGroupsDecreasePayments).AuditGMDate = dr["AuditGMDate"].ToString();
                                (t as ViewGroupsDecreasePayments).Operator = dr["Operator"].ToString();
                                (t as ViewGroupsDecreasePayments).IsMatchCreditCard = int.Parse(dr["IsMatchCreditCard"].ToString());
                                (t as ViewGroupsDecreasePayments).PriceType = string.IsNullOrEmpty(dr["PriceType"].ToString()) ? 0 : int.Parse(dr["PriceType"].ToString()) ;
                                (t as ViewGroupsDecreasePayments).Coefficient = string.IsNullOrEmpty(dr["coefficient"].ToString()) ? 0.00M : decimal.Parse(dr["coefficient"].ToString());
                                break;
                            case "ViewGroudCitySumPrice":
                                (t as ViewGroudCitySumPrice).Area = dr["Area"].ToString();
                                (t as ViewGroudCitySumPrice).SumPrice = float.Parse(dr["SumPrice"].ToString());
                                (t as ViewGroudCitySumPrice).Currency = dr["Currency"].ToString();
                                (t as ViewGroudCitySumPrice).PayMoney = float.Parse(dr["PayMoney"].ToString());
                                (t as ViewGroudCitySumPrice).DayRate = dr["DayRate"].ToString();
                                try { (t as ViewGroudCitySumPrice).RMBPrice = float.Parse(dr["RMBPrice"].ToString()); }
                                catch { (t as ViewGroudCitySumPrice).RMBPrice = 0f; }
                                (t as ViewGroudCitySumPrice).PayPercentage = dr["PayPercentage"].ToString();
                                (t as ViewGroudCitySumPrice).PayThenMoney = dr["PayThenMoney"].ToString();
                                (t as ViewGroudCitySumPrice).OperatorDate = dr["OperatorDate"].ToString();
                                break;
                            case "DailyFeePayment":
                                (t as DailyFeePayment).Id = Convert.ToInt32(dr["Id"]);
                                (t as DailyFeePayment).Instructions = dr["Instructions"].ToString();
                                (t as DailyFeePayment).SumPrice = float.Parse(dr["SumPrice"].ToString());
                                (t as DailyFeePayment).Operators = Convert.ToInt32(dr["Operator"]);
                                (t as DailyFeePayment).OperatorsDate = dr["OperatorDate"].ToString();
                                (t as DailyFeePayment).FAudit = Convert.ToInt32(dr["FAudit"]);
                                (t as DailyFeePayment).FAuditDate = dr["FAuditDate"].ToString();
                                (t as DailyFeePayment).MAudit = Convert.ToInt32(dr["MAudit"]);
                                (t as DailyFeePayment).MAuditDate = dr["MAuditDate"].ToString();
                                (t as DailyFeePayment).Reason = dr["Reason"].ToString();
                                (t as DailyFeePayment).IsDel = Convert.ToInt32(dr["IsDel"]);
                                (t as DailyFeePayment).IsPay = Convert.ToInt32(dr["IsPay"]);
                                (t as DailyFeePayment).OrbitalPrivateTransfer = Convert.ToInt32(dr["OrbitalPrivateTransfer"]);
                                (t as DailyFeePayment).PriceType = Convert.ToInt32(dr["PriceType"]);
                                (t as DailyFeePayment).CId = Convert.ToInt32(dr["CId"]);
                                (t as DailyFeePayment).CName = dr["CName"].ToString();
                                (t as DailyFeePayment).RAudit = Convert.ToInt32(dr["RAudit"]);
                                (t as DailyFeePayment).RAuditDate = dr["RAuditDate"].ToString();
                                (t as DailyFeePayment).AuditOperator = Convert.ToInt32(dr["AuditOperator"]);
                                break;
                            case "DailyFeePaymentDesc":
                                (t as DailyFeePaymentDesc).Id = Convert.ToInt32(dr["Id"]);
                                (t as DailyFeePaymentDesc).Instructions = dr["Instructions"].ToString();
                                (t as DailyFeePaymentDesc).SumPrice = float.Parse(dr["SumPrice"].ToString());
                                (t as DailyFeePaymentDesc).Operators = Convert.ToInt32(dr["Operator"]);
                                (t as DailyFeePaymentDesc).OperatorsDate = dr["OperatorDate"].ToString();
                                (t as DailyFeePaymentDesc).FAudit = Convert.ToInt32(dr["FAudit"]);
                                (t as DailyFeePaymentDesc).FAuditDate = dr["FAuditDate"].ToString();
                                (t as DailyFeePaymentDesc).MAudit = Convert.ToInt32(dr["MAudit"]);
                                (t as DailyFeePaymentDesc).MAuditDate = dr["MAuditDate"].ToString();
                                (t as DailyFeePaymentDesc).Reason = dr["Reason"].ToString();
                                (t as DailyFeePaymentDesc).IsDel = Convert.ToInt32(dr["IsDel"]);
                                (t as DailyFeePaymentDesc).IsPay = Convert.ToInt32(dr["IsPay"]);
                                (t as DailyFeePaymentDesc).OrbitalPrivateTransfer = Convert.ToInt32(dr["OrbitalPrivateTransfer"]);
                                (t as DailyFeePaymentDesc).PriceType = Convert.ToInt32(dr["PriceType"]);
                                (t as DailyFeePaymentDesc).CId = Convert.ToInt32(dr["CId"]);
                                (t as DailyFeePaymentDesc).CName = dr["CName"].ToString();
                                (t as DailyFeePaymentDesc).RAudit = Convert.ToInt32(dr["RAudit"]);
                                (t as DailyFeePaymentDesc).RAuditDate = dr["RAuditDate"].ToString();
                                (t as DailyFeePaymentDesc).AuditOperator = Convert.ToInt32(dr["AuditOperator"]);
                                (t as DailyFeePaymentDesc).RowNumber = Convert.ToInt32(dr["RowNumber"]);
                                break;
                            case "CountData":
                                (t as CountData).Count = Convert.ToInt32(dr["Count"]);
                                break;
                            case "DailyFeePaymentContent":
                                (t as DailyFeePaymentContent).Id = Convert.ToInt32(dr["Id"]);
                                (t as DailyFeePaymentContent).DFPID = Convert.ToInt32(dr["DFPID"]);
                                (t as DailyFeePaymentContent).PriceName = dr["PriceName"].ToString();
                                (t as DailyFeePaymentContent).Count = float.Parse(dr["Count"].ToString());
                                (t as DailyFeePaymentContent).Price = float.Parse(dr["Price"].ToString());
                                (t as DailyFeePaymentContent).ItemSumPrice = float.Parse(dr["ItemSumPrice"].ToString());
                                (t as DailyFeePaymentContent).Remark = dr["Remark"].ToString();
                                break;
                            case "ViewDailyFeePayment":
                                (t as ViewDailyFeePayment).PriceName = dr["PriceName"].ToString();
                                (t as ViewDailyFeePayment).Count = Convert.ToInt32(dr["Count"]);
                                (t as ViewDailyFeePayment).Price = float.Parse(dr["Price"].ToString());
                                (t as ViewDailyFeePayment).ItemSumPrice = float.Parse(dr["ItemSumPrice"].ToString());
                                (t as ViewDailyFeePayment).Remark = dr["Remark"].ToString();
                                break;
                            case "ForeignReceivables":
                                (t as ForeignReceivables).Id = Convert.ToInt32(dr["Id"]);
                                (t as ForeignReceivables).DIId = Convert.ToInt32(dr["DIId"]);
                                (t as ForeignReceivables).PriceName = dr["PriceName"].ToString();
                                (t as ForeignReceivables).Price = decimal.Parse(dr["Price"].ToString());
                                (t as ForeignReceivables).Count = float.Parse(dr["Count"].ToString());
                                (t as ForeignReceivables).Unit = dr["Unit"].ToString();
                                (t as ForeignReceivables).ItemSumPrice = decimal.Parse(dr["ItemSumPrice"].ToString());
                                (t as ForeignReceivables).To = dr["To"].ToString();
                                (t as ForeignReceivables).ToTel = dr["ToTel"].ToString();
                                (t as ForeignReceivables).PayDate = dr["PayDate"].ToString();
                                (t as ForeignReceivables).Attention = dr["Attention"].ToString();
                                (t as ForeignReceivables).Operators = Convert.ToInt32(dr["Operator"]);
                                (t as ForeignReceivables).OperatorsDate = dr["OperatorDate"].ToString();
                                (t as ForeignReceivables).IsDel = Convert.ToInt32(dr["IsDel"]);
                                try
                                {
                                    (t as ForeignReceivables).Rate = Convert.ToDecimal(dr["Rate"]);
                                }
                                catch
                                {
                                    (t as ForeignReceivables).Rate = 1;
                                }
                                (t as ForeignReceivables).Currency = dr["Currency"].ToString();

                                (t as ForeignReceivables).AddingWay = Convert.ToInt32(dr["AddingWay"]);
                                break;
                            case "Wage":
                                (t as Wage).Id = Convert.ToInt32(dr["Id"]);
                                (t as Wage).YearMonth = dr["YearMonth"].ToString();
                                (t as Wage).UserId = Convert.ToInt32(dr["UserId"]);
                                (t as Wage).StartDate = dr["StartDate"].ToString();
                                (t as Wage).EndDate = dr["EndDate"].ToString();
                                (t as Wage).Basic = float.Parse(dr["Basic"].ToString());
                                (t as Wage).Floats = float.Parse(dr["Floats"].ToString());
                                (t as Wage).PostAllowance = float.Parse(dr["PostAllowance"].ToString());
                                (t as Wage).GarmentWashSubsidies = float.Parse(dr["GarmentWashSubsidies"].ToString());
                                (t as Wage).CommunicationSubsidies = float.Parse(dr["CommunicationSubsidies"].ToString());
                                (t as Wage).TrafficSubsidies = float.Parse(dr["TrafficSubsidies"].ToString());
                                (t as Wage).InformationSecurityFee = float.Parse(dr["InformationSecurityFee"].ToString());
                                (t as Wage).OperationBonus = float.Parse(dr["OperationBonus"].ToString());
                                (t as Wage).SpecialAllowance = float.Parse(dr["SpecialAllowance"].ToString());
                                (t as Wage).OtherSubsidies = float.Parse(dr["OtherSubsidies"].ToString());
                                (t as Wage).WithholdingInsurance = float.Parse(dr["WithholdingInsurance"].ToString());
                                (t as Wage).SickLeave = float.Parse(dr["SickLeave"].ToString());
                                (t as Wage).SomethingFalse = float.Parse(dr["SomethingFalse"].ToString());
                                (t as Wage).LateTo = float.Parse(dr["LateTo"].ToString());
                                (t as Wage).LeaveEarly = float.Parse(dr["LeaveEarly"].ToString());
                                (t as Wage).Absenteeism = float.Parse(dr["Absenteeism"].ToString());
                                (t as Wage).NotPunch = float.Parse(dr["NotPunch"].ToString());
                                (t as Wage).OtherDeductions = float.Parse(dr["OtherDeductions"].ToString());
                                (t as Wage).Should = float.Parse(dr["Should"].ToString());
                                (t as Wage).TotalDeductions = float.Parse(dr["TotalDeductions"].ToString());
                                (t as Wage).TotalRealHair = float.Parse(dr["TotalRealHair"].ToString());
                                (t as Wage).IsLock = Convert.ToInt32(dr["IsLock"]);
                                (t as Wage).Remark = dr["Remark"].ToString();
                                (t as Wage).Operators = Convert.ToInt32(dr["Operator"]);
                                (t as Wage).OperatorsDate = dr["OperatorDate"].ToString();
                                (t as Wage).IsDel = Convert.ToInt32(dr["IsDel"]);
                                (t as Wage).Gongjijin = float.Parse(dr["Gongjijin"].ToString());
                                (t as Wage).GroupCost = float.Parse(dr["GroupCost"].ToString());
                                try
                                {
                                    (t as Wage).Tax = float.Parse(dr["Tax"].ToString());
                                }
                                catch
                                {
                                    (t as Wage).Tax = float.Parse("0.00");
                                }
                                try
                                {
                                    (t as Wage).AfterTax = float.Parse(dr["AfterTax"].ToString());
                                }
                                catch
                                {
                                    (t as Wage).AfterTax = float.Parse("0.00");
                                }
                                try
                                {
                                    (t as Wage).Mealsupplement = float.Parse(dr["Mealsupplement"].ToString());
                                }
                                catch
                                {
                                    (t as Wage).Mealsupplement = 0;
                                }
                                break;
                            case "IncreasePayments":
                                (t as IncreasePayments).Id = Convert.ToInt32(dr["Id"]);
                                (t as IncreasePayments).YearMonths = dr["YearMonth"].ToString();
                                (t as IncreasePayments).UserId = Convert.ToInt32(dr["UserId"]);
                                (t as IncreasePayments).Sid = Convert.ToInt32(dr["Sid"]);
                                (t as IncreasePayments).OccurrenceDate = dr["OccurrenceDate"].ToString();
                                (t as IncreasePayments).Money = float.Parse(dr["Money"].ToString());
                                (t as IncreasePayments).Remark = dr["Remark"].ToString();
                                (t as IncreasePayments).Operators = Convert.ToInt32(dr["Operator"]);
                                (t as IncreasePayments).OperatorsDate = dr["OperatorDate"].ToString();
                                (t as IncreasePayments).IsDel = Convert.ToInt32(dr["IsDel"]);
                                break;
                            case "ViewWageSelectAD":
                                (t as ViewWageSelectAD).SwipeDate = dr["SwipeDate"].ToString();
                                (t as ViewWageSelectAD).UserNumber = dr["UserNumber"].ToString();
                                (t as ViewWageSelectAD).A = dr["A"].ToString();
                                (t as ViewWageSelectAD).B = dr["B"].ToString();
                                (t as ViewWageSelectAD).C = dr["C"].ToString();
                                (t as ViewWageSelectAD).D = dr["D"].ToString();
                                break;
                            case "ViewUpCardAudit":
                                (t as ViewUpCardAudit).Uid = Convert.ToInt32(dr["Uid"]);
                                (t as ViewUpCardAudit).YearMonth = dr["YearMonth"].ToString();
                                (t as ViewUpCardAudit).IsAudit = Convert.ToInt32(dr["IsAudit"]);
                                (t as ViewUpCardAudit).UpcardHours = float.Parse(dr["UpcardHours"].ToString());
                                (t as ViewUpCardAudit).Did = Convert.ToInt32(dr["Did"]);
                                break;
                            case "ViewWage":
                                (t as ViewWage).YearMonth = dr["YearMonth"].ToString();
                                (t as ViewWage).Date = dr["Date"].ToString();
                                (t as ViewWage).UserNumber = dr["UserNumber"].ToString();
                                (t as ViewWage).UserName = dr["UserName"].ToString();
                                (t as ViewWage).Basic = float.Parse(dr["Basic"].ToString()).ToString("#0.00");
                                (t as ViewWage).Floats = float.Parse(dr["Floats"].ToString()).ToString("#0.00");
                                (t as ViewWage).PostAllowance = float.Parse(dr["PostAllowance"].ToString()).ToString("#0.00");
                                (t as ViewWage).GarmentWashSubsidies = float.Parse(dr["GarmentWashSubsidies"].ToString()).ToString("#0.00");
                                (t as ViewWage).CommunicationSubsidies = float.Parse(dr["CommunicationSubsidies"].ToString()).ToString("#0.00");
                                (t as ViewWage).TrafficSubsidies = float.Parse(dr["TrafficSubsidies"].ToString()).ToString("#0.00");
                                (t as ViewWage).InformationSecurityFee = float.Parse(dr["InformationSecurityFee"].ToString()).ToString("#0.00");
                                (t as ViewWage).OperationBonus = float.Parse(dr["OperationBonus"].ToString()).ToString("#0.00");
                                (t as ViewWage).SpecialAllowance = float.Parse(dr["SpecialAllowance"].ToString()).ToString("#0.00");
                                (t as ViewWage).OtherSubsidies = float.Parse(dr["OtherSubsidies"].ToString()).ToString("#0.00");
                                (t as ViewWage).WithholdingInsurance = float.Parse(dr["WithholdingInsurance"].ToString()).ToString("#0.00");
                                (t as ViewWage).SickLeave = float.Parse(dr["SickLeave"].ToString()).ToString("#0.00");
                                (t as ViewWage).SomethingFalse = float.Parse(dr["SomethingFalse"].ToString()).ToString("#0.00");
                                (t as ViewWage).LateTo = float.Parse(dr["LateTo"].ToString()).ToString("#0.00");
                                (t as ViewWage).LeaveEarly = float.Parse(dr["LeaveEarly"].ToString()).ToString("#0.00");
                                (t as ViewWage).Absenteeism = float.Parse(dr["Absenteeism"].ToString()).ToString("#0.00");
                                (t as ViewWage).NotPunch = float.Parse(dr["NotPunch"].ToString()).ToString("#0.00");
                                (t as ViewWage).OtherDeductions = float.Parse(dr["OtherDeductions"].ToString()).ToString("#0.00");
                                (t as ViewWage).Should = float.Parse(dr["Should"].ToString()).ToString("#0.00");
                                (t as ViewWage).TotalDeductions = float.Parse(dr["TotalDeductions"].ToString()).ToString("#0.00");
                                (t as ViewWage).TotalRealHair = float.Parse(dr["TotalRealHair"].ToString()).ToString("#0.00");
                                (t as ViewWage).WriteVal = "";
                                (t as ViewWage).Company = Convert.ToInt32(dr["Company"]);
                                (t as ViewWage).Gongjijin = float.Parse(dr["Gongjijin"].ToString()).ToString("#0.00");
                                (t as ViewWage).GroupCost = float.Parse(dr["GroupCost"].ToString()).ToString("#0.00");

                                try
                                {
                                    (t as ViewWage).Tax = dr["Tax"].ToString();
                                }
                                catch
                                {
                                    (t as ViewWage).Tax = "0.00";
                                }
                                try
                                {
                                    (t as ViewWage).AfterTax = dr["AfterTax"].ToString();
                                }
                                catch
                                {
                                    (t as ViewWage).AfterTax = "0.00";
                                }
                                try
                                {
                                    (t as ViewWage).Mealsupplement = float.Parse(dr["Mealsupplement"].ToString()).ToString("#0.00");
                                }
                                catch
                                {
                                    (t as ViewWage).Mealsupplement = "0.00";
                                }
                                break;
                            case "SalesQuotation":
                                (t as SalesQuotation).Id = Convert.ToInt32(dr["Id"]);
                                (t as SalesQuotation).DIID = Convert.ToInt32(dr["DIID"]);
                                (t as SalesQuotation).PriceDescription = dr["PriceDescription"].ToString();
                                (t as SalesQuotation).Contains = dr["Contains"].ToString();
                                (t as SalesQuotation).NoContains = dr["NoContains"].ToString();
                                (t as SalesQuotation).ExchangeRate = dr["ExchangeRate"].ToString();
                                (t as SalesQuotation).Remark = dr["Remark"].ToString();
                                (t as SalesQuotation).Operators = Convert.ToInt32(dr["Operator"]);
                                (t as SalesQuotation).OperatorsDate = dr["OperatorDate"].ToString();
                                (t as SalesQuotation).IsDel = Convert.ToInt32(dr["IsDel"]);
                                break;
                            case "ViewMyHotelReservations":
                                (t as ViewMyHotelReservations).City = dr["City"].ToString();
                                (t as ViewMyHotelReservations).HotelName = dr["HotelName"].ToString();
                                (t as ViewMyHotelReservations).Date = dr["Date"].ToString();
                                (t as ViewMyHotelReservations).Moneys = dr["Moneys"].ToString();
                                (t as ViewMyHotelReservations).RoomExplanation = dr["RoomExplanation"].ToString();
                                (t as ViewMyHotelReservations).Consumptionpatterns = dr["Consumptionpatterns"].ToString();
                                (t as ViewMyHotelReservations).Name = dr["Name"].ToString();
                                (t as ViewMyHotelReservations).BankNo = dr["BankNo"].ToString();
                                (t as ViewMyHotelReservations).PayMoney = dr["PayMoney"].ToString();
                                (t as ViewMyHotelReservations).PayName = dr["PayName"].ToString();
                                (t as ViewMyHotelReservations).Remark = dr["Remark"].ToString();
                                (t as ViewMyHotelReservations).BudgetCurrency = dr["BudgetCurrency"].ToString();
                                (t as ViewMyHotelReservations).PayMoneys = dr["PayMoneys"].ToString();
                                (t as ViewMyHotelReservations).BookingWebsite = dr["BookingWebsite"].ToString();
                                (t as ViewMyHotelReservations).PayTime = dr["PayTime"].ToString();
                                (t as ViewMyHotelReservations).CardPrice = float.Parse(dr["CardPrice"].ToString());
                                break;
                            case "DailyManagement":
                                (t as DailyManagement).Id = Convert.ToInt32(dr["Id"]);
                                (t as DailyManagement).DailyDate = dr["DailyDate"].ToString();
                                (t as DailyManagement).WorkTitle = dr["WorkTitle"].ToString();
                                (t as DailyManagement).WorkHours = dr["WorkHours"].ToString();
                                (t as DailyManagement).CompletionRate = dr["CompletionRate"].ToString();
                                (t as DailyManagement).WorkContent = dr["WorkContent"].ToString();
                                (t as DailyManagement).UserId = Convert.ToInt32(dr["UserId"]);
                                (t as DailyManagement).Dates = dr["Dates"].ToString();
                                (t as DailyManagement).IsAudit = Convert.ToInt32(dr["IsAudit"]);
                                (t as DailyManagement).AuditUserId = Convert.ToInt32(dr["AuditUserId"]);
                                (t as DailyManagement).AuditDate = dr["AuditDate"].ToString();
                                (t as DailyManagement).IsDel = Convert.ToInt32(dr["IsDel"]);
                                break;
                            case "ProceedsReceived":
                                (t as ProceedsReceived).Id = Convert.ToInt32(dr["Id"]);
                                (t as ProceedsReceived).DIID = Convert.ToInt32(dr["DIID"]);
                                (t as ProceedsReceived).SectionTime = dr["SectionTime"].ToString();
                                (t as ProceedsReceived).Price = decimal.Parse(dr["Price"].ToString());
                                (t as ProceedsReceived).Currency = Convert.ToInt32(dr["Currency"]);
                                (t as ProceedsReceived).ReceivablesType = Convert.ToInt32(dr["ReceivablesType"]);
                                (t as ProceedsReceived).Client = dr["Client"].ToString();
                                (t as ProceedsReceived).Remark = dr["Remark"].ToString();
                                (t as ProceedsReceived).Operators = Convert.ToInt32(dr["Operator"]);
                                (t as ProceedsReceived).OperatorsDate = dr["OperatorDate"].ToString();
                                (t as ProceedsReceived).IsDel = Convert.ToInt32(dr["IsDel"]);
                                (t as ProceedsReceived).FID = dr["FID"].ToString();
                                break;
                            case "ViewDelegationInfoAndForeignReceivables":
                                (t as ViewDelegationInfoAndForeignReceivables).DIID = Convert.ToInt32(dr["DIID"]);
                                (t as ViewDelegationInfoAndForeignReceivables).TeamName = dr["TeamName"].ToString();
                                (t as ViewDelegationInfoAndForeignReceivables).ClientUnit = dr["ClientUnit"].ToString();
                                (t as ViewDelegationInfoAndForeignReceivables).VisitDate = dr["VisitDate"].ToString();
                                break;
                            case "ViewDelegationInfoAndcreditCardPayment":
                                (t as ViewDelegationInfoAndcreditCardPayment).DIID = Convert.ToInt32(dr["DIID"]);
                                (t as ViewDelegationInfoAndcreditCardPayment).TeamName = dr["TeamName"].ToString();
                                (t as ViewDelegationInfoAndcreditCardPayment).ClientUnit = dr["ClientUnit"].ToString();
                                (t as ViewDelegationInfoAndcreditCardPayment).VisitDate = dr["VisitDate"].ToString();
                                break;
                            case "MediaSuppliers":
                                (t as MediaSuppliers).Id = Convert.ToInt32(dr["Id"]);
                                (t as MediaSuppliers).Did = Convert.ToInt32(dr["Did"]);
                                (t as MediaSuppliers).Privince = dr["Privince"].ToString();
                                (t as MediaSuppliers).City = dr["City"].ToString();
                                (t as MediaSuppliers).Name = dr["Name"].ToString();
                                (t as MediaSuppliers).Sex = Convert.ToInt32(dr["Sex"]);
                                (t as MediaSuppliers).UnitName = dr["UnitName"].ToString();
                                (t as MediaSuppliers).UnitAbbreviation = dr["UnitAbbreviation"].ToString();
                                (t as MediaSuppliers).Post = dr["Post"].ToString();
                                (t as MediaSuppliers).Tel = dr["Tel"].ToString();
                                (t as MediaSuppliers).QQ = dr["QQ"].ToString();
                                (t as MediaSuppliers).Email = dr["Email"].ToString();
                                (t as MediaSuppliers).Fax = dr["Fax"].ToString();
                                (t as MediaSuppliers).Address = dr["Address"].ToString();
                                (t as MediaSuppliers).OtherInformation = dr["OtherInformation"].ToString();
                                (t as MediaSuppliers).Operators = Convert.ToInt32(dr["Operator"]);
                                (t as MediaSuppliers).OperatorsDate = dr["OperatorDate"].ToString();
                                (t as MediaSuppliers).IsDel = Convert.ToInt32(dr["IsDel"]);
                                break;
                            case "Level":
                                (t as Level).Id = Convert.ToInt32(dr["Id"]);
                                (t as Level).Lid = Convert.ToInt32(dr["Lid"]);
                                (t as Level).LName = dr["LName"].ToString();
                                (t as Level).Profit = float.Parse(dr["Profit"].ToString());
                                (t as Level).Rebate = float.Parse(dr["Rebate"].ToString());
                                (t as Level).Tax = float.Parse(dr["Tax"].ToString());
                                (t as Level).Did = Convert.ToInt32(dr["Did"]);
                                (t as Level).IsDel = Convert.ToInt32(dr["IsDel"]);
                                (t as Level).Cid = Convert.ToInt32(dr["Cid"]);
                                break;
                            case "OfferData":
                                (t as OfferData).Id = Convert.ToInt32(dr["Id"]);
                                (t as OfferData).PId = Convert.ToInt32(dr["PId"]);
                                (t as OfferData).Cid = Convert.ToInt32(dr["Cid"].ToString());
                                (t as OfferData).PublishedPrice = decimal.Parse(dr["PublishedPrice"].ToString());
                                (t as OfferData).BasePrice = decimal.Parse(dr["BasePrice"].ToString());
                                (t as OfferData).AddedTax = decimal.Parse(dr["AddedTax"].ToString());
                                (t as OfferData).IsDel = Convert.ToInt32(dr["IsDel"]);
                                SetData sd = new SetData();
                                if (dr["Name"] != null)
                                    sd.Name = dr["Name"].ToString();
                                (t as OfferData).Sd = sd;
                                break;
                            case "Offer":
                                (t as Offer).Id = Convert.ToInt32(dr["Id"]);
                                (t as Offer).Uid = Convert.ToInt32(dr["Uid"]);
                                (t as Offer).Projects = dr["Projects"].ToString().ToString();
                                (t as Offer).Cid = Convert.ToInt32(dr["Cid"].ToString());
                                (t as Offer).Pid = Convert.ToInt32(dr["Pid"].ToString());
                                (t as Offer).Discount = decimal.Parse(dr["Discount"].ToString());
                                (t as Offer).SalePrice = decimal.Parse(dr["SalePrice"].ToString());
                                (t as Offer).Profit = decimal.Parse(dr["Profit"].ToString());
                                (t as Offer).Version = Convert.ToInt32(dr["Version"]);
                                (t as Offer).IsNew = Convert.ToInt32(dr["IsNew"]);
                                (t as Offer).IsDel = Convert.ToInt32(dr["IsDel"]);
                                (t as Offer).InputTime = Convert.ToDateTime(dr["InputTime"].ToString());
                                (t as Offer).ProCode = dr["ProCode"].ToString();
                                break;
                            //LiuChengYi   2014/4/16
                            //用于报表
                            case "reportModel":
                                (t as ReportModel).Num = dr["num"].ToString();
                                (t as ReportModel).Category = dr["SalesQuoteNo"].ToString();
                                (t as ReportModel).Sequence = dr["SalesDate"].ToString();
                                break;
                            case "BillInfo":
                                (t as BillInfo).Id = Convert.ToInt32(dr["Id"]);
                                (t as BillInfo).IsDel = Convert.ToInt32(dr["IsDel"]);
                                (t as BillInfo).PostDate = dr["PostDate"].ToString();
                                (t as BillInfo).Currency = dr["Currency"].ToString();
                                (t as BillInfo).Amount = float.Parse(dr["Amount"].ToString());
                                (t as BillInfo).TransDate = dr["TransDate"].ToString();
                                (t as BillInfo).Description = dr["Description"].ToString();
                                break;
                            case "OvertimeApplication":
                                (t as OvertimeApplication).ID = Convert.ToInt32(dr["Id"]);
                                (t as OvertimeApplication).UID = Convert.ToInt32(dr["UID"]);
                                (t as OvertimeApplication).OverDate = Convert.ToDateTime(dr["OverDate"].ToString());
                                (t as OvertimeApplication).StardTime = dr["StardTime"].ToString();
                                (t as OvertimeApplication).EndTime = dr["EndTime"].ToString();
                                (t as OvertimeApplication).ObjectiveTime = dr["ObjectiveTime"].ToString();
                                (t as OvertimeApplication).SubjectiveTime = dr["SubjectiveTime"].ToString();
                                (t as OvertimeApplication).Reason = dr["Reason"].ToString();
                                (t as OvertimeApplication).MAudio = Convert.ToInt32(dr["MAudio"].ToString());
                                (t as OvertimeApplication).IsAudio = Convert.ToInt32(dr["IsAudio"].ToString());
                                (t as OvertimeApplication).AudioMan = dr["AudioMan"].ToString();
                                (t as OvertimeApplication).AudioTime = Convert.ToDateTime(dr["AudioTime"].ToString());
                                (t as OvertimeApplication).Remark = dr["Remark"].ToString();
                                (t as OvertimeApplication).IsDel = Convert.ToInt32(dr["IsDel"].ToString());

                                try
                                {
                                    (t as OvertimeApplication).Did = Convert.ToInt32(dr["Did"].ToString());
                                }
                                catch
                                {
                                    (t as OvertimeApplication).Did = 0;
                                }
                                (t as OvertimeApplication).OvertimeType = Convert.ToInt32(dr["OvertimeType"].ToString());
                                break;
                            //LiuChengYi 2014-5-29
                            case "PageMsg":
                                (t as PageMsg).Id = Convert.ToInt32(dr["Id"]);
                                (t as PageMsg).Name = dr["Name"].ToString();
                                (t as PageMsg).Url = dr["url"].ToString();
                                (t as PageMsg).Img = dr["img"].ToString();
                                break;
                            case "OtherPriceOP":
                                (t as OtherPriceOP).Id = Convert.ToInt32(dr["Id"]);
                                (t as OtherPriceOP).DIID = Convert.ToInt32(dr["DIID"]);
                                (t as OtherPriceOP).PriceName = dr["PriceName"].ToString();
                                (t as OtherPriceOP).Price = float.Parse(dr["Price"].ToString());
                                (t as OtherPriceOP).Currency = Convert.ToInt32(dr["Currency"]);
                                (t as OtherPriceOP).Remark = dr["Remark"].ToString();
                                (t as OtherPriceOP).Operators = Convert.ToInt32(dr["Operator"]);
                                (t as OtherPriceOP).OperatorsDate = dr["OperatorDate"].ToString();
                                (t as OtherPriceOP).IsDel = Convert.ToInt32(dr["IsDel"]);
                                (t as OtherPriceOP).PayType = dr["PayType"].ToString();
                                (t as OtherPriceOP).PriceType = Convert.ToInt32(dr["PriceType"]);
                                break;
                            case "ViewOtherPriceOP":
                                (t as ViewOtherPriceOP).PriceName = dr["PriceName"].ToString();
                                (t as ViewOtherPriceOP).Price = float.Parse(dr["Price"].ToString());
                                (t as ViewOtherPriceOP).Name = dr["Name"].ToString();
                                (t as ViewOtherPriceOP).Spread = float.Parse(dr["Spread"].ToString());
                                (t as ViewOtherPriceOP).DayRate = dr["DayRate"].ToString();
                                (t as ViewOtherPriceOP).Remark = dr["Remark"].ToString();
                                (t as ViewOtherPriceOP).IsPay = dr["IsPay"].ToString();
                                try
                                {
                                    (t as ViewOtherPriceOP).RMBPrice = float.Parse(dr["RMBPrice"].ToString());
                                }
                                catch { (t as ViewOtherPriceOP).RMBPrice = 0f; }
                                (t as ViewOtherPriceOP).OperatorDate = dr["OperatorDate"].ToString();
                                (t as ViewOtherPriceOP).Payee = dr["Payee"].ToString();
                                (t as ViewOtherPriceOP).OrbitalPrivateTransfer = dr["OrbitalPrivateTransfer"].ToString();
                                (t as ViewOtherPriceOP).PayDid = dr["PayDid"].ToString();
                                (t as ViewOtherPriceOP).PaydName = dr["PaydName"].ToString();
                                (t as ViewOtherPriceOP).AuditGMDate = dr["AuditGMDate"].ToString();
                                (t as ViewOtherPriceOP).Operator = dr["Operator"].ToString();
                                (t as ViewOtherPriceOP).IsMatchCreditCard = int.Parse(dr["IsMatchCreditCard"].ToString());
                                break;
                            case "IpInfo":
                                (t as IpInfo).Id = Convert.ToInt32(dr["Id"]);
                                (t as IpInfo).StartIp = Convert.ToDecimal(dr["StartIp"]);
                                (t as IpInfo).EndIp = Convert.ToDecimal(dr["EndIp"]);
                                (t as IpInfo).Country = dr["Country"].ToString();
                                (t as IpInfo).City = dr["City"].ToString();
                                break;
                            case "TeamRate":
                                (t as TeamRate).ID = Convert.ToInt32(dr["Id"]);
                                (t as TeamRate).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as TeamRate).CTable = Convert.ToInt32(dr["CTable"]);
                                (t as TeamRate).OPer = Convert.ToInt32(dr["OPer"]);
                                (t as TeamRate).OPDate = dr["OPDate"].ToString();
                                (t as TeamRate).OtherRate = dr["OtherRate"].ToString();
                                (t as TeamRate).OtherPrice = dr["OtherPrice"].ToString();
                                (t as TeamRate).RateU = dr["RateU"].ToString();
                                (t as TeamRate).RateE = dr["RateE"].ToString();
                                (t as TeamRate).RateJ = dr["RateJ"].ToString();
                                (t as TeamRate).RateH = dr["RateH"].ToString();
                                (t as TeamRate).RateN = dr["RateN"].ToString();
                                (t as TeamRate).RateS = dr["RateS"].ToString();
                                (t as TeamRate).RateA = dr["RateA"].ToString();
                                (t as TeamRate).RateC = dr["RateC"].ToString();
                                (t as TeamRate).RateT = dr["RateT"].ToString();
                                (t as TeamRate).RateBL = dr["RateBL"].ToString();
                                (t as TeamRate).RateHB = dr["RateHB"].ToString();
                                (t as TeamRate).RateFJD = dr["RateFJD"].ToString();
                                (t as TeamRate).RateTL = dr["RateTL"].ToString();
                                (t as TeamRate).RateRP = dr["RateRP"].ToString();
                                (t as TeamRate).RatePeso = dr["RatePeso"].ToString();
                                (t as TeamRate).RateMYR = dr["RateMYR"].ToString();
                                (t as TeamRate).RateCZK = dr["RateCZK"].ToString();
                                (t as TeamRate).RateMXN = dr["RateMXN"].ToString();
                                (t as TeamRate).RateMOP = dr["RateMOP"].ToString();
                                (t as TeamRate).RateARS = dr["RateARS"].ToString();
                                (t as TeamRate).RateHUF = dr["RateHUF"].ToString();
                                (t as TeamRate).RateRUB = dr["RateRUB"].ToString();
                                break;
                            case "InsuranceCost":
                                (t as InsuranceCost).Id = Convert.ToInt32(dr["Id"]);
                                (t as InsuranceCost).GName = dr["GName"].ToString();
                                (t as InsuranceCost).RechargeCost = Convert.ToInt32(dr["RechargeCost"]);
                                (t as InsuranceCost).Remarks = dr["Remarks"].ToString();
                                (t as InsuranceCost).Operators = Convert.ToInt32(dr["Operators"]);
                                (t as InsuranceCost).OperatorDate = dr["OperatorDate"].ToString();
                                (t as InsuranceCost).IsDel = Convert.ToInt32(dr["IsDel"]);
                                break;
                            case "CustomerVisaInfo":
                                (t as CustomerVisaInfo).Id = Convert.ToInt32(dr["Id"]);
                                (t as CustomerVisaInfo).DIId = Convert.ToInt32(dr["DIId"]);
                                (t as CustomerVisaInfo).Name = dr["Name"].ToString();
                                (t as CustomerVisaInfo).Sex = Convert.ToInt32(dr["Sex"]);
                                (t as CustomerVisaInfo).PhoneNumber = dr["PhoneNumber"].ToString();
                                (t as CustomerVisaInfo).Dirthday = dr["Dirthday"].ToString();
                                (t as CustomerVisaInfo).NativePlace = dr["NativePlace"].ToString();
                                (t as CustomerVisaInfo).CardId = dr["CardId"].ToString();
                                (t as CustomerVisaInfo).PassportNo = dr["PassportNo"].ToString();
                                (t as CustomerVisaInfo).PassportsValidity = dr["PassportsValidity"].ToString();
                                (t as CustomerVisaInfo).UnitName = dr["UnitName"].ToString();
                                (t as CustomerVisaInfo).Post = dr["Post"].ToString();
                                (t as CustomerVisaInfo).UnitAddress = dr["UnitAddress"].ToString();
                                (t as CustomerVisaInfo).HomeAddress = dr["HomeAddress"].ToString();
                                (t as CustomerVisaInfo).FiveYearsAgo = dr["FiveYearsAgo"].ToString();
                                (t as CustomerVisaInfo).Operators = Convert.ToInt32(dr["Operators"].ToString());
                                (t as CustomerVisaInfo).OperatorDate = dr["OperatorDate"].ToString();
                                (t as CustomerVisaInfo).VId = Convert.ToInt32(dr["VId"].ToString());
                                (t as CustomerVisaInfo).IsDel = Convert.ToInt32(dr["IsDel"].ToString());
                                (t as CustomerVisaInfo).Remark = dr["Remark"].ToString();
                                break;
                            case "CarCompanyAndTouristGuide":
                                (t as CarCompanyAndTouristGuide).Id = Convert.ToInt32(dr["Id"]);
                                (t as CarCompanyAndTouristGuide).CGId = Convert.ToInt32(dr["CGId"]);
                                (t as CarCompanyAndTouristGuide).CarType = dr["CarType"].ToString();
                                (t as CarCompanyAndTouristGuide).Price = float.Parse(dr["Price"].ToString());
                                (t as CarCompanyAndTouristGuide).Unit = dr["Unit"].ToString();
                                (t as CarCompanyAndTouristGuide).CompanyOrGuide = Convert.ToInt32(dr["CompanyOrGuide"]);
                                (t as CarCompanyAndTouristGuide).Operators = Convert.ToInt32(dr["Operators"]);
                                (t as CarCompanyAndTouristGuide).OperatorDate = dr["OperatorDate"].ToString();
                                (t as CarCompanyAndTouristGuide).Remark = dr["Remark"].ToString();
                                (t as CarCompanyAndTouristGuide).Currency = dr["Currency"].ToString();
                                (t as CarCompanyAndTouristGuide).IsDel = Convert.ToInt32(dr["IsDel"]);
                                break;
                            case "ViewCarDataAndGuide":
                                (t as ViewCarDataAndGuide).Id = Convert.ToInt32(dr["Id"]);
                                (t as ViewCarDataAndGuide).UnitArea = dr["UnitArea"].ToString();
                                (t as ViewCarDataAndGuide).UnitName = dr["UnitName"].ToString();
                                (t as ViewCarDataAndGuide).Contact = dr["Contact"].ToString();
                                (t as ViewCarDataAndGuide).Tel = dr["Tel"].ToString();
                                (t as ViewCarDataAndGuide).Score = Convert.ToInt32(dr["Score"]);
                                (t as ViewCarDataAndGuide).OperatorsDate = dr["OperatorDate"].ToString();
                                (t as ViewCarDataAndGuide).Price = float.Parse(dr["Price"].ToString());
                                (t as ViewCarDataAndGuide).Currency = dr["Currency"].ToString();
                                break;
                            case "Ticket":
                                (t as Ticket).Id = Convert.ToInt32(dr["Id"]);
                                (t as Ticket).Country = dr["Country"].ToString();
                                (t as Ticket).Area = dr["Area"].ToString();
                                (t as Ticket).ScenicSpot = dr["ScenicSpot"].ToString();
                                (t as Ticket).Address = dr["Address"].ToString();
                                (t as Ticket).Contact = dr["Contact"].ToString();
                                (t as Ticket).Price = float.Parse(dr["Price"].ToString());
                                (t as Ticket).Currency = Convert.ToInt32(dr["Currency"]);
                                (t as Ticket).Star = Convert.ToInt32(dr["Star"]);
                                (t as Ticket).StartDate = dr["StartDate"].ToString();
                                (t as Ticket).Remark = dr["Remark"].ToString();
                                (t as Ticket).IsDel = Convert.ToInt32(dr["IsDel"]);
                                break;
                            case "MonthKpiItem":
                                (t as MonthKpiItem).Id = Convert.ToInt32(dr["Id"]);
                                (t as MonthKpiItem).ProId = dr["ProId"].ToString();
                                (t as MonthKpiItem).Pro = dr["Pro"].ToString();
                                (t as MonthKpiItem).ItemId = dr["ItemId"].ToString();
                                (t as MonthKpiItem).Item = dr["Item"].ToString();
                                (t as MonthKpiItem).Rank = dr["Rank"].ToString();
                                (t as MonthKpiItem).Weight = dr["Weight"].ToString();
                                (t as MonthKpiItem).IsDel = Convert.ToInt32(dr["IsDel"]);
                                break;
                            case "MonthKpiItemMark":
                                (t as MonthKpiItemMark).Id = Convert.ToInt32(dr["Id"]);
                                (t as MonthKpiItemMark).KpiItemId = Convert.ToInt32(dr["KpiItemId"]);
                                (t as MonthKpiItemMark).Score = float.Parse(dr["Score"].ToString());
                                (t as MonthKpiItemMark).IsDel = Convert.ToInt32(dr["IsDel"]);
                                break;
                            case "MonthKpiItemScore":
                                (t as MonthKpiItemScore).Id = Convert.ToInt32(dr["Id"]);
                                (t as MonthKpiItemScore).Uid = Convert.ToInt32(dr["Uid"]);
                                (t as MonthKpiItemScore).YearMonth = dr["YearMonth"].ToString();
                                (t as MonthKpiItemScore).ItemId = dr["ItemId"].ToString();
                                (t as MonthKpiItemScore).ItemLeaderScore = float.Parse(dr["ItemLeaderScore"].ToString());
                                (t as MonthKpiItemScore).ItemManaScore = float.Parse(dr["ItemManaScore"].ToString());
                                (t as MonthKpiItemScore).ItemEmployScore = float.Parse(dr["ItemEmployScore"].ToString());
                                (t as MonthKpiItemScore).IsDel = Convert.ToInt32(dr["IsDel"]);
                                break;
                            case "DeleOverView":
                                (t as DeleOverView).Id = Convert.ToInt32(dr["Id"]);
                                (t as DeleOverView).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as DeleOverView).BaoPi = dr["BaoPi"].ToString();
                                (t as DeleOverView).GongWu = dr["GongWu"].ToString();
                                (t as DeleOverView).JiPiao = dr["JiPiao"].ToString();
                                (t as DeleOverView).JiuDian = dr["JiuDian"].ToString();
                                (t as DeleOverView).DiJie = dr["DiJie"].ToString();
                                (t as DeleOverView).Oper = dr["Oper"].ToString();
                                (t as DeleOverView).OpTime = dr["OpTime"].ToString();
                                (t as DeleOverView).IsDel = Convert.ToInt32(dr["IsDel"]);
                                break;
                            case "DeleFile":
                                (t as DeleFile).Id = Convert.ToInt32(dr["Id"]);
                                (t as DeleFile).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as DeleFile).Category = dr["Category"].ToString();
                                (t as DeleFile).Kind = Convert.ToInt32(dr["Kind"]);
                                (t as DeleFile).FileName = dr["FileName"].ToString();
                                (t as DeleFile).FilePath = dr["FilePath"].ToString();
                                (t as DeleFile).Oper = dr["Oper"].ToString();
                                (t as DeleFile).OpTime = dr["OpTime"].ToString();
                                (t as DeleFile).IsDel = Convert.ToInt32(dr["IsDel"]);
                                break;
                            case "NewClientData":
                                (t as NewClientData).ID = Convert.ToInt32(dr["Id"]);
                                (t as NewClientData).Number = Convert.ToInt32(dr["Number"]);
                                (t as NewClientData).Lvl = dr["Lvl"].ToString();
                                (t as NewClientData).Client = dr["Client"].ToString();
                                (t as NewClientData).Weight = dr["Weight"].ToString();
                                (t as NewClientData).ClientShort = dr["ClientShort"].ToString();
                                (t as NewClientData).Contact = dr["Contact"].ToString();
                                (t as NewClientData).Gender = dr["Gender"].ToString();
                                (t as NewClientData).Passport = dr["Passport"].ToString();
                                (t as NewClientData).PassportDate = dr["PassportDate"].ToString();
                                (t as NewClientData).Job = dr["Job"].ToString();
                                (t as NewClientData).TelePhone = dr["TelePhone"].ToString();
                                (t as NewClientData).Phone = dr["Phone"].ToString();
                                (t as NewClientData).Email = dr["Email"].ToString();
                                (t as NewClientData).Location = dr["Location"].ToString();
                                (t as NewClientData).Address = dr["Address"].ToString();
                                (t as NewClientData).Birthday = dr["Birthday"].ToString();
                                (t as NewClientData).OtherInfo = dr["OtherInfo"].ToString();
                                (t as NewClientData).Ascription = dr["Ascription"].ToString();
                                (t as NewClientData).Remarks = dr["Remarks"].ToString();
                                (t as NewClientData).FZR = dr["FZR"].ToString();
                                (t as NewClientData).WeChat = dr["WeChat"].ToString();
                                (t as NewClientData).Category = dr["Category"].ToString();
                                (t as NewClientData).PreDele = dr["PreDele"].ToString();
                                (t as NewClientData).FinlishedDele = dr["FinlishedDele"].ToString();
                                (t as NewClientData).OPer = dr["OPer"].ToString();
                                (t as NewClientData).OPdate = dr["OPdate"].ToString();
                                (t as NewClientData).IsDel = Convert.ToInt32(dr["IsDel"]);
                                break;
                            case "GroupCost":
                                (t as GroupCost).Id = Convert.ToInt32(dr["Id"]);
                                (t as GroupCost).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as GroupCost).DAY = dr["DAY"].ToString();
                                (t as GroupCost).Date = dr["Date"].ToString();
                                (t as GroupCost).ITIN = dr["ITIN"].ToString();
                                (t as GroupCost).CarType = dr["CarType"].ToString();
                                (t as GroupCost).CarTiming = float.Parse(dr["CarTiming"].ToString());
                                (t as GroupCost).CarNumber = float.Parse(dr["CarNumber"].ToString());
                                (t as GroupCost).CarCost = float.Parse(dr["CarCost"].ToString());
                                (t as GroupCost).TGS = float.Parse(dr["TGS"].ToString());
                                (t as GroupCost).TGWH = float.Parse(dr["TGWH"].ToString());
                                (t as GroupCost).TGN = float.Parse(dr["TGN"].ToString());
                                (t as GroupCost).TGOF = float.Parse(dr["TGOF"].ToString());
                                (t as GroupCost).TGM = float.Parse(dr["TGM"].ToString());
                                (t as GroupCost).TGA = float.Parse(dr["TGA"].ToString());
                                (t as GroupCost).TGTF = float.Parse(dr["TGTF"].ToString());
                                (t as GroupCost).TGEF = float.Parse(dr["TGEF"].ToString());
                                (t as GroupCost).CFS = float.Parse(dr["CFS"].ToString());
                                (t as GroupCost).CFM = float.Parse(dr["CFM"].ToString());
                                (t as GroupCost).CFOF = float.Parse(dr["CFOF"].ToString());
                                (t as GroupCost).B = float.Parse(dr["B"].ToString());
                                (t as GroupCost).L = float.Parse(dr["L"].ToString());
                                (t as GroupCost).D = float.Parse(dr["D"].ToString());
                                (t as GroupCost).TBR = float.Parse(dr["TBR"].ToString());
                                (t as GroupCost).SGR = float.Parse(dr["SGR"].ToString());
                                (t as GroupCost).JS_ES = float.Parse(dr["JS_ES"].ToString());
                                (t as GroupCost).Suite = float.Parse(dr["Suite"].ToString());
                                (t as GroupCost).ACCON = dr["ACCON"].ToString();
                                (t as GroupCost).TV = float.Parse(dr["TV"].ToString());
                                (t as GroupCost).iL = float.Parse(dr["IL"].ToString());
                                (t as GroupCost).IF = float.Parse(dr["IF"].ToString());
                                (t as GroupCost).EF = float.Parse(dr["EF"].ToString());
                                (t as GroupCost).B_R_F = float.Parse(dr["B_R_F"].ToString());
                                (t as GroupCost).TE = float.Parse(dr["TE"].ToString());
                                (t as GroupCost).TGTips = float.Parse(dr["TGTips"].ToString());
                                (t as GroupCost).DRVTips = float.Parse(dr["DRVTips"].ToString());
                                (t as GroupCost).PC = float.Parse(dr["PC"].ToString());
                                (t as GroupCost).TLF = float.Parse(dr["TLF"].ToString());
                                (t as GroupCost).ECT = float.Parse(dr["ECT"].ToString());
                                (t as GroupCost).Oper = Convert.ToInt32(dr["Oper"]);
                                (t as GroupCost).OpTime = dr["OpTime"].ToString();
                                (t as GroupCost).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "CarGuideData_US":
                                (t as CarGuideData_US).Id = Convert.ToInt32(dr["Id"]);
                                (t as CarGuideData_US).Area = dr["Area"].ToString();
                                (t as CarGuideData_US).ServiceType = dr["ServiceType"].ToString();
                                (t as CarGuideData_US).CarType = dr["CarType"].ToString();
                                (t as CarGuideData_US).IsHighTop = dr["IsHighTop"].ToString();
                                (t as CarGuideData_US).CarCost = dr["CarCost"].ToString();
                                (t as CarGuideData_US).GuideCost = dr["GuideCost"].ToString();
                                (t as CarGuideData_US).WorkTime = dr["WorkTime"].ToString();
                                (t as CarGuideData_US).CarOverTimeCost = dr["CarOverTimeCost"].ToString();
                                (t as CarGuideData_US).GuideOverTimeCost = dr["GuideOverTimeCost"].ToString();
                                (t as CarGuideData_US).Remark = dr["Remark"].ToString();
                                (t as CarGuideData_US).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "CarGuideData_SA":
                                (t as CarGuideData_SA).Id = Convert.ToInt32(dr["Id"]);
                                (t as CarGuideData_SA).Area = dr["Area"].ToString();
                                (t as CarGuideData_SA).ServiceType = dr["ServiceType"].ToString();
                                (t as CarGuideData_SA).CarType = dr["CarType"].ToString();
                                (t as CarGuideData_SA).Tip = dr["Tip"].ToString();
                                (t as CarGuideData_SA).CarCost = dr["CarCost"].ToString();
                                (t as CarGuideData_SA).GuideCost = dr["GuideCost"].ToString();
                                (t as CarGuideData_SA).CarWorkTime = dr["CarWorkTime"].ToString();
                                (t as CarGuideData_SA).CarOverTimeCost = dr["CarOverTimeCost"].ToString();
                                (t as CarGuideData_SA).Remark = dr["Remark"].ToString();
                                (t as CarGuideData_SA).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "CarGuideData_EU":
                                (t as CarGuideData_EU).Id = Convert.ToInt32(dr["Id"]);
                                (t as CarGuideData_EU).Country = dr["Country"].ToString();
                                (t as CarGuideData_EU).Area = dr["Area"].ToString();
                                (t as CarGuideData_EU).CarType = dr["CarType"].ToString();
                                (t as CarGuideData_EU).CarCost = dr["CarCost"].ToString();
                                (t as CarGuideData_EU).CarAirTran = dr["CarAirTran"].ToString();
                                (t as CarGuideData_EU).DriverTip = dr["DriverTip"].ToString();
                                (t as CarGuideData_EU).GuideCost = dr["GuideCost"].ToString();
                                (t as CarGuideData_EU).GuideTip = dr["GuideTip"].ToString();
                                (t as CarGuideData_EU).GuideAirTran = dr["GuideAirTran"].ToString();
                                (t as CarGuideData_EU).Meal = dr["Meal"].ToString();
                                (t as CarGuideData_EU).WorkTime = dr["WorkTime"].ToString();
                                (t as CarGuideData_EU).OverTimeCost = dr["OverTimeCost"].ToString();
                                (t as CarGuideData_EU).Remark = dr["Remark"].ToString();
                                (t as CarGuideData_EU).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "GroupCostParameter":
                                (t as GroupCostParameter).Id = Convert.ToInt32(dr["Id"]);
                                (t as GroupCostParameter).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as GroupCostParameter).Currency = dr["Currency"].ToString();
                                (t as GroupCostParameter).Rate = float.Parse(dr["Rate"].ToString());
                                (t as GroupCostParameter).Tax = float.Parse(dr["Tax"].ToString());
                                (t as GroupCostParameter).FFYS = float.Parse(dr["FFYS"].ToString());
                                (t as GroupCostParameter).HotelXS = float.Parse(dr["HotelXS"].ToString());
                                (t as GroupCostParameter).JJCCB = float.Parse(dr["JJCCB"].ToString());
                                (t as GroupCostParameter).JJCXS = float.Parse(dr["JJCXS"].ToString());
                                (t as GroupCostParameter).JJCRS = Convert.ToInt32(dr["JJCRS"].ToString());
                                (t as GroupCostParameter).GWCCB = float.Parse(dr["GWCCB"].ToString());
                                (t as GroupCostParameter).GWCXS = float.Parse(dr["GWCXS"].ToString());
                                (t as GroupCostParameter).GWCRS = Convert.ToInt32(dr["GWCRS"].ToString());
                                (t as GroupCostParameter).HCPCB = float.Parse(dr["HCPCB"].ToString());
                                (t as GroupCostParameter).HCPRS = Convert.ToInt32(dr["HCPRS"].ToString());
                                (t as GroupCostParameter).HCPXS = float.Parse(dr["HCPXS"].ToString());
                                (t as GroupCostParameter).CPCB = float.Parse(dr["CPCB"].ToString());
                                (t as GroupCostParameter).CPRS = Convert.ToInt32(dr["CPRS"].ToString());
                                (t as GroupCostParameter).CPXS = float.Parse(dr["CPXS"].ToString());

                                (t as GroupCostParameter).BXCB = string.IsNullOrWhiteSpace(dr["BXCB"].ToString()) ? 0.00f : float.Parse(dr["BXCB"].ToString()) ;
                                (t as GroupCostParameter).BXRS = string.IsNullOrWhiteSpace(dr["BXRS"].ToString()) ? 0 : Convert.ToInt32(dr["BXRS"].ToString());
                                (t as GroupCostParameter).BXXS = string.IsNullOrWhiteSpace(dr["BXXS"].ToString()) ? 0.00f : float.Parse(dr["BXXS"].ToString());

                                (t as GroupCostParameter).HSCB = string.IsNullOrWhiteSpace(dr["HSCB"].ToString()) ? 0.00f : float.Parse(dr["HSCB"].ToString());
                                (t as GroupCostParameter).HSRS = Convert.ToInt32(dr["HSRS"].ToString());
                                (t as GroupCostParameter).HSXS = float.Parse(dr["HSXS"].ToString());

                                (t as GroupCostParameter).VisaCB = float.Parse(dr["VisaCB"].ToString());
                                (t as GroupCostParameter).VisaXS = float.Parse(dr["VisaXS"].ToString());
                                (t as GroupCostParameter).VisaRS = Convert.ToInt32(dr["VisaRS"].ToString());
                                (t as GroupCostParameter).GWCB = float.Parse(dr["GWCB"].ToString());
                                (t as GroupCostParameter).GWXS = float.Parse(dr["GWXS"].ToString());
                                (t as GroupCostParameter).GWRS = Convert.ToInt32(dr["GWRS"].ToString());
                                (t as GroupCostParameter).DJCB = float.Parse(dr["DJCB"].ToString());
                                (t as GroupCostParameter).DJXS = float.Parse(dr["DJXS"].ToString());
                                (t as GroupCostParameter).LYJCB = float.Parse(dr["LYJCB"].ToString());
                                (t as GroupCostParameter).LYJXS = float.Parse(dr["LYJXS"].ToString());
                                (t as GroupCostParameter).LYJRS = Convert.ToInt32(dr["LYJRS"].ToString());
                                (t as GroupCostParameter).SGRCB = float.Parse(dr["SGRCB"].ToString());
                                (t as GroupCostParameter).SGRNumber = Convert.ToInt32(dr["SGRNumber"].ToString());
                                (t as GroupCostParameter).SGRXS = float.Parse(dr["SGRXS"].ToString());
                                (t as GroupCostParameter).TBRCB = float.Parse(dr["TBRCB"].ToString());
                                (t as GroupCostParameter).TBRNumber = Convert.ToInt32(dr["TBRNumber"].ToString());
                                (t as GroupCostParameter).TBRXS = float.Parse(dr["TBRXS"].ToString());
                                (t as GroupCostParameter).JSESCB = float.Parse(dr["JSESCB"].ToString());
                                (t as GroupCostParameter).JSESNumber = Convert.ToInt32(dr["JSESNumber"].ToString());
                                (t as GroupCostParameter).JSESXS = float.Parse(dr["JSESXS"].ToString());
                                (t as GroupCostParameter).SUITECB = float.Parse(dr["SUITECB"].ToString());
                                (t as GroupCostParameter).SUITENumber = Convert.ToInt32(dr["SUITENumber"].ToString());
                                (t as GroupCostParameter).SUITEXS = float.Parse(dr["SUITEXS"].ToString());
                                (t as GroupCostParameter).IsShare = Convert.ToInt32(dr["IsShare"].ToString());
                                (t as GroupCostParameter).Oper = Convert.ToInt32(dr["Oper"].ToString());
                                (t as GroupCostParameter).OpTime = dr["OpTime"].ToString();

                                (t as GroupCostParameter).CostType = string.IsNullOrWhiteSpace(dr["CostType"].ToString()) ? "A" : dr["CostType"].ToString();
                                (t as GroupCostParameter).AstartTime = string.IsNullOrWhiteSpace(dr["AstartTime"].ToString()) ? "" : dr["AstartTime"].ToString();
                                (t as GroupCostParameter).AendTime = string.IsNullOrWhiteSpace(dr["AendTime"].ToString()) ? "" : dr["AendTime"].ToString();
                                (t as GroupCostParameter).Anumber = string.IsNullOrWhiteSpace(dr["Anumber"].ToString()) ? 0 : int.Parse(dr["Anumber"].ToString());

                                (t as GroupCostParameter).BstartTime = string.IsNullOrWhiteSpace(dr["BstartTime"].ToString()) ? "" : dr["BstartTime"].ToString();
                                (t as GroupCostParameter).BendTime = string.IsNullOrWhiteSpace(dr["BendTime"].ToString()) ? "" : dr["BendTime"].ToString();
                                (t as GroupCostParameter).Bnumber = string.IsNullOrWhiteSpace(dr["Bnumber"].ToString()) ? 0 : int.Parse(dr["Bnumber"].ToString());

                                break;
                            case "ThreeCode":
                                (t as ThreeCode).Id = Convert.ToInt32(dr["Id"]);
                                (t as ThreeCode).Three = dr["Three"].ToString();
                                (t as ThreeCode).Four = dr["Four"].ToString();
                                (t as ThreeCode).Country = dr["Country"].ToString();
                                (t as ThreeCode).City = dr["City"].ToString();
                                (t as ThreeCode).AirPort = dr["AirPort"].ToString();
                                (t as ThreeCode).AirPort_En = dr["AirPort_En"].ToString();
                                (t as ThreeCode).OPer = dr["OPer"].ToString();
                                (t as ThreeCode).OPDate = dr["OPDate"].ToString();
                                (t as ThreeCode).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "AirCompany":
                                (t as AirCompany).Id = Convert.ToInt32(dr["Id"]);
                                (t as AirCompany).ShortCode = dr["ShortCode"].ToString();
                                (t as AirCompany).CnName = dr["CnName"].ToString();
                                (t as AirCompany).EnName = dr["EnName"].ToString();
                                (t as AirCompany).OPer = dr["OPer"].ToString();
                                (t as AirCompany).OPDate = dr["OPDate"].ToString();
                                (t as AirCompany).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "OfficalActivities":
                                (t as OfficialActivities).Id = Convert.ToInt32(dr["Id"]);
                                (t as OfficialActivities).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as OfficialActivities).Dovid = Convert.ToInt32(dr["Dovid"]);
                                (t as OfficialActivities).Client = dr["Client"].ToString();
                                (t as OfficialActivities).Date = dr["Date"].ToString();
                                (t as OfficialActivities).Time = dr["Time"].ToString();
                                (t as OfficialActivities).Address = dr["Address"].ToString();
                                (t as OfficialActivities).Job = dr["Job"].ToString();
                                (t as OfficialActivities).Contact = dr["Contact"].ToString();
                                (t as OfficialActivities).Tel = dr["Tel"].ToString();
                                (t as OfficialActivities).Form = dr["Form"].ToString();
                                (t as OfficialActivities).Setting = dr["Setting"].ToString();
                                (t as OfficialActivities).Dresscode = dr["Dresscode"].ToString();
                                (t as OfficialActivities).Attendees = dr["Attendees"].ToString();
                                (t as OfficialActivities).IsNeedTrans = dr["IsNeedTrans"].ToString();
                                (t as OfficialActivities).Translators = dr["Translators"].ToString();
                                (t as OfficialActivities).Language = dr["Language"].ToString();
                                (t as OfficialActivities).Trip = dr["Trip"].ToString();
                                (t as OfficialActivities).Oper = Convert.ToInt32(dr["Oper"]);
                                (t as OfficialActivities).OpDate = dr["OpDate"].ToString();
                                (t as OfficialActivities).Isdel = Convert.ToInt32(dr["Isdel"]);
                                (t as OfficialActivities).Type = Convert.ToInt32(dr["Type"]);
                                (t as OfficialActivities).IsSubmitApproval = Convert.ToInt32(dr["IsSubmitApproval"]);
                                (t as OfficialActivities).IsPay = Convert.ToInt32(dr["IsPay"]);

                                break;
                            case "AskData":
                                (t as AskData).Id = Convert.ToInt32(dr["Id"]);
                                (t as AskData).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as AskData).DeleName = dr["DeleName"].ToString();
                                (t as AskData).Country = dr["Country"].ToString();
                                (t as AskData).Area = dr["Area"].ToString();
                                (t as AskData).UnitName = dr["UnitName"].ToString();
                                (t as AskData).Field = dr["Field"].ToString();
                                (t as AskData).TalkCase = dr["TalkCase"].ToString();
                                (t as AskData).Oper = Convert.ToInt32(dr["Oper"]);
                                (t as AskData).OpDate = dr["OpDate"].ToString();
                                (t as AskData).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "VisaFile":
                                (t as VisaFile).Id = Convert.ToInt32(dr["Id"]);
                                (t as VisaFile).Continent = dr["Continent"].ToString();
                                (t as VisaFile).Country = dr["Country"].ToString();
                                (t as VisaFile).Category = dr["Category"].ToString();
                                (t as VisaFile).FileName = dr["FileName"].ToString();
                                (t as VisaFile).FilePath = dr["FilePath"].ToString();
                                (t as VisaFile).Oper = Convert.ToInt32(dr["Oper"]);
                                (t as VisaFile).OpDate = dr["OpDate"].ToString();
                                (t as VisaFile).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "VisaCustomer":
                                (t as VisaCustomer).Id = Convert.ToInt32(dr["Id"]);
                                (t as VisaCustomer).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as VisaCustomer).Type = Convert.ToInt32(dr["Type"]);
                                (t as VisaCustomer).LastName = dr["LastName"].ToString();
                                (t as VisaCustomer).FirstName = dr["FirstName"].ToString();
                                (t as VisaCustomer).OldName = dr["OldName"].ToString();
                                (t as VisaCustomer).Marriage = dr["Marriage"].ToString();
                                (t as VisaCustomer).Phone = dr["Phone"].ToString();
                                (t as VisaCustomer).BirthCity = dr["BirthCity"].ToString();
                                (t as VisaCustomer).BirthProvince = dr["BirthProvince"].ToString();
                                (t as VisaCustomer).BirthDay = dr["BirthDay"].ToString();
                                (t as VisaCustomer).Tel = dr["Tel"].ToString();
                                (t as VisaCustomer).Email = dr["Email"].ToString();
                                (t as VisaCustomer).IdCard = dr["IdCard"].ToString();
                                (t as VisaCustomer).IdStartDate = dr["IdStartDate"].ToString();
                                (t as VisaCustomer).IdEndDate = dr["IdEndDate"].ToString();
                                (t as VisaCustomer).IdCardAddress = dr["IdCardAddress"].ToString();
                                (t as VisaCustomer).Address = dr["Address"].ToString();
                                (t as VisaCustomer).HighestEducation = dr["HighestEducation"].ToString();
                                (t as VisaCustomer).PostCodes = dr["PostCodes"].ToString();
                                (t as VisaCustomer).Client = dr["Client"].ToString();
                                (t as VisaCustomer).ClientAddress = dr["ClientAddress"].ToString();
                                (t as VisaCustomer).ClientPostCodes = dr["ClientPostCodes"].ToString();
                                (t as VisaCustomer).Job = dr["Job"].ToString();
                                (t as VisaCustomer).WorkDate = dr["WorkDate"].ToString();
                                (t as VisaCustomer).Wage = dr["Wage"].ToString();
                                (t as VisaCustomer).ClientPhone = dr["ClientPhone"].ToString();
                                (t as VisaCustomer).ClientFax = dr["ClientFax"].ToString();
                                (t as VisaCustomer).ClientEmail = dr["ClientEmail"].ToString();
                                (t as VisaCustomer).ClientLeader = dr["ClientLeader"].ToString();
                                (t as VisaCustomer).ClientLeaderJob = dr["ClientLeaderJob"].ToString();
                                (t as VisaCustomer).WorkState = dr["WorkState"].ToString();
                                (t as VisaCustomer).IsGetSchengen = dr["IsGetSchengen"].ToString();
                                (t as VisaCustomer).StartTime = dr["StartTime"].ToString();
                                (t as VisaCustomer).EndTime = dr["EndTime"].ToString();
                                (t as VisaCustomer).IsFinger = dr["IsFinger"].ToString();
                                (t as VisaCustomer).FingerDate = dr["FingerDate"].ToString();
                                (t as VisaCustomer).CostBearers = dr["CostBearers"].ToString();
                                (t as VisaCustomer).TableOpName = dr["TableOpName"].ToString();
                                (t as VisaCustomer).TableOpTel = dr["TableOpTel"].ToString();
                                (t as VisaCustomer).TableDate = dr["TableDate"].ToString();
                                (t as VisaCustomer).Party = dr["Party"].ToString();
                                (t as VisaCustomer).Nationality = dr["Nationality"].ToString();
                                (t as VisaCustomer).Sex = dr["Sex"].ToString();
                                (t as VisaCustomer).WeddingDate = dr["WeddingDate"].ToString();
                                (t as VisaCustomer).DivorceDate = dr["DivorceDate"].ToString();
                                (t as VisaCustomer).MateName = dr["MateName"].ToString();
                                (t as VisaCustomer).MateBirthDay = dr["MateBirthDay"].ToString();
                                (t as VisaCustomer).MateBirthCity = dr["MateBirthCity"].ToString();
                                (t as VisaCustomer).MateBirthCountry = dr["MateBirthCountry"].ToString();
                                (t as VisaCustomer).MateAddress = dr["MateAddress"].ToString();
                                (t as VisaCustomer).MateClient = dr["MateClient"].ToString();
                                (t as VisaCustomer).MateClientAddress = dr["MateClientAddress"].ToString();
                                (t as VisaCustomer).MateJob = dr["MateJob"].ToString();
                                (t as VisaCustomer).VisitCountry = dr["VisitCountry"].ToString();
                                (t as VisaCustomer).Paper = dr["Paper"].ToString();
                                (t as VisaCustomer).Papent = dr["Papent"].ToString();
                                (t as VisaCustomer).PhD = dr["PhD"].ToString();
                                (t as VisaCustomer).IsVisitUC = dr["IsVisitUC"].ToString();
                                (t as VisaCustomer).USADate = dr["USADate"].ToString();
                                (t as VisaCustomer).USADays = dr["USADays"].ToString();
                                (t as VisaCustomer).CanDate = dr["CanDate"].ToString();
                                (t as VisaCustomer).CanDays = dr["CanDays"].ToString();
                                (t as VisaCustomer).IsUSAVia = dr["IsUSAVia"].ToString();
                                (t as VisaCustomer).GetUSAVisaDate = dr["GetUSAVisaDate"].ToString();
                                (t as VisaCustomer).GetUPPlace = dr["GetUPPlace"].ToString();
                                (t as VisaCustomer).USAVisaCate = dr["USAVisaCate"].ToString();
                                (t as VisaCustomer).USAVisaCode = dr["USAVisaCode"].ToString();
                                (t as VisaCustomer).USAFinger = dr["USAFinger"].ToString();
                                (t as VisaCustomer).IsRejected = dr["IsRejected"].ToString();
                                (t as VisaCustomer).RejectedDate = dr["RejectedDate"].ToString();
                                (t as VisaCustomer).RejectedPlace = dr["RejectedPlace"].ToString();
                                (t as VisaCustomer).RejectedVisa = dr["RejectedVisa"].ToString();
                                (t as VisaCustomer).IsRevoke = dr["IsRevoke"].ToString();
                                (t as VisaCustomer).IsLose = dr["IsLose"].ToString();
                                (t as VisaCustomer).LoseDate = dr["LoseDate"].ToString();
                                (t as VisaCustomer).LoseCode = dr["LoseCode"].ToString();
                                (t as VisaCustomer).IsUSAVisa = dr["IsUSAVisa"].ToString();
                                (t as VisaCustomer).MateUSA = dr["MateUSA"].ToString();
                                (t as VisaCustomer).MateIden = dr["MateIden"].ToString();
                                (t as VisaCustomer).WHUSA = dr["WHUSA"].ToString();
                                (t as VisaCustomer).WHIden = dr["WHIden"].ToString();
                                (t as VisaCustomer).ParentUSA = dr["ParentUSA"].ToString();
                                (t as VisaCustomer).ParentIden = dr["ParentIden"].ToString();
                                (t as VisaCustomer).ChildUSA = dr["ChildUSA"].ToString();
                                (t as VisaCustomer).ChildIden = dr["ChildIden"].ToString();
                                (t as VisaCustomer).BroUSA = dr["BroUSA"].ToString();
                                (t as VisaCustomer).BroIden = dr["BroIden"].ToString();
                                (t as VisaCustomer).Social = dr["Social"].ToString();
                                (t as VisaCustomer).IsArmy = dr["IsArmy"].ToString();
                                (t as VisaCustomer).ArmyState = dr["ArmyState"].ToString();
                                (t as VisaCustomer).ApplyDate = dr["ApplyDate"].ToString();
                                (t as VisaCustomer).Oper = Convert.ToInt32(dr["Oper"]);
                                (t as VisaCustomer).OpDate = dr["OpDate"].ToString();
                                (t as VisaCustomer).passportNumber = dr["passportNumber"].ToString(); //护照号
                                (t as VisaCustomer).Isdel = Convert.ToInt32(dr["Isdel"]); ;
                                break;
                            case "VisaCustomerCompany":
                                (t as VisaCustomerCompany).Id = Convert.ToInt32(dr["Id"]);
                                (t as VisaCustomerCompany).DCid = Convert.ToInt32(dr["DCid"]);
                                (t as VisaCustomerCompany).Company = dr["Company"].ToString();
                                (t as VisaCustomerCompany).CompanyAddress = dr["CompanyAddress"].ToString();
                                (t as VisaCustomerCompany).Phone = dr["Phone"].ToString();
                                (t as VisaCustomerCompany).Job = dr["Job"].ToString();
                                (t as VisaCustomerCompany).LeaderName = dr["LeaderName"].ToString();
                                (t as VisaCustomerCompany).WorkStart = dr["WorkStart"].ToString();
                                (t as VisaCustomerCompany).WorkEnd = dr["WorkEnd"].ToString();
                                (t as VisaCustomerCompany).WorkState = dr["WorkState"].ToString();
                                break;
                            case "VisaCustomerFamily":
                                (t as VisaCustomerFamily).Id = Convert.ToInt32(dr["Id"]);
                                (t as VisaCustomerFamily).DCId = Convert.ToInt32(dr["DCId"]);
                                (t as VisaCustomerFamily).Appellation = dr["Appellation"].ToString();
                                (t as VisaCustomerFamily).Name = dr["Name"].ToString();
                                (t as VisaCustomerFamily).BirthDay = dr["BirthDay"].ToString();
                                (t as VisaCustomerFamily).BirthPlace = dr["BirthPlace"].ToString();
                                (t as VisaCustomerFamily).Politics = dr["Politics"].ToString();
                                (t as VisaCustomerFamily).Client = dr["Client"].ToString();
                                (t as VisaCustomerFamily).Address = dr["Address"].ToString();
                                (t as VisaCustomerFamily).IsEu = Convert.ToInt32(dr["IsEu"]);
                                (t as VisaCustomerFamily).NameSnd = dr["NameSnd"].ToString();
                                (t as VisaCustomerFamily).BirthDaySnd = dr["BirthDaySnd"].ToString();
                                (t as VisaCustomerFamily).Nationality = dr["Nationality"].ToString();
                                (t as VisaCustomerFamily).IDCard = dr["IDCard"].ToString();
                                (t as VisaCustomerFamily).Reletionship = dr["Reletionship"].ToString();
                                (t as VisaCustomerFamily).IsUSA = dr["IsUSA"].ToString();
                                break;
                            case "VisaCustomerSchool":
                                (t as VisaCustomerSchool).Id = Convert.ToInt32(dr["Id"]);
                                (t as VisaCustomerSchool).DCid = Convert.ToInt32(dr["DCid"]);
                                (t as VisaCustomerSchool).School = dr["School"].ToString();
                                (t as VisaCustomerSchool).Address = dr["Address"].ToString();
                                (t as VisaCustomerSchool).Teacher = dr["Teacher"].ToString();
                                (t as VisaCustomerSchool).Subject = dr["Subject"].ToString();
                                (t as VisaCustomerSchool).StudyStart = dr["StudyStart"].ToString();
                                (t as VisaCustomerSchool).StudyEnd = dr["StudyEnd"].ToString();
                                break;
                            case "VisaProgress":
                                (t as VisaProgress).Id = Convert.ToInt32(dr["Id"]);
                                (t as VisaProgress).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as VisaProgress).Country = dr["Country"].ToString();
                                (t as VisaProgress).GetData = dr["GetData"].ToString();
                                (t as VisaProgress).GetDataTime = dr["GetDataTime"].ToString();
                                (t as VisaProgress).GetPassport = dr["GetPassport"].ToString();
                                (t as VisaProgress).GetPassportTime = dr["GetPassportTime"].ToString();
                                (t as VisaProgress).FillData = dr["FillData"].ToString();
                                (t as VisaProgress).FillDataTime = dr["FillDataTime"].ToString();
                                (t as VisaProgress).SendVisa = dr["SendVisa"].ToString();
                                (t as VisaProgress).SendVisaTime = dr["SendVisaTime"].ToString();
                                (t as VisaProgress).SignOut = dr["SignOut"].ToString();
                                (t as VisaProgress).SignOutTime = dr["SignOutTime"].ToString();
                                (t as VisaProgress).SendBackPassport = dr["SendBackPassport"].ToString();
                                (t as VisaProgress).SendBackPassporTime = dr["SendBackPassporTime"].ToString();
                                (t as VisaProgress).Receiver = dr["Receiver"].ToString();
                                (t as VisaProgress).Oper = Convert.ToInt32(dr["Oper"]);
                                (t as VisaProgress).Opdate = dr["Opdate"].ToString();
                                (t as VisaProgress).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "DelegationEnData":
                                (t as DelegationEnData).Id = Convert.ToInt32(dr["Id"]);
                                (t as DelegationEnData).Area = dr["Area"].ToString();
                                (t as DelegationEnData).Job = dr["Job"].ToString();
                                (t as DelegationEnData).JobEn = dr["JobEn"].ToString();
                                (t as DelegationEnData).DelegationSetting = dr["DelegationSetting"].ToString();
                                (t as DelegationEnData).DelegationSettingEn = dr["DelegationSettingEn"].ToString();
                                (t as DelegationEnData).Oper = Convert.ToInt32(dr["Oper"]);
                                (t as DelegationEnData).Opdate = dr["Opdate"].ToString();
                                (t as DelegationEnData).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "AirTicketAgent":
                                (t as AirTicketAgent).Id = Convert.ToInt32(dr["Id"]);
                                (t as AirTicketAgent).Name = dr["Name"].ToString();
                                (t as AirTicketAgent).Account = dr["Account"].ToString();
                                (t as AirTicketAgent).Bank = dr["Bank"].ToString();
                                (t as AirTicketAgent).OPer = Convert.ToInt32(dr["OPer"]);
                                (t as AirTicketAgent).OPdate = dr["OPdate"].ToString();
                                (t as AirTicketAgent).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "DeleClient":
                                (t as DeleClient).Id = Convert.ToInt32(dr["Id"]);
                                (t as DeleClient).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as DeleClient).Name = dr["Name"].ToString();
                                (t as DeleClient).LastName = dr["LastName"].ToString();
                                (t as DeleClient).Pinyin = dr["Pinyin"].ToString();
                                (t as DeleClient).Company = dr["Company"].ToString();
                                (t as DeleClient).GroupUnit = dr["GroupUnit"].ToString();
                                (t as DeleClient).Job = dr["Job"].ToString();
                                (t as DeleClient).Phone = dr["Phone"].ToString();
                                (t as DeleClient).Sex = dr["Sex"].ToString();
                                (t as DeleClient).IDcard = dr["IDcard"].ToString();
                                (t as DeleClient).PassprotType = dr["PassprotType"].ToString();
                                (t as DeleClient).PassportNo = dr["PassportNo"].ToString();
                                (t as DeleClient).passportCountry = dr["passportCountry"].ToString();
                                (t as DeleClient).IssuePlace = dr["IssuePlace"].ToString();
                                (t as DeleClient).IssueDate = dr["IssueDate"].ToString();
                                (t as DeleClient).ExpiryDate = dr["ExpiryDate"].ToString();
                                (t as DeleClient).Birthday = dr["Birthday"].ToString();
                                (t as DeleClient).AirType = dr["AirType"].ToString();
                                (t as DeleClient).AirRemark = dr["AirRemark"].ToString();
                                (t as DeleClient).RoomType = dr["RoomType"].ToString();
                                (t as DeleClient).Remark = dr["Remark"].ToString();
                                (t as DeleClient).OPer = Convert.ToInt32(dr["OPer"]);
                                (t as DeleClient).OPdate = dr["OPdate"].ToString();
                                (t as DeleClient).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "DeleClientNeeds":
                                (t as DeleClientNeeds).Id = Convert.ToInt32(dr["Id"]);
                                (t as DeleClientNeeds).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as DeleClientNeeds).OffActPlace = dr["OffActPlace"].ToString();
                                (t as DeleClientNeeds).OffActLetter = dr["OffActLetter"].ToString();
                                (t as DeleClientNeeds).TransNeed = dr["TransNeed"].ToString();
                                (t as DeleClientNeeds).TranLanguage = dr["TranLanguage"].ToString();
                                (t as DeleClientNeeds).TranScene = dr["TranScene"].ToString();
                                (t as DeleClientNeeds).VisaNeeds = dr["VisaNeeds"].ToString();
                                (t as DeleClientNeeds).Hobby = dr["Hobby"].ToString();
                                (t as DeleClientNeeds).CarNeeds = dr["CarNeeds"].ToString();
                                (t as DeleClientNeeds).GuideNeeds = dr["GuideNeeds"].ToString();
                                (t as DeleClientNeeds).MealNeeds = dr["MealNeeds"].ToString();
                                (t as DeleClientNeeds).CheckInTime = dr["CheckInTime"].ToString();
                                (t as DeleClientNeeds).HotelLevel = dr["HotelLevel"].ToString();
                                (t as DeleClientNeeds).HotelPosition = dr["HotelPosition"].ToString();
                                (t as DeleClientNeeds).RoomNum = dr["RoomNum"].ToString();
                                (t as DeleClientNeeds).NeedsRemark = dr["NeedsRemark"].ToString();
                                (t as DeleClientNeeds).OPer = Convert.ToInt32(dr["OPer"]);
                                (t as DeleClientNeeds).OPdate = dr["OPdate"].ToString();
                                (t as DeleClientNeeds).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "BackProgress":
                                (t as BackProgress).Id = Convert.ToInt32(dr["Id"]);
                                (t as BackProgress).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as BackProgress).BPTime = dr["BPTime"].ToString();
                                (t as BackProgress).BPRemark = dr["BPRemark"].ToString();
                                (t as BackProgress).SQTime = dr["SQTime"].ToString();
                                (t as BackProgress).SQRemark = dr["SQRemark"].ToString();
                                (t as BackProgress).CPJTime = dr["CPJTime"].ToString();
                                (t as BackProgress).CPJRemark = dr["CPJRemark"].ToString();
                                (t as BackProgress).HZTime = dr["HZTime"].ToString();
                                (t as BackProgress).HZRemark = dr["HZRemark"].ToString();
                                (t as BackProgress).QZTime = dr["QZTime"].ToString();
                                (t as BackProgress).QZRemark = dr["QZRemark"].ToString();
                                (t as BackProgress).SQQZTime = dr["SQQZTime"].ToString();
                                (t as BackProgress).SQQZRemark = dr["SQQZRemark"].ToString();
                                (t as BackProgress).CQTime = dr["CQTime"].ToString();
                                (t as BackProgress).CQRemark = dr["CQRemark"].ToString();
                                (t as BackProgress).XQHTime = dr["XQHTime"].ToString();
                                (t as BackProgress).XQHRemark = dr["XQHRemark"].ToString();
                                (t as BackProgress).SJTime = dr["SJTime"].ToString();
                                (t as BackProgress).SJRemark = dr["SJRemark"].ToString();
                                (t as BackProgress).OPer = Convert.ToInt32(dr["OPer"]);
                                (t as BackProgress).OPDate = dr["OPDate"].ToString();
                                (t as BackProgress).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "EnterExitCost":
                                (t as EnterExitCost).Id = Convert.ToInt32(dr["Id"]);
                                (t as EnterExitCost).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as EnterExitCost).InsidePay = dr["InsidePay"].ToString();
                                (t as EnterExitCost).VisaPay = dr["VisaPay"].ToString();
                                (t as EnterExitCost).VisaPayRemark = dr["VisaPayRemark"].ToString();
                                (t as EnterExitCost).SafePay = dr["SafePay"].ToString();
                                (t as EnterExitCost).YiMiao = dr["YiMiao"].ToString();
                                (t as EnterExitCost).HeSuan = dr["HeSuan"].ToString();

                                (t as EnterExitCost).ServiceFee = dr["ServiceFee"].ToString();

                                (t as EnterExitCost).Ticket = dr["Ticket"].ToString();
                                (t as EnterExitCost).OutsideJJ = dr["OutsideJJ"].ToString();
                                (t as EnterExitCost).OutsaideGW = dr["OutsaideGW"].ToString();
                                (t as EnterExitCost).AirJJ = dr["AirJJ"].ToString();
                                (t as EnterExitCost).AirGW = dr["AirGW"].ToString();
                                (t as EnterExitCost).CityTranffic = dr["CityTranffic"].ToString();
                                (t as EnterExitCost).RateUSD = float.Parse(dr["RateUSD"].ToString());
                                (t as EnterExitCost).RateJPY = float.Parse(dr["RateJPY"].ToString());
                                (t as EnterExitCost).RateEUR = float.Parse(dr["RateEUR"].ToString());
                                (t as EnterExitCost).RateGBP = float.Parse(dr["RateGBP"].ToString());
                                (t as EnterExitCost).RateHKD = float.Parse(dr["RateHKD"].ToString());
                                (t as EnterExitCost).OPer = Convert.ToInt32(dr["OPer"]);
                                (t as EnterExitCost).OPDate = dr["OPDate"].ToString();
                                (t as EnterExitCost).Isdel = Convert.ToInt32(dr["Isdel"]);
                                (t as EnterExitCost).ChoiceOne = Convert.ToInt32(dr["ChoiceOne"]);
                                (t as EnterExitCost).ChoiceTwo = Convert.ToInt32(dr["ChoiceTwo"]);
                                (t as EnterExitCost).ChoiceThree = Convert.ToInt32(dr["ChoiceThree"]);
                                (t as EnterExitCost).ChoiceFour = Convert.ToInt32(dr["ChoiceFour"]);
                                (t as EnterExitCost).ChoiceFive = Convert.ToInt32(dr["ChoiceFive"]);
                                (t as EnterExitCost).SumJJC = Convert.ToInt32(dr["SumJJC"]);
                                (t as EnterExitCost).SumGWC = Convert.ToInt32(dr["SumGWC"]);
                                (t as EnterExitCost).AirJJC_Checked = Convert.ToInt32(dr["AirJJC_Checked"]);
                                (t as EnterExitCost).AirGWC_Checked = Convert.ToInt32(dr["AirGWC_Checked"]);
                                (t as EnterExitCost).ChoiceSix = Convert.ToInt32(dr["ChoiceSix"]);
                                break;
                            case "DayAndCost":
                                (t as DayAndCost).Id = Convert.ToInt32(dr["Id"]);
                                (t as DayAndCost).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as DayAndCost).Type = Convert.ToInt32(dr["Type"]);
                                (t as DayAndCost).Days = Convert.ToInt32(dr["Days"]);
                                (t as DayAndCost).Place = dr["Place"].ToString();
                                (t as DayAndCost).Cost = dr["Cost"].ToString();
                                (t as DayAndCost).Currency = dr["Currency"].ToString();
                                (t as DayAndCost).SubTotal = dr["SubTotal"].ToString();
                                (t as DayAndCost).OPer = Convert.ToInt32(dr["OPer"]);
                                (t as DayAndCost).OPDate = dr["OPDate"].ToString();
                                (t as DayAndCost).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "DeleProgress":
                                (t as DeleProgress).Id = Convert.ToInt32(dr["Id"]);
                                (t as DeleProgress).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as DeleProgress).BP_GetReady = Convert.ToInt32(dr["BP_GetReady"]);
                                (t as DeleProgress).BP_GetReadyTime = dr["BP_GetReadyTime"].ToString();
                                (t as DeleProgress).BP_Work = Convert.ToInt32(dr["BP_Work"]);
                                (t as DeleProgress).BP_WorkTime = dr["BP_WorkTime"].ToString();
                                (t as DeleProgress).HZ_Work = Convert.ToInt32(dr["HZ_Work"]);
                                (t as DeleProgress).HZ_WorkTime = dr["HZ_WorkTime"].ToString();
                                (t as DeleProgress).QZ_Work = Convert.ToInt32(dr["QZ_Work"]);
                                (t as DeleProgress).QZ_WorkTime = dr["QZ_WorkTime"].ToString();
                                (t as DeleProgress).SQ_Work = Convert.ToInt32(dr["SQ_Work"]);
                                (t as DeleProgress).SQ_WorkTime = dr["SQ_WorkTime"].ToString();
                                (t as DeleProgress).CQ = Convert.ToInt32(dr["CQ"]);
                                (t as DeleProgress).CQTime = dr["CQTime"].ToString();
                                (t as DeleProgress).XQH = Convert.ToInt32(dr["XQH"]);
                                (t as DeleProgress).XQHTime = dr["XQHTime"].ToString();
                                (t as DeleProgress).SJ = Convert.ToInt32(dr["SJ"]);
                                (t as DeleProgress).SJTime = dr["SJTime"].ToString();
                                (t as DeleProgress).OPer = Convert.ToInt32(dr["OPer"]);
                                (t as DeleProgress).OPDate = dr["OPDate"].ToString();
                                break;
                            case "EnterExitPrice":
                                (t as EnterExitPrice).Id = Convert.ToInt32(dr["Id"]);
                                (t as EnterExitPrice).Continent = dr["Continent"].ToString();
                                (t as EnterExitPrice).Country = dr["Country"].ToString();
                                (t as EnterExitPrice).City = dr["City"].ToString();
                                (t as EnterExitPrice).Currency = dr["Currency"].ToString();
                                (t as EnterExitPrice).RoomCost = dr["RoomCost"].ToString();
                                (t as EnterExitPrice).FoodCost = dr["FoodCost"].ToString();
                                (t as EnterExitPrice).PublicCost = dr["PublicCost"].ToString();
                                (t as EnterExitPrice).Oper = Convert.ToInt32(dr["Oper"]);
                                (t as EnterExitPrice).Opdate = dr["Opdate"].ToString();
                                (t as EnterExitPrice).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "Translator":
                                (t as Translator).Id = Convert.ToInt32(dr["Id"]);
                                (t as Translator).OA_Oper = dr["OA_Oper"].ToString();
                                (t as Translator).Name = dr["Name"].ToString();
                                (t as Translator).Back = dr["Back"].ToString();
                                (t as Translator).Resume = dr["Resume"].ToString();
                                (t as Translator).Language = dr["Language"].ToString();
                                (t as Translator).Tel = dr["Tel"].ToString();
                                (t as Translator).Certificate = dr["Certificate"].ToString();
                                (t as Translator).knowRelations = dr["knowRelations"].ToString();
                                (t as Translator).Shorthand = dr["Shorthand"].ToString();
                                (t as Translator).Suit = dr["Suit"].ToString();
                                (t as Translator).List = dr["List"].ToString();
                                (t as Translator).SuitScore = dr["SuitScore"].ToString();
                                (t as Translator).ShortHandScore = dr["ShortHandScore"].ToString();
                                (t as Translator).AbilityScore = dr["AbilityScore"].ToString();
                                (t as Translator).TimeScore = dr["TimeScore"].ToString();
                                (t as Translator).LinkUpScore = dr["LinkUpScore"].ToString();
                                (t as Translator).QualityScore = dr["QualityScore"].ToString();
                                (t as Translator).StrainScore = dr["StrainScore"].ToString();
                                (t as Translator).MeetScore = dr["MeetScore"].ToString();
                                (t as Translator).CertificateScore = dr["CertificateScore"].ToString();
                                (t as Translator).Oper = Convert.ToInt32(dr["Isdel"]);
                                (t as Translator).Opdate = dr["Opdate"].ToString();
                                (t as Translator).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "AirGoods":
                                (t as AirGoods).Id = Convert.ToInt32(dr["Id"]);
                                (t as AirGoods).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as AirGoods).Goods = dr["Goods"].ToString();
                                (t as AirGoods).Price = dr["Price"].ToString();
                                (t as AirGoods).Num = dr["Num"].ToString();
                                (t as AirGoods).SubPrices = dr["SubPrices"].ToString();
                                (t as AirGoods).Remark = dr["Remark"].ToString();
                                (t as AirGoods).Oper = Convert.ToInt32(dr["Isdel"]);
                                (t as AirGoods).Opdate = dr["Opdate"].ToString();
                                (t as AirGoods).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "AirTicketBlackCode":
                                (t as AirTicketBlackCode).Id = Convert.ToInt32(dr["Id"]);
                                (t as AirTicketBlackCode).Diid = Convert.ToInt32(dr["Did"]);
                                (t as AirTicketBlackCode).LeaveCode = dr["LeaveCode"].ToString();
                                (t as AirTicketBlackCode).BlackCode = dr["BlackCode"].ToString();
                                (t as AirTicketBlackCode).ReturnCode = dr["ReturnCode"].ToString();
                                (t as AirTicketBlackCode).Price = dr["Price"].ToString();
                                (t as AirTicketBlackCode).NowPrice = dr["NowPrice"].ToString();
                                (t as AirTicketBlackCode).BCPrice = dr["BCPrice"].ToString();
                                (t as AirTicketBlackCode).ECPrice = dr["ECPrice"].ToString();
                                (t as AirTicketBlackCode).OPer = Convert.ToInt32(dr["OPer"]);
                                (t as AirTicketBlackCode).Opdate = dr["Opdate"].ToString();
                                (t as AirTicketBlackCode).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "TravelList":
                                (t as TravelList).Id = Convert.ToInt32(dr["Id"]);
                                (t as TravelList).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as TravelList).Days = Convert.ToInt32(dr["Days"]);
                                (t as TravelList).Date = dr["Date"].ToString();
                                (t as TravelList).WeekDay = dr["WeekDay"].ToString();
                                (t as TravelList).Traffic_First = dr["Traffic_First"].ToString();
                                (t as TravelList).Traffic_Second = dr["Traffic_Second"].ToString();
                                (t as TravelList).Trip = dr["Trip"].ToString();
                                (t as TravelList).OPer = Convert.ToInt32(dr["OPer"]);
                                (t as TravelList).OPdate = dr["OPdate"].ToString();
                                (t as TravelList).issel = Convert.ToInt32(dr["issel"]);
                                (t as TravelList).diffgroup = Convert.ToInt32(dr["diffgroup"]);
                                (t as TravelList).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "TravelList_External":
                                (t as TravelList_External).Id = Convert.ToInt32(dr["Id"]);
                                (t as TravelList_External).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as TravelList_External).Days = Convert.ToInt32(dr["Days"]);
                                (t as TravelList_External).Date = dr["Date"].ToString();
                                (t as TravelList_External).WeekDay = dr["WeekDay"].ToString();
                                (t as TravelList_External).Traffic_First = dr["Traffic_First"].ToString();
                                (t as TravelList_External).Traffic_Second = dr["Traffic_Second"].ToString();
                                (t as TravelList_External).Trip = dr["Trip"].ToString();
                                (t as TravelList_External).OPer = Convert.ToInt32(dr["OPer"]);
                                (t as TravelList_External).OPdate = dr["OPdate"].ToString();
                                (t as TravelList_External).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "ApprovalTravel":
                                (t as ApprovalTravel).Id = Convert.ToInt32(dr["Id"]);
                                (t as ApprovalTravel).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as ApprovalTravel).Date = dr["Date"].ToString();
                                (t as ApprovalTravel).Time = dr["Time"].ToString();
                                (t as ApprovalTravel).Detail = dr["Detail"].ToString();
                                (t as ApprovalTravel).OPer = Convert.ToInt32(dr["OPer"]);
                                (t as ApprovalTravel).OPdate = dr["OPdate"].ToString();
                                (t as ApprovalTravel).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "VisaCheckOutTime":
                                (t as VisaCheckOutTime).Id = Convert.ToInt32(dr["Id"]);
                                (t as VisaCheckOutTime).Contient = dr["Contient"].ToString();
                                (t as VisaCheckOutTime).Country = dr["Country"].ToString();
                                (t as VisaCheckOutTime).Time = dr["Time"].ToString();
                                (t as VisaCheckOutTime).RushTime = dr["RushTime"].ToString();
                                (t as VisaCheckOutTime).Remark = dr["Remark"].ToString();
                                (t as VisaCheckOutTime).Oper = Convert.ToInt32(dr["Oper"]);
                                (t as VisaCheckOutTime).Opdate = dr["Opdate"].ToString();
                                (t as VisaCheckOutTime).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "VisaCheckTimeForBack":
                                (t as VisaCheckTimeForBack).Id = Convert.ToInt32(dr["Id"]);
                                (t as VisaCheckTimeForBack).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as VisaCheckTimeForBack).Country = dr["Country"].ToString();
                                (t as VisaCheckTimeForBack).Time = dr["Time"].ToString();
                                (t as VisaCheckTimeForBack).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            // 签证费用标准
                            case "Country_FeeCost":
                                (t as Country_FeeCost).VisaId = Convert.ToInt32(dr["VisaId"]);
                                (t as Country_FeeCost).VisaContinent = dr["VisaContinent"].ToString();
                                (t as Country_FeeCost).VisaCountry = dr["VisaCountry"].ToString();
                                (t as Country_FeeCost).IsVisaExemption = Convert.ToInt32(dr["IsVisaExemption"]);
                                (t as Country_FeeCost).IsVisaOnArrival = Convert.ToInt32(dr["IsVisaOnArrival"]);
                                (t as Country_FeeCost).IsElectronicSignature = Convert.ToInt32(dr["IsElectronicSignature"]);
                                (t as Country_FeeCost).VisaPrice = float.Parse(dr["VisaPrice"].ToString());
                                (t as Country_FeeCost).VisaPriceDesc = dr["VisaPriceDesc"].ToString();
                                (t as Country_FeeCost).VisaType = dr["VisaType"].ToString();
                                (t as Country_FeeCost).VisaTime = dr["VisaTime"].ToString();
                                (t as Country_FeeCost).IsUrgent = Convert.ToInt32(dr["IsUrgent"]);
                                (t as Country_FeeCost).UrgentTime = dr["UrgentTime"].ToString();
                                (t as Country_FeeCost).UrgentPrice = float.Parse(dr["UrgentPrice"].ToString());
                                (t as Country_FeeCost).UrgentPriceDesc = dr["UrgentPriceDesc"].ToString();
                                (t as Country_FeeCost).VisaAddress = dr["VisaAddress"].ToString();
                                (t as Country_FeeCost).VisaRemark = dr["VisaRemark"].ToString();
                                (t as Country_FeeCost).Oper = Convert.ToInt32(dr["Oper"]);
                                (t as Country_FeeCost).OPDate = dr["OPDate"].ToString();
                                (t as Country_FeeCost).isDel = Convert.ToInt32(dr["isDel"]);
                                break;
                            case "DelegationInfoOrFeeCost":
                                (t as DelegationInfoOrFeeCost).DFCid = Convert.ToInt32(dr["DFCid"]);
                                (t as DelegationInfoOrFeeCost).DIid = Convert.ToInt32(dr["DIid"]);
                                (t as DelegationInfoOrFeeCost).CFCid = Convert.ToInt32(dr["CFCid"]);
                                (t as DelegationInfoOrFeeCost).Oper = Convert.ToInt32(dr["Oper"]);
                                (t as DelegationInfoOrFeeCost).OpdTime = dr["OpdTime"].ToString();
                                (t as DelegationInfoOrFeeCost).isdel = Convert.ToInt32(dr["isdel"]);
                                break;
                            case "GoogleMapApiResult":
                                (t as GoogleMapApiResult).Id = Convert.ToInt32(dr["Id"]);
                                (t as GoogleMapApiResult).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as GoogleMapApiResult).Date = dr["Date"].ToString();
                                (t as GoogleMapApiResult).Moment = dr["Moment"].ToString();
                                (t as GoogleMapApiResult).StartAddress = dr["StartAddress"].ToString();
                                (t as GoogleMapApiResult).EndAddress = dr["EndAddress"].ToString();
                                (t as GoogleMapApiResult).Time = dr["Time"].ToString();
                                (t as GoogleMapApiResult).Distance = dr["Distance"].ToString();
                                break;
                            case "TravelDetails":
                                (t as TravelDetails).Id = Convert.ToInt32(dr["Id"]);
                                (t as TravelDetails).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as TravelDetails).OrderNum = dr["OrderNum"].ToString();
                                (t as TravelDetails).Date = dr["Date"].ToString();
                                (t as TravelDetails).Time = dr["Time"].ToString();
                                (t as TravelDetails).ActivityType = dr["ActivityType"].ToString();
                                (t as TravelDetails).Activity = dr["Activity"].ToString();
                                (t as TravelDetails).Address = dr["Address"].ToString();
                                (t as TravelDetails).Remark = dr["Remark"].ToString();
                                (t as TravelDetails).OPer = Convert.ToInt32(dr["OPer"]);
                                (t as TravelDetails).Opdate = dr["Opdate"].ToString();
                                (t as TravelDetails).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "InvitingPartyInfo":
                                (t as InvitingPartyInfo).Id = Convert.ToInt32(dr["Id"]);
                                (t as InvitingPartyInfo).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as InvitingPartyInfo).Country = dr["Country"].ToString();
                                (t as InvitingPartyInfo).City = dr["City"].ToString();
                                (t as InvitingPartyInfo).InvitingUnit = dr["InvitingUnit"].ToString();
                                (t as InvitingPartyInfo).InvitingAddress = dr["InvitingAddress"].ToString();
                                (t as InvitingPartyInfo).Contacts = dr["Contacts"].ToString();
                                (t as InvitingPartyInfo).ContactsJob = dr["ContactsJob"].ToString();
                                (t as InvitingPartyInfo).ContactsTel = dr["ContactsTel"].ToString();
                                (t as InvitingPartyInfo).ContactsEmail = dr["ContactsEmail"].ToString();
                                (t as InvitingPartyInfo).ContactsFax = dr["ContactsFax"].ToString();
                                (t as InvitingPartyInfo).InvitingUrl = dr["InvitingUrl"].ToString();
                                (t as InvitingPartyInfo).Oper = Convert.ToInt32(dr["Oper"]);
                                (t as InvitingPartyInfo).Opdate = dr["Opdate"].ToString();
                                (t as InvitingPartyInfo).Isdel = Convert.ToInt32(dr["Isdel"]);
                                (t as InvitingPartyInfo).UnitWeb = dr["UnitWeb"].ToString();
                                (t as InvitingPartyInfo).Field = dr["Field"].ToString();
                                break;
                            case "GroupBudgetInfo":
                                (t as GroupBudgetInfo).G_Id = Convert.ToInt32(dr["G_Id"]);
                                (t as GroupBudgetInfo).G_Diid = Convert.ToInt32(dr["G_Diid"]);
                                (t as GroupBudgetInfo).G_GroupName = dr["G_GroupName"].ToString();
                                (t as GroupBudgetInfo).G_Destination = dr["G_Destination"].ToString();
                                (t as GroupBudgetInfo).G_StartDate = dr["G_StartDate"].ToString();
                                (t as GroupBudgetInfo).G_EndDate = dr["G_EndDate"].ToString();
                                (t as GroupBudgetInfo).G_StayDays = dr["G_StayDays"].ToString();
                                (t as GroupBudgetInfo).G_TripDescribe = dr["G_TripDescribe"].ToString();
                                (t as GroupBudgetInfo).G_GroupNumber = dr["G_GroupNumber"].ToString();
                                (t as GroupBudgetInfo).G_PettyCash = dr["G_PettyCash"].ToString();
                                (t as GroupBudgetInfo).G_InvitationFee = dr["G_InvitationFee"].ToString();
                                (t as GroupBudgetInfo).G_VisaDetails = dr["G_VisaDetails"].ToString();
                                (t as GroupBudgetInfo).G_VisaCoefficient = dr["G_VisaCoefficient"].ToString();
                                (t as GroupBudgetInfo).G_VisaCostPrice = dr["G_VisaCostPrice"].ToString();
                                (t as GroupBudgetInfo).G_VisaOffer = dr["G_VisaOffer"].ToString();
                                (t as GroupBudgetInfo).G_AirDetails = dr["G_AirDetails"].ToString();
                                (t as GroupBudgetInfo).G_AirCoefficient = dr["G_AirCoefficient"].ToString();
                                (t as GroupBudgetInfo).G_AirCostPrice = dr["G_AirCostPrice"].ToString();
                                (t as GroupBudgetInfo).G_AirOffer = dr["G_AirOffer"].ToString();
                                (t as GroupBudgetInfo).G_GroundingDetails = dr["G_GroundingDetails"].ToString();
                                (t as GroupBudgetInfo).G_GroundingCoefficient = dr["G_GroundingCoefficient"].ToString();
                                (t as GroupBudgetInfo).G_GroundingCostPrice = dr["G_GroundingCostPrice"].ToString();
                                (t as GroupBudgetInfo).G_GroundingOffer = dr["G_GroundingOffer"].ToString();
                                (t as GroupBudgetInfo).G_HotelDetails = dr["G_HotelDetails"].ToString();
                                (t as GroupBudgetInfo).G_HotelCoefficient = dr["G_HotelCoefficient"].ToString();
                                (t as GroupBudgetInfo).G_HotelCostPrice = dr["G_HotelCostPrice"].ToString();
                                (t as GroupBudgetInfo).G_HotelOffer = dr["G_HotelOffer"].ToString();
                                (t as GroupBudgetInfo).G_OfficialDetails = dr["G_OfficialDetails"].ToString();
                                (t as GroupBudgetInfo).G_OfficialCoefficient = dr["G_OfficialCoefficient"].ToString();
                                (t as GroupBudgetInfo).G_OfficialCostPrice = dr["G_OfficialCostPrice"].ToString();
                                (t as GroupBudgetInfo).G_OfficialOffer = dr["G_OfficialOffer"].ToString();
                                (t as GroupBudgetInfo).G_Oper = Convert.ToInt32(dr["G_Oper"]);
                                (t as GroupBudgetInfo).G_OPDate = dr["G_OPDate"].ToString();
                                (t as GroupBudgetInfo).G_Isdel = Convert.ToInt32(dr["G_Isdel"]);
                                break;
                            case "Restaurant_OP":
                                (t as Restaurant_OP).Id = Convert.ToInt32(dr["Id"]);
                                (t as Restaurant_OP).Country = dr["Country"].ToString();
                                (t as Restaurant_OP).City = dr["City"].ToString();
                                (t as Restaurant_OP).Name = dr["Name"].ToString();
                                (t as Restaurant_OP).SpecialDishes = dr["SpecialDishes"].ToString();
                                (t as Restaurant_OP).Address = dr["Address"].ToString();
                                (t as Restaurant_OP).Standard = dr["Standard"].ToString();
                                (t as Restaurant_OP).Currency = dr["Currency"].ToString();
                                (t as Restaurant_OP).PrivateRoom = dr["PrivateRoom"].ToString();
                                (t as Restaurant_OP).Remark = dr["Remark"].ToString();
                                (t as Restaurant_OP).OPer = Convert.ToInt32(dr["OPer"]);
                                (t as Restaurant_OP).OPdate = dr["OPdate"].ToString();
                                (t as Restaurant_OP).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "CarGuides":
                                (t as CarGuides).Id = Convert.ToInt32(dr["Id"]);
                                (t as CarGuides).Country = dr["Country"].ToString();
                                (t as CarGuides).City = dr["City"].ToString();
                                (t as CarGuides).ServiceType = dr["ServiceType"].ToString();
                                (t as CarGuides).CarType = dr["CarType"].ToString();
                                (t as CarGuides).Offer = dr["Offer"].ToString();
                                (t as CarGuides).CGCost = dr["CGCost"].ToString();
                                (t as CarGuides).RuningTime = dr["RuningTime"].ToString();
                                (t as CarGuides).OvertimeFee = dr["OvertimeFee"].ToString();
                                (t as CarGuides).CGOvertimeFee = dr["CGOvertimeFee"].ToString();
                                (t as CarGuides).Currency = dr["Currency"].ToString();
                                (t as CarGuides).Remark = dr["Remark"].ToString();
                                (t as CarGuides).Oper = Convert.ToInt32(dr["Oper"]);
                                (t as CarGuides).OpDate = dr["OpDate"].ToString();
                                (t as CarGuides).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "GuidesInfo":
                                (t as GuidesInfo).Id = Convert.ToInt32(dr["Id"]);
                                (t as GuidesInfo).Country = dr["Country"].ToString();
                                (t as GuidesInfo).City = dr["City"].ToString();
                                (t as GuidesInfo).ServiceType = dr["ServiceType"].ToString();
                                (t as GuidesInfo).When = dr["When"].ToString();
                                (t as GuidesInfo).Price = dr["Price"].ToString();
                                (t as GuidesInfo).TranslationPrice = dr["TranslationPrice"].ToString();
                                (t as GuidesInfo).OvertimeFee = dr["OvertimeFee"].ToString();
                                (t as GuidesInfo).Currency = dr["Currency"].ToString();
                                (t as GuidesInfo).Remark = dr["Remark"].ToString();
                                (t as GuidesInfo).Oper = Convert.ToInt32(dr["Oper"]);
                                (t as GuidesInfo).OpDate = dr["OpDate"].ToString();
                                (t as GuidesInfo).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "ScenicSpotInfo":
                                (t as ScenicSpotInfo).Id = Convert.ToInt32(dr["Id"]);
                                (t as ScenicSpotInfo).Country = dr["Country"].ToString();
                                (t as ScenicSpotInfo).City = dr["City"].ToString();
                                (t as ScenicSpotInfo).ScenicSpot = dr["ScenicSpot"].ToString();
                                (t as ScenicSpotInfo).ScenicSpotDetail = dr["ScenicSpotDetail"].ToString();
                                (t as ScenicSpotInfo).Price = float.Parse(dr["Price"].ToString());
                                (t as ScenicSpotInfo).Currency = dr["Currency"].ToString();
                                (t as ScenicSpotInfo).Rate = float.Parse(dr["Rate"].ToString());
                                (t as ScenicSpotInfo).Address = dr["Address"].ToString();
                                (t as ScenicSpotInfo).Oper = Convert.ToInt32(dr["Oper"]);
                                (t as ScenicSpotInfo).OpDate = dr["OpDate"].ToString();
                                (t as ScenicSpotInfo).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "CarInfo":
                                (t as CarInfo).Id = Convert.ToInt32(dr["Id"]);
                                (t as CarInfo).Country = dr["Country"].ToString();
                                (t as CarInfo).City = dr["City"].ToString();
                                (t as CarInfo).CarType = dr["CarType"].ToString();
                                (t as CarInfo).ServiceType = dr["ServiceType"].ToString();
                                (t as CarInfo).When = dr["When"].ToString();
                                (t as CarInfo).Price = dr["Price"].ToString();
                                (t as CarInfo).Currency = dr["Currency"].ToString();
                                (t as CarInfo).OvertimeFee = dr["OvertimeFee"].ToString();
                                (t as CarInfo).Remark = dr["Remark"].ToString();
                                (t as CarInfo).Oper = Convert.ToInt32(dr["Oper"]);
                                (t as CarInfo).OpDate = dr["OpDate"].ToString();
                                (t as CarInfo).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "CheckBoxs":
                                (t as CheckBoxs).Id = Convert.ToInt32(dr["Id"]);
                                (t as CheckBoxs).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as CheckBoxs).cbType = dr["cbType"].ToString();
                                (t as CheckBoxs).cbValues = dr["cbValues"].ToString();
                                (t as CheckBoxs).Oper = Convert.ToInt32(dr["Oper"]);
                                (t as CheckBoxs).OPDate = dr["OPDate"].ToString();
                                (t as CheckBoxs).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "BackwardTable_Visa":
                                (t as BackwardTable_Visa).BT_Id = Convert.ToInt32(dr["BT_Id"]);
                                (t as BackwardTable_Visa).BT_Diid = Convert.ToInt32(dr["BT_Diid"]);
                                (t as BackwardTable_Visa).BT_VisaCountry = dr["BT_VisaCountry"].ToString();
                                (t as BackwardTable_Visa).BT_BusinessType = dr["BT_BusinessType"].ToString();
                                (t as BackwardTable_Visa).BT_VisaType = dr["BT_VisaType"].ToString();
                                (t as BackwardTable_Visa).BT_VisaTime = dr["BT_VisaTime"].ToString();
                                (t as BackwardTable_Visa).BT_Oper = Convert.ToInt32(dr["BT_Oper"]);
                                (t as BackwardTable_Visa).BT_OperDate = dr["BT_OperDate"].ToString();
                                (t as BackwardTable_Visa).BT_Isdel = Convert.ToInt32(dr["BT_Isdel"]);
                                break;
                            case "Commission":
                                (t as Commission).Id = Convert.ToInt32(dr["Id"]);
                                (t as Commission).Personnel = Convert.ToInt32(dr["Personnel"]);
                                (t as Commission).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as Commission).GroupDate = dr["GroupDate"].ToString();
                                (t as Commission).GroupLvl = dr["GroupLvl"].ToString();
                                (t as Commission).NetProfit = dr["NetProfit"].ToString();
                                (t as Commission).Balance = dr["Balance"].ToString();
                                (t as Commission).Detail = dr["Detail"].ToString();
                                (t as Commission).Money = dr["Money"].ToString();
                                (t as Commission).WageYearMonth = dr["WageYearMonth"].ToString();
                                (t as Commission).IsMakeLoss = Convert.ToInt32(dr["IsMakeLoss"]);
                                (t as Commission).IsLoss = Convert.ToInt32(dr["IsLoss"]);
                                (t as Commission).OPer = Convert.ToInt32(dr["OPer"]);
                                (t as Commission).OPDate = dr["OPDate"].ToString();
                                (t as Commission).IsDel = Convert.ToInt32(dr["IsDel"]);
                                break;
                            case "SendMachineSuppliesData":
                                (t as SendMachineSuppliesData).Id = Convert.ToInt32(dr["Id"]);
                                (t as SendMachineSuppliesData).Country = dr["Country"].ToString();
                                (t as SendMachineSuppliesData).MaterialName = dr["MaterialName"].ToString();
                                (t as SendMachineSuppliesData).MaterialPrice = float.Parse(dr["MaterialPrice"].ToString());
                                (t as SendMachineSuppliesData).MaterialRemark = dr["MaterialRemark"].ToString();
                                (t as SendMachineSuppliesData).Operator = Convert.ToInt32(dr["Operator"]);
                                (t as SendMachineSuppliesData).OperatingTime = dr["OperatingTime"].ToString();
                                (t as SendMachineSuppliesData).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "TeamAttachmentInfo":
                                (t as TeamAttachmentInfo).Id = Convert.ToInt32(dr["Id"]);
                                (t as TeamAttachmentInfo).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as TeamAttachmentInfo).AirNumber = Convert.ToInt32(dr["AirNumber"]);
                                (t as TeamAttachmentInfo).HotelNumber = Convert.ToInt32(dr["HotelNumber"]);
                                (t as TeamAttachmentInfo).VisaNumber = Convert.ToInt32(dr["VisaNumber"]);
                                (t as TeamAttachmentInfo).InvitedNumber = Convert.ToInt32(dr["InvitedNumber"]);
                                (t as TeamAttachmentInfo).OfficialNumber = Convert.ToInt32(dr["OfficialNumber"]);
                                (t as TeamAttachmentInfo).PickNumber = Convert.ToInt32(dr["PickNumber"]);
                                (t as TeamAttachmentInfo).Oper = Convert.ToInt32(dr["Oper"]);
                                (t as TeamAttachmentInfo).OperDate = dr["OperDate"].ToString();
                                (t as TeamAttachmentInfo).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "TravelUsers": // 外部用户登陆表  雷怡 2021-10-12 11:46
                                (t as TravelUsers).Id = Convert.ToInt32(dr["Id"]);
                                (t as TravelUsers).LoginName = dr["LoginName"].ToString();
                                (t as TravelUsers).LoginPassWord = dr["LoginPassWord"].ToString();
                                (t as TravelUsers).SubordinateUnits = dr["SubordinateUnits"].ToString();
                                (t as TravelUsers).CareteTime = dr["CareteTime"].ToString();
                                (t as TravelUsers).LoginState = Convert.ToInt32(dr["LoginState"]);
                                (t as TravelUsers).Oper = Convert.ToInt32(dr["Oper"]);
                                (t as TravelUsers).OperDate = dr["OperDate"].ToString();
                                (t as TravelUsers).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "TravelUsersAndDiid": // 外部行程用户关联团组行程Diid表  雷怡 2021-10-12 11:48
                                (t as TravelUsersAndDiid).Id = Convert.ToInt32(dr["Id"]);
                                (t as TravelUsersAndDiid).TravelUsersId = Convert.ToInt32(dr["TravelUsersId"]);
                                (t as TravelUsersAndDiid).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as TravelUsersAndDiid).Oper = Convert.ToInt32(dr["Oper"]);
                                (t as TravelUsersAndDiid).OperDate = dr["OperDate"].ToString();
                                (t as TravelUsersAndDiid).Isdel = Convert.ToInt32(dr["Isdel"]);
                                break;
                            case "TravelUsersLoginRecord": // 外部行程用户登陆记录  雷怡 2021-10-12 11:48
                                (t as TravelUsersLoginRecord).Id = Convert.ToInt32(dr["Id"]);
                                (t as TravelUsersLoginRecord).TravelUsersId = Convert.ToInt32(dr["TravelUsersId"]);
                                (t as TravelUsersLoginRecord).LoginAddress = dr["LoginAddress"].ToString();
                                (t as TravelUsersLoginRecord).LoginDeviceName = dr["LoginDeviceName"].ToString();
                                (t as TravelUsersLoginRecord).LoginMacAddress = dr["LoginMacAddress"].ToString();
                                (t as TravelUsersLoginRecord).LoginRealIPAddress = dr["LoginRealIPAddress"].ToString();
                                (t as TravelUsersLoginRecord).LoginIntranetIPAddress = dr["LoginIntranetIPAddress"].ToString();
                                (t as TravelUsersLoginRecord).LoginBrowser = dr["LoginBrowser"].ToString();
                                (t as TravelUsersLoginRecord).LoginBrowserType = dr["LoginBrowserType"].ToString();
                                (t as TravelUsersLoginRecord).LoginBrowserVersion = dr["LoginBrowserVersion"].ToString();
                                (t as TravelUsersLoginRecord).LoginDateTime = dr["LoginDateTime"].ToString();

                                break;
                            case "AssociationGroup": // 外部行程用户登陆记录  雷怡 2021-10-12 11:48
                                (t as AssociationGroup).id = Convert.ToInt32(dr["id"]);
                                (t as AssociationGroup).Ipid = Convert.ToInt32(dr["Ipid"]);
                                (t as AssociationGroup).IoaId = Convert.ToInt32(dr["IoaId"]);
                                (t as AssociationGroup).Diid = Convert.ToInt32(dr["Diid"]);

                                break;

                            case "AirAdvanceInquiry": // 外部行程用户登陆记录  雷怡 2021-10-12 11:48
                                (t as AirAdvanceInquiry).Id = Convert.ToInt32(dr["Id"]);
                                (t as AirAdvanceInquiry).Diid = Convert.ToInt32(dr["Diid"]);
                                (t as AirAdvanceInquiry).Area = dr["Area"].ToString();
                                (t as AirAdvanceInquiry).Airlines = dr["Airlines"].ToString();
                                (t as AirAdvanceInquiry).Shift = dr["Shift"].ToString();
                                (t as AirAdvanceInquiry).StartTime = dr["StartTime"].ToString();;
                                (t as AirAdvanceInquiry).EndTime =dr["EndTime"].ToString();
                                (t as AirAdvanceInquiry).SpaceType = dr["SpaceType"].ToString();
                                (t as AirAdvanceInquiry).SelectTime =dr["SelectTime"].ToString();;
                                (t as AirAdvanceInquiry).LowestPrice = float.Parse(dr["LowestPrice"].ToString());
                                (t as AirAdvanceInquiry).Remark =dr["Remark"].ToString();
                                (t as AirAdvanceInquiry).Oper = Convert.ToInt32(dr["Oper"]);
                                (t as AirAdvanceInquiry).OperDate =dr["OperDate"].ToString();
                                (t as AirAdvanceInquiry).Isdel = Convert.ToInt32(dr["Isdel"]);
                                (t as AirAdvanceInquiry).FullPrice = float.Parse(dr["FullPrice"].ToString());
                                (t as AirAdvanceInquiry).InstantPrice = float.Parse(dr["InstantPrice"].ToString());
                                break;
                            case "hotelidbreakfast": // 酒店早餐表
                                (t as hotelidbreakfast).Tid = Convert.ToInt32(dr["tid"]);
                                (t as hotelidbreakfast).Diid = Convert.ToInt32(dr["diid"]);
                                (t as hotelidbreakfast).Hotelid = dr["hotelid"].ToString();
                                (t as hotelidbreakfast).BreakfastPrice = float.Parse(dr["breakfastPrice"].ToString());
                                (t as hotelidbreakfast).Isdel = Convert.ToInt32(dr["isdel"]);
                                break;
                            case "opitineraryfixed": // 手册固定字段
                                (t as opitineraryfixed).Tid = Convert.ToInt32(dr["tid"]);
                                (t as opitineraryfixed).ItemPrepare = dr["itemPrepare"].ToString();
                                (t as opitineraryfixed).SpecialReminder = dr["specialReminder"].ToString();
                                (t as opitineraryfixed).CGPrecautions = dr["CGPrecautions"].ToString();
                                (t as opitineraryfixed).YGCG = dr["YGCG"].ToString();
                                (t as opitineraryfixed).Conduct = dr["Conduct"].ToString();
                                (t as opitineraryfixed).CommonEnglish = dr["CommonEnglish"].ToString();
                                break;
                            case "opitinerarydata": // 手册非固定字段
                                (t as opitinerarydata).Tid = Convert.ToInt32(dr["tid"]);
                                (t as opitinerarydata).Name = dr["name"].ToString();
                                (t as opitinerarydata).Introduction = dr["Introduction"].ToString();
                                (t as opitinerarydata).TimeDifference = dr["timeDifference"].ToString();
                                (t as opitinerarydata).CurrExchangeRate = float.Parse(dr["currExchangeRate"].ToString());
                                (t as opitinerarydata).Temperature = dr["temperature"].ToString();
                                break;
                            case "ViewbreakfastPrice":
                                (t as ViewbreakfastPrice).breakfastPrice = float.Parse(dr["breakfastPrice"].ToString());
                                (t as ViewbreakfastPrice).City = dr["City"].ToString();
                                (t as ViewbreakfastPrice).PaymentCurrency = int.Parse(dr["PaymentCurrency"].ToString());
                                (t as ViewbreakfastPrice).HotelName = dr["HotelName"].ToString();
                                (t as ViewbreakfastPrice).PayMoney = float.Parse(dr["PayMoney"].ToString());
                                (t as ViewbreakfastPrice).DayRate = float.Parse(dr["DayRate"].ToString());
                                (t as ViewbreakfastPrice).RMBPrice = float.Parse(dr["RMBPrice"].ToString());
                                (t as ViewbreakfastPrice).PayCurrencyName = dr["PayCurrencyName"].ToString();
                                break;
                            case "TrainingExpenses":
                                (t as TrainingExpenses).id = int.Parse(dr["id"].ToString());
                                (t as TrainingExpenses).continent = dr["continent"].ToString();
                                (t as TrainingExpenses).country = dr["country"].ToString();
                                (t as TrainingExpenses).currency = dr["currency"].ToString();
                                (t as TrainingExpenses).expense = float.Parse(dr["expense"].ToString());
                                (t as TrainingExpenses).operationTime = DateTime.Parse(dr["operationTime"].ToString());
                                (t as TrainingExpenses).operationUser = dr["operationUser"].ToString();
                                (t as TrainingExpenses).isdel = int.Parse(dr["isdel"].ToString());
                                break;
                            case "Position":
                                (t as Position).Id = int.Parse(dr["id"].ToString());
                                (t as Position).JobTitleCn = dr["JobTitleCn"].ToString();
                                (t as Position).JobTitleEn = dr["JobTitleEn"].ToString();
                                (t as Position).SetDataId = int.Parse(dr["SetDataId"].ToString());
                                (t as Position).IsDel = int.Parse(dr["IsDel"].ToString());
                                break;
                            case "ApprovalTravelDetails":
                                (t as ApprovalTravelDetails).Id = int.Parse(dr["id"].ToString());
                                (t as ApprovalTravelDetails).Time = dr["Time"].ToString();
                                (t as ApprovalTravelDetails).ParentId =int.Parse(dr["parentId"].ToString());
                                (t as ApprovalTravelDetails).Details = dr["Details"].ToString();
                                (t as ApprovalTravelDetails).IsDel = int.Parse(dr["isdel"].ToString());
                                break;
                            case "grouopExceed":
                                (t as grouopExceed).Id = Convert.ToInt32(dr["Id"]);
                                (t as grouopExceed).DIID = Convert.ToInt32(dr["DIID"]);
                                (t as grouopExceed).PriceName = dr["PriceName"].ToString();
                                (t as grouopExceed).Price = string.IsNullOrWhiteSpace(dr["Price"].ToString()) ? 0.00M : decimal.Parse(dr["Price"].ToString());
                                (t as grouopExceed).Currency = Convert.ToInt32(dr["Currency"]);
                                (t as grouopExceed).FilePath = dr["FilePath"].ToString();
                                (t as grouopExceed).Remark = dr["Remark"].ToString();
                                (t as grouopExceed).Operators = Convert.ToInt32(dr["operators"]);
                                (t as grouopExceed).OperatorsDate = dr["OperatorsDate"].ToString();
                                (t as grouopExceed).IsDel = Convert.ToInt32(dr["IsDel"]);
                                (t as grouopExceed).PriceType = string.IsNullOrWhiteSpace(dr["PriceType"].ToString()) ? 0 : int.Parse(dr["PriceType"].ToString());
                                (t as grouopExceed).coefficient = string.IsNullOrWhiteSpace(dr["coefficient"].ToString()) ? 0.00M : decimal.Parse(dr["coefficient"].ToString());
                                (t as grouopExceed).PriceTypeDetail = string.IsNullOrWhiteSpace(dr["PriceTypeDetail"].ToString()) ? 0 : int.Parse(dr["PriceTypeDetail"].ToString());
                                break;
                            case "CostTypeHotelNumber":
                                (t as CostTypeHotelNumber).id = string.IsNullOrWhiteSpace(dr["id"].ToString()) ? 0 : int.Parse(dr["id"].ToString());
                                (t as CostTypeHotelNumber).ASGR = string.IsNullOrWhiteSpace(dr["ASGR"].ToString()) ? 0 : int.Parse(dr["ASGR"].ToString());
                                (t as CostTypeHotelNumber).BSGR = string.IsNullOrWhiteSpace(dr["BSGR"].ToString()) ? 0 : int.Parse(dr["BSGR"].ToString());
                                (t as CostTypeHotelNumber).ATBR = string.IsNullOrWhiteSpace(dr["ATBR"].ToString()) ? 0 : int.Parse(dr["ATBR"].ToString());
                                (t as CostTypeHotelNumber).BTBR = string.IsNullOrWhiteSpace(dr["BTBR"].ToString()) ? 0 : int.Parse(dr["BTBR"].ToString());
                                (t as CostTypeHotelNumber).AJSES = string.IsNullOrWhiteSpace(dr["AJSES"].ToString()) ? 0 : int.Parse(dr["AJSES"].ToString());
                                (t as CostTypeHotelNumber).BJSES = string.IsNullOrWhiteSpace(dr["BJSES"].ToString()) ? 0 : int.Parse(dr["BJSES"].ToString());
                                (t as CostTypeHotelNumber).ASUITE = string.IsNullOrWhiteSpace(dr["ASUITE"].ToString()) ? 0 : int.Parse(dr["ASUITE"].ToString());
                                (t as CostTypeHotelNumber).BSUITE = string.IsNullOrWhiteSpace(dr["BSUITE"].ToString()) ? 0 : int.Parse(dr["BSUITE"].ToString());
                                (t as CostTypeHotelNumber).DIID = string.IsNullOrWhiteSpace(dr["DIID"].ToString()) ? 0 : int.Parse(dr["DIID"].ToString());
                                (t as CostTypeHotelNumber).IsDel = string.IsNullOrWhiteSpace(dr["IsDel"].ToString()) ? 0 : int.Parse(dr["IsDel"].ToString());
                                break;
                            case "grouopExceedView":
                                (t as grouopExceedView).TeamName = dr["TeamName"].ToString(); ;
                                (t as grouopExceedView).operatorsDate  = dr["operatorsDate"].ToString();
                                (t as grouopExceedView).PriceType = Convert.ToInt32(dr["PriceType"]);
                                (t as grouopExceedView).PriceName  = dr["PriceName"].ToString();
                                (t as grouopExceedView).Price  = string.IsNullOrWhiteSpace(dr["Price"].ToString()) ? 0.00F : float.Parse(dr["Price"].ToString());
                                (t as grouopExceedView).Currency  = dr["Currency"].ToString();
                                (t as grouopExceedView).DayRate  = string.IsNullOrWhiteSpace(dr["DayRate"].ToString()) ? 0.00F : float.Parse(dr["DayRate"].ToString());
                                (t as grouopExceedView).RMBPrice = string.IsNullOrWhiteSpace(dr["RMBPrice"].ToString()) ? 0.00F : float.Parse(dr["RMBPrice"].ToString());
                                (t as grouopExceedView).Coefficient = string.IsNullOrWhiteSpace(dr["Coefficient"].ToString()) ? 0.00M : decimal.Parse(dr["Coefficient"].ToString());
                                (t as grouopExceedView).remark = dr["remark"].ToString();
                                break;
                        }
                        tList.Add(t);
                    }
                }
            }
            return tList;
        }
    }
}