private bool SpecialProcessHandler(RepairRecordModel repairRecModel, string currlineStationID, ref bool needRepair, ref string restr) { ModuleProcessModel cuurModuleProcess = bllModuleProcess.GetProcessByID(currlineStationID); if (cuurModuleProcess == null) { restr += "当前线体服务器工位编号错误:" + currlineStationID + ",线体服务器查无此工位编号!"; needRepair = false; return(false); } ModuleProcessModel repairProcess = bllModuleProcess.GetProcessByWorkStationID(repairRecModel.RepairStartStationNum); if (repairProcess == null) { restr = "开始工位中心号错误:" + repairRecModel.RepairStartStationNum + ",线体服务查无此工作中心号!"; return(false); } if (repairProcess.LineName != cuurModuleProcess.LineName)//不在一个线别,那就用流程代号处理 { } else//在一个线别就用起始加工中心判断 { needRepair = NeedRepairByWorkstationOrder(repairRecModel.RepairStartStationNum, repairProcess.ModuleProcessID, ref restr); return(true); } return(true); }
private bool ProcessB7(RepairRecordModel repairRecModel, string lineStationID, ref bool needRepair, ref string restr) { ModuleProcessModel currProcess = bllModuleProcess.GetProcessByID(lineStationID); if (currProcess == null) { restr = "工作中心号错误:" + lineStationID + ",不存在此工作中中心号!"; return(false); } ModuleProcessModel laster1Process = bllModuleProcess.GetProcessByWorkStationID(this.laserClean1); if (laster1Process == null) { restr = "工作中心号错误:" + laster1Process.WorkStationID + ",不存在此工作中中心号!"; return(false); } if (currProcess.ModuleProcessOrder < laster1Process.ModuleProcessOrder) { restr += "当前工作中心:" + currProcess.WorkStationID + ",工艺顺序在激光清洗1#前面,不需要加工!"; needRepair = false; return(true); } if (currProcess.WorkStationID == this.glueOutCheck1 || currProcess.WorkStationID == this.laserClean2 || currProcess.WorkStationID == this.glueOutCheck2 || currProcess.WorkStationID == this.wedlAluminum2) { needRepair = false; return(true); } needRepair = true; return(true); //} //return true; }
private bool ProcessB10(RepairRecordModel repairRecModel, string lineStationID, ref bool needRepair, ref string restr) { ModuleProcessModel currProcess = bllModuleProcess.GetProcessByID(lineStationID); if (currProcess == null) { restr = "工作中心号错误:" + lineStationID + ",不存在此工作中中心号!"; return(false); } ModuleProcessModel weld2Process = bllModuleProcess.GetProcessByWorkStationID(this.wedlAluminum2); if (weld2Process == null) { restr = "工作中心号错误:" + weld2Process.WorkStationID + ",不存在此工作中中心号!"; return(false); } if (currProcess.ModuleProcessOrder < weld2Process.ModuleProcessOrder) { restr += "当前工作中心:" + currProcess.WorkStationID + ",工艺顺序在" + weld2Process.ModuleProcessName + "前面,不需要加工!"; needRepair = false; return(true); } if (currProcess.WorkStationID == this.glueOutCheck2) { needRepair = false; return(true); } needRepair = NeedRepairByWorkstationOrder(this.wedlAluminum2, lineStationID, ref restr); return(true); }
private bool ProcessB12(RepairRecordModel repairRecModel, string lineStationID, ref bool needRepair, ref string restr) { ModuleProcessModel currProcess = bllModuleProcess.GetProcessByID(lineStationID); if (currProcess == null) { restr = "工作中心号错误:" + lineStationID + ",不存在此工作中中心号!"; return(false); } ModuleProcessModel jueyuanScrew = bllModuleProcess.GetProcessByWorkStationID(this.cLineJYScrew); if (currProcess == null) { restr = "工作中心号错误:" + cLineJYScrew + ",不存在此工作中中心号!"; return(false); } if (currProcess.ModuleProcessOrder < jueyuanScrew.ModuleProcessOrder) { needRepair = false; restr = "当前工位工艺在绝缘螺丝机的前面,不需要加工!"; return(true); } needRepair = true; return(true); }
private bool ProcessB6(RepairRecordModel repairRecModel, string lineStationID, ref bool needRepair, ref string restr) { ModuleProcessModel wled2Process = bllModuleProcess.GetProcessByWorkStationID(this.wedlAluminum2); if (wled2Process == null) { restr = "工作中心号错误:" + this.wedlAluminum2 + ",不存在此工作中中心号!"; return(false); } ModuleProcessModel currModuleProcess = bllModuleProcess.GetProcessByID(lineStationID); if (wled2Process == null) { restr = "工位编号错误:" + lineStationID + ",不存在此工位编号!"; return(false); } if (currModuleProcess.ModuleProcessOrder < wled2Process.ModuleProcessOrder) { restr = "当前加工工作中心:" + currModuleProcess.WorkStationID + ",工艺顺序在铝丝焊2#工位前,不需要加工!"; needRepair = false; return(true); } needRepair = NeedRepairByWorkstationOrder(this.wedlAluminum2, lineStationID, ref restr); return(true); }
public ActionResult EditRecord(RepairRecordModel model) { var result = RepairRecordBLL.EditRepairRecord(model, base.UserIDForLog); base.DoLog(OperationTypeEnum.Edit, result, "PlateNum:" + model.PlateNum); return(Json(result)); }
private bool ProcessB2(RepairRecordModel repairRecModel, string lineStationID, ref bool needRepair, ref string restr) { ModuleProcessModel cuurModuleProcess = bllModuleProcess.GetProcessByID(lineStationID); if (cuurModuleProcess == null) { restr += "当前线体服务器工位编号错误:" + lineStationID + ",线体服务器查无此工位编号!"; needRepair = false; return(false); } ModuleProcessModel laserClean1Procss = bllModuleProcess.GetProcessByWorkStationID(this.laserClean1); if (laserClean1Procss == null) { restr += "工作中心号:" + laserClean1 + ",线体服务器查无此工作中心号!"; return(false); } if (cuurModuleProcess.WorkStationID == this.glueOutCheck1) { needRepair = false; restr += "当前工作中心号:" + cuurModuleProcess.WorkStationID + "为1号胶溢检测不需要加工!"; return(true); } if (cuurModuleProcess.ModuleProcessOrder < laserClean1Procss.ModuleProcessOrder) { needRepair = false; restr += "当前工作中心号:" + cuurModuleProcess.WorkStationID + "工艺顺序在1#激光清洗工艺前面,不需要加工!"; return(true); } ModuleProcessModel aluminumProecss = bllModuleProcess.GetProcessByWorkStationID(this.weldAluminum1); if (aluminumProecss == null) { restr += "铝丝焊1#:" + weldAluminum1 + ",线体服务器不存在此工作中心号!"; return(false); } if (cuurModuleProcess.ModuleProcessOrder >= aluminumProecss.ModuleProcessOrder) { restr += "当前工作中心:" + cuurModuleProcess.WorkStationID + "工艺顺序在铝丝焊1#工艺之后,需要加工!"; needRepair = true; return(true); } needRepair = true; return(true); }
private bool ProcessB9(RepairRecordModel repairRecModel, string lineStationID, ref bool needRepair, ref string restr) { ModuleProcessModel currProcess = bllModuleProcess.GetProcessByID(lineStationID); if (currProcess == null) { restr = "工作中心号错误:" + lineStationID + ",不存在此工作中中心号!"; return(false); } ModuleProcessModel laserClean2Process = bllModuleProcess.GetProcessByWorkStationID(this.laserClean2); if (laserClean2Process == null) { restr = "工作中心号错误:" + laserClean2Process.WorkStationID + ",不存在此工作中中心号!"; return(false); } if (currProcess.WorkStationID == this.laserClean2) { restr += "激光清洗2#需要加工!"; needRepair = true; return(true); } if (currProcess.ModuleProcessOrder < laserClean2Process.ModuleProcessOrder) { restr += "当前工作中心:" + currProcess.WorkStationID + ",工艺顺序在" + laserClean2Process.ModuleProcessName + "前面,不需要加工!"; needRepair = false; return(true); } if (currProcess.WorkStationID == this.glueOutCheck2) { restr = "当前工作中心号:" + this.glueOutCheck2 + ",胶外溢2,此工作中心不需要加工!"; needRepair = false; return(true); } //ModuleProcessModel weld2Process = bllModuleProcess.GetProcessByWorkStationID(this.wedlAluminum2); // if (weld2Process == null) //{ // restr = "工作中心号错误:" + this.wedlAluminum2 + ",不存在此工作中中心号!"; // return false; //} needRepair = NeedRepairByWorkstationOrder(this.wedlAluminum2, lineStationID, ref restr); return(true); }
public bool ReportToMesByProcessStationID(string stationID, string rfid) { List <DBAccess.Model.BatteryModuleModel> modList = modBll.GetModelList(string.Format("palletID='{0}' and palletBinded=1", rfid)); if (modList == null || modList.Count == 0) { this.nodeBase.LogRecorder.AddDebugLog(this.nodeBase.NodeName, "返修流程不加工工位:" + stationID + ",RFID:" + rfid + ",绑定数据为空,不需要上传数据!"); return(true); } RepairRecordModel repairRecModel = bllRepairRecord.GetModel(modList[0].batModuleID); if (repairRecModel == null)//如果没有这个记录则不为返修流程 { this.nodeBase.LogRecorder.AddDebugLog(this.nodeBase.NodeName, "返修记录不存在二维码:" + modList[0].batModuleID + ",不需要上传数据!"); return(true); } DBAccess.Model.ModuleProcessModel startModuleProcess = bllModuleProcess.GetProcessByWorkStationID(repairRecModel.RepairStartStationNum); if (startModuleProcess == null) { this.nodeBase.LogRecorder.AddDebugLog(this.nodeBase.NodeName, "起始加工中心编号:" + repairRecModel.RepairStartStationNum + "错误,没有此加工中心编号!"); } DBAccess.Model.ModuleProcessModel currModuleProcess = bllModuleProcess.GetProcessByID(stationID); if (currModuleProcess == null) { this.nodeBase.LogRecorder.AddDebugLog(this.nodeBase.NodeName, "工位编号错误:" + stationID + ",无此工位编号"); return(false); } if (currModuleProcess.ModuleProcessOrder < startModuleProcess.ModuleProcessOrder) { this.nodeBase.LogRecorder.AddDebugLog(this.nodeBase.NodeName, "开始工位工艺前面的工位不需要上传MES数据!"); return(true); } FTDataAccess.Model.OfflineDataModel offlineData = bllOfflineData.GetLastDataByWorkStationID(currModuleProcess.WorkStationID); if (offlineData == null) { this.nodeBase.LogRecorder.AddDebugLog(this.nodeBase.NodeName, "获取上一次加工数据失败,工作中心号:" + currModuleProcess.WorkStationID + ",上报MES失败!"); return(false); } RootObject rootObj = WShelper.UploadDataByJson(offlineData.UploadJsonData); this.nodeBase.LogRecorder.AddDebugLog(this.nodeBase.NodeName, "返修流程," + currModuleProcess.ModuleProcessName + ",不加工工作中心上传MES正常数据成功:" + currModuleProcess.WorkStationID + ",数据:" + offlineData.UploadJsonData); return(true); }
private bool ProcessB11(RepairRecordModel repairRecModel, string lineStationID, ref bool needRepair, ref string restr) { ModuleProcessModel currProcess = bllModuleProcess.GetProcessByID(lineStationID); if (currProcess == null) { restr = "工作中心号错误:" + lineStationID + ",不存在此工作中中心号!"; return(false); } if (currProcess.WorkStationID == this.dcir) { needRepair = true; return(true); } needRepair = false; return(true); }
private bool ProcessB8(RepairRecordModel repairRecModel, string lineStationID, ref bool needRepair, ref string restr) { ModuleProcessModel currProcess = bllModuleProcess.GetProcessByID(lineStationID); if (currProcess == null) { restr = "工作中心号错误:" + lineStationID + ",不存在此工作中中心号!"; return(false); } ModuleProcessModel weldProcess = bllModuleProcess.GetProcessByWorkStationID(this.weldAluminum1); if (weldProcess == null) { restr = "工作中心号错误:" + weldProcess.WorkStationID + ",不存在此工作中中心号!"; return(false); } if (currProcess.ModuleProcessOrder < weldProcess.ModuleProcessOrder) { restr += "当前工作中心:" + currProcess.WorkStationID + ",工艺顺序在铝丝焊1#前面,不需要加工!"; needRepair = false; return(true); } if (currProcess.WorkStationID == this.laserClean2 || currProcess.WorkStationID == this.glueOutCheck2 || currProcess.WorkStationID == this.wedlAluminum2) { needRepair = false; restr += "当前工作中心:" + currProcess.WorkStationID + ",不需要加工!"; return(true); } if (currProcess.WorkStationID == this.dcir) { restr += "当前工作中心:" + currProcess.WorkStationID + "DCIR工位,需要加工!"; needRepair = true; return(true); } needRepair = true; return(true); }
public static SelectResult <RepairRecordModel> GetRecordByID(int id) { List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter("@id", SqlDbType.Int), }; paras[0].Value = id; string sql = @"SELECT * FROM dbo.RepairRecord WHERE ID=@id"; List <RepairRecordModel> list = ConvertToList <RepairRecordModel> .Convert(MSSQLHelper.ExecuteDataTable(CommandType.Text, sql, paras.ToArray())); RepairRecordModel data = null; string msg = string.Empty; if (list == null) { msg = PromptInformation.DBError; } else if (list.Count == 0) { msg = PromptInformation.NotExists; } else { data = list[0]; } string recordsql = @"select * from dbo.RepairRecordDetail where LinkedRecordID=@id"; List <SqlParameter> paras1 = new List <SqlParameter>() { new SqlParameter("@id", SqlDbType.Int), }; paras1[0].Value = id; List <RepairRecordDetail> detaillist = ConvertToList <RepairRecordDetail> .Convert(MSSQLHelper.ExecuteDataTable(CommandType.Text, recordsql, paras1.ToArray())); data.RepairRecordDetail = detaillist; data.RepairStartTime = Convert.ToDateTime(data.RepairStartTime).ToString("yyyy-MM-dd"); data.RepairEndTime = Convert.ToDateTime(data.RepairEndTime).ToString("yyyy-MM-dd"); return(new SelectResult <RepairRecordModel>() { DataResult = data, Message = msg }); }
public static OperationResult EditRepairRecord(RepairRecordModel model, int ID) { #region SQL string sql = @"IF exists (SELECT * FROM RepairRecord WHERE ID=@ID and Status<>1) begin update RepairRecord set [PlateNum]=@PlateNum,[DriverName]=@DriverName,[DriverPhone]=@DriverPhone ,[RepairStartTime]=@RepairStartTime, [RepairEndTime]=@RepairEndTime ,[RepairType]=@RepairType,[TotalPrice]=@TotalPrice,[Status]=@Status,LinkedVehicleID=@LinkedVehicleID,Remark=@Remark,OperateTime=getdate(),OperateUserID=@OperateUserID where ID=@ID; delete from RepairRecordDetail where LinkedRecordID=@ID end "; #endregion List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter("@PlateNum", SqlDbType.NVarChar, 10), new SqlParameter("@DriverName", SqlDbType.NVarChar, 20), new SqlParameter("@DriverPhone", SqlDbType.NVarChar, 20), new SqlParameter("@RepairType", SqlDbType.NVarChar, 20), new SqlParameter("@RepairStartTime", SqlDbType.Date), new SqlParameter("@RepairEndTime", SqlDbType.Date), new SqlParameter("@TotalPrice", SqlDbType.Float), new SqlParameter("@Status", SqlDbType.Int), new SqlParameter("@ID", SqlDbType.BigInt), new SqlParameter("@LinkedVehicleID", SqlDbType.Int), new SqlParameter("@Remark", SqlDbType.NVarChar, 2000), new SqlParameter("@OperateUserID", SqlDbType.Int) }; paras[0].Value = model.PlateNum.Trim(); paras[1].Value = string.IsNullOrWhiteSpace(model.DriverName) ? DBNull.Value : (object)model.DriverName.Trim(); paras[2].Value = string.IsNullOrWhiteSpace(model.DriverPhone) ? DBNull.Value : (object)model.DriverPhone.Trim(); paras[3].Value = string.IsNullOrWhiteSpace(model.RepairType) ? DBNull.Value : (object)model.RepairType.Trim(); paras[4].Value = model.RepairStartTime; paras[5].Value = model.RepairEndTime; paras[6].Value = string.IsNullOrWhiteSpace(model.TotalPrice) ? DBNull.Value : (object)model.TotalPrice; paras[7].Value = 0; paras[8].Value = model.ID; paras[9].Value = model.LinkedVehicleID; paras[10].Value = string.IsNullOrWhiteSpace(model.Remark) ? DBNull.Value : (object)model.Remark; paras[11].Value = ID; //bool result = MSSQLHelper.ExecuteTransaction(CommandType.Text, sql, paras.ToArray()); bool result = false; SqlConnection myConnection = new SqlConnection(ConnStr); myConnection.Open(); SqlTransaction myTrans = myConnection.BeginTransaction(); SqlCommand cmd = new SqlCommand(); cmd.Connection = myConnection; cmd.Transaction = myTrans; SqlParameter[] commandParameters = paras.ToArray(); try { if (commandParameters == null) { MSSQLHelper.PrepareCommand(cmd, myConnection, null, CommandType.Text, sql, null, 60); } else { MSSQLHelper.PrepareCommand(cmd, myConnection, null, CommandType.Text, sql, commandParameters, 60); } int i = cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); //内容被审核 if (i <= 0) { myTrans.Rollback(); return(new OperationResult() { Success = false, Message = PromptInformation.StatusChange }); } else { //插入项目明细 foreach (var reecorddetail in model.RepairRecordDetail) { reecorddetail.LinkedRecordID = model.ID; } SaveRepairRecordDetail(model.RepairRecordDetail, "RepairRecordDetail"); result = true; myTrans.Commit(); } } catch (Exception e) { myTrans.Rollback(); LogHelper.DoDataBaseErrorLog("维修单修改:" + e.ToString()); result = false; } return(new OperationResult() { Success = result, Message = result ? PromptInformation.OperationSuccess : PromptInformation.DBError }); }
private bool CCDCheckNeedRepair(RepairRecordModel repairRecModel, string currlineStationID, ref string restr) { restr = "流程匹配,需要返修!"; if (repairRecModel.RepairProcessNum == "A4") { if (repairRecModel.RepairStartStationNum != this.dianjiao3) { restr = "返修MES判定在CCD检测,流程代码为A4,起始工位不为3号点胶机"; return(NeedRepairByWorkstationOrder(repairRecModel.RepairStartStationNum, currlineStationID, ref restr)); } return(NeedRepairByWorkstationOrder(this.dianjiao3, currlineStationID, ref restr)); } else if (repairRecModel.RepairProcessNum == "A5") { if (repairRecModel.RepairStartStationNum != this.dianjiao3) { restr = "返修MES判定在CCD检测,流程代码为A5,起始工位不为3号点胶机"; return(NeedRepairByWorkstationOrder(repairRecModel.RepairStartStationNum, currlineStationID, ref restr)); } //if (repairRecModel.RepairStartStationNum != this.dianjiao3) //{ // restr = "返修MES判定在CCD检测,流程代码为A5,起始工位不为3号点胶机"; // return NeedRepairByWorkstationOrder(repairRecModel, currlineStationID); //} ModuleProcessModel cuurModuleProcess = bllModuleProcess.GetProcessByID(currlineStationID); if (cuurModuleProcess == null) { restr = "开始工位中心号错误:" + currlineStationID + ",线体服务查无此线体服务编号!"; return(false); } if (cuurModuleProcess.WorkStationID == this.ccdCheck || cuurModuleProcess.WorkStationID == this.dianjiao3 || cuurModuleProcess.WorkStationID == this.manualSation2) { restr = "当前返修流程代号A5,加工中心号" + cuurModuleProcess.WorkStationID + ",需要加工!"; return(true); } else { restr = "当前返修流程代号A5,加工中心号" + cuurModuleProcess.WorkStationID + ",不需要加工!"; return(false); } } else if (repairRecModel.RepairProcessNum == "A6") { if (repairRecModel.RepairStartStationNum != this.dianjiao4) { restr = "返修MES判定在CCD检测,流程代码为A6,起始工位不为4号点胶机"; return(NeedRepairByWorkstationOrder(repairRecModel.RepairStartStationNum, currlineStationID, ref restr)); } return(NeedRepairByWorkstationOrder(this.dianjiao4, currlineStationID, ref restr)); } else if (repairRecModel.RepairProcessNum == "A7") { ModuleProcessModel cuurModuleProcess = bllModuleProcess.GetProcessByID(currlineStationID); if (cuurModuleProcess == null) { restr = "开始工位中心号错误:" + currlineStationID + ",线体服务查无此线体服务编号!"; return(false); } if (cuurModuleProcess.WorkStationID != this.ccdCheck) { restr = "返修MES判定在CCD检测,流程代码为A7,起始工位不为CCCheck"; //return NeedRepairByWorkstationOrder(repairRecModel.RepairStartStationNum, currlineStationID,ref restr); return(false); } //if(repairRecModel.RepairStartStationNum!=currlineStationID) //{ // restr = "流程代码为A7,当前工位不为CCDCheck,不需要加工!"; // return false; //} return(true); } else { return(true); } }
/// <summary> /// 是否需要返修,只有AB线绑定工位是通过PLC地址判断其他工位只读取数据库判断 /// </summary> /// <param name="moduleID">模块ID</param> /// <returns></returns> public virtual bool GetNeedRepairALine(string rfid, string lineStationID, ref bool needRepair, ref string restr) { restr = "获取是否需要加工成功!"; this.NeedRepair = needRepair; if (this.repairManualNoWorkRequireDic.Keys.Contains(this.nodeBase.NodeID) == true) { string manualRepairAddr = this.repairManualNoWorkRequireDic[this.nodeBase.NodeID]; int noWorkStatus = 0;//返修人工干预不加工标识,等于1不加工,直接放行 if (this.nodeBase.PlcRW.ReadDB(manualRepairAddr, ref noWorkStatus) == false) { restr = "读取返修人工干预是否加工标识地址:" + manualRepairAddr + ",失败"; return(false); } this.nodeBase.LogRecorder.AddDebugLog(this.nodeBase.NodeName, "读取返修人工干预是否加工标识地址:" + manualRepairAddr + "成功,值为:" + noWorkStatus + "!"); if (noWorkStatus == 1) { needRepair = false; return(true); } } List <DBAccess.Model.BatteryModuleModel> modList = modBll.GetModelList(string.Format("palletID='{0}' and palletBinded=1 or checkResult=2", rfid)); if (modList == null || modList.Count == 0) { restr = "RFID:" + rfid + "绑定数据为空!"; needRepair = false; return(true); } RepairRecordModel repairRecModel = bllRepairRecord.GetModel(modList[0].batModuleID); if (repairRecModel == null)//如果没有这个记录则不为返修流程 { needRepair = true; this.nodeBase.LogRecorder.AddDebugLog(this.nodeBase.NodeName, "返修记录不存在二维码:" + modList[0].batModuleID + ",不为返修流程所有工位,需要加工!"); return(true); } ModuleProcessModel cuurModuleProcess = bllModuleProcess.GetProcessByID(lineStationID); if (cuurModuleProcess == null) { restr += "当前线体服务器工位编号错误:" + lineStationID + ",线体服务器查无此工位编号!"; needRepair = false; return(false); } ModuleProcessModel repairProcess = bllModuleProcess.GetProcessByWorkStationID(repairRecModel.RepairStartStationNum); if (repairProcess == null) { restr = "开始工位中心号错误:" + repairRecModel.RepairStartStationNum + ",线体服务查无此工作中心号!"; return(false); } if (repairRecModel.RepairRec_Reserve1 == true.ToString()) //特殊产品流程 { if (repairProcess.LineName == cuurModuleProcess.LineName) //在一个线别就用起始加工中心判断 { needRepair = NeedRepairByWorkstationOrder(repairRecModel.RepairStartStationNum, cuurModuleProcess.ModuleProcessID, ref restr); return(true); } else//在一个线别,那就用流程代号处理,不用处理了 就用下面的流程 { } } if (repairRecModel.IsMatchRepairProcess == false && repairRecModel.RepairRec_Reserve1 == false.ToString()) { this.nodeBase.LogRecorder.AddDebugLog(this.nodeBase.NodeName, "流程不匹配,当前工位需要加工!"); needRepair = NeedRepairByWorkstationOrder(repairRecModel.RepairStartStationNum, lineStationID, ref restr); return(true); } if (repairRecModel.RepairProcessNum == "A4" || repairRecModel.RepairProcessNum == "A5" || repairRecModel.RepairProcessNum == "A6" || repairRecModel.RepairProcessNum == "A7") //CCD检测单独判断 { needRepair = CCDCheckNeedRepair(repairRecModel, lineStationID, ref restr); return(true); } if (repairProcess.ModuleProcessOrder <= cuurModuleProcess.ModuleProcessOrder) { needRepair = true; this.nodeBase.LogRecorder.AddDebugLog(this.nodeBase.NodeName, "当前工位在开始工位或者在开始工位后续流程中,此工位需要加工!"); return(true); } return(true); }
private bool ProcessB4(RepairRecordModel repairRecModel, string lineStationID, ref bool needRepair, ref string restr) { needRepair = NeedRepairByWorkstationOrder(this.laserClean2, lineStationID, ref restr); return(true); }
private bool ProcessB1(RepairRecordModel repairRecModel, string lineStationID, ref bool needRepair, ref string restr) { needRepair = NeedRepairByWorkstationOrder(repairRecModel.RepairStartStationNum, lineStationID, ref restr); return(true); }
public static OperationResult AddRepairRecord(RepairRecordModel model, int ID) { #region SQL string sql = @" Declare @id BIGINT; INSERT INTO [TMS2016].[dbo].[RepairRecord] ([PlateNum] ,[DriverName] ,[DriverPhone] ,[RepairStartTime] ,[RepairEndTime] ,[RepairType] ,[TotalPrice] ,[Status],[LinkedVehicleID],[Remark],OperateUserID) VALUES (@PlateNum ,@DriverName ,@DriverPhone ,@RepairStartTime ,@RepairEndTime ,@RepairType ,@TotalPrice ,@Status,@LinkedVehicleID,@Remark,@OperateUserID); set @id=SCOPE_IDENTITY(); select @id as ID;"; #endregion List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter("@PlateNum", SqlDbType.NVarChar, 10), new SqlParameter("@DriverName", SqlDbType.NVarChar, 20), new SqlParameter("@DriverPhone", SqlDbType.NVarChar, 20), new SqlParameter("@RepairType", SqlDbType.NVarChar, 20), new SqlParameter("@RepairStartTime", SqlDbType.Date), new SqlParameter("@RepairEndTime", SqlDbType.Date), new SqlParameter("@TotalPrice", SqlDbType.Float), new SqlParameter("@Status", SqlDbType.Int), new SqlParameter("@LinkedVehicleID", SqlDbType.Int), new SqlParameter("@Remark", SqlDbType.NVarChar, 2000), new SqlParameter("@OperateUserID", SqlDbType.Int) }; paras[0].Value = model.PlateNum.Trim(); paras[1].Value = string.IsNullOrWhiteSpace(model.DriverName) ? DBNull.Value : (object)model.DriverName.Trim(); paras[2].Value = string.IsNullOrWhiteSpace(model.DriverPhone) ? DBNull.Value : (object)model.DriverPhone.Trim(); paras[3].Value = string.IsNullOrWhiteSpace(model.RepairType) ? DBNull.Value : (object)model.RepairType.Trim(); paras[4].Value = model.RepairStartTime; paras[5].Value = model.RepairEndTime; paras[6].Value = string.IsNullOrWhiteSpace(model.TotalPrice) ? DBNull.Value : (object)model.TotalPrice; paras[7].Value = 0; paras[8].Value = model.LinkedVehicleID; paras[9].Value = string.IsNullOrWhiteSpace(model.Remark) ? DBNull.Value : (object)model.Remark; paras[10].Value = ID; bool result = false; List <RecordID> recordid = ConvertToList <RecordID> .Convert(MSSQLHelper.ExecuteDataTable(CommandType.Text, sql, paras.ToArray())); try { int id = recordid[0].ID; foreach (var reecorddetail in model.RepairRecordDetail) { reecorddetail.LinkedRecordID = id; } SaveRepairRecordDetail(model.RepairRecordDetail, "RepairRecordDetail"); result = true; } catch (Exception e) { LogHelper.DoDataBaseErrorLog("维修单详情错误记录:" + e.ToString()); result = false; } return(new OperationResult() { Success = result, Message = result ? PromptInformation.OperationSuccess : PromptInformation.DBError }); }
private bool ProcessB3(RepairRecordModel repairRecModel, string lineStationID, ref bool needRepair, ref string restr) { needRepair = NeedRepairByWorkstationOrder(this.weldAluminum1, lineStationID, ref restr); return(true); }