private void btn_submit_Click(object sender, RoutedEventArgs e) { if (gridPrice.SelectedItems.Count != 1) { return; } P_Price p = gridPrice.SelectedItem as P_Price; Reckon r = Db.QueryReckonByAssignId(p.AssignId).Single(); try { r.Count = int.Parse(txt_Count.Text); if (r.Count < 0) { SystemSounds.Beep.Play(); MessageBox.Show("计件数量不能小于零!"); return; } Db.UpdateReckonCount(r); p.IsSubmited = true; } catch { SystemSounds.Beep.Play(); MessageBox.Show("提交失败!"); return; } }
public int UpdateReckonCount(Reckon r) { using (IDbConnection conn = OpenConnection()) { return(conn.Execute("update tbl_Reckon set Count=@Count where Assign_Id=@Assign_Id", new { Count = r.Count, Assign_Id = r.Assign_Id })); } }
private void gridPrice_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (gridPrice.SelectedItems.Count != 1) { return; } P_Price p = gridPrice.SelectedItem as P_Price; Reckon r = Db.QueryReckonByAssignId(p.AssignId).Single(); txt_Count.Text = r.Count.ToString(); }
public int InsertReckon(Reckon r) { //Assign_Id INT PRIMAEY KEY, //CONSTRAINT fk_Assign_Id FOREIGN KEY (Assign_Id) // REFERENCES tbl_Assign (Id) ON DELETE CASCADE ON UPDATE CASCADE, //Price_Id INT, //CONSTRAINT fk_Price_Id FOREIGN KEY (Price_Id) // REFERENCES tbl_Value_Price (Id) ON DELETE CASCADE ON UPDATE CASCADE, //Count INT using (IDbConnection conn = OpenConnection()) { return(conn.Execute("Insert into tbl_Reckon values " + "(@Assign_Id, @Count)", new { Assign_Id = r.Assign_Id, Count = r.Count })); } }
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(); }