/// <summary> /// 更新和写入服务启动信息 /// </summary> /// <param name="server"></param> public void ExistsServerStartState(List <CENTER_STARTSTATE> list, CENTER_SERVER server) { if (server.RunState == "start") { CENTER_STARTSTATE startstate = new CENTER_STARTSTATE(); startstate.DTime = server.DTime; startstate.ProjectName = server.ProjectName; startstate.PublicIP = server.PublicIP; startstate.RunTime = server.RunTime; list.Add(startstate); //写入 bool b = PublicBD.db.AddCENTER_STARTSTATE(startstate); } else { var ser = from s in list where s.ProjectName == server.ProjectName && s.PublicIP == server.PublicIP && s.DTime == server.SrartTime select s; lock (list) { if (ser.Count() > 0) { ser.First().RunTime = server.RunTime; //更新 bool b = PublicBD.db.UdpCENTER_STARTSTATE(ser.First(), " where ProjectName='" + server.ProjectName + "' and PublicIP='" + server.PublicIP + "' and CONVERT(varchar(100), DTime, 120) like '%" + server.SrartTime.ToString("yyyy-MM-dd HH:mm:ss") + "%'"); } } } }
/// <summary> /// 更新服务启动信息 /// </summary> /// <param name="model">实体</param> /// <param name="Where">条件</param> /// <returns></returns> public bool UdpCENTER_STARTSTATE(CENTER_STARTSTATE model, string Where) { return(dt.Update <CENTER_STARTSTATE>("CENTER_STARTSTATE", model, Where)); }
/// <summary> /// 添加服务启动信息 /// </summary> /// <param name="model">实体</param> /// <returns></returns> public bool AddCENTER_STARTSTATE(CENTER_STARTSTATE model) { return(dt.Insert <CENTER_STARTSTATE>("CENTER_STARTSTATE", model)); }