private void tsmUpdateBarcode_Click(object sender, EventArgs e) { try { if (TResultDetail.CreateQuery().WHERE(TResultDetail.Columns.TestId, grdTestInfo.GetValue("Test_ID")).GetRecordCount() > 0) { Utility.ShowMsg("Đăng ký đã có kết quả. Không được sửa barcode !"); return; } frmInput_Update_Barcode oForm = new frmInput_Update_Barcode(); if (SysPara.AutoGenerateBarcode == 2) { oForm.vTestType_ID = Utility.Int32Dbnull(grdTestInfo.GetValue("TestType_ID")); } oForm.txtBarcode.Text = Utility.sDbnull(grdTestInfo.GetValue("Barcode")); oForm.txtTestType_Name.Text = Utility.sDbnull(grdTestInfo.GetValue("TestType_Name")); oForm.vPatient_ID = patientId; oForm.ShowDialog(); if (string.IsNullOrEmpty(oForm.txtBarcode.Text) | oForm.txtBarcode.Text == Utility.sDbnull(grdTestInfo.GetValue("Barcode"))) { return; } new Update(TTestInfo.Schema.Name).Set(TTestInfo.Columns.Barcode).EqualTo(oForm.txtBarcode.Text). Where(TTestInfo.Columns.TestId).IsEqualTo(Utility.Int32Dbnull(grdTestInfo.GetValue("Test_ID"))). Execute(); new Update(TRegList.Schema.Name).Set(TTestInfo.Columns.Barcode).EqualTo(oForm.txtBarcode.Text). Where(TRegList.Columns.TestId).IsEqualTo(Utility.Int32Dbnull(grdTestInfo.GetValue("Test_ID"))). Execute(); grdTestInfo.CurrentRow.Cells["Barcode"].Value = oForm.txtBarcode.Text; } catch (Exception ex) { Utility.ShowMsg(ex.Message); } }
private void tsmUpdateBarcode_Click(object sender, EventArgs e) { try { if (TResultDetail.CreateQuery().WHERE(TResultDetail.Columns.TestId,grdTestInfo.GetValue("Test_ID")).GetRecordCount() > 0) { Utility.ShowMsg("Đăng ký đã có kết quả. Không được sửa barcode !"); return; } frmInput_Update_Barcode oForm = new frmInput_Update_Barcode(); if (SysPara.AutoGenerateBarcode == 2) oForm.vTestType_ID = Utility.Int32Dbnull(grdTestInfo.GetValue("TestType_ID")); oForm.txtBarcode.Text = Utility.sDbnull(grdTestInfo.GetValue("Barcode")); oForm.txtTestType_Name.Text = Utility.sDbnull(grdTestInfo.GetValue("TestType_Name")); oForm.vPatient_ID = patientId; oForm.ShowDialog(); if (string.IsNullOrEmpty(oForm.txtBarcode.Text) | oForm.txtBarcode.Text == Utility.sDbnull(grdTestInfo.GetValue("Barcode"))) { return; } new Update(TTestInfo.Schema.Name).Set(TTestInfo.Columns.Barcode).EqualTo(oForm.txtBarcode.Text). Where(TTestInfo.Columns.TestId).IsEqualTo(Utility.Int32Dbnull(grdTestInfo.GetValue("Test_ID"))). Execute(); new Update(TRegList.Schema.Name).Set(TTestInfo.Columns.Barcode).EqualTo(oForm.txtBarcode.Text). Where(TRegList.Columns.TestId).IsEqualTo(Utility.Int32Dbnull(grdTestInfo.GetValue("Test_ID"))). Execute(); grdTestInfo.CurrentRow.Cells["Barcode"].Value = oForm.txtBarcode.Text; } catch (Exception ex) { Utility.ShowMsg(ex.Message); } }
/// <summary> /// Hàm xử lý click vào nút đăng ký xn /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BtnTestTypeClick(object sender, EventArgs e) { try { int count; var btn = (UIButton) sender; int vTestTypeId = Utility.Int32Dbnull(btn.Tag); count = TTestInfo.CreateQuery().WHERE(TTestInfo.Columns.PatientId, patientId). WHERE(TTestInfo.Columns.TestTypeId, vTestTypeId).GetRecordCount(); if (count > 0) { //Utility.ShowMsg("Loại Xét Nghiệm đã được đăng ký"); //Todo: focus vào test đã đăng ký for (int i = 0; i < grdTestInfo.RowCount; i++) { if (Utility.sDbnull(grdTestInfo.GetRow(i).Cells["TestType_ID"].Value) == (string)btn.Tag) { grdTestInfo.MoveTo(i); break; } } return; } string vBarcode = ""; DataRow drTestType = Utility.GetDataRow(dtTestTypeList, TTestTypeList.Columns.TestTypeId, btn.Tag); if (SysPara.AutoGenerateBarcode == 2 | (SysPara.AutoGenerateBarcode == 0 & dtTestInfo.Rows.Count == 0)) { frmInput_Update_Barcode oForm = new frmInput_Update_Barcode(); if (dtTestInfo.Rows.Count > 0) { oForm.txtBarcode.Text = Utility.sDbnull(grdTestInfo.GetValue("Barcode")); oForm.txtBarcode.SelectAll(); } oForm.vTestType_ID = vTestTypeId; oForm.txtTestType_Name.Text = Utility.sDbnull(drTestType["TestType_Name"]); oForm.ShowDialog(); if (string.IsNullOrEmpty(oForm.txtBarcode.Text)) return; vBarcode = oForm.txtBarcode.Text; } else if (dtTestInfo.Rows.Count > 0) { vBarcode = Utility.sDbnull(grdTestInfo.GetValue("Barcode")).Trim(); //count = new Select().From(TTestInfo.Schema).Where(TTestInfo.Columns.TestTypeId).IsEqualTo(vTestTypeId). // And(TTestInfo.Columns.Barcode).IsEqualTo(vBarcode).GetRecordCount(); //if (count > 0) //{ // Utility.ShowMsg("Barcode tồn tại. Mời nhập lại."); // return; //} } else { vBarcode = BarcodeInfo.GetBarcodeForPatient(patientId, vTestTypeId, drTestType[TTestTypeList.Columns.IntOrder].ToString()); if (vBarcode == "-1") { Utility.ShowMsg("Không tìm được Barcode"); return; } } string canlamsangid; LPatientInfo lPatientInfo = new Select().From(LPatientInfo.Schema.Name).Where(LPatientInfo.Columns.PatientId).IsEqualTo(patientId).ExecuteSingle<LPatientInfo>(); canlamsangid=lPatientInfo.CanLamSangId; var obj = new TTestInfo(); obj.TestTypeId = vTestTypeId; obj.Barcode = vBarcode; obj.PatientId = patientId; obj.TestDate = DateTime.Now; obj.RequireDate = DateTime.Now; obj.AssignId = Utility.Int32Dbnull(cboAssignDoctor.SelectedValue); obj.CanLamSangId = "OO" + DateTime.Now.ToString("yyMMdd")+"."+canlamsangid; obj.IsNew = true; obj.Save(); DataRow dr = dtTestInfo.NewRow(); dr[TTestInfo.Columns.TestId] = TTestInfo.CreateQuery().WHERE(TTestInfo.Columns.PatientId, patientId). WHERE(TTestInfo.Columns.TestTypeId, vTestTypeId).GetMax(TTestInfo.Columns.TestId); dr[TTestInfo.Columns.TestDate] = obj.TestDate; dr[TTestInfo.Columns.Barcode] = obj.Barcode; dr[TTestInfo.Columns.PatientId] = obj.PatientId; dr[TTestInfo.Columns.TestTypeId] = obj.TestTypeId; dr[TTestTypeList.Columns.TestTypeName] = drTestType[TTestTypeList.Columns.TestTypeName].ToString(); dr[TTestInfo.Columns.AssignId] = obj.AssignId; dr["AssignDoctor_Name"] = Utility.Int32Dbnull(cboAssignDoctor.SelectedValue) == -1 ? "" : cboAssignDoctor.Text; dtTestInfo.Rows.InsertAt(dr, 0); grdTestInfo.SelectionChanged -= grdTestInfo_SelectionChanged; dtTestInfo.AcceptChanges(); grdTestInfo.SelectionChanged += grdTestInfo_SelectionChanged; grdTestInfo.MoveFirst(); // Todo: xử lý sau khi nhấn nút đăng ký //Nếu ô đăng ký test có dl thì chuyển sang //if (flpTestGroup.Controls.Count > 0) flpTestGroup.Focus(); //else flpStandardTest.Focus(); } catch (Exception ex) { Utility.ShowMsg(ex.Message); } finally {FocusButtonDetail();} }
/// <summary> /// Hàm xử lý click vào nút đăng ký xn /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BtnTestTypeClick(object sender, EventArgs e) { try { int count; var btn = (UIButton)sender; int vTestTypeId = Utility.Int32Dbnull(btn.Tag); count = TTestInfo.CreateQuery().WHERE(TTestInfo.Columns.PatientId, patientId). WHERE(TTestInfo.Columns.TestTypeId, vTestTypeId).GetRecordCount(); if (count > 0) { //Utility.ShowMsg("Loại Xét Nghiệm đã được đăng ký"); //Todo: focus vào test đã đăng ký for (int i = 0; i < grdTestInfo.RowCount; i++) { if (Utility.sDbnull(grdTestInfo.GetRow(i).Cells["TestType_ID"].Value) == (string)btn.Tag) { grdTestInfo.MoveTo(i); break; } } return; } string vBarcode = ""; DataRow drTestType = Utility.GetDataRow(dtTestTypeList, TTestTypeList.Columns.TestTypeId, btn.Tag); if (SysPara.AutoGenerateBarcode == 2 | (SysPara.AutoGenerateBarcode == 0 & dtTestInfo.Rows.Count == 0)) { frmInput_Update_Barcode oForm = new frmInput_Update_Barcode(); if (dtTestInfo.Rows.Count > 0) { oForm.txtBarcode.Text = Utility.sDbnull(grdTestInfo.GetValue("Barcode")); oForm.txtBarcode.SelectAll(); } oForm.vTestType_ID = vTestTypeId; oForm.txtTestType_Name.Text = Utility.sDbnull(drTestType["TestType_Name"]); oForm.ShowDialog(); if (string.IsNullOrEmpty(oForm.txtBarcode.Text)) { return; } vBarcode = oForm.txtBarcode.Text; } else if (dtTestInfo.Rows.Count > 0) { vBarcode = Utility.sDbnull(grdTestInfo.GetValue("Barcode")).Trim(); //count = new Select().From(TTestInfo.Schema).Where(TTestInfo.Columns.TestTypeId).IsEqualTo(vTestTypeId). // And(TTestInfo.Columns.Barcode).IsEqualTo(vBarcode).GetRecordCount(); //if (count > 0) //{ // Utility.ShowMsg("Barcode tồn tại. Mời nhập lại."); // return; //} } else { vBarcode = BarcodeInfo.GetBarcodeForPatient(patientId, vTestTypeId, drTestType[TTestTypeList.Columns.IntOrder].ToString()); if (vBarcode == "-1") { Utility.ShowMsg("Không tìm được Barcode"); return; } } string canlamsangid; LPatientInfo lPatientInfo = new Select().From(LPatientInfo.Schema.Name).Where(LPatientInfo.Columns.PatientId).IsEqualTo(patientId).ExecuteSingle <LPatientInfo>(); canlamsangid = lPatientInfo.CanLamSangId; var obj = new TTestInfo(); obj.TestTypeId = vTestTypeId; obj.Barcode = vBarcode; obj.PatientId = patientId; obj.TestDate = DateTime.Now; obj.RequireDate = DateTime.Now; obj.AssignId = Utility.Int32Dbnull(cboAssignDoctor.SelectedValue); obj.CanLamSangId = "OO" + DateTime.Now.ToString("yyMMdd") + "." + canlamsangid; obj.IsNew = true; obj.Save(); DataRow dr = dtTestInfo.NewRow(); dr[TTestInfo.Columns.TestId] = TTestInfo.CreateQuery().WHERE(TTestInfo.Columns.PatientId, patientId). WHERE(TTestInfo.Columns.TestTypeId, vTestTypeId).GetMax(TTestInfo.Columns.TestId); dr[TTestInfo.Columns.TestDate] = obj.TestDate; dr[TTestInfo.Columns.Barcode] = obj.Barcode; dr[TTestInfo.Columns.PatientId] = obj.PatientId; dr[TTestInfo.Columns.TestTypeId] = obj.TestTypeId; dr[TTestTypeList.Columns.TestTypeName] = drTestType[TTestTypeList.Columns.TestTypeName].ToString(); dr[TTestInfo.Columns.AssignId] = obj.AssignId; dr["AssignDoctor_Name"] = Utility.Int32Dbnull(cboAssignDoctor.SelectedValue) == -1 ? "" : cboAssignDoctor.Text; dtTestInfo.Rows.InsertAt(dr, 0); grdTestInfo.SelectionChanged -= grdTestInfo_SelectionChanged; dtTestInfo.AcceptChanges(); grdTestInfo.SelectionChanged += grdTestInfo_SelectionChanged; grdTestInfo.MoveFirst(); // Todo: xử lý sau khi nhấn nút đăng ký //Nếu ô đăng ký test có dl thì chuyển sang //if (flpTestGroup.Controls.Count > 0) flpTestGroup.Focus(); //else flpStandardTest.Focus(); } catch (Exception ex) { Utility.ShowMsg(ex.Message); } finally { FocusButtonDetail(); } }