public string GetNewCode()
{
string procname = "NW_Node_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
DataTable dt = db.ExecuteDataTable(procname);
if (dt.Rows.Count > 0)
{
string _strCode = dt.Rows[dt.Rows.Count - 1][0].ToString();
_strCode = _strCode.Substring(2, _strCode.Length - 2);
int next_id = int.Parse(_strCode) + 1;
switch (next_id.ToString().Length)
{
case 1:
return "N00000" + next_id.ToString();
case 2:
return "N0000" + next_id.ToString();
case 3:
return "N000" + next_id.ToString();
case 4:
return "N00" + next_id.ToString();
case 5:
return "N0" + next_id.ToString();
case 6:
return "N" + next_id.ToString();
}
}
return "N000001";
}
public DataTable NW_InterfaceControllerWarning_GetList()
{
string procname = "NW_InterfaceControllerWarning_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return db.ExecuteDataTable(procname);
}
public DataTable NW_Device_Status_GetList()
{
string procname = "NW_Device_Status_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return db.ExecuteDataTable(procname);
}
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_Device_Status_GetByInterface()
{
string procname = "NW_Device_Status_GetByInterface";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@Interface", Interface);
return db.ExecuteDataTable(procname);
}
public DataTable NW_InterfaceControllerWarning_GetList()
{
string procname = "NW_InterfaceControllerWarning_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(procname));
}
public DataTable NW_Dhcp_Ip_GetbyPoolModem()
{
string procname = "NW_Dhcp_Ip_GetbyPoolModem";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(procname));
}
public DataTable NW_CurrentTrafic_GetAll()
{
string procname = "NW_CurrentTrafic_GetAll";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(procname));
}
public DataTable NW_InterfaceGauge_Getlist()
{
string procname = "NW_InterfaceGauge_Getlist";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(procname));
}
public DataTable NW_Device_GetStatic()
{
string procname = "NW_Device_GetStatic";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(procname));
}
public DataTable NW_Dhcp_Customer_Getlist()
{
string procname = "NW_Dhcp_Customer_Getlist";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return(db.ExecuteDataTable(procname));
}
public DataTable NW_OpticalSW_Get()
{
string procname = "NW_OpticalSW_Get";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@ID", ID);
return(db.ExecuteDataTable(procname));
}
public DataTable NW_SignalLog_5Day_GetByMacLike()
{
string procname = "NW_SignalLog_5Day_GetByMacLike";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@MacAddress", MacAddress);
return(db.ExecuteDataTable(procname));
}
public DataTable NW_Device_Status_GetByInterface()
{
string procname = "NW_Device_Status_GetByInterface";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@Interface", Interface);
return(db.ExecuteDataTable(procname));
}
public DataTable NW_Dhcp_Customer_GetbyMacaddress()
{
string procname = "NW_Dhcp_Customer_GetbyMacaddress";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@MacAddress", MacAddress);
return(db.ExecuteDataTable(procname));
}
public DataTable NW_Device_GetByNodeCode()
{
string procname = "NW_Device_GetByNodeCode";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@NodeCode", NodeCode);
return(db.ExecuteDataTable(procname));
}
public DataTable NW_Device_GetByMac()
{
string procname = "NW_Device_GetByMac";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@MacAddress", MacAddress);
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));
}
public DataTable NW_SignalLog_5Day_GetSNRLow()
{
string procname = "NW_SignalLog_5Day_GetSNRLow";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@Day", Day);
db.AddParameter("@Minute", Minute);
return(db.ExecuteDataTable(procname));
}
public DataTable NW_Trafic_Get()
{
string procname = "NW_Trafic_Get";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@MacAddress", MacAddress);
db.AddParameter("@Month", Month);
db.AddParameter("@Year", Year);
return(db.ExecuteDataTable(procname));
}
public string GetNewCode()
{
string procname = "NW_Node_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
DataTable dt = db.ExecuteDataTable(procname);
if (dt.Rows.Count > 0)
{
string _strCode = dt.Rows[dt.Rows.Count - 1][0].ToString();
_strCode = _strCode.Substring(2, _strCode.Length - 2);
int next_id = int.Parse(_strCode) + 1;
switch (next_id.ToString().Length)
{
case 1:
return("N00000" + next_id.ToString());
case 2:
return("N0000" + next_id.ToString());
case 3:
return("N000" + next_id.ToString());
case 4:
return("N00" + next_id.ToString());
case 5:
return("N0" + next_id.ToString());
case 6:
return("N" + next_id.ToString());
}
}
return("N000001");
}
public DataTable NW_OpticalSW_Get()
{
string procname = "NW_OpticalSW_Get";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@ID", ID);
return db.ExecuteDataTable(procname);
}
public DataTable NW_Dhcp_Customer_GetbyMacaddress()
{
string procname = "NW_Dhcp_Customer_GetbyMacaddress";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@MacAddress", MacAddress);
return db.ExecuteDataTable(procname);
}
public DataTable NW_Dhcp_Customer_GetbyPoolPublic()
{
string procname = "NW_Dhcp_Customer_GetbyPoolPublic";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@PoolIp", PoolIp);
return db.ExecuteDataTable(procname);
}
public DataTable NW_Dhcp_Customer_Getlist()
{
string procname = "NW_Dhcp_Customer_Getlist";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return db.ExecuteDataTable(procname);
}
public DataTable NW_Trafic_Get()
{
string procname = "NW_Trafic_Get";
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_CurrentTrafic_GetAll()
{
string procname = "NW_CurrentTrafic_GetAll";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return db.ExecuteDataTable(procname);
}
public DataTable NW_Node_Get()
{
string procname = "NW_Node_Get";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@NodeCode", NodeCode);
return db.ExecuteDataTable(procname);
}
public DataTable NW_SignalLog_5Day_GetSNRLow()
{
string procname = "NW_SignalLog_5Day_GetSNRLow";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@Day", Day);
db.AddParameter("@Minute", Minute);
return db.ExecuteDataTable(procname);
}
public DataTable NW_SignalLog_GetByMac()
{
string procname = "NW_SignalLog_GetByMac";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@MacAddress", MacAddress);
return db.ExecuteDataTable(procname);
}
public DataTable NW_InterfaceGauge_Getlist()
{
string procname = "NW_InterfaceGauge_Getlist";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return db.ExecuteDataTable(procname);
}
