Exemplo n.º 1
0
        private void selectMitsumoriList()
        {
            H0210_MitsumoriInput_B inputB = new H0210_MitsumoriInput_B();

            textBox10.Text = "";

            try
            {
                this.Cursor = Cursors.WaitCursor;
                int iRd1 = 1;
                if (rdSort2.Checked)
                {
                    iRd1 = 2;
                }
                int iRd2 = 0;
                if (rdShoninYes.Checked)
                {
                    iRd2 = 1;
                }
                else if (rdShoninNo.Checked)
                {
                    iRd2 = 2;
                }

                DataTable dt = inputB.getMitsumoriList(txtFrom.Text, txtTo.Text, lsTanto.CodeTxtText, lsTokui.CodeTxtText,
                                                       txtTanto.Text, txtKenmei.Text, txtBiko.Text, txtKata.Text, iRd1, iRd2);

                int intCnt = 0;
                if (dt != null && dt.Rows.Count > 0)
                {
                    intCnt = dt.Rows.Count;
                }

                textBox10.Text = intCnt.ToString();

                gridMitsu.DataSource = dt;
                gridMitsu.Focus();
            }
            catch (Exception ex)
            {
                //データロギング
                new CommonException(ex);
                inputB.rollback();
                //例外発生メッセージ(OK)
                BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_ERROR, CommonTeisu.LABEL_ERROR_MESSAGE, CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR);
                basemessagebox.ShowDialog();
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }
Exemplo n.º 2
0
        private void updShonin(string strFlg)
        {
            int intRowNum = gridMitsu.CurrentCell.RowIndex;
            DataGridViewSelectedRowCollection rc = gridMitsu.SelectedRows;

            H0210_MitsumoriInput_B inputB = new H0210_MitsumoriInput_B();

            try
            {
                this.Cursor = Cursors.WaitCursor;
                inputB.beginTrance();

                int intRowIdx = 0;

                for (int i = 0; i < rc.Count; i++)
                {
                    intRowIdx = rc[i].Index;

                    if (gridMitsu[1, intRowIdx].Value != null)
                    {
                        inputB.updShoninFlg((gridMitsu[1, intRowIdx].Value).ToString(), strFlg, txtMemo.Text);
                    }
                }

                if (rc.Count > 0)
                {
                    inputB.commit();
                }
                selectMitsumoriList();
            }
            catch (Exception ex)
            {
                inputB.rollback();
                //データロギング
                new CommonException(ex);
                //例外発生メッセージ(OK)
                BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_ERROR, CommonTeisu.LABEL_ERROR_MESSAGE, CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR);
                basemessagebox.ShowDialog();
                return;
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }