protected void Page_Load(object sender, EventArgs e)
{
if (!this.Page.IsPostBack)
{
string str = ALCSA.FWK.Web.Sitio.ExtraerValorQueryString(Request, "deudor");
this.txtnomDeudor.Text = Session["snomdeudor"].ToString();
if (Session["snoperacion"] == null)
{
txtNrooperacion.Text = ALCSA.FWK.Web.Sitio.ExtraerValorQueryString(Request, "estado");
}
else
{
txtNrooperacion.Text = Session["snoperacion"].ToString();
}
this.txtRutDeudor.Text = Session["srutdeudor"].ToString();
DataTable table = ConsultasEspecificas.ConMostrarDomicilios(str);
Session["Excel_domi_cilios"] = table;
Grilla.DataSource = table;
Grilla.DataBind();
if (ALCSA.FWK.Web.Sitio.ExtraerValorQueryStringComoEntero(Request, "cerrar").Equals(1))
{
btnCerrar.OnClientClick = "window.close();";
}
}
}
public void SetGrid(Grilla <CasillaNodo> grid)
{
this.grid = grid;
UpdateVisual();
grid.OnGridObjectChanged += Grid_OnGridValueChanged;
}
public Nodo Padre; // apuntador al nodo padre del nodo actual
public Nodo(Grilla <Nodo> grilla, int x, int y) //constructor de la clase nodo
{
this.grilla = grilla;
this.x = x;
this.y = y;
casillaValida = true;
}
private void CargarAlumnos()
{
cAlumno alumno = new cAlumno();
DataTable trdo = alumno.GetAlumnos();
Grilla.DataSource = trdo;
Grilla.DataBind();
}
protected void btnLimpiar_Click(object sender, EventArgs e)
{
txtId.Value = "0";
txtNombre.Text = "";
chkActivo.Checked = false;
tu.limpiar();
txtNombre.Focus();
Grilla.DataSource = null;
Grilla.DataBind();
}
public CasillaNodo(Grilla <CasillaNodo> grilla, int x, int y) //constructor de la clase nodo
{
this.grilla = grilla;
this.x = x;
this.y = y;
this.Grilla_Real = 0;
this.Grilla_Agente = -2;
this.Padre = null;
Visitado = false;
}
public static Contratos.Grilla <Contratos.Padre> ConvertirGrillaPadres(Grilla <Lógica.Padre> padres)
{
Contratos.Grilla <Contratos.Padre> GrillaPad = new Contratos.Grilla <Contratos.Padre>();
Contratos.Padre[] Pad = new Contratos.Padre[padres.CantidadRegistros];
int i = 0;
foreach (var item in padres.Lista)
{
Pad[i] = ConvertirPadre(item);
i++;
}
GrillaPad.CantidadRegistros = padres.CantidadRegistros;
GrillaPad.Lista = Pad;
return(GrillaPad);
}
private void EspecificaDeGastoUI_Load(object sender, EventArgs e)
{
WinForm.pfActiveControl(this, false);
prcActiveButton(true, false);
DatosTabla();
dgvPartidasEspecificas.DefaultCellStyle.ForeColor = Color.Black;
List <int> listaColumnas = new List <int>()
{
2, 2
};
Grilla.EsconderColumnas(dgvPartidasEspecificas, listaColumnas);
string[] cabeceras = { "Partida Específica", "Descripción" };
Grilla.PonerCabeceraAGrid(dgvPartidasEspecificas, cabeceras);
}
public static Contratos.Grilla <Directora> ConvertirGrillaDirectores(Grilla <Director> directores)
{
Contratos.Grilla <Directora> GrillaDir = new Contratos.Grilla <Directora>();
Directora[] Dir = new Directora[directores.CantidadRegistros];
int i = 0;
foreach (var item in directores.Lista)
{
Dir[i] = ConvertirDirector(item);
i = i + 1;
}
GrillaDir.Lista = Dir;
GrillaDir.CantidadRegistros = directores.CantidadRegistros;
return(GrillaDir);
}
public void TakeSnapshot(Grilla <Nodo> grid, Nodo current, List <Nodo> openList, List <Nodo> closedList)
{
GridSnapshotAction gridSnapshotAction = new GridSnapshotAction();
gridSnapshotAction.AddAction(HideNodeVisuals);
for (int x = 0; x < grid.GetWidth(); x++)
{
for (int y = 0; y < grid.GetHeight(); y++)
{
Nodo Nodo = grid.GetGridObject(x, y);
int CostoG = Nodo.CostoG;
int CostoH = Nodo.CostoH;
int CostoF = Nodo.CostoF;
Vector3 gridPosition = new Vector3(Nodo.x, Nodo.y) * grid.GetCellSize() + Vector3.one * grid.GetCellSize() * .5f;
bool isCurrent = Nodo == current;
bool isInOpenList = openList.Contains(Nodo);
bool isInClosedList = closedList.Contains(Nodo);
int tmpX = x;
int tmpY = y;
gridSnapshotAction.AddAction(() => {
Transform visualNode = visualNodeArray[tmpX, tmpY];
SetupVisualNode(visualNode, CostoG, CostoH, CostoF);
Color backgroundColor = UtilsClass.GetColorFromString("636363");
if (isInClosedList)
{
backgroundColor = new Color(1, 0, 0);
}
if (isInOpenList)
{
backgroundColor = UtilsClass.GetColorFromString("009AFF");
}
if (isCurrent)
{
backgroundColor = new Color(0, 1, 0);
}
visualNode.Find("sprite").GetComponent <SpriteRenderer>().color = backgroundColor;
});
}
}
gridSnapshotActionList.Add(gridSnapshotAction);
}
protected void btnLimpiar_Click(object sender, EventArgs e)
{
txtId.Value = "";
txtNombre.Text = "";
txtRut.Text = "";
txtDigito.Text = "";
txtRazonSocial.Text = "";
txtTelefono1.Text = "";
txtTelefono2.Text = "";
txtEmail.Text = "";
chkActivo.Checked = false;
proveedor.limpiar();
txtNombre.Focus();
Grilla.DataSource = null;
Grilla.DataBind();
}
public static Contratos.Grilla <Contratos.Hijo> ConvertirGrillaHijos(Grilla <Lógica.Hijo> hijos)
{
Contratos.Grilla <Contratos.Hijo> GrillaHijo = new Contratos.Grilla <Contratos.Hijo>();
Contratos.Hijo[] Hij = new Contratos.Hijo[hijos.CantidadRegistros];
int i = 0;
foreach (var item in hijos.Lista)
{
Hij[i] = ConvertirHijo(item);
i++;
}
GrillaHijo.CantidadRegistros = hijos.CantidadRegistros;
GrillaHijo.Lista = Hij;
return(GrillaHijo);
}
public void Setup(Grilla <CasillaNodo> grid)
{
visualNodeArray = new Transform[grid.GetWidth(), grid.GetHeight()];
for (int x = 0; x < grid.GetWidth(); x++)
{
for (int y = 0; y < grid.GetHeight(); y++)
{
Vector3 gridPosition = new Vector3(x, y) * grid.GetCellSize() + Vector3.one * grid.GetCellSize() * .5f;
Transform visualNode = CreateVisualNode(gridPosition);
visualNodeArray[x, y] = visualNode;
visualNodeList.Add(visualNode);
}
}
HideNodeVisuals();
}
public static Contratos.Grilla <Contratos.Docente> ConvertirGrillaDocentes(Grilla <Lógica.Docente> docentes)
{
Contratos.Grilla <Contratos.Docente> GrillaDoc = new Contratos.Grilla <Contratos.Docente>();
Contratos.Docente[] Doc = new Contratos.Docente[docentes.CantidadRegistros];
int i = 0;
foreach (var item in docentes.Lista)
{
Doc[i] = ConvertirDocente(item);
i = i + 1;
}
GrillaDoc.CantidadRegistros = docentes.CantidadRegistros;
GrillaDoc.Lista = Doc;
return(GrillaDoc);
}
private void CargaGrilla(int indice)
{
DataTable table = ConsultasEspecificas.ConsultaDatosGrillaDomicilios(
txtRut.Text,
txtNroOperacion.Text,
ddlCliente.SelectedValue
);
if (table != null && table.Rows.Count > 0)
{
Session["snomdeudor"] = table.Rows[0]["nomdeudor"].ToString();
Session["srutdeudor"] = table.Rows[0]["rut_deudor"].ToString();
}
Grilla.PageIndex = indice;
Grilla.DataSource = table;
Grilla.DataBind();
}
public void baseRender()
{
SkyBox.Render();
//Dibujar bounding boxes de los mesh (Debugging)
foreach (var plataforma in Plataformas)
{
RenderObject(plataforma.Mesh);
}
foreach (var pozo in ListaPozos)
{
RenderObject(pozo);
}
foreach (var caja in ListaCajasEmpujables)
{
RenderObject(caja.Mesh);
}
Grilla.render(Env.Frustum, ShowGrilla, this);
}
public void TakeSnapshotFinalPath(Grilla <CasillaNodo> grid, List <CasillaNodo> path)
{
GridSnapshotAction gridSnapshotAction = new GridSnapshotAction();
gridSnapshotAction.AddAction(HideNodeVisuals);
for (int x = 0; x < grid.GetWidth(); x++)
{
for (int y = 0; y < grid.GetHeight(); y++)
{
CasillaNodo CasillaNodo = grid.GetGridObject(x, y);
Vector3 gridPosition = new Vector3(CasillaNodo.x, CasillaNodo.y) * grid.GetCellSize() + Vector3.one * grid.GetCellSize() * .5f;
bool isInPath = path.Contains(CasillaNodo);
int tmpX = x;
int tmpY = y;
gridSnapshotAction.AddAction(() => {
Transform visualNode = visualNodeArray[tmpX, tmpY];
Color backgroundColor;
if (isInPath)
{
backgroundColor = new Color(0, 1, 0);
}
else
{
backgroundColor = UtilsClass.GetColorFromString("636363");
}
visualNode.Find("sprite").GetComponent <SpriteRenderer>().color = backgroundColor;
});
}
}
gridSnapshotActionList.Add(gridSnapshotAction);
}
protected void btnListar_Click(object sender, EventArgs e)
{
tu.Nombre = txtNombre.Text;
Grilla.DataSource = tu.listar();
Grilla.DataBind();
}
private void Grid_OnGridValueChanged(object sender, Grilla <CasillaNodo> .OnGridObjectChangedEventArgs e)
{
updateMesh = true;
}
private void Agregar()
{
if (txtCodigo.Text == "")
{
Mensaje("Debe ingresar un articulo");
return;
}
if (txtCantidad.Text == "")
{
Mensaje("Debe ingresar una cantidad");
return;
}
if (txtPrecio.Text == "")
{
Mensaje("Debe ingresar un precio");
return;
}
string Codigo = txtCodigo.Text;
if (fun.Buscar(tbCompra, "CodArticulo", Codigo) == true)
{
Mensaje("Ya se ha ingresado el articulo");
return;
}
int Libreria = 0;
string Nombre = "";
if (chkLibreria.Checked == true)
{
Nombre = txt_Nombre.Text;
Libreria = 1;
}
else
{
Nombre = txtNombreJuguete.Text;
Libreria = 0;
}
Int32 Cantidad = Convert.ToInt32(txtCantidad.Text);
Double Precio = fun.ToDouble(txtPrecio.Text);
Double Descuento = 0;
Double Efectivo = 0;
Double Tarjeta = 0;
if (txtEfectivo.Text != "")
{
Efectivo = Convert.ToDouble(txtEfectivo.Text);
}
if (txtTarjeta.Text != "")
{
Tarjeta = Convert.ToDouble(txtTarjeta.Text);
}
Double PorEfe = 0;
Double PorTar = 0;
if (txtPorEfe.Text != "")
{
PorEfe = Convert.ToDouble(txtPorEfe.Text);
}
if (txtPorTar.Text != "")
{
PorTar = Convert.ToDouble(txtPorTar.Text);
}
Indice = Indice + 1;
Double SubTotal = Cantidad * Precio;
string Val = Codigo + ";" + Nombre;
Val = Val + ";" + Cantidad.ToString();
Val = Val + ";" + Precio.ToString();
Val = Val + ";" + Descuento.ToString();
Val = Val + ";" + Efectivo.ToString().Replace(",", ".");
Val = Val + ";" + Tarjeta.ToString().Replace(",", ".");
Val = Val + ";" + SubTotal;
Val = Val + ";" + Libreria;
Val = Val + ";" + PorEfe;
Val = Val + ";" + PorTar;
Val = Val + ";" + Indice.ToString();
tbCompra = fun.AgregarFilas(tbCompra, Val);
Grilla.DataSource = tbCompra;
CalcularTotal();
LimpiarArticulo();
fun.AnchoColumnas(Grilla, "0;40;10;10;0;10;10;10;0;5;5;0");
txt_Codigo.Focus();
if (tbCompra.Rows.Count > 1)
{
Grilla.Sort(Grilla.Columns[11], ListSortDirection.Descending);
}
}
private void Agregar()
{
if (txtCodigo.Text == "")
{
Mensaje("Debe ingresar un articulo");
return;
}
if (txtCantidad.Text == "")
{
Mensaje("Debe ingresar una cantidad");
return;
}
if (txtPrecio.Text == "")
{
Mensaje("Debe ingresar un precio");
return;
}
Boolean Des = false;
if (chkDescuento.Visible == true)
{
if (chkDescuento.Checked == true)
{
Des = true;
}
}
//string Col = "CodArticulo;Nombre;Precio;Cantidad;Subtotal";
Int32 CodArticulo = Convert.ToInt32(txtCodigo.Text);
int Cantidad = Convert.ToInt32(txtCantidad.Text);
Double Precio = 0;
if (Des == false)
{
Precio = Convert.ToDouble(txtPrecio.Text);
}
if (Des == true)
{
Precio = Convert.ToDouble(txtDescuento.Text);
}
Double Subtotal = Precio * Cantidad;
string Nombre = txt_Nombre.Text;
if (fun.Buscar(tbVenta, "CodArticulo", CodArticulo.ToString()) == true)
{
Mensaje("Ya se ha ingresado el articulo");
return;
}
int Libreria = 1;
if (radioJugueteria.Checked == true)
{
Libreria = 0;
}
string Val = CodArticulo + ";" + Nombre;
Val = Val + ";" + Precio.ToString();
Val = Val + ";" + Cantidad.ToString();
Val = Val + ";" + Subtotal.ToString();
Val = Val + ";" + Indice.ToString();
Val = Val + ";" + Libreria;
tbVenta = fun.AgregarFilas(tbVenta, Val);
Indice = Indice + 1;
//Grilla.Sort(Grilla.Columns[3]), ListSortDirection.Ascending)
if (tbVenta.Rows.Count > 1)
{
Grilla.Sort(Grilla.Columns[5], ListSortDirection.Descending);
}
Grilla.DataSource = tbVenta;
Grilla.Columns[0].Visible = false;
Grilla.Columns[5].Visible = false;
Grilla.Columns[1].Width = 370;
Double Total = fun.TotalizarColumna(tbVenta, "Subtotal");
txtTotal.Text = Total.ToString();
txtTotalConDescuento.Text = Total.ToString();
txtCodigo.Text = "";
txt_Codigo.Text = "";
txt_CodigoBarra.Text = "";
txt_Stock.Text = "";
txtPrecio.Text = "";
txtCantidad.Text = "";
txt_Nombre.Text = "";
// Valida = false;
txt_CodigoBarra.Focus();
Grilla.Refresh();
if (tbVenta.Rows.Count > 0)
{
for (int i = 0; i < Grilla.Rows.Count - 1; i++)
{
if (i == 0)
{
Grilla.Rows[0].Selected = true;
}
else
{
Grilla.Rows[i].Selected = false;
}
}
}
//
}
public void Inicializar()
{
_punto = new Punto();
_grilla = new Grilla(_punto);
}
void muestra_productos()
{
String queryString = "Lista_Prod_Stock";
lbl_error.Text = "";
//lbl_status.Text = "";
using (MySqlConnection conn = new MySqlConnection(SMysql))
{
try
{
conn.Open();
MySqlCommand command = new MySqlCommand(queryString, conn);
command.CommandType = CommandType.StoredProcedure;
if (txt_codigo.Text == "")
{
command.Parameters.AddWithValue("@v_codigo", DBNull.Value);
}
else
{
command.Parameters.AddWithValue("@v_codigo", txt_codigo.Text);
}
command.Parameters["@v_codigo"].Direction = ParameterDirection.Input;
if (LstLineaVtas.SelectedItem.Value.ToString() == "0")
{
command.Parameters.AddWithValue("@v_id_linea_vta", DBNull.Value);
}
else
{
command.Parameters.AddWithValue("@v_id_linea_vta", LstLineaVtas.SelectedItem.Value.ToString());
}
command.Parameters["@v_id_linea_vta"].Direction = ParameterDirection.Input;
//var result = command.ExecuteNonQuery();
DataSet ds = new DataSet();
DataTable table = new DataTable();
MySqlDataAdapter mysqlDAdp = new MySqlDataAdapter(command);
///MySqlDataReader dr = command.ExecuteReader();
mysqlDAdp.Fill(table);
if (table.Rows.Count == 0)
{
lbl_mensaje.Text = "Sin Resultados";
}
else
{
Grilla.DataSource = table;
Grilla.DataBind();
}
lbl_mensaje.Text = "Cantidad de Registros: " + Grilla.Rows.Count.ToString();
conn.Close();
conn.Dispose();
}
catch (Exception ex)
{
conn.Close();
conn.Dispose();
lbl_error.Text = ex.Message;
}
}
}
public override void Init(GameModel _env)
{
//useShadows = false;
Env = _env;
string compilationErrors;
var d3dDevice = D3DDevice.Instance.Device;
shadowEffect = TgcShaders.loadEffect(Env.ShadersDir + "ShadowMap.fx");
skeletalShadowEffect = TgcShaders.loadEffect(Env.ShadersDir + "TgcSkeletalShadowMapMeshShader.fx");
shaderArbustos = TgcShaders.loadEffect(Env.ShadersDir + "movimientoArbustos.fx");
shaderLiquidos = TgcShaders.loadEffect(Env.ShadersDir + "movimientoLiquidos.fx");
shaderAceites = TgcShaders.loadEffect(Env.ShadersDir + "movimientoLiquidos.fx");
time = 0;
var dir = new TGCVector3(0, -1, 0);
dir.Normalize();
Lights.Add(new Tuple <float, TGCVector3, TGCVector3>(0.05f, new TGCVector3(0, 80, 100), dir));
dir = new TGCVector3(1, -2, 0);
dir.Normalize();
Lights.Add(new Tuple <float, TGCVector3, TGCVector3>(0.05f, new TGCVector3(220, 80, 390), dir));
Lights.Add(new Tuple <float, TGCVector3, TGCVector3>(0.05f, new TGCVector3(1370, 80, 57), new TGCVector3(0, -1, 0)));
Lights.Add(new Tuple <float, TGCVector3, TGCVector3>(0.05f, new TGCVector3(842, 80, -327), new TGCVector3(0, -1, 0)));
Lights.Add(new Tuple <float, TGCVector3, TGCVector3>(0.05f, new TGCVector3(1050, 80, -110), new TGCVector3(0, -1, 0)));
g_LightPos = new TGCVector3(140, 40, 390);
EfectoRender2D = Effect.FromFile(d3dDevice, Env.ShadersDir + "render2D.fx",
null, null, ShaderFlags.PreferFlowControl, null, out compilationErrors);
if (EfectoRender2D == null)
{
throw new Exception("Error al cargar shader. Errores: " + compilationErrors);
}
EfectoRender2D.SetValue("screen_dx", d3dDevice.PresentationParameters.BackBufferWidth);
EfectoRender2D.SetValue("screen_dy", d3dDevice.PresentationParameters.BackBufferHeight);
try
{
texturaVida = TextureLoader.FromFile(d3dDevice, Env.MediaDir + "\\Menu\\heart.png");
texturaLogo = TextureLoader.FromFile(d3dDevice, Env.MediaDir + "\\Menu\\LogoTGC.png");
}
catch
{
throw new Exception(string.Format("Error at loading texture: {0}", Env.MediaDir + "\\Menu\\heart.png"));
}
TextoLogo.Align = TgcText2D.TextAlign.LEFT;
TextoLogo.changeFont(new System.Drawing.Font("Comic Sans MS", 24, FontStyle.Bold));
TextoLogo.Position = new Point(D3DDevice.Instance.Width - 70, D3DDevice.Instance.Height - 65);
TextoLogo.Color = Color.White;
var PisoSelvaTexture = TgcTexture.createTexture(D3DDevice.Instance.Device, Env.MediaDir + "pasto.jpg");
PisoSelva1 = new TgcPlane(new TGCVector3(-81f, 0f, -74f), new TGCVector3(168f, 5f, 161f), TgcPlane.Orientations.XZplane, PisoSelvaTexture, 15, 15);
ListaPlanos.Add(PisoSelva1);
PisoSelva2 = new TgcPlane(new TGCVector3(-81f, 0f, 150f), new TGCVector3(168f, 5f, 110f), TgcPlane.Orientations.XZplane, PisoSelvaTexture, 15, 15);
ListaPlanos.Add(PisoSelva2);
PisoSelva3 = new TgcPlane(new TGCVector3(-81f, 0f, 278f), new TGCVector3(302f, 5f, 247f), TgcPlane.Orientations.XZplane, PisoSelvaTexture, 15, 15);
ListaPlanos.Add(PisoSelva3);
PisoSelva4 = new TgcPlane(new TGCVector3(309f, 0f, 278f), new TGCVector3(111f, 5f, 247f), TgcPlane.Orientations.XZplane, PisoSelvaTexture, 15, 15);
ListaPlanos.Add(PisoSelva4);
PisoSelva5 = new TgcPlane(new TGCVector3(595f, 0f, 236f), new TGCVector3(387f, 5f, 350f), TgcPlane.Orientations.XZplane, PisoSelvaTexture, 15, 15);
ListaPlanos.Add(PisoSelva5);
PisoSelva6 = new TgcPlane(new TGCVector3(707f, 0f, -50f), new TGCVector3(259f, 5f, 77f), TgcPlane.Orientations.XZplane, PisoSelvaTexture, 15, 15);
ListaPlanos.Add(PisoSelva6);
PisoSelva7 = new TgcPlane(new TGCVector3(834f, 0f, 49f), new TGCVector3(132f, 5f, 48f), TgcPlane.Orientations.XZplane, PisoSelvaTexture, 15, 15);
ListaPlanos.Add(PisoSelva7);
PisoSelva8 = new TgcPlane(new TGCVector3(707f, 0f, 147.5f), new TGCVector3(130f, 5f, 38f), TgcPlane.Orientations.XZplane, PisoSelvaTexture, 15, 15);
ListaPlanos.Add(PisoSelva8);
PisoSelva9 = new TgcPlane(new TGCVector3(707f, -0.1f, 0f), new TGCVector3(81f, 5f, 148f), TgcPlane.Orientations.XZplane, PisoSelvaTexture, 15, 15);
ListaPlanos.Add(PisoSelva9);
PisoSelva10 = new TgcPlane(new TGCVector3(881f, -0.1f, -0.2f), new TGCVector3(79.5f, 5f, 50f), TgcPlane.Orientations.XZplane, PisoSelvaTexture, 15, 15);
ListaPlanos.Add(PisoSelva10);
PisoSelva11 = new TgcPlane(new TGCVector3(883f, -0.1f, 96f), new TGCVector3(83f, 5f, 145f), TgcPlane.Orientations.XZplane, PisoSelvaTexture, 15, 15);
ListaPlanos.Add(PisoSelva11);
PisoSelva12 = new TgcPlane(new TGCVector3(43.7f, -0.1f, 219f), new TGCVector3(552f, 5f, 133.5f), TgcPlane.Orientations.XZplane, PisoSelvaTexture, 15, 15);
ListaPlanos.Add(PisoSelva12);
PisoSelva13 = new TgcPlane(new TGCVector3(218f, -0.1f, 432f), new TGCVector3(379f, 5f, 148.5f), TgcPlane.Orientations.XZplane, PisoSelvaTexture, 15, 15);
ListaPlanos.Add(PisoSelva13);
PisoSelva14 = new TgcPlane(new TGCVector3(-81f, -0.1f, 86f), new TGCVector3(40f, 5f, 193f), TgcPlane.Orientations.XZplane, PisoSelvaTexture, 15, 15);
ListaPlanos.Add(PisoSelva14);
PisoSelva15 = new TgcPlane(new TGCVector3(41f, -0.1f, 82f), new TGCVector3(46f, 5f, 70f), TgcPlane.Orientations.XZplane, PisoSelvaTexture, 15, 15);
ListaPlanos.Add(PisoSelva15);
PisoSelva16 = new TgcPlane(new TGCVector3(705f, -0.1f, 185f), new TGCVector3(84f, 5f, 58f), TgcPlane.Orientations.XZplane, PisoSelvaTexture, 15, 15);
ListaPlanos.Add(PisoSelva16);
var PisoCastilloTexture = TgcTexture.createTexture(D3DDevice.Instance.Device, Env.MediaDir + "rockfloor.jpg");
PisoCastillo1 = new TgcPlane(new TGCVector3(791f, 21f, -155.4f), new TGCVector3(91f, 5f, 27.7f), TgcPlane.Orientations.XZplane, PisoCastilloTexture, 15, 15);
ListaPlanos.Add(PisoCastillo1);
PisoCastillo2 = new TgcPlane(new TGCVector3(776f, 21f, -604f), new TGCVector3(218.2f, 5f, 331.3f), TgcPlane.Orientations.XZplane, PisoCastilloTexture, 15, 15);
ListaPlanos.Add(PisoCastillo2);
PisoCastillo3 = new TgcPlane(new TGCVector3(1088.4f, 21f, -607.2f), new TGCVector3(158.8f, 5f, 118f), TgcPlane.Orientations.XZplane, PisoCastilloTexture, 15, 15);
ListaPlanos.Add(PisoCastillo3);
PisoCastillo4 = new TgcPlane(new TGCVector3(1436.2f, 21f, -611.2f), new TGCVector3(270.4f, 5f, 331.4f), TgcPlane.Orientations.XZplane, PisoCastilloTexture, 15, 15);
ListaPlanos.Add(PisoCastillo4);
PisoCastillo5 = new TgcPlane(new TGCVector3(1614.6f, 21f, -279.9f), new TGCVector3(87.65f, 5f, 97.9f), TgcPlane.Orientations.XZplane, PisoCastilloTexture, 15, 15);
ListaPlanos.Add(PisoCastillo5);
PisoCastillo6 = new TgcPlane(new TGCVector3(1538.2f, 21f, -182.5f), new TGCVector3(169f, 5f, 58.6f), TgcPlane.Orientations.XZplane, PisoCastilloTexture, 15, 15);
ListaPlanos.Add(PisoCastillo6);
PisoCastillo7 = new TgcPlane(new TGCVector3(1485f, 21f, -75.5f), new TGCVector3(228f, 5f, 192.2f), TgcPlane.Orientations.XZplane, PisoCastilloTexture, 15, 15);
ListaPlanos.Add(PisoCastillo7);
PisoCastillo8 = new TgcPlane(new TGCVector3(1540f, 21f, -124.36f), new TGCVector3(58.35f, 5f, 49.16f), TgcPlane.Orientations.XZplane, PisoCastilloTexture, 15, 15);
ListaPlanos.Add(PisoCastillo8);
PisoCastillo9 = new TgcPlane(new TGCVector3(986f, 21f, -108.7603f), new TGCVector3(134.15f, 5f, 223.6003f), TgcPlane.Orientations.XZplane, PisoCastilloTexture, 15, 15);
ListaPlanos.Add(PisoCastillo9);
PisoCastillo10 = new TgcPlane(new TGCVector3(951f, 21f, -225f), new TGCVector3(130f, 5f, 116.2397f), TgcPlane.Orientations.XZplane, PisoCastilloTexture, 15, 15);
ListaPlanos.Add(PisoCastillo10);
PisoCastillo11 = new TgcPlane(new TGCVector3(1080f, 21f, -185f), new TGCVector3(50f, 5f, 80f), TgcPlane.Orientations.XZplane, PisoCastilloTexture, 15, 15);
ListaPlanos.Add(PisoCastillo11);
var Acido = TgcTexture.createTexture(D3DDevice.Instance.Device, Env.MediaDir + "slime7.jpg");
PisoAcido = new TgcPlane(new TGCVector3(1427f, -228.4502f, -1000f), new TGCVector3(400f, 5f, 450f), TgcPlane.Orientations.XZplane, Acido, 15, 15);
ListaPlanoAcido.Add(PisoAcido);
//Crear SkyBox
CreateSkyBox(TGCVector3.Empty, new TGCVector3(10000, 10000, 10000), "SkyBox1");
// Cargar escena
Loader = new TgcSceneLoader();
Scene = Loader.loadSceneFromFile(Env.MediaDir + "\\" + "Escenario1\\escenarioConLogos-TgcScene.xml");
Reset();
///////////agrego pisos subterraneos
ListaPisosSubterraneos = Scene.Meshes.FindAll(m => m.Name.Contains("Floor"));
foreach (var piso in ListaPisosSubterraneos)
{
Scene.Meshes.Remove(piso);
}
// Paredes
ListaParedesCastillo = Scene.Meshes.FindAll(m => m.Name.Contains("ParedCastillo"));
TgcMesh paredSinBB = Scene.Meshes.Find(m => m.Name.Contains("ParedCastillo441"));
foreach (var m in ListaParedesCastillo)
{
m.AutoTransform = false;
var p = (m.BoundingBox.PMax + m.BoundingBox.PMin) * 0.5f;
var t = new TGCVector3(0, 20.8f, 0);
m.Transform = TGCMatrix.Translation(-1 * p) * TGCMatrix.Translation(t + p);
m.BoundingBox.scaleTranslate(new TGCVector3(0, 21, 0), new TGCVector3(1, 1, 1));
}
ListaParedesCastillo.Remove(paredSinBB); //elimino la pared que no necesita agrandar su BB
foreach (var m in ListaParedesCastillo)
{
m.BoundingBox = new TgcBoundingAxisAlignBox(m.BoundingBox.PMin - new TGCVector3(5, 0, 5), m.BoundingBox.PMax + new TGCVector3(5, 0, 5));
}
// Paredes envolventes
ListaParedesEnvolventes = Scene.Meshes.FindAll(m => m.Name.Contains("ParedEnvolvente") || m.Name.Contains("Room"));
foreach (var m in ListaParedesEnvolventes)
{
m.BoundingBox = new TgcBoundingAxisAlignBox(m.BoundingBox.PMin - new TGCVector3(5, 0, 5), m.BoundingBox.PMax + new TGCVector3(5, 0, 5));
}
// Paredes de caida
ListaParedesCaida = Scene.Meshes.FindAll(m => m.Name.Contains("Plane"));
foreach (var m in ListaParedesCaida)
{
var agregado = new TGCVector3(3, -0.8f, 3);
m.BoundingBox = new TgcBoundingAxisAlignBox(m.BoundingBox.PMin - agregado, m.BoundingBox.PMax + agregado);
}
// Pozos
ListaPozos = Scene.Meshes.FindAll(m => m.Name.Contains("Pozo"));
foreach (var mesh in ListaPozos)
{
Scene.Meshes.Remove(mesh);
}
// Logos
ListaLogos = Scene.Meshes.FindAll(m => m.Name.Contains("LogoTGC"));
CantLogos = ListaLogos.Count;
// Alargar algunas AABB
var r = new Random();
foreach (var mesh in Scene.Meshes.FindAll(m => m.Name.Contains("Arbusto")))
{
mesh.BoundingBox.scaleTranslate(new TGCVector3(0, 0, 0), new TGCVector3(1, 10, 1));
mesh.AutoTransform = false;
var ang = r.Next(0, 360);
var p = (mesh.BoundingBox.PMax + mesh.BoundingBox.PMin) * 0.5f;
var s = new TGCVector3(((float)r.Next(90, 110)) / 100f, 1, ((float)r.Next(90, 110)) / 100f);
var rango = 6;
var t = new TGCVector3(((float)r.Next(-rango * 100, rango * 100)) / 100f, 0, ((float)r.Next(-rango * 100, rango * 100)) / 100f);
mesh.Transform = TGCMatrix.Translation(-1 * p) * TGCMatrix.Scaling(s) * TGCMatrix.RotationY(ang) * TGCMatrix.Translation(t + p);
}
foreach (var mesh in Scene.Meshes.FindAll(m => m.Name.Contains("Flores")))
{
mesh.BoundingBox.scaleTranslate(new TGCVector3(0, 0, 0), new TGCVector3(1, 10, 1));
}
ListaPisosResbalosos = Scene.Meshes.FindAll(m => m.Name.Contains("PisoResbaloso"));
ListaMeshesSinColision.Add(Scene.Meshes.Find(m => m.Name.Contains("ParedEnvolvente001233")));
ListaMeshesSinColision.Add(Scene.Meshes.Find(m => m.Name.Contains("ParedEnvolvente001248")));
// Cajas Empujables
/*TgcMesh MeshEmpujable = Scene.Meshes.Find(m => m.Name.Contains("Caja3"));
* Scene.Meshes.Remove(Scene.Meshes.Find(m => m.Name.Contains("Caja3")));
* TGCVector3 PosicionMeshEmpujable = MeshEmpujable.Position;
* CajaEmpujable CajaEmpujable = new CajaEmpujable(MeshEmpujable, new TGCVector3(0f, 0f, 0f));
* ListaCajasEmpujables.Add(CajaEmpujable);*/
foreach (var mesh in Scene.Meshes.FindAll(m => m.Name.Contains("Caja3")))
{
Scene.Meshes.Remove(mesh);
TGCVector3 PosicionMeshEmpujable = mesh.Position;
CajaEmpujable CajaEmpujable = new CajaEmpujable(mesh, new TGCVector3(0f, 0f, 0f));
ListaCajasEmpujables.Add(CajaEmpujable);
}
// Setear cancion
cancionPcpal.FileName = Env.MediaDir + "\\Sound\\crash.mp3";
// Setear plataformas
Plataformas = new List <Plataforma>();
List <TgcMesh> ListaPlataformaEstatica = new List <TgcMesh>();
List <TgcMesh> ListaPlataformaX = new List <TgcMesh>();
// TgcMesh PlataformaY;
List <TgcMesh> ListaPlataformaZ = new List <TgcMesh>();
List <TgcMesh> ListaMovibles = new List <TgcMesh>();
List <TgcMesh> Escalones = new List <TgcMesh>();
ListaPlataformaEstatica = Scene.Meshes.FindAll(m => m.Name.Contains("Box_0"));
ListaPlataformaX = Scene.Meshes.FindAll(m => m.Name.Contains("Box_1"));
ListaPlataformaZ = Scene.Meshes.FindAll(m => m.Name.Contains("Box_2"));
PlataformaY = Scene.Meshes.Find(Mesh => Mesh.Name.Contains("SubeBaja"));
ListaMovibles = Scene.Meshes.FindAll(m => m.Name.Contains("Box_M"));
Escalones = Scene.Meshes.FindAll(m => m.Name.Contains("Escalon"));
//agrego plataforma que se mueven en X
foreach (var p in ListaPlataformaX)
{
Plataformas.Add(new PlataformaLineal(p, new TGCVector3(0f, 0f, 0f), 25f, true, false, 12f, false));
}
//agrego plataforma que se mueven en Z
foreach (var p in ListaPlataformaZ)
{
//-20f es para que este centrado en el camino
if (p.Name == "Box_202" || p.Name == "Box_204")
{
Plataformas.Add(new PlataformaLineal(p, new TGCVector3(0f, 0f, -20f), 25f, false, false, 12f, true));
}
else
{
Plataformas.Add(new PlataformaLineal(p, new TGCVector3(0f, 0f, -20f), 25f, false, false, 12f, false));
}
}
Plataformas.Add(new PlataformaLineal(PlataformaY, new TGCVector3(0f, -90f, 0f), 90f, false, true, 15f, true));
//agrego objetos moviles
foreach (var p in ListaMovibles)
{
Plataformas.Add(new PlataformaLineal(p, new TGCVector3(0f, 0f, 0f), 0f, false, false, 0f, false));
}
//agrego objetos estaticos
foreach (var p in ListaPlataformaEstatica)
{
Plataformas.Add(new PlataformaLineal(p, new TGCVector3(0f, 0f, 0f), 0f, false, false, 0f, false));
}
//se agregan plataformas giratorias
var meshGiratorio = Plataformas[0].Mesh.clone("pGira");
Plataformas.Add(new PlataformaGiratoria(15, meshGiratorio, new TGCVector3(260f, 0f, 275f), 5f));
Scene.Meshes.Add(meshGiratorio);
var meshGiratorio2 = ListaPlataformaZ[4].clone("pGira2");
Plataformas.Add(new PlataformaGiratoria(28, meshGiratorio2, new TGCVector3(75f, 0f, -20f), 5f));
Scene.Meshes.Add(meshGiratorio2);
var meshGiratorio3 = ListaPlataformaZ[4].clone("pGira3");
Plataformas.Add(new PlataformaGiratoria(28, meshGiratorio3, new TGCVector3(-135f, 0f, 575f), 5f));
Scene.Meshes.Add(meshGiratorio3);
foreach (var plataforma in Plataformas)
{
ListaPlataformas.Add(plataforma.Mesh);
MeshConMovimiento.Add(plataforma.Mesh);
Scene.Meshes.Remove(plataforma.Mesh);
}
//agrego escalones
foreach (var escalon in Escalones)
{
ListaEscalones.Add(escalon);
}
Grilla.create(Scene.Meshes.FindAll(m => !m.Name.Contains("Box")), Scene.BoundingBox);
Grilla.createDebugMeshes();
}
void carga_clientes()
{
String queryString = "";
lbl_mensaje.Text = "";
queryString = "select cl.id_cliente, cl.rut + '-' + cl.Dv_Rut Rut, SUBSTRING(cl.razon_social,1,30) razon_social , pe.id_item ID_Item, pe.codigo, SUBSTRING(pe.descripcion,1,30) descripcion, mn.Sigla Moneda, pe.precio_lista , pe.precio, ";
queryString = queryString + "IFNULL(pe.fecha_vigencia,IFNULL(pe.fecha_vigencia,DATE_SUB(NOW(),INTERVAL 24 HOUR))) fecha_vigencia, ";
queryString = queryString + "IF(DATEDIFF(IFNULL(date(pe.fecha_vigencia),date(DATE_SUB(NOW(),INTERVAL 24 HOUR))),date(NOW())) > 0, 'S','N') Vigente ";
queryString = queryString + "from tbl_clientes cl, tbl_precios_especiales pe, tbl_Monedas mn ";
queryString = queryString + "where cl.ID_Cliente = pe.ID_Cliente ";
queryString = queryString + "and pe.id_moneda = mn.ID_Moneda ";
if (txt_idw.Text != "")
{
queryString = queryString + "and cl.id_cliente = " + txt_idw.Text;
}
if (txt_rutw.Text != "")
{
queryString = queryString + "and cl.rut = " + txt_rutw.Text;
}
if (txt_razonw.Text != "")
{
queryString = queryString + "and cl.Razon_Social like '%" + txt_razonw.Text + "%'";
}
queryString = queryString + " order by cl.ID_Cliente ";
using (MySqlConnection conn = new MySqlConnection(SMysql))
{
try
{
conn.Open();
DataSet ds = new DataSet();
MySqlDataAdapter adapter = new MySqlDataAdapter();
adapter.SelectCommand = new MySqlCommand(queryString, conn);
adapter.Fill(ds);
if (ds.Tables[0].Rows.Count == 0)
{
lbl_mensaje.Text = "Sin Resultados";
}
else
{
Grilla.DataSource = ds;
Grilla.DataBind();
}
//Productos.DataMember = "tbl_items";
conn.Close();
conn.Dispose();
}
catch (Exception ex)
{
lbl_error.Text = ex.Message;
conn.Close();
conn.Dispose();
}
}
}
public void iniciargrilla(int width, int height)
{
grilla = new Grilla <CasillaNodo>(width, height, 50f, Vector3.zero, (Grilla <CasillaNodo> g, int x, int y) => new CasillaNodo(g, x, y)); // crea la grilla con el ancho y el alto especificados
}
public AStar_PathFinder(int width, int height)
{
grilla = new Grilla <Nodo>(width, height, 50f, Vector3.zero, (Grilla <Nodo> g, int x, int y) => new Nodo(g, x, y));
}
