private void layoutView1_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
if (e.FocusedRowHandle < 0)
{
return;
}
DataRow dataRow = layoutView1.GetDataRow(e.FocusedRowHandle);
if (dataRow == null)
{
return;
}
//check
if ((EmrDept2Hosptial != null) && (EmrDept2Hosptial.GetChanges() != null))
{
if (m_app.CustomMessageBox.MessageShow("数据已修改过，是否需要保存？", CustomMessageBoxKind.QuestionYesNo) == System.Windows.Forms.DialogResult.OK)
{
SaveMyDepts();
return;
}
}
m_currentHisDeptid = dataRow["ID"].ToString();
GetHIS2EMRDEPTS(m_currentHisDeptid);
labelControlTip.Text = "科室：" + dataRow["NAME"].ToString().Trim();
labelControlTip.Visible = true;
OperDeptID = m_currentHisDeptid;
}
private void Add2MyDepts(string emrid, string emrName, string hisid)
{
//added by ywk 2012年3月8日14:39:14
string sql = string.Format(@" select * from emrdept2his where emr_dept_id
='{0}' and his_dept_id='{1}' ", emrid, hisid);
DataTable Mydt = m_app.SqlHelper.ExecuteDataTable(sql);//获得datatable
if (Mydt.Rows.Count > 0)
{
//已存在的对应关系，不重复加入
//m_app.CustomMessageBox.MessageShow("对不起，该对应关系已经存在！");
return;
}
DataRow[] rows = EmrDept2Hosptial.Select("EMR_DEPT_ID='" + emrid + "'");
if (rows.Length > 0)
{
return;
}
treeList_MyDepts.BeginUnboundLoad();
DataRow newRow = EmrDept2Hosptial.NewRow();
newRow["EMR_DEPT_ID"] = emrid;
newRow["dept_name"] = emrName;
newRow["HIS_DEPT_ID"] = hisid;
EmrDept2Hosptial.Rows.Add(newRow);
TreeListNode node = treeList_MyDepts.AppendNode(new object[] { newRow["dept_name"] }, null);
node.Tag = newRow;
treeList_MyDepts.EndUnboundLoad();
}
/// <summary>
/// 保存操作
/// </summary>
void SaveMyDepts()
{
try
{
//保存科室信息
DataTable updateTable = EmrDept2Hosptial.Copy();
//消除不关闭窗体，多次保存此处删除列的错误edit by ywk 2012年4月16日
if (updateTable.Columns.Contains("DEPT_NAME"))
{
updateTable.Columns.Remove("DEPT_NAME");
//updateTable.AcceptChanges();
}
if (DeletedTable.Columns.Contains("DEPT_NAME"))
{
DeletedTable.Columns.Remove("DEPT_NAME");
//DeletedTable.AcceptChanges();
}
m_app.SqlHelper.UpdateTable(updateTable, "EMRDEPT2HIS", true, DeletedTable);
//保存模板信息
DataTable updateTemplet = EmrMyTemplet.Copy();
if (updateTemplet.Columns.Contains("MR_NAME"))
{
updateTemplet.Columns.Remove("MR_NAME");
}
if (DeleteTemplTable.Columns.Contains("MR_NAME"))
{
DeleteTemplTable.Columns.Remove("MR_NAME");//新增的记录删除数据的表
}
m_app.SqlHelper.UpdateTable(updateTemplet, "TEMPLET2HISDEPT", true, DeleteTemplTable);
m_app.CustomMessageBox.MessageShow("保存成功");
}
catch (Exception ex)
{
m_app.CustomMessageBox.MessageShow(ex.Message);
}
}
