/// <summary> /// 添加装配顺序防错的信息 /// </summary> /// <param name="workbenchConfig">装配顺序防错数据对象</param> /// <param name="error">错误信息</param> /// <returns>成功返回true 失败返回false</returns> public bool InsertWorkbenchConfig(ZPX_ProductWorkbenchConfig workbenchConfig, out string error) { error = ""; PlatformServiceDataContext dataContxt = ParameterFactory.PlatformDataContext; try { var result = from a in dataContxt.ZPX_ProductWorkbenchConfig where a.产品类型 == workbenchConfig.产品类型 && a.当前工位 == workbenchConfig.当前工位 select a; if (result.Count() == 0) { dataContxt.ZPX_ProductWorkbenchConfig.InsertOnSubmit(workbenchConfig); } else { error = "数据重复,请检查!"; return(false); } dataContxt.SubmitChanges(); return(true); } catch (Exception ex) { error = ex.Message; return(false); } }
/// <summary> /// 修改装配顺序及工位间装配顺序的屏蔽时间 /// </summary> /// <param name="workBench">当前工位</param> /// <param name="upWorkBench">上道工位</param> /// <param name="productCode">产品类型</param> /// <param name="name">分总成名称</param> /// <param name="starTime">屏蔽开始时间</param> /// <param name="endTime">屏蔽终止时间</param> /// <param name="error">错误信息</param> /// <returns>修改成功返回true,失败返回False</returns> public bool UpdateProductWorkbenchTime(string workBench, string upWorkBench, string productCode, string name, DateTime starTime, DateTime endTime, out string error) { error = ""; try { PlatformServiceDataContext dataContxt = ParameterFactory.PlatformDataContext; var result = from a in dataContxt.ZPX_ProductWorkbenchConfig where a.当前工位 == workBench && a.道工位 == upWorkBench && a.产品类型 == productCode && a.分总成名称 == name select a; if (result.Count() == 1) { ZPX_ProductWorkbenchConfig product = result.Single(); product.屏蔽开始时间 = starTime; product.屏蔽终止时间 = endTime; } dataContxt.SubmitChanges(); return(true); } catch (Exception ex) { error = ex.Message; return(false); } }
/// <summary> /// 修改装配顺序防错的信息 /// </summary> /// <param name="workbenchConfig">装配顺序防错数据对象</param> /// <param name="error">错误信息</param> /// <returns>成功返回true 失败返回false</returns> public bool UpdateWorkbenchConfig(ZPX_ProductWorkbenchConfig workbenchConfig, out string error) { error = ""; PlatformServiceDataContext dataContxt = ParameterFactory.PlatformDataContext; try { var result = from a in dataContxt.ZPX_ProductWorkbenchConfig where a.当前工位 == workbenchConfig.当前工位 && a.产品类型 == workbenchConfig.产品类型 select a; if (result.Count() != 1) { error = "数据错误,请检查!"; return(false); } else { ZPX_ProductWorkbenchConfig lnqWorkbenchConfig = result.Single(); lnqWorkbenchConfig.序装配末道工序值 = workbenchConfig.序装配末道工序值; lnqWorkbenchConfig.序装配端口号 = workbenchConfig.序装配端口号; lnqWorkbenchConfig.道工位 = workbenchConfig.道工位; lnqWorkbenchConfig.是按顺序流水号装配 = workbenchConfig.是按顺序流水号装配; lnqWorkbenchConfig.是本阶段末工位 = workbenchConfig.是本阶段末工位; lnqWorkbenchConfig.是本阶段起始工位 = workbenchConfig.是本阶段起始工位; lnqWorkbenchConfig.是气密性检测工位 = workbenchConfig.是气密性检测工位; lnqWorkbenchConfig.是所有产品通用工位 = workbenchConfig.是所有产品通用工位; } dataContxt.SubmitChanges(); return(true); } catch (Exception ex) { error = ex.Message; return(false); } }