/// <summary> /// 新增一条质检记录 /// </summary> /// <param name="qcRecord">用户实体</param> /// /// <param name="rint">新增后自动增长编号</param> /// <returns></returns> public static bool InsertOneQCRecord(Unusualstandard qcRecord, out int rint) { rint = 0; bool rbool = true; using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { try { db.Unusualstandard.InsertOnSubmit(qcRecord); db.SubmitChanges(); rint = qcRecord.Unusualstandard_ID; rbool = true; } catch { rbool = false; } finally { db.Connection.Close(); } } return(rbool); }
/// <summary> /// 修改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnEdit_Click(object sender, EventArgs e) { if (DGVUnusual.SelectedRows.Count != 1 && DGVUnusual.DataSource != null) { MessageBox.Show("请选择一条数据!"); return; } Unusualstandard u = new Unusualstandard(); if (txtPROD.Text.Trim() == "") { MessageBox.Show("货品不能为空!"); return; } if (txtDEGRADE_MOISTURE_PERCT.Text.Trim() == "") { MessageBox.Show("水分标准不能为空!"); return; } if (txtDEGRADE_MATERIAL_PERCT.Text.Trim() == "") { MessageBox.Show("杂质标准不能为空!"); return; } if (txtDEGRADE_OUTTHROWS_PERCT.Text.Trim() == "") { MessageBox.Show("杂纸标准不能为空!"); return; } if (txtMOISTUREMIN.Text != "") { u.Unusualstandard_MOISTUREMIN = Convert.ToInt32(txtMOISTUREMIN.Text); } else { MessageBox.Show("水分接收下限不能为空!"); return; } if (txtMOISTUREMAX.Text != "") { u.Unusualstandard_MOISTUREMAX = Convert.ToInt32(txtMOISTUREMAX.Text); } else { MessageBox.Show("水分接收上限不能为空!"); return; } int id = Convert.ToInt32(DGVUnusual.SelectedRows[0].Cells["Unusualstandard_ID"].Value); Expression <Func <Unusualstandard, bool> > fnUnu = n => n.Unusualstandard_ID == id; Action <Unusualstandard> aUnu = a => { a.Unusualstandard_PROD = txtPROD.Text.Trim(); a.Unusualstandard_DEGRADE_MOISTURE_PERCT = txtDEGRADE_MOISTURE_PERCT.Text.Trim(); a.Unusualstandard_DEGRADE_MATERIAL_PERCT = txtDEGRADE_MATERIAL_PERCT.Text.Trim(); a.DEGRADE_OUTTHROWS_PERCT = txtDEGRADE_OUTTHROWS_PERCT.Text.Trim(); a.Unusualstandard_MOISTUREMIN = Convert.ToInt32(txtMOISTUREMIN.Text); a.Unusualstandard_MOISTUREMAX = Convert.ToInt32(txtMOISTUREMAX.Text); }; bool b = UnusualstandardDAL.Update(fnUnu, aUnu); if (b) { MessageBox.Show("修改成功!"); LoadData(); } }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, EventArgs e) { try { Unusualstandard u = new Unusualstandard(); if (txtPROD.Text.Trim() != "") { u.Unusualstandard_PROD = txtPROD.Text.Trim(); } else { MessageBox.Show("货品不能为空!"); return; } if (txtDEGRADE_MOISTURE_PERCT.Text.Trim() != "") { u.Unusualstandard_DEGRADE_MOISTURE_PERCT = txtDEGRADE_MOISTURE_PERCT.Text.Trim(); } else { MessageBox.Show("水分标准不能为空!"); return; } if (txtDEGRADE_MATERIAL_PERCT.Text.Trim() != "") { u.Unusualstandard_DEGRADE_MATERIAL_PERCT = txtDEGRADE_MATERIAL_PERCT.Text.Trim(); } else { MessageBox.Show("杂质标准不能为空!"); return; } if (txtDEGRADE_OUTTHROWS_PERCT.Text.Trim() != "") { u.DEGRADE_OUTTHROWS_PERCT = txtDEGRADE_OUTTHROWS_PERCT.Text.Trim(); } else { MessageBox.Show("杂纸标准不能为空!"); return; } if (txtMOISTUREMIN.Text != "") { u.Unusualstandard_MOISTUREMIN = Convert.ToInt32(txtMOISTUREMIN.Text); } else { MessageBox.Show("水分接收下限不能为空!"); return; } if (txtMOISTUREMAX.Text != "") { u.Unusualstandard_MOISTUREMAX = Convert.ToInt32(txtMOISTUREMAX.Text); } else { MessageBox.Show("水分接收上限不能为空!"); return; } DataTable dt = LinQBaseDao.Query("select * from dbo.Unusualstandard where Unusualstandard_PROD ='" + txtPROD.Text.Trim() + "'").Tables[0]; if (dt.Rows.Count > 0) { MessageBox.Show("货品重名!"); return; } else { int result = 0; UnusualstandardDAL.InsertOneQCRecord(u, out result); if (result > 0) { MessageBox.Show("添加成功!"); LoadData(); } } } catch { } }