internal void InsertarDetail(string interfaceLinkId, string almacenScale, asn asn)
{
var id = string.Format("{0}{1}", DateTime.Now.ToString("yyyyMMddHHmmssfff"), asn.citas.Id);
var parameters = new List <SqlParameter>
{
new SqlParameter(
"@INTERFACE_RECORD_ID", id),
new SqlParameter("@Interface_link_id", interfaceLinkId),
new SqlParameter("@warehouse", almacenScale),
new SqlParameter("@INTERFACE_ACTION_CODE", "Save"),
new SqlParameter("@INTERFACE_CONDITION", "Ready"),
new SqlParameter("@ERP_ORDER_LINE_NUM", asn.NumeroPosicion),
new SqlParameter("@item", asn.NumeroMaterial),
//new SqlParameter("@ITEM_NET_PRICE",precio),
new SqlParameter("@user_def5", asn.citas.FechaCita.ToString("aaaaMMdd")),
//new SqlParameter("@TOTAL_QTY",cantidadSolicitada),
// new SqlParameter("@QUANTITY_UM",unidadMedida),
};
var sql = string.Format(@"
INSERT INTO DOWNLOAD_RECEIPT_DETAIL
(INTERFACE_RECORD_ID,
Interface_link_id,
warehouse,
INTERFACE_ACTION_CODE,
INTERFACE_CONDITION,
ERP_ORDER_LINE_NUM,
item,
--ITEM_NET_PRICE,
user_def5,
--TOTAL_QTY,
--QUANTITY_UM,
DATE_TIME_STAMP)
VALUES
(@INTERFACE_RECORD_ID,
@Interface_link_id,
@warehouse,
@INTERFACE_ACTION_CODE,
@INTERFACE_CONDITION,
@ERP_ORDER_LINE_NUM,
@item,
--@ITEM_NET_PRICE,
@user_def5,
--@TOTAL_QTY,
--@QUANTITY_UM,
GETDATE());");
DbScale.Insert(sql, parameters);
}
internal string InsertarHeader(citas cita, string almacenScale, string numeroOrden)
{
var proveedor = cita.proveedores;
var id = string.Format("{0}{1}", DateTime.Now.ToString("yyyyMMddHHmmss"), cita.Id);
var parameters = new List <SqlParameter>
{
new SqlParameter(
"@INTERFACE_RECORD_ID", id),
new SqlParameter("@INTERFACE_ACTION_CODE", "Save"),
new SqlParameter("@INTERFACE_CONDITION", "Ready"),
new SqlParameter("@warehouse", almacenScale),
new SqlParameter("@ERP_ORDER_NUM", numeroOrden),
new SqlParameter("@RECEIPT_ID", string.Format("{0}{1}", numeroOrden, cita.Id)),
new SqlParameter("@RECEIPT_ID_TYPE", "foo"),
new SqlParameter("@RECEIPT_TYPE", "foo"),
new SqlParameter("@RECEIPT_DATE", cita.FechaCita),
new SqlParameter("@Ship_From", proveedor.NumeroProveedor),
new SqlParameter("@SHIP_FROM_ADDRESS1", proveedor.Calle),
new SqlParameter("@SHIP_FROM_ADDRESS2", proveedor.Direccion),
new SqlParameter("@Ship_From_city", proveedor.Poblacion),
new SqlParameter("@SHIP_FROM_STATE", "foo"),
new SqlParameter("@SHIP_FROM_COUNTRY", "MEXICO"),
new SqlParameter("@SHIP_FROM_POSTAL_CODE", proveedor.CodigoPostal),
new SqlParameter("@SHIP_FROM_NAME",
string.Format(
"{0} {1} {2} {3}",
proveedor.Nombre1,
proveedor.Nombre2,
proveedor.Nombre3,
proveedor.Nombre4)),
new SqlParameter("@SHIP_FROM_EMAIL_ADDRESS", proveedor.Correo),
new SqlParameter("@SHIP_FROM_PHONE_NUM", proveedor.NumeroTelefono),
new SqlParameter("@SHIP_FROM_FAX_NUM", "foo"),
new SqlParameter("@Source_id", proveedor.NumeroProveedor),
new SqlParameter("@Source_name",
string.Format(
"{0} {1} {2} {3}",
proveedor.Nombre1,
proveedor.Nombre2,
proveedor.Nombre3,
proveedor.Nombre4)),
new SqlParameter("@SOURCE_ADDRESS1", proveedor.Calle),
new SqlParameter("@SOURCE_ADDRESS2", proveedor.Direccion),
new SqlParameter("@Source_City", proveedor.Poblacion),
new SqlParameter("@Source_State", "foo"),
new SqlParameter("@SOURCE_POSTAL_CODE", proveedor.CodigoPostal),
new SqlParameter("@SOURCE_COUNTRY", "MEXICO"),
new SqlParameter("@SOURCE_PHONE_NUM", proveedor.NumeroTelefono),
new SqlParameter("@SOURCE_FAX_NUM", "foo"),
new SqlParameter("@SOURCE_EMAIL_ADDRESS", proveedor.Correo),
new SqlParameter("@user_def1", cita.FechaCita),
new SqlParameter("@user_def2", proveedor.OrganizacionCompra),
new SqlParameter("@user_def3", "foo"),
new SqlParameter("@user_def4", "foo"),
new SqlParameter("@user_def5", "foo"),
new SqlParameter("@user_def6", "foo"),
//new SqlParameter("@user_def7",0),
//new SqlParameter("@user_def8",0),
//new SqlParameter("@DATE_TIME_STAMP","GETDATE()"),
new SqlParameter("@ARRIVED_DATE_TIME", cita.FechaCita),
};
var sql = string.Format(@"
INSERT INTO download_receipt_header
(interface_record_id,
interface_action_code,
interface_condition,
warehouse,
erp_order_num,
receipt_id,
receipt_id_type,
receipt_type,
receipt_date,
ship_from,
ship_from_address1,
ship_from_address2,
ship_from_city,
ship_from_state,
ship_from_country,
ship_from_postal_code,
ship_from_name,
ship_from_email_address,
ship_from_phone_num,
ship_from_fax_num,
source_id,
source_name,
source_address1,
source_address2,
source_city,
source_state,
source_postal_code,
source_country,
source_phone_num,
source_fax_num,
source_email_address,
user_def1,
user_def2,
user_def3,
user_def4,
user_def5,
user_def6,
--user_def7,
--user_def8,
date_time_stamp,
arrived_date_time)
VALUES (@INTERFACE_RECORD_ID,
@INTERFACE_ACTION_CODE,
@INTERFACE_CONDITION,
@warehouse,
@ERP_ORDER_NUM,
@RECEIPT_ID,
@RECEIPT_ID_TYPE,
@RECEIPT_TYPE,
@RECEIPT_DATE,
@Ship_From,
@SHIP_FROM_ADDRESS1,
@SHIP_FROM_ADDRESS2,
@Ship_From_city,
@SHIP_FROM_STATE,
@SHIP_FROM_COUNTRY,
@SHIP_FROM_POSTAL_CODE,
@SHIP_FROM_NAME,
@SHIP_FROM_EMAIL_ADDRESS,
@SHIP_FROM_PHONE_NUM,
@SHIP_FROM_FAX_NUM,
@Source_id,
@Source_name,
@SOURCE_ADDRESS1,
@SOURCE_ADDRESS2,
@Source_City,
@Source_State,
@SOURCE_POSTAL_CODE,
@SOURCE_COUNTRY,
@SOURCE_PHONE_NUM,
@SOURCE_FAX_NUM,
@SOURCE_EMAIL_ADDRESS,
@user_def1,
@user_def2,
@user_def3,
@user_def4,
@user_def5,
@user_def6,
--@user_def7,
--@user_def8,
GETDATE(),
@ARRIVED_DATE_TIME);
");
DbScale.Insert(sql, parameters);
return(id);
}
