public static bool Add_emr_image(emr_imageMdl model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into emr_image(");
strSql.Append("guid,emr_guid,img_type,img_content,thumbnail,img_url)");
strSql.Append(" values (");
strSql.Append("@guid,@emr_guid,@img_type,@img_content,@thumbnail,@img_url)");
SqlParameter[] parameters =
{
new SqlParameter("@guid", SqlDbType.VarChar, 36),
new SqlParameter("@emr_guid", SqlDbType.VarChar, 36),
new SqlParameter("@img_type", SqlDbType.Int, 4),
new SqlParameter("@img_content", SqlDbType.VarBinary, -1),
new SqlParameter("@thumbnail", SqlDbType.VarBinary, -1),
new SqlParameter("@img_url", SqlDbType.NVarChar, 512)
};
parameters[0].Value = model.guid;
parameters[1].Value = model.emr_guid;
parameters[2].Value = model.img_type;
parameters[3].Value = model.img_content;
parameters[4].Value = model.thumbnail;
parameters[5].Value = model.img_url;
int rows = SqlHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
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 = "";
}