public Get_Out End(string data) { Get_Out OutResult = new Get_Out(); Get_In_setToWorkOut input = Newtonsoft.Json.JsonConvert.DeserializeObject<Get_In_setToWorkOut>(data); try { DBStep db = new DBStep(); if (input.nWorkTypeID == 1) { db.UpdateToYiChuQin(input.strTrainPlanGUID, input.dtConfirmTime, input.strConfirmBrief, input.strUserName, input.strUserNumber, input.nWorkTypeID); } else if (input.nWorkTypeID == 2) { db.UpdateToYiTuiQin(input.strTrainPlanGUID, input.strSiteGUID, input.dtConfirmTime, input.strConfirmBrief, input.strUserName, input.strUserNumber, 2); } OutResult.result = "0"; OutResult.resultStr = "执行成功!"; } catch (Exception ex) { OutResult.result = "1"; OutResult.resultStr = "提交失败:" + ex.Message; } return OutResult; }
public override void CheckIsSpecialStep() { DBStep db = new DBStep(); //检测是否是特殊步骤 if (db.CheckIsSpecialStep(WorkType.TQZhuanChu, input.strWorkShopGUID, base._nWorkTypeID)) { DBStep dbStep = new DBStep(); dbStep.UpdateToYiTuiQin(input.strTrainPlanGUID, input.runRecordFileMain.strSiteNumber, DateTime.Now, "", "", "", 2); } }
private void SaveDrinkStepData(string strTrainPlanGUID, string strTrainmanGUID, string strTrainmanNumber, string strTainmanName, InSubmitDrink InParams, int nWorkTypeID, string strStepName) { DBStep db = new DBStep(); #region 出勤步骤结果的实体信息 StepResult StepResult = new StepResult(); StepResult.dtBeginTime = ObjectConvertClass.static_ext_date(InParams.DrinkInfo.createTime); StepResult.dtCreateTime = ObjectConvertClass.static_ext_date(InParams.DrinkInfo.createTime); StepResult.dtEndTime = ObjectConvertClass.static_ext_date(InParams.DrinkInfo.createTime); int nStepIndex = db.getIndexOfStep(InParams.DrinkInfo.strWorkShopGUID, "RS.STEP.DRINKTEST", nWorkTypeID); StepResult.nStepIndex = nStepIndex; StepResult.strStepBrief = nWorkTypeID == 1?"出勤测酒":"退勤测酒"; StepResult.strStepName = strStepName; StepResult.strTrainPlanGUID = strTrainPlanGUID; StepResult.strTrainmanGUID = InParams.DrinkInfo.trainmanID; StepResult.strTrainmanNumber = strTrainmanNumber; StepResult.strTrainmanName = InParams.DrinkInfo.strTrainmanName; StepResult.nWorkTypeID = nWorkTypeID; StepResult.nStepResult = 1; #endregion #region 出勤步骤索引信息 DateTime dtStartTime = GetdtStartTime(strTrainPlanGUID); string npost = getTmPost(strTrainPlanGUID, strTrainmanNumber); List <StepIndex> LStepIndex = new List <StepIndex>(); StepIndex StepIndex = new StepIndex(); StepIndex.dtStartTime = ObjectConvertClass.static_ext_date(dtStartTime); StepIndex.strFieldName = "nDrinkResult"; StepIndex.nStepData = int.Parse(InParams.DrinkInfo.drinkResult); StepIndex.strTrainmanNumber = strTrainmanNumber; StepIndex.strTrainPlanGUID = strTrainPlanGUID; StepIndex.nWorkTypeID = nWorkTypeID; LStepIndex.Add(StepIndex); StepIndex StepIndex2 = new StepIndex(); StepIndex2.dtStartTime = ObjectConvertClass.static_ext_date(dtStartTime); StepIndex2.strTrainmanNumber = strTrainmanNumber; StepIndex2.strTrainPlanGUID = strTrainPlanGUID; StepIndex2.strFieldName = "LateTimeDiff"; DateTime dt1 = Convert.ToDateTime(DateTime.Now); DateTime dt2 = Convert.ToDateTime(dtStartTime); TimeSpan ts = dt1 - dt2; StepIndex2.nStepData = Convert.ToInt32(ts.TotalMinutes); StepIndex2.nWorkTypeID = nWorkTypeID; LStepIndex.Add(StepIndex2); StepIndex StepIndex3 = new StepIndex(); StepIndex3.dtStartTime = ObjectConvertClass.static_ext_date(dtStartTime); StepIndex3.strTrainmanNumber = strTrainmanNumber; StepIndex3.strTrainPlanGUID = strTrainPlanGUID; StepIndex3.strFieldName = "bbtimediff"; StepIndex3.nWorkTypeID = nWorkTypeID; StepIndex3.nStepData = GetdtStartTimeDiff(strTrainPlanGUID, Convert.ToDateTime(InParams.DrinkInfo.createTime)); LStepIndex.Add(StepIndex3); #endregion #region 出勤步骤详细信息 List <StepData> LStepData = new List <StepData>(); StepData StepData1 = new StepData(); StepData1.strTrainPlanGUID = strTrainPlanGUID; StepData1.strFieldName = "nDrinkResult" + npost; StepData1.strStepName = strStepName; StepData1.strTrainmanNumber = strTrainmanNumber; StepData1.nWorkTypeID = nWorkTypeID; StepData1.nStepData = int.Parse(InParams.DrinkInfo.drinkResult); LStepData.Add(StepData1); StepData StepData2 = new StepData(); StepData2.strTrainPlanGUID = strTrainPlanGUID; StepData2.strFieldName = "LateTimeDiff" + npost; StepData2.strTrainmanNumber = strTrainmanNumber; StepData2.strStepName = strStepName; StepData2.nWorkTypeID = nWorkTypeID; StepData2.nStepData = Convert.ToInt32(ts.TotalMinutes); LStepData.Add(StepData2); StepData StepData3 = new StepData(); StepData3.strTrainPlanGUID = strTrainPlanGUID; StepData3.strFieldName = "dtEventTime" + npost; StepData3.strTrainmanNumber = strTrainmanNumber; StepData3.strStepName = strStepName; StepData3.nWorkTypeID = nWorkTypeID; StepData3.dtStepData = ObjectConvertClass.static_ext_date(InParams.DrinkInfo.createTime); LStepData.Add(StepData3); StepData StepData4 = new StepData(); StepData4.strTrainPlanGUID = strTrainPlanGUID; StepData4.strFieldName = "picture" + npost; StepData4.strTrainmanNumber = strTrainmanNumber; StepData4.strStepName = strStepName; StepData4.nWorkTypeID = nWorkTypeID; StepData4.strStepData = ObjectConvertClass.static_ext_string(InParams.DrinkInfo.imagePath); LStepData.Add(StepData4); StepData StepData5 = new StepData(); StepData5.strTrainPlanGUID = strTrainPlanGUID; StepData5.strFieldName = "nVerifyID" + npost; StepData5.strTrainmanNumber = strTrainmanNumber; StepData5.strStepName = strStepName; StepData5.nWorkTypeID = nWorkTypeID; StepData5.nStepData = ObjectConvertClass.static_ext_int(InParams.VerifyID); LStepData.Add(StepData5); #endregion db.AddStep(LStepIndex, LStepData, StepResult); List <trainmanList> trainmanlist = new List <trainmanList>(); trainmanList trainman = new trainmanList(); trainman.strTrainmanGUID = strTrainmanGUID; trainmanlist.Add(trainman); //检测是否是特殊步骤 if (db.CheckIsSpecialStep(strStepName, InParams.DrinkInfo.strWorkShopGUID, nWorkTypeID)) { if (CheckIsCejiuAll(strTrainPlanGUID, nWorkTypeID)) { if (nWorkTypeID == 1) { db.UpdateToYiChuQin(strTrainPlanGUID, DateTime.Now, "", "", "", nWorkTypeID); } else if (nWorkTypeID == 2) { DBStep dal = new DBStep(); dal.UpdateToYiTuiQin(InParams.TrainPlanGUID, InParams.DrinkInfo.strSiteGUID, DateTime.Now, "", "", "", 2); } } } //检测是否是断网测酒 if (getSetTime(InParams.DrinkInfo.strWorkShopGUID, nWorkTypeID) > Convert.ToDateTime(InParams.DrinkInfo.createTime)) { if (CheckIsCejiuAll(strTrainPlanGUID, nWorkTypeID)) { if (nWorkTypeID == 1) { db.UpdateToYiChuQin(strTrainPlanGUID, DateTime.Now, "", "", "", nWorkTypeID); } else if (nWorkTypeID == 2) { DBStep dal = new DBStep(); dal.UpdateToYiTuiQin(InParams.TrainPlanGUID, InParams.DrinkInfo.strSiteGUID, DateTime.Now, "", "", "", 2); } } } }