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