/// <summary>
/// 删除工装工位配置信息
/// </summary>
/// <param name="frockOfWorkBench">工装工位配置实体集</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回True ，失败返回False</returns>
public bool DeleteFrockOfWorkBench(S_FrockOfWorkBenchSetting frockOfWorkBench, out string error)
{
error = null;
try
{
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
var varData = from a in ctx.S_FrockOfWorkBenchSetting
where a.WorkBench == frockOfWorkBench.WorkBench &&
a.FrockNumber == frockOfWorkBench.FrockNumber
select a;
ctx.S_FrockOfWorkBenchSetting.DeleteAllOnSubmit(varData);
ctx.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 添加工装工位配置信息
/// </summary>
/// <param name="frockOfWorkBench">工装工位配置实体集</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回True ，失败返回False</returns>
public bool AddFrockOfWorkBench(S_FrockOfWorkBenchSetting frockOfWorkBench, out string error)
{
error = null;
try
{
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
var varData = from a in ctx.S_FrockOfWorkBenchSetting
where a.WorkBench == frockOfWorkBench.WorkBench &&
a.FrockNumber == frockOfWorkBench.FrockNumber
select a;
if (varData.Count() == 0)
{
ctx.S_FrockOfWorkBenchSetting.InsertOnSubmit(frockOfWorkBench);
ctx.SubmitChanges();
}
else
{
error = "不能添加重复项";
return(false);
}
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
private void btnContentUpdate_Click(object sender, EventArgs e)
{
GetMessage();
S_FrockOfWorkBenchSetting lnqOldData = new S_FrockOfWorkBenchSetting();
lnqOldData.WorkBench = dataGridView1.CurrentRow.Cells["工位"].Value.ToString();
lnqOldData.FrockNumber = dataGridView1.CurrentRow.Cells["工装编号"].Value.ToString();
if (!m_serverFrockStandingBook.UpdateFrockOfWorkBench(lnqOldData, m_lnqFrockOfWorkBenchSet, out m_strErr))
{
MessageDialog.ShowPromptMessage(m_strErr);
}
else
{
MessageDialog.ShowPromptMessage("更新成功");
}
RefreshData();
}
/// <summary>
/// 更新工装工位配置信息
/// </summary>
/// <param name="oldFrockOfWorkBench">旧实体集</param>
/// <param name="newFrockOfWorkBench">新实体集</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回True，失败返回False</returns>
public bool UpdateFrockOfWorkBench(S_FrockOfWorkBenchSetting oldFrockOfWorkBench,
S_FrockOfWorkBenchSetting newFrockOfWorkBench, out string error)
{
error = null;
try
{
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
var varData = from a in ctx.S_FrockOfWorkBenchSetting
where a.FrockNumber == oldFrockOfWorkBench.FrockNumber &&
a.WorkBench == oldFrockOfWorkBench.WorkBench
select a;
if (varData.Count() != 1)
{
error = "数据为空或者不唯一";
return(false);
}
else
{
S_FrockOfWorkBenchSetting lnqData = varData.Single();
lnqData.FrockNumber = newFrockOfWorkBench.FrockNumber;
lnqData.WorkBench = newFrockOfWorkBench.WorkBench;
ctx.SubmitChanges();
}
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
