コード例 #1
0
ファイル: AccountantService.cs プロジェクト: ZengYuming/TNS
        public bool Add(Accountant accountant)
        {
            try
            {
                string sql = "INSERT INTO accountant values(?AccountantId,?Account,?PassWord,?Name)";

                MySqlParameter[] parameter = new MySqlParameter[] {
                    new MySqlParameter("?AccountantId", accountant.AccountantId),
                    new MySqlParameter("?Account", accountant.Account),
                    new MySqlParameter("?PassWord", accountant.PassWord) ,
                    new MySqlParameter("?Name", accountant.Name)
                };
                return MySqlHelper.ExecuteNonQuery(CommandType.Text, sql, parameter) == 1;
            }
            catch (Exception e)
            {
                MySqlHelper.CloseDBConnection();
                throw e;
            }
            finally
            {

            }
        }
コード例 #2
0
        private void chkBackupAuthentication_CheckedChanged(object sender, EventArgs e)
        {
            Accountant _obj = mApplicationController.mAccountant;

            _obj.ConfigMgr.SetParam("BACKUP_AUTHENTICATION", chkBackupAuthentication.Checked ? "1" : "0");
        }
コード例 #3
0
        //
        // GET: /Admin/AdminAccountant/

        public ActionResult CashBook()
        {
            using (var db = new Data_MassageEntities1())
            {
                var chi = db.tbl_Phieu_Chi.ToList();
                List <Accountant> kho = new List <Accountant> {
                };
                foreach (var item in chi)
                {
                    if (kho == null)
                    {
                        var item1 = new Accountant();
                        var list1 = new List <Accountant>();
                        item1.chuky_nguoinhan = item.chuky_nguoinhan;
                        item1.diachi          = item.diachi;
                        item1.Id            = item.Id;
                        item1.ngaylap       = item.ngaylap;
                        item1.nguoilap      = item.nguoilap;
                        item1.nguoinhan     = item.nguoinhan;
                        item1.nguoinop      = item.nguoinhan;
                        item1.nguoinoptien  = item.nguoinhan;
                        item1.noidungchi    = item.noidungchi;
                        item1.noidungthu    = item.noidungchi;
                        item1.Note_chi      = item.Note_chi;
                        item1.Note_thu      = item.Note_chi;
                        item1.sodienthoai   = item.sodienthoai;
                        item1.sotien_chi    = (float)item.sotien_chi;
                        item1.sotien_thu    = 0;
                        item1.sochungtu_thu = item.sochungtu_chi;
                        var y = item1.sotien_chi;
                        var x = item1.sotien_thu;
                        item1.sotienton = x - y;
                        kho.Add(item1);
                    }
                    else
                    {
                        var item1 = new Accountant();
                        var list1 = new List <Accountant>();
                        item1.chuky_nguoinhan = item.chuky_nguoinhan;
                        item1.diachi          = item.diachi;
                        item1.Id            = item.Id;
                        item1.ngaylap       = item.ngaylap;
                        item1.nguoilap      = item.nguoilap;
                        item1.nguoinhan     = item.nguoinhan;
                        item1.nguoinop      = item.nguoinhan;
                        item1.nguoinoptien  = item.nguoinhan;
                        item1.noidungchi    = item.noidungchi;
                        item1.noidungthu    = item.noidungchi;
                        item1.Note_chi      = item.Note_chi;
                        item1.Note_thu      = item.Note_chi;
                        item1.sodienthoai   = item.sodienthoai;
                        item1.sotien_thu    = 0;
                        item1.sochungtu_thu = item.sochungtu_chi;
                        if (item.sotien_chi == null)
                        {
                            item.sotien_chi = 0;
                        }
                        item1.sotien_chi = (float)item.sotien_chi;
                        var y = item1.sotien_chi;
                        var x = item1.sotien_thu;
                        item1.sotienton = x - y;
                        kho.Add(item1);
                    }
                }
                var thu = db.phieu_thu.ToList();
                foreach (var item in thu)
                {
                    if (kho == null)
                    {
                        var item1 = new Accountant();
                        var list1 = new List <Accountant>();
                        item1.chuky_nguoinhan = item.nguoinop;
                        item1.diachi          = item.diachi;
                        item1.Id            = item.Id;
                        item1.ngaylap       = item.ngaylap;
                        item1.nguoilap      = item.nguoilap;
                        item1.nguoinhan     = item.nguoinop;
                        item1.nguoinop      = item.nguoinoptien;
                        item1.nguoinoptien  = item.nguoinoptien;
                        item1.noidungchi    = item.noidungthu;
                        item1.noidungthu    = item.noidungthu;
                        item1.Note_chi      = item.Note_thu;
                        item1.sodienthoai   = item.sodienthoai;
                        item1.sochungtu_thu = item.sochungtu_thu;
                        item1.sotien_chi    = 0;
                        item1.sotien_thu    = (float)item.sotien_thu;
                        item1.sotienton     = item1.sotien_thu - item1.sotien_chi;

                        kho.Add(item1);
                    }
                    else
                    {
                        var item1 = new Accountant();
                        var list1 = new List <Accountant>();
                        item1.chuky_nguoinhan = item.nguoinop;
                        item1.diachi          = item.diachi;
                        item1.Id            = item.Id;
                        item1.ngaylap       = item.ngaylap;
                        item1.nguoilap      = item.nguoilap;
                        item1.nguoinhan     = item.nguoinop;
                        item1.nguoinop      = item.nguoinoptien;
                        item1.nguoinoptien  = item.nguoinoptien;
                        item1.noidungchi    = item.noidungthu;
                        item1.noidungthu    = item.noidungthu;
                        item1.Note_chi      = item.Note_thu;
                        item1.sodienthoai   = item.sodienthoai;
                        item1.sochungtu_thu = item.sochungtu_thu;
                        item1.sotien_chi    = 0;
                        if (item.sotien_thu == null)
                        {
                            item.sotien_thu = 0;
                        }
                        item1.sotien_thu = (float)item.sotien_thu;
                        item1.sotienton  = item1.sotien_thu - item1.sotien_chi;
                        kho.Add(item1);
                    }
                }
                ViewData["list_quy_tien"] = kho.OrderBy(x => x.sotien_thu).OrderByDescending(x => x.ngaylap).ToList();

                return(View());
            }
        }
