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