public ProgSwitchInfo GetProgSwitchById(ref string errMessage, int progSwitchId)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
DataSet ds = ProgSwitchDataAccess.GetProgSwitchById(db, progSwitchId);
if (ds.Tables[0].Rows.Count == 0)
{
return(null);
}
var progSwitchInfo = new ProgSwitchInfo(ds.Tables[0].Rows[0])
{
ListProgSwitchDetailInfo = new Dictionary <int, ProgSwitchDetailInfo>()
};
var progSwitchDetail = ProgSwitchDetailDataAccess.GetProgSwitchDetailByProgSwitchId(db, progSwitchInfo.Id);
progSwitchInfo.ListProgSwitchDetailInfo = new Dictionary <int, ProgSwitchDetailInfo>();
//对于一个程序切换中的所有与程序切换有联系的记录
foreach (DataRow drpsd in progSwitchDetail.Tables[0].Rows)
{
var progSwitchDetailInfo = new ProgSwitchDetailInfo(drpsd);
progSwitchInfo.ListProgSwitchDetailInfo.Add(progSwitchDetailInfo.ProgSwitchDetailId, progSwitchDetailInfo);
}
return(progSwitchInfo);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
Logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
public int DeleteProgSwitchDetailById(ref string errMessage, int id)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
int iRtn = ProgSwitchDetailDataAccess.Delete(db, id);
return(iRtn);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(-1);
}
}
public DataTable GetProgSwitchDetailDataSet(ref string errMessage)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
DataSet ds = ProgSwitchDetailDataAccess.GetAllProgSwitchDetailInfos(db);
return(ds.Tables[0]);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
public int InsertProgSwitchDetailById(ref string errMessage, int grogSwitchid, int cameraId, int tickTime)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
int iRtn = ProgSwitchDetailDataAccess.Insert(db, grogSwitchid, cameraId, tickTime);
return(iRtn);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(-1);
}
}
public Dictionary <int, ProgSwitchInfo> GetAllProgSwitchs(ref string errMessage)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
var list = new Dictionary <int, ProgSwitchInfo>();
try
{
ProgSwitchInfo progSwitchInfo;
DataSet ds = ProgSwitchDataAccess.GetAllProgSwitchInfo(db);
DataSet dsProgSwitchDetail;
ProgSwitchDetailInfo progSwitchDetailInfo;
//对于每一个程序切换
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
progSwitchInfo = new ProgSwitchInfo(ds.Tables[0].Rows[i]);
dsProgSwitchDetail = ProgSwitchDetailDataAccess.GetProgSwitchDetailByProgSwitchId(db, progSwitchInfo.Id);
progSwitchInfo.ListProgSwitchDetailInfo = new Dictionary <int, ProgSwitchDetailInfo>();
//对于一个程序切换中的所有与程序切换有联系的记录
foreach (DataRow drpsd in dsProgSwitchDetail.Tables[0].Rows)
{
progSwitchDetailInfo = new ProgSwitchDetailInfo(drpsd);
progSwitchInfo.ListProgSwitchDetailInfo.Add(progSwitchDetailInfo.ProgSwitchDetailId, progSwitchDetailInfo);
}
list.Add(progSwitchInfo.Id, progSwitchInfo);
}
return(list);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
Logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
public ProgSwitchDetailInfo GetProgSwitchDetailByDetailId(ref string errMessage, int detailId)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
DataSet ds = ProgSwitchDetailDataAccess.GetProgSwitchDetailByDetailId(db, detailId);
if (ds.Tables[0].Rows.Count == 0)
{
return(null);
}
return(new ProgSwitchDetailInfo(ds.Tables[0].Rows[0]));
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
