public T_Exception Get()
{
string cmdStr = "select * from T_Exception";
DataRow dr = SQLHelpler.ExecuteAdapter(cmdStr).Rows[0];
return(ToModel(dr));
}
public DataTable GetAll()
{
string cmdStr = "select * from T_Log order by ID desc";
//List<T_Log> models = new List<T_Log>();
//foreach (DataRow drTemp in SQLHelpler.ExecuteAdapter(cmdStr).Rows)
//{
// ToModel(models, drTemp);
//}
//return models;
return(SQLHelpler.ExecuteAdapter(cmdStr));
}
public IList <T_PingObj> GetAll()
{
string cmdStr = "select * from T_PingObj";
List <T_PingObj> models = new List <T_PingObj>();
foreach (DataRow drTemp in SQLHelpler.ExecuteAdapter(cmdStr).Rows)
{
T_PingObj modelTemp = ToModel(drTemp);
models.Add(modelTemp);
}
return(models);
}
public IList <T_PingObj> GetByMonitor()
{
string cmdStr = "select * from T_PingObj where MONITORSPEED=true or MONITORNET=true";
List <T_PingObj> models = new List <T_PingObj>();
foreach (DataRow drTemp in SQLHelpler.ExecuteAdapter(cmdStr).Rows)
{
T_PingObj modelTemp = ToModel(drTemp);
models.Add(modelTemp);
}
return(models);
}
public IList <T_MailAddress> GetAll()
{
string cmdStr = "select * from T_MailAddress";
List <T_MailAddress> models = new List <T_MailAddress>();
foreach (DataRow drTemp in SQLHelpler.ExecuteAdapter(cmdStr).Rows)
{
T_MailAddress modelTemp = new T_MailAddress();
modelTemp.ID = (int)drTemp["ID"];
modelTemp.MAILADDRESS = (string)drTemp["MAILADDRESS"];
models.Add(modelTemp);
}
return(models);
}
public T_MailConfig Get()
{
string cmdStr = "select * from T_MailConfig";
DataRow dr = SQLHelpler.ExecuteAdapter(cmdStr).Rows[0];
T_MailConfig model = new T_MailConfig();
model.ID = (int)dr["ID"];
model.ISSHOW = (bool)dr["ISSHOW"];
model.SENDMAIL = (string)dr["SENDMAIL"];
model.SENDER = (string)dr["SENDER"];
model.SENDSMTP = (string)dr["SENDSMTP"];
model.SENDPORT = (int)dr["SENDPORT"];
model.SENDUSER = (string)dr["SENDUSER"];
model.SENDPWD = (string)dr["SENDPWD"];
model.MAILTITLE = (string)dr["MAILTITLE"];
model.MAILBODY = (string)dr["MAILBODY"];
return(model);
}
