/// <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); } }