private void saveSougiTable()
{
string sData;
int yy, mm, dd, hh, min;
string sYMD;
string sSHM, sEHM;
DateTime dt = DateTime.Now;
sData = m_nCrtSougiId + "," + dt.ToString("yyyy/MM/dd hh:mm");
sData = sData + "," + m_sSGSeikyuno + "," + txtSouke.Text;
yy = m_libCmn.StrToInt(txtTuyaYY.Text);
mm = m_libCmn.StrToInt(txtTuyaMM.Text);
dd = m_libCmn.StrToInt(txtTuyaDD.Text);
sYMD = yy.ToString("D4") + "/" + mm.ToString("D2") + "/" + dd.ToString("D2");
hh = m_libCmn.StrToInt(txtSTuyaHH.Text);
min = m_libCmn.StrToInt(txtSTuyaMin.Text);
sSHM = hh.ToString("D2") + ":" + min.ToString("D2");
hh = m_libCmn.StrToInt(txtETuyaHH.Text);
min = m_libCmn.StrToInt(txtETuyaMin.Text);
sEHM = hh.ToString("D2") + ":" + min.ToString("D2");
sData = sData + "," + sYMD + "," + sSHM + "," + sEHM;
hh = m_libCmn.StrToInt(txtSSikiHH.Text);
min = m_libCmn.StrToInt(txtSSikiMin.Text);
sSHM = hh.ToString("D2") + ":" + min.ToString("D2");
hh = m_libCmn.StrToInt(txtESikiHH.Text);
min = m_libCmn.StrToInt(txtESikiMin.Text);
sEHM = hh.ToString("D2") + ":" + min.ToString("D2");
sData = sData + "," + m_sKokubetu + "," + sSHM + "," + sEHM;
sData = sData + "," + txtSekoubasyo.Text + "," + txtTantou.Text + ",,";
if (m_nCrtSougiId == 0)
{
m_nCrtSougiId = m_libOdbc.insertSougi(sData);
}
else
{
m_libOdbc.updateSougi(sData);
}
}
private void saveSougiSeikyuHanbai()
{
string sFilds;
sFilds = getSougiFilds();
if (m_nCrtSougiId == 0)
{
m_nCrtSougiId = m_libOdbc.insertSougi(sFilds);
}
else
{
m_libOdbc.updateSougi(sFilds);
}
sFilds = getSeikyuFilds();
if (m_nCrtSeikyuId == 0)
{
m_nCrtSeikyuId = m_libOdbc.insertSeikyu(sFilds);
}
else
{
m_libOdbc.updateSeikyu(sFilds);
}
saveHanbaiTable();
}