コード例 #4
0
        private void RunMark(IVoucherDetailQuery filt, CsvParser parsed, string marker, StringBuilder sb)
        {
            if (filt.IsDangerous())
            {
                throw new SecurityException("检测到弱检索式");
            }

            var marked    = 0;
            var remarked  = 0;
            var converted = 0;
            var res       = Accountant.SelectVouchers(filt.VoucherQuery).ToList();

            foreach (var b in parsed.Items)
            {
                bool Trial(bool date)
                {
                    var resx = date
                        ? res.Where(v => v.Date == b.Date)
                        : res.OrderBy(v => v.Date.HasValue
                            ? Math.Abs((v.Date.Value - b.Date).TotalDays)
                            : double.PositiveInfinity);
                    var voucher = resx
                                  .Where(v => v.Details.Any(d => (d.Fund.Value - b.Fund).IsZero() && d.IsMatch(filt.DetailEmitFilter.DetailFilter)))
                                  .FirstOrDefault();

                    if (voucher == null)
                    {
                        return(false);
                    }

                    var o = voucher.Details.First(d => (d.Fund.Value - b.Fund).IsZero() && d.IsMatch(filt.DetailEmitFilter.DetailFilter));

                    if (o.Remark == null)
                    {
                        marked++;
                    }
                    else if (o.Remark == marker)
                    {
                        remarked++;
                    }
                    else
                    {
                        converted++;
                    }

                    o.Remark = marker;
                    Accountant.Upsert(voucher);
                    return(true);
                }

                if (Trial(true) || Trial(false))
                {
                    continue;
                }

                sb.AppendLine(b.Raw);
            }

            sb.AppendLine($"{marked} marked");
            sb.AppendLine($"{remarked} remarked");
            sb.AppendLine($"{converted} converted");
        }
コード例 #5
0
 public PluginShell(Accountant helper) => m_Plugins =
コード例 #6
0
    public BLLTest()
    {
        m_Accountant = new(new(db : "accounting-test"), "b1", DateTime.UtcNow.Date);

        m_Accountant.DeleteVouchersAsync(VoucherQueryUnconstrained.Instance).AsTask().Wait();
    }
コード例 #7
0
        private IQueryResult Query(string content, ref string expr)
        {
            var rng = Parsing.Range(ref expr) ?? DateFilter.Unconstrained;

            var trans   = new List <Trans>();
            var rebates = new List <Rebate>();
            var convs   = new List <Conversion>();

            foreach (var voucher in Accountant.RunVoucherQuery($"T224101 {content.Quotation('\'')} {rng.AsDateRange()}")
                     )
            {
                var ds = voucher.Details.Where(d => d.Title == 2241 && d.SubTitle == 01 && d.Content == content)
                         .ToList();
                if (ds.Count > 2)
                {
                    throw new ApplicationException("过多相关细目");
                }

                if (ds.Count == 2)
                {
                    // ReSharper disable PossibleInvalidOperationException
                    var v1 = ds[0].Fund.Value;
                    var v2 = ds[1].Fund.Value;
                    // ReSharper restore PossibleInvalidOperationException

                    if (v1 < 0 &&
                        v2 > 0)
                    {
                        convs.Add(
                            new Conversion
                        {
                            Date           = voucher.Date,
                            TargetCurrency = ds[0].Currency,
                            TargetFund     = -v1,
                            OriginCurrency = ds[1].Currency,
                            OriginFund     = v2,
                        });
                        continue;
                    }

                    if (v1 > 0 &&
                        v2 < 0)
                    {
                        convs.Add(
                            new Conversion
                        {
                            Date           = voucher.Date,
                            TargetCurrency = ds[1].Currency,
                            TargetFund     = -v2,
                            OriginCurrency = ds[0].Currency,
                            OriginFund     = v1,
                        });
                        continue;
                    }
                }

                trans.AddRange(
                    // ReSharper disable once PossibleInvalidOperationException
                    ds.Where(d => d.Fund.Value < 0)
                    .Select(
                        d => new Trans {
                    Date = voucher.Date, RawCurrency = d.Currency, RawFund = -d.Fund.Value
                }));
            }


            foreach (var voucher in Accountant.RunVoucherQuery(
                         $"{{T224101 {content.Quotation('\'')}}}*{{T660300}}*{{T224101 {content.Quotation('\'')} +T3999+T660300 A {rng.AsDateRange()}}}")
                     )
            {
                // Assume proper ordering here
                var d0 = voucher.Details.Single(d => d.Title == 2241);
                var d1 = voucher.Details.Single(d => d.Title == 6603);
                if (d0.Title != 2241 ||
                    d0.SubTitle != 01 ||
                    d0.Content != content)
                {
                    continue;
                }
                if (d1.Title != 6603 ||
                    d1.SubTitle != null ||
                    d1.Content != null)
                {
                    continue;
                }
                if (!d0.Fund.HasValue ||
                    !d1.Fund.HasValue)
                {
                    continue;
                }

                rebates.Add(
                    new Rebate
                {
                    Date          = voucher.Date,
                    RawCurrency   = d1.Currency,
                    RawFund       = d1.Fund.Value,
                    TheConversion = new Conversion
                    {
                        Date           = voucher.Date,
                        OriginCurrency = d1.Currency,
                        OriginFund     = d1.Fund.Value,
                        TargetCurrency = d0.Currency,
                        TargetFund     = d0.Fund.Value,
                    },
                });
            }

            foreach (var tran in trans)
            {
                var conv = convs.FirstOrDefault(
                    c => c.Date >= tran.Date && c.OriginCurrency == tran.RawCurrency &&
                    (c.OriginFund - tran.RawFund).IsZero());
                if (conv == null)
                {
                    continue;
                }

                tran.TheConversion = conv;
                convs.Remove(conv);
            }

            var sb = new StringBuilder();

            foreach (var conv in convs)
            {
                sb.Append(conv.Date.AsDate());
                sb.Append($" @{conv.OriginCurrency} {conv.OriginFund.AsCurrency().CPadLeft(15)}");
                sb.AppendLine(
                    $" {conv.Date.AsDate()} @{conv.TargetCurrency} {conv.TargetFund.AsCurrency().CPadLeft(15)} !!!");
            }

            if (sb.Length != 0)
            {
                sb.AppendLine("===========================================================");
            }

            foreach (var tran in trans.Concat(rebates).OrderByDescending(t => t.Date))
            {
                sb.Append(tran.Date.AsDate());
                sb.Append($" @{tran.RawCurrency} {tran.RawFund.AsCurrency().CPadLeft(15)}");
                if (tran.TheConversion != null)
                {
                    sb.AppendLine(
                        $" {tran.TheConversion.Date.AsDate()} @{tran.TheConversion.TargetCurrency} {tran.TheConversion.TargetFund.AsCurrency().CPadLeft(15)}");
                }
                else
                {
                    sb.AppendLine();
                }
            }

            return(new PlainText(sb.ToString()));
        }
