public DataTable SelectAll() { DataTable dt = new DataTable(); String sql = "select * " + "From lab_m01 "; dt = conn.selectData(sql); //new LogWriter("d", "SelectHnLabOut1 sql "+sql); return(dt); }
public DataTable SelectAll() { DataTable dt = new DataTable(); String sql = "select * " + "From finance_m01 " + //"Where MNC_FN_TYP_STS = 'Y' " + "Order By MNC_FN_CD"; dt = conn.selectData(sql); //new LogWriter("d", "SelectHnLabOut1 sql "+sql);MNC_DEF_DSC return(dt); }
public DataTable selectAll() { DataTable dt = new DataTable(); String sql = "select * " + "From " + dgs.table + " dgs " + //"Left Join f_patient_prefix pfx On stf.prefix_id = pfx.f_patient_prefix_id " + " Where dgs." + dgs.active + " ='1' " + "Order By doc_group_id "; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectAll() { DataTable dt = new DataTable(); String sql = "select dfm.*, dgss.doc_group_sub_name " + "From " + dfm.table + " dfm " + "Left Join doc_group_sub_scan dgss On dfm.doc_group_sub_id = dgss.doc_group_sub_id " + " Where dfm." + dfm.active + " ='1' " + "Order By dfm.fm_code "; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable SelectAll() { DataTable dt = new DataTable(); String sql = "select * " + "From b_patient_smartcard " + //"Where MNC_FN_TYP_STS = 'Y' " + "Order By patient_smartcard_id desc"; dt = conn.selectData(conn.conn, sql); //new LogWriter("d", "SelectHnLabOut1 sql "+sql);MNC_DEF_DSC return(dt); }
public DataTable selectLabM01By(String labcode) { DataTable dt = new DataTable(); String sql = "select * " + "From LAB_M01 " + //"Left Join f_patient_prefix pfx On stf.prefix_id = pfx.f_patient_prefix_id " + "Where MNC_LB_CD ='" + labcode + "' " + "Order By MNC_LB_CD "; dt = conn.selectData(conn.connMainHIS, sql); return(dt); }
public DataTable selectAllDeptUS() { DataTable dt = new DataTable(); String sql = "select dgss.*, dgs.doc_group_name " + "From " + dgss.table + " dgss " + "Left Join doc_group_scan dgs On dgs.doc_group_id = dgss.doc_group_id " + " Where dgss." + dgss.active + " ='1' and dept_us = '1' " + "Order By dgss.doc_group_id, dgss.doc_group_sub_id "; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable SelectAll() { DataTable dt = new DataTable(); String sql = "select * " + "From finance_m02 " + "Where MNC_FN_TYP_STS = 'Y' " + "Order By mnc_fn_typ_cd"; dt = conn.selectData(sql); //new LogWriter("d", "SelectHnLabOut1 sql "+sql); return(dt); }
public DataTable selectResultByAccessNumber(String acc) { ResOrderTab cop1 = new ResOrderTab(); DataTable dt = new DataTable(); String sql = "select * " + "From " + rpttc.table + " rpttc " + //"Left Join f_patient_prefix pfx On stf.prefix_id = pfx.f_patient_prefix_id " + "Where rpttc." + rpttc.AccessNumber + " ='" + acc + "' " + " "; dt = conn.selectData(conn.conn, sql); return(dt); }
public OPDCheckUP selectByPk(String id) { OPDCheckUP item = new OPDCheckUP(); String sql = ""; DataTable dt = new DataTable(); sql = "Select * From " + opdc.table + " Where " + opdc.pkField + "='" + id + "'"; dt = conn.selectData(sql); if (dt.Rows.Count > 0) { item = setData(item, dt); } return(item); }
public DataTable SelectAll() { DataTable dt = new DataTable(); String sql = "select pm01.*, pm05.mnc_ph_pri01, pm05.mnc_ph_pri02, pm05.mnc_ph_pri03 " + "From pharmacy_m01 pm01 " + "inner join pharmacy_m05 pm05 on pm01.mnc_ph_cd = pm05.mnc_ph_cd " + //"Where MNC_FN_TYP_STS = 'Y' " + "Order By pm01.MNC_PH_CD"; dt = conn.selectData(conn.connMainHIS, sql); //new LogWriter("d", "SelectHnLabOut1 sql "+sql); return(dt); }
public DataTable SelectDepartment() { DataTable dt = new DataTable(); String sql = "Select pttm32.mnc_md_dep_no, pttm32.mnc_md_dep_dsc, pttm32.mnc_sec_no " + "From Patient_m32 pttm32 " + " " + "where MNC_DP_NO in ('111','302','OPE','ERI','XRY','W7A','CCU','W5W','ICU','WNS','W6A','W5M') " + "Order By mnc_md_dep_dsc "; dt = conn.selectData(sql); return(dt); }
public DataTable selectSummaryOPD(String hn, String hnyr, String vn, String vsdate) { DataTable dt = new DataTable(); String sql = "", whereAn = ""; sql = "Select tem02.*, tem01.mnc_hn_name, tem01.mnc_com_name, tem01.mnc_com_addr, tem01.mnc_age, tem01.mnc_sex,convert(VARCHAR(20), tem01.mnc_doc_dat ,23) as doc_dat, tem02.MNC_def_lev " + ", tem01.MNC_SUM_AMT, tem01.MNC_FN_TYP_CD, tem01.MNC_FN_TYP_DSC,tem01.MNC_COM_NAME, tem01.MNC_DIA_DSC, convert(VARCHAR(20),tem01.MNC_DIS_DAT) as MNC_DIS_DAT, convert(VARCHAR(20),tem01.MNC_ADM_DAT) as MNC_ADM_DAT, convert(VARCHAR(20),tem01.MNC_DIA_DAT) as MNC_DIA_DAT " + "From temporary_m01 tem01 " + "inner join temporary_m02 tem02 on tem01.MNC_DOC_CD = tem02.MNC_DOC_CD and tem01.MNC_DOC_YR = tem02.MNC_DOC_YR and tem01.MNC_DOC_NO = tem02.MNC_DOC_NO and tem01.MNC_DOC_DAT = tem02.MNC_DOC_DAT " + "where tem01.mnc_hn_yr = '" + hnyr + "' and tem01.mnc_hn_no = '" + hn + "' and tem01.mnc_vn_no = '" + vn + "' and tem01.mnc_doc_dat = '" + vsdate + "'" + "Order By tem02.mnc_ord_by "; //} dt = conn.selectData(sql); return(dt); }
public DataTable selectLabAll() { DataTable dt = new DataTable(); String sql = ""; sql = "Select lab01.mnc_lb_cd, lab01.mnc_lb_dsc, lab01.mnc_lb_typ_cd, lab01.mnc_lb_grp_cd,lab_m06.MNC_LB_GRP_DSC " + ",lab01.MNC_LB_GRP_CD,lab_m07.MNC_LB_TYP_DSC " + "From lab_m01 lab01 " + "inner join LAB_M06 on lab01.MNC_LB_GRP_CD = LAB_M06.MNC_LB_GRP_CD " + "inner join LAB_M07 on lab01.MNC_LB_TYP_CD= LAB_M07.MNC_LB_TYP_CD and lab01.MNC_LB_GRP_CD = LAB_M07.MNC_LB_GRP_CD " + " Where lab01.MNC_lb_STS = 'Y' " + "Order By lab01.mnc_lb_cd"; dt = conn.selectData(sql); return(dt); }
public DataTable selectDrugAll() { DataTable dt = new DataTable(); String sql = ""; sql = "Select pm01.mnc_ph_cd, pm01.mnc_ph_id, pm01.mnc_ph_ctl_cd, pm01.mnc_ph_tn, pm01.mnc_ph_gn" + ", pm01.mnc_ph_unt_cd, pm01.mnc_ph_grp_cd, pm01.mnc_ph_typ_cd " + ", pm01.mnc_ph_dir_cd, pm04.mnc_ph_dir_dsc, pm01.MNC_PH_CAU_CD, pm11.MNC_PH_CAU_dsc " + "From pharmacy_m01 pm01 " + "Left join pharmacy_m04 pm04 on pm01.MNC_PH_DIR_CD = pm04.MNC_PH_DIR_CD " + "Left join PHARMACY_M11 pm11 on pm01.MNC_PH_CAU_CD = pm11.MNC_PH_CAU_CD " + "Where pm01.MNC_ph_STS = 'Y' and pm01.mnc_ph_typ_flg = 'P' " + "Order By pm01.mnc_ph_tn"; dt = conn.selectData(sql); return(dt); }
public Staff selectByUsernameLevelDoctor(String username) { Staff cop1 = new Staff(); DataTable dt = new DataTable(); String sql = "select stf.mnc_usr_name, stf.mnc_usr_pw, stf.mnc_usr_full,stf.mnc_usr_lev " + "From userlog_m01 stf " + //"Left Join f_patient_prefix pfx On stf.prefix_id = pfx.f_patient_prefix_id " + "Where stf." + stf.username + " ='" + username + " and mnc_usr_lev = '5' "; dt = conn.selectData(conn.connMainHIS, sql); cop1 = setStaff(dt); return(cop1); }
public DataTable SelectAll() { DataTable dt = new DataTable(); String sql = "select * " + "From drugcatalog "; dt = conn.selectData(conn.connOPBKK, sql); //new LogWriter("d", "SelectHnLabOut1 sql "+sql); return(dt); }
public LabEx selectByPk(String Id) { LabEx item = new LabEx(); String sql = ""; DataTable dt = new DataTable(); sql = "Select * From " + labex.table + " Where " + labex.pkField + "='" + Id + "'"; //lw.WriteLog("LabExDB.selectByPk sql " + sql); //lw.WriteLog("LabExDB.selectByPk connBua.hostNameBua " + connBua.hostNameBua + " connBua.databaseNameBua " + connBua.databaseNameBua); //MessageBox.Show("111111 connBua.databaseNameBua " + connBua.databaseNameBua, "1111111"); //if (connBua.hostNameBua.Equals("")) //{ // lw.WriteLog("LabExDB.selectByPk connBua.hostNameBua if (connBua.hostNameBua.Equals" ); // IniFile iniFile = new IniFile("reportbangna.ini"); // connBua.databaseNameBua = iniFile.Read("database_name_bua"); // connBua.hostNameBua = iniFile.Read("host_name_bua"); // connBua.userNameBua = iniFile.Read("user_name_bua"); // connBua.passwordBua = iniFile.Read("password_bua"); // //MessageBox.Show("connBua.databaseNameBua " + connBua.databaseNameBua, ""); // //MessageBox.Show("connBua.hostNameBua " + connBua.hostNameBua, ""); // //MessageBox.Show("connBua.hostNameMainHIS " + connBua.hostNameMainHIS, ""); // //MessageBox.Show("connBua.hostNameMainHIS " + , ""); //} dt = conn.selectData(sql); if (dt.Rows.Count > 0) { item = setData(item, dt); } //lw.WriteLog("LabExDB.selectByPk End connBua.connMainHIS.State " + connBua.connMainHIS.State); return(item); }
public String selectByPk(String reqyr, String reqdate, String reqno, String xrcode) { DataTable dt = new DataTable(); String sql = "", re = "insert"; sql = "Select * from xray_t04 Where mnc_req_yr = '" + reqyr + "' and mnc_req_no = '" + reqno + "' and mnc_req_dat = '" + reqdate + "' and mnc_xr_cd = '" + xrcode + "'"; dt = conn.selectData(sql); if (dt.Rows.Count > 0) { re = "update"; } return(re); }
public DataTable selectAll() { DataTable dt = new DataTable(); String sql = "select labB.* " + "From " + queueType.table + " labB " + //"Left Join f_patient_prefix pfx On stf.prefix_id = pfx.f_patient_prefix_id " + //"Where labB." + queueType.active + "='1' " + "Order By labB. " + queueType.queue_type_name; dt = conn.selectData(conn.conn, sql); return(dt); }
public String InsertPrakunM01() { String sql = "", cnt = ""; DataTable dt = new DataTable(); sql = "Delete from prakun_m01_pop_temp;"; conn.ExecuteNonQueryLogPage(conn.connMainHIS, sql); sql = "insert into prakun_m01_pop_temp (SocialID, Social_Card_no,TitleName,FirstName, LastName,FullName, PrakanCode, Prangnant, StartDate,EndDate,BirthDay,UploadDate,FLAG ) " + "Select SocialID, Social_Card_no,TitleName,FirstName, LastName,FullName, PrakanCode, Prangnant, StartDate,EndDate,BirthDay,UploadDate,FLAG From prakun_m01_pop "; conn.ExecuteNonQueryLogPage(conn.connMainHIS, sql); sql = "Select count(1) as cnt from prakun_m01_pop_temp"; dt = conn.selectData(conn.connMainHIS, sql); if (dt.Rows.Count > 0) { cnt = dt.Rows[0]["cnt"].ToString(); } return(cnt); }
public DataTable selectReq(String hnyr, String hn, String vsdate, String preno) { String sql = ""; DataTable dt = new DataTable(); sql = "Select phart02.*, pharm01.mnc_ph_tn, pharm01.mnc_ph_id, pharm01.mnc_ph_ctl_cd, pharm01.mnc_ph_gn " + ", pharm01.mnc_ph_unt_cd, pharm01.mnc_ph_grp_cd, pharm01.mnc_ph_typ_cd " + ", pharm01.mnc_ph_dir_cd, pm04.mnc_ph_dir_dsc, pharm01.MNC_PH_CAU_CD, pm11.MNC_PH_CAU_dsc,pharm01.mnc_ph_typ_flg " + "From " + pharT02.table + " phart02 " + "inner join pharmacy_t01 phart01 on phart02.mnc_doc_cd = phart01.mnc_doc_cd and phart02.mnc_req_no = phart01.mnc_req_no and phart02.mnc_req_yr = phart01.mnc_req_yr " + "Left Join pharmacy_m01 pharm01 on phart02.mnc_ph_cd = pharm01.mnc_ph_cd " + "Left join pharmacy_m04 pm04 on pharm01.MNC_PH_DIR_CD = pm04.MNC_PH_DIR_CD " + "Left join PHARMACY_M11 pm11 on pharm01.MNC_PH_CAU_CD = pm11.MNC_PH_CAU_CD " + "Where phart01.mnc_hn_no = '" + hn + "' and phart01.mnc_hn_yr = '" + hnyr + "' and phart01.mnc_pre_no = '" + preno + "' and phart01.mnc_date = '" + vsdate + "' " + "Order By phart02.mnc_ord_no"; dt = conn.selectData(sql); return(dt); }
public String selectHnMax() { DataTable dt = new DataTable(); String sql = "", re = ""; sql = "Select max(m01.mnc_hn_no) as hn_no " + "From patient_m01 m01 "; dt = conn.selectData(conn.connMainHIS, sql); if (dt.Rows.Count > 0) { re = dt.Rows[0]["hn_no"].ToString(); } return(re); }
public DataTable selectVisitStatus1PacsReqByDate(String Date) { DataTable dt = new DataTable(); String sql = ""; String[] aa = Date.Split('/'); //sql = "Select xr01.*, xr01.MNC_HN_NO,m02.MNC_PFIX_DSC as prefix, " + // "ptt01.MNC_FNAME_T,ptt01.MNC_LNAME_T,ptt01.MNC_AGE,t01.MNC_VN_NO,t01.MNC_VN_SEQ,t01.MNC_VN_SUM, t01.mnc_vn_no, t01.mnc_vn_seq, t01.mnc_vn_sum " + // ",ptt01.mnc_bday, ptt01.mnc_sex, t01.mnc_shif_memo " + // "From xray_t01 xr01 " + // "Left Join patient_m01 ptt01 on xr01.mnc_hn_no = ptt01.mnc_hn_no and xr01.mnc_hn_yr = ptt01.mnc_hn_yr " + // "Left join patient_m02 m02 on ptt01.MNC_PFIX_CDT = m02.MNC_PFIX_CD " + // " inner join patient_t01 t01 on xr01.MNC_HN_NO = t01.MNC_HN_NO " + // " Where xr01.MNC_req_dat = '" + Date + "' and t01.mnc_sts <> 'C' and xr01.mnc_req_sts <> 'A' and xr01.status_pacs <> '1' "; //sql = "Select xr01.*, xr01.MNC_HN_NO,m02.MNC_PFIX_DSC as prefix, " + // "ptt01.MNC_FNAME_T,ptt01.MNC_LNAME_T,ptt01.MNC_AGE,t01.MNC_VN_NO,t01.MNC_VN_SEQ,t01.MNC_VN_SUM, t01.mnc_vn_no, t01.mnc_vn_seq, t01.mnc_vn_sum " + // ",ptt01.mnc_bday, ptt01.mnc_sex, t01.mnc_shif_memo " + // "From xray_t01 xr01 " + // "Left Join patient_m01 ptt01 on xr01.mnc_hn_no = ptt01.mnc_hn_no and xr01.mnc_hn_yr = ptt01.mnc_hn_yr " + // "Left join patient_m02 m02 on ptt01.MNC_PFIX_CDT = m02.MNC_PFIX_CD " + // " inner join patient_t01 t01 on xr01.MNC_HN_NO = t01.MNC_HN_NO and xr01.mnc_hn_yr = t01.mnc_hn_yr " + // " Where t01.MNC_date = '" + Date + "' and t01.mnc_sts <> 'C' and xr01.status_pacs = '0' " + // "Order By xr01.mnc_req_dat, xr01.mnc_req_tim"; sql = "Select xr01.mnc_req_yr,xr01.mnc_req_no, xt02.MNC_XR_CD, xr01.mnc_req_dep, xr01.MNC_HN_NO,m02.MNC_PFIX_DSC +' '+ m01.MNC_FNAME_T+' '+m01.MNC_LNAME_T as fullname " + ",m01.MNC_AGE,ptt01.MNC_VN_NO, " + " ptt01.MNC_VN_SEQ,ptt01.MNC_VN_SUM, ptt01.mnc_vn_no,ptt01.mnc_vn_seq, m01.mnc_vn_sum ,convert(VARCHAR(20),m01.mnc_bday,23) as mnc_bday, " + "m01.mnc_sex, ptt01.mnc_shif_memo, xt02.MNC_XR_CD, xm01.MNC_XR_DSC, xr01.MNC_DOT_CD, um01.mnc_usr_full,ptt01.MNC_SEC_NO, pm32.MNC_MD_DEP_DSC, ptt01.mnc_sts, xm01.mnc_xr_grp_cd" + ", xm05.mnc_xr_grp_dsc,convert(VARCHAR(20),xr01.mnc_req_dat,23) as mnc_req_dat1 " + "From xray_t01 xr01 " + "inner Join patient_m01 m01 on xr01 .mnc_hn_no = m01.mnc_hn_no " + "inner join patient_m02 m02 on m01.MNC_PFIX_CDT = m02.MNC_PFIX_CD " + "inner join PATIENT_T01 ptt01 on xr01 .mnc_hn_no = ptt01.mnc_hn_no and xr01.MNC_DATE = ptt01.MNC_DATE and xr01 .MNC_PRE_NO = ptt01.MNC_PRE_NO " + "Left Join xray_t02 xt02 on xr01.MNC_REQ_NO = xt02.MNC_REQ_NO and xr01.MNC_REQ_YR = xt02.MNC_REQ_YR and xr01.MNC_REQ_DAT = xt02.MNC_REQ_DAT " + " Left Join xray_m01 xm01 on xm01.MNC_XR_CD = xt02.MNC_XR_CD " + " Left Join userlog_m01 um01 on xr01.MNC_DOT_CD = um01.mnc_usr_name " + " Left Join patient_m32 pm32 on ptt01.MNC_SEC_NO = pm32.MNC_SEC_NO " + "Left Join xray_m05 xm05 on xm01.mnc_xr_grp_cd = xm05.mnc_xr_grp_cd " + " Where xr01.MNC_REQ_DAT = '" + Date + "' and xr01.MNC_REQ_STS = 'A' " + "and xt02.status_pacs = '1' " + "Order By xr01.mnc_req_dat, xr01.mnc_req_tim"; dt = conn.selectData(sql); return(dt); }