public Dictionary<int, GroupInfo> GetAllGroupInfos(ref string errMessage) { Database db = DatabaseFactory.CreateDatabase(); errMessage = ""; Dictionary<int, GroupInfo> list = new Dictionary<int, GroupInfo>(); try { GroupInfo oGroupInfo; DeviceInfo oDevice; DataSet ds= GroupDataAccess.GetAllGroupInfo(db); DataSet dsDevice; DataSet dsCamera; CameraInfo oCamera; DataSet dsAlarm; AlarmInfo oAlarm; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { oGroupInfo = new GroupInfo(ds.Tables[0].Rows[i]); dsDevice = DeviceDataAccess.GetDeviceInfoByGroupId(db, oGroupInfo.GroupID); oGroupInfo.ListDevice = new Dictionary<int, DeviceInfo>(); foreach (DataRow dr in dsDevice.Tables[0].Rows) { oDevice = new DeviceInfo(dr); oDevice.ListCamera = new Dictionary<int, CameraInfo>(); dsCamera = CameraDataAccess.GetCamInfoByDeviceId(db, oDevice.DeviceId); foreach (DataRow drCam in dsCamera.Tables[0].Rows) { oCamera=new CameraInfo(drCam); oDevice.ListCamera.Add(oCamera.CameraId, oCamera); } oDevice.ListAlarm = new Dictionary<int, AlarmInfo>(); dsAlarm = AlarmDataAccess.GetAlarmInfoByDeviceId(db, oDevice.DeviceId); foreach (DataRow drAlarm in dsAlarm.Tables[0].Rows) { oAlarm = new AlarmInfo(drAlarm); oDevice.ListAlarm.Add(oAlarm.AlarmId, oAlarm); } oGroupInfo.ListDevice.Add(oDevice.DeviceId, oDevice); } list.Add(oGroupInfo.GroupID, oGroupInfo); } return list; } catch (Exception ex) { errMessage = ex.Message + ex.StackTrace; logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace); return null; } }
private void btnOK_Click(object sender, EventArgs e) { GroupInfo ogroup=new GroupInfo(); ogroup.Name = txtName.Text; ogroup.Description =txtDescription.Text; ogroup.ParentId = ParentGroupId; ogroup.GroupID = GroupId; errMessage = ""; switch (Opt) { case Util.Operateion.Add: GroupId = GroupBusiness.Instance.Insert(ref errMessage, ogroup); ogroup = GroupBusiness.Instance.GetGroupInfoByGroupName(ref errMessage, ogroup.Name); OperateLogBusiness.Instance.Insert(ref errMessage, new OperateLog { HappenTime = DateTime.Now, OperateTypeId = (int)(OperateLogTypeId.GroupAdd), OperateTypeName = OperateLogTypeName.GroupAdd, Content = ogroup.ToString(), GroupId = ogroup.GroupID, OperateUserName = MainForm.CurrentUser.UserName, ClientUserName = MainForm.CurrentUser.UserName, ClientUserId = MainForm.CurrentUser.UserId }); break; case Util.Operateion.Update: ogroup = GroupBusiness.Instance.GetGroupInfoByGroupId(ref errMessage, GroupId); ogroup.Name = txtName.Text; ogroup.Description = txtDescription.Text; GroupId = GroupBusiness.Instance.Update(ref errMessage, ogroup); OperateLogBusiness.Instance.Insert(ref errMessage, new OperateLog { HappenTime = DateTime.Now, OperateTypeId = (int)(OperateLogTypeId.GroupUpdate), OperateTypeName = OperateLogTypeName.GroupUpdate, Content = ogroup.ToString(), GroupId = ogroup.GroupID, OperateUserName = MainForm.CurrentUser.UserName, ClientUserName = MainForm.CurrentUser.UserName, ClientUserId = MainForm.CurrentUser.UserId }); break; case Util.Operateion.Delete: ogroup = GroupBusiness.Instance.GetGroupInfoByGroupId(ref errMessage, GroupId); GroupId = GroupBusiness.Instance.Delete(ref errMessage, GroupId); OperateLogBusiness.Instance.Insert(ref errMessage, new OperateLog { HappenTime = DateTime.Now, OperateTypeId = (int)(OperateLogTypeId.GroupDelete), OperateTypeName = OperateLogTypeName.GroupDelete , Content = ogroup.ToString(), GroupId = ogroup.GroupID, OperateUserName = MainForm.CurrentUser.UserName, ClientUserName = MainForm.CurrentUser.UserName, ClientUserId = MainForm.CurrentUser.UserId }); break; default: break; } if (errMessage.Length == 0) { this.Close(); } }
public static int Insert(Database db, GroupInfo oGroupInfo) { StringBuilder sbField = new StringBuilder(); StringBuilder sbValue = new StringBuilder(); sbField.Append("INSERT INTO GroupInfo("); sbValue.Append("values("); sbField.Append("Name"); sbValue.AppendFormat("'{0}'", oGroupInfo.Name); sbField.Append(",Description"); sbValue.AppendFormat(",'{0}'", oGroupInfo.Description); sbField.Append(",ParentId"); sbValue.AppendFormat(",{0}", oGroupInfo.ParentId); sbField.Append(",AddBy"); sbValue.AppendFormat(",'{0}'", oGroupInfo.AddBy); sbField.Append(",AddTime)"); sbValue.AppendFormat(",'{0}')", oGroupInfo.AddTime); string cmdText = sbField.ToString() + " " + sbValue.ToString() + ""; try { return db.ExecuteNonQuery(CommandType.Text, cmdText); } catch (Exception ex) { throw ex; } }
public static int Update(Database db, GroupInfo oGroupInfo) { StringBuilder sb = new StringBuilder(); sb.Append("update GroupInfo set"); sb.AppendFormat(" Name='{0}'", oGroupInfo.Name); sb.AppendFormat(",Description='{0}'", oGroupInfo.Description); sb.AppendFormat(",ParentId={0}", oGroupInfo.ParentId); sb.AppendFormat(",ModifyBy='{0}'", oGroupInfo.AddBy); sb.AppendFormat(",ModifyTime='{0}'", oGroupInfo.AddTime ?? DateTime.Now.ToString()); sb.AppendFormat(" where GroupID={0}", oGroupInfo.GroupID); string cmdText = sb.ToString(); try { return db.ExecuteNonQuery(CommandType.Text, cmdText); } catch (Exception ex) { throw ex; } }
public int Update(ref string errMessage, GroupInfo oGroupInfo) { Database db = DatabaseFactory.CreateDatabase(); errMessage = ""; try { return GroupDataAccess.Update(db, oGroupInfo); } catch (Exception ex) { errMessage = ex.Message + ex.StackTrace; logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace); return -1; } }
public GroupInfo GetGroupInfoByGroupName(ref string errMessage, string groupName) { Database db = DatabaseFactory.CreateDatabase(); errMessage = ""; try { DataSet ds = GroupDataAccess.GetGroupInfoByGroupName(db, groupName); if (ds.Tables[0].Rows.Count == 0) { return null; } DataSet dsDevice; DataSet dsCamera; CameraInfo oCamera; DeviceInfo oDevice; DataSet dsAlarm; AlarmInfo oAlarm; GroupInfo oGroupInfo = new GroupInfo(ds.Tables[0].Rows[0]); dsDevice = DeviceDataAccess.GetDeviceInfoByGroupId(db, oGroupInfo.GroupID); oGroupInfo.ListDevice = new Dictionary<int, DeviceInfo>(); foreach (DataRow dr in ds.Tables[0].Rows) { oDevice = new DeviceInfo(dr); oDevice.ListCamera = new Dictionary<int, CameraInfo>(); dsCamera = CameraDataAccess.GetCamInfoByDeviceId(db, oDevice.DeviceId); foreach (DataRow drCam in dsCamera.Tables[0].Rows) { oCamera = new CameraInfo(drCam); oDevice.ListCamera.Add(oCamera.CameraId, oCamera); } oDevice.ListAlarm = new Dictionary<int, AlarmInfo>(); dsAlarm = AlarmDataAccess.GetAlarmInfoByDeviceId(db, oDevice.DeviceId); foreach (DataRow drAlarm in dsAlarm.Tables[0].Rows) { oAlarm = new AlarmInfo(drAlarm); oDevice.ListAlarm.Add(oAlarm.AlarmId, oAlarm); } oGroupInfo.ListDevice.Add(oDevice.DeviceId, oDevice); } return oGroupInfo; } catch (Exception ex) { errMessage = ex.Message + ex.StackTrace; logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace); return null; } }