private void CapNhat() { try { KHAMDINHKI khamdinhki1 = GetKHAMDINHKIByForm(); KHAMCHUYENKHOA khamchuyenkhoa1 = GetKHAMCHUYENKHOAByForm(); KHAMCANLAMSANG khamcanlamsang1 = GetKHAMCANLAMSANGByForm(); KHAMTHELUC khamtheluc1 = GetKHAMTHELUCByForm(); khamdinhki1.ID = khamdinhki.ID; khamdinhki1.KHAMCANLAMSANGID = khamdinhki.KHAMCANLAMSANGID; khamdinhki1.KHAMTHELUCID = khamdinhki.KHAMTHELUCID; khamdinhki1.KHAMCHUYENKHOAID = khamdinhki.KHAMCHUYENKHOAID; khamchuyenkhoa1.ID = (int)khamdinhki.KHAMCHUYENKHOAID; khamcanlamsang1.ID = (int)khamdinhki.KHAMCANLAMSANGID; khamtheluc1.ID = (int)khamdinhki.KHAMTHELUCID; KHAMDINHKIService.Update(khamdinhki1); KHAMCHUYENKHOAService.Update(khamchuyenkhoa1); KHAMCANLAMSANGService.Update(khamcanlamsang1); KHAMTHELUCService.Update(khamtheluc1); } catch { } }
/// <summary> /// Populate business objects from the data reader /// </summary> /// <param name="dataReader">data reader</param> /// <returns>list of KHAMTHELUC</returns> internal List <KHAMTHELUC> PopulateObjectsFromReader(IDataReader dataReader) { List <KHAMTHELUC> list = new List <KHAMTHELUC>(); while (dataReader.Read()) { KHAMTHELUC businessObject = new KHAMTHELUC(); PopulateBusinessObjectFromReader(businessObject, dataReader); list.Add(businessObject); } return(list); }
/// <summary> /// Populate business object from data reader /// </summary> /// <param name="businessObject">business object</param> /// <param name="dataReader">data reader</param> internal void PopulateBusinessObjectFromReader(KHAMTHELUC businessObject, IDataReader dataReader) { businessObject.ID = dataReader.GetInt32(dataReader.GetOrdinal(KHAMTHELUC.KHAMTHELUCFields.ID.ToString())); if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHELUC.KHAMTHELUCFields.BACSIID.ToString()))) { businessObject.BACSIID = dataReader.GetInt32(dataReader.GetOrdinal(KHAMTHELUC.KHAMTHELUCFields.BACSIID.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHELUC.KHAMTHELUCFields.CHIEUCAO.ToString()))) { businessObject.CHIEUCAO = dataReader.GetString(dataReader.GetOrdinal(KHAMTHELUC.KHAMTHELUCFields.CHIEUCAO.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHELUC.KHAMTHELUCFields.CANNANG.ToString()))) { businessObject.CANNANG = dataReader.GetInt32(dataReader.GetOrdinal(KHAMTHELUC.KHAMTHELUCFields.CANNANG.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHELUC.KHAMTHELUCFields.MACH.ToString()))) { businessObject.MACH = dataReader.GetString(dataReader.GetOrdinal(KHAMTHELUC.KHAMTHELUCFields.MACH.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHELUC.KHAMTHELUCFields.HUYETAP.ToString()))) { businessObject.HUYETAP = dataReader.GetString(dataReader.GetOrdinal(KHAMTHELUC.KHAMTHELUCFields.HUYETAP.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHELUC.KHAMTHELUCFields.VONGNGUC.ToString()))) { businessObject.VONGNGUC = dataReader.GetInt32(dataReader.GetOrdinal(KHAMTHELUC.KHAMTHELUCFields.VONGNGUC.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHELUC.KHAMTHELUCFields.NHIETDO.ToString()))) { businessObject.NHIETDO = dataReader.GetInt32(dataReader.GetOrdinal(KHAMTHELUC.KHAMTHELUCFields.NHIETDO.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHELUC.KHAMTHELUCFields.KETQUALAMSANG.ToString()))) { businessObject.KETQUALAMSANG = dataReader.GetString(dataReader.GetOrdinal(KHAMTHELUC.KHAMTHELUCFields.KETQUALAMSANG.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHELUC.KHAMTHELUCFields.GHICHU.ToString()))) { businessObject.GHICHU = dataReader.GetString(dataReader.GetOrdinal(KHAMTHELUC.KHAMTHELUCFields.GHICHU.ToString())); } }
private void UpdateDetail() { try { UpdateDetailKhamDinhKi(khamdinhki); KHAMCHUYENKHOA khamchuyenkhoa = KHAMCHUYENKHOAService.GetByPrimaryKey(new KHAMCHUYENKHOAKeys((int)khamdinhki.KHAMCHUYENKHOAID)); KHAMCANLAMSANG khamcanlamsang = KHAMCANLAMSANGService.GetByPrimaryKey(new KHAMCANLAMSANGKeys((int)khamdinhki.KHAMCANLAMSANGID)); KHAMTHELUC khamtheluc = KHAMTHELUCService.GetByPrimaryKey(new KHAMTHELUCKeys((int)khamdinhki.KHAMTHELUCID)); UpdateDetailKhamChuyenKhoa(khamchuyenkhoa); UpdateDetailKhamCanLamSang(khamcanlamsang); UpdateDetailKhamTheLuc(khamtheluc); } catch { } }
private void btnLuu_Click(object sender, EventArgs e) { try { if (CheckKhamDinhKi()) { KHAMDINHKI khamdinhki1 = GetKHAMDINHKIByForm(); KHAMCHUYENKHOA khamchuyenkhoa = GetKHAMCHUYENKHOAByForm(); KHAMCANLAMSANG khamcanlamsang = GetKHAMCANLAMSANGByForm(); KHAMTHELUC khamtheluc = GetKHAMTHELUCByForm(); if (khamdinhki.ID == 0) { KHAMCHUYENKHOAService.Insert(khamchuyenkhoa); KHAMCANLAMSANGService.Insert(khamcanlamsang); KHAMTHELUCService.Insert(khamtheluc); khamdinhki1.KHAMCHUYENKHOAID = khamchuyenkhoa.ID; khamdinhki1.KHAMTHELUCID = khamtheluc.ID; khamdinhki1.KHAMCANLAMSANGID = khamcanlamsang.ID; KHAMDINHKIService.Insert(khamdinhki1); MessageBox.Show("Thêm thông tin khám định kì thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); LockControl(); } else { CapNhat(); MessageBox.Show("Cập nhật thông tin khám định kì thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } UpdateDetail(); } } catch { } }
private void UpdateDetailKhamTheLuc(KHAMTHELUC khamtheluc) { try { cbxBacSiTheLuc.EditValue = khamtheluc.BACSIID; txtTheLucChieuCao.Text = khamtheluc.CHIEUCAO; txtTheLucCanNang.Text = khamtheluc.CANNANG.ToString(); txtTheLucMach.Text = khamtheluc.MACH; txtTheLucHuyetAp.Text = khamtheluc.HUYETAP; txtTheLucGhiChu.Text = khamtheluc.GHICHU; txtTheLucVongNguc.Text = khamtheluc.VONGNGUC.ToString(); txtTheLucNhietDo.Text = khamtheluc.NHIETDO.ToString(); txtTheLucKetQua.Text = khamtheluc.KETQUALAMSANG; } catch { } }
private KHAMTHELUC GetKHAMTHELUCByForm() { KHAMTHELUC ans = new KHAMTHELUC(); ans.BACSIID = (int)cbxBacSiTheLuc.EditValue; ans.CHIEUCAO = txtTheLucChieuCao.Text; ans.KETQUALAMSANG = txtTheLucKetQua.Text; ans.MACH = txtTheLucMach.Text; ans.HUYETAP = txtTheLucHuyetAp.Text; ans.GHICHU = txtTheLucGhiChu.Text; // can nang try { ans.CANNANG = Int32.Parse(txtTheLucCanNang.Text); } catch { ans.CANNANG = 0; } // vong nguc try { ans.VONGNGUC = Int32.Parse(txtTheLucVongNguc.Text); } catch { ans.VONGNGUC = 0; } // nhiet do try { ans.NHIETDO = Int32.Parse(txtTheLucNhietDo.Text); } catch { ans.NHIETDO = 0; } return(ans); }
/// <summary> /// Select by primary key /// </summary> /// <param name="keys">primary keys</param> /// <returns>KHAMTHELUC business object</returns> public KHAMTHELUC SelectByPrimaryKey(KHAMTHELUCKeys keys) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[KHAMTHELUC_SelectByPrimaryKey]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, keys.ID)); MainConnection.Open(); IDataReader dataReader = sqlCommand.ExecuteReader(); if (dataReader.Read()) { KHAMTHELUC businessObject = new KHAMTHELUC(); PopulateBusinessObjectFromReader(businessObject, dataReader); return(businessObject); } else { return(null); } } catch //(Exception ex) { return(null); //throw new Exception("KHAMTHELUC::SelectByPrimaryKey::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// insert new row in the table /// </summary> /// <param name="businessObject">business object</param> /// <returns>true of successfully insert</returns> public bool Insert(KHAMTHELUC businessObject) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[KHAMTHELUC_Insert]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int, 4, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Proposed, businessObject.ID)); sqlCommand.Parameters.Add(new SqlParameter("@BACSIID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.BACSIID)); sqlCommand.Parameters.Add(new SqlParameter("@CHIEUCAO", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.CHIEUCAO)); sqlCommand.Parameters.Add(new SqlParameter("@CANNANG", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.CANNANG)); sqlCommand.Parameters.Add(new SqlParameter("@MACH", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.MACH)); sqlCommand.Parameters.Add(new SqlParameter("@HUYETAP", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.HUYETAP)); sqlCommand.Parameters.Add(new SqlParameter("@VONGNGUC", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.VONGNGUC)); sqlCommand.Parameters.Add(new SqlParameter("@NHIETDO", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.NHIETDO)); sqlCommand.Parameters.Add(new SqlParameter("@KETQUALAMSANG", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.KETQUALAMSANG)); sqlCommand.Parameters.Add(new SqlParameter("@GHICHU", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.GHICHU)); MainConnection.Open(); sqlCommand.ExecuteNonQuery(); businessObject.ID = (int)sqlCommand.Parameters["@ID"].Value; return(true); } catch //(Exception ex) { return(false); //throw new Exception("KHAMTHELUC::Insert::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }