public long GuardarBultos(int nid_arrive, string nid_sku, int nid_sku_type, string clocation, int nid_sku_state, int nid_sku_level)
{
InsertSQL = "INSERT INTO sku_arrivals " +
"(nid_arrive, nid_sku, nid_sku_type, clocation, nid_sku_state, nid_sku_level, bloaded) " +
"VALUES (@nid_arrive,@nid_sku,@nid_sku_type,@clocation, @nid_sku_state,@nid_sku_level, 0)";
InsertParametros.Add("@nid_arrive", SqlDbType.VarChar, 100).Value = nid_arrive;
InsertParametros.Add("@nid_sku", SqlDbType.VarChar, 100).Value = nid_sku;
InsertParametros.Add("@nid_sku_type", SqlDbType.VarChar, 100).Value = nid_sku_type;
InsertParametros.Add("@clocation", SqlDbType.VarChar, 100).Value = clocation;
InsertParametros.Add("@nid_sku_state", SqlDbType.VarChar, 100).Value = nid_sku_state;
InsertParametros.Add("@nid_sku_level", SqlDbType.VarChar, 100).Value = nid_sku_level;
return(this.insert());
}
public void LogCambioDueno(string nid_skuLog, int nid_userLog, int idCteAnt, int idCteNvo)
{
//Guarda en el log el cliente que se elimino
InsertSQL = "INSERT INTO log_cambiodueno VALUES (@nid_sku, @movimiento, GETDATE(), @nid_user, @idCliente)";
InsertParametros.Add("@nid_sku", SqlDbType.VarChar, 100).Value = nid_skuLog;
InsertParametros.Add("@movimiento", SqlDbType.VarChar, 40).Value = "Desasignar Cliente";
InsertParametros.Add("@nid_user", SqlDbType.Int, 4).Value = nid_userLog;
InsertParametros.Add("@idCliente", SqlDbType.Int, 4).Value = idCteAnt;
insert();
InsertSQL = "INSERT INTO log_cambiodueno VALUES (@nid_sku, @movimiento, GETDATE(), @nid_user, @idCliente)";
InsertParametros.Add("@nid_sku", SqlDbType.VarChar, 100).Value = nid_skuLog;
InsertParametros.Add("@movimiento", SqlDbType.VarChar, 40).Value = "Asignar Cliente";
InsertParametros.Add("@nid_user", SqlDbType.Int, 4).Value = nid_userLog;
InsertParametros.Add("@idCliente", SqlDbType.Int, 4).Value = idCteNvo;
insert();
}