コード例 #8
0
        private IQueryResult Create(string content, ref string expr, IEntitiesSerializer serializer)
        {
            var currency     = Parsing.Token(ref expr, false);
            var baseCurrency = Parsing.Token(ref expr, false);

            var lst = new List <Voucher>();

            while (!string.IsNullOrWhiteSpace(expr))
            {
                var date = Parsing.UniqueTime(ref expr);
                if (!date.HasValue)
                {
                    var dayF = ParsingF.DoubleF(ref expr);
                    var day  = (int)dayF;
                    // ReSharper disable once CompareOfFloatsByEqualityOperator
                    if (day != dayF)
                    {
                        throw new ApplicationException("非整数日期");
                    }

                    date = ClientDateTime.Today.Day < day
                        ? ClientDateTime.Today.AddMonths(-1).AddDays(day - ClientDateTime.Today.Day)
                        : ClientDateTime.Today.AddDays(day - ClientDateTime.Today.Day);
                }

                var from    = ParsingF.DoubleF(ref expr);
                var to      = ParsingF.DoubleF(ref expr);
                var voucher = new Voucher
                {
                    Date    = date.Value,
                    Details = new List <VoucherDetail>
                    {
                        new VoucherDetail
                        {
                            Currency = baseCurrency,
                            Title    = 2241,
                            SubTitle = 01,
                            Content  = content,
                            Fund     = -to,
                        },
                        new VoucherDetail {
                            Currency = baseCurrency, Title = 3999, Fund = to
                        },
                        new VoucherDetail {
                            Currency = currency, Title = 3999, Fund = -from
                        },
                        from >= 0
                                    ? new VoucherDetail
                        {
                            Currency = currency,
                            Title    = 2241,
                            SubTitle = 01,
                            Content  = content,
                            Fund     = from,
                        }
                                    : new VoucherDetail {
                            Currency = currency, Title = 6603, Fund = from
                        },
                    },
                };
                Accountant.Upsert(voucher);
                lst.Add(voucher);
            }

            if (lst.Any())
            {
                return(new DirtyText(serializer.PresentVouchers(lst)));
            }

            return(new PlainSucceed());
        }
コード例 #9
0
 public BOPurchaseOrder(Accountant accountant, Purchase _obj, BOContext _state)
     : base(accountant, _obj, _state)
 {
     mObjectID = BOType.BOPurchaseOrder;
     mDataProxy.PurchaseStatus = mAccountant.StatusMgr.Status_Order;
 }
コード例 #10
0
 public CarryYearShell(Accountant helper) => m_Accountant = helper;
コード例 #11
0
        /// <inheritdoc />
        public override IQueryResult Execute(string expr, IEntitiesSerializer serializer)
        {
            var content = Parsing.Token(ref expr);
            var avg     = Parsing.DoubleF(ref expr);

            Parsing.Eof(expr);

            var tdy     = ClientDateTime.Today;
            var ldom    = AccountantHelper.LastDayOfMonth(tdy.Year, tdy.Month);
            var srng    = new DateFilter(new DateTime(tdy.Year, tdy.Month, 1, 0, 0, 0, DateTimeKind.Utc), tdy);
            var balance = Accountant.RunGroupedQuery(
                $"T1002 {content.Quotation('\'')} [~{tdy.AsDate()}]`vD{srng.AsDateRange()}");

            var bal = 0D;
            var btd = 0D;

            foreach (var b in balance.Items.Cast <ISubtotalDate>())
            {
                if (b.Date == tdy)
                {
                    btd += b.Fund;
                }
                else
                {
                    bal += b.Fund;
                }
            }

            var targ = ldom.Day * avg;

            var sb = new StringBuilder();

            sb.AppendLine($"Target: {targ.AsCurrency()}");
            sb.AppendLine($"Balance until yesterday: {bal.AsCurrency()}");
            if ((bal - targ).IsNonNegative())
            {
                sb.AppendLine("Achieved.");
                sb.AppendLine();

                sb.AppendLine(
                    (btd - avg).IsNonNegative()
                        ? $"Plan A: Credit {(btd - avg).AsCurrency()}, Balance {avg.AsCurrency()}"
                        : $"Plan A: Debit {(avg - btd).AsCurrency()}, Balance {avg.AsCurrency()}");
                sb.AppendLine("Plan B: No Action");
            }
            else
            {
                var res = targ - bal;
                var rsd = ldom.Day - tdy.Day + 1;
                sb.AppendLine($"Deficiency: {res.AsCurrency()}");
                var avx = res / rsd;
                if ((rsd * avg - res).IsNonNegative())
                {
                    sb.AppendLine($"Average deficiency: {avx.AsCurrency()} <= {avg.AsCurrency()}");
                    sb.AppendLine();

                    sb.AppendLine(
                        (btd - avx).IsNonNegative()
                            ? $"Plan A: Credit {(btd - avx).AsCurrency()}, Balance {avx.AsCurrency()}"
                            : $"Plan A: Debit {(avx - btd).AsCurrency()}, Balance {avx.AsCurrency()}");
                    sb.AppendLine(
                        (btd - avg).IsNonNegative()
                            ? $"Plan B: Credit {(btd - avg).AsCurrency()}, Balance {avg.AsCurrency()}"
                            : $"Plan B: Debit {(avg - btd).AsCurrency()}, Balance {avg.AsCurrency()}");
                }
                else
                {
                    sb.AppendLine($"Average deficiency: {avx.AsCurrency()} > {avg.AsCurrency()}");
                    sb.AppendLine();

                    sb.AppendLine(
                        (btd - avx).IsNonNegative()
                            ? $"Plan: Credit {(btd - avx).AsCurrency()}, Balance {avx.AsCurrency()}"
                            : $"Plan: Debit {(avx - btd).AsCurrency()}, Balance {avx.AsCurrency()}");
                }
            }

            return(new PlainText(sb.ToString()));
        }
コード例 #12
0
 public AverageDailyBalance(Accountant accountant) : base(accountant)
 {
 }
コード例 #13
0
 public BaseCurrencyShell(Accountant helper) => m_Accountant = helper;
コード例 #14
0
 protected PluginBase(Accountant accountant) => Accountant = accountant;
コード例 #15
0
 public ItemsListSummaryRpt(Accountant acc)
     : base(acc)
 {
 }
コード例 #16
0
ファイル: AccountantService.cs プロジェクト: ZengYuming/TNS
        public bool Update(Accountant accountant)
        {
            try
            {
                string sql = "UPDATE accountant SET Account=?Account,PassWord=?PassWord,Name=?Name WHERE AccountantId=?AccountantId";

                MySqlParameter[] parameter = new MySqlParameter[] {
                    new MySqlParameter("?AccountantId", accountant.AccountantId),
                    new MySqlParameter("?Account", accountant.Account),
                    new MySqlParameter("?PassWord", accountant.PassWord) ,
                    new MySqlParameter("?Name", accountant.Name)
                };

                return MySqlHelper.ExecuteNonQuery(CommandType.Text, sql, parameter) == 1;
            }
            catch (Exception e)
            {
                MySqlHelper.CloseDBConnection();
                throw e;
            }
            finally
            {

            }
        }
