public void Execute(object parameter) { try { CellCommandParameter cellCommandParameter = (CellCommandParameter)parameter; if (cellCommandParameter.Area == SpreadArea.Cells && cellCommandParameter.CellPosition.Row >= 0 && cellCommandParameter.CellPosition.Row < this._gcSpreadGrid.Rows.Count ) { int rowNo = cellCommandParameter.CellPosition.Row; var row = this._gcSpreadGrid.Rows[rowNo]; var sNo = row.Cells[this._gcSpreadGrid.Columns["車輌コード"].Index].Value; var sNe = row.Cells[this._gcSpreadGrid.Columns["年月"].Index].Value; var sTe = row.Cells[this._gcSpreadGrid.Columns["点検日"].Index].Value; var wnd = GetWindow(this._gcSpreadGrid); if ((int?)sNo != null && (int?)sNe != null) { SRY22020 frm = new SRY22020(); frm.初期車輌コード = (int?)sNo; frm.初期作成年月 = (int?)sNe; frm.初期点検日 = (int?)sTe; frm.ShowDialog(wnd); } } } catch (Exception ex) { } finally { this._gcSpreadGrid.IsEnabled = true; } }
public void Execute(object parameter) { CellCommandParameter cellCommandParameter = (CellCommandParameter)parameter; if (cellCommandParameter.Area == SpreadArea.Cells) { int rowNo = cellCommandParameter.CellPosition.Row; var row = this._gcSpreadGrid.Rows[rowNo]; var 品番コード = row.Cells[GridColumnsMapping.品番コード.GetHashCode()].Value; // 未設定行の場合は処理しない if (品番コード == null || string.IsNullOrEmpty(品番コード.ToString())) { return; } throw new NotImplementedException("画面未実装"); //var p商品ID = row.Cells[this._gcSpreadGrid.Columns["商品ID"].Index].Value; //var p入庫日 = row.Cells[this._gcSpreadGrid.Columns["str入庫日"].Index].Value; //var p保管料計算開始日 = row.Cells[this._gcSpreadGrid.Columns["str保管料計算開始日"].Index].Value; //var p賞味期限 = row.Cells[this._gcSpreadGrid.Columns["str賞味期限"].Index].Value; //var pロケーション番号 = row.Cells[this._gcSpreadGrid.Columns["ロケーション"].Index].Value; //var pロット番号 = row.Cells[this._gcSpreadGrid.Columns["ロット番号"].Index].Value; //var p得意先コード = row.Cells[this._gcSpreadGrid.Columns["得意先コード"].Index].Value; //var wnd = GetWindow(this._gcSpreadGrid); //var query = this._gcSpreadGrid.ItemsSource; //DateTime Wk; //DateTime? d入庫日, d賞味期限; //d入庫日 = p入庫日 == null ? (DateTime?)null : DateTime.TryParse(p入庫日.ToString(), out Wk) ? Wk : (DateTime?)null; //d賞味期限 = p賞味期限 == null ? (DateTime?)null : DateTime.TryParse(p賞味期限.ToString(), out Wk) ? Wk : (DateTime?)null; //var innercmd在庫詳細 = typeof(DLY31010.cmd在庫詳細); //var outercmd在庫詳細 = innercmd在庫詳細.DeclaringType; //DLY31020 frm = new DLY31020(); //frm.在庫参照元 = 1; //frm.在庫商品ID = p商品ID == null ? string.Empty : (string)p商品ID; //frm.在庫入庫日 = d入庫日; //frm.在庫保管料計算開始日 = (DateTime?)null; //frm.在庫賞味期限 = d賞味期限; //frm.在庫ロケーション番号 = pロケーション番号 == null ? string.Empty : (string)pロケーション番号; //frm.在庫ロット番号 = pロット番号 == null ? string.Empty : (string)pロット番号; //frm.得意先コード = (int?)p得意先コード; //frm.在庫行番号 = (int?)rowNo; //frm.出庫データ = query; //frm.ShowDialog(wnd); //this._gcSpreadGrid.Columns["在庫照会"].Focusable = false; } }
/// <summary> /// 確定ボタン押下 /// </summary> /// <param name="parameter"></param> public void Execute(object parameter) { CellCommandParameter cellCommandParameter = (CellCommandParameter)parameter; var parent = ViewBaseCommon.FindVisualParent <TKS90010>(this._gcSpreadGrid); string msg = string.Empty; if (cellCommandParameter.Area == SpreadArea.Cells) { int rowNo = cellCommandParameter.CellPosition.Row; var row = this._gcSpreadGrid.Rows[rowNo]; var fixKbn = row.Cells[(int)GridColumnsMapping.確定区分].Value; var fixDay = row.Cells[(int)GridColumnsMapping.確定日].Value; var closeDay = row.Cells[(int)GridColumnsMapping.締日].Value; var toriKbn = row.Cells[(int)GridColumnsMapping.取引区分ID].Value; var toriKbnNm = row.Cells[(int)GridColumnsMapping.取引区分].Value; var jisCode = row.Cells[(int)GridColumnsMapping.自社コード].Value; // エラー情報をクリア row.ValidationErrors.Clear(); if (fixDay == null || fixDay.ToString() == DEFAULT_YYMMDD) { msg = "確定日を設定してください。"; CellPosition cp = new CellPosition(rowNo, GridColumnsMapping.確定日.GetHashCode()); this._gcSpreadGrid[cp].ValidationErrors.Add(new SpreadValidationError(msg, null)); MessageBox.Show(msg); return; } if (MessageBox.Show( string.Format("{0}日締の{1}を {2} で確定登録します。\n確定日以前の伝票は編集できなくなります。\nよろしいですか?" , closeDay.ToString() , toriKbnNm.ToString() , fixDay.ToString()), "登録確認", MessageBoxButton.YesNo, MessageBoxImage.Question, MessageBoxResult.Yes) == MessageBoxResult.No) { return; } // 登録処理を呼び出し parent.UpdateTableData(jisCode.ToString(), fixKbn.ToString(), closeDay.ToString(), fixDay.ToString(), toriKbn.ToString()); } }
public void Execute(object parameter) { CellCommandParameter cellCommandParameter = (CellCommandParameter)parameter; if (cellCommandParameter.Area == SpreadArea.Cells) { int rowNo = cellCommandParameter.CellPosition.Row; var row = this._gcSpreadGrid.Rows[rowNo]; var wnd = GetWindow(this._gcSpreadGrid); var a = row.Cells[this._gcSpreadGrid.Columns["開始日付1"].Index].CellType; var b = row.Cells[this._gcSpreadGrid.Columns["開始日付2"].Index].CellType; row.Cells[this._gcSpreadGrid.Columns["開始日付1"].Index].Value = row.Cells[this._gcSpreadGrid.Columns["クリア開始日付"].Index].Value; row.Cells[this._gcSpreadGrid.Columns["終了日付1"].Index].Value = row.Cells[this._gcSpreadGrid.Columns["クリア終了日付"].Index].Value; row.Cells[this._gcSpreadGrid.Columns["開始日付2"].Index].Value = DBNull.Value; row.Cells[this._gcSpreadGrid.Columns["終了日付2"].Index].Value = DBNull.Value; row.Cells[this._gcSpreadGrid.Columns["開始日付3"].Index].Value = DBNull.Value; row.Cells[this._gcSpreadGrid.Columns["終了日付3"].Index].Value = DBNull.Value; } }
public void Execute(object parameter) { try { this._gcSpreadGrid.IsEnabled = false; CellCommandParameter cellCommandParameter = (CellCommandParameter)parameter; if (cellCommandParameter.Area == SpreadArea.Cells && cellCommandParameter.CellPosition.Row >= 0 && cellCommandParameter.CellPosition.Row < this._gcSpreadGrid.Rows.Count ) { this._gcSpreadGrid.SelectedItems.Remove(cellCommandParameter.CellPosition.Row); this._gcSpreadGrid.Rows.Remove(cellCommandParameter.CellPosition.Row); } } catch (Exception ex) { } finally { this._gcSpreadGrid.IsEnabled = true; } }
public void Execute(object parameter) { CellCommandParameter cellCommandParameter = (CellCommandParameter)parameter; if (cellCommandParameter.Area == SpreadArea.Cells) { int rowNo = cellCommandParameter.CellPosition.Row; var row = this._gcSpreadGrid.Rows[rowNo]; var mNo = row.Cells[this._gcSpreadGrid.Columns["明細番号"].Index].Value; var wnd = GetWindow(this._gcSpreadGrid); DLY09010 frm = new DLY09010(); frm.初期明細番号 = (int?)mNo; frm.ShowDialog(wnd); if (frm.IsUpdated) { // 日報側で更新された場合、再検索を実行する var parent = ViewBaseCommon.FindVisualParent <DLY16010>(this._gcSpreadGrid); parent.Button_Click_1(null, null); } } }
public void Execute(object parameter) { CellCommandParameter cellCommandParameter = (CellCommandParameter)parameter; if (cellCommandParameter.Area == SpreadArea.Cells) { int rowNo = cellCommandParameter.CellPosition.Row; var row = this._gcSpreadGrid.Rows[rowNo]; /* * var wnd = GetWindow(this._gcSpreadGrid); * //表示区分 * int i表示区分 = Convert.ToInt32(this._gcSpreadGrid[rowNo, this._gcSpreadGrid.Columns["表示区分"].Index].Value.ToString()); * string d検索日付FROM = this._gcSpreadGrid[rowNo, this._gcSpreadGrid.Columns["検索日付FROM"].Index].Value.ToString(); * string d検索日付TO = this._gcSpreadGrid[rowNo, this._gcSpreadGrid.Columns["検索日付TO"].Index].Value.ToString(); * * if (i表示区分 == 0) * { * * string s得意先ID = this._gcSpreadGrid[rowNo, this._gcSpreadGrid.Columns["得意先ID"].Index].Value.ToString(); * string s商品ID = this._gcSpreadGrid[rowNo, this._gcSpreadGrid.Columns["商品ID"].Index].Value.ToString(); * * * //商品毎 * DLY39010 frm = new DLY39010(); * frm.初期得意先ID = s得意先ID; * frm.初期商品ID = s商品ID; * frm.初期表示区分 = i表示区分; * frm.初期検索日付From = Convert.ToDateTime(d検索日付FROM).ToShortDateString(); * frm.初期検索日付To = Convert.ToDateTime(d検索日付TO).ToShortDateString(); * frm.ShowDialog(wnd); * } * else if (i表示区分 == 1) * { * * string s得意先ID = this._gcSpreadGrid[rowNo, this._gcSpreadGrid.Columns["得意先ID"].Index].Value.ToString(); * string s商品ID = this._gcSpreadGrid[rowNo, this._gcSpreadGrid.Columns["商品ID"].Index].Value.ToString(); * string sロット = this._gcSpreadGrid[rowNo, this._gcSpreadGrid.Columns["ロット番号"].Index].Value == null ? "" : this._gcSpreadGrid[rowNo, this._gcSpreadGrid.Columns["ロット番号"].Index].Value.ToString(); * * //商品+ロット毎 * DLY39010 frm = new DLY39010(); * frm.初期得意先ID = s得意先ID; * frm.初期商品ID = s商品ID; * frm.初期ロット = sロット; * frm.初期表示区分 = i表示区分; * frm.初期検索日付From = Convert.ToDateTime(d検索日付FROM).ToShortDateString(); * frm.初期検索日付To = Convert.ToDateTime(d検索日付TO).ToShortDateString(); * frm.ShowDialog(wnd); * } * else if (i表示区分 == 2) * { * * string s得意先ID = this._gcSpreadGrid[rowNo, this._gcSpreadGrid.Columns["得意先ID"].Index].Value.ToString(); * string s商品ID = this._gcSpreadGrid[rowNo, this._gcSpreadGrid.Columns["商品ID"].Index].Value.ToString(); * string s倉庫ID = this._gcSpreadGrid[rowNo, this._gcSpreadGrid.Columns["倉庫ID"].Index].Value.ToString(); * * //商品+倉庫 * DLY39010 frm = new DLY39010(); * frm.初期得意先ID = s得意先ID; * frm.初期商品ID = s商品ID; * frm.初期倉庫ID = s倉庫ID; * frm.初期表示区分 = i表示区分; * frm.初期検索日付From = d検索日付FROM; * frm.初期検索日付To = d検索日付TO; * frm.ShowDialog(wnd); * } * else if (i表示区分 == 3) * { * * string s得意先ID = this._gcSpreadGrid[rowNo, this._gcSpreadGrid.Columns["得意先ID"].Index].Value.ToString(); * string s商品ID = this._gcSpreadGrid[rowNo, this._gcSpreadGrid.Columns["商品ID"].Index].Value.ToString(); * string s倉庫ID = this._gcSpreadGrid[rowNo, this._gcSpreadGrid.Columns["倉庫ID"].Index].Value.ToString(); * string sロット = this._gcSpreadGrid[rowNo, this._gcSpreadGrid.Columns["ロット番号"].Index].Value == null ? "" : this._gcSpreadGrid[rowNo, this._gcSpreadGrid.Columns["ロット番号"].Index].Value.ToString(); * string sロケーション = this._gcSpreadGrid[rowNo, this._gcSpreadGrid.Columns["ロケーション"].Index].Value == null ? "" : this._gcSpreadGrid[rowNo, this._gcSpreadGrid.Columns["ロケーション"].Index].Value.ToString(); * * //商品+倉庫 * DLY39010 frm = new DLY39010(); * frm.初期得意先ID = s得意先ID; * frm.初期商品ID = s商品ID; * frm.初期倉庫ID = s倉庫ID; * frm.初期表示区分 = i表示区分; * frm.初期ロケーション = sロケーション; * frm.初期検索日付From = d検索日付FROM; * frm.初期検索日付To = d検索日付TO; * frm.ShowDialog(wnd); * } * else if (i表示区分 == 4) * { * * string s得意先ID = this._gcSpreadGrid[rowNo, this._gcSpreadGrid.Columns["得意先ID"].Index].Value.ToString(); * string s商品ID = this._gcSpreadGrid[rowNo, this._gcSpreadGrid.Columns["商品ID"].Index].Value.ToString(); * string s倉庫ID = this._gcSpreadGrid[rowNo, this._gcSpreadGrid.Columns["倉庫ID"].Index].Value.ToString(); * string sロット = this._gcSpreadGrid[rowNo, this._gcSpreadGrid.Columns["ロット番号"].Index].Value == null ? "" : this._gcSpreadGrid[rowNo, this._gcSpreadGrid.Columns["ロット番号"].Index].Value.ToString(); * string sロケーション = this._gcSpreadGrid[rowNo, this._gcSpreadGrid.Columns["ロケーション"].Index].Value == null ? "" : this._gcSpreadGrid[rowNo, this._gcSpreadGrid.Columns["ロケーション"].Index].Value.ToString(); * * //商品+倉庫+ロット * DLY39010 frm = new DLY39010(); * frm.初期得意先ID = s得意先ID; * frm.初期商品ID = s商品ID; * frm.初期倉庫ID = s倉庫ID; * frm.初期ロット = sロット; * frm.初期ロケーション = sロケーション; * frm.初期表示区分 = i表示区分; * frm.初期検索日付From = d検索日付FROM; * frm.初期検索日付To = d検索日付TO; * frm.ShowDialog(wnd); * } */ } }