public DecoderInfo GetDecoderInfoByDecoderIP(ref string errMessage, string IP)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
DataSet ds = DecoderDataAccess.GetDecoderInfoByDecoderIP(db, IP);
if (ds.Tables[0].Rows.Count == 0)
{
return(null);
}
DecoderInfo decoderInfo = new DecoderInfo(ds.Tables[0].Rows[0]);
DataSet dsCamera;
CameraInfo oCamera;
dsCamera = DecoderDataAccess.GetCameraInfoByDecoderId(db, decoderInfo.id);
//DecoderDataAccess.GetCamInfoByCameraId(db,dsCamera.Tables[0].Rows[i].)
decoderInfo.ListCameras = new Dictionary <int, CameraInfo>();
foreach (DataRow dr in dsCamera.Tables[0].Rows)
{
oCamera = new CameraInfo(dr);
decoderInfo.ListCameras.Add(oCamera.CameraId, oCamera);
}
return(decoderInfo);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
public Dictionary <int, DecoderInfo> GetAllDecoderInfo(ref string errMessage)
{
/*Database db = DatabaseFactory.CreateDatabase();
* errMessage = "";
* Dictionary<int, DecoderInfo> list = new Dictionary<int, DecoderInfo>();
* try
* {
*
* DataSet ds = DecoderDataAccess.GetAllDecInfo(db);
*
* DecoderInfo oDecoder;
* for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
* {
* oDecoder = new DecoderInfo(ds.Tables[0].Rows[i]);
* list.Add(oDecoder.id, oDecoder);
*
* }
* return list;
*
* }
* catch (Exception ex)
* {
* errMessage = ex.Message + ex.StackTrace;
* logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
* return null;
* }*/
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
Dictionary <int, DecoderInfo> list = new Dictionary <int, DecoderInfo>();
try
{
DecoderInfo oDecoderInfo;
DataSet ds = DecoderDataAccess.GetAllDecInfo(db);
DataSet dsCamera;
CameraInfo oCamera;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
oDecoderInfo = new DecoderInfo(ds.Tables[0].Rows[i]);
dsCamera = DecoderDataAccess.GetCameraInfoByDecoderId(db, oDecoderInfo.id);
//DecoderDataAccess.GetCamInfoByCameraId(db,dsCamera.Tables[0].Rows[i].)
oDecoderInfo.ListCameras = new Dictionary <int, CameraInfo>();
foreach (DataRow dr in dsCamera.Tables[0].Rows)
{
oCamera = new CameraInfo(dr);
oDecoderInfo.ListCameras.Add(oCamera.CameraId, oCamera);
}
list.Add(oDecoderInfo.id, oDecoderInfo);
}
return(list);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
public int Update(ref string errMessage, DecoderInfo DecoderInfo)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
return(DecoderDataAccess.Update(db, DecoderInfo));
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(-1);
}
}
public int Delete(ref string errMessage, int DecoderId)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
int iRtn = DecoderDataAccess.Delete(db, DecoderId);
return(iRtn);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(-1);
}
}
public DeviceInfo GetDeviceInfoByCameraId(ref string errMessage, int Id)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
DataSet ds = DecoderDataAccess.GetDeviceInfoByCameraId(db, Id);
if (ds.Tables[0].Rows.Count == 0)
{
return(null);
}
return(new DeviceInfo(ds.Tables[0].Rows[0]));
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
public Dictionary <int, DecoderInfo> GetDecoderInfoByName(ref string errMessage, string Name)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
Dictionary <int, DecoderInfo> mylist = new Dictionary <int, DecoderInfo>();
try
{
DataSet ds = DecoderDataAccess.GetDecoderInfoByName(db, Name);
DecoderInfo decoderInfo;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
decoderInfo = new DecoderInfo(ds.Tables[0].Rows[i]);
DataSet dsCamera;
CameraInfo oCamera;
dsCamera = DecoderDataAccess.GetCameraInfoByDecoderId(db, decoderInfo.id);
//DecoderDataAccess.GetCamInfoByCameraId(db,dsCamera.Tables[0].Rows[i].)
decoderInfo.ListCameras = new Dictionary <int, CameraInfo>();
foreach (DataRow dr in dsCamera.Tables[0].Rows)
{
oCamera = new CameraInfo(dr);
decoderInfo.ListCameras.Add(oCamera.CameraId, oCamera);
}
mylist.Add(decoderInfo.id, decoderInfo);
}
return(mylist);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
//向decodercamera中添加摄像头信息
public int InsertCamera(ref string errMessage, int odecoder, int ocamera)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
if (DecoderDataAccess.GetTheCamera(db, ocamera).Tables[0].Rows.Count != 0)
{
return(-1);
}
else
{
return(DecoderDataAccess.InsertCamera(db, odecoder, ocamera));
}
//return DecoderDataAccess.InsertCamera(db, odecoder, ocamera);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(-1);
}
}
