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