public bool GetGroupInfo(string GroupGUID, RRsGroup Group) { string strSql = "select top 1 * from VIEW_Nameplate_Group where strGroupGUID=@strGroupGUID"; SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter("strGroupGUID", GroupGUID) }; DataTable table = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql).Tables[0]; if (table.Rows.Count > 0) { ADOQueryToGroup(Group, table.Rows[0]); return(true); } return(false); }
public RRsGroup GetTrainmanGroup(string TrainmanGUID) { string strSql = @"select top 1 * from VIEW_Nameplate_Group where strTrainmanGUID1 =@strTrainmanGUID or strTrainmanGUID2=@strTrainmanGUID or strTrainmanGUID3=@strTrainmanGUID or strTrainmanGUID4=@strTrainmanGUID"; SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter("strTrainmanGUID", TrainmanGUID), }; DataTable table = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParameters).Tables[0]; if (table.Rows.Count > 0) { RRsGroup group = new RRsGroup(); ADOQueryToGroup(group, table.Rows[0]); return(group); } return(null); }
public void ADOQueryToGroup(RRsGroup Group, DataRow row) { Group.strGroupGUID = row["strGroupGUID"].ToString(); Group.strTrainPlanGUID = row["strTrainPlanGUID"].ToString(); DateTime dtArriveTime; if (row["dtLastArriveTime"] != null) { if (DateTime.TryParse(row["dtLastArriveTime"].ToString(), out dtArriveTime)) { Group.dtArriveTime = dtArriveTime; } } Group.ZFQJ.strZFQJGUID = row["strZFQJGUID"].ToString(); Group.ZFQJ.strTrainJiaoluGUID = row["strTrainJiaoluGUID"].ToString(); int nQuJianIndex; if (row["nQuJianIndex"] != null) { if (int.TryParse(row["nQuJianIndex"].ToString(), out nQuJianIndex)) { Group.ZFQJ.nQuJianIndex = nQuJianIndex; } } Group.ZFQJ.strBeginStationGUID = row["strBeginStationGUID"].ToString(); Group.ZFQJ.strBeginStationName = row["strBeginStationName"].ToString(); Group.ZFQJ.strEndStationGUID = row["strEndStationGUID"].ToString(); Group.ZFQJ.strEndStationName = row["strEndStationName"].ToString(); Group.Trainman1.strTrainmanGUID = row["strTrainmanGUID1"].ToString(); Group.Trainman1.strTrainmanName = row["strTrainmanName1"].ToString(); Group.Trainman1.strTrainmanNumber = row["strTrainmanNumber1"].ToString(); Group.Trainman1.strTelNumber = row["strTelNumber1"].ToString(); if (row["nTrainmanState1"] == null) { Group.Trainman1.nTrainmanState = TRsTrainmanState.tsNil; } else { Group.Trainman1.nTrainmanState = (TRsTrainmanState)(int.Parse(row["nTrainmanState1"].ToString())); } Group.Trainman1.nPostID = (TRsPost)(int.Parse(row["nPost1"].ToString())); Group.Trainman1.strWorkShopGUID = row["strWorkShopGUID1"].ToString(); DateTime dtLastEndworkTime; if (row["dtLastEndworkTime1"] != null) { if (DateTime.TryParse(row["dtLastEndworkTime1"].ToString(), out dtLastEndworkTime)) { Group.Trainman1.dtLastEndworkTime = dtLastEndworkTime; } } Group.Trainman2.strTrainmanGUID = row["strTrainmanGUID2"].ToString(); Group.Trainman2.strTrainmanName = row["strTrainmanName2"].ToString(); Group.Trainman2.strTrainmanNumber = row["strTrainmanNumber2"].ToString(); Group.Trainman2.strTelNumber = row["strTelNumber2"].ToString(); if (row["nTrainmanState2"] == null) { Group.Trainman2.nTrainmanState = TRsTrainmanState.tsNil; } else { Group.Trainman2.nTrainmanState = (TRsTrainmanState)Convert.ToInt32(row["nTrainmanState2"].ToString()); } int nPostID; if (row["nPost2"] != null && int.TryParse(row["nPost2"].ToString(), out nPostID)) { Group.Trainman2.nPostID = (TRsPost)nPostID; } Group.Trainman2.strWorkShopGUID = row["strWorkShopGUID2"].ToString(); if (row["dtLastEndworkTime2"] != null && DateTime.TryParse(row["dtLastEndworkTime2"].ToString(), out dtLastEndworkTime)) { Group.Trainman2.dtLastEndworkTime = dtLastEndworkTime; } Group.Trainman3.strTrainmanGUID = row["strTrainmanGUID3"].ToString(); Group.Trainman3.strTrainmanName = row["strTrainmanName3"].ToString(); Group.Trainman3.strTrainmanNumber = row["strTrainmanNumber3"].ToString(); Group.Trainman3.strTelNumber = row["strTelNumber3"].ToString(); if (row["nTrainmanState3"] == null) { Group.Trainman3.nTrainmanState = TRsTrainmanState.tsNil; } else { Group.Trainman3.nTrainmanState = (TRsTrainmanState)Convert.ToInt32(row["nTrainmanState3"]); } if (row["nPost3"] != null) { Group.Trainman3.nPostID = (TRsPost)Convert.ToInt32(row["nPost3"]); } Group.Trainman3.strWorkShopGUID = row["strWorkShopGUID3"].ToString(); if (row["dtLastEndworkTime3"] != null && DateTime.TryParse(row["dtLastEndworkTime3"].ToString(), out dtLastEndworkTime)) { Group.Trainman3.dtLastEndworkTime = dtLastEndworkTime; } Group.Trainman4.strTrainmanGUID = row["strTrainmanGUID4"].ToString(); Group.Trainman4.strTrainmanName = row["strTrainmanName4"].ToString(); Group.Trainman4.strTrainmanNumber = row["strTrainmanNumber4"].ToString(); Group.Trainman4.strTelNumber = row["strTelNumber4"].ToString(); if (row["nTrainmanState4"] == null) { Group.Trainman4.nTrainmanState = TRsTrainmanState.tsNil; } else { Group.Trainman4.nTrainmanState = (TRsTrainmanState)Convert.ToInt32(row["nTrainmanState4"]); } if (row["nPost4"] != null) { Group.Trainman4.nPostID = (TRsPost)Convert.ToInt32(row["nPost4"]); } Group.Trainman4.strWorkShopGUID = row["strWorkShopGUID4"].ToString(); if (row["dtLastEndworkTime4"] != null && DateTime.TryParse(row["dtLastEndworkTime4"].ToString(), out dtLastEndworkTime)) { Group.Trainman4.dtLastEndworkTime = dtLastEndworkTime; } }