/// <summary>
/// 根据参数实体查询数据
/// </summary>
/// <param name="data">检索不为空的数据</param>
/// <returns>返回查询到的数据</returns>
public IEnumerable <View_ZPX_CVTOffLineTestResult> GetViewData(View_ZPX_CVTOffLineTestResult data)
{
DepotManagementDataContext context = CommentParameter.DepotDataContext;
IEnumerable <View_ZPX_CVTOffLineTestResult> result = null;
if (data.编号 > 0)
{
result = from r in context.View_ZPX_CVTOffLineTestResult
where r.编号 == data.编号
select r;
}
else
{
result = from r in context.View_ZPX_CVTOffLineTestResult
where r.产品型号 == data.产品型号
select r;
if (!GlobalObject.GeneralFunction.IsNullOrEmpty(data.产品箱号))
{
result = from r in result
where r.产品箱号.Contains(data.产品箱号)
select r;
}
}
return(result);
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
if (dataGridView1.CurrentRow == null)
{
MessageDialog.ShowPromptMessage("请选择要操作的记录后再进行此操作");
return;
}
View_ZPX_CVTOffLineTestResult data = new View_ZPX_CVTOffLineTestResult();
data.编号 = (int)dataGridView1.CurrentRow.Cells["编号"].Value;
data.产品型号 = dataGridView1.CurrentRow.Cells["产品型号"].Value.ToString();
data.产品箱号 = dataGridView1.CurrentRow.Cells["产品箱号"].Value.ToString();
if (MessageDialog.ShowEnquiryMessage("是否要删除【产品型号】：" + data.产品型号
+ " 【产品箱号】：" + data.产品箱号 + "？") == DialogResult.No)
{
return;
}
m_testServer.Delete(data);
MessageDialog.ShowPromptMessage("删除成功");
SearchData();
}
catch (Exception ex)
{
MessageDialog.ShowPromptMessage(ex.Message);
}
}
public void Delete(View_ZPX_CVTOffLineTestResult data)
{
DepotManagementDataContext context = CommentParameter.DepotDataContext;
var result = from r in context.ZPX_CVTOffLineTestResult
where r.ID == data.编号
select r;
if (result.Count() == 0)
{
throw new Exception("不存在此记录");
}
if (result.First().ReviewFlag)
{
throw new Exception("记录已经审核，不允许进行此操作");
}
context.ZPX_CVTOffLineTestResult.DeleteAllOnSubmit(result);
var resultLog = from a in context.ZPX_CVTOffLineTestResultLog
where a.ProdutCode == data.产品型号 + " " + data.产品箱号
select a;
context.ZPX_CVTOffLineTestResultLog.DeleteAllOnSubmit(resultLog);
context.SubmitChanges();
}
/// <summary>
/// 更新说明
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnUpdateRemark_Click(object sender, EventArgs e)
{
if (!CheckData())
{
return;
}
if (dataGridView1.SelectedRows.Count == 0)
{
MessageDialog.ShowPromptMessage("请选择要操作的记录后再进行此操作");
return;
}
View_ZPX_CVTOffLineTestResult data = GetSelectedData();
data.备注 = txtRemark.Text.Trim();
try
{
m_testServer.UpdateRemark(data);
MessageDialog.ShowPromptMessage("执行成功");
RefreshDataGridView(m_testServer.GetViewData(new View_ZPX_CVTOffLineTestResult()
{
编号 = data.编号
}));
}
catch (Exception exce)
{
MessageDialog.ShowErrorMessage(exce.Message);
}
}
/// <summary>
/// 从dataGridView中获取选择的数据
/// </summary>
/// <returns>返回获取到的数据</returns>
private View_ZPX_CVTOffLineTestResult GetSelectedData()
{
List <View_ZPX_CVTOffLineTestResult> result =
dataGridView1.DataSource as List <View_ZPX_CVTOffLineTestResult>;
DataGridViewCellCollection cells = dataGridView1.SelectedRows[0].Cells;
View_ZPX_CVTOffLineTestResult data = null;
if (result == null)
{
data = new View_ZPX_CVTOffLineTestResult();
data.编号 = (int)cells["编号"].Value;
data.产品型号 = (string)cells["产品型号"].Value;
data.产品箱号 = (string)cells["产品箱号"].Value;
data.预装员工号 = (string)cells["预装员工号"].Value;
data.预装员姓名 = (string)cells["预装员姓名"].Value;
data.故障现象 = (string)cells["故障现象"].Value;
data.备注 = (string)cells["备注"].Value;
data.合格标志 = (bool)cells["合格标志"].Value;
data.记录时间 = (DateTime)cells["记录时间"].Value;
data.记录员工号 = (string)cells["记录员工号"].Value;
data.记录员姓名 = (string)cells["记录员姓名"].Value;
data.检查标志 = (bool)cells["检查标志"].Value;
data.检查时间 = cells["检查时间"].Value as DateTime?;
data.类别 = (string)cells["类别"].Value;
}
else
{
data = result.Single(p => p.编号 == (int)cells["编号"].Value);
}
return(data);
}
/// <summary>
/// 检索实体数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSearchProduct_Click(object sender, EventArgs e)
{
View_ZPX_CVTOffLineTestResult data = new View_ZPX_CVTOffLineTestResult();
data.产品型号 = cmbProductCode.Text;
data.产品箱号 = GlobalObject.GeneralFunction.IsNullOrEmpty(txtProductNumber.Text) ? null : txtProductNumber.Text;
RefreshDataGridView(m_testServer.GetViewData(data));
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="data">要更新的数据</param>
/// <returns>操作是否成功的标志</returns>
public bool Update(View_ZPX_CVTOffLineTestResult data)
{
DepotManagementDataContext context = CommentParameter.DepotDataContext;
var result = from r in context.ZPX_CVTOffLineTestResult
where r.ID == data.编号
select r;
if (result.Count() == 0)
{
throw new Exception("找不到要更新的记录，无法进行此操作");
}
ZPX_CVTOffLineTestResult updateData = result.Single();
if (updateData.UserCode != GlobalObject.BasicInfo.LoginID)
{
throw new Exception("不是记录创建人员不允许进行此操作");
}
if (updateData.ReviewFlag)
{
throw new Exception("记录已经审核，不允许进行此操作");
}
View_ZPX_CVTOffLineTestResult old = (from r in context.View_ZPX_CVTOffLineTestResult
where r.编号 == data.编号
select r).Single();
if (GlobalObject.StapleFunction.SimpleEqual <View_ZPX_CVTOffLineTestResult>(old, data))
{
throw new Exception("数据没有任何变化，不需要进行此操作");
}
PlatformManagement.ILogManagement log =
PlatformManagement.PlatformFactory.GetObject <PlatformManagement.ILogManagement>();
log.WriteUpdateLog <View_ZPX_CVTOffLineTestResult>(GlobalObject.BasicInfo.LoginID, "下线试验信息管理",
new List <string>(new string[] { "编号" }), old, data);
updateData.ProductType = data.产品型号;
updateData.ProductNumber = data.产品箱号;
updateData.Assembler = data.预装员工号;
updateData.Date = ServerTime.Time;
updateData.QualifiedFlag = data.合格标志;
updateData.Fault = data.故障现象;
updateData.Remark = data.备注;
context.SubmitChanges();
return(true);
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.SelectedRows.Count == 0)
{
return;
}
View_ZPX_CVTOffLineTestResult data = GetSelectedData();
cmbProductCode.Text = data.产品型号;
txtProductNumber.Text = data.产品箱号;
txtAssembler.Text = data.预装员姓名;
txtAssembler.Tag = data.预装员工号;
txtFault.Text = data.故障现象;
txtRemark.Text = data.备注;
试验合格.Checked = data.合格标志;
cmbRepairType.Text = data.类别;
}
/// <summary>
/// 更新
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnUpdate_Click(object sender, EventArgs e)
{
if (!CheckData())
{
return;
}
if (dataGridView1.SelectedRows.Count == 0)
{
MessageDialog.ShowPromptMessage("请选择要操作的记录后再进行此操作");
return;
}
View_ZPX_CVTOffLineTestResult data = GetSelectedData();
data.产品型号 = cmbProductCode.Text;
data.产品箱号 = txtProductNumber.Text;
data.预装员工号 = txtAssembler.Tag.ToString();
data.故障现象 = txtFault.Text;
data.备注 = txtRemark.Text.Trim();
data.合格标志 = 试验合格.Checked;
data.类别 = cmbRepairType.Text;
try
{
m_testServer.Update(data);
MessageDialog.ShowPromptMessage("执行成功");
RefreshDataGridView(m_testServer.GetViewData(new View_ZPX_CVTOffLineTestResult()
{
编号 = data.编号
}));
}
catch (Exception exce)
{
MessageDialog.ShowErrorMessage(exce.Message);
}
}
/// <summary>
/// 更新说明
/// </summary>
/// <param name="data">要更新的数据</param>
/// <returns>操作是否成功的标志</returns>
public bool UpdateRemark(View_ZPX_CVTOffLineTestResult data)
{
DepotManagementDataContext context = CommentParameter.DepotDataContext;
var result = from r in context.ZPX_CVTOffLineTestResult
where r.ID == data.编号
select r;
if (result.Count() == 0)
{
throw new Exception("找不到要更新的记录，无法进行此操作");
}
ZPX_CVTOffLineTestResult updateData = result.Single();
if (updateData.UserCode != GlobalObject.BasicInfo.LoginID)
{
throw new Exception("不是记录创建人员不允许进行此操作");
}
View_ZPX_CVTOffLineTestResult old = (from r in context.View_ZPX_CVTOffLineTestResult
where r.编号 == data.编号
select r).Single();
PlatformManagement.ILogManagement log =
PlatformManagement.PlatformFactory.GetObject <PlatformManagement.ILogManagement>();
log.WriteUpdateLog <View_ZPX_CVTOffLineTestResult>(GlobalObject.BasicInfo.LoginID, "下线试验信息管理",
new List <string>(new string[] { "编号" }), old, data);
updateData.Remark = data.备注;
context.SubmitChanges();
return(true);
}
