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 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 = get_busyo_name(tb_busyo_cd.Text.ToString());
}
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_jisyaden_kbn_DoubleClick(object sender, EventArgs e)
{
//選択用のdatatableの作成
DataTable dt_work = new DataTable();
//列の定義
dt_work.Columns.Add("区分コード");
dt_work.Columns.Add("区分名");
//行追加
DataRow dr_work = dt_work.NewRow();
dr_work["区分コード"] = "0";
dr_work["区分名"] = "発行しない";
dt_work.Rows.Add(dr_work);
dr_work = dt_work.NewRow();
dr_work["区分コード"] = "1";
dr_work["区分名"] = "発行する";
dt_work.Rows.Add(dr_work);
//選択画面へ
this.tb_jisyaden_kbn.Text = tss.kubun_cd_select_dt("自社伝発行区分", dt_work, tb_jisyaden_kbn.Text);
chk_jisyaden_kbn(); //自社伝発行区分名の表示
}
private void tb_syain_kbn_DoubleClick(object sender, EventArgs e)
{
//選択用のdatatableの作成
DataTable dt_work = new DataTable();
//列の定義
dt_work.Columns.Add("区分");
dt_work.Columns.Add("区分名");
//行追加
DataRow dr_work = dt_work.NewRow();
dr_work["区分"] = "0";
dr_work["区分名"] = "未使用";
dt_work.Rows.Add(dr_work);
dr_work = dt_work.NewRow();
dr_work["区分"] = "1";
dr_work["区分名"] = "正社員";
dt_work.Rows.Add(dr_work);
dr_work = dt_work.NewRow();
dr_work["区分"] = "2";
dr_work["区分名"] = "パート";
dt_work.Rows.Add(dr_work);
dr_work = dt_work.NewRow();
dr_work["区分"] = "3";
dr_work["区分名"] = "嘱託";
dt_work.Rows.Add(dr_work);
dr_work = dt_work.NewRow();
dr_work["区分"] = "4";
dr_work["区分名"] = "派遣・アルバイト・臨時";
dt_work.Rows.Add(dr_work);
//選択画面へ
this.tb_syain_kbn.Text = tss.kubun_cd_select_dt("社員区分", dt_work, tb_syain_kbn.Text);
tb_syain_kbn_name.Text = get_syain_kbn(tb_syain_kbn.Text);
}
private string kintai_kbn_select(string in_cd)
{
string out_kbn;
out_kbn = "";
//選択用のdatatableの作成
DataTable dt_work = new DataTable();
//列の定義
dt_work.Columns.Add("区分");
dt_work.Columns.Add("区分名");
//行追加
DataRow dr_work = dt_work.NewRow();
dr_work["区分"] = "01";
dr_work["区分名"] = "欠勤";
dt_work.Rows.Add(dr_work);
dr_work = dt_work.NewRow();
dr_work["区分"] = "02";
dr_work["区分名"] = "遅刻";
dt_work.Rows.Add(dr_work);
dr_work = dt_work.NewRow();
dr_work["区分"] = "03";
dr_work["区分名"] = "早退";
dt_work.Rows.Add(dr_work);
dr_work = dt_work.NewRow();
dr_work["区分"] = "04";
dr_work["区分名"] = "外出";
dt_work.Rows.Add(dr_work);
dr_work = dt_work.NewRow();
dr_work["区分"] = "05";
dr_work["区分名"] = "代休";
dt_work.Rows.Add(dr_work);
//選択画面へ
out_kbn = tss.kubun_cd_select_dt("勤怠区分", dt_work, in_cd);
return(out_kbn);
}
private void tb_kouza_syubetu_DoubleClick(object sender, EventArgs e)
{
//選択用のdatatableの作成
DataTable dt_work = new DataTable();
//列の定義
dt_work.Columns.Add("区分コード");
dt_work.Columns.Add("区分名");
//行追加
DataRow dr_work = dt_work.NewRow();
dr_work["区分コード"] = "1";
dr_work["区分名"] = "普通";
dt_work.Rows.Add(dr_work);
dr_work = dt_work.NewRow();
dr_work["区分コード"] = "2";
dr_work["区分名"] = "当座";
dt_work.Rows.Add(dr_work);
//選択画面へ
this.tb_kouza_syubetu.Text = tss.kubun_cd_select_dt("口座種別", dt_work);
chk_kouza_syubetu(); //口座種別の表示
}
