/// <summary>
/// 获取各交路下人员数量
/// </summary>
public InterfaceOutPut GetTrainmanJiaoLuCount(String Data)
{
InterfaceOutPut output = new InterfaceOutPut();
output.result = 1;
try
{
JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();
InGetTrainmanJiaoLuCount InParams = javaScriptSerializer.Deserialize <InGetTrainmanJiaoLuCount>(Data);
OutGetTrainmanJiaoLuCount OutParams = new OutGetTrainmanJiaoLuCount();
string strSql = @"select count(*) as nCount,strTrainmanJiaoluGUID,strTrainmanJiaoluName from VIEW_Nameplate_TrainmanInJiaolu_All
where strTrainmanJiaoluGUID in (select strTrainmanJiaoluGUID from VIEW_Base_JiaoluRelation where strWorkShopGUID = @strWorkShopGUID)
group by strTrainmanJiaoluGUID,strTrainmanJiaoluName ";
SqlParameter[] sqlParams = new SqlParameter[] {
new SqlParameter("strWorkShopGUID", InParams.WorkShopGUID)
};
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
TrainmanJiaoluCount c = new TrainmanJiaoluCount();
c.nCount = ObjectConvertClass.static_ext_int(dt.Rows[i]["nCount"]);
c.strJiaoLuName = dt.Rows[i]["strTrainmanJiaoluName"].ToString();
OutParams.SumCount.Add(c);
}
output.data = OutParams;
output.result = 0;
}
catch (Exception ex)
{
output.resultStr = ex.Message;
LogClass.log("Interface.GetTrainmanJiaoLuCount:" + ex.Message);
throw ex;
}
return(output);
}
/// <summary>
/// 根据nid获取乘务员
/// </summary>
public InterfaceOutPut GetTrainmanByID(String Data)
{
InterfaceOutPut output = new InterfaceOutPut();
output.result = 1;
try
{
JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();
InGetTrainmanByID InParams = javaScriptSerializer.Deserialize <InGetTrainmanByID>(Data);
string strSql = "select top 1 * from VIEW_Org_Trainman where nid = @nid";
SqlParameter[] sqlParams = new SqlParameter[] {
new SqlParameter("nid", InParams.ID)
};
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams).Tables[0];
OutGetTrainmanByID OutParams = new OutGetTrainmanByID();
output.data = OutParams;
if (dt.Rows.Count > 0)
{
PSTrainman.TrainmanFromDB(OutParams.TM, dt.Rows[0], 0);
}
output.result = 0;
}
catch (Exception ex)
{
output.resultStr = ex.Message;
LogClass.log("Interface.GetTrainmanByID:" + ex.Message);
throw ex;
}
return(output);
}
/// <summary>
/// 获取车间下各交路的人员状态分布及机组信息
/// </summary>
public InterfaceOutPut GetTrainmanRunStateCount(String Data)
{
InterfaceOutPut output = new InterfaceOutPut();
output.result = 1;
try
{
JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();
InGetTrainmanRunStateCount InParams = javaScriptSerializer.Deserialize <InGetTrainmanRunStateCount>(Data);
OutGetTrainmanRunStateCount OutParams = new OutGetTrainmanRunStateCount();
string strSql = @"select tm.*,p.nPlanState,
(select top 1 nEventID from tab_plan_RunEvent where tm.strTrainPlanGUID = strTrainPlanGUID order by dtEventTime desc) as nEventID from
(
select strWorkShopGUID1,strTrainmanName1,strTrainmanNumber1, strTrainmanName2,strTrainmanNumber2,strTrainmanName3,strTrainmanNumber3, strTrainmanName4,strTrainmanNumber4,strTrainmanJiaoluName,strTrainPlanGUID from VIEW_Nameplate_Group
)
as tm left join tab_plan_train as p on tm.strTrainPlanGUID = p.strTrainPlanGUID
left join TAB_Org_WorkShop as w on tm.strWorkShopGUID1 = w.strWorkShopGUID where strWorkShopGUID1 = @strWorkShopGUID order by strTrainmanjiaoluName";
SqlParameter[] sqlParams = new SqlParameter[] {
new SqlParameter("strWorkShopGUID", InParams.WorkShopGUID)
};
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
bool bFind = false;
for (int k = 0; k < OutParams.Sum.Count; k++)
{
if (dt.Rows[i]["strTrainmanJiaoluName"].ToString() == OutParams.Sum[k].strJiaoLuName)
{
TrainmanGroup group = new TrainmanGroup();
group.TrainmanName1 = dt.Rows[i]["strTrainmanName1"].ToString();
group.TrainmanName2 = dt.Rows[i]["strTrainmanName2"].ToString();
group.TrainmanName3 = dt.Rows[i]["strTrainmanName3"].ToString();
group.TrainmanName4 = dt.Rows[i]["strTrainmanName4"].ToString();
group.TrainmanNumber1 = dt.Rows[i]["strTrainmanNumber1"].ToString();
group.TrainmanNumber2 = dt.Rows[i]["strTrainmanNumber2"].ToString();
group.TrainmanNumber3 = dt.Rows[i]["strTrainmanNumber3"].ToString();
group.TrainmanNumber4 = dt.Rows[i]["strTrainmanNumber4"].ToString();
string nEvent = dt.Rows[i]["nEventID"].ToString();
if (nEvent == "10001")
{
group.GroupState = 5; //tsOutRoom
OutParams.Sum[k].nSiteCount++;
//Inc(TrainmanRunStateCountArray[n].nSiteCount) ;
}
else
{
string nPlanState = dt.Rows[i]["nPlanState"].ToString();
if (nPlanState == "7")
{
group.GroupState = 6;//tsRuning;
OutParams.Sum[k].nRuningCount++;
//Inc(TrainmanRunStateCountArray[n].nRuningCount) ;
}
else
{
group.GroupState = 4; //tsInRoom;
OutParams.Sum[k].nLocalCount++;
//Inc(TrainmanRunStateCountArray[n].nLocalCount) ;
}
}
bFind = true;
OutParams.Sum[k].group.Add(group);
break;
}
}
if (!bFind)
{
TrainmanRunStateCount sum = new TrainmanRunStateCount();
sum.strJiaoLuName = dt.Rows[i]["strTrainmanJiaoluName"].ToString();
TrainmanGroup group = new TrainmanGroup();
group.TrainmanName1 = dt.Rows[i]["strTrainmanName1"].ToString();
group.TrainmanName2 = dt.Rows[i]["strTrainmanName2"].ToString();
group.TrainmanName3 = dt.Rows[i]["strTrainmanName3"].ToString();
group.TrainmanName4 = dt.Rows[i]["strTrainmanName4"].ToString();
group.TrainmanNumber1 = dt.Rows[i]["strTrainmanNumber1"].ToString();
group.TrainmanNumber2 = dt.Rows[i]["strTrainmanNumber2"].ToString();
group.TrainmanNumber3 = dt.Rows[i]["strTrainmanNumber3"].ToString();
group.TrainmanNumber4 = dt.Rows[i]["strTrainmanNumber4"].ToString();
string nEvent = dt.Rows[i]["nEventID"].ToString();
if (nEvent == "10001")
{
group.GroupState = 5; //tsOutRoom
sum.nSiteCount = 1;
//Inc(TrainmanRunStateCountArray[n].nSiteCount) ;
}
else
{
string nPlanState = dt.Rows[i]["nPlanState"].ToString();
if (nPlanState == "7")
{
group.GroupState = 6;//tsRuning;
sum.nRuningCount = 1;
//Inc(TrainmanRunStateCountArray[n].nRuningCount) ;
}
else
{
group.GroupState = 4;//tsInRoom;
sum.nLocalCount = 1;
//Inc(TrainmanRunStateCountArray[n].nLocalCount) ;
}
}
sum.group.Add(group);
OutParams.Sum.Add(sum);
}
}
output.data = OutParams;
output.result = 0;
}
catch (Exception ex)
{
output.resultStr = ex.Message;
LogClass.log("Interface.GetTrainmanRunStateCount:" + ex.Message);
throw ex;
}
return(output);
}
/// <summary>
/// 获取指定车间内各种请销假人员的数量
/// </summary>
public InterfaceOutPut GetTrainmanLeaveCount(String Data)
{
InterfaceOutPut output = new InterfaceOutPut();
output.result = 1;
try
{
JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();
InGetTrainmanLeaveCount InParams = javaScriptSerializer.Deserialize <InGetTrainmanLeaveCount>(Data);
OutGetTrainmanLeaveCount OutParams = new OutGetTrainmanLeaveCount();
string strSql = @"select * from TAB_LeaveMgr_LeaveType order by strTypeGUID,strTypeName ";
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
EnumSum sum = new EnumSum();
sum.EnumCount = 0;
sum.EnumID = dt.Rows[i]["strTypeGUID"].ToString();
sum.EnumName = dt.Rows[i]["strTypeName"].ToString();
OutParams.Sum.Add(sum);
}
strSql = @"select strTrainmanNumber,
(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 order by strLeaveTypeGUID,strTrainmanNumber ";
SqlParameter[] sqlParams = new SqlParameter[] {
new SqlParameter("strWorkShopGUID", InParams.WorkShopGUID)
};
dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
bool bFind = false;
for (int k = 0; k < OutParams.Sum.Count; k++)
{
if (OutParams.Sum[k].EnumID == dt.Rows[i]["strLeaveTypeGUID"].ToString())
{
OutParams.Sum[k].EnumCount++;
bFind = true;
break;
}
}
if (!bFind)
{
EnumSum sum = new EnumSum();
sum.EnumCount = 1;
sum.EnumID = dt.Rows[i]["strLeaveTypeGUID"].ToString();
sum.EnumName = dt.Rows[i]["strLeaveTypeName"].ToString();
OutParams.Sum.Add(sum);
}
}
output.data = OutParams;
output.result = 0;
}
catch (Exception ex)
{
output.resultStr = ex.Message;
LogClass.log("Interface.GetTrainmanLeaveCount:" + ex.Message);
throw ex;
}
return(output);
}
/// <summary>
/// 获取各状态人员数量统计信息
/// </summary>
public InterfaceOutPut GetTrainmanStateCount(String Data)
{
InterfaceOutPut output = new InterfaceOutPut();
output.result = 1;
try
{
JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();
InGetTrainmanStateCount InParams = javaScriptSerializer.Deserialize <InGetTrainmanStateCount>(Data);
OutGetTrainmanStateCount OutParams = new OutGetTrainmanStateCount();
string strSql = "select nTrainmanState,count(*) as c from TAB_Org_Trainman where strWorkShopGUID = @strWorkShopGUID group by nTrainmanState order by nTrainmanState";
SqlParameter[] sqlParams = new SqlParameter[] {
new SqlParameter("strWorkShopGUID", InParams.WorkShopGUID)
};
OutParams.SumCount.nInRoom = 0;
OutParams.SumCount.nNil = 0;
OutParams.SumCount.nNormal = 0;
OutParams.SumCount.nOutRoom = 0;
OutParams.SumCount.nPlaning = 0;
OutParams.SumCount.nReady = 0;
OutParams.SumCount.nRuning = 0;
OutParams.SumCount.nUnRuning = 0;
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams).Tables[0];
foreach (DataRow dr in dt.Rows)
{
switch (dr["nTrainmanState"].ToString())
{
case "0":
{
OutParams.SumCount.nUnRuning = ObjectConvertClass.static_ext_int(dr["c"]);
break;
}
case "1":
{
OutParams.SumCount.nReady = ObjectConvertClass.static_ext_int(dr["c"]);
break;
}
case "2":
{
OutParams.SumCount.nNormal = ObjectConvertClass.static_ext_int(dr["c"]);
break;
}
case "3":
{
OutParams.SumCount.nPlaning = ObjectConvertClass.static_ext_int(dr["c"]);
break;
}
case "4":
{
OutParams.SumCount.nInRoom = ObjectConvertClass.static_ext_int(dr["c"]);
break;
}
case "5":
{
OutParams.SumCount.nOutRoom = ObjectConvertClass.static_ext_int(dr["c"]);
break;
}
case "6":
{
OutParams.SumCount.nRuning = ObjectConvertClass.static_ext_int(dr["c"]);
break;
}
case "7":
{
OutParams.SumCount.nNil = ObjectConvertClass.static_ext_int(dr["c"]);
break;
}
default: break;
}
}
output.data = OutParams;
output.result = 0;
}
catch (Exception ex)
{
output.resultStr = ex.Message;
LogClass.log("Interface.GetTrainmanStateCount:" + ex.Message);
throw ex;
}
return(output);
}