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