void btnTZLY_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.cbBoxTZLY.Text))
{
MessageBox.Show("请选择一个听诊器..");
return;
}
var stetInfo = Setting.GetStetInfoByStetName(this.cbBoxTZLY.Text);
var frmAudioRecord = new FrmAudioRecord()
{
PatientType = stetInfo.StetType,
StetName = this.cbBoxTZLY.Text
};
frmAudioRecord.ShowDialog();
LoadLocalPatientInfo();
}
void dgvTZLY_Local_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0 && e.ColumnIndex >= 0)
{
var PatientInfo = new
{
PatientGUID = dgvTZLY_Local.Rows[e.RowIndex].Cells[0].Value + ""
,
PatientType = dgvTZLY_Local.Rows[e.RowIndex].Cells[1].Value + ""
,
PatientName = dgvTZLY_Local.Rows[e.RowIndex].Cells[2].Value + ""
,
DocName = dgvTZLY_Local.Rows[e.RowIndex].Cells[3].Value + ""
,
DocDiagnose = dgvTZLY_Local.Rows[e.RowIndex].Cells[4].Value + ""
,
DocRemark = dgvTZLY_Local.Rows[e.RowIndex].Cells[5].Value + ""
};
switch (dgvTZLY_Local.Columns[e.ColumnIndex].Name)
{
case "dgvTZLYLoaclDetail":
{
var formAudioRecord = new FrmAudioRecord()
{
PatientType = Setting.GetPatientTypeByName(PatientInfo.PatientType.ToString())
,
StetName = this.cbBoxTZLY.Text,
PatientGUID = PatientInfo.PatientGUID,
PatientName = PatientInfo.PatientName,
DocName = PatientInfo.DocName,
DocDiagnose = PatientInfo.DocDiagnose,
DocRemark = PatientInfo.DocRemark,
CanEdit = false
};
formAudioRecord.ShowDialog();
LoadLocalPatientInfo();
}
break;
case "dgvTZLYLoaclDelete":
{
if (DialogResult.OK == MessageBox.Show("你确定要删除该记录及其文件吗", "删除录音提示", MessageBoxButtons.OKCancel))
{
string sqlDelP = "delete from PatientInfo where PatientGUID={0}";
var k = Mediator.sqliteHelper.ExecuteNonQuery(sqlDelP, PatientInfo.PatientGUID);
if (k > 0)
{
Mediator.ShowMsg(string.Format("删除患者{0}信息成功...", Path.GetFileName(PatientInfo.PatientName)));
string sqlQueryAudio = "select GUID ,RecordTime from AudioInfo where PGUID={0}";
var dt = Mediator.sqliteHelper.ExecuteDatatable(sqlQueryAudio, PatientInfo.PatientGUID);
string sqlDelAudio = "delete from AudioInfo where PGUID={0}";
var n = Mediator.sqliteHelper.ExecuteNonQuery(sqlDelAudio, PatientInfo.PatientGUID);
if (n > 0)
{
foreach (DataRow row in dt.Rows)
{
string guid = row["GUID"] + "";
DateTime recordTime = (DateTime)row["RecordTime"];
string filePath = Path.Combine(Setting.localData, @"DevicesData\AudioFiles\" + recordTime.Year
+ "\\" + recordTime.Month + "\\" + recordTime.Day + "\\" + guid + ".MP3");
if (File.Exists(filePath))
{
File.Delete(filePath);
Mediator.ShowMsg(string.Format("删除文件{0}成功...", Path.GetFileName(filePath)));
}
}
}
}
}
LoadLocalPatientInfo();
}
break;
}
}
}
