public string GetElements(int viewID, long viewStamp, int startIndex, int count)
{
try
{
UserRights userRights;
AppData.CheckLoggedOn(out userRights);
SchemeView schemeView = GetSchemeView(viewID, userRights);
ElementsDTO dto = new ElementsDTO(count);
dto.ViewStamp = schemeView.Stamp;
if (viewStamp == 0 || viewStamp == dto.ViewStamp)
{
List <SchemeView.Element> srcElems = schemeView.ElementList;
int srcCnt = srcElems.Count;
dto.EndOfElements = startIndex + count >= srcCnt;
for (int i = startIndex, j = 0; i < srcCnt && j < count; i++, j++)
{
dto.Elements.Add(srcElems[i]);
}
}
return(JsSerializer.Serialize(dto));
}
catch (Exception ex)
{
AppData.Log.WriteException(ex, Localization.UseRussian ?
"Ошибка при получении элементов схемы с ид.={0}" :
"Error getting the elements of the scheme with ID={0}", viewID);
return(GetErrorDtoJs(ex));
}
}
public static List <ElementsDTO> GetElements()
{
DataTable _dt = new DataTable();
List <ElementsDTO> elements = new List <ElementsDTO>();
try
{
using (MySqlConnection cn = new MySqlConnection(cs))
{
cn.Open();
string query = "SELECT Id_element, partie_id, elementLibelle, elementsImg FROM t_elements";
using (MySqlDataAdapter da = new MySqlDataAdapter(query, cn))
{
da.SelectCommand.CommandTimeout = 600;
da.Fill(_dt);
}
cn.Close();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
foreach (DataRow row in _dt.Rows)
{
ElementsDTO element = new ElementsDTO();
element.ID = Convert.ToInt32(row["Id_element"]);
element.PartieID = Convert.ToInt32(row["partie_id"]);
element.Libelle = row["elementLibelle"].ToString();
element.Image = row["elementsImg"].ToString();
elements.Add(element);
}
return(elements);
}
