public decimal ReturnTeamProFit(string tid, string cid)
 {
     decimal profit = 0;
     decimal totalincome = 0;
     mod = bll.GetList(Convert.ToInt32(tid));
     if (cid == "4" || cid == "5")//地接
     {
         profit = (mod.TotalIncome + mod.JDIncome + mod.OtherIncome) - (mod.QuoteOuterPrice + mod.OtherCost + mod.BookPrice);
     }
     else if (cid == "1" || cid == "3")//散客
     {
         IList<MBL_TeamInfo> ilist = bll.GetListsByFilterString(" State>-1 and ParentID=" + tid);
         foreach (MBL_TeamInfo team in ilist)
         {
             totalincome += team.TotalIncome;
         }
         profit = (totalincome + mod.OtherIncome + mod.JDIncome) - (mod.QuoteOuterPrice + mod.OtherCost + mod.BookPrice);
     }
     return profit;
 }
示例#2
0
 /// <summary>
 /// 返回一条记录
 /// </summary>
 /// <param name="id">键值</param>
 public MBL_User GetList(int id)
 {
     MBL_User str = null;
      SqlParameter parm = new SqlParameter(PARM_UID, SqlDbType.Int, 4);
      parm.Value = id;
      using (SqlDataReader rdr = SqlHelper.ExecuteReader(ConnectionInfo.DBConnStr, CommandType.Text, SqlstrbyID, parm))
      {
          if (rdr.Read())
          {
              MBL_User info = new MBL_User(Convert.ToInt32(rdr.GetValue(0).Equals(DBNull.Value)?"0":rdr.GetValue(0).ToString()),Convert.ToInt32(rdr.GetValue(1).Equals(DBNull.Value)?"0":rdr.GetValue(1).ToString()),Convert.ToInt32(rdr.GetValue(2).Equals(DBNull.Value)?"0":rdr.GetValue(2).ToString()),Convert.ToInt32(rdr.GetValue(3).Equals(DBNull.Value)?"0":rdr.GetValue(3).ToString()),rdr.GetValue(4).ToString(),rdr.GetValue(5).ToString(),rdr.GetValue(6).ToString(),rdr.GetValue(7).ToString(),Convert.ToBoolean(rdr.GetValue(8).Equals(DBNull.Value)?"0":rdr.GetValue(8).ToString()),rdr.GetValue(9).ToString(),rdr.GetValue(10).ToString(),Convert.ToDateTime(rdr.GetValue(11).Equals(DBNull.Value)?"1900-01-01":rdr.GetValue(11).ToString()),rdr.GetValue(12).ToString(),Convert.ToInt32(rdr.GetValue(13).Equals(DBNull.Value)?"0":rdr.GetValue(13).ToString()),rdr.GetValue(14).ToString(),Convert.ToBoolean(rdr.GetValue(15).Equals(DBNull.Value)?"0":rdr.GetValue(15).ToString()),rdr.GetValue(16).ToString(),rdr.GetValue(17).ToString(),rdr.GetValue(18).ToString(),rdr.GetValue(19).ToString(),Convert.ToDateTime(rdr.GetValue(20).Equals(DBNull.Value)?"1900-01-01":rdr.GetValue(20).ToString()),rdr.GetValue(22).ToString(),rdr.GetValue(23).ToString(),rdr.GetValue(24).ToString(),rdr.GetValue(25).ToString(),rdr.GetValue(26).ToString(),rdr.GetValue(27).ToString(),rdr.GetValue(28).ToString(),Convert.ToDateTime(rdr.GetValue(30).Equals(DBNull.Value)?"1900-01-01":rdr.GetValue(30).ToString()),rdr.GetValue(32).ToString(),rdr.GetValue(33).ToString(),rdr.GetValue(34).ToString());
              str = info;
          }
          else
          {
              MBL_TeamInfo info = new MBL_TeamInfo();
              str = info;
          }
      }
      return str;
 }
示例#3
0
 /// <summary>
 /// 修改一条记录
 /// </summary>
 public void Modify(MBL_TeamInfo info)
 {
     DAL.Modify(info);
 }
示例#4
0
 /// <summary>
 /// 增加一条记录
 /// </summary>
 public object Insert(MBL_TeamInfo info)
 {
     return DAL.Insert(info);
 }
示例#5
0
 /// <summary>
 /// 修改一条记录
 /// </summary>
 public void Modify(MBL_TeamInfo info)
 {
     SqlParameter[] orderParms = GetOrderParameters();
      SqlCommand cmd = new SqlCommand();
      orderParms[0].Value = info.TID;
      orderParms[1].Value = info.ParentID;
      orderParms[2].Value = info.MPID;
      orderParms[3].Value = info.INID;
      orderParms[4].Value = info.CID;
      orderParms[5].Value = info.CPID;
      orderParms[6].Value = info.TeamTypeID;
      orderParms[7].Value = info.INTRID;
      orderParms[8].Value = info.MyTeamNum;
      orderParms[9].Value = info.CopartnerTeamNum;
      orderParms[10].Value = info.StartDate;
      orderParms[11].Value = info.EndDate;
      orderParms[12].Value = info.AdultNum;
      orderParms[13].Value = info.ChildNum;
      orderParms[14].Value = info.AccompanyNum;
      orderParms[15].Value = info.Contractor;
      orderParms[16].Value = info.ConTel;
      orderParms[17].Value = info.ConFax;
      orderParms[18].Value = info.AccompanyName;
      orderParms[19].Value = info.NeedGuide;
      orderParms[20].Value = info.GuideSex;
      orderParms[21].Value = info.GuideGradeID;
      orderParms[22].Value = info.GuideLanguageID;
      orderParms[23].Value = info.GatherPlace;
      orderParms[24].Value = info.GatherMarks;
      orderParms[25].Value = info.GoodByePlace;
      orderParms[26].Value = info.RoomStarID;
      orderParms[27].Value = info.LIDString;
      orderParms[28].Value = info.SDRNum;
      orderParms[29].Value = info.SGRNum;
      orderParms[30].Value = info.TRRNum;
      orderParms[31].Value = info.State;
      orderParms[32].Value = info.AdultPrice;
      orderParms[33].Value = info.ChildPrice;
      orderParms[34].Value = info.TotalIncome;
      orderParms[35].Value = info.OtherIncome;
      orderParms[36].Value = info.SKMethodID;
      orderParms[37].Value = info.SendTicketID;
      orderParms[38].Value = info.CountryID;
      orderParms[39].Value = info.FromCityID;
      orderParms[40].Value = info.RoomNum;
      orderParms[41].Value = info.RoomNum1;
      orderParms[42].Value = info.RoomNum3;
      orderParms[43].Value = info.ReachFlightNo;
      orderParms[44].Value = info.LeaveFlightNo;
      orderParms[45].Value = info.ReachFlightContent;
      orderParms[46].Value = info.LeaveFlightContent;
      orderParms[47].Value = info.SingleVerify;
      orderParms[48].Value = info.Checked;
      orderParms[49].Value = info.IsMerged;
      orderParms[50].Value = info.UserID;
      orderParms[51].Value = info.GroupID;
      orderParms[52].Value = info.QuoteRemark;
      orderParms[53].Value = info.OrderRemark;
      orderParms[54].Value = info.ViewSpotEnterNum;
      orderParms[55].Value = info.AddDate;
      orderParms[56].Value = info.ModifyUID;
      orderParms[57].Value = info.ModifyDate;
      orderParms[58].Value = info.Remarks;
      orderParms[59].Value = info.CheckAmount;
      orderParms[60].Value = info.QuoteOuterPrice;
      orderParms[61].Value = info.BookPrice;
      orderParms[62].Value = info.OtherCost;
      orderParms[63].Value = info.JDIncome;
      orderParms[64].Value = info.LineCost;
      orderParms[65].Value = info.LineIncome;
      orderParms[66].Value = info.LGroupID;
      orderParms[67].Value = info.WLUserID;
      orderParms[68].Value = info.Export;
      orderParms[69].Value = info.OrderDaSuoTicketTime;
      orderParms[70].Value = info.OrderXiaoSuoTicketTime;
      orderParms[71].Value = info.OrderMaoNiuTicketTime;
      orderParms[72].Value = info.OrderYingXiangTicketTime;
      orderParms[73].Value = info.OrderDaSuoTicketNum;
      orderParms[74].Value = info.OrderXiaoSuoTicketNum;
      orderParms[75].Value = info.OrderMaoNiuTicketNum;
      orderParms[76].Value = info.OrderYinXiangTicketNum;
      orderParms[77].Value = info.AuditOneUID;
      orderParms[78].Value = info.AuditTwoUID;
      orderParms[79].Value = info.ProvinceAccompany;
      orderParms[80].Value = info.UTotalIncome;
      foreach (SqlParameter parm in orderParms)
      {
          cmd.Parameters.Add(parm);
      }
      using (SqlConnection conn = new SqlConnection(ConnectionInfo.DBConnStr))
      {
          conn.Open();
          cmd.Connection = conn;
          cmd.CommandType = CommandType.Text;
          cmd.CommandText = ModifySqlstr;
          obj = cmd.ExecuteNonQuery();
          cmd.Parameters.Clear();
       }
 }
