/// <summary> /// 查询是否存在指定的打印模板记录 /// </summary> /// <param name="iPrintTemplateDict"></param> /// <returns></returns> public override bool Exists(IModel iPrintTemplateDict) { MPrintTemplateDict mPrintTemplateDict = (MPrintTemplateDict)iPrintTemplateDict; strSql = "select PRINT_TEMPLATE_ID from " + TableName + " where PRINT_TEMPLATE_ID=" + mPrintTemplateDict.PRINT_TEMPLATE_ID; return(recordIsExist(strSql)); }
private void btn_Ok_Click(object sender, EventArgs e) { string temps = ""; for (int i = 0; i < this.dgv_PrintTemplate.Rows.Count; i++) { if (this.dgv_PrintTemplate.Rows[i].Cells["IS_DEFAULT"].Value.ToString() == "是") { temps += this.dgv_PrintTemplate.Rows[i].Cells["EXAM_CLASS"].Value.ToString() + "," + this.dgv_PrintTemplate.Rows[i].Cells["EXAM_SUB_CLASS"].Value.ToString() + "," + this.dgv_PrintTemplate.Rows[i].Cells["PRINT_TEMPLATE"].Value.ToString() + "|"; } } GetConfig.SetRS_DefPrintTemp(temps.TrimEnd('|')); if (this.dgv_PrintTemplate.SelectedRows.Count > 0) { //if (this.dgv_PrintTemplate.SelectedRows[0].Cells["EXAM_CLASS"].Value.ToString() == this.temp.ExamClass && // this.dgv_PrintTemplate.SelectedRows[0].Cells["EXAM_SUB_CLASS"].Value.ToString() == this.temp.ExamSubClass && // this.dgv_PrintTemplate.SelectedRows[0].Cells["PRINT_TEMPLATE"].Value.ToString() != this.temp.TemplateName) if (this.dgv_PrintTemplate.SelectedRows[0].Cells["EXAM_CLASS"].Value.ToString() == this.temp.ExamClass && this.dgv_PrintTemplate.SelectedRows[0].Cells["EXAM_SUB_CLASS"].Value.ToString() == this.temp.ExamSubClass) { string filter = "PRINT_TEMPLATE_ID=" + this.dgv_PrintTemplate.SelectedRows[0].Cells["PRINT_TEMPLATE_ID"].Value.ToString(); DataRow dr = ((DataTable)this.dgv_PrintTemplate.DataSource).Select(filter)[0]; BPrintTemplateDict bpt = new BPrintTemplateDict(); this.mpt = (MPrintTemplateDict)bpt.GetModel(dr); } } this.DialogResult = DialogResult.OK; }
private void btn_New_Click(object sender, EventArgs e) { if (!CheckInput()) { return; } this.mPrint = new MPrintTemplateDict(); try { word.ProtectWord(); } catch { } try { mPrint.FIELD_INF = word.GetWordCells(); mPrint.FILE_NAME = GetFile(); } catch (Exception ex) { MessageBox.Show(ex.Message + "Word文档不可为空或不符合规范,请创建或修改!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } mPrint.PRINT_TEMPLATE_ID = int.Parse(new ILL.DGetSeqValue("SIS", "SEQ_PRINT_TEMPLATE_ID").GetSeqValue()); mPrint.EXAM_CLASS = cmb_ExamClass.Text; mPrint.EXAM_SUB_CLASS = cmb_ExamSubClass.Text; mPrint.FILE_DATE_TIME = DateTime.Now; mPrint.PRINT_TEMPLATE = tx_TempName.Text; bPrint.Add(mPrint); MessageBox.Show("添加成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); DgvBind(); }
private void cmb_ExamClass_SelectedIndexChanged(object sender, EventArgs e) { this.cmb_ExamSubClass.DataSource = bExamClass.GetList(" exam_class='" + this.cmb_ExamClass.Text + "'"); this.cmb_ExamSubClass.DisplayMember = "EXAM_SUB_CLASS"; this.cmb_ExamSubClass.ValueMember = "EXAM_SUB_CLASS"; this.cmb_ExamSubClass.SelectedIndex = -1; this.mPrint = null; }
/// <summary> /// 获取指定行的打印模板记录 /// </summary> /// <param name="dr"></param> /// <returns></returns> public override IModel GetModel(DataRow dr) { MPrintTemplateDict mPrintTemplateDict = new MPrintTemplateDict(); mPrintTemplateDict.EXAM_CLASS = dr["EXAM_CLASS"].ToString(); mPrintTemplateDict.EXAM_SUB_CLASS = dr["EXAM_SUB_CLASS"].ToString(); mPrintTemplateDict.FILE_NAME = (byte[])dr["FILE_NAME"]; mPrintTemplateDict.PRINT_TEMPLATE = dr["PRINT_TEMPLATE"].ToString(); mPrintTemplateDict.FIELD_INF = dr["FIELD_INF"].ToString(); mPrintTemplateDict.PRINT_TEMPLATE_ID = Convert.ToInt32(dr["PRINT_TEMPLATE_ID"].ToString()); mPrintTemplateDict.FILE_DATE_TIME = Convert.ToDateTime(dr["FILE_DATE_TIME"].ToString()); return(mPrintTemplateDict); }
/// <summary> /// 插入一条打印模板记录 /// </summary> /// <param name="iPrintTemplateDict"></param> /// <returns></returns> public override int Add(IModel iPrintTemplateDict) { MPrintTemplateDict mPrintTemplateDict = (MPrintTemplateDict)iPrintTemplateDict; Hashtable ht = new Hashtable(); ht.Add("EXAM_CLASS", mPrintTemplateDict.EXAM_CLASS); ht.Add("EXAM_SUB_CLASS", mPrintTemplateDict.EXAM_SUB_CLASS); ht.Add("FILE_NAME", mPrintTemplateDict.FILE_NAME); ht.Add("PRINT_TEMPLATE", mPrintTemplateDict.PRINT_TEMPLATE); ht.Add("PRINT_TEMPLATE_ID", mPrintTemplateDict.PRINT_TEMPLATE_ID); ht.Add("FIELD_INF", mPrintTemplateDict.FIELD_INF); ht.Add("FILE_DATE_TIME", mPrintTemplateDict.FILE_DATE_TIME); return(ExecuteSql(StringConstructor.InsertSql(TableName, ht), ht)); }
/// <summary> /// 获取指定检查类别、检查子类的打印模板记录 /// </summary> /// <param name="EXAM_CLASS"></param> /// <param name="EXAM_SUB_CLASS"></param> /// <returns></returns> public override IModel GetModel(string EXAM_CLASS, string EXAM_SUB_CLASS) { strSql = "select * from " + TableName + " where EXAM_CLASS = '" + EXAM_CLASS + "' and EXAM_SUB_CLASS='" + EXAM_SUB_CLASS + "'"; DataTable dt = GetDataTable(strSql); if (dt.Rows.Count == 0) { return(null); } MPrintTemplateDict mPrintTemplateDict = new MPrintTemplateDict(); mPrintTemplateDict.EXAM_CLASS = dt.Rows[0]["EXAM_CLASS"].ToString(); mPrintTemplateDict.EXAM_SUB_CLASS = dt.Rows[0]["EXAM_SUB_CLASS"].ToString(); mPrintTemplateDict.FILE_NAME = (byte[])dt.Rows[0]["FILE_NAME"]; mPrintTemplateDict.PRINT_TEMPLATE = dt.Rows[0]["PRINT_TEMPLATE"].ToString(); mPrintTemplateDict.FIELD_INF = dt.Rows[0]["FIELD_INF"].ToString(); mPrintTemplateDict.PRINT_TEMPLATE_ID = Convert.ToInt32(dt.Rows[0]["PRINT_TEMPLATE_ID"].ToString()); mPrintTemplateDict.FILE_DATE_TIME = Convert.ToDateTime(dt.Rows[0]["FILE_DATE_TIME"].ToString()); return(mPrintTemplateDict); }
private void dgv_Print_DoubleClick(object sender, EventArgs e) { if (this.dgv_Print.SelectedRows.Count <= 0) { return; } cmb_ExamClass.SelectedValue = this.dgv_Print.SelectedRows[0].Cells["EXAM_CLASS"].Value.ToString(); cmb_ExamSubClass.SelectedValue = this.dgv_Print.SelectedRows[0].Cells["EXAM_SUB_CLASS"].Value.ToString(); mPrint = (MPrintTemplateDict)(bPrint.GetModel(this.dgv_Print.SelectedRows[0].Cells["PRINT_TEMPLATE_ID"].Value.ToString())); tx_TempName.Text = mPrint.PRINT_TEMPLATE; this.winWordControl.QuitWord(); FileStream fs = new FileStream(path, FileMode.OpenOrCreate, FileAccess.Write); fs.Write(mPrint.FILE_NAME, 0, mPrint.FILE_NAME.Length); fs.Close(); if (word.WordOpen(path) == -1) { MessageBox.Show("打开模版失败,请重新打开!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
/// <summary> /// 下载报告 /// </summary> /// <returns></returns> public SIS_Model.MReport PacsReportDownLoad(SIS_Model.MStudy mStudy, string saveDir) { SIS_Model.MReport mReport = (SIS_Model.MReport)bReport.GetModel(mStudy.EXAM_ACCESSION_NUM); if (mReport == null) { return(null); } string ReportPath = saveDir + "\\" + mStudy.EXAM_ACCESSION_NUM + ".doc"; if (mReport.REPORT_NAME == null) { SIS_Model.MPrintTemplateDict mPrint = (SIS_Model.MPrintTemplateDict)bPrint.GetModel(mStudy.EXAM_CLASS, mStudy.EXAM_SUB_CLASS); if (mPrint != null) { FileOp.FileSave(mPrint.FILE_NAME, ReportPath); mReport.FIELD_INF = mPrint.FIELD_INF; } else//无此检查类别,检查子类的打印模版时,下载此检查类别下的默认打印模版 { DataTable dt = bPrint.GetList("EXAM_CLASS = '" + mStudy.EXAM_CLASS + "'"); if (dt.Rows.Count > 0) { mPrint = (SIS_Model.MPrintTemplateDict)bPrint.GetModel(dt.Rows[0]); FileOp.FileSave(mPrint.FILE_NAME, ReportPath); mReport.FIELD_INF = mPrint.FIELD_INF; } else { return(null); } } } else { FileOp.FileSave(mReport.REPORT_NAME, ReportPath); } return(mReport); }
/// <summary> /// 下载报告 /// </summary> /// <returns></returns> public IModel ReportDownLoad(IModel iWorklist, string saveDir) { string ReportPath = saveDir + "\\report.doc"; try { if (GetConfig.DALAndModel == "SIS") { SIS_Model.MWorkList mWorklist = (SIS_Model.MWorkList)iWorklist; SIS_Model.MReport mReport = (SIS_Model.MReport)bReport.GetModel(mWorklist.EXAM_ACCESSION_NUM); if (mReport == null || mReport.REPORT_NAME == null) { if (mReport == null) { mReport = new SIS_Model.MReport(); } SIS_Model.MPrintTemplateDict mPrint = (SIS_Model.MPrintTemplateDict)bPrint.GetModel(mWorklist.EXAM_CLASS, mWorklist.EXAM_SUB_CLASS); if (mPrint != null) { FileOp.FileSave(mPrint.FILE_NAME, ReportPath); mReport.FIELD_INF = mPrint.FIELD_INF; mReport.PRINT_TEMPLATE = mPrint.PRINT_TEMPLATE; } else//无此检查类别,检查子类的打印模版时,下载此检查类别下的默认打印模版 { DataTable dt = bPrint.GetList("EXAM_CLASS = '" + mWorklist.EXAM_CLASS + "'"); if (dt.Rows.Count > 0) { mPrint = (SIS_Model.MPrintTemplateDict)bPrint.GetModel(dt.Rows[0]); FileOp.FileSave(mPrint.FILE_NAME, ReportPath); mReport.FIELD_INF = mPrint.FIELD_INF; mReport.PRINT_TEMPLATE = mPrint.PRINT_TEMPLATE; } else { return(null); } } } else { FileOp.FileSave(mReport.REPORT_NAME, ReportPath); } return(mReport); } else { PACS_Model.MWorkList mWorklist = (PACS_Model.MWorkList)iWorklist; PACS_Model.MReport mReport = (PACS_Model.MReport)bReport.GetModel(mWorklist.EXAM_ACCESSION_NUM); if (mReport == null || mReport.REPORT_NAME == null) { if (mReport == null) { mReport = new PACS_Model.MReport(); } PACS_Model.MPrintTemplateDict mPrint = (PACS_Model.MPrintTemplateDict)bPrint.GetModel(mWorklist.EXAM_CLASS, mWorklist.EXAM_SUB_CLASS); if (mPrint != null) { FileOp.FileSave(mPrint.FILE_NAME, ReportPath); mReport.FIELD_INF = mPrint.FIELD_INF; mReport.PRINT_TEMPLATE = mPrint.PRINT_TEMPLATE; } else//无此检查类别,检查子类的打印模版时,下载此检查类别下的默认打印模版 { DataTable dt = bPrint.GetList("EXAM_CLASS = '" + mWorklist.EXAM_CLASS + "'"); if (dt.Rows.Count > 0) { mPrint = (PACS_Model.MPrintTemplateDict)bPrint.GetModel(dt.Rows[0]); FileOp.FileSave(mPrint.FILE_NAME, ReportPath); mReport.FIELD_INF = mPrint.FIELD_INF; mReport.PRINT_TEMPLATE = mPrint.PRINT_TEMPLATE; } else { return(null); } } } else { FileOp.FileSave(mReport.REPORT_NAME, ReportPath); } return(mReport); } } catch { return(null); } }
private void cmb_ExamSubClass_SelectedIndexChanged(object sender, EventArgs e) { this.tx_TempName.Text = ""; this.mPrint = null; }