private void ModificaDbPedidos(Pedidos pedFb, Pedidos pedDb)
{
try
{
string[] dats = { "AUTORIZACION", "SURTIR", "MODIFICACION" };
pedFb.estatuspedido = (pedDb.estatuspedido.In(dats)) ? pedDb.estatuspedido : "MODIFICACION";
var query = "update PEDIDO set " +
"CAN_TOT = " + pedFb.can_tot + ", IMP_TOT1 = " + pedFb.imp_tot1 + ", IMP_TOT2 = " + pedFb.imp_tot2 + ", " +
"IMP_TOT3 = " + pedFb.imp_tot3 + ", IMP_TOT4 = " + pedFb.imp_tot4 + ", DES_TOT = " + pedFb.des_tot + ", " +
"DES_FIN = " + pedFb.des_fin + ", COM_TOT = " + pedFb.com_tot + ", DES_FIN_PORC = " + pedFb.des_fin_porc + ", " +
"DES_TOT_PORC = " + pedFb.des_tot_porc + ", IMPORTE = " + pedFb.importe + ", COM_TOT_PORC = " + pedFb.com_tot_porc + ", " +
"ESTATUSPEDIDO = '" + pedFb.estatuspedido + "' " +
"where CVE_DOC = '" + pedFb.cve_doc + "'";
if (GetExecute("DB", query, 10))
{
List <DetallePedidos> listFbDetalle = CargaFbDetallePedido(pedFb.cve_doc);
List <DetallePedidos> listDbDetalle = CargaDbDetallePedido(pedFb.cve_doc);
var detalleAct = listFbDetalle.Where(o => listDbDetalle.Any(p => o.cve_art == p.cve_art)).ToList();
var detalleNuevos = listFbDetalle.Except(detalleAct).ToList();
var detalleExcluidos = listDbDetalle.Except(listDbDetalle.Where(o => listFbDetalle.Any(p => o.cve_art == p.cve_art))).ToList();
var detalleDiferentes = detalleAct.Except(detalleAct.Where(o => listDbDetalle.Any(p => p.cve_art == o.cve_art && p.cant == o.cant))).ToList();
foreach (var det in detalleNuevos)
{
GuardaDbDetallePedido(det);
}
foreach (var det in detalleExcluidos)
{
CancelaDbDetallePedido(det);
}
foreach (var detFB in detalleDiferentes)
{
DetallePedidos detDB = listDbDetalle.FirstOrDefault(o => o.cve_art == detFB.cve_art);
ModificaDbDetallePedido(detDB, detFB);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void CancelaDbDetallePedido(DetallePedidos det)
{
try
{
var query = "insert DETALLEPEDIDODEV (CVE_DOC, NUM_PAR, CVE_ART, CANT, PXS, PREC, COST, " +
"IMPU1, IMPU2, IMPU3, IMPU4, IMP1APLA, IMP2APLA, IMP3APLA, IMP4APLA, TOTIMP1, TOTIMP2, TOTIMP3, TOTIMP4, " +
"DESC1, DESC2, DESC3, COMI, APAR, ACT_INV, NUM_ALM, POLIT_APLI, TIP_CAM, UNI_VENTA, TIPO_PROD, CVE_OBS, REG_SERIE, " +
"E_LTPD, TIPO_ELEM, NUM_MOV, TOT_PARTIDA, IMPRIMIR) select CVE_DOC, NUM_PAR, CVE_ART, CANT, PXS, PREC, COST, " +
"IMPU1, IMPU2, IMPU3, IMPU4, IMP1APLA, IMP2APLA, IMP3APLA, IMP4APLA, TOTIMP1, TOTIMP2, TOTIMP3, TOTIMP4, " +
"DESC1, DESC2, DESC3, COMI, APAR, ACT_INV, NUM_ALM, POLIT_APLI, TIP_CAM, UNI_VENTA, TIPO_PROD, CVE_OBS, REG_SERIE, " +
"E_LTPD, TIPO_ELEM, NUM_MOV, TOT_PARTIDA, IMPRIMIR from DETALLEPEDIDO where CVE_DOC = '" + det.cve_doc + "' " +
"and CVE_ART = '" + det.cve_art + "' and isnull(SURTIDO,0) = 1 " +
"delete DETALLEPEDIDO where CVE_DOC = '" + det.cve_doc + "' and CVE_ART = '" + det.cve_art + "'";
var res = GetExecute("DB", query, 14);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void ModificaDbDetallePedido(DetallePedidos detDB, DetallePedidos detFB)
{
try
{
if (detDB.cantsurtido > 0)
{
if (detDB.cantsurtido > detFB.cant)
{
var dif = detDB.cantsurtido - detFB.cant;
var query2 =
"insert DETALLEPEDIDODEV (CVE_DOC, NUM_PAR, CVE_ART, CANT, PXS, PREC, COST, " +
"IMPU1, IMPU2, IMPU3, IMPU4, IMP1APLA, IMP2APLA, IMP3APLA, IMP4APLA, TOTIMP1, TOTIMP2, TOTIMP3, TOTIMP4, " +
"DESC1, DESC2, DESC3, COMI, APAR, ACT_INV, NUM_ALM, POLIT_APLI, TIP_CAM, UNI_VENTA, TIPO_PROD, CVE_OBS, REG_SERIE, " +
"E_LTPD, TIPO_ELEM, NUM_MOV, TOT_PARTIDA, IMPRIMIR) select CVE_DOC, NUM_PAR, CVE_ART, " + dif + ", PXS, PREC, COST, " +
"IMPU1, IMPU2, IMPU3, IMPU4, IMP1APLA, IMP2APLA, IMP3APLA, IMP4APLA, TOTIMP1, TOTIMP2, TOTIMP3 , TOTIMP4, " +
"DESC1, DESC2, DESC3, COMI, APAR, ACT_INV, NUM_ALM, POLIT_APLI, TIP_CAM, UNI_VENTA, TIPO_PROD, CVE_OBS, REG_SERIE, " +
"E_LTPD, TIPO_ELEM, NUM_MOV, TOT_PARTIDA, IMPRIMIR from DETALLEPEDIDO where CVE_ART = '" + detDB.cve_art + "' " +
"CVE_DOC = '" + detDB.cve_doc + "'";
GetExecute("DB", query2, 12);
detDB.cantsurtido = detFB.cant;
}
else
{
detFB.cant = detDB.cantsurtido;
}
}
var query3 = "update DETALLEPEDIDO SET CANT = " + detFB.cant + ", PXS = " + detFB.pxs + ", PREC = " + detFB.prec + ", COST = " + detFB.cost + ", " +
"IMPU1 = " + detFB.impu1 + ", IMPU2 = " + detFB.impu2 + ", IMPU3 = " + detFB.impu3 + ", IMPU4 = " + detFB.impu4 + ", " +
"IMP1APLA = " + detFB.imp1apla + ", IMP2APLA = " + detFB.imp2apla + ", IMP3APLA = " + detFB.imp3apla + ", IMP4APLA = " + detFB.imp4apla + ", " +
"TOTIMP1 = " + detFB.totimp1 + ", TOTIMP2 = " + detFB.totimp2 + ", TOTIMP3 = " + detFB.totimp3 + ", TOTIMP4 = " + detFB.totimp4 + ", " +
"DESC1 = " + detFB.desc1 + ", DESC2 = " + detFB.desc2 + ", DESC3 = " + detFB.desc3 + ", COMI = " + detFB.comi + ", APAR = " + detFB.apar + ", " +
"NUM_ALM = " + detFB.num_alm + ", TIP_CAM = " + detFB.tip_cam + ", TOT_PARTIDA = " + detFB.tot_partida + ", " +
"CANTSURTIDO = " + detDB.cantsurtido + ", SURTIDO = 0 where CVE_ART = '" + detFB.cve_art + "' " +
"CVE_DOC = '" + detFB.cve_doc + "'";
GetExecute("DB", query3, 13);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void GuardaDbDetallePedido(DetallePedidos ped)
{
try
{
var query = "insert DETALLEPEDIDO (CVE_DOC, NUM_PAR, CVE_ART, CANT, PXS, PREC, COST, " +
"IMPU1, IMPU2, IMPU3, IMPU4, IMP1APLA, IMP2APLA, " +
"IMP3APLA, IMP4APLA, TOTIMP1, TOTIMP2, TOTIMP3, TOTIMP4, " +
"DESC1, DESC2, DESC3, COMI, APAR, ACT_INV, NUM_ALM, " +
"POLIT_APLI, TIP_CAM, UNI_VENTA, TIPO_PROD, CVE_OBS, REG_SERIE, " +
"E_LTPD, TIPO_ELEM, NUM_MOV, TOT_PARTIDA, IMPRIMIR) VALUES ( '" +
ped.cve_doc + "', " + ped.num_par + ", '" + ped.cve_art + "', " + ped.cant + ", " + ped.pxs + ", " + ped.prec + ", " + ped.cost + ", " +
ped.impu1 + ", " + ped.impu2 + ", " + ped.impu3 + ", " + ped.impu4 + ", " + ped.imp1apla + ", " + ped.imp2apla + ", " +
ped.imp3apla + ", " + ped.imp4apla + ", " + ped.totimp1 + ", " + ped.totimp2 + ", " + ped.totimp3 + ", " + ped.totimp4 + ", " +
ped.desc1 + ", " + ped.desc2 + ", " + ped.desc3 + ", " + ped.comi + ", '" + ped.apar + "', '" + ped.act_inv + "', " + ped.num_alm + ", '" +
ped.polit_apli + "', " + ped.tip_cam + ", '" + ped.uni_venta + "', '" + ped.tipo_prod + "', " + ped.cve_obs + ", " + ped.reg_serie + ", " +
ped.e_ltpd + ", '" + ped.tipo_elem + "', " + ped.num_mov + ", " + ped.tot_partida + ", '" + ped.imprimir + "')";
var res = GetExecute("DB", query, 9);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
