/// <summary>
/// 给工位设置装配用途
/// </summary>
/// <param name="workbench">工位号</param>
/// <param name="purposeID">用途编号</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>成功返回true, 失败返回false</returns>
public bool UpdateWorkbenchPurpose(string workbench, int purposeID, out string error)
{
error = null;
try
{
PlatformServiceDataContext dataContxt = ParameterFactory.PlatformDataContext;
var result = from r in dataContxt.ZPX_WorkBenchConfig
where r.工位 == workbench
select r;
if (result.Count() == 0)
{
error = string.Format("{0} 工位配置信息不存在，无法进行此设置", workbench);
return(false);
}
ZPX_WorkBenchConfig obj = result.Single();
obj.用途编号 = purposeID;
dataContxt.SubmitChanges();
return(true);
}
catch (Exception exce)
{
error = exce.Message;
return(false);
}
}
/// <summary>
/// 删除CCD拍照防错的信息
/// </summary>
/// <param name="goodsCode">图号型号</param>
/// <param name="goodsName">物品名称</param>
/// <param name="spec">规格</param>
/// <param name="bench">工位</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回true 失败返回false</returns>
public bool DeleteCCDConfig(string goodsCode, string goodsName, string spec, string bench, out string error)
{
error = "";
PlatformServiceDataContext dataContxt = ParameterFactory.PlatformDataContext;
try
{
var result = from a in dataContxt.ZPX_CCDConfig
where a.工位 == bench && a.零件图号 == goodsCode &&
a.零件名称 == goodsName && a.零件规格 == spec
select a;
if (result.Count() != 1)
{
error = "数据错误，请检查！";
return(false);
}
else
{
dataContxt.ZPX_CCDConfig.DeleteAllOnSubmit(result);
}
dataContxt.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <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>
/// 添加装配顺序防错的信息
/// </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="product">产品类型</param>
/// <param name="bench">当前工位</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回true 失败返回false</returns>
public bool DeleteWorkbenchConfig(string product, string bench, out string error)
{
error = "";
PlatformServiceDataContext dataContxt = ParameterFactory.PlatformDataContext;
try
{
var result = from a in dataContxt.ZPX_ProductWorkbenchConfig
where a.产品类型 == product && a.当前工位 == bench
select a;
if (result.Count() != 1)
{
error = "数据错误，请检查！";
return(false);
}
else
{
dataContxt.ZPX_ProductWorkbenchConfig.DeleteAllOnSubmit(result);
}
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="id">序号</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回true 失败返回false</returns>
public bool DeleteLeakproofParts(int id, out string error)
{
error = "";
PlatformServiceDataContext dataContxt = ParameterFactory.PlatformDataContext;
try
{
var result = from a in dataContxt.ZPX_LeakproofParts
where a.ID == id
select a;
if (result.Count() != 1)
{
error = "数据错误，请检查！";
return(false);
}
else
{
dataContxt.ZPX_LeakproofParts.DeleteAllOnSubmit(result);
}
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 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>
/// <returns>获取到的工位用途信息</returns>
public IQueryable <WorkbenchPurpose> GetWorkbenchPurpose()
{
PlatformServiceDataContext dataContxt = ParameterFactory.PlatformDataContext;
var result = from r in dataContxt.View_ZPX_WorkBenchConfig
orderby r.工位
select new WorkbenchPurpose {
工位 = r.工位, 装配用途编号 = r.用途编号, 装配用途名称 = r.用途
};
return(result);
}
/// <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);
}
}
/// <summary>
/// 获取指定人员具有权限的工位用途信息
/// </summary>
/// <param name="workID">人员工号</param>
/// <returns>获取到的工位用途信息</returns>
public IQueryable <WorkbenchPurpose> GetWorkbenchPurpose(string workID)
{
IQueryable <View_ZPX_PersonnelAuthority> purposeAuthority = GetPurposeAuthority(workID);
if (purposeAuthority.Count() == 0)
{
return(null);
}
List <int> lstPurposeID = (from r in purposeAuthority
select r.装配用途编号).ToList();
PlatformServiceDataContext dataContxt = ParameterFactory.PlatformDataContext;
var result = from r in dataContxt.View_ZPX_WorkBenchConfig
where lstPurposeID.Contains(r.用途编号)
select new WorkbenchPurpose {
工位 = r.工位, 装配用途编号 = r.用途编号, 装配用途名称 = r.用途
};
return(result);
}
/// <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);
}
}
/// <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);
}
}
