/// <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)); }