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; } }