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(); //口座種別の表示 }