Esempio n. 1
0
    public void getMovementOrderOrg()
    {
        clSys  mu    = new clSys();
        string Comm1 = "select f2 movementTime from moveTime";

        System.Data.Common.DbDataReader R1 = mu.ExecuteReader(Comm1);

        string moveTime = mu.ExecuteScalar(Comm1);

        string[] moveDateAr = moveTime.Split(' ');
        string[] dateValue  = moveDateAr[0].Split('/');
        int      hours      = int.Parse(moveDateAr[1].Split(':')[0]);
        int      mins       = int.Parse(moveDateAr[1].Split(':')[1]);
        string   dataStr    = "";

        DateTime moveTimeDate = new DateTime(int.Parse(dateValue[2]), int.Parse(dateValue[1]), int.Parse(dateValue[0]),
                                             hours, mins, 0);

        if (DateTime.Now > moveTimeDate)
        {
            dataStr = getCurrentOrder();
        }
        else
        {
            dataStr = "{\"move\":\"0\"}";
        }
        R1.Close();

        HttpContext.Current.Response.Write(dataStr);
    }
Esempio n. 2
0
    public void getCampsSupervisors()
    {
        clSys  mu    = new clSys();
        string Comm1 = "select top 10 item_id id, f2 name, f3 age, f4 ageUnit, f5 address from persons";

        System.Data.Common.DbDataReader R1 = mu.ExecuteReader(Comm1);
        string json = "";

        if (R1.HasRows)
        {
            string dataStr = "";


            while (R1.Read())
            {
                dataStr += dataStr == "" ? "{\"id\":\"" + R1["id"] + "\",\"name\":\"" + R1["name"] + "\" "
                           + "\"}"
                    :
                           ","
                           + "{\"id\":\"" + R1["id"] + "\",\"name\":\"" + R1["name"] + "\" "
                           + "\"}";
            }
            json = "{\"success\":\"1\", \"error\":\"0\", \"title\"  :[" + dataStr + "]}";
        }
        else
        {
            json = "{\"success\":\"1\", \"error\":\"0\", \"title\"  :[{\"id\":\"noData\",\"name\":\"No data\"}]}";
        }
        R1.Close();



        HttpContext.Current.Response.Write(json);
    }
Esempio n. 3
0
    private string getCurrentOrder()
    {
        clSys mu = new clSys();

        string Comm1 = "select top 1 item_id campID, f2 campName,  f3 personID, f4 moveOrder from camps where f5 is null"
                       + " order by convert(int, f4) \n";

        System.Data.Common.DbDataReader R1 = mu.ExecuteReader(Comm1);
        string json = "";

        string dataStr = "";

        if (R1.HasRows)
        {
            while (R1.Read())
            {
                //dataStr += R1["campName"] + ", " + R1["personID"] + ", " + R1["moveOrder"] + " \n";
                dataStr = "{\"move\":\"1\", \"campID\":\"" + R1["campID"] + "\",\"campName\":\"" + R1["campName"] + "\", \"moveOrder\":\"" + R1["moveOrder"] + "\" } ";
            }
        }
        else
        {
            //return -1 means the cycle completed
            dataStr = "{\"move\":\"-1\"}";
        }
        R1.Close();
        return(dataStr);
    }
Esempio n. 4
0
    public void getMovementOrder(string campID)
    {
        //update the campID
        clSys  mu    = new clSys();
        string Comm1 = "update camps set f5='1' where item_id='" + campID + "'";

        mu.ExecuteNonQuery(Comm1);
        //select the new Camp
        String dataStr = getCurrentOrder();

        HttpContext.Current.Response.Write(dataStr);
    }