private void ReadNamedGroups(string workShopGUID, List <NpCommon> npCommons)
{
//获取所有的记名式交路名牌
string strSql = string.Format(@"select * from VIEW_Nameplate_TrainmanJiaolu_Named where strTrainmanJiaoluGUID in
(select strTrainmanJiaoluGUID from tab_base_jiaolurelation where strTrainJiaoluGUID in
(select strTrainJiaoluGUID from TAB_Base_TrainJiaolu where strWorkShopGUID=@strWorkShopGUID))
order by strTrainmanJiaoluGUID,nCheciOrder");
SqlParameter[] sqlParamsNamed =
{
new SqlParameter("strWorkShopGUID", workShopGUID)
};
DataTable tabNamed = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParamsNamed).Tables[0];
NpCommon npCommon = null;
foreach (DataRow dr in tabNamed.Rows)
{
GetNpCommon(dr, ref npCommon, npCommons);
NpNamedGroup grp = new NpNamedGroup();
grp.cc1 = dr["strCheci1"].ToString();
grp.cc2 = dr["strCheci2"].ToString();
grp.order = DBObjToInt(dr["nCheciOrder"]);
DBRowToGroup(dr, grp);
npCommon.dataArray.Add(grp);
}
}
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 ReadUnrun(string workShopGUID, List <NpCommon> npCommons)
{
//获取所有请销假人员
string strSql = @"select strTrainmanGUID,strTrainmanNumber,strTrainmanName,nPostID,strTrainmanJiaoluGUID,
(select top 1 strLeaveTypeGUID from VIEW_LeaveMgr_AskLeaveWithTypeName where strTrainmanID=strTrainmanNumber order by dBeginTime desc) as strLeaveTypeGUID,
(select top 1 strTypeName from VIEW_LeaveMgr_AskLeaveWithTypeName where strTrainmanID=strTrainmanNumber order by dBeginTime desc) as strLeaveTypeName
from VIEW_Org_Trainman where strWorkShopGUID=@strWorkShopGUID
and nTrainmanState = 0 and isnull(strTrainmanJiaoluGUID,'') <> '' order by strTrainmanJiaoluGUID,strLeaveTypeGUID,strTrainmanNumber ";
SqlParameter[] sqlParamsUnrun =
{
new SqlParameter("strWorkShopGUID", workShopGUID)
};
DataTable tabUnun = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParamsUnrun).Tables[0];
NpCommon npCommon = null;
NpUnrun unrun = null;
foreach (DataRow dr in tabUnun.Rows)
{
GetNpCommon(dr, ref npCommon, npCommons);
if ((unrun == null) || (unrun.leaveTypeName != dr["strLeaveTypeName"].ToString()))
{
unrun = new NpUnrun();
npCommon.dataArray.Add(unrun);
unrun.leaveTypeId = dr["strLeaveTypeGUID"].ToString();
unrun.leaveTypeName = dr["strLeaveTypeName"].ToString();
}
NpTrainman tm = new NpTrainman();
unrun.tms.Add(tm);
tm.tmName = dr["strTrainmanName"].ToString();
tm.tmNumber = dr["strTrainmanNumber"].ToString();
tm.tmPost = 1;
if (dr["nPostID"].ToString() != "")
{
tm.tmPost = int.Parse(dr["nPostID"].ToString());
}
}
foreach (NpCommon item in npCommons)
{
GetJlInfo(item.jlId, out item.jlName, out item.jlType);
}
}
private void GetNpCommon(DataRow dr, ref NpCommon npCommon, List <NpCommon> npCommons)
{
if ((npCommon == null) || (npCommon.jlId != dr["strTrainmanJiaoluGUID"].ToString()))
{
npCommon = new NpCommon();
npCommons.Add(npCommon);
npCommon.jlId = dr["strTrainmanJiaoluGUID"].ToString();
if (dr.Table.Columns.Contains("strTrainmanJiaoluName"))
{
npCommon.jlName = dr["strTrainmanJiaoluName"].ToString();
}
if (dr.Table.Columns.Contains("nJiaoluType"))
{
npCommon.jlType = DBObjToInt(dr["nJiaoluType"]);
}
}
}
private void ReadReadyPlates(string workShopGUID, List <NpCommon> npCommons)
{
//获取所有预备人员
string strSql = @"select strTrainmanGUID,strTrainmanNumber,strTrainmanName,nPostID,strTrainmanJiaoluGUID
from VIEW_Org_Trainman where strWorkShopGUID=@strWorkShopGUID
and nTrainmanState = 1 and isnull(strTrainmanJiaoluGUID,'') <> '' order by strTrainmanJiaoluGUID,strTrainmanNumber ";
SqlParameter[] sqlParamsPrepare =
{
new SqlParameter("strWorkShopGUID", workShopGUID)
};
DataTable tabPrepare = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParamsPrepare).Tables[0];
NpCommon npCommon = null;
foreach (DataRow dr in tabPrepare.Rows)
{
GetNpCommon(dr, ref npCommon, npCommons);
NpTrainman tm = new NpTrainman();
tm.tmName = dr["strTrainmanName"].ToString();
tm.tmNumber = dr["strTrainmanNumber"].ToString();
tm.tmPost = 1;
if (dr["nPostID"].ToString() != "")
{
tm.tmPost = int.Parse(dr["nPostID"].ToString());
}
npCommon.dataArray.Add(tm);
}
foreach (NpCommon item in npCommons)
{
GetJlInfo(item.jlId, out item.jlName, out item.jlType);
}
}
