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