public static DataTable Listar(KanbanDetLogica kan)
{
DataTable datos = new DataTable();
try
{
datos = AccesoDatos.ConsultarPRO("select * from t_kanban_det where folio = " + kan.Folio + " and consec = " + kan.Consec + "");
}
catch (Exception ex)
{
throw ex;
}
return(datos);
}
public static DataTable Consultar(KanbanDetLogica kan)
{
DataTable datos = new DataTable();
try
{
datos = AccesoDatos.ConsultarPRO("SELECT * FROM t_kanban_det where folio = " + kan.Folio + "");
}
catch (Exception ex)
{
throw ex;
}
return(datos);
}
public static double BuscaDisponible(KanbanDetLogica kan)
{
try
{
double dCant = 0;
string sQuery;
sQuery = "select kw.cantidad from vw_kanban_line kw inner join t_kanban_plan kp on kw.linea = kp.descrip where kw.folio = " + kan.Folio + " and kp.linea = '" + kan.Line + "' ";
DataTable datos = AccesoDatos.ConsultarPRO(sQuery);
if (datos.Rows.Count != 0)
{
dCant = double.Parse(datos.Rows[0][0].ToString());
}
return(dCant);
}
catch
{
return(0);
}
}
public static bool Verificar(KanbanDetLogica kan)
{
try
{
string sQuery;
sQuery = "SELECT * FROM t_kanban_det where line = '" + kan.Line + "' and rpo = '" + kan.RPO + "' ";
DataTable datos = AccesoDatos.ConsultarPRO(sQuery);
if (datos.Rows.Count != 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
public static int Guardar(KanbanDetLogica kan)
{
string[] parametros = { "@Folio", "@Line", "@RPO", "@Creation", "@Item", "@Qty", "@Print", "@Register", "@Kanban", "@Start", "@QtyFinish", "@QtyShipped", "@Saldo", "Hora" };
return(AccesoDatos.ActualizarPRO("sp_mant_kanban_det", parametros, kan.Folio, kan.Line, kan.RPO, kan.Creation, kan.Item, kan.Quantity, kan.Print, kan.Register, kan.Kanban, kan.Start, kan.QtyFinish, kan.QtyShipped, kan.Saldo, kan.Hora));
}
