//查询流程列表
public void Query(string flowType, string tmid, string planID, List <WorkFlow> flows)
{
flows.Clear();
string sql = "select * from TAB_Plan_WorkFlow where strTmID = @tmid and strPlanID = @planID and strFlowType = @flowType order by dtEventTime";
SqlParameter[] sqlParams =
{
new SqlParameter("tmid", tmid),
new SqlParameter("planID", planID),
new SqlParameter("flowType", flowType)
};
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, sql, sqlParams).Tables[0];
WorkFlow workFlow;
foreach (DataRow dr in dt.Rows)
{
workFlow = new WorkFlow();
workFlow.planID = ObjectConvertClass.static_ext_string(dr["strPlanID"]);
workFlow.description = ObjectConvertClass.static_ext_string(dr["strDescription"]);
workFlow.eventTime = ObjectConvertClass.static_ext_Date(dr["dtEventTime"]);
workFlow.flowIdentify = ObjectConvertClass.static_ext_string(dr["strFlowIdentify"]);
workFlow.flowType = ObjectConvertClass.static_ext_string(dr["strFlowType"]);
workFlow.success = ObjectConvertClass.static_ext_int(dr["nSuccess"]);
workFlow.tmid = ObjectConvertClass.static_ext_string(dr["strTmid"]);
workFlow.tmName = ObjectConvertClass.static_ext_string(dr["strTmName"]);
flows.Add(workFlow);
}
}
public MDJDPlan GetJDPlan(DataRow dr)
{
MDJDPlan model = new MDJDPlan();
if (dr != null)
{
model.Day = ObjectConvertClass.static_ext_string(dr["day"]);
model.Shift = ObjectConvertClass.static_ext_int(dr["shift"]);
model.Typ = ObjectConvertClass.static_ext_int(dr["typ"]);
model.Section_id = ObjectConvertClass.static_ext_string(dr["section_id"]);
model.Trainkind = ObjectConvertClass.static_ext_int(dr["trainkind"]);
model.Train_id = ObjectConvertClass.static_ext_string(dr["train_id"]);
model.Train_code = ObjectConvertClass.static_ext_string(dr["train_code"]);
model.Time_deptart = ObjectConvertClass.static_ext_Date(dr["time_deptart"]);
model.Time_arrived = ObjectConvertClass.static_ext_Date(dr["time_arrived"]);
model.Station_deptart = ObjectConvertClass.static_ext_string(dr["station_deptart"]);
model.Station_arrived = ObjectConvertClass.static_ext_string(dr["station_arrived"]);
model.Loco_num = ObjectConvertClass.static_ext_int(dr["loco_num"]);
model.Weight = (float)ObjectConvertClass.static_ext_double(dr["weight"]);
model.Car_count = ObjectConvertClass.static_ext_int(dr["car_count"]);
model.C_length = (float)ObjectConvertClass.static_ext_double(dr["c_length"]);
model.PlanGUID = ObjectConvertClass.static_ext_string(dr["strTrainPlanGUID"]);
model.Section_name = ObjectConvertClass.static_ext_string(dr["strSectionName"]);
model.Station_deptart_id = ObjectConvertClass.static_ext_string(dr["strDeptartStationID"]);
model.Station_arrived_id = ObjectConvertClass.static_ext_string(dr["strArrivedStationID"]);
model.IsUpdate = ObjectConvertClass.static_ext_int(dr["nIsUpdate"]);
}
return(model);
}
//从数据行中读取数据到TrainPlanChangeLog中
public static void TrainPlanChangeLogFromDB(TrainPlanChangeLog Log, DataRow dr)
{
Log.nid = ObjectConvertClass.static_ext_int(dr["nid"]);
Log.strLogGUID = ObjectConvertClass.static_ext_string(dr["strLogGUID"]);
Log.strTrainPlanGUID = ObjectConvertClass.static_ext_string(dr["strTrainPlanGUID"]);
Log.strTrainTypeName = ObjectConvertClass.static_ext_string(dr["strTrainTypeName"]);
Log.strTrainNumber = ObjectConvertClass.static_ext_string(dr["strTrainNumber"]);
Log.strTrainNo = ObjectConvertClass.static_ext_string(dr["strTrainNo"]);
Log.dtStartTime = ObjectConvertClass.static_ext_Date(dr["dtStartTime"]);
Log.strTrainJiaoluGUID = ObjectConvertClass.static_ext_string(dr["strTrainJiaoluGUID"]);
Log.strTrainJiaoluName = ObjectConvertClass.static_ext_string(dr["strTrainJiaoluName"]);
Log.strStartStation = ObjectConvertClass.static_ext_string(dr["strStartStation"]);
Log.strStartStationName = ObjectConvertClass.static_ext_string(dr["strStartStationName"]);
Log.strEndStation = ObjectConvertClass.static_ext_string(dr["strEndStation"]);
Log.strEndStationName = ObjectConvertClass.static_ext_string(dr["strEndStationName"]);
Log.nTrainmanTypeID = ObjectConvertClass.static_ext_int(dr["nTrainmanTypeID"]);
Log.nPlanType = ObjectConvertClass.static_ext_int(dr["nPlanType"]);
Log.nDragType = ObjectConvertClass.static_ext_int(dr["nDragType"]);
Log.nKehuoID = ObjectConvertClass.static_ext_int(dr["nKehuoID"]);
Log.nRemarkType = ObjectConvertClass.static_ext_int(dr["nRemarkType"]);
Log.strRemark = ObjectConvertClass.static_ext_string(dr["strRemark"]);
Log.nPlanState = ObjectConvertClass.static_ext_int(dr["nPlanState"]);
Log.dtCreateTime = ObjectConvertClass.static_ext_Date(dr["dtCreateTime"]);
Log.strOperateSiteGUID = ObjectConvertClass.static_ext_string(dr["strOperateSiteGUID"]);
Log.strOperateSiteName = ObjectConvertClass.static_ext_string(dr["strOperateSiteName"]);
Log.strOperateUserGUID = ObjectConvertClass.static_ext_string(dr["strOperateUserGUID"]);
Log.strOperateUserName = ObjectConvertClass.static_ext_string(dr["strOperateUserName"]);
Log.strOperateUserID = ObjectConvertClass.static_ext_string(dr["strOperateUserID"]);
Log.dtChangeTime = ObjectConvertClass.static_ext_Date(dr["dtChangeTime"]);
}
public SystemDict.DrinkImageInfo GetDrinkImageList(string strTrainmanGUID, string strTrainPlanGUID, int WorkTypeID)
{
DataSet set = this.GetList(strTrainmanGUID, strTrainPlanGUID, WorkTypeID);
SystemDict.DrinkImageInfo dii = new SystemDict.DrinkImageInfo();
if (set.Tables[0].Rows.Count > 0)
{
dii.dtCreateTime = ObjectConvertClass.static_ext_Date(set.Tables[0].Rows[0]["dtCreateTime"]);
dii.nDrinkResult = ObjectConvertClass.static_ext_int(set.Tables[0].Rows[0]["nDrinkResult"]);
dii.strPictureURL = ObjectConvertClass.static_ext_string(set.Tables[0].Rows[0]["strImagePath"]);
}
return(dii);
}
/// <summary>
/// 读取DataRow数据到Model中
/// </summary>
private void DataRowToModel(ZXYJInfo model, DataRow dr)
{
model.nid = ObjectConvertClass.static_ext_int(dr["nid"]);
model.strTrainPlanGUID = ObjectConvertClass.static_ext_string(dr["strTrainPlanGUID"]);
model.strTrainmanNumber1 = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber1"]);
model.strTrainmanNumber2 = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber2"]);
model.dtEventTime = ObjectConvertClass.static_ext_Date(dr["dtEventTime"]);
model.strXDMC = ObjectConvertClass.static_ext_string(dr["strXDMC"]);
model.strTrainNo = ObjectConvertClass.static_ext_string(dr["strTrainNo"]);
model.strTrainNumber = ObjectConvertClass.static_ext_string(dr["strTrainNumber"]);
model.strTrainTypeName = ObjectConvertClass.static_ext_string(dr["strTrainTypeName"]);
model.strDWH = ObjectConvertClass.static_ext_string(dr["strDWH"]);
model.dtCreateTime = ObjectConvertClass.static_ext_Date(dr["dtCreateTime"]);
model.nTMIS = ObjectConvertClass.static_ext_string(dr["nTMIS"]);
model.strTMISName = ObjectConvertClass.static_ext_string(dr["strTMISName"]);
}
/// <summary>
/// 设置属性
/// </summary>
/// <param name="model"></param>
/// <param name="dr"></param>
/// <returns></returns>
public Dic_StaffInfo SetValue(Dic_StaffInfo model, DataRow dr)
{
if (dr != null)
{
model.nID = ObjectConvertClass.static_ext_int(dr["nID"].ToString());
model.strID = dr["strID"].ToString();
model.strNumber = dr["strNumber"].ToString();
model.strName = dr["strName"].ToString();
model.strDuty = dr["strDuty"].ToString();
model.strPassword = dr["strPassword"].ToString();
model.strPictureFileName = dr["strPictureFileName"].ToString();
model.dtTokenTime = ObjectConvertClass.static_ext_Date(dr["dtTokenTime"]);
model.dtLoginTime = ObjectConvertClass.static_ext_Date(dr["dtLoginTime"]);
model.strTokenID = ObjectConvertClass.static_ext_string(dr["strTokenID"]);
model.nRoleID = ObjectConvertClass.static_ext_int(dr["nRoleID"]);
}
return(model);
}
/// <summary>
/// 工号得到一个对象实体
/// </summary>
public Dic_StaffInfo GetModelByNumber(string strNumber)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select *");
strSql.Append(" from WebPlatForm_Dic_StaffInfo where strNumber=@strNumber");
SqlParameter[] sqlParams =
{
new SqlParameter("strNumber", strNumber)
};
Dic_StaffInfo model = new Dic_StaffInfo();
DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["nID"].ToString() != "")
{
model.nID = int.Parse(ds.Tables[0].Rows[0]["nID"].ToString());
}
model.strID = ds.Tables[0].Rows[0]["strID"].ToString();
model.strNumber = ds.Tables[0].Rows[0]["strNumber"].ToString();
model.strName = ds.Tables[0].Rows[0]["strName"].ToString();
model.strDuty = ds.Tables[0].Rows[0]["strDuty"].ToString();
model.strPassword = ds.Tables[0].Rows[0]["strPassword"].ToString();
model.strPictureFileName = ds.Tables[0].Rows[0]["strPictureFileName"].ToString();
model.dtTokenTime = ObjectConvertClass.static_ext_Date(ds.Tables[0].Rows[0]["dtTokenTime"]);
model.dtLoginTime = ObjectConvertClass.static_ext_Date(ds.Tables[0].Rows[0]["dtLoginTime"]);
model.strTokenID = ObjectConvertClass.static_ext_string(ds.Tables[0].Rows[0]["strTokenID"]);
model.nRoleID = ObjectConvertClass.static_ext_int(ds.Tables[0].Rows[0]["nRoleID"]);
return(model);
}
else
{
return(null);
}
}
public void Query(string flowType, string tmid, DateTime cqTime, List <WorkFlow> flows)
{
flows.Clear();
string sql = "select * from TAB_Plan_WorkFlow where strTmID = @tmid and strFlowType = @flowType and dtEventTime > @bTime and dtEventTime < @eTime order by dtEventTime desc";
SqlParameter[] sqlParams =
{
new SqlParameter("tmid", tmid),
new SqlParameter("bTime", cqTime.AddHours(-4)),
new SqlParameter("eTime", cqTime.AddMinutes(30)),
new SqlParameter("flowType", flowType)
};
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, sql, sqlParams).Tables[0];
WorkFlow workFlow;
string flowIdentify = "";
foreach (DataRow dr in dt.Rows)
{
flowIdentify = ObjectConvertClass.static_ext_string(dr["strFlowIdentify"]);
WorkFlow retFlow = flows.Where(obj => obj.flowIdentify == flowIdentify).FirstOrDefault();
if (retFlow != null)
{
continue;
}
workFlow = new WorkFlow();
workFlow.planID = ObjectConvertClass.static_ext_string(dr["strPlanID"]);
workFlow.description = ObjectConvertClass.static_ext_string(dr["strDescription"]);
workFlow.eventTime = ObjectConvertClass.static_ext_Date(dr["dtEventTime"]);
workFlow.flowIdentify = ObjectConvertClass.static_ext_string(dr["strFlowIdentify"]);
workFlow.flowType = ObjectConvertClass.static_ext_string(dr["strFlowType"]);
workFlow.success = ObjectConvertClass.static_ext_int(dr["nSuccess"]);
workFlow.tmid = ObjectConvertClass.static_ext_string(dr["strTmid"]);
workFlow.tmName = ObjectConvertClass.static_ext_string(dr["strTmName"]);
flows.Add(workFlow);
}
}
private WorkTimeEntity dtRowToWorkTime(DataRow dr)
{
WorkTimeEntity result = new WorkTimeEntity();
result.nid = ObjectConvertClass.static_ext_int(dr["nid"]);
result.strFlowID = ObjectConvertClass.static_ext_string(dr["strFlowID"]);
result.strWorkShopName = ObjectConvertClass.static_ext_string(dr["strWorkShopName"]);
result.strTrainmanNumber = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber"]);
result.strTrainmanName = ObjectConvertClass.static_ext_string(dr["strTrainmanName"]);
result.dtBeginWorkTime = ObjectConvertClass.static_ext_Date(dr["dtBeginWorkTime"]);
result.dtStartTime = ObjectConvertClass.static_ext_Date(dr["dtkcTime"]);
result.dtArriveTime = ObjectConvertClass.static_ext_Date(dr["dtArriveTime"]);
result.dtInRoomTime = ObjectConvertClass.static_ext_Date(dr["dtInRoomTime"]);
result.dtOutRoomTime = ObjectConvertClass.static_ext_Date(dr["dtOutRoomTime"]);
ObjectConvertClass.static_ext_Date(dr["dtOutRoomTime"]);
result.dtStartTime2 = ObjectConvertClass.static_ext_Date(dr["dtStartTime2"]);
result.dtArriveTime2 = ObjectConvertClass.static_ext_Date(dr["dtArriveTime2"]);
result.dtEndWorkTime = ObjectConvertClass.static_ext_Date(dr["dtEndWorkTime"]);
result.fRunTotalTime = ObjectConvertClass.static_ext_int(dr["fRunTotalTime"]);
result.fBeginTotalTime = ObjectConvertClass.static_ext_int(dr["fBeginTotalTime"]);
result.fEndTotalTime = ObjectConvertClass.static_ext_int(dr["fEndTotalTime"]);
result.fTotalTime = ObjectConvertClass.static_ext_int(dr["fTotalTime"]);
result.nFlowState = ObjectConvertClass.static_ext_int(dr["nFlowState"]);
result.nkehuoID = ObjectConvertClass.static_ext_int(dr["nkehuoID"]);
result.nNoticeState = ObjectConvertClass.static_ext_int(dr["nNoticeState"]);
result.strTrainTypeName = ObjectConvertClass.static_ext_string(dr["strTrainTypeName"]);
result.strTrainNumber = ObjectConvertClass.static_ext_string(dr["strTrainNumber"]);
result.strTrainNo = ObjectConvertClass.static_ext_string(dr["strTrainNo"]);
result.strWorkShopNumber = ObjectConvertClass.static_ext_string(dr["strWorkShopNumber"]);
result.strDestStationTMIS = ObjectConvertClass.static_ext_string(dr["strDestStationTMIS"]);
result.strDestStationName = ObjectConvertClass.static_ext_string(dr["strDestStationName"]);
result.bLocalOutDepots = ObjectConvertClass.static_ext_int(dr["bLocalOutDepots"]);
result.dtLocalOutDepotsTime = ObjectConvertClass.static_ext_Date(dr["dtLocalOutDepotsTime"]);
result.bDestInDepots = ObjectConvertClass.static_ext_int(dr["bDestInDepots"]);
result.dtDestInDepotsTime = ObjectConvertClass.static_ext_Date(dr["dtDestInDepotsTime"]);
result.bDestOutDepots = ObjectConvertClass.static_ext_int(dr["bDestOutDepots"]);
result.dtDestOutDepotsTime = ObjectConvertClass.static_ext_Date(dr["dtDestOutDepotsTime"]);
result.bLocalInDepots = ObjectConvertClass.static_ext_int(dr["bLocalInDepots"]);
result.dtLocalInDepotsTime = ObjectConvertClass.static_ext_Date(dr["dtLocalInDepotsTime"]);
result.strBackTrainTypeName = ObjectConvertClass.static_ext_string(dr["strBackTrainTypeName"]);
result.strBackTrainNumber = ObjectConvertClass.static_ext_string(dr["strBackTrainNumber"]);
result.strBackTrainNo = ObjectConvertClass.static_ext_string(dr["strBackTrainNo"]);
result.dtRealArriveTime = ObjectConvertClass.static_ext_Date(dr["dtRealArriveTime"]);
result.bConfirm = ObjectConvertClass.static_ext_int(dr["bConfirm"]);
result.dtConfirmTime = ObjectConvertClass.static_ext_Date(dr["dtConfirmTime"]);
result.strConfirmDutyUser = ObjectConvertClass.static_ext_string(dr["strConfirmDutyUser"]);
result.nLocalStopMinutes = ObjectConvertClass.static_ext_int(dr["nLocalStopMinutes"]);
result.nRemoteStopMinutes = ObjectConvertClass.static_ext_int(dr["nRemoteStopMinutes"]);
result.strArriveStationTMIS = ObjectConvertClass.static_ext_string(dr["strArriveStationTMIS"]);
result.strArriveStationName = ObjectConvertClass.static_ext_string(dr["strArriveStationName"]);
result.nAlarmMinutes = ObjectConvertClass.static_ext_int(dr["nAlarmMinutes"]);
result.nOutMinutes = ObjectConvertClass.static_ext_int(dr["nOutMinutes"]);
//如果超劳时小于0则置为0
if (ObjectConvertClass.static_ext_int(dr["nOutTotalTime"]) < 0)
{
result.nOutTotalTime = 0;
}
else
{
result.nOutTotalTime = ObjectConvertClass.static_ext_int(dr["nOutTotalTime"]);
}
result.dtFileBeginTime = ObjectConvertClass.static_ext_Date(dr["dtFileBeginTime"]);
result.dtFileEndTime = ObjectConvertClass.static_ext_Date(dr["dtFileEndTime"]);
result.nChuQinTypeID = ObjectConvertClass.static_ext_int(dr["nChuQinTypeID"]);
result.nTuiQinTypeID = ObjectConvertClass.static_ext_int(dr["nTuiQinTypeID"]);
//停留时间
result.nGoRunTotalMinutes = ObjectConvertClass.static_ext_int(dr["nGoRunTotalMinutes"]);
result.nBackRunTotalMinutes = ObjectConvertClass.static_ext_int(dr["nBackRunTotalMinutes"]);
//技术速度
result.fGoSpeed = ObjectConvertClass.static_ext_double(dr["fGoSpeed"]);
result.fBackSpeed = ObjectConvertClass.static_ext_double(dr["fBackSpeed"]);
result.TrainmanPlan.TrainPlan.strTrainJiaoluName = ObjectConvertClass.static_ext_string(dr["strTrainJiaoluName"]);
result.TrainmanPlan.TrainPlan.strTrainPlanGUID = ObjectConvertClass.static_ext_string(dr["strTrainPlanGUID"]);
result.TrainmanPlan.TrainPlan.strTrainTypeName = ObjectConvertClass.static_ext_string(dr["strTrainTypeName"]);
result.TrainmanPlan.TrainPlan.strTrainNumber = ObjectConvertClass.static_ext_string(dr["strTrainNumber"]);
result.TrainmanPlan.TrainPlan.strTrainNo = ObjectConvertClass.static_ext_string(dr["strTrainNo"]);
result.TrainmanPlan.TrainPlan.nKeHuoID = ObjectConvertClass.static_ext_int(dr["nKeHuoID"]);
result.TrainmanPlan.Group.Trainman1.strTrainmanGUID = ObjectConvertClass.static_ext_string(dr["strTrainmanGUID1"]);
result.TrainmanPlan.Group.Trainman1.strTrainmanName = ObjectConvertClass.static_ext_string(dr["strTrainmanName1"]);
result.TrainmanPlan.Group.Trainman1.strTrainmanNumber = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber1"]);
result.TrainmanPlan.Group.Trainman2.strTrainmanGUID = ObjectConvertClass.static_ext_string(dr["strTrainmanGUID2"]);
result.TrainmanPlan.Group.Trainman2.strTrainmanName = ObjectConvertClass.static_ext_string(dr["strTrainmanName2"]);
result.TrainmanPlan.Group.Trainman2.strTrainmanNumber = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber2"]);
result.TrainmanPlan.Group.Trainman3.strTrainmanGUID = ObjectConvertClass.static_ext_string(dr["strTrainmanGUID3"]);
result.TrainmanPlan.Group.Trainman3.strTrainmanName = ObjectConvertClass.static_ext_string(dr["strTrainmanName3"]);
result.TrainmanPlan.Group.Trainman3.strTrainmanNumber = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber3"]);
return(result);
}
public static void DataRowToGroup(DataRow Row, Group Group)
{
Group.groupID = ObjectConvertClass.static_ext_string(Row["strGroupGUID"]);
DateTime arriveTime;
if (DateTime.TryParse(ObjectConvertClass.static_ext_string(Row["dtLastArriveTime"]), out arriveTime))
{
Group.arriveTime = arriveTime.ToString("yyyy-MM-dd HH:mm:ss");
}
Group.dtTXBeginTime = ObjectConvertClass.static_ext_Date(Row["dtTXBeginTime"]);
Group.nTxState = ObjectConvertClass.static_ext_int(Row["nTXState"]);
//正常
Group.groupState = (int)TRsTrainmanState.tsNormal;
if (ObjectConvertClass.static_ext_string(Row["GroupState"]) != "")
{
//计划中
Group.groupState = (int)TRsTrainmanState.tsPlaning;
if (ObjectConvertClass.static_ext_string(Row["GroupState"]) == "7")
{
//已出勤
Group.groupState = (int)TRsTrainmanState.tsRuning;
}
}
Group.trainPlanID = ObjectConvertClass.static_ext_string(Row["strTrainPlanGUID"]);
Group.trainNo = ObjectConvertClass.static_ext_string(Row["strTrainNo"]);
Group.trainTypeName = ObjectConvertClass.static_ext_string(Row["strTrainTypeName"]);
Group.trainNumber = ObjectConvertClass.static_ext_string(Row["strTrainNumber"]);
Group.startTime = ObjectConvertClass.static_ext_string(Row["dtStartTime"]);
DateTime lastInRoomTime1, lastInRoomTime2, lastInRoomTime3, lastInRoomTime4;
if (DateTime.TryParse(ObjectConvertClass.static_ext_string(Row["InRoomTime1"]), out lastInRoomTime1))
{
Group.lastInRoomTime1 = lastInRoomTime1.ToString("yyyy-MM-dd HH:mm:ss");
}
if (DateTime.TryParse(ObjectConvertClass.static_ext_string(Row["InRoomTime2"]), out lastInRoomTime2))
{
Group.lastInRoomTime2 = lastInRoomTime2.ToString("yyyy-MM-dd HH:mm:ss");
}
if (DateTime.TryParse(ObjectConvertClass.static_ext_string(Row["InRoomTime3"]), out lastInRoomTime3))
{
Group.lastInRoomTime3 = lastInRoomTime3.ToString("yyyy-MM-dd HH:mm:ss");
}
if (DateTime.TryParse(ObjectConvertClass.static_ext_string(Row["InRoomTime4"]), out lastInRoomTime4))
{
Group.lastInRoomTime4 = lastInRoomTime4.ToString("yyyy-MM-dd HH:mm:ss");
}
DateTime LastOutRoomTime1, LastOutRoomTime2, LastOutRoomTime3, LastOutRoomTime4;
if (Row.Table.Columns.Contains("OutRoomTime1"))
{
if (DateTime.TryParse(ObjectConvertClass.static_ext_string(Row["OutRoomTime1"]), out LastOutRoomTime1))
{
Group.LastOutRoomTime1 = LastOutRoomTime1.ToString("yyyy-MM-dd HH:mm:ss");
}
if (DateTime.TryParse(ObjectConvertClass.static_ext_string(Row["OutRoomTime2"]), out LastOutRoomTime2))
{
Group.LastOutRoomTime2 = LastOutRoomTime2.ToString("yyyy-MM-dd HH:mm:ss");
}
if (DateTime.TryParse(ObjectConvertClass.static_ext_string(Row["OutRoomTime3"]), out LastOutRoomTime3))
{
Group.LastOutRoomTime3 = LastOutRoomTime3.ToString("yyyy-MM-dd HH:mm:ss");
}
if (DateTime.TryParse(ObjectConvertClass.static_ext_string(Row["OutRoomTime4"]), out LastOutRoomTime4))
{
Group.LastOutRoomTime4 = LastOutRoomTime4.ToString("yyyy-MM-dd HH:mm:ss");
}
}
Group.station.stationID = ObjectConvertClass.static_ext_string(Row["strStationGUID"]);;
Group.station.stationName = ObjectConvertClass.static_ext_string(Row["strStationName"]);;
Group.station.stationNumber = ObjectConvertClass.static_ext_string(Row["strStationNumber"]);;
Group.place.placeID = ObjectConvertClass.static_ext_string(Row["strPlaceID"]);
Group.place.placeName = ObjectConvertClass.static_ext_string(Row["strPlaceName"]);
Group.trainman1.trainmanID = ObjectConvertClass.static_ext_string(Row["strTrainmanGUID1"]);
if (Group.trainman1.trainmanID != "")
{
Group.trainman1.trainmanName = ObjectConvertClass.static_ext_string(Row["strTrainmanName1"]);
Group.trainman1.trainmanNumber = ObjectConvertClass.static_ext_string(Row["strTrainmanNumber1"]);
if (Row["nPost1"] != null && !string.IsNullOrEmpty(ObjectConvertClass.static_ext_string(Row["nPost1"])))
{
Group.trainman1.postID = Int32.Parse(Row["nPost1"].ToString());
}
Group.trainman1.telNumber = ObjectConvertClass.static_ext_string(Row["strTelNumber1"]);
Group.trainman1.trainmanState = 0;
if (Row["nTrainmanState1"].ToString() != "")
{
Group.trainman1.trainmanState = ObjectConvertClass.static_ext_int(Row["nTrainmanState1"]);
}
Int32.TryParse(ObjectConvertClass.static_ext_string(Row["bIsKey1"]), out Group.trainman1.isKey);
Group.trainman1.strFixedGroupID = ObjectConvertClass.static_ext_string(Row["strFixedGroupGUID1"]);
Group.trainman1.lastEndworkTime = TF.RunSafty.Utils.Parse.TFParse.DBToDateTime(Row["dtLastEndworkTime1"], DateTime.MinValue);
}
Group.trainman2.trainmanID = ObjectConvertClass.static_ext_string(Row["strTrainmanGUID2"]);
if (Group.trainman2.trainmanID != "")
{
Group.trainman2.trainmanName = ObjectConvertClass.static_ext_string(Row["strTrainmanName2"]);
Group.trainman2.trainmanNumber = ObjectConvertClass.static_ext_string(Row["strTrainmanNumber2"]);
if (Row["nPost2"] != null && !string.IsNullOrEmpty(ObjectConvertClass.static_ext_string(Row["nPost2"])))
{
Group.trainman2.postID = ObjectConvertClass.static_ext_int(Row["nPost2"]);
}
Group.trainman2.telNumber = ObjectConvertClass.static_ext_string(Row["strTelNumber2"]);
Group.trainman2.trainmanState = 0;
if (ObjectConvertClass.static_ext_string(Row["nTrainmanState2"]) != "")
{
Group.trainman2.trainmanState = ObjectConvertClass.static_ext_int(Row["nTrainmanState2"]);
}
Int32.TryParse(ObjectConvertClass.static_ext_string(Row["bIsKey2"]), out Group.trainman2.isKey);
Group.trainman2.strFixedGroupID = ObjectConvertClass.static_ext_string(Row["strFixedGroupGUID2"]);
Group.trainman2.lastEndworkTime = TF.RunSafty.Utils.Parse.TFParse.DBToDateTime(Row["dtLastEndworkTime2"], DateTime.MinValue);
}
Group.trainman3.trainmanID = ObjectConvertClass.static_ext_string(Row["strTrainmanGUID3"]);
if (Group.trainman3.trainmanID != "")
{
Group.trainman3.trainmanName = ObjectConvertClass.static_ext_string(Row["strTrainmanName3"]);
Group.trainman3.trainmanNumber = ObjectConvertClass.static_ext_string(Row["strTrainmanNumber3"]);
if (Row["nPost3"] != null && !string.IsNullOrEmpty(ObjectConvertClass.static_ext_string(Row["nPost3"])))
{
Group.trainman3.postID = ObjectConvertClass.static_ext_int(Row["nPost3"]);
}
Group.trainman3.telNumber = ObjectConvertClass.static_ext_string(Row["strTelNumber3"]);
Group.trainman3.trainmanState = 0;
if (ObjectConvertClass.static_ext_string(Row["nTrainmanState3"]) != "")
{
Group.trainman3.trainmanState = ObjectConvertClass.static_ext_int(Row["nTrainmanState3"]);
}
Int32.TryParse(ObjectConvertClass.static_ext_string(Row["bIsKey3"]), out Group.trainman3.isKey);
Group.trainman3.strFixedGroupID = ObjectConvertClass.static_ext_string(Row["strFixedGroupGUID3"]);
Group.trainman3.lastEndworkTime = TF.RunSafty.Utils.Parse.TFParse.DBToDateTime(Row["dtLastEndworkTime3"], DateTime.MinValue);
}
Group.trainman4.trainmanID = ObjectConvertClass.static_ext_string(Row["strTrainmanGUID4"]);
if (Group.trainman4.trainmanID != "")
{
Group.trainman4.trainmanName = ObjectConvertClass.static_ext_string(Row["strTrainmanName4"]);
Group.trainman4.trainmanNumber = ObjectConvertClass.static_ext_string(Row["strTrainmanNumber4"]);
if (Row["nPost4"] != null && !string.IsNullOrEmpty(ObjectConvertClass.static_ext_string(Row["nPost4"])))
{
Group.trainman4.postID = ObjectConvertClass.static_ext_int(Row["nPost4"]);
}
Group.trainman4.telNumber = ObjectConvertClass.static_ext_string(Row["strTelNumber4"]);
Group.trainman4.trainmanState = 0;
if (ObjectConvertClass.static_ext_string(Row["nTrainmanState4"]) != "")
{
Group.trainman4.trainmanState = ObjectConvertClass.static_ext_int(Row["nTrainmanState4"]);
}
Int32.TryParse(ObjectConvertClass.static_ext_string(Row["bIsKey4"]), out Group.trainman4.isKey);
Group.trainman4.strFixedGroupID = ObjectConvertClass.static_ext_string(Row["strFixedGroupGUID4"]);
Group.trainman4.lastEndworkTime = TF.RunSafty.Utils.Parse.TFParse.DBToDateTime(Row["dtLastEndworkTime4"], DateTime.MinValue);
}
}
public bool ProduceJDPlan(string SectionID, string SiteName, string SiteNumber, string TrainID, string JiaoluGUID, string SiteGUID, string UserGUID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * ");
strSql.Append(" FROM TAB_TMIS_Train where train_id='" + TrainID + "' ");
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString()).Tables[0];
if (dt.Rows.Count <= 0)
{
throw new Exception("未在TAB_TMIS_Train 表中找到train_id为" + TrainID + "的数据");
}
else
{
MDTrain model = new MDTrain();
model.strTrainNo = ObjectConvertClass.static_ext_string(dt.Rows[0]["train_code"]);
//通过出勤规则，计划开车时间计算出计划出勤时间
int minutes = GetPlanTimes(1, "2200004");
DateTime dtStartTime = ObjectConvertClass.static_ext_Date(dt.Rows[0]["time_deptart"]).AddMinutes(-minutes);
model.dtStartTime = dtStartTime;
model.strStartStation = getStationGUIDByName(ObjectConvertClass.static_ext_string(dt.Rows[0]["station_deptart"]));
model.strEndStation = getStationGUIDByName(ObjectConvertClass.static_ext_string(dt.Rows[0]["station_arrived"]));
model.strTrainPlanGUID = Guid.NewGuid().ToString();
model.strTrainTypeName = "";
model.strTrainNumber = "";
model.dtRealStartTime = Convert.ToDateTime("2000-01-01 00:00:00");
model.strTrainJiaoluGUID = JiaoluGUID;
model.nTrainmanTypeID = 1;
model.nPlanType = 1;
model.nDragType = 2;
TF.RunSafty.Utility.TGlobalDM d = new Utility.TGlobalDM();
string remark = "";
model.nKehuoID = Convert.ToInt32(d.getKeHuoByTrainNo(model.strTrainNo, ref remark));
TF.CommonUtility.LogClass.log("获取客货类型----车次：" + model.strTrainNo + "客货类型：" + model.nKehuoID + "备注：" + remark);
model.nRemarkType = 1;
model.strRemark = "";
model.nPlanState = 1;
model.dtCreateTime = DateTime.Now;
model.strCreateSiteGUID = SiteGUID;
model.strCreateUserGUID = UserGUID;
model.dtFirstStartTime = Convert.ToDateTime("2000-01-01 00:00:00");
model.dtChuQinTime = ObjectConvertClass.static_ext_Date(dt.Rows[0]["time_deptart"]);
model.nNeedRest = 0;
model.dtArriveTime = Convert.ToDateTime("2000-01-01 00:00:00");
model.dtCallTime = Convert.ToDateTime("2000-01-01 00:00:00");
model.strBak1 = "";
model.strMainPlanGUID = "";
model.strPlaceID = getPlaceIDByTJLGUID(JiaoluGUID);
if (this.AddPlan(model) >= 1)
{
string sql = "update TAB_TMIS_Train set strTrainPlanGUID = @strTrainPlanGUID where train_id='" + TrainID + "'";
SqlParameter[] param =
{
new SqlParameter("strTrainPlanGUID", model.strTrainPlanGUID)
};
SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, sql, param);
return(true);
}
}
return(false);
}