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")); }
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 }
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(); }