private void ShowDeviceInfo(ParkDevice device)
{
LANInfo li;
if (device.GetLANInfo(out li))
{
ShowLANInfo(li);
}
else
{
ShowLANInfo(device.LANInfo);
}
WorkmodeInfo ws;
if (device.GetWorkmode(out ws))
{
ShowWorkmodeInfo(ws);
}
List <string> carPlateNotifyIp = device.GetCarPlateNotifyControllerIP();
if (carPlateNotifyIp != null && carPlateNotifyIp.Count == 3)
{
this.txtCarPlateNotifyController.IP = carPlateNotifyIp[0];
this.txtCarPlateNotifyControllerSecond1.IP = carPlateNotifyIp[1];
this.txtCarPlateNotifyControllerSecond2.IP = carPlateNotifyIp[2];
}
}
public JsonResult GetParkDeviceParam(string deviceId)
{
try
{
ParkDevice device = ParkDeviceServices.QueryParkDeviceByRecordId(deviceId);
if (device == null)
{
throw new MyException("获取设备失败");
}
if (device.DeviceType != DeviceType.NZ_CONTROL)
{
throw new MyException("设备类型不正确");
}
ParkDeviceParam deviceParam = ParkDeviceServices.QueryParkDeviceParamByDID(deviceId);
return(Json(MyResult.Success("获取成功", deviceParam)));
}
catch (MyException ex)
{
return(Json(MyResult.Error(ex.Message)));
}
catch (Exception ex)
{
ExceptionsServices.AddExceptions(ex, "删除设备信息失败");
return(Json(MyResult.Error("删除设备信息失败")));
}
}
public JsonResult SaveEditDevice(ParkDevice model)
{
try
{
bool result = false;
if (string.IsNullOrWhiteSpace(model.DeviceID))
{
result = ParkDeviceServices.Add(model);
if (!result)
{
throw new MyException("添加失败");
}
return(Json(MyResult.Success()));
}
else
{
result = ParkDeviceServices.Update(model);
if (!result)
{
throw new MyException("修改失败");
}
return(Json(MyResult.Success()));
}
}
catch (MyException ex)
{
return(Json(MyResult.Error(ex.Message)));
}
catch (Exception ex)
{
ExceptionsServices.AddExceptions(ex, "保存设备信息失败");
return(Json(MyResult.Error("保存设备信息失败")));
}
}
public static bool Update(ParkDevice model)
{
if (model == null)
{
throw new ArgumentNullException("model");
}
IParkDevice factory = ParkDeviceFactory.GetFactory();
IParkDeviceDetection factoryDetection = ParkDeviceDetectionFactory.GetFactory();
bool result = false;
using (DbOperator dbOperator = ConnectionManager.CreateConnection())
{
try
{
dbOperator.BeginTransaction();
result = factory.Update(model, dbOperator);
if (!result)
{
throw new MyException("修改设备失败");
}
if (model.DeviceType == DeviceType.NZ_CONTROL)
{
ParkDeviceParam deviceParam = factory.QueryParkDeviceParamByDID(model.DeviceID);
if (deviceParam == null)
{
AddDefaultParkDeviceParam(model.GateID, model.DeviceID, model.DeviceNo, dbOperator);
}
else
{
factory.UpdateParam(model.DeviceID, model.DeviceNo, dbOperator);
}
}
dbOperator.CommitTransaction();
}
catch
{
dbOperator.RollbackTransaction();
throw;
}
}
if (result)
{
OperateLogServices.AddOperateLog <ParkDevice>(model, OperateType.Update);
}
return(result);
}
public static bool Add(ParkDevice model)
{
if (model == null)
{
throw new ArgumentNullException("model");
}
IParkDeviceDetection factoryDetection = ParkDeviceDetectionFactory.GetFactory();
model.DeviceID = GuidGenerator.GetGuid().ToString();
IParkDevice factory = ParkDeviceFactory.GetFactory();
bool result = false;
using (DbOperator dbOperator = ConnectionManager.CreateConnection())
{
try
{
dbOperator.BeginTransaction();
result = factory.Add(model, dbOperator);
if (!result)
{
throw new MyException("添加设备失败");
}
if (model.DeviceType == DeviceType.NZ_CONTROL)
{
int devId = 0;
if (!int.TryParse(model.DeviceNo, out devId))
{
throw new MyException("设备编号只能输入纯数字");
}
AddDefaultParkDeviceParam(model.GateID, model.DeviceID, model.DeviceNo, dbOperator);
}
dbOperator.CommitTransaction();
}
catch
{
dbOperator.RollbackTransaction();
throw;
}
}
if (result)
{
OperateLogServices.AddOperateLog <ParkDevice>(model, OperateType.Add);
}
return(result);
}
private static ParkDeviceDetection GetParkDeviceDetectionModel(ParkDevice device)
{
ParkDeviceDetection model = new ParkDeviceDetection();
model.RecordID = GuidGenerator.GetGuid().ToString();
model.DeviceID = device.DeviceID;
model.ConnectionState = 0;
IParkGate factory = ParkGateFactory.GetFactory();
model.PKID = factory.QueryParkingIdByGateId(device.GateID);
if (string.IsNullOrWhiteSpace(model.PKID))
{
throw new MyException("获取车场编号失败");
}
return(model);
}
private void mnu_Update_Click(object sender, EventArgs e)
{
if (grid.SelectedRows.Count == 1)
{
ParkDevice device = grid.SelectedRows[0].Tag as ParkDevice;
if (device != null)
{
List <EntranceInfo> items = (new EntranceBll(AppSettings.CurrentSetting.ParkConnect)).GetAllEntraces().QueryObjects;
if (items.Exists(item => item.IPAddress == device.LANInfo.IPAddress))
{
MessageBox.Show(string.Format(Resources.Resource1.FrmSearchDevice_DeviceExists, device.LANInfo.IPAddress));
return;
}
FrmParkDeviceIP frm = new FrmParkDeviceIP();
frm.UpdatingDevice = device;
frm.ShowDialog();
grid.SelectedRows[0].Cells["colIP"].Value = frm.UpdatingDevice.LANInfo.IPAddress;
}
}
}
public bool Add(ParkDevice model, DbOperator dbOperator)
{
model.DataStatus = DataStatus.Normal;
model.LastUpdateTime = DateTime.Now;
model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ParkDevice(DeviceID,GateID,DeviceType,PortType,Baudrate,SerialPort,IpAddr,IpPort,UserName,UserPwd,NetID,LedNum,DeviceNo,OfflinePort,DataStatus,LastUpdateTime,HaveUpdate,IsCapture,IsSVoice,IsCarBit,IsContestDev,ControllerType,DisplayMode,IsMonitor)");
strSql.Append(" values(@DeviceID,@GateID,@DeviceType,@PortType,@Baudrate,@SerialPort,@IpAddr,@IpPort,@UserName,@UserPwd,@NetID,@LedNum,@DeviceNo,@OfflinePort,@DataStatus,@LastUpdateTime,@HaveUpdate,@IsCapture,@IsSVoice,@IsCarBit,@IsContestDev,@ControllerType,@DisplayMode,@IsMonitor)");
dbOperator.ClearParameters();
dbOperator.AddParameter("DeviceID", model.DeviceID);
dbOperator.AddParameter("GateID", model.GateID);
dbOperator.AddParameter("DeviceType", model.DeviceType);
dbOperator.AddParameter("PortType", model.PortType);
dbOperator.AddParameter("Baudrate", model.Baudrate);
dbOperator.AddParameter("SerialPort", model.SerialPort);
dbOperator.AddParameter("IpAddr", model.IpAddr);
dbOperator.AddParameter("IpPort", model.IpPort);
dbOperator.AddParameter("UserName", model.UserName);
dbOperator.AddParameter("UserPwd", model.UserPwd);
dbOperator.AddParameter("NetID", model.NetID);
dbOperator.AddParameter("LedNum", model.LedNum);
dbOperator.AddParameter("DeviceNo", model.DeviceNo);
dbOperator.AddParameter("OfflinePort", model.OfflinePort);
dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime);
dbOperator.AddParameter("HaveUpdate", model.HaveUpdate);
dbOperator.AddParameter("DataStatus", (int)model.DataStatus);
dbOperator.AddParameter("IsCapture", model.IsCapture);
dbOperator.AddParameter("IsSVoice", model.IsSVoice);
dbOperator.AddParameter("IsCarBit", model.IsCarBit);
dbOperator.AddParameter("IsContestDev", model.IsContestDev);
dbOperator.AddParameter("ControllerType", model.ControllerType);
dbOperator.AddParameter("DisplayMode", model.DisplayMode);
dbOperator.AddParameter("IsMonitor", model.IsMonitor);
return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0);
}
private void mnu_AddTo_Click(object sender, EventArgs e)
{
if (grid.SelectedRows.Count == 1)
{
ParkDevice device = grid.SelectedRows[0].Tag as ParkDevice;
if (device != null)
{
List <EntranceInfo> items = (new EntranceBll(AppSettings.CurrentSetting.ParkConnect)).GetAllEntraces().QueryObjects;
if (items.Exists(item => item.IPAddress == device.LANInfo.IPAddress))
{
MessageBox.Show(string.Format(Resources.Resource1.FrmSearchDevice_DeviceExists, device.LANInfo.IPAddress));
return;
}
else
{
if (this.ItemAdding != null)
{
ItemAdding(device, EventArgs.Empty);
}
}
}
}
}
public bool Update(ParkDevice model, DbOperator dbOperator)
{
model.DataStatus = DataStatus.Normal;
model.LastUpdateTime = DateTime.Now;
model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag;
StringBuilder strSql = new StringBuilder();
strSql.Append("update ParkDevice set DeviceID=@DeviceID,GateID=@GateID,DeviceType=@DeviceType,PortType=@PortType,Baudrate=@Baudrate,SerialPort=@SerialPort,IpAddr=@IpAddr,IpPort=@IpPort,UserName=@UserName,UserPwd=@UserPwd,NetID=@NetID,LedNum=@LedNum,IsMonitor=@IsMonitor");
strSql.Append(",DeviceNo=@DeviceNo,OfflinePort=@OfflinePort,LastUpdateTime=@LastUpdateTime,HaveUpdate=@HaveUpdate,IsCapture=@IsCapture,IsSVoice=@IsSVoice,IsCarBit=@IsCarBit,IsContestDev=@IsContestDev,ControllerType=@ControllerType,DisplayMode=@DisplayMode where DeviceID=@DeviceID");
dbOperator.ClearParameters();
dbOperator.AddParameter("DeviceID", model.DeviceID);
dbOperator.AddParameter("GateID", model.GateID);
dbOperator.AddParameter("DeviceType", model.DeviceType);
dbOperator.AddParameter("PortType", model.PortType);
dbOperator.AddParameter("Baudrate", model.Baudrate);
dbOperator.AddParameter("SerialPort", model.SerialPort);
dbOperator.AddParameter("IpAddr", model.IpAddr);
dbOperator.AddParameter("IpPort", model.IpPort);
dbOperator.AddParameter("UserName", model.UserName);
dbOperator.AddParameter("UserPwd", model.UserPwd);
dbOperator.AddParameter("NetID", model.NetID);
dbOperator.AddParameter("LedNum", model.LedNum);
dbOperator.AddParameter("DeviceNo", model.DeviceNo);
dbOperator.AddParameter("OfflinePort", model.OfflinePort);
dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime);
dbOperator.AddParameter("HaveUpdate", model.HaveUpdate);
dbOperator.AddParameter("IsCapture", model.IsCapture);
dbOperator.AddParameter("IsSVoice", model.IsSVoice);
dbOperator.AddParameter("IsCarBit", model.IsCarBit);
dbOperator.AddParameter("IsContestDev", model.IsContestDev);
dbOperator.AddParameter("ControllerType", model.ControllerType);
dbOperator.AddParameter("DisplayMode", model.DisplayMode);
dbOperator.AddParameter("IsMonitor", model.IsMonitor);
return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0);
}
