/// <summary> /// 更新一条数据,根据ID /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool Update(Model.SiteMonitoring model) { string strSql = "update SiteMonitoring set StationOName=@StationOName, SatelliteType=@SatelliteType, Numbering=@Numbering, Track=@Track, Quantity=@Quantity, Angle=@Angle, Time=@Time, Ratio=@Ratio, StorageEable=@StorageEable, DesignCapacity=@DesignCapacity, UsedstorageSpace=@UsedstorageSpace, AvailablestorageSpace=@AvailablestorageSpace, ReceiverTemperature=@ReceiverTemperature, ReceiverVoltage=@ReceiverVoltage, ReceiverElectricity=@ReceiverElectricity, ReceiverCPU=@ReceiverCPU, WeatherTemperature=@WeatherTemperature, WeatherVoltage=@WeatherVoltage, WeatherElectricity=@WeatherElectricity, WeatherCPU=@WeatherCPU, UPSTemperature=@UPSTemperature, UPSVoltage=@UPSVoltage, UPSElectricity=@UPSElectricity, UPSCPU=@UPSCPU where ID = " + model.ID.ToString(); SqlParameter StationOName = new SqlParameter("StationOName", SqlDbType.NVarChar); StationOName.Value = model.StationOName; SqlParameter SatelliteType = new SqlParameter("SatelliteType", SqlDbType.NVarChar); SatelliteType.Value = model.SatelliteType; SqlParameter Numbering = new SqlParameter("Numbering", SqlDbType.NVarChar); Numbering.Value = model.Numbering; SqlParameter Track = new SqlParameter("Track", SqlDbType.NVarChar); Track.Value = model.Track; SqlParameter Quantity = new SqlParameter("Quantity", SqlDbType.NVarChar); Quantity.Value = model.Quantity; SqlParameter Angle = new SqlParameter("Angle", SqlDbType.NVarChar); Angle.Value = model.Angle; SqlParameter Time = new SqlParameter("Time", SqlDbType.DateTime); Time.Value = model.Time; SqlParameter Ratio = new SqlParameter("Ratio", SqlDbType.NVarChar); Ratio.Value = model.Ratio; SqlParameter StorageEable = new SqlParameter("StorageEable", SqlDbType.Int); StorageEable.Value = model.StorageEable; SqlParameter DesignCapacity = new SqlParameter("DesignCapacity", SqlDbType.NVarChar); DesignCapacity.Value = model.DesignCapacity; SqlParameter UsedstorageSpace = new SqlParameter("UsedstorageSpace", SqlDbType.NVarChar); UsedstorageSpace.Value = model.UsedstorageSpace; SqlParameter AvailablestorageSpace = new SqlParameter("AvailablestorageSpace", SqlDbType.NVarChar); AvailablestorageSpace.Value = model.AvailablestorageSpace; SqlParameter ReceiverTemperature = new SqlParameter("ReceiverTemperature", SqlDbType.NVarChar); ReceiverTemperature.Value = model.ReceiverTemperature; SqlParameter ReceiverVoltage = new SqlParameter("ReceiverVoltage", SqlDbType.NVarChar); ReceiverVoltage.Value = model.ReceiverVoltage; SqlParameter ReceiverElectricity = new SqlParameter("ReceiverElectricity", SqlDbType.NVarChar); ReceiverElectricity.Value = model.ReceiverElectricity; SqlParameter ReceiverCPU = new SqlParameter("ReceiverCPU", SqlDbType.NVarChar); ReceiverCPU.Value = model.ReceiverCPU; SqlParameter WeatherTemperature = new SqlParameter("WeatherTemperature", SqlDbType.NVarChar); WeatherTemperature.Value = model.WeatherTemperature; SqlParameter WeatherVoltage = new SqlParameter("WeatherVoltage", SqlDbType.NVarChar); WeatherVoltage.Value = model.WeatherVoltage; SqlParameter WeatherElectricity = new SqlParameter("WeatherElectricity", SqlDbType.NVarChar); WeatherElectricity.Value = model.WeatherElectricity; SqlParameter WeatherCPU = new SqlParameter("WeatherCPU", SqlDbType.NVarChar); WeatherCPU.Value = model.WeatherCPU; SqlParameter UPSTemperature = new SqlParameter("UPSTemperature", SqlDbType.NVarChar); UPSTemperature.Value = model.UPSTemperature; SqlParameter UPSVoltage = new SqlParameter("UPSVoltage", SqlDbType.NVarChar); UPSVoltage.Value = model.UPSVoltage; SqlParameter UPSElectricity = new SqlParameter("UPSElectricity", SqlDbType.NVarChar); UPSElectricity.Value = model.UPSElectricity; SqlParameter UPSCPU = new SqlParameter("UPSCPU", SqlDbType.NVarChar); UPSCPU.Value = model.UPSCPU; return(DBHelperSQL.GetNums(strSql, new SqlParameter[] { StationOName, SatelliteType, Numbering, Track, Quantity, Angle, Time, Ratio, StorageEable, DesignCapacity, UsedstorageSpace, AvailablestorageSpace, ReceiverTemperature, ReceiverVoltage, ReceiverElectricity, ReceiverCPU, WeatherTemperature, WeatherVoltage, WeatherElectricity, WeatherCPU, UPSTemperature, UPSVoltage, UPSElectricity, UPSCPU }, connectionString) == 1 ? true : false); }
private void AddStas() { Model.CORSStationInfo cors = new Model.CORSStationInfo(); cors.StationName = Request.Form["StationName"].ToString(); cors.StationOName = Request.Form["StationName"].ToString(); cors.TransferType = Request.Form["TransType"].ToString(); cors.IP = Request.Form["Ip"].ToString(); cors.Port = Request.Form["Port"].ToString(); cors.Lat = double.Parse(Request.Form["Lat"].ToString()); cors.Lon = double.Parse(Request.Form["Lon"].ToString()); cors.H = double.Parse(Request.Form["H"].ToString()); cors.Remark = Request.Form["Remark"].ToString(); cors.IsOK = 0; if (DAL.CORSStationInfo.Exists(cors.StationName) || DAL.CORSStationInfo.GetModelByOName(cors.StationOName) != null) { Response.Clear(); Response.Write("0"); Response.End(); } else { Model.EquipmentInfo eq = new Model.EquipmentInfo(); eq.StationOName = cors.StationOName; eq.StationName = cors.StationName; eq.IP = cors.IP; eq.Port = cors.Port; Model.SiteMonitoring ms = new Model.SiteMonitoring(); ms.StationOName = cors.StationOName; try { DAL.CORSStationInfo.Add(cors); Model.CORSStationInfo cos = DAL.CORSStationInfo.GetModel(cors.StationName); DAL.EquipmentInfo.Add(eq); DAL.SiteMonitoring.Add(ms); result = cos.ID.ToString(); Response.Clear(); Response.Write("1"); Response.End(); } catch (Exception) { } Model.SysLog mSysLog = new Model.SysLog(); mSysLog.LogTime = DateTime.Now; mSysLog.LogType = 0; mSysLog.UserName = Session["UserName"].ToString(); mSysLog.Remark = "管理员添加基站:" + cors.StationName + "的信息"; DAL.SysLog.Add(mSysLog); } }
/// <summary> /// 得到一个实体对象 /// </summary> /// <param name="Id"></param> /// <returns></returns> public static Model.SiteMonitoring GetModel(int ID) { string strSql = "select * from SiteMonitoring where ID = " + ID.ToString(); Model.SiteMonitoring model = new Model.SiteMonitoring(); DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString); model.ID = ID; if (ds.Tables[0].Rows.Count > 0) { model.StationOName = Convert.ToString(ds.Tables[0].Rows[0]["StationOName"]); model.SatelliteType = Convert.ToString(ds.Tables[0].Rows[0]["SatelliteType"]); model.Numbering = Convert.ToString(ds.Tables[0].Rows[0]["Numbering"]); model.Track = Convert.ToString(ds.Tables[0].Rows[0]["Track"]); model.Quantity = Convert.ToString(ds.Tables[0].Rows[0]["Quantity"]); model.Angle = Convert.ToString(ds.Tables[0].Rows[0]["Angle"]); model.Time = Convert.ToDateTime(ds.Tables[0].Rows[0]["Time"]); model.Ratio = Convert.ToString(ds.Tables[0].Rows[0]["Ratio"]); model.StorageEable = Convert.ToInt32(ds.Tables[0].Rows[0]["StorageEable"]); model.DesignCapacity = Convert.ToString(ds.Tables[0].Rows[0]["DesignCapacity"]); model.UsedstorageSpace = Convert.ToString(ds.Tables[0].Rows[0]["UsedstorageSpace"]); model.AvailablestorageSpace = Convert.ToString(ds.Tables[0].Rows[0]["AvailablestorageSpace"]); model.ReceiverTemperature = Convert.ToString(ds.Tables[0].Rows[0]["ReceiverTemperature"]); model.ReceiverVoltage = Convert.ToString(ds.Tables[0].Rows[0]["ReceiverVoltage"]); model.ReceiverElectricity = Convert.ToString(ds.Tables[0].Rows[0]["ReceiverElectricity"]); model.ReceiverCPU = Convert.ToString(ds.Tables[0].Rows[0]["ReceiverCPU"]); model.WeatherTemperature = Convert.ToString(ds.Tables[0].Rows[0]["WeatherTemperature"]); model.WeatherVoltage = Convert.ToString(ds.Tables[0].Rows[0]["WeatherVoltage"]); model.WeatherElectricity = Convert.ToString(ds.Tables[0].Rows[0]["WeatherElectricity"]); model.WeatherCPU = Convert.ToString(ds.Tables[0].Rows[0]["WeatherCPU"]); model.UPSTemperature = Convert.ToString(ds.Tables[0].Rows[0]["UPSTemperature"]); model.UPSVoltage = Convert.ToString(ds.Tables[0].Rows[0]["UPSVoltage"]); model.UPSElectricity = Convert.ToString(ds.Tables[0].Rows[0]["UPSElectricity"]); model.UPSCPU = Convert.ToString(ds.Tables[0].Rows[0]["UPSCPU"]); return(model); } else { return(null); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserName"] == null) { Response.Write("<script>alert(\"请登录\");location.href = location.origin+\"/Index.aspx\";</script>"); Response.End(); } if (Session["UserType"] == null || (Convert.ToInt32(Session["UserType"]) != 2 && Convert.ToInt32(Session["UserType"]) != 3)) { Response.Write("<script>alert(\"登录账户类型有误\");location.href = location.origin+\"/Index.aspx\";</script>"); Response.End(); } if (!IsPostBack) { string id = null; id = Request["id"]; stationid.Value = id.ToString(); Model.CORSStationInfo mc = DAL.CORSStationInfo.GetModel(int.Parse(id.ToString())); StationName.Value = mc.StationName; StationOName.Value = mc.StationOName; if (mc.IsOK == 1) { IsOK.Value = "正常"; } else { IsOK.Value = "异常"; } TransferType.Value = mc.TransferType; IP.Value = mc.IP; Port.Value = mc.Port; Lat.Value = mc.Lat.ToString(); Lon.Value = mc.Lon.ToString(); H.Value = mc.H.ToString(); StationType.Value = mc.StationType; CaseNumber.Value = mc.CaseNumber; if (mc.BuildTime != null) { BuildTime.Value = mc.BuildTime.ToString(); } AffiliatedNetwork.Value = mc.AffiliatedNetwork; PiersType.Value = mc.PiersType; RelyUnits.Value = mc.RelyUnits; Address.Value = mc.Address; ThicknessOfLayer.Value = mc.ThicknessOfLayer; TrafficCondition.Value = mc.TrafficCondition; SitePerson.Value = mc.SitePerson; Builder.Value = mc.Builder; SoilType.Value = mc.SoilType; PermafrostDepth.Value = mc.PermafrostDepth; ThawDepth.Value = mc.ThawDepth; GroundwaterDepth.Value = mc.GroundwaterDepth; BelongsMap.Value = mc.BelongsMap; GeologicalStructure.Value = mc.GeologicalStructure; MaintenanceUnit.Value = mc.MaintenanceUnit; ContactPerson.Value = mc.ContactPerson; ContactTel.Value = mc.ContactTel; StationPlan.Value = mc.StationPlan; GravityPier.Value = mc.GravityPier; LevelSign.Value = mc.LevelSign; LightningReport.Value = mc.LightningReport; StationPhoto.Value = mc.StationPhoto; if (mc.StationPlan == "" || mc.StationPlan == null) { viewPlan.Disabled = true; } if (mc.RingView == "" || mc.RingView == null) { viewRingView.Disabled = true; } if (mc.GravityPier == "" || mc.GravityPier == null) { viewGravityPier.Disabled = true; } if (mc.LevelSign == "" || mc.LevelSign == null) { viewLevelSign.Disabled = true; } if (mc.LightningReport == "" || mc.LightningReport == null) { viewLightningReport.Disabled = true; } if (mc.StationPhoto == "" || mc.StationPhoto == null) { viewStationPhoto.Disabled = true; } RingView.Value = mc.RingView; EnvironmentalDescription.Value = mc.EnvironmentalDescription; SiteConditions.Value = mc.SiteConditions; } else { if (Request["upload"] == "plan") { string filename = Request.Files["FilePlan"].FileName; string stationname = Request.Form["StationName"].ToString().Trim(); string[] filenames = filename.Split('.'); Request.Files["FilePlan"].SaveAs(Server.MapPath("~/upload/PLAN/") + stationname + "." + filenames[filenames.Length - 1]); Model.CORSStationInfo ms = DAL.CORSStationInfo.GetModel(stationname); ms.StationPlan = "/upload/PLAN/" + stationname + "." + filenames[filenames.Length - 1]; DAL.CORSStationInfo.Update(ms); Model.EquipReviceRecord MERR = new Model.EquipReviceRecord(); MERR.ReviceID = Request.Form["stationid"].ToString().Trim(); MERR.Contents = Request.Form["StationName"].ToString().Trim() + "信息发生了修改:平面图;"; MERR.RevicePerson = Session["UserName"].ToString(); MERR.ReviceTime = DateTime.Now; MERR.Information = "基站信息"; DAL.EquipReviceRecord.Add(MERR); Response.Clear(); Response.Write("1"); Response.End(); } if (Request["upload"] == "ringview") { string filename = Request.Files["FileRingView"].FileName; string stationname = Request.Form["StationName"].ToString().Trim(); string[] filenames = filename.Split('.'); Request.Files["FileRingView"].SaveAs(Server.MapPath("~/upload/RINGVIEW/") + stationname + "." + filenames[filenames.Length - 1]); Model.CORSStationInfo ms = DAL.CORSStationInfo.GetModel(stationname); ms.RingView = "/upload/RINGVIEW/" + stationname + "." + filenames[filenames.Length - 1]; DAL.CORSStationInfo.Update(ms); Model.EquipReviceRecord MERR = new Model.EquipReviceRecord(); MERR.ReviceID = Request.Form["stationid"].ToString().Trim(); MERR.Contents = Request.Form["StationName"].ToString().Trim() + "信息发生了修改:环视图;"; MERR.RevicePerson = Session["UserName"].ToString(); MERR.ReviceTime = DateTime.Now; MERR.Information = "基站信息"; DAL.EquipReviceRecord.Add(MERR); Response.Clear(); Response.Write("1"); Response.End(); } if (Request["upload"] == "GravityPier") { string filename = Request.Files["FileGravityPier"].FileName; string stationname = Request.Form["StationName"].ToString().Trim(); string[] filenames = filename.Split('.'); Request.Files["FileGravityPier"].SaveAs(Server.MapPath("~/upload/GravityPier/") + stationname + "." + filenames[filenames.Length - 1]); Model.CORSStationInfo ms = DAL.CORSStationInfo.GetModel(stationname); ms.GravityPier = "/upload/GravityPier/" + stationname + "." + filenames[filenames.Length - 1]; DAL.CORSStationInfo.Update(ms); Model.EquipReviceRecord MERR = new Model.EquipReviceRecord(); MERR.ReviceID = Request.Form["stationid"].ToString().Trim(); MERR.Contents = Request.Form["StationName"].ToString().Trim() + "信息发生了修改:重力墩;"; MERR.RevicePerson = Session["UserName"].ToString(); MERR.ReviceTime = DateTime.Now; MERR.Information = "基站信息"; DAL.EquipReviceRecord.Add(MERR); Response.Clear(); Response.Write("1"); Response.End(); } if (Request["upload"] == "LevelSign") { string filename = Request.Files["FileLevelSign"].FileName; string stationname = Request.Form["StationName"].ToString().Trim(); string[] filenames = filename.Split('.'); Request.Files["FileLevelSign"].SaveAs(Server.MapPath("~/upload/LevelSign/") + stationname + "." + filenames[filenames.Length - 1]); Model.CORSStationInfo ms = DAL.CORSStationInfo.GetModel(stationname); ms.LevelSign = "/upload/LevelSign/" + stationname + "." + filenames[filenames.Length - 1]; DAL.CORSStationInfo.Update(ms); Model.EquipReviceRecord MERR = new Model.EquipReviceRecord(); MERR.ReviceID = Request.Form["stationid"].ToString().Trim(); MERR.Contents = Request.Form["StationName"].ToString().Trim() + "信息发生了修改:水准标志;"; MERR.RevicePerson = Session["UserName"].ToString(); MERR.ReviceTime = DateTime.Now; MERR.Information = "基站信息"; DAL.EquipReviceRecord.Add(MERR); Response.Clear(); Response.Write("1"); Response.End(); } if (Request["upload"] == "LightningReport") { string filename = Request.Files["FileLightningReport"].FileName; string stationname = Request.Form["StationName"].ToString().Trim(); string[] filenames = filename.Split('.'); Request.Files["FileLightningReport"].SaveAs(Server.MapPath("~/upload/LightningReport/") + stationname + "." + filenames[filenames.Length - 1]); Model.CORSStationInfo ms = DAL.CORSStationInfo.GetModel(stationname); ms.LightningReport = "/upload/LightningReport/" + stationname + "." + filenames[filenames.Length - 1]; DAL.CORSStationInfo.Update(ms); Model.EquipReviceRecord MERR = new Model.EquipReviceRecord(); MERR.ReviceID = Request.Form["stationid"].ToString().Trim(); MERR.Contents = Request.Form["StationName"].ToString().Trim() + "信息发生了修改:检测报告;"; MERR.RevicePerson = Session["UserName"].ToString(); MERR.ReviceTime = DateTime.Now; MERR.Information = "基站信息"; DAL.EquipReviceRecord.Add(MERR); Response.Clear(); Response.Write("1"); Response.End(); } if (Request["upload"] == "StationPhoto") { string filename = Request.Files["FileStationPhoto"].FileName; string stationname = Request.Form["StationName"].ToString().Trim(); string[] filenames = filename.Split('.'); Request.Files["FileStationPhoto"].SaveAs(Server.MapPath("~/upload/StationPhoto/") + stationname + "." + filenames[filenames.Length - 1]); Model.CORSStationInfo ms = DAL.CORSStationInfo.GetModel(stationname); ms.StationPhoto = "/upload/StationPhoto/" + stationname + "." + filenames[filenames.Length - 1]; DAL.CORSStationInfo.Update(ms); Model.EquipReviceRecord MERR = new Model.EquipReviceRecord(); MERR.ReviceID = Request.Form["stationid"].ToString().Trim(); MERR.Contents = Request.Form["StationName"].ToString().Trim() + "信息发生了修改:基站照片;"; MERR.RevicePerson = Session["UserName"].ToString(); MERR.ReviceTime = DateTime.Now; MERR.Information = "基站信息"; DAL.EquipReviceRecord.Add(MERR); Response.Clear(); Response.Write("1"); Response.End(); } if (Request["action"] == "save") { Model.CORSStationInfo mcors = DAL.CORSStationInfo.GetModel(int.Parse(Request.Form["stationid"].ToString().Trim())); Model.EquipmentInfo me = DAL.EquipmentInfo.GetModel(mcors.StationOName); Model.SiteMonitoring ms = DAL.SiteMonitoring.GetModel(mcors.StationOName); #region 对修改信息进行比对 Model.EquipReviceRecord MERR = new Model.EquipReviceRecord(); bool IsRevice = false; MERR.Contents = mcors.StationName + "信息发生了修改:"; if (mcors.TransferType != Request.Form["TransferType"].ToString().Trim()) { IsRevice = true; MERR.Contents += "传输类型;"; } if (mcors.IP != Request.Form["IP"].ToString().Trim()) { IsRevice = true; MERR.Contents += "IP地址;"; } if (mcors.Port != Request.Form["Port"].ToString().Trim()) { IsRevice = true; MERR.Contents += "端口;"; } if (mcors.Lat != double.Parse(Request.Form["Lat"].ToString().Trim())) { IsRevice = true; MERR.Contents += "纬度;"; } if (mcors.Lon != double.Parse(Request.Form["Lon"].ToString().Trim())) { IsRevice = true; MERR.Contents += "经度;"; } if (mcors.H != double.Parse(Request.Form["H"].ToString().Trim())) { IsRevice = true; MERR.Contents += "高程;"; } if (mcors.StationType != Request.Form["StationType"].ToString().Trim()) { IsRevice = true; MERR.Contents += "基站型号;"; } if (mcors.CaseNumber != Request.Form["CaseNumber"].ToString().Trim()) { IsRevice = true; MERR.Contents += "备案号;"; } if (mcors.BuildTime != DateTime.Parse(Request.Form["BuildTime"].ToString().Trim())) { IsRevice = true; MERR.Contents += "建站时间;"; } if (mcors.AffiliatedNetwork != Request.Form["AffiliatedNetwork"].ToString().Trim()) { IsRevice = true; MERR.Contents += "所属站网;"; } if (mcors.PiersType != Request.Form["PiersType"].ToString().Trim()) { IsRevice = true; MERR.Contents += "墩标类型;"; } if (mcors.RelyUnits != Request.Form["RelyUnits"].ToString().Trim()) { IsRevice = true; MERR.Contents += "依托单位;"; } if (mcors.Address != Request.Form["Address"].ToString().Trim()) { IsRevice = true; MERR.Contents += "所在地区;"; } if (mcors.ThicknessOfLayer != Request.Form["ThicknessOfLayer"].ToString().Trim()) { IsRevice = true; MERR.Contents += "土层厚度;"; } if (mcors.TrafficCondition != Request.Form["TrafficCondition"].ToString().Trim()) { IsRevice = true; MERR.Contents += "交通情况;"; } if (mcors.SitePerson != Request.Form["SitePerson"].ToString().Trim()) { IsRevice = true; MERR.Contents += "选点者信息;"; } if (mcors.Builder != Request.Form["Builder"].ToString().Trim()) { IsRevice = true; MERR.Contents += "建站者信息;"; } if (mcors.SoilType != Request.Form["SoilType"].ToString().Trim()) { IsRevice = true; MERR.Contents += "地类土质;"; } if (mcors.PermafrostDepth != Request.Form["PermafrostDepth"].ToString().Trim()) { IsRevice = true; MERR.Contents += "冻土深度;"; } if (mcors.ThawDepth != Request.Form["ThawDepth"].ToString().Trim()) { IsRevice = true; MERR.Contents += "解冻深度;"; } if (mcors.BelongsMap != Request.Form["BelongsMap"].ToString().Trim()) { IsRevice = true; MERR.Contents += "所在图幅;"; } if (mcors.GroundwaterDepth != Request.Form["GroundwaterDepth"].ToString().Trim()) { IsRevice = true; MERR.Contents += "地下水深度;"; } if (mcors.GeologicalStructure != Request.Form["GeologicalStructure"].ToString().Trim()) { IsRevice = true; MERR.Contents += "基础岩性和地质构造说明;"; } if (mcors.MaintenanceUnit != Request.Form["MaintenanceUnit"].ToString().Trim()) { IsRevice = true; MERR.Contents += "维护单位;"; } if (mcors.ContactPerson != Request.Form["ContactPerson"].ToString().Trim()) { IsRevice = true; MERR.Contents += "维护人;"; } if (mcors.ContactTel != Request.Form["ContactTel"].ToString().Trim()) { IsRevice = true; MERR.Contents += "联系电话;"; } if (mcors.EnvironmentalDescription != Request.Form["EnvironmentalDescription"].ToString().Trim()) { IsRevice = true; MERR.Contents += "环境说明;"; } if (mcors.SiteConditions != Request.Form["SiteConditions"].ToString().Trim()) { IsRevice = true; MERR.Contents += "站点条件信息;"; } #endregion mcors.StationName = Request.Form["StationName"].ToString().Trim(); mcors.StationOName = Request.Form["StationOName"].ToString().Trim(); if (Request.Form["IsOK"].ToString() == "正常") { mcors.IsOK = 1; } else { mcors.IsOK = 0; } mcors.TransferType = Request.Form["TransferType"].ToString().Trim(); mcors.IP = Request.Form["IP"].ToString().Trim(); mcors.Port = Request.Form["Port"].ToString().Trim(); mcors.Lat = double.Parse(Request.Form["Lat"].ToString().Trim()); mcors.Lon = double.Parse(Request.Form["Lon"].ToString().Trim()); mcors.H = double.Parse(Request.Form["H"].ToString().Trim()); mcors.StationType = Request.Form["StationType"].ToString().Trim(); mcors.CaseNumber = Request.Form["CaseNumber"].ToString().Trim(); mcors.BuildTime = DateTime.Parse(Request.Form["BuildTime"].ToString().Trim()); mcors.AffiliatedNetwork = Request.Form["AffiliatedNetwork"].ToString().Trim(); mcors.PiersType = Request.Form["PiersType"].ToString().Trim(); mcors.RelyUnits = Request.Form["RelyUnits"].ToString().Trim(); mcors.Address = Request.Form["Address"].ToString().Trim(); mcors.ThicknessOfLayer = Request.Form["ThicknessOfLayer"].ToString().Trim(); mcors.TrafficCondition = Request.Form["TrafficCondition"].ToString().Trim(); mcors.SitePerson = Request.Form["SitePerson"].ToString().Trim(); mcors.Builder = Request.Form["Builder"].ToString().Trim(); mcors.SoilType = Request.Form["SoilType"].ToString().Trim(); mcors.PermafrostDepth = Request.Form["PermafrostDepth"].ToString().Trim(); mcors.ThawDepth = Request.Form["ThawDepth"].ToString().Trim(); mcors.GroundwaterDepth = Request.Form["GroundwaterDepth"].ToString().Trim(); mcors.BelongsMap = Request.Form["BelongsMap"].ToString().Trim(); mcors.GeologicalStructure = Request.Form["GeologicalStructure"].ToString().Trim(); mcors.MaintenanceUnit = Request.Form["MaintenanceUnit"].ToString().Trim(); mcors.ContactPerson = Request.Form["ContactPerson"].ToString().Trim(); mcors.ContactTel = Request.Form["ContactTel"].ToString().Trim(); if (Request.Form["StationPlan"].ToString().Trim().Contains("PLAN")) { mcors.StationPlan = Request.Form["StationPlan"].ToString().Trim(); } if (Request.Form["RingView"].ToString().Trim().Contains("RINGVIEW")) { mcors.RingView = Request.Form["RingView"].ToString().Trim(); } if (Request.Form["GravityPier"].ToString().Trim().Contains("GravityPier")) { mcors.GravityPier = Request.Form["GravityPier"].ToString().Trim(); } if (Request.Form["LevelSign"].ToString().Trim().Contains("LevelSign")) { mcors.LevelSign = Request.Form["LevelSign"].ToString().Trim(); } if (Request.Form["LightningReport"].ToString().Trim().Contains("LightningReport")) { mcors.LightningReport = Request.Form["LightningReport"].ToString().Trim(); } if (Request.Form["StationPhoto"].ToString().Trim().Contains("StationPhoto")) { mcors.StationPhoto = Request.Form["StationPhoto"].ToString().Trim(); } mcors.SiteConditions = Request.Form["SiteConditions"].ToString().Trim(); mcors.EnvironmentalDescription = Request.Form["EnvironmentalDescription"].ToString().Trim(); bool res = DAL.CORSStationInfo.Update(mcors, 1); me.StationName = mcors.StationName; me.StationOName = mcors.StationOName; me.IP = mcors.IP; me.Port = mcors.Port; DAL.EquipmentInfo.Update(me); ms.StationOName = me.StationOName; bool r = DAL.SiteMonitoring.Update(ms); if (res) { if (IsRevice) { MERR.ReviceID = mcors.ID.ToString(); MERR.RevicePerson = Session["UserName"].ToString(); MERR.ReviceTime = DateTime.Now; MERR.Information = "基站信息"; DAL.EquipReviceRecord.Add(MERR); } } Response.Clear(); Response.Write("1"); Response.End(); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserName"] == null) { Response.Write("<script>alert(\"请登录\");location.href = location.origin+\"/forms/Index.aspx\";</script>"); Response.End(); } if (Session["UserType"] == null || (Convert.ToInt32(Session["UserType"]) != 2 && Convert.ToInt32(Session["UserType"]) != 3)) { Response.Write("<script>alert(\"登录账户类型有误\");location.href = location.origin+\"/forms/Index.aspx\";</script>"); Response.End(); } if (!IsPostBack) { string stoname = Request["StationOName"].ToString(); Model.SiteMonitoring ms = DAL.SiteMonitoring.GetModel(stoname); StationOName.Value = ms.StationOName; SatelliteType.Value = ms.SatelliteType; Numbering.Value = ms.Numbering; Track.Value = ms.Track; Quantity.Value = ms.Quantity; Angle.Value = ms.Angle; Time.Value = ms.Time.ToString(); Ratio.Value = ms.Ratio; if (ms.StorageEable == 1) { StorageEable.SelectedIndex = 0; } else { StorageEable.SelectedIndex = 1; } DesignCapacity.Value = ms.DesignCapacity; UsedstorageSpace.Value = ms.UsedstorageSpace; AvailablestorageSpace.Value = ms.AvailablestorageSpace; if (ms.AvailablestorageSpace != "" && (ms.DesignCapacity) != "") { AvailablestorageSpaceRate.Value = (double.Parse(ms.AvailablestorageSpace) / double.Parse(ms.DesignCapacity) * 100).ToString() + "%"; } ReceiverTemperature.Value = ms.ReceiverTemperature; ReceiverVoltage.Value = ms.ReceiverVoltage; ReceiverElectricity.Value = ms.ReceiverElectricity; ReceiverCPU.Value = ms.ReceiverCPU; WeatherTemperature.Value = ms.WeatherTemperature; WeatherVoltage.Value = ms.WeatherVoltage; WeatherElectricity.Value = ms.WeatherElectricity; WeatherCPU.Value = ms.WeatherCPU; UPSTemperature.Value = ms.UPSTemperature; UPSVoltage.Value = ms.UPSVoltage; UPSElectricity.Value = ms.UPSElectricity; UPSCPU.Value = ms.UPSCPU; } if (Request["action"] == "save") { Model.SiteMonitoring ms = DAL.SiteMonitoring.GetModel(Request.Form["StationOName"].ToString().Trim()); ms.Numbering = Request.Form["Numbering"].ToString(); ms.Track = Request.Form["Track"].ToString(); ms.Quantity = Request.Form["Quantity"].ToString(); ms.Angle = Request.Form["Angle"].ToString(); ms.Time = DateTime.Parse(Request.Form["Time"].ToString()); ms.Ratio = Request.Form["Ratio"].ToString(); if (Request.Form["StorageEable"].ToString() == "可用") { ms.StorageEable = 1; } else { ms.StorageEable = 1; } ms.DesignCapacity = Request.Form["DesignCapacity"].ToString(); ms.UsedstorageSpace = Request.Form["UsedstorageSpace"].ToString(); ms.AvailablestorageSpace = Request.Form["AvailablestorageSpace"].ToString(); ms.ReceiverTemperature = Request.Form["ReceiverTemperature"].ToString(); ms.ReceiverVoltage = Request.Form["ReceiverVoltage"].ToString(); ms.ReceiverElectricity = Request.Form["ReceiverElectricity"].ToString(); ms.ReceiverCPU = Request.Form["ReceiverCPU"].ToString(); ms.WeatherTemperature = Request.Form["WeatherTemperature"].ToString(); ms.WeatherVoltage = Request.Form["WeatherVoltage"].ToString(); ms.WeatherElectricity = Request.Form["WeatherElectricity"].ToString(); ms.WeatherCPU = Request.Form["WeatherCPU"].ToString(); ms.UPSTemperature = Request.Form["UPSTemperature"].ToString(); ms.UPSVoltage = Request.Form["UPSVoltage"].ToString(); ms.UPSElectricity = Request.Form["UPSElectricity"].ToString(); ms.UPSCPU = Request.Form["UPSCPU"].ToString(); bool result = DAL.SiteMonitoring.Update(ms); if (result) { Response.Clear(); Response.Write("1"); Response.End(); } else { Response.Clear(); Response.Write("0"); Response.End(); } } }