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 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; } }