/// <summary>
/// Book Sales Книги покупок продаж на банк
/// </summary>
/// <param name="inn">ИНН</param>
/// <param name="year">ГОД Данных</param>
/// <returns></returns>
public CardFaceUl CardUiBookSales(string inn, int year)
{
try
{
var cardFace = new CardFaceUl()
{
Card = new Card()
};
Automation.Database.CommandTimeout = 120000;
var logicModel = Automation.LogicsSelectAutomations.FirstOrDefault(logic => logic.Id == 8);
cardFace.FaceUl = Automation.Database.SqlQuery <FaceUl>(logicModel.SelectUser,
new SqlParameter(logicModel.SelectedParametr.Split(',')[0], inn),
new SqlParameter(logicModel.SelectedParametr.Split(',')[1], 1),
new SqlParameter(logicModel.SelectedParametr.Split(',')[2], year)).FirstOrDefault();
cardFace.SummaryBankSales = Automation.Database.SqlQuery <SummaryBankSales>(logicModel.SelectUser,
new SqlParameter(logicModel.SelectedParametr.Split(',')[0], inn),
new SqlParameter(logicModel.SelectedParametr.Split(',')[1], 15),
new SqlParameter(logicModel.SelectedParametr.Split(',')[2], year)).ToArray();
cardFace.SummaryBankPurchase = Automation.Database.SqlQuery <SummaryBankPurchase>(logicModel.SelectUser,
new SqlParameter(logicModel.SelectedParametr.Split(',')[0], inn),
new SqlParameter(logicModel.SelectedParametr.Split(',')[1], 16),
new SqlParameter(logicModel.SelectedParametr.Split(',')[2], year)).ToArray();
return(cardFace);
}
catch (Exception ex)
{
Loggers.Log4NetLogger.Error(ex);
}
return(null);
}
/// <summary>
/// Собираем модель карточки Только АСК НДС по банку и покупкам продажам
/// </summary>
/// <param name="inn">ИНН</param>
/// <param name="year">Год выгрузки</param>
/// <returns></returns>
public CardFaceUl CardUiAskNds(string inn, int year)
{
try
{
var cardFace = new CardFaceUl()
{
Card = new Card()
};
Automation.Database.CommandTimeout = 120000;
var logicModel = Automation.LogicsSelectAutomations.FirstOrDefault(logic => logic.Id == 27);
if (logicModel != null)
{
cardFace.FullReportAskNds = Automation.Database.SqlQuery <FullReportAskNds>(logicModel.SelectUser,
new SqlParameter(logicModel.SelectedParametr.Split(',')[0], inn),
new SqlParameter(logicModel.SelectedParametr.Split(',')[1], year)).ToArray();
}
return(cardFace);
}
catch (Exception ex)
{
Loggers.Log4NetLogger.Error(ex);
}
return(null);
}
/// <summary>
/// Собираем модель карточки (полная)
/// </summary>
/// <param name="inn">ИНН</param>
/// <param name="year">Год выгрузки</param>
/// <returns></returns>
public CardFaceUl CardUi(string inn, int year)
{
try
{
var xml = new XmlReadOrWrite();
var cardFace = new CardFaceUl()
{
Card = new Card()
};
Automation.Database.CommandTimeout = 120000;
var logicModel = Automation.LogicsSelectAutomations.FirstOrDefault(logic => logic.Id == 8);
if (logicModel != null)
{
cardFace.FaceUl = Automation.Database.SqlQuery <FaceUl>(logicModel.SelectUser,
new SqlParameter(logicModel.SelectedParametr.Split(',')[0], inn),
new SqlParameter(logicModel.SelectedParametr.Split(',')[1], 1),
new SqlParameter(logicModel.SelectedParametr.Split(',')[2], year)).FirstOrDefault();
cardFace.BranchUlFace = Automation.Database.SqlQuery <BranchUlFace>(logicModel.SelectUser,
new SqlParameter(logicModel.SelectedParametr.Split(',')[0], inn),
new SqlParameter(logicModel.SelectedParametr.Split(',')[1], 2),
new SqlParameter(logicModel.SelectedParametr.Split(',')[2], year)).ToArray();
cardFace.Card.List1Card = Automation.Database.SqlQuery <List1Card>(logicModel.SelectUser,
new SqlParameter(logicModel.SelectedParametr.Split(',')[0], inn),
new SqlParameter(logicModel.SelectedParametr.Split(',')[1], 3),
new SqlParameter(logicModel.SelectedParametr.Split(',')[2], year)).ToArray();
cardFace.HistoriUlFace = Automation.Database.SqlQuery <HistoriUlFace>(logicModel.SelectUser,
new SqlParameter(logicModel.SelectedParametr.Split(',')[0], inn),
new SqlParameter(logicModel.SelectedParametr.Split(',')[1], 4),
new SqlParameter(logicModel.SelectedParametr.Split(',')[2], year)).ToArray();
cardFace.CashUlFace = Automation.Database.SqlQuery <CashUlFace>(logicModel.SelectUser,
new SqlParameter(logicModel.SelectedParametr.Split(',')[0], inn),
new SqlParameter(logicModel.SelectedParametr.Split(',')[1], 5),
new SqlParameter(logicModel.SelectedParametr.Split(',')[2], year)).ToArray();
cardFace.CashBankSpr = Automation.Database.SqlQuery <CashBankSpr>(logicModel.SelectUser,
new SqlParameter(logicModel.SelectedParametr.Split(',')[0], inn),
new SqlParameter(logicModel.SelectedParametr.Split(',')[1], 6),
new SqlParameter(logicModel.SelectedParametr.Split(',')[2], year)).ToArray();
cardFace.Card.List2Card = Automation.Database.SqlQuery <List2Card>(logicModel.SelectUser,
new SqlParameter(logicModel.SelectedParametr.Split(',')[0], inn),
new SqlParameter(logicModel.SelectedParametr.Split(',')[1], 7),
new SqlParameter(logicModel.SelectedParametr.Split(',')[2], year)).ToArray();
var rukAndUcrh = Automation.Database.SqlQuery <string>(logicModel.SelectUser,
new SqlParameter(logicModel.SelectedParametr.Split(',')[0], inn),
new SqlParameter(logicModel.SelectedParametr.Split(',')[1], 8),
new SqlParameter(logicModel.SelectedParametr.Split(',')[2], year)).ToArray();
if (rukAndUcrh[0] != null)
{
var res = (CardFaceUl)xml.ReadXmlText(string.Join("", rukAndUcrh), typeof(CardFaceUl));
cardFace.RukAndUcrh = res.RukAndUcrh;
}
cardFace.ImZmTrUl = Automation.Database.SqlQuery <ImZmTrUl>(logicModel.SelectUser,
new SqlParameter(logicModel.SelectedParametr.Split(',')[0], inn),
new SqlParameter(logicModel.SelectedParametr.Split(',')[1], 9),
new SqlParameter(logicModel.SelectedParametr.Split(',')[2], year)).ToArray();
cardFace.Active = Automation.Database.SqlQuery <Active>(logicModel.SelectUser,
new SqlParameter(logicModel.SelectedParametr.Split(',')[0], inn),
new SqlParameter(logicModel.SelectedParametr.Split(',')[1], 10),
new SqlParameter(logicModel.SelectedParametr.Split(',')[2], year)).ToArray();
cardFace.Balans = Automation.Database.SqlQuery <Balans>(logicModel.SelectUser,
new SqlParameter(logicModel.SelectedParametr.Split(',')[0], inn),
new SqlParameter(logicModel.SelectedParametr.Split(',')[1], 11),
new SqlParameter(logicModel.SelectedParametr.Split(',')[2], year)).ToArray();
cardFace.Profit = Automation.Database.SqlQuery <Profit>(logicModel.SelectUser,
new SqlParameter(logicModel.SelectedParametr.Split(',')[0], inn),
new SqlParameter(logicModel.SelectedParametr.Split(',')[1], 12),
new SqlParameter(logicModel.SelectedParametr.Split(',')[2], year)).ToArray();
cardFace.Nds = Automation.Database.SqlQuery <Nds>(logicModel.SelectUser,
new SqlParameter(logicModel.SelectedParametr.Split(',')[0], inn),
new SqlParameter(logicModel.SelectedParametr.Split(',')[1], 13),
new SqlParameter(logicModel.SelectedParametr.Split(',')[2], year)).ToArray();
cardFace.FlRukUcrh = Automation.Database.SqlQuery <FlRukUcrh>(logicModel.SelectUser,
new SqlParameter(logicModel.SelectedParametr.Split(',')[0], inn),
new SqlParameter(logicModel.SelectedParametr.Split(',')[1], 14),
new SqlParameter(logicModel.SelectedParametr.Split(',')[2], year)).ToArray();
cardFace.SummaryBankSales = Automation.Database.SqlQuery <SummaryBankSales>(logicModel.SelectUser,
new SqlParameter(logicModel.SelectedParametr.Split(',')[0], inn),
new SqlParameter(logicModel.SelectedParametr.Split(',')[1], 15),
new SqlParameter(logicModel.SelectedParametr.Split(',')[2], year)).ToArray();
cardFace.SummaryBankPurchase = Automation.Database.SqlQuery <SummaryBankPurchase>(logicModel.SelectUser,
new SqlParameter(logicModel.SelectedParametr.Split(',')[0], inn),
new SqlParameter(logicModel.SelectedParametr.Split(',')[1], 16),
new SqlParameter(logicModel.SelectedParametr.Split(',')[2], year)).ToArray();
}
return(cardFace);
}
catch (Exception ex)
{
Loggers.Log4NetLogger.Error(ex);
}
return(null);
}