コード例 #17
0
 public YieldRate(Accountant accountant) : base(accountant)
 {
 }
コード例 #18
0
        /// <summary>
        ///     从上次计息日后一日起计算单利利息并整理还款
        /// </summary>
        /// <param name="info">借款信息</param>
        /// <param name="capitalIntegral">剩余本金</param>
        /// <param name="interestIntegral">剩余利息</param>
        /// <param name="lastSettlement">上次计息日</param>
        /// <param name="finalDay">截止日期</param>
        private void Regularize(LoanInfo info, ref double capitalIntegral, ref double interestIntegral,
            DateTime? lastSettlement, DateTime finalDay)
        {
            var capitalPattern = info.AsCapital(this);
            var interestPattern = info.AsInterest(this);
            var rng = lastSettlement.HasValue
                ? new DateFilter(lastSettlement.Value.AddDays(1), finalDay)
                : new DateFilter(null, finalDay);
            foreach (var grp in
                Accountant
                    .RunVoucherQuery($"{info.QueryMajor(this)} {rng.AsDateRange()}")
                    .GroupBy(v => v.Date)
                    .OrderBy(grp => grp.Key, new DateComparer()))
            {
                var key = grp.Key ?? throw new ApplicationException("无法处理无穷长时间以前的利息收入");

                if (!lastSettlement.HasValue)
                    lastSettlement = key;

                // Settle Interest
                interestIntegral += SettleInterest(
                    info,
                    capitalIntegral,
                    key.Subtract(lastSettlement.Value).Days,
                    grp.SingleOrDefault(
                        v =>
                            v.Details.Any(d => d.IsMatch(interestPattern, Dir())))
                    ?? new Voucher
                        {
                            Date = key,
                            Details = new List<VoucherDetail>()
                        });
                lastSettlement = key;

                // Settle Loan
                // ReSharper disable once PossibleInvalidOperationException
                capitalIntegral +=
                    grp.SelectMany(v => v.Details.Where(d => d.IsMatch(capitalPattern, Dir())))
                        .Select(d => d.Fund.Value)
                        .Sum();

                // Settle Return
                foreach (
                    var voucher in
                    grp.Where(
                            v =>
                                v.Details.Any(
                                    d => d.IsMatch(capitalPattern, -Dir()) || d.IsMatch(interestPattern, -Dir())))
                        .OrderBy(v => v.ID))
                {
                    // ReSharper disable once PossibleInvalidOperationException
                    var value =
                        -voucher.Details.Where(
                                d => d.IsMatch(capitalPattern, -Dir()) || d.IsMatch(interestPattern, -Dir()))
                            .Select(d => d.Fund.Value)
                            .Sum();
                    if ((Dir() * (-value + interestIntegral)).IsNonNegative())
                    {
                        RegularizeVoucherDetail(info, voucher, 0, value);
                        interestIntegral -= value;
                    }
                    else
                    {
                        RegularizeVoucherDetail(info, voucher, value - interestIntegral, interestIntegral);
                        capitalIntegral -= value - interestIntegral;
                        interestIntegral = 0;
                    }
                }
            }

            if (lastSettlement == null)
                throw new ApplicationException("无法处理无穷长时间以前的利息收入");

            if (lastSettlement != finalDay)
                interestIntegral += SettleInterest(
                    info,
                    capitalIntegral,
                    finalDay.Subtract(lastSettlement.Value).Days,
                    new Voucher
                        {
                            Date = finalDay,
                            Details = new List<VoucherDetail>()
                        });
        }
コード例 #19
0
 public CreditCardConvert(Accountant accountant) : base(accountant)
 {
 }
コード例 #20
0
 protected InterestBase(Accountant accountant) : base(accountant) { }
コード例 #21
0
 public CheckShell(Accountant helper) => m_Accountant = helper;
コード例 #22
0
        /// <summary>
        ///     正确登记还款
        /// </summary>
        /// <param name="info">借款信息</param>
        /// <param name="voucher">记账凭证</param>
        /// <param name="capVol">本金还款额</param>
        /// <param name="intVol">利息还款额</param>
        private void RegularizeVoucherDetail(LoanInfo info, Voucher voucher, double capVol, double intVol)
        {
            var flag = false;
            var capFlag = false;
            var intFlag = false;
            for (var i = 0; i < voucher.Details.Count; i++)
            {
                if (voucher.Details[i].IsMatch(info.AsCapital(this), -Dir()))
                {
                    if (capFlag || capVol.IsZero())
                    {
                        voucher.Details.RemoveAt(i);
                        flag = true;
                        i--;
                        continue;
                    }

                    // ReSharper disable once PossibleInvalidOperationException
                    if (!(voucher.Details[i].Fund.Value - capVol).IsZero())
                    {
                        voucher.Details[i].Fund = -capVol;
                        flag = true;
                    }

                    capFlag = true;
                }

                if (voucher.Details[i].IsMatch(info.AsInterest(this), -Dir()))
                {
                    if (intFlag || intVol.IsZero())
                    {
                        voucher.Details.RemoveAt(i);
                        flag = true;
                        i--;
                        continue;
                    }

                    // ReSharper disable once PossibleInvalidOperationException
                    if (!(voucher.Details[i].Fund.Value - intVol).IsZero())
                    {
                        voucher.Details[i].Fund = -intVol;
                        flag = true;
                    }

                    intFlag = true;
                }
            }

            if (!capFlag &&
                !capVol.IsZero())
            {
                voucher.Details.Add(info.AsCapital(this, -capVol));
                flag = true;
            }

            if (!intFlag &&
                !intVol.IsZero())
            {
                voucher.Details.Add(info.AsInterest(this, -intVol));
                flag = true;
            }

            if (flag)
                Accountant.Upsert(voucher);
        }
