private void btn_Regist_Pro_Click(object sender, EventArgs e) { try { M_Product pr = new M_Product() { MaID = int.Parse(textB_MakerID_Pro.Text), PrName = textB_ProName_Pro.Text, Price = int.Parse(textB_Pri_Pro.Text), PrJCode = textB_JAN_Pro.Text, PrSafetyStock = int.Parse(textB_SSQ_Pro.Text), ScID = int.Parse(textB_SCID_Pro.Text), PrModelNumber = int.Parse(textB_Mnumber_Pro.Text), PrColor = textB_Color_Pro.Text, PrReleaseDate = dtp_RelDate_Pro.Value, PrFlag = checkB_Del_Pro.Checked ? 1 : 0, }; SalesManagement_DevContext context = new SalesManagement_DevContext(); context.M_Products.Add(pr); context.SaveChanges(); context.Dispose(); MessageBox.Show("登録が完了しました。", "登録完了", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message, "エラー", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private bool GetValidDataAtSyukkoUpdate() { int id = int.Parse(txt_PrID.Text); using (SalesManagement_DevContext dbContext = new SalesManagement_DevContext()) { var result = dbContext.T_Stocks .Where(s => s.PrID == id).ToArray(); foreach (var item in result) { int stquntity = item.StQuantity - int.Parse(txt_ChQuantity.Text); var regStock = new T_Stock() { StID = item.StID, PrID = item.PrID, StQuantity = stquntity, StFlag = item.StFlag }; // 注文情報の登録 var errorMessage = _St.PutStock(regStock); if (errorMessage != string.Empty) { MessageBox.Show(errorMessage); return(false); } } return(true); } }
private bool loginauthor() { using (SalesManagement_DevContext dbContext = new SalesManagement_DevContext()) { var loresult = dbContext.M_Employees .Where(e => e.EmID == transfer_int) .ToArray(); foreach (var item in loresult) { txt_loginSoID.Text = (item.SoID).ToString(); txt_loginEmID.Text = (item.EmID).ToString(); } return(true); } }
private void btn_CleateDabase_Click(object sender, EventArgs e) { //データベースの生成を行います. //再度実行する場合には,必ずデータベースの削除をしてから実行してください. //役職マスタを生成するサンプル(1件目に管理者を追加する例) M_Position FirstPosition = new M_Position() { PoName = "管理者" }; SalesManagement_DevContext context = new SalesManagement_DevContext(); context.SaveChanges(); context.Dispose(); MessageBox.Show("テーブル作成完了"); }
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_ShID.Text); using (SalesManagement_DevContext dbContext = new SalesManagement_DevContext()) { var result = dbContext.T_Shipments .Where(s => s.ShID == id).ToArray(); foreach (var item in result) { var regShipment = new T_Shipment() { ShID = item.ShID, EmID = transfer_int, ClID = item.ClID, SoID = item.SoID, OrID = item.OrID, ShFinishDate = DateTime.Now, ShStateFlag = 1, ShFlag = item.ShFlag, ShHidden = item.ShHidden }; // 注文情報の登録 var errorMessage = _Sh.PutShipment(regShipment); if (errorMessage != string.Empty) { MessageBox.Show(errorMessage); return; } return; } } }
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 bool Get_Syukko_Data_AtRegistration() { // 確定可否 if (DialogResult.OK != MessageBox.Show(this, "確定してよろしいですか", "確定可否", MessageBoxButtons.OKCancel, MessageBoxIcon.Question)) { return(false); } //注文情報を出庫テーブルに送る int id = int.Parse(txt_ChID.Text); using (SalesManagement_DevContext dbContext = new SalesManagement_DevContext()) { var result = dbContext.T_Chumons .Where(c => c.ChID == id).ToArray(); foreach (var item in result) { var regSyukko = new T_Syukko() { EmID = null, ClID = item.ClID, SoID = item.SoID, OrID = item.OrID, SyDate = null, SyStateFlag = 0, SyFlag = 0, SyHidden = "" }; // 注文情報の登録 var errorMessage = _Sy.PostT_Syukko(regSyukko); if (errorMessage != string.Empty) { MessageBox.Show(errorMessage); return(false); } } int id2 = int.Parse(txt_OrID.Text); var syresult = dbContext.T_Syukkos .Where(s => s.OrID == id2) .ToArray(); foreach (var item in syresult) { var regSyukkoDetail = new T_SyukkoDetail() { SyID = item.SyID, PrID = int.Parse(txt_PrID.Text), SyQuantity = int.Parse(txt_ChQuantity.Text) }; // 注文情報の登録 var errorMessage = _Sy.PostT_SyukkoDetail(regSyukkoDetail); if (errorMessage != string.Empty) { MessageBox.Show(errorMessage); return(false); } } foreach (var item in result) { var regChumon = new T_Chumon() { ChID = item.ChID, SoID = item.SoID, EmID = transfer_int, ClID = item.ClID, OrID = item.OrID, ChDate = DateTime.Now, ChStateFlag = 1, ChFlag = item.ChFlag, ChHidden = item.ChHidden }; // 注文情報の登録 var errorMessage = _Ch.PutChumon(regChumon); if (errorMessage != string.Empty) { MessageBox.Show(errorMessage); return(false); } } //// 画面更新 fncAllSelect(); txt_ChID.Focus(); return(true); } }
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; } }