public PartListCompositeType GetPartListById(int iIdPartList) { var et = new PartListCompositeType(); param = new SqlParameter[1]; param[0] = new SqlParameter("@fiid_part_list", SqlDbType.Int) { Value = iIdPartList }; DataTable dt = objDB.ExecStore("sp_getPartListById", param); et.iIdPart = int.Parse(dt.Rows[0].ItemArray[0].ToString()); et.iNumber = dt.Rows[0].ItemArray[1].ToString(); et.sDescription = dt.Rows[0].ItemArray[2].ToString(); et.bStatus = bool.Parse(dt.Rows[0].ItemArray[4].ToString()); et.iNumberClient = dt.Rows[0].ItemArray[3].ToString(); return(et); }
/// <summary> /// Obtiene todos los Tipos de Cambio /// </summary> /// <returns></returns> public List <PartListCompositeType> getAll() { var lst = new List <PartListCompositeType>(); DataTable dt = objDB.Consult("sp_selectPartList"); foreach (DataRow dr in dt.Rows) { var et = new PartListCompositeType { iIdPart = int.Parse(dr.ItemArray[0].ToString()), iNumber = dr.ItemArray[1].ToString(), sDescription = dr.ItemArray[2].ToString(), bStatus = bool.Parse(dr.ItemArray[4].ToString()), iNumberClient = dr.ItemArray[3].ToString() }; lst.Add(et); } return(lst); }
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; } }