示例#6
0
 public IList<MBL_TeamInfo> GetListsByFilterString(string FilterString, string OrderByString)
 {
     IList<MBL_TeamInfo> strs = new List<BL_TeamInfo>();
      using (SqlDataReader rdr = SqlHelper.ExecuteReader(ConnectionInfo.DBConnStr, CommandType.Text, "Select * From BL_TeamInfo Where " + FilterString + " order by " + OrderByString, null))
      {
          while (rdr.Read())
          {
              MBL_TeamInfo info = new MBL_TeamInfo(Convert.ToInt32(rdr.GetValue(0).Equals(DBNull.Value)?"0":rdr.GetValue(0).ToString()),Convert.ToInt32(rdr.GetValue(1).Equals(DBNull.Value)?"0":rdr.GetValue(1).ToString()),Convert.ToInt32(rdr.GetValue(2).Equals(DBNull.Value)?"0":rdr.GetValue(2).ToString()),Convert.ToInt32(rdr.GetValue(3).Equals(DBNull.Value)?"0":rdr.GetValue(3).ToString()),Convert.ToInt32(rdr.GetValue(4).Equals(DBNull.Value)?"0":rdr.GetValue(4).ToString()),Convert.ToInt32(rdr.GetValue(5).Equals(DBNull.Value)?"0":rdr.GetValue(5).ToString()),Convert.ToInt32(rdr.GetValue(6).Equals(DBNull.Value)?"0":rdr.GetValue(6).ToString()),Convert.ToInt32(rdr.GetValue(7).Equals(DBNull.Value)?"0":rdr.GetValue(7).ToString()),rdr.GetValue(8).ToString(),rdr.GetValue(9).ToString(),Convert.ToDateTime(rdr.GetValue(10).Equals(DBNull.Value)?"1900-01-01":rdr.GetValue(10).ToString()),Convert.ToDateTime(rdr.GetValue(11).Equals(DBNull.Value)?"1900-01-01":rdr.GetValue(11).ToString()),Convert.ToInt32(rdr.GetValue(12).Equals(DBNull.Value)?"0":rdr.GetValue(12).ToString()),Convert.ToInt32(rdr.GetValue(13).Equals(DBNull.Value)?"0":rdr.GetValue(13).ToString()),Convert.ToInt32(rdr.GetValue(14).Equals(DBNull.Value)?"0":rdr.GetValue(14).ToString()),rdr.GetValue(15).ToString(),rdr.GetValue(16).ToString(),rdr.GetValue(17).ToString(),rdr.GetValue(18).ToString(),Convert.ToBoolean(rdr.GetValue(19).Equals(DBNull.Value)?"0":rdr.GetValue(19).ToString()),Convert.ToInt32(rdr.GetValue(21).Equals(DBNull.Value)?"0":rdr.GetValue(21).ToString()),Convert.ToInt32(rdr.GetValue(22).Equals(DBNull.Value)?"0":rdr.GetValue(22).ToString()),rdr.GetValue(23).ToString(),rdr.GetValue(24).ToString(),rdr.GetValue(25).ToString(),Convert.ToInt32(rdr.GetValue(26).Equals(DBNull.Value)?"0":rdr.GetValue(26).ToString()),rdr.GetValue(27).ToString(),Convert.ToInt32(rdr.GetValue(28).Equals(DBNull.Value)?"0":rdr.GetValue(28).ToString()),Convert.ToInt32(rdr.GetValue(29).Equals(DBNull.Value)?"0":rdr.GetValue(29).ToString()),Convert.ToInt32(rdr.GetValue(30).Equals(DBNull.Value)?"0":rdr.GetValue(30).ToString()),Convert.ToDecimal(rdr.GetValue(32).Equals(DBNull.Value)?"0":rdr.GetValue(32).ToString()),Convert.ToDecimal(rdr.GetValue(33).Equals(DBNull.Value)?"0":rdr.GetValue(33).ToString()),Convert.ToDecimal(rdr.GetValue(34).Equals(DBNull.Value)?"0":rdr.GetValue(34).ToString()),Convert.ToDecimal(rdr.GetValue(35).Equals(DBNull.Value)?"0":rdr.GetValue(35).ToString()),Convert.ToInt32(rdr.GetValue(36).Equals(DBNull.Value)?"0":rdr.GetValue(36).ToString()),Convert.ToInt32(rdr.GetValue(37).Equals(DBNull.Value)?"0":rdr.GetValue(37).ToString()),Convert.ToInt32(rdr.GetValue(38).Equals(DBNull.Value)?"0":rdr.GetValue(38).ToString()),Convert.ToInt32(rdr.GetValue(39).Equals(DBNull.Value)?"0":rdr.GetValue(39).ToString()),Convert.ToInt32(rdr.GetValue(40).Equals(DBNull.Value)?"0":rdr.GetValue(40).ToString()),Convert.ToInt32(rdr.GetValue(41).Equals(DBNull.Value)?"0":rdr.GetValue(41).ToString()),Convert.ToInt32(rdr.GetValue(42).Equals(DBNull.Value)?"0":rdr.GetValue(42).ToString()),rdr.GetValue(43).ToString(),rdr.GetValue(44).ToString(),rdr.GetValue(45).ToString(),rdr.GetValue(46).ToString(),Convert.ToBoolean(rdr.GetValue(47).Equals(DBNull.Value)?"0":rdr.GetValue(47).ToString()),Convert.ToBoolean(rdr.GetValue(48).Equals(DBNull.Value)?"0":rdr.GetValue(48).ToString()),Convert.ToBoolean(rdr.GetValue(49).Equals(DBNull.Value)?"0":rdr.GetValue(49).ToString()),Convert.ToInt32(rdr.GetValue(50).Equals(DBNull.Value)?"0":rdr.GetValue(50).ToString()),Convert.ToInt32(rdr.GetValue(51).Equals(DBNull.Value)?"0":rdr.GetValue(51).ToString()),rdr.GetValue(52).ToString(),rdr.GetValue(53).ToString(),rdr.GetValue(54).ToString(),Convert.ToDateTime(rdr.GetValue(55).Equals(DBNull.Value)?"1900-01-01":rdr.GetValue(55).ToString()),Convert.ToInt32(rdr.GetValue(56).Equals(DBNull.Value)?"0":rdr.GetValue(56).ToString()),Convert.ToDateTime(rdr.GetValue(57).Equals(DBNull.Value)?"1900-01-01":rdr.GetValue(57).ToString()),rdr.GetValue(58).ToString(),Convert.ToDecimal(rdr.GetValue(59).Equals(DBNull.Value)?"0":rdr.GetValue(59).ToString()),Convert.ToDecimal(rdr.GetValue(60).Equals(DBNull.Value)?"0":rdr.GetValue(60).ToString()),Convert.ToDecimal(rdr.GetValue(61).Equals(DBNull.Value)?"0":rdr.GetValue(61).ToString()),Convert.ToDecimal(rdr.GetValue(62).Equals(DBNull.Value)?"0":rdr.GetValue(62).ToString()),Convert.ToDecimal(rdr.GetValue(63).Equals(DBNull.Value)?"0":rdr.GetValue(63).ToString()),Convert.ToDecimal(rdr.GetValue(64).Equals(DBNull.Value)?"0":rdr.GetValue(64).ToString()),Convert.ToDecimal(rdr.GetValue(65).Equals(DBNull.Value)?"0":rdr.GetValue(65).ToString()),Convert.ToInt32(rdr.GetValue(66).Equals(DBNull.Value)?"0":rdr.GetValue(66).ToString()),Convert.ToInt32(rdr.GetValue(67).Equals(DBNull.Value)?"0":rdr.GetValue(67).ToString()),Convert.ToDateTime(rdr.GetValue(69).Equals(DBNull.Value)?"1900-01-01":rdr.GetValue(69).ToString()),Convert.ToDateTime(rdr.GetValue(70).Equals(DBNull.Value)?"1900-01-01":rdr.GetValue(70).ToString()),Convert.ToDateTime(rdr.GetValue(71).Equals(DBNull.Value)?"1900-01-01":rdr.GetValue(71).ToString()),Convert.ToDateTime(rdr.GetValue(72).Equals(DBNull.Value)?"1900-01-01":rdr.GetValue(72).ToString()),Convert.ToDecimal(rdr.GetValue(73).Equals(DBNull.Value)?"0":rdr.GetValue(73).ToString()),Convert.ToDecimal(rdr.GetValue(74).Equals(DBNull.Value)?"0":rdr.GetValue(74).ToString()),Convert.ToDecimal(rdr.GetValue(75).Equals(DBNull.Value)?"0":rdr.GetValue(75).ToString()),Convert.ToDecimal(rdr.GetValue(76).Equals(DBNull.Value)?"0":rdr.GetValue(76).ToString()),Convert.ToInt32(rdr.GetValue(77).Equals(DBNull.Value)?"0":rdr.GetValue(77).ToString()),Convert.ToInt32(rdr.GetValue(78).Equals(DBNull.Value)?"0":rdr.GetValue(78).ToString()),rdr.GetValue(79).ToString(),Convert.ToDecimal(rdr.GetValue(80).Equals(DBNull.Value)?"0":rdr.GetValue(80).ToString()));
              strs.Add(info);
          }
      }
      return strs;
 }
