/// <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);
}
