public JsonResult UnidadeContratante(string Prefix)
{
UtilModel util = new UtilModel();
string SessionID = (string)Session["SessionID"];
ListaItem listaItem = new ListaItem();
listaItem.Itens = new List <Item>()
{
};
var unidadeContratante = util.ListaUnidade(SessionID, "UNIDADE");
var retorno = (from u in unidadeContratante
where u.Nome.Contains("PARANA")
select new { u.Codigo, u.Nome });
foreach (var i in retorno)
{
Item item = new Item();
item.codigo = i.Codigo;
item.Descricao = i.Nome;
listaItem.Itens.Add(item);
}
return(Json(listaItem, JsonRequestBehavior.AllowGet));
}
#pragma warning disable 1998
protected override void BuildRenderTree(Microsoft.AspNetCore.Components.Rendering.RenderTreeBuilder __builder)
{
#line 3 "C:\_blazor\Blazor_Tarefas\Blazor_Tarefas\Shared\ListaGenerica.razor"
if (ListaItem == null)
{
if (Carregando == null)
{
#line default
#line hidden
__builder.AddMarkupContent(0, " <img src=\"https://media.giphy.com/media/3oEjI6SIIHBdRxXI40/giphy.gif\">\r\n");
__builder.AddContent(1, " Carregando ");
#line 8 "C:\_blazor\Blazor_Tarefas\Blazor_Tarefas\Shared\ListaGenerica.razor"
}
else
{
#line default
#line hidden
__builder.AddContent(2,
#line 12 "C:\_blazor\Blazor_Tarefas\Blazor_Tarefas\Shared\ListaGenerica.razor"
Carregando
#line default
#line hidden
);
#line 12 "C:\_blazor\Blazor_Tarefas\Blazor_Tarefas\Shared\ListaGenerica.razor"
}
}
else if (!ListaItem.Any())
{
if (SemRegistro == null)
{
#line default
#line hidden
__builder.AddMarkupContent(3, " <img src=\"https://media.giphy.com/media/3o7WTDH9gYo71TurPq/giphy.gif\">\r\n");
__builder.AddMarkupContent(4, " Não existem tarefas ");
#line 20 "C:\_blazor\Blazor_Tarefas\Blazor_Tarefas\Shared\ListaGenerica.razor"
}
else
{
#line default
#line hidden
__builder.AddContent(5,
#line 24 "C:\_blazor\Blazor_Tarefas\Blazor_Tarefas\Shared\ListaGenerica.razor"
SemRegistro
#line default
#line hidden
);
#line 24 "C:\_blazor\Blazor_Tarefas\Blazor_Tarefas\Shared\ListaGenerica.razor"
}
}
else
{
foreach (var elemento in ListaItem)
{
#line default
#line hidden
__builder.AddContent(6,
#line 31 "C:\_blazor\Blazor_Tarefas\Blazor_Tarefas\Shared\ListaGenerica.razor"
Lista(elemento)
#line default
#line hidden
);
#line 31 "C:\_blazor\Blazor_Tarefas\Blazor_Tarefas\Shared\ListaGenerica.razor"
}
}
#line default
#line hidden
}
internal void Refrescar()
{
ListaItem.Items.Clear();
if (this.Connection != null)
{
if (m_Table.Length > 0 && m_KeyField.Length > 0 && m_DetailField != null && m_DetailField.Length > 0)
{
string TextoSql = null;
string sBuscar = EntradaBuscar.Text;
sBuscar = this.Connection.EscapeString(sBuscar.Replace(" ", " ").Trim());
if (m_Table.Length >= 7 && m_Table.Substring(0, 7) == "SELECT ")
{
TextoSql = m_Table;
}
else
{
TextoSql = "SELECT " + m_KeyField + ", " + m_DetailField;
if (m_ExtraDetailFields != null && m_ExtraDetailFields.Length > 0)
{
TextoSql += ", " + m_ExtraDetailFields;
}
// Si es la tabla de artículos, muestro algunas cosas más
if (m_Table == "articulos")
{
TextoSql += ", control_stock, stock_actual, pedido, destacado";
}
TextoSql += " FROM " + m_Table;
bool AgregueWhere = false;
if (sBuscar != null && sBuscar.Length > 1)
{
TextoSql += " WHERE (" + m_DetailField + " LIKE '%" + sBuscar.Replace(" ", "%' AND " + m_DetailField + " LIKE '%") + "%'";
AgregueWhere = true;
}
else if (sBuscar != null && sBuscar.Length > 0)
{
TextoSql += " WHERE (" + m_DetailField + " LIKE '" + this.Connection.EscapeString(sBuscar) + "%'";
AgregueWhere = true;
}
if (m_ExtraDetailFields != null && m_ExtraDetailFields.Length > 0 && sBuscar != null && sBuscar.Length > 1)
{
string TempExtraDetailFields = m_ExtraDetailFields;
string TempWhere = "";
string ExtraField = Lfx.Types.Strings.GetNextToken(ref TempExtraDetailFields, ",");
while (ExtraField.Length > 0)
{
if (TempWhere.Length == 0)
{
TempWhere += ExtraField + " LIKE '%" + sBuscar + "%'";
}
else
{
TempWhere += " OR " + ExtraField + " LIKE '%" + sBuscar + "%'";
}
ExtraField = Lfx.Types.Strings.GetNextToken(ref TempExtraDetailFields, ",");
}
TextoSql += " OR (" + TempWhere + ")";
}
if (AgregueWhere)
{
TextoSql += ") ";
}
if (m_Filter != null && m_Filter.Length > 0)
{
if (AgregueWhere)
{
TextoSql += " AND (" + m_Filter + ")";
}
else
{
TextoSql += " WHERE " + m_Filter;
}
}
if (m_Table == "articulos")
{
TextoSql += " ORDER BY IF(stock_actual+pedido>0,0,1), " + m_DetailField;
}
else
{
TextoSql += " ORDER BY " + m_DetailField;
}
// TODO: Código dependiente de MySql/PostgreSql. Pasar a qGen.SqlCommandBuilder
if (Lfx.Workspace.Master.SlowLink)
{
TextoSql += " LIMIT 40";
}
else
{
TextoSql += " LIMIT 100";
}
}
System.Data.DataTable TableRes = this.Connection.Select(TextoSql);
ListaItem.SuspendLayout();
ListaItem.BeginUpdate();
foreach (System.Data.DataRow OrgRow in TableRes.Rows)
{
Lfx.Data.Row RowRes = (Lfx.Data.Row)OrgRow;
ListViewItem itm = ListaItem.Items.Add(RowRes.Fields[m_KeyField].ValueInt.ToString("00000"));
itm.SubItems.Add(new ListViewItem.ListViewSubItem(itm, RowRes.Fields[m_DetailField].ValueString));
if (m_ExtraDetailFields != null && m_ExtraDetailFields.Length > 0)
{
string TempExtraDetailFields = m_ExtraDetailFields;
string Campo = Lfx.Types.Strings.GetNextToken(ref TempExtraDetailFields, ",").Trim();
while (Campo.Length > 0)
{
if (RowRes.Fields[Campo].Value == null)
{
itm.SubItems.Add("");
}
else
{
switch (RowRes[Campo].GetType().ToString())
{
case "System.Single":
case "System.Double":
case "System.Decimal":
itm.SubItems.Add(Lfx.Types.Formatting.FormatNumber(RowRes.Fields[Campo].ValueDecimal, 4));
break;
default:
itm.SubItems.Add(System.Convert.ToString(RowRes.Fields[Campo].Value));
break;
}
}
Campo = Lfx.Types.Strings.GetNextToken(ref TempExtraDetailFields, ",").Trim();
}
}
// TODO: que tome m_ExtraDetailFields esto en cuenta
if (m_Table == "articulos")
{
if (System.Convert.ToInt32(RowRes["control_stock"]) != 0 && System.Convert.ToDouble(RowRes["stock_actual"]) <= 0)
{
// No hay stock.
if (System.Convert.ToDouble(RowRes["pedido"]) + System.Convert.ToDouble(RowRes["stock_actual"]) > 0)
{
// Pero hay pedido suficiente para cubrir un stock negativo y sobra
itm.ForeColor = System.Drawing.Color.OrangeRed;
itm.Font = new Font(itm.Font, FontStyle.Regular);
}
else
{
itm.ForeColor = System.Drawing.Color.Red;
itm.Font = new Font(itm.Font, FontStyle.Strikeout);
}
}
else if (System.Convert.ToInt32(RowRes["destacado"]) != 0)
{
itm.ForeColor = System.Drawing.Color.DarkGreen;
itm.Font = new Font(itm.Font, FontStyle.Regular);
}
}
}
ListaItem.EndUpdate();
ListaItem.ResumeLayout();
if (ListaItem.Items.Count > 0)
{
ListaItem.Items[0].Selected = true;
}
}
}
}
