private void frm_search_syain_Load(object sender, EventArgs e)
{
switch (str_mode)
{
case "1":
//通常モード
mode1();
break;
case "2":
//子画面モード
mode2();
if (str_name != "")
{
DataTable w_dt = new DataTable();
w_dt = tss.OracleSelect("select syain_cd,syain_name,syain_kbn,busyo_cd,kinmu_time1,kinmu_time2,bikou,delete_flg from tss_syain_m where syain_cd like '" + str_name + "%' or syain_name like '%" + str_name + "%'");
list_disp(w_dt);
//tb_seihin_name.Text = str_name;
//kensaku();
}
break;
default:
MessageBox.Show("画面モードのプロパティに異常があります。処理を中止します。");
form_close_false();
break;
}
}
private void frm_search_torihikisaki_Load(object sender, EventArgs e)
{
switch (str_mode)
{
case "1":
//通常モード
mode1();
break;
case "2":
//子画面モード
mode2();
if (str_name != "")
{
tb_torihikisaki_name.Text = str_name;
DataTable w_dt = new DataTable();
w_dt = tss.OracleSelect("select torihikisaki_cd,torihikisaki_name,jusyo1,jusyo2,tel_no from tss_torihikisaki_m where torihikisaki_cd like '" + str_name + "%' or torihikisaki_name like '%" + str_name + "%'");
list_disp(w_dt);
//tb_torihikisaki_name.Text = str_name;
//kensaku();
}
break;
default:
MessageBox.Show("画面モードのプロパティに異常があります。処理を中止します。");
form_close_false();
break;
}
}
private void message_log_check()
{
tss.GetUser();
DataTable w_dt = new DataTable();
w_dt = tss.OracleSelect("select * from tss_message_log_f where user_cd_to = '" + tss.user_cd + "'");
if (w_dt.Rows.Count > 0)
{
btn_message_log.Visible = true;
int w_cnt = 0;
for (int i = 0; i <= w_dt.Rows.Count - 1; i++)
{
if (w_dt.Rows[i]["kidoku_datetime"].ToString().Length == 0)
{
w_cnt++;
}
}
if (w_cnt > 0)
{
btn_message_log.BackColor = System.Drawing.Color.Orange;
btn_message_log.Text = w_cnt.ToString() + "件の未読システムメッセージがあります。";
}
else
{
btn_message_log.BackColor = System.Drawing.SystemColors.Control;
btn_message_log.Text = "未読のシステムメッセージはありません。";
}
}
else
{
btn_message_log.Visible = false;
}
}
private void frm_kubun_select_Load(object sender, EventArgs e)
{
//リードオンリーにする
dgv_kubun_m.ReadOnly = true;
//行ヘッダーを非表示にする
dgv_kubun_m.RowHeadersVisible = false;
//カラム幅の自動調整（ヘッダーとセルの両方の最長幅に調整する）
dgv_kubun_m.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
//セルの高さ変更不可
dgv_kubun_m.AllowUserToResizeRows = false;
//カラムヘッダーの高さ変更不可
dgv_kubun_m.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
//削除不可にする（コードからは削除可）
dgv_kubun_m.AllowUserToDeleteRows = false;
//１行のみ選択可能（複数行の選択不可）
dgv_kubun_m.MultiSelect = false;
//セルを選択すると行全体が選択されるようにする
dgv_kubun_m.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
//DataGridView1にユーザーが新しい行を追加できないようにする
dgv_kubun_m.AllowUserToAddRows = false;
//画面に引数の区分名称コード表示
this.tb_kubun_meisyou_cd.Text = str_kubun_meisyou_cd;
//画面に区分名称表示
DataTable dt_work = new DataTable();
dt_work = tss.OracleSelect("select kubun_meisyou_cd,kubun_name from tss_kubun_meisyou_m where kubun_meisyou_cd = '" + tb_kubun_meisyou_cd.Text.ToString() + "'");
if (dt_work == null)
{
MessageBox.Show("該当する区分名称マスタがありません。");
form_close_false();
}
this.tb_kubun_meisyou_name.Text = dt_work.Rows[0]["KUBUN_NAME"].ToString();
//引数を基にデータを抽出して表示
dt_kubun_m = tss.OracleSelect("select kubun_cd,kubun_name from tss_kubun_m where kubun_meisyou_cd = '" + tb_kubun_meisyou_cd.Text.ToString() + "' order by kubun_cd asc");
dgv_kubun_m.DataSource = null;
dgv_kubun_m.DataSource = dt_kubun_m;
//DataGridViewのカラムヘッダーテキストを変更する
dgv_kubun_m.Columns[0].HeaderText = "区分コード";
dgv_kubun_m.Columns[1].HeaderText = "区分名";
if (dt_kubun_m == null)
{
MessageBox.Show("該当する区分マスタがありません。");
form_close_false();
}
//initial_cdに何かが入っていたら、初期選択行をinitial_cdと同一の行にする
if (str_initial_cd != null && str_initial_cd != "")
{
for (int i = 0; i < dgv_kubun_m.Rows.Count; i++)
{
if (dgv_kubun_m.Rows[i].Cells[0].Value.ToString() == str_initial_cd)
{
dgv_kubun_m.Rows[i].Selected = true;
break;
}
}
}
}
private void button3_Click(object sender, EventArgs e)
{
if (tss.User_Kengen_Check(6, 9) == false)
{
MessageBox.Show("権限がありません");
return;
}
//フリー在庫レコード作成
DialogResult result = MessageBox.Show("フリー在庫レコードが無い部品を抽出し、フリー在庫レコードを作成します。\n（この処理は少し時間がかかります。）\nよろしいですか？", "確認", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
DataTable dtdt = new DataTable();
dtdt = tss.OracleSelect("select * from tss_buhin_m");
DataTable dddd = new DataTable();
bool bl;
foreach (DataRow dr in dtdt.Rows)
{
dddd = tss.OracleSelect("select * from tss_buhin_zaiko_m where buhin_cd = '" + dr["buhin_cd"].ToString() + "' and zaiko_kbn = '01'");
if (dddd.Rows.Count == 0)
{
bl = tss.OracleInsert("INSERT INTO tss_buhin_zaiko_m (buhin_cd,zaiko_kbn,torihikisaki_cd,juchu_cd1,juchu_cd2,zaiko_su,create_user_cd,create_datetime)"
+ " VALUES ('" + dr["buhin_cd"].ToString() + "','01','999999','9999999999999999','9999999999999999','0','" + "000000" + "',SYSDATE)");
}
}
MessageBox.Show("フリー在庫レコードの作成が完了しました。");
}
}
private void btn_touroku_Click(object sender, EventArgs e)
{
if (tss.User_Kengen_Check(6, 6) == false)
{
MessageBox.Show("権限がありません");
return;
}
//区分名称コードのチェック
if (kubun_meisyou_cd_check() != true)
{
tb_kubun_meisyou_cd.Focus();
}
//区分名称のチェック
else if (tb_kubun_meisyou.Text == null || tb_kubun_meisyou.Text.Length == 0 || System.Text.Encoding.GetEncoding(932).GetByteCount(tb_kubun_meisyou.Text) > 20)
{
MessageBox.Show("名称を20バイト以内で入力してください。");
tb_kubun_meisyou.Focus();
}
//備考のチェック
else if (System.Text.Encoding.GetEncoding(932).GetByteCount(tb_bikou.Text) > 256)
{
MessageBox.Show("備考が256バイトを超えています。");
tb_bikou.Focus();
}
//書込み
else
{
tss.GetUser();
bool bl_tss;
//既存の区分があるかチェック
DataTable dt_work = new DataTable();
dt_work = tss.OracleSelect("select * from TSS_KUBUN_MEISYOU_M where kubun_meisyou_cd = '" + tb_kubun_meisyou_cd.Text.ToString() + "'");
if (dt_work.Rows.Count != 0)
{
//更新
bl_tss = tss.OracleUpdate("UPDATE TSS_KUBUN_MEISYOU_M SET KUBUN_NAME = '" + tb_kubun_meisyou.Text.ToString() + "',BIKOU = '" + tb_bikou.Text.ToString() + "',UPDATE_USER_CD = '" + tss.user_cd + "',UPDATE_DATETIME = SYSDATE WHERE KUBUN_MEISYOU_CD = '" + tb_kubun_meisyou_cd.Text.ToString() + "'");
if (bl_tss != true)
{
tss.ErrorLogWrite(tss.user_cd, "区分名称マスタ／登録", "登録ボタン押下時のOracleUpdate");
MessageBox.Show("書込みでエラーが発生しました。処理を中止します。");
this.Close();
}
}
else
{
//新規
bl_tss = tss.OracleInsert("INSERT INTO tss_kubun_meisyou_m (kubun_meisyou_cd,kubun_name,bikou,create_user_cd) VALUES ('" + tb_kubun_meisyou_cd.Text.ToString() + "','" + tb_kubun_meisyou.Text.ToString() + "','" + tb_bikou.Text.ToString() + "','" + tss.user_cd + "')");
if (bl_tss != true)
{
tss.ErrorLogWrite(tss.user_cd, "区分名称マスタ／登録", "登録ボタン押下時のOracleInsert");
MessageBox.Show("書込みでエラーが発生しました。処理を中止します。");
this.Close();
}
}
kubun_meisyou_m_disp();
gamen_clear();
tb_kubun_meisyou_cd.Focus();
}
}
private void tb_seihin_cd_Validating(object sender, CancelEventArgs e)
{
tb_seihin_name.Text = get_seihin_name(tb_seihin_cd.Text);
DataTable dt_work = new DataTable();
dt_work = tss.OracleSelect("select seihin_kousei_no,seihin_kousei_name from tss_seihin_kousei_name_m where seihin_cd = '" + tb_seihin_cd.Text.ToString() + "' ORDER BY seihin_kousei_no");
dgv_kubun_m.DataSource = dt_work;
dgv_kubun_m.Columns[0].HeaderText = "製品構成番号";
dgv_kubun_m.Columns[1].HeaderText = "製品構成名称";
}
private void tb_koutei_cd_DoubleClick(object sender, EventArgs e)
{
//選択用のdatatableの作成
DataTable dt_work = new DataTable();
dt_work = tss.OracleSelect("select koutei_cd,koutei_name from TSS_koutei_M ORDER BY koutei_CD");
dt_work.Columns["koutei_cd"].ColumnName = "工程コード";
dt_work.Columns["koutei_name"].ColumnName = "工程名";
//選択画面へ
this.tb_koutei_cd.Text = tss.kubun_cd_select_dt("工程一覧", dt_work, tb_koutei_cd.Text);
tb_koutei_name.Text = tss.get_koutei_name(tb_koutei_cd.Text.ToString());
}
private void tb_busyo_cd_DoubleClick(object sender, EventArgs e)
{
//選択用のdatatableの作成
DataTable dt_work = new DataTable();
dt_work = tss.OracleSelect("select busyo_cd,busyo_name from TSS_BUSYO_M WHERE delete_flg = 0 ORDER BY BUSYO_CD");
dt_work.Columns["busyo_cd"].ColumnName = "部署コード";
dt_work.Columns["busyo_name"].ColumnName = "部署名";
//選択画面へ
this.tb_busyo_cd.Text = tss.kubun_cd_select_dt("部署一覧", dt_work, tb_busyo_cd.Text);
tb_busyo_name.Text = tss.get_busyo_name(tb_busyo_cd.Text);
}
private void make_insatu_data()
{
w_dt = new DataTable(); //生産スケジュール用
//画面の条件からsqlを作成しデータを抽出
string[] sql_where = new string[7];
int sql_cnt = 0;
//部署
if (tb_busyo_cd.Text != "" && tb_busyo_cd.Text != "")
{
sql_where[sql_cnt] = "a.busyo_cd = '" + tb_busyo_cd.Text.ToString() + "'";
sql_cnt++;
}
//工程
if (tb_koutei_cd.Text != "" && tb_koutei_cd.Text != "")
{
sql_where[sql_cnt] = "a.koutei_cd = '" + tb_koutei_cd.Text.ToString() + "'";
sql_cnt++;
}
//ライン
if (tb_line_cd.Text != "" && tb_line_cd.Text != "")
{
sql_where[sql_cnt] = "a.line_cd = '" + tb_line_cd.Text.ToString() + "'";
sql_cnt++;
}
//string sql = "select * from tss_seisan_schedule_f where seisan_yotei_date = '" + tb_seisan_yotei_date.Text + "' ";
string sql = "select A.seisan_yotei_date,A.busyo_cd,B.busyo_name,A.koutei_cd,C.koutei_name,A.line_cd,D.line_name,A.seq,A.torihikisaki_cd,A.juchu_cd1,A.juchu_cd2,A.seihin_cd,A.seihin_name,A.seisankisyu,A.juchu_su,A.seisan_su,A.tact_time,A.dandori_kousu,A.tuika_kousu,A.hoju_kousu,A.seisan_time,A.start_time,A.end_time,A.ninzu,A.members,A.hensyu_flg,A.bikou,E.bikou2,A.create_user_cd,A.create_datetime,A.update_user_cd,A.update_datetime"
+ " from tss_seisan_schedule_f A"
+ " left outer join tss_busyo_m B on A.busyo_cd = B.busyo_cd"
+ " left outer join tss_koutei_m C on A.koutei_cd = C.koutei_cd"
+ " left outer join tss_line_m D on A.line_cd = D.line_cd"
+ " left outer join tss_juchu_m E on A.torihikisaki_cd = E.torihikisaki_cd and A.juchu_cd1 = E.juchu_cd1 and A.juchu_cd2 = E.juchu_cd2"
+ " where seisan_yotei_date = '" + tb_seisan_yotei_date.Text + "' ";
for (int i = 1; i <= sql_cnt; i++)
{
if (i >= 1)
{
sql = sql + " and ";
}
sql = sql + sql_where[i - 1];
}
sql = sql + " order by koutei_cd,line_cd,A.start_time ";
w_dt = tss.OracleSelect(sql);
w_dt.Columns.Add("seisanzumi", Type.GetType("System.Int32")).SetOrdinal(27);
seisanzumi();
}
private void insatu_preview()
{
DataTable w_dt_uriage = new DataTable();
if (rb_kuuhaku.Checked == true)
{
//空白の請求書を印刷
w_dt_uriage.Rows.Clear();
w_dt_uriage = null; //白紙の印刷時はnullを渡す
rpt_seikyu rpt = new rpt_seikyu();
//レポートへデータを受け渡す
rpt.DataSource = w_dt_uriage;
rpt.w_dr = null; //白紙の印刷時はnullを渡す
rpt.Run();
this.viewer1.Document = rpt.Document;
}
else
{
//通常の印刷
if (rb_seikyu_no.Checked == true)
{
w_dt_urikake = tss.OracleSelect("select * from tss_urikake_m where urikake_no = '" + tb_urikake_no.Text.ToString() + "'");
}
else
{
w_dt_urikake = tss.OracleSelect("select * from tss_urikake_m where torihikisaki_cd >= '" + tb_torihikisaki_cd1.Text.ToString() + "' and torihikisaki_cd <= '" + tb_torihikisaki_cd2.Text.ToString() + "' and uriage_simebi = '" + tb_simebi.Text.ToString() + "'");
}
if (w_dt_urikake.Rows.Count == 0)
{
MessageBox.Show("印刷するデータがありません。");
return;
}
//w_dt_urikakeのレコード数分、印刷を繰り返す
foreach (DataRow dr in w_dt_urikake.Rows)
{
//明細印刷用の売上情報の読み込み
w_dt_uriage.Rows.Clear();
w_dt_uriage = tss.OracleSelect("select seihin_cd,seihin_name,sum(uriage_su) uriage_su,sum(uriage_kingaku) uriage_kingaku,sum(syouhizeigaku) syouhizeigaku from tss_uriage_m where urikake_no = '" + dr["urikake_no"].ToString() + "' group by seihin_cd,seihin_name order by seihin_cd asc,seihin_name asc");
rpt_seikyu rpt = new rpt_seikyu();
//レポートへデータを受け渡す
rpt.DataSource = w_dt_uriage;
rpt.w_dr = dr; //ヘッダー用の売掛マスタレコード
rpt.Run();
this.viewer1.Document = rpt.Document;
//this.viewer1.Print(true,true,true);
}
}
}
private void frm_search_buhin_Load(object sender, EventArgs e)
{
switch (str_mode)
{
case "1":
//通常モード
mode1();
break;
case "2":
//子画面モード
mode2();
if (str_name != "")
{
DataTable w_dt = new DataTable();
w_dt = tss.OracleSelect("select buhin_cd,buhin_name,buhin_hosoku,maker_name,siiresaki_cd,siire_kbn,torihikisaki_cd,siire_tanka from tss_buhin_m where buhin_cd like '" + str_name + "%' or buhin_name like '%" + str_name + "%'");
list_disp(w_dt);
//tb_buhin_name.Text = str_name;
//kensaku();
}
break;
default:
MessageBox.Show("画面モードのプロパティに異常があります。処理を中止します。");
form_close_false();
break;
}
}
private void data_read()
{
string w_sql;
w_sql = "select A.seisan_yotei_date,B.busyo_name,C.koutei_name,D.line_name,A.seq,A.seisankisyu,A.seisan_su,A.seisan_time,A.start_time,A.end_time,A.ninzu,A.members,A.bikou,A.hensyu_flg"
+ " from tss_seisan_schedule_f A"
+ " left outer join tss_busyo_m B on (A.busyo_cd = B.busyo_cd)"
+ " left outer join tss_koutei_m C on (A.koutei_cd = C.koutei_cd)"
+ " left outer join tss_line_m D on (A.line_cd = D.line_cd)"
+ " where torihikisaki_cd = '" + tb_torihikisaki_cd.Text.ToString() + "' and juchu_cd1 = '" + tb_juchu_cd1.Text.ToString() + "' and juchu_cd2 = '" + tb_juchu_cd2.Text.ToString()
+ "' order by A.seisan_yotei_date,seq asc";
w_dt_seisan_schedule = tss.OracleSelect(w_sql);
w_dt_busyo_koutei = tss.OracleSelect("select A.busyo_cd,B.busyo_name,A.koutei_cd,C.koutei_name,sum(A.seisan_su) seisan_su from tss_seisan_schedule_f A left outer join tss_busyo_m B on A.busyo_cd = B.busyo_cd left outer join tss_koutei_m C on A.koutei_cd = C.koutei_cd where torihikisaki_cd = '" + tb_torihikisaki_cd.Text + "' and juchu_cd1 = '" + tb_juchu_cd1.Text + "' and juchu_cd2 = '" + tb_juchu_cd2.Text + "' group by A.busyo_cd, A.koutei_cd, B.busyo_name, C.koutei_name order by A.busyo_cd,A.koutei_cd asc");
}
private void message_log_list_disp()
{
tss.GetUser();
w_dt_message_log = tss.OracleSelect("SELECT A.message_datetime,A.user_cd_from,A.user_cd_to,B.user_name,A.message_syori_name,A.message_log_naiyou,A.kidoku_datetime from tss_message_log_f A LEFT OUTER JOIN tss_user_m B ON A.user_cd_to = B.user_cd WHERE A.user_cd_from = '" + tss.user_cd + "' order by A.message_datetime desc");
dgv_message_log.DataSource = w_dt_message_log;
//リードオンリーにする
dgv_message_log.ReadOnly = true;
//行ヘッダーを非表示にする
dgv_message_log.RowHeadersVisible = false;
//カラム幅の自動調整（ヘッダーとセルの両方の最長幅に調整する）
dgv_message_log.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
//セルの高さ変更不可
dgv_message_log.AllowUserToResizeRows = false;
//カラムヘッダーの高さ変更不可
dgv_message_log.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
//削除不可にする（コードからは削除可）
dgv_message_log.AllowUserToDeleteRows = false;
//１行のみ選択可能（複数行の選択不可）
dgv_message_log.MultiSelect = false;
//セルを選択すると行全体が選択されるようにする
dgv_message_log.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
//DataGridView1にユーザーが新しい行を追加できないようにする
dgv_message_log.AllowUserToAddRows = false;
//DataGridViewのカラムヘッダーテキストを変更する
dgv_message_log.Columns[0].HeaderText = "発生日時";
dgv_message_log.Columns[1].HeaderText = "宛先";
dgv_message_log.Columns[2].HeaderText = "作成者";
dgv_message_log.Columns[3].HeaderText = "作成者名";
dgv_message_log.Columns[4].HeaderText = "処理・タイトル";
dgv_message_log.Columns[5].HeaderText = "内容";
dgv_message_log.Columns[6].HeaderText = "既読日時";
//DataGridView1のはじめの列を非表示にする
dgv_message_log.Columns[5].Visible = false;
}
private void get_calendar()
{
w_dt_calendar.Rows.Clear();
w_dt_calendar.Columns.Clear();
w_dt_calendar.Clear();
w_dt_calendar = tss.OracleSelect("select * from tss_calendar_f where calendar_year = '" + nud_year.Value.ToString() + "' and calendar_month = '" + nud_month.Value.ToString("00") + "'");
}
private string get_seihin_name(string in_cd)
{
string out_name = ""; //戻り値用
DataTable dt_work = new DataTable();
dt_work = tss.OracleSelect("select * from tss_seihin_m where seihin_cd = '" + in_cd + "'");
if (dt_work.Rows.Count <= 0)
{
out_name = "";
}
else
{
out_name = dt_work.Rows[0]["seihin_name"].ToString();
}
return(out_name);
}
private bool chk_seihin_cd()
{
bool bl = true; //戻り値
DataTable dt_work = new DataTable();
dt_work = tss.OracleSelect("select * from tss_seihin_m where seihin_cd = '" + tb_seihin_cd.Text.ToString() + "'");
if (dt_work.Rows.Count <= 0)
{
//無し
bl = false;
}
else
{
//既存データ有
}
return(bl);
}
private void dgv_idou_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
DataGridView dgv = (DataGridView)sender;
//部品コードが入力されたならば、部品名を部品マスターから取得して表示
if (dgv.Columns[e.ColumnIndex].Index == 0 && dgv.CurrentCell.Value.ToString() != null)
{
int i = e.RowIndex;
DataTable dtTmp = (DataTable)dgv_idou.DataSource;
//部品コードをキーに、部品名を引っ張ってくる
DataTable dt_work = new DataTable();
int j = dt_work.Rows.Count;
dt_work = tss.OracleSelect("select * from tss_buhin_m where buhin_cd = '" + dgv.CurrentCell.Value.ToString() + "'");
if (dt_work.Rows.Count <= 0)
{
MessageBox.Show("この部品コードは登録されていません。部品登録してください。");
dgv.Rows[i].Cells[1].Value = "";
dgv_idou.Focus();
dgv_idou.CurrentCell = dgv_idou[i, 0];
}
else
{
dgv.Rows[i].Cells[1].Value = dt_work.Rows[j][1].ToString();
}
return;
}
}
private bool chk_user_cd()
{
bool bl = true; //戻り値
DataTable dt_work = new DataTable();
dt_work = tss.OracleSelect("select * from tss_user_m where user_cd = '" + tb_user_cd.Text.ToString() + "'");
if (dt_work.Rows.Count <= 0)
{
//新規
gamen_sinki(tb_user_cd.Text);
}
else
{
//既存データ有
gamen_disp(dt_work);
}
return(bl);
}
private void set_kaisya()
{
string w_kouza_syubetu;
w_dt_kaisya = tss.OracleSelect("select * from tss_torihikisaki_m where torihikisaki_cd = '000000'");
tb_kaisya_name.Text = w_dt_kaisya.Rows[0]["torihikisaki_name"].ToString();
tb_kaisya_jusyo.Text = "〒" + w_dt_kaisya.Rows[0]["yubin_no"].ToString().TrimEnd() + " " + w_dt_kaisya.Rows[0]["jusyo1"].ToString().TrimEnd() + w_dt_kaisya.Rows[0]["jusyo2"].ToString().TrimEnd();
tb_kaisya_tel.Text = "TEL " + w_dt_kaisya.Rows[0]["tel_no"].ToString().TrimEnd() + " FAX " + w_dt_kaisya.Rows[0]["fax_no"].ToString().TrimEnd();
w_dt_bank = tss.OracleSelect("select * from tss_bank_m where torihikisaki_cd = '000000'");
if (w_dt_bank.Rows[0]["kouza_syubetu"].ToString() == "1")
{
w_kouza_syubetu = "普通";
}
else
{
w_kouza_syubetu = "当座";
}
tb_kaisya_bank.Text = "振込先 " + w_dt_bank.Rows[0]["bank_name"].ToString().TrimEnd() + " " + w_dt_bank.Rows[0]["siten_name"].ToString().TrimEnd() + " " + w_kouza_syubetu + " " + w_dt_bank.Rows[0]["kouza_no"].ToString().TrimEnd();
}
private bool chk_seihin_cd()
{
bool bl = true; //戻り値
DataTable dt_work = new DataTable();
dt_work = tss.OracleSelect("select * from tss_seihin_m where seihin_cd = '" + tb_seihin_cd.Text.ToString() + "'");
if (dt_work.Rows.Count <= 0)
{
//無い
bl = false;
}
else
{
//既存データ有
tb_seihin_name.Text = dt_work.Rows[0]["seihin_name"].ToString();
tb_seihin_kousei_no.Text = dt_work.Rows[0]["seihin_kousei_no"].ToString();
get_seihin_kousei_name();
}
return(bl);
}
private void tb_buhin_cd_Validating(object sender, CancelEventArgs e)
{
if (tss.Check_String_Escape(tb_buhin_cd.Text) == false)
{
e.Cancel = true;
return;
}
if (tb_buhin_cd.Text.ToString() != null && tb_buhin_cd.Text.ToString() != "")
{
w_dt_m = tss.OracleSelect("select * from tss_buhin_m where buhin_cd = '" + tb_buhin_cd.Text.ToString() + "'");
if (w_dt_m.Rows.Count != 0)
{
tb_buhin_name.Text = w_dt_m.Rows[0]["buhin_name"].ToString();
}
else
{
MessageBox.Show("入力した部品コードは存在しません。");
e.Cancel = true;
}
}
}
private void btn_start_Click(object sender, EventArgs e)
{
string w_sql1 = "";
string w_sql2 = "";
w_sql1 = " and to_char(A.create_datetime,'yyyy/mm/dd') <= '" + tb_date.Text.ToString() + "'";
if (cb_zaiko.Checked)
{
w_sql2 = " and A.zaiko_su <> 0";
}
w_dt = null;
//w_dt = tss.OracleSelect("SELECT A.* FROM tss_buhin_zaiko_m A LEFT OUTER JOIN tss_juchu_m B ON (A.torihikisaki_cd = B.torihikisaki_cd AND A.juchu_cd1 = B.juchu_cd1 AND A.juchu_cd2 = B.juchu_cd2) WHERE A.zaiko_kbn = '02' AND B.torihikisaki_cd IS NULL" + w_sql1 + w_sql2);
w_dt = tss.OracleSelect("SELECT A.buhin_cd,C.buhin_name,A.zaiko_kbn,A.torihikisaki_cd,A.juchu_cd1,A.juchu_cd2,A.zaiko_su,A.create_user_cd,A.create_datetime,A.update_user_cd,A.update_datetime FROM tss_buhin_zaiko_m A LEFT OUTER JOIN tss_juchu_m B ON (A.torihikisaki_cd = B.torihikisaki_cd AND A.juchu_cd1 = B.juchu_cd1 AND A.juchu_cd2 = B.juchu_cd2) LEFT OUTER JOIN tss_buhin_m C ON (A.buhin_cd = C.buhin_cd) WHERE A.zaiko_kbn = '02' AND B.torihikisaki_cd IS NULL" + w_sql1 + w_sql2);
dgv_m.DataSource = null;
dgv_m.DataSource = w_dt;
//リードオンリーにする
dgv_m.ReadOnly = true;
//行ヘッダーを非表示にする
dgv_m.RowHeadersVisible = false;
//カラム幅の自動調整（ヘッダーとセルの両方の最長幅に調整する）
dgv_m.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
//セルの高さ変更不可
dgv_m.AllowUserToResizeRows = false;
//カラムヘッダーの高さ変更不可
dgv_m.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
//削除不可にする（コードからは削除可）
dgv_m.AllowUserToDeleteRows = false;
//１行のみ選択可能（複数行の選択不可）
dgv_m.MultiSelect = false;
//セルを選択すると行全体が選択されるようにする
dgv_m.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
//DataGridView1にユーザーが新しい行を追加できないようにする
dgv_m.AllowUserToAddRows = false;
//DataGridViewのカラムヘッダーテキストを変更する
dgv_m.Columns[0].HeaderText = "部品コード";
dgv_m.Columns[1].HeaderText = "部品名";
dgv_m.Columns[2].HeaderText = "在庫区分";
dgv_m.Columns[3].HeaderText = "取引先コード";
dgv_m.Columns[4].HeaderText = "受注コード1";
dgv_m.Columns[5].HeaderText = "受注コード2";
dgv_m.Columns[6].HeaderText = "在庫数";
dgv_m.Columns[7].HeaderText = "作成者";
dgv_m.Columns[8].HeaderText = "作成日時";
dgv_m.Columns[9].HeaderText = "更新者";
dgv_m.Columns[10].HeaderText = "更新日時";
//右詰
dgv_m.Columns[6].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
}
private void line_m_disp()
{
dt = tss.OracleSelect("select line_cd,line_name,line_ryakusiki_name,bikou,delete_flg from tss_line_m order by line_cd asc");
dgv_line_m.DataSource = null;
if (dt.Rows.Count >= 1)
{
dgv_line_m.DataSource = dt;
dgv_line_m.Columns[0].HeaderText = "ラインコード";
dgv_line_m.Columns[1].HeaderText = "ライン名称";
dgv_line_m.Columns[2].HeaderText = "ライン略式名称";
dgv_line_m.Columns[3].HeaderText = "備考";
dgv_line_m.Columns[4].HeaderText = "削除フラグ";
dgv_line_m.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; //カラム幅の自動調整
dgv_line_m.AllowUserToResizeRows = false; //セルの高さ変更不可
dgv_line_m.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing; //カラムヘッダーの高さ変更不可
dgv_line_m.ReadOnly = true; //編集不可
dgv_line_m.AllowUserToDeleteRows = false; //削除不可
dgv_line_m.RowHeadersVisible = false; //行ヘッダーを非表示にする
dgv_line_m.AllowUserToAddRows = false; //行を追加できないようにする（最下行を非表示にする）
}
}
//取引先コード入力時の処理
private void tb_torihikisaki_cd_Validating(object sender, CancelEventArgs e)
{
if (tb_torihikisaki_cd.Text == "")
{
tb_torihikisaki_name.Text = "";
return;
}
DataTable dt_work = new DataTable();
dt_work = tss.OracleSelect("select * from tss_torihikisaki_m where torihikisaki_cd = '" + tb_torihikisaki_cd.Text + "'");
if (dt_work.Rows.Count <= 0)
{
//無し
MessageBox.Show("入力された取引先コードが存在しません。取引先マスタに登録してください。");
tb_torihikisaki_cd.Focus();
}
else
{
//既存データ有
tb_torihikisaki_name.Text = get_torihikisaki_name(tb_torihikisaki_cd.Text);
}
//データグリッドビューにフォーカス移動
dgv_nyusyukkoidou.Focus();
}
private void frm_search_seihin_Load(object sender, EventArgs e)
{
switch (str_mode)
{
case "1":
//通常モード
mode1();
break;
case "2":
//子画面モード
mode2();
if (str_name != "")
{
tb_seihin_name.Text = str_name;
DataTable w_dt = new DataTable();
w_dt = tss.OracleSelect("select A.seihin_cd,A.seihin_name,A.torihikisaki_cd,B.torihikisaki_name,A.nouhin_schedule_kbn,A.seihin_kousei_no,A.bikou from tss_seihin_m A left outer join tss_torihikisaki_m B on A.torihikisaki_cd = B.torihikisaki_cd where seihin_cd like '" + str_name + "%' or seihin_name like '%" + str_name + "%'");
list_disp(w_dt);
}
break;
default:
MessageBox.Show("画面モードのプロパティに異常があります。処理を中止します。");
form_close_false();
break;
}
}
private bool chk_torihikisaki_cd()
{
bool bl = true; //戻り値
//取引先コードのオール９はシステムで使用しているため使用不可
if (tb_torihikisaki_cd.Text == "999999")
{
bl = false;
return(bl);
}
DataTable dt_work = new DataTable();
dt_work = tss.OracleSelect("select * from tss_torihikisaki_m where torihikisaki_cd = '" + tb_torihikisaki_cd.Text.ToString() + "'");
if (dt_work.Rows.Count <= 0)
{
//無し
bl = false;
}
else
{
//既存データ有
}
return(bl);
}
private void eigyoubi_get()
{
DataTable w_dt = new DataTable();
w_dt = tss.OracleSelect("select * from tss_calendar_f where calendar_year = '" + w_yyyy + "' and calendar_month = '" + w_mm + "'");
if (w_dt.Rows.Count > 0)
{
foreach (DataRow dr in w_dt.Rows)
{
int w_int;
if (int.TryParse(dr["calendar_day"].ToString(), out w_int))
{
w_day[w_int] = dr["eigyou_kbn"].ToString();
}
}
}
}
private void tb_torihikisaki_cd_Validating(object sender, CancelEventArgs e)
{
DataTable dt_work = new DataTable();
dt_work = tss.OracleSelect("select torihikisaki_name,syouhizei_sansyutu_kbn from tss_torihikisaki_m where torihikisaki_cd = '" + tb_torihikisaki_cd.Text + "'");
if (dt_work.Rows.Count == 0)
{
return;
}
else
{
tb_torihikisaki_name.Text = dt_work.Rows[0][0].ToString();
}
tb_siire_simebi.Clear();
dgv_siire_simebi.Rows.Clear();
tb_create_user_cd.Clear();
tb_create_datetime.Clear();
tb_update_user_cd.Clear();
tb_update_datetime.Clear();
}
private void cb_table_name_DropDown(object sender, EventArgs e)
{
//テーブル名を取得してコンボボックスのアイテムに追加する
TssSystemLibrary tss = new TssSystemLibrary();
DataTable dt2 = new DataTable();
dt2 = tss.OracleSelect("SELECT TABLE_NAME FROM USER_TABLES order by table_name asc");
if (dt2 == null)
{
MessageBox.Show("テーブルが取得できません。", "エラー");
return;
}
cb_table_name.Items.Clear();
foreach (DataRow tablename in dt2.Rows)
{
cb_table_name.Items.Add(tablename[0]);
}
}
private void cb_table_name_DropDown(object sender, EventArgs e)
{
//テーブル名を取得してコンボボックスのアイテムに追加する
TssSystemLibrary tss = new TssSystemLibrary();
DataTable dt2 = new DataTable();
dt2 = tss.OracleSelect("SELECT TABLE_NAME FROM USER_TABLES order by table_name asc");
if (dt2 == null)
{
MessageBox.Show("テーブルが取得できません。", "エラー");
return;
}
cb_table_name.Items.Clear();
foreach (DataRow tablename in dt2.Rows)
{
cb_table_name.Items.Add(tablename[0]);
}
}
private void status_disp()
{
TssSystemLibrary tss = new TssSystemLibrary();
tss.GetSystemSetting();
tss.GetUser();
//tss.GetConnectionString();
ss_status.Items.Clear(); //追加する前にクリアする
ss_status.Items.Add(tss.system_name);
ss_status.Items.Add(tss.system_version);
ss_status.Items.Add("CODE:" + tss.code_version);
ss_status.Items.Add(tss.user_name);
ss_status.Items.Add(tss.kengen1+tss.kengen2+tss.kengen3+"-"+tss.kengen4+tss.kengen5+tss.kengen6+"-"+tss.kengen7+tss.kengen8+tss.kengen9);
switch (tss.DataSource)
{
case "pdb2a":
lbl_db.Text = "TSS SYSTEM PRODUCTION Connect";
lbl_db.BackColor = Color.RoyalBlue;
lbl_db.ForeColor = Color.White;
break;
case "pdb2a_dev":
lbl_db.Text = "開発用DBに接続中！";
lbl_db.BackColor = Color.Red;
lbl_db.ForeColor = Color.White;
break;
default:
lbl_db.Text = "不明なDBに接続されています！";
lbl_db.BackColor = Color.Red;
lbl_db.ForeColor = Color.White;
break;
}
//メッセージ表示
DataTable w_dt_ctrl = new DataTable();
w_dt_ctrl = tss.OracleSelect("select * from tss_control_m where system_cd = '0101'");
if(w_dt_ctrl.Rows.Count<=0)
{
MessageBox.Show("コントロールマスタに異常があります。\nシステムを終了します。");
Application.Exit();
}
//メッセージの表示
lbl_msg1.Text = w_dt_ctrl.Rows[0]["msg1"].ToString();
lbl_msg2.Text = w_dt_ctrl.Rows[0]["msg2"].ToString();
lbl_msg3.Text = w_dt_ctrl.Rows[0]["msg3"].ToString();
//メッセージの色の設定
switch (w_dt_ctrl.Rows[0]["color1"].ToString())
{
case "1":
lbl_msg1.ForeColor = Color.Red;
break;
case "2":
lbl_msg1.ForeColor = Color.Blue;
break;
case "3":
lbl_msg1.ForeColor = Color.Green;
break;
case "4":
lbl_msg1.ForeColor = Color.Orange;
break;
case "5":
lbl_msg1.ForeColor = Color.Gray;
break;
default:
lbl_msg1.ForeColor = Color.Black;
break;
}
switch (w_dt_ctrl.Rows[0]["color2"].ToString())
{
case "1":
lbl_msg2.ForeColor = Color.Red;
break;
case "2":
lbl_msg2.ForeColor = Color.Blue;
break;
case "3":
lbl_msg2.ForeColor = Color.Green;
break;
case "4":
lbl_msg2.ForeColor = Color.Orange;
break;
case "5":
lbl_msg2.ForeColor = Color.Gray;
break;
default:
lbl_msg2.ForeColor = Color.Black;
break;
}
switch (w_dt_ctrl.Rows[0]["color3"].ToString())
{
case "1":
lbl_msg3.ForeColor = Color.Red;
break;
case "2":
lbl_msg3.ForeColor = Color.Blue;
break;
case "3":
lbl_msg3.ForeColor = Color.Green;
break;
case "4":
lbl_msg3.ForeColor = Color.Orange;
break;
case "5":
lbl_msg3.ForeColor = Color.Gray;
break;
default:
lbl_msg3.ForeColor = Color.Black;
break;
}
}
