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