/// <summary>
/// 添加零件电子称防错的信息
/// </summary>
/// <param name="leakproofParts">电子称防错数据对象</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回true 失败返回false</returns>
public bool InsertLeakproofParts(ZPX_LeakproofParts leakproofParts, out string error)
{
error = "";
PlatformServiceDataContext dataContxt = ParameterFactory.PlatformDataContext;
try
{
var result = from a in dataContxt.ZPX_LeakproofParts
where a.工位 == leakproofParts.工位 &&
a.防漏装零件图号 == leakproofParts.防漏装零件图号 &&
a.防漏装零件名称 == leakproofParts.防漏装零件名称 &&
a.防漏装零件规格 == leakproofParts.防漏装零件规格
select a;
if (result.Count() == 0)
{
dataContxt.ZPX_LeakproofParts.InsertOnSubmit(leakproofParts);
}
else
{
error = "数据重复，请检查！";
return(false);
}
dataContxt.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 修改电子称零件的屏蔽时间
/// </summary>
/// <param name="workBench">工位</param>
/// <param name="goodsCode">图号型号</param>
/// <param name="goodsName">物品名称</param>
/// <param name="spec">规格</param>
/// <param name="starTime">屏蔽开始时间</param>
/// <param name="endTime">屏蔽终止时间</param>
/// <param name="error">错误信息</param>
/// <returns>修改成功返回true，失败返回False</returns>
public bool UpdateLeakproofTime(string workBench, string goodsCode, string goodsName,
string spec, DateTime starTime, DateTime endTime, out string error)
{
error = "";
try
{
PlatformServiceDataContext dataContxt = ParameterFactory.PlatformDataContext;
var result = from a in dataContxt.ZPX_LeakproofParts
where a.工位 == workBench && a.防漏装零件图号 == goodsCode &&
a.防漏装零件名称 == goodsName && a.防漏装零件规格 == spec
select a;
if (result.Count() == 1)
{
ZPX_LeakproofParts leakproof = result.Single();
leakproof.屏蔽开始时间 = starTime;
leakproof.屏蔽终止时间 = endTime;
}
dataContxt.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 修改零件打扭矩的信息
/// </summary>
/// <param name="leakproofParts">电子称防错数据对象</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回true 失败返回false</returns>
public bool UpdateLeakproofParts(ZPX_LeakproofParts leakproofParts, out string error)
{
error = "";
PlatformServiceDataContext dataContxt = ParameterFactory.PlatformDataContext;
try
{
var result = from a in dataContxt.ZPX_LeakproofParts
where a.工位 == leakproofParts.工位 &&
a.防漏装零件图号 == leakproofParts.防漏装零件图号 &&
a.防漏装零件名称 == leakproofParts.防漏装零件名称 &&
a.防漏装零件规格 == leakproofParts.防漏装零件规格
select a;
if (result.Count() != 1)
{
error = "数据错误，请检查！";
return(false);
}
else
{
ZPX_LeakproofParts lnqLeakproof = result.Single();
lnqLeakproof.电子秤端口号 = leakproofParts.电子秤端口号;
lnqLeakproof.防错模式 = leakproofParts.防错模式;
lnqLeakproof.零件单重 = leakproofParts.零件单重;
lnqLeakproof.公差 = leakproofParts.公差;
}
dataContxt.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
