public DataTable NW_Dhcp_Ip_GetbyCPEStatic() { string procname = "NW_Dhcp_Ip_GetbyCPEStatic"; DbAccess db = new DbAccess(); db.CreateNewSqlCommand(); return db.ExecuteDataTable(procname); }
public DataTable NW_Teamview_Getlist() { string procname = "NW_Teamview_Getlist"; DbAccess db = new DbAccess(); db.CreateNewSqlCommand(); return db.ExecuteDataTable(procname); }
public DataTable NW_Trafic_Getlike() { string procname = "NW_Trafic_Getlike"; DbAccess db = new DbAccess(); db.CreateNewSqlCommand(); db.AddParameter("@MacAddress", MacAddress); db.AddParameter("@Month", Month); db.AddParameter("@Year", Year); return db.ExecuteDataTable(procname); }
public DataTable NW_Trafic_GetByDay() { string procname = "NW_Trafic_GetByDay"; DbAccess db = new DbAccess(); if (MacAddress == null) { procname = "NW_Trafic_GetByDay"; } else { procname = "NW_Trafic_GetByDayMac"; } db.CreateNewSqlCommand(); if (MacAddress != null) { db.AddParameter("@MacAddress", MacAddress); } db.AddParameter("@Day", Day); db.AddParameter("@Month", Month); db.AddParameter("@Year", Year); return db.ExecuteDataTable(procname); }
public DataTable NW_Dhcp_Ip_GetIPbyPool() { string procname = "NW_Dhcp_Ip_GetIPbyPool"; DbAccess db = new DbAccess(); db.CreateNewSqlCommand(); db.AddParameter("@PoolIp", PoolIp); return db.ExecuteDataTable(procname); }