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