private bool Generate_RegistrationArrival(T_Arrival regArrival)
{
// 入荷情報の登録
var errorMessage = _Ar.PostT_Arrival(regArrival);
if (errorMessage != string.Empty)
{
MessageBox.Show(errorMessage);
return(false);
}
return(true);
}
//
//
// 11.1.3 入荷情報登録
//
//
private bool Generate_Registration(T_Arrival regArrival)
{
// 登録可否
if (DialogResult.OK != MessageBox.Show(this, "登録してよろしいですか", "登録可否", MessageBoxButtons.OKCancel, MessageBoxIcon.Question))
{
return(false);
}
// 入荷情報の登録
var errorMessage = _Ar.PostT_Arrival(regArrival);
if (errorMessage != string.Empty)
{
MessageBox.Show(errorMessage);
return(false);
}
// 画面更新
RefreshDataGridView();
txt_ArID.Focus();
return(true);
}
//
//
// 11.2.3 入荷情報更新
//
//
private bool ArrivalUpdate(T_Arrival regArrival)
{
// 更新可否
if (DialogResult.OK != MessageBox.Show(this, "更新してよろしいですか", "更新可否", MessageBoxButtons.OKCancel, MessageBoxIcon.Question))
{
return(false);
}
var errorMessage = _Ar.PutArrival(regArrival);
if (errorMessage != string.Empty)
{
MessageBox.Show(errorMessage);
return(false);
}
// 表示データ更新 & 入力クリア
RefreshDataGridView();
txt_ArID.Focus();
return(true);
}
private void btn_commit_FLG_Click(object sender, EventArgs e)
{
// 確定可否
if (DialogResult.OK != MessageBox.Show(this, "確定してよろしいですか", "確定可否", MessageBoxButtons.OKCancel, MessageBoxIcon.Question))
{
return;
}
//入荷情報を出荷テーブルに送る
int id = int.Parse(txt_ArID.Text);
using (SalesManagement_DevContext dbContext = new SalesManagement_DevContext())
{
var result = dbContext.T_Arrivals
.Where(c => c.ArID == id).ToArray();
foreach (var item in result)
{
var regShipment = new T_Shipment()
{
EmID = null,
ClID = item.ClID,
SoID = item.SoID,
OrID = item.OrID,
ShFinishDate = null,
ShStateFlag = 0,
ShFlag = 0,
ShHidden = ""
};
// 入荷情報の登録
var errorMessage = _Sh.PostT_Shipment(regShipment);
if (errorMessage != string.Empty)
{
MessageBox.Show(errorMessage);
return;
}
}
int id2 = int.Parse(txt_OrID.Text);
var syresult = dbContext.T_Shipments
.Where(s => s.OrID == id2)
.ToArray();
foreach (var item in syresult)
{
var regShipmentDetail = new T_ShipmentDetail()
{
ShID = item.ShID,
PrID = int.Parse(txt_PrID.Text),
ShDquantity = int.Parse(txt_ArQuantity.Text)
};
// 注文情報の登録
var errorMessage = _Sh.PostT_ShipmentDetail(regShipmentDetail);
if (errorMessage != string.Empty)
{
MessageBox.Show(errorMessage);
return;
}
}
foreach (var item in result)
{
var regArrival = new T_Arrival()
{
ArID = item.ArID,
SoID = item.SoID,
EmID = transfer_int,
ClID = item.ClID,
OrID = item.OrID,
ArDate = DateTime.Now,
ArStateFlag = 1,
ArFlag = item.ArFlag,
ArHidden = item.ArHidden
};
// 注文情報の登録
var errorMessage = _Ar.PutArrival(regArrival);
if (errorMessage != string.Empty)
{
MessageBox.Show(errorMessage);
return;
}
}
//// 画面更新
fncAllSelect();
txt_ArID.Focus();
return;
}
}
private void btn_commit_FLG_Click(object sender, EventArgs e)
{
// 確定可否
if (DialogResult.OK != MessageBox.Show(this, "確定してよろしいですか", "確定可否", MessageBoxButtons.OKCancel, MessageBoxIcon.Question))
{
return;
}
//出庫情報を入荷テーブルに送る
using (SalesManagement_DevContext dbContext = new SalesManagement_DevContext())
{
int id = int.Parse(txt_SyID.Text);
var result = dbContext.T_Syukkos
.Where(s => s.SyID == id).ToArray();
foreach (var item in result)
{
var regArrival = new T_Arrival()
{
EmID = null,
ClID = item.ClID,
SoID = item.SoID,
OrID = item.OrID,
ArDate = null,
ArStateFlag = 0,
ArFlag = 0,
ArHidden = ""
};
// 入荷情報の登録
var errorMessage = _Ar.PostT_Arrival(regArrival);
if (errorMessage != string.Empty)
{
MessageBox.Show(errorMessage);
return;
}
}
//出庫詳細情報を入荷詳細テーブルに送る
int id2 = int.Parse(txt_OrID.Text);
var syresult = dbContext.T_Arrivals
.Where(a => a.ArID == id2)
.ToArray();
foreach (var item in syresult)
{
var regArrivalDetail = new T_ArrivalDetail()
{
ArID = item.ArID,
PrID = int.Parse(txt_PrID.Text),
ArQuantity = int.Parse(txt_SyQuantity.Text)
};
// 注文情報の登録
var errorMessage2 = _Ar.PostT_ArrivalDetail(regArrivalDetail);
if (errorMessage2 != string.Empty)
{
MessageBox.Show(errorMessage2);
return;
}
}
//出庫情報を更新
foreach (var item in result)
{
var regSyukko = new T_Syukko()
{
SyID = item.SyID,
EmID = transfer_int,
ClID = item.ClID,
SoID = item.SoID,
OrID = item.OrID,
SyDate = DateTime.Now,
SyStateFlag = 1,
SyFlag = item.SyFlag,
SyHidden = item.SyHidden
};
// 注文情報の登録
var errorMessage = _Sy.PutSyukko(regSyukko);
if (errorMessage != string.Empty)
{
MessageBox.Show(errorMessage);
return;
}
}
//// 画面更新
fncAllSelect();
txt_SyID.Focus();
return;
}
}
