Exemple #1
0
        private List <VTFormObject> helperSummary(string str_cmd)
        {
            connect();

            List <VTFormObject> list_VTFormObject = new List <VTFormObject>();

            OdbcCommand    cmd = new OdbcCommand(str_cmd, conn);
            OdbcDataReader reader;
            VTFormObject   formObject  = null;
            string         header_name = string.Empty;

            reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            while (reader.Read())
            {
                string _return = reader["return"].ToString().Trim();
                string _msg    = reader["message"].ToString().Trim();
                // If the query passes
                if (_return == "0")
                {
                    // Check if it is the first call
                    if (header_name != reader["Header_Name"].ToString().Trim())
                    {
                        if (!(header_name == ""))
                        {
                            list_VTFormObject.Add(formObject);
                        }

                        header_name             = reader["Header_Name"].ToString().Trim();
                        formObject              = new VTFormObject();
                        formObject.HeaderTitle  = header_name;
                        formObject.SerialNumber = reader["Serial_Number"].ToString().Trim();
                        formObject.ProductLine  = reader["Product_Line"].ToString().Trim();
                        formObject.TubeType     = reader["Tube_Type"].ToString().Trim();
                        formObject.TimeStamp    = reader["Header_Date"].ToString().Trim();
                        formObject.return_num   = _return;
                    }

                    VTFieldObject fieldObject = new VTFieldObject();
                    fieldObject.HeaderName = header_name;
                    fieldObject.Token      = reader["Detail_Token"].ToString().Trim();
                    fieldObject.Label      = reader["Default_Label"].ToString().Trim() + ": ";
                    fieldObject.Spec       = reader["Default_Spec"].ToString().Trim();
                    fieldObject.Value      = reader["Detail_Data"].ToString().Trim();
                    // Add the object to the formObjects list of fieldObjects
                    formObject.FieldList.Add(fieldObject);
                }

                // Cover the error case
                else
                {
                    formObject = new VTFormObject();
                    formObject.error_message = _msg;
                    formObject.return_num    = _return;
                    list_VTFormObject.Add(formObject);
                    return(list_VTFormObject); // Returns, due to an error case
                }
            }
            list_VTFormObject.Add(formObject); // Adds the last header
            return(list_VTFormObject);
        }
Exemple #2
0
        /**
         * Method : helperReadCmdAllHeaders
         * Fuction : Reads the cmd, parses all of the header titles and header token into a list.
         * Paramaters : string cmd to the db
         * Return : A list filled with tokens and titles of the forms.@
         * */
        private List <VTFormObject> helperReadCmdAllHeaders(string str_cmd)
        {
            connect();

            List <VTFormObject> list_VTFormObject = new List <VTFormObject>();

            OdbcCommand    cmd = new OdbcCommand(str_cmd, conn);
            OdbcDataReader reader;


            reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            while (reader.Read())
            {
                string       _return    = reader["return"].ToString().Trim();
                string       _msg       = reader["message"].ToString().Trim();
                VTFormObject formObject = new VTFormObject();
                if (_return == "0")
                {
                    // Sets the form object properties
                    formObject.HeaderTitle = reader["Obj_Name"].ToString().Trim();
                    formObject.HeaderToken = reader["Obj_Token"].ToString().Trim();
                    formObject.Username    = reader["Username"].ToString().Trim();
                    formObject.TubeType    = reader["Tube_Type"].ToString().Trim();
                    formObject.ProductLine = reader["Product_Line"].ToString().Trim();
                    formObject.HasActivity = reader["hasActivity"].ToString().Trim();
                    formObject.Status      = reader["Status"].ToString().Trim();
                    if (formObject.Status == "0")
                    {
                        formObject.Status = "1";
                    }
                    formObject.return_num = _return;
                }
                else
                {
                    formObject.error_message = _msg;
                    formObject.return_num    = _return;
                }
                list_VTFormObject.Add(formObject);
            }

            return(list_VTFormObject);
        }