コード例 #1
0
ファイル: AllOperation.cs プロジェクト: lexxkrt/usno
        public List<AllOperation> GetAllOperation(DateTime from, DateTime to)
        {
            var bank = new BankOperationsRepository().GetBankOperations(from, to);
            var kassa = new KassaOperationRepository().GetKassaOperations(from, to);

            var all = new List<AllOperation>();

            var alloperations = bank.Select(c => new AllOperation()
            {
                Id = c.Id,
                FlagOperation = c.FlagOperation,
                OperationType = c.OperationType,
                DocNum = c.DocNum,
                DocDate = c.DocDate,
                DocType = c.DocType,
                Contractor = c.Contractor,
                Summa = c.Summa,
                Osnovanie = c.Osnovanie,
                FlagBankOrKassa = BankOrKassa.Bank
            })
                .Union(kassa.Select(c => new AllOperation()
                {
                    FlagOperation = c.FlagOperation,
                    OperationType = c.OperationType,
                    DocNum = c.DocNum,
                    DocDate = c.DocDate,
                    DocType = null,
                    Contractor = c.Contractor,
                    Summa = c.Summa,
                    Osnovanie = c.Osnovanie,
                    FlagBankOrKassa = BankOrKassa.Kassa
                })).OrderBy(c => c.DocDate).ThenBy(c => c.DocNum).ToList();
            return alloperations;
        }
コード例 #2
0
ファイル: AllOperation.cs プロジェクト: lexxkrt/usno
        public List<AllOperation> Find(string find)
        {
            var all = new List<AllOperation>();
            decimal summa = 0;
            Decimal.TryParse(find, out summa);

            var bank = new BankOperationsRepository().GetAll().Where(c => c.Contractor.Contains(find)
                || c.DocNum == find || c.Summa == summa);
            var kassa = new KassaOperationRepository().GetAll().Where(c => c.Contractor.Contains(find)
                || c.DocNum == find || c.Summa == summa);

            var alloperations = bank.Select(c => new AllOperation()
            {
                Id = c.Id,
                FlagOperation = c.FlagOperation,
                OperationType = c.OperationType,
                DocNum = c.DocNum,
                DocDate = c.DocDate,
                DocType = c.DocType,
                Contractor = c.Contractor,
                Summa = c.Summa,
                Osnovanie = c.Osnovanie,
                FlagBankOrKassa = BankOrKassa.Bank
            })
                .Union(kassa.Select(c => new AllOperation()
                {
                    FlagOperation = c.FlagOperation,
                    OperationType = c.OperationType,
                    DocNum = c.DocNum,
                    DocDate = c.DocDate,
                    DocType = null,
                    Contractor = c.Contractor,
                    Summa = c.Summa,
                    Osnovanie = c.Osnovanie,
                    FlagBankOrKassa = BankOrKassa.Kassa
                })).OrderBy(c => c.DocDate).ThenBy(c => c.DocNum).ToList();
            return alloperations;
        }
コード例 #3
0
ファイル: frmMain.cs プロジェクト: lexxkrt/usno
        private void обороткаToolStripMenuItem1_Click(object sender, EventArgs e)
        {
            Stimulsoft.Report.StiConfig.LoadLocalization("ru.xml");
            StiReport report = new StiReport();
            StiOptions.Dictionary.BusinessObjects.MaxLevel = 0;
            report.Load(Path.Combine(Application.StartupPath, "Reports\\oborotka.mrt"));

            var opers = new KassaOperationRepository().GetKassaOperations(BeginDate, EndDate).ToList();
            report.RegData("Operations", opers);
            report.Dictionary.Variables.Add("BeginDate", BeginDate);
            report.Dictionary.Variables.Add("EndDate", EndDate);
            var saldolist = new KassaOperationRepository().GetKassaOperations(BeginDate, EndDate).ToList();
            decimal saldodebet, saldokredit;
            if (saldolist != null)
            {
                saldodebet = saldolist.Sum(c => c.SummaDebet);
                saldokredit = saldolist.Sum(c => c.SummaKredit);
            }
            else
                saldodebet = saldokredit = 0M;
            report.Dictionary.Variables.Add("SaldoDebet", saldodebet);
            report.Dictionary.Variables.Add("SaldoKredit", saldokredit);

            //report.ReportName = String.Format("Накладная №{0} от {1:dd-MM-yyyy}", order.Invoice.Num, order.Invoice.Data);
            //report.Design();
            report.Show(true);
        }