private void sbrAltaPedido() { try { cPedidosVenta.CabVenta cabven = (cPedidosVenta.CabVenta)bS1.Current; int vId = cabven.fncAlta(); if (vId == 0) { MessageBox.Show("No se ha podido dar de Alta el Pedido"); return; } sbrActuDatos(); bS1.MoveLast(); //bS1.Add(cabven); //bS1.MoveLast(); txCodCli.Focus(); btDel.Visible = true; } catch (Exception ex) { MessageBox.Show("No se ha podido dar de Alta el Pedido :'" + ex.Message + "'"); bS1.CancelEdit(); } }
private void sbrProcesoPedCli() { if (cParamXml.ActPedCli == "False") { return; } tiProces.Enabled = false; lbMen.Text = "Procesando Pedidos de Cliente"; Application.DoEvents(); DataTable dt = new DataTable(); string vNumSerie = SQLDataAccess.GenTraeNumSerie(cParamXml.NSerPedCli, false, cParamXml.strConec); string vSql = cConstantes.SQL_CabPed_Dbf; vSql = vSql.Replace("[?vbCr]", cConstantes.vbCtr.ToString()); vSql = vSql.Replace("[?vbLf]", cConstantes.vbLF.ToString()); vSql = vSql.Replace("[?NumPed]", vNumSerie); try { dt = SQLDataAccess.TraeDBF(vSql, cUtil.DBFConec(cParamXml.strOleDBConecDbf)); cPedidosVenta.CabVenta oCabPed = new cPedidosVenta.CabVenta(); cPedidosVenta.LinVenta oLinPed = new cPedidosVenta.LinVenta(); string vNumPed = ""; string vErr = ""; foreach (DataRow dr in dt.Rows) { vNumPed = dr["nnumped"].ToString(); if (oCabPed.fncAlta(dr)) { string vSql2 = cConstantes.SQL_LinPed_Dbf; vSql2 = vSql2.Replace("[?vbCr]", cConstantes.vbCtr.ToString()); vSql2 = vSql2.Replace("[?vbLf]", cConstantes.vbLF.ToString()); vSql2 = vSql2.Replace("[?NumPed]", vNumPed); DataTable dt2 = SQLDataAccess.TraeDBF(vSql2, cUtil.DBFConec(cParamXml.strOleDBConecDbf)); foreach (DataRow dr2 in dt2.Rows) { //DataRow dr2 = dt2.Rows[0]; if (!oLinPed.fncAltaLin(dr2)) { vErr = oLinPed.Error; lbError.Text = vErr; Application.DoEvents(); Thread.Sleep(5000); } } } else { vErr = oCabPed.Error; lbError.Text = vErr; Application.DoEvents(); Thread.Sleep(5000); } SQLDataAccess.GenSetNumSerie(cParamXml.NSerPedCli, vNumPed, cParamXml.strConec); } } catch (Exception ex) { lbError.Text = DateTime.Now.ToLongDateString() + "-- " + ex.Message; } lbMen.Text = ""; Application.DoEvents(); tiProces.Enabled = true; }