Ejemplo n.º 1
0
        /// <summary>
        /// 同步员工
        /// </summary>
        /// <returns></returns>
        public string getEmployee()
        {
            DBClass class2 = new DBClass();
            DataSet ds     = new DataSet();
            string  sql    = " SELECT distinct  eno AccountID    ,null  Pas ,null  Position    ,eno DEmployeeCode  , ename DEmployeeName  ,1 IsValid  ,0 Type    FROM v_pivas_employee";

            ds = class2.getOraDB(sql);
            string str2 = "truncate table DEmployeeTemp ";

            class2.SetDB(str2);
            XmlToDataSet set2    = new XmlToDataSet();
            WriteLog     log     = new WriteLog();
            string       content = set2.getxml(ds);

            log.writeLog("Employee_" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), content);
            return(content);
        }
Ejemplo n.º 2
0
        /// <summary>
        /// 同步频次
        /// </summary>
        /// <returns></returns>
        public string getFreq()
        {
            DBClass class2 = new DBClass();
            DataSet ds     = new DataSet();
            string  sql    = " SELECT DISTINCT    REPLACE(fname, '''', '’') as  freqcode,      REPLACE(fname, '''', '’')  as freqname,     1 as timesofday ,     1 as intervalday , null as  UseTime FROM v_pivas_freq";

            ds = class2.getOraDB(sql);
            string str2 = "delete from DFreqTemp";

            class2.SetDB(str2);
            XmlToDataSet set2    = new XmlToDataSet();
            WriteLog     log     = new WriteLog();
            string       content = set2.getxml(ds);

            log.writeLog("Freq_" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), content);
            return(content);
        }
Ejemplo n.º 3
0
        /// <summary>
        /// 同步药品
        /// </summary>
        /// <returns></returns>
        public string getDrug()
        {
            DBClass class2 = new DBClass();
            DataSet ds     = new DataSet();
            string  sql    = "  SELECT distinct ccode  as DrugCode,cname  as DrugName, cname  as DrugNameJC,spec   as Spec, dos    as Dosage, dosu   as DosageUnit, null   Major,null   MajorUnit, dos    AS Capacity,  null   Conversion,capu as CapacityUnit,null   as Form,units  as FormUnit,null   as Conversion, spell  as SpellCode, 0      as UniPreparationID,0      IsMenstruum, 0      withmenstruum, 0      PreConfigure, pishi  as PiShi, 0      NotCompound,  0      Precious, null   AsMajorDrug,  null   BigUnit, portno PortNo,null   Symbol, null   IsValid, null   Difficulty, null   DifficultySF, null   Species, null   Positions1,null   Positions2,null   NoName,spec1   ProductName,null   Concentration, FIRM_ID   firm_id    FROM v_pivas_drugdict";

            ds = class2.getOraDB(sql);
            string str2 = "delete from DDrugTemp ";

            class2.SetDB(str2);
            XmlToDataSet set2    = new XmlToDataSet();
            WriteLog     log     = new WriteLog();
            string       content = set2.getxml(ds);

            log.writeLog("Drug_" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), content);
            return(content);
        }
Ejemplo n.º 4
0
        /// <summary>
        /// 同步剂量单位
        /// </summary>
        /// <returns></returns>
        public string getDosage()
        {
            DBClass class2 = new DBClass();
            DataSet ds     = new DataSet();
            string  sql    = "SELECT distinct UNIT_CODE MetricCode ,UNIT_NAME  MetricName ,null UnitID  FROM   v_pivas_dosunit";

            ds = class2.getOraDB(sql);
            string str2 = "delete from DMetricTemp ";

            class2.SetDB(str2);
            XmlToDataSet set2    = new XmlToDataSet();
            WriteLog     log     = new WriteLog();
            string       content = set2.getxml(ds);

            log.writeLog("Dosage_" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), content);
            return(content);
        }
Ejemplo n.º 5
0
        /// <summary>
        /// 同步病区
        /// </summary>
        /// <returns></returns>
        public string getWard()
        {
            DBClass      class2 = new DBClass();
            DataSet      ds     = new DataSet();
            XmlToDataSet set2   = new XmlToDataSet();
            string       sql    = " select   wcode as WardCode,   wname as WardName,    null as WardSimName,    null as WardSeqNo,null as WardArea,  null as IsOpen,  null as Spellcode  from v_pivas_ward";

            ds = class2.getOraDB(sql);
            string str2 = "delete from DWardTemp ";

            class2.SetDB(str2);
            WriteLog log     = new WriteLog();
            string   content = set2.getxml(ds);

            log.writeLog("Ward_" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), content);
            return(content);
        }
Ejemplo n.º 6
0
        /// <summary>
        /// 同步医嘱
        /// </summary>
        /// <returns></returns>
        public string getPrecption()
        {
            DBClass class2 = new DBClass();
            DataSet ds     = new DataSet();
            string  sql    = " select   distinct   hospital_no||visit_id||'Y'||parent_no||'Z'||act_order_no as RecipeNo,  hospital_no||visit_id||parent_no as GroupNo,   ward_code WardCode,  Doctor DoctorCode,  '' DrawerCode,        inpatient_no PatientCode,      hospital_no CaseID,      Bed_no BedNo,        UsageName UsageCode,      UsageName UsageName,     freq_code FreqCode,    charge_code DrugCode, drugname DrugName,       specification Spec,      dose Dosage,      dose_unit DosageUnit,      0 Quantity,     null QuantityUnit,     sysdate InceptDT,     start_time StartDT,   end_time EndDT,      TPN,     2 PDStatus,      0 PPause,     null Remark1,    null Remark2,'未记帐' as Remark3,     null Remark4,      null Remark5,   null Remark6,    remark Remark7,   null Remark8,    null Remark9,   null Remark10,   0 OldGroup,   0 OldRecipe,   0 OldStop  from v_pivas_yz";

            ds = class2.getOraDB(sql);
            string str2 = "delete from PrescriptionTemp";

            class2.SetDB(str2);
            XmlToDataSet set2    = new XmlToDataSet();
            WriteLog     log     = new WriteLog();
            string       content = set2.getxml(ds);

            log.writeLog("Precption_" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), content);
            return(content);
        }
Ejemplo n.º 7
0
        /// <summary>
        /// 同步患者
        /// </summary>
        /// <returns></returns>
        public string getPatient()
        {
            DBClass class2 = new DBClass();
            DataSet ds     = new DataSet();
            string  sql    = "SELECT distinct  pcode PatCode   ,pname PatName,    CASE Sex WHEN '?D' THEN '1' ELSE '2'    END Sex                  ,     birthday  Birthday                  ,'0'Height                    ,'0'Weight  ,ward WardCode                    ,bed  BedNo                     ,1 PatStatus       ,trunc(months_between  (sysdate,birthday)/12) Age        ,null AgeSTR  ,0 UPdateStatu    FROM v_pivas_actpatient";

            ds = class2.getOraDB(sql);
            string str2 = "delete from PatientTemp ";

            class2.SetDB(str2);
            XmlToDataSet set2    = new XmlToDataSet();
            WriteLog     log     = new WriteLog();
            string       content = set2.getxml(ds);

            log.writeLog("Patient_" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), content);
            return(content);
        }