예제 #1
0
        private void updateHanbaiRecord()
        {
            string sData;
            string sCsv;

            DateTime dt        = DateTime.Now;
            string   sCrtymdhm = dt.ToString("yyyy/MM/dd HH:mm");

            sData = getElementText();
            m_libOdbc.updateHanbai(sData);
            if (txtSeikyuSaki.Text != "")
            {
                m_nSeikyusakiId = searchSeikyuusakiId(txtSeikyuSaki.Text, txtSeikyuBusyo.Text);
                sCsv            = m_nSeikyusakiId + "," + sCrtymdhm + "," + txtSeikyuSaki.Text + "," + txtSeikyuBusyo.Text;
                sCsv            = sCsv + "," + cmbSKeisyou.Text + "," + cmbAKeisyou.Text;
                sCsv            = sCsv + "," + txtSeikyuPost.Text;
                sCsv            = sCsv + "," + txtSeikyuAdrs1.Text + "," + txtSeikyuAdrs2.Text;
                sCsv            = sCsv + "," + txtSeikyuTel.Text + "," + txtSeikyuFax.Text;
                sCsv            = sCsv + "," + txtSeikyuPay.Text + ",,";
                if (m_nSeikyusakiId == 0)
                {
                    m_nSeikyusakiId = m_libOdbc.insertSeikyusaki(sCsv);
                }
                else
                {
                    m_libOdbc.updateSeikyusaki(sCsv);
                }
            }
            m_bModify = false;
        }