/// <summary> /// 得到一个对象实体 /// </summary> public TF.RunSafty.Model.VIEW_Plan_BeginWork GetModel(int nid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 strTrainJiaoluName,strTrainmanTypeName,strTrainPlanGUID,strTrainJiaoluGUID,strTrainNo,strTrainNumber,dtStartTime,dtChuQinTime,strStartStation,strEndStation,dtCreateTime,nPlanState,strTrainTypeName,strStartStationName,strEndStationName,nTrainmanTypeID,SendPlan,nNeedRest,dtArriveTime,dtCallTime,nKehuoID,dtRealStartTime,nPlanType,nDragType,nRemarkType,strRemark,strCreateSiteGUID,strCreateUserGUID,strCreateUserID,strCreateUserName,strCreateSiteName,strTrainmanNumber1,strTrainmanName1,nPostID1,strWorkShopGUID1,strTelNumber1,dtLastEndWorkTime1,strTrainmanGUID1,strTrainmanGUID2,strTrainmanNumber2,strTrainmanName2,strWorkShopGUID2,strTelNumber2,strTrainmanNumber3,strTrainmanGUID3,dtLastEndWorkTime2,nPostID2,strTrainmanName3,nPostID3,strWorkShopGUID3,strTelNumber3,dtLastEndWorkTime3,strDutyGUID,strGroupGUID,strDutySiteGUID,dtTrainmanCreateTime,dtFirstStartTime,nid,nDragTypeName,strKehuoName,nTrainmanState1,nTrainmanState2,nTrainmanState3,strBak1,dtLastArriveTime,strMainPlanGUID,strTrainmanName4,strTrainmanNumber4,nPostID4,strTelNumber4,dtLastEndWorkTime4,nTrainmanState,strTrainmanGUID4,strRemarkTypeName,strPlanTypeName,strPlaceID,strStateName,nDriverType1,nDriverType2,nDriverType3,nDriverType4,strABCD1,strABCD2,strABCD3,strABCD4,isKey1,isKey2,isKey3,isKey4,strPlanStateName,'' as strStationName,'' as strStationNumber,strPlaceName,'' as strStationGUID,dtTestTime1,nVerifyID1,DrinkImage1,nDrinkResult1,dtTestTime2,nVerifyID2,DrinkImage2,nDrinkResult2,dtTestTime3,nVerifyID3,DrinkImage3,nDrinkResult3,strBeginWorkGUID1,strBeginWorkGUID2,strBeginWorkGUID3,strBeginWorkGUID4,dtTestTime4,nVerifyID4,DrinkImage4,nDrinkResult4,strICCheckResult from VIEW_Plan_BeginWork "); strSql.Append(" where nid=@nid"); SqlParameter[] parameters = { new SqlParameter("@nid", SqlDbType.Int, 4) }; parameters[0].Value = nid; TF.RunSafty.Model.VIEW_Plan_BeginWork model = new TF.RunSafty.Model.VIEW_Plan_BeginWork(); DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public TF.RunSafty.Model.VIEW_Plan_BeginWork DataRowToModel(DataRow row) { TF.RunSafty.Model.VIEW_Plan_BeginWork model = new TF.RunSafty.Model.VIEW_Plan_BeginWork(); if (row != null) { if (row.Table.Columns.Contains("nFlowState")) { if (row["nFlowState"] == DBNull.Value) { model.nFlowState = 0; } else { model.nFlowState = Convert.ToInt32(row["nFlowState"]); } } if (row["dtBeginworkTime"] != null) { DateTime dtBeginworkTime; if (DateTime.TryParse(row["dtBeginworkTime"].ToString(), out dtBeginworkTime)) { model.dtBeginWorkTime = dtBeginworkTime; } } if (row["strTrainJiaoluName"] != null) { model.strTrainJiaoluName = row["strTrainJiaoluName"].ToString(); } if (row["strTrainmanTypeName"] != null) { model.strTrainmanTypeName = row["strTrainmanTypeName"].ToString(); } if (row["strTrainPlanGUID"] != null) { model.strTrainPlanGUID = row["strTrainPlanGUID"].ToString(); } if (row["strTrainJiaoluGUID"] != null) { model.strTrainJiaoluGUID = row["strTrainJiaoluGUID"].ToString(); } if (row["strTrainNo"] != null) { model.strTrainNo = row["strTrainNo"].ToString(); } if (row["strTrainNumber"] != null) { model.strTrainNumber = row["strTrainNumber"].ToString(); } if (row["dtStartTime"] != null && row["dtStartTime"].ToString() != "") { DateTime dtStartTime; if (DateTime.TryParse(row["dtStartTime"].ToString(), out dtStartTime)) { model.dtStartTime = dtStartTime; } } if (row["dtChuQinTime"] != null && row["dtChuQinTime"].ToString() != "") { DateTime dtChuQinTime; if (DateTime.TryParse(row["dtChuQinTime"].ToString(), out dtChuQinTime)) { model.dtChuQinTime = dtChuQinTime; } } if (row["strStartStation"] != null) { model.strStartStation = row["strStartStation"].ToString(); } if (row["strEndStation"] != null) { model.strEndStation = row["strEndStation"].ToString(); } if (row["dtCreateTime"] != null && row["dtCreateTime"].ToString() != "") { DateTime dtCreateTime; if (DateTime.TryParse(row["dtCreateTime"].ToString(), out dtCreateTime)) { model.dtCreateTime = dtCreateTime; } } if (row["nPlanState"] != null && row["nPlanState"].ToString() != "") { model.nPlanState = int.Parse(row["nPlanState"].ToString()); } if (row["strTrainTypeName"] != null) { model.strTrainTypeName = row["strTrainTypeName"].ToString(); } if (row["strStartStationName"] != null) { model.strStartStationName = row["strStartStationName"].ToString(); } if (row["strEndStationName"] != null) { model.strEndStationName = row["strEndStationName"].ToString(); } if (row["nTrainmanTypeID"] != null && row["nTrainmanTypeID"].ToString() != "") { model.nTrainmanTypeID = int.Parse(row["nTrainmanTypeID"].ToString()); } if (row["SendPlan"] != null && row["SendPlan"].ToString() != "") { model.SendPlan = int.Parse(row["SendPlan"].ToString()); } if (row["nNeedRest"] != null && row["nNeedRest"].ToString() != "") { model.nNeedRest = int.Parse(row["nNeedRest"].ToString()); } if (row["dtArriveTime"] != null && row["dtArriveTime"].ToString() != "") { model.dtArriveTime = DateTime.Parse(row["dtArriveTime"].ToString()); } if (row["dtCallTime"] != null && row["dtCallTime"].ToString() != "") { //model.dtCallTime = DateTime.Parse(row["dtCallTime"].ToString()); DateTime dtCallTime; if (DateTime.TryParse(row["dtCallTime"].ToString(), out dtCallTime)) { model.dtCallTime = dtCallTime; } } if (row["nKehuoID"] != null && row["nKehuoID"].ToString() != "") { model.nKehuoID = int.Parse(row["nKehuoID"].ToString()); } if (row["dtRealStartTime"] != null && row["dtRealStartTime"].ToString() != "") { DateTime dtRealStartTime; if (DateTime.TryParse(row["dtRealStartTime"].ToString(), out dtRealStartTime)) { model.dtRealStartTime = dtRealStartTime; } } if (row["nPlanType"] != null && row["nPlanType"].ToString() != "") { model.nPlanType = int.Parse(row["nPlanType"].ToString()); } if (row["nDragType"] != null && row["nDragType"].ToString() != "") { model.nDragType = int.Parse(row["nDragType"].ToString()); } if (row["nRemarkType"] != null && row["nRemarkType"].ToString() != "") { model.nRemarkType = int.Parse(row["nRemarkType"].ToString()); } if (row["strRemark"] != null) { model.strRemark = row["strRemark"].ToString(); } if (row["strCreateSiteGUID"] != null) { model.strCreateSiteGUID = row["strCreateSiteGUID"].ToString(); } if (row["strCreateUserGUID"] != null) { model.strCreateUserGUID = row["strCreateUserGUID"].ToString(); } if (row["strCreateUserID"] != null) { model.strCreateUserID = row["strCreateUserID"].ToString(); } if (row["strCreateUserName"] != null) { model.strCreateUserName = row["strCreateUserName"].ToString(); } if (row["strCreateSiteName"] != null) { model.strCreateSiteName = row["strCreateSiteName"].ToString(); } if (row["strTrainmanNumber1"] != null) { model.strTrainmanNumber1 = row["strTrainmanNumber1"].ToString(); } if (row["strTrainmanName1"] != null) { model.strTrainmanName1 = row["strTrainmanName1"].ToString(); } if (row["nPostID1"] != null && row["nPostID1"].ToString() != "") { model.nPostID1 = int.Parse(row["nPostID1"].ToString()); } if (row["strWorkShopGUID1"] != null) { model.strWorkShopGUID1 = row["strWorkShopGUID1"].ToString(); } if (row["strTelNumber1"] != null) { model.strTelNumber1 = row["strTelNumber1"].ToString(); } if (row["dtLastEndWorkTime1"] != null && row["dtLastEndWorkTime1"].ToString() != "") { DateTime dtLastEndWorkTime1; if (DateTime.TryParse(row["dtLastEndWorkTime1"].ToString(), out dtLastEndWorkTime1)) { model.dtLastEndWorkTime1 = dtLastEndWorkTime1; } } if (row["strTrainmanGUID1"] != null) { model.strTrainmanGUID1 = row["strTrainmanGUID1"].ToString(); } if (row["strTrainmanGUID2"] != null) { model.strTrainmanGUID2 = row["strTrainmanGUID2"].ToString(); } if (row["strTrainmanNumber2"] != null) { model.strTrainmanNumber2 = row["strTrainmanNumber2"].ToString(); } if (row["strTrainmanName2"] != null) { model.strTrainmanName2 = row["strTrainmanName2"].ToString(); } if (row["strWorkShopGUID2"] != null) { model.strWorkShopGUID2 = row["strWorkShopGUID2"].ToString(); } if (row["strTelNumber2"] != null) { model.strTelNumber2 = row["strTelNumber2"].ToString(); } if (row["strTrainmanNumber3"] != null) { model.strTrainmanNumber3 = row["strTrainmanNumber3"].ToString(); } if (row["strTrainmanGUID3"] != null) { model.strTrainmanGUID3 = row["strTrainmanGUID3"].ToString(); } if (row["dtLastEndWorkTime2"] != null && row["dtLastEndWorkTime2"].ToString() != "") { DateTime dtLastEndWorkTime2; if (DateTime.TryParse(row["dtLastEndWorkTime2"].ToString(), out dtLastEndWorkTime2)) { model.dtLastEndWorkTime2 = dtLastEndWorkTime2; } } if (row["nPostID2"] != null && row["nPostID2"].ToString() != "") { model.nPostID2 = int.Parse(row["nPostID2"].ToString()); } if (row["strTrainmanName3"] != null) { model.strTrainmanName3 = row["strTrainmanName3"].ToString(); } if (row["nPostID3"] != null && row["nPostID3"].ToString() != "") { model.nPostID3 = int.Parse(row["nPostID3"].ToString()); } if (row["strWorkShopGUID3"] != null) { model.strWorkShopGUID3 = row["strWorkShopGUID3"].ToString(); } if (row["strTelNumber3"] != null) { model.strTelNumber3 = row["strTelNumber3"].ToString(); } if (row["dtLastEndWorkTime3"] != null && row["dtLastEndWorkTime3"].ToString() != "") { DateTime dtLastEndWorkTime3; if (DateTime.TryParse(row["dtLastEndWorkTime3"].ToString(), out dtLastEndWorkTime3)) { model.dtLastEndWorkTime3 = dtLastEndWorkTime3; } } if (row["strDutyGUID"] != null) { model.strDutyGUID = row["strDutyGUID"].ToString(); } if (row["strGroupGUID"] != null) { model.strGroupGUID = row["strGroupGUID"].ToString(); } if (row["strDutySiteGUID"] != null) { model.strDutySiteGUID = row["strDutySiteGUID"].ToString(); } if (row["dtTrainmanCreateTime"] != null && row["dtTrainmanCreateTime"].ToString() != "") { //model.dtTrainmanCreateTime = DateTime.Parse(row["dtTrainmanCreateTime"].ToString()); DateTime dtTrainmanCreateTime; if (DateTime.TryParse(row["dtTrainmanCreateTime"].ToString(), out dtTrainmanCreateTime)) { model.dtTrainmanCreateTime = dtTrainmanCreateTime; } } if (row["dtFirstStartTime"] != null && row["dtFirstStartTime"].ToString() != "") { DateTime dtFirstStartTime; if (DateTime.TryParse(row["dtFirstStartTime"].ToString(), out dtFirstStartTime)) { model.dtFirstStartTime = dtFirstStartTime; } } if (row["nid"] != null && row["nid"].ToString() != "") { model.nid = int.Parse(row["nid"].ToString()); } if (row["nDragTypeName"] != null) { model.nDragTypeName = row["nDragTypeName"].ToString(); } if (row["strKehuoName"] != null) { model.strKehuoName = row["strKehuoName"].ToString(); } if (row["nTrainmanState1"] != null && row["nTrainmanState1"].ToString() != "") { model.nTrainmanState1 = int.Parse(row["nTrainmanState1"].ToString()); } if (row["nTrainmanState2"] != null && row["nTrainmanState2"].ToString() != "") { model.nTrainmanState2 = int.Parse(row["nTrainmanState2"].ToString()); } if (row["nTrainmanState3"] != null && row["nTrainmanState3"].ToString() != "") { model.nTrainmanState3 = int.Parse(row["nTrainmanState3"].ToString()); } if (row["strBak1"] != null) { model.strBak1 = row["strBak1"].ToString(); } if (row["dtLastArriveTime"] != null && row["dtLastArriveTime"].ToString() != "") { //model.dtLastArriveTime = DateTime.Parse(row["dtLastArriveTime"].ToString()); DateTime dtLastArriveTime; if (DateTime.TryParse(row["dtLastArriveTime"].ToString(), out dtLastArriveTime)) { model.dtLastArriveTime = dtLastArriveTime; } } if (row["strMainPlanGUID"] != null) { model.strMainPlanGUID = row["strMainPlanGUID"].ToString(); } if (row["strTrainmanName4"] != null) { model.strTrainmanName4 = row["strTrainmanName4"].ToString(); } if (row["strTrainmanNumber4"] != null) { model.strTrainmanNumber4 = row["strTrainmanNumber4"].ToString(); } if (row["nPostID4"] != null && row["nPostID4"].ToString() != "") { model.nPostID4 = int.Parse(row["nPostID4"].ToString()); } if (row["strTelNumber4"] != null) { model.strTelNumber4 = row["strTelNumber4"].ToString(); } if (row["dtLastEndWorkTime4"] != null && row["dtLastEndWorkTime4"].ToString() != "") { // model.dtLastEndWorkTime4 = DateTime.Parse(row["dtLastEndWorkTime4"].ToString()); DateTime dtLastEndWorkTime4; if (DateTime.TryParse(row["dtLastEndWorkTime4"].ToString(), out dtLastEndWorkTime4)) { model.dtLastEndWorkTime4 = dtLastEndWorkTime4; } } if (row["nTrainmanState"] != null && row["nTrainmanState"].ToString() != "") { model.nTrainmanState = int.Parse(row["nTrainmanState"].ToString()); } if (row["strTrainmanGUID4"] != null) { model.strTrainmanGUID4 = row["strTrainmanGUID4"].ToString(); } if (row["strRemarkTypeName"] != null) { model.strRemarkTypeName = row["strRemarkTypeName"].ToString(); } if (row["strPlanTypeName"] != null) { model.strPlanTypeName = row["strPlanTypeName"].ToString(); } if (row["strPlaceID"] != null) { model.strPlaceID = row["strPlaceID"].ToString(); } if (row["strStateName"] != null) { model.strStateName = row["strStateName"].ToString(); } if (row["nDriverType1"] != null && row["nDriverType1"].ToString() != "") { model.nDriverType1 = int.Parse(row["nDriverType1"].ToString()); } if (row["nDriverType2"] != null && row["nDriverType2"].ToString() != "") { model.nDriverType2 = int.Parse(row["nDriverType2"].ToString()); } if (row["nDriverType3"] != null && row["nDriverType3"].ToString() != "") { model.nDriverType3 = int.Parse(row["nDriverType3"].ToString()); } if (row["nDriverType4"] != null && row["nDriverType4"].ToString() != "") { model.nDriverType4 = int.Parse(row["nDriverType4"].ToString()); } if (row["strABCD1"] != null) { model.strABCD1 = row["strABCD1"].ToString(); } if (row["strABCD2"] != null) { model.strABCD2 = row["strABCD2"].ToString(); } if (row["strABCD3"] != null) { model.strABCD3 = row["strABCD3"].ToString(); } if (row["strABCD4"] != null) { model.strABCD4 = row["strABCD4"].ToString(); } if (row["isKey1"] != null && row["isKey1"].ToString() != "") { model.isKey1 = int.Parse(row["isKey1"].ToString()); } if (row["isKey2"] != null && row["isKey2"].ToString() != "") { model.isKey2 = int.Parse(row["isKey2"].ToString()); } if (row["isKey3"] != null && row["isKey3"].ToString() != "") { model.isKey3 = int.Parse(row["isKey3"].ToString()); } if (row["isKey4"] != null && row["isKey4"].ToString() != "") { model.isKey4 = int.Parse(row["isKey4"].ToString()); } if (row["strPlanStateName"] != null) { model.strPlanStateName = row["strPlanStateName"].ToString(); } if (row["strStationName"] != null) { model.strStationName = row["strStationName"].ToString(); } if (row["strStationNumber"] != null && row["strStationNumber"].ToString() != "") { model.strStationNumber = int.Parse(row["strStationNumber"].ToString()); } if (row["strPlaceName"] != null) { model.strPlaceName = row["strPlaceName"].ToString(); } if (row["strStationGUID"] != null) { model.strStationGUID = row["strStationGUID"].ToString(); } if (row["dtTestTime1"] != null && row["dtTestTime1"].ToString() != "") { DateTime dtTestTime1; if (DateTime.TryParse(row["dtTestTime1"].ToString(), out dtTestTime1)) { model.dtTestTime1 = dtTestTime1; } } if (row["nVerifyID1"] != null && row["nVerifyID1"].ToString() != "") { model.nVerifyID1 = int.Parse(row["nVerifyID1"].ToString()); } if (row["DrinkImage1"] != null && row["DrinkImage1"].ToString() != "") { model.DrinkImage1 = (byte[])row["DrinkImage1"]; } if (row["nDrinkResult1"] != null && row["nDrinkResult1"].ToString() != "") { model.nDrinkResult1 = int.Parse(row["nDrinkResult1"].ToString()); } if (row["dtTestTime2"] != null && row["dtTestTime2"].ToString() != "") { DateTime dtTestTime2; if (DateTime.TryParse(row["dtTestTime2"].ToString(), out dtTestTime2)) { model.dtTestTime2 = dtTestTime2; } } if (row["nVerifyID2"] != null && row["nVerifyID2"].ToString() != "") { model.nVerifyID2 = int.Parse(row["nVerifyID2"].ToString()); } if (row["DrinkImage2"] != null && row["DrinkImage2"].ToString() != "") { model.DrinkImage2 = (byte[])row["DrinkImage2"]; } if (row["nDrinkResult2"] != null && row["nDrinkResult2"].ToString() != "") { model.nDrinkResult2 = int.Parse(row["nDrinkResult2"].ToString()); } if (row["dtTestTime3"] != null && row["dtTestTime3"].ToString() != "") { DateTime dtTestTime3; if (DateTime.TryParse(row["dtTestTime3"].ToString(), out dtTestTime3)) { model.dtTestTime3 = dtTestTime3; } } if (row["nVerifyID3"] != null && row["nVerifyID3"].ToString() != "") { model.nVerifyID3 = int.Parse(row["nVerifyID3"].ToString()); } if (row["DrinkImage3"] != null && row["DrinkImage3"].ToString() != "") { model.DrinkImage3 = (byte[])row["DrinkImage3"]; } if (row["nDrinkResult3"] != null && row["nDrinkResult3"].ToString() != "") { model.nDrinkResult3 = int.Parse(row["nDrinkResult3"].ToString()); } if (row["strBeginWorkGUID1"] != null) { model.strBeginWorkGUID1 = row["strBeginWorkGUID1"].ToString(); } if (row["strBeginWorkGUID2"] != null) { model.strBeginWorkGUID2 = row["strBeginWorkGUID2"].ToString(); } if (row["strBeginWorkGUID3"] != null) { model.strBeginWorkGUID3 = row["strBeginWorkGUID3"].ToString(); } if (row["strBeginWorkGUID4"] != null) { model.strBeginWorkGUID4 = row["strBeginWorkGUID4"].ToString(); } if (row["dtTestTime4"] != null && row["dtTestTime4"].ToString() != "") { DateTime dtTestTime4; if (DateTime.TryParse(row["dtTestTime4"].ToString(), out dtTestTime4)) { model.dtTestTime4 = dtTestTime4; } } if (row["nVerifyID4"] != null && row["nVerifyID4"].ToString() != "") { model.nVerifyID4 = int.Parse(row["nVerifyID4"].ToString()); } if (row["DrinkImage4"] != null && row["DrinkImage4"].ToString() != "") { model.DrinkImage4 = (byte[])row["DrinkImage4"]; } if (row["nDrinkResult4"] != null && row["nDrinkResult4"].ToString() != "") { model.nDrinkResult4 = int.Parse(row["nDrinkResult4"].ToString()); } if (row["strICCheckResult"] != null) { model.strICCheckResult = row["strICCheckResult"].ToString(); } } return(model); }