コード例 #23
0
        private void PopulateData(Excel.Worksheet ws)
        {
            Sheet1 sh1 = Globals.Sheet1;
            Sheet2 sh2 = Globals.Sheet2;

            int year_from = int.Parse(txtFromYear.Text);
            int year_to   = int.Parse(txtToYear.Text);

            int    SaleAmountColIndex        = 0;
            int    CostOfSalesAmountColIndex = 0;
            int    GrossProfitColIndex       = 0;
            int    ProfitMarginColIndex      = 0;
            double TotalSaleAmount           = 0;
            double TotalCostOfSalesAmount    = 0;
            double TotalGrossProfit          = 0;
            double TotalProfitMargin         = 0;

            bool oldSh2Locked = sh2.Locked;

            sh2.Locked = false;

            Excel.Range cell = null;

            Accountant _obj = AccountantPool.Instance.CurrentAccountant;

            IList <Item> items = _obj.ItemMgr.List();

            int columnIndex = 1;
            int rowOffset   = 7;

            if (chkItemNumber.Checked)
            {
                cell           = ws.Cells[rowOffset, columnIndex++] as Excel.Range;
                cell.Value2    = "Item #";
                cell.Font.Bold = true;
            }
            if (chkItemName.Checked)
            {
                cell           = ws.Cells[rowOffset, columnIndex++] as Excel.Range;
                cell.Value2    = "Name";
                cell.Font.Bold = true;
            }
            if (chkBatchNumber.Checked)
            {
                cell           = ws.Cells[rowOffset, columnIndex++] as Excel.Range;
                cell.Value2    = "Batch #";
                cell.Font.Bold = true;
            }
            if (chkSerialNumber.Checked)
            {
                cell           = ws.Cells[rowOffset, columnIndex++] as Excel.Range;
                cell.Value2    = "Serial #";
                cell.Font.Bold = true;
            }
            if (chkExpiryDate.Checked)
            {
                cell           = ws.Cells[rowOffset, columnIndex++] as Excel.Range;
                cell.Value2    = "Expiry Date";
                cell.Font.Bold = true;
            }
            if (chkBrand.Checked)
            {
                cell           = ws.Cells[rowOffset, columnIndex++] as Excel.Range;
                cell.Value2    = "Brand";
                cell.Font.Bold = true;
            }
            if (chkColor.Checked)
            {
                cell           = ws.Cells[rowOffset, columnIndex++] as Excel.Range;
                cell.Value2    = "Color";
                cell.Font.Bold = true;
            }
            if (chkGender.Checked)
            {
                cell           = ws.Cells[rowOffset, columnIndex++] as Excel.Range;
                cell.Value2    = "Gender";
                cell.Font.Bold = true;
            }
            if (chkSize.Checked)
            {
                cell           = ws.Cells[rowOffset, columnIndex++] as Excel.Range;
                cell.Value2    = "Size";
                cell.Font.Bold = true;
            }

            if (chkSaleAmount.Checked)
            {
                SaleAmountColIndex = columnIndex;
                cell           = ws.Cells[rowOffset, columnIndex++] as Excel.Range;
                cell.Value2    = "Sales";
                cell.Font.Bold = true;
            }
            if (chkCostOfSalesAmount.Checked)
            {
                CostOfSalesAmountColIndex = columnIndex;
                cell           = ws.Cells[rowOffset, columnIndex++] as Excel.Range;
                cell.Value2    = "Cost of Sales";
                cell.Font.Bold = true;
            }
            if (chkGrossProfit.Checked)
            {
                GrossProfitColIndex = columnIndex;
                cell           = ws.Cells[rowOffset, columnIndex++] as Excel.Range;
                cell.Value2    = "Gross Profit";
                cell.Font.Bold = true;
            }
            if (chkProfitMargin.Checked)
            {
                ProfitMarginColIndex = columnIndex;
                cell           = ws.Cells[rowOffset, columnIndex++] as Excel.Range;
                cell.Value2    = "%Margin";
                cell.Font.Bold = true;
            }

            if (chkUnitsSold.Checked)
            {
                cell           = ws.Cells[rowOffset, columnIndex++] as Excel.Range;
                cell.Value2    = "Units Sold";
                cell.Font.Bold = true;
            }
            if (chkAverageCost.Checked)
            {
                cell           = ws.Cells[rowOffset, columnIndex++] as Excel.Range;
                cell.Value2    = "Average Cost";
                cell.Font.Bold = true;
            }

            int totalColCount = columnIndex - 1;

            ws.get_Range(ws.Cells[1, 1], ws.Cells[1, totalColCount]).Merge(missing);
            cell = ws.Cells[1, 1] as Excel.Range;
            cell.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
            cell.Font.Bold           = true;
            cell.Value2 = _obj.DataFileInformationMgr.Company.CompanyName;

            ws.get_Range(ws.Cells[2, 1], ws.Cells[2, totalColCount]).Merge(missing);
            cell = ws.Cells[2, 1] as Excel.Range;
            cell.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
            cell.Font.Italic         = true;
            cell.RowHeight           = 48;
            cell.Value2 = _obj.DataFileInformationMgr.Company.Address;

            ws.get_Range(ws.Cells[3, 1], ws.Cells[3, totalColCount]).Merge(missing);
            cell = ws.Cells[3, 1] as Excel.Range;
            cell.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
            cell.Font.Bold           = true;
            cell.Value2 = "Analyse Sales [Item]";

            ws.get_Range(ws.Cells[4, 1], ws.Cells[4, totalColCount]).Merge(missing);
            cell = ws.Cells[4, 1] as Excel.Range;
            cell.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
            cell.Font.Bold           = true;
            if (year_from == year_to)
            {
                cell.Value2 = string.Format("{0}", year_from);
            }
            else
            {
                cell.Value2 = string.Format("{0} - {1}", year_from, year_to);
            }

            ws.get_Range(ws.Cells[5, 1], ws.Cells[5, totalColCount]).Merge(missing);
            cell = ws.Cells[5, 1] as Excel.Range;
            cell.HorizontalAlignment = Excel.XlHAlign.xlHAlignLeft;
            cell.Font.Bold           = true;
            cell.Value2 = DateTime.Now.ToString("yyyy-MMM-dd");

            ws.get_Range(ws.Cells[6, 1], ws.Cells[6, totalColCount]).Merge(missing);
            cell = ws.Cells[6, 1] as Excel.Range;
            cell.HorizontalAlignment = Excel.XlHAlign.xlHAlignLeft;
            cell.Font.Bold           = true;
            cell.Value2 = DateTime.Now.ToString("HH:mm:ss");

            rowOffset++;

            int itemCount = items.Count;

            for (int i = 0; i < itemCount; ++i)
            {
                columnIndex = 1;

                LightItem _lght = sh2.GetItem(items[i].ItemNumber);

                if (chkItemNumber.Checked)
                {
                    cell        = ws.Cells[i + rowOffset, columnIndex++] as Excel.Range;
                    cell.Value2 = items[i].ItemNumber;
                }

                if (chkItemName.Checked)
                {
                    cell        = ws.Cells[i + rowOffset, columnIndex++] as Excel.Range;
                    cell.Value2 = items[i].ItemName;
                }

                if (chkBatchNumber.Checked)
                {
                    cell        = ws.Cells[i + rowOffset, columnIndex++] as Excel.Range;
                    cell.Value2 = _lght.BatchNumber;
                }

                if (chkSerialNumber.Checked)
                {
                    cell        = ws.Cells[i + rowOffset, columnIndex++] as Excel.Range;
                    cell.Value2 = _lght.SerialNumber;
                }

                if (chkExpiryDate.Checked)
                {
                    cell        = ws.Cells[i + rowOffset, columnIndex++] as Excel.Range;
                    cell.Value2 = _lght.ExpiryDate.ToString("yyyy-MMM-dd");
                }

                if (chkBrand.Checked)
                {
                    cell        = ws.Cells[i + rowOffset, columnIndex++] as Excel.Range;
                    cell.Value2 = _lght.Brand;
                }

                if (chkColor.Checked)
                {
                    cell        = ws.Cells[i + rowOffset, columnIndex++] as Excel.Range;
                    cell.Value2 = _lght.Color;
                }

                if (chkGender.Checked)
                {
                    cell        = ws.Cells[i + rowOffset, columnIndex++] as Excel.Range;
                    cell.Value2 = _lght.Gender.ToString();
                }

                if (chkSize.Checked)
                {
                    cell        = ws.Cells[i + rowOffset, columnIndex++] as Excel.Range;
                    cell.Value2 = _lght.Size.ToString();
                }



                List <ItemSalesHistory> itemSalesHistories = _obj.ItemSalesHistoryMgr.List(items[i].ItemID, year_from, year_to);
                double SaleAmount = 0;
                if (chkSaleAmount.Checked || chkGrossProfit.Checked)
                {
                    foreach (ItemSalesHistory history in itemSalesHistories)
                    {
                        SaleAmount += history.SaleAmount;
                    }

                    cell        = ws.Cells[i + rowOffset, columnIndex++] as Excel.Range;
                    cell.Value2 = _obj.CurrencyMgr.Format(SaleAmount);
                }

                double CostOfSalesAmount = 0;
                if (chkCostOfSalesAmount.Checked || chkGrossProfit.Checked)
                {
                    foreach (ItemSalesHistory history in itemSalesHistories)
                    {
                        CostOfSalesAmount += history.CostOfSalesAmount;
                    }

                    cell        = ws.Cells[i + rowOffset, columnIndex++] as Excel.Range;
                    cell.Value2 = _obj.CurrencyMgr.Format(CostOfSalesAmount);
                }

                double GrossProfit = SaleAmount - CostOfSalesAmount;
                if (chkGrossProfit.Checked)
                {
                    cell        = ws.Cells[i + rowOffset, columnIndex++] as Excel.Range;
                    cell.Value2 = _obj.CurrencyMgr.Format(GrossProfit);
                }

                double margin = 0;
                if (SaleAmount != 0)
                {
                    margin = GrossProfit * 100 / SaleAmount;
                }
                if (chkProfitMargin.Checked)
                {
                    cell        = ws.Cells[i + rowOffset, columnIndex++] as Excel.Range;
                    cell.Value2 = _obj.CurrencyMgr.FormatPercent(margin);
                }

                if (chkUnitsSold.Checked)
                {
                    double UnitsSold = 0;
                    foreach (ItemSalesHistory history in itemSalesHistories)
                    {
                        UnitsSold += history.UnitsSold;
                    }

                    cell        = ws.Cells[i + rowOffset, columnIndex++] as Excel.Range;
                    cell.Value2 = UnitsSold.ToString();
                }

                if (chkAverageCost.Checked)
                {
                    cell        = ws.Cells[i + rowOffset, columnIndex++] as Excel.Range;
                    cell.Value2 = _obj.CurrencyMgr.Format(items[i].PositiveAverageCost);
                }

                TotalSaleAmount        += SaleAmount;
                TotalProfitMargin      += margin;
                TotalGrossProfit       += GrossProfit;
                TotalCostOfSalesAmount += CostOfSalesAmount;
            }

            if (chkSaleAmount.Checked)
            {
                cell        = ws.Cells[itemCount + rowOffset, SaleAmountColIndex] as Excel.Range;
                cell.Value2 = _obj.CurrencyMgr.Format(TotalSaleAmount / itemCount);
            }
            if (chkCostOfSalesAmount.Checked)
            {
                cell        = ws.Cells[itemCount + rowOffset, CostOfSalesAmountColIndex] as Excel.Range;
                cell.Value2 = _obj.CurrencyMgr.Format(TotalCostOfSalesAmount / itemCount);
            }
            if (chkProfitMargin.Checked)
            {
                cell        = ws.Cells[itemCount + rowOffset, ProfitMarginColIndex] as Excel.Range;
                cell.Value2 = _obj.CurrencyMgr.FormatPercent(TotalProfitMargin / itemCount);
            }
            if (chkGrossProfit.Checked)
            {
                cell        = ws.Cells[itemCount + rowOffset, GrossProfitColIndex] as Excel.Range;
                cell.Value2 = _obj.CurrencyMgr.Format(TotalGrossProfit / itemCount);
            }


            ws.UsedRange.Columns.AutoFit();

            sh2.Locked = oldSh2Locked;
        }
