using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using MvcApplication1.Models;
using LibX.X;
using LibX.X.X.cifIO;
namespace MvcApplication1.Controllers
{
public class ClientesController : Controller
{
//
// GET: /FormularioClientes/
public ActionResult Formulario()
{
Parametros p = new Parametros();
ViewBag.doccli = p.comboBCT("TIPDOC");
ViewBag.paises = p.comboBCT("PAIS");
return View();
}
public ActionResult Listado(FormCollection form)
{
SqlDb odb = new SqlDb();
odb.AbrirDB();
odb.BeginTran();
ViewBag.doccli = form["doccli"];
cli.doccli = int.Parse(form["doccli"].ToString());
cli.numcli = long.Parse(form["numcli"].ToString());
cli.digcli = form["digcli"].ToString();
Cliente c = new Cliente();
try
{
cli.LeerCliente(odb);
c.doccli = cli.doccli;
c.numcli = cli.numcli;
c.nomabr = cli.nomabr;
odb.CommitTran();
odb.CerrarDB();
}
catch (Exception e)
{
c.nomabr = "NO HAY DATOS...";
}
return View(c);
}
}
}
Models / Cliente.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.ComponentModel.DataAnnotations;
namespace MvcApplication1.Models
{
public class Cliente
{
public int doccli {get; set;}
[StringLength(7)]
public long numcli {get; set;}
public int digcli {get; set;}
public String nomabr { get; set; }
}
}
Models / Parametros.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Web.UI.WebControls;
using LibX.X;
using LibX.X.Y.bctIO;
namespace MvcApplication1.Models
{
public class Parametros
{
public int ItemBCT { get; set; }
public List<System.Web.Mvc.SelectListItem> ItemBCTList { get; set; }
public List<System.Web.Mvc.SelectListItem> comboBCT(String tabla)
{
SqlDb odb = new SqlDb();
odb.AbrirDB();
odb.BeginTran();
des.LeerBCTPorTabla(odb, tabla);
List<System.Web.Mvc.SelectListItem> lista = new List<System.Web.Mvc.SelectListItem>();
for (int i = 0; i < odb.dt.Rows.Count; i++)
{
SelectListItem item = new SelectListItem { Value = odb.dt.Rows[i]["coddestab"].ToString(), Text = odb.dt.Rows[i]["coddestab"].ToString() + " - " + odb.dt.Rows[i]["descortab"].ToString() };
lista.Add(item);
/*
ItemBCTList = new List<System.Web.Mvc.SelectListItem>() {
new SelectListItem { Value = "1", Text = "Renault" },
new SelectListItem { Value = "2", Text = "Peugeot" } };
* */
}
odb.CommitTran();
odb.CerrarDB();
return lista;
// return ItemBCTList;
}
}
}
Models / Parametros.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Web.UI.WebControls;
using LibX.X;
using LibX.X.Y.bctIO;
namespace MvcApplication1.Models
{
public class Parametros
{
public int ItemBCT { get; set; }
public List<System.Web.Mvc.SelectListItem> ItemBCTList { get; set; }
public List<System.Web.Mvc.SelectListItem> comboBCT(String tabla)
{
SqlDb odb = new SqlDb();
odb.AbrirDB();
odb.BeginTran();
des.LeerBCTPorTabla(odb, tabla);
List<System.Web.Mvc.SelectListItem> lista = new List<System.Web.Mvc.SelectListItem>();
for (int i = 0; i < odb.dt.Rows.Count; i++)
{
SelectListItem item = new SelectListItem { Value = odb.dt.Rows[i]["coddestab"].ToString(), Text = odb.dt.Rows[i]["coddestab"].ToString() + " - " + odb.dt.Rows[i]["descortab"].ToString() };
lista.Add(item);
/*
ItemBCTList = new List<System.Web.Mvc.SelectListItem>() {
new SelectListItem { Value = "1", Text = "Renault" },
new SelectListItem { Value = "2", Text = "Peugeot" } };
* */
}
odb.CommitTran();
odb.CerrarDB();
return lista;
// return ItemBCTList;
}
}
}
Views / Clientes / Formulario.cshtml
<!DOCTYPE html>
@using MvcApplication1.Models
@model Cliente
@{
ViewBag.Title = "Formulario";
}
<link href="../../Content/themes/base/jquery-ui.css" rel="stylesheet" type="text/css" />
<script src="../../Scripts/jquery-1.10.2.js" type="text/javascript"></script>
<script src="../../Scripts/jquery-ui-1.10.3.js" type="text/javascript"></script>
@using (Html.BeginForm("Listado", "Clientes", FormMethod.Post))
{
@Html.DropDownList("doccli")
@Html.Label("Numcli")
@Html.TextBoxFor(m => m.numcli)
@Html.TextBoxFor(m => m.digcli)
<input id="Submit1" type="submit" value="submit" />
}
No hay comentarios:
Publicar un comentario