/// <summary>
/// 修改CCD零件的屏蔽时间
/// </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 UpdateCCDConfigTime(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_CCDConfig
where a.工位 == workBench && a.零件图号 == goodsCode &&
a.零件名称 == goodsName && a.零件规格 == spec
select a;
if (result.Count() == 1)
{
ZPX_CCDConfig CCDConfig = result.Single();
CCDConfig.屏蔽开始时间 = starTime;
CCDConfig.屏蔽终止时间 = endTime;
}
dataContxt.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 添加CCD拍照防错的信息
/// </summary>
/// <param name="config">装配顺序防错数据对象</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回true 失败返回false</returns>
public bool InsertCCDConfig(ZPX_CCDConfig config, out string error)
{
error = "";
PlatformServiceDataContext dataContxt = ParameterFactory.PlatformDataContext;
try
{
var result = from a in dataContxt.ZPX_CCDConfig
where a.工位 == config.工位 &&
a.零件图号 == config.零件图号 && a.零件名称 == config.零件名称 &&
a.零件规格 == config.零件规格
select a;
if (result.Count() == 0)
{
dataContxt.ZPX_CCDConfig.InsertOnSubmit(config);
}
else
{
error = "数据重复，请检查！";
return(false);
}
dataContxt.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 修改CCD拍照防错的信息
/// </summary>
/// <param name="config">CCD拍照防错数据对象</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回true 失败返回false</returns>
public bool UpdateCCDConfig(ZPX_CCDConfig config, out string error)
{
error = "";
PlatformServiceDataContext dataContxt = ParameterFactory.PlatformDataContext;
try
{
var result = from a in dataContxt.ZPX_CCDConfig
where a.工位 == config.工位 &&
a.零件图号 == config.零件图号 && a.零件名称 == config.零件名称 &&
a.零件规格 == config.零件规格
select a;
if (result.Count() != 1)
{
error = "数据错误，请检查！";
return(false);
}
else
{
ZPX_CCDConfig lnqCCD = result.Single();
lnqCCD.测点号 = config.测点号;
lnqCCD.适用产品类型 = config.适用产品类型;
}
dataContxt.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}