/// <summary>
/// 根据环节id获取是否所有步骤已完成 false为全完成
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static bool boolCheckStepFinish(DataRow dr, int jcid)
{
SqlParameter[] hssqlParams =
{
new SqlParameter("stepid", dr["stepID"].ToString()),
new SqlParameter("jcid", jcid)
};
int type = PageBase.static_ext_int(dr["nStepType"].ToString());
if (dr["nEnabled"].ToString() == "0")
{
return(true);
}
if (type >= 7 && type <= 99 && type != 17)
{
string sql = @"select count(*) from View_CheckStandardHandleFinish where strID = @stepid and nEnabled=1 and JiCheID=@jcid and nState=1;";
if (PageBase.static_ext_int(SqlHelper.ExecuteScalar(searchmaster.GetSqlConnConfig("57"), CommandType.Text, sql, hssqlParams)) <= 0)
{
return(false);
}
}
else
{
switch (type)
{
case 0: //风速 只检验整备后风速
if (dr["nCaseType"].ToString() == "2")
{
string Sql2 = @"select strID,JiCheID from View_CheckFengSuFinish where strID = @stepid and nEnabled=1 and JiCheID=@jcid and nFinalIsQualified=1 and nSstate=1 group by strID,JiCheID;";
if (PageBase.static_ext_int(SqlHelper.ExecuteDataset(searchmaster.GetSqlConnConfig("57"), CommandType.Text, Sql2, hssqlParams).Tables[0].Rows.Count) <= 0)
{
return(false);
}
}
break;
case 1: //滤网
///读取手持机卡控 是否启用该步骤
if (SysConfig.GetSingleSysconfig("Scjkk", "Lw") == "True")
{
lsDatLvWang lsdatlv = lsDatLvWang.getLastLvWangJianCeRiQi("", "", jcid);
TimeSpan ts = PageBase.diffTimeReturnTimeSpan(lsdatlv.genghuanriqi, DateTime.Now);
if (ts.Days > lsdatlv.nGhts)
{
string Sql1 = @"select count(*) from View_ChecklvWangFinish where strID = @stepid and nEnabled=1 and JiCheID=@jcid and nState=1;";
if (PageBase.static_ext_int(SqlHelper.ExecuteScalar(searchmaster.GetSqlConnConfig("57"), CommandType.Text, Sql1, hssqlParams)) <= 0)
{
return(false);
}
}
}
break;
case 2: //单节
string Sql3 = @"select count(*) from View_CheckDanJieFinish where strID = @stepid and nEnabled=1 and JiCheID=@jcid and nState=1;";
if (PageBase.static_ext_int(SqlHelper.ExecuteScalar(searchmaster.GetSqlConnConfig("57"), CommandType.Text, Sql3, hssqlParams)) <= 0)
{
return(false);
}
break;
case 3: //直供电
string Sql4 = @"select strID,JiCheID from View_CheckZhiGongDianFinish where strID = @stepid and nEnabled=1 and JiCheID=@jcid and nSstate=1 group by strID,JiCheID;";
if (PageBase.static_ext_int(SqlHelper.ExecuteDataset(searchmaster.GetSqlConnConfig("57"), CommandType.Text, Sql4, hssqlParams).Tables[0].Rows.Count) <= 0)
{
return(false);
}
break;
case 4: //瓷瓶
string Sql5 = @"select count(*) from View_CheckCiPingFinish where strID = @stepid and nEnabled=1 and JiCheID=@jcid and nState=1;";
if (PageBase.static_ext_int(SqlHelper.ExecuteScalar(searchmaster.GetSqlConnConfig("57"), CommandType.Text, Sql5, hssqlParams)) <= 0)
{
return(false);
}
break;
case 5: //列车管
if (SysConfig.GetSingleSysconfig("Scjkk", "Lcg") == "True")
{
lsDatLieCheGuan lsdatlcg = lsDatLieCheGuan.getLastLcgJianCeRiQi("", "", jcid);
TimeSpan timespan = PageBase.diffTimeReturnTimeSpan(lsdatlcg.JianChaDate, DateTime.Now);
if (timespan.Days > lsdatlcg.nGhts)
{
string Sql6 = @"select count(*) from View_CheckLiCheGuanFinish where strID = @stepid and nEnabled=1 and JiCheID=@jcid and nState=1;";
if (PageBase.static_ext_int(SqlHelper.ExecuteScalar(searchmaster.GetSqlConnConfig("57"), CommandType.Text, Sql6, hssqlParams)) <= 0)
{
return(false);
}
}
}
break;
case 6: //受电弓
string Sql7 = @"select count(*) from View_CheckHuaBanFinish where strID = @stepid and nEnabled=1 and JiCheID=@jcid and nState=1;";
if (PageBase.static_ext_int(SqlHelper.ExecuteScalar(searchmaster.GetSqlConnConfig("57"), CommandType.Text, Sql7, hssqlParams)) <= 0)
{
return(false);
}
break;
}
}
return(true);
}
/// <summary>
/// 根据环节id获取是否所有步骤已完成 false为全完成
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static bool boolCheckCaseFinish(string id, int zbid)
{
string hssql = @"select a.strID,a.nStepType,b.nCaseType from TAB_HandleStep a,TAB_HandleCase b where b.strID=a.strCaseID and a.strCaseID = @id and a.nEnabled=1";
SqlParameter[] hssqlParams =
{
new SqlParameter("id", id),
new SqlParameter("zbid", zbid)
};
DataTable dtHandlerStepStrid = SqlHelper.ExecuteDataset(searchmaster.GetSqlConnConfig("57"), CommandType.Text, hssql, hssqlParams).Tables[0];
foreach (DataRow dr in dtHandlerStepStrid.Rows)
{
int type = PageBase.static_ext_int(dr["nStepType"].ToString());
if (type >= 7 && type <= 16)
{
String strSQLText = "select count(*) from View_CheckStandardHandleFinish where JiCheID=@zbid and nEnabled=1 And strCaseID = @id and nState=1 and nStepType = " + type;
if (PageBase.static_ext_int(SqlHelper.ExecuteScalar(searchmaster.GetSqlConnConfig("57"), CommandType.Text, strSQLText, hssqlParams)) <= 0)
{
return(false);
}
}
else
{
switch (type)
{
//卡控整备后的数据
case 0: //风速
if (dr["nCaseType"].ToString() == "2")
{
string Sql2 = @"select strCaseID from View_CheckFengSuFinish where strCaseID = @id and nEnabled=1 and JiCheID=@zbid and nSstate=1 group by strCaseID,JiCheID;";
if (PageBase.static_ext_int(SqlHelper.ExecuteDataset(searchmaster.GetSqlConnConfig("57"), CommandType.Text, Sql2, hssqlParams).Tables[0].Rows.Count) <= 0)
{
return(false);
}
}
break;
case 1: //滤网
///读取手持机卡控 是否启用该步骤
if (SysConfig.GetSingleSysconfig("Scjkk", "Lw") == "True")
{
lsDatLvWang lsdatlv = lsDatLvWang.getLastLvWangJianCeRiQi("", "", zbid);
TimeSpan ts = PageBase.diffTimeReturnTimeSpan(lsdatlv.genghuanriqi, DateTime.Now);
if (ts.Days > lsdatlv.nGhts)
{
string Sql1 = @"select count(*) from View_ChecklvWangFinish where strID = @stepid and nEnabled=1 and JiCheID=@jcid and nState=1;";
if (PageBase.static_ext_int(SqlHelper.ExecuteScalar(searchmaster.GetSqlConnConfig("57"), CommandType.Text, Sql1, hssqlParams)) <= 0)
{
return(false);
}
}
}
break;
case 2: //单节
string Sql3 = @"select count(*) from View_CheckDanJieFinish where strCaseID = @id and nEnabled=1 and JiCheID=@zbid and nState=1;";
if (PageBase.static_ext_int(SqlHelper.ExecuteScalar(searchmaster.GetSqlConnConfig("57"), CommandType.Text, Sql3, hssqlParams)) <= 0)
{
return(false);
}
break;
case 3: //直供电
string Sql4 = @"select strCaseID from View_CheckZhiGongDianFinish where strCaseID = @id and nEnabled=1 and JiCheID=@zbid and nSstate=1 group by strCaseID,JiCheID;";
if (PageBase.static_ext_int(SqlHelper.ExecuteDataset(searchmaster.GetSqlConnConfig("57"), CommandType.Text, Sql4, hssqlParams).Tables[0].Rows.Count) <= 0)
{
return(false);
}
break;
case 4: //瓷瓶
string Sql5 = @"select count(*) from View_CheckCiPingFinish where strCaseID = @id and nEnabled=1 and JiCheID=@zbid and nState=1;";
if (PageBase.static_ext_int(SqlHelper.ExecuteScalar(searchmaster.GetSqlConnConfig("57"), CommandType.Text, Sql5, hssqlParams)) <= 0)
{
return(false);
}
break;
case 5: //列车管
if (SysConfig.GetSingleSysconfig("Scjkk", "Lcg") == "True")
{
lsDatLieCheGuan lsdatlcg = lsDatLieCheGuan.getLastLcgJianCeRiQi("", "", zbid);
TimeSpan timespan = PageBase.diffTimeReturnTimeSpan(lsdatlcg.JianChaDate, DateTime.Now);
if (timespan.Days > lsdatlcg.nGhts)
{
string Sql6 = @"select count(*) from View_CheckLiCheGuanFinish where strID = @stepid and nEnabled=1 and JiCheID=@jcid and nState=1;";
if (PageBase.static_ext_int(SqlHelper.ExecuteScalar(searchmaster.GetSqlConnConfig("57"), CommandType.Text, Sql6, hssqlParams)) <= 0)
{
return(false);
}
}
}
break;
case 6: //受电弓
string Sql7 = @"select count(*) from View_CheckHuaBanFinish where strCaseID = @id and nEnabled=1 and JiCheID=@zbid and nState=1;";
if (PageBase.static_ext_int(SqlHelper.ExecuteScalar(searchmaster.GetSqlConnConfig("57"), CommandType.Text, Sql7, hssqlParams)) <= 0)
{
return(false);
}
break;
}
}
}
return(true);
}