/// <summary>
/// 转换数据元的数据元所属类别属性
/// 0将汉字转数字 1将数字转汉字
/// </summary>
/// <param name="dataElementEntityList"></param>
/// <param name="Type"></param>
public void ConvertDataElemnetClass(DataElementEntity item, int Type)
{
var baseTypeList = CommonTabHelper.GetAllDataElemnetClass();
switch (Type)
{
case 0:
foreach (var basetype in baseTypeList)
{
if (basetype.Name == item.ElementClass)
{
item.ElementClass = basetype.Id;
}
}
break;
case 1:
foreach (var basetype in baseTypeList)
{
if (basetype.Id == item.ElementClass)
{
item.ElementClass = basetype.Name;
}
}
break;
default:
break;
}
}
/// <summary>
/// 编辑项目
/// </summary>
private void EditDataElement()
{
try
{
DataElementEntity dataElementEntity = gvDataElement.GetFocusedRow() as DataElementEntity;
int editindex = gvDataElement.FocusedRowHandle;
if (dataElementEntity == null)
{
//m_app.CustomMessageBox.MessageShow("未选中要编辑的项目");
//return;
throw new Exception("未选中要编辑的项目");
}
DataElementEntity dataElementEntityClone = dataElementEntity.Clone() as DataElementEntity;
dataElemntBiz.ConvertDataElemnetClass(dataElementEntityClone, 0);
dataElemntBiz.ConvertIsDataElementOne(dataElementEntityClone, 0);
if (dataElementEntityClone == null)
{
return;
}
AddTabControl(dataElementEntityClone);
gvDataElement.MoveBy(editindex);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 转换数据元的是否是卫生部发布属性
/// 0将汉字转数字 1将数字转汉字
/// </summary>
/// <param name="dataElementEntityList"></param>
/// <param name="Type">0将汉字转数字 1将数字转汉字</param>
public void ConvertIsDataElementOne(DataElementEntity item, int Type)
{
switch (Type)
{
case 0:
if (item.IsDataElemet == "是")
{
item.IsDataElemet = "1";
}
else if (item.IsDataElemet == "不是")
{
item.IsDataElemet = "0";
}
break;
case 1:
if (item.IsDataElemet == "0")
{
item.IsDataElemet = "不是";
}
else if (item.IsDataElemet == "1")
{
item.IsDataElemet = "是";
}
break;
default:
break;
}
}
//删除选中的信息
private void btnDel_Click(object sender, EventArgs e)
{
try
{
DataElementEntity dataElementEntity = gvDataElement.GetFocusedRow() as DataElementEntity;
if (dataElementEntity == null)
{
return;
}
DialogResult dialogResult = m_app.CustomMessageBox.MessageShow("确定要删除吗？", DrectSoft.Core.CustomMessageBoxKind.QuestionYesNo);
if (dialogResult == DialogResult.Yes)
{
string message = "";
bool result = dataElemntBiz.DelDataElement(dataElementEntity, ref message);
if (result)
{
m_app.CustomMessageBox.MessageShow("删除成功！");
SearchDateElement();
}
else
{
m_app.CustomMessageBox.MessageShow(message);
}
}
}
catch (Exception ex)
{
m_app.CustomMessageBox.MessageShow(ex.Message);
}
}
/// <summary>
/// 删除数据元
/// </summary>
/// <param name="dataElement"></param>
/// <param name="message"></param>
/// <returns></returns>
public bool DelDataElement(DataElementEntity dataElement, ref string message)
{
ConvertIsDataElementOne(dataElement, 0);
ConvertDataElemnetClass(dataElement, 0);
dataElement.Valid = "0";
bool result = UpDateElement(dataElement, ref message);
return(result);
}
private bool AddDateElement(DataElementEntity dataElement, ref string message)
{
bool validateResult = ValidateDateElement(dataElement.ElementId);
if (!validateResult)
{
message = "数据元ID存在，请重新输入";
return(false);
}
else
{
SqlParameter[] sqlParams = new SqlParameter[] {
new SqlParameter("@ElementFlow", SqlDbType.VarChar, 50),
new SqlParameter("@ElementId", SqlDbType.VarChar, 50),
new SqlParameter("@ElementName", SqlDbType.VarChar, 50),
new SqlParameter("@ElementType", SqlDbType.VarChar, 50),
new SqlParameter("@ElementForm", SqlDbType.VarChar, 50),
new SqlParameter("@ElementRange", SqlDbType.VarChar, 50),
new SqlParameter("@ElementDescribe", SqlDbType.VarChar, 50),
new SqlParameter("@ElementClass", SqlDbType.VarChar, 50),
new SqlParameter("@IsDataElemet", SqlDbType.VarChar, 50),
new SqlParameter("@ElementPYM", SqlDbType.VarChar, 50)
};
dataElement.ElementFlow = Guid.NewGuid().ToString();
dataElement.Valid = "1";
dataElement.ElementPYM = StringCommon.GetChineseSpell(dataElement.ElementName);
if (dataElement.ElementPYM == null || dataElement.ElementPYM == "")
{
dataElement.ElementPYM = dataElement.ElementName;
}
sqlParams[0].Value = dataElement.ElementFlow;
sqlParams[1].Value = dataElement.ElementId;
sqlParams[2].Value = dataElement.ElementName;
sqlParams[3].Value = dataElement.ElementType;
sqlParams[4].Value = dataElement.ElementForm;
sqlParams[5].Value = dataElement.ElementRange;
sqlParams[6].Value = dataElement.ElementDescribe;
sqlParams[7].Value = dataElement.ElementClass;
sqlParams[8].Value = dataElement.IsDataElemet;
sqlParams[9].Value = dataElement.ElementPYM;
try
{
m_app.SqlHelper.ExecuteNoneQuery("EMR_CommonNote.usp_InsertElement", sqlParams, CommandType.StoredProcedure);
}
catch (Exception ex)
{
message = ex.Message;
return(false);
}
return(true);
}
}
/// <summary>
/// 通过流水号获取数据元
/// </summary>
/// <param name="dataElementFlow"></param>
/// <returns></returns>
public DataElementEntity GetDataElement(string dataElementFlow)
{
SqlParameter[] sqlParams = new SqlParameter[] {
new SqlParameter("@ElementFlow", SqlDbType.VarChar, 50)
};
sqlParams[0].Value = dataElementFlow;
DataTable dataTableElement = m_app.SqlHelper.ExecuteDataTable("EMR_CommonNote.usp_GetDateElementOne", sqlParams, CommandType.StoredProcedure);
DataElementEntity dataElementEntity = DataTableToList <DataElementEntity> .ConvertToModelOne(dataTableElement);
return(dataElementEntity);
}
/// <summary>
/// 保存数据元 包括修改和添加
/// </summary>
/// <param name="dataElement"></param>
/// <param name="message"></param>
/// <returns></returns>
public bool SaveDataElement(DataElementEntity dataElement, ref string message)
{
bool result = true;
if (string.IsNullOrEmpty(dataElement.ElementFlow))
{
result = AddDateElement(dataElement, ref message);
}
else
{
result = UpDateElement(dataElement, ref message);
}
return(result);
}
public DataElementInfo(DataElementEntity dataElementEntity, IEmrHost app)
{
try
{
m_dataElementEntity = dataElementEntity;
m_app = app;
InitializeComponent();
InitData();
InitDataElement();
}
catch (Exception ex)
{
throw ex;
}
}
//数据元改变时触发事件 对CommonNote_ItemEntity进行赋值
private void repositoryItemSearchLookUpEdit1_EditValueChanged(object sender, EventArgs e)
{
try
{
SearchLookUpEdit searchLookUpEdit = sender as SearchLookUpEdit;
DataElementEntity dataElementEntity = searchLookUpEdit.Properties.View.GetFocusedRow() as DataElementEntity;
CommonNote_ItemEntity commonNote_Item = gvCommonItem.GetFocusedRow() as CommonNote_ItemEntity;
if (dataElementEntity != null && commonNote_Item != null)
{
commonNote_Item.DataElementName = dataElementEntity.ElementName;
commonNote_Item.DataElementId = dataElementEntity.ElementId;
commonNote_Item.DataElementFlow = dataElementEntity.ElementFlow;
commonNote_Item.OtherName = dataElementEntity.ElementName;
}
}
catch (Exception ex)
{
MyMessageBox.Show(1, ex);
}
}
/// <summary>
/// 获取所有数据元
/// </summary>
private void GetAllDataElement()
{
try
{
//将所有数据元都取出来 需要改进 点find按钮是获取
DataElementEntity dataElementEntity = new DataElementEntity();
dataElementEntity.ElementId = "";
dataElementEntity.ElementName = "";
dataElementEntity.ElementPYM = "";
dataElementEntity.ElementClass = "";
DataElemntBiz dataElemntBiz = new CommonTableConfig.DataElemntBiz(m_app);
if (CommonTabHelper.DataElementListAll == null)
{
CommonTabHelper.DataElementListAll = dataElemntBiz.GetDataElement(dataElementEntity);
}
repositoryItemSearchLookUpEdit1.DataSource = CommonTabHelper.DataElementListAll;
}
catch (Exception ex)
{
throw ex;
}
}
//打开一个数据元详情标签 包括修改和新增
private void AddTabControl(DataElementEntity dataElementEntity)
{
try
{
XtraTabPage tabpage = new XtraTabPage();
uCDataElementInfo = new DataElementInfo(dataElementEntity, m_app);
uCDataElementInfo.btnSave.Click += new EventHandler(btnSave_Click);
tabpage.Tag = dataElementEntity;
if (string.IsNullOrEmpty(dataElementEntity.ElementFlow))
{
uCDataElementInfo.Text = "新增数据元";
}
else
{
uCDataElementInfo.Text = "编辑" + dataElementEntity.ElementName;
}
uCDataElementInfo.ShowDialog();
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 根据条件获取数据元 用于展示
/// </summary>
/// <param name="dataElementSearch"></param>
/// <returns></returns>
public List <DataElementEntity> GetDataElement(DataElementEntity dataElementSearch)
{
SqlParameter[] sqlParams = new SqlParameter[] {
new SqlParameter("@ElementId", SqlDbType.VarChar, 50),
new SqlParameter("@ElementName", SqlDbType.VarChar, 50),
new SqlParameter("@ElementClass", SqlDbType.VarChar, 50),
new SqlParameter("@ElementPYM", SqlDbType.VarChar, 50)
};
if (dataElementSearch.ElementPYM == null)
{
dataElementSearch.ElementPYM = "";
}
dataElementSearch.ElementPYM = dataElementSearch.ElementPYM.ToUpper();
sqlParams[0].Value = dataElementSearch.ElementId;
sqlParams[1].Value = dataElementSearch.ElementName;
sqlParams[2].Value = dataElementSearch.ElementClass;
sqlParams[3].Value = dataElementSearch.ElementPYM;
DataTable dataTableElement = m_app.SqlHelper.ExecuteDataTable("EMR_CommonNote.usp_GetDateElement", sqlParams, CommandType.StoredProcedure);
List <DataElementEntity> dataElementEntityList = DataTableToList <DataElementEntity> .ConvertToModel(dataTableElement);
ConvertIsDataElementPropery(dataElementEntityList, 1);
ConvertDataElemnetClass(dataElementEntityList, 1);
return(dataElementEntityList);
}
