private void tb_torihikisaki_cd_Validating(object sender, CancelEventArgs e)
{
if (tss.Check_String_Escape(tb_torihikisaki_cd.Text) == false)
{
e.Cancel = true;
return;
}
if (tb_torihikisaki_cd.Text == "999999")
{
MessageBox.Show("取引先コードのオール９は、システム予約コードの為、使用できません。");
tb_torihikisaki_cd.Focus();
e.Cancel = true;
return;
}
//終了ボタンを考慮して、空白は許容する
if (tb_torihikisaki_cd.Text != "")
{
if (chk_torihikisaki_cd() != true)
{
MessageBox.Show("取引先コードに異常があります。");
e.Cancel = true;
}
else
{
//取引先名を取得・表示
tb_torihikisaki_name.Text = tss.get_torihikisaki_name(tb_torihikisaki_cd.Text);
}
}
}
private void tb_torihikisaki_cd_Validating(object sender, CancelEventArgs e)
{
tb_torihikisaki_name.Text = tss.get_torihikisaki_name(tb_torihikisaki_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_torihikisaki_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_torihikisaki_cd_DoubleClick(object sender, EventArgs e)
{
//選択画面へ
string w_cd;
w_cd = tss.search_torihikisaki("2", tb_torihikisaki_cd.Text);
if (w_cd != "")
{
tb_torihikisaki_cd.Text = w_cd;
tb_torihikisaki_name.Text = tss.get_torihikisaki_name(tb_torihikisaki_cd.Text);
}
}
private void tb_torihikisaki_cd_Validated(object sender, EventArgs e)
{
if (tb_torihikisaki_cd.Text != "")
{
tb_torihikisaki_name.Text = tss.get_torihikisaki_name(tb_torihikisaki_cd.Text);
}
}
private void rpt_seikyu_ReportStart(object sender, EventArgs e)
{
//w_dt_urikakeに印刷する売掛レコードが入ってくる
//会社情報をヘッダーに割り当て
set_kaisya();
//ヘッダー情報を割り当て
if (w_dr == null)
{
tb_torihikisaki_cd.Text = "";
tb_hiduke.Text = "";
tb_kurikosi.Text = "";
tb_uriage.Text = "";
tb_syouhizei.Text = "";
tb_nyukin.Text = "";
tb_zandaka.Text = "";
tb_seikyu.Text = "";
tb_mm.Text = "";
tb_torihikisaki_name.Text = "";
tb_urikake_no.Text = "";
}
else
{
tb_torihikisaki_cd.Text = w_dr["torihikisaki_cd"].ToString();
tb_hiduke.Text = w_dr["uriage_simebi"].ToString();
tb_kurikosi.Text = tss.try_string_to_decimal(w_dr["kurikosigaku"].ToString()).ToString("#,##0");
tb_uriage.Text = tss.try_string_to_decimal(w_dr["uriage_kingaku"].ToString()).ToString("#,##0");
tb_syouhizei.Text = tss.try_string_to_decimal(w_dr["syouhizeigaku"].ToString()).ToString("#,##0");
tb_nyukin.Text = tss.try_string_to_decimal(w_dr["nyukingaku2"].ToString()).ToString("#,##0");
tb_zandaka.Text = tss.try_string_to_decimal(w_dr["urikake_zandaka"].ToString()).ToString("#,##0");
tb_seikyu.Text = (tss.try_string_to_decimal(w_dr["uriage_kingaku"].ToString()) + tss.try_string_to_decimal(w_dr["syouhizeigaku"].ToString())).ToString("#,##0");
tb_mm.Text = tss.try_string_to_decimal(w_dr["uriage_simebi"].ToString().Substring(5, 2)).ToString("##");
tb_torihikisaki_name.Text = tss.get_torihikisaki_name(w_dr["torihikisaki_cd"].ToString()) + " 様";
tb_urikake_no.Text = w_dr["urikake_no"].ToString();
//フッター情報（消費税）を割り当て
//w_dt_syouhizei = tss.OracleSelect("select * from tss_torihikisaki_m where torihikisaki_cd = '" + w_dr["torihikisaki_cd"].ToString() + "'");
//if (w_dt_syouhizei.Rows[0]["syouhizei_sansyutu_kbn"].ToString() == "0")
//{
// //請求合計
// tb_footer_name.Text = "消費税";
// tb_footer_syouhizei.Text = tss.try_string_to_double(w_dr["syouhizeigaku"].ToString()).ToString("#,##0");
//}
//if (w_dt_syouhizei.Rows[0]["syouhizei_sansyutu_kbn"].ToString() == "1")
//{
// //明細毎
// tb_footer_name.Text = "";
// tb_footer_syouhizei.Text = "";
//}
//if (w_dt_syouhizei.Rows[0]["syouhizei_sansyutu_kbn"].ToString() == "2")
//{
// //伝票毎
// tb_footer_name.Text = "消費税は伝票毎に算出させていただいている為、合計金額のみ記載させていただきます。";
// tb_footer_syouhizei.Text = "";
//}
}
}
private void uriage_disp(DataTable in_dt)
{
//dgvをクリア
dgv_m.DataSource = null;
dgv_m.Columns.Clear();
dgv_m.Rows.Clear();
//画面の見出し項目を表示
tb_torihikisaki_cd.Text = in_dt.Rows[0]["torihikisaki_cd"].ToString();
tb_torihikisaki_name.Text = tss.get_torihikisaki_name(in_dt.Rows[0]["torihikisaki_cd"].ToString());
tb_uriage_date.Text = DateTime.Parse(in_dt.Rows[0]["uriage_date"].ToString()).ToShortDateString();
//dgvにデータをバインド
dgv_m.DataSource = in_dt;
//dgvの表示設定
uriage_init();
//合計を表示
uriage_goukei_disp();
}
private void tb_siire_no_Validating(object sender, CancelEventArgs e)
{
//入力された仕入番号を"0000000000"形式の文字列に変換
double w_double;
if (double.TryParse(tb_siire_no.Text.ToString(), out w_double))
{
tb_siire_no.Text = w_double.ToString("0000000000");
}
else
{
MessageBox.Show("仕入番号に異常があります。");
tb_siire_no.Focus();
}
//新規か既存かの判定
if (tb_siire_no.Text.ToString() == w_siire_no.ToString("0000000000"))
{
//新規
//dgvに空のデータを表示するためのダミー抽出
//DataTable dt_work = new DataTable();
//dt_work = tss.OracleSelect("select * from tss_uriage_m where uriage_no = '" + tb_siire_no.Text.ToString() + "' order by uriage_no asc,seq asc");
////uriage_sinki(w_dt);
}
else
{
//既存仕入の表示
DataTable dt_work = new DataTable();
dt_work = tss.OracleSelect("select siire_no, seq,torihikisaki_cd, siire_date,buhin_cd,buhin_name,siire_su,siire_tanka,siire_kingaku,siire_denpyo_no,TO_CHAR(siire_simebi, 'YYYY/MM/DD'),TO_CHAR(shiharai_date, 'YYYY/MM/DD'),bikou,DELETE_FLG,create_user_cd,create_datetime,update_user_cd,update_datetime from tss_siire_m where siire_no = '" + tb_siire_no.Text.ToString() + "' ORDER BY SEQ");
int rc = dt_work.Rows.Count;
if (dt_work.Rows.Count == 0)
{
MessageBox.Show("データがありません。");
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");
tb_siire_no.Focus();
return;
}
else
{
dgv_siire.Rows.Clear();
tb_siire_denpyou_no.Text = dt_work.Rows[0][9].ToString();
tb_torihikisaki_cd.Text = dt_work.Rows[0][2].ToString();
tb_torihikisaki_name.Text = tss.get_torihikisaki_name(tb_torihikisaki_cd.Text);
dtp_siire_date.Value = DateTime.Parse(dt_work.Rows[0][3].ToString());
tb_create_user_cd.Text = dt_work.Rows[0][14].ToString();
tb_create_datetime.Text = dt_work.Rows[0][15].ToString();
tb_update_user_cd.Text = dt_work.Rows[0][16].ToString();
tb_update_datetime.Text = dt_work.Rows[0][17].ToString();
for (int i = 0; i < rc; i++)
{
dgv_siire.Rows.Add();
dgv_siire.Rows[i].Cells[0].Value = dt_work.Rows[i][4].ToString();
dgv_siire.Rows[i].Cells[1].Value = dt_work.Rows[i][5].ToString();
dgv_siire.Rows[i].Cells[2].Value = dt_work.Rows[i][6].ToString();
dgv_siire.Rows[i].Cells[3].Value = dt_work.Rows[i][7].ToString();
dgv_siire.Rows[i].Cells[4].Value = dt_work.Rows[i][8].ToString();
dgv_siire.Rows[i].Cells[5].Value = dt_work.Rows[i][10].ToString();
dgv_siire.Rows[i].Cells[6].Value = dt_work.Rows[i][11].ToString();
dgv_siire.Rows[i].Cells[7].Value = dt_work.Rows[i][12].ToString();
}
}
}
}
private void tb_torihikisaki_cd_Validating(object sender, CancelEventArgs e)
{
tb_torihikisaki_name.Text = tss.get_torihikisaki_name(tb_torihikisaki_cd.Text);
}
private void make_insatu_data()
{
DataTable w_dt = new DataTable(); //生産スケジュール用
DataTable w_dt_bikou = new DataTable(); //備考用
DataRow w_dr; //書込み用
//画面の条件からsqlを作成しデータを抽出
string[] sql_where = new string[7];
int sql_cnt = 0;
//部署
if (tb_busyo_cd.Text != "" && tb_busyo_cd.Text != "")
{
sql_where[sql_cnt] = "busyo_cd = '" + tb_busyo_cd.Text.ToString() + "'";
sql_cnt++;
}
//工程
if (tb_koutei_cd.Text != "" && tb_koutei_cd.Text != "")
{
sql_where[sql_cnt] = "koutei_cd = '" + tb_koutei_cd.Text.ToString() + "'";
sql_cnt++;
}
//ライン
if (tb_line_cd.Text != "" && tb_line_cd.Text != "")
{
sql_where[sql_cnt] = "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 + "' ";
for (int i = 1; i <= sql_cnt; i++)
{
if (i >= 1)
{
sql = sql + " and ";
}
sql = sql + sql_where[i - 1];
}
w_dt = tss.OracleSelect(sql);
//画面条件分のデータの指示書印刷データを作成する
DateTime w_datetime;
foreach (DataRow loop_dr in w_dt.Rows)
{
w_dr = w_dt_meisai.NewRow();
//作業日
w_dr["seisan_yotei_date"] = loop_dr["seisan_yotei_date"].ToString();
//順番（ページ数）
w_dr["seq1"] = loop_dr["seq"].ToString();
//順番（総ページ数）
w_dr["seq2"] = get_page_count(loop_dr["seisan_yotei_date"].ToString(), loop_dr["busyo_cd"].ToString(), loop_dr["koutei_cd"].ToString(), loop_dr["line_cd"].ToString());
//部署コード
w_dr["busyo_cd"] = loop_dr["busyo_cd"].ToString();
//部署名
w_dr["busyo_name"] = tss.get_busyo_name(loop_dr["busyo_cd"].ToString());
//工程コード
w_dr["koutei_cd"] = loop_dr["koutei_cd"].ToString();
//工程名
w_dr["koutei_name"] = tss.get_koutei_name(loop_dr["koutei_cd"].ToString());
//ラインコード
w_dr["line_cd"] = loop_dr["line_cd"].ToString();
//ライン名
w_dr["line_name"] = tss.get_line_name(loop_dr["line_cd"].ToString());
//生産工程のseq_no
w_dr["seq_no1"] = get_seq_no1(loop_dr["seihin_cd"].ToString(), loop_dr["busyo_cd"].ToString(), loop_dr["koutei_cd"].ToString());
//生産工程のseq_noのmax
w_dr["seq_no2"] = get_seq_no2(loop_dr["seihin_cd"].ToString());
//取引先コード
w_dr["torihikisaki_cd"] = loop_dr["torihikisaki_cd"].ToString();
//受注コード１
w_dr["juchu_cd1"] = loop_dr["juchu_cd1"].ToString();
//受注コード２
w_dr["juchu_cd2"] = loop_dr["juchu_cd2"].ToString();
//受注数
w_dr["juchu_su"] = loop_dr["juchu_su"].ToString();
//取引先名
w_dr["torihikisaki_name"] = tss.get_torihikisaki_name(loop_dr["torihikisaki_cd"].ToString());
//製品コード
w_dr["seihin_cd"] = loop_dr["seihin_cd"].ToString();
//製品名
w_dr["seihin_name"] = loop_dr["seihin_name"].ToString();
//生産機種
w_dr["seisankisyu"] = loop_dr["seisankisyu"].ToString();
//メンバー
//現時点メンバーは未対応として、空白で印字
w_dr["member01"] = "";
w_dr["member02"] = "";
w_dr["member03"] = "";
w_dr["member04"] = "";
w_dr["member05"] = "";
w_dr["member06"] = "";
w_dr["member07"] = "";
w_dr["member08"] = "";
w_dr["member09"] = "";
w_dr["member10"] = "";
w_dr["member11"] = "";
w_dr["member12"] = "";
//備考
w_dr["bikou"] = loop_dr["bikou"].ToString();
//備考に受注マスタのbikouとbikou2を追加する
w_dt_bikou = tss.OracleSelect("select * from tss_juchu_m where torihikisaki_cd = '" + loop_dr["torihikisaki_cd"].ToString() + "' and juchu_cd1 = '" + loop_dr["juchu_cd1"].ToString() + "' and juchu_cd2 = '" + loop_dr["juchu_cd2"].ToString() + "'");
if (w_dt_bikou.Rows.Count <= 0)
{
//受注が存在しない場合
}
else
{
w_dr["bikou"] = w_dr["bikou"] + " " + w_dt_bikou.Rows[0]["bikou2"].ToString();
}
//タクトタイム
w_dr["tact_time"] = loop_dr["tact_time"].ToString();
//段取工数
w_dr["dandori_kousu"] = loop_dr["dandori_kousu"].ToString();
//追加工数
w_dr["tuika_kousu"] = loop_dr["tuika_kousu"].ToString();
//補充工数
w_dr["hoju_kousu"] = loop_dr["hoju_kousu"].ToString();
//生産済み数
w_dr["seisan_sumi_su"] = get_seisan_sumi_su(loop_dr["torihikisaki_cd"].ToString(), loop_dr["juchu_cd1"].ToString(), loop_dr["juchu_cd2"].ToString(), loop_dr["koutei_cd"].ToString());
//生産数（指示数）
w_dr["seisan_su"] = loop_dr["seisan_su"].ToString();
//生産時間
w_dr["seisan_time"] = loop_dr["seisan_time"].ToString();
//開始時刻
if (DateTime.TryParse(loop_dr["start_time"].ToString(), out w_datetime))
{
//正常な値
w_dr["start_time"] = w_datetime.ToShortTimeString();
}
else
{
//日時として認識できない場合は空白にする
w_dr["start_time"] = "";
}
//終了時刻
if (DateTime.TryParse(loop_dr["end_time"].ToString(), out w_datetime))
{
//正常な値
w_dr["end_time"] = w_datetime.ToShortTimeString();
}
else
{
//日時として認識できない場合は空白にする
w_dr["end_time"] = "";
}
//前回の不適合
//現時点で未対応の為、空白にする
w_dr["hinsitu_zenkai_name1"] = "";
w_dr["hinsitu_zenkai_su1"] = "";
w_dr["hinsitu_zenkai_name2"] = "";
w_dr["hinsitu_zenkai_su2"] = "";
w_dr["hinsitu_zenkai_name3"] = "";
w_dr["hinsitu_zenkai_su3"] = "";
w_dr["hinsitu_zenkai_name4"] = "";
w_dr["hinsitu_zenkai_su4"] = "";
w_dr["hinsitu_zenkai_name5"] = "";
w_dr["hinsitu_zenkai_su5"] = "";
w_dr["hinsitu_zenkai_name6"] = "";
w_dr["hinsitu_zenkai_su6"] = "";
//過去の不適合
//現時点で未対応の為、空白にする
w_dr["hinsitu_kako_name1"] = "";
w_dr["hinsitu_kako_su1"] = "";
w_dr["hinsitu_kako_name2"] = "";
w_dr["hinsitu_kako_su2"] = "";
w_dr["hinsitu_kako_name3"] = "";
w_dr["hinsitu_kako_su3"] = "";
w_dr["hinsitu_kako_name4"] = "";
w_dr["hinsitu_kako_su4"] = "";
w_dr["hinsitu_kako_name5"] = "";
w_dr["hinsitu_kako_su5"] = "";
w_dr["hinsitu_kako_name6"] = "";
w_dr["hinsitu_kako_su6"] = "";
//バーコード（指示書のバーコード識別文字はSJ1とし、各項目をdbと同じ桁数の文字列にして連結させる）（BC読込後に加工無しでdbへアクセスできるように考慮）
w_dr["barcode"] = "SJ1"
+ tss.StringMidByte(loop_dr["seisan_yotei_date"].ToString() + " ", 0, 10)
+ tss.StringMidByte(loop_dr["busyo_cd"].ToString() + " ", 0, 4)
+ tss.StringMidByte(loop_dr["koutei_cd"].ToString() + " ", 0, 3)
+ tss.StringMidByte(loop_dr["line_cd"].ToString() + " ", 0, 3)
+ tss.StringMidByte(loop_dr["seq"].ToString() + " ", 0, 3)
+ tss.StringMidByte(loop_dr["torihikisaki_cd"].ToString() + " ", 0, 6)
+ tss.StringMidByte(loop_dr["juchu_cd1"].ToString() + " ", 0, 16)
+ tss.StringMidByte(loop_dr["juchu_cd2"].ToString() + " ", 0, 16)
;
w_dt_meisai.Rows.Add(w_dr);
}
}
private void tb_siire_no_Validating(object sender, CancelEventArgs e)
{
if (tss.Check_String_Escape(tb_siire_no.Text) == false)
{
e.Cancel = true;
return;
}
//入力された売上番号を"0000000000"形式の文字列に変換
decimal w_decimal;
if (decimal.TryParse(tb_siire_no.Text.ToString(), out w_decimal))
{
tb_siire_no.Text = w_decimal.ToString("0000000000");
}
else
{
MessageBox.Show("仕入番号に異常があります。");
tb_siire_no.Focus();
}
//新規か既存かの判定
if (tb_siire_no.Text.ToString() == w_siire_no.ToString("0000000000"))
{
//新規
//dgvに空のデータを表示するためのダミー抽出
//DataTable dt_work = new DataTable();
//dt_work = tss.OracleSelect("select * from tss_uriage_m where uriage_no = '" + tb_siire_no.Text.ToString() + "' order by uriage_no asc,seq asc");
////uriage_sinki(w_dt);
}
else
{
//既存仕入の表示
DataTable dt_work = new DataTable();
dt_work = tss.OracleSelect("select siire_no, seq,torihikisaki_cd, siire_date,buhin_cd,buhin_name,siire_su,siire_tanka,siire_kingaku,siire_denpyo_no,TO_CHAR(siire_simebi, 'YYYY/MM/DD'),TO_CHAR(siharai_date, 'YYYY/MM/DD'),bikou,DELETE_FLG,create_user_cd,create_datetime,update_user_cd,update_datetime from tss_siire_m where siire_no = '" + tb_siire_no.Text.ToString() + "' ORDER BY SEQ");
int rc = dt_work.Rows.Count;
if (dt_work.Rows.Count == 0)
{
MessageBox.Show("データがありません。");
dt_work = null;
dgv_siire.DataSource = dt_work;
//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");
tb_siire_no.Focus();
return;
}
else
{
//dgv_siire.Rows.Clear();
tb_siire_denpyou_no.Text = dt_work.Rows[0][9].ToString();
tb_torihikisaki_cd.Text = dt_work.Rows[0][2].ToString();
tb_torihikisaki_name.Text = tss.get_torihikisaki_name(tb_torihikisaki_cd.Text);
dtp_siire_date.Value = DateTime.Parse(dt_work.Rows[0][3].ToString());
tb_create_user_cd.Text = dt_work.Rows[0][14].ToString();
tb_create_datetime.Text = dt_work.Rows[0][15].ToString();
tb_update_user_cd.Text = dt_work.Rows[0][16].ToString();
tb_update_datetime.Text = dt_work.Rows[0][17].ToString();
dt_work.Columns.Remove("torihikisaki_cd");
dt_work.Columns.Remove("siire_no");
dt_work.Columns.Remove("seq");
dt_work.Columns.Remove("siire_date");
dt_work.Columns.Remove("delete_flg");
dt_work.Columns.Remove("siire_denpyo_no");
dt_work.Columns.Remove("create_user_cd");
dt_work.Columns.Remove("create_datetime");
dt_work.Columns.Remove("update_user_cd");
dt_work.Columns.Remove("update_datetime");
dgv_siire.DataSource = dt_work;
dgv_siire_disp();
}
}
}
private void tb_nyukin_no_Validating(object sender, CancelEventArgs e)
{
if (tss.Check_String_Escape(tb_nyukin_no.Text) == false)
{
e.Cancel = true;
return;
}
//入力された売上番号を"0000000000"形式の文字列に変換
decimal w_decimal;
if (decimal.TryParse(tb_nyukin_no.Text.ToString(), out w_decimal))
{
//nyukin_no_disp();
tb_nyukin_no.Text = w_decimal.ToString("0000000000");
}
else
{
MessageBox.Show("入金番号に異常があります。");
tb_nyukin_no.Focus();
}
//新規か既存かの判定
if (tb_nyukin_no.Text.ToString() == w_nyukin_no.ToString("0000000000"))
{
//新規
//dgvに空のデータを表示するためのダミー抽出
DataTable dt_work = new DataTable();
dt_work.Columns.Add("nyukin_kbn");
dt_work.Columns.Add("nyukin_kbn_name");
dt_work.Columns.Add("nyukingaku");
dt_work.Columns.Add("bikou");
dgv_m.DataSource = dt_work;
dgv_m_disp();
//nyukin_sinki(dt_work);
}
else
{
//既存入金の表示
DataTable dt_work = new DataTable();
dt_work = tss.OracleSelect("select * from tss_nyukin_m where nyukin_no = '" + tb_nyukin_no.Text.ToString() + "' ORDER BY SEQ");
int rc = dt_work.Rows.Count;
if (dt_work.Rows.Count == 0)
{
MessageBox.Show("データがありません。");
dt_work = null;
dgv_m.DataSource = dt_work;
tb_nyukin_no.Text = w_nyukin_no.ToString("0000000000");
tb_nyukin_no.Focus();
//画面の項目をクリア
tb_torihikisaki_cd.Text = "";
tb_torihikisaki_name.Text = "";
tb_nyukin_date.Text = "";
tb_create_user_cd.Text = "";
tb_create_datetime.Text = "";
tb_update_user_cd.Text = "";
tb_update_datetime.Text = "";
tb_nyukin_goukei.Text = "";
return;
}
else
{
tb_torihikisaki_cd.Text = dt_work.Rows[0][2].ToString();
tb_torihikisaki_name.Text = tss.get_torihikisaki_name(tb_torihikisaki_cd.Text);
tb_nyukin_date.Text = DateTime.Parse(dt_work.Rows[0][4].ToString()).ToShortDateString();
tb_create_user_cd.Text = dt_work.Rows[0][7].ToString();
tb_create_datetime.Text = dt_work.Rows[0][8].ToString();
tb_update_user_cd.Text = dt_work.Rows[0][9].ToString();
tb_update_datetime.Text = dt_work.Rows[0][10].ToString();
dt_work.Columns.Remove("nyukin_no");
dt_work.Columns.Remove("seq");
dt_work.Columns.Remove("torihikisaki_cd");
dt_work.Columns.Remove("nyukin_date");
//dt_work.Columns.Add("nyukin_kbn_name");
dt_work.Columns.Remove("create_user_cd");
dt_work.Columns.Remove("create_datetime");
dt_work.Columns.Remove("update_user_cd");
dt_work.Columns.Remove("update_datetime");
dt_work.Columns.Add("nyukin_kbn_name", Type.GetType("System.String")).SetOrdinal(1);
for (int i = 0; i < rc; i++)
{
if (dt_work.Rows[i][0].ToString() == "1")
{
dt_work.Rows[i][1] = "振込";
}
if (dt_work.Rows[i][0].ToString() == "2")
{
dt_work.Rows[i][1] = "手形";
}
if (dt_work.Rows[i][0].ToString() == "3")
{
dt_work.Rows[i][1] = "現金";
}
if (dt_work.Rows[i][0].ToString() == "4")
{
dt_work.Rows[i][1] = "手数料";
}
if (dt_work.Rows[i][0].ToString() == "5")
{
dt_work.Rows[i][1] = "相殺";
}
}
dgv_m.DataSource = dt_work;
decimal goukei = decimal.Parse(dt_work.Compute("SUM(nyukingaku)", null).ToString());
tb_nyukin_goukei.Text = goukei.ToString("#,0##");
if (tb_nyukin_goukei.Text == "")
{
nyukin_goukei_w = 0;
}
else
{
nyukin_goukei_w = decimal.Parse(tb_nyukin_goukei.Text.ToString());
}
}
}
dgv_m_disp();
}
