//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;
}
}
