示例#1
0
        private void BindData(DbObject dbobj)
        {
            DataSet dsobj = new DataSet();

            SqlParameter[] parameters2 =
            {
                new SqlParameter("@OrgId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,OrgId),
            };
            dsobj=dbobj.dsRunProcedure("sp_SelectEquipAltLists",parameters2,"Lists");

            ddStatusId.DataSource = dsobj;
            ddStatusId.DataMember = "Lists";
            ddStatusId.DataValueField = "id";
            ddStatusId.DataTextField = "vchName";
            ddStatusId.DataBind();

            ddPMScheduleId.DataSource = dsobj;
            ddPMScheduleId.DataMember = "Lists1";
            ddPMScheduleId.DataValueField = "id";
            ddPMScheduleId.DataTextField = "vchName";
            ddPMScheduleId.DataBind();
            ddPMScheduleId.Items.Insert(0,"");

            ddInspectionId.DataSource = dsobj;
            ddInspectionId.DataMember = "Lists2";
            ddInspectionId.DataValueField = "id";
            ddInspectionId.DataTextField = "vchName";
            ddInspectionId.DataBind();
            ddInspectionId.Items.Insert(0,"");
        }
示例#2
0
        private void BindData(DbObject dbobj)
        {
            DataSet dsobj = new DataSet();

            SqlParameter[] parameters2 = {
                new SqlParameter("@OrgId",SqlDbType.Int)
                };
            parameters2[0].Value = OrgId;

            dsobj=dbobj.dsRunProcedure("sp_SelectEquipTypesMakesModels",parameters2,"Types");

            dsobj.Relations.Add( new DataRelation( "Types_Makes", dsobj.Tables["Types"].Columns["Id"], dsobj.Tables["Types1"].Columns["TypeId"] ) );
            dsobj.Relations.Add( new DataRelation( "Makes_Models", dsobj.Tables["Types1"].Columns["Id"], dsobj.Tables["Types2"].Columns["MakeId"] ) );

            ddTypeId.DataSource = dsobj;
            ddTypeId.DataMember = "Types";
            ddTypeId.DataValueField = "id";
            ddTypeId.DataTextField = "vchName";
            ddTypeId.DataBind();
            ddTypeId.Items.Insert(0,"");

            ddMakeId.DataSource = dsobj;
            ddMakeId.DataMember = "Types1";
            ddMakeId.DataValueField = "id";
            ddMakeId.DataTextField = "vchMakeName";
            ddMakeId.DataBind();
            ddMakeId.Items.Insert(0,"");

            ddModelId.DataSource = dsobj;
            ddModelId.DataMember = "Types2";
            ddModelId.DataValueField = "id";
            ddModelId.DataTextField = "vchModelName";
            ddModelId.DataBind();
            ddModelId.Items.Insert(0,"");

            ddDeptId.DataSource = dsobj;
            ddDeptId.DataMember = "Types3";
            ddDeptId.DataValueField = "id";
            ddDeptId.DataTextField = "vchName";
            ddDeptId.DataBind();
            ddDeptId.Items.Insert(0,"");

            ddLocationId.DataSource = dsobj;
            ddLocationId.DataMember = "Types4";
            ddLocationId.DataValueField = "id";
            ddLocationId.DataTextField = "vchName";
            ddLocationId.DataBind();
            ddLocationId.Items.Insert(0,"");

            ListLink1.DataBind();
            ListLink2.DataBind();
        }
示例#3
0
        private void BindData()
        {
            SqlParameter[] parameters = {
                new SqlParameter("@OrgId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,OrgId)
            };
            DbObject dbobj1 = new DbObject();
            dbobj1.CntOpen();

            DataGrid1.DataSource=dbobj1.drRunProcedure("sp_SelectEquipList",parameters);
            DataGrid1.DataBind();

            dbobj1.CntClose();
        }
示例#4
0
        private void btSave_FormSubmit(object sender, EventArgs e)
        {
            Trace.Write("btSave-UserId", UId.ToString());
            Trace.Write("btSave-SelectedValue",ddAssignTo.SelectedValue);

            SqlParameter[] parameters =
            {
                new SqlParameter("@OrgId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,OrgId),
                new SqlParameter("@UID",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,UId),
                new SqlParameter("@EquipId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,EquipId),
                new SqlParameter("@intAssignedTo",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,ddAssignTo.SelectedValue),
                new SqlParameter("@vchNote",SqlDbType.VarChar,250,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,tbNote.Text)
            };
            DbObject dbobj1 = new DbObject();
            dbobj1.intRunProcedure("sp_UpdateEquipAssignedTo",parameters);

            Response.Redirect(ParentPageURL);
        }
示例#5
0
        private void LoadData()
        {
            int returnValue;
            SqlCommand cmd;

            SqlParameter[] parameters =
            {
                new SqlParameter("@OrgId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,OrgId),
                new SqlParameter("@Id",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,EquipId),
                new SqlParameter("@vchEquipId",SqlDbType.Int,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@intYear",SqlDbType.Int,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@vchType",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@vchMake",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@vchModel",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@vchAssignedTo",SqlDbType.VarChar,100,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null)
            };
            DbObject dbobj = new DbObject();
            cmd = dbobj.cmdRunProcedure("sp_SelectEquipView",parameters,out returnValue);
            if(returnValue!=-1)
            {
                lbEquipId.Text=cmd.Parameters["@vchEquipId"].Value.ToString();
                lbTypeMakeModel.Text=cmd.Parameters["@vchType"].Value.ToString()+"/"+cmd.Parameters["@vchMake"].Value.ToString()+"/"+cmd.Parameters["@vchModel"].Value.ToString();
                lbYear.Text=cmd.Parameters["@intYear"].Value.ToString();
                lbAssignFrom.Text=cmd.Parameters["@vchAssignedTo"].Value.ToString();
            }
            SqlParameter[] parameters2 =
            {
                new SqlParameter("@OrgId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,OrgId),
                new SqlParameter("@EquipId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,EquipId)
            };
            DataSet dsobj=dbobj.dsRunProcedure("sp_SelectEquipAssignTo",parameters2,"Names");

            ddAssignTo.DataSource = dsobj;
            ddAssignTo.DataMember = "Names";
            ddAssignTo.DataValueField = "id";
            ddAssignTo.DataTextField = "vchName";
            ddAssignTo.DataBind();
            ddAssignTo.Items.Insert(0,new System.Web.UI.WebControls.ListItem("","0"));
        }
示例#6
0
        private void Page_Load(object sender, System.EventArgs e)
        {
            EquipId=Convert.ToInt32(Request.QueryString["id"]);

            if(EquipId==0){ //Add New
                string [,] arrBrdCrumbs = new string [2,2];
                arrBrdCrumbs[0,0]="../default.aspx";
                arrBrdCrumbs[0,1]="Home";
                arrBrdCrumbs[1,0]="list.aspx";
                arrBrdCrumbs[1,1]="Equipment List";
                PageTitle = "Add Equipment";
                Header.BrdCrumbs=ParseBreadCrumbs(arrBrdCrumbs,PageTitle);
                Header.PageTitle=PageTitle;

                ckReassign.Visible=false;
                lbAssignedToCap.Visible=false;
                lbReassignCap.Visible=false;
                lbReassignHelp.Visible=false;

            }else{
                string [,] arrBrdCrumbs = new string [3,2];
                arrBrdCrumbs[0,0]="../default.aspx";
                arrBrdCrumbs[0,1]="Home";
                arrBrdCrumbs[1,0]="list.aspx";
                arrBrdCrumbs[1,1]="Equipment List";
                arrBrdCrumbs[2,0]="view.aspx?id="+EquipId+"";
                arrBrdCrumbs[2,1]="Equipment Detail";
                PageTitle = "Equipment-Edit Main";
                Header.BrdCrumbs=ParseBreadCrumbs(arrBrdCrumbs,PageTitle);
                Header.PageTitle=PageTitle;
            }
            SaveCancelControl.ParentPageURL=ParentPageURL;
            #region Not Postback
            if(!Page.IsPostBack)//Not Postback
            {
                DbObject dbobj1 = new DbObject();
                if(EquipId!=0) //Look up existing values
                {
                    //Lookup current DB values

                    SqlParameter[] parameters =
                    {
                        new SqlParameter("@Action",SqlDbType.Char,1,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,"S"),
                        new SqlParameter("@OrgId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,OrgId),
                        new SqlParameter("@Id",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,EquipId),
                        new SqlParameter("@TypeId",SqlDbType.Int,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                        new SqlParameter("@MakeId",SqlDbType.Int,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                        new SqlParameter("@ModelId",SqlDbType.Int,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                        new SqlParameter("@vchEquipId",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                        new SqlParameter("@intYear",SqlDbType.Int,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                        new SqlParameter("@DeptId",SqlDbType.Int,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                        new SqlParameter("@LocId",SqlDbType.Int,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                        new SqlParameter("@vchAssignedTo",SqlDbType.VarChar,100,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                        new SqlParameter("@vchVinSerial",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                        new SqlParameter("@vchFuelCode",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null)
                    };
                    int returnValue;
                    //SqlCommand cmd = dbobj1.cmdRunProcedure("sp_SelectEquipDetail",parameters,out returnValue);
                    SqlCommand cmd = dbobj1.cmdRunProcedure("sp_EquipEditDetail",parameters,out returnValue);

                    if(returnValue!=-1)
                    {
                        ddTypeId.SelectedValue=cmd.Parameters["@TypeId"].Value.ToString();
                        ddMakeId.SelectedValue=cmd.Parameters["@MakeId"].Value.ToString();
                        ddModelId.SelectedValue=cmd.Parameters["@ModelId"].Value.ToString();
                        tbEquipId.Text=cmd.Parameters["@vchEquipId"].Value.ToString();
                        tbYear.Text=cmd.Parameters["@intYear"].Value.ToString();
                        ddDeptId.SelectedValue=cmd.Parameters["@DeptId"].Value.ToString();
                        ddLocationId.SelectedValue=cmd.Parameters["@LocId"].Value.ToString();
                        lbAssignedTo.Text=cmd.Parameters["@vchAssignedTo"].Value.ToString();
                        tbVinSerial.Text=cmd.Parameters["@vchVinSerial"].Value.ToString();
                        tbFuelCode.Text=cmd.Parameters["@vchFuelCode"].Value.ToString();
                    }
                    else //record not found
                    {
                        Response.Redirect("list.aspx");
                    }
                } //End looking up current values
                BindData(dbobj1);
            }//End Not Postback
            #endregion
        }
示例#7
0
        private void btSave_FormSubmit(object sender, EventArgs e)
        {
            EquipId=Convert.ToInt32(Request.QueryString["id"]);
            bool AddNew=false;
            if(EquipId==0){
                AddNew=true;
            }
            DbObject dbobj1 = new DbObject();
            SqlParameter[] parameters =
            {
                new SqlParameter("@Action",SqlDbType.Char,1,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,"U"),
                new SqlParameter("@OrgId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,OrgId),
                new SqlParameter("@Id",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,EquipId),
                new SqlParameter("@TypeId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,ddTypeId.SelectedValue),
                new SqlParameter("@MakeId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,ddMakeId.SelectedValue),
                new SqlParameter("@ModelId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,ddModelId.SelectedValue),
                new SqlParameter("@DeptId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,ddDeptId.SelectedValue),
                new SqlParameter("@LocId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,ddLocationId.SelectedValue),
                new SqlParameter("@intYear",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,tbYear.Text),
                new SqlParameter("@vchEquipId",SqlDbType.VarChar,25,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,tbEquipId.Text),
                new SqlParameter("@vchVinSerial",SqlDbType.VarChar,50,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,tbVinSerial.Text),
                new SqlParameter("@vchFuelCode",SqlDbType.VarChar,25,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,tbFuelCode.Text)
            };

            EquipId = dbobj1.intRunProcedure("sp_EquipEditDetail",parameters);

            if(ckReassign.Checked | AddNew==true){
                Response.Redirect("reassign.aspx?id="+EquipId+"");
                }
            else{
                Response.Redirect("view.aspx?id="+EquipId+"");
                }
        }
示例#8
0
        private void Page_Load(object sender, System.EventArgs e)
        {
            EquipId=Convert.ToInt32(Request.QueryString["id"]);

            PageTitle = "Equipment Detail";
            string [,] arrBrdCrumbs = new string [2,2];
            arrBrdCrumbs[0,0]="../default.aspx";
            arrBrdCrumbs[0,1]="Home";
            arrBrdCrumbs[1,0]="list.aspx";
            arrBrdCrumbs[1,1]="Equipment List";
            Header.BrdCrumbs=ParseBreadCrumbs(arrBrdCrumbs,PageTitle);
            Header.PageTitle=PageTitle;

            DbObject dbobj1 = new DbObject();

            SqlParameter[] parameters =
            {
                new SqlParameter("@OrgId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,OrgId),
                new SqlParameter("@Id",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,EquipId),
                new SqlParameter("@vchEquipId",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@intYear",SqlDbType.Int,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@vchType",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@vchMake",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@vchModel",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@vchDept",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@vchLocation",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@vchAssignedTo",SqlDbType.VarChar,100,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@vchVinSerial",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@vchStatus",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@vchPMSched",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@vchInspect",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@intCurrentUnits",SqlDbType.Int,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@dtInService",SqlDbType.SmallDateTime,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@dtAquired",SqlDbType.SmallDateTime,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@vchPurOrgContact",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@smPurAmount",SqlDbType.SmallMoney,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@intPurUnits",SqlDbType.Int,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@vchPurNotes",SqlDbType.VarChar,250,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@dtOutOfService",SqlDbType.SmallDateTime,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@dtDisposed",SqlDbType.SmallDateTime,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@vchDispOrgContact",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@smDispAmount",SqlDbType.SmallMoney,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@intDispUnits",SqlDbType.Int,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@vchDispNotes",SqlDbType.VarChar,250,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@vchDispMethod",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),

                new SqlParameter("@vchTransMake",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@vchTransModel",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@vchTransPart",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@vchTransSerial",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),

                new SqlParameter("@vchEngineMake",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@vchEngineModel",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@vchEnginePart",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@vchEngineSerial",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),

                new SqlParameter("@vchChasisMake",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
                new SqlParameter("@vchChasisNumber",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),

                new SqlParameter("@vchFuelCode",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null)
            };
            int returnValue;
            SqlCommand cmd = dbobj1.cmdRunProcedure("sp_SelectEquipView",parameters,out returnValue);

            lbYear.Text=cmd.Parameters["@intYear"].Value.ToString();
            lbDept.Text=cmd.Parameters["@vchDept"].Value.ToString();
            lbLoc.Text=cmd.Parameters["@vchLocation"].Value.ToString();
            lbVinSerial.Text=cmd.Parameters["@vchVinSerial"].Value.ToString();
            lbAssignedTo.Text=cmd.Parameters["@vchAssignedTo"].Value.ToString();

            lbStrEquipId.Text=cmd.Parameters["@vchEquipId"].Value.ToString();
            lbMake.Text=cmd.Parameters["@vchMake"].Value.ToString();
            lbModel.Text=cmd.Parameters["@vchModel"].Value.ToString();;
            lbType.Text=cmd.Parameters["@vchType"].Value.ToString();

            lbStatus.Text=cmd.Parameters["@vchStatus"].Value.ToString();
            lbPMSched.Text=cmd.Parameters["@vchPMSched"].Value.ToString();
            lbInspection.Text=cmd.Parameters["@vchInspect"].Value.ToString();
            lbUnits.Text=cmd.Parameters["@intCurrentUnits"].Value.ToString();

            lbDtInService.Text=String.Format("{0:d}",cmd.Parameters["@dtInService"].Value);
            lbDtAquired.Text=String.Format("{0:d}",cmd.Parameters["@dtAquired"].Value);
            lbVchPurOrgContact.Text=cmd.Parameters["@vchPurOrgContact"].Value.ToString();
            lbSmPurAmount.Text=String.Format("{0:0.00}",cmd.Parameters["@smPurAmount"].Value);
            lbIntPurUnits.Text=cmd.Parameters["@intPurUnits"].Value.ToString();
            lbVchPurNotes.Text=cmd.Parameters["@vchPurNotes"].Value.ToString();

            lbDtOutOfService.Text=String.Format("{0:d}",cmd.Parameters["@dtOutOfService"].Value);;
            lbDtDisposed.Text=String.Format("{0:d}",cmd.Parameters["@dtDisposed"].Value);;
            lbVchDispOrgContact.Text=cmd.Parameters["@vchDispOrgContact"].Value.ToString();;
            lbSmDispAmount.Text=String.Format("{0:0.00}",cmd.Parameters["@smDispAmount"].Value);;
            lbIntDispUnits.Text=cmd.Parameters["@intDispUnits"].Value.ToString();;
            lbVchDispNotes.Text=cmd.Parameters["@vchDispNotes"].Value.ToString();
            lbVchDispMethod.Text=cmd.Parameters["@vchDispMethod"].Value.ToString();

            lbTranMake.Text=cmd.Parameters["@vchTransMake"].Value.ToString();
            tbTransModel.Text=cmd.Parameters["@vchTransModel"].Value.ToString();
            lbTranPart.Text=cmd.Parameters["@vchTransPart"].Value.ToString();
            lbTranSerial.Text=cmd.Parameters["@vchTransSerial"].Value.ToString();

            lbEngineMake.Text=cmd.Parameters["@vchEngineMake"].Value.ToString();
            lbEngineModel.Text=cmd.Parameters["@vchEngineModel"].Value.ToString();
            lbEnginePart.Text=cmd.Parameters["@vchEnginePart"].Value.ToString();
            lbEngineSerial.Text=cmd.Parameters["@vchEngineSerial"].Value.ToString();

            lblChasisMake.Text = cmd.Parameters["@vchChasisMake"].Value.ToString();
            lblChasisNumber.Text = cmd.Parameters["@vchChasisNumber"].Value.ToString();

            lbFuelCode.Text=cmd.Parameters["@vchFuelCode"].Value.ToString();
        }