Example #1
0
 /// <summary>
 /// 获得到上报卡列表
 /// </summary>
 /// <param name="searchDataEntity"></param>
 /// <returns></returns>
 public DataTable GetCardList(SearchDataEntity searchDataEntity, string querytype)
 {
     SqlParameter[] sqlParam = new SqlParameter[]
     {
         new SqlParameter("@report_type1", SqlDbType.VarChar),
         new SqlParameter("@report_type2", SqlDbType.VarChar),
         new SqlParameter("@name", SqlDbType.VarChar),
         new SqlParameter("@patid", SqlDbType.VarChar),
         new SqlParameter("@deptid", SqlDbType.VarChar),
         new SqlParameter("@applicant", SqlDbType.VarChar),
         new SqlParameter("@status", SqlDbType.VarChar),
         new SqlParameter("@createdatestart", SqlDbType.VarChar), //上报日期开始
         new SqlParameter("@createdateend", SqlDbType.VarChar),   //上报日期结束
         new SqlParameter("@querytype", SqlDbType.VarChar)        //查询类型(区分时间段查询语句)
     };
     sqlParam[0].Value = searchDataEntity.FirstReport;
     sqlParam[1].Value = searchDataEntity.ModifiedReport;
     sqlParam[2].Value = searchDataEntity.PatientName;
     sqlParam[3].Value = searchDataEntity.PatID;
     sqlParam[4].Value = searchDataEntity.DeptID;
     sqlParam[5].Value = searchDataEntity.Owner;
     sqlParam[6].Value = searchDataEntity.Status;
     sqlParam[7].Value = searchDataEntity.CreateDateStart; //上报日期开始
     sqlParam[8].Value = searchDataEntity.CreateDateEnd;   //上报日期结束
     sqlParam[9].Value = querytype;                        //查询类型
     return(m_IDataAccess.ExecuteDataTable("emr_zymosis_report.usp_geteditzymosisreport", sqlParam, CommandType.StoredProcedure));
 }
Example #2
0
        public IPlugIn Run(IEmrHost host)
        {
            IPlugIn plg = new PlugIn(this.GetType().ToString(), this);

            m_App              = host;
            m_SqlHelper        = new SqlHelper(host.SqlHelper);
            m_SearchDataEntity = new SearchDataEntity();

            return(plg);
        }