コード例 #24
0
        /// <inheritdoc />
        public override IQueryResult Execute(string expr, IEntitiesSerializer serializer)
        {
            var remark = Parsing.Token(ref expr);
            var rate = Parsing.DoubleF(ref expr) / 10000D;
            var all = Parsing.Optional(ref expr, "all");
            var endDate = !all ? Parsing.UniqueTime(ref expr) : null;
            Parsing.Eof(expr);

            var loans = Accountant.RunGroupedQuery($"({MajorFilter()})-\"\" ``rtcC").Items
                .Cast<ISubtotalRemark>()
                .ToList();
            var rmkObj =
                loans.Single(
                    b =>
                        b.Remark?.StartsWith(remark, StringComparison.InvariantCultureIgnoreCase) == true &&
                        !b.Remark.EndsWith("-利息", StringComparison.Ordinal));
            var titleObj = rmkObj.Items.Cast<ISubtotalTitle>().Single();
            var cntObj = titleObj.Items.Cast<ISubtotalContent>().Single();
            // ReSharper disable once PossibleInvalidOperationException
            var title = titleObj.Title.Value;
            var content = cntObj.Content;
            var rmk = rmkObj.Remark;
            var currency = cntObj.Items.Cast<ISubtotalCurrency>().Single().Currency;
            var info = new LoanInfo
                {
                    Currency = currency,
                    Title = title,
                    Content = content,
                    Remark = rmk,
                    Rate = rate
                };

            if (!all && !endDate.HasValue ||
                endDate.HasValue)
            {
                // ReSharper disable once PossibleInvalidOperationException
                var lastD = Accountant.RunVoucherQuery(info.QueryInterest(this))
                        .OrderByDescending(v => v.Date, new DateComparer())
                        .FirstOrDefault()
                        ?.Date ??
                    Accountant.RunVoucherQuery(info.QueryCapital(this))
                        .OrderBy(v => v.Date, new DateComparer())
                        .First()
                        .Date.Value;
                var capQuery = $"{info.QueryCapital(this)} [~{lastD.AsDate()}]``v";
                var intQuery = $"{info.QueryInterest(this)} [~{lastD.AsDate()}]``v";
                var capitalIntegral = Accountant.RunGroupedQuery(capQuery).Fund;
                var interestIntegral = Accountant.RunGroupedQuery(intQuery).Fund;
                Regularize(
                    info,
                    ref capitalIntegral,
                    ref interestIntegral,
                    lastD,
                    endDate ?? ClientDateTime.Today);
            }
            else
            {
                var capitalIntegral = 0D;
                var interestIntegral = 0D;
                Regularize(
                    info,
                    ref capitalIntegral,
                    ref interestIntegral,
                    null,
                    ClientDateTime.Today);
            }

            return new DirtySucceed();
        }
