protected void btnSave_Click(object sender, EventArgs e)
{
emr_indexMdl emr_indexMdl = new emr_indexMdl();
emr_indexMdl.guid = Guid.NewGuid().ToString();
emr_indexMdl.patient_guid = this.hidPatientGUID.Value;
emr_indexMdl.type_guid = this.ddlEMRType.SelectedValue;
emr_indexMdl.type_name = this.ddlEMRType.SelectedItem.Text;
emr_indexMdl.content = this.txtContent.Text;
if (this.hidEMRImageURL.Value != "" && File.Exists(this.hidEMRImageURL.Value))
{
emr_indexMdl.img_count = 1;
}
else
{
emr_indexMdl.img_count = 0;
}
// Save EMR Basic
EMR_PatientMdlDAL.Add_emr_index(emr_indexMdl);
if (this.hidEMRImageURL.Value != "" && File.Exists(this.hidEMRImageURL.Value))
{
emr_imageMdl emr_imageMdl = new emr_imageMdl();
emr_imageMdl.guid = Guid.NewGuid().ToString();
emr_imageMdl.emr_guid = emr_indexMdl.guid;
emr_imageMdl.img_type = 0;
emr_imageMdl.img_content = File.ReadAllBytes(this.hidEMRImageURL.Value);
emr_imageMdl.thumbnail = ImageUtils.getThumbnail(emr_imageMdl.img_content);
// Save EMR Image
EMR_PatientMdlDAL.Add_emr_image(emr_imageMdl);
}
// Clear filter
this.hidFilterType.Value = "";
// After save, refresh the EMR list
this.RefreshEMRListByPatientUidAndEMRType();
// Clear input
this.txtContent.Text = "";
this.txtContent_t.Text = "";
this.litEMRImg.Text = "";
}
public static bool Add_emr_index(emr_indexMdl model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into emr_index(");
strSql.Append("guid,patient_guid,type_guid,type_name,img_count,content,content_t,hospital,hospital_t,created_dt,modified_dt)");
strSql.Append(" values (");
strSql.Append("@guid,@patient_guid,@type_guid,@type_name,@img_count,@content,@content_t,@hospital,@hospital_t,getdate(),getdate())");
SqlParameter[] parameters =
{
new SqlParameter("@guid", SqlDbType.VarChar, 36),
new SqlParameter("@patient_guid", SqlDbType.VarChar, 36),
new SqlParameter("@type_guid", SqlDbType.VarChar, 36),
new SqlParameter("@type_name", SqlDbType.VarChar, 64),
new SqlParameter("@img_count", SqlDbType.Int, 4),
new SqlParameter("@content", SqlDbType.NVarChar, -1),
new SqlParameter("@content_t", SqlDbType.NVarChar, -1),
new SqlParameter("@hospital", SqlDbType.NVarChar, 256),
new SqlParameter("@hospital_t", SqlDbType.NVarChar, 256)
};
parameters[0].Value = model.guid;
parameters[1].Value = model.patient_guid;
parameters[2].Value = model.type_guid;
parameters[3].Value = model.type_name;
parameters[4].Value = model.img_count;
parameters[5].Value = model.content;
parameters[6].Value = model.content_t;
parameters[7].Value = model.hospital;
parameters[8].Value = model.hospital_t;
int rows = SqlHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
