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