/// <summary> /// 検索処理実行 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Search_Click(object sender, RoutedEventArgs e) { try { // DB接続 SqlServer clsSqlServer = new SqlServer(Com01.clsSystemInfo.SystemDatabase); clsSqlServer.Connect(); // マテリアルマスタ検索(共通) Com02.struct_m_material m_material = new Com02.struct_m_material(); m_material.kigyo_code = Com01.clsSystemInfo.ComLineArgs.kigyo_code; m_material.material_code = clsBindData.SearchMaterialCode; m_material.material_name = clsBindData.SearchMaterialName; if (clsBindData.SearchInvalidFlg == true) { m_material.invalid_flg = 1; } clsBindData.MaterialInfo = Com02.Get_m_material(clsSqlServer, m_material, 100); // 画面更新 this.DataContext = clsBindData; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// マテリアルマスタ登録データ設定処理 /// </summary> /// <param name="clsSqlServer"></param> /// <param name="bindingData"></param> /// <returns></returns> private Com02.struct_m_material Set_EntryData(SqlServer clsSqlServer, BindingData bindingData) { // キーを条件に最新データを取得 Com02.struct_m_material m_material = new Com02.struct_m_material(); m_material.kigyo_code = Com01.clsSystemInfo.ComLineArgs.kigyo_code; m_material.material_code = bindingData.MaterialCode; m_material.invalid_flg = 1; // 削除も含めて検索 DataTable dTable = Com02.Get_m_material(clsSqlServer, m_material, 1); // システム日時を取得 Com01.Set_DateTime(clsSqlServer); // 更新日時をセット m_material.koshin_datetime = Com01.clsSystemInfo.dtNow.ToString(); m_material.koshin_user_id = Com01.clsSystemInfo.ComLineArgs.user_id; m_material.koshin_program = Com01.clsSystemInfo.strExeName; // 検索結果 if (dTable == null || dTable.Rows.Count == 0) { // 新規登録日時 m_material.toroku_datetime = m_material.koshin_datetime; m_material.toroku_user_id = m_material.koshin_user_id; m_material.toroku_program = m_material.koshin_program; // 空の場合は規定値を m_material.invalid_flg = 0; } else { DataRow dRow = dTable.Rows[0]; // 取得内容を構造体へ m_material.toroku_datetime = dRow[Com02.struct_m_material.idx_toroku_datetime].ToString(); m_material.toroku_user_id = dRow[Com02.struct_m_material.idx_toroku_user_id].ToString(); m_material.toroku_program = dRow[Com02.struct_m_material.idx_toroku_program].ToString(); m_material.kigyo_code = dRow[Com02.struct_m_material.idx_kigyo_code].ToString(); m_material.material_code = dRow[Com02.struct_m_material.idx_material_code].ToString(); m_material.material_name = dRow[Com02.struct_m_material.idx_material_name].ToString(); m_material.unit_kbn = dRow[Com02.struct_m_material.idx_unit_kbn].ToString(); m_material.type_name = dRow[Com02.struct_m_material.idx_type_name].ToString(); m_material.kikaku_shiyo = dRow[Com02.struct_m_material.idx_kikaku_shiyo].ToString(); m_material.biko = dRow[Com02.struct_m_material.idx_biko].ToString(); m_material.yobi1 = dRow[Com02.struct_m_material.idx_yobi1].ToString(); m_material.yobi2 = dRow[Com02.struct_m_material.idx_yobi2].ToString(); m_material.yobi3 = dRow[Com02.struct_m_material.idx_yobi3].ToString(); m_material.yobi4 = dRow[Com02.struct_m_material.idx_yobi4].ToString(); m_material.yobi5 = dRow[Com02.struct_m_material.idx_yobi5].ToString(); m_material.invalid_flg = int.Parse(dRow[Com02.struct_m_material.idx_invalid_flg].ToString()); } // これに対して画面内容を上書く if (bindingData.InvalidFlg == true) { m_material.invalid_flg = 1; } else { m_material.invalid_flg = 0; } m_material.material_name = bindingData.MaterialName; m_material.unit_kbn = bindingData.UnitKbn; m_material.type_name = bindingData.TypeName; m_material.kikaku_shiyo = bindingData.KikakuShiyo; m_material.biko = bindingData.Biko; return(m_material); }