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