コード例 #25
0
        protected DistributedShell(Accountant helper)
        {
            Accountant = helper;
            var resetComopser =
                new ShellComposer
            {
                new ShellComponent(
                    "soft",
                    (expr, serializer) =>
                {
                    var dist = Parsing.DistributedQuery(ref expr);
                    var rng  = Parsing.Range(ref expr) ?? DateFilter.Unconstrained;
                    Parsing.Eof(expr);
                    return(ExecuteResetSoft(dist, rng));
                }),
                new ShellComponent(
                    "mixed",
                    (expr, serializer) =>
                {
                    var dist = Parsing.DistributedQuery(ref expr);
                    var rng  = Parsing.Range(ref expr) ?? DateFilter.Unconstrained;
                    Parsing.Eof(expr);
                    return(ExcuteResetMixed(dist, rng));
                }),
                new ShellComponent(
                    "hard",
                    (expr, serializer) =>
                {
                    var dist     = Parsing.DistributedQuery(ref expr);
                    var vouchers = Parsing.OptColVouchers(ref expr);
                    Parsing.Eof(expr);
                    return(ExecuteResetHard(dist, vouchers));
                })
            };

            m_Composer =
                new ShellComposer
            {
                new ShellComponent(
                    "all",
                    (expr, serializer) =>
                {
                    var safe = Parsing.Token(ref expr, false, t => t == "unsafe") == null;
                    var dist = Parsing.DistributedQuery(ref expr);
                    Parsing.Eof(expr);
                    if (dist.IsDangerous() && safe)
                    {
                        throw new SecurityException("检测到弱检索式");
                    }

                    return(ExecuteList(dist, null, false, serializer));
                }),
                new ShellComponent(
                    "li",
                    (expr, serializer) =>
                {
                    var safe = Parsing.Token(ref expr, false, t => t == "unsafe") == null;
                    var dt   = Parsing.UniqueTime(ref expr) ?? ClientDateTime.Today;
                    var dist = Parsing.DistributedQuery(ref expr);
                    Parsing.Eof(expr);
                    if (dist.IsDangerous() && safe)
                    {
                        throw new SecurityException("检测到弱检索式");
                    }

                    return(ExecuteList(dist, dt, true, serializer));
                }),
                new ShellComponent(
                    "q",
                    (expr, serializer) =>
                {
                    var safe = Parsing.Token(ref expr, false, t => t == "unsafe") == null;
                    var dist = Parsing.DistributedQuery(ref expr);
                    Parsing.Eof(expr);
                    if (dist.IsDangerous() && safe)
                    {
                        throw new SecurityException("检测到弱检索式");
                    }

                    return(ExecuteQuery(dist, serializer));
                }),
                new ShellComponent(
                    "reg",
                    (expr, serializer) =>
                {
                    var dist     = Parsing.DistributedQuery(ref expr);
                    var rng      = Parsing.Range(ref expr) ?? DateFilter.Unconstrained;
                    var vouchers = Parsing.OptColVouchers(ref expr);
                    Parsing.Eof(expr);
                    return(ExecuteRegister(dist, rng, vouchers, serializer));
                }),
                new ShellComponent(
                    "unreg",
                    (expr, serializer) =>
                {
                    var dist     = Parsing.DistributedQuery(ref expr);
                    var rng      = Parsing.Range(ref expr) ?? DateFilter.Unconstrained;
                    var vouchers = Parsing.OptColVouchers(ref expr);
                    Parsing.Eof(expr);
                    return(ExecuteUnregister(dist, rng, vouchers, serializer));
                }),
                new ShellComponent(
                    "recal",
                    (expr, serializer) =>
                {
                    var dist = Parsing.DistributedQuery(ref expr);
                    Parsing.Eof(expr);
                    return(ExecuteRecal(dist, serializer));
                }),
                new ShellComponent("rst", (expr, serializer) => resetComopser.Execute(expr, serializer)),
                new ShellComponent(
                    "ap",
                    (expr, serializer) =>
                {
                    var collapse = Parsing.Optional(ref expr, "col");
                    var dist     = Parsing.DistributedQuery(ref expr);
                    var rng      = Parsing.Range(ref expr) ?? DateFilter.Unconstrained;
                    Parsing.Eof(expr);
                    return(ExecuteApply(dist, rng, collapse));
                }),
                new ShellComponent(
                    "chk",
                    (expr, serializer) =>
                {
                    var dist = Parsing.DistributedQuery(ref expr);
                    Parsing.Eof(expr);
                    return(ExecuteCheck(dist, new DateFilter(null, ClientDateTime.Today), serializer));
                }),
                new ShellComponent(
                    null,
                    (expr, serializer) =>
                {
                    var dt   = Parsing.UniqueTime(ref expr) ?? ClientDateTime.Today;
                    var dist = Parsing.DistributedQuery(ref expr);
                    Parsing.Eof(expr);
                    return(ExecuteList(dist, dt, false, serializer));
                })
            };
        }
コード例 #26
0
 public Composite(Accountant accountant) : base(accountant)
 {
 }
コード例 #27
0
 public Statement(Accountant accountant) : base(accountant)
 {
 }
コード例 #28
0
 public AssetDisposition(Accountant accountant) : base(accountant)
 {
 }
コード例 #29
0
        private void chkBackupItemAddOn_CheckedChanged(object sender, EventArgs e)
        {
            Accountant _obj = mApplicationController.mAccountant;

            _obj.ConfigMgr.SetParam("BACKUP_ITEMADDON", chkBackupItemAddOn.Checked ? "1" : "0");
        }
