private void btn_Modify_Click(object sender, RoutedEventArgs e) { ValuePrice modifiedPrice = new ValuePrice(); try { modifiedPrice.Unit_Price = double.Parse(txt_Price.Text); } catch { SystemSounds.Beep.Play(); MessageBox.Show("工序单价必须为数字!"); return; } modifiedPrice.Id = OriginPrice.Id; modifiedPrice.Procedure_Id = OriginPrice.Procedure_Id; modifiedPrice.Value_Id = OriginPrice.Value_Id; modifiedPrice.Unit = txt_Unit.Text; Db.UpdatePrice(modifiedPrice); PsPage.FillPrice(); this.Close(); }
private void btn_AddRelationship_Click(object sender, RoutedEventArgs e) { Assign a = new Assign(); a.EmployeeId = (cmb_Employee.SelectedItem as Employee).Id; a.Price_Id = SelectedPrice.Id; if (Db.QueryAssignWhetherExsit(a).Count() > 0) { SystemSounds.Beep.Play(); string str = "该员工已被分配到此工序!"; MessageBox.Show(str); return; } Db.InsertAssign(a); Assign a0 = Db.QueryAssignWhetherExsit(a).Single(); Reckon r = new Reckon(); r.Assign_Id = a0.Id; r.Count = 0; Db.InsertReckon(r); PsPage.FillEmployee(); this.Close(); }
private void btn_AddTask_Click(object sender, RoutedEventArgs e) { Value v = new Value(); if (cmb_Product.SelectedIndex == -1) { SystemSounds.Beep.Play(); MessageBox.Show("产品编号不能为空!"); return; } else { v.Product_Id = (cmb_Product.SelectedItem as Product).Id; v.Product_Name = (cmb_Product.SelectedItem as Product).Name; } try { if (string.IsNullOrWhiteSpace(txt_TaskNum.Text) == true) { SystemSounds.Beep.Play(); MessageBox.Show("任务编号不能为空!"); return; } else { v.TaskNum = int.Parse(txt_TaskNum.Text); } } catch (FormatException fe) { txt_TaskNum.Text = string.Empty; SystemSounds.Beep.Play(); MessageBox.Show("任务编号必须为数字!"); return; } //if (Db.QueryValueByName(txt_Value.Text).Count() == 0) // QueryValueByNameNotInProduct if (Db.QueryValueByNameAndProductId(txt_Value.Text, v.Product_Id).Count() == 0) { v.Name = txt_Value.Text; } else { SystemSounds.Beep.Play(); MessageBox.Show("该产品已存在感值:" + txt_Value.Text); txt_Value.Text = string.Empty; return; } v.TaskDate = DateTime.Now; Db.InsertValue(v); IEnumerable <Relationship> relateList = Db.QueryRelationshipByProduct_Id(v.Product_Id); foreach (Relationship item in relateList) { ValuePrice price = new ValuePrice(); price.Procedure_Id = Db.QueryProcedureByName(item.InputProcedure).Single().Id; price.Value_Id = Db.QueryValueByTaskNum(v.TaskNum).Single().Id; Db.InsertValuePrice(price); } PsPage.FillGridTask(); this.Close(); }