public FaultAlarmInfo [] SelectAlarmInfoByAlarmCode(IList <int> AlarmCodes) { IList <FaultAlarmInfo> faultAlarmInfos = new List <FaultAlarmInfo>(); if (AlarmCodes.Count > 0) { string AlarmCodeStr = "('"; foreach (var a in AlarmCodes) { AlarmCodeStr += a.ToString() + "','"; } AlarmCodeStr = AlarmCodeStr.Remove(AlarmCodeStr.LastIndexOf("','"), 2); AlarmCodeStr += ")"; var ra = TransactionScopeManager[Global.THOK_WCS_DB_NAME].NewRelationAccesser(); string sql = string.Format(@"select * from wcs_alarm_info where alarm_code in {0}", AlarmCodeStr); var set = ra.DoQuery(sql); for (int i = 0; i < set.Tables[0].Rows.Count; i++) { FaultAlarmInfo FaultAlarmInfo = new FaultAlarmInfo(); FaultAlarmInfo.FaultCode = set.Tables[0].Rows[i]["alarm_code"].ToString(); FaultAlarmInfo.Description = set.Tables[0].Rows[i]["description"].ToString(); faultAlarmInfos.Add(FaultAlarmInfo); } } return(faultAlarmInfos.ToArray()); }
public FaultAlarmInfo [] SelectAlarmInfoByAlarmCode(IList<int> AlarmCodes) { IList<FaultAlarmInfo> faultAlarmInfos = new List<FaultAlarmInfo>(); if (AlarmCodes.Count>0) { string AlarmCodeStr = "('"; foreach (var a in AlarmCodes) { AlarmCodeStr += a.ToString() + "','"; } AlarmCodeStr = AlarmCodeStr.Remove(AlarmCodeStr.LastIndexOf("','"), 2); AlarmCodeStr += ")"; var ra = TransactionScopeManager[Global.THOK_WCS_DB_NAME].NewRelationAccesser(); string sql = string.Format(@"select * from wcs_alarm_info where alarm_code in {0}", AlarmCodeStr); var set = ra.DoQuery(sql); for (int i = 0; i < set.Tables[0].Rows.Count; i++) { FaultAlarmInfo FaultAlarmInfo = new FaultAlarmInfo(); FaultAlarmInfo.FaultCode = set.Tables[0].Rows[i]["alarm_code"].ToString(); FaultAlarmInfo.Description = set.Tables[0].Rows[i]["description"].ToString(); faultAlarmInfos.Add(FaultAlarmInfo); } } return faultAlarmInfos.ToArray(); }