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