public bool UpdateCameraInfo(VM_CameraParameters vm_cp) { int count = 0; string sql = string.Format("UPDATE [dbo].[{0}] SET [camera]={1} ,[exposureMode] = {2},[exposureMax] = {3},[exposureMin] ={4},[exposureValue] ={5} WHERE [ID]='{6}'", CP_TableName, vm_cp.camera, vm_cp.exposureMode, vm_cp.exposureMax, vm_cp.exposureMin, vm_cp.exposureValue, vm_cp.ID); count = m_CameraDAL.UpdateCameraInfo(sql); return(count > 0 ? true : false); }
public bool InsertCameraInfo(VM_CameraParameters vm_cp) { int count = 0; string sql = string.Format("INSERT INTO[dbo].[{0}]([camera],[exposureMode],[exposureMax],[exposureMin],[exposureValue]) VALUES('{1}','{2}','{3}','{4}','{5}'); ", CP_TableName, vm_cp.camera, vm_cp.exposureMode, vm_cp.exposureMax, vm_cp.exposureMin, vm_cp.exposureValue); count = m_CameraDAL.InsertCameraInfo(sql); return(count > 0? true : false); }
private void btnAdd_Click(object sender, EventArgs e) { CamereBLL camereBLL = new CamereBLL(); VM_CameraParameters vm_cp = new VM_CameraParameters(); vm_cp.camera = textEdit1.Text.ToString(); vm_cp.exposureMax = textEditExposureMax.Text.ToString(); vm_cp.exposureMin = textEditExposureMin.Text.ToString(); vm_cp.exposureMode = textEditExposureMode.Text.ToString(); vm_cp.exposureValue = textEditExposureValue.Text.ToString(); if (camereBLL.InsertCameraInfo(vm_cp)) { RefreshCameraUI(); } else { MessageBox.Show("插入数据失败!"); } }
private void btnUpdate_Click(object sender, EventArgs e) { VM_CameraParameters vm_cp = new VM_CameraParameters(); CamereBLL camereBLL = new CamereBLL(); int nId = GetSelectID(); if (nId == 0) { MessageBoxHelper.ShowInformationMessageBox("数据为空,不支持更新!"); return; } vm_cp.ID = nId; vm_cp.camera = textEdit1.Text.ToString(); vm_cp.exposureMax = textEditExposureMax.Text.ToString(); vm_cp.exposureMin = textEditExposureMin.Text.ToString(); vm_cp.exposureMode = textEditExposureMode.Text.ToString(); vm_cp.exposureValue = textEditExposureValue.Text.ToString(); camereBLL.UpdateCameraInfo(vm_cp); RefreshCameraUI(); }