/// <summary> /// 查重方法 /// </summary> /// <returns></returns> private bool btnCheckupdate() { bool rbool = true; try { string PositionName = this.cbxPositionName.Text.ToString(); int lenth = cbxDrivewayName.Text.Trim().Length; string DrivewayName = cbxDrivewayName.Text.Trim().Substring(0, 4); string DrivewayType = cbxDrivewayName.Text.Trim().Substring(lenth - 1, 1); string CameraName = this.txtCamera_Name.Text.Trim(); string CameraCardAdd = this.txtCamera_CardAdd.Text.Trim(); //判断名称是否已存在 Expression <Func <View_Camera_Driveway_Position, bool> > funviewCamera = n => n.Position_Name == PositionName && n.Driveway_Name == DrivewayName && n.Camera_Name == CameraName && n.Camera_Name != this.dgvCamera.SelectedRows[0].Cells["Camera_Name"].Value.ToString(); if (CameraDAL.QueryView(funviewCamera).Count() > 0) { PublicClass.ShowToolTip(ToolTipIcon.Info, "提示", "该摄像头名称已存在", txtCamera_Name, this); txtCamera_Name.Focus(); rbool = false;; } Expression <Func <View_Camera_Driveway_Position, bool> > funviewCamera1 = n => n.Position_Name == PositionName && n.Driveway_Name == DrivewayName && n.Camera_AddCard == CameraCardAdd && n.Camera_AddCard != this.dgvCamera.SelectedRows[0].Cells["Camera_AddCard"].Value.ToString(); if (CameraDAL.QueryView(funviewCamera1).Count() > 0) { PublicClass.ShowToolTip(ToolTipIcon.Info, "提示", "该摄像头地址码已存在", txtCamera_CardAdd, this); txtCamera_CardAdd.Focus(); rbool = false;; } return(rbool); } catch { CommonalityEntity.WriteTextLog("摄像头管理 btnCheck()"); rbool = false; } return(rbool); }
/// <summary> /// 双击组件时发生 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvCamera_DoubleClick(object sender, EventArgs e) { this.btnUpdate.Enabled = true; this.btnSave.Enabled = false; if (this.dgvCamera.SelectedRows.Count > 0)//选中行 { if (dgvCamera.SelectedRows.Count > 1) { MessageBox.Show("修改只能选中一行!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { //修改的值 int ID = int.Parse(this.dgvCamera.SelectedRows[0].Cells["Camera_ID"].Value.ToString()); Expression <Func <View_Camera_Driveway_Position, bool> > funviewinto = n => n.Camera_ID == ID; foreach (var n in CameraDAL.QueryView(funviewinto)) { if (n.Position_Name != null) { // 门岗名称 this.cbxPositionName.Text = n.Position_Name; } if (n.Driveway_ID > 0) { //通道名称 this.cbxDrivewayName.Text = n.Driveway_Name + n.Driveway_Type; } if (n.Camera_AddCard != null) { // 摄像头地址码 this.txtCamera_CardAdd.Text = n.Camera_AddCard; } if (n.Camera_Name != null) { // 摄像头名称 this.txtCamera_Name.Text = n.Camera_Name; } if (n.Camera_State != null) { // 摄像头状态 this.cbxCamera_State.Text = n.Camera_State; } if (n.Camera_Location != null) { // 摄像头拍照位置 this.cbxCamera_Location.Text = n.Camera_Location; } if (n.Camera_Remark != null) { // 摄像头备注 this.txtCamera_Remark.Text = n.Camera_Remark; } break; } } } else { MessageBox.Show("请选择要修改的行!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }