enjoy.
{
char cquoute = (char)31;
char cdelimite = (char)30;
String quote = cquoute.ToString();
String delimite = quote + cdelimite.ToString() + quote;
StringBuilder RawData = new StringBuilder();
RawData.Append(quote + (Row.customerAddressId. ToString()) + delimite);
RawData.Append((!Row. AddressName_IsNull ? Row.AddressName : "NULL") + delimite);
RawData.Append((!Row. CompanyName_IsNull ? Row.CompanyName : "NULL") + delimite);
RawData.Append((!Row.Address1_ IsNull ? Row.Address1 : "NULL") + delimite);
RawData.Append((!Row.Address2_ IsNull ? Row.Address2 : "NULL") + delimite);
RawData.Append((!Row.City_ IsNull ? Row.City : "NULL") + delimite);
RawData.Append((!Row. StateName_IsNull ? Row.StateName : "NULL") + delimite);
RawData.Append((!Row.Zip_ IsNull ? Row.Zip : "NULL") + delimite);
RawData.Append((!Row. CountryName_IsNull ? Row.CountryName : "NULL") + delimite);
RawData.Append((!Row. FirstName_IsNull ? Row.FirstName : "NULL") + delimite);
RawData.Append((!Row.LastName_ IsNull ? Row.LastName : "NULL") + delimite);
RawData.Append((!Row.Phone_ IsNull ? Row.Phone : "NULL") + delimite);
RawData.Append((!Row. IsDefaultBilling_IsNull ? Row.IsDefaultBilling.ToString( ) : "False") + delimite);
RawData.Append((!Row. IsDefaultShipping_IsNull ? Row.IsDefaultShipping. ToString() : "False") + delimite);
RawData.Append((!Row.IsAPO_ IsNull ? Row.IsAPO.ToString() : "False") + delimite);
RawData.Append((!Row. AddressUuid_IsNull ? Row.AddressUuid : "NULL") + delimite);
RawData.Append((!Row. ModifiedDate_IsNull ? Row.ModifiedDate.ToString() : "NULL") + quote);
Output0Buffer.AddRow();
Output0Buffer.customerid = (int) Row.CustomerId;
Output0Buffer.addressid = (int)Row.customerAddressId;
Output0Buffer.RawData. AddBlobData(Encoding.UTF8. GetBytes(RawData.ToString()));
No comments:
Post a Comment