private void FindEmployeeForPrintJob_Load(object sender, EventArgs e) { try { using (DatabaseConnectionDataContext conn = new DatabaseConnectionDataContext()) { var resPJ = conn.T_PrintJob.Where(o => o.printJobDateCompleted == null && o.managerEmployeeNo == null); var resEM = conn.T_Employee; printJob.Items.Clear(); foreach (var k in resPJ) { printJob.Items.Add(k.printJobNo + "," + k.printJobDescription); } employee.Items.Clear(); foreach (var l in resEM) { employee.Items.Add(l.employeeNo + "," + l.employeeName); } } } catch (Exception ee) { MessageBox.Show(ee.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { ResetAllControls(); } }
private void initCase1() { try { this.Text = "综合查询 - 印刷任务(待生成订单)查询"; Results.DataSource = null; using (DatabaseConnectionDataContext conn = new DatabaseConnectionDataContext()) { var res = from n in conn.T_PrintJob join k in conn.T_PrintJobType on n.printJobTypeNo equals k.printJobTypeNo join l in conn.T_Publisher on n.publisherNo equals l.publisherNo join m in conn.T_Employee on n.managerEmployeeNo equals m.employeeNo where n.managerEmployeeNo != null && n.printJobDateCompleted == null && !conn.T_PurchaseOrder.Any(t => t.printJobNo == n.printJobNo) select new { 印刷任务编号 = n.printJobNo, 印刷任务描述 = n.printJobDescription, 任务下达时间 = n.printJobDateReceived, 承担出版商 = l.publisherName, 责任雇员 = m.employeeName, 印刷任务类型 = k.printJobTypeDescription }; if (res != null) Results.DataSource = res; } } catch (Exception ee) { MessageBox.Show(ee.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void button_P_löschen_Click(object sender, RoutedEventArgs e) { if (dataGrid_WR.SelectedItem != null) { if (MessageBox.Show("Möchten sie die Prüfung wirklich löschen?", "Achtung!", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { int p_id = Convert.ToInt32("" + ((TextBlock)dataGrid_WR.Columns[0].GetCellContent(dataGrid_WR.SelectedItem)).Text); DatabaseConnectionDataContext d = new DatabaseConnectionDataContext(); var pre = from p in d.Prüfung where p.Id == p_id select p; d.Prüfung.DeleteAllOnSubmit(pre); try { d.SubmitChanges(); } catch (Exception) { MessageBox.Show("Keine Verbindung zur Datenbank!", "Fehler!"); } LoadDatagridData(); } } else { MessageBox.Show("Bitte wählen sie eine Prüfung zum löschen aus!", "Achtung!"); } }
private void ProducePrintJob_Load(object sender, EventArgs e) { try { using (DatabaseConnectionDataContext conn = new DatabaseConnectionDataContext()) { var resPublisher = conn.T_Publisher; var resPrintJobType = conn.T_PrintJobType; printJobPublisher.Items.Clear(); foreach (var resP in resPublisher) { printJobPublisher.Items.Add(resP.publisherNo + "," + resP.publisherName); } printJobType.Items.Clear(); foreach (var resJ in resPrintJobType) { printJobType.Items.Add(resJ.printJobTypeNo + "," + resJ.printJobTypeDescription); } } ClearAllControls(); } catch(Exception ee) { MessageBox.Show(ee.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnOK_Click(object sender, EventArgs e) { try { string printJobNo = orderDetail.SelectedItem.ToString().Split(',')[1].Split(':')[1]; using (DatabaseConnectionDataContext conn = new DatabaseConnectionDataContext()) { var res = conn.T_PrintJob.Where(o => o.printJobNo == printJobNo).FirstOrDefault(); if (res != null) { res.printJobDateCompleted = DateTime.Now; conn.SubmitChanges(); MessageBox.Show("订单交付成功!", "成功", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } } catch (Exception ee) { MessageBox.Show(ee.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { OrderComplete_Load(null, null); } }
private void btnOK_Click(object sender, EventArgs e) { string printjobNo=printJobNo.Text; try { using (DatabaseConnectionDataContext conn = new DatabaseConnectionDataContext()) { var res1 = conn.T_PrintJob.Where(o => o.printJobNo == printjobNo).FirstOrDefault(); if (res1 == null) { MessageBox.Show("数据库经检索后不存在此记录,请确认无误后重试。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (res1.managerEmployeeNo == null) { MessageBox.Show("此记录尚未分配至雇员,无法操作。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { res1.managerEmployeeNo = null; var res2 = conn.T_EmpPrintJob.Where(o => o.printJobNo == printjobNo).FirstOrDefault(); conn.T_EmpPrintJob.DeleteOnSubmit(res2); conn.SubmitChanges(); MessageBox.Show("撤销分配成功!", "成功", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } } catch (Exception ee) { MessageBox.Show(ee.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { DeleteEmployeeForPrintJob_Load(null, null); } }
private void btnDel_Click(object sender, EventArgs e) { var selectedRow=datagridItemKind.Rows[datagridItemKind.CurrentRow.Index]; try { if (MessageBox.Show(string.Format("确定删除{0}吗?此过程不可逆,请谨慎操作!", selectedRow.Cells[1].Value.ToString()), "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { using (DatabaseConnectionDataContext conn = new DatabaseConnectionDataContext()) { var res = conn.T_Item.Where(o => o.itemNo == selectedRow.Cells[0].Value.ToString()).FirstOrDefault(); conn.T_Item.DeleteOnSubmit(res); conn.SubmitChanges(); MessageBox.Show("删除成功!", "成功", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } catch (Exception ee) { MessageBox.Show(ee.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { ItemKindManagement_Load(null, null); } }
private void btnOK_Click(object sender, EventArgs e) { try { if (printJobDescription.Text.Trim() != "") { using (DatabaseConnectionDataContext conn = new DatabaseConnectionDataContext()) { T_PrintJob res = new T_PrintJob(); res.printJobNo = SerialGenerator.GenerateSerialNumber(); res.printJobDescription = printJobDescription.Text; res.printJobDateReceived = DateTime.Now; string[] publisher = printJobPublisher.SelectedItem.ToString().Split(','); string[] printjob = printJobType.SelectedItem.ToString().Split(','); res.publisherNo = publisher[0]; res.printJobTypeNo = printjob[0]; conn.T_PrintJob.InsertOnSubmit(res); conn.SubmitChanges(); MessageBox.Show(string.Format("印刷任务下达成功!\n印刷任务编号:{0}\n印刷任务描述:{1}\n", res.printJobNo, res.printJobDescription), "成功", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } catch (Exception ee) { MessageBox.Show(ee.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { ProducePrintJob_Load(null, null); } }
private void button_kunde_zuordnen_Click(object sender, RoutedEventArgs e) { button_prüfung_speichern_Click(sender, e); DatabaseConnectionDataContext d = new DatabaseConnectionDataContext(); var kvr = from x in d.Prüfung where x.Charge == textBox_prüfer_charge.Text && x.Bundnummer == textBox_prüfer_bundNr.Text select x; if (kvr.Count() > 0) { kvr.First().Id_Kunde = Helper.GetIntFromDataGrid(dataGrid_Kunde, 0); var gek = from y in d.Kunde where y.Id == Helper.GetIntFromDataGrid(dataGrid_Kunde, 0) select y; try { textBox_Firma_Name.Text = gek.First().Firma; textBox_Firma_Land.Text = gek.First().Land; d.SubmitChanges(); } catch (Exception) { MessageBox.Show("Verknüpfung zu Kunden konnte nicht gesetzt werden!", "Fehler!"); } } }
private void button_ExportierenUndSchließen_Click(object sender, RoutedEventArgs e) { DateTime?d1 = D1_Picker.SelectedDate; DateTime?d2 = D2_Picker.SelectedDate; if (d1 != null && d2 != null) { DatabaseConnectionDataContext d = new DatabaseConnectionDataContext(); var pre = from p in d.Prüfung where p.Prüfdatum >= d1 && p.Prüfdatum <= d2 select p; int i = pre.Count(); d.Prüfung.DeleteAllOnSubmit(pre); try { d.SubmitChanges(); } catch (Exception) { MessageBox.Show("Datenbank konnte nicht erreicht werden!", "Fehler!"); } mainWindow.LoadDatagridData(); this.Close(); } else { MessageBox.Show("Bitte wählen sie einen Bereich für das Datum aus!", "Achtung!"); } }
private void dataGrid_Kunde_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (dataGrid_Kunde.SelectedIndex != -1) { DatabaseConnectionDataContext d = new DatabaseConnectionDataContext(); try { Kunde k = (from x in d.Kunde where x.Id == Helper.GetIntFromDataGrid(dataGrid_Kunde, 0) select x).First(); textBox_Ansprechpartner.Text = k.Ansprechnpartner; textBox_EMail.Text = k.EMail; textBox_Firma.Text = k.Firma; textBox_Land.Text = k.Land; textBox_Mobil.Text = k.Mobil; textBox_PLZ.Text = k.PLZ; textBox_Sonstiges.Text = k.Sonstige; textBox_Stadt.Text = k.Stadt; textBox_Straße.Text = k.Straße; textBox_Telefon.Text = k.Telefon; textBox_Web.Text = k.Web; } catch (Exception) { MessageBox.Show("Kunde nicht gefunden!", "Fehler!"); } button_kunde_bearbeiten.IsEnabled = true; } else { Helper.ClearTextBoxes(Grid_Kunden); } }
private void btnOK_Click(object sender, EventArgs e) { try { using (DatabaseConnectionDataContext conn = new DatabaseConnectionDataContext()) { var printJobNo=printJob.SelectedItem.ToString().Split(','); var employeeNo=employee.SelectedItem.ToString().Split(','); var res = conn.T_PrintJob.Where(o => o.printJobNo == printJobNo[0]).FirstOrDefault(); res.managerEmployeeNo = employeeNo[0]; T_EmpPrintJob table = new T_EmpPrintJob(); table.employeeNo = employeeNo[0]; table.printJobNo = printJobNo[0]; table.jobDate = DateTime.Now; conn.T_EmpPrintJob.InsertOnSubmit(table); conn.SubmitChanges(); MessageBox.Show("任务分配成功!", "成功", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } catch (Exception ee) { MessageBox.Show(ee.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { FindEmployeeForPrintJob_Load(null, null); } }
internal void CSV_Load(string csv_Importpfad) { //Ließt Rippendaten aus DatabaseConnectionDataContext d = new DatabaseConnectionDataContext(); System.IO.DirectoryInfo csv_directory = new System.IO.DirectoryInfo(csv_Importpfad); var fpr = from x in d.Prüfung where x.fR == 0 && x.Prüfdatum > DateTime.Today - TimeSpan.FromDays(700) select x; foreach (System.IO.FileInfo f in csv_directory.GetFiles()) { if (f.Name.Contains(".csv")) { CSV_Reader csv_Reader = new CSV_Reader(f.FullName); foreach (Prüfung p in fpr) { if (p != null) { Prüfung np = csv_Reader.Read(p); if (np != null) { p.a1m = np.a1m; p.a2m = np.a2m; p.a3m = np.a3m; p.a4m = np.a4m; //10 Mittelwert p.a1_025 = np.a1_025; p.a2_025 = np.a2_025; p.a3_025 = np.a3_025; p.a4_025 = np.a4_025; //15 Mittelwert p.a1_075 = np.a1_075; p.a2_075 = np.a2_075; p.a3_075 = np.a3_075; p.a4_075 = np.a4_075; //20 Mittelwert p.c1 = np.c1; p.c2 = np.c2; p.c3 = np.c3; p.c4 = np.c4; //25 Mittelwert p.se1 = np.se1; p.se2 = np.se2; p.se3 = np.se3; p.se4 = np.se4; //30 Summe p.Beta = np.Beta; p.Alpha = np.Alpha; p.fR = np.fR; d.SubmitChanges(); } } } } } }
public static List<Matten> GetMattenByDataGrid(int l, DataGrid g) { DatabaseConnectionDataContext db = new DatabaseConnectionDataContext(); var mat = from m in db.Matten where m.Id == GetIntFromDataGrid(l, g) select m; return mat.ToList(); }
private void LoadDatagrid() { DatabaseConnectionDataContext db = new DatabaseConnectionDataContext(); var mat = from u in db.Prüfer select u; dataGrid_pruefer.ItemsSource = mat.ToList(); }
private void comboBox_art_SelectionChanged(object sender, SelectionChangedEventArgs e) { DatabaseConnectionDataContext d = new DatabaseConnectionDataContext(); string tmp = comboBox_art.SelectedValue.ToString(); int slider_Value = 600; if (tmp == "Fremdprüfung") { //this.dataGrid_Kunde.Margin = new Thickness(10, 0, 10, 0); //this.button_kunde_zuordnen.Margin = new Thickness(10, 0, 10, 0); //this.button_art_Kundendaten.Margin = new Thickness(10, 0, 10, 0); SetWidthForFremdprüfungen(slider_Value / 3); button_art_Kundendaten.HorizontalAlignment = HorizontalAlignment.Right; var i = from y in d.Prüfung where y.Bundnummer == textBox_prüfer_bundNr.Text && y.Charge == textBox_prüfer_charge.Text select y; var k = from x in d.Kunde select new { x.Id, x.Firma, x.Land }; dataGrid_Kunde.ItemsSource = k; if (i.First().Id_Kunde != null) { dataGrid_Kunde_Select_ByLoad(); } } else { this.Width = 750; SetWidthForFremdprüfungen(0); dataGrid_Kunde.ItemsSource = null; var alk = from y in d.Prüfung where y.Bundnummer == textBox_prüfer_bundNr.Text && y.Charge == textBox_prüfer_charge.Text && y.Id_Kunde != null select y; if (alk.Count() > 0) { alk.First().Id_Kunde = null; try { d.SubmitChanges(); } catch (Exception) { } } } }
public static int GetSchweissmaschinenIdByName(String n) { DatabaseConnectionDataContext d = new DatabaseConnectionDataContext(); var pru = from p in d.Schweissmaschine where p.Name == n select p; return pru.First().Id; }
public static int GetPrüferIdByName(String n) { DatabaseConnectionDataContext d = new DatabaseConnectionDataContext(); var pru = from p in d.Prüfer where p.Name == n select p; return pru.First().Id; }
public void LoadDatagridData() { DatabaseConnectionDataContext db = new DatabaseConnectionDataContext(); var mat = from u in db.Prüfung where u.Prüfdatum >= Datepicker_Von.SelectedDate && u.Prüfdatum <= Datepicker_Bis.SelectedDate select new { u.Id, u.Prüfdatum, u.Produktionsdatum, Prüfer = u.Prüfer. Name, u.Charge, u.Bundnummer, d = u.Du, dGs = u.Dgs, Rp = u.Re, u.Rm, RmRp = u.RmRe, //u.A, u.Agt, u.fR, u.se1, u.se2, u.se3, u.se4, u.a1m, u.a2m, u.a3m, u.a4m, u.a1_025, u.a2_025, u.a3_025, u.a4_025, u.a1_075, u.a2_075, u.a3_075, u.a4_075, u.c1, u.c2, u.c3, u.c4, u.Alpha, u.Beta }; dataGrid_WR.ItemsSource = mat.ToList(); Prüfungen_Label_Count(label_Anzahl_Datensätze); }
private void Button_Löschen_Click(object sender, RoutedEventArgs e) { DatabaseConnectionDataContext db = new DatabaseConnectionDataContext(); string tmp = "" + ((TextBlock)dataGrid_BenutzerVerwaltung.Columns[0].GetCellContent(dataGrid_BenutzerVerwaltung.SelectedItem)).Text; var usr = from u in db.User where u.Id == Convert.ToInt32( tmp) select u; db.User.DeleteAllOnSubmit(usr); db.SubmitChanges(); LoadDatagrid(); }
private void btnOK_Click(object sender, EventArgs e) { try { using (DatabaseConnectionDataContext conn = new DatabaseConnectionDataContext()) { var res = conn.T_PurchaseOrder.Where(o => o.purchaseOrderNo == poNum.Text).FirstOrDefault(); if (res != null) { var resIsCompleted = conn.T_PrintJob.Where(o => o.printJobDateCompleted != null && o.printJobNo == res.printJobNo).FirstOrDefault(); if (resIsCompleted != null) { MessageBox.Show("经检索,这条订单已经交付,无法撤销。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else { if(MessageBox.Show(string.Format("检索到符合要求的记录如下:\n订单号:{0}\n订单日期:{1}\n印刷任务名称:{2}\n印刷耗材记录条数:{3}\n确定撤销这个订单吗?", res.purchaseOrderNo, res.purchaseOrderDate.ToString(), conn.T_PrintJob.Where(o=>o.printJobNo==res.printJobNo).FirstOrDefault().printJobDescription, conn.T_POItem.Where(o=>o.purchaseOrderNo==res.purchaseOrderNo).Count().ToString()), "确认", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { //归还库存&删除订单耗材 var allPOItems = conn.T_POItem.Where(o => o.purchaseOrderNo == res.purchaseOrderNo); foreach (var poItem in allPOItems) { var resI = conn.T_Item.Where(o => o.itemNo == poItem.itemNo).FirstOrDefault(); resI.itemQuantityInStock += poItem.quantity; conn.T_POItem.DeleteOnSubmit(poItem); } //删除订单 conn.T_PurchaseOrder.DeleteOnSubmit(res); conn.SubmitChanges(); MessageBox.Show("撤销订单成功!", "成功", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } } else { MessageBox.Show("经检索,数据库中不存在这样的记录,请确认无误后再试。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } } catch (Exception ee) { MessageBox.Show(ee.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { DeleteAOrder_Load(null, null); } }
private void MakeChoice(Prüfung p) { DatabaseConnectionDataContext d = new DatabaseConnectionDataContext(); var nap = from x in d.Prüfung where x.Charge == p.Charge && Helper.DeleteLetter("S", Helper.DeleteLetter("U", x.Bundnummer)) == Helper.DeleteLetter("N", p.Bundnummer) select x; if (nap.Count() > 0) { Window n = new Nachprüfung_Frage_Window(nap.First(), p); n.Show(); } }
private void button_löschen_Click(object sender, RoutedEventArgs e) { string tmp = Helper.GetStringFromDataGrid(dataGrid_pruefer, 0); if (tmp != "8") { if (MessageBox.Show("Wenn Sie diesen Prüfer löschen, löschen sie alle damit verbundenen Prüfungen! Sicher?" , "Achtung!", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { DatabaseConnectionDataContext db = new DatabaseConnectionDataContext(); var pru = from x in db.Prüfung where x.Id_Kunde == Convert.ToInt32(tmp) select x; db.Prüfung.DeleteAllOnSubmit(pru); try { db.SubmitChanges(); } catch (Exception) { } var usr = from u in db.Prüfer where u.Id == Convert.ToInt32(tmp) select u; db.Prüfer.DeleteAllOnSubmit(usr); try { db.SubmitChanges(); } catch (Exception) { } LoadDatagrid(); } } else { MessageBox.Show("Dieser Prüfer ist nicht löschbar!", "Achtung!"); } }
private void DataGrid_Load() { DatabaseConnectionDataContext d = new DatabaseConnectionDataContext(); try { var k = from x in d.Kunde select new { x.Id, x.Firma, x.Land, x.Ansprechnpartner }; dataGrid_Kunde.ItemsSource = k; } catch (Exception) { MessageBox.Show("Kunden konnten nicht geladen werden!", "Fehler!"); } }
private void dataGrid_Kunde_Select_ByLoad() { DatabaseConnectionDataContext d = new DatabaseConnectionDataContext(); var kvr = from x in d.Prüfung where x.Charge == textBox_prüfer_charge.Text && x.Bundnummer == textBox_prüfer_bundNr.Text select x; if (kvr.Count() > 0) { var gek = from y in d.Kunde where y.Id == kvr.First().Id_Kunde select y; textBox_Firma_Name.Text = gek.First().Firma; textBox_Firma_Land.Text = gek.First().Land; } }
private void button_feld_löschen_Click(object sender, RoutedEventArgs e) { DatabaseConnectionDataContext d = new DatabaseConnectionDataContext(); var gre = from g in d.Grenzwert where g.Id == Erweiterungen.Helper.GetIntFromDataGrid(0, dataGrid_feld) select g; d.Grenzwert.DeleteOnSubmit(gre.First()); try { d.SubmitChanges(); } catch (Exception) { MessageBox.Show("Datenbankverbindung fehlgeschlagen!", "Nee!"); } LoadDataGridFeld(); }
private void btnCreate_Click(object sender, EventArgs e) { try { using (DatabaseConnectionDataContext conn = new DatabaseConnectionDataContext()) { if (listItem.Items.Count != 0) { T_PurchaseOrder table = new T_PurchaseOrder(); table.purchaseOrderNo = SerialGenerator.GenerateSerialNumber(); table.purchaseOrderDate = DateTime.Now; table.printJobNo = printJob.SelectedItem.ToString().Split(',')[0]; conn.T_PurchaseOrder.InsertOnSubmit(table); conn.SubmitChanges(); //添加POItem表信息 for (int i = 0; i < listItem.Items.Count; i++) { T_POItem ta = new T_POItem(); ta.itemNo = listItem.Items[i].SubItems[0].Text; ta.purchaseOrderNo = table.purchaseOrderNo; ta.quantity = int.Parse(listItem.Items[i].SubItems[2].Text); //减库存 var res = conn.T_Item.Where(o => o.itemNo == ta.itemNo).FirstOrDefault(); res.itemQuantityInStock -= ta.quantity; conn.T_POItem.InsertOnSubmit(ta); } conn.SubmitChanges(); MessageBox.Show("订单生成成功!订单号为:" + table.purchaseOrderNo, "成功", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else { MessageBox.Show("尚未选择印刷耗材,无法生成订单。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } } catch (Exception ee) { MessageBox.Show(ee.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { CreateAOrder_Load(null, null); } }
private void btnSaver_Click(object sender, EventArgs e) { try { if (itemNo.Text == "") { using (DatabaseConnectionDataContext conn = new DatabaseConnectionDataContext()) { T_Item res = new T_Item(); res.itemNo = SerialGenerator.GenerateSerialNumber(); res.itemDescription = itemName.Text; res.itemPrice = double.Parse(itemPrice.Text); res.itemQuantityInStock = 0; res.itemRecorderQuantity = int.Parse(itemMaxStock.Text); res.itemRecorderLeadTime = itemTime.Value; conn.T_Item.InsertOnSubmit(res); conn.SubmitChanges(); MessageBox.Show(string.Format("信息添加成功!\n耗材编号:{0}\n耗材名称:{1}", res.itemNo, res.itemDescription), "成功", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { using (DatabaseConnectionDataContext conn = new DatabaseConnectionDataContext()) { var res = conn.T_Item.Where(o => o.itemNo == itemNo.Text).FirstOrDefault(); res.itemDescription = itemName.Text; res.itemPrice = double.Parse(itemPrice.Text); res.itemRecorderLeadTime = itemTime.Value; conn.SubmitChanges(); MessageBox.Show(string.Format("信息修改成功!\n耗材编号:{0}\n耗材名称:{1}", res.itemNo, res.itemDescription), "成功", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } catch(Exception ee) { MessageBox.Show(ee.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { ItemKindManagement_Load(null, null); } }
private void button_kunde_löschen_Click(object sender, RoutedEventArgs e) { DatabaseConnectionDataContext d = new DatabaseConnectionDataContext(); try { Kunde k = (from x in d.Kunde where x.Id == Helper.GetIntFromDataGrid(dataGrid_Kunde, 0) select x).First(); d.Kunde.DeleteOnSubmit(k); d.SubmitChanges(); } catch (Exception) { MessageBox.Show("Kunde nicht gefunden! Konnte nicht gelöscht werden!", "Fehler!"); } Helper.ClearTextBoxes(Grid_Kunden); DataGrid_Load(); }
private void button_P_Behalten_Click(object sender, RoutedEventArgs e) { DatabaseConnectionDataContext d = new DatabaseConnectionDataContext(); d.Prüfung.DeleteOnSubmit(p_new); try { choice = true; d.SubmitChanges(); } catch (Exception) { MessageBox.Show("Keine Verbindung zur Datenbank!", "Fehler!"); } finally { Close(); } }
private void button_Login_Click(object sender, RoutedEventArgs e) { DatabaseConnectionDataContext db = new DatabaseConnectionDataContext(); var usr = from u in db.User where u.Name == textBox_Name.Text && u.Passwort == passwordBox.Password select u; if (usr.Count() > 0) { w.user = usr.First(); w.ActivateMenu(usr.First(),true); this.Close(); } else { label_message.Content = "Nutzer oder Passwort nicht bekannt!"; } }
private void button_prüfung_löschen_Click(object sender, RoutedEventArgs e) { DatabaseConnectionDataContext d = new DatabaseConnectionDataContext(); var pre = from p in d.Prüfung where p.Id == p_id select p; d.Prüfung.DeleteAllOnSubmit(pre); try { d.SubmitChanges(); } catch (Exception) { } p_id = 0; FillFieldWithNothing(); w.LoadDatagridData(); }
private void InitOrderDetail() { try { using (DatabaseConnectionDataContext conn = new DatabaseConnectionDataContext()) { var res = from n in conn.T_PurchaseOrder join p in conn.T_PrintJob on n.printJobNo equals p.printJobNo where p.printJobDateCompleted == null select new { orderNum = n.purchaseOrderNo, orderDate = n.purchaseOrderDate, printJobDescription = p.printJobDescription, printJobNum = n.printJobNo }; if (res != null) { orderDetail.Items.Clear(); foreach (var k in res) { orderDetail.Items.Add("订单编号:" + k.orderNum + ",任务编号:" + k.printJobNum + ",任务名称:" + k.printJobDescription); } } } } catch (Exception ee) { MessageBox.Show(ee.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { if (orderDetail.Items.Count != 0) { orderDetail.SelectedIndex = 0; } orderDetail.Focus(); } }
private Word.Document SetBookmarks_Ergebnis(Word.Document doc, Kunde kunde) { DatabaseConnectionDataContext d = new DatabaseConnectionDataContext(); var fpr = from x in d.Prüfung where x.Art == "Fremdprüfung" && x.Id_Kunde == kunde.Id && (x.Prüfdatum > d1 && x.Prüfdatum < d2) select x; if (fpr.Count() > 0) { Prüfung p = fpr.First(); SetValidBookmark(doc, "Kunde", kunde.Firma); SetValidBookmark(doc, "Wareneingang", Convert.ToDateTime(p.Wareneingangdatum).ToShortDateString()); SetValidBookmark(doc, "Lieferschein", Convert.ToDateTime(p.Lieferscheindatum).ToShortDateString()); SetValidBookmark(doc, "Bemerkungen", p.Bemerkungen); SetValidBookmark(doc, "Hersteller", p.Hersteller); SetValidBookmark(doc, "ChargenNr", Helper.DeleteLetter("F", p.Charge)); SetValidBookmark(doc, "Bundnummer", p.Bundnummer); SetValidBookmark(doc, "Durchmesser", p.Du.ToString()); SetValidBookmark(doc, "Re", p.Re.ToString()); SetValidBookmark(doc, "Rm", p.Rm.ToString()); SetValidBookmark(doc, "RmRe", p.RmRe.ToString()); SetValidBookmark(doc, "Agt", p.Agt.ToString()); SetValidBookmark(doc, "G", p.Dgs.ToString()); SetValidBookmark(doc, "fR", p.fR.ToString()); SetValidBookmark(doc, "Materialart", p.Materialart); SetValidBookmark(doc, "Verarbeitungsdatum", Convert.ToDateTime(p.Produktionsdatum).ToShortDateString()); SetValidBookmark(doc, "Maschine", p.Maschine); } else { MessageBox.Show("Keine gültige Prüfung gefunden!", "Fehler!"); } return(doc); }
private void textBox_KundenNr_TextChanged(object sender, TextChangedEventArgs e) { if (textBox_KundenNr.Text != String.Empty && !textBox_KundenNr.Text.Contains("Hier")) { int value = 0; if (Int32.TryParse(textBox_KundenNr.Text, out value)) { DatabaseConnectionDataContext d = new DatabaseConnectionDataContext(); var ksu = from x in d.Kunde where x.Id == value select new { x.Id, x.Firma, x.Land }; dataGrid_Kunden.ItemsSource = ksu; } else { MessageBox.Show("Bitte geben sie eine gültige Zahl ein!", "Fehler!"); } } }
private void comboBox_Prüfer_Load() { DatabaseConnectionDataContext d = new DatabaseConnectionDataContext(); var pru = from p in d.Prüfer select p.Name; comboBox_prüfer.ItemsSource = pru; if (!neu) { var tpu = from t in d.Prüfer where t.Id == p.Id_Prüfer select new { t.Name }; if (tpu.Count() > 0) { string n = tpu.First().Name; comboBox_prüfer.SelectedItem = n; } } }
private void button_Speichern_Click(object sender, RoutedEventArgs e) { DatabaseConnectionDataContext db = new DatabaseConnectionDataContext(); if (neu) { try { Schweissmaschine m = new Schweissmaschine() { Name = textBox_Schweissmaschinen.Text }; db.Schweissmaschine.InsertOnSubmit(m); } catch (Exception) { MessageBox.Show("Eingabe muss eine Zahl sein!", "Falsche Eingabe!"); } } else { var mat = from m in db.Schweissmaschine where m.Id == Convert.ToInt32("" + ((TextBlock)dataGrid_schweissmaschinen.Columns[0].GetCellContent(dataGrid_schweissmaschinen.SelectedItem)).Text) select m; try { mat.First().Name = textBox_Schweissmaschinen.Text; } catch (Exception) { MessageBox.Show("Eingabe muss eine Zahl sein!", "Falsche Eingabe!"); } } db.SubmitChanges(); textBox_Schweissmaschinen.Text = String.Empty; LoadDatagrid(); }
private void button_Speichern_Click(object sender, RoutedEventArgs e) { DatabaseConnectionDataContext db = new DatabaseConnectionDataContext(); if (neu) { Prüfer m = new Prüfer() { Name = textBox_Pruefer.Text }; db.Prüfer.InsertOnSubmit(m); } else { var mat = from m in db.Prüfer where m.Id == Convert.ToInt32("" + ((TextBlock)dataGrid_pruefer.Columns[0].GetCellContent(dataGrid_pruefer.SelectedItem)).Text) select m; mat.First().Name = textBox_Pruefer.Text; } db.SubmitChanges(); textBox_Pruefer.Text = String.Empty; LoadDatagrid(); }
private void comboBox_Art_Load(int pId) { if (!neu) { DatabaseConnectionDataContext d = new DatabaseConnectionDataContext(); string art = (from a in d.Prüfung where a.Id == pId select a).First().Art; comboBox_art.Items.Add("Standard"); comboBox_art.Items.Add("Ungereckt"); comboBox_art.Items.Add("Stab"); comboBox_art.Items.Add("Fremdprüfung"); try { comboBox_art.SelectedItem = art; } catch (Exception) { MessageBox.Show("Es konnte keine gültige Art gefunden werden!", "Fehler!"); } } }
private void FillFieldsWithPrüfung(int i) { button_prüfung_bearbeiten.IsEnabled = true; //Grid_Eingabe.IsEnabled = true; neu = false; DatabaseConnectionDataContext d = new DatabaseConnectionDataContext(); var pru = from p in d.Prüfung where p.Id == i select p; if (pru.Count() > 0) { p = pru.First(); datepicker_prüfung.SelectedDate = p.Prüfdatum.Value; datepicker_produktion.SelectedDate = p.Produktionsdatum.Value; //textBox_prüfer_a.Text = p.A.ToString(); textBox_prüfer_agt.Text = p.Agt.ToString(); textBox_prüfer_a1025.Text = p.a1_025.ToString(); textBox_prüfer_a2025.Text = p.a2_025.ToString(); textBox_prüfer_a3025.Text = p.a3_025.ToString(); textBox_prüfer_a4025.Text = p.a4_025.ToString(); textBox_prüfer_a1075.Text = p.a1_075.ToString(); textBox_prüfer_a2075.Text = p.a2_075.ToString(); textBox_prüfer_a3075.Text = p.a3_075.ToString(); textBox_prüfer_a4075.Text = p.a4_075.ToString(); textBox_prüfer_a1m.Text = p.a1m.ToString(); textBox_prüfer_a2m.Text = p.a2m.ToString(); textBox_prüfer_a3m.Text = p.a3m.ToString(); textBox_prüfer_a4m.Text = p.a4m.ToString(); textBox_prüfer_bundNr.Text = p.Bundnummer.ToString(); if (p.Charge != null) { textBox_prüfer_charge.Text = p.Charge.ToString(); } textBox_prüfer_du.Text = p.Du.ToString(); textBox_prüfer_fr.Text = p.fR.ToString(); textBox_prüfer_dgs.Text = p.Dgs.ToString(); textBox_prüfer_rm.Text = p.Rm.ToString(); textBox_prüfer_re.Text = p.Re.ToString(); textBox_prüfer_rmre.Text = p.RmRe.ToString(); textBox_prüfer_se1.Text = p.se1.ToString(); textBox_prüfer_se2.Text = p.se2.ToString(); textBox_prüfer_se3.Text = p.se3.ToString(); textBox_prüfer_se4.Text = p.se4.ToString(); textBox_prüfer_C1.Text = p.c1.ToString(); textBox_prüfer_C2.Text = p.c2.ToString(); textBox_prüfer_C3.Text = p.c3.ToString(); textBox_prüfer_C4.Text = p.c4.ToString(); textBox_prüfung_Alpha.Text = p.Alpha.ToString(); textBox_prüfung_Beta.Text = p.Beta.ToString(); //textBox_prüfung_c.Text = p.C.ToString(); //textBox_prüfung_AgtM.Text = p.AgtM.ToString(); textBox_P_Bemerkungen.Text = p.Bemerkungen; textBox_P_Hersteller.Text = p.Hersteller; textBox_P_Maschine.Text = p.Maschine; textBox_P_Materialart.Text = p.Materialart; } else { MessageBox.Show("Datensatz in Datenbank nicht gefunden!", "Fehler!"); } }
private void ReadData() { DatabaseConnectionDataContext d = new DatabaseConnectionDataContext(); XmlNodeList nList = x.SelectNodes(n1); if (nList.Count > 1) { Prüfung p = new Prüfung(); if (n.Contains("U")) { p.Art = "Ungereckt"; } else if (n.Contains("S")) { p.Art = "Stab"; } else if (n.Contains("F")) { p.Art = "Fremdprüfung"; } else if (n.Contains("N")) { p.Art = "Nachprüfung"; } else { p.Art = "Standard"; } foreach (XmlNode xNode in nList) { string s = xNode[STRING_PARAMETER_TYPE].InnerText; switch (s) { case "600": //Bediener //p.Id_Prüfer = 8; //try //{ // d.SubmitChanges(); //} //catch (Exception) //{ //} ////Testet ob Prüfer in Datenbank vorhanden //try //{ // string b = xNode[STRING_VALUE].InnerText; // if (b.Length > 0) // { // var prf = from x in d.Prüfer // where x.Name == b // select x; // if (prf.Count() == 0) // { // d.Prüfer.InsertOnSubmit(new Prüfer { Name = b }); // try // { // d.SubmitChanges(); // } // catch (Exception) // { // } // } // } // try // { // int pfr = (from l in d.Prüfer // where l.Name == b // select l // ).First().Id; // if (pfr == 0) // { // pfr = 2; // } // p.Id_Prüfer = pfr; // d.SubmitChanges(); // } // catch (Exception) // { // p.Id_Prüfer = 2; // d.SubmitChanges(); // } //} //catch (Exception) //{ // MessageBox.Show("Kein Bediener in " + n + " gefunden!", "Achtung!"); //} break; case "601": //Kunde if (p.Art == "Fremdprüfung") { try { string q = xNode[STRING_VALUE].InnerText; var vku = from y in d.Kunde where y.Firma.Contains(q) select y; if (vku.Count() > 0) { p.Id_Kunde = vku.First().Id; } else { Kunde kunde = new Kunde() { Firma = q }; d.Kunde.InsertOnSubmit(kunde); } d.SubmitChanges(); } catch (Exception) { MessageBox.Show("Fremdprüfung: " + n + " konnte kein Kunde zugeordnet werden!", "Achtung!"); } } break; case "603": //LS Datum if (p.Art == "Fremdprüfung") { try { p.Lieferscheindatum = DateTime.Parse(xNode[STRING_VALUE].InnerText); } catch (Exception) { MessageBox.Show("Es konnte kein Lieferscheindatum in der XML-Datei: " + n + " gefunden werden!", "Fehler!"); } } break; case "604": //WE Datum if (p.Art == "Fremdprüfung") { try { p.Wareneingangdatum = DateTime.Parse(xNode[STRING_VALUE].InnerText); } catch (Exception) { MessageBox.Show("Es konnte kein Wareneingangdatum in der XML-Datei: " + n + " gefunden werden!", "Fehler!"); } } break; case "605": //Maschine if (p.Art == "Fremdprüfung") { try { p.Maschine = xNode[STRING_VALUE].InnerText; } catch (Exception) { } } break; case "607": //Prüfdatum try { p.Prüfdatum = DateTime.Parse(xNode[STRING_VALUE].InnerText); } catch (Exception) { MessageBox.Show("Es konnte kein Prüfdatum in der XML-Datei: " + n + " gefunden werden!", "Fehler!"); } break; case "596": //Produktionsdatum try { p.Produktionsdatum = DateTime.Parse(xNode[STRING_VALUE].InnerText); } catch (Exception) { MessageBox.Show("Es konnte kein Produktionsdatum in der XML-Datei: " + n + " gefunden werden!", "Fehler!"); } break; case "597": //Ring-Nr try { p.Bundnummer = xNode[STRING_VALUE].InnerText; } catch (Exception) { MessageBox.Show("Es konnte kein Bundnummer in der XML-Datei: " + n + " gefunden werden!", "Fehler!"); } break; case "533": //DGs p.Dgs = Parse_Double(n, xNode, STRING_VALUE, 0); break; case "9": //ChargenNr try { p.Charge = xNode[STRING_VALUE].InnerText; } catch (Exception) { MessageBox.Show("Es konnte kein ChargenNr in der XML-Datei: " + n + " gefunden werden!", "Fehler!"); } break; case "51": //Durchmesser p.Du = Parse_Double(n, xNode, STRING_VALUE, 2); break; case "318": //Agt p.Agt = Parse_Double(n, xNode, STRING_VALUE, 2); break; case "308": //Rm p.Rm = Parse_Double(n, xNode, STRING_VALUE, 0); break; case "257": //Rp p.Re = Parse_Double(n, xNode, STRING_VALUE, 0); break; default: break; } } //Berechnet Rm/Rp if (p.Rm != 0 && p.Re != 0) { p.RmRe = Math.Round(Convert.ToDouble(p.Rm / p.Re), 2); } p.fR = 0; p.Id_Prüfer = 8; //Speichert Daten in Datenbank d.Prüfung.InsertOnSubmit(p); try { d.SubmitChanges(); } catch (Exception) { MessageBox.Show("Keine Verbindung zur Datenbank!", "Fehler!"); } if (p.Art == "Nachprüfung") { MakeChoice(p); } } }
private void btnPrintJobTypeSave_Click(object sender, EventArgs e) { try { if (printJobNo.Text == "") { if (printJobName.Text != "") { using (DatabaseConnectionDataContext conn = new DatabaseConnectionDataContext()) { var table = new T_PrintJobType(); table.printJobTypeNo = SerialGenerator.GenerateSerialNumber(); table.printJobTypeDescription = printJobName.Text; conn.T_PrintJobType.InsertOnSubmit(table); conn.SubmitChanges(); MessageBox.Show(string.Format("添加信息成功!\n印刷任务编号:{0}\n印刷任务描述:{1}", table.printJobTypeNo, table.printJobTypeDescription), "成功", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } else { if (printJobName.Text != "") { using (DatabaseConnectionDataContext conn = new DatabaseConnectionDataContext()) { var table = conn.T_PrintJobType.Where(o => o.printJobTypeNo == printJobNo.Text).FirstOrDefault(); table.printJobTypeDescription = printJobName.Text; conn.SubmitChanges(); MessageBox.Show(string.Format("添加修改成功!\n印刷任务编号:{0}\n印刷任务描述:{1}", table.printJobTypeNo, table.printJobTypeDescription), "成功", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } } catch(Exception ee) { MessageBox.Show(ee.Message.ToString(), "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { tabPrintJobType_Enter(null, null); } }
private void btnPublisherSave_Click(object sender, EventArgs e) { try { if (publisherNo.Text == "") { if (publisherZipCode.Text != "") { using (DatabaseConnectionDataContext conn = new DatabaseConnectionDataContext()) { T_Publisher table = new T_Publisher(); table.publisherNo = SerialGenerator.GenerateSerialNumber(); table.publisherName = publisherName.Text; table.publisherStreet = publisherStreet.Text; table.publisherCity = publisherCity.Text; table.publisherState = publisherCountry.Text; table.publisherZipCode = publisherZipCode.Text; table.pubTelNo = publisherTel.Text; table.pubFaxNo = publihserFax.Text; table.pubWebAddress = publisherHomePage.Text; table.contactName = contactName.Text; table.contactTelNo = contactTel.Text; table.contactFaxNo = contactFax.Text; table.contactEmailAddress = contactEmail.Text; table.creditRating = (int)publihserCreditLevel.Value; conn.T_Publisher.InsertOnSubmit(table); conn.SubmitChanges(); MessageBox.Show(string.Format("信息添加成功!\n出版社编号:{0}\n出版社名称:{1}", table.publisherNo, table.publisherName), "成功", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } else { if (publisherZipCode.Text != "") { using (DatabaseConnectionDataContext conn = new DatabaseConnectionDataContext()) { var table = conn.T_Publisher.Where(o => o.publisherNo == publisherNo.Text).FirstOrDefault(); table.publisherName = publisherName.Text; table.publisherStreet = publisherStreet.Text; table.publisherCity = publisherCity.Text; table.publisherState = publisherCountry.Text; table.publisherZipCode = publisherZipCode.Text; table.pubTelNo = publisherTel.Text; table.pubFaxNo = publihserFax.Text; table.pubWebAddress = publisherHomePage.Text; table.contactName = contactName.Text; table.contactTelNo = contactTel.Text; table.contactFaxNo = contactFax.Text; table.contactEmailAddress = contactEmail.Text; table.creditRating = (int)publihserCreditLevel.Value; conn.SubmitChanges(); MessageBox.Show(string.Format("信息修改成功!\n出版社编号:{0}\n出版社名称:{1}", table.publisherNo, table.publisherName), "成功", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } } catch (Exception ee) { MessageBox.Show(ee.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { tabPublisher_Enter(null, null); } }
public void Load(ProgressBar progressBar) { DatabaseConnectionDataContext d = new DatabaseConnectionDataContext(); try { option_xml.Load(Import_Manager.option_pfad); xml_Importpfad = option_xml.SelectSingleNode("Einstellungen").SelectSingleNode("XML_Importpfad").InnerText; csv_Importpfad = option_xml.SelectSingleNode("Einstellungen").SelectSingleNode("CSV_Importpfad").InnerText; } catch (Exception) { MessageBox.Show("Einstellungen nicht gefunden!", "Fehler!"); } System.IO.DirectoryInfo xml_directory = new System.IO.DirectoryInfo(xml_Importpfad); //Setzt PBar Werte auf Dateienanzahl progressBar.Maximum = xml_directory.GetFiles().Count(); int z = 0; foreach (System.IO.FileInfo f in xml_directory.GetFiles()) { var s = from h in d.Import where h.Name == f.Name select h; if (s.Count() < 1) { if (f.Name.Contains(".xml")) { data_xml.Load(f.FullName); try { XML_Reader xr = new XML_Reader(data_xml, "TestParameters/TestParameter", f.Name); d.Import.InsertOnSubmit(new Import() { Name = f.Name }); z = z + 1; } catch (Exception e) { MessageBox.Show("Import der Datei " + f.Name + " fehlgeschlagen!\n\n" + e, "Fehler!"); } } try { d.SubmitChanges(); } catch (Exception) { MessageBox.Show("Keine Verbindung zur Datenbank!", "Fehler!"); } } progressBar.Value++; } CSV_Load(csv_Importpfad); //Setzt Balken auf 0 progressBar.Value = 0; //Meldet ob Import fertig MessageBox.Show("Import abgeschlossen!\n" + z + " Dateien importiert!", "Information"); //Refresh Mainwindow mainWindow.LoadDatagridData(); }
private void initCase4() { try { this.Text = "综合查询 - 印刷订单(已完成订单)查询"; Results.DataSource = null; using (DatabaseConnectionDataContext conn = new DatabaseConnectionDataContext()) { var res = from order in conn.T_PurchaseOrder join job in conn.T_PrintJob on order.printJobNo equals job.printJobNo where job.printJobDateCompleted != null select new { 订单编号 = order.purchaseOrderNo, 印刷任务编号 = job.printJobNo, 印刷任务名称 = job.printJobDescription, 生成订单时间 = order.purchaseOrderDate }; if (res != null) Results.DataSource = res; } } catch (Exception ee) { MessageBox.Show(ee.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnPrintJobDel_Click(object sender, EventArgs e) { try { var selectedRow = datagridPrintJobType.Rows[datagridPrintJobType.CurrentRow.Index]; using (DatabaseConnectionDataContext conn = new DatabaseConnectionDataContext()) { if (MessageBox.Show(string.Format("你确定删除{0}吗?此过程不可逆,请谨慎操作!", selectedRow.Cells[1].Value.ToString()), "确认", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { var res = conn.T_PrintJobType.Where(o => o.printJobTypeNo == selectedRow.Cells[0].Value.ToString()).FirstOrDefault(); conn.T_PrintJobType.DeleteOnSubmit(res); conn.SubmitChanges(); MessageBox.Show("删除成功!", "成功", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } catch (Exception ee) { MessageBox.Show(ee.Message.ToString(), "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { tabPrintJobType_Enter(null, null); } }
private void button_kunde_speichern_Click(object sender, RoutedEventArgs e) { DatabaseConnectionDataContext d = new DatabaseConnectionDataContext(); if (neu) { try { Kunde n_kunde = new Kunde() { Ansprechnpartner = textBox_Ansprechpartner.Text, EMail = textBox_EMail.Text, Firma = textBox_Firma.Text, Land = textBox_Land.Text, Mobil = textBox_Mobil.Text, PLZ = textBox_PLZ.Text, Sonstige = textBox_Sonstiges.Text, Stadt = textBox_Stadt.Text, Straße = textBox_Straße.Text, Telefon = textBox_Telefon.Text, Web = textBox_Web.Text }; d.Kunde.InsertOnSubmit(n_kunde); d.SubmitChanges(); Helper.IsEnabledTextBoxes(Grid_Kunden, false); button_kunde_speichern.IsEnabled = false; } catch (Exception ex) { MessageBox.Show("Kunde konnte nicht gespeichert werden!/n" + ex, "Fehler!"); } } else { try { Kunde b_kunde = (from x in d.Kunde where x.Id == Helper.GetIntFromDataGrid(dataGrid_Kunde, 0) select x).First(); b_kunde.Ansprechnpartner = textBox_Ansprechpartner.Text; b_kunde.EMail = textBox_EMail.Text; b_kunde.Firma = textBox_Firma.Text; b_kunde.Land = textBox_Land.Text; b_kunde.Mobil = textBox_Mobil.Text; b_kunde.PLZ = textBox_PLZ.Text; b_kunde.Sonstige = textBox_Sonstiges.Text; b_kunde.Stadt = textBox_Stadt.Text; b_kunde.Straße = textBox_Straße.Text; b_kunde.Telefon = textBox_Telefon.Text; b_kunde.Web = textBox_Web.Text; d.SubmitChanges(); Helper.IsEnabledTextBoxes(Grid_Kunden, false); button_kunde_speichern.IsEnabled = false; } catch (Exception) { MessageBox.Show("Kunde konnte nicht gespeichert werden!", "Fehler!"); } } DataGrid_Load(); }
private void button_ExportierenUndSchließen_Click(object sender, RoutedEventArgs e) { //Sind die Datepicker ausgefüllt? if (D1_Picker.SelectedDate != null && D2_Picker.SelectedDate != null && D1_Picker.SelectedDate < D2_Picker.SelectedDate) { string as400_Message = String.Empty; string string_Float_Format = "{0:00000.0000}"; int success_Messages = 0; //Konvertieren des Datums d1 = D1_Picker.SelectedDate; d2 = D2_Picker.SelectedDate; //Datenbankabfrage der Matten mit betreffenden Datum die noch nicht exportiert wurden DatabaseConnectionDataContext d = new DatabaseConnectionDataContext(); var ase = from a in d.Prüfung where a.Produktionsdatum >= d1 && a.Produktionsdatum <= d2 && (a.Gesendet == false || a.Gesendet == null) && a.Art == "Standard" select a; int i = ase.Count(); //Schleife durchfährt alle betreffenden Prüfungen foreach (var m in ase) { as400_Message = //as400_Message m.Produktionsdatum + m.Charge.PadLeft(15) //+ m.Bundnummer.PadLeft(15) //+ (Helper.stringIsNull(m.Art)).PadLeft(15) // + (Helper.stringIsNull(m.Prüfer.Name)).PadLeft(15) + String.Format(string_Float_Format, m.Du) + String.Format(string_Float_Format, m.Dgs) + String.Format(string_Float_Format, m.Re) + String.Format(string_Float_Format, m.Rm) + String.Format(string_Float_Format, m.RmRe) + String.Format(string_Float_Format, m.Agt) + String.Format(string_Float_Format, m.fR) ; if (SendToAS400(as400_Message) == true) { success_Messages = success_Messages + 1; m.Gesendet = true; try { d.SubmitChanges(); } catch (Exception) { } } } MessageBox.Show("Es wurden " + success_Messages + " / " + i + " Prüfungen erfolgreich übertragen!", "Erfolgreich!"); this.Close(); } else { MessageBox.Show("Bitte wählen sie für beide Datumsfelder ein Datum aus!", "Achtung!"); } }
private void LoadDatagrid() { DatabaseConnectionDataContext db = new DatabaseConnectionDataContext(); var mat = from u in db.Schweissmaschine select u; dataGrid_schweissmaschinen.ItemsSource = mat.ToList(); }
public CreateWordSheet(DateTime?d1, DateTime?d2, int v) { this.d1 = d1; this.d2 = d2; this.v = v; DatabaseConnectionDataContext d = new DatabaseConnectionDataContext(); var kun = from x in d.Kunde where x.Id == v select x; if (kun.Count() > 0) { Kunde kunde = kun.First(); string path_Anschreiben = Directory.GetCurrentDirectory() + @"\Vorlagen\Anschreiben_Eigenüberwachung_2016.docx"; string path_Ergebnis = Directory.GetCurrentDirectory() + @"\Vorlagen\Vorlage_Eigenüberwachung_2016.docx"; Word.Application app = new Word.Application(); string pdf_Pfad_Anschreiben = @"C:\WR Export\Export_Anschreiben_" + kunde.Firma + "_" + DateTime.Today.ToShortDateString() + ".pdf"; string pdf_Pfad_Ergebnis = @"C:\WR Export\Export_Eigenüberwachung_" + kunde.Firma + "_" + DateTime.Today.ToShortDateString() + ".pdf"; if (File.Exists(pdf_Pfad_Anschreiben)) { File.Delete(pdf_Pfad_Anschreiben); File.Delete(pdf_Pfad_Ergebnis); Thread.Sleep(1000); } try { Thread.Sleep(1000); Word.Document doc_Anschreiben = app.Documents.Open(FileName: path_Anschreiben, ReadOnly: false); Word.Document doc_Ergebnis = app.Documents.Open(FileName: path_Ergebnis, ReadOnly: false); doc_Anschreiben = SetBookmarks_Anschreiben(doc_Anschreiben, kunde); doc_Ergebnis = SetBookmarks_Ergebnis(doc_Ergebnis, kunde); doc_Anschreiben.SaveAs2(pdf_Pfad_Anschreiben, Word.WdSaveFormat.wdFormatPDF); doc_Anschreiben.Close(Word.WdSaveOptions.wdDoNotSaveChanges); doc_Ergebnis.SaveAs2(pdf_Pfad_Ergebnis, Word.WdSaveFormat.wdFormatPDF); doc_Ergebnis.Close(Word.WdSaveOptions.wdDoNotSaveChanges); Thread.Sleep(1000); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { app.Quit(SaveChanges: false); } try { Process.Start(pdf_Pfad_Anschreiben); Process.Start(pdf_Pfad_Ergebnis); } catch (Exception) { MessageBox.Show("Dokumente konnten nicht geöffnet werden!", "Fehler!"); } } }
private void tabPublisher_Enter(object sender, EventArgs e) { this.Text = "基础信息维护 - 出版商信息维护"; try { using (DatabaseConnectionDataContext conn = new DatabaseConnectionDataContext()) { var res = conn.T_Publisher; if (res != null) { datagridPublisher.DataSource = res; SetPublisherDataGrid(); btnPublihserCls_Click(null, null); } } } catch (Exception ee) { MessageBox.Show(ee.Message.ToString(), "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void tabEmployee_Enter(object sender, EventArgs e) { this.Text = "基础信息维护 - 雇员信息维护"; try { using(DatabaseConnectionDataContext conn=new DatabaseConnectionDataContext()) { var res = conn.T_Employee; datagridEmployee.DataSource = res; btnEmployeeCls_Click(null, null); SetEmployeeDataGrid(); } } catch(Exception ee) { MessageBox.Show(ee.Message.ToString(), "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void button_prüfung_speichern_Click(object sender, RoutedEventArgs e) { DatabaseConnectionDataContext d = new DatabaseConnectionDataContext(); int pid = ( from h in d.Prüfer where h.Name == (string)comboBox_prüfer.SelectedItem select new { h.Id } ).First().Id; if (neu) { p = new Prüfung() { Id_Prüfer = pid, Prüfdatum = datepicker_prüfung.SelectedDate, Produktionsdatum = datepicker_produktion.SelectedDate, Charge = textBox_prüfer_charge.Text, Bundnummer = textBox_prüfer_bundNr.Text, Du = TextboxToDouble(textBox_prüfer_du), Dgs = TextboxToDouble(textBox_prüfer_dgs), Re = TextboxToDouble(textBox_prüfer_re), Rm = TextboxToDouble(textBox_prüfer_rm), RmRe = TextboxToDouble(textBox_prüfer_rmre), //A = TextboxToDouble(textBox_prüfer_a), Agt = TextboxToDouble(textBox_prüfer_agt), fR = TextboxToDouble(textBox_prüfer_fr), Art = (string)comboBox_art.SelectedItem, se1 = TextboxToDouble(textBox_prüfer_se1), se2 = TextboxToDouble(textBox_prüfer_se2), se3 = TextboxToDouble(textBox_prüfer_se3), se4 = TextboxToDouble(textBox_prüfer_se4), a1m = TextboxToDouble(textBox_prüfer_a1m), a2m = TextboxToDouble(textBox_prüfer_a2m), a3m = TextboxToDouble(textBox_prüfer_a3m), a4m = TextboxToDouble(textBox_prüfer_a4m), a1_025 = TextboxToDouble(textBox_prüfer_a1025), a2_025 = TextboxToDouble(textBox_prüfer_a2025), a3_025 = TextboxToDouble(textBox_prüfer_a3025), a4_025 = TextboxToDouble(textBox_prüfer_a4025), a1_075 = TextboxToDouble(textBox_prüfer_a1075), a2_075 = TextboxToDouble(textBox_prüfer_a2075), a3_075 = TextboxToDouble(textBox_prüfer_a3075), a4_075 = TextboxToDouble(textBox_prüfer_a4075), c1 = TextboxToDouble(textBox_prüfer_C1), c2 = TextboxToDouble(textBox_prüfer_C2), c3 = TextboxToDouble(textBox_prüfer_C3), c4 = TextboxToDouble(textBox_prüfer_C4), Alpha = TextboxToDouble(textBox_prüfung_Alpha), Beta = TextboxToDouble(textBox_prüfung_Beta) //C = TextboxToDouble(textBox_prüfung_c), //AgtM = TextboxToDouble(textBox_prüfung_AgtM) , Maschine = textBox_P_Maschine.Text, Materialart = textBox_P_Materialart.Text, Hersteller = textBox_P_Hersteller.Text, Bemerkungen = textBox_P_Bemerkungen.Text }; d.Prüfung.InsertOnSubmit(p); } else { var pru = from i in d.Prüfung where i.Id == p_id select i; Prüfung p = pru.First(); p.Id_Prüfer = pid; p.Prüfdatum = datepicker_prüfung.SelectedDate; p.Produktionsdatum = datepicker_produktion.SelectedDate; p.Charge = textBox_prüfer_charge.Text; p.Bundnummer = textBox_prüfer_bundNr.Text; p.Du = TextboxToDouble(textBox_prüfer_du); p.Dgs = TextboxToDouble(textBox_prüfer_dgs); p.Re = TextboxToDouble(textBox_prüfer_re); p.Rm = TextboxToDouble(textBox_prüfer_rm); p.RmRe = TextboxToDouble(textBox_prüfer_rmre); //p.A = TextboxToDouble(textBox_prüfer_a); p.Agt = TextboxToDouble(textBox_prüfer_agt); p.fR = TextboxToDouble(textBox_prüfer_fr); p.Art = (string)comboBox_art.SelectedItem; p.se1 = TextboxToDouble(textBox_prüfer_se1); p.se2 = TextboxToDouble(textBox_prüfer_se2); p.se3 = TextboxToDouble(textBox_prüfer_se3); p.se4 = TextboxToDouble(textBox_prüfer_se4); p.a1m = TextboxToDouble(textBox_prüfer_a1m); p.a2m = TextboxToDouble(textBox_prüfer_a2m); p.a3m = TextboxToDouble(textBox_prüfer_a3m); p.a4m = TextboxToDouble(textBox_prüfer_a4m); p.a1_025 = TextboxToDouble(textBox_prüfer_a1025); p.a2_025 = TextboxToDouble(textBox_prüfer_a2025); p.a3_025 = TextboxToDouble(textBox_prüfer_a3025); p.a4_025 = TextboxToDouble(textBox_prüfer_a4025); p.a1_075 = TextboxToDouble(textBox_prüfer_a1075); p.a2_075 = TextboxToDouble(textBox_prüfer_a2075); p.a3_075 = TextboxToDouble(textBox_prüfer_a3075); p.a4_075 = TextboxToDouble(textBox_prüfer_a4075); p.c1 = TextboxToDouble(textBox_prüfer_C1); p.c2 = TextboxToDouble(textBox_prüfer_C2); p.c3 = TextboxToDouble(textBox_prüfer_C3); p.c4 = TextboxToDouble(textBox_prüfer_C4); p.Alpha = TextboxToDouble(textBox_prüfung_Alpha); p.Beta = TextboxToDouble(textBox_prüfung_Beta); //p.C = TextboxToDouble(textBox_prüfung_c); //p.AgtM = TextboxToDouble(textBox_prüfung_AgtM); p.Hersteller = textBox_P_Hersteller.Text; p.Materialart = textBox_P_Materialart.Text; p.Maschine = textBox_P_Maschine.Text; p.Bemerkungen = textBox_P_Bemerkungen.Text; } try { d.SubmitChanges(); } catch (Exception) { MessageBox.Show("Keine Verbindung zur Datenbank!", "Fehler!"); } Grid_Eingabe.IsEnabled = false; Grid_Kunde.IsEnabled = false; w.LoadDatagridData(); }
private void tabPrintJobType_Enter(object sender, EventArgs e) { this.Text = "基础信息维护 - 印刷任务类型信息维护"; try { using (DatabaseConnectionDataContext conn = new DatabaseConnectionDataContext()) { var res = conn.T_PrintJobType; if (res != null) { datagridPrintJobType.DataSource = res; datagridPrintJobType.Columns[0].HeaderText = "印刷任务编号"; datagridPrintJobType.Columns[0].Width = 220; datagridPrintJobType.Columns[1].HeaderText = "印刷任务描述"; datagridPrintJobType.Columns[1].Width = 250; btnPrintJobCls_Click(null, null); } } } catch (Exception ee) { MessageBox.Show(ee.Message.ToString(), "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnOk_Click(object sender, EventArgs e) { try { if (printJobNo.Text != "") { using (DatabaseConnectionDataContext conn = new DatabaseConnectionDataContext()) { var res = conn.T_PrintJob.Where(o => o.printJobNo == printJobNo.Text).FirstOrDefault(); if (res != null) { if (res.printJobDateCompleted != null) { MessageBox.Show("此印刷任务已经完成,不可撤销。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else { if (res.managerEmployeeNo != null) { MessageBox.Show("此印刷任务已分配至雇员,请取消雇员分配后再试。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else { var respo = conn.T_PurchaseOrder.Where(o => o.printJobNo == res.printJobNo).FirstOrDefault(); if (respo != null) { MessageBox.Show("此印刷任务已生成订单,请撤销订单后再试。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else { var pubName = conn.T_Publisher.Where(o => o.publisherNo == res.publisherNo).FirstOrDefault(); var pjName = conn.T_PrintJobType.Where(o => o.printJobTypeNo == res.printJobTypeNo).FirstOrDefault(); var result = MessageBox.Show(string.Format("检索到符合要求的记录如下:\n印刷任务编号:{0}\n印刷任务描述:{1}\n印刷任务下达时间:{2}\n任务承担出版商:{3}\n印刷任务类型:{4}\n确定要撤销吗?", res.printJobNo, res.printJobDescription, res.printJobDateReceived.ToString(), pubName.publisherName, pjName.printJobTypeDescription), "确认", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (result == DialogResult.OK) { conn.T_PrintJob.DeleteOnSubmit(res); conn.SubmitChanges(); MessageBox.Show("任务撤销成功!", "成功", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } } } else { MessageBox.Show("经检索不存在此编号的印刷任务,请确认无误后重新操作。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } } } catch (Exception ee) { MessageBox.Show(ee.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { DeletePrintJob_Load(null, null); } }
private void btnEmployeeDel_Click(object sender, EventArgs e) { try { var selectedRow = datagridEmployee.Rows[datagridEmployee.CurrentRow.Index]; using(DatabaseConnectionDataContext conn =new DatabaseConnectionDataContext()) { var res = conn.T_Employee.Where(o => o.employeeNo == selectedRow.Cells[0].Value.ToString()).FirstOrDefault(); if (MessageBox.Show("确认删除" + res.employeeName + "吗?此过程不可逆,请谨慎操作!", "确认", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { conn.T_Employee.DeleteOnSubmit(res); conn.SubmitChanges(); MessageBox.Show("删除成功!", "成功", MessageBoxButtons.OK, MessageBoxIcon.Information); tabEmployee_Enter(null, null); btnEmployeeCls_Click(null, null); } } } catch(Exception ee) { MessageBox.Show(ee.Message.ToString(), "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { } }
private void btnEmployeeSave_Click(object sender, EventArgs e) { try { if (employeeIDLabel.Text == "") { if (employeeNameTextBox.Text != "") { using (DatabaseConnectionDataContext conn = new DatabaseConnectionDataContext()) { T_Employee table = new T_Employee(); table.employeeNo = SerialGenerator.GenerateSerialNumber(); table.employeeName = employeeNameTextBox.Text; table.employeeSex = employeeSexCombobox.SelectedItem.ToString(); conn.T_Employee.InsertOnSubmit(table); conn.SubmitChanges(); MessageBox.Show(string.Format("添加雇员成功!\n雇员编号:{0}\n雇员姓名:{1}\n雇员性别:{2}", table.employeeNo, table.employeeName, table.employeeSex), "成功", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } else { if (employeeNameTextBox.Text != "") { using (DatabaseConnectionDataContext conn=new DatabaseConnectionDataContext()) { var res = conn.T_Employee.Where(o => o.employeeNo == employeeIDLabel.Text).FirstOrDefault(); res.employeeName = employeeNameTextBox.Text; res.employeeSex = employeeSexCombobox.SelectedItem.ToString(); conn.SubmitChanges(); MessageBox.Show(string.Format("修改雇员成功!\n雇员编号:{0}\n雇员姓名:{1}\n雇员性别:{2}", res.employeeNo, res.employeeName, res.employeeSex), "成功", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } } catch (Exception ee) { MessageBox.Show(ee.Message.ToString(), "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { tabEmployee_Enter(null, null); btnEmployeeCls_Click(null, null); } }