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