private void btn_sakujyo_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("担当者情報を削除しますか？",
"担当者削除",
MessageBoxButtons.OKCancel,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button2);
//何が選択されたか調べる
if (result == DialogResult.OK)
{
//「はい」が選択された時
tss.GetUser();
bool bl_tss;
bl_tss = tss.OracleDelete("delete from TSS_TORIHIKISAKI_TANTOU_M where TANTOUSYA_CD = '" + tb_tantousya_cd.Text + "'");
if (bl_tss != true)
{
tss.ErrorLogWrite(tss.user_cd, "取引先担当者マスタ／登録", "登録ボタン押下時のOracleUpdate");
MessageBox.Show("エラーが発生しました。処理を中止します。");
this.Close();
}
else
{
MessageBox.Show("担当者情報から削除しました。");
this.Close();
}
}
else if (result == DialogResult.Cancel)
{
//「キャンセル」が選択された時
Console.WriteLine("「キャンセル」が選択されました");
}
}
private void uriage_delete()
{
if (tss.OracleDelete("delete from tss_uriage_m where uriage_no = '" + tb_uriage_no.Text.ToString() + "'") == false)
{
tss.ErrorLogWrite(tss.user_cd, "売上", "登録ボタン押下時のOracleDelete");
MessageBox.Show("書込みでエラーが発生しました。処理を中止します。");
this.Close();
}
}
private void make_uriage_denpyou_trn()
{
DataTable w_dt_trn_count = new DataTable();
//トランファイルの存在を確認して、あったら削除
w_dt_trn_count = tss.OracleSelect("select * from user_tables where upper(table_name) = upper('tss_uriage_denpyou_trn')");
if (w_dt_trn_count.Rows.Count >= 1)
{
tss.OracleDelete("DROP TABLE tss_uriage_denpyou_trn CASCADE CONSTRAINTS");
}
//伝票印刷用のトランファイルを削除
//tss.OracleDelete("DROP TABLE tss_uriage_denpyou_trn CASCADE CONSTRAINTS");
//印刷用のトランファイルを作成
tss.OracleSelect("CREATE table tss_uriage_denpyou_trn AS SELECT * FROM tss_uriage_m where uriage_no = '" + tb_uriage_no.Text.ToString() + "'");
}
private void btn_sakujyo_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("口座情報を削除しますか？",
"口座削除",
MessageBoxButtons.OKCancel,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button2);
//何が選択されたか調べる
if (result == DialogResult.OK)
{
//「はい」が選択された時
int i = dgv_bank_m.CurrentCell.RowIndex;
tb_torihikisaki_cd.Text = dgv_bank_m[0, i].Value.ToString();
tb_torihikisaki_name.Text = dgv_bank_m[2, i].Value.ToString();
tb_bank_cd.Text = dgv_bank_m[3, i].Value.ToString();
tb_bank_name.Text = dgv_bank_m[4, i].Value.ToString();
tb_siten_cd.Text = dgv_bank_m[5, i].Value.ToString();
tb_siten_name.Text = dgv_bank_m[6, i].Value.ToString();
tb_kouza_syubetu.Text = dgv_bank_m[7, i].Value.ToString();
tb_kouza_no.Text = dgv_bank_m[8, i].Value.ToString();
tb_kouza_meigi.Text = dgv_bank_m[9, i].Value.ToString();
tss.GetUser();
bool bl_tss;
bl_tss = tss.OracleDelete("delete from TSS_BANK_M where torihikisaki_cd = '" + tb_torihikisaki_cd.Text + "'and bank_cd = '" + tb_bank_cd.Text + "'and siten_cd = '" + tb_siten_cd.Text + "' and kouza_syubetu = '" + tb_kouza_syubetu.Text + "'and kouza_no = '" + tb_kouza_no.Text + "'");
if (bl_tss != true)
{
tss.ErrorLogWrite(tss.user_cd, "銀行マスタ／登録", "登録ボタン押下時のOracleUpdate");
MessageBox.Show("エラーが発生しました。処理を中止します。");
//this.Close();
}
else
{
MessageBox.Show("口座情報から削除しました。");
dgv_disp();
tb_clear();
//this.Close();
}
}
else if (result == DialogResult.Cancel)
{
//「キャンセル」が選択された時
Console.WriteLine("「キャンセル」が選択されました");
}
}
private void btn_execute_Click(object sender, EventArgs e)
{
if (rb_select.Checked)
{
w_dt_result = tss.OracleSelect(tb_sql.Text);
dgv_result.DataSource = w_dt_result;
lbl_result.Text = "Done.";
}
else
{
if (rb_update.Checked)
{
w_bl = tss.OracleUpdate(tb_sql.Text);
dgv_result.DataSource = null;
lbl_result.Text = w_bl.ToString();
}
else
{
if (rb_insert.Checked)
{
w_bl = tss.OracleInsert(tb_sql.Text);
dgv_result.DataSource = null;
lbl_result.Text = w_bl.ToString();
}
else
{
if (rb_delete.Checked)
{
w_bl = tss.OracleDelete(tb_sql.Text);
dgv_result.DataSource = null;
lbl_result.Text = w_bl.ToString();
}
}
}
}
}
private void btn_touroku_Click(object sender, EventArgs e)
{
DataTable dt_work = new DataTable();
//登録前に全ての項目をチェック
//仕入番号
if (chk_siire_no() == false)
{
MessageBox.Show("仕入番号は10バイト以内で入力してください");
tb_siire_no.Focus();
return;
}
//仕入伝票番号
if (chk_siire_denpyou_no() == false)
{
MessageBox.Show("仕入伝票番号は16バイト以内で入力してください");
tb_siire_denpyou_no.Focus();
return;
}
//取引先コードのチェック
if (chk_torihikisaki_cd() == false)
{
MessageBox.Show("取引先コードは6文字で入力してください。");
tb_torihikisaki_cd.Focus();
return;
}
//データグリッドビューの中を1行ずつループしてチェック
int dgvrc = dgv_siire.Rows.Count;
if (dgvrc == 1)
{
MessageBox.Show("表の中に何も入力されていません");
return;
}
tss.GetUser(); //ユーザー情報の取得
//テキストボックスとデータグリッドビューの入力内容チェック
for (int i = 0; i < dgvrc - 1; i++)
{
if (dgv_siire.Rows[i].Cells[0].Value == null || tss.StringByte(dgv_siire.Rows[i].Cells[0].Value.ToString()) > 16)
{
MessageBox.Show("部品コードの値が異常です");
return;
}
if (dgv_siire.Rows[i].Cells[1].Value == null)
{
MessageBox.Show("部品名を入力してください");
return;
}
if (dgv_siire.Rows[i].Cells[2].Value == null || tss.StringByte(dgv_siire.Rows[i].Cells[2].Value.ToString()) > 12)
{
MessageBox.Show("仕入数量の値が異常です");
return;
}
if (dgv_siire.Rows[i].Cells[3].Value == null || tss.StringByte(dgv_siire.Rows[i].Cells[3].Value.ToString()) > 12)
{
MessageBox.Show("仕入単価を入力してください");
return;
}
if (dgv_siire.Rows[i].Cells[4].Value == null)
{
MessageBox.Show("仕入締日を入力してください");
return;
}
//支払計上日が空白の場合、""を代入 空欄だとnull扱いされ、SQエラー回避
if (dgv_siire.Rows[i].Cells[6].Value == null)
{
dgv_siire.Rows[i].Cells[6].Value = "";
}
//備考が空白の場合、""を代入 空欄だとnull扱いされ、SQエラー回避
if (dgv_siire.Rows[i].Cells[7].Value == null)
{
dgv_siire.Rows[i].Cells[7].Value = "";
}
}
dt_work = tss.OracleSelect("select * from tss_siire_m where siire_no = '" + tb_siire_no.Text.ToString() + "'");
int rc = dt_work.Rows.Count;
int rc2 = dgv_siire.Rows.Count;
tss.GetUser();
if (rc == 0)
{
for (int i = 0; i < rc2 - 1; i++)
{
bool bl = tss.OracleInsert("insert into tss_siire_m (siire_no, seq,torihikisaki_cd, siire_date,buhin_cd,buhin_name,siire_su,siire_tanka,siire_kingaku,siire_denpyo_no,siire_simebi,bikou,create_user_cd,create_datetime) values ('"
+ tb_siire_no.Text.ToString() + "','"
+ (i + 1) + "','"
+ tb_torihikisaki_cd.Text.ToString() + "','"
+ dtp_siire_date.Value.ToShortDateString() + "','"
+ dgv_siire.Rows[i].Cells[0].Value.ToString() + "','"
+ dgv_siire.Rows[i].Cells[1].Value.ToString() + "','"
+ dgv_siire.Rows[i].Cells[2].Value.ToString() + "','"
+ dgv_siire.Rows[i].Cells[3].Value.ToString() + "','"
+ dgv_siire.Rows[i].Cells[4].Value.ToString() + "','"
+ tb_siire_denpyou_no.Text.ToString() + "','"
+ dgv_siire.Rows[i].Cells[5].Value.ToString() + "','"
//+ "to_date('" + dgv_siire.Rows[i].Cells[5].Value.ToString() + "','YYYY/MM/DD HH24:MI:SS'),'"
//+ "to_date('" + dgv_siire.Rows[i].Cells[6].Value.ToString() + "','YYYY/MM/DD HH24:MI:SS'),'"
+ dgv_siire.Rows[i].Cells[7].Value.ToString() + "','"
+ tss.user_cd + "',SYSDATE)");
if (bl != true)
{
tss.ErrorLogWrite(tss.user_cd, "仕入登録", "登録ボタン押下時のOracleInsert");
MessageBox.Show("仕入処理でエラーが発生しました。" + Environment.NewLine + "処理を中止します。");
this.Close();
}
else
{
}
}
tb_create_user_cd.Text = tss.user_cd;
tb_create_datetime.Text = DateTime.Now.ToString();
MessageBox.Show("仕入登録しました。");
w_siire_no = tss.GetSeq("06");
dgv_siire.Rows.Clear();
tb_torihikisaki_cd.Clear();
tb_torihikisaki_name.Clear();
dtp_siire_date.Value = DateTime.Today;
tb_siire_denpyou_no.Clear();
tb_create_user_cd.Clear();
tb_create_datetime.Clear();
tb_update_user_cd.Clear();
tb_update_datetime.Clear();
tb_siire_no.Text = w_siire_no.ToString("0000000000");
return;
}
else
{
DialogResult result = MessageBox.Show("既存の仕入データを上書きしますか？",
"仕入データの上書き確認",
MessageBoxButtons.OKCancel,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button2);
if (result == DialogResult.OK)
{
//仕入マスタから削除してインサート
tss.OracleDelete("delete from tss_siire_m WHERE siire_no = '" + tb_siire_no.Text.ToString() + "'");
for (int i = 0; i < rc2 - 1; i++)
{
bool bl = tss.OracleInsert("insert into tss_siire_m (siire_no, seq,torihikisaki_cd, siire_date,buhin_cd,buhin_name,siire_su,siire_tanka,siire_kingaku,siire_denpyo_no,siire_simebi,bikou,create_user_cd,create_datetime,update_user_cd,update_datetime) values ('"
+ tb_siire_no.Text.ToString() + "','"
+ (i + 1) + "','"
+ tb_torihikisaki_cd.Text.ToString() + "','"
+ dtp_siire_date.Value.ToShortDateString() + "','"
+ dgv_siire.Rows[i].Cells[0].Value.ToString() + "','"
+ dgv_siire.Rows[i].Cells[1].Value.ToString() + "','"
+ dgv_siire.Rows[i].Cells[2].Value.ToString() + "','"
+ dgv_siire.Rows[i].Cells[3].Value.ToString() + "','"
+ dgv_siire.Rows[i].Cells[4].Value.ToString() + "','"
+ tb_siire_denpyou_no.Text.ToString() + "','"
+ dgv_siire.Rows[i].Cells[5].Value.ToString() + "','"
+ dgv_siire.Rows[i].Cells[7].Value.ToString() + "','"
+ tb_create_user_cd.Text.ToString() + "',"//←カンマがあると、日付をインサートする際にエラーになるので注意する
+ "to_date('" + tb_create_datetime.Text.ToString() + "','YYYY/MM/DD HH24:MI:SS'),'"
+ tss.user_cd + "',SYSDATE)");
if (bl != true)
{
tss.ErrorLogWrite(tss.user_cd, "仕入登録", "登録ボタン押下時のOracleInsert");
MessageBox.Show("仕入処理でエラーが発生しました。" + Environment.NewLine + "処理を中止します。");
this.Close();
}
else
{
}
}
tb_update_user_cd.Text = tss.user_cd.ToString();
tb_update_datetime.Text = DateTime.Now.ToString();
MessageBox.Show("仕入登録しました。");
w_siire_no = tss.GetSeq("06");
dgv_siire.Rows.Clear();
tb_torihikisaki_cd.Clear();
tb_torihikisaki_name.Clear();
dtp_siire_date.Value = DateTime.Today;
tb_siire_denpyou_no.Clear();
tb_create_user_cd.Clear();
tb_create_datetime.Clear();
tb_update_user_cd.Clear();
tb_update_datetime.Clear();
tb_siire_no.Text = w_siire_no.ToString("0000000000");
return;
}
//「いいえ」が選択された時
else if (result == DialogResult.Cancel)
{
return;
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (cb_year.Text.ToString() == "")
{
MessageBox.Show("年を指定してください");
return;
}
if (cb_month.Text.ToString() == "")
{
MessageBox.Show("月を指定してください");
return;
}
string taisyounengetu = cb_year.Text + "/" + cb_month.Text;
DataTable dt_work = new DataTable();
dt_work = tss.OracleSelect("select BUHIN_CD from tss_buhin_m");
dt_work.Columns.Add("FREE_ZAIKO_SU", Type.GetType("System.Decimal"));
dt_work.Columns.Add("LOT_ZAIKO_SU", Type.GetType("System.Decimal"));
dt_work.Columns.Add("SONOTA_ZAIKO_SU", Type.GetType("System.Decimal"));
dt_work.Columns.Add("TOTAL_ZAIKO_SU", Type.GetType("System.Decimal"));
dt_work.Columns.Add("TAISYOU_NENGETU", Type.GetType("System.String"));
//dt_work.Columns.Add("CREATE_USER_CD", Type.GetType("System.String"));
//dt_work.Columns.Add("CREATE_DATETIME", Type.GetType("System.DateTime"));
//dt_work.Columns.Add("UPDATE_USER_CD", Type.GetType("System.String"));
//dt_work.Columns.Add("UPDATE_DATETIME", Type.GetType("System.DateTime"));
int rc = dt_work.Rows.Count;
decimal freezaikosu = new decimal();
decimal lotzaikosu = new decimal();
decimal sonotazaikosu = new decimal();
decimal totalzaikosu = new decimal();
for (int i = 0; i < rc; i++)
{
//在庫マスタから在庫数を調べる
string buhin_cd = dt_work.Rows[i][0].ToString();
DataTable freezaiko = new DataTable();
freezaiko = tss.OracleSelect("select zaiko_su from tss_buhin_zaiko_m where buhin_cd = '" + buhin_cd.ToString() + "' and zaiko_kbn = '01'");
if (freezaiko.Rows.Count == 0)
{
dt_work.Rows[i][1] = "0";
freezaikosu = 0;
}
else
{
freezaikosu = decimal.Parse(freezaiko.Rows[0][0].ToString());
dt_work.Rows[i][1] = freezaikosu;
}
DataTable lotzaiko = new DataTable();
lotzaiko = tss.OracleSelect("select zaiko_su from tss_buhin_zaiko_m where buhin_cd = '" + buhin_cd.ToString() + "' and zaiko_kbn = '02'");
if (lotzaiko.Rows.Count == 0)
{
dt_work.Rows[i][2] = "0";
lotzaikosu = 0;
}
else
{
object obj = lotzaiko.Compute("Sum(zaiko_su)", null);
lotzaikosu = decimal.Parse(obj.ToString());
dt_work.Rows[i][2] = lotzaikosu;
}
DataTable sonotazaiko = new DataTable();
sonotazaiko = tss.OracleSelect("select zaiko_su from tss_buhin_zaiko_m where buhin_cd = '" + buhin_cd.ToString() + "' and zaiko_kbn = '03'");
if (sonotazaiko.Rows.Count == 0)
{
dt_work.Rows[i][3] = "0";
sonotazaikosu = 0;
}
else
{
object obj = sonotazaiko.Compute("Sum(zaiko_su)", null);
sonotazaikosu = decimal.Parse(obj.ToString());
dt_work.Rows[i][3] = sonotazaikosu;
}
totalzaikosu = freezaikosu + lotzaikosu + sonotazaikosu;
dt_work.Rows[i][4] = totalzaikosu;
//対象月
dt_work.Rows[i][5] = taisyounengetu;
}
//月末在庫マスタに書き込み
//同じ対象月のものがあれば、削除する
DataTable dt_w = new DataTable();
dt_w = tss.OracleSelect("Select * from tss_getumatu_zaiko_m where taisyou_nengetu = '" + taisyounengetu.ToString() + "'");
if (dt_w.Rows.Count != 0)
{
DialogResult result = MessageBox.Show("在庫データを上書きしますか？",
"買掛データの上書き確認",
MessageBoxButtons.OKCancel,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button2);
if (result == DialogResult.OK)
{
tss.OracleDelete("Delete from tss_getumatu_zaiko_m where taisyou_nengetu = '" + taisyounengetu.ToString() + "'");
tss.GetUser();
for (int i = 0; i < rc; i++)
{
bool bl = tss.OracleInsert("insert into tss_getumatu_zaiko_m (buhin_cd,free_zaiko_su,lot_zaiko_su,sonota_zaiko_su,total_zaiko_su,taisyou_nengetu,create_user_cd,create_datetime) values ('"
+ dt_work.Rows[i][0].ToString() + "','"
+ dt_work.Rows[i][1].ToString() + "','"
+ dt_work.Rows[i][2].ToString() + "','"
+ dt_work.Rows[i][3].ToString() + "','"
+ dt_work.Rows[i][4].ToString() + "','"
+ dt_work.Rows[i][5].ToString() + "','"
+ tss.user_cd + "',SYSDATE)");
if (bl != true)
{
tss.ErrorLogWrite(tss.user_cd, "月末在庫登録処理", "登録ボタン押下時のOracleInsert");
MessageBox.Show("月末在庫登録処理でエラーが発生しました。" + Environment.NewLine + "処理を中止します。");
this.Close();
}
else
{
}
}
MessageBox.Show("月末在庫登録処理が完了しました。");
}
}
else
{
tss.GetUser();
for (int i = 0; i < rc; i++)
{
bool bl = tss.OracleInsert("insert into tss_getumatu_zaiko_m (buhin_cd,free_zaiko_su,lot_zaiko_su,sonota_zaiko_su,total_zaiko_su,taisyou_nengetu,create_user_cd,create_datetime) values ('"
+ dt_work.Rows[i][0].ToString() + "','"
+ dt_work.Rows[i][1].ToString() + "','"
+ dt_work.Rows[i][2].ToString() + "','"
+ dt_work.Rows[i][3].ToString() + "','"
+ dt_work.Rows[i][4].ToString() + "','"
+ dt_work.Rows[i][5].ToString() + "','"
+ tss.user_cd + "',SYSDATE)");
if (bl != true)
{
tss.ErrorLogWrite(tss.user_cd, "月末在庫登録処理", "登録ボタン押下時のOracleInsert");
MessageBox.Show("月末在庫登録処理でエラーが発生しました。" + Environment.NewLine + "処理を中止します。");
this.Close();
}
else
{
}
}
MessageBox.Show("月末在庫登録処理が完了しました。");
}
//tss.OracleInsert("Delete from tss_getumatu_zaiko_m where taisyou_nengetu = '" + taisyounengetu.ToString() + "'");
MessageBox.Show("完了");
}
private void btn_touroku_Click(object sender, EventArgs e)
{
//入力項目のチェック
if (chk_seihin_kousei_name() == false)
{
MessageBox.Show("製品構成名称が正しく入力されていません。");
tb_seihin_kousei_name.Focus();
return;
}
//データグリッドビューの中を1行ずつループしてチェック
int dgvrc = dgv_seihin_kousei.Rows.Count;
if (dgvrc == 1)
{
MessageBox.Show("表の中に何も入力されていません");
return;
}
tss.GetUser(); //ユーザー情報の取得
//テキストボックスとデータグリッドビューの入力内容チェック
for (int i = 0; i < dgvrc - 1; i++)
{
if (dgv_seihin_kousei.Rows[i].Cells[0].Value == null || dgv_seihin_kousei.Rows[i].Cells[0].Value.ToString() == "" || int.Parse(dgv_seihin_kousei.Rows[i].Cells[0].Value.ToString()) <= 0 || tss.StringByte(dgv_seihin_kousei.Rows[i].Cells[0].Value.ToString()) > 1)
{
MessageBox.Show("部品レベルの値が異常です。（1～9の範囲で入力）");
dgv_seihin_kousei.Focus();
dgv_seihin_kousei.CurrentCell = dgv_seihin_kousei[0, i];
return;
}
if (dgv_seihin_kousei.Rows[i].Cells[1].Value == null || dgv_seihin_kousei.Rows[i].Cells[1].Value.ToString() == "" || tss.StringByte(dgv_seihin_kousei.Rows[i].Cells[1].Value.ToString()) > 16)
{
MessageBox.Show("部品コードの値が異常です。（1バイト以上、16バイト以内の文字で入力）");
dgv_seihin_kousei.Focus();
dgv_seihin_kousei.CurrentCell = dgv_seihin_kousei[1, i];
return;
}
if (dgv_seihin_kousei.Rows[i].Cells[2].Value == null || dgv_seihin_kousei.Rows[i].Cells[2].Value.ToString() == "" || tss.StringByte(dgv_seihin_kousei.Rows[i].Cells[2].Value.ToString()) > 40)
{
MessageBox.Show("部品名の値が異常です。（1バイト以上、40バイト以内の文字で入力）");
dgv_seihin_kousei.Focus();
dgv_seihin_kousei.CurrentCell = dgv_seihin_kousei[2, i];
return;
}
if (dgv_seihin_kousei.Rows[i].Cells[3].Value == null || dgv_seihin_kousei.Rows[i].Cells[3].Value.ToString() == "" || double.Parse(dgv_seihin_kousei.Rows[i].Cells[3].Value.ToString()) > 9999999999.99 || double.Parse(dgv_seihin_kousei.Rows[i].Cells[3].Value.ToString()) < -9999999999.99 || tss.StringByte(dgv_seihin_kousei.Rows[i].Cells[3].Value.ToString()) > 16)
{
MessageBox.Show("使用数量の値が異常です。（10桁以内。小数点以下2桁以内で入力）");
dgv_seihin_kousei.Focus();
dgv_seihin_kousei.CurrentCell = dgv_seihin_kousei[3, i];
return;
}
if (tss.StringByte(dgv_seihin_kousei.Rows[i].Cells[4].Value.ToString()) > 16)
{
MessageBox.Show("互換部品コードの値が異常です。（1バイト以上、16バイト以内の文字で入力）");
dgv_seihin_kousei.Focus();
dgv_seihin_kousei.CurrentCell = dgv_seihin_kousei[4, i];
return;
}
//互換部品コードが入力されているのに、互換部品名がない場合
if (dgv_seihin_kousei.Rows[i].Cells[4].Value.ToString() != "" && dgv_seihin_kousei.Rows[i].Cells[5].Value.ToString() == "")
{
MessageBox.Show("互換部品名の値が異常です。（1バイト以上、40バイト以内の文字で入力）");
dgv_seihin_kousei.Focus();
dgv_seihin_kousei.CurrentCell = dgv_seihin_kousei[5, i];
return;
}
//互換部品コードが入力されていないのに、互換部品名がある場合
if (dgv_seihin_kousei.Rows[i].Cells[4].Value.ToString() == "" && dgv_seihin_kousei.Rows[i].Cells[5].Value.ToString() != "")
{
MessageBox.Show("互換部品コードの値が異常です。（1バイト以上、16バイト以内の文字で入力）");
dgv_seihin_kousei.Focus();
dgv_seihin_kousei.CurrentCell = dgv_seihin_kousei[4, i];
return;
}
}
tss.GetUser();
int rc = dgv_seihin_kousei.Rows.Count;
DataTable dt_work = new DataTable();
dt_work = tss.OracleSelect("select * from TSS_SEIHIN_KOUSEI_M WHERE seihin_cd = '" + tb_seihin_cd.Text.ToString() + "' and seihin_kousei_no = '" + tb_seihin_kousei_no.Text.ToString() + "'");
//新規の製品構成を登録する
if (dt_work.Rows.Count == 0)
{
// dt_work.Rows.Clear();
for (int i = 0; i < rc - 1; i++)
{
dt_work.Rows.Add();
dt_work.Rows[i][0] = tb_seihin_cd.Text.ToString();
dt_work.Rows[i][1] = tb_seihin_kousei_no.Text.ToString();
dt_work.Rows[i][2] = i + 1; //SEQ
dt_work.Rows[i][3] = dgv_seihin_kousei.Rows[i].Cells[0].Value.ToString(); //部品レベル
dt_work.Rows[i][4] = dgv_seihin_kousei.Rows[i].Cells[1].Value.ToString(); //部品コード
if (dgv_seihin_kousei.Rows[i].Cells[0].Value.ToString() == "1")
{
dt_work.Rows[i][5] = 999; //親行番号
dt_work.Rows[i][6] = ""; //親部品コード
}
if (int.Parse(dgv_seihin_kousei.Rows[i].Cells[0].Value.ToString()) > 1)
{
for (int j = 1; j < rc - 1; j++)
{
int a = int.Parse(dgv_seihin_kousei.Rows[i].Cells[0].Value.ToString()) - int.Parse(dgv_seihin_kousei.Rows[i - j].Cells[0].Value.ToString());
if (a == 0)
{
dt_work.Rows[i][5] = dt_work.Rows[i - 1][5]; //親行番号
dt_work.Rows[i][6] = dt_work.Rows[i - 1][6]; //親部品コード
break;
}
if (a == 1)
{
dt_work.Rows[i][5] = dt_work.Rows[i - 1][2]; //親行番号
dt_work.Rows[i][6] = dt_work.Rows[i - 1][4]; //親部品コード
break;
}
}
}
dt_work.Rows[i][7] = dgv_seihin_kousei.Rows[i].Cells[3].Value.ToString(); //使用数
dt_work.Rows[i][8] = dgv_seihin_kousei.Rows[i].Cells[4].Value.ToString(); //互換部品コード
dt_work.Rows[i][9] = dgv_seihin_kousei.Rows[i].Cells[6].Value.ToString(); //備考
if (dt_work.Rows[i][10].ToString() == "")
{
dt_work.Rows[i][10] = tss.user_cd;//クリエイトユーザーコード
}
if (dt_work.Rows[i][11].ToString() == "")
{
dt_work.Rows[i][11] = DateTime.Now;//クリエイトデートタイム
}
}
tss.OracleDelete("delete from TSS_SEIHIN_KOUSEI_M WHERE seihin_cd = '" + tb_seihin_cd.Text.ToString() + "' and seihin_kousei_no = '" + tb_seihin_kousei_no.Text.ToString() + "'");
for (int i = 0; i < rc - 1; i++)
{
tss.OracleInsert("INSERT INTO tss_seihin_kousei_m (seihin_cd,seihin_kousei_no,seq,buhin_level,buhin_cd,oya_seq,oya_buhin_cd,siyou_su,gokan_buhin_cd,bikou,create_user_cd,create_datetime)"
+ " VALUES ('"
+ dt_work.Rows[i][0].ToString() + "','"
+ dt_work.Rows[i][1].ToString() + "','"
+ dt_work.Rows[i][2].ToString() + "','"
+ dt_work.Rows[i][3].ToString() + "','"
+ dt_work.Rows[i][4].ToString() + "','"
+ dt_work.Rows[i][5].ToString() + "','"
+ dt_work.Rows[i][6].ToString() + "','"
+ dt_work.Rows[i][7].ToString() + "','"
+ dt_work.Rows[i][8].ToString() + "','"
+ dt_work.Rows[i][9].ToString() + "','"
+ dt_work.Rows[i][10].ToString() + "',SYSDATE)");
}
tb_create_user_cd.Text = dt_work.Rows[0][10].ToString();
tb_create_datetime.Text = DateTime.Now.ToString();
MessageBox.Show("製品構成マスタに登録しました");
//製品構成名称マスタの更新
DataTable dt_work4 = new DataTable();
dt_work4 = tss.OracleSelect("select * from TSS_SEIHIN_KOUSEI_NAME_M WHERE seihin_cd = '" + tb_seihin_cd.Text.ToString() + "' and seihin_kousei_no = '" + tb_seihin_kousei_no.Text.ToString() + "'");
if (dt_work4.Rows.Count == 0)
{
tss.OracleInsert("INSERT INTO tss_seihin_kousei_name_m (seihin_cd,seihin_kousei_no,seihin_kousei_name,create_user_cd,create_datetime)"
+ " VALUES ('"
+ tb_seihin_cd.Text.ToString() + "','"
+ tb_seihin_kousei_no.Text.ToString() + "','"
+ tb_seihin_kousei_name.Text.ToString() + "','"
+ tss.user_cd + "',SYSDATE)");
}
else
{
tss.OracleUpdate("UPDATE TSS_seihin_kousei_name_m SET seihin_cd = '"
+ tb_seihin_cd.Text.ToString() + "',seihin_kousei_name = '" + tb_seihin_kousei_name.Text.ToString()
+ "',UPDATE_USER_CD = '" + tss.user_cd + "',UPDATE_DATETIME = SYSDATE WHERE seihin_cd = '" + tb_seihin_cd.Text.ToString() + "'and seihin_kousei_no = '" + tb_seihin_kousei_no.Text.ToString() + "'");
}
MessageBox.Show("製品構成名称マスタに登録しました");
seihin_kousei_name_disp(tb_seihin_cd.Text);
}
else
{
//既にある製品構成を更新する処理
//dt_work.Rows.Clear();
//dt_work2 = this.dgv_seihin_kousei.DataSource();
DataTable dtTmp = (DataTable)this.dgv_seihin_kousei.DataSource;
dtTmp.AcceptChanges();
int rc2 = dtTmp.Rows.Count;
dt_work.Rows.Clear();
for (int i = 0; i < rc2; i++)
{
dt_work.Rows.Add();
dt_work.Rows[i][0] = tb_seihin_cd.Text.ToString();
dt_work.Rows[i][1] = tb_seihin_kousei_no.Text.ToString();
dt_work.Rows[i][2] = i + 1; //SEQ
dt_work.Rows[i][3] = dtTmp.Rows[i][0].ToString(); //部品レベル
dt_work.Rows[i][4] = dtTmp.Rows[i][1].ToString(); //部品コード
if (dtTmp.Rows[i][0].ToString() == "1")
{
dt_work.Rows[i][5] = 999; //親行番号
dt_work.Rows[i][6] = ""; //親部品コード
}
if (int.Parse(dtTmp.Rows[i][0].ToString()) > 1)
{
for (int j = 1; j < rc2 - 1; j++)
{
int a = int.Parse(dtTmp.Rows[i][0].ToString()) - int.Parse(dtTmp.Rows[i - j][0].ToString());
if (a == 0)
{
dt_work.Rows[i][5] = dt_work.Rows[i - 1][5]; //親行番号
dt_work.Rows[i][6] = dt_work.Rows[i - 1][6]; //親部品コード
break;
}
if (a == 1)
{
dt_work.Rows[i][5] = dt_work.Rows[i - 1][2]; //親行番号
dt_work.Rows[i][6] = dt_work.Rows[i - 1][4]; //親部品コード
break;
}
}
}
dt_work.Rows[i][7] = dtTmp.Rows[i][3].ToString(); //使用数
dt_work.Rows[i][8] = dtTmp.Rows[i][4].ToString(); //互換部品コード
dt_work.Rows[i][9] = dtTmp.Rows[i][6].ToString(); //備考
if (dt_work.Rows[i][10].ToString() == "")
{
dt_work.Rows[i][10] = tb_create_user_cd.Text;//クリエイトユーザーコード
}
if (dt_work.Rows[i][11].ToString() == "")
{
dt_work.Rows[i][11] = tb_create_datetime.Text;//クリエイトデートタイム
}
}
tss.OracleDelete("delete from TSS_SEIHIN_KOUSEI_M WHERE seihin_cd = '" + tb_seihin_cd.Text.ToString() + "' and seihin_kousei_no = '" + tb_seihin_kousei_no.Text.ToString() + "'");
for (int i = 0; i < rc - 1; i++)
{
tss.OracleInsert("INSERT INTO tss_seihin_kousei_m (seihin_cd,seihin_kousei_no,seq,buhin_level,buhin_cd,oya_seq,oya_buhin_cd,siyou_su,gokan_buhin_cd,bikou,create_user_cd,create_datetime,update_user_cd,update_datetime)"
+ " VALUES ('"
+ dt_work.Rows[i][0].ToString() + "','"
+ dt_work.Rows[i][1].ToString() + "','"
+ dt_work.Rows[i][2].ToString() + "','"
+ dt_work.Rows[i][3].ToString() + "','"
+ dt_work.Rows[i][4].ToString() + "','"
+ dt_work.Rows[i][5].ToString() + "','"
+ dt_work.Rows[i][6].ToString() + "','"
+ dt_work.Rows[i][7].ToString() + "','"
+ dt_work.Rows[i][8].ToString() + "','"
+ dt_work.Rows[i][9].ToString() + "','"
+ dt_work.Rows[i][10].ToString() + "',"
+ "to_date('" + dt_work.Rows[i][11].ToString() + "','YYYY/MM/DD HH24:MI:SS'),'"
+ tss.user_cd + "',SYSDATE)");
}
MessageBox.Show("製品構成マスタに登録しました");
//製品構成名称マスタの更新
DataTable dt_work4 = new DataTable();
dt_work4 = tss.OracleSelect("select * from TSS_SEIHIN_KOUSEI_NAME_M WHERE seihin_cd = '" + tb_seihin_cd.Text.ToString() + "' and seihin_kousei_no = '" + tb_seihin_kousei_no.Text.ToString() + "'");
if (dt_work4.Rows.Count == 0)
{
tss.OracleInsert("INSERT INTO tss_seihin_kousei_name_m (seihin_cd,seihin_kousei_no,seihin_kousei_name,create_user_cd,create_datetime)"
+ " VALUES ('"
+ tb_seihin_cd.Text.ToString() + "','"
+ tb_seihin_kousei_no.Text.ToString() + "','"
+ tb_seihin_kousei_name.Text.ToString() + "','"
+ tss.user_cd + "',SYSDATE)");
}
else
{
tss.OracleUpdate("UPDATE TSS_seihin_kousei_name_m SET seihin_cd = '"
+ tb_seihin_cd.Text.ToString() + "',seihin_kousei_name = '" + tb_seihin_kousei_name.Text.ToString()
+ "',UPDATE_USER_CD = '" + tss.user_cd + "',UPDATE_DATETIME = SYSDATE WHERE seihin_cd = '" + tb_seihin_cd.Text.ToString() + "'and seihin_kousei_no = '" + tb_seihin_kousei_no.Text.ToString() + "'");
}
tb_update_user_cd.Text = tss.user_cd.ToString();
tb_update_datetime.Text = DateTime.Now.ToString();
MessageBox.Show("製品構成名称マスタに登録しました");
seihin_kousei_name_disp(tb_seihin_cd.Text);
}
}
private void button1_Click(object sender, EventArgs e)
{
dt_work = tss.OracleSelect("select DISTINCT buhin_cd from tss_buhin_zaiko_m order by buhin_cd");
int rc = dt_work.Rows.Count;
for (int i = 0; i < rc - 1; i++)
{
string buhin_cd = dt_work.Rows[i][0].ToString();
//string buhin_cd = "00005100468";
dt_free_zaiko = tss.OracleSelect("select * from tss_buhin_zaiko_m where buhin_cd = '" + buhin_cd + "' and zaiko_kbn = '01'");
int rc2 = dt_free_zaiko.Rows.Count;
if (rc2 > 0)
{
f_zaikosu = decimal.Parse(dt_free_zaiko.Rows[0][5].ToString());
t_zaikosu = f_zaikosu;
}
dt_lot_zaiko = tss.OracleSelect("select * from tss_buhin_zaiko_m where buhin_cd = '" + buhin_cd + "' and zaiko_kbn = '02'");
int rc3 = dt_lot_zaiko.Rows.Count;
if (rc3 > 0)
{
object obj = dt_lot_zaiko.Compute("Sum(zaiko_su)", null);
l_zaikosu = decimal.Parse(obj.ToString());
t_zaikosu = f_zaikosu + l_zaikosu;
//ロット在庫消す
//tss.OracleDelete("delete from tss_buhin_zaiko_m where buhin_cd = '" + buhin_cd + "' and zaiko_kbn = '02'");
}
dt_sonota_zaiko = tss.OracleSelect("select * from tss_buhin_zaiko_m where buhin_cd = '" + buhin_cd + "' and zaiko_kbn = '03'");
int rc4 = dt_sonota_zaiko.Rows.Count;
if (rc4 > 0)
{
object obj2 = dt_sonota_zaiko.Compute("Sum(zaiko_su)", null);
s_zaikosu = decimal.Parse(obj2.ToString());
t_zaikosu = t_zaikosu + s_zaikosu;
//その他在庫消す
//tss.OracleDelete("delete from tss_buhin_zaiko_m where buhin_cd = '" + buhin_cd + "' and zaiko_kbn = '03'");
}
//フリー在庫を t_zaikosu でアップデート
tss.OracleUpdate("UPDATE tss_buhin_zaiko_m SET zaiko_su = '" + t_zaikosu.ToString() + "',UPDATE_USER_CD = '" + tss.user_cd + "',UPDATE_DATETIME = SYSDATE WHERE buhin_cd = '" + buhin_cd + "' and zaiko_kbn = '01'");
}
MessageBox.Show("ロット在庫→フリー在庫への移動完了");
tss.OracleDelete("delete from tss_buhin_zaiko_m where zaiko_kbn = '02'");
MessageBox.Show("ロット在庫削除完了");
}
private void btn_touroku_Click(object sender, EventArgs e)
{
if (tss.User_Kengen_Check(4, 6) == false)
{
MessageBox.Show("権限がありません");
return;
}
DataTable dt_work = new DataTable();
//データグリッドビューの中を1行ずつループしてチェック
int dgvrc = dgv_m.Rows.Count;
if (dgvrc == 1)
{
MessageBox.Show("表の中に何も入力されていません");
return;
}
tss.GetUser(); //ユーザー情報の取得
//データグリッドビューの入力内容チェック
for (int i = 0; i < dgvrc - 1; i++)
{
if (dgv_m.Rows[i].Cells[0].Value == null || dgv_m.Rows[i].Cells[0].Value.ToString() == "")
{
MessageBox.Show("単価区分を入力してください");
dgv_m.Focus();
dgv_m.CurrentCell = dgv_m[0, i];
return;
}
if (dgv_m.Rows[i].Cells[2].Value == null || dgv_m.Rows[i].Cells[2].Value.ToString() == "")
{
MessageBox.Show("部門コードを入力してください");
return;
}
if (dgv_m.Rows[i].Cells[4].Value == null || dgv_m.Rows[i].Cells[4].Value.ToString() == "")
{
MessageBox.Show("単価を入力してください");
return;
}
//備考が空白の場合、""を代入 空欄だとnull扱いされ、SQエラー回避
if (dgv_m.Rows[i].Cells[5].Value == null)
{
dgv_m.Rows[i].Cells[5].Value = "";
}
}
//製品コードの重複チェック
dt_work = tss.OracleSelect("select * from tss_seihin_tanka_m where seihin_cd = '" + tb_seihin_cd.Text.ToString() + "'");
//重複がない（新規）の場合
if (dt_work.Rows.Count == 0)
{
//レコードの行数分ループしてインサート
int dgvrc2 = dgv_m.Rows.Count;
for (int i = 0; i < dgvrc2 - 1; i++)
{
bool bl = tss.OracleInsert("INSERT INTO tss_seihin_tanka_m (seihin_cd,tanka_kbn,bumon_cd,tanka,bikou,create_user_cd,create_datetime) VALUES ('"
+ tb_seihin_cd.Text.ToString() + "','"
+ dgv_m.Rows[i].Cells[0].Value.ToString() + "','"
+ dgv_m.Rows[i].Cells[2].Value.ToString() + "','"
//+ dgv_m.Rows[i].Cells[4].Value.ToString() + "','"
+ decimal.Parse(dgv_m.Rows[i].Cells[4].Value.ToString()) + "','"
+ dgv_m.Rows[i].Cells[5].Value.ToString() + "','"
+ tss.user_cd + "',SYSDATE)");
if (bl != true)
{
tss.ErrorLogWrite(tss.user_cd, "製品単価／登録", "登録ボタン押下時のOracleInsert");
MessageBox.Show("製品単価登録でエラーが発生しました。" + Environment.NewLine + "処理を中止します。");
this.Close();
}
}
tb_create_user_cd.Text = tss.user_cd;
tb_create_datetime.Text = DateTime.Now.ToString();
MessageBox.Show("製品単価登録が完了しました");
gamen_clear();
}
//重複がある（入金の修正処理）
if (dt_work.Rows.Count != 0)
{
tss.OracleDelete("delete from TSS_SEIHIN_TANKA_M WHERE seihin_cd = '" + tb_seihin_cd.Text.ToString() + "'");
int dgvrc2 = dgv_m.Rows.Count;
for (int i = 0; i < dgvrc2 - 1; i++)
{
bool bl = tss.OracleInsert("INSERT INTO tss_seihin_tanka_m (seihin_cd,tanka_kbn,bumon_cd,tanka,bikou,create_user_cd,create_datetime,update_user_cd,update_datetime) VALUES ('"
+ tb_seihin_cd.Text.ToString() + "','"
+ dgv_m.Rows[i].Cells[0].Value.ToString() + "','"
+ dgv_m.Rows[i].Cells[2].Value.ToString() + "','"
//+ dgv_m.Rows[i].Cells[4].Value.ToString() + "','"
+ decimal.Parse(dgv_m.Rows[i].Cells[4].Value.ToString()) + "','"
+ dgv_m.Rows[i].Cells[5].Value.ToString() + "','"
+ tb_create_user_cd.Text.ToString() + "',"
+ "to_date('" + tb_create_datetime.Text.ToString() + "','YYYY/MM/DD HH24:MI:SS'),'"
//+ tb_create_datetime.Text.ToString() + "','"
+ tss.user_cd + "',SYSDATE)");
if (bl != true)
{
tss.ErrorLogWrite(tss.user_cd, "製品単価／登録", "登録ボタン押下時のOracleInsert");
MessageBox.Show("製品単価登録でエラーが発生しました。" + Environment.NewLine + "処理を中止します。");
this.Close();
}
}
tb_update_user_cd.Text = tss.user_cd;
tb_update_datetime.Text = DateTime.Now.ToString();
MessageBox.Show("製品単価登録が完了しました");
gamen_clear();
}
}
private void btn_touroku_Click(object sender, EventArgs e)
{
if (tss.User_Kengen_Check(3, 5) == false)
{
MessageBox.Show("権限がありません");
return;
}
DataTable dt_work = new DataTable();
dt_work = tss.OracleSelect("select kadoubi from tss_kadoubi_m where uriage_yotei_nengetu = '" + tb_nengetu.Text.ToString() + "'");
int rc = dt_work.Rows.Count;
int rc2 = dgv_m.Rows.Count;
tss.GetUser();
if (rc == 0)
{
for (int i = 0; i < rc2 - 1; i++)
{
//売上予定が空白の場合、""を代入 空欄だとnull扱いされ、SQエラー回避
if (dgv_m.Rows[i].Cells[2].Value == null)
{
dgv_m.Rows[i].Cells[2].Value = "";
}
if (dgv_m.Rows[i].Cells[3].Value == null)
{
dgv_m.Rows[i].Cells[3].Value = "";
}
bool bl = tss.OracleInsert("insert into tss_uriage_yotei_m (uriage_yotei_nengetu,torihikisaki_cd,uriage_yotei_1,uriage_yotei_2,bikou,create_user_cd,create_datetime) values ('"
+ tb_nengetu.Text.ToString() + "','"
+ dgv_m.Rows[i].Cells[0].Value.ToString() + "','"
+ dgv_m.Rows[i].Cells[2].Value.ToString() + "','"
+ dgv_m.Rows[i].Cells[3].Value.ToString() + "','"
+ dgv_m.Rows[i].Cells[4].Value.ToString() + "','"
+ tss.user_cd + "',SYSDATE)");
if (bl != true)
{
tss.ErrorLogWrite(tss.user_cd, "売上予定登録", "登録ボタン押下時のOracleInsert");
MessageBox.Show("売上予定登録処理でエラーが発生しました。" + Environment.NewLine + "処理を中止します。");
this.Close();
}
else
{
}
}
tss.OracleInsert("insert into tss_kadoubi_m (uriage_yotei_nengetu,kadoubi,create_user_cd,create_datetime) values ('" + tb_nengetu.Text.ToString() + "','" + tb_kadou_su.Text.ToString() + "','" + tss.user_cd + "',SYSDATE)");
tb_create_user_cd.Text = tss.user_cd;
tb_create_datetime.Text = DateTime.Now.ToString();
MessageBox.Show("売上予定登録しました。");
return;
}
else
{
DialogResult result = MessageBox.Show("既存の売上予定データを上書きしますか？",
"売上予定データの上書き確認",
MessageBoxButtons.OKCancel,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button2);
if (result == DialogResult.OK)
{
//売上予定マスタから削除してインサート
tss.OracleDelete("delete from tss_uriage_yotei_m WHERE uriage_yotei_nengetu = '" + tb_nengetu.Text.ToString() + "'");
for (int i = 0; i < rc2 - 1; i++)
{
//売上予定が空白の場合、""を代入 空欄だとnull扱いされ、SQエラー回避
if (dgv_m.Rows[i].Cells[2].Value == null)
{
dgv_m.Rows[i].Cells[2].Value = "";
}
if (dgv_m.Rows[i].Cells[3].Value == null)
{
dgv_m.Rows[i].Cells[3].Value = "";
}
bool bl = tss.OracleInsert("insert into tss_uriage_yotei_m (uriage_yotei_nengetu,torihikisaki_cd,uriage_yotei_1,uriage_yotei_2,bikou,create_user_cd,create_datetime,update_user_cd,update_datetime) values ('"
+ tb_nengetu.Text.ToString() + "','"
+ dgv_m.Rows[i].Cells[0].Value.ToString() + "','"
+ dgv_m.Rows[i].Cells[2].Value.ToString() + "','"
+ dgv_m.Rows[i].Cells[3].Value.ToString() + "','"
+ dgv_m.Rows[i].Cells[4].Value.ToString() + "','"
+ tb_create_user_cd.Text.ToString() + "',"//←カンマがあると、日付をインサートする際にエラーになるので注意する
+ "to_date('" + tb_create_datetime.Text.ToString() + "','YYYY/MM/DD HH24:MI:SS'),'"
+ tss.user_cd + "',SYSDATE)");
if (bl != true)
{
tss.ErrorLogWrite(tss.user_cd, "売上予定登録", "登録ボタン押下時のOracleInsert");
MessageBox.Show("売上予定登録処理でエラーが発生しました。" + Environment.NewLine + "処理を中止します。");
this.Close();
}
else
{
}
}
tss.OracleDelete("delete from tss_kadoubi_m WHERE uriage_yotei_nengetu = '" + tb_nengetu.Text.ToString() + "'");
tss.OracleInsert("insert into tss_kadoubi_m (uriage_yotei_nengetu,kadoubi,create_user_cd,create_datetime) values ('" + tb_nengetu.Text.ToString() + "','" + tb_kadou_su.Text.ToString() + "','" + tss.user_cd + "',SYSDATE)");
tb_update_user_cd.Text = tss.user_cd.ToString();
tb_update_datetime.Text = DateTime.Now.ToString();
MessageBox.Show("売上予定登録しました。");
return;
}
//「いいえ」が選択された時
else if (result == DialogResult.Cancel)
{
return;
}
}
}
private void make_insatu_table()
{
DataTable w_dt_trn_count = new DataTable();
string w_sql;
//指示書の印刷データのテーブル書き込み
//トランファイルの存在を確認して、あったら削除
w_dt_trn_count = tss.OracleSelect("select * from user_tables where upper(table_name) = upper('" + w_trn_name + "')");
if (w_dt_trn_count.Rows.Count >= 1)
{
tss.OracleDelete("DROP TABLE " + w_trn_name + " CASCADE CONSTRAINTS purge");
}
w_sql = "create table " + w_trn_name + " ("
+ "seisan_yotei_date VARCHAR2(10) not null"
+ ",seq1 VARCHAR2(3)"
+ ",seq2 VARCHAR2(3)"
+ ",busyo_cd varchar2(4)"
+ ",busyo_name varchar2(20)"
+ ",koutei_cd varchar2(3)"
+ ",koutei_name varchar(40)"
+ ",line_cd varchar2(3)"
+ ",line_name varchar2(40)"
+ ",seq_no1 varchar2(3)"
+ ",seq_no2 varchar2(3)"
+ ",torihikisaki_cd varchar2(6)"
+ ",juchu_cd1 varchar2(16)"
+ ",juchu_cd2 varchar2(16)"
+ ",juchu_su number(12,2)"
+ ",torihikisaki_name varchar2(40)"
+ ",seihin_cd varchar2(16)"
+ ",seihin_name varchar2(40)"
+ ",seisankisyu varchar2(128)"
+ ",member01 varchar2(20)"
+ ",member02 varchar2(20)"
+ ",member03 varchar2(20)"
+ ",member04 varchar2(20)"
+ ",member05 varchar2(20)"
+ ",member06 varchar2(20)"
+ ",member07 varchar2(20)"
+ ",member08 varchar2(20)"
+ ",member09 varchar2(20)"
+ ",member10 varchar2(20)"
+ ",member11 varchar2(20)"
+ ",member12 varchar2(20)"
+ ",bikou varchar2(128)"
+ ",tact_time number(7,2)"
+ ",dandori_kousu number(7,2)"
+ ",tuika_kousu number(7,2)"
+ ",hoju_kousu number(7,2)"
+ ",seisan_sumi_su number(12,2)"
+ ",seisan_su number(12,2)"
+ ",seisan_time number(10,2)"
+ ",start_time varchar2(20)"
+ ",end_time varchar2(20)"
+ ",hinsitu_zenkai_name1 varchar2(40)"
+ ",hinsitu_zenkai_su1 number(12,2)"
+ ",hinsitu_zenkai_name2 varchar2(40)"
+ ",hinsitu_zenkai_su2 number(12,2)"
+ ",hinsitu_zenkai_name3 varchar2(40)"
+ ",hinsitu_zenkai_su3 number(12,2)"
+ ",hinsitu_zenkai_name4 varchar2(40)"
+ ",hinsitu_zenkai_su4 number(12,2)"
+ ",hinsitu_zenkai_name5 varchar2(40)"
+ ",hinsitu_zenkai_su5 number(12,2)"
+ ",hinsitu_zenkai_name6 varchar2(40)"
+ ",hinsitu_zenkai_su6 number(12,2)"
+ ",hinsitu_kako_name1 varchar2(40)"
+ ",hinsitu_kako_su1 number(12,2)"
+ ",hinsitu_kako_name2 varchar2(40)"
+ ",hinsitu_kako_su2 number(12,2)"
+ ",hinsitu_kako_name3 varchar2(40)"
+ ",hinsitu_kako_su3 number(12,2)"
+ ",hinsitu_kako_name4 varchar2(40)"
+ ",hinsitu_kako_su4 number(12,2)"
+ ",hinsitu_kako_name5 varchar2(40)"
+ ",hinsitu_kako_su5 number(12,2)"
+ ",hinsitu_kako_name6 varchar2(40)"
+ ",hinsitu_kako_su6 number(12,2)"
+ ",barcode varchar2(64)"
+ ",constraint " + w_trn_name + "_pkc primary key (seisan_yotei_date,busyo_cd,koutei_cd,line_cd,seq1)"
+ ")";
tss.OracleSelect(w_sql);
//トランファイルへ書き込み
string w_sql2;
foreach (DataRow w_dr in w_dt_meisai.Rows)
{
w_sql2 = "insert into " + w_trn_name + " ("
+ "seisan_yotei_date"
+ ",seq1"
+ ",seq2"
+ ",busyo_cd"
+ ",busyo_name"
+ ",koutei_cd"
+ ",koutei_name"
+ ",line_cd"
+ ",line_name"
+ ",seq_no1"
+ ",seq_no2"
+ ",torihikisaki_cd"
+ ",juchu_cd1"
+ ",juchu_cd2"
+ ",juchu_su"
+ ",torihikisaki_name"
+ ",seihin_cd"
+ ",seihin_name"
+ ",seisankisyu"
+ ",member01"
+ ",member02"
+ ",member03"
+ ",member04"
+ ",member05"
+ ",member06"
+ ",member07"
+ ",member08"
+ ",member09"
+ ",member10"
+ ",member11"
+ ",member12"
+ ",bikou"
+ ",tact_time"
+ ",dandori_kousu"
+ ",tuika_kousu"
+ ",hoju_kousu"
+ ",seisan_sumi_su"
+ ",seisan_su"
+ ",seisan_time"
+ ",start_time"
+ ",end_time"
+ ",hinsitu_zenkai_name1"
+ ",hinsitu_zenkai_su1"
+ ",hinsitu_zenkai_name2"
+ ",hinsitu_zenkai_su2"
+ ",hinsitu_zenkai_name3"
+ ",hinsitu_zenkai_su3"
+ ",hinsitu_zenkai_name4"
+ ",hinsitu_zenkai_su4"
+ ",hinsitu_zenkai_name5"
+ ",hinsitu_zenkai_su5"
+ ",hinsitu_zenkai_name6"
+ ",hinsitu_zenkai_su6"
+ ",hinsitu_kako_name1"
+ ",hinsitu_kako_su1"
+ ",hinsitu_kako_name2"
+ ",hinsitu_kako_su2"
+ ",hinsitu_kako_name3"
+ ",hinsitu_kako_su3"
+ ",hinsitu_kako_name4"
+ ",hinsitu_kako_su4"
+ ",hinsitu_kako_name5"
+ ",hinsitu_kako_su5"
+ ",hinsitu_kako_name6"
+ ",hinsitu_kako_su6"
+ ",barcode"
+ ") values ("
+ "'" + w_dr["seisan_yotei_date"].ToString() + "',"
+ "'" + w_dr["seq1"].ToString() + "',"
+ "'" + w_dr["seq2"].ToString() + "',"
+ "'" + w_dr["busyo_cd"].ToString() + "',"
+ "'" + w_dr["busyo_name"].ToString() + "',"
+ "'" + w_dr["koutei_cd"].ToString() + "',"
+ "'" + w_dr["koutei_name"].ToString() + "',"
+ "'" + w_dr["line_cd"].ToString() + "',"
+ "'" + w_dr["line_name"].ToString() + "',"
+ "'" + w_dr["seq_no1"].ToString() + "',"
+ "'" + w_dr["seq_no2"].ToString() + "',"
+ "'" + w_dr["torihikisaki_cd"].ToString() + "',"
+ "'" + w_dr["juchu_cd1"].ToString() + "',"
+ "'" + w_dr["juchu_cd2"].ToString() + "',"
+ "'" + w_dr["juchu_su"].ToString() + "',"
+ "'" + w_dr["torihikisaki_name"].ToString() + "',"
+ "'" + w_dr["seihin_cd"].ToString() + "',"
+ "'" + w_dr["seihin_name"].ToString() + "',"
+ "'" + w_dr["seisankisyu"].ToString() + "',"
+ "'" + w_dr["member01"].ToString() + "',"
+ "'" + w_dr["member02"].ToString() + "',"
+ "'" + w_dr["member03"].ToString() + "',"
+ "'" + w_dr["member04"].ToString() + "',"
+ "'" + w_dr["member05"].ToString() + "',"
+ "'" + w_dr["member06"].ToString() + "',"
+ "'" + w_dr["member07"].ToString() + "',"
+ "'" + w_dr["member08"].ToString() + "',"
+ "'" + w_dr["member09"].ToString() + "',"
+ "'" + w_dr["member10"].ToString() + "',"
+ "'" + w_dr["member11"].ToString() + "',"
+ "'" + w_dr["member12"].ToString() + "',"
+ "'" + w_dr["bikou"].ToString() + "',"
+ "'" + w_dr["tact_time"].ToString() + "',"
+ "'" + w_dr["dandori_kousu"].ToString() + "',"
+ "'" + w_dr["tuika_kousu"].ToString() + "',"
+ "'" + w_dr["hoju_kousu"].ToString() + "',"
+ "'" + w_dr["seisan_sumi_su"].ToString() + "',"
+ "'" + w_dr["seisan_su"].ToString() + "',"
+ "'" + w_dr["seisan_time"].ToString() + "',"
+ "'" + w_dr["start_time"].ToString() + "',"
+ "'" + w_dr["end_time"].ToString() + "',"
+ "'" + w_dr["hinsitu_zenkai_name1"].ToString() + "',"
+ "'" + w_dr["hinsitu_zenkai_su1"].ToString() + "',"
+ "'" + w_dr["hinsitu_zenkai_name2"].ToString() + "',"
+ "'" + w_dr["hinsitu_zenkai_su2"].ToString() + "',"
+ "'" + w_dr["hinsitu_zenkai_name3"].ToString() + "',"
+ "'" + w_dr["hinsitu_zenkai_su3"].ToString() + "',"
+ "'" + w_dr["hinsitu_zenkai_name4"].ToString() + "',"
+ "'" + w_dr["hinsitu_zenkai_su4"].ToString() + "',"
+ "'" + w_dr["hinsitu_zenkai_name5"].ToString() + "',"
+ "'" + w_dr["hinsitu_zenkai_su5"].ToString() + "',"
+ "'" + w_dr["hinsitu_zenkai_name6"].ToString() + "',"
+ "'" + w_dr["hinsitu_zenkai_su6"].ToString() + "',"
+ "'" + w_dr["hinsitu_kako_name1"].ToString() + "',"
+ "'" + w_dr["hinsitu_kako_su1"].ToString() + "',"
+ "'" + w_dr["hinsitu_kako_name2"].ToString() + "',"
+ "'" + w_dr["hinsitu_kako_su2"].ToString() + "',"
+ "'" + w_dr["hinsitu_kako_name3"].ToString() + "',"
+ "'" + w_dr["hinsitu_kako_su3"].ToString() + "',"
+ "'" + w_dr["hinsitu_kako_name4"].ToString() + "',"
+ "'" + w_dr["hinsitu_kako_su4"].ToString() + "',"
+ "'" + w_dr["hinsitu_kako_name5"].ToString() + "',"
+ "'" + w_dr["hinsitu_kako_su5"].ToString() + "',"
+ "'" + w_dr["hinsitu_kako_name6"].ToString() + "',"
+ "'" + w_dr["hinsitu_kako_su6"].ToString() + "',"
+ "'" + w_dr["barcode"].ToString() + "'"
+ ")";
tss.OracleInsert(w_sql2);
}
}
private void siharai_kousin() //支払マスタの更新
{
tss.GetUser();
DataTable dt_work = new DataTable();
dt_work = tss.OracleSelect("select * from tss_siharai_m where siharai_no = '" + tb_siharai_no.Text + "'");
int rc = dt_work.Rows.Count;
int rc2 = dgv_siharai.Rows.Count;
decimal siharai = decimal.Parse(tb_siharai_goukei.Text.ToString());
//decimal sisan = decimal.Parse(w_mibarai) - siharai;
//支払マスタにレコードがない場合
if (rc == 0)
{
bool bl = new bool();
for (int i = 0; i < rc2; i++)
{
bl = tss.OracleInsert("insert into tss_siharai_m (siharai_no,seq,torihikisaki_cd,siire_simebi,siharai_kbn,siharai_date,siharaigaku,tesuryou,sousai,kokyaku_seikyu_no,bikou,create_user_cd,create_datetime) values ('"
+ tb_siharai_no.Text.ToString() + "','"
+ (i + 1) + "','"
+ tb_torihikisaki_cd.Text.ToString() + "',"
+ "to_date('" + dgv_siharai.Rows[i].Cells[0].Value.ToString() + "','YYYY/MM/DD HH24:MI:SS'),'"
+ dgv_siharai.Rows[i].Cells[2].Value.ToString() + "',"
+ "to_date('" + tb_siharai_date.Text.ToString() + "','YYYY/MM/DD HH24:MI:SS'),'"
+ dgv_siharai.Rows[i].Cells[3].Value.ToString() + "','"
+ dgv_siharai.Rows[i].Cells[4].Value.ToString() + "','"
+ dgv_siharai.Rows[i].Cells[5].Value.ToString() + "','"
+ dgv_siharai.Rows[i].Cells[1].Value.ToString() + "','"
+ dgv_siharai.Rows[i].Cells[7].Value.ToString() + "','"
+ tss.user_cd + "',SYSDATE)");
}
if (bl != true)
{
tss.ErrorLogWrite(tss.user_cd, "支払処理", "登録ボタン押下時のOracleInsert");
MessageBox.Show("支払処理でエラーが発生しました。" + Environment.NewLine + "処理を中止します。");
this.Close();
}
else
{
tb_create_user_cd.Text = tss.user_cd;
tb_create_datetime.Text = DateTime.Now.ToString();
MessageBox.Show("支払処理登録しました。");
}
//買掛マスタ更新メソッド実行
kaikake_kousin();
//仕入マスタ更新メソッド実行
siire_kousin();
}
//支払マスタに同じ支払ナンバーのレコードが存在している場合
else
{
string str_create_user_cd = tb_create_user_cd.Text.ToString();
string dstr_create_datetime = tb_create_datetime.Text.ToString();
//支払マスタから削除してインサート
tss.OracleDelete("delete from tss_siharai_m where siharai_no = '" + tb_siharai_no.Text.ToString() + "'");
bool bl = new bool();
for (int i = 0; i < rc2; i++)
{
bl = tss.OracleInsert("insert into tss_siharai_m (siharai_no,seq,torihikisaki_cd,siire_simebi,siharai_kbn,siharai_date,siharaigaku,tesuryou,sousai,kokyaku_seikyu_no,bikou,create_user_cd,create_datetime,update_user_cd,update_datetime) values ('"
+ tb_siharai_no.Text.ToString() + "','"
+ (i + 1) + "','"
+ tb_torihikisaki_cd.Text.ToString() + "',"
+ "to_date('" + dgv_siharai.Rows[i].Cells[0].Value.ToString() + "','YYYY/MM/DD HH24:MI:SS'),'"
+ dgv_siharai.Rows[i].Cells[2].Value.ToString() + "',"
+ "to_date('" + tb_siharai_date.Text.ToString() + "','YYYY/MM/DD HH24:MI:SS'),'"
+ dgv_siharai.Rows[i].Cells[3].Value.ToString() + "','"
+ dgv_siharai.Rows[i].Cells[4].Value.ToString() + "','"
+ dgv_siharai.Rows[i].Cells[5].Value.ToString() + "','"
+ dgv_siharai.Rows[i].Cells[1].Value.ToString() + "','"
+ dgv_siharai.Rows[i].Cells[7].Value.ToString() + "','"
+ str_create_user_cd + "', " + "to_date('" + dgv_siharai.Rows[i].Cells[0].Value.ToString() + "','YYYY/MM/DD HH24:MI:SS'),'"
+ tss.user_cd + "',SYSDATE)");
}
if (bl != true)
{
tss.ErrorLogWrite(tss.user_cd, "支払処理", "登録ボタン押下時のOracleInsert");
MessageBox.Show("支払処理でエラーが発生しました。" + Environment.NewLine + "処理を中止します。");
this.Close();
}
else
{
tb_update_user_cd.Text = tss.user_cd;
tb_update_datetime.Text = DateTime.Now.ToString();
MessageBox.Show("支払処理登録しました。");
}
//買掛マスタ更新メソッド実行
kaikake_kousin();
}
dgv_mibarai_disp();
//テキストボックスを空にする
//tb_torihikisaki_cd.Text = "";
//tb_torihikisaki_name.Text = "";
tb_siharai_date.Text = "";
tb_create_user_cd.Text = "";
tb_create_datetime.Text = "";
tb_update_user_cd.Text = "";
tb_update_datetime.Text = "";
tb_siharai_goukei.Text = "";
tb_kurikosi_zandaka.Text = "";
tb_siharai_no.Enabled = false;
tb_siharai_date.Enabled = false;
w_siharai_no = tss.GetSeq("07");
tb_siharai_no.Text = w_siharai_no.ToString("0000000000");
//データグリッドビューを空にする
DataTable dt_work2 = new DataTable();
dgv_siharai.DataSource = dt_work2;
}
private void btn_touroku_Click(object sender, EventArgs e)
{
string w_sql;
//勤怠区分、勤怠開始時刻、終了時刻の未入力チェック
foreach (DataRow dr in w_dt_kintai.Rows)
{
if (dr["kintai_kbn"].ToString() == null || dr["kintai_kbn"].ToString() == "")
{
MessageBox.Show("勤怠区分が入力されていないデータがあります。");
return;
}
else
{
if (tss.try_string_to_date(dr["kintai_date1"].ToString()) == false)
{
MessageBox.Show("勤怠開始日に異常があります。");
return;
}
else
{
if (tss.try_string_to_time(dr["kintai_time1"].ToString()) == false)
{
MessageBox.Show("勤怠開始時刻に異常があります。");
return;
}
else
{
if (tss.try_string_to_date(dr["kintai_date2"].ToString()) == false)
{
MessageBox.Show("勤怠終了日に異常があります。");
return;
}
else
{
if (tss.try_string_to_time(dr["kintai_time2"].ToString()) == false)
{
MessageBox.Show("勤怠終了時刻に異常があります。");
return;
}
}
}
}
}
}
//二重登録防止チェック（キー違反）
for (int i = 0; i < w_dt_kintai.Rows.Count; i++)
{
for (int n = 0; n < w_dt_kintai.Rows.Count; n++)
{
//自分の行は飛ばす
if (i != n)
{
if (w_dt_kintai.Rows[i]["syain_cd"].ToString() == w_dt_kintai.Rows[n]["syain_cd"].ToString())
{
if (w_dt_kintai.Rows[i]["kintai_kbn"].ToString() == w_dt_kintai.Rows[n]["kintai_kbn"].ToString())
{
if (w_dt_kintai.Rows[i]["kintai_date1"].ToString() == w_dt_kintai.Rows[n]["kintai_date1"].ToString())
{
if (w_dt_kintai.Rows[i]["kintai_time1"].ToString() == w_dt_kintai.Rows[n]["kintai_time1"].ToString())
{
MessageBox.Show("同一日時の勤怠があります。\n" + (i + 1).ToString() + "行目 " + (n + 1).ToString() + "行目");
return;
}
}
}
}
}
}
}
//既にあるデータを削除して新規に書き込む
if (tss.OracleDelete("delete from tss_kintai_f where kintai_date1 = '" + tb_hizuke.Text + "'"))
{
//新規に書き込み
foreach (DataRow dr in w_dt_kintai.Rows)
{
w_sql = "insert into tss_kintai_f (syain_cd,kintai_kbn,kintai_date1,kintai_time1,kintai_date2,kintai_time2,bikou,create_user_cd,create_datetime) values ("
+ "'" + dr["syain_cd"].ToString() + "',"
+ "'" + dr["kintai_kbn"].ToString() + "',"
+ "'" + dr["kintai_date1"].ToString() + "',"
+ "'" + dr["kintai_time1"].ToString() + "',"
+ "'" + dr["kintai_date2"].ToString() + "',"
+ "'" + dr["kintai_time2"].ToString() + "',"
+ "'" + dr["bikou"].ToString() + "',"
+ "'" + tss.user_cd + "',"
+ "sysdate)";
if (tss.OracleInsert(w_sql) == false)
{
MessageBox.Show("書き込み中にエラーが発生しました。\n処理を注意します。");
this.Close();
}
}
}
MessageBox.Show("登録しました。");
}
private void btn_touroku_Click(object sender, EventArgs e)
{
DataTable dt_work = new DataTable();
//登録前に全ての項目をチェック
//取引先コード
if (chk_torihikisaki_cd() == false)
{
MessageBox.Show("取引先コードは6桁の数字で入力してください（空白不可）");
tb_torihikisaki_cd.Focus();
return;
}
//入金日
if (tb_nyukin_date == null || tb_nyukin_date.Text.ToString() == "")
{
MessageBox.Show("入金日を入力してください（空白不可）");
tb_nyukin_date.Focus();
return;
}
//データグリッドビューの中を1行ずつループしてチェック
int dgvrc = dgv_m.Rows.Count;
if (dgvrc == 1)
{
MessageBox.Show("表の中に何も入力されていません");
return;
}
tss.GetUser(); //ユーザー情報の取得
//データグリッドビューの入力内容チェック
for (int i = 0; i < dgvrc - 1; i++)
{
if (dgv_m.Rows[i].Cells[0].Value.ToString() == null || dgv_m.Rows[i].Cells[0].Value.ToString() == "")
{
MessageBox.Show("入金区分に未入力があります");
dgv_m.Focus();
dgv_m.CurrentCell = dgv_m[0, i];
return;
}
if (dgv_m.Rows[i].Cells[2].Value.ToString() == null || dgv_m.Rows[i].Cells[2].Value.ToString() == "")
{
MessageBox.Show("入金額に未入力があります");
return;
}
//備考が空白の場合、""を代入 空欄だとnull扱いされ、SQLエラー回避
if (dgv_m.Rows[i].Cells[3].Value == null)
{
dgv_m.Rows[i].Cells[3].Value = "";
}
}
//入金番号の重複チェック
dt_work = tss.OracleSelect("select * from tss_nyukin_m where nyukin_no = '" + tb_nyukin_no.Text.ToString() + "'");
//重複がない（新規）の場合
if (dt_work.Rows.Count == 0)
{
//レコードの行数分ループしてインサート
int dgvrc2 = dgv_m.Rows.Count;
for (int i = 0; i < dgvrc2 - 1; i++)
{
bool bl6 = tss.OracleInsert("INSERT INTO tss_nyukin_m (nyukin_no,seq,torihikisaki_cd,nyukin_kbn,nyukin_date,nyukingaku,bikou,create_user_cd,create_datetime) VALUES ('"
+ tb_nyukin_no.Text.ToString() + "','"
+ (i + 1) + "','"
+ tb_torihikisaki_cd.Text.ToString() + "','"
+ dgv_m.Rows[i].Cells[0].Value.ToString() + "','"
+ tb_nyukin_date.Text.ToString() + "','"
+ decimal.Parse(dgv_m.Rows[i].Cells[2].Value.ToString()) + "','"
+ dgv_m.Rows[i].Cells[3].Value.ToString() + "','"
+ tss.user_cd + "',SYSDATE)");
if (bl6 != true)
{
tss.ErrorLogWrite(tss.user_cd, "入金／登録", "登録ボタン押下時のOracleInsert");
MessageBox.Show("入金処理でエラーが発生しました。" + Environment.NewLine + "処理を中止します。");
this.Close();
}
}
tb_create_user_cd.Text = tss.user_cd;
tb_create_datetime.Text = DateTime.Now.ToString();
MessageBox.Show("入金処理が完了しました");
//取引先マスタの未処理入金額の更新
decimal misyori_nyukingaku;
DataTable dt_work_2 = tss.OracleSelect("select misyori_nyukingaku from tss_torihikisaki_m where torihikisaki_cd = '" + tb_torihikisaki_cd.Text + "'");//取引先マスタの未処理金額
if (dt_work_2.Rows[0][0] == null || dt_work_2.Rows[0][0].ToString() == "")
{
misyori_nyukingaku = 0;
}
else
{
misyori_nyukingaku = decimal.Parse(dt_work_2.Rows[0][0].ToString()) + decimal.Parse(tb_nyukin_goukei.Text.ToString());
}
tss.OracleUpdate("UPDATE TSS_torihikisaki_m SET misyori_nyukingaku = '" + misyori_nyukingaku + "',UPDATE_USER_CD = '" + tss.user_cd + "',UPDATE_DATETIME = SYSDATE WHERE torihikisaki_cd = '" + tb_torihikisaki_cd.Text.ToString() + "'");
//tssシステムライブラリの売掛消込処理実行
tss.urikake_kesikomi(tb_torihikisaki_cd.Text.ToString());
}
//重複がある（入金の修正処理）
if (dt_work.Rows.Count != 0)
{
decimal nyukin_goukei_w2 = decimal.Parse(tb_nyukin_goukei.Text.ToString());
//入金合計額が変わった場合、取引先マスタの未処理入金額更新メソッドを動かす。
if (nyukin_goukei_w2 != nyukin_goukei_w)
{
decimal sagaku = nyukin_goukei_w2 - nyukin_goukei_w;
decimal misyori_nyukingaku;
DataTable dt_work_3 = tss.OracleSelect("select misyori_nyukingaku from tss_torihikisaki_m where torihikisaki_cd = '" + tb_torihikisaki_cd.Text + "'");//取引先マスタの未処理金額
if (dt_work_3.Rows[0][0] == null || dt_work_3.Rows[0][0].ToString() == "")
{
misyori_nyukingaku = 0;
}
else
{
misyori_nyukingaku = decimal.Parse(dt_work_3.Rows[0][0].ToString()) + sagaku;
}
tss.OracleUpdate("UPDATE TSS_torihikisaki_m SET misyori_nyukingaku = '" + misyori_nyukingaku + "',UPDATE_USER_CD = '" + tss.user_cd + "',UPDATE_DATETIME = SYSDATE WHERE torihikisaki_cd = '" + tb_torihikisaki_cd.Text.ToString() + "'");
tss.urikake_kesikomi(tb_torihikisaki_cd.Text.ToString());
}
//入金合計額が変わらなかったら
else
{
}
tss.OracleDelete("delete from tss_nyukin_m WHERE nyukin_no = '" + tb_nyukin_no.Text.ToString() + "'");
int rc2 = dgv_m.Rows.Count;
for (int i = 0; i < rc2 - 1; i++)
{
bool bl = tss.OracleInsert("insert into tss_nyukin_m (nyukin_no, seq,torihikisaki_cd,nyukin_kbn,nyukin_date,nyukingaku,bikou,create_user_cd,create_datetime,update_user_cd,update_datetime) values ('"
+ tb_nyukin_no.Text.ToString() + "','"
+ (i + 1) + "','"
+ tb_torihikisaki_cd.Text.ToString() + "','"
+ dgv_m.Rows[i].Cells[0].Value.ToString() + "',"
+ "to_date('" + tb_nyukin_date.Text.ToString() + "','YYYY/MM/DD HH24:MI:SS'),'"
+ dgv_m.Rows[i].Cells[2].Value.ToString() + "','"
+ dgv_m.Rows[i].Cells[3].Value.ToString() + "','"
+ tb_create_user_cd.Text.ToString() + "',"//←カンマがあると、日付をインサートする際にエラーになるので注意する
+ "to_date('" + tb_create_datetime.Text.ToString() + "','YYYY/MM/DD HH24:MI:SS'),'"
+ tss.user_cd + "',SYSDATE)");
if (bl != true)
{
tss.ErrorLogWrite(tss.user_cd, "入金登録", "登録ボタン押下時のOracleInsert");
MessageBox.Show("入金更新処理でエラーが発生しました。" + Environment.NewLine + "処理を中止します。");
this.Close();
}
else
{
}
}
MessageBox.Show("入金更新処理完了");
//form_disp();
}
form_disp();
}
