/// <summary>
/// 保存中医诊断库信息
/// </summary>
/// <param name="diagnosis">中医诊断库实体</param>
/// <param name="editType">1:新增 2：修改</param>
/// <returns></returns>
public string SaveDiagnosisOfChinese(DiagnosisOfChinese diagnosis, 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("@Valid", SqlDbType.VarChar),
new SqlParameter("@Memo", SqlDbType.VarChar),
new SqlParameter("@Memo1", SqlDbType.VarChar),
new SqlParameter("@Category", SqlDbType.VarChar)
};
sqlParam[0].Value = editType;
sqlParam[1].Value = diagnosis.Id;
sqlParam[2].Value = diagnosis.Mapid;
sqlParam[3].Value = diagnosis.Name;
sqlParam[4].Value = diagnosis.Py;
sqlParam[5].Value = diagnosis.Wb;
sqlParam[6].Value = diagnosis.Valid;
sqlParam[7].Value = diagnosis.Memo;
sqlParam[8].Value = diagnosis.Memo1;
sqlParam[9].Value = diagnosis.Category;
return(m_app.SqlHelper.ExecuteDataSet("EmrSysTable.usp_Edit_DiagnosisOfChinese", sqlParam, CommandType.StoredProcedure).Tables[0].Rows[0][0].ToString());
}
/// <summary>
/// 将页面值加入到诊断实体中
/// </summary>
/// <returns></returns>
private DiagnosisOfChinese SetEntityByPageValue()
{
DiagnosisOfChinese diagnosis = new DiagnosisOfChinese();
diagnosis.Id = this.txtID.Text.Trim();
diagnosis.Mapid = this.txtMapID.Text.Trim();
diagnosis.Name = this.txtName.Text.Trim();
diagnosis.Py = this.txtPy.Text.Trim();
diagnosis.Wb = this.txtWb.Text.Trim();
diagnosis.Valid = this.cmbValid.SelectedIndex;
diagnosis.Memo = this.txtMemo.Text.Trim();
diagnosis.Memo1 = this.txtMemo1.Text.Trim();
diagnosis.Category = this.lookUpEditorCategory.CodeValue.Trim();
return(diagnosis);
}
/// <summary>
/// 将诊断实体中值加载到页面
/// </summary>
/// <param name="diagnosis"></param>
private void SetPageValue(DiagnosisOfChinese diagnosis)
{
if (diagnosis == null || diagnosis.Id == "")
{
return;
}
this.txtID.Text = diagnosis.Id.Trim();
this.txtMapID.Text = diagnosis.Mapid.Trim();
this.txtName.Text = diagnosis.Name.Trim();
this.txtPy.Text = diagnosis.Py.Trim();
this.txtWb.Text = diagnosis.Wb.Trim();
this.cmbValid.SelectedIndex = diagnosis.Valid;
this.txtMemo.Text = diagnosis.Memo.Trim();
this.txtMemo1.Text = diagnosis.Memo1.Trim();
this.lookUpEditorCategory.CodeValue = diagnosis.Category.Trim();
}
/// <summary>
/// 保存诊断值
/// </summary>
/// <param name="diag"></param>
/// <returns></returns>
private bool SaveDiagnosis(DiagnosisOfChinese diag)
{
try
{
string edittype = "";
if (m_EditState == EditState.Add)
{
edittype = "1";
}
else
{
edittype = "2";
}
m_SysTableManger.SaveDiagnosisOfChinese(diag, edittype);
return(true);
}
catch (Exception e)
{
return(false);
}
}
/// <summary>
/// 将gridview中对应行值加载到实体中
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private DiagnosisOfChinese SetEntityByDataRow(DataRow dr)
{
if (dr == null)
{
return(null);
}
DiagnosisOfChinese diagnosis = new DiagnosisOfChinese();
diagnosis.Id = dr["Id"].ToString();
diagnosis.Mapid = dr["Mapid"].ToString();
diagnosis.Name = dr["Name"].ToString();
diagnosis.Py = dr["Py"].ToString();
diagnosis.Wb = dr["Wb"].ToString();
diagnosis.Valid = Convert.ToInt32(dr["Valid"].ToString());
diagnosis.Memo = dr["Memo"].ToString();
diagnosis.Memo1 = dr["Memo1"].ToString();
diagnosis.Category = dr["Category"].ToString();
return(diagnosis);
}
/// <summary>
/// 根据模板ID获取模板信息
/// </summary>
/// <param name="templet_id"></param>
public DiagnosisOfChinese GetDiagnosisOfChinese(string markId)
{
DiagnosisOfChinese diagnosis = new DiagnosisOfChinese();
DataTable dt = GetDiagnosisOfChinese_Table(markId);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
diagnosis.Id = dr["Id"].ToString();
diagnosis.Mapid = dr["Mapid"].ToString();
diagnosis.Name = dr["Name"].ToString();
diagnosis.Py = dr["Py"].ToString();
diagnosis.Wb = dr["Wb"].ToString();
diagnosis.Valid = Convert.ToInt32(dr["Valid"].ToString());
diagnosis.Memo = dr["Memo"].ToString();
diagnosis.Memo1 = dr["Memo1"].ToString();
diagnosis.Category = dr["Category"].ToString();
}
return(diagnosis);
}
/// <summary>
/// 根据传入诊断实体删除对应数据
/// </summary>
/// <param name="emrtemplet"></param>
/// <returns></returns>
public bool DelDiagnosisOfChinese(DiagnosisOfChinese diag)
{
return(DelDiagnosisOfChinese(diag.Id));
}
