/// <summary> /// 录入信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnOK_Click(object sender, EventArgs e) { Semi_finishedProducts pro = new Semi_finishedProducts(); if (!string.IsNullOrEmpty(txtWorkNumber.Text) && (IsNumber(txtStoreNum.Text))) { pro.WorkNumber = txtWorkNumber.Text.Trim(); pro.Count = Convert.ToDecimal(txtStoreNum.Text.Trim()); pro.Material = cmbMaterial.SelectedItem.ToString(); pro.Name = txtName.Text.Trim(); if (instore.SaveMessage(pro).Equals(1)) { MessageBox.Show("保存成功", "提示"); } } else { MessageBox.Show("填写信息有误,请正确填写相关信息", "提示"); } }
public int SaveMessage(Semi_finishedProducts product) { int num = 0; using (StoreAccess access = new StoreAccess(true)) { try { access.Open(); access.BeginTransaction(); num = access.Insert(product); access.Commit(); } catch (DbException ex) { access.Close(); access.RollBack(); MessageBox.Show(ex.Message, "错误"); } } return(num); }