//
public static List <mg_alarm> getfsabydateNew(string dtb, string dta)
{
List <mg_alarm> allal = new List <mg_alarm>();
string SqlStr = SqlHelper.SqlConnString;
SqlConnection conn = new SqlConnection(SqlStr);
string sql1 = @"select distinct AlarmStation,
case when AlarmType = 1 then 5 when AlarmType = 2 then 4
when AlarmType = 3 then 3 when AlarmType = 4 then 1
when AlarmType = 5 then 2 when AlarmType = 6 then 6 else 0 end as AlarmType
from mg_Alarm where [AlarmStartTime]>='" + dtb + "' and [AlarmEndTime]<='" + dta + "' and AlarmType != 4 ";
string sql = @"select a.AlarmStation as AlarmStation,max(a.AlarmType)as AlarmType from ( " + sql1 + " ) a group by a.AlarmStation";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
mg_alarm alarm = new mg_alarm();
alarm.AlarmStation = dr["AlarmStation"].ToString();
alarm.AlarmType = (int)dr["AlarmType"];
allal.Add(alarm);
}
dr.Close();
conn.Close();
return(allal);
}
public static List <mg_alarm> getfsaexcel()
{
List <mg_alarm> allal = new List <mg_alarm>();
string SqlStr = SqlHelper.SqlConnString;
SqlConnection conn = new SqlConnection(SqlStr);
string sql = "";
sql = "select distinct* from mg_Alarm where CONVERT(varchar(12) , AlarmStartTime, 23 ) = CONVERT(varchar(12) , getdate(), 23 ) order by AlarmStation";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
mg_alarm alarm = new mg_alarm();
alarm.AlarmType = (int)dr["AlarmType"];
if (dr["AlarmText"] != DBNull.Value)
{
alarm.AlarmText = dr["AlarmText"].ToString();
}
alarm.AlarmStation = dr["AlarmStation"].ToString();
if (dr["AlarmStartTime"] != DBNull.Value)
{
alarm.AlarmStartTime = Convert.ToDateTime(dr["AlarmStartTime"]);
}
if (dr["AlarmEndTime"] != DBNull.Value)
{
alarm.AlarmEndTime = Convert.ToDateTime(dr["AlarmEndTime"]);
}
if (dr["StartOrderNo"] != DBNull.Value)
{
alarm.StartOrderNo = dr["StartOrderNo"].ToString();
}
if (dr["EndOrderNo"] != DBNull.Value)
{
alarm.EndOrderNo = dr["EndOrderNo"].ToString();
}
alarm.IsSolve = (int)dr["AlarmType"];
allal.Add(alarm);
}
dr.Close();
conn.Close();
return(allal);
}
public static List <mg_alarm> getfsabydate(string dtb, string dta)
{
List <mg_alarm> allal = new List <mg_alarm>();
string SqlStr = SqlHelper.SqlConnString;
SqlConnection conn = new SqlConnection(SqlStr);
string sql = "";
sql = "select distinct AlarmStation,AlarmType from mg_Alarm where [AlarmStartTime]>='" + dtb + "' and [AlarmEndTime]<='" + dta + "' and AlarmType != 4 order by AlarmStation";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
mg_alarm alarm = new mg_alarm();
alarm.AlarmStation = dr["AlarmStation"].ToString();
alarm.AlarmType = (int)dr["AlarmType"];
allal.Add(alarm);
}
dr.Close();
conn.Close();
return(allal);
}
//public static List<mg_alarm> getfsa(string dti1, string dti2, DateTime StartTime)
public static List <mg_alarm> getfsa()
{
List <mg_alarm> allal = new List <mg_alarm>();
string SqlStr = SqlHelper.SqlConnString;
SqlConnection conn = new SqlConnection(SqlStr);
string sql = "";
sql = "select distinct AlarmStation,AlarmType from mg_Alarm where IsSolve=0 and CONVERT(varchar(12) , AlarmStartTime, 23 ) = CONVERT(varchar(12) , getdate(), 23 ) and AlarmType != 4 order by AlarmStation";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
mg_alarm alarm = new mg_alarm();
alarm.AlarmStation = dr["AlarmStation"].ToString();
alarm.AlarmType = (int)dr["AlarmType"];
allal.Add(alarm);
}
dr.Close();
conn.Close();
return(allal);
}
