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