/*para agregar direcciones que exista en el cliente*/
sqlconAddress.Open();
string sQueryAddress;
sQueryAddress = "SELECT [Address], [CardCode], [Street], [Block], [ZipCode], [City], [Country]," +
"[State],[LineNum],[TaxCode],[AdresType] FROM CRD1 WHERE CardCode='" + CardCode + "' ORDER BY LineNum";
SqlCommand cmdAddress;
SqlDataReader drAddress;
cmdAddress = new SqlCommand(sQueryAddress, sqlconAddress);
drAddress = cmdAddress.ExecuteReader();
if (drAddress.HasRows)
{
while (drAddress.Read())
{
MiSocio.Addresses.Add();
MiSocio.Addresses.SetCurrentLine(Convert.ToInt32(drAddress["LineNum"].ToString()));
MiSocio.Addresses.AddressName = drAddress["Address"].ToString();
MiSocio.Addresses.Street = drAddress["Street"] == null ? string.Empty : drAddress["Street"].ToString();
MiSocio.Addresses.Block = drAddress["Block"] == null ? string.Empty : drAddress["Block"].ToString();
MiSocio.Addresses.Country = drAddress["Country"].ToString();
MiSocio.Addresses.ZipCode = drAddress["ZipCode"] == null ? string.Empty : drAddress["ZipCode"].ToString();
MiSocio.Addresses.City = drAddress["City"].ToString();
MiSocio.Addresses.State = drAddress["State"] == null ? string.Empty : drAddress["State"].ToString();
MiSocio.Addresses.TaxCode = drAddress["TaxCode"] == null ? string.Empty : drAddress["TaxCode"].ToString();
switch (drAddress["AdresType"].ToString())
{
case "B":
MiSocio.Addresses.AddressType = BoAddressType.bo_BillTo;
break;
case "S":
MiSocio.Addresses.AddressType = BoAddressType.bo_ShipTo;
break;
}
}
}
drAddress.Close();
sqlconAddress.Close();
/*termina de agregar direcciones*/
/*para agregar Agentes que exista en el cliente*/
sqlconAddress.Open();
string sQueryAddress;
sQueryAddress = "SELECT [Address], [CardCode], [Street], [Block], [ZipCode], [City], [Country]," +
"[State],[LineNum],[TaxCode],[AdresType] FROM CRD1 WHERE CardCode='" + CardCode + "' ORDER BY LineNum";
SqlCommand cmdAddress;
SqlDataReader drAddress;
cmdAddress = new SqlCommand(sQueryAddress, sqlconAddress);
drAddress = cmdAddress.ExecuteReader();
if (drAddress.HasRows)
{
while (drAddress.Read())
{
MiSocio.Addresses.Add();
MiSocio.Addresses.SetCurrentLine(Convert.ToInt32(drAddress["LineNum"].ToString()));
MiSocio.Addresses.AddressName = drAddress["Address"].ToString();
MiSocio.Addresses.Street = drAddress["Street"] == null ? string.Empty : drAddress["Street"].ToString();
MiSocio.Addresses.Block = drAddress["Block"] == null ? string.Empty : drAddress["Block"].ToString();
MiSocio.Addresses.Country = drAddress["Country"].ToString();
MiSocio.Addresses.ZipCode = drAddress["ZipCode"] == null ? string.Empty : drAddress["ZipCode"].ToString();
MiSocio.Addresses.City = drAddress["City"].ToString();
MiSocio.Addresses.State = drAddress["State"] == null ? string.Empty : drAddress["State"].ToString();
MiSocio.Addresses.TaxCode = drAddress["TaxCode"] == null ? string.Empty : drAddress["TaxCode"].ToString();
switch (drAddress["AdresType"].ToString())
{
case "B":
MiSocio.Addresses.AddressType = BoAddressType.bo_BillTo;
break;
case "S":
MiSocio.Addresses.AddressType = BoAddressType.bo_ShipTo;
break;
}
}
}
drAddress.Close();
sqlconAddress.Close();
/*termina de agregar direcciones*/
/*para agregar Agentes que exista en el cliente*/
No hay comentarios:
Publicar un comentario