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