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;
}
/// <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;
}
/// <summary>
/// 修改一条记录
/// </summary>
public void Modify(MBL_TeamInfo info)
{
DAL.Modify(info);
}
/// <summary>
/// 增加一条记录
/// </summary>
public object Insert(MBL_TeamInfo info)
{
return DAL.Insert(info);
}
/// <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();
}
}
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;
}
/// <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;
}