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