/// <summary> /// 根据车型车号获取滤网上次更换时间 /// </summary> /// <param name="locotype"></param> /// <param name="loconum"></param> /// <returns></returns> public static lsDatLvWang getLastLvWangJianCeRiQi(string locotype, string loconum, int jcid) { string strSql = "SELECT TOP (1) a.*,(SELECT TianShu FROM dbo.lsDicJianCeTianShu WHERE (LocoType = b.LocoType) AND (FenLei = '滤网') AND (UnitId = b.UnitId)) as ts FROM dbo.lsDatLvWang a,lsDatJT6JiChe b WHERE (a.LocoType = b.LocoType) AND (a.LocoNum = b.LocoNum) AND (a.LocoNum = @LocoNum) AND (a.LocoType = @LocoType) ORDER BY a.genghuanriqi DESC"; if (jcid != 0) { strSql = "SELECT TOP (1) a.*,(SELECT TianShu FROM dbo.lsDicJianCeTianShu WHERE (LocoType = b.LocoType) AND (FenLei = '滤网') AND (UnitId = b.UnitId)) as ts FROM dbo.lsDatLvWang a,lsDatJT6JiChe b WHERE a.LocoType = b.LocoType AND a.LocoNum = b.LocoNum and b.ID=@ID ORDER BY a.genghuanriqi DESC"; } SqlParameter[] sqlParams = { new SqlParameter("LocoType", locotype), new SqlParameter("LocoNum", loconum), new SqlParameter("ID", jcid) }; DataTable dt = SqlHelper.ExecuteDataset(searchmaster.GetSqlConnConfig("57"), CommandType.Text, strSql, sqlParams).Tables[0]; lsDatLvWang lsdatlvwang = new lsDatLvWang(); if (dt.Rows.Count > 0) { lsdatlvwang.nGhts = PageBase.static_ext_int(dt.Rows[0]["ts"]); SetValue(lsdatlvwang, dt.Rows[0]); } return(lsdatlvwang); }
public static string GetBjInfo(lsDatJT6JiChe jiche) { string rtnstr = ""; DataTable dtCheckType = lsDicJianCeTianShu.GetlsDicJianCeTianShu(jiche.LocoType, jiche.UnitId); if (dtCheckType.Rows.Count > 0) { foreach (DataRow dr in dtCheckType.Rows) { switch (dr["FenLei"].ToString()) { case "滤网": lsDatLvWang lsdatlw = lsDatLvWang.getLastLvWangJianCeRiQi(jiche.LocoType, jiche.LocoNum, 0); string lvbj = MakeBjContent(lsdatlw.genghuanriqi, PageBase.static_ext_int(dr["TianShu"]), PageBase.static_ext_int(dr["BaoJing"]), "滤网"); rtnstr += lvbj; rtnstr += lvbj == "" ? "" : ","; break; case "列车管": lsDatLieCheGuan lsdatlcg = lsDatLieCheGuan.getLastLcgJianCeRiQi(jiche.LocoType, jiche.LocoNum, 0); string lcgbj = MakeBjContent(lsdatlcg.JianChaDate, PageBase.static_ext_int(dr["TianShu"]), PageBase.static_ext_int(dr["BaoJing"]), "列车管"); rtnstr += lcgbj; rtnstr += lcgbj == "" ? "" : ","; break; } } } rtnstr = PageBase.CutComma(rtnstr); return(rtnstr); }
/// <summary> /// 根据传入where条件获取滤网记录 /// </summary> /// <param name="where"></param> /// <returns></returns> public static lsDatLvWang LvWangRecord(string where) { string strSql = "select * from lsDatLvWang where 1=1 " + where; DataTable dtLvWang = SqlHelper.ExecuteDataset(searchmaster.GetSqlConnConfig("57"), CommandType.Text, strSql).Tables[0]; lsDatLvWang LvWang = new lsDatLvWang(); return(SetValue(LvWang, dtLvWang.Rows[0])); }
/// <summary> /// 结构体赋值 /// </summary> /// <param name="StandardHandle"></param> /// <param name="dr"></param> /// <returns></returns> public static lsDatLvWang SetValue(lsDatLvWang LvWang, DataRow dr) { if (dr != null) { LvWang.ID = dr["strID"].ToString(); LvWang.LocoType = dr["LocoType"].ToString(); LvWang.LocoNum = dr["LocoNum"].ToString(); LvWang.banCi = dr["banCi"].ToString(); LvWang.genghuanriqi = PageBase.static_ext_date(dr["genghuanriqi"].ToString()); LvWang.genghuanren = dr["genghuanren"].ToString(); LvWang.GovernUnitId = PageBase.static_ext_int(dr["GovernUnitId"].ToString()); LvWang.UnitId = PageBase.static_ext_int(dr["UnitId"].ToString()); LvWang.DepartmentId = PageBase.static_ext_int(dr["DepartmentId"].ToString()); LvWang.ApanageId = PageBase.static_ext_int(dr["ApanageId"].ToString()); LvWang.strStepID = dr["strStepID"].ToString(); LvWang.strID = dr["strID"].ToString(); LvWang.JiCheID = PageBase.static_ext_int(dr["JiCheID"].ToString()); LvWang.nState = PageBase.static_ext_int(dr["nState"].ToString()); LvWang.dtBeginTime = PageBase.static_ext_date(dr["dtBeginTime"].ToString()); LvWang.dtEndTime = PageBase.static_ext_date(dr["dtEndTime"].ToString()); LvWang.strFileName = dr["strFileName"].ToString(); } return(LvWang); }
/// <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); }