//Add public int GetMaxTimingTaskExchangeByIdExchange(ExchangeCompositeType ect) { param = new SqlParameter[1]; param[0] = new SqlParameter("@fiid_exchange", SqlDbType.Int) { Value = ect.iIdExchange }; DataTable dt = objDB.ExecStore("sp_selectMaxTimingByIdExchange", param); return(int.Parse(dt.Rows[0].ItemArray[0].ToString())); }
public ExchangeCompositeType getExchangeByPreFolioUnique(String sPreFolio) { var ect = new ExchangeCompositeType(); param = new SqlParameter[1]; param[0] = new SqlParameter("@fvprefolio_Exchange", SqlDbType.VarChar) { Value = sPreFolio }; DataTable dt = objDB.ExecStore("sp_selectExchangeByPreFolio", param); if (dt.Rows[0].ItemArray[18].ToString() != "") { ect.dAplicationDate = DateTime.Parse(dt.Rows[0].ItemArray[18].ToString()); } if (dt.Rows[0].ItemArray[8].ToString() != "") { // ect.dLimitDate = DateTime.Parse(dt.Rows[0].ItemArray[18].ToString()).ToShortDateString(); ect.iIdClient = int.Parse(dt.Rows[0].ItemArray[13].ToString()); } ect.iIdExchange = int.Parse(dt.Rows[0].ItemArray[0].ToString()); ect.iIdExchangeType = int.Parse(dt.Rows[0].ItemArray[12].ToString()); ect.iIdPlant = int.Parse(dt.Rows[0].ItemArray[11].ToString()); ect.iIdPriority = int.Parse(dt.Rows[0].ItemArray[15].ToString()); ect.iProductEngener = int.Parse(dt.Rows[0].ItemArray[17].ToString()); ect.iSerie = int.Parse(dt.Rows[0].ItemArray[16].ToString()); ect.iStatus = int.Parse(dt.Rows[0].ItemArray[10].ToString()); ect.sClient = dt.Rows[0].ItemArray[19].ToString(); ect.sContact = dt.Rows[0].ItemArray[4].ToString(); ect.sDescription = dt.Rows[0].ItemArray[1].ToString(); ect.sExchangeType = dt.Rows[0].ItemArray[20].ToString(); ect.sFolio = dt.Rows[0].ItemArray[5].ToString(); ect.sFolioPre = dt.Rows[0].ItemArray[6].ToString(); ect.sIssue = dt.Rows[0].ItemArray[2].ToString(); ect.sLastFolio = dt.Rows[0].ItemArray[9].ToString(); ect.sMeasure = dt.Rows[0].ItemArray[3].ToString(); ect.sPlant = dt.Rows[0].ItemArray[21].ToString(); ect.sPriority = dt.Rows[0].ItemArray[22].ToString(); ect.sProductEngener = dt.Rows[0].ItemArray[23].ToString(); ect.sProyect = dt.Rows[0].ItemArray[7].ToString(); ect.sReason = dt.Rows[0].ItemArray[14].ToString(); ect.sSerie = dt.Rows[0].ItemArray[24].ToString(); return(ect); }
//Add public errorCompositeType UpdateExchangeDateById(ExchangeCompositeType ect) { var lstError = new errorCompositeType(); try { bool bStatus = true; param = new SqlParameter[21]; param[0] = new SqlParameter("@fvdescription_Exchange", SqlDbType.VarChar) { Value = ect.sDescription }; param[1] = new SqlParameter("@fvissue_Exchange", SqlDbType.VarChar) { Value = ect.sIssue }; param[2] = new SqlParameter("@fvmeasure_Exchange", SqlDbType.VarChar) { Value = ect.sMeasure }; param[3] = new SqlParameter("@fvcontact_Exchange", SqlDbType.VarChar) { Value = ect.sContact }; param[4] = new SqlParameter("@fvfolio_Exchange", SqlDbType.VarChar) { Value = ect.sFolio }; param[5] = new SqlParameter("@fvprefolio_Exchange", SqlDbType.VarChar) { Value = ect.sFolioPre }; param[6] = new SqlParameter("@fvproyect_Exchange", SqlDbType.VarChar) { Value = ect.sProyect }; param[7] = new SqlParameter("@fdlimit_date_Exchange", SqlDbType.DateTime) { Value = ect.dLimitDate }; param[8] = new SqlParameter("@fvlast_folio_Exchange", SqlDbType.VarChar) { Value = ect.sLastFolio }; param[9] = new SqlParameter("@fistatus_Exchange", SqlDbType.Int) { Value = ect.iStatus }; param[10] = new SqlParameter("@fiid_plant", SqlDbType.Int) { Value = ect.iIdPlant }; param[11] = new SqlParameter("@fiid_Exchange_type", SqlDbType.Int) { Value = ect.iIdExchangeType }; param[12] = new SqlParameter("@fiid_client", SqlDbType.Int) { Value = ect.iIdClient }; param[13] = new SqlParameter("@fvreason_Exchange", SqlDbType.VarChar) { Value = ect.sReason }; param[14] = new SqlParameter("@fiid_priority", SqlDbType.Int) { Value = ect.iIdPriority }; param[15] = new SqlParameter("@fiid_serie_proyect", SqlDbType.Int) { Value = ect.iSerie }; param[16] = new SqlParameter("@fiid_product_engeener", SqlDbType.Int) { Value = ect.iProductEngener }; param[17] = new SqlParameter("@fiid_Exchange", SqlDbType.Int) { Value = ect.iIdExchange }; param[18] = new SqlParameter("@fi_idreview_logistic", SqlDbType.Int) { Value = ect.iReview }; param[19] = new SqlParameter("@fi_timing_exchange", SqlDbType.Int) { Value = ect.iTimingExchange }; param[20] = new SqlParameter("@fdaplication_date", SqlDbType.DateTime) { Value = ect.dAplicationDate }; objDB.ExecStoredIUD("sp_updateExchangeDate", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
private void Quote() { if (ddlPartListC.Items.Count > 0) { pnQuoteA.Visible = true; pnQuoteNon.Visible = false; var plct = new DS.SAI.Data.PartListCompositeType(); var plm = new PartListManager(); var ect = new DS.SAI.Data.ExchangeCompositeType(); var em = new ExchangeManager(); var qct = new DS.SAI.Data.QuoteCompositeType(); var qm = new QuoteManager(); qct.iExchange = int.Parse(lblIdExchange.Text.ToString()); qct.iPartList = int.Parse(ddlPartListC.SelectedValue.ToString()); plct = plm.getPartListById(int.Parse(ddlPartListC.SelectedValue.ToString())); ect = em.getExchangeById(int.Parse(lblIdExchange.Text)); lblNoParC.Text = plct.iNumber.ToString(); lblClientC.Text = ect.sClient.ToString(); lblProyectC.Text = ect.sProyect.ToString(); lblDescriptionC.Text = ect.sDescription.ToString(); if (qm.ExistQuoteDuplicate(qct)) { qct = qm.getQuoteById(qct); txtDateIn.Text = qct.dIn.ToShortDateString(); txtDateProm.Text = qct.dProm.ToShortDateString(); txtDateOut.Text = qct.dOut.ToShortDateString(); txtSOPClientC.Text = qct.SOPCliente; txtMoldC.Text = qct.iMoldProt.ToString(); txtMoldSC.Text = qct.iMoldSerie.ToString(); txtCFC.Text = qct.iCF.ToString(); txtDeviceC.Text = qct.iDevice.ToString(); txtObsoletC.Text = qct.iObsolet.ToString(); txtManEngC.Text = qct.iEngMan.ToString(); txtDesignC.Text = qct.iDesign.ToString(); txtComponentsC.Text = qct.iComponents.ToString(); txtOthersTitleWC.Text = qct.sOthers.ToString(); txtOthersWC.Text = qct.iOthers.ToString(); txtPaintC.Text = qct.iPaint.ToString(); txtEmpC.Text = qct.iEmp.ToString(); txtBankC.Text = qct.iBank.ToString(); txtPrue.Text = qct.iOthersC.ToString(); txtPoundC.Text = qct.iPound.ToString(); txtDelta1.Text = qct.iDelta1.ToString(); txtDelta2.Text = qct.iDelta2.ToString(); txtCost.Text = qct.iCost.ToString(); txtR1.Text = qct.iFR1.ToString(); txtR2.Text = qct.iFR2.ToString(); txtMoldPlazoC.Text = qct.iMoldP.ToString(); txtMoldProtC.Text = qct.iMoldProtP.ToString(); txtDateStart.Text = qct.iStart.ToString(); txtObsC.Text = qct.sDescription.ToString(); lblINVTotal.Text = qct.iTotalInv.ToString(); lblTotalPieceTotal.Text = qct.iTotalP.ToString(); chkMoldC.Checked = qct.bMoldProt; chkMoldSC.Checked = qct.bMoldSerie; chkCFC.Checked = qct.bCF; chkDeviceC.Checked = qct.bDevice; chkObsoletC.Checked = qct.bObsolet; chkManEngC.Checked = qct.bEngMan; chkDesingC.Checked = qct.bDesign; chkComponetsC.Checked = qct.bComponents; chkOthersWC.Checked = qct.bOthers; chkPaintC.Checked = qct.bPaint; chkEmpC.Checked = qct.bEmp; chkBankC.Checked = qct.bBank; setVisibleChecked(); BlockQuote(); btnUpdateQuote.Visible = true; btnUpdateQuoteGuardar.Visible = false; btnAddQuote.Visible = false; } else { clearControlsQuote(); UnblockQuote(); } } else { pnQuoteA.Visible = false; pnQuoteNon.Visible = true; } }