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