public int DelAny(string[] ids) { string whereStr = string.Join(",", ids); string cmdStr = "delete from T_Log where ID in (" + whereStr + ")"; return(SQLHelpler.ExecuteNonQuery(cmdStr)); }
public int Del(int id) { string cmdStr = "delete from T_PingObj where ID=@ID"; OleDbParameter parm = new OleDbParameter("ID", id); return(SQLHelpler.ExecuteNonQuery(cmdStr, parm)); }
public T_Exception Get() { string cmdStr = "select * from T_Exception"; DataRow dr = SQLHelpler.ExecuteAdapter(cmdStr).Rows[0]; return(ToModel(dr)); }
public int Add(T_MailAddress modelIn) { string cmdStr = "insert into T_MailAddress(MAILADDRESS) values(@MAILADDRESS)"; OleDbParameter parm = new OleDbParameter("MAILADDRESS", modelIn.MAILADDRESS); SQLHelpler.ExecuteNonQuery(cmdStr, parm); return((int)SQLHelpler.ExecuteSclary("select max(ID) from T_MailAddress")); }
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 int Add(T_Log modelIn) { string cmdStr = "insert into T_Log(LOGTIME,OBJNAME,ADDRESS,STATE,RETIME) values(@LOGTIME,@OBJNAME,@ADDRESS,@STATE,@RETIME)"; OleDbParameter[] parms = { new OleDbParameter("LOGTIME", modelIn.LOGTIME.ToString()), new OleDbParameter("OBJNAME", modelIn.OBJNAME), new OleDbParameter("ADDRESS", modelIn.ADDRESS), new OleDbParameter("STATE", modelIn.STATE), new OleDbParameter("RETIME", modelIn.RETIME) }; return(SQLHelpler.ExecuteNonQuery(cmdStr, parms)); }
public int Update(T_PingObj modelIn) { string cmdStr = "update T_PingObj set OBJNAME=@OBJNAME,ADDRESS=@ADDRESS,MONITORSPEED=@MONITORSPEED,MONITORNET=@MONITORNET where ID=@ID"; OleDbParameter[] parms = { new OleDbParameter("OBJNAME", modelIn.OBJNAME == null?"":modelIn.OBJNAME), new OleDbParameter("ADDRESS", modelIn.ADDRESS == null?"":modelIn.ADDRESS), new OleDbParameter("MONITORSPEED", modelIn.MONITORSPEED), new OleDbParameter("MONITORNET", modelIn.MONITORNET), new OleDbParameter("ID", modelIn.ID) }; return(SQLHelpler.ExecuteNonQuery(cmdStr, parms)); }
public int Add(T_PingObj modelIn) { string cmdStr = "insert into T_PingObj(OBJNAME,ADDRESS,MONITORSPEED,MONITORNET) values(@OBJNAME,@ADDRESS,@MONITORSPEED,@MONITORNET)"; OleDbParameter[] parms = { new OleDbParameter("OBJNAME", modelIn.OBJNAME == null?"":modelIn.OBJNAME), new OleDbParameter("ADDRESS", modelIn.ADDRESS == null?"":modelIn.ADDRESS), new OleDbParameter("MONITORSPEED", modelIn.MONITORSPEED), new OleDbParameter("MONITORNET", modelIn.MONITORNET) }; SQLHelpler.ExecuteNonQuery(cmdStr, parms); return((int)SQLHelpler.ExecuteSclary("select max(ID) from T_PingObj")); }
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 int Update(T_Exception modelIn) { string cmdStr = "update T_Exception set ISMAIL=@ISMAIL,ISLOG=@ISLOG,ISREMIND=@ISREMIND,TIMESPAN=@TIMESPAN,SPEEDRETIME=@SPEEDRETIME,SPEEDCOUNT=@SPEEDCOUNT,NONETCOUNT=@NONETCOUNT where ID=@ID"; OleDbParameter[] parms = { new OleDbParameter("ISMAIL", modelIn.ISMAIL), new OleDbParameter("ISLOG", modelIn.ISLOG), new OleDbParameter("ISREMIND", modelIn.ISREMIND), new OleDbParameter("TIMESPAN", modelIn.TIMESPAN), new OleDbParameter("SPEEDRETIME", modelIn.SPEEDRETIME), new OleDbParameter("SPEEDCOUNT", modelIn.SPEEDCOUNT), new OleDbParameter("NONETCOUNT", modelIn.NONETCOUNT), new OleDbParameter("ID", modelIn.ID) }; return(SQLHelpler.ExecuteNonQuery(cmdStr, parms)); }
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); }
public int Update(T_MailConfig modelIn) { string cmdStr = "update T_MailConfig set ISSHOW=@ISSHOW,SENDMAIL=@SENDMAIL,SENDER=@SENDER,SENDSMTP=@SENDSMTP,SENDPORT=@SENDPORT,SENDUSER=@SENDUSER,SENDPWD=@SENDPWD,MAILTITLE=@MAILTITLE,MAILBODY=@MAILBODY where ID=@ID"; //string cmdStr = string.Format("update T_MailConfig set SENDMAIL='{0}',SENDER='{1}',SENDSMTP='{2}',SENDPORT={3},SENDUSER='******',SENDPWD='{5}',MAILTITLE='{6}',MAILBODY='{7}' where ID={8}", modelIn.SENDMAIL, modelIn.SENDER, modelIn.SENDSMTP, modelIn.SENDPORT, modelIn.SENDUSER, modelIn.SENDPWD, modelIn.MAILTITLE, modelIn.MAILBODY, modelIn.ID); OleDbParameter[] parms = { new OleDbParameter("ISSHOW", modelIn.ISSHOW), new OleDbParameter("SENDMAIL", modelIn.SENDMAIL), new OleDbParameter("SENDER", modelIn.SENDER), new OleDbParameter("SENDSMTP", modelIn.SENDSMTP), new OleDbParameter("SENDPORT", modelIn.SENDPORT), new OleDbParameter("SENDUSER", modelIn.SENDUSER), new OleDbParameter("SENDPWD", modelIn.SENDPWD), new OleDbParameter("MAILTITLE", modelIn.MAILTITLE), new OleDbParameter("MAILBODY", modelIn.MAILBODY), new OleDbParameter("ID", modelIn.ID) }; return(SQLHelpler.ExecuteNonQuery(cmdStr, parms)); }