コード例 #30
0
        /// <inheritdoc />
        public override IQueryResult Execute(string expr, IEntitiesSerializer serializer)
        {
            var voucherID = Parsing.Token(ref expr);
            var guids     = new List <string>();
            var guidT     = Guid.Empty;

            // ReSharper disable once AccessToModifiedClosure
            while (Parsing.Token(ref expr, true, s => Guid.TryParse(s, out guidT)) != null)
            {
                guids.Add(guidT.ToString());
            }
            Parsing.Eof(expr);

            var voucher = Accountant.SelectVoucher(voucherID);

            if (voucher == null)
            {
                throw new ApplicationException("找不到记账凭证");
            }

            var sb = new StringBuilder();

            foreach (var detail in voucher.Details.Where(vd => vd.Title == 1601 || vd.Title == 1701))
            {
                if (guids.Count != 0 &&
                    !guids.Contains(detail.Content))
                {
                    continue;
                }

                var asset = Accountant.SelectAsset(Guid.Parse(detail.Content));
                foreach (var item in asset.Schedule)
                {
                    if (item is DispositionItem)
                    {
                        throw new InvalidOperationException("已经处置");
                    }

                    if (item.Date < voucher.Date)
                    {
                        if (item.VoucherID == null)
                        {
                            throw new InvalidOperationException("尚未注册");
                        }
                    }
                    else
                    {
                        if (item.VoucherID != null)
                        {
                            throw new InvalidOperationException("注册过多");
                        }
                    }
                }

                var id = asset.Schedule.FindIndex(it => it.Date >= voucher.Date);
                if (id != -1)
                {
                    asset.Schedule.RemoveRange(id, asset.Schedule.Count - id);
                }

                asset.Schedule.Add(new DispositionItem {
                    Date = voucher.Date, VoucherID = voucher.ID
                });
                sb.Append(serializer.PresentAsset(asset).Wrap());
                Accountant.Upsert(asset);
            }

            if (sb.Length > 0)
            {
                return(new DirtyText(sb.ToString()));
            }

            return(new PlainSucceed());
        }
コード例 #31
0
        private void show_Click(object sender, EventArgs e)
        {
            hmssDataContext dbcon = new hmssDataContext();

            Admin        pro1 = new Admin();
            Receptionist pro3 = new Receptionist();
            Employee     pro4 = new Employee();
            Doctor       pro5 = new Doctor();


            pro1 = dbcon.Admins.SingleOrDefault(x => x.LoginID == holdID);


            pro5 = dbcon.Doctors.SingleOrDefault(x => x.LoginID == holdID);
            pro3 = dbcon.Receptionists.SingleOrDefault(x => x.LoginID == holdID);
            pro4 = dbcon.Employees.SingleOrDefault(x => x.LoginID == holdID);


            MessageBox.Show(holdID, holdProfile);


            if (pro1.LoginID == holdID && holdProfile == "ADMIN")
            {
                if (pro1 != null)
                {
                    MessageBox.Show("NOT NULL ADMIN");
                    metroTextBox1.Text = pro1.AdminName;
                    metroTextBox2.Text = "N/A";
                    metroTextBox3.Text = "N/A";
                    metroTextBox4.Text = "N/A";
                    metroTextBox5.Text = pro1.AdminPhone;
                    metroTextBox6.Text = "N/A";
                }
                else
                {
                    MessageBox.Show(" NULL ADMIN");
                    MetroMessageBox.Show(this, "Incorrect Data.", "Halt!!!", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error);
                }
            }

            Patient pro2 = new Patient();

            pro2 = dbcon.Patients.SingleOrDefault(x => x.LoginID == holdID);

            if (pro2.LoginID == holdID && holdProfile == "PATIENT")
            {
                if (pro2 != null)
                {
                    MessageBox.Show("NOT NULL");
                    metroTextBox1.Text = pro2.PatientName;
                    metroTextBox2.Text = pro2.PatientAge;
                    metroTextBox3.Text = pro2.PatientGender;
                    metroTextBox4.Text = pro2.PatientAddress;
                    metroTextBox5.Text = pro2.PatientPhone;
                    metroTextBox6.Text = "N/A";
                }
                else
                {
                    MessageBox.Show("NULL");
                    MetroMessageBox.Show(this, "NULL DATABASE.", "Halt!!!", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error);
                }
            }

            Accountant pro6 = new Accountant();

            pro6 = dbcon.Accountants.SingleOrDefault(x => x.LoginID == holdID);


            if (pro6.AccountantID == holdID && holdProfile == "ACCOUNTANT")

            {
                MessageBox.Show(holdProfile);

                if (pro6 != null)
                {
                    metroTextBox1.Text = pro6.AccountantName;
                    metroTextBox2.Text = pro6.AccountantAge;
                    metroTextBox3.Text = pro6.AccountantGender;
                    metroTextBox4.Text = pro6.AccountantAddress;
                    metroTextBox5.Text = pro6.AccountantPhone;
                    metroTextBox6.Text = pro6.AccountantEmail;
                }
                else
                {
                    MetroMessageBox.Show(this, "Incorrect Data.", "Halt!!!", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error);
                }
            }


            if (pro5.LoginID == holdID && holdProfile == "DOCTOR")

            {
                if (pro5 != null)
                {
                    metroTextBox1.Text = pro5.DoctorName;
                    metroTextBox2.Text = pro5.DoctorAge;
                    metroTextBox3.Text = pro5.DoctorGender;
                    metroTextBox4.Text = pro5.DoctorAddress;
                    metroTextBox5.Text = pro5.DoctorPhone;
                    metroTextBox6.Text = pro5.DoctorEmail;
                }
                else
                {
                    MetroMessageBox.Show(this, "Incorrect Data.", "Halt!!!", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error);
                }
            }

            else if (pro3.LoginID == holdID && holdProfile == "RECEPTIONIST")
            {
                if (pro3 != null)
                {
                    metroTextBox1.Text = pro3.ReceptionistName;
                    metroTextBox2.Text = pro3.ReceptionistAge;
                    metroTextBox3.Text = pro3.ReceptionistGender;
                    metroTextBox4.Text = pro3.ReceptionistAddress;
                    metroTextBox5.Text = pro3.ReceptionistPhone;
                    metroTextBox6.Text = pro3.ReceptionistEmail;
                }
                else
                {
                    MetroMessageBox.Show(this, "Incorrect Data.", "Halt!!!", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error);
                }
            }
            else if (pro4.LoginID == holdID && holdProfile == "Employee")
            {
                if (pro4 != null)
                {
                    metroTextBox1.Text = pro4.EmployeeName;
                    metroTextBox2.Text = pro4.EmployeeAge;
                    metroTextBox3.Text = pro4.EmployeeGender;
                    metroTextBox4.Text = pro4.EmployeeAddress;
                    metroTextBox5.Text = pro4.EmployeePhone;
                    metroTextBox6.Text = pro4.EmployeeEmail;
                }
                else
                {
                    MetroMessageBox.Show(this, "Incorrect Data.", "Halt!!!", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error);
                }
            }
        }
コード例 #32
0
 public BOListLocation(Accountant accountant)
     : base(accountant)
 {
     mObjectID = BOType.BOListLocation;
 }