public static int GetRouterCount(RouterCondition rc)
{
DataSet ds = new DataSet();
string sql = string.Empty;
using (SqlConnection conn = new SqlConnection(connLocal))
{
switch (rc)
{
case RouterCondition.All:
sql = "select COUNT(*) total from dbo.RouterInformation where convert(nvarchar(10),date,127)=convert(nvarchar(10),GETDATE(),127)";
break;
case RouterCondition.Up:
sql = "select COUNT(*) total from dbo.RouterInformation where routerNetwork='Up' and convert(nvarchar(10),date,127)=convert(nvarchar(10),GETDATE(),127)";
break;
case RouterCondition.Down:
sql = "select COUNT(*) total from dbo.RouterInformation where routerNetwork='Down' and convert(nvarchar(10),date,127)=convert(nvarchar(10),GETDATE(),127)";
break;
}
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand(sql, conn);
da.SelectCommand = cmd;
conn.Open();
da.Fill(ds);
conn.Close();
}
return(Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString()));
}
public static DataSet GetRouterInformation(RouterCondition rc)
{
DataSet ds = new DataSet();
string sql = string.Empty;
using (SqlConnection conn = new SqlConnection(connLocal))
{
switch (rc)
{
case RouterCondition.All:
sql = "select * from dbo.RouterInformation where convert(nvarchar(10),date,127)=convert(nvarchar(10),GETDATE(),127) order by routerNetwork, storeNo;";
break;
case RouterCondition.Up:
sql = "select * from dbo.RouterInformation where routerNetwork='Up' and convert(nvarchar(10),date,127)=convert(nvarchar(10),GETDATE(),127) order by storeNo;";
break;
case RouterCondition.Down:
sql = "select * from dbo.RouterInformation where routerNetwork='Down' and convert(nvarchar(10),date,127)=convert(nvarchar(10),GETDATE(),127) order by storeNo;";
break;
}
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand(sql, conn);
da.SelectCommand = cmd;
conn.Open();
da.Fill(ds);
conn.Close();
}
return(ds);
}
private static ArrayList GetData(RouterCondition rc)
{
ArrayList list = new ArrayList();
DataSet ds = SqlHelper.GetRouterInformation(rc);
int count = ds.Tables[0].Rows.Count;
for (int i = 0; i < count; i++)
{
RouterInformation router = new RouterInformation();
router.StoreNo = ds.Tables[0].Rows[i]["storeNo"].ToString();
router.StoreRegion = ds.Tables[0].Rows[i]["storeRegion"].ToString();
router.StoreType = ds.Tables[0].Rows[i]["storeType"].ToString();
router.RouterNetwork = ds.Tables[0].Rows[i]["routerNetwork"].ToString();
router.RouterType = ds.Tables[0].Rows[i]["routerType"].ToString();
router.Date = ds.Tables[0].Rows[i]["date"].ToString();
list.Add(router);
}
return(list);
}
public static DataSet GetRouterInformation(RouterCondition rc)
{
DataSet ds = new DataSet();
string sql = string.Empty;
using (SqlConnection conn = new SqlConnection(connLocal))
{
switch (rc)
{
case RouterCondition.All:
sql = "select * from dbo.RouterInformation where convert(nvarchar(10),date,127)=convert(nvarchar(10),GETDATE(),127) order by routerNetwork, storeNo;";
break;
case RouterCondition.Up:
sql = "select * from dbo.RouterInformation where routerNetwork='Up' and convert(nvarchar(10),date,127)=convert(nvarchar(10),GETDATE(),127) order by storeNo;";
break;
case RouterCondition.Down:
sql = "select * from dbo.RouterInformation where routerNetwork='Down' and convert(nvarchar(10),date,127)=convert(nvarchar(10),GETDATE(),127) order by storeNo;";
break;
}
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand(sql, conn);
da.SelectCommand = cmd;
conn.Open();
da.Fill(ds);
conn.Close();
}
return ds;
}
public static int GetRouterCount(RouterCondition rc)
{
DataSet ds = new DataSet();
string sql = string.Empty;
using (SqlConnection conn = new SqlConnection(connLocal))
{
switch (rc)
{
case RouterCondition.All:
sql = "select COUNT(*) total from dbo.RouterInformation where convert(nvarchar(10),date,127)=convert(nvarchar(10),GETDATE(),127)";
break;
case RouterCondition.Up:
sql = "select COUNT(*) total from dbo.RouterInformation where routerNetwork='Up' and convert(nvarchar(10),date,127)=convert(nvarchar(10),GETDATE(),127)";
break;
case RouterCondition.Down:
sql = "select COUNT(*) total from dbo.RouterInformation where routerNetwork='Down' and convert(nvarchar(10),date,127)=convert(nvarchar(10),GETDATE(),127)";
break;
}
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand(sql, conn);
da.SelectCommand = cmd;
conn.Open();
da.Fill(ds);
conn.Close();
}
return Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
}
private static ArrayList GetData(RouterCondition rc)
{
ArrayList list = new ArrayList();
DataSet ds = SqlHelper.GetRouterInformation(rc);
int count = ds.Tables[0].Rows.Count;
for (int i = 0; i < count; i++)
{
RouterInformation router = new RouterInformation();
router.StoreNo = ds.Tables[0].Rows[i]["storeNo"].ToString();
router.StoreRegion = ds.Tables[0].Rows[i]["storeRegion"].ToString();
router.StoreType = ds.Tables[0].Rows[i]["storeType"].ToString();
router.RouterNetwork = ds.Tables[0].Rows[i]["routerNetwork"].ToString();
router.RouterType = ds.Tables[0].Rows[i]["routerType"].ToString();
router.Date = ds.Tables[0].Rows[i]["date"].ToString();
list.Add(router);
}
return list;
}
