public Student(string name, int classNumber, IClassroom classroom, string details = null)
: base(name, details)
{
this.ClassNumber = classNumber;
this.Class = classroom;
SchoolData.AddStudentToDatabase(this);
}
public static List <result_exam4> List()
{
List <result_exam4> result_examList = new List <result_exam4>();
SqlConnection connection = SchoolData.GetConnection();
string selectStatement
= "SELECT "
+ " [ExamId] "
+ "FROM "
+ " [exam] "
+ "";
SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
try
{
connection.Open();
SqlDataReader reader = selectCommand.ExecuteReader();
result_exam4 clsresult_exam = new result_exam4();
while (reader.Read())
{
clsresult_exam = new result_exam4();
clsresult_exam.ExamId = System.Convert.ToInt32(reader["ExamId"]);
result_examList.Add(clsresult_exam);
}
reader.Close();
}
catch (SqlException ex)
{
throw ex;
}
finally
{
connection.Close();
}
return(result_examList);
}
public static bool DownloadMediaFileT(ReceiveMessageBase rmb)
{
if (rmb is VoiceReceiveMessage)
{
try
{
VoiceReceiveMessage _vrm = rmb as VoiceReceiveMessage;
Logger.WriteTxtLog(_vrm.MediaId + "|" + WxAccToken.AccessTokenStr);
string _url = string.Format("http://apple1302.gicp.net/WxService/FileHandler.ashx?type=voice&MediaId={0}&AccessToken={1}&FromUserName={2}",
_vrm.MediaId, WxAccToken.AccessTokenStr, _vrm.FromUserName);
string _val = AtWeb.Get(_url);
DateTime _now = DateTime.Now;
string fileName = System.AppDomain.CurrentDomain.BaseDirectory;
if (!fileName.EndsWith("\\"))
{
fileName += "\\";
}
fileName += "WxVoice\\";
string mp3 = _now.ToString("yyyyMMddHHmmss") + ".mp3";
fileName += mp3;
SchoolData.语音记录(mp3);
FileIO _fio = new FileIO();
_fio.OpenWriteFile(fileName);
_fio.WriteLine(_val);
_fio.CloseWriteFile();
}
catch { }
}
return(true);
}
public static bool DownloadMediaFileS(ReceiveMessageBase rmb)
{
if (rmb is VoiceReceiveMessage)
{
VoiceReceiveMessage _vrm = rmb as VoiceReceiveMessage;
DownloadMediaRequest _request = new DownloadMediaRequest();
_request.AppIdInfo = new DefAppIdInfo();
_request.AccessToken = WxAccToken.AccessTokenStr;
_request.MediaId = _vrm.MediaId;
string fileName = AppDomain.CurrentDomain.BaseDirectory;
if (!fileName.EndsWith("\\"))
{
fileName += "\\";
}
fileName += "WxVoice\\";
_request.SaveDir = fileName;
//Logger.WriteTxtLog("语音ID：" + _vrm.MediaId);
IMpClient mpClient = new MpClient();
DownloadMediaResponse _response = mpClient.Execute(_request);
if (_response.IsError)
{
return(false);
}
string _filename = _response.SaveFileName;
_filename = _filename.Substring(_filename.LastIndexOf('\\') + 1);
//Logger.WriteTxtLog("语音ID：" + _filename);
SchoolData.语音记录(_filename);
}
return(true);
}
public static DataTable SelectAll()
{
SqlConnection connection = SchoolData.GetConnection();
string selectStatement
= "SELECT "
+ " [Class ID] = [studentclass].[ClassId] "
+ " ,[Class Name] = [studentclass].[ClassName] "
+ "FROM "
+ " [studentclass] "
+ "";
SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
selectCommand.CommandType = CommandType.Text;
DataTable dt = new DataTable();
try
{
connection.Open();
SqlDataReader reader = selectCommand.ExecuteReader();
if (reader.HasRows)
{
dt.Load(reader);
}
reader.Close();
}
catch (SqlException)
{
return(dt);
}
finally
{
connection.Close();
}
return(dt);
}
public void Update(SchoolData data)
{
using (MySqlConnection conn = context.GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("UPDATE `School` SET (" +
"`smis`=@smis,`sc_code`=@sc_code,`sc_name`=@sc_name,`areacode`=@areacode,`sc_network`=@sc_network,`aumphur`=@aumphur,`province`=@province,`spt`=@spt,`add1`=@add1" +
",`add2`=@add2,`tumbol`=@tumbol,`p_code`=@p_code,`tel`=@tel,`low_class`=@low_class,`top_clsass`=@top_clsass,`lat`=@lat,`lng`=@lng,`VatId`=@VatId)" +
"WHERE `sc_id`=@Id", conn);
cmd.Parameters.AddWithValue("@sc_id", data.sc_id);
cmd.Parameters.AddWithValue("@smis", data.smis);
cmd.Parameters.AddWithValue("@sc_code", data.sc_code);
cmd.Parameters.AddWithValue("@sc_name", data.sc_name);
cmd.Parameters.AddWithValue("@areacode", data.areacode);
cmd.Parameters.AddWithValue("@sc_network", data.sc_network);
cmd.Parameters.AddWithValue("@aumphur", data.aumphur);
cmd.Parameters.AddWithValue("@province", data.province);
cmd.Parameters.AddWithValue("@spt", data.spt);
cmd.Parameters.AddWithValue("@add1", data.add1);
cmd.Parameters.AddWithValue("@add2", data.add2);
cmd.Parameters.AddWithValue("@tumbol", data.tumbol);
cmd.Parameters.AddWithValue("@p_code", data.p_code);
cmd.Parameters.AddWithValue("@tel", data.tel);
cmd.Parameters.AddWithValue("@low_class", data.low_class);
cmd.Parameters.AddWithValue("@top_clsass", data.top_class);
cmd.Parameters.AddWithValue("@lat", data.lat);
cmd.Parameters.AddWithValue("@lng", data.lng);
cmd.Parameters.AddWithValue("@VatId", data.VatId);
cmd.ExecuteNonQuery();
}
}
public static List <students_studentclass> List()
{
List <students_studentclass> students_studentclassList = new List <students_studentclass>();
SqlConnection connection = SchoolData.GetConnection();
string selectStatement
= "SELECT "
+ " [ClassId] "
+ "FROM "
+ " [studentclass] "
+ "";
SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
try
{
connection.Open();
SqlDataReader reader = selectCommand.ExecuteReader();
students_studentclass clsstudents_studentclass = new students_studentclass();
while (reader.Read())
{
clsstudents_studentclass = new students_studentclass();
clsstudents_studentclass.ClassId = System.Convert.ToInt32(reader["ClassId"]);
students_studentclassList.Add(clsstudents_studentclass);
}
reader.Close();
}
catch (SqlException ex)
{
throw ex;
}
finally
{
connection.Close();
}
return(students_studentclassList);
}
public int Insert(SchoolData data)
{
using (MySqlConnection conn = context.GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("INSERT INTO `School` (" +
"`sc_id`, `smis`, `sc_code`, `sc_name`, `areacode`, `sc_network`, `aumphur`, `province`, `spt`, `add1`, " +
"`add2`, `tumbol`, `p_code`, `tel`, `low_class`, `top_clsass`, `lat`, `lng`, `VatId`) " +
"VALUES (" +
"@sc_id,@smis,@sc_code,@sc_name,@areacode,@sc_network,@aumphur,@province,@spt,@add1," +
"@add2,@tumbol,@p_code,@tel,@low_class,@top_clsass,@lat,@lng,@VatId)", conn);
cmd.Parameters.AddWithValue("@sc_id", data.sc_id);
cmd.Parameters.AddWithValue("@smis", data.smis);
cmd.Parameters.AddWithValue("@sc_code", data.sc_code);
cmd.Parameters.AddWithValue("@sc_name", data.sc_name);
cmd.Parameters.AddWithValue("@areacode", data.areacode);
cmd.Parameters.AddWithValue("@sc_network", data.sc_network);
cmd.Parameters.AddWithValue("@aumphur", data.aumphur);
cmd.Parameters.AddWithValue("@province", data.province);
cmd.Parameters.AddWithValue("@spt", data.spt);
cmd.Parameters.AddWithValue("@add1", data.add1);
cmd.Parameters.AddWithValue("@add2", data.add2);
cmd.Parameters.AddWithValue("@tumbol", data.tumbol);
cmd.Parameters.AddWithValue("@p_code", data.p_code);
cmd.Parameters.AddWithValue("@tel", data.tel);
cmd.Parameters.AddWithValue("@low_class", data.low_class);
cmd.Parameters.AddWithValue("@top_clsass", data.top_class);
cmd.Parameters.AddWithValue("@lat", data.lat);
cmd.Parameters.AddWithValue("@lng", data.lng);
cmd.Parameters.AddWithValue("@VatId", data.VatId);
cmd.ExecuteNonQuery();
return((int)cmd.LastInsertedId);
}
}
protected void OnSaveInfoClick(object sender, EventArgs e)
{
string _content = tbcontent.Text;
if (string.IsNullOrEmpty(_content))
{
return;
}
string _sql = "insert into 题目内容(类型,题目,答案) values('{0}','{1}','{2}')";
_sql = string.Format(_sql, lbtype.SelectedValue, _content, tbsave.Text);
int _index = SchoolData.ExecNonQuery(_sql);
if (_index > 0)
{
tbsave.Text = "";
tbcontent.Text = "";
}
else
{
return;
}
_sql = "select * from 题目内容 order by id desc";
DataTable _dt = SchoolData.Query(_sql);
GridView1.DataSource = _dt;
GridView1.DataBind();
}
public static void SaveSchoolDataToUsersLocation(SchoolData schoolData)
{
var path = StandaloneFileBrowser.SaveFilePanel("Save File", "", "", "txt");
IStructureModifier modifiedStructure = new ClassOverview();
File.WriteAllText(path, modifiedStructure.GenerateData(schoolData));
}
protected void lbcourseselect_SelectedIndexChanged(object sender, EventArgs e)
{
string _sql = "select * from 题目内容 where 类型 = " + lbtype.SelectedValue;
DataTable _dt = SchoolData.Query(_sql);
GridView1.DataSource = _dt;
GridView1.DataBind();
}
private IEnumerator ProcessSchoolDataToUIWithInterval(SchoolData schoolData, float interval)
{
yield return(StartCoroutine(ProcessDataToUIWithInterval(schoolData.subjects, SubjectDataText, interval)));
yield return(StartCoroutine(ProcessDataToUIWithInterval(schoolData.classes, ClassesDataText, interval)));
yield return(StartCoroutine(ProcessDataToUIWithInterval(schoolData.userdata, UserDataText, interval)));
}
public static School Create(SchoolView v)
{
var d = new SchoolData();
Copy.Members(v, d);
return(new School(d));
}
public async Task <IList <Model.School> > GetSchool()
{
SchoolData obj = new SchoolData(csName);
var Result = obj.GetSchool();
var SchoolList = Mapper.Map <IList <Data.School>, IList <Model.School> >(Result);
return(SchoolList);
}
private string Processing(NameValueCollection par)
{
string ret = "alert('не найдено');";
string[] allKeys = par.AllKeys;
if (allKeys.Contains("la") && allKeys.Contains("lg"))
{
double la = Convert.ToSingle(par["la"], CultureInfo.InvariantCulture.NumberFormat);
double lg = Convert.ToSingle(par["lg"], CultureInfo.InvariantCulture.NumberFormat);
GeoCoordinate source = new GeoCoordinate(la, lg);
Dictionary <int, Tuple <double, Guid> > schoolDistance = new Dictionary <int, Tuple <double, Guid> >();
foreach (KeyValuePair <Guid, SchoolData> item in Global.schoolDict)
{
double dist = item.Value.pointOnMap.GetDistanceTo(source);
Tuple <double, Guid> dataExist;
if (schoolDistance.TryGetValue(item.Value.school, out dataExist))
{
if (dist < dataExist.Item1)
{
schoolDistance[item.Value.school] = Tuple.Create <double, Guid>(dist, item.Key);
}
}
else
{
schoolDistance.Add(item.Value.school, Tuple.Create <double, Guid>(dist, item.Key));
}
}
schoolDistance = schoolDistance.OrderBy(x => x.Value.Item1).Take(1).ToDictionary(x => x.Key, x => x.Value);
foreach (KeyValuePair <int, Tuple <double, Guid> > item in schoolDistance)
{
SchoolData sd = Global.schoolDict[item.Value.Item2];
if (Global.ratingDict.ContainsKey(sd.school))
{
RatingData rd = Global.ratingDict[sd.school];
ret = string.Format("alert('школа - {0} \\r\\n расстояние - {1} \\r\\n общий рейтинг - {2} \\r\\n место по городу - {3} \\r\\n общий уровень - {4}');",
rd.school,
item.Value.Item1,
rd.egCommonRating,
rd.egCommomLevel,
rd.egCommonState);
}
else
{
ret = string.Format("alert('школа - {0} \\r\\n расстояние - {1} \\r\\n в рейтинге отсутствует');", sd.school, item.Value.Item1);
}
}
}
return(ret);
}
public static students Select_Record(students clsstudentsPara)
{
students clsstudents = new students();
SqlConnection connection = SchoolData.GetConnection();
string selectStatement
= "SELECT "
+ " [StudentId] "
+ " ,[ClassId] "
+ " ,[FullName] "
+ " ,[DateOfBirth] "
+ " ,[HomeAddress] "
+ " ,[Gender] "
+ " ,[Father] "
+ " ,[Mother] "
+ " ,[ParentContact] "
+ "FROM "
+ " [students] "
+ "WHERE "
+ " [StudentId] = @StudentId "
+ "";
SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
selectCommand.CommandType = CommandType.Text;
selectCommand.Parameters.AddWithValue("@StudentId", clsstudentsPara.StudentId);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
clsstudents.StudentId = System.Convert.ToInt32(reader["StudentId"]);
clsstudents.ClassId = reader["ClassId"] is DBNull ? null : (Int32?)reader["ClassId"];
clsstudents.FullName = reader["FullName"] is DBNull ? null : reader["FullName"].ToString();
clsstudents.DateOfBirth = reader["DateOfBirth"] is DBNull ? null : (DateTime?)reader["DateOfBirth"];
clsstudents.HomeAddress = reader["HomeAddress"] is DBNull ? null : reader["HomeAddress"].ToString();
clsstudents.Gender = System.Convert.ToString(reader["Gender"]);
clsstudents.Father = reader["Father"] is DBNull ? null : reader["Father"].ToString();
clsstudents.Mother = reader["Mother"] is DBNull ? null : reader["Mother"].ToString();
clsstudents.ParentContact = reader["ParentContact"] is DBNull ? null : reader["ParentContact"].ToString();
}
else
{
clsstudents = null;
}
reader.Close();
}
catch (SqlException ex)
{
throw ex;
}
finally
{
connection.Close();
}
return(clsstudents);
}
/// <summary>
/// 下一题
/// </summary>
/// <param name="p_type"></param>
/// <param name="p_id"></param>
/// <returns></returns>
private string GetSxNext(string p_type, string p_id = "")
{
string _result = string.Empty;
if (_jlc == null)
{
_jlc = new Dictionary <string, List <int> >();
}
if (_dic == null)
{
_dic = new Dictionary <string, List <string> >();
}
if (!_dic.ContainsKey(p_type))
{
List <string> _list = new List <string>();
string _sql = string.Empty;
if (p_type == "5")
{
_sql = "select * from 题目内容 where 类型 in ('3','4')";
}
else
{
_sql = "select * from 题目内容 where 类型 = '" + p_type + "'";
}
DataTable _dt = SchoolData.Query(_sql);
foreach (DataRow _dr in _dt.Rows)
{
_list.Add(_dr.Str("ID") + "," + _dr.Str("题目") + "," + _dr.Str("答案"));
}
_dic[p_type] = _list;
_jlc[p_type] = new List <int>();
}
if (_jlc[p_type].Count == _dic[p_type].Count)
{
_jlc[p_type].Clear();
}
int _index = 0;
for (int i = 0; i < _dic[p_type].Count; i++)
{
Random _r = new Random();
_index = _r.Next(_dic[p_type].Count);
if (!_jlc[p_type].Contains(_index))
{
_jlc[p_type].Add(_index);
_result = _dic[p_type][_index];
break;
}
}
_result = _dic[p_type].Count + "|" + _jlc[p_type].Count + "|" + _result;
return(_result);
}
public AppSearch(IWebDriver driver)
{
this._driver = driver;
this._appLog = new AppLoginLogout(_driver);
this._user = new UserData();
this._rec = new RecData();
this._school = new SchoolData();
this._utils = new DriverUtilities(_driver);
this._nav = new Navigate(_driver);
}
public static bool Update(studentclass oldstudentclass,
studentclass newstudentclass)
{
SqlConnection connection = SchoolData.GetConnection();
string updateStatement
= "UPDATE "
+ " [studentclass] "
+ "SET "
+ " [ClassName] = @NewClassName "
+ "WHERE "
+ " [ClassId] = @OldClassId "
+ " AND ((@OldClassName IS NULL AND [ClassName] IS NULL) OR [ClassName] = @OldClassName) "
+ "";
SqlCommand updateCommand = new SqlCommand(updateStatement, connection);
updateCommand.CommandType = CommandType.Text;
if (newstudentclass.ClassName != null)
{
updateCommand.Parameters.AddWithValue("@NewClassName", newstudentclass.ClassName);
}
else
{
updateCommand.Parameters.AddWithValue("@NewClassName", DBNull.Value);
}
updateCommand.Parameters.AddWithValue("@OldClassId", oldstudentclass.ClassId);
if (oldstudentclass.ClassName != null)
{
updateCommand.Parameters.AddWithValue("@OldClassName", oldstudentclass.ClassName);
}
else
{
updateCommand.Parameters.AddWithValue("@OldClassName", DBNull.Value);
}
try
{
connection.Open();
int count = updateCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException ex)
{
throw ex;
}
finally
{
connection.Close();
}
}
public SearchForTestScript(IWebDriver driver)
{
this._driver = driver;
this._results = new Result();
this._searchFor = new SearchFor(_driver);
this._pageValidation = new PageValidation(_driver);
this._utilsValidation = new DriverUtilitiesValidation(_driver);
this._userData = new UserData();
this._recData = new RecommenderData();
this._schoolData = new SchoolData();
}
private string 分类目录()
{
string _result = string.Empty;
string _sql = "select * from 阅读分类";
DataTable _dt = SchoolData.Query(_sql);
foreach (DataRow dr in _dt.Rows)
{
_result += dr.Str("ID") + "," + dr.Str("大类") + "," + dr.Str("小类") + "|";
}
return(_result.TrimEnd('|'));
}
public IActionResult Delete(int id, SchoolData request)
{
try
{
schoolDac.Delete(id);
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
/// <summary>
/// 生字表
/// </summary>
/// <returns></returns>
private string GetSzList()
{
string _result = string.Empty;
string _sql = "select * from 题目内容 where 类型 = '2'";
DataTable _dt = SchoolData.Query(_sql);
foreach (DataRow _dr in _dt.Rows)
{
_result += _dr.Str("题目") + "," + _dr.Str("答案") + "|";
}
return(_result.TrimEnd('|'));
}
public IActionResult Create(SchoolData request)
{
try
{
schoolDac.Insert(request);
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
private void cbExport_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
using (new WaitCursor())
{
try
{
SchoolData clsSchoolData = new SchoolData();
if (cbiPDF.IsSelected == true)
{
if (tiGrid.IsSelected)
{
clsSchoolData.ExportToPdf("Many",
"Dbo.Result", Grid, (DataRowView)Grid.CurrentItem, Row);
}
else if (tiDetail.IsSelected)
{
clsSchoolData.ExportToPdf("One",
"Dbo.Result", Grid, (DataRowView)Grid.CurrentItem, Row);
}
}
else if (cbiExcel.IsSelected == true)
{
if (tiGrid.IsSelected)
{
clsSchoolData.ExportToExcel("Many",
"Dbo.Result", Grid, (DataRowView)Grid.CurrentItem, Row);
}
else if (tiDetail.IsSelected)
{
clsSchoolData.ExportToExcel("One",
"Dbo.Result", Grid, (DataRowView)Grid.CurrentItem, Row);
}
}
else if (cbiWord.IsSelected == true)
{
if (tiGrid.IsSelected)
{
clsSchoolData.ExportToWord("Many",
"Dbo.Result", Grid, (DataRowView)Grid.CurrentItem, Row);
}
else if (tiDetail.IsSelected)
{
clsSchoolData.ExportToWord("One",
"Dbo.Result", Grid, (DataRowView)Grid.CurrentItem, Row);
}
}
cbiExport.IsSelected = true;
}
catch
{
}
}
}
private string GetflList()
{
string _result = string.Empty;
string _sql = "select * from 分类目录";
DataTable _dt = SchoolData.Query(_sql);
foreach (DataRow dr in _dt.Rows)
{
_result += dr.Str("ID") + "," + dr.Str("名称") + "," + dr.Str("类别") + "|";
}
return(_result.TrimEnd('|'));
}
/// <summary>
/// 语音列表
/// </summary>
/// <returns></returns>
private string GetVoices()
{
string _result = string.Empty;
string _sql = "select * from 语音记录 order by id desc";
DataTable _dt = SchoolData.Query(_sql);
foreach (DataRow _dr in _dt.Rows)
{
_result += _dr.ToDateTime("时间").ToString("MM-dd HH:mm:ss") + "=" + _dr.Str("名称") + "|";
}
_result = _result.TrimEnd('|');
return(_result);
}
/// <summary>
/// 获取指定学校的课程信息列表
/// </summary>
/// <param name="schoolId"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public static PageResult <CourseBase> GetSchoolCoursePageList(int schoolId, int pageIndex, int pageSize)
{
List <CourseBase> courseList = SchoolData.GetSchoolCourses(schoolId).ToList();
PageResult <CourseBase> pageData = new PageResult <CourseBase>
{
RecordCount = courseList.Count,
PageIndex = pageIndex,
PageSize = pageSize
};
pageData.Data = courseList.SkipTake <CourseBase>(pageData.PageSize, pageData.PageIndex);
return(pageData);
}
public static teacher Select_Record(teacher clsteacherPara)
{
teacher clsteacher = new teacher();
SqlConnection connection = SchoolData.GetConnection();
string selectStatement
= "SELECT "
+ " [TeacherId] "
+ " ,[ClassId] "
+ " ,[FullName] "
+ " ,[DateOfJoin] "
+ " ,[HomeAddress] "
+ " ,[PhoneNumber] "
+ "FROM "
+ " [teacher] "
+ "WHERE "
+ " [TeacherId] = @TeacherId "
+ "";
SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
selectCommand.CommandType = CommandType.Text;
selectCommand.Parameters.AddWithValue("@TeacherId", clsteacherPara.TeacherId);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
clsteacher.TeacherId = System.Convert.ToInt32(reader["TeacherId"]);
clsteacher.ClassId = reader["ClassId"] is DBNull ? null : (Int32?)reader["ClassId"];
clsteacher.FullName = reader["FullName"] is DBNull ? null : reader["FullName"].ToString();
clsteacher.DateOfJoin = reader["DateOfJoin"] is DBNull ? null : (DateTime?)reader["DateOfJoin"];
clsteacher.HomeAddress = reader["HomeAddress"] is DBNull ? null : reader["HomeAddress"].ToString();
clsteacher.PhoneNumber = reader["PhoneNumber"] is DBNull ? null : reader["PhoneNumber"].ToString();
}
else
{
clsteacher = null;
}
reader.Close();
}
catch (SqlException ex)
{
throw ex;
}
finally
{
connection.Close();
}
return(clsteacher);
}
private void GenerateWidgetRow(ref string ret, string pattern, SchoolData sd, double?distance, RatingData rd)
{
string row = pattern;
row = row.Replace("{school_num}", sd.school.ToString());
string adr = string.Concat("ул. ", sd.street, " д.", sd.buildNum);
row = row.Replace("{address}", adr);
string distStr = string.Empty;
if ((distance.HasValue) && (40 < distance.Value))
{
distStr = string.Concat("Расстояние:<br/>", DistanceFormat.InKiloMeters(distance.Value));
}
row = row.Replace("{distance}", distStr);
if (null != rd)
{
row = row.Replace("{common_raiting}", rd.egCommonRating);
row = row.Replace("{common_level}", rd.egCommomLevel);
row = row.Replace("{common_raiting_level}", rd.egCommonState);
string ratingStyle = string.Empty;
switch (rd.egCommonState)
{
case "Средний": { ratingStyle = "schoollist_item_data_middle_level"; break; }
case "Ниже среднего": { ratingStyle = "schoollist_item_data_low_middle_level"; break; }
case "Выше среднего": { ratingStyle = "schoollist_item_data_high_middle_level"; break; }
case "Самый высокий": { ratingStyle = "schoollist_item_data_high_level"; break; }
case "Самый низкий": { ratingStyle = "schoollist_item_data_low_level"; break; }
}
row = row.Replace("{common_raiting_level_style}", ratingStyle);
Global.EnableBlock(ref row, "RAITING DATA");
Global.DisableBlock(ref row, "NORAITING DATA");
}
else
{
Global.EnableBlock(ref row, "NORAITING DATA");
Global.DisableBlock(ref row, "RAITING DATA");
}
ret = ret + row;
}
