/// <summary> /// 获取指定的条件的知识库记录 /// </summary> /// <param name="VISC_NAME"></param> /// <param name="DESC_NAME"></param> /// <param name="IMAGE_NAME"></param> /// <returns></returns> public override IModel GetModel(string VISC_NAME, string DESC_NAME, string IMAGE_NAME) { strSql = "select * from " + TableName + " where VISC_NAME='" + VISC_NAME + "' and DESC_NAME = '" + DESC_NAME + "' and IMAGE_NAME ='" + IMAGE_NAME + "'"; DataTable dt = GetDataTable(strSql); if (dt.Rows.Count == 0) { return(null); } MKnowledgeBase mKnowledgeBase = new MKnowledgeBase(); mKnowledgeBase.CLINIC_OFFICE_CODE = dt.Rows[0]["CLINIC_OFFICE_CODE"].ToString(); mKnowledgeBase.IMAGE_COMMENT = dt.Rows[0]["IMAGE_COMMENT"].ToString(); mKnowledgeBase.DESC_NAME = dt.Rows[0]["DESC_NAME"].ToString(); mKnowledgeBase.IMAGE_NAME = dt.Rows[0]["IMAGE_NAME"].ToString(); mKnowledgeBase.IMAGE_DATA = (byte[])dt.Rows[0]["IMAGE_DATA"]; mKnowledgeBase.VISC_NAME = dt.Rows[0]["VISC_NAME"].ToString(); if (dt.Rows[0]["IMAGE_INDEX"].ToString() == "") { mKnowledgeBase.IMAGE_INDEX = null; } else { mKnowledgeBase.IMAGE_INDEX = Convert.ToInt32(dt.Rows[0]["IMAGE_INDEX"].ToString()); } return(mKnowledgeBase); }
/// <summary> /// 查询是否存在指定的知识库记录 /// </summary> /// <param name="iknowledgeBase"></param> /// <returns></returns> public override bool Exists(IModel iknowledgeBase) { MKnowledgeBase mKnowledgeBase = (MKnowledgeBase)iknowledgeBase; strSql = "select * from " + TableName + " where VISC_NAME='" + mKnowledgeBase.VISC_NAME + "' and DESC_NAME = '" + mKnowledgeBase.DESC_NAME + "' and IMAGE_NAME ='" + mKnowledgeBase.IMAGE_NAME + "'"; return(recordIsExist(strSql)); }
private void dgv_KnowledgeBase_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { //string sql = " VISC_NAME='" + cmb_VISC_NAME.Text + "' AND DESC_NAME='" + cmb_DESC_NAME.Text + "' AND image_name='" + dgv_KnowledgeBase.Rows[e.RowIndex].Cells["IMAGE_NAME"].Value.ToString() + "' ORDER BY IMAGE_INDEX"; //DataTable dt = bklBase.GetList(sql); if (e.RowIndex >= 0) { btn_Clean_Click(null, null); mkb = new MKnowledgeBase(); mkb.VISC_NAME = cmb_VISC_NAME.Text; mkb.DESC_NAME = cmb_DESC_NAME.Text; txt_VISC_NAME.Text = cmb_VISC_NAME.Text; txt_DESC_NAME.Text = cmb_DESC_NAME.Text; txt_IMAGE_NAME.Text = dgv_KnowledgeBase.Rows[e.RowIndex].Cells["IMAGE_NAME"].Value.ToString(); if (!string.IsNullOrEmpty(dgv_KnowledgeBase.Rows[e.RowIndex].Cells["IMAGE_DATA"].Value.ToString())) { pb_Image.Image = SIS_Function.ImageOpe.ByteToImage((byte[])dgv_KnowledgeBase.Rows[e.RowIndex].Cells["IMAGE_DATA"].Value); } if (!string.IsNullOrEmpty(dgv_KnowledgeBase.Rows[e.RowIndex].Cells["IMAGE_INDEX"].Value.ToString())) { nud_IMAGE_INDEX.Value = Convert.ToInt32(dgv_KnowledgeBase.Rows[e.RowIndex].Cells["IMAGE_INDEX"].Value.ToString()); } if (!string.IsNullOrEmpty(dgv_KnowledgeBase.Rows[e.RowIndex].Cells["IMAGE_COMMENT"].Value.ToString())) { txt_COMMENT.Text = dgv_KnowledgeBase.Rows[e.RowIndex].Cells["IMAGE_COMMENT"].Value.ToString(); } if (!string.IsNullOrEmpty(dgv_KnowledgeBase.Rows[e.RowIndex].Cells["CLINIC_OFFICE_CODE"].Value.ToString())) { cmb_CLINIC_OFFICE_CODE.SelectedValue = dgv_KnowledgeBase.Rows[e.RowIndex].Cells["CLINIC_OFFICE_CODE"].Value.ToString(); } } }
private MKnowledgeBase GetValue() { MKnowledgeBase MKB = new MKnowledgeBase(); if (!string.IsNullOrEmpty(txt_VISC_NAME.Text.Trim())) { MKB.VISC_NAME = txt_VISC_NAME.Text.Trim(); } else { MessageBoxEx.Show("脏器不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return(null); } if (!string.IsNullOrEmpty(txt_DESC_NAME.Text.Trim())) { MKB.DESC_NAME = txt_DESC_NAME.Text.Trim(); } else { MessageBoxEx.Show("病种不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return(null); } MKB.IMAGE_INDEX = Convert.ToInt32(nud_IMAGE_INDEX.Text); if (!string.IsNullOrEmpty(txt_IMAGE_NAME.Text.Trim())) { MKB.IMAGE_NAME = txt_IMAGE_NAME.Text.Trim(); } else { MessageBoxEx.Show("图像名称不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return(null); } if (!string.IsNullOrEmpty(cmb_CLINIC_OFFICE_CODE.SelectedValue.ToString())) { MKB.CLINIC_OFFICE_CODE = cmb_CLINIC_OFFICE_CODE.SelectedValue.ToString(); } if (!string.IsNullOrEmpty(txt_COMMENT.Text.Trim())) { MKB.IMAGE_COMMENT = txt_COMMENT.Text.Trim(); } if (pb_Image.Image != null) { System.IO.MemoryStream ms = new System.IO.MemoryStream(); pb_Image.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); byte[] ArrBy = ms.GetBuffer(); MKB.IMAGE_DATA = ArrBy; } return(MKB); }
/// <summary> /// 插入一条知识库记录 /// </summary> /// <param name="iknowledgeBase"></param> /// <returns></returns> public override int Add(IModel iknowledgeBase) { MKnowledgeBase mKnowledgeBase = (MKnowledgeBase)iknowledgeBase; Hashtable ht = new Hashtable(); ht.Add("CLINIC_OFFICE_CODE", mKnowledgeBase.CLINIC_OFFICE_CODE); ht.Add("IMAGE_COMMENT", mKnowledgeBase.IMAGE_COMMENT); ht.Add("DESC_NAME", mKnowledgeBase.DESC_NAME); ht.Add("IMAGE_NAME", mKnowledgeBase.IMAGE_NAME); ht.Add("IMAGE_DATA", mKnowledgeBase.IMAGE_DATA); ht.Add("IMAGE_INDEX", mKnowledgeBase.IMAGE_INDEX); ht.Add("VISC_NAME", mKnowledgeBase.VISC_NAME); return(ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString(), ht)); }
private void btn_Save_Click(object sender, EventArgs e) { MKnowledgeBase Imkb = GetValue(); if (Imkb == null) { return; } bool bl = bklBase.Exists(Imkb); if (bl) { int i = bklBase.Update(Imkb, " where VISC_NAME='" + Imkb.VISC_NAME + "' and DESC_NAME='" + Imkb.DESC_NAME + "' and IMAGE_NAME='" + Imkb.IMAGE_NAME + "'"); if (i >= 0) { MessageBoxEx.Show("修改成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); cmb_VISC_NAME_SelectedIndexChanged(null, null); btn_Clean_Click(null, null); } else { MessageBoxEx.Show("修改失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { int i = bklBase.Add(Imkb); if (i > 0) { MessageBoxEx.Show("添加成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); cmb_VISC_NAME_SelectedIndexChanged(null, null); btn_Clean_Click(null, null); } else { MessageBoxEx.Show("添加失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }