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