private void ReadOrderGroups(string workShopGUID, List <NpCommon> npCommons)
{
//获取所有的轮乘交路名牌
string strSql = string.Format(@"select * from VIEW_Nameplate_TrainmanJiaolu_Order where strTrainmanJiaoluGUID in
(select strTrainmanJiaoluGUID from tab_base_jiaolurelation where strTrainJiaoluGUID in
(select strTrainJiaoluGUID from TAB_Base_TrainJiaolu where strWorkShopGUID=@strWorkShopGUID))
order by strTrainmanJiaoluGUID,GroupState,dtLastArriveTime");
SqlParameter[] sqlParamsOrder =
{
new SqlParameter("strWorkShopGUID", workShopGUID)
};
DataTable tabOrder = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParamsOrder).Tables[0];
NpCommon npCommon = null;
foreach (DataRow dr in tabOrder.Rows)
{
GetNpCommon(dr, ref npCommon, npCommons);
NpGroup grp = new NpGroup();
grp.order = DBObjToInt(dr["nOrder"]);
DBRowToGroup(dr, grp);
npCommon.dataArray.Add(grp);
}
}
private void DBRowToGroup(DataRow dr, NpGroup group)
{
group.grpId = dr["strGroupGUID"].ToString();
group.state = 2;
if (dr["GroupState"].ToString() != "")
{
group.state = 3;
if (int.Parse(dr["GroupState"].ToString()) == 7)
{
group.state = 6;
}
}
if (dr["strTrainmanGUID1"].ToString() != "")
{
group.tm1 = new NpTrainman();
group.tm1.tmName = dr["strTrainmanName1"].ToString();
group.tm1.tmNumber = dr["strTrainmanNumber1"].ToString();
group.tm1.tmPost = 1;
if (dr["nPost1"].ToString() != "")
{
group.tm1.tmPost = int.Parse(dr["nPost1"].ToString());
}
}
if (dr["strTrainmanGUID2"].ToString() != "")
{
group.tm2 = new NpTrainman();
group.tm2.tmName = dr["strTrainmanName2"].ToString();
group.tm2.tmNumber = dr["strTrainmanNumber2"].ToString();
group.tm2.tmPost = 1;
if (dr["nPost2"].ToString() != "")
{
group.tm2.tmPost = int.Parse(dr["nPost2"].ToString());
}
}
if (dr["strTrainmanGUID3"].ToString() != "")
{
group.tm3 = new NpTrainman();
group.tm3.tmName = dr["strTrainmanName3"].ToString();
group.tm3.tmNumber = dr["strTrainmanNumber3"].ToString();
group.tm3.tmPost = 1;
if (dr["nPost3"].ToString() != "")
{
group.tm3.tmPost = int.Parse(dr["nPost3"].ToString());
}
}
if (dr["strTrainmanGUID4"].ToString() != "")
{
group.tm4 = new NpTrainman();
group.tm4.tmName = dr["strTrainmanName4"].ToString();
group.tm4.tmNumber = dr["strTrainmanNumber4"].ToString();
group.tm4.tmPost = 1;
if (dr["nPost4"].ToString() != "")
{
group.tm4.tmPost = int.Parse(dr["nPost4"].ToString());
}
}
}