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(); }