public Object DataTableMarca(Globales.ClsDataTables RequesDT) { RequesDT.draw = RequesDT.Form.GetValues("draw").FirstOrDefault(); RequesDT.start = RequesDT.Form.GetValues("start").FirstOrDefault(); RequesDT.length = RequesDT.Form.GetValues("length").FirstOrDefault(); RequesDT.sortColumn = RequesDT.Form.GetValues("columns[" + RequesDT.Form.GetValues("order[0][column]").FirstOrDefault() + "][data]").FirstOrDefault(); RequesDT.sortColumnDir = RequesDT.Form.GetValues("order[0][dir]").FirstOrDefault(); RequesDT.searchValue = RequesDT.Form.GetValues("search[value]").FirstOrDefault(); RequesDT.pageSize = RequesDT.length != null?Convert.ToInt32(RequesDT.length) : 0; RequesDT.skip = RequesDT.start != null?Convert.ToInt32(RequesDT.start) : 0; RequesDT.recordsTotal = 0; using (DBKuupEntities db = new DBKuupEntities()) { var Query = (from q in db.ViMarca select new ClsMarcas() { NumeroDeMarca = q.MRA_NUM_MARCA, NombreDeMarca = q.MRA_NOM_MARCA, TextoDeEstatus = q.MRA_TXT_ESTATUS }).AsQueryable(); String sql = String.Empty; if (!string.IsNullOrEmpty(RequesDT.Form.GetValues("columns[0][search][value]").FirstOrDefault())) { if (!String.IsNullOrEmpty(sql)) { sql += " && "; } sql += String.Format("NumeroDeMarca = {0}", RequesDT.Form.GetValues("columns[0][search][value]").FirstOrDefault().Trim().ToUpper()); } if (!string.IsNullOrEmpty(RequesDT.Form.GetValues("columns[1][search][value]").FirstOrDefault())) { if (!String.IsNullOrEmpty(sql)) { sql += " && "; } sql += String.Format("NombreDeMarca.Trim().ToUpper().Contains(\"{0}\")", RequesDT.Form.GetValues("columns[1][search][value]").FirstOrDefault().Trim().ToUpper()); } if (!string.IsNullOrEmpty(RequesDT.Form.GetValues("columns[2][search][value]").FirstOrDefault())) { if (!String.IsNullOrEmpty(sql)) { sql += " && "; } sql += String.Format("TextoDeEstatus.Trim().ToUpper().Contains(\"{0}\")", RequesDT.Form.GetValues("columns[2][search][value]").FirstOrDefault().Trim().ToUpper()); } if (!String.IsNullOrEmpty(sql)) { Query = Query.Where(sql); } if (!(string.IsNullOrEmpty(RequesDT.sortColumn) && string.IsNullOrEmpty(RequesDT.sortColumnDir))) { Query = Query.OrderBy(RequesDT.sortColumn + " " + RequesDT.sortColumnDir); } RequesDT.recordsTotal = Query.Count(); var ProductoTable = Query.Skip(RequesDT.skip).Take(RequesDT.pageSize).ToArray(); RequesDT.DatosJson = new { RequesDT.draw, recordsFiltered = RequesDT.recordsTotal, RequesDT.recordsTotal, data = ProductoTable }; } return(RequesDT.DatosJson); }
public Object DataTableSurtido(Globales.ClsDataTables RequesDT) { RequesDT.draw = RequesDT.Form.GetValues("draw").FirstOrDefault(); RequesDT.start = RequesDT.Form.GetValues("start").FirstOrDefault(); RequesDT.length = RequesDT.Form.GetValues("length").FirstOrDefault(); RequesDT.sortColumn = RequesDT.Form.GetValues("columns[" + RequesDT.Form.GetValues("order[0][column]").FirstOrDefault() + "][data]").FirstOrDefault(); RequesDT.sortColumnDir = RequesDT.Form.GetValues("order[0][dir]").FirstOrDefault(); RequesDT.searchValue = RequesDT.Form.GetValues("search[value]").FirstOrDefault(); RequesDT.pageSize = RequesDT.length != null?Convert.ToInt32(RequesDT.length) : 0; RequesDT.skip = RequesDT.start != null?Convert.ToInt32(RequesDT.start) : 0; RequesDT.recordsTotal = 0; using (DBKuupEntities db = new DBKuupEntities()) { var Query = (from q in db.ViSurtido select new ClsSurtidos { FolioDeSurtido = q.SUR_FOLIO_SURTIDO, NombreDeProducto = q.SUR_NOM_PRODUCTO, NombreDeUsuario = (q.SUR_NOM_PROVEEDOR == null ? q.SUR_NOM_USUARIO : q.SUR_NOM_PROVEEDOR), CantidadNueva = q.SUR_CANT_NUEVA, FechaDeSurtido = q.SUR_FECHA_SURTIDO, TextoDeEstatus = q.SUR_TXT_ESTATUS }).AsQueryable(); String sql = String.Empty; if (!string.IsNullOrEmpty(RequesDT.Form.GetValues("columns[0][search][value]").FirstOrDefault())) { if (!String.IsNullOrEmpty(sql)) { sql += " && "; } sql += String.Format("FolioDeSurtido.ToString().Trim().ToUpper().Contains(\"{0}\")", RequesDT.Form.GetValues("columns[0][search][value]").FirstOrDefault().Trim().ToUpper()); } if (!string.IsNullOrEmpty(RequesDT.Form.GetValues("columns[1][search][value]").FirstOrDefault())) { if (!String.IsNullOrEmpty(sql)) { sql += " && "; } sql += String.Format("NombreDeProducto.Trim().ToUpper().Contains(\"{0}\")", RequesDT.Form.GetValues("columns[1][search][value]").FirstOrDefault().Trim().ToUpper()); } if (!string.IsNullOrEmpty(RequesDT.Form.GetValues("columns[2][search][value]").FirstOrDefault())) { if (!String.IsNullOrEmpty(sql)) { sql += " && "; } sql += String.Format("NombreDeUsuario.Trim().ToUpper().Contains(\"{0}\")", RequesDT.Form.GetValues("columns[2][search][value]").FirstOrDefault().Trim().ToUpper()); } if (!string.IsNullOrEmpty(RequesDT.Form.GetValues("columns[3][search][value]").FirstOrDefault())) { if (!String.IsNullOrEmpty(sql)) { sql += " && "; } sql += String.Format("CantidadNueva.ToString().Trim().ToUpper().Contains(\"{0}\")", RequesDT.Form.GetValues("columns[3][search][value]").FirstOrDefault().Trim().ToUpper()); } if (!string.IsNullOrEmpty(RequesDT.Form.GetValues("columns[4][search][value]").FirstOrDefault())) { String Fecha = RequesDT.Form.GetValues("columns[4][search][value]").FirstOrDefault().Trim().ToUpper(); if (!String.IsNullOrEmpty(Fecha)) { if (Fecha.Split('-').Length == 3) { if (!String.IsNullOrEmpty(sql)) { sql += " && "; } sql += String.Format("FechaDeSurtido == Datetime({0},{1},{2})", Fecha.Split('-')[0], Fecha.Split('-')[1], Fecha.Split('-')[2]); } } } if (!string.IsNullOrEmpty(RequesDT.Form.GetValues("columns[5][search][value]").FirstOrDefault())) { if (!String.IsNullOrEmpty(sql)) { sql += " && "; } sql += String.Format("TextoDeEstatus.Trim().ToUpper().Contains(\"{0}\")", RequesDT.Form.GetValues("columns[5][search][value]").FirstOrDefault().Trim().ToUpper()); } if (!String.IsNullOrEmpty(sql)) { Query = Query.Where(sql); } //if (!String.IsNullOrEmpty(RequesDT.searchValue)) //{ // Query = Query.Where(x => x.FolioDeSurtido.ToString().Contains(RequesDT.searchValue.Trim().ToUpper()) || // x.NombreDeProducto.Trim().ToUpper().Contains(RequesDT.searchValue.Trim().ToUpper())); //} if (!(string.IsNullOrEmpty(RequesDT.sortColumn) && string.IsNullOrEmpty(RequesDT.sortColumnDir))) { Query = Query.OrderBy(RequesDT.sortColumn + " " + RequesDT.sortColumnDir); } RequesDT.recordsTotal = Query.Count(); var ProductoTable = Query.Skip(RequesDT.skip).Take(RequesDT.pageSize).ToArray(); RequesDT.DatosJson = new { RequesDT.draw, recordsFiltered = RequesDT.recordsTotal, RequesDT.recordsTotal, data = ProductoTable.Select(x => new { x.FolioDeSurtido, x.NombreDeProducto, NombreDeQuienSurtio = x.NombreDeUsuario, x.CantidadNueva, FechaDeSurtido = x.FechaDeSurtido.ToString("yyyy-MM-dd"), x.TextoDeEstatus }) }; } return(RequesDT.DatosJson); }
public Object DataTableConfiguraPaquete(Globales.ClsDataTables RequesDT) { RequesDT.draw = RequesDT.Form.GetValues("draw").FirstOrDefault(); RequesDT.start = RequesDT.Form.GetValues("start").FirstOrDefault(); RequesDT.length = RequesDT.Form.GetValues("length").FirstOrDefault(); RequesDT.sortColumn = RequesDT.Form.GetValues("columns[" + RequesDT.Form.GetValues("order[0][column]").FirstOrDefault() + "][data]").FirstOrDefault(); RequesDT.sortColumnDir = RequesDT.Form.GetValues("order[0][dir]").FirstOrDefault(); RequesDT.searchValue = RequesDT.Form.GetValues("search[value]").FirstOrDefault(); RequesDT.pageSize = RequesDT.length != null?Convert.ToInt32(RequesDT.length) : 0; RequesDT.skip = RequesDT.start != null?Convert.ToInt32(RequesDT.start) : 0; RequesDT.recordsTotal = 0; using (DBKuupEntities db = new DBKuupEntities()) { var Query = (from q in db.ViConfiguraPaquete select new ClsConfiguraPaquetes() { CodigoDeBarrasPadre = q.CNP_CODIGO_BARRAS_PADRE, NombreDeProductoPadre = q.CNP_NOM_PRODUCTO_PADRE, PrecioDeProductoPadre = q.CNP_PRECIO_PRODUCTO_PADRE, CodigoDeBarrasHijo = q.CNP_CODIGO_BARRAS_HIJO, NombreDeProductoHijo = q.CNP_NOM_PRODUCTO_HIJO, PrecioDeProductoHijo = q.CNP_PRECIO_PRODUCTO_HIJO, ImporteTotal = q.CNP_IMPORTE_TOTAL, NumeroDeProductoPadre = q.CNP_NUM_PRODUCTO_PADRE, NumeroDeProductoHijo = q.CNP_NUM_PRODUCTO_HIJO }).AsQueryable(); String sql = String.Empty; if (!string.IsNullOrEmpty(RequesDT.Form.GetValues("columns[0][search][value]").FirstOrDefault())) { if (!String.IsNullOrEmpty(sql)) { sql += " && "; } sql += String.Format("CodigoDeBarrasPadre.Trim().ToUpper().Contains(\"{0}\")", RequesDT.Form.GetValues("columns[0][search][value]").FirstOrDefault().Trim().ToUpper()); } if (!string.IsNullOrEmpty(RequesDT.Form.GetValues("columns[1][search][value]").FirstOrDefault())) { if (!String.IsNullOrEmpty(sql)) { sql += " && "; } sql += String.Format("NombreDeProductoPadre.Trim().ToUpper().Contains(\"{0}\")", RequesDT.Form.GetValues("columns[1][search][value]").FirstOrDefault().Trim().ToUpper()); } if (!string.IsNullOrEmpty(RequesDT.Form.GetValues("columns[2][search][value]").FirstOrDefault())) { if (!String.IsNullOrEmpty(sql)) { sql += " && "; } sql += String.Format("PrecioDeProductoPadre.ToString().Trim().ToUpper().Contains(\"{0}\")", RequesDT.Form.GetValues("columns[2][search][value]").FirstOrDefault().Trim().ToUpper()); } if (!string.IsNullOrEmpty(RequesDT.Form.GetValues("columns[3][search][value]").FirstOrDefault())) { if (!String.IsNullOrEmpty(sql)) { sql += " && "; } sql += String.Format("CodigoDeBarrasHijo.ToString().Trim().ToUpper().Contains(\"{0}\")", RequesDT.Form.GetValues("columns[3][search][value]").FirstOrDefault().Trim().ToUpper()); } if (!string.IsNullOrEmpty(RequesDT.Form.GetValues("columns[4][search][value]").FirstOrDefault())) { if (!String.IsNullOrEmpty(sql)) { sql += " && "; } sql += String.Format("NombreDeProductoHijo.Trim().ToUpper().Contains(\"{0}\")", RequesDT.Form.GetValues("columns[4][search][value]").FirstOrDefault().Trim().ToUpper()); } if (!string.IsNullOrEmpty(RequesDT.Form.GetValues("columns[5][search][value]").FirstOrDefault())) { if (!String.IsNullOrEmpty(sql)) { sql += " && "; } sql += String.Format("PrecioDeProductoHijo.ToString().Trim().ToUpper().Contains(\"{0}\")", RequesDT.Form.GetValues("columns[5][search][value]").FirstOrDefault().Trim().ToUpper()); } if (!string.IsNullOrEmpty(RequesDT.Form.GetValues("columns[6][search][value]").FirstOrDefault())) { if (!String.IsNullOrEmpty(sql)) { sql += " && "; } sql += String.Format("ImporteTotal.ToString().Trim().ToUpper().Contains(\"{0}\")", RequesDT.Form.GetValues("columns[6][search][value]").FirstOrDefault().Trim().ToUpper()); } if (!String.IsNullOrEmpty(sql)) { Query = Query.Where(sql); } //if (!String.IsNullOrEmpty(RequesDT.searchValue)) //{ // Query = Query.Where(x => x.CodigoDeBarrasPadre.Trim().ToUpper().Contains(RequesDT.searchValue.Trim().ToUpper()) || // x.NombreDeProductoPadre.Trim().ToUpper().Contains(RequesDT.searchValue.Trim().ToUpper()) || // x.CodigoDeBarrasHijo.Trim().ToUpper().Contains(RequesDT.searchValue.Trim().ToUpper()) || // x.NombreDeProductoHijo.Trim().ToUpper().Contains(RequesDT.searchValue.Trim().ToUpper())); //} if (!(string.IsNullOrEmpty(RequesDT.sortColumn) && string.IsNullOrEmpty(RequesDT.sortColumnDir))) { Query = Query.OrderBy(RequesDT.sortColumn + " " + RequesDT.sortColumnDir); } RequesDT.recordsTotal = Query.Count(); var ProductoTable = Query.Skip(RequesDT.skip).Take(RequesDT.pageSize).ToArray(); RequesDT.DatosJson = new { RequesDT.draw, recordsFiltered = RequesDT.recordsTotal, RequesDT.recordsTotal, data = ProductoTable }; } return(RequesDT.DatosJson); }
public Object DataTableProducto(Globales.ClsDataTables RequesDT) { RequesDT.draw = RequesDT.Form.GetValues("draw").FirstOrDefault(); RequesDT.start = RequesDT.Form.GetValues("start").FirstOrDefault(); RequesDT.length = RequesDT.Form.GetValues("length").FirstOrDefault(); RequesDT.sortColumn = RequesDT.Form.GetValues("columns[" + RequesDT.Form.GetValues("order[0][column]").FirstOrDefault() + "][data]").FirstOrDefault(); RequesDT.sortColumnDir = RequesDT.Form.GetValues("order[0][dir]").FirstOrDefault(); RequesDT.searchValue = RequesDT.Form.GetValues("search[value]").FirstOrDefault(); RequesDT.pageSize = RequesDT.length != null?Convert.ToInt32(RequesDT.length) : 0; RequesDT.skip = RequesDT.start != null?Convert.ToInt32(RequesDT.start) : 0; RequesDT.recordsTotal = 0; using (DBKuupEntities db = new DBKuupEntities()) { var Query = (from q in db.ViProducto select new ClsProductos() { NumeroDeProducto = q.PRO_NUM_PRODUCTO, CodigoDeBarras = q.PRO_CODIGO_BARRAS, NombreDeProducto = q.PRO_NOM_PRODUCTO, NombreDeTipoDeProducto = q.PRO_NOM_TIPO_PRODUCTO, NombreDeMarca = q.PRO_NOM_MARCA, CantidadDeProductoTotal = q.PRO_CANT_PRODUCTO_TOTAL, PrecioUnitario = q.PRO_PRECIO_UNITARIO, TextoAviso = q.PRO_TXT_AVISO, TextoCorreoSurtido = q.PRO_TXT_CORREO_SURTIDO, TextoDeEstatus = q.PRO_TXT_ESTATUS }).AsQueryable(); String sql = String.Empty; if (!string.IsNullOrEmpty(RequesDT.Form.GetValues("columns[0][search][value]").FirstOrDefault())) { if (!String.IsNullOrEmpty(sql)) { sql += " && "; } sql += String.Format("NumeroDeProducto.ToString().Trim().ToUpper().Contains(\"{0}\")", RequesDT.Form.GetValues("columns[0][search][value]").FirstOrDefault().Trim().ToUpper()); } if (!string.IsNullOrEmpty(RequesDT.Form.GetValues("columns[1][search][value]").FirstOrDefault())) { if (!String.IsNullOrEmpty(sql)) { sql += " && "; } sql += String.Format("CodigoDeBarras.Trim().ToUpper().Contains(\"{0}\")", RequesDT.Form.GetValues("columns[1][search][value]").FirstOrDefault().Trim().ToUpper()); } if (!string.IsNullOrEmpty(RequesDT.Form.GetValues("columns[2][search][value]").FirstOrDefault())) { if (!String.IsNullOrEmpty(sql)) { sql += " && "; } sql += String.Format("NombreDeProducto.Trim().ToUpper().Contains(\"{0}\")", RequesDT.Form.GetValues("columns[2][search][value]").FirstOrDefault().Trim().ToUpper()); } if (!string.IsNullOrEmpty(RequesDT.Form.GetValues("columns[3][search][value]").FirstOrDefault())) { if (!String.IsNullOrEmpty(sql)) { sql += " && "; } sql += String.Format("NombreDeTipoDeProducto.Trim().ToUpper().Contains(\"{0}\")", RequesDT.Form.GetValues("columns[3][search][value]").FirstOrDefault().Trim().ToUpper()); } if (!string.IsNullOrEmpty(RequesDT.Form.GetValues("columns[4][search][value]").FirstOrDefault())) { if (!String.IsNullOrEmpty(sql)) { sql += " && "; } sql += String.Format("NombreDeMarca.Trim().ToUpper().Contains(\"{0}\")", RequesDT.Form.GetValues("columns[4][search][value]").FirstOrDefault().Trim().ToUpper()); } if (!string.IsNullOrEmpty(RequesDT.Form.GetValues("columns[5][search][value]").FirstOrDefault())) { if (!String.IsNullOrEmpty(sql)) { sql += " && "; } sql += String.Format("CantidadDeProductoTotal.ToString().Trim().ToUpper().Contains(\"{0}\")", RequesDT.Form.GetValues("columns[5][search][value]").FirstOrDefault().Trim().ToUpper()); } if (!string.IsNullOrEmpty(RequesDT.Form.GetValues("columns[6][search][value]").FirstOrDefault())) { if (!String.IsNullOrEmpty(sql)) { sql += " && "; } sql += String.Format("PrecioUnitario.ToString().Trim().ToUpper().Contains(\"{0}\")", RequesDT.Form.GetValues("columns[6][search][value]").FirstOrDefault().Trim().ToUpper()); } if (!string.IsNullOrEmpty(RequesDT.Form.GetValues("columns[7][search][value]").FirstOrDefault())) { if (!String.IsNullOrEmpty(sql)) { sql += " && "; } sql += String.Format("TextoAviso.Trim().ToUpper().Contains(\"{0}\")", RequesDT.Form.GetValues("columns[7][search][value]").FirstOrDefault().Trim().ToUpper()); } if (!string.IsNullOrEmpty(RequesDT.Form.GetValues("columns[8][search][value]").FirstOrDefault())) { if (!String.IsNullOrEmpty(sql)) { sql += " && "; } sql += String.Format("TextoCorreoSurtido.Trim().ToUpper().Contains(\"{0}\")", RequesDT.Form.GetValues("columns[8][search][value]").FirstOrDefault().Trim().ToUpper()); } if (!string.IsNullOrEmpty(RequesDT.Form.GetValues("columns[9][search][value]").FirstOrDefault())) { if (!String.IsNullOrEmpty(sql)) { sql += " && "; } sql += String.Format("TextoDeEstatus.Trim().ToUpper().Contains(\"{0}\")", RequesDT.Form.GetValues("columns[9][search][value]").FirstOrDefault().Trim().ToUpper()); } if (!String.IsNullOrEmpty(sql)) { Query = Query.Where(sql); } //if (!String.IsNullOrEmpty(RequesDT.searchValue)) //{ // Query = Query.Where(x => x.NombreDeProducto.Trim().ToUpper().Contains(RequesDT.searchValue.Trim().ToUpper()) || // x.CodigoDeBarras.Trim().ToUpper().Contains(RequesDT.searchValue.Trim().ToUpper())); //} if (!(string.IsNullOrEmpty(RequesDT.sortColumn) && string.IsNullOrEmpty(RequesDT.sortColumnDir))) { Query = Query.OrderBy(RequesDT.sortColumn + " " + RequesDT.sortColumnDir); } RequesDT.recordsTotal = Query.Count(); var ProductoTable = Query.Skip(RequesDT.skip).Take(RequesDT.pageSize).ToArray(); RequesDT.DatosJson = new { RequesDT.draw, recordsFiltered = RequesDT.recordsTotal, RequesDT.recordsTotal, data = ProductoTable }; } return(RequesDT.DatosJson); }