function Recordset(arrFieldNames,arrData,arrType) {
    this.Columns = arrFieldNames;
    this.Data = arrData;
    this.DataDelete = new Array();
    this.Type = arrType;
    this.Columns.Count = this.Columns.length;
    this.Record = 0;
    this.AbsolutePosition = 1;
    this.EOF = false;
    this.BOF = false;
    this.RecordCount = arrData.length;

    this.Fields = Recordset_Fields;
    this.Move = Recordset_Move;
    this.MoveFirst = Recordset_MoveFirst;
    this.MoveNext = Recordset_MoveNext;
    this.MovePrevious = Recordset_MovePrevious;
    this.MoveLast = Recordset_MoveLast;
    this.AddNew = Recordset_AddNew;
    this.InsertNew = Recordset_InsertNew;
    this.Update = Recordset_Update;
	this.DsUpdate = Recordset_DsUpdate;
    this.Delete = Recordset_Delete;
    this.CheckPosition = Recordset_CheckPosition;
    this.Format = Recordset_Format;
    this.CheckPosition();
}

    function Recordset_Fields(x, debug) {
        this.Record = this.AbsolutePosition-1;
        if (isNaN(x*1)) {
            for (var i=0; i<this.Columns.length; i++) if (this.Columns[i].toUpperCase() == x.toUpperCase()) return (new Field(this.Columns[i], this.Data[this.Record][i],this.Type[i]));
        } else if (x < this.Data[this.Record].length) {
            return (new Field(this.Columns[x], this.Data[this.Record][x]),this.Type[x]);
        }
       // alert(this.Columns[x]);
        alert("JS Recordset error: Item (" + x + ") not found.");
        return (new Field(x, "",x));
    }

    function Recordset_Move(i) {
        this.Record = i;
        this.AbsolutePosition = i;
        this.CheckPosition();
    }

    function Recordset_MoveFirst() {
        this.Record = 0;
        this.AbsolutePosition = 1;
        this.EOF = false;
        this.BOF = false;
    }

    function Recordset_MoveNext() {
        this.Record++;
        this.AbsolutePosition++;
        this.CheckPosition(0);
    }

    function Recordset_MovePrevious() {
        this.Record--;
        this.AbsolutePosition--;
        this.CheckPosition(1);
    }

    function Recordset_MoveLast() {
        this.Record = this.Data.length-1;
        this.AbsolutePosition = this.Data.length;
        this.EOF = false;
        this.BOF = false;
    }

    function Recordset_AddNew(xFields, xValues) {
        this.Record = this.Data.length;
        this.AbsolutePosition = this.Data.length+1;
        this.Data[this.Data.length] = new Array(this.Columns.length);
        this.RecordCount = this.Data.length;
        if (this.Columns[this.Columns.length-1].toUpperCase() == "DATAROWSTATE")
        {
            this.Data[this.Record][this.Columns.length-1]="added";
        }
        if (xFields) this.Update(xFields, xValues);
    }
    function Recordset_InsertNew(xFields, xValues,r) {
        this.Record = this.Data.length;
        this.AbsolutePosition = this.Data.length+1;
        this.Data.splice(r,0,new Array(this.Columns.length));
        this.RecordCount = this.Data.length;
        alert("insert");
        this.Data[this.Record][this.Columns.length-1]!="added"
        if (xFields) this.Update(xFields, xValues);
    }
    function Recordset_Update(xFields, xValues) {
	   // alert("upd"+xFields+" "+xValues);
        this.Record = this.AbsolutePosition-1;
        if (typeof(xFields) == "string") {
            for (var i=0; i<this.Columns.length; i++) {
                if (this.Columns[i].toUpperCase() == xFields.toUpperCase()) {
	               // alert(this.Record+"  "+i);
	                //str=xValues;
	               // if (!xValues){str="";}
                    this.Data[this.Record][i] = xValues + "";
                    //$("alo").innerHTML=this.Data[this.Record][this.Columns.length-1];
					//alert(this.Data[this.Record][this.Columns.length-1]);
					if (this.Data[this.Record][this.Columns.length-1]!="added" && this.Data[this.Record][this.Columns.length-1]!="deleted" ){
                       this.Data[this.Record][this.Columns.length-1] = "modified";
                      // $("alo").innerHTML="intra";
					 // alert(this.Data[this.Record][i]+"  "+i);
					 }
                    return true;
                }
            }
            throw "JS Recordset error: Item (" + xFields + ") not found.";
        } else {
            if (xFields.length) for (var i=0; i<xFields.length; i++) this.Update(xFields[i], xValues[i]);
            return true;
        }
    }

    function Recordset_DsUpdate(xFields, xValues) {
        this.Record = this.AbsolutePosition-1;
        if (typeof(xFields) == "string") {
            for (var i=0; i<this.Columns.length; i++) {
                if (this.Columns[i].toUpperCase() == xFields.toUpperCase()) {
                    

	                //str=xValues;
	               // if (!xValues){str="";}	               
                    this.Data[this.Record][i] = this.Format(xValues + "",this.Type[i]);
                   // this.Data[this.Record][i] = str + "";
                    return true;
                }
            }
            throw "JS Recordset error: Item (" + xFields + ") not found.";
        } 
        else 
        {
            if (xFields.length) for (var i=0; i<xFields.length; i++) this.DsUpdate(xFields[i], xValues[i]);
            return true;
        }
    }

    function Recordset_Delete() {
	   // alert("sterg"+this.Record);
	   // alert(this.Data[this.Record]);
	    //this.Data[this.Columns.length-1][this.Record] = "deleted";
	    this.DataDelete.push(this.Data[this.Record]);
	   // this.DataDelete
	   // alert("Lungsterg"+this.DataDelete.length);
        this.Data.splice(this.Record,1);	  		
        this.RecordCount = this.Data.length;
        this.Record--;
        this.AbsolutePosition--;
        this.CheckPosition();
    }

    function Field(strName, strValue,strType) {
        this.Name = strName;
        this.Value = strValue;
        this.tip=strType;
    }

    function Recordset_CheckPosition(iDirection) {
        switch(iDirection) {
        case 0 : // forward - check EOF
            if (this.Record == this.Data.length) this.EOF = true;
            else this.EOF = false;
            break;

        case 1 : // backward - check BOF
            if (this.Record == -1) this.BOF = true;
            else this.BOF = false;
            break;
        
        default :
            if (this.Record == this.Data.length || this.Data.length == 0) this.EOF = true;
            else this.EOF = false;
            if (this.Record == -1 || this.Data.length == 0) this.BOF = true;
            else this.BOF = false;
        }
    }
    function Recordset_Format(val,tip){
	    switch(tip) {
		   case "int" : // integer
		      myval=parseInt(val);
		      return myval;
		      break;
		   case "decimal" : // decimal value
		      myval=parseFloat(val).toFixed(2);
		      return myval;
		      break;
		   case "double" : // double value
		      myval=parseFloat(val).toFixed(2);
		      return myval;
		      break;
		   case "string" : // decimal value		      
		      return val;
		      break;
		   case "dateTime" : // date format  value	
		      myval=val.substring(0,10);	      
		      return myval;
		      break;		      		      		   
		   default : 
		    return val;
	    }
    }