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