/// <summary> /// Выгрузка модели телефонного справочника /// </summary> /// <param name="logic">Логика выборки</param> /// <param name="listparametr">Параметры</param> /// <returns>Возвращает объект для превращения его в схему</returns> public object GenerateSchemeXsdSql <TKey, TValue>(LogicaSelect logic, Dictionary <TKey, TValue> listparametr = null) { var sqlConnect = new SqlConnectionType(); switch (logic.Id) { case 10: TelephoneHelp telephoneHelp = new TelephoneHelp { TelephonHeaders = ((TelephoneHelp)sqlConnect.SelectFullParametrSqlReader(ConnectionString, logic.SelectUser, typeof(TelephoneHelp), ModelSqlFullService.ParamCommand("1"))).TelephonHeaders, TelephonBody = ((TelephoneHelp) sqlConnect.SelectFullParametrSqlReader(ConnectionString, logic.SelectUser, typeof(TelephoneHelp), ModelSqlFullService.ParamCommand("2"))).TelephonBody }; return(telephoneHelp); case 12: Book book = new Book { BareCodeBook = new BareCodeBook(), Organization = ((Book)sqlConnect.SelectFullParametrSqlReader(ConnectionString, logic.SelectUser, typeof(Book), listparametr)).Organization }; return(book); default: return(null); } }
/// <summary> /// Это для инвентаризации выборка /// </summary> /// <param name="logic">Логика</param> /// <returns></returns> public string SqlModelInventory <T>(LogicaSelect logic) { SerializeJson serializeJson = new SerializeJson(); object result; string resultModel; Inventory.Database.CommandTimeout = 120000; if (logic.IsResultXml) { var xml = new XmlReadOrWrite(); result = Inventory.Database.SqlQuery <string>(logic.SelectUser).ToArray(); var resultXml = (T)xml.ReadXmlText(string.Join("", (string[])result), typeof(T)); resultModel = serializeJson.JsonLibrary(resultXml, "dd.MM.yyyy HH:mm"); } else { result = Inventory.Database.SqlQuery <T>(logic.SelectUser).ToList(); dynamic expand = new ExpandoObject(); AddProperty(expand, typeof(T).Name, result); resultModel = serializeJson.JsonLibrary(expand, "dd.MM.yyyy HH:mm"); } return(resultModel); }