/// <summary>
/// 根据病种设置库ID获取病种设置库实体信息
/// </summary>
/// <param name="templet_id"></param>
public DiseaseCFG GetDiseaseCFG(string markId)
{
DiseaseCFG diseaseCFG = new DiseaseCFG();
DataTable dt = GetDiagnosisOfChinese_Table(markId);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
diseaseCFG.Id = dr["Id"].ToString();
diseaseCFG.Mapid = dr["Mapid"].ToString();
diseaseCFG.Name = dr["Name"].ToString();
diseaseCFG.Py = dr["Py"].ToString();
diseaseCFG.Wb = dr["Wb"].ToString();
diseaseCFG.Diseaseid = dr["Diseaseid"].ToString();
diseaseCFG.Surgeryid = dr["Surgeryid"].ToString();
diseaseCFG.Category = dr["Category"].ToString();
diseaseCFG.Mark = dr["Mark"].ToString();
diseaseCFG.Parentid = dr["Parentid"].ToString();
diseaseCFG.Valid = Convert.ToInt32(dr["Valid"].ToString());
diseaseCFG.Memo = dr["Memo"].ToString();
}
return(diseaseCFG);
}
/// <summary>
/// 将gridview中对应行值加载到实体中
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private DiseaseCFG SetEntityByDataRow(DataRow dr)
{
if (dr == null)
{
return(null);
}
DiseaseCFG diseaseCFG = new DiseaseCFG();
diseaseCFG.Id = dr["Id"].ToString();
diseaseCFG.Mapid = dr["Mapid"].ToString();
diseaseCFG.Name = dr["Name"].ToString();
diseaseCFG.Py = dr["Py"].ToString();
diseaseCFG.Wb = dr["Wb"].ToString();
diseaseCFG.Diseaseid = dr["Diseaseid"].ToString();
diseaseCFG.Surgeryid = dr["Surgeryid"].ToString();
diseaseCFG.Category = dr["Category"].ToString();
diseaseCFG.Mark = dr["Mark"].ToString();
diseaseCFG.Parentid = dr["Parentid"].ToString();
diseaseCFG.Valid = Convert.ToInt32(dr["Valid"].ToString());
diseaseCFG.Memo = dr["Memo"].ToString();
return(diseaseCFG);
}
/// <summary>
/// 保存病种值
/// </summary>
/// <param name="diag"></param>
/// <returns></returns>
private bool SaveDiseaseCFG(DiseaseCFG diseaseCFG)
{
try
{
string edittype = "";
if (m_EditState == EditState.Add)
{
edittype = "1";
}
else
{
edittype = "2";
}
m_SysTableManger.SaveDiseaseCFG(diseaseCFG, edittype);
return(true);
}
catch (Exception e)
{
return(false);
}
}
/// <summary>
/// 保存病种设置库
/// </summary>
/// <param name="diagnosis">手术代码库实体</param>
/// <param name="editType">1:新增 2：修改</param>
/// <returns></returns>
public string SaveDiseaseCFG(DiseaseCFG diseaseCFG, string editType)
{
SqlParameter[] sqlParam = new SqlParameter[]
{
new SqlParameter("@EditType", SqlDbType.VarChar),
new SqlParameter("@ID", SqlDbType.VarChar),
new SqlParameter("@MapID", SqlDbType.VarChar),
new SqlParameter("@Name", SqlDbType.VarChar),
new SqlParameter("@Py", SqlDbType.VarChar),
new SqlParameter("@Wb", SqlDbType.VarChar),
new SqlParameter("@DiseaseID", SqlDbType.VarChar),
new SqlParameter("@SurgeryID", SqlDbType.VarChar),
new SqlParameter("@Category", SqlDbType.VarChar),
new SqlParameter("@Mark", SqlDbType.VarChar),
new SqlParameter("@ParentID", SqlDbType.VarChar),
new SqlParameter("@Valid", SqlDbType.VarChar),
new SqlParameter("@Memo", SqlDbType.VarChar)
};
sqlParam[0].Value = editType;
sqlParam[1].Value = diseaseCFG.Id;
sqlParam[2].Value = diseaseCFG.Mapid;
sqlParam[3].Value = diseaseCFG.Name;
sqlParam[4].Value = diseaseCFG.Py;
sqlParam[5].Value = diseaseCFG.Wb;
sqlParam[6].Value = diseaseCFG.Diseaseid;
sqlParam[7].Value = diseaseCFG.Surgeryid;
sqlParam[8].Value = diseaseCFG.Category;
sqlParam[9].Value = diseaseCFG.Mark;
sqlParam[10].Value = diseaseCFG.Parentid;
sqlParam[11].Value = diseaseCFG.Valid;
sqlParam[12].Value = diseaseCFG.Memo;
return(m_app.SqlHelper.ExecuteDataSet("EmrSysTable.usp_Edit_DiseaseCFG", sqlParam, CommandType.StoredProcedure).Tables[0].Rows[0][0].ToString());
}
/// <summary>
/// 将页面值加入到病种实体中
/// </summary>
/// <returns></returns>
private DiseaseCFG SetEntityByPageValue()
{
DiseaseCFG diseaseCFG = new DiseaseCFG();
diseaseCFG.Id = this.txtID.Text.Trim();
diseaseCFG.Mapid = this.txtMapID.Text.Trim();
diseaseCFG.Name = this.txtName.Text.Trim();
diseaseCFG.Py = this.txtPy.Text.Trim();
diseaseCFG.Wb = this.txtWb.Text.Trim();
diseaseCFG.Diseaseid = this.txtDiseaseID.Text.Trim();
diseaseCFG.Surgeryid = this.txtSurgeryID.Text.Trim();
diseaseCFG.Category = this.lookUpEditorCategory.CodeValue.Trim();
diseaseCFG.Mark = this.txtMark.Text.Trim();
diseaseCFG.Parentid = this.txtParentID.Text.Trim();
diseaseCFG.Valid = cmbValid.SelectedIndex;
diseaseCFG.Memo = this.txtMemo.Text.Trim();
return(diseaseCFG);
}
/// <summary>
/// 将病种实体中值加载到页面
/// </summary>
/// <param name="diagnosis"></param>
private void SetPageValue(DiseaseCFG diseaseCFG)
{
if (diseaseCFG == null || diseaseCFG.Id == "")
{
return;
}
this.txtID.Text = diseaseCFG.Id.Trim();
this.txtMapID.Text = diseaseCFG.Mapid.Trim();
this.txtName.Text = diseaseCFG.Name.Trim();
this.txtPy.Text = diseaseCFG.Py.Trim();
this.txtWb.Text = diseaseCFG.Wb.Trim();
this.txtDiseaseID.Text = diseaseCFG.Diseaseid.Trim();
this.txtSurgeryID.Text = diseaseCFG.Surgeryid.Trim();
this.lookUpEditorCategory.CodeValue = diseaseCFG.Category.Trim();
this.txtMark.Text = diseaseCFG.Mark.Trim();
this.txtParentID.Text = diseaseCFG.Parentid.Trim();
cmbValid.SelectedIndex = diseaseCFG.Valid;
this.txtMemo.Text = diseaseCFG.Memo.Trim();
}
/// <summary>
/// 根据传入病种设置库实体删除对应数据
/// </summary>
/// <param name="emrtemplet"></param>
/// <returns></returns>
public bool DelDiseaseCFG(DiseaseCFG diseaseCFG)
{
return(DelDiseaseCFG(diseaseCFG.Id));
}
