/// <summary>
/// データ受信メソッド
/// </summary>
/// <param name="message"></param>
public override void OnReceivedResponseData(CommunicationObject message)
{
try
{
var data = message.GetResultData();
if (data is DataTable)
{
DataTable tbl = data as DataTable;
switch (message.GetMessageName())
{
// 通常データ検索
case TargetTableNm:
SetData(tbl);
break;
}
}
else
{
switch (message.GetMessageName())
{
// 更新処理受信
case TargetTableNmUpdate:
if ((int)data == -1)
{
// TODO:リトライ？？？
base.SendRequest(new CommunicationObject(
MessageType.UpdateData,
TargetTableNmUpdate,
new object[] {
MstData,
ccfg.ユーザID
}));
break;
}
MessageBox.Show(AppConst.COMPLETE_UPDATE);
//コントロール初期化
ScreenClear();
break;
// 削除処理受信
case TargetTableNmDelete:
MessageBox.Show(AppConst.COMPLETE_DELETE);
//コントロール初期化
ScreenClear();
break;
default:
break;
}
}
}
catch (Exception ex)
{
this.ErrorMessage = ex.Message;
}
}
public override void OnReceivedResponseData(CommunicationObject message)
{
IsConnected = true;
var data = message.GetResultData();
DataTable tbl = (data is DataTable) ? (data as DataTable) : null;
MSGMAS = tbl;
switch (message.GetMessageName())
{
case GetMSGLIST:
this.viewsCommData.SetupMessageList(tbl);
resMSG = true;
break;
case GetComboList:
(this.viewsCommData.AppData as AppCommonData).codedatacollection = tbl;
resCOMBO = true;
break;
}
if (resMSG)
{
Message += "\r\nデータベースに接続できました。";
Message += "\r\nアプリケーション実行の準備をしています。";
}
if (resMSG && resCOMBO)
{
this.Progress = 100;
base.TimerLoopStop();
Message += "\r\n準備完了しました。";
this.Close();
}
}
/// <summary>
/// 取得データの取り込み
/// </summary>
/// <param name="message"></param>
public override void OnReceivedResponseData(CommunicationObject message)
{
var data = message.GetResultData();
DataTable tbl = (data is DataTable) ? (data as DataTable) : null;
switch (message.GetMessageName())
{
case TabelNm:
if (tbl.Columns.Contains("登録日時"))
{
tbl.Columns.Remove("登録日時");
}
if (tbl.Columns.Contains("更新日時"))
{
tbl.Columns.Remove("更新日時");
}
//Gridのバインド変数に代入
CarData = tbl;
break;
default:
break;
}
}
/// <summary>
/// データ受信メソッド
/// </summary>
/// <param name="message"></param>
public override void OnReceivedResponseData(CommunicationObject message)
{
try
{
base.SetFreeForInput();
var data = message.GetResultData();
if (data is DataTable)
{
DataTable tbl = data as DataTable;
switch (message.GetMessageName())
{
case ACCOUNTS_PAYABLE_PRT:
DispPreviw(tbl);
break;
case ACCOUNTS_PAYABLE_PRT_CSV:
OutPutCSV(tbl);
break;
}
}
}
catch (Exception ex)
{
this.ErrorMessage = ex.Message;
}
}
/// <summary>
/// 取得データの取り込み
/// </summary>
/// <param name="message"></param>
public override void OnReceivedResponseData(CommunicationObject message)
{
var data = message.GetResultData();
DataTable tbl = (data is DataTable) ? (data as DataTable) : null;
switch (message.GetMessageName())
{
case GET_DATA:
base.SetFreeForInput();
if (tbl == null || tbl.Rows.Count == 0)
{
this.ErrorMessage = "該当するデータが見つかりません";
SearchResult = null;
return;
}
SearchResult = tbl;
// フォーカスをSPREADへ
spGridList.Focus();
spGridList.Focusable = true;
spGridList.ActiveCellPosition = new CellPosition(0, 1);
spGridList.ShowCell(0, 1); // No.383 Add
break;
}
}
/// <summary>
/// 取得データの正常受信時のイベント
/// </summary>
/// <param name="message"></param>
public override void OnReceivedResponseData(CommunicationObject message)
{
try
{
var data = message.GetResultData();
DataTable tbl = (data is DataTable) ? (data as DataTable) : null;
switch (message.GetMessageName())
{
//締日プレビュー出力用
case SEARCH_SRY10010:
if (tbl == null || tbl.Rows.Count == 0)
{
this.ErrorMessage = "該当するデータはありません。";
return;
}
DispPreviw(tbl);
break;
//締日CSV出力用
case SEARCH_SRY10010_CSV:
if (tbl == null || tbl.Rows.Count == 0)
{
this.ErrorMessage = "該当するデータはありません。";
return;
}
OutPutCSV(tbl);
break;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 取得データの取り込み
/// </summary>
/// <param name="message"></param>
public override void OnReceivedResponseData(CommunicationObject message)
{
var data = message.GetResultData();
DataTable tbl = (data is DataTable) ? (data as DataTable) : null;
switch (message.GetMessageName())
{
case GET_DATA:
// 検索処理結果受信
base.SetFreeForInput();
if (tbl == null || tbl.Rows.Count == 0)
{
this.ErrorMessage = "該当するデータが見つかりません";
SearchResult = null;
return;
}
SearchResult = tbl;
// グリッド文字色の変更
SetGridColor();
// フォーカスをSPREADへ
spGridList.Focus();
spGridList.Focusable = true;
spGridList.ActiveCellPosition = new CellPosition(0, (int)GridColumnsMapping.庫);
// スクロールバーをもとの位置に戻す
spGridList.ShowCell(0, (int)GridColumnsMapping.庫);
break;
default:
break;
}
}
/// <summary>
/// 取得データの正常受信時のイベント
/// </summary>
/// <param name="message"></param>
public override void OnReceivedResponseData(CommunicationObject message)
{
try
{
var data = message.GetResultData();
DataTable tbl = (data is DataTable) ? (data as DataTable) : null;
switch (message.GetMessageName())
{
//検索結果取得時
case SYUKEI_JMI10010:
base.SetFreeForInput();
MessageBoxResult result = MessageBox.Show("集計が終了しました。\n\r終了しても宜しいでしょうか?"
, "確認"
, MessageBoxButton.YesNo
, MessageBoxImage.Question);
//OKならクリア
if (result == MessageBoxResult.Yes)
{
this.Close();
}
break;
default:
break;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 取得データの正常受信時のイベント
/// </summary>
/// <param name="message"></param>
public override void OnReceivedResponseData(CommunicationObject message)
{
try
{
var data = message.GetResultData();
DataTable tbl = (data is DataTable) ? (data as DataTable) : null;
switch (message.GetMessageName())
{
//締日プレビュー出力用
case SEARCH_SRY12010:
DispPreviw(tbl);
break;
//締日CSV出力用
case SEARCH_SRY12010_CSV:
tbl.Columns.Remove("集計年月From");
tbl.Columns.Remove("集計年月To");
tbl.Columns.Remove("表示順序");
tbl.Columns.Remove("車種指定");
tbl.Columns.Remove("車種ﾋﾟｯｸｱｯﾌﾟ");
OutPutCSV(tbl);
break;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public override void OnReceivedResponseData(CommunicationObject message)
{
var data = message.GetResultData();
DataTable tbl = (data is DataTable) ? (data as DataTable) : null;
// 追加
if (tbl != null)
{
tbl.Columns.Remove("取引停止区分");
tbl.Columns["停止区分"].ColumnName = "取引停止区分";
}
switch (message.GetMessageName())
{
case GetMasterList:
this.MSTData = tbl;
PrintOut();
break;
//CSV出力
case GetMasterList_CSV:
OutPutCSV(tbl);
break;
}
}
/// <summary>
/// 取得データの取り込み
/// </summary>
/// <param name="message"></param>
public override void OnReceivedResponseData(CommunicationObject message)
{
try
{
this.ErrorMessage = string.Empty;
base.SetFreeForInput();
var data = message.GetResultData();
DataTable tbl = (data is DataTable) ? (data as DataTable) : null;
switch (message.GetMessageName())
{
case GET_CSV_LIST:
outputCsv(tbl);
break;
case GET_PRINT_LIST:
outputReport(tbl);
break;
default:
break;
}
}
catch (Exception ex)
{
base.SetFreeForInput();
this.ErrorMessage = ex.Message;
}
}
public override void OnReceivedResponseData(CommunicationObject message)
{
var data = message.GetResultData();
DataTable tbl = (data is DataTable) ? (data as DataTable) : null;
switch (message.GetMessageName())
{
//データ検索
case TargetTableNm:
MSTData = tbl;
break;
//プレビュー出力
case M02_SEARCH_MST19010:
DispPreviw(tbl);
break;
//CSV出力
case M02_SEARCH_MST19010_CSV:
OutPutCSV(tbl);
break;
}
this.MSTData = null;
}
/// <summary>
/// 取得データの取り込み
/// </summary>
/// <param name="message"></param>
public override void OnReceivedResponseData(CommunicationObject message)
{
try
{
this.ErrorMessage = string.Empty;
base.SetFreeForInput();
var data = message.GetResultData();
DataTable tbl = (data is DataTable) ? (data as DataTable) : null;
switch (message.GetMessageName())
{
case BILLING_AGGREGATE:
MessageBoxResult result =
MessageBox.Show(
"集計が終了しました。\n\r終了しても宜しいでしょうか?",
"確認",
MessageBoxButton.YesNo,
MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
this.Close();
}
break;
}
}
catch (Exception ex)
{
this.ErrorMessage = ex.Message;
}
}
/// <summary>
/// 取得データの取り込み
/// </summary>
/// <param name="message"></param>
public override void OnReceivedResponseData(CommunicationObject message)
{
try
{
this.ErrorMessage = string.Empty;
var data = message.GetResultData();
DataTable tbl = (data is DataTable) ? (data as DataTable) : null;
switch (message.GetMessageName())
{
//検索結果取得時
case SEARCH_TKS17010:
if (tbl == null)
{
return;
}
DispPreviw(tbl);
break;
case SEARCH_TKS17010_CSV:
OutPutCSV(tbl);
break;
default:
break;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 取得データの取り込み
/// </summary>
/// <param name="message"></param>
public override void OnReceivedResponseData(CommunicationObject message)
{
try
{
var data = message.GetResultData();
DataTable rptdata = (data is DataTable) ? (data as DataTable) : null;
switch (message.GetMessageName())
{
case "":
break;
}
KyoeiSystem.Framework.Reports.Preview.ReportPreview view
= new KyoeiSystem.Framework.Reports.Preview.ReportPreview();
view.MakeReport("乗務員収支実績表", rptFullPathNameJMI, 0, 0, 0);
view.SetReportData(rptdata);
if (reportSwitch == PreviewOrPrint.Preview)
{
view.ShowPreview();
}
else
{
view.PrintOut();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// データ受信メソッド
/// </summary>
/// <param name="message"></param>
public override void OnReceivedResponseData(CommunicationObject message)
{
try
{
var data = message.GetResultData();
DataTable tbl = data as DataTable;
switch (message.GetMessageName())
{
// No-378 Add Start
case SearchProductData:
if (tbl.Rows.Count == 0)
{
this.ErrorMessage = string.Format("データが登録されていません。");
return;
}
else
{
this.HinbanCode = Convert.ToInt32(tbl.Rows[0]["品番コード"]);
this.COLOR.Text1 = tbl.Rows[0]["自社色"].ToString();
this.HINBAN.Text2 = tbl.Rows[0]["自社品名"].ToString();
}
// 仕入先が未入力なので品番で検索実行
sendSearchForProduct();
break;
// No-378 Add End
case SearchTableToSupplier:
// 仕入先コードで検索された場合
DeletedItem = tbl.Clone();
SetTblData(tbl);
break;
case SearchTableToProduct:
// 品番コードで検索された場合
DeletedItem = tbl.Clone();
SetTblData(tbl);
break;
case MasterCode_Product:
productInfoList = tbl.Copy();
break;
case M02_BAIKA_Update:
MessageBox.Show("登録処理が完了しました", "情報", MessageBoxButton.OK, MessageBoxImage.Information);
//ScreenClear();
break;
default:
break;
}
}
catch (Exception ex)
{
this.ErrorMessage = ex.Message;
}
}
/// <summary>
/// 取得データの正常受信時のイベント
/// </summary>
/// <param name="message"></param>
public override void OnReceivedResponseData(CommunicationObject message)
{
try
{
var data = message.GetResultData();
DataTable tbl = (data is DataTable) ? (data as DataTable) : null;
switch (message.GetMessageName())
{
case GET_CNTL:
this.WarimasiName1 = AppCommon.GetWarimasiName1(tbl);
this.WarimasiName2 = AppCommon.GetWarimasiName2(tbl);
break;
case GET_RPT:
GetReportFile(tbl);
break;
case PUT_RPT:
break;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// データ受信メソッド
/// </summary>
/// <param name="message"></param>
public override void OnReceivedResponseData(CommunicationObject message)
{
try
{
var data = message.GetResultData();
if (data is DataTable)
{
DataTable tbl = data as DataTable;
switch (message.GetMessageName())
{
case SEARCH_TKS07010_PRT:
// 検索結果取得時
DispPreviw(tbl);
break;
case SEARCH_TKS07010_CSV:
OutPutCSV(tbl);
break;
}
}
}
catch (Exception ex)
{
this.ErrorMessage = ex.Message;
}
}
public override void OnReceivedResponseData(CommunicationObject message)
{
base.OnReceivedResponseData(message);
try
{
var data = message.GetResultData();
DataTable tbl = (data is DataTable) ? (data as DataTable) : null;
switch (message.GetMessageName())
{
case "":
break;
}
if (tbl.Rows.Count > 0)
{
RowM01TOK = tbl.Rows[0];
}
else
{
RowM01TOK = null;
}
}
catch (Exception ex)
{
RowM01TOK = null;
this.ErrorMessage = ex.Message;
}
}
/// <summary>
/// 取得データの取り込み
/// </summary>
/// <param name="message"></param>
public override void OnReceivedResponseData(CommunicationObject message)
{
try
{
this.ErrorMessage = string.Empty;
var data = message.GetResultData();
DataTable tbl = (data is DataTable) ? (data as DataTable) : null;
switch (message.GetMessageName())
{
case 一括車輌固定データ取得:
this.一括車輌固定費データ = tbl;
break;
case 一括車輌固定データ更新:
MessageBox.Show("データを更新しました。");
this.Close();
break;
default:
break;
}
}
catch (Exception ex)
{
this.ErrorMessage = ex.Message;
}
}
/// <summary>
/// 取得データの取り込み
/// </summary>
/// <param name="message"></param>
public override void OnReceivedResponseData(CommunicationObject message)
{
try
{
this.ErrorMessage = string.Empty;
base.SetFreeForInput();
var data = message.GetResultData();
DataTable tbl = (data is DataTable) ? (data as DataTable) : null;
switch (message.GetMessageName())
{
case GET_LIST_SEARCH:
if (tbl == null)
{
this.sp請求データ一覧.ItemsSource = null;
this.ErrorMessage = "システムエラーが発生しました。サポートにお問い合わせください。";
return;
}
else
{
if (tbl.Rows.Count > 0)
{
SearchList = tbl;
}
else
{
SearchList = null;
this.ErrorMessage = "指定された条件の請求データはありません。";
}
}
break;
case BILLING_AGGREGATE:
MessageBoxResult result =
MessageBox.Show(
"集計が終了しました。\n\r終了しても宜しいでしょうか?",
"確認",
MessageBoxButton.YesNo,
MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
this.Close();
}
else
{
//検索をクリアして再度実施する時は検索ボタンの押下を促す。
SearchList = null;
}
break;
}
}
catch (Exception ex)
{
this.ErrorMessage = ex.Message;
}
}
/// <summary>
/// 取得データの正常受信時のイベント
/// </summary>
/// <param name="message"></param>
public override void OnReceivedResponseData(CommunicationObject message)
{
try
{
var data = message.GetResultData();
DataTable tbl = (data is DataTable) ? (data as DataTable) : null;
switch (message.GetMessageName())
{
//締日プレビュー出力用
case SEARCH_TKS20010:
DispPreviw(tbl);
break;
//締日CSV出力用
case SEARCH_TKS20010_CSV:
tbl.Columns.Remove("開始日付");
tbl.Columns.Remove("終了日付");
tbl.Columns.Remove("年月");
tbl.Columns.Remove("コードFrom");
tbl.Columns.Remove("コードTo");
tbl.Columns.Remove("ピックアップ指定");
OutPutCSV(tbl);
break;
default:
break;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 取得データの取り込み
/// </summary>
/// <param name="message"></param>
public override void OnReceivedResponseData(CommunicationObject message)
{
var data = message.GetResultData();
DataTable tbl = (data is DataTable) ? (data as DataTable) : null;
switch (message.GetMessageName())
{
case TabelNm:
tbl = getTrimColumns(tbl);
// Gridのバインド変数に代入
DataView view = new DataView(tbl);
StringBuilder sb = new StringBuilder();
if (!string.IsNullOrEmpty(this.txtKana.Text))
{
sb.AppendFormat("{0} LIKE '%{1}%'", COLNAME_NAME, this.txtKana.Text);
}
view.RowFilter = sb.ToString();
SearchResult = view.ToTable();
SearchGrid.SelectedIndex = -1;
break;
default:
break;
}
}
/// <summary>
/// 取得データの正常受信時のイベント
/// </summary>
/// <param name="message"></param>
public override void OnReceivedResponseData(CommunicationObject message)
{
try
{
var data = message.GetResultData();
DataTable tbl = (data is DataTable) ? (data as DataTable) : null;
switch (message.GetMessageName())
{
//検索結果取得時
case SEARCH_JMI03010:
DispPreviw(tbl);
break;
case SEARCH_JMI03010_CSV:
OutPutCSV(tbl);
break;
default:
break;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 取得データの取り込み
/// </summary>
/// <param name="message"></param>
public override void OnReceivedResponseData(CommunicationObject message)
{
var data = message.GetResultData();
DataTable tbl = (data is DataTable) ? (data as DataTable) : null;
switch (message.GetMessageName())
{
//case MST20011_GetMasterDataSet:
// if (data is DataSet)
// {
// MasterDataSet = data as DataSet;
// }
// break;
case MST19011_GetData:
base.SetFreeForInput();
if (tbl.Rows.Count > 0)
{
SearchResult = tbl;
SetData(tbl);
spGridList.ShowRow(0);
}
break;
case MST19011_Update:
base.SetFreeForInput();
MessageBox.Show("更新完了しました。");
ScreenClear();
break;
}
}
/// <summary>
/// 取得データの取り込み
/// </summary>
/// <param name="message"></param>
public override void OnReceivedResponseData(CommunicationObject message)
{
var data = message.GetResultData();
DataTable tbl = (data is DataTable) ? (data as DataTable) : null;
switch (message.GetMessageName())
{
case TabelNmList:
// データが取得できなかった場合は処理しない
if (tbl == null)
{
return;
}
DataView dv;
dv = convertTableDisplayList(tbl).AsDataView();
// 絞り込みフィルタ生成
StringBuilder sb = new StringBuilder();
// 品番
if (!string.IsNullOrEmpty(this.txtCode.Text))
{
sb.AppendFormat("( セット品番 LIKE '%{0}%' )", this.txtCode.Text);
}
// 品名
if (!string.IsNullOrEmpty(this.txtName.Text))
{
sb.AppendFormat("{0} {1} LIKE '%{2}%'", sb.Length == 0 ? string.Empty : " AND", COLUMN_MY_NAME, this.txtName.Text);
}
// フィルタリング設定
dv.RowFilter = sb.ToString();
switch (OrderColumn.SelectedIndex)
{
case 0: // 品番
default:
dv.Sort = COLUMN_CODE;
break;
case 1: // 自社品番
dv.Sort = COLUMN_MY_CODE;
break;
case 2: // 自社品名
dv.Sort = COLUMN_MY_NAME;
break;
}
SearchResult = dv.ToTable();
SearchGrid.SelectedIndex = 0;
break;
default:
break;
}
}
/// <summary>
/// 取得データの正常受信時のイベント
/// </summary>
/// <param name="message"></param>
public override void OnReceivedResponseData(CommunicationObject message)
{
try
{
var data = message.GetResultData();
DataTable tbl = (data is DataTable) ? (data as DataTable) : null;
switch (message.GetMessageName())
{
//締日プレビュー出力用
case SEARCH_NNG01010:
DispPreviw(tbl);
break;
//締日CSV出力用
case SEARCH_NNG01010_CSV:
if (tbl == null || tbl.Rows.Count == 0)
{
return;
}
tbl.Columns["月1"].ColumnName = (string)tbl.Rows[0]["月名1"];
tbl.Columns["月2"].ColumnName = (string)tbl.Rows[0]["月名2"];
tbl.Columns["月3"].ColumnName = (string)tbl.Rows[0]["月名3"];
tbl.Columns["月4"].ColumnName = (string)tbl.Rows[0]["月名4"];
tbl.Columns["月5"].ColumnName = (string)tbl.Rows[0]["月名5"];
tbl.Columns["月6"].ColumnName = (string)tbl.Rows[0]["月名6"];
tbl.Columns["月7"].ColumnName = (string)tbl.Rows[0]["月名7"];
tbl.Columns["月8"].ColumnName = (string)tbl.Rows[0]["月名8"];
tbl.Columns["月9"].ColumnName = (string)tbl.Rows[0]["月名9"];
tbl.Columns["月10"].ColumnName = (string)tbl.Rows[0]["月名10"];
tbl.Columns["月11"].ColumnName = (string)tbl.Rows[0]["月名11"];
tbl.Columns["月12"].ColumnName = (string)tbl.Rows[0]["月名12"];
tbl.Columns.Remove("月名1");
tbl.Columns.Remove("月名2");
tbl.Columns.Remove("月名3");
tbl.Columns.Remove("月名4");
tbl.Columns.Remove("月名5");
tbl.Columns.Remove("月名6");
tbl.Columns.Remove("月名7");
tbl.Columns.Remove("月名8");
tbl.Columns.Remove("月名9");
tbl.Columns.Remove("月名10");
tbl.Columns.Remove("月名11");
tbl.Columns.Remove("月名12");
OutPutCSV(tbl);
break;
default:
break;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 取得データの取り込み
/// </summary>
/// <param name="message"></param>
public override void OnReceivedResponseData(CommunicationObject message)
{
var data = message.GetResultData();
DataTable tbl = (data is DataTable) ? (data as DataTable) : null;
switch (message.GetMessageName())
{
case TabelNm:
//Gridのバインド変数に代入
SearchResult = tbl;
DataRow r = null;
//かな読みの条件で抽出
if (!string.IsNullOrEmpty(ｶﾅ読み検索))
{
DataTable dt = SearchResult.Clone();
foreach (DataRow dtRow in SearchResult.Select("かな読み LIKE '%" + ｶﾅ読み検索 + "%'"))
{
r = dt.NewRow();
for (int n = 0; n < dtRow.ItemArray.Length; n++)
{
r[n] = dtRow[n];
}
dt.Rows.Add(r);
}
SearchResult = dt;
}
DataView view = new DataView(SearchResult);
switch (OrderColumn.SelectedIndex)
{
case 0: //コード
default:
view.Sort = COLUM_ID;
break;
case 1: //商品名
view.Sort = COLUM_NAME;
break;
case 2: //商品よみ
view.Sort = COLUM_JIGYOU;
break;
}
SearchResult = view.ToTable();
SearchGrid.SelectedIndex = 0;
break;
default:
break;
}
}
/// <summary>
/// 取得データの取り込み
/// </summary>
/// <param name="message"></param>
public override void OnReceivedResponseData(CommunicationObject message)
{
var data = message.GetResultData();
DataTable tbl = (data is DataTable) ? (data as DataTable) : null;
switch (message.GetMessageName())
{
case TargetTableNm:
DataView dv = new DataView(tbl);
// 絞り込みフィルタ生成
StringBuilder sb = new StringBuilder();
if (!string.IsNullOrEmpty(商品群名))
{
sb.AppendFormat("商品群名 LIKE '%{0}%'", 商品群名);
}
if (!string.IsNullOrEmpty(かな読み))
{
sb.AppendFormat("{0} かな読み LIKE '%{1}%'", sb.Length == 0 ? string.Empty : " AND", かな読み);
}
if (!string.IsNullOrEmpty(商品群コード))
{
sb.AppendFormat("{0} 商品群コード LIKE '%{1}%'", sb.Length == 0 ? string.Empty : " AND", 商品群コード);
}
// フィルタリング設定
dv.RowFilter = sb.ToString();
switch (OrderColumn.SelectedIndex)
{
case 0: //コード
default:
dv.Sort = COLUM_ID;
break;
case 1: //名称
dv.Sort = COLUM_NAME;
break;
case 2: //かな読み
dv.Sort = COLUM_KANA;
break;
}
SearchResult = dv.ToTable();
SearchGrid.SelectedIndex = 0;
break;
default:
break;
}
}
/// <summary>
/// 取得データの取り込み
/// </summary>
/// <param name="message"></param>
public override void OnReceivedResponseData(CommunicationObject message)
{
try
{
this.ErrorMessage = string.Empty;
var data = message.GetResultData();
DataTable tbl = (data is DataTable) ? (data as DataTable) : null;
switch (message.GetMessageName())
{
case 取引先期首残一括データ取得:
if (tbl != null)
{
this.取引先一括期首残データ = tbl;
string ym = Convert.ToString(取引先一括期首残データ.Compute("max(期首年月)", null));
if (ym.Length == 6)
{
ym = ym.Substring(0, 4) + "/" + ym.Substring(4, 2);
}
else
{
ym = string.Empty;
}
this.lbl期首年月.LabelText = string.Format("{0}{1}{2}", 期首年月始, ym, 期首年月終);
// ロック設定
if (DataUpdateVisible == System.Windows.Visibility.Hidden)
{
権限Get.SpreadGridLock(this, true);
}
// フィルタ設定
FileterSet();
SumCalculation();
}
break;
case 取引先期首残一括データ更新:
MessageBox.Show("データを更新しました。");
/*
* ScreenClear();
* EditOn = false;
*/
this.Close();
break;
default:
break;
}
}
catch (Exception ex)
{
this.ErrorMessage = ex.Message;
}
}
