/// <summary> /// 删除 /// </summary> private void tsbDelete_Click() { try { int j = 0; if (this.DGVUnusual.SelectedRows.Count > 0)//选中删除 { if (MessageBox.Show("确定要删除吗?", "系统提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { //选中数量 int count = DGVUnusual.SelectedRows.Count; //遍历 for (int i = 0; i < count; i++) { Expression <Func <Unusualstandard, bool> > funUnusual = n => n.Unusualstandard_ID == Convert.ToInt32(DGVUnusual.SelectedRows[i].Cells["Unusualstandard_ID"].Value.ToString()); if (!UnusualstandardDAL.DeleteToMany(funUnusual)) { j++; LogInfoDAL.loginfoadd("删除", "删除检测项目异常标准:" + DGVUnusual.SelectedRows[i].Cells["Unusualstandard_PROD"].Value.ToString(), Common.USERNAME);//添加日志 } } if (j == 0) { MessageBox.Show("成功删除", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { MessageBox.Show("删除失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } else//没有选中 { MessageBox.Show("请选择要删除的行!"); } } catch (Exception ex) { Common.WriteTextLog("检测项目异常标准 tsbDelete_Click()+" + ex.Message.ToString()); } finally { page = new PageControl(); //LoadData(Name);//更新 page.PageMaxCount = tscbxPageSize2.SelectedItem.ToString(); } }
/// <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 { } }