/// <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())
{
//マスター登録、マスター情報検索時のデータをSPREADに表示。
case TargetTableNm:
//SPREADシート追加
// datatableをlistへ変換
KodateKingaku = (List <M03_YTAN4_MEMBER>)AppCommon.ConvertFromDataTable(typeof(List <M03_YTAN4_MEMBER>), tbl);
break;
case TargetTableNm_Newold:
// datatableをlistへ変換
KodateKingaku = (List <M03_YTAN4_MEMBER>)AppCommon.ConvertFromDataTable(typeof(List <M03_YTAN4_MEMBER>), tbl);
break;
case TargetTableNm_Newold2:
strData(tbl);
break;
//sp全件表示
case spTargetTableNm:
// datatableをlistへ変換
KodateKingaku = (List <M03_YTAN4_MEMBER>)AppCommon.ConvertFromDataTable(typeof(List <M03_YTAN4_MEMBER>), tbl);
break;
case TargetTableNmDelete:
ScreenClear();
break;
case TargetTableNmUpdate:
ScreenClear();
break;
default:
//ScreenClear();
//KodateKingaku = null;
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 SHRCHE_DLY16010:
base.SetFreeForInput();
var ds = data as DataSet;
if (ds == null)
{
this.売上明細データ = null;
}
else
{
売上明細データ = (List <DLY16010_Member>)AppCommon.ConvertFromDataTable(typeof(List <DLY16010_Member>), ds.Tables["DataList"]);
if (this.売上明細データ.Count == 0)
{
Summary();
this.ErrorMessage = "該当するデータはありません。";
return;
}
DataReSort();
//Perform_Pickup();
Summary();
textbox検索日付From.Focus();
}
break;
//プレビュー出力用
case SHRCHE_DLY16010_Pri:
DispPreviw(tbl);
break;
case DLY16010_UPDATE:
if (CloseFlg)
{
CloseFlg = false; this.Close();
}
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())
{
// マスター登録、マスター情報検索時のデータをSPREADに表示。
case TargetTableNm:
// -- 検索処理結果
// SPREADシート追加
setTableBlankRows(tbl);
// datatableをlistへ変換
SetKouseihin = (List <M10_SHIN_MEMBER>)AppCommon.ConvertFromDataTable(typeof(List <M10_SHIN_MEMBER>), tbl);
if (SetKouseihin.Count > 0)
{
this.spComponent.IsEnabled = true;
this.spComponent.Focus();
this.spComponent.ActiveCellPosition = new CellPosition(0, 2);
txtMyProduct.Text2 = SetKouseihin[0].自社品名;
ChangeKeyItemChangeable(false);
}
break;
case TargetTableNm_GetProduct:
// -- 入力品番情報取得結果
setInputRowData(tbl);
break;
case TargetTableNm_Update:
// -- 編集情報更新結果
MessageBox.Show("データの登録が完了しました。");
ScreenClear();
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 GetDetailsNumber:
base.SetFreeForInput();
var ds = data as DataSet;
this.ErrorMessage = string.Empty;
if (tbl.Rows.Count == 0)
{
if (this.MaintenanceMode != AppConst.MAINTENANCEMODE_ADD)
{
this.IDetailsNumber.Focus();
this.ErrorMessage = "該当する明細番号はありません。";
return;
}
}
else
{
this.MaintenanceMode = AppConst.MAINTENANCEMODE_EDIT;
入力者ID = AppCommon.IntParse(tbl.Rows[0]["入力者ID"].ToString());
}
入金明細リスト = (List <DLY08010_Member>)AppCommon.ConvertFromDataTable(typeof(List <DLY08010_Member>), tbl);
if (MaintenanceMode == AppConst.MAINTENANCEMODE_ADD)
{
//新規データならSpreadに新規行を1件作成
spNyukin.Rows.AddNew();
//this.入金明細データ.Rows.InsertAt(this.入金明細データ.NewRow(), 0);
this.spNyukin.Select(new CellRange(0, 0), SelectionType.New);
this.spNyukin[0, spNyukin.Columns["明細番号"].Index].Value = this.DetailsNumber;
this.spNyukin[0, spNyukin.Columns["明細行"].Index].Value = 1;
}
else
{
this.得意先ID = AppCommon.IntParse(tbl.Rows[0]["得意先ID"].ToString());
if (DBNull.Value.Equals(tbl.Rows[0]["入出金日付"]))
{
this.入金日付 = null;
}
else
{
DateTime Wk;
this.入金日付 = DateTime.TryParse(tbl.Rows[0]["入出金日付"].ToString(), out Wk) ? Wk : 初期日付;
}
//int MaxRow = spNyukin.RowCount;
//this.入金明細データ.Rows.InsertAt(this.入金明細データ.NewRow(), MaxRow);
//this.spNyukin.Select(new CellRange(0, 0), SelectionType.New);
//foreach (var row in spNyukin.Rows)
//{
// spNyukin[MaxRow, spNyukin.Columns["明細番号"].Index].Value = this.DetailsNumber;
// int num = Convert.ToInt32(spNyukin[MaxRow - 1, spNyukin.Columns["明細行"].Index].Value);
// spNyukin[MaxRow, spNyukin.Columns["明細行"].Index].Value = num + 1;
// spNyukin[MaxRow, spNyukin.Columns["入出金日付"].Index].Value = Convert.ToDateTime(this.Nyukinbi.Text);
// //spNyukin[MaxRow, spNyukin.Columns["入出金日付"].Index].Value = spNyukin[MaxRow - 1, spNyukin.Columns["入出金日付"].Index].Value;
//}
//#region 画面LOCK
//this.LabelTextShiharaiId.IsKeyItem = true;
//this.Nyukinbi.IsKeyItem = true;
//#endregion
Calculate();
}
//if (MaintenanceMode == AppConst.MAINTENANCEMODE_EDIT)
//{
//spNyukin.Locked = false;
//}
ChangeKeyItemChangeable(false);
SetFocusToTopControl();
break;
case M01ALLTableNm:
if (tbl.Rows.Count > 0)
{
締日 = tbl.Rows[0]["締日"].ToString();
集金日 = tbl.Rows[0]["集金日"].ToString();
サイト = tbl.Rows[0]["サイト"].ToString();
DoEvents();
//if (MaintenanceMode == AppConst.MAINTENANCEMODE_EDIT)
//{
if (!base.CheckAllValidation())
{
this.ErrorMessage = "入力内容に誤りがあります。";
MessageBox.Show("入力内容に誤りがあります。");
SetFocusToTopControl();
return;
}
OgetData();
//}
}
break;
case New_Details:
DetailsNumber = (int)data;
this.MaintenanceMode = AppConst.MAINTENANCEMODE_ADD;
base.SendRequest(new CommunicationObject(MessageType.RequestData, GetDetailsNumber, new object[] { DetailsNumber }));
break;
case GetTekiyoName:
CatchupTekiyoName(tbl);
break;
case DLY08010_NData:
入金予定額 = Convert.ToInt32(tbl.Rows[0]["予定入金金額"].ToString());
既入金額 = Convert.ToInt32(tbl.Rows[0]["既入金額"].ToString());
出金相殺 = Convert.ToInt32(tbl.Rows[0]["出金相殺"].ToString());
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
spNyukin.Locked = false;
break;
case DLY08010_OData:
this.過去入金明細データ検索結果 = (data as DataTable);
this.spOldNyukin.ItemsSource = this.過去入金明細データ検索結果.DefaultView;
break;
case DLY08010_DELETE:
IsUpdated = true;
MessageBox.Show("データを削除しました。");
ScreenClear();
break;
case DLY08010_UPDATE:
IsUpdated = true;
if (番号通知区分 == 1)
{
MessageBox.Show(string.Format("明細番号 {0} で登録しました。", (int)data));
}
ScreenClear();
break;
case GetMeisaiNo:
if (data == null)
{
return;
}
int no = (int)data;
if (no < 1)
{
// データが無かった場合
switch (datagetmode)
{
case DataGetMode.first:
case DataGetMode.last:
this.ErrorMessage = "データがありません。";
break;
case DataGetMode.previous:
this.ErrorMessage = "先頭のデータです。";
break;
case DataGetMode.next:
this.ErrorMessage = "最後のデータです。";
break;
case DataGetMode.number:
break;
}
return;
}
if (no != this.DetailsNumber)
{
this.DetailsNumber = no;
GetMeisaiData();
}
break;
case GetMaxMeisaiNo:
登録件数 = (int)data;
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 LOAD_MST31010:
if (tbl.Rows.Count > 0)
{
燃費目標データ = null;
燃費目標データ = (List <SERCHE_MST31010>)AppCommon.ConvertFromDataTable(typeof(List <SERCHE_MST31010>), tbl);
//燃費目標データ一覧 = tbl;
//this.sp燃費目標データ.ItemsSource = this.燃費目標データ一覧.DefaultView;
Cnt = 0;
}
else
{
this.ErrorMessage = "データがありません。";
return;
}
break;
case SEARCH_MST31010:
if (tbl.Rows.Count > 0)
{
燃費目標データ = (List <SERCHE_MST31010>)AppCommon.ConvertFromDataTable(typeof(List <SERCHE_MST31010>), tbl);
//燃費目標データ一覧 = tbl;
//this.sp燃費目標データ.ItemsSource = this.燃費目標データ一覧.DefaultView;
Cnt = 1;
ChangeKeyItemChangeable(false);
//リボンの状態表示
if (tbl.Rows[0]["Flg"].ToString() == "0")
{
//新規ステータス表示
this.MaintenanceMode = AppConst.MAINTENANCEMODE_ADD;
}
else
{
//編集ステータス表示
this.MaintenanceMode = AppConst.MAINTENANCEMODE_EDIT;
}
}
else
{
this.ErrorMessage = "データがありません。";
return;
}
break;
case LAST_MANTH_MST31010:
if (tbl.Rows.Count > 0)
{
燃費目標データ = (List <SERCHE_MST31010>)AppCommon.ConvertFromDataTable(typeof(List <SERCHE_MST31010>), tbl);
//燃費目標データ一覧 = tbl;
//this.sp燃費目標データ.ItemsSource = this.燃費目標データ一覧.DefaultView;
Cnt = 1;
}
else
{
this.ErrorMessage = "データがありません。";
return;
}
break;
case NINSERT_MST31010:
MessageBox.Show("更新が完了しました。");
ChangeKeyItemChangeable(true);
SetFocusToTopControl();
this.MaintenanceMode = string.Empty;
base.SendRequest(new CommunicationObject(MessageType.RequestData, LOAD_MST31010, new object[] { }));
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 LOAD_MST32010:
if (tbl.Rows.Count > 0)
{
車輌別予算リスト = (List <SERCHE_MST32010>)AppCommon.ConvertFromDataTable(typeof(List <SERCHE_MST32010>), tbl);
//車輌別予算データ = tbl;
//this.sp燃費目標データ.ItemsSource = this.車輌別予算データ.DefaultView;
Cnt = 0;
}
else
{
this.ErrorMessage = "データがありません。";
return;
}
break;
case SEARCH_MST32010:
if (tbl.Rows.Count > 0)
{
車輌別予算リスト = null;
車輌別予算リスト = (List <SERCHE_MST32010>)AppCommon.ConvertFromDataTable(typeof(List <SERCHE_MST32010>), tbl);
//車輌別予算データ = tbl;
//this.sp燃費目標データ.ItemsSource = this.車輌別予算データ.DefaultView;
Cnt = 1;
ChangeKeyItemChangeable(false);
//リボンの状態表示
if (tbl.Rows[0]["Flg"].ToString() == "0")
{
//新規ステータス表示
this.MaintenanceMode = AppConst.MAINTENANCEMODE_ADD;
}
else
{
//編集ステータス表示
this.MaintenanceMode = AppConst.MAINTENANCEMODE_EDIT;
}
DateTime d年月 = Convert.ToDateTime(作成年月.Substring(0, 4).ToString() + "/" + 作成年月.Substring(5, 2).ToString() + "/" + "01");
sp燃費目標データ.ColumnHeader[0, 2].Value = (d年月.Month).ToString() + "月";
sp燃費目標データ.ColumnHeader[0, 3].Value = (d年月.AddMonths(1).Month).ToString() + "月";
sp燃費目標データ.ColumnHeader[0, 4].Value = d年月.AddMonths(2).Month.ToString() + "月";
sp燃費目標データ.ColumnHeader[0, 5].Value = d年月.AddMonths(3).Month.ToString() + "月";
sp燃費目標データ.ColumnHeader[0, 6].Value = d年月.AddMonths(4).Month.ToString() + "月";
sp燃費目標データ.ColumnHeader[0, 7].Value = d年月.AddMonths(5).Month.ToString() + "月";
sp燃費目標データ.ColumnHeader[0, 8].Value = d年月.AddMonths(6).Month.ToString() + "月";
sp燃費目標データ.ColumnHeader[0, 9].Value = d年月.AddMonths(7).Month.ToString() + "月";
sp燃費目標データ.ColumnHeader[0, 10].Value = d年月.AddMonths(8).Month.ToString() + "月";
sp燃費目標データ.ColumnHeader[0, 11].Value = d年月.AddMonths(9).Month.ToString() + "月";
sp燃費目標データ.ColumnHeader[0, 12].Value = d年月.AddMonths(10).Month.ToString() + "月";
sp燃費目標データ.ColumnHeader[0, 13].Value = d年月.AddMonths(11).Month.ToString() + "月";
}
else
{
this.ErrorMessage = "データがありません。";
return;
}
break;
case LAST_MANTH_MST32010:
if (tbl.Rows.Count > 0)
{
車輌別予算リスト = (List <SERCHE_MST32010>)AppCommon.ConvertFromDataTable(typeof(List <SERCHE_MST32010>), tbl);
//車輌別予算データ = tbl;
Cnt = 1;
}
else
{
this.ErrorMessage = "データがありません。";
return;
}
break;
case NINSERT_MST32010:
MessageBox.Show("更新が完了しました。");
ChangeKeyItemChangeable(true);
SetFocusToTopControl();
this.MaintenanceMode = string.Empty;
車輌別予算リスト = 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;
if (data is DataTable)
{
switch (message.GetMessageName())
{
//データ取得
case TargetTableNm:
if (!(乗務員ID > 0))
{
iChkFlg = 9;
break;
}
if (tbl.Rows.Count > 0)
{
//編集ステータス表示
this.MaintenanceMode = AppConst.MAINTENANCEMODE_EDIT;
//rowS01Data = tbl;
SetTblData(tbl);
int?年月;
年月 = ((DateTime)処理年月).Year * 100 + ((DateTime)処理年月).Month;
年月 = AppCommon.IntParse(年月.ToString());
//マスタ表示
base.SendRequest(new CommunicationObject(MessageType.RequestData, S11TableNm_Hendo, new object[] { 乗務員ID, 年月 }));
//マスタ表示
base.SendRequest(new CommunicationObject(MessageType.RequestData, S11TableNm_Jinken, new object[] { 乗務員ID, 年月 }));
//マスタ表示
base.SendRequest(new CommunicationObject(MessageType.RequestData, S11TableNm_Kotei, new object[] { 乗務員ID, 年月 }));
}
else
{
this.ErrorMessage = "データがありません。";
iChkFlg = 9;
}
break;
//変動データ取得
case S11TableNm_Hendo:
if (!(乗務員ID > 0))
{
break;
}
if (tbl.Rows.Count > 0)
{
rowHendoData = (List <S13_DRVSB_Member>)AppCommon.ConvertFromDataTable(typeof(List <S13_DRVSB_Member>), tbl);
//this.sp変動費.ItemsSource = this.rowHendoData.DefaultView;
//this.sp変動費.SelectedItems.Clear();
}
else
{
return;
}
break;
//人件データ取得
case S11TableNm_Jinken:
if (!(乗務員ID > 0))
{
break;
}
if (tbl.Rows.Count > 0)
{
rowJinkenData = (List <S13_DRVSB_Member>)AppCommon.ConvertFromDataTable(typeof(List <S13_DRVSB_Member>), tbl);
//this.sp人件費.ItemsSource = this.rowJinkenData.DefaultView;
//this.sp人件費.SelectedItems.Clear();
}
else
{
return;
}
break;
//固定データ取得
case S11TableNm_Kotei:
if (!(乗務員ID > 0))
{
SetFocusToTopControl();
this.ErrorMessage = "データがありません。";
break;
}
if (tbl.Rows.Count > 0)
{
rowKoteiData = (List <S13_DRVSB_Member>)AppCommon.ConvertFromDataTable(typeof(List <S13_DRVSB_Member>), tbl);
//this.sp固定経.ItemsSource = this.rowKoteiData.DefaultView;
//this.sp固定経.SelectedItems.Clear();
}
else
{
SetFocusToTopControl();
this.ErrorMessage = "データがありません。";
return;
}
if (iChkFlg == 0)
{
System.Windows.Forms.Application.DoEvents();
Keisan();
//キーをfalse
ChangeKeyItemChangeable(false);
SetFocusToTopControl();
}
else
{
SetFocusToTopControl();
this.ErrorMessage = "データがありません。";
return;
}
break;
case UpdateTable:
break;
case DeleteTable:
ScreenClear();
break;
//case M04_DRVTableNm:
// string Henkan;
// Henkan = tbl.Rows[0]["Ｔ締日"].ToString();
// 締日 = AppCommon.IntParse(Henkan);
// break;
default:
break;
}
}
else
{
//DataTable tbl = data as DataTable;
switch (message.GetMessageName())
{
case TargetTableNm:
iChkFlg = 9;
break;
case S11TableNm_Hendo:
rowS11 = tbl.Rows[0];
this.MaintenanceMode = AppConst.MAINTENANCEMODE_ADD;
rowS11 = tbl.Rows[0];
//キーをfalse
ChangeKeyItemChangeable(false);
SetFocusToTopControl();
break;
//人件データ取得
case S11TableNm_Jinken:
return;
//固定データ取得
case S11TableNm_Kotei:
if (iChkFlg == 9)
{
this.ErrorMessage = "データがありません。";
}
return;
case UpdateTable:
return;
case DeleteTable:
ScreenClear();
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_CNTL:
this.WarimasiName1 = AppCommon.GetWarimasiName1(tbl);
this.WarimasiName2 = AppCommon.GetWarimasiName2(tbl);
break;
case GET_RPT:
GetReportFile(tbl);
break;
case TKS05010_KIKAN_SET:
//this.請求書一覧データ = tbl;
if (tbl == null)
{
this.sp請求データ一覧.ItemsSource = null;
this.ErrorMessage = "システムエラーが発生しました。サポートにお問い合わせください。";
return;
}
else
{
請求書一覧データ = (List <TKS05010_KIKAN>)AppCommon.ConvertFromDataTable(typeof(List <TKS05010_KIKAN>), tbl);
//this.sp請求データ一覧.ItemsSource = this.請求書一覧データ.DefaultView;
if (tbl.Rows.Count > 0)
{
}
else
{
this.ErrorMessage = "指定された条件の請求データはありません。";
}
}
break;
case TKS05010_SYUKEI:
MessageBoxResult result = MessageBox.Show("集計が終了しました。\n\r終了しても宜しいでしょうか?"
, "確認"
, MessageBoxButton.YesNo
, MessageBoxImage.Question);
//OKならクリア
if (result == MessageBoxResult.Yes)
{
this.Close();
}
break;
}
}
catch (Exception ex)
{
this.ErrorMessage = ex.Message;
}
}
