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; }