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