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