public static string FillBoulder(SqlConnection cn) { string res = ""; NowClimbingListsTableAdapter ta = new NowClimbingListsTableAdapter(); ta.Connection = cn; DsListShow.NowClimbingListsDataTable table = ta.GetDataByStyle("Боулдеринг"); foreach (DsListShow.NowClimbingListsRow row in table.Rows) { string nowClCur = ClimbingCompetition.ResultListBoulder.getNowClStr(row.iid, cn); if (nowClCur.Length > 0) { if (res.Length > 0) { res += "; "; } res += row.grp + ": " + nowClCur; } } return(res); }
public static string FillSpeed(SqlConnection cn) { string res = ""; NowClimbingListsTableAdapter ta = new NowClimbingListsTableAdapter(); SpeedNowClimbingDataTableAdapter sta = new SpeedNowClimbingDataTableAdapter(); sta.Connection = ta.Connection = cn; DsListShow.NowClimbingListsDataTable table = ta.GetDataByStyle("Скорость"); foreach (DsListShow.NowClimbingListsRow row in table.Rows) { if (row.IsnowClimbingNull() && row.IsnowClimbingTmpNull() && row.IsnowClimbing3Null()) { continue; } if (res.Length > 0) { res += "; "; } res += row.grp + ": "; bool stIns = false; if (!row.IsnowClimbingNull()) { foreach (DsListShow.SpeedNowClimbingDataRow row2 in sta.GetDataByIdClm(row.iid, row.nowClimbing)) { res += "Трасса 1: " + GetClimberName(row2) + " (Ст.№ " + row2.start.ToString() + ")"; stIns = true; break; } } if (!row.IsnowClimbingTmpNull()) { foreach (DsListShow.SpeedNowClimbingDataRow row2 in sta.GetDataByIdClm(row.iid, row.nowClimbingTmp)) { if (stIns) { res += ", "; } else { stIns = true; } res += "Трасса 2: " + GetClimberName(row2) + " (Ст.№ " + row2.start.ToString() + ")"; break; } } if (!row.IsnowClimbing3Null()) { foreach (DsListShow.SpeedNowClimbingDataRow row2 in sta.GetDataByIdClm(row.iid, row.nowClimbing3)) { if (row2.IsresNull()) { break; } if (stIns) { res += ", "; } string pos; if (row2.IsposNull() || row2.pos == "в/к" || row2.res == "н/я" || row2.pos == "н/я") { pos = ""; } else { pos = row2.pos; } res += GetClimberName(row2) + ": " + "рез-т " + row2.res + ((pos.Length > 0) ? ", " + pos + " место" : ""); break; } } } return(res); }
public static string FillLead(SqlConnection cn) { string res = ""; NowClimbingListsTableAdapter ta = new NowClimbingListsTableAdapter(); LeadNowClimbingDataTableAdapter lta = new LeadNowClimbingDataTableAdapter(); lta.Connection = ta.Connection = cn; DsListShow.NowClimbingListsDataTable table = ta.GetDataByStyle("Трудность"); foreach (DsListShow.NowClimbingListsRow row in table.Rows) { if (row.IsnowClimbingNull() && row.IsnowClimbingTmpNull()) { continue; } if (res.Length > 0) { res += "; "; } res += row.grp; string rnd = row.round.ToLower(); if (rnd.IndexOf("трасса 1") > -1) { rnd = "Трасса 1"; } else if (rnd.IndexOf("трасса 2") > -1) { rnd = "Трасса 2"; } else { rnd = ""; } if (rnd.Length > 0) { res += " " + rnd; } res += ": "; bool stIns = false; if (!row.IsnowClimbingNull()) { foreach (DsListShow.LeadNowClimbingDataRow row2 in lta.GetDataByIdClm(row.iid, row.nowClimbing)) { res += "На трассе " + row2.surname.ToUpper() + ((row2.IsnameNull()) ? "" : ((row2.name.Length > 0) ? " " + row2.name : "")) + " (Ст.№ " + row2.start.ToString() + ")"; stIns = true; break; } } if (!row.IsnowClimbingTmpNull()) { foreach (DsListShow.LeadNowClimbingDataRow row2 in lta.GetDataByIdClm(row.iid, row.nowClimbingTmp)) { if (row2.IsresNull()) { break; } if (stIns) { res += ", "; } string pos; if (row2.IsposNull() || row2.pos == "в/к" || row2.res == "н/я" || row2.pos == "н/я") { pos = ""; } else { pos = row2.pos; } res += row2.surname.ToUpper() + ((row2.IsnameNull()) ? "" : ((row2.name.Length > 0) ? " " + row2.name : "")) + ": " + "рез-т " + row2.res + ((pos.Length > 0) ? ", " + pos + " место" : ""); break; } } } return(res); }