示例#7
0
 /// <summary>
 /// 返回一条记录
 /// </summary>
 /// <param name="id">键值</param>
 public MBL_TeamInfo GetList(int id)
 {
     MBL_TeamInfo str = null;
      SqlParameter parm = new SqlParameter(PARM_TID, SqlDbType.Int, 4);
      parm.Value = id;
      using (SqlDataReader rdr = SqlHelper.ExecuteReader(ConnectionInfo.DBConnStr, CommandType.Text, SqlstrbyID, parm))
      {
          if (rdr.Read())
          {
              MBL_TeamInfo info = new MBL_TeamInfo(Convert.ToInt32(rdr.GetValue(0).Equals(DBNull.Value)?"0":rdr.GetValue(0).ToString()),Convert.ToInt32(rdr.GetValue(1).Equals(DBNull.Value)?"0":rdr.GetValue(1).ToString()),Convert.ToInt32(rdr.GetValue(2).Equals(DBNull.Value)?"0":rdr.GetValue(2).ToString()),Convert.ToInt32(rdr.GetValue(3).Equals(DBNull.Value)?"0":rdr.GetValue(3).ToString()),Convert.ToInt32(rdr.GetValue(4).Equals(DBNull.Value)?"0":rdr.GetValue(4).ToString()),Convert.ToInt32(rdr.GetValue(5).Equals(DBNull.Value)?"0":rdr.GetValue(5).ToString()),Convert.ToInt32(rdr.GetValue(6).Equals(DBNull.Value)?"0":rdr.GetValue(6).ToString()),Convert.ToInt32(rdr.GetValue(7).Equals(DBNull.Value)?"0":rdr.GetValue(7).ToString()),rdr.GetValue(8).ToString(),rdr.GetValue(9).ToString(),Convert.ToDateTime(rdr.GetValue(10).Equals(DBNull.Value)?"1900-01-01":rdr.GetValue(10).ToString()),Convert.ToDateTime(rdr.GetValue(11).Equals(DBNull.Value)?"1900-01-01":rdr.GetValue(11).ToString()),Convert.ToInt32(rdr.GetValue(12).Equals(DBNull.Value)?"0":rdr.GetValue(12).ToString()),Convert.ToInt32(rdr.GetValue(13).Equals(DBNull.Value)?"0":rdr.GetValue(13).ToString()),Convert.ToInt32(rdr.GetValue(14).Equals(DBNull.Value)?"0":rdr.GetValue(14).ToString()),rdr.GetValue(15).ToString(),rdr.GetValue(16).ToString(),rdr.GetValue(17).ToString(),rdr.GetValue(18).ToString(),Convert.ToBoolean(rdr.GetValue(19).Equals(DBNull.Value)?"0":rdr.GetValue(19).ToString()),Convert.ToInt32(rdr.GetValue(21).Equals(DBNull.Value)?"0":rdr.GetValue(21).ToString()),Convert.ToInt32(rdr.GetValue(22).Equals(DBNull.Value)?"0":rdr.GetValue(22).ToString()),rdr.GetValue(23).ToString(),rdr.GetValue(24).ToString(),rdr.GetValue(25).ToString(),Convert.ToInt32(rdr.GetValue(26).Equals(DBNull.Value)?"0":rdr.GetValue(26).ToString()),rdr.GetValue(27).ToString(),Convert.ToInt32(rdr.GetValue(28).Equals(DBNull.Value)?"0":rdr.GetValue(28).ToString()),Convert.ToInt32(rdr.GetValue(29).Equals(DBNull.Value)?"0":rdr.GetValue(29).ToString()),Convert.ToInt32(rdr.GetValue(30).Equals(DBNull.Value)?"0":rdr.GetValue(30).ToString()),Convert.ToDecimal(rdr.GetValue(32).Equals(DBNull.Value)?"0":rdr.GetValue(32).ToString()),Convert.ToDecimal(rdr.GetValue(33).Equals(DBNull.Value)?"0":rdr.GetValue(33).ToString()),Convert.ToDecimal(rdr.GetValue(34).Equals(DBNull.Value)?"0":rdr.GetValue(34).ToString()),Convert.ToDecimal(rdr.GetValue(35).Equals(DBNull.Value)?"0":rdr.GetValue(35).ToString()),Convert.ToInt32(rdr.GetValue(36).Equals(DBNull.Value)?"0":rdr.GetValue(36).ToString()),Convert.ToInt32(rdr.GetValue(37).Equals(DBNull.Value)?"0":rdr.GetValue(37).ToString()),Convert.ToInt32(rdr.GetValue(38).Equals(DBNull.Value)?"0":rdr.GetValue(38).ToString()),Convert.ToInt32(rdr.GetValue(39).Equals(DBNull.Value)?"0":rdr.GetValue(39).ToString()),Convert.ToInt32(rdr.GetValue(40).Equals(DBNull.Value)?"0":rdr.GetValue(40).ToString()),Convert.ToInt32(rdr.GetValue(41).Equals(DBNull.Value)?"0":rdr.GetValue(41).ToString()),Convert.ToInt32(rdr.GetValue(42).Equals(DBNull.Value)?"0":rdr.GetValue(42).ToString()),rdr.GetValue(43).ToString(),rdr.GetValue(44).ToString(),rdr.GetValue(45).ToString(),rdr.GetValue(46).ToString(),Convert.ToBoolean(rdr.GetValue(47).Equals(DBNull.Value)?"0":rdr.GetValue(47).ToString()),Convert.ToBoolean(rdr.GetValue(48).Equals(DBNull.Value)?"0":rdr.GetValue(48).ToString()),Convert.ToBoolean(rdr.GetValue(49).Equals(DBNull.Value)?"0":rdr.GetValue(49).ToString()),Convert.ToInt32(rdr.GetValue(50).Equals(DBNull.Value)?"0":rdr.GetValue(50).ToString()),Convert.ToInt32(rdr.GetValue(51).Equals(DBNull.Value)?"0":rdr.GetValue(51).ToString()),rdr.GetValue(52).ToString(),rdr.GetValue(53).ToString(),rdr.GetValue(54).ToString(),Convert.ToDateTime(rdr.GetValue(55).Equals(DBNull.Value)?"1900-01-01":rdr.GetValue(55).ToString()),Convert.ToInt32(rdr.GetValue(56).Equals(DBNull.Value)?"0":rdr.GetValue(56).ToString()),Convert.ToDateTime(rdr.GetValue(57).Equals(DBNull.Value)?"1900-01-01":rdr.GetValue(57).ToString()),rdr.GetValue(58).ToString(),Convert.ToDecimal(rdr.GetValue(59).Equals(DBNull.Value)?"0":rdr.GetValue(59).ToString()),Convert.ToDecimal(rdr.GetValue(60).Equals(DBNull.Value)?"0":rdr.GetValue(60).ToString()),Convert.ToDecimal(rdr.GetValue(61).Equals(DBNull.Value)?"0":rdr.GetValue(61).ToString()),Convert.ToDecimal(rdr.GetValue(62).Equals(DBNull.Value)?"0":rdr.GetValue(62).ToString()),Convert.ToDecimal(rdr.GetValue(63).Equals(DBNull.Value)?"0":rdr.GetValue(63).ToString()),Convert.ToDecimal(rdr.GetValue(64).Equals(DBNull.Value)?"0":rdr.GetValue(64).ToString()),Convert.ToDecimal(rdr.GetValue(65).Equals(DBNull.Value)?"0":rdr.GetValue(65).ToString()),Convert.ToInt32(rdr.GetValue(66).Equals(DBNull.Value)?"0":rdr.GetValue(66).ToString()),Convert.ToInt32(rdr.GetValue(67).Equals(DBNull.Value)?"0":rdr.GetValue(67).ToString()),Convert.ToDateTime(rdr.GetValue(69).Equals(DBNull.Value)?"1900-01-01":rdr.GetValue(69).ToString()),Convert.ToDateTime(rdr.GetValue(70).Equals(DBNull.Value)?"1900-01-01":rdr.GetValue(70).ToString()),Convert.ToDateTime(rdr.GetValue(71).Equals(DBNull.Value)?"1900-01-01":rdr.GetValue(71).ToString()),Convert.ToDateTime(rdr.GetValue(72).Equals(DBNull.Value)?"1900-01-01":rdr.GetValue(72).ToString()),Convert.ToDecimal(rdr.GetValue(73).Equals(DBNull.Value)?"0":rdr.GetValue(73).ToString()),Convert.ToDecimal(rdr.GetValue(74).Equals(DBNull.Value)?"0":rdr.GetValue(74).ToString()),Convert.ToDecimal(rdr.GetValue(75).Equals(DBNull.Value)?"0":rdr.GetValue(75).ToString()),Convert.ToDecimal(rdr.GetValue(76).Equals(DBNull.Value)?"0":rdr.GetValue(76).ToString()),Convert.ToInt32(rdr.GetValue(77).Equals(DBNull.Value)?"0":rdr.GetValue(77).ToString()),Convert.ToInt32(rdr.GetValue(78).Equals(DBNull.Value)?"0":rdr.GetValue(78).ToString()),rdr.GetValue(79).ToString(),Convert.ToDecimal(rdr.GetValue(80).Equals(DBNull.Value)?"0":rdr.GetValue(80).ToString()));
              str = info;
          }
          else
          {
              MBL_TeamInfo info = new MBL_TeamInfo();
              str = info;
          }
      }
      return str;
 }