C# (CSharp) darwinDataSet.新請求書Row.Get新入金Rows Examples

Example #1

        /// ------------------------------------------------------------------
        /// <summary>
        ///     グリッドデータを表示する </summary>
        /// <param name="g">
        ///     データグリッドビューオブジェクト</param>
        /// ------------------------------------------------------------------
        private void gridShow(DataGridView g, int sID)
        {
            if (!dts.新請求書.Any(a => a.ID == sID))
            {
                return;
            }

            nr = dts.新請求書.Single(a => a.ID == sID);

            lblNum.Text        = nr.ID.ToString();
            lblClientCode.Text = nr.得意先ID.ToString();

            if (nr.得意先Row != null)
            {
                lblClientName.Text = nr.得意先Row.略称;
            }
            else
            {
                lblClientName.Text = string.Empty;
            }

            lblHDt.Text    = nr.請求書発行日.ToShortDateString();
            lblSDt.Text    = nr.支払期日.ToShortDateString();
            lblSeikyu.Text = nr.請求金額.ToString("#,##0");
            lblUriage.Text = nr.売上金額.ToString("#,##0");
            lblTax.Text    = nr.消費税.ToString("#,##0");
            lblNebiki.Text = nr.値引額.ToString("#,##0");
            lblZan.Text    = nr.残金.ToString("#,##0");

            if (nr.入金完了 == global.FLGON)
            {
                checkBox1.Checked = true;
                label6.Visible    = true;
            }
            else
            {
                checkBox1.Checked = false;
                label6.Visible    = false;
            }

            // 入金済みメッセージ
            if (nr.入金完了 == global.FLGON && nr.残金 > 0)
            {
                label6.Text = "未収確定";
            }
            else if (nr.入金完了 == global.FLGON && nr.残金 == 0)
            {
                label6.Text = "入金完了";
            }
            else
            {
                label6.Text = string.Empty;
            }

            if (nr.Is備考Null())
            {
                txtSeikyuMemo.Text = string.Empty;
            }
            else
            {
                txtSeikyuMemo.Text = nr.備考;
            }

            // 入金日
            DateTime dt;

            if (DateTime.TryParse(lblSDt.Text, out dt))
            {
                dateTimePicker1.Value = dt;
            }
            else
            {
                dateTimePicker1.Value = DateTime.Today;
            }

            // 無効な請求書
            if (nr.無効 == global.FLGON)
            {
                lblMukou.Visible = true;
            }
            else
            {
                lblMukou.Visible = false;
            }

            // 精算日付
            if (nr.精算日付 == string.Empty)
            {
                dateTimeSai.Checked = false;
            }
            else
            {
                if (DateTime.TryParse(nr.精算日付, out dt))
                {
                    dateTimeSai.Checked = true;
                    dateTimeSai.Value   = dt;
                }
                else
                {
                    dateTimeSai.Checked = false;
                }
            }

            // 精算額
            txtSai.Text = nr.精算額.ToString();

            // 精算備考
            txtSaiMemo.Text = nr.精算備考.ToString();

            // 口座 : 2017/08/15
            if (Utility.nullToStr(nr.口座) == string.Empty)
            {
                cmbKouza.SelectedIndex = -1;
            }
            else
            {
                cmbKouza.SelectedIndex = -1;

                for (int i = 0; i < kouzaArray.Length; i++)
                {
                    if (kouzaArray[i] == nr.口座)
                    {
                        cmbKouza.SelectedIndex = i;
                        break;
                    }
                }
            }

            g.Rows.Clear();
            int iX = 0;

            foreach (var t in nr.Get新入金Rows())
            {
                g.Rows.Add();

                g[colDate, iX].Value    = t.入金年月日.ToShortDateString();
                g[colKingaku, iX].Value = t.金額.ToString("#,##0");
                g[colMemo, iX].Value    = t.備考;
                g[colID, iX].Value      = t.ID.ToString();

                iX++;
            }

            g.CurrentCell   = null;
            button2.Enabled = false;
        }