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