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; }
private void updateHanbaiData() { int max, idx; DataRow dataRow; int id, change; string sData; DateTime dt = DateTime.Now; max = m_dt.Rows.Count; for (idx = 0; idx < max; idx++) { dataRow = m_dt.Rows[idx]; id = m_libCmn.StrToInt(dataRow["col_id"].ToString()); change = m_libCmn.StrToInt(dataRow["col_change"].ToString()); dataRow["col_change"] = 0; // if (change == 1) { dataRow["col_regdate"] = dt.ToString("yyyy/MM/dd hh:mm"); sData = getDataRowString(dataRow); if (id == 0) { id = m_libOdbc.insertHanbai(sData); dataRow["col_id"] = id; } else { m_libOdbc.updateHanbai(sData); } } } dgHanbai.DataContext = m_dt; }
private void saveHanbaiTable() { int max, idx; string[] sAry; max = m_aryRecLine.Length; for (idx = 0; idx < max; idx++) { sAry = m_aryRecLine[idx].Split(','); if (4 < sAry.Length) { sAry[4] = m_nCrtSougiId.ToString(); m_aryRecLine[idx] = m_libCmn.AryToCsvString(sAry); m_libOdbc.updateHanbai(m_aryRecLine[idx]); } } }
private void saveHanbaiTable() { string sTmp; string[] sSKAry; int max, idx; string[] sAry; if (m_sSeikyusakiFilds != null && m_sSeikyusakiFilds != "") { sSKAry = m_sSeikyusakiFilds.Split(','); } else { sTmp = ""; sSKAry = sTmp.Split(','); } max = m_aryRecLine.Length; for (idx = 0; idx < max; idx++) { sAry = m_aryRecLine[idx].Split(','); if (4 < sAry.Length) { sAry[3] = m_nCrtSeikyuId.ToString(); sAry[4] = m_nCrtSougiId.ToString(); if (12 < sSKAry.Length) { sAry[14] = sSKAry[2]; sAry[15] = sSKAry[3]; sAry[16] = sSKAry[4]; sAry[17] = sSKAry[5]; sAry[18] = sSKAry[6]; sAry[19] = sSKAry[7]; sAry[20] = sSKAry[8]; sAry[21] = sSKAry[9]; sAry[22] = sSKAry[10]; sAry[23] = sSKAry[11]; } m_aryRecLine[idx] = m_libCmn.AryToCsvString(sAry); m_libOdbc.updateHanbai(m_aryRecLine[idx]); } } }