///<summary> ///addTanaoroshi ///テキストボックス内のデータをDBに登録 ///作成者:大河内 ///作成日:2017/3/10 ///更新者:大河内 ///更新日:2017/3/22 ///カラム論理名 ///</summary> private void addTanaoroshi() { if (blnDataCheckAdd() != true) { return; } TanaorosiInput_B tanaorosiinputB = new TanaorosiInput_B(); tanaorosiinputB.addTanaoroshi(txtYMD.Text, txtEigyousyo.Text, txtShouhinCD.Text, txtTanasuu.Text, txtTanabanEdit.Text); setViewGrid(); txtTanasuu.Text = ""; txtTanabanEdit.Text = ""; lblDspTanabanEdit.Text = ""; txtChubunruiEdit.Text = ""; lblDspChubunEdit.Text = ""; txtMakerEdit.Text = ""; lblDspMakerEdit.Text = ""; lblDspShouhin.Text = ""; //MessageBox.Show("正常に登録されました。", "登録", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtEigyousyo.Focus(); }
private void TanaorosiInput_Load(object sender, EventArgs e) { //delText(); this.Show(); this._Title = "棚卸入力"; // フォームでもキーイベントを受け取る this.KeyPreview = true; radioButton4.Checked = true; lblDspEigyousyo.TextAlign = ContentAlignment.MiddleLeft; lblDspDaibunrui.TextAlign = ContentAlignment.MiddleLeft; lblDspChubunrui.TextAlign = ContentAlignment.MiddleLeft; lblDspMaker.TextAlign = ContentAlignment.MiddleLeft; lblDspTanaban.TextAlign = ContentAlignment.MiddleLeft; lblDspShouhin.TextAlign = ContentAlignment.MiddleLeft; lblDspTanabanEdit.TextAlign = ContentAlignment.MiddleLeft; lblDspChubunEdit.TextAlign = ContentAlignment.MiddleLeft; lblDspMakerEdit.TextAlign = ContentAlignment.MiddleLeft; txtTanasuu.TextAlign = HorizontalAlignment.Right; txtTyoubosuu.TextAlign = HorizontalAlignment.Right; //DataGridViewの初期設定 dgvSetUp(); //SQLのインスタンス作成 DBConnective dbconnective = new DBConnective(); DataTable dtYMD = new DataTable(); //処理部に移動 TanaorosiInput_B tanaorosiinputB = new TanaorosiInput_B(); dtYMD = tanaorosiinputB.setYMD(); string strYMD = dtYMD.Rows[0]["最新棚卸年月日"].ToString(); txtYMD.Text = strYMD.Substring(0, 10); this.txtYMD.ReadOnly = true; this.txtYMD.Enabled = false; this.txtTyoubosuu.Enabled = false; this.btnF01.Text = STR_FUNC_F1; this.btnF04.Text = STR_FUNC_F4; this.btnF12.Text = STR_FUNC_F12; }
///<summary> ///setSelectItem ///データグリッドビューの処理 ///作成者:大河内 ///作成日:2017/3/15 ///更新者:大河内 ///更新日:2017/4/7 ///カラム論理名 ///</summary> private void setSelectItem() { //データ渡し用 List <string> lstString = new List <string>(); DataTable dtSelect = null; //選択行の商品コード取得 string strSelectSyouhinCD = (string)dgvRireki.CurrentRow.Cells["商品コード"].Value; //データ渡し用 lstString.Add(txtYMD.Text); lstString.Add(strSelectSyouhinCD); //処理部に移動 TanaorosiInput_B tanaorosiinputB = new TanaorosiInput_B(); //戻り値のDatatableを取り込む dtSelect = tanaorosiinputB.setSelectItem(lstString); //各ラベル,テキストボックスに記入 txtShouhinCD.Text = strSelectSyouhinCD; txtChubunruiEdit.Text = dtSelect.Rows[0]["中分類コード"].ToString(); txtTanabanEdit.Text = dtSelect.Rows[0]["棚番"].ToString(); txtMakerEdit.Text = dtSelect.Rows[0]["メーカーコード"].ToString(); lblDspShouhin.Text = dtSelect.Rows[0]["品名型番"].ToString(); //文字列をDecimal型に変換、小数点以下を削除 decimal decElemTanasu = Math.Floor(decimal.Parse(dtSelect.Rows[0]["棚卸数量"].ToString())); decimal decElemShitei = Math.Floor(decimal.Parse(dtSelect.Rows[0]["指定日在庫"].ToString())); //各テキストボックスに記入 txtTanasuu.Text = decElemTanasu.ToString(); txtTyoubosuu.Text = decElemShitei.ToString(); txtTanabanEdit.Focus(); txtChubunruiEdit.Focus(); txtMakerEdit.Focus(); txtKensaku.Focus(); txtTanasuu.Focus(); }
///<summary> ///setViewGrid ///Gridを表示させる ///作成者:大河内 ///作成日:2017/3/10 ///更新者:大河内 ///更新日:2017/4/6 ///カラム論理名 ///</summary> private void setViewGrid() { //データ渡し用 List <string> lstString = new List <string>(); strDaibunruiCD = null; strDaibunruiCD = txtDaibunrui.Text; DataTable dtView = new DataTable(); dgvRireki.Enabled = true; string strBtnJud = "0"; if (radioButton1.Checked == true) { strBtnJud = "1"; } else if (radioButton2.Checked == true) { strBtnJud = "2"; } else if (radioButton3.Checked == true) { strBtnJud = "3"; } else if (radioButton4.Checked == true) { strBtnJud = "4"; } //データ渡し用 lstString.Add(txtYMD.Text); lstString.Add(txtEigyousyo.Text); lstString.Add(txtDaibunrui.Text); lstString.Add(txtChubunrui.Text); lstString.Add(txtMaker.Text); lstString.Add(txtTanaban.Text); lstString.Add(strBtnJud); //処理部に移動 TanaorosiInput_B tanaorosiinputB = new TanaorosiInput_B(); //戻り値のDatatableを取り込む dtView = tanaorosiinputB.setViewGrid(lstString); //指定日在庫、棚卸数量の小数点切り下げ for (int cnt = 0; cnt < dtView.Rows.Count; cnt++) { decimal decTyoubosuu = Math.Floor(decimal.Parse(dtView.Rows[cnt]["棚卸数量"].ToString())); dtView.Rows[cnt]["棚卸数量"] = decTyoubosuu.ToString(); decimal decTanasuu = Math.Floor(decimal.Parse(dtView.Rows[cnt]["指定日在庫"].ToString())); dtView.Rows[cnt]["指定日在庫"] = decTanasuu.ToString(); } dgvRireki.DataSource = dtView; if (dgvRireki.RowCount > 0) { dgvRireki.Focus(); } else { btnViewGrid.Focus(); } lblRecords.Text = "該当件数:" + dgvRireki.RowCount.ToString(); txtShouhinCD.Text = ""; txtTanasuu.Text = ""; txtTanabanEdit.Text = ""; lblDspTanabanEdit.Text = ""; blnEditting = false; }
///<summary> ///txtGridViewLieave ///code入力箇所からフォーカスが外れた時(Grid表示関係) ///作成者:大河内 ///作成日:2017/3/14 ///更新者:大河内 ///更新日:2017/4/6 ///カラム論理名 ///</summary> private void txtGridViewLieave(object sender, EventArgs e, int intDBjud) { //データ渡し用 List <string> lstString = new List <string>(); //初期化 strSQL = ""; //SQL出力後のデータテーブル DataTable dtSetData = null; //フォーカス時に空白の場合そのままスルー if (txtEigyousyo.Text == "" && intDBjud == 1) { return; } else if (txtDaibunrui.Text == "" && intDBjud == 2) { return; } else if (txtChubunrui.Text == "" && intDBjud == 3) { return; } else if (txtMaker.Text == "" && intDBjud == 4) { return; } else if (txtTanaban.Text == "" && intDBjud == 5) { return; } else if (txtChubunruiEdit.Text == "" && intDBjud == 6) { return; } else if (txtMakerEdit.Text == "" && intDBjud == 7) { return; } else if (txtTanabanEdit.Text == "" && intDBjud == 8) { return; } //データ渡し用 lstString.Add(txtEigyousyo.Text); lstString.Add(txtDaibunrui.Text); lstString.Add(txtChubunrui.Text); lstString.Add(txtMaker.Text); lstString.Add(txtTanaban.Text); lstString.Add(txtChubunruiEdit.Text); lstString.Add(txtMakerEdit.Text); lstString.Add(txtTanabanEdit.Text); //処理部に移動 TanaorosiInput_B tanaorosiinputB = new TanaorosiInput_B(); //戻り値のDatatableを取り込む dtSetData = tanaorosiinputB.txtGridViewLieave(intDBjud, lstString); if (dtSetData.Rows.Count != 0) { switch (intDBjud) { case 1: //営業所 txtEigyousyo.Text = dtSetData.Rows[0]["営業所コード"].ToString(); lblDspEigyousyo.Text = dtSetData.Rows[0]["営業所名"].ToString(); txtDaibunrui.Focus(); break; case 2: //大分類 txtDaibunrui.Text = dtSetData.Rows[0]["大分類コード"].ToString(); lblDspDaibunrui.Text = dtSetData.Rows[0]["大分類名"].ToString(); txtChubunrui.Focus(); break; case 3: //中分類 txtChubunrui.Text = dtSetData.Rows[0]["中分類コード"].ToString(); lblDspChubunrui.Text = dtSetData.Rows[0]["中分類名"].ToString(); txtMaker.Focus(); break; case 4: //メーカー txtMaker.Text = dtSetData.Rows[0]["メーカーコード"].ToString(); lblDspMaker.Text = dtSetData.Rows[0]["メーカー名"].ToString(); txtTanaban.Focus(); break; case 5: //棚番 txtTanaban.Text = dtSetData.Rows[0]["棚番"].ToString(); lblDspTanaban.Text = dtSetData.Rows[0]["棚番名"].ToString(); txtKensaku.Focus(); break; case 6: //編集中分類 txtChubunruiEdit.Text = dtSetData.Rows[0]["中分類コード"].ToString(); lblDspChubunEdit.Text = dtSetData.Rows[0]["中分類名"].ToString(); txtMakerEdit.Focus(); break; case 7: //編集メーカー txtMakerEdit.Text = dtSetData.Rows[0]["メーカーコード"].ToString(); lblDspMakerEdit.Text = dtSetData.Rows[0]["メーカー名"].ToString(); btnF01.Focus(); break; case 8: //編集棚番 txtTanabanEdit.Text = dtSetData.Rows[0]["棚番"].ToString(); lblDspTanabanEdit.Text = dtSetData.Rows[0]["棚番名"].ToString(); txtChubunruiEdit.Focus(); break; default: return; } //初期化 intDBjud = 0; //SendKeys.Send("{TAB}"); } else { switch (intDBjud) { case 1: //営業所 lblDspEigyousyo.Text = ""; txtEigyousyo.Focus(); break; case 2: //大分類 lblDspDaibunrui.Text = ""; txtDaibunrui.Focus(); break; case 3: //中分類 lblDspChubunrui.Text = ""; txtChubunrui.Focus(); break; case 4: //メーカー lblDspMaker.Text = ""; txtMaker.Focus(); break; case 5: //棚番 lblDspTanaban.Text = ""; return; case 6: //編集中分類 lblDspChubunEdit.Text = ""; txtChubunruiEdit.Focus(); break; case 7: //編集メーカー lblDspMakerEdit.Text = ""; txtMakerEdit.Focus(); break; case 8: //編集棚番 lblDspTanabanEdit.Text = ""; txtTanabanEdit.Focus(); break; default: return; } MessageBox.Show("入力された文字列が正しくありません。", "入力項目", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }