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