public Get(string _BA_PRODUKT)
{
ProductoAlfak pr = new ProductoAlfak();
BA_PRODUKTE = pr.GetByCod(_BA_PRODUKT);
Costo Cst = new Costo(_BA_PRODUKT, "3", "5");
Costos = Cst.Lista;
}
public BA_PRODUKTE GetByCod(string CodigoAlfak)
{
BA_PRODUKTE Item;
Conn = new Coneccion();
string Select = "SELECT A.EXT_STAT AS 'STAT',A.EAN,A.BA_SN_MAKRO_NAME,A.BA_MASS_GEWICHT,A.BA_MASS_DICKE,ART.PRD_NR AS 'ARTPRDNR', GRP.PRDKTGRP_NR AS 'PRDKTGRPNR' , B.BA_MENGENEINH,B.BA_BEZ3, B.BA_BEZ1,C.BEZ AS 'FAMILIA',A.*,B.* " +
"FROM PHGLASS.SYSADM.BA_PRODUKTE A, PHGLASS.SYSADM.BA_PRODUKTE_BEZ B, SYSADM.KA_WGR C, SYSADM.KA_PRODUKTART ART, SYSADM.KA_PRODUKTGRP GRP " +
"WHERE A.BA_WGR = C.ID AND A.BA_PRODUKT = B.BA_PRODUKT and A.BA_PRODUKT=@CodAlfak AND A.BA_PRODUKTART = ART.BEZ AND ART.BEZ = GRP.PRDKTART_ID AND A.BA_PRODUKTGRP = GRP.PRDKTGRP_ID";
try
{
Conn.ConnAlfak.Open();
Conn.Cmd = new SqlCommand(Select, Conn.ConnAlfak);
Conn.Cmd.Parameters.AddWithValue("@CodAlfak", CodigoAlfak);
dr = Conn.Cmd.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
Validadores VAL = new Validadores();
Item = new BA_PRODUKTE {
Descripcion = dr["BA_BEZ1"].ToString(),
CodigoAlfak = dr["BA_PRODUKT"].ToString(),
Abreviacion = dr["BA_MCODE"].ToString(),
Id_familiaAlfak = dr["BA_WGR"].ToString(),
Familia_Alfak = dr["FAMILIA"].ToString(),
BA_BEZ3 = dr["BA_BEZ3"].ToString(),
BA_MENGENEINH = dr["BA_MENGENEINH"].ToString(),
ARTPRDNR = dr["ARTPRDNR"].ToString(),
PRDKTGRPNR = dr["PRDKTGRPNR"].ToString(),
BA_MASS_DICKE = VAL.ParseoDouble(dr["BA_MASS_DICKE"].ToString()),
BA_MASS_GEWICHT = VAL.ParseoDouble(dr["BA_MASS_GEWICHT"].ToString()),
BA_SN_MAKRO_NAME = dr["BA_SN_MAKRO_NAME"].ToString(),
EAN = dr["EAN"].ToString(),
EXT_STAT = dr["STAT"].ToString(),
};
}
else
{
Item = new BA_PRODUKTE {
};
}
dr.Close();
Conn.ConnAlfak.Close();
}
catch (Exception ex)
{
throw ex;
}
return(Item);
}
public ProductoAlfak(string CodFamilia, string Filtro)
{
string Filter = "%" + Filtro + "%";
Conn = new Coneccion();
string consulta = "SELECT b.BA_BEZ1,C.BEZ AS 'FAMILIA',a.*,b.* FROM PHGLASS.SYSADM.BA_PRODUKTE a,PHGLASS.SYSADM.BA_PRODUKTE_BEZ b ," +
" PHGLASS.SYSADM.KA_WGR C WHERE a.BA_WGR=C.ID and a.BA_PRODUKT=b.BA_PRODUKT and a.BA_WGR=@familia and (b.BA_BEZ1 LIKE @filter OR a.EAN LIKE @filter OR a.BA_PRODUKT LIKE @filter )";
Listaproductos = new List <BA_PRODUKTE>();
DataTable TablaDetalle = new DataTable();
using (Conn.ConnAlfak)
{
try
{
SqlDataAdapter adaptador = new SqlDataAdapter(consulta, Conn.ConnAlfak);
adaptador.SelectCommand.Parameters.AddWithValue("@familia", CodFamilia);
adaptador.SelectCommand.Parameters.AddWithValue("@filter", Filter);
adaptador.Fill(TablaDetalle);
}
catch (Exception ex)
{
throw ex;
}
}
if (TablaDetalle.Rows.Count > 0)
{
foreach (DataRow row in TablaDetalle.Rows)
{
BA_PRODUKTE ITEM = new BA_PRODUKTE
{
Descripcion = row["BA_BEZ1"].ToString(),
CodigoAlfak = row["BA_PRODUKT"].ToString(),
Abreviacion = row["BA_MCODE"].ToString(),
Id_familiaAlfak = row["BA_WGR"].ToString(),
Familia_Alfak = row["FAMILIA"].ToString(),
EAN = row["EAN"].ToString(),
};
Listaproductos.Add(ITEM);
}
}
}
