/// <summary>
/// 修改打扭矩零件的屏蔽时间
/// </summary>
/// <param name="workBench">工位</param>
/// <param name="goodsCode">图号型号</param>
/// <param name="goodsName">物品名称</param>
/// <param name="spec">规格</param>
/// <param name="startTime">屏蔽开始时间</param>
/// <param name="endTime">屏蔽终止时间</param>
/// <param name="error">错误信息</param>
/// <returns>修改成功返回true，失败返回False</returns>
public bool UpdateShieldTime(string workBench, string goodsCode, string goodsName,
string spec, DateTime startTime, DateTime endTime, out string error)
{
error = "";
try
{
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
var result = from a in dataContxt.ZPX_TorqueSpanner
where a.WorkBench == workBench && a.GoodsCode == goodsCode &&
a.GoodsName == goodsName && a.Spec == spec
select a;
if (result.Count() == 1)
{
ZPX_TorqueSpanner torque = result.Single();
torque.StartTime = startTime;
torque.EndTime = endTime;
}
dataContxt.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 添加零件打扭矩的信息
/// </summary>
/// <param name="torqueSpanner">打扭矩数据对象</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回true 失败返回false</returns>
public bool InsertTorqueSpanner(ZPX_TorqueSpanner torqueSpanner, out string error)
{
error = "";
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
try
{
var result = from a in dataContxt.ZPX_TorqueSpanner
where a.WorkBench == torqueSpanner.WorkBench &&
a.GoodsCode == torqueSpanner.GoodsCode &&
a.GoodsName == torqueSpanner.GoodsName &&
a.Spec == torqueSpanner.Spec
select a;
if (result.Count() == 0)
{
dataContxt.ZPX_TorqueSpanner.InsertOnSubmit(torqueSpanner);
}
else
{
error = "数据重复，请检查！";
return(false);
}
dataContxt.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 修改零件打扭矩的信息
/// </summary>
/// <param name="torqueSpanner">打扭矩数据对象</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回true 失败返回false</returns>
public bool UpdateTorqueSpanner(ZPX_TorqueSpanner torqueSpanner, out string error)
{
error = "";
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
try
{
var result = from a in dataContxt.ZPX_TorqueSpanner
where a.WorkBench == torqueSpanner.WorkBench &&
a.GoodsCode == torqueSpanner.GoodsCode &&
a.GoodsName == torqueSpanner.GoodsName &&
a.Spec == torqueSpanner.Spec
select a;
if (result.Count() != 1)
{
error = "数据错误，请检查！";
return(false);
}
else
{
ZPX_TorqueSpanner lnqTorque = result.Single();
lnqTorque.ProductType = torqueSpanner.ProductType;
lnqTorque.Seconds = torqueSpanner.Seconds;
lnqTorque.CommPort = torqueSpanner.CommPort;
lnqTorque.GoodsWorkBench = torqueSpanner.GoodsWorkBench;
lnqTorque.IsOtherWorkBenchPart = torqueSpanner.IsOtherWorkBenchPart;
lnqTorque.CommMode = torqueSpanner.CommMode;
lnqTorque.TorqueCount = torqueSpanner.TorqueCount;
}
dataContxt.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
