//从数据行中读取数据到TuiQinPlan中
public static void EndworkFromDB(TuiQinPlan Plan, DataRow dr)
{
TrainPlanFromDB(Plan.trainPlan, dr);
GroupFromDB(Plan.tuiqinGroup.group, dr);
Plan.beginWorkTime = Plan.trainPlan.kaiCheTime.ToString("yyyy-MM-dd HH:mm:ss");
//Plan.tuiqinGroup.isOver = dr["bIsOver"].ToString();
//Plan.tuiqinGroup.signed = dr["bSigned"].ToString();
Plan.tuiqinGroup.testAlcoholInfo1.testAlcoholResult = TFParse.DBToInt(dr["nDrinkResult1"], 0);
Plan.tuiqinGroup.testAlcoholInfo1.testTime = TFParse.DBToDateTime(dr["dtTestTime1"], DateTime.Parse("1899-01-01")).ToString("yyyy-MM-dd HH:mm:ss");
//Plan.tuiqinGroup.testAlcoholInfo1.picture = dr["Picture1"].ToString();
Plan.tuiqinGroup.testAlcoholInfo2.testAlcoholResult = TFParse.DBToInt(dr["nDrinkResult2"], 0);
Plan.tuiqinGroup.testAlcoholInfo2.testTime = TFParse.DBToDateTime(dr["dtTestTime2"], DateTime.Parse("1899-01-01")).ToString("yyyy-MM-dd HH:mm:ss");
//Plan.tuiqinGroup.testAlcoholInfo2.picture = dr["Picture2"].ToString();
Plan.tuiqinGroup.testAlcoholInfo3.testAlcoholResult = TFParse.DBToInt(dr["nDrinkResult3"], 0);
Plan.tuiqinGroup.testAlcoholInfo3.testTime = TFParse.DBToDateTime(dr["dtTestTime3"], DateTime.Parse("1899-01-01")).ToString("yyyy-MM-dd HH:mm:ss");
//Plan.tuiqinGroup.testAlcoholInfo3.picture = dr["Picture3"].ToString();
Plan.tuiqinGroup.testAlcoholInfo4.testAlcoholResult = TFParse.DBToInt(dr["nDrinkResult4"], 0);
Plan.tuiqinGroup.testAlcoholInfo4.testTime = TFParse.DBToDateTime(dr["dtTestTime4"], DateTime.Parse("1899-01-01")).ToString("yyyy-MM-dd HH:mm:ss");
//Plan.tuiqinGroup.testAlcoholInfo4.picture = dr["Picture4"].ToString();
//Plan.tuiqinGroup.turnAlarmMinutes = dr["nTurnAlarmMinutes"].ToString();
//Plan.tuiqinGroup.turnMinutes = dr["nTurnMinutes"].ToString() ;
//Plan.tuiqinGroup.turnStartTime = TFParse.DBToDateTime(dr["dtTurnStartTime"], DateTime.Parse("1899-01-01")).ToString("yyyy-MM-dd HH:mm:ss");
Plan.tuiqinGroup.verifyID1 = TFParse.DBToInt(dr["nVerifyID1"].ToString(), 0);
Plan.tuiqinGroup.verifyID2 = TFParse.DBToInt(dr["nVerifyID2"].ToString(), 0);
Plan.tuiqinGroup.verifyID3 = TFParse.DBToInt(dr["nVerifyID3"].ToString(), 0);
Plan.tuiqinGroup.verifyID4 = TFParse.DBToInt(dr["nVerifyID4"].ToString(), 0);
}
public List <TuiQinPlan> GetPlanList(List <MDEndWork_Full> vPlans)
{
List <TuiQinPlan> lPlans = new List <TuiQinPlan>();
TuiQinPlan clientPlan = null;
if (vPlans != null)
{
foreach (MDEndWork_Full plan in vPlans)
{
clientPlan = new TuiQinPlan();
TuiQinGroup tuiqinGroup = new TuiQinGroup();
clientPlan.tuiqinGroup = tuiqinGroup;
tuiqinGroup.group = new NameGroup();
DutyPlace cPlace = new DutyPlace();
tuiqinGroup.group.place = cPlace;
cPlace.placeID = plan.strPlaceID;
cPlace.placeName = plan.strPlaceName;
tuiqinGroup.group.groupID = plan.strGroupGUID;
clientPlan.trainPlan = new TrainPlan();
clientPlan.trainPlan.createSiteGUID = plan.strCreateSiteGUID;
clientPlan.trainPlan.createSiteName = plan.strCreateSiteName;
if (plan.dtCreateTime.HasValue)
{
clientPlan.trainPlan.createTime = plan.dtCreateTime.Value;
}
clientPlan.trainPlan.createUserGUID = plan.strCreateUserGUID;
clientPlan.trainPlan.createUserName = plan.strCreateUserName;
clientPlan.trainPlan.dragTypeID = plan.nDragType.ToString();
clientPlan.trainPlan.dragTypeName = plan.nDragTypeName;
clientPlan.trainPlan.endStationID = plan.strEndStation;
clientPlan.trainPlan.endStationName = plan.strEndStationName;
clientPlan.trainPlan.kehuoID = plan.nKehuoID.ToString();
clientPlan.trainPlan.kehuoName = plan.strKehuoName;
clientPlan.trainPlan.mainPlanGUID = plan.strMainPlanGUID;
clientPlan.trainPlan.placeID = plan.strPlaceID;
clientPlan.trainPlan.placeName = plan.strPlaceName;
if (plan.nPlanState.HasValue)
{
clientPlan.trainPlan.planStateID = plan.nPlanState.Value;
}
clientPlan.trainPlan.planStateName = plan.strPlanStateName;
clientPlan.trainPlan.planTypeID = plan.nPlanType.ToString();
clientPlan.trainPlan.planTypeName = plan.strPlanTypeName;
clientPlan.trainPlan.remarkTypeID = plan.nRemarkType.ToString();
clientPlan.trainPlan.remarkTypeName = plan.strRemarkTypeName;
clientPlan.trainPlan.startStationID = plan.strStartStation;
clientPlan.trainPlan.startStationName = plan.strStartStationName;
clientPlan.trainPlan.mainPlanGUID = plan.strMainPlanGUID;
clientPlan.trainPlan.planID = plan.strTrainPlanGUID;
clientPlan.trainPlan.strTrainPlanGUID = plan.strTrainPlanGUID;
clientPlan.trainPlan.trainJiaoluGUID = plan.strTrainJiaoluGUID;
clientPlan.trainPlan.trainJiaoluName = plan.strTrainJiaoluName;
if (plan.dtLastArriveTime.HasValue)
{
clientPlan.trainPlan.lastArriveTime = plan.dtLastArriveTime.Value;
}
if (plan.dtStartTime.HasValue)
{
clientPlan.trainPlan.startTime = plan.dtStartTime.Value;
}
if (plan.dtRealStartTime.HasValue)
{
clientPlan.trainPlan.realStartTime = plan.dtRealStartTime.Value;
}
if (plan.dtStartTime.HasValue)
{
clientPlan.trainPlan.startTime = plan.dtStartTime.Value;
}
if (plan.dtFirstStartTime.HasValue)
{
clientPlan.trainPlan.firstStartTime = plan.dtFirstStartTime.Value;
}
if (plan.dtChuQinTime.HasValue)
{
clientPlan.beginWorkTime = plan.dtChuQinTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
clientPlan.trainPlan.kaiCheTime = plan.dtChuQinTime.Value;
}
else
{
clientPlan.beginWorkTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
clientPlan.trainPlan.trainmanTypeID = plan.nTrainmanTypeID.ToString();
clientPlan.trainPlan.trainmanTypeName = plan.strTrainmanTypeName;
clientPlan.trainPlan.trainNo = plan.strTrainNo;
clientPlan.trainPlan.trainNumber = plan.strTrainNumber;
clientPlan.trainPlan.trainTypeName = plan.strTrainTypeName;
tuiqinGroup.group.station = new Station();
tuiqinGroup.group.station.stationID = plan.strStartStation;
tuiqinGroup.group.station.stationName = plan.strStartStationName;
tuiqinGroup.group.station.stationNumber = plan.ToString();
tuiqinGroup.group.trainman1 = new TF.RunSafty.WorkSteps.Trainman();
tuiqinGroup.group.trainman1.ABCD = plan.strABCD1;
if (plan.nDriverType1.HasValue)
{
tuiqinGroup.group.trainman1.driverTypeID = plan.nDriverType1.Value;
}
if (plan.isKey1.HasValue)
{
tuiqinGroup.group.trainman1.isKey = plan.isKey1.Value;
}
if (plan.nPostID1.HasValue)
{
tuiqinGroup.group.trainman1.postID = plan.nPostID1.Value;
}
tuiqinGroup.group.trainman1.trainmanID = plan.strTrainmanGUID1;
tuiqinGroup.group.trainman1.trainmanName = plan.strTrainmanName1;
tuiqinGroup.group.trainman1.trainmanNumber = plan.strTrainmanNumber1;
tuiqinGroup.group.trainman2 = new TF.RunSafty.WorkSteps.Trainman();
tuiqinGroup.group.trainman2.ABCD = plan.strABCD2;
if (plan.nDriverType2.HasValue)
{
tuiqinGroup.group.trainman2.driverTypeID = plan.nDriverType2.Value;
}
if (plan.isKey2.HasValue)
{
tuiqinGroup.group.trainman2.isKey = plan.isKey2.Value;
}
if (plan.nPostID2.HasValue)
{
tuiqinGroup.group.trainman2.postID = plan.nPostID2.Value;
}
tuiqinGroup.group.trainman2.trainmanID = plan.strTrainmanGUID2;
tuiqinGroup.group.trainman2.trainmanName = plan.strTrainmanName2;
tuiqinGroup.group.trainman2.trainmanNumber = plan.strTrainmanNumber2;
tuiqinGroup.group.trainman3 = new TF.RunSafty.WorkSteps.Trainman();
tuiqinGroup.group.trainman3.ABCD = plan.strABCD3;
if (plan.nDriverType3.HasValue)
{
tuiqinGroup.group.trainman3.driverTypeID = plan.nDriverType3.Value;
}
if (plan.isKey3.HasValue)
{
tuiqinGroup.group.trainman3.isKey = plan.isKey3.Value;
}
if (plan.nPostID3.HasValue)
{
tuiqinGroup.group.trainman3.postID = plan.nPostID3.Value;
}
tuiqinGroup.group.trainman3.trainmanID = plan.strTrainmanGUID3;
tuiqinGroup.group.trainman3.trainmanName = plan.strTrainmanName3;
tuiqinGroup.group.trainman3.trainmanNumber = plan.strTrainmanNumber3;
tuiqinGroup.group.trainman4 = new TF.RunSafty.WorkSteps.Trainman();;
tuiqinGroup.group.trainman4.ABCD = plan.strABCD4;
if (plan.nDriverType4.HasValue)
{
tuiqinGroup.group.trainman4.driverTypeID = plan.nDriverType4.Value;
}
if (plan.isKey4.HasValue)
{
tuiqinGroup.group.trainman4.isKey = plan.isKey4.Value;
}
if (plan.nPostID4.HasValue)
{
tuiqinGroup.group.trainman4.postID = plan.nPostID4.Value;
}
tuiqinGroup.group.trainman4.trainmanID = plan.strTrainmanGUID4;
tuiqinGroup.group.trainman4.trainmanName = plan.strTrainmanName4;
tuiqinGroup.group.trainman4.trainmanNumber = plan.strTrainmanNumber4;
tuiqinGroup.turnMinutes = plan.nTurnMinutes.ToString();
tuiqinGroup.turnAlarmMinutes = plan.nTurnAlarmMinutes.ToString();
tuiqinGroup.isOver = plan.bIsOver.ToString();
tuiqinGroup.signed = plan.bSigned.ToString();
if (plan.dtTurnStartTime.HasValue)
{
tuiqinGroup.turnStartTime = plan.dtTurnStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
}
//clientPlan.icCheckResult = plan.strICCheckResult;
if (plan.nVerifyID1.HasValue)
{
clientPlan.tuiqinGroup.verifyID1 = plan.nVerifyID1.Value;
}
clientPlan.tuiqinGroup.testAlcoholInfo1 = new TestAlcoholInfo();
if (plan.picture1 == null)
{
clientPlan.tuiqinGroup.testAlcoholInfo1.picture = "";
}
else
{
clientPlan.tuiqinGroup.testAlcoholInfo1.picture = plan.picture1;
}
if (plan.cqtime1 == null)
{
clientPlan.tuiqinGroup.testAlcoholInfo1.testTime = "";
}
else
{
clientPlan.tuiqinGroup.testAlcoholInfo1.testTime = Convert.ToDateTime(plan.cqtime1).ToString("yyyy-MM-dd HH:mm:ss");
}
clientPlan.tuiqinGroup.testAlcoholInfo1.testAlcoholResult = plan.cqcj1;
if (plan.nVerifyID2.HasValue)
{
clientPlan.tuiqinGroup.verifyID2 = plan.nVerifyID2.Value;
}
clientPlan.tuiqinGroup.testAlcoholInfo2 = new TestAlcoholInfo();
if (plan.picture2 == null)
{
clientPlan.tuiqinGroup.testAlcoholInfo2.picture = "";
}
else
{
clientPlan.tuiqinGroup.testAlcoholInfo2.picture = plan.picture2;
}
if (plan.cqtime2 == null)
{
clientPlan.tuiqinGroup.testAlcoholInfo2.testTime = "";
}
else
{
clientPlan.tuiqinGroup.testAlcoholInfo2.testTime = Convert.ToDateTime(plan.cqtime2).ToString("yyyy-MM-dd HH:mm:ss");
}
clientPlan.tuiqinGroup.testAlcoholInfo2.testAlcoholResult = plan.cqcj2;
if (plan.nVerifyID3.HasValue)
{
clientPlan.tuiqinGroup.verifyID3 = plan.nVerifyID3.Value;
}
clientPlan.tuiqinGroup.testAlcoholInfo3 = new TestAlcoholInfo();
if (plan.picture3 == null)
{
clientPlan.tuiqinGroup.testAlcoholInfo3.picture = "";
}
else
{
clientPlan.tuiqinGroup.testAlcoholInfo3.picture = plan.picture3;
}
if (plan.cqtime3 == null)
{
clientPlan.tuiqinGroup.testAlcoholInfo3.testTime = "";
}
else
{
clientPlan.tuiqinGroup.testAlcoholInfo3.testTime = Convert.ToDateTime(plan.cqtime3).ToString("yyyy-MM-dd HH:mm:ss");
}
clientPlan.tuiqinGroup.testAlcoholInfo3.testAlcoholResult = plan.cqcj3;
lPlans.Add(clientPlan);
}
}
return(lPlans);
}
