/// <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
{
}
}
