C# Data.getString方法代码示例

        /// <summary>
        /// get a report for items
        /// </summary>
        /// <param name="data"></param>
        /// <returns></returns>
        public Data getItemReport(Data data)
        {
            String startDate = data.getString("startDate");
            String endDate = data.getString("endDate");
            String today = DateTime.Now.Date.ToString().Substring(0,10);
            if ("".Equals(startDate))
            {
                data.add("startDate",today);
            }
            if ("".Equals(startDate))
            {
                data.add("endDate", today);
            }
            String query = @"SELECT G.Item, G.Price, COUNT(M.ItemId) AS How_many_times, SUM(G.Price) AS Total
                            FROM Medicine M, GeneralPayment G, history H
                            WHERE H.historyId = M.historyId
                                AND M.ItemId = G.ID
                                AND M.state < 9
                                AND H.date >= CONVERT(datetime, @startDate, 103)
                                AND H.date <= CONVERT(datetime, @endDate, 103)
                            GROUP BY G.Item, G.price
                            ORDER BY G.Item ASC";

            return select(query, data);
        }

        /// <summary>
        /// set query to select patient ID and nurse ID. Search for patient.
        /// </summary>
        /// <param name="field"></param>
        /// <param name="value"></param>
        /// <param name="data"></param>
        /// <returns></returns>
        public Data list(String field, String value,Data data)
        {
            String query = "Select * From history A, Users B WHERE A.patientId = B.UserID AND A.patientId = @pId AND A.staffId = @NurseID AND status = '0' <SEARCH> <DATE> ORDER BY historyId DESC";
            String date = data.getString("date");
            if (field.Equals(""))
            {
                query = query.Replace("<SEARCH>", "");
            }
            else if (field.Equals("memo"))
            {
                query = query.Replace("<SEARCH>", "AND memo LIKE '%" + value + "%'");
            }
            else if (field.Equals("patientId"))
            {
                query = query.Replace("<SEARCH>", "AND patientId LIKE '%" + value + "%'");
            }

            if (date.Equals(""))
            {
                query = query.Replace("<DATE>", "");
            }
            else
            {
                query = query.Replace("<DATE>", "AND CONVERT(VARCHAR(10), A.date, 103) = '<DATE>'".Replace("<DATE>", date));
            }

            return select(query, data);
        }

    protected void onChange(object sender, EventArgs e)
    {
        Data data = new Data();
        data.add("doctorId", UserInfo.getId(Session));
        data.add("pID", Param.get("pId"));
        data.add("pre", pre.SelectedValue);
        DoctorBiz doctor = new DoctorBiz();
        Data result = doctor.list(Param.getString("searchFiled"), Param.getString("searchValue"), data);

        pId.Value = data.getString("pID");
        DoctorID.Value = data.getString("doctorId");
        int count = result.Count;
        for (int i = 0; i < count; i++)
        {
            result.add(i, "date", result.getString(i, "date").Substring(0, 10));
        }
        patienthistory.DataSource = result.Source;
        patienthistory.DataBind();
        userNameLabel.Text = result.getString("UserSurName") + "," + result.getString("UserFirstName") + ",ID:" + result.getString("UserID");
    }

    protected override void Fire(object sender, EventArgs e)
    {
        if (!UserInfo.isDoctor(Session))
        {
            alertAndGoback("you are not a doctor. Please login");
            return;
        }

        Data data = new Data();
        data.add("doctorId", UserInfo.getId(Session));
        data.add("pID", Param.get("pId"));

        DoctorBiz doctor = new DoctorBiz();
        Data result = doctor.list(Param.getString("searchFiled"), Param.getString("searchValue"), data);

        pId.Value = data.getString("pID");
        DoctorID.Value = data.getString("doctorId");
        patienthistory.DataSource = result.Source;
        patienthistory.DataBind();
        userNameLabel.Text = result.getString("UserSurName") + "," + result.getString("UserFirstName") + ",ID:" + result.getString("UserID");
    }

    protected override void Fire(object sender, EventArgs e)
    {
        if (!UserInfo.isDoctor(Session))
        {
            alertAndGoback("you are not a doctor. Please login");
            return;
        }

        DateTime xToday = DateTime.Now.Date;
        DOT.Text = xToday.ToString().Substring(0, 10);
        //UserID.Text = Param.getString("pId");
        Data result = new Data();
        DBC dbc = new DBC();
        Data data = new Data();
        data.add("pID", Param.get("pId"));
        UserID.Value = Param.getString("pId");

        TestResultBiz biz = new TestResultBiz();
        result = biz.view(data);
        userNameLabel.Text = result.getString("UserSurName") + "," + result.getString("UserFirstName") + ",ID:" + result.getString("UserID");
    }

 /// <summary>
 /// create a new test
 /// </summary>
 /// <param name="data"></param>
 /// <returns></returns>
 public override bool create(Data data)
 {
     dbc = new DBC();
     dbc.open();
     Object TestResultId = dbc.select("SELECT COUNT(TestResultID) + 1 AS MAX_ID FROM DoctorsTestResult", data).get("MAX_ID");
     String XrayMan = dbc.select("SELECT UserID FROM Users WHERE JobCOde = 17", new Data()).getString("UserID");
     String MRIMan = dbc.select("SELECT UserID FROM Users WHERE JobCOde = 21", new Data()).getString("UserID");
     data.add("TestResultID", TestResultId);
     data.add("XrayMan", XrayMan);
     data.add("MRIMan", MRIMan);
     dbc.update(@"INSERT INTO DoctorsTestResult
             (DoctorID, TestResultID, UserID, UserOR1, UserOR2, UserOR3, UserOR4, UserOR5, UserOR6,UserORT1,UserORT2,UserORT3,UserORT4,UserORT5,UserORT6,other_abnormalities, DOT, Memo, state)
             VALUES  (@DoctorID, @TestResultID, @UserID, @OR1, @OR2, @OR3, @OR4, @OR5, @OR6,@ORT1, @ORT2, @ORT3, @ORT4, @ORT5, @ORT6, @other_abnormalities, CONVERT(datetime, @DOT, 103), @Memo, 0)", data);
     data.add("historyId", dbc.select(@"SELECT   MAX(historyId) +1 AS MAX_ID FROM history", data).get("MAX_ID"));
     dbc.update(@"INSERT INTO history
         (patientId, historyId, staffId, memo, type, cntId, date, payId)
          VALUES   (@UserID, @historyId, @DoctorID, @Memo, 1, @TestResultID, CONVERT(datetime, @DOT, 103), 12)", data);
     //order Xray
     if ("True".Equals(data.getString("Xray")))
     {
         String xRayMemo = "[" + data.getString("UserID") + "] FROM " + data.getString("DoctorID") + "\n" + data.getString("Memo");
         data.add("xRayMemo", xRayMemo);
         data.add("xHistoryId", int.Parse(data.getString("historyId")) + 1);
         dbc.update(@"INSERT INTO history
         (patientId, historyId, staffId, memo, type, cntId, date, payId)
          VALUES   (@UserID, @xHistoryId, @XrayMan, @xRayMemo, -1, @TestResultID, CONVERT(datetime, @DOT, 103), 17)", data);
     }
     //order MRI
     if ("True".Equals(data.getString("MRI")))
     {
         String xRayMemo = "[" + data.getString("UserID") + "] FROM " + data.getString("DoctorID") + "\n" + data.getString("Memo");
         data.add("xRayMemo", xRayMemo);
         data.add("mHistoryId", int.Parse(data.getString("xHistoryId")) + 1);
         dbc.update(@"INSERT INTO history
         (patientId, historyId, staffId, memo, type, cntId, date, payId)
          VALUES   (@UserID, @mHistoryId, @MRIMan, @xRayMemo, -1, @TestResultID, CONVERT(datetime, @DOT, 103), 18)", data);
     }
     dbc.close();
     return true;
 }

        public Data getPatientAndService(Data data)
        {
            String startDate = data.getString("startDate");
            String endDate = data.getString("endDate");
            String today = DateTime.Now.Date.ToString().Substring(0, 10);
            if ("".Equals(startDate))
            {
                data.add("startDate", today);
            }
            if ("".Equals(startDate))
            {
                data.add("endDate", today);
            }

            String query = @"SELECT H.patientId, G.Item AS Type,
                                G.Price,
                                G.Price * (100 - I.rate) / 100 AS Patient_Fee,
                                G.Price * I.rate / 100 AS Insurance_Fee,
                                I.InsuranceName, I.rate,
                                H.date
                            FROM GeneralPayment G, history H, Users U, Insurance I
                            WHERE G.ID = H.PayId
                                AND U.UserID = H.patientId
                                AND I.insuranceId = U.InsuranceId
                                AND H.payId > 0
                                AND H.date >= CONVERT(datetime, @startDate, 103)
                                AND H.date <= CONVERT(datetime, @endDate, 103)
                            GROUP BY H.patientId, G.Item, G.Price, I.InsuranceName, I.rate, H.date
                            ORDER BY Date DESC";
            Data result = select(query, data);
            int count = result.Count;
            for (int i = 0; i < count; i++)
            {
                result.add(i, "date", result.getString(i, "date").Substring(0, 10));
            }
            return result;
        }

        // it will be deleted
        public bool checkId(Data data)
        {
            if (!Text.isAble(data.getString("UserID"), 32))
            {
                return false;
            }
            Data param = new Data();
            param.add("UserID", data.get("UserID"));
            Data result = new Data();
            UserData ud = new UserData();
            result = ud.checkId(param);

            if (result.Count == 0)
            {
                return true;
            }

            return false;
        }

        /// <summary>
        /// get a patients list
        /// </summary>
        /// <param name="field"></param>
        /// <param name="value"></param>
        /// <param name="data"></param>
        /// <returns></returns>
        public Data list(String field, String value, Data data)
        {
            //String query = "Select * From Users U WHERE JobCode = 0 and UserID in (SELECT patientId FROM history WHERE staffId = @doctorId AND state = 0 <DATE>) <SEARCH> ORDER BY UserID DESC";
            String query = @"Select * From Users U, history H
                            WHERE U.UserID = H.patientId
                                AND U.JobCode = 0
                                AND H.status = 0
                                AND H.staffId = @doctorId
                                <DATE>
                                <SEARCH> ORDER BY U.UserID DESC";
            //searcing
            if (field.Equals(""))
            {
                query = query.Replace("<SEARCH>", "");
            }
            else if (field.Equals("memo"))
            {
                query = query.Replace("<SEARCH>", "AND H.memo LIKE '%" + value + "%'");
            }
            else if (field.Equals("UserID"))
            {
                query = query.Replace("<SEARCH>", "AND U.UserID LIKE '%" + value + "%'");
            }
            else if (field.Equals("firstName"))
            {
                query = query.Replace("<SEARCH>", "AND U.firstName LIKE '%" + value + "%'");
            }
            else if (field.Equals("surName"))
            {
                query = query.Replace("<SEARCH>", "AND U.surName LIKE '%" + value + "%'");
            }

            if (!"".Equals(data.getString("date")))
            {
                query = query.Replace("<DATE>", "AND H.date = CONVERT(datetime, @date, 103)");
            }
            else
            {
                query = query.Replace("<DATE>", "");
            }
            return select(query, data);
        }

 /// <summary>
 /// create a report for payment
 /// </summary>
 /// <param name="data"></param>
 /// <returns></returns>
 public override bool create(Data data)
 {
     String date = DateTime.Now.Date.ToString().Substring(0, 10);
     data.add("date", date);
     data.add("total", float.Parse(data.getString("total")));
     String getId = "SELECT COUNT(*) + 1 AS NEW_ID FROM PaymentReport";
     String query = "UPDATE history SET payState = 1 WHERE PatientID = @PatientID";
     String mQuery = "UPDATE Medicine SET state = 1 WHERE historyId in (SELECT historyId FROM history WHERE PatientID = @PatientID)";
     String createQuery = @"INSERT INTO PaymentReport
                             (PaymentReportID, UserID, reportFilePath, total, date)
                             VALUES (@PaymentReportID, @PatientID, @reportFilePath, @total, convert(datetime, @date, 103))";
     dbc = new DBC();
     dbc.open();
     Object id = dbc.select(getId, new Data()).get("NEW_ID");
     data.add("PaymentReportID", id);
     dbc.update(query, data);
     dbc.update(mQuery, data);
     dbc.update(createQuery, data);
     dbc.close();
     return true;
 }

    protected override void Fire(object sender, EventArgs e)
    {
        if (!UserInfo.isPharmacist(Session))
        {
            alertAndGoback("you are not a Pharmacist. Please login");
            return;
        }
        Data result = new Data();
        Data data = new Data();
        MedicineBiz bizz = new MedicineBiz();
        data.add("doctorId", UserInfo.getId(Session));
        data.add("historyId", Param.get("historyId"));
        historyId.Value = Param.getString("historyId");
        String rId = Param.getString("rId");
        if (!"".Equals(rId))
        {
            data.add("medicineId", rId);
            bizz.delete(data);
        }
        PharmacistBiz biz = new PharmacistBiz();
        result = biz.view(data);
        userNameLabel.Text = result.getString("UserSurName") + "," + result.getString("UserFirstName") + ",ID:" + result.getString("UserID");
        Usermed.Text = result.getString("UserOD");
        Memo.Text = result.getString("Memo");
        UserID.Text = result.getString("UserID");
        OrderID.Text = result.getString("historyId");

        Data itemReslt = bizz.getItems("", data);
        Data medicineResult = bizz.view(data);

        MedicineDroplist.DataSource = itemReslt.Source;
        MedicineDroplist.DataBind();

        Medicinelist.DataSource = medicineResult.Source;
        Medicinelist.DataBind();
    }

        /// <summary>
        /// get a report for patients number
        /// </summary>
        /// <param name="data"></param>
        /// <returns></returns>
        public Data getPatientReport(Data data)
        {
            String startDate = data.getString("startDate");
            String endDate = data.getString("endDate");
            String today = DateTime.Now.Date.ToString().Substring(0, 10);
            if ("".Equals(startDate))
            {
                data.add("startDate", today);
            }
            if ("".Equals(startDate))
            {
                data.add("endDate", today);
            }

            String query = @"SELECT staffId, R.JobName, R.GroupName, COUNT(*) AS how_many_times
                            FROM history H, Users U, Roles R
                            WHERE U.UserID = H.staffId
                                AND R.JobCode = U.JobCode
                                AND H.date >= CONVERT(datetime, @startDate, 103)
                                AND H.date <= CONVERT(datetime, @endDate, 103)
                            GROUP BY H.staffId, R.JobName, R.GroupName
                            ORDER BY H.staffId ASC";

            Data result = select(query, data);
            return result;
        }

        /// <summary>
        /// create a new order data
        /// </summary>
        /// <param name="data"></param>
        /// <returns></returns>
        public override bool create(Data data)
        {
            String medication = data.getString("UsermedCheck");
            String UserNAA = data.getString("UserNAA");
            String UserStay = data.getString("UserStay");

            String doctorType = data.getString("JobCode");
            String payId = "11";
            DateTime xToday = DateTime.Now.Date;
            if ("19".Equals(doctorType))
            {
                payId = "15";
            }
            else if ("20".Equals(doctorType))
            {
                payId = "16";
            }
            data.add("PDate", xToday.ToString().Substring(0, 10));
            dbc = new DBC();
            dbc.open();
            Object orderId = dbc.select("SELECT COUNT(orderId) + 1 AS MAX_ID FROM DoctorsOrder", data).get("MAX_ID");
            data.add("orderId", orderId);
            dbc.update(@"INSERT INTO DoctorsOrder
                (DoctorID, UserID, orderId, UserOD, UsermedCheck, Usermed, Usernas, Userdosage, Userside, UserNAA, Memo, state)
                 VALUES   (@DoctorID, @UserID, @orderId, @UserOD, @UsermedCheck, @Usermed,
                 @Usernas, @Userdosage, @Userside, @UserNAA, @Memo, 0)", data);
            data.add("historyId", dbc.select(@"SELECT MAX(historyId) +1 AS MAX_ID FROM history", data).get("MAX_ID"));
            data.add("PDate", xToday.ToString().Substring(0, 10));
            dbc.update(@"INSERT INTO history
                (patientId, historyId, staffId, memo, type, cntId, date, payId)
                 VALUES   (@UserID, @historyId, @DoctorID, @Memo, 0, @orderId, CONVERT(datetime, @PDate, 103), " + payId + ")", data);
            // create a new appointment
            if ("True".Equals(UserNAA))
            {
                data.add("historyId", int.Parse(data.getString("historyId")) + 1);
                dbc.update(@"INSERT INTO history
                (patientId, historyId, staffId, memo, type, cntId, date)
                 VALUES   (@UserID, @historyId, @DoctorID, @Memo, -1, @orderId, CONVERT(datetime, @date, 103))", data);
            }
            // order medicine
            if ("True".Equals(medication))
            {

                String getPharmarcist = "SELECT UserID FROM Users WHERE JobCode = 16";
                String pharmacist = dbc.select(getPharmarcist, data).getString("UserID");
                data.add("staffID", pharmacist);
                data.add("historyId", int.Parse(data.getString("historyId")) + 1);
                dbc.update(@"INSERT INTO history
                (patientId, historyId, staffId, memo, type, cntId, date)
                 VALUES   (@UserID, @historyId, @staffID, @Usermed, -1, @orderId, CONVERT(datetime, @PDate, 103))", data);
            }
            // order user to stay hospital for a while
            if ("True".Equals(UserStay))
            {

                String getNurse = "SELECT UserID FROM Users WHERE JobCode = 18";
                String nurse = dbc.select(getNurse, data).getString("UserID");
                data.add("staffID", nurse);
                data.add("historyId", int.Parse(data.getString("historyId")) + 1);
                dbc.update(@"INSERT INTO history
                (patientId, historyId, staffId, memo, type, cntId, date)
                 VALUES   (@UserID, @historyId, @staffID, @Memo, -1, @orderId, CONVERT(datetime, @PDate, 103))", data);
            }
            dbc.close();
            return true;
        }

        /// <summary>
        /// search a list of payment reports
        /// </summary>
        /// <param name="searchField"></param>
        /// <param name="searchValue"></param>
        /// <param name="data"></param>
        /// <returns></returns>
        public Data reportList(String searchField, String searchValue, Data data)
        {
            String query = @"SELECT * FROM PaymentReport P, Users U
                            WHERE U.UserID = P.UserID
                                AND P.date >= CONVERT(datetime, @startDate, 103)
                                AND P.date <= CONVERT(datetime, @endDate, 103)
                                <SEARCH>
                                ORDER BY date DESC";
            String startDate = data.getString("startDate");
            String endDate = data.getString("endDate");
            String today = DateTime.Now.Date.ToString().Substring(0, 10);
            if ("".Equals(startDate))
            {
                data.add("startDate", today);
            }
            if ("".Equals(startDate))
            {
                data.add("endDate", today);
            }

            if ("none".Equals(searchField))
            {
                query = query.Replace("<SEARCH>", "");
            }
            else if ("UserID".Equals(searchField))
            {
                query = query.Replace("<SEARCH>", "AND P.UserID LIKE '%" + searchValue +"%'");
            }
            else if ("UserFirstName".Equals(searchField))
            {
                query = query.Replace("<SEARCH>", "AND U.UserFirstName LIKE '%" + searchValue + "%'");
            }
            else if ("UserSurName".Equals(searchField))
            {
                query = query.Replace("<SEARCH>", "AND U.UserSurName LIKE '%" + searchValue + "%'");
            }
            Data result = select(query, data);
            int count = result.Count;
            for (int i = 0; i < count; i++)
            {
                result.add(i, "date", result.getString(i, "date").Substring(0, 10));
            }
            return result;
        }

 /// <summary>
 /// get a list of pateints
 /// </summary>
 /// <param name="data"></param>
 /// <returns></returns>
 public Data getPatient(Data data)
 {
     return recData.getPatient(data.getString("searchField"), data.getString("searchValue"));
 }