public formObj() { InitializeComponent(); bll = new T_PingObjBLL(); model = new T_PingObj(); bs = new BindingSource(); }
private void 除ToolStripMenuItem_Click(object sender, EventArgs e) { model = (T_PingObj)bs.Current; if (model.ID != 0) { bll.Del(model.ID); bs.RemoveCurrent(); } }
private static T_PingObj ToModel(DataRow drTemp) { T_PingObj modelTemp = new T_PingObj(); modelTemp.ID = (int)drTemp["ID"]; modelTemp.OBJNAME = (string)drTemp["OBJNAME"]; modelTemp.ADDRESS = (string)drTemp["ADDRESS"]; modelTemp.MONITORSPEED = (bool)drTemp["MONITORSPEED"]; modelTemp.MONITORNET = (bool)drTemp["MONITORNET"]; return(modelTemp); }
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 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")); }
private void dgvwResults_CellEndEdit(object sender, DataGridViewCellEventArgs e) { //MessageBox.Show(((T_PingObj)bs.Current).ToString()); model = (T_PingObj)bs.Current; if (model.ID == 0) { model.ID = bll.Add(model); } else { bll.Update(model); } //bll.Update((T_PingObj)bs.Current); }
//线程开始方法 private void ThreadPing(object ObjIn) { ListViewItem itemTemp = (ListViewItem)ObjIn; T_PingObj modelObj = (T_PingObj)itemTemp.Tag; NetState model = new NetState(); model.name = itemTemp.Text; model.ip = itemTemp.SubItems[1].Text; string targetIp = itemTemp.SubItems[1].Text; int noNetCount = 0; int slowSpeedCount = 0; int reTime = 0; bool isConvertIP = false; Ping p = new Ping(); DelegateUpdateLst updateLst = new DelegateUpdateLst(UpdateLst); while (isMon) { if (!isConvertIP) { try { targetIp = Dns.GetHostAddresses(targetIp)[0].ToString(); isConvertIP = true; } catch { reTime = -2; } } if (isConvertIP) { PingReply pr = p.Send(targetIp, 5000); if (pr.Status == IPStatus.Success) { reTime = Convert.ToInt32(pr.RoundtripTime); //下面是监控网速 if (modelObj.MONITORSPEED) { if (reTime >= SpeedReTime) { slowSpeedCount++; if (slowSpeedCount >= SpeedCount) { DelegateExecption Exce = new DelegateExecption(ExecptionHandle); model.reTime = reTime; model.state = "网速很慢"; this.Invoke(Exce, model); slowSpeedCount = 0; } } else { slowSpeedCount = 0; } } noNetCount = 0; } else { reTime = -1; //下面是监控断网 if (modelObj.MONITORNET) { noNetCount++; if (noNetCount >= NoNetCount) { DelegateExecption exceptionHandle = new DelegateExecption(ExecptionHandle); model.state = "断网"; model.reTime = -1; this.Invoke(exceptionHandle, model); noNetCount = 0; //这里发送邮件 } } } } lstvResults.Invoke(updateLst, itemTemp, reTime); Thread.Sleep(1000); } }
public int Update(T_PingObj modelIn) { return(new T_PingObjDAL().Update(modelIn)); }
public int Add(T_PingObj modelIn) { return(new T_PingObjDAL().Add(modelIn)); }