/// <summary>
/// 获得新增病人时弹出的病人列表
/// </summary>
/// <param name="deptNO"></param>
/// <returns></returns>
public DataTable GetPatientListForNew(string deptNO)
{
string sql = string.Format(m_SqlGetPatientListForNew, deptNO);
DataTable dt = YD_SqlHelper.ExecuteDataTable(sql);
return(dt);
}
/// <summary>
/// 抓取病历诊断编码
/// Add by xlb 2013-03-21
/// </summary>
private DataTable GetDialogData()
{
try
{
string sql = "select ICD,NAME,PY,WB from diagnosis_xt_bj where valid='1'";
DataTable dtDialog = YD_SqlHelper.ExecuteDataTable(sql, CommandType.Text);
return(dtDialog);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="host"></param>
public IemDialogForm(IEmrHost host)
: this()
{
try
{
m_app = host;
YD_SqlHelper.CreateSqlHelper();
InitLookUpEdit();
}
catch (Exception ex)
{
throw ex;
}
}
public UCIemDiagnose()
{
try
{
InitializeComponent();
m_SqlHelper = DataAccessFactory.DefaultDataAccess;
InitLookUpEditor();
YD_SqlHelper.CreateSqlHelper();
}
catch (Exception ex)
{
throw ex;
}
}
public string GetDeptName(string deptcode)
{
try
{
if (deptcode == "")
{
return("");
}
string sql = string.Format(@"select d.name from department d where d.id='{0}' ", deptcode);
return(YD_SqlHelper.ExecuteScalar(sql).ToString());
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 初始化接收人下拉数据源
/// Add by xlb 2013-07-02
/// </summary>
/// <param name="lookUpEditor"></param>
/// <param name="lookUpWindows"></param>
private void InitializeJSR(ref LookUpEditor lookUpEditor, ref LookUpWindow lookUpWindows)
{
try
{
YD_SqlHelper.CreateSqlHelper();
lookUpEditor.Kind = WordbookKind.Sql;
lookUpEditor.ListWindow = lookUpWindows;
DataTable dataJCZ = YD_SqlHelper.ExecuteDataTable(@"select id,name,py,wb from users where valid='1' and
grade in ('2000','2001','2002','2003') and category in ('400','401') and deptid=@deptId",
new SqlParameter[] { new SqlParameter("@deptId", DrectSoft.Common.DS_Common.currentUser.CurrentDeptId) }, CommandType.Text);
Dictionary <string, Int32> columnWidth = new Dictionary <string, int>();
dataJCZ.Columns["ID"].Caption = "编码";
dataJCZ.Columns["NAME"].Caption = "名称";
columnWidth.Add("ID", 68);
columnWidth.Add("NAME", 120);
SqlWordbook sqlWord = new SqlWordbook("JCZ", dataJCZ, "ID", "NAME", columnWidth, "ID//NAME//PY//WB");
lpEdiMidwifery.SqlWordbook = sqlWord;
dtEdiMidwifery = dataJCZ;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 返回报告卡类别列表
/// </summary>
/// <returns></returns>
public DataTable GetReportCategoryList()
{
DataTable dt = YD_SqlHelper.ExecuteDataTable("SELECT ID,Name FROM reportcategory where VALID=1 ORDER BY ORDERID ASC");
return(dt);
}
public SqlHelper()
{
YD_SqlHelper.CreateSqlHelper();
}
/// <summary>
/// 获得新增病人时弹出的所有病人的列表
/// </summary>
/// <param name="deptNO"></param>
/// <returns></returns>
public DataTable GetAllPatientListForNew()
{
DataTable dt = YD_SqlHelper.ExecuteDataTable(m_SqlGetAllPatientListForNew);
return(dt);
}
/// <summary>
/// 取得时限规则数据集
/// by xlb 2013-01-05
/// </summary>
/// <returns></returns>
public DataTable GetAllDataRule()
{
DataTable dt = YD_SqlHelper.ExecuteDataTable(ruleSql, CommandType.Text);